DAL/DAL.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
DAL/基础资料/其他基础资料/ClsGy_SupMaterial_Ctl.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
Model/Model.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
Model/基础资料/其他基础资料/ClsGy_SupMaterial_Model.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/CJGL/Cj_StationInBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/Gy_StdMinPickQtyController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Models/ClsGy_SupMaterial.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/WebAPI.csproj | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
DAL/DAL.csproj
@@ -103,6 +103,7 @@ <Compile Include="åºç¡èµæ\å ¶ä»åºç¡èµæ\ClsGy_MateMould_Ctl.cs" /> <Compile Include="åºç¡èµæ\å ¶ä»åºç¡èµæ\ClsGy_QCCheckProject_View.cs" /> <Compile Include="åºç¡èµæ\å ¶ä»åºç¡èµæ\ClsGy_StdWorkTimes_Ctl.cs" /> <Compile Include="åºç¡èµæ\å ¶ä»åºç¡èµæ\ClsGy_SupMaterial_Ctl.cs" /> <Compile Include="æºå\ERPæºå\Cls_S_Sc_ABJJD.cs" /> <Compile Include="æºå\InterFaceæºå\Cls_S_IF_ICMOBillList.cs" /> <Compile Include="æºå\InterFaceæºå\Cls_S_IF_ProcessReportBillList.cs" /> DAL/»ù´¡×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/ClsGy_SupMaterial_Ctl.cs
New file @@ -0,0 +1,183 @@ using DBUtility; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Text; namespace DAL { public class ClsGy_SupMaterial_Ctl: DBUtility.ClsGy_Base_Ctl { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); //å代ç ç¨äº æ¿æ¢åé¡¹ç® public string HOldNumber; public List<Model.ClsGy_SupMaterial_Model> DetailColl = new List<Model.ClsGy_SupMaterial_Model>(); //åå®¡æ ¸ public bool AbandonCheck(Int64 lngBillKey, ref string sReturn) { try { oCn.RunProc(" Update Gy_StdMinPickQty set HChecker='',HCheckDate=null Where HItemID=" + lngBillKey.ToString()); sReturn = ""; return true; } catch (Exception e) { sReturn = e.Message; return false; } } //å®¡æ ¸ public bool CheckBill(Int64 lngBillKey, ref string sReturn) { try { oCn.RunProc(" Update Gy_StdMinPickQty set HUsed=0,HChecker='" + DBUtility.ClsPub.CurUserName + "',HCheckDate='" + DBUtility.ClsPub.GetServerDate(-1) + "' Where HItemID=" + lngBillKey.ToString()); //å°å ¶ä» 工价设置为 åç¨ //oCn.RunProc(" exec h_p_Gy_MateMouldStopflag " + lngBillKey.ToString()); // sReturn = ""; return true; } catch (Exception e) { sReturn = e.Message; return false; } } //æ°å¢ public override bool AddNew() { try { oCn.BeginTran(); //æå ¥è¡¨ foreach (Model.ClsGy_SupMaterial_Model oSub in DetailColl) { DataSet Ds; Int64 HInterID = 1; Ds = oCn.RunProcReturn("select MAX(HInterID) HInterID from Gy_StdMinPickQty", "Gy_StdMinPickQty"); if (Ds.Tables[0].Rows.Count != 0 && ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString()) != 0) { HInterID = ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"].ToString()); HInterID += 1; } DataSet Cs; Int64 HEntryID = 1; Cs = oCn.RunProcReturn("select MAX(HEntryID) HEntryID from Gy_StdMinPickQty", "Gy_StdMinPickQty"); if (Cs.Tables[0].Rows.Count != 0 && ClsPub.isLong(Cs.Tables[0].Rows[0]["HEntryID"].ToString()) != 0) { HEntryID = ClsPub.isLong(Cs.Tables[0].Rows[0]["HEntryID"].ToString()); HEntryID += 1; } oCn.RunProc("Insert into Gy_StdMinPickQty " + " (HInterID,HEntryID,HMaterID,HPackTypeID,HSupID,HMinQty,HBagQty" + ",HBeginDate,HEndDate" + ",HUsed,HRemark,HMaker,HMakeDate)" + " values(" + HInterID + "," + HEntryID + "," + oSub.HMaterID.ToString() + "," + oSub.HPackTypeID.ToString() + "," + oSub.HSupID.ToString() + "," + oSub.HMinQty.ToString() + "," + oSub.HBagQty.ToString() + ",'" + oSub.HBeginDate.ToShortDateString() + "','" + oSub.HEndDate.ToShortDateString() + "'," + Convert.ToString(oSub.HUsed ? 1 : 0) + ",'" + oSub.HRemark + "','" + oSub.HMaker + "','" + oSub.HMakeDate + "'" + ") "); } oCn.Commit(); return true; } catch (Exception e) { oCn.RollBack(); throw (e); } } //ä¿®æ¹ public override bool ModifyByID(Int64 sItemID) { try { oCn.BeginTran(); //DeleteByID(sItemID); //å é¤è®°å½ ////æå ¥è¡¨ foreach (Model.ClsGy_SupMaterial_Model oSub in DetailColl) { // oCn.RunProc("Insert into Gy_StdMinPickQty " + // " (HMaterID,HRelationID,HUnitID" + // ",HBeginDate,HEndDate" + // ",HUsed,HRemark,HMaker,HMakeDate)" + // " values(" + oSub.HMaterID.ToString() + "," + oSub.HRelationID.ToString() + "," + oSub.HUnitID.ToString() + // ",'" + oSub.HBeginDate.ToShortDateString() + "','" + oSub.HEndDate.ToShortDateString() + "'," + Convert.ToString(oSub.HUsed ? 1 : 0) + ",'" + oSub.HRemark + "','" + oSub.HMaker + "','" + oSub.HMakeDate + "') "); oCn.RunProc("Update Gy_StdMinPickQty set " + "HMaterID=" + oSub.HMaterID + ",HSupID =" + oSub.HSupID + ",HPackTypeID =" + oSub.HPackTypeID + ",HMinQty =" + oSub.HMinQty + ",HBagQty =" + oSub.HBagQty + ",HRemark='" + oSub.HRemark + "'" + ",HBeginDate='" + oSub.HBeginDate + "'" + ",HEndDate='" + oSub.HEndDate + "'" + //",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + //",HUseFlag=" + Convert.ToString(HUseFlag ? 1 : 0) + //",HMakeTime= getdate()" + //",HMakeEmp='" + HMakeEmp + "'" + /*",HRemark='" + HRemark + */"Where HItemID ='" + sItemID + "'", ref DBUtility.ClsPub.sExeReturnInfo); } oCn.Commit(); return true; } catch (Exception e) { oCn.RollBack(); throw (e); } } //æ¾ç¤ºåæ® public bool ShowBill(Int64 lngBillKey, ref string sReturn) { try { //æ¥è¯¢ä¸»è¡¨ DataSet DsSub = new DataSet(); DsSub = oCn.RunProcReturn("Select * from Gy_StdMinPickQty Where HitemID=" + lngBillKey.ToString(), "Gy_StdMinPickQty"); DetailColl.Clear();//æ¸ ç©º for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++) { Model.ClsGy_SupMaterial_Model oSub = new Model.ClsGy_SupMaterial_Model(); oSub.HMaterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HMaterID"]); oSub.HUnitID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HUnitID"]); oSub.HBeginDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[i]["HBeginDate"]); oSub.HEndDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[i]["HEndDate"]); oSub.HRemark = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HRemark"]); oSub.HMaker = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HMaker"]); oSub.HMakeDate = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HMakeDate"]); oSub.HChecker = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HChecker"]); oSub.HCheckDate = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HCheckDate"]); DetailColl.Add(oSub); } sReturn = "æ¾ç¤ºåæ®æåï¼"; return true; } catch (Exception e) { sReturn = e.Message; return false; } } //æé 彿° public ClsGy_SupMaterial_Ctl() { MvarItemKey = "Gy_StdMinPickQty"; MvarReportTitle = "ä¾åºå对åºç©æèµæ"; } } } Model/Model.csproj
@@ -303,6 +303,7 @@ <Compile Include="åºç¡èµæ\å ¶ä»åºç¡èµæ\ClsGy_QCCheckProjectSub.cs" /> <Compile Include="åºç¡èµæ\å ¶ä»åºç¡èµæ\ClsGy_SourceShift_Model.cs" /> <Compile Include="åºç¡èµæ\å ¶ä»åºç¡èµæ\ClsGy_StdWorkTimes_Model.cs" /> <Compile Include="åºç¡èµæ\å ¶ä»åºç¡èµæ\ClsGy_SupMaterial_Model.cs" /> <Compile Include="åºç¡èµæ\å ¶ä»åºç¡èµæ\ClsGy_TechParamByProc_Model.cs" /> <Compile Include="åºç¡èµæ\å ¶ä»åºç¡èµæ\ClsGy_UserCustomerRelation_Model.cs" /> <Compile Include="åºç¡èµæ\å ¶ä»åºç¡èµæ\ClsGy_UserDeptRelation_Model.cs" /> Model/»ù´¡×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/ClsGy_SupMaterial_Model.cs
New file @@ -0,0 +1,24 @@ using System; using System.Collections.Generic; using System.Linq; using System.Text; namespace Model { public class ClsGy_SupMaterial_Model : DBUtility.ClsGy_Base_Model { public long HInterID; public long HPackTypeID; public long HSupID; public decimal HMinQty; public decimal HBagQty; public long HMaterID; public bool HUsed; //å½åæ£å¨å¯ç¨ public DateTime HBeginDate; public DateTime HEndDate; public string HMaker; public string HMakeDate; public string HChecker; public string HCheckDate; } } WebAPI/Controllers/CJGL/Cj_StationInBillController.cs
@@ -1042,5 +1042,61 @@ } } #endregion #region è¿åç¨æ·è·åé»è®¤å¼å表 [Route("Cj_StationInBill/GetDefValByUser")] [HttpGet] public object GetDefValByUser(string Czybm, string Czymc) { try { ////夿æ¯å¦ææ¥è¯¢æé //if (!DBUtility.ClsPub.Security_Log("Cj_StationInBill_Query", 1, false, user)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æ æ¥è¯¢æé!"; // objJsonResult.data = null; // return objJsonResult; //} if (Czymc == null || Czymc.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Cj_GetDefValByUser", "h_v_Cj_GetDefValByUser"); } else { string sql1 = "select * from h_v_Cj_GetDefValByUser where 1 = 1 "; string sql = sql1 + " and ç¨æ·ç¼ç ='" + Czybm + "' and ç¨æ·åç§° ='" + Czymc + "'"; ds = oCN.RunProcReturn(sql, "h_v_Cj_GetDefValByUser"); } if (ds.Tables[0].Rows.Count != 0 || ds != null) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; 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/Controllers/Gy_StdMinPickQtyController.cs
New file @@ -0,0 +1,326 @@ using Newtonsoft.Json; using Newtonsoft.Json.Linq; using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Web; using System.Web.Http; using WebAPI.Models; namespace WebAPI.Controllers { public class Gy_StdMinPickQtyController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus; private json objJsonResult = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); DataSet ds; /// <summary> /// è¿åä¾åºåä¸ç©ææ¸ åå表 ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Gy_StdMinPickQty/list")] [HttpGet] public object list(string sWhere, string user, string Organization) { try { List<object> columnNameList = new List<object>(); //ç¼è¾æé //if (!DBUtility.ClsPub.Security_Log_second("Gy_StdMinPickQty", 1, false, user)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æ æ¥çæéï¼"; // objJsonResult.data = null; // return objJsonResult; //} string sql1 = string.Format(@"select * from h_v_Gy_StdMinPickQtyList where 1 =1 ");//where ç»ç»åç§°='" + Organization + "' if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn(sql1 + sWhere + " order by HItemID ", "h_v_Gy_StdMinPickQtyList"); } else { string sql = sql1 + sWhere + " order by HItemID"; ds = oCN.RunProcReturn(sql, "h_v_Gy_StdMinPickQtyList"); } //æ·»å åå 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; } } /// <summary> /// æ ¹æ®åºç¡èµæID æ¥æ¾è®°å½ ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Gy_StdMinPickQty/cx")] [HttpGet] public object cx(long HInterID) { try { ds = oCN.RunProcReturn("select * from h_v_Gy_StdMinPickQtyList where HitemID=" + HInterID, "h_v_Gy_StdMinPickQtyList"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "falseï¼"; objJsonResult.data = null; return objJsonResult; } else { 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; } } #region ä¾åºåä¸ç©ææ¸ åä¿å [Route("Gy_StdMinPickQty/set_SaveBill")] [HttpPost] public object set_SaveBill([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); //ä¿ååæ® return objJsonResult = AddBillMain(msg1); } public json AddBillMain(string msg1) { string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); string OperationType = sArray[2].ToString().Trim(); string msg4 = sArray[3].ToString(); bool bResult; try { //æ¥çæé //if (!DBUtility.ClsPub.Security_Log("Gy_ProcPriceList_Edit", 1, false, msg4)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æ ä¿åæéï¼"; // objJsonResult.data = null; // return objJsonResult; //} msg2 = "[" + msg2.ToString() + "]"; List<ClsGy_SupMaterial> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsGy_SupMaterial>>(msg2); List<ClsGy_SupMaterial> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<ClsGy_SupMaterial>>(msg3); DAL.ClsGy_SupMaterial_Ctl BillNew = new DAL.ClsGy_SupMaterial_Ctl(); BillNew.DetailColl = new List<Model.ClsGy_SupMaterial_Model>(); Model.ClsGy_SupMaterial_Model BillOld = new Model.ClsGy_SupMaterial_Model(); for (int i = 0; i < subList.ToArray().Length; i++) { if (i >= 0)//HQty { Model.ClsGy_SupMaterial_Model oSub = new Model.ClsGy_SupMaterial_Model(); oSub.HMaterID = DBUtility.ClsPub.isLong(subList[i].HMaterIDCol); oSub.HPackTypeID = DBUtility.ClsPub.isLong(subList[i].HPackTypeIDCol); oSub.HSupID = DBUtility.ClsPub.isLong(subList[i].HSupIDCol); oSub.HMinQty = DBUtility.ClsPub.isLong(subList[i].HMinQtyCol); oSub.HBagQty = DBUtility.ClsPub.isLong(subList[i].HBagQtyCol); oSub.HBeginDate = DBUtility.ClsPub.isDate(subList[i].HBeginDateCol); oSub.HEndDate = DBUtility.ClsPub.isDate(subList[i].HEndDateCol); oSub.HUsed = false; oSub.HMaker = DBUtility.ClsPub.isStrNull(mainList[0].HMaker); oSub.HMakeDate = DateTime.Today.ToString(); oSub.HRemark = DBUtility.ClsPub.isStrNull(subList[i].HRemarkCol); BillNew.DetailColl.Add(oSub); } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ æç»è¡ä¿¡æ¯!"; objJsonResult.data = null; return objJsonResult; } } //ä¿å宿¯åå¤ç if (OperationType.Equals("1.1") || OperationType.Equals("1.2") || OperationType.Equals("2")) { bResult = BillNew.AddNew(); } else { bResult = BillNew.ModifyByID(DBUtility.ClsPub.isLong(subList[0].HItemID)); } //æç¤º if (bResult == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "ä¿åæåï¼"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; //objJsonResult.Message = "ä¿å失败!åå :" + ClsPub.sExeReturnInfo; objJsonResult.data = null; 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_StdMinPickQty/GetSupMaterialValue")] [HttpGet] public object GetSupMaterialValue(int HItemID) { try { List<object> columnNameList = new List<object>(); //ds = oCN.RunProcReturn("select * from h_v_Gy_StdMinPickQtyList where HItemID = " + HItemID, "h_v_Gy_StdMinPickQtyList"); ds = oCN.RunProcReturn("select " + "a.HItemID,a.HMaterID HMaterIDCol,a.ç©æä»£ç ,a.ç©æåç§°,a.è§æ ¼åå·" + ",a.HSupID HSupIDCol,a.ä¾åºå代ç ,a.ä¾åºååç§° ,a.HPackTypeID HPackTypeIDCol,a.å è£ æ¹å¼ä»£ç " + ",a.å è£ æ¹å¼åç§° ,a.æ åå è£ æ°é,a.å¤ç®±å è£ æ°é" + ",a.å¼å§æ¥æ ,a.ç»ææ¥æ ,a.夿³¨, a.å¶å人,a.å¶åæ¥æ" + " from h_v_Gy_StdMinPickQtyList a " + " where a.HItemID = " + HItemID, "Gy_MateMouldInfo"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ å表信æ¯ï¼"; objJsonResult.data = null; return objJsonResult; } else { //æ·»å åå 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 /// <summary> /// ä¾åºåç©æå表å é¤åè½ /// </summary> /// <returns></returns> [Route("DeltetGy_StdMinPickQty")] [HttpGet] public object DeltetGy_StdMinPickQty(string HItemID) { DataSet ds; 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();//å¼å§äºå¡ ds = oCN.RunProcReturn("select * from Gy_StdMinPickQty where HItemID=" + HItemID, "Gy_StdMinPickQty"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ²¡ææ°æ®ï¼æ æ³å é¤ï¼"; objJsonResult.data = null; return objJsonResult; ; } oCN.RunProc("delete from Gy_StdMinPickQty 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; } } } } WebAPI/Models/ClsGy_SupMaterial.cs
New file @@ -0,0 +1,25 @@ using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace WebAPI.Models { public class ClsGy_SupMaterial { public long HMaterIDCol { get; set; } public long HPackTypeIDCol { get; set; } public long HSupIDCol { get; set; } public decimal HMinQtyCol { get; set; } public decimal HBagQtyCol { get; set; } public DateTime HBeginDateCol { get; set; } public DateTime HEndDateCol { get; set; } public string HMaker { get; set; } public string HRemarkCol { get; set; } public long HItemID { get; set; } } } WebAPI/WebAPI.csproj
@@ -393,6 +393,7 @@ <Compile Include="Controllers\CJGL\Cj_StationEntrustOutBillController.cs" /> <Compile Include="Controllers\CJGL\Sc_WorkBillAutoSortBillMainController.cs" /> <Compile Include="Controllers\Gy_MateMouldController.cs" /> <Compile Include="Controllers\Gy_StdMinPickQtyController.cs" /> <Compile Include="Controllers\MJGL\Sc_MouldDotCheckRuleBillController.cs" /> <Compile Include="Controllers\MJGL\Sc_MouldLifeUseBillController.cs" /> <Compile Include="Controllers\MJGL\Sc_MouldScrapRequestBillController.cs" /> @@ -605,6 +606,7 @@ <Compile Include="InvokeHelper.cs" /> <Compile Include="Log.cs" /> <Compile Include="Models\ClsGy_MateMould.cs" /> <Compile Include="Models\ClsGy_SupMaterial.cs" /> <Compile Include="Models\ClsSc_AssemblyBillMain.cs" /> <Compile Include="Models\ClsSc_AssemblyBillSub.cs" /> <Compile Include="Models\Employee.cs" /> @@ -930,6 +932,7 @@ <Folder Include="Views\Gy_SettleStyle\" /> <Folder Include="Views\Gy_SOPBill\" /> <Folder Include="Views\Gy_Staff\" /> <Folder Include="Views\Gy_StdMinPickQty\" /> <Folder Include="Views\Gy_StockPlace_\" /> <Folder Include="Views\Gy_StockStatusBill\" /> <Folder Include="Views\Gy_SupplierContactBill\" />