DAL/ÐÅϢƽ̨/ClsOA_ErrMsgBackCheckBill.cs
@@ -195,7 +195,7 @@ oCn.RunProc(sql); //éªæ¶åååå¼å¸¸åé¦å,ä¸ºå·²å®æ oCn.RunProc("update OA_ErrMsgBackBillMain set HResult='已宿' where HInterID="+ omodel.HErrMsgBackInterID); oCn.RunProc("update OA_ErrMsgBackBillMain set HCloseFlag='1' where HInterID=" + omodel.HErrMsgBackInterID); //=========================ä¿ååæ§å¶ DataSet ds2 = oCn.RunProcReturn("Exec h_p_OA_ErrMsgBackCheckBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',1 ", "h_p_OA_ErrMsgBackCheckBill_AfterSaveCtrl"); WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs
@@ -461,36 +461,36 @@ //主表 LogService.Write($"5.ç³»ç»æ§å¶æ¥è¯¢å¤æï¼ç¨æ¶" + sw.Elapsed); //ds = oCN.RunProcReturn("exec h_p_MES_StationOutBill_QtyCtrl " + HInterID + "", "h_p_MES_StationOutBill_QtyCtrl"); //if (ds == null) //{ // oCN.RollBack(); // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "夿æ°é失败ï¼"; // objJsonResult.data = null; // return objJsonResult; //} //LogService.Write($"5.1ï¼ç¨æ¶" + sw.Elapsed); //if (ds.Tables[0].Rows.Count == 0) //{ // oCN.RollBack(); // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "夿æ°é失败ï¼"; // objJsonResult.data = null; // return objJsonResult; //} //LogService.Write($"5.2ï¼ç¨æ¶" + sw.Elapsed); //if (ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) == "2") //{ // oCN.RollBack(); // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æ°éæ§å¶," + ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]); // objJsonResult.data = null; // return objJsonResult; //} ds = oCN.RunProcReturn("exec h_p_MES_StationOutBill_QtyCtrl " + HInterID + "", "h_p_MES_StationOutBill_QtyCtrl"); if (ds == null) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "夿æ°é失败ï¼"; objJsonResult.data = null; return objJsonResult; } LogService.Write($"5.1ï¼ç¨æ¶" + sw.Elapsed); if (ds.Tables[0].Rows.Count == 0) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "夿æ°é失败ï¼"; objJsonResult.data = null; return objJsonResult; } LogService.Write($"5.2ï¼ç¨æ¶" + sw.Elapsed); if (ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) == "2") { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ°éæ§å¶," + ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]); objJsonResult.data = null; return objJsonResult; } LogService.Write($"6.å¤æç»æï¼ç¨æ¶" + sw.Elapsed); oCN.RunProc("exec h_p_Mes_ProcessExchangeRelationQty_Out " + HInterID + ","+ num + ""); LogService.Write($"6.1ï¼ç¨æ¶" + sw.Elapsed); WebAPI/Controllers/SCGL/Sc_MESTransFerWorkBillController.cs
@@ -534,11 +534,12 @@ A.HLevel,A.HMaterNumber,A.HMaterName,A.HMaterModel, B.HReadFlag, A.HMaker,A.HMakeDate,A.HUpDater,A.HUpDateDate,A.HChecker,A.HCheckDate,A.HCloseMan,A.HCloseDate,A.HDeleteMan,A.HDeleteDate, A.HSourceInterID,A.HSourceEntryID,A.HSourceBillNo,A.HSourceBillType, A.HHandleEmpID,f.HName HHandleEmpName A.HHandleEmpID,f.HName HHandleEmpName,A.HErrMsgBackTypeID,g.HName HErrMsgBackTypeName from OA_ErrMsgBackBillMain A inner join OA_ErrMsgBackBillSub2 B on A.HInterID=B.HInterID left join Gy_Department D on A.HDeptID=D.HItemID left join Gy_Employee f on A.HHandleEmpID=f.HItemID left join Gy_Employee f on A.HHandleEmpID=f.HItemID left join Gy_ErrMsgBackType g on A.HErrMsgBackTypeID=g.HItemID where A.HInterID='" + HID + "' and b.HEntryID='" + HEntryID + "'"); var dataSet = oCN.RunProcReturn(sql, "OA_ErrMsgBackBillMain"); if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) @@ -1027,6 +1028,7 @@ { bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); _ = SendDingDingAsync(oBill.omodel.HSendMan, oBill.omodel.HHandleEmpID,oBill.omodel.HDescription,""); } else if (refSav == "Update") { @@ -2001,6 +2003,7 @@ { bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); _ = SendDingDingAsync(oBill.omodel.HSendMan, 1, oBill.omodel.HDescription, oBill.omodel.HReceiveMan); } else if (refSav == "Update") { @@ -2917,6 +2920,7 @@ { bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); _ = SendDingDingAsync(oBill.omodel.HSendMan, 1, oBill.omodel.HDescription, oBill.omodel.HReceiveMan); } else if (refSav == "Update") { @@ -3830,6 +3834,7 @@ { bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); _ = SendDingDingAsync(oBill.omodel.HReceiveMan, 0, oBill.omodel.HDescription, oBill.omodel.HCopyMan); } else if (refSav == "Update") { @@ -6606,7 +6611,95 @@ #endregion #region å¼å¸¸åé¦ æ¥æ¶,å¤ç,éªæ¶åä¿ååéæ¶æ¯ /// <summary> /// å¼å¸¸åé¦ æ¥æ¶,å¤ç,éªæ¶åä¿ååéæ¶æ¯ /// </summary> /// <param name="HSendMan"></param> /// <param name="HHandleEmpID"></param> /// <param name="HDescription"></param> /// <param name="HCopyMan"></param> /// <returns></returns> public async Task<object> SendDingDingAsync(string HSendMan, int HHandleEmpID,string HDescription,string HCopyMan) { string concatenatedNames = ""; Cls_DDMsg msg = new Cls_DDMsg(); string appKey = "dingrsrzhdyn3mlaof95"; string appSecret = "RAqH6YtZnPLCpDbuqfaYQkKkVtVdS0wqfC8I26X6qiS-8eoCJCNrzx3fubGND4Sq"; if (HHandleEmpID==0) //å¼å¸¸åé¦éªæ¶åä¿å å°æ¶æ¯ åéç» æ¥æ¶äººï¼ææ´¾å¤ç人ï¼å ¨é¨æé人 { string HReceiveMan = HSendMan; string[] names = HCopyMan.Split(','); string sqlNames = ""; foreach (string name in names) { sqlNames += "'" + name.Trim() + "',"; } sqlNames = sqlNames.TrimEnd(','); //è·åææ´¾å¤ç人,åé人çééid string sql1 = "select HDingDingUserID ééid from Gy_Czygl where Czymc in ('" + HReceiveMan + "'," + sqlNames + ")"; ds = oCN.RunProcReturn(sql1, "Gy_Czygl"); List<string> HNames = new List<string>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string HName = ds.Tables[0].Rows[i]["ééid"].ToString(); HNames.Add(HName); } concatenatedNames = string.Join(",", HNames); } else if (HHandleEmpID==1)//å¼å¸¸åé¦ç¾å°å,å¼å¸¸åé¦å¤çå å°æ¶æ¯ åéç» åéäººï¼æ¥æ¶äºº { //è·ååé人 æ¥æ¶äºº string HReceiveMan = HCopyMan; string sql1 = "select HDingDingUserID ééid from Gy_Czygl where Czymc in ('" + HSendMan + "','" + HReceiveMan + "')"; ds = oCN.RunProcReturn(sql1, "Gy_Czygl"); List<string> HNames = new List<string>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string HName = ds.Tables[0].Rows[i]["ééid"].ToString(); HNames.Add(HName); } concatenatedNames = string.Join(",", HNames); } else { //æ¥è¯¢ææ´¾å¤ç人 string sql = "select HName from Gy_Employee where HItemID='" + HHandleEmpID + "'"; ds = oCN.RunProcReturn(sql, "Gy_Employee"); string HHandleEmpName = ds.Tables[0].Rows[0]["HName"].ToString(); //è·åææ´¾å¤ç人,åé人çééid string sql1 = "select HDingDingUserID ééid from Gy_Czygl where Czymc in ('" + HSendMan + "','" + HHandleEmpName + "')"; ds = oCN.RunProcReturn(sql1, "Gy_Czygl"); List<string> HNames = new List<string>(); for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { string HName = ds.Tables[0].Rows[i]["ééid"].ToString(); HNames.Add(HName); } concatenatedNames = string.Join(",", HNames); } //è·åä¼ä¸çaccess_tokençå¼ string response = msg.GetAccessToken(appKey, appSecret); JObject responseJson = JObject.Parse(response); // è·åaccess_tokençå¼ string accessToken = responseJson["accessToken"].ToString(); //è°ç¨æ¹æ³åéæ¶æ¯ string agentId = "3118119317";//ééåå°å»ºç«çå°ç¨åºid string userIdList = concatenatedNames;//éé人åçid string deptIdList = "0"; // 空åç¬¦ä¸²è¡¨ç¤ºä¸æå®é¨é¨ string toAllUser = "false"; string message = HDescription; response = await msg.SendTextMessage(accessToken, agentId, userIdList, deptIdList, toAllUser, message); Console.WriteLine(response); return response; } #endregion #region å¼å¸¸åé¦åæ¥è¯¢ï¼æ¥æ¶çï¼åéçï¼æéçï¼ @@ -6657,5 +6750,129 @@ } #endregion #region æ¥å·¥å°è·³è½¬å¼å¸¸åé¦å å¼¹çªè·åçäº§ç¶æä¸´æ¶è¡¨ç ç©æ æ°é ä¿¡æ¯ [Route("Sc_MESTransFerWorkBill/Get_Sc_ICMOBillStatus")] [HttpGet] public object Get_Sc_ICMOBillStatus(string HSourceBill) { try { List<object> columnNameList = new List<object>(); string sql = "select a.HSourceBillNo æµè½¬å¡å·,a.HSourceBillType æµè½¬å¡ç±»å,a.HSourceInterID æµè½¬å¡ä¸»å ç ,a.HSourceEntryID æµè½¬å¡åå ç ,b.HNumber ç©æä»£ç ,b.HName ç©æåç§°,b.HModel è§æ ¼åå·,a.HPlanQty è®¡åæ°é from Sc_ICMOBillStatus_Tmp a left join Gy_Material b on a.HMaterID=b.HItemID where HSourceBillNo='" + HSourceBill + "'"; ds = oCN.RunProcReturn(sql, "Sc_ICMOBillStatus_Tmp"); //æ·»å åå 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 ex) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¥è¯¢æ°æ®å¼å¸¸ï¼è¯·ä¸ç®¡çåèç³»ï¼" + ex.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region æ¥å·¥å°è·³è½¬å¼å¸¸åé¦å å¼¹çªè·å å¼å¸¸ç±»å [Route("Sc_MESTransFerWorkBill/Get_ErrMsgBackType")] [HttpGet] public object Get_ErrMsgBackType(string TypeName) { try { List<object> columnNameList = new List<object>(); string sql = "select HItemID,HName from Gy_ErrMsgBackType where HName='" + TypeName + "'"; ds = oCN.RunProcReturn(sql, "Gy_ErrMsgBackType"); //æ·»å åå 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 ex) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¥è¯¢æ°æ®å¼å¸¸ï¼è¯·ä¸ç®¡çåèç³»ï¼" + ex.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region æ¥å·¥å°è·³è½¬å¼å¸¸åé¦å å¼¹çªè·å å½å人çä¸çº§ [Route("Sc_MESTransFerWorkBill/Get_UserSuperiors")] [HttpGet] public object Get_UserSuperiors(string HName) { try { List<object> columnNameList = new List<object>(); //æ ¹æ®å½å人è·åèå¡ string sql = "select a.Czymc ç¨æ·åç§°,c.GroupName èå¡ from Gy_Czygl a left join System_UserGroupInfo b on a.Czybm = b.UserId left join System_UserGroup c on b.GroupId = c.GroupID where a.Czymc = '"+HName+"'"; ds = oCN.RunProcReturn(sql, "Gy_ErrMsgBackType"); string Job = ds.Tables[0].Rows[0]["èå¡"].ToString(); //æ ¹æ®è塿¾å°ä»çä¸çº§ string sql1 = "select * from Gy_Duty where HParentID=(select HParentID from Gy_Duty where HItemID =(select HParentID from Gy_Duty group by HParentID, HName having HName = '"+Job+"' and count(*) = 1))"; ds = oCN.RunProcReturn(sql1, "Gy_Duty"); string Job1= ds.Tables[0].Rows[0]["HName"].ToString(); //ç¨ä¸çº§çè塿¾å°ç¨æ· string sql2 = "select a.Czymc ç¨æ·åç§° from Gy_Czygl a left join System_UserGroupInfo b on a.Czybm = b.UserId left join System_UserGroup c on b.GroupId = c.GroupID where c.GroupName = '"+Job1+"'"; ds = oCN.RunProcReturn(sql2, "Gy_Czygl"); //æ·»å åå 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 ex) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¥è¯¢æ°æ®å¼å¸¸ï¼è¯·ä¸ç®¡çåèç³»ï¼" + ex.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion } } WebAPI/Controllers/Sc_MouldRepairInBillListController.cs
@@ -5796,7 +5796,7 @@ } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); //è·åä¿å »é¡¹ç®ç¼è¾æ°æ® string sql = "select HMaintainItemID, ä¿å »é¡¹ç®ä»£ç HMaintainItemNumber,ä¿å »é¡¹ç®åç§° HMaintainItem,ä¿å »é¨ä½ HMaintainPart,å ·ä½è¦æ± HClaim,HManagerID,è´è´£äººä»£ç HManagerNumber,è´è´£äºº HManagerName,表ä½å¤æ³¨ HRemark from h_v_Sc_MouldMaintainBillListItem where 1 = 1 " + Swhere + ""; string sql = "select HMaintainItemID, ä¿å »é¡¹ç®ä»£ç HMaintainItemNumber,ä¿å »é¡¹ç®åç§° HMaintainItem,ä¿å »é¨ä½ HMaintainPart,å ·ä½è¦æ± HClaim,HManagerID,è´è´£äººä»£ç HManagerNumber,è´è´£äºº HManagerName,表ä½å¤æ³¨ HRemark,ä¿å »ç»æ HMaintainResult from h_v_Sc_MouldMaintainBillListItem where 1 = 1 " + Swhere + ""; ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldMaintainBillListItem"); //è·åé 件项ç®ç¼è¾æ°æ® string sql1 = "select HMaterID, é 件代ç HMaterNumber,é ä»¶åç§° HMaterName,è§æ ¼åå· HMaterSpec,HUnitID,åä½ä»£ç HUnitNumber,åä½åç§° HUnitName,å®é ç¨é HQty,æ åç¨é HQtyMust,HManagerID,è´è´£äººä»£ç HManagerNumber,è´è´£äºº HManagerName,表ä½å¤æ³¨ HRemark from h_v_Sc_MouldMaintainBillList where 1 = 1 " + Swhere + ""; WebAPI/Controllers/²Ö´æ¹ÜÀí/ÌõÂëÉú³É/Sc_BarCodeController.cs
@@ -833,6 +833,8 @@ Int64 HGroupID = 0; long HEmpID = 0; string HCusModel = ""; //客æ·ç©æè§æ ¼ string HCusMaterName = ""; //客æ·ç©æåç§° DataSet Ds; msg2 = msg2.Replace("\\", ""); @@ -854,6 +856,8 @@ HheatNO = ClsPub.isStrNull(ordrlist[j].HheatNO); HGroupID = ClsPub.isInt(ordrlist[j].HGroupID); HEmpID = ClsPub.isLong(ordrlist[j].HEmpID); HCusModel = ClsPub.isStrNull(ordrlist[j].HCusModel); HCusMaterName = ClsPub.isStrNull(ordrlist[j].HCusMaterName); //æ¥æè·åæ¹å¼ sDate = DateTime.Now.ToString(); // @@ -1203,6 +1207,8 @@ barcode.HGroupID2 = ordrlist[j].HGroupID; barcode.HEmpID2 = ordrlist[j].HEmpID; barcode.HCusModel2 = ordrlist[j].HCusModel; barcode.HCusMaterName2 = ordrlist[j].HCusMaterName; ListRows.Add(barcode); k = k + 1; n = n + 1; @@ -1252,6 +1258,8 @@ DateTime HProduceDate; DateTime HExpiryDate; long HEmpID2 = 0; string HCusModel2 = ""; string HCusMaterName2 = ""; try { @@ -1307,6 +1315,8 @@ HExpiryDate = ClsPub.isDate(ListRows[i].HExpiryDate); HGroupID2 = ClsPub.isInt(ListRows[i].HGroupID2); HEmpID2 = ClsPub.isLong(ListRows[i].HEmpID2); HCusModel2 = ClsPub.isStrNull(ListRows[i].HCusModel2); HCusMaterName2 = ClsPub.isStrNull(ListRows[i].HCusMaterName2); oCN.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" + ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " + @@ -1315,7 +1325,7 @@ ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " + ",HGiveAwayFlag " + ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo" + ",HCoilNO,HFurnaceNO,HFactory,HAuxQty,HheatNO,HProduceDate,HExpiryDate,HEmpID " + ",HCoilNO,HFurnaceNO,HFactory,HAuxQty,HheatNO,HProduceDate,HExpiryDate,HEmpID,HCusModel,HCusMaterName " + ") values (" + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString() + ",'" + HBatchNo2 + "'," + HSupID.ToString() + "," + HGroupID2.ToString() + ",'" + ClsPub.CurUserName + "',getdate()," + HPrintQty.ToString() + "," + HQty2.ToString() @@ -1324,7 +1334,7 @@ + ", " + HCusID.ToString() + ",'" + HCusType + "','" + HEndDate.ToShortDateString() + "','" + HWorkLineName + "','" + sDate + "'" + ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",'" + HSeOrderBillNo + "'," + HInterID.ToString() + "," + HEntryID.ToString() + "" + ", " + DBUtility.ClsPub.BoolToString(HGiveAwayFlag) + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "','" + HCoilNO2 + "','" + HFurnaceNO2 + "','" + HFactory2 + "'," + HAuxQty2 + ",'" + HheatNO2 + "','" + HProduceDate + "','" + HExpiryDate + "'," + HEmpID2.ToString() + ")"); + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "','" + HCoilNO2 + "','" + HFurnaceNO2 + "','" + HFactory2 + "'," + HAuxQty2 + ",'" + HheatNO2 + "','" + HProduceDate + "','" + HExpiryDate + "'," + HEmpID2.ToString() + ",'" + HCusModel2 + "','" + HCusMaterName2 + "'" + ")"); //HNumber = ClsPub.isStrNull(grdSub.Rows[i].Cells[HMaterID2Col].Value); WebAPI/Controllers/Æ·ÖʹÜÀí/Ѳ¼ìµ¥/QC_PatrolProcCheckOtherBillController.cs
@@ -24,7 +24,7 @@ //è·åç³»ç»åæ° Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); #region å·¡æ£åå表 ä¸ ç¼è¾åæ¾ #region å·¡æ£åå表 [Route("QC_PatrolProcCheckOtherBill/QC_PatrolProcCheckOtherBillList")] [HttpGet] public object QC_FirstPieceCheckBillList(string sWhere, string user) @@ -63,6 +63,45 @@ } #endregion #region å·¡æ£åç¼è¾åæ¾ [Route("QC_PatrolProcCheckOtherBill/QC_PatrolProcCheckOtherBillList_Edit")] [HttpGet] public object QC_FirstPieceCheckBillList_Edit(string sWhere, string user) { try { List<object> columnNameList = new List<object>(); string sql1 = "select * from h_v_QC_PatrolProcCheckOtherBill_Edit where 1 = 1 "; string sql = sql1 + sWhere + " order by hmainid desc"; ds = oCN.RunProcReturn(sql, "h_v_QC_PatrolProcCheckOtherBill_Edit"); //æ·»å åå 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.list = columnNameList; 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("QC_PatrolProcCheckOtherBill/set_SaveBill")] [HttpPost] WebAPI/Controllers/Æ·ÖʹÜÀí/¹¤Ðò¼ìÑéµ¥/QC_ProcessCheckBillController.cs
@@ -177,6 +177,56 @@ } #endregion #region å·¥åºæ£éªåç¼è¾æ¥è¯¢æ°æ® [Route("QC_ProcessCheckBill/QC_ProcessCheckBill_Edit")] [HttpGet] public object QC_ProcessCheckBill_Edit(string sWhere, string user) { try { List<object> columnNameList = new List<object>(); string sql1 = "select * from h_v_QC_ProcessCheckBill_Edit where 1 = 1 "; string sql = sql1 + sWhere + " order by hmainid desc"; ds = oCN.RunProcReturn(sql, "h_v_QC_ProcessCheckBill_Edit"); //æ·»å åå 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å对象çåå } if (ds.Tables[0].Rows.Count > 0) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.list = columnNameList; objJsonResult.data = ds.Tables[0]; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ²¡ææ¥è¯¢å°æ°æ®"; objJsonResult.list = columnNameList; 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 å·¥åºæ£éªå å®¡æ ¸ åå®¡æ ¸ å ³é åå ³é ä½åº åä½åº /// <summary> WebAPI/Controllers/Æ·ÖʹÜÀí/Ê×¼þ¼ìÑéµ¥/QC_FirstPieceCheckBillController.cs
@@ -126,6 +126,57 @@ } #endregion #region é¦ä»¶æ£éªåç¼è¾è·åæ°æ® [Route("QC_FirstPieceCheckBill/QC_FirstPieceCheckBill_Edit")] [HttpGet] public object QC_FirstPieceCheckBill_Edit(string sWhere, string user) { try { List<object> columnNameList = new List<object>(); string sql1 = "select * from h_v_QC_FirstPieceCheckBill_Edit where 1 = 1 "; string sql = sql1 + sWhere + " order by hmainid desc"; ds = oCN.RunProcReturn(sql, "h_v_QC_FirstPieceCheckBill_Edit"); //æ·»å åå 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å对象çåå } if (ds.Tables[0].Rows.Count > 0) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.list = columnNameList; objJsonResult.data = ds.Tables[0]; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ²¡ææ¥è¯¢å°æ°æ®"; objJsonResult.list = columnNameList; 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("QC_FirstPieceCheckBill/set_SaveBill")] [HttpPost] WebAPI/Controllers/Éú²ú¹ÜÀí/ÖÊÁ¿»ã±¨µ¥/Sc_QualityReportBillController.cs
@@ -744,6 +744,99 @@ } #endregion #region ä¸è¯ééæ¹éæ±æ¥ æ°å¢ [Route("Sc_QualityReportBill/SaveSc_QualityReportBillSub")] [HttpPost] public object SaveSc_QualityReportBillSub([FromBody] JObject msg) { var _value = msg["msg"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); //è¡¨å¤´æ°æ® string msg3 = sArray[1].ToString(); //å表1æ°æ® string refSav = sArray[2].ToString(); //æä½æ¹å¼ string msg4 = sArray[3].ToString(); //ç¨æ· DBUtility.ClsPub.CurUserName = msg4; ListModels oListModels = new ListModels(); try { DAL.ClsSc_QualityReportBill oBill = new DAL.ClsSc_QualityReportBill(); //è¡¨ä½æ°æ® //æ },{æ¥æåæ°ç» //廿ãåã msg3 = msg3.Substring(1, msg3.Length - 2); msg3 = msg3.Replace("\\", ""); msg3 = msg3.Replace("\n", ""); //\n List<Model.ClsSc_QualityReportBillSub> ls = new List<Model.ClsSc_QualityReportBillSub>(); ls = oListModels.getObjectByJson_Sc_QualityReportBillSub(msg3); int i = 0; foreach (Model.ClsSc_QualityReportBillSub oSub in ls) { i++; oSub.HMakeDate = DateTime.Now; oSub.HEntryID = i; string subSql = "Insert into Sc_QualityReportBillSub " + " (HInterID,HEntryID,HBillNo_bak,HRemark" + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" + ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" + ",HBarCode,HReportType" + ",HAddr,HMaker,HMakeDate" + ") values(" + "" + oSub.HInterID.ToString() + "" + "," + oSub.HEntryID.ToString() + "" + ",'" + oSub.HBillNo_bak + "'" + ",'" + oSub.HRemark + "'" + "," + oSub.HSourceInterID.ToString() + "" + "," + oSub.HSourceEntryID.ToString() + "" + ",'" + oSub.HSourceBillNo + "'" + ",'" + oSub.HSourceBillType + "'" + "," + oSub.HRelationQty.ToString() + "" + "," + oSub.HRelationMoney.ToString() + "," + oSub.HMaterID.ToString() + "" + "," + oSub.HUnitID.ToString() + "" + ",'" + oSub.HQty.ToString() + "','" + oSub.HResult + "'" + "," + oSub.HEmpID.ToString() + "" + "," + oSub.HSourceID.ToString() + "" + "," + oSub.HBadReasonID.ToString() + "" + "," + oSub.HICMOInterID.ToString() + "" + "," + oSub.HICMOEntryID.ToString() + "" + ",'" + oSub.HICMOBillNo + "'" + "," + oSub.HProcExchInterID + "" + "," + oSub.HProcExchEntryID + "" + ",'" + oSub.HProcExchBillNo + "'" + ",'" + oSub.HBarCode + "'" + ",'" + 3 + "','" + oSub.HAddr + "'" + ",'" + msg4 + "'" + ",'" + oSub.HMakeDate.ToShortDateString() + "'" + ") "; oCN.RunProc(subSql); } objJsonResult.code = "0"; 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/Models/HBarCodeList.cs
@@ -73,5 +73,8 @@ public Int64 HGroupID2 { get; set; } //"çç»"; public Int64 HEmpID2 { get; set; } //"æä½å"; public string HCusModel2 { get; set; } //"客æ·ç©æè§æ ¼"; public string HCusMaterName2 { get; set; } //"客æ·ç©æåç§°"; } } WebAPI/Models/HSouceOrderList.cs
@@ -76,5 +76,7 @@ public Int64 HEmpID { get; set; } //"æä½å"; public string HEmpNumber { get; set; } //"æä½å"; public string HEmpName { get; set; } //"æä½å"; public string HCusModel { get; set; } //"客æ·ç©æè§æ ¼"; public string HCusMaterName { get; set; } //"客æ·ç©æåç§°"; } } WebAPI/Properties/PublishProfiles/FolderProfile.pubxml
@@ -10,7 +10,7 @@ <LastUsedBuildConfiguration>Debug</LastUsedBuildConfiguration> <LastUsedPlatform>x86</LastUsedPlatform> <PublishProvider>FileSystem</PublishProvider> <PublishUrl>G:\issWeb\ç½ç«åå¸\API</PublishUrl> <PublishUrl>D:\ç½ç«åå¸\æºäºMESWMS\API</PublishUrl> <WebPublishMethod>FileSystem</WebPublishMethod> <SiteUrlToLaunchAfterPublish /> </PropertyGroup> WebAPI/Properties/PublishProfiles/FolderProfile13.pubxml
New file @@ -0,0 +1,17 @@ <?xml version="1.0" encoding="utf-8"?> <!-- https://go.microsoft.com/fwlink/?LinkID=208121. --> <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <PropertyGroup> <DeleteExistingFiles>True</DeleteExistingFiles> <ExcludeApp_Data>False</ExcludeApp_Data> <LaunchSiteAfterPublish>True</LaunchSiteAfterPublish> <LastUsedBuildConfiguration>Debug</LastUsedBuildConfiguration> <LastUsedPlatform>Any CPU</LastUsedPlatform> <PublishProvider>FileSystem</PublishProvider> <PublishUrl>D:\ç½ç«åå¸\æºäºMESWMS\API</PublishUrl> <WebPublishMethod>FileSystem</WebPublishMethod> <SiteUrlToLaunchAfterPublish /> </PropertyGroup> </Project> WebAPI/Properties/PublishProfiles/FolderProfile13.pubxml.user
New file @@ -0,0 +1,459 @@ <?xml version="1.0" encoding="utf-8"?> <!-- https://go.microsoft.com/fwlink/?LinkID=208121. --> <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <PropertyGroup> <_PublishTargetUrl>D:\ç½ç«åå¸\æºäºMESWMS\API</_PublishTargetUrl> <History>True|2024-07-02T00:52:20.9683250Z;True|2024-07-01T15:34:19.0810024+08:00;True|2024-07-01T15:29:41.8587401+08:00;True|2024-07-01T15:06:46.7127992+08:00;True|2024-07-01T14:45:31.0703303+08:00;True|2024-07-01T14:13:18.0986061+08:00;True|2024-07-01T14:11:15.8643251+08:00;True|2024-07-01T13:29:59.6069813+08:00;True|2024-07-01T11:12:59.9147877+08:00;True|2024-07-01T10:22:37.9929084+08:00;True|2024-07-01T10:20:59.0844221+08:00;True|2024-07-01T10:17:38.9582335+08:00;True|2024-07-01T10:09:18.2084318+08:00;True|2024-07-01T10:08:49.4427785+08:00;True|2024-07-01T10:05:38.5373813+08:00;True|2024-07-01T09:47:53.4738455+08:00;</History> </PropertyGroup> <ItemGroup> <File Include="apiapp.json"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="bin/Aliyun.Credentials.dll"> <publishTime>12/05/2022 15:40:12</publishTime> </File> <File Include="bin/Antlr3.Runtime.dll"> <publishTime>02/22/2013 16:43:40</publishTime> </File> <File Include="bin/Antlr3.Runtime.pdb"> <publishTime>02/22/2013 16:43:40</publishTime> </File> <File Include="bin/BLL.dll"> <publishTime>07/02/2024 08:52:03</publishTime> </File> <File Include="bin/BLL.pdb"> <publishTime>07/02/2024 08:52:03</publishTime> </File> <File Include="bin/BouncyCastle.Crypto.dll"> <publishTime>12/18/2020 05:32:28</publishTime> </File> <File Include="bin/DAL.dll"> <publishTime>07/02/2024 08:52:01</publishTime> </File> <File Include="bin/DAL.pdb"> <publishTime>07/02/2024 08:52:01</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 22:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> <publishTime>07/02/2024 08:51:59</publishTime> </File> <File Include="bin/DBUtility.pdb"> <publishTime>07/02/2024 08:51:59</publishTime> </File> <File Include="bin/Grpc.Core.Api.dll"> <publishTime>03/22/2022 13:17:26</publishTime> </File> <File Include="bin/Grpc.Core.Api.pdb"> <publishTime>03/19/2022 07:39:42</publishTime> </File> <File Include="bin/Grpc.Core.dll"> <publishTime>03/22/2022 13:17:20</publishTime> </File> <File Include="bin/Grpc.Core.pdb"> <publishTime>03/19/2022 07:39:48</publishTime> </File> <File Include="bin/grpc_csharp_ext.x64.dll"> <publishTime>03/22/2022 13:17:22</publishTime> </File> <File Include="bin/grpc_csharp_ext.x86.dll"> <publishTime>03/22/2022 13:17:22</publishTime> </File> <File Include="bin/ICSharpCode.SharpZipLib.dll"> <publishTime>05/09/2021 01:08:30</publishTime> </File> <File Include="bin/ICSharpCode.SharpZipLib.pdb"> <publishTime>05/09/2021 01:08:30</publishTime> </File> <File Include="bin/Kingdee.BOS.WebApi.Client.dll"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="bin/libgrpc_csharp_ext.x64.dylib"> <publishTime>03/19/2022 07:38:44</publishTime> </File> <File Include="bin/libgrpc_csharp_ext.x64.so"> <publishTime>03/19/2022 07:38:42</publishTime> </File> <File Include="bin/Microsoft.Azure.AppService.ApiApps.Service.dll"> <publishTime>03/19/2015 01:02:50</publishTime> </File> <File Include="bin/Microsoft.CSharp.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/Microsoft.Web.Infrastructure.dll"> <publishTime>07/25/2012 19:48:56</publishTime> </File> <File Include="bin/Model.dll"> <publishTime>07/02/2024 08:51:59</publishTime> </File> <File Include="bin/Model.pdb"> <publishTime>07/02/2024 08:51:59</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="bin/Newtonsoft.Json.dll"> <publishTime>09/07/2014 18:39:38</publishTime> </File> <File Include="bin/NPOI.dll"> <publishTime>10/23/2021 09:07:54</publishTime> </File> <File Include="bin/NPOI.OOXML.dll"> <publishTime>10/23/2021 09:07:56</publishTime> </File> <File Include="bin/NPOI.OOXML.pdb"> <publishTime>10/23/2021 17:07:56</publishTime> </File> <File Include="bin/NPOI.OpenXml4Net.dll"> <publishTime>10/23/2021 09:07:54</publishTime> </File> <File Include="bin/NPOI.OpenXml4Net.pdb"> <publishTime>10/23/2021 17:07:54</publishTime> </File> <File Include="bin/NPOI.OpenXmlFormats.dll"> <publishTime>10/23/2021 09:07:54</publishTime> </File> <File Include="bin/NPOI.OpenXmlFormats.pdb"> <publishTime>10/23/2021 17:07:54</publishTime> </File> <File Include="bin/NPOI.pdb"> <publishTime>10/23/2021 17:07:54</publishTime> </File> <File Include="bin/Pub_Class.dll"> <publishTime>07/02/2024 08:51:57</publishTime> </File> <File Include="bin/Pub_Class.pdb"> <publishTime>07/02/2024 08:51:57</publishTime> </File> <File Include="bin/Pub_Control.dll"> <publishTime>07/02/2024 08:51:57</publishTime> </File> <File Include="bin/Pub_Control.pdb"> <publishTime>07/02/2024 08:51:57</publishTime> </File> <File Include="bin/RestSharp.dll"> <publishTime>08/31/2012 06:22:50</publishTime> </File> <File Include="bin/SQLHelper.dll"> <publishTime>07/02/2024 08:51:58</publishTime> </File> <File Include="bin/SQLHelper.pdb"> <publishTime>07/02/2024 08:51:58</publishTime> </File> <File Include="bin/Swashbuckle.Core.dll"> <publishTime>02/16/2015 01:57:08</publishTime> </File> <File Include="bin/System.Buffers.dll"> <publishTime>07/19/2017 18:01:28</publishTime> </File> <File Include="bin/System.ComponentModel.DataAnnotations.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.Configuration.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.Data.DataSetExtensions.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.Data.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.Drawing.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.EnterpriseServices.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.IdentityModel.Tokens.Jwt.dll"> <publishTime>08/19/2014 18:03:34</publishTime> </File> <File Include="bin/System.Memory.dll"> <publishTime>04/18/2019 00:24:34</publishTime> </File> <File Include="bin/System.Net.Http.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.Net.Http.Extensions.dll"> <publishTime>02/20/2015 04:10:46</publishTime> </File> <File Include="bin/System.Net.Http.Formatting.dll"> <publishTime>11/28/2018 21:00:36</publishTime> </File> <File Include="bin/System.Net.Http.Primitives.dll"> <publishTime>02/20/2015 04:10:46</publishTime> </File> <File Include="bin/System.Runtime.CompilerServices.Unsafe.dll"> <publishTime>09/19/2018 03:38:10</publishTime> </File> <File Include="bin/System.Runtime.Serialization.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.Web.ApplicationServices.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.Web.Cors.dll"> <publishTime>11/28/2018 20:58:44</publishTime> </File> <File Include="bin/System.Web.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.Web.DynamicData.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.Web.Entity.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.Web.Extensions.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.Web.Helpers.dll"> <publishTime>01/28/2015 12:04:30</publishTime> </File> <File Include="bin/System.Web.Http.Cors.dll"> <publishTime>11/28/2018 21:01:26</publishTime> </File> <File Include="bin/System.Web.Http.dll"> <publishTime>11/28/2018 21:01:00</publishTime> </File> <File Include="bin/System.Web.Http.WebHost.dll"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="bin/System.Web.Mvc.dll"> <publishTime>01/28/2015 12:02:18</publishTime> </File> <File Include="bin/System.Web.Optimization.dll"> <publishTime>02/11/2014 23:26:04</publishTime> </File> <File Include="bin/System.Web.Razor.dll"> <publishTime>01/28/2015 12:02:32</publishTime> </File> <File Include="bin/System.Web.Services.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.Web.WebPages.Deployment.dll"> <publishTime>01/28/2015 12:04:30</publishTime> </File> <File Include="bin/System.Web.WebPages.dll"> <publishTime>01/28/2015 12:04:30</publishTime> </File> <File Include="bin/System.Web.WebPages.Razor.dll"> <publishTime>01/28/2015 12:04:30</publishTime> </File> <File Include="bin/System.Xml.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/System.Xml.Linq.dll"> <publishTime>09/26/2012 03:16:08</publishTime> </File> <File Include="bin/WebActivatorEx.dll"> <publishTime>11/24/2014 19:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> <publishTime>07/02/2024 08:52:11</publishTime> </File> <File Include="bin/WebAPI.pdb"> <publishTime>07/02/2024 08:52:11</publishTime> </File> <File Include="bin/WebGrease.dll"> <publishTime>07/18/2013 01:03:52</publishTime> </File> <File Include="bin/zh-Hans/System.Net.Http.Formatting.resources.dll"> <publishTime>11/29/2018 21:26:02</publishTime> </File> <File Include="bin/zh-Hans/System.Web.Http.resources.dll"> <publishTime>11/29/2018 21:26:30</publishTime> </File> <File Include="Config/kdapi.config"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Content/bootstrap.css"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Content/bootstrap.min.css"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Content/Site.css"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="DLL/BLL.dll"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="DLL/DAL.dll"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="DLL/DBUtility.dll"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="DLL/Kingdee.BOS.WebApi.Client.dll"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="DLL/Model.dll"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="DLL/Newtonsoft.Json.Net35.dll"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="DLL/Pub_Class.dll"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="DLL/Pub_Control.dll"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="DLL/SQLHelper.dll"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.eot"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.svg"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.ttf"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.woff"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Global.asax"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="grpc_csharp_ext.x64.dll"> <publishTime>03/22/2022 13:17:22</publishTime> </File> <File Include="grpc_csharp_ext.x86.dll"> <publishTime>03/22/2022 13:17:22</publishTime> </File> <File Include="Index.html"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="libgrpc_csharp_ext.x64.dylib"> <publishTime>03/19/2022 07:38:44</publishTime> </File> <File Include="libgrpc_csharp_ext.x64.so"> <publishTime>03/19/2022 07:38:42</publishTime> </File> <File Include="libman.json"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="packages.config"> <publishTime>06/25/2024 09:50:21</publishTime> </File> <File Include="Views/Scripts/bootstrap.js"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Views/Scripts/bootstrap.min.js"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.js"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.min.js"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.min.map"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Views/Scripts/jquery.validate.js"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Views/Scripts/jquery.validate.min.js"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Views/Scripts/jquery.validate.unobtrusive.js"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Views/Scripts/modernizr-2.6.2.js"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Views/Shared/Error.cshtml"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Views/Shared/_Layout.cshtml"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Views/web.config"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Views/_ViewStart.cshtml"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Department_Model.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_Customer_Model.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_Department_Model.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_Employee_Model.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_Group_Model.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_Source_Model.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsKf_ICStockBill_Mould.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web References/WebS/Reference.map"> <publishTime>05/25/2024 09:46:41</publishTime> </File> <File Include="Web.config"> <publishTime>07/02/2024 08:52:20</publishTime> </File> </ItemGroup> </Project>