WebAPI/Controllers/基础资料/基础资料/Gy_DutyBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/基础资料/基础资料/Xt_CheckFlowBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/基础资料/基础资料/Xt_CheckItemBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/ListModels.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Models/Xt_CheckFlowMain.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Models/Xt_CheckFlowSub.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Models/Xt_CheckItem.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Models/基础资料/Gy_Duty.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/WebAPI.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Gy_DutyBillController.cs
New file @@ -0,0 +1,375 @@ using Newtonsoft.Json; using Newtonsoft.Json.Linq; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Net; using System.Net.Http; using System.Web.Http; using WebAPI.Models.åºç¡èµæ; using WebAPI.Models; namespace WebAPI.Controllers.åºç¡èµæ.åºç¡èµæ { public class Gy_DutyBillController : ApiController { private json objJsonResult = new json(); public DataSet ds = new DataSet(); public SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); #region ç»ç»æ¶æè®¾ç½® æ å½¢å¾ public class TreeModel { public string id { get; set; } public string title { get; set; } public List<TreeModel> children = new List<TreeModel>(); } [Route("Gy_DutyBill/Gy_DutyBillTreeList")] [HttpGet] public object Gy_DutyBillTreeList() { try { string sql1 = string.Format("select hitemid,hnumber,hname from Gy_Duty order by hnumber"); ds = oCN.RunProcReturn(sql1, "Gy_Duty"); List<TreeModel> treeModels = new List<TreeModel>(); TreeModel first = new TreeModel(); first.id = "0"; first.title = "ç»ç»æ¶æè®¾ç½®"; treeModels.Add(first); foreach (DataRow row in ds.Tables[0].Rows) { var strLen = row["hnumber"].ToString().Split('.'); if (strLen.Length == 1) { TreeModel tree = new TreeModel(); tree.id = row["hnumber"].ToString(); tree.title = row["hname"].ToString(); treeModels[0].children.Add(tree); } } digui(ds.Tables[0], treeModels[0].children, 2); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = Newtonsoft.Json.JsonConvert.SerializeObject(treeModels); return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } /// <summary> /// éå½å½æ° /// </summary> public void digui(DataTable dt, List<TreeModel> tree,int num) { for (int m = 0; m < tree.Count; m++) { tree[m].children = new List<TreeModel>(); for (int i = 0; i < dt.Rows.Count; i++)//ç¬¬ä¸æ¬¡å¾ªç¯ï¼å¾å°æææ ¹èç¹çåé { var strLen = dt.Rows[i]["hnumber"].ToString().Split('.'); if (strLen.Length == num && dt.Rows[i]["hnumber"].ToString().Contains(tree[m].id + ".")) { TreeModel tbjson = new TreeModel(); tbjson.id = dt.Rows[i]["hnumber"].ToString(); tbjson.title = dt.Rows[i]["hname"].ToString(); tree[m].children.Add(tbjson); } } var strLens = tree[m].id.Split('.'); for (int i = 0; i < tree[m].children.Count; i++) { digui(dt, tree[m].children, strLens.Length + 2);//忬¡ç¨åéå»å¾ªç¯ï¼æ¿åºåéçåé } } } #endregion #region ç»ç»æ¶æè®¾ç½® å表 [Route("Gy_DutyBill/Gy_DutyBillList")] [HttpGet] public object Gy_DutyBillList(string sWhere) { try { string sql1 = string.Format(@"select * from h_v_Gy_DutyList where 1=1 "); ds = oCN.RunProcReturn(sql1+ sWhere+ " order by ç»ç»æ¶æä»£ç ", "h_v_Gy_DutyList"); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region ç»ç»æ¶æè®¾ç½® ä¿å [Route("Gy_DutyBill/Gy_DutyBillEdit")] [HttpPost] public object Xt_CheckFlowBillEdit([FromBody] JObject msg) { var _value = msg["msg"].ToString(); string msg3 = _value.ToString(); string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg1 = sArray[0].ToString(); string msg2 = sArray[1].ToString(); string msg4 = sArray[2].ToString(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); try { Gy_Duty Duty = JsonConvert.DeserializeObject<Gy_Duty>(msg1); //è·åä¸çº§ç代ç var topHNum = DBUtility.ClsPub.GetParentCode(Duty.HNumber); if (topHNum == "") { Duty.HParentID = 0; } else { ds = oCN.RunProcReturn("select * from Gy_Duty where HStopflag=0 and HNumber='" + topHNum + "' or HNumber='" + Duty.HNumber + "' ", "Gy_Duty"); if (ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¸çº§ä»£ç ä¸åå¨æè¢«ç¦ç¨ï¼"; objJsonResult.data = null; return objJsonResult; } if (msg4 == "1") { if (ds.Tables[0].Rows.Count == 2) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "代ç éå¤ï¼"; objJsonResult.data = null; return objJsonResult; } } Duty.HParentID = int.Parse(ds.Tables[0].Rows[0]["HItemID"].ToString()); } if (Duty.HItemID != 0) { ds = oCN.RunProcReturn("select * from Gy_Duty where HItemID='" + Duty.HItemID + "' ", "Gy_Duty"); var newHNum = Duty.HNumber.Split('.'); var oldHNum = ds.Tables[0].Rows[0]["HNumber"].ToString().Split('.'); if (newHNum.Length > oldHNum.Length && Duty.HItemID == Duty.HParentID) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ°ä»£ç ä¸è½æ¯èªå·±çä¸çº§çå项ç®ï¼"; objJsonResult.data = null; return objJsonResult; } ds = oCN.RunProcReturn("select * from Gy_Duty where HParentID='" + Duty.HItemID + "' ", "Gy_Duty"); if (ds.Tables[0].Rows.Count>0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "该项ç®ä¸é¢æå项ç®,ä¸è½ä¿®æ¹ï¼"; objJsonResult.data = null; return objJsonResult; } } Duty.HEndFlag = 1; Duty.HShortNumber = DBUtility.ClsPub.GetShortNumber(Duty.HNumber); Duty.HLevel = DBUtility.ClsPub.GetLevel(Duty.HNumber); if (Duty.HShortNumber == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ç代ç 为空ï¼"; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran(); if (msg4 == "1") { //ä¿å //ä¿å宿¯åå¤ç oCN.RunProc("Insert into Gy_Duty " + " (HNumber,HName,HHelpCode,HShortNumber,HParentID,HUserGroupID" + ",HLevel,HEndFlag,HStopflag,HRemark) " + " Values('" + Duty.HNumber + "','" + Duty.HName + "','" + Duty.HHelpCode + "','" + Duty.HShortNumber + "'," + Duty.HParentID.ToString() + "," + Duty.HUserGroupID.ToString() + "," + Duty.HLevel.ToString() + "," + Duty.HEndFlag + "," + Convert.ToString(Duty.HStopflag ? 1 : 0) + ",'" + Duty.HRemark + "')", ref DBUtility.ClsPub.sExeReturnInfo); } else { oCN.RunProc("Update Gy_Duty set " + " HNumber='" + Duty.HNumber + "'" + ",HName='" + Duty.HName + "'" + ",HShortNumber='" + Duty.HShortNumber + "'" + ",HHelpCode='" + Duty.HHelpCode + "'" + ",HLevel=" + Duty.HLevel.ToString() + ",HParentID=" + Duty.HParentID.ToString() + ",HUserGroupID=" + Duty.HUserGroupID.ToString() + ",HEndflag=" + Duty.HEndFlag + ",HStopflag=" + Convert.ToString(Duty.HStopflag ? 1 : 0) + ",HRemark= '" + Duty.HRemark + "' Where HItemID=" + Duty.HItemID, ref DBUtility.ClsPub.sExeReturnInfo); } //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç oCN.RunProc("Update Gy_Duty set HEndflag=0 where HItemID=" + Duty.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "ä¿åæåï¼"; objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败ï¼" + e.ToString(); objJsonResult.data = 1; return objJsonResult; } } #endregion #region ç»ç»æ¶æè®¾ç½® å é¤ [Route("Gy_DutyBill/Gy_DutyBillDel")] [HttpGet] public object Gy_DutyBillDel(string HItemID, string user) { try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HItemID为空ï¼"; objJsonResult.data = null; return objJsonResult; } ds = oCN.RunProcReturn("select * from Gy_Duty where HParentID='" + HItemID + "' ", "Gy_Duty"); if (ds.Tables[0].Rows.Count > 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "该项ç®ä¸é¢æå项ç®,ä¸è½å é¤ï¼,请å å é¤å项ç®!"; objJsonResult.data = null; return objJsonResult; } ds = oCN.RunProcReturn("select * from Gy_Duty where HItemID='" + HItemID + "' ", "Gy_Duty"); oCN.BeginTran();//å¼å§äºå¡ //å 餿°æ® oCN.RunProc("Delete from Gy_Duty where HItemID='" + HItemID + "'"); //ä¿®æ¹ä¸çº§ä¸ºæ«çº§ oCN.RunProc("Update Gy_Duty set HEndflag=1 where HItemID=" + ds.Tables[0].Rows[0]["HParentID"].ToString()); oCN.Commit();//æäº¤äºå¡ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "* æ°æ®å 餿åï¼"; objJsonResult.data = null; return objJsonResult; ; } catch (Exception e) { //åæ» oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å é¤å¤±è´¥ï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region ç»ç»æ¶æè®¾ç½® æ£æµ [Route("Gy_DutyBill/Gy_DutyBillTest")] [HttpGet] public object Gy_DutyBillTest(string HItemID, string user) { try { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HItemID为空ï¼"; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran();//å¼å§äºå¡ //æ£æµæ°æ® oCN.RunProc("exec h_p_Gy_Duty " + HItemID ); oCN.Commit();//æäº¤äºå¡ objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "æåï¼"; objJsonResult.data = null; return objJsonResult; ; } catch (Exception e) { //åæ» oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "失败ï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion } } WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Xt_CheckFlowBillController.cs
New file @@ -0,0 +1,399 @@ using Newtonsoft.Json; using Newtonsoft.Json.Linq; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Net; using System.Net.Http; using System.Web.Http; using WebAPI.Models; namespace WebAPI.Controllers.åºç¡èµæ.åºç¡èµæ { public class Xt_CheckFlowBillController : ApiController { private json objJsonResult = new json(); public DataSet ds = new DataSet(); public SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); #region å®¡æ ¸æµç¨åå表 [Route("Xt_CheckFlowBill/Xt_CheckFlowBillList")] [HttpGet] public object Xt_CheckFlowBillList(string sWhere, string user) { try { List<object> columnNameList = new List<object>(); //æ¥è¯¢æé if (!DBUtility.ClsPub.Security_Log_second("Xt_CheckFlow_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ æ¥çæéï¼"; objJsonResult.data = null; return objJsonResult; } string sql1 = string.Format(@"select * from h_v_Xt_CheckFlowList where 1=1 "); ds = oCN.RunProcReturn(sql1 + sWhere+ " order by æµç¨åç§°", "h_v_Xt_CheckFlowList"); //æ·»å åå foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion # region å®¡æ ¸æµç¨å ä¿å [Route("Xt_CheckFlowBill/Xt_CheckFlowBillEdit")] [HttpPost] public object Xt_CheckFlowBillEdit([FromBody] JObject msg) { var _value = msg["msg"].ToString(); string msg3 = _value.ToString(); string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg1 = sArray[0].ToString(); string msg2 = sArray[1].ToString(); msg3 = sArray[2].ToString(); string msg4 = sArray[3].ToString(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); //ç¼è¾æé if (!DBUtility.ClsPub.Security_Log_second("Xt_CheckFlow_Edit", 1, false, msg4)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ ä¿åæéï¼"; objJsonResult.data = null; return objJsonResult; } try { Models.Xt_CheckFlowMain main = JsonConvert.DeserializeObject<Xt_CheckFlowMain>(msg1); List<Models.Xt_CheckFlowSub> lsmain = new List<Models.Xt_CheckFlowSub>(); msg2 = msg2.Replace("\\", ""); msg2 = msg2.Replace("\n", ""); //\n lsmain =JsonConvert.DeserializeObject<List<Xt_CheckFlowSub>>(msg2); foreach (Xt_CheckFlowSub oItem in lsmain) { if (oItem.HCheckItemID == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败ï¼å®¡æ¹é¡¹ç®ä»£ç ä¸è½ä¸ºç©ºï¼"; objJsonResult.data = 1; return objJsonResult; } if (oItem.HFlowNo == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿åå¤±è´¥ï¼æµç¨å·ä¸è½ä¸ºç©ºï¼"; objJsonResult.data = 1; return objJsonResult; } } ds = oCN.RunProcReturn("select * from h_v_Xt_CheckFlowList where Hmainid= " + main.HInterID, "h_v_Xt_CheckFlowList"); //ä¿å //ä¿å宿¯åå¤ç oCN.BeginTran(); if (msg3 == "1" && ds.Tables[0].Rows.Count == 0) { oCN.RunProc("Insert Into Xt_CheckFlowMain " + "(HBillTypeID,HInterID,HDeptID" + ",HRemark,HStandard,HName" + ") " + " values('" + main.HBillTypeID.ToString() + "'," + main.HInterID.ToString() + "," + main.HDeptID.ToString() + ",'" + main.HRemark + "'," + Convert.ToString(main.HStandard ? 1 : 0) + ",'" + main.HName.ToString() + "') "); int i = 0; foreach (Xt_CheckFlowSub oSub in lsmain) { i++; bool bResult = false; oCN.RunProc("Insert into Xt_CheckFlowSub " + " (HInterID,HEntryID,HCheckMan" + ",HFlowNo,HJumpFlag,HMakerSelf,HCheckItemID" + " )values(" + main.HInterID.ToString() + "," + i + ",'" + oSub.HCheckMan + "'" + "," + oSub.HFlowNo + "," + Convert.ToString(oSub.HJumpFlag ? 1 : 0) + "," + Convert.ToString(oSub.HMakerSelf ? 1 : 0) + "," + oSub.HCheckItemID + ") "); bResult = true; if (!bResult) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败ï¼" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = 1; return objJsonResult; } } } oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "ä¿åæåï¼"; objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败ï¼" + e.ToString(); objJsonResult.data = 1; return objJsonResult; } } #endregion #region å®¡æ ¸æµç¨å å é¤ [Route("Xt_CheckFlowBill/Xt_CheckFlowBillDelete")] [HttpGet] public object Xt_CheckFlowBillDelete(string HItemID, string user) { try { //å 餿é if (!DBUtility.ClsPub.Security_Log("Xt_CheckFlow_Drop", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ å 餿é"; objJsonResult.data = null; return objJsonResult; } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HItemID为空ï¼"; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran();//å¼å§äºå¡ //å é¤å表 oCN.RunProc("Delete From Xt_CheckFlowSub where HInterID=" + HItemID); //å é¤ä¸»è¡¨ oCN.RunProc("Delete From Xt_CheckFlowMain where HInterID=" + HItemID); oCN.Commit();//æäº¤äºå¡ objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "* æ°æ®å 餿åï¼"; objJsonResult.data = null; return objJsonResult; ; } catch (Exception e) { //åæ» oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å é¤å¤±è´¥ï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 审æ¹ç¨æ·æé设置 [Route("Xt_CheckFlowBill/Xt_CheckUserRight")] [HttpGet] public object Xt_CheckUserRight() { try { string sql1 = string.Format(@"select * from Gy_Czygl "); ds = oCN.RunProcReturn(sql1, "Gy_Czygl"); string TreeStr = "[{\"title\": \"审æ¹ç¨æ·æé设置\", \"id\": \"1\" ,\"spread\": \"true\",\"children\":["; foreach (DataRow item in ds.Tables[0].Rows) { TreeStr+= "{ \"title\": \"" + item["Czymc"].ToString() + "\",\"id\": \"" + item["Czybm"].ToString() + "\"},"; } TreeStr = TreeStr.Substring(0, TreeStr.Length - 1); TreeStr += "]}]"; objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = JsonConvert.DeserializeObject(TreeStr); return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 审æ¹ç¨æ·æé设置 å³ [Route("Xt_CheckFlowBill/Xt_CheckUserRightListMain")] [HttpGet] public object Xt_CheckUserRightListMain(string sWhere) { try { string sql1 = string.Format(@"select *,row_number()over(ORDER BY HInterID ) num from h_v_Xt_CheckUserRightMain where 1=1 "); ds = oCN.RunProcReturn(sql1+sWhere, "h_v_Xt_CheckUserRightMain"); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 审æ¹ç¨æ·æé设置 å·¦ [Route("Xt_CheckFlowBill/Xt_CheckUserRightListMainSource")] [HttpGet] public object Xt_CheckUserRightListMainSource(string sWhere) { try { string sql1 = string.Format(@"select *,row_number()over(ORDER BY HInterID ) num from h_v_Xt_CheckUserRightSource where 1=1 "); ds = oCN.RunProcReturn(sql1 + sWhere, "h_v_Xt_CheckUserRightSource"); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region 审æ¹ç¨æ·æé设置 ä¿å //åæ®µ public class Xt_CheckUserRightsub { public int hcheckitemid; } [Route("Xt_CheckFlowBill/Xt_CheckUserRightEdit")] [HttpPost] public object Xt_CheckUserRightEdit([FromBody] JObject msg) { var _value = msg["msg"].ToString(); string msg3 = _value.ToString(); string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg1 = sArray[0].ToString(); string msg2 = sArray[1].ToString(); msg3 = sArray[2].ToString(); string msg4 = sArray[3].ToString(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); //ç¼è¾æé if (!DBUtility.ClsPub.Security_Log_second("Xt_CheckFlow_Edit", 1, false, msg4)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ ä¿åæéï¼"; objJsonResult.data = null; return objJsonResult; } try { List<Xt_CheckUserRightsub> lsmain = new List<Xt_CheckUserRightsub>(); msg1 = msg1.Replace("\\", ""); msg1 = msg1.Replace("\n", ""); //\n lsmain = JsonConvert.DeserializeObject<List<Xt_CheckUserRightsub>>(msg1); oCN.BeginTran(); //å é¤åè®°å½ oCN.RunProc("Delete From Xt_CheckUserRight where HUserID='" + msg2 + "'and HCheckFlowInterID=" + msg3 + ""); var HCheckItemID=0; //æ°å¢è®°å½ for (int i = 0; i <= lsmain.Count - 1; i++) { if (HCheckItemID != lsmain[i].hcheckitemid) { oCN.RunProc("insert into Xt_CheckUserRight(HUserID,HCheckFlowInterID,HCheckItemID) values('" + msg2 + "'," + msg3 + "," + lsmain[i].hcheckitemid + ") "); HCheckItemID = lsmain[i].hcheckitemid; } } oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "ä¿åæåï¼"; objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败ï¼" + e.ToString(); objJsonResult.data = 1; return objJsonResult; } } #endregion } } WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Xt_CheckItemBillController.cs
New file @@ -0,0 +1,262 @@ using Newtonsoft.Json; using Newtonsoft.Json.Linq; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Net; using System.Net.Http; using System.Web.Http; using WebAPI.Models; namespace WebAPI.Controllers.åºç¡èµæ.åºç¡èµæ { public class Xt_CheckItemBillController : ApiController { private json objJsonResult = new json(); public DataSet ds = new DataSet(); public SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); #region å®¡æ ¸é¡¹ç®å表 [Route("Xt_CheckItemBill/Xt_CheckItemList")] [HttpGet] public object Xt_CheckItemList(string sWhere, string user) { try { List<object> columnNameList = new List<object>(); //æ¥è¯¢æé if (!DBUtility.ClsPub.Security_Log_second("Xt_CheckItem_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ æ¥çæéï¼"; objJsonResult.data = null; return objJsonResult; } string sql1 = string.Format(@"select * from h_v_Xt_CheckItemList where 1=1 "); ds = oCN.RunProcReturn(sql1 + sWhere + " order by 审æ¹é¡¹ç®ä»£ç ", "h_v_Xt_CheckItemList"); //æ·»å åå foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region å®¡æ ¸é¡¹ç®ä¿å [Route("Xt_CheckItemBill/Xt_CheckItemEdit")] [HttpPost] public object Xt_CheckItemEdit([FromBody] JObject msg) { DataSet ds; var _value = msg["msg"].ToString(); string msg3 = _value.ToString(); string[] sArray = msg3.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg1 = sArray[0].ToString(); string msg2 = sArray[1].ToString(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); //ç¼è¾æé if (!DBUtility.ClsPub.Security_Log_second("Xt_CheckItem_Edit", 1, false, msg2)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ ä¿åæéï¼"; objJsonResult.data = null; return objJsonResult; } ListModels oListModels = new ListModels(); try { List<Models.Xt_CheckItem> lsmain = new List<Models.Xt_CheckItem>(); msg1 = msg1.Replace("\\", ""); msg1 = msg1.Replace("\n", ""); //\n lsmain = oListModels.getObjectByJson_Xt_CheckItem(msg1); foreach (Xt_CheckItem oItem in lsmain) { if (oItem.HNumber.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败ï¼ä»£ç ä¸è½ä¸ºç©ºï¼"; objJsonResult.data = 1; return objJsonResult; } if (oItem.HName.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败ï¼åç§°ä¸è½ä¸ºç©ºï¼"; objJsonResult.data = 1; return objJsonResult; } //æ¥è¯¢æ°æ®ä¸æ¯å¦åå¨éå¤ä»£ç ds = oCN.RunProcReturn("select * from Xt_CheckItem where HStopflag=0 and HNumber='" + oItem.HNumber.Trim() + "'", "Xt_CheckItem"); //æ°å¢æ¶å¤æ if (oItem.HItemID == 0) { if (ds == null || ds.Tables[0].Rows.Count == 0) { } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败ï¼ä»£ç éå¤ï¼"; objJsonResult.data = 1; return objJsonResult; } } } //ä¿å //ä¿å宿¯åå¤ç oCN.BeginTran(); foreach (Xt_CheckItem oItem in lsmain) { bool bResult = false; if (oItem.HItemID == 0) { oCN.RunProc("Insert into Xt_CheckItem " + " (HNumber,HName" + ",HStopflag,HRemark) " + " Values('" + oItem.HNumber + "','" + oItem.HName + "'," + Convert.ToString(oItem.HStopFlag ? 1 : 0) + ",'" + oItem.HRemark + "')"); bResult = true; } else { oCN.RunProc("Update Xt_CheckItem set " + " HNumber='" + oItem.HNumber + "'" + ",HName='" + oItem.HName + "'" + ",HStopflag=" + Convert.ToString(oItem.HStopFlag ? 1 : 0) + ",HRemark= '" + oItem.HRemark + "' Where HItemID=" + oItem.HItemID); bResult = true; } if (!bResult) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败ï¼" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = 1; return objJsonResult; } } oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "ä¿åæåï¼"; objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败ï¼" + e.ToString(); objJsonResult.data = 1; return objJsonResult; } } #endregion #region å®¡æ ¸é¡¹ç®å é¤ [Route("Xt_CheckItemBill/Xt_CheckItemBillDelete")] [HttpGet] public object Xt_CheckItemBillDelete(string HItemID, string user) { try { //å 餿é if (!DBUtility.ClsPub.Security_Log("Xt_CheckItem_Drop", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ å 餿é"; objJsonResult.data = null; return objJsonResult; } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HItemID为空ï¼"; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran();//å¼å§äºå¡ ds = oCN.RunProcReturn("select * from Xt_CheckItem where HItemID=" + HItemID, "Xt_CheckItem"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ²¡ææ°æ®ï¼æ æ³å é¤ï¼"; objJsonResult.data = null; return objJsonResult; ; } var HStopflag = Convert.ToBoolean(ds.Tables[0].Rows[0]["HStopflag"]); if (HStopflag) { oCN.RollBack();//åæ»äºå¡ objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ°æ®å·²å 餿 æ³å次å é¤ï¼"; objJsonResult.data = null; return objJsonResult; } oCN.RunProc("update Xt_CheckItem set HStopflag=1 where HItemID=" + HItemID); oCN.Commit();//æäº¤äºå¡ objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "* æ°æ®å 餿åï¼"; objJsonResult.data = null; return objJsonResult; ; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å é¤å¤±è´¥ï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion } } WebAPI/ListModels.cs
@@ -838,6 +838,18 @@ } /// <summary> /// å¤çæ°å¢å®¡æ ¸é¡¹ç®çjson /// </summary> /// <param name="jsonString"></param> /// <returns></returns> public List<Models.Xt_CheckItem> getObjectByJson_Xt_CheckItem(string jsonString) { jsonString = "[" + jsonString.ToString() + "]"; List<Models.Xt_CheckItem> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.Xt_CheckItem>>(jsonString); return list; } /// <summary> /// å¤çæ°å¢è®¾å¤ç»´ä¿®ä¸»è¡¨çjson /// </summary> /// <param name="jsonString"></param> WebAPI/Models/Xt_CheckFlowMain.cs
New file @@ -0,0 +1,17 @@ using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace WebAPI.Models { public class Xt_CheckFlowMain { public Int64 HInterID; public string HName; public string HBillTypeID; public Int64 HDeptID; public bool HStandard; public string HRemark; } } WebAPI/Models/Xt_CheckFlowSub.cs
New file @@ -0,0 +1,19 @@ using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace WebAPI.Models { public class Xt_CheckFlowSub { public Int64 HInterID; public Int64 HEntryID; public int HSno; public string HFlowNo; public long HCheckItemID; public bool HJumpFlag; public bool HMakerSelf; public string HCheckMan; } } WebAPI/Models/Xt_CheckItem.cs
New file @@ -0,0 +1,16 @@ using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace WebAPI.Models { public class Xt_CheckItem { public int HItemID; public string HNumber; public string HName; public string HRemark; public bool HStopFlag; } } WebAPI/Models/»ù´¡×ÊÁÏ/Gy_Duty.cs
New file @@ -0,0 +1,22 @@ using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace WebAPI.Models.åºç¡èµæ { public class Gy_Duty { public int HItemID; public int HParentID; public int HLevel; public string HNumber { get; set; } public string HName { get; set; } public string HUserGroupID { get; set; } public string HRemark { get; set; } public string HShortNumber { get; set; } public string HHelpCode { get; set; } public bool HStopflag; public int HEndFlag; } } WebAPI/WebAPI.csproj
@@ -439,10 +439,13 @@ <Compile Include="Controllers\ä»å管ç\颿åè´§\Kf_StepFoldOutBillController.cs" /> <Compile Include="Controllers\ä»å管ç\éªæ¶å ¥åº\Kf_StepFoldinBillController.cs" /> <Compile Include="Controllers\忥èªå¨æ«ç 线\ScanlineAPIController.cs" /> <Compile Include="Controllers\åºç¡èµæ\åºç¡èµæ\Gy_DutyBillController.cs" /> <Compile Include="Controllers\åºç¡èµæ\åºç¡èµæ\Gy_SOPBillController.cs" /> <Compile Include="Controllers\åºç¡èµæ\åºç¡èµæ\Gy_SOPBillListController.cs" /> <Compile Include="Controllers\åºç¡èµæ\åºç¡èµæ\Gy_StockCheckItemBillController.cs" /> <Compile Include="Controllers\åºç¡èµæ\åºç¡èµæ\Gy_WorkStationBillController.cs" /> <Compile Include="Controllers\åºç¡èµæ\åºç¡èµæ\Xt_CheckFlowBillController.cs" /> <Compile Include="Controllers\åºç¡èµæ\åºç¡èµæ\Xt_CheckItemBillController.cs" /> <Compile Include="Controllers\å·¥èµç®¡ç\Pay_MonthlySalaryReportController.cs" /> <Compile Include="Controllers\å·¥èµç®¡ç\Pay_PieceRateWageReportController.cs" /> <Compile Include="Controllers\å·¥èµç®¡ç\Gy_ClassTimePrjBillController.cs" /> @@ -602,10 +605,14 @@ <Compile Include="Models\TechnologyParameter.cs" /> <Compile Include="Models\TechnologyParameterUnit.cs" /> <Compile Include="Models\TechParamByProc.cs" /> <Compile Include="Models\Xt_CheckFlowMain.cs" /> <Compile Include="Models\Xt_CheckFlowSub.cs" /> <Compile Include="Models\Xt_CheckItem.cs" /> <Compile Include="Models\å ¶å®\ReciveBill_FastModel.cs" /> <Compile Include="Models\卿å\OptionListModel.cs" /> <Compile Include="Models\åºç¡èµæ\ConkType.cs" /> <Compile Include="Models\åºç¡èµæ\Gy_ClassTimePrj.cs" /> <Compile Include="Models\åºç¡èµæ\Gy_Duty.cs" /> <Compile Include="Models\åºç¡èµæ\PackType.cs" /> <Compile Include="Models\åºç¡èµæ\WorkStation.cs" /> <Compile Include="Models\å·¥èµç®¡ç\ClsGy_ClassTimePrj_Model.cs" /> @@ -862,6 +869,7 @@ <Folder Include="Views\Cj_ComplementGoodsBill\" /> <Folder Include="Views\Cj_SendGoodsBill\" /> <Folder Include="Views\Gy_ConkType\" /> <Folder Include="Views\Gy_DutyBill\" /> <Folder Include="Views\Gy_EquipType\" /> <Folder Include="Views\Gy_ICBomBill\" /> <Folder Include="Views\Gy_MateMould\" /> @@ -896,6 +904,8 @@ <Folder Include="Views\Sc_WorkBillAutoSortBillMain\" /> <Folder Include="Views\Sc_WorkBillSortBill\" /> <Folder Include="Views\Sc_WorkDemandPlanBill\" /> <Folder Include="Views\Xt_CheckFlowBill\" /> <Folder Include="Views\Xt_CheckItem\" /> <Folder Include="Views\Xt_grdAlignment_WMES\" /> </ItemGroup> <ItemGroup>