WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/SBGL/Sb_EquipMaintainRuleBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/基础资料/基础资料/Gy_StockCheckItemBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/DLL/ClsSb_EquipDotCheckRuleBill.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/DLL/ClsSb_EquipMaintainRuleBill.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/ListModels.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Models/ClsGy_StockCheckItemBill.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/WebAPI.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebAPI/Controllers/SBGL/Sb_EquipDotCheckRuleBillController.cs
@@ -92,7 +92,7 @@ return objJsonResult; } bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); bool IsDete = oBill.DeleteBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo); if (IsDete) { objJsonResult.code = "0"; WebAPI/Controllers/SBGL/Sb_EquipMaintainRuleBillController.cs
@@ -90,7 +90,7 @@ objJsonResult.data = null; return objJsonResult; } if (oBill.omodel.HChecker != "") if (oBill.omodel.HChecker != ""&& oBill.omodel.HChecker != null) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -99,7 +99,7 @@ return objJsonResult; } bool IsDete = oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); bool IsDete = oBill.DeleteBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo); if (IsDete) { objJsonResult.code = "0"; WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Gy_StockCheckItemBillController.cs
New file @@ -0,0 +1,254 @@ 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 Gy_StockCheckItemBillController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus;//åæ®ç¶æï¼æ°å¢ï¼ä¿®æ¹ï¼æµè§ï¼æ´æ°åä»·ï¼åæ´ï¼ private json objJsonResult = new json(); public DataSet ds = new DataSet(); public SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); public Models.ClsGy_StockCheckItemBill BillNew0 = new Models.ClsGy_StockCheckItemBill(); #region çç¹æ¹æ¡å表 [Route("Gy_StockCheckItemBill/Get_StockCheckItemList")] [HttpGet] public object Get_StockCheckItemList(string sWhere) { try { ds = StockCheckItemList(sWhere); if (ds == null) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¥è¯¢æ°æ®å¼å¸¸ï¼è¯·ä¸ç®¡çåèç³»ï¼"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "è¿åè®°å½æåï¼"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } } catch (Exception ex) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¥è¯¢æ°æ®å¼å¸¸ï¼è¯·ä¸ç®¡çåèç³»ï¼" + ex.ToString(); objJsonResult.data = null; return objJsonResult; } } public static DataSet StockCheckItemList(string sWhere) { string sql1 = string.Format(@"select * from h_v_Gy_StockCheckItemList"); if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn(sql1 + sWhere + " order by hitemid desc", "h_v_Gy_StockCheckItemList"); } else { string sql = sql1 + sWhere + "order by hitemid desc"; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Gy_StockCheckItemList"); } } #endregion #region [çç¹æ¹æ¡å é¤åè½] [Route("Gy_StockCheckItemBill/set_DeleteBill")] [HttpGet] public object set_DeleteBill(string HItemID) { Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HItemID); if (lngBillKey == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®ID为空ï¼"; objJsonResult.data = null; return objJsonResult; } ds = oCn.RunProcReturn("select * from Gy_StockCheckItem where HItemID=" + lngBillKey, "Gy_StockCheckItem"); if (ds != null) { oCn.RunProc("Delete from Gy_StockCheckItem where HItemID=" + lngBillKey); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "å 餿åï¼"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¤åæ®ä¸åå¨ï¼è¯·æ¥çæ¯å¦éå¤å é¤"; objJsonResult.data = null; return objJsonResult; } } #endregion #region [ç¼è¾æ¾ç¤ºè¡¨å¤´] [Route("Gy_StockCheckItemBill/GetStockCheckItemByID")] [HttpGet] public object GetStockCheckItemByID(string HID) { Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HID); if (lngBillKey == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®ID为空ï¼"; objJsonResult.data = null; return objJsonResult; } ds = oCn.RunProcReturn("select * from Gy_StockCheckItem where HItemID=" + lngBillKey, "Gy_ConkReason"); if (ds != null) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = ""; objJsonResult.data = ds.Tables[0]; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¤åæ®ä¸åå¨"; objJsonResult.data = null; return objJsonResult; } } #endregion #region ä¿åçç¹æ¹æ¡ [Route("Gy_StockCheckItemBill/SaveGy_StockCheckItem")] [HttpPost] public object SaveGy_StockCheckItem([FromBody] JObject msg) { var _value = msg["msg"].ToString(); string msg2 = _value.ToString(); string[] sArray = msg2.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg1 = sArray[0].ToString(); string msg3 = sArray[1].ToString();//å½å人 SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ListModels oListModels = new ListModels(); try { Models.ClsGy_StockCheckItemBill oBill = new Models.ClsGy_StockCheckItemBill(); List<Models.ClsGy_StockCheckItemBill> lsmain = new List<Models.ClsGy_StockCheckItemBill>(); msg1 = msg1.Replace("\\", ""); msg1 = msg1.Replace("\n", ""); //\n lsmain = oListModels.getObjectByJson_Gy_StockCheckItem(msg1); foreach (Models.ClsGy_StockCheckItemBill 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; } //å¾å°ç代ç string sShortNumber; sShortNumber = DBUtility.ClsPub.GetShortNumber(oItem.HNumber.Trim()); if (sShortNumber.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败ï¼ç代ç 为空ï¼"; objJsonResult.data = 1; return objJsonResult; } oItem.HShortNumber = sShortNumber;//ç代ç oItem.HEndFlag = true;//æ«çº§æ å¿ oItem.HLevel = DBUtility.ClsPub.GetLevel(oItem.HNumber.Trim()); //ç级 oBill = oItem; } //ä¿å //ä¿å宿¯åå¤ç if (oBill.HItemID == 0) { oCn.RunProc("Insert into Gy_StockCheckItem " + " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + ",HLevel,HEndFlag,HStopflag,HRemark,HUseFlag,HMakeTime,HMakeEmp,HEndDate,HOrgID) " + " Values('" + oBill.HNumber + "','" + oBill.HName + "','" + oBill.HHelpCode + "','" + oBill.HShortNumber + "'," + oBill.HParentID.ToString() + "," + oBill.HLevel.ToString() + "," + Convert.ToString(oBill.HEndFlag ? 1 : 0) + "," + Convert.ToString(oBill.HStopflag ? 1 : 0) + ",'" + oBill.HRemark + "','" + oBill.HUseFlag + "',getdate(),'" + msg3 + "','" + oBill.HEndDate.ToString() + "'," + oBill.HOrgID.ToString()+ ")", ref DBUtility.ClsPub.sExeReturnInfo); //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç oCn.RunProc("Update Gy_StockCheckItem set HEndflag=0 where HItemID=" + oBill.HParentID, ref DBUtility.ClsPub.sExeReturnInfo); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "ä¿åæåï¼"; //WebAPIController.Add_Log("éè´§å䏿¨", UserName, "çæéè´§å"); objJsonResult.data = 1; return objJsonResult; } else { oCN.RunProc("UpDate Gy_StockCheckItem set " + " HNumber='" + oBill.HNumber + "'" + //åºå®èµå¼=============== ",HName='" + oBill.HName + "'" + ",HShortNumber='" + oBill.HShortNumber + "'" + ",HHelpCode='" + oBill.HHelpCode + "'" + ",HUseFlag='" + oBill.HUseFlag + "'" + ",HRemark='" + oBill.HRemark + "'" + ",HEndDate='" + oBill.HEndDate + "'" + ",HModifyTime=getdate()" + ",HModifyEmp='" + msg3 + "'" + ",HStopflag=" + Convert.ToString(oBill.HStopflag ? 1 : 0) + " where HItemID=" + oBill.HItemID.ToString()); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "ä¿®æ¹æåï¼"; objJsonResult.data = 1; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败ï¼" + e.ToString(); objJsonResult.data = 1; return objJsonResult; } } #endregion } } WebAPI/DLL/ClsSb_EquipDotCheckRuleBill.cs
@@ -12,7 +12,7 @@ public ClsSb_EquipDotCheckRuleBill() { base.MvarItemKeySub = "ClsSb_EquipDotCheckRuleBillSub"; base.MvarItemKeySub = "Sb_EquipDotCheckRuleBillSub"; base.MvarItemKeySub2 = ""; base.MvarItemKeySub3 = ""; base.MvarItemKeySub4 = ""; WebAPI/DLL/ClsSb_EquipMaintainRuleBill.cs
@@ -42,7 +42,7 @@ // oCn.BeginTran(); //æ´æ°ä¸»è¡¨ oCn.RunProc("UpDate Sb_EquipMaintainPlanBillMain set " + oCn.RunProc("UpDate Sb_EquipMaintainRuleBillMain set " + " HBillNo='" + omodel.HBillNo + "'" + //åºå®èµå¼=============== ",HDate='" + omodel.HDate + "'" + ",HYear='" + omodel.HYear.ToString() + "'" + @@ -83,7 +83,7 @@ //æå ¥é ä»¶å表 foreach (Models.ClsSb_EquipMaintainRuleBillSub oSub in DetailColl_Mater) { oCn.RunProc("Insert into Sb_EquipMaintainRuleBillSub " + string sql = "Insert into Sb_EquipMaintainRuleBillSub " + " (HInterID,HEntryID," + "HCloseMan,HEntryCloseDate,HCloseType,HRemark," + "HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney," + @@ -92,8 +92,9 @@ + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + "," + oSub.HQty.ToString() + "," + oSub.HMaterID.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HQtyMust.ToString() + ") "); "," + oSub.HQty.ToString() + "," + oSub.HMaterID.ToString() + "," + oSub.HUnitID.ToString() + ",0" + ") "; oCn.RunProc(sql); } sReturn = "ä¿®æ¹åæ®æåï¼"; oCn.Commit(); WebAPI/ListModels.cs
@@ -583,6 +583,18 @@ } /// <summary> /// å¤çæ°çç¹æ¹æ¡è¡¨çjson /// </summary> /// <param name="jsonString"></param> /// <returns></returns> public List<Models.ClsGy_StockCheckItemBill> getObjectByJson_Gy_StockCheckItem(string jsonString) { jsonString = "[" + jsonString.ToString() + "]"; List<Models.ClsGy_StockCheckItemBill> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsGy_StockCheckItemBill>>(jsonString); return list; } /// <summary> /// å¤çæ°å¢æ¨¡å ·ä¿å »è®°å½è¡¨ä¸»è¡¨çjson /// </summary> /// <param name="jsonString"></param> WebAPI/Models/ClsGy_StockCheckItemBill.cs
New file @@ -0,0 +1,32 @@ using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace WebAPI.Models { public class ClsGy_StockCheckItemBill : DBUtility.ClsGy_Base_Model { //public int HItemID; // int //ä¸»é® int //public string HNumber; // varchar(50) //代ç //public string HName; // varchar(50) //åç§° //public string HShortNumber; // varchar(50) //ç代ç //public int HParentID; // int //ç¶çº§ID int //public int HLevel; // int //ç级 int //public bool HEndFlag; // bit //æ«çº§æ å¿ bit //public bool HStopflag; // bit //ç¦ç¨æ å¿ bit //public string HRemark; // varchar(500) //夿³¨ varchar(50) //public string HHelpCode; // varchar(20) //å©è®°ç varchar(20) //public string HUseFlag; // varchar(10) //使ç¨ç¶æï¼æªæ£æµï¼æªä½¿ç¨ï¼å·²ä½¿ç¨ï¼ //public DateTime HMakeTime; // datetime //å»ºç«æ¶é´(getdate()) public string HMakeEmp; // varchar(100) //å建人 public string HCheckEmp; // varchar(100) //å®¡æ ¸äºº public DateTime HCheckTime; // datetime //å®¡æ ¸æ¶é´ public string HModifyEmp; // varchar(100) //ä¿®æ¹äºº public DateTime HModifyTime; // datetime //ä¿®æ¹æ¶é´ public string HStopEmp; // varchar(100) //ç¦ç¨äºº public DateTime HStopTime; // datetime //ç¦ç¨æ¶é´ public DateTime HEndDate; public int HOrgID; } } WebAPI/Properties/PublishProfiles/FolderProfile.pubxml.user
@@ -18,25 +18,25 @@ <publishTime>02/22/2013 08:43:40</publishTime> </File> <File Include="bin/BLL.dll"> <publishTime>12/10/2021 16:24:07</publishTime> <publishTime>12/14/2021 15:46:52</publishTime> </File> <File Include="bin/BLL.pdb"> <publishTime>12/10/2021 16:24:07</publishTime> <publishTime>12/14/2021 15:46:52</publishTime> </File> <File Include="bin/DAL.dll"> <publishTime>12/10/2021 16:24:05</publishTime> <publishTime>12/14/2021 15:46:49</publishTime> </File> <File Include="bin/DAL.pdb"> <publishTime>12/10/2021 16:24:05</publishTime> <publishTime>12/14/2021 15:46:49</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 14:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> <publishTime>12/10/2021 16:24:02</publishTime> <publishTime>12/14/2021 15:46:43</publishTime> </File> <File Include="bin/DBUtility.pdb"> <publishTime>12/10/2021 16:24:02</publishTime> <publishTime>12/14/2021 15:46:43</publishTime> </File> <File Include="bin/Interop.gregn6Lib.dll"> <publishTime>08/25/2021 10:28:25</publishTime> @@ -60,10 +60,10 @@ <publishTime>07/25/2012 11:48:56</publishTime> </File> <File Include="bin/Model.dll"> <publishTime>12/10/2021 16:24:03</publishTime> <publishTime>12/14/2021 15:46:44</publishTime> </File> <File Include="bin/Model.pdb"> <publishTime>12/10/2021 16:24:03</publishTime> <publishTime>12/14/2021 15:46:44</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> <publishTime>08/16/2021 17:23:15</publishTime> @@ -72,22 +72,22 @@ <publishTime>08/03/2014 20:33:56</publishTime> </File> <File Include="bin/Pub_Class.dll"> <publishTime>12/10/2021 16:24:00</publishTime> <publishTime>12/14/2021 15:46:39</publishTime> </File> <File Include="bin/Pub_Class.pdb"> <publishTime>12/10/2021 16:24:00</publishTime> <publishTime>12/14/2021 15:46:39</publishTime> </File> <File Include="bin/Pub_Control.dll"> <publishTime>12/10/2021 16:24:01</publishTime> <publishTime>12/14/2021 15:46:40</publishTime> </File> <File Include="bin/Pub_Control.pdb"> <publishTime>12/10/2021 16:24:01</publishTime> <publishTime>12/14/2021 15:46:40</publishTime> </File> <File Include="bin/SQLHelper.dll"> <publishTime>12/10/2021 16:24:01</publishTime> <publishTime>12/14/2021 15:46:41</publishTime> </File> <File Include="bin/SQLHelper.pdb"> <publishTime>12/10/2021 16:24:01</publishTime> <publishTime>12/14/2021 15:46:41</publishTime> </File> <File Include="bin/stdole.dll"> <publishTime>05/09/2021 13:35:37</publishTime> @@ -189,10 +189,10 @@ <publishTime>11/24/2014 11:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> <publishTime>12/10/2021 16:24:10</publishTime> <publishTime>12/14/2021 15:47:00</publishTime> </File> <File Include="bin/WebAPI.pdb"> <publishTime>12/10/2021 16:24:10</publishTime> <publishTime>12/14/2021 15:47:00</publishTime> </File> <File Include="bin/WebGrease.dll"> <publishTime>07/17/2013 17:03:52</publishTime> @@ -363,7 +363,7 @@ <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web.config"> <publishTime>12/10/2021 16:24:31</publishTime> <publishTime>12/14/2021 15:49:27</publishTime> </File> </ItemGroup> </Project> WebAPI/WebAPI.csproj
@@ -349,6 +349,7 @@ <Compile Include="Controllers\Open_PrintTemController.cs" /> <Compile Include="Controllers\ReportStepPlatFormController.cs" /> <Compile Include="Controllers\忥èªå¨æ«ç 线\ScanlineAPIController.cs" /> <Compile Include="Controllers\åºç¡èµæ\åºç¡èµæ\Gy_StockCheckItemBillController.cs" /> <Compile Include="Controllers\å·¥èµç®¡ç\Pay_OtherBalBillController.cs" /> <Compile Include="Controllers\å·¥èµç®¡ç\Pay_GroupBalBillController.cs" /> <Compile Include="Controllers\PurchaseOrderController.cs" /> @@ -451,6 +452,7 @@ <Compile Include="DLL\ClsSc_MouldMoveStockStepOutBill.cs" /> <Compile Include="DLL\å·¥èµç®¡ç\ClsPay_GroupBalBill.cs" /> <Compile Include="DLL\å·¥èµç®¡ç\ClsPay_WorkTimesBill.cs" /> <Compile Include="Models\ClsGy_StockCheckItemBill.cs" /> <Compile Include="Models\jsonScanline.cs" /> <Compile Include="Models\ScanLineCode.cs" /> <Compile Include="Models\å·¥èµç®¡ç\ClsPay_GroupBalBillEmp.cs" />