DAL/²Ö¿â¹ÜÀí/ClsKf_SellOutBillForLayUI.cs
@@ -170,6 +170,7 @@ ",HSTOCKORGID = " + omodel.HOrgID + "" + ",HOWNERID = " + omodel.HOrgID + "" + ",HOrgID = " + omodel.HOrgID + "" + ",HBillNo='" + omodel.HBillNo + "'" + ",HMainSourceInterID = " + omodel.HMainSourceInterID + "" + ",HMainSourceEntryID = " + omodel.HMainSourceEntryID + "" + ",HMainSourceBillNo = '" + omodel.HMainSourceBillNo + "'" + WarM/ÌõÂë´òÓ¡/Gy_CusBarCodeBill_KaiBei_LangChao.cs
@@ -771,7 +771,8 @@ } // LSH = LSH + 1; LSH2 = ConvertToBase(LSH, 36); LSH2 = LSH.ToString(); //LSH2 = ConvertToBase(LSH, 34); while (LSH2.Length < LSHlen) //å¦ææµæ°´å·ä½æ°å°äº LSHlen åé¢è¡¥0 { LSH2 = "0" + LSH2; @@ -1008,7 +1009,7 @@ #region å°åè¿å¶æ°å¼è½¬ææå®è¿å¶æ°å¼ï¼num为è¦è½¬æ¢çåè¿è¡æ°å¼ï¼nbase为æå®è¿å¶ï¼ public string ConvertToBase(int num, int nbase) { string chars = "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"; string chars = "0123456789ABCDEFGHJKLMNPQRSTUVWXYZ"; if (nbase < 2 || nbase > chars.Length) return ""; int r; WebAPI/Controllers/CGGL/Cg_POInStockBillController.cs
@@ -524,7 +524,7 @@ return objJsonResult; } ds = oCN.RunProcReturn("select * from h_v_IF_POInStockBillList where hmainid=" + HInterID + " and åæ®å·='" + HBillNo + "'", "h_v_IF_POOrderBillList"); ds = oCN.RunProcReturn("select * from h_v_IF_POInStockBillList where hmainid=" + HInterID, "h_v_IF_POOrderBillList"); if ((OperationType == 1 || OperationType == 2 || OperationType == 4) && ds.Tables[0].Rows.Count == 0)//æ°å¢ { @@ -570,7 +570,7 @@ else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) { //ä¿®æ¹ DataSet dss; dss = oCN.RunProcReturn("select * from h_v_IF_POInStockBillList where hmainid=" + HInterID + " and åæ®å·='" + HBillNo + "'", "h_v_IF_POOrderBillList"); dss = oCN.RunProcReturn("select * from h_v_IF_POInStockBillList where hmainid=" + HInterID , "h_v_IF_POOrderBillList"); //夿æ¯å¦å¯ç¼è¾ if (dss.Tables[0].Rows[0]["å®¡æ ¸äºº"].ToString() != "" && dss.Tables[0].Rows[0]["å®¡æ ¸äºº"] != null) { @@ -590,8 +590,8 @@ } string sql= $@"update Cg_POInStockBillMain set " + "HRemark='" + HRemark + "', HUpDater ='" + HMaker + "', HUpDateDate=getdate()" + ",HSupID=" + HSupID + ",HCurID=" + HCurID "HRemark='" + HRemark + "', HUpDater ='" + HMaker + "', HUpDateDate=getdate()"+ ",HBillNo='" + HBillNo + "'" + ",HSupID=" + HSupID + ",HCurID=" + HCurID + ",HExRate=" + HExRate + ",HEmpID=" + HEmpID + ",HManagerID=" + HManagerID + ",HDeptID=" + HDeptID + ",HAddress='" + HAddress + "',HInnerBillNo='" + HInnerBillNo + "',HProjectID="+ HProjectID + ",HInvoiceBillNo='"+ HInvoiceBillNo + "' where HInterID=" + HInterID; WebAPI/Controllers/CGGL/Cg_POOrderBillController.cs
@@ -841,7 +841,7 @@ { //ä¿®æ¹ DataSet dss; dss = oCN.RunProcReturn("select * from h_v_IF_POOrderBillList where hmainid=" + HInterID + " and åæ®å·='" + HBillNo + "'", "h_v_IF_POOrderBillList"); dss = oCN.RunProcReturn("select * from h_v_IF_POOrderBillList where hmainid=" + HInterID, "h_v_IF_POOrderBillList"); //夿æ¯å¦å¯ç¼è¾ if (dss.Tables[0].Rows[0]["å®¡æ ¸äºº"].ToString() != "" && dss.Tables[0].Rows[0]["å®¡æ ¸äºº"] != null) { @@ -860,7 +860,7 @@ return objJsonResult; } oCN.RunProc("update Cg_POOrderBillMain set " + "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + ",HBillNo='" +HBillNo +"'"+ ",HSSID=" + HSSID + ",HPSStyleID=" + HPSStyleID + ",HSupID=" + HSupID + ",HCurID=" + HCurID + ",HExRate=" + HExRate + ",HEmpID=" + HEmpID + ",HManagerID=" + HManagerID + ",HDeptID=" + HDeptID + ",HAddress='" + HAddress + "',HSSDate='" + HSSDate + "',HWHID="+ HWHID + ",HProjectID="+ HProjectID +",HLinkMan = '"+HLinkMan+"',HLinkPhone = '"+HLinkPhone+ "' where HInterID=" + HInterID); WebAPI/Controllers/CGGL/Kf_POStockInBillController.cs
@@ -194,7 +194,7 @@ return objJsonResult; } ds = oCN.RunProcReturn("select * from h_v_Kf_POStockInBillList where hmainid=" + HInterID + " and åæ®å·='" + HBillNo + "'", "h_v_Kf_POStockInBillList"); ds = oCN.RunProcReturn("select * from h_v_Kf_POStockInBillList where hmainid=" + HInterID, "h_v_Kf_POStockInBillList"); if ((OperationType == 1 || OperationType == 2 || OperationType == 4) && ds.Tables[0].Rows.Count == 0)//æ°å¢ { @@ -235,7 +235,7 @@ { //ä¿®æ¹ DataSet dss; dss = oCN.RunProcReturn("select * from h_v_Kf_POStockInBillList where hmainid=" + HInterID + " and åæ®å·='" + HBillNo + "'", "h_v_Kf_POStockInBillList"); dss = oCN.RunProcReturn("select * from h_v_Kf_POStockInBillList where hmainid=" + HInterID , "h_v_Kf_POStockInBillList"); //夿æ¯å¦å¯ç¼è¾ if (dss.Tables[0].Rows[0]["å®¡æ ¸äºº"].ToString() != "" && dss.Tables[0].Rows[0]["å®¡æ ¸äºº"] != null) { @@ -255,7 +255,7 @@ } String sql = $@"update Kf_ICStockBillMain set " + "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + ",HBillNo='" + HBillNo + "'" + ",HSupID=" + HSupID + ",HCurID=" + HCurID + ",HSecManagerID=" + HSecManagerID + ", HSTOCKORGID=" + HSTOCKORGID + ",HKeeperID=" + HKeeperID + ",HWHID = " + HWHID + ",HEmpID=" + HEmpID + ",HManagerID=" + HManagerID + ",HDeptID=" + HDeptID + ",HOWNERID=" + HOWNERID + ",HAddress='" + HAddress + "',HInnerBillNo='" + HInnerBillNo + "',HProjectID="+ HProjectID + ",HInvoiceBillNo='"+ HInvoiceBillNo + "' where HInterID=" + HInterID; WebAPI/Controllers/CJGL/Cj_NoPassProcController.cs
@@ -77,8 +77,14 @@ try { List<object> columnNameList = new List<object>(); Dictionary<object, object> dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<object, object>>(sWhere); ds = oCN.RunProcReturn("exec h_p_Cj_HeatTreatmentTemperatureCurveChart '"+ sWhere + "'", "h_p_Cj_HeatTreatmentTemperatureCurveChart"); string HEquipNumber = dic["HEquipNumber"].ToString();//设å¤ç¼ç string HBeginDate = dic["HBeginDate"].ToString();//é鿥æ string HEndDate = dic["HEndDate"].ToString();//é鿥æ string HProcExchBillNo = dic["HProcExchBillNo"].ToString();//å·¥åºæµè½¬å¡ ds = oCN.RunProcReturn("exec h_p_Cj_HeatTreatmentTemperatureCurveChart '" + HEquipNumber + "','" + HBeginDate + "','" + HEndDate + "','" + HProcExchBillNo + "'", "h_p_Cj_HeatTreatmentTemperatureCurveChart"); //æ·»å åå foreach (DataColumn col in ds.Tables[0].Columns) @@ -105,5 +111,49 @@ } } #endregion #region 车é´ç®¡ç å¹²ç¥æºæ¸©åº¦æ²çº¿å¾ [Route("Cj_NoPassProc/Cj_TemperatureCurveDryingMachine")] [HttpGet] public object Cj_TemperatureCurveDryingMachine(string sWhere, string user) { try { List<object> columnNameList = new List<object>(); Dictionary<object, object> dic = Newtonsoft.Json.JsonConvert.DeserializeObject<Dictionary<object, object>>(sWhere); string HEquipNumber = dic["HEquipNumber"].ToString();//设å¤ç¼ç string HBeginDate = dic["HBeginDate"].ToString();//é鿥æ string HEndDate = dic["HEndDate"].ToString();//é鿥æ string HProcExchBillNo = dic["HProcExchBillNo"].ToString();//å·¥åºæµè½¬å¡ ds = oCN.RunProcReturn("exec h_p_Cj_TemperatureCurveDryingMachine '" + HEquipNumber + "','"+ HBeginDate + "','"+ HEndDate + "','" + HProcExchBillNo + "'", "h_p_Cj_TemperatureCurveDryingMachine"); //æ·»å åå 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 = ""; objJsonResult.data = ds; 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 } } WebAPI/Controllers/CJGL/Cj_SingleStationController.cs
@@ -1010,7 +1010,7 @@ #region å·¥åºååè¿ç« é ä»¶ç æ¥è¯¢ [Route("Cj_SingleStation/HBardCodeAccessoryList")] [HttpGet] public object HBardCodeAccessoryList(string HBarCode, string user) public object HBardCodeAccessoryList(string HBarCode, string HProcExchBillNo, string user,string HBillType) { try { @@ -1043,6 +1043,25 @@ return objJsonResult; } DataSet dataSet = oCN.RunProcReturn(@"exec h_p_CJ_SNBarCodeBillMouldBathSelect '" + HBarCode + "','" + HProcExchBillNo + "','"+ HBillType + "'", "h_p_CJ_SNBarCodeBillMouldBathSelect"); if (dataSet.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "é ä»¶æ¡ç å¤æå¤±è´¥ï¼"; objJsonResult.data = null; return objJsonResult; } if (ClsPub.isStrNull(dataSet.Tables[0].Rows[0]["HBack"]) == "2") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = DBUtility.ClsPub.isStrNull(dataSet.Tables[0].Rows[0]["HBackRemark"]); objJsonResult.data = null; return objJsonResult; } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = ""; WebAPI/Controllers/JHGL/Gy_RoutingBillController.cs
@@ -292,7 +292,7 @@ DataSet dss; dss = oCN.RunProcReturn("select * from Gy_RoutingBillMain where HInterID=" + HInterID + " and HBillNo='" + HBillNo + "'", "Gy_RoutingBillMain"); //夿æ¯å¦å¯ç¼è¾ if ((dss.Tables[0].Rows[0]["HChecker"].ToString() != "" && dss.Tables[0].Rows[0]["HChecker"] != null) || (dss.Tables[0].Rows[0]["HBillStatus"].ToString() != "1" && dss.Tables[0].Rows[0]["HBillStatus"].ToString() != "0")) if ((dss.Tables[0].Rows[0]["HChecker"].ToString() != "" && dss.Tables[0].Rows[0]["HChecker"] != null) || (dss.Tables[0].Rows[0]["HBillStatus"].ToString() != "1" && dss.Tables[0].Rows[0]["HBillStatus"].ToString() != "0" && dss.Tables[0].Rows[0]["HBillStatus"].ToString() != "5")) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -2046,6 +2046,17 @@ objJsonResult.count = CountConstant.SUCCEED; objJsonResult.Message = "å®¡æ ¸æå"; objJsonResult.data = null; //è·åç³»ç»åæ° string Ret = ""; if (oSystemParameter.ShowBill(ref Ret)) { //å¤æå®¢æ· if (oSystemParameter.omodel.WMS_CampanyName == "æ·»åº·ç§æ") //ç³»ç»åæ° { //å·æ°é»è®¤å·¥èºè·¯çº¿ oCN.RunProc("exec h_p_Gy_RoutingBillCheck " + HInterID + ",'" + CurUserName + "'"); } } } else { WebAPI/Controllers/LMESController.cs
@@ -1326,7 +1326,7 @@ { string sql1 = "select * from h_v_Gy_RoutingBillList where 1 = 1 "; //客æ·èªå®ä¹ if (oSystemParameter.omodel.WMS_CampanyName == "çä¸ç¥º" || oSystemParameter.omodel.WMS_CampanyName == "å¯è´å¥ç¹" || oSystemParameter.omodel.WMS_CampanyName == "æ·»åº·ç§æ") if (oSystemParameter.omodel.WMS_CampanyName == "çä¸ç¥º" || oSystemParameter.omodel.WMS_CampanyName == "å¯è´å¥ç¹" ) { sql1 = "select top 1000 * from h_v_Gy_RoutingBillList where 1 = 1 "; } WebAPI/Controllers/XSGL/Xs_ReceivableBillController.cs
@@ -25,6 +25,38 @@ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); DataSet ds; #region åºæ¶åå表 æ ¹æ®åä»·ç±»åè·åç©æåå» /// <summary> /// è¿ååºæ¶åå表 ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Xs_ReceivableBill/getPriceByType")] [HttpGet] public object getPriceByType(string HMaterID, string HType) { try { string sql1 = "exec h_p_Xs_ReceivableBill_getPriceByType " + HMaterID + ",'" + HType + "'"; ds = oCN.RunProcReturn(sql1, "h_p_Xs_ReceivableBill_getPriceByType"); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = ds.Tables[0].Rows[0]["HPrice"].ToString(); 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/XSGL/Xs_SeOutStockBillController.cs
@@ -389,7 +389,7 @@ string HLinkPhone = mainList[0].HLinkPhone; string HSeOrderBillNo_M = mainList[0].HSeOrderBillNo_M; ds = oCN.RunProcReturn("select * from h_v_IF_SeOutStockBillList where hmainid=" + HInterID + " and åæ®å·='" + HBillNo + "'", "h_v_IF_SeOutStockBillList"); ds = oCN.RunProcReturn("select * from h_v_IF_SeOutStockBillList where hmainid=" + HInterID, "h_v_IF_SeOutStockBillList"); //è¿è¡ ä¼è®¡æé´ ç»è´¦ çå¤æåæ§å¶ string s = ""; @@ -450,7 +450,7 @@ { //ä¿®æ¹ DataSet dss; dss = oCN.RunProcReturn("select * from h_v_IF_SeOutStockBillList where hmainid=" + HInterID + " and åæ®å·='" + HBillNo + "'", "h_v_IF_SeOutStockBillList"); dss = oCN.RunProcReturn("select * from h_v_IF_SeOutStockBillList where hmainid=" + HInterID, "h_v_IF_SeOutStockBillList"); //夿æ¯å¦å¯ç¼è¾ if (dss.Tables[0].Rows[0]["å®¡æ ¸äºº"].ToString() != "" && dss.Tables[0].Rows[0]["å®¡æ ¸äºº"] != null) { @@ -470,7 +470,7 @@ } string sql = $@"update Xs_SeOutStockBillMain set " + "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + ",HBillNo='" + HBillNo + "'" + ",HCusID='" + HCusID + "', HCurID='" + HCurID + "', HWHID = '" + HWHID + "',HExRate='" + HExRate + "',HEmpID='" + HEmpID + "',HSeOrderBillNo_M='" + HSeOrderBillNo_M + "',HManagerID='" + HManagerID + "',HDeptID='" + HDeptID + "',HOWNERID='" + HOWNERID + "',HAddress='" + HAddress + "',HProjectID='"+ HProjectID + "' where HInterID=" + HInterID; WebAPI/Controllers/¹¤×ʹÜÀí/Pay_GroupBalBillController.cs
@@ -496,6 +496,63 @@ } #endregion #region å·¥èµç»ç®åé使¹éå®¡æ ¸äºç /// <summary> /// å·¥èµç»ç®åæ¹éå®¡æ ¸äºç /// </summary> /// <returns></returns> [Route("Pay_GroupBalBillController/CheckAllByTimeAndGroup")] [HttpGet] public object CheckAllByTimeAndGroup(string sWhere, string HMaker) { try { //夿æé if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 3, false, HMaker)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¨æ²¡æè¯¥æ¨¡åæé,请ä¸ç®¡çåèç³»ï¼"; objJsonResult.data = null; return objJsonResult; } ds = oCn.RunProcReturn($"exec h_p_Pay_GroupBalBill_CheckAllByTimeAndGroup " + sWhere + "", "h_p_Pay_GroupBalBill_CheckAllByTimeAndGroup"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åå¨è¿ç¨å¤æå¤±è´¥ï¼"; objJsonResult.data = null; return objJsonResult; } else { if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HBack"]) == 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å®¡æ ¸å¤±è´¥ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]); objJsonResult.data = null; return objJsonResult; } } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "æåï¼"; objJsonResult.data = ds.Tables[0].Rows[0]["HRemark"]; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¥è¯¢å表信æ¯å¤±è´¥ï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region å·¥èµç»ç®åï¼éä½ï¼ å ³é/åå ³é /// <summary> WebAPI/Controllers/¹¤×ʹÜÀí/Pay_SingleBalBillController.cs
@@ -954,7 +954,63 @@ } #endregion #region å·¥èµç»ç®åæ¹éå®¡æ ¸äºç /// <summary> /// å·¥èµç»ç®åæ¹éå®¡æ ¸äºç /// </summary> /// <returns></returns> [Route("Pay_SingleBalBillController/CheckAllByTimeAndGroup")] [HttpGet] public object CheckAllByTimeAndGroup(string sWhere, string HMaker) { try { //夿æé if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 3, false, HMaker)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¨æ²¡æè¯¥æ¨¡åæé,请ä¸ç®¡çåèç³»ï¼"; objJsonResult.data = null; return objJsonResult; } ds = oCn.RunProcReturn($"exec h_p_Pay_SingleBalBill_CheckAllByTimeAndGroup " + sWhere + "", "h_p_Pay_SingleBalBill_CheckAllByTimeAndGroup"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åå¨è¿ç¨å¤æå¤±è´¥ï¼"; objJsonResult.data = null; return objJsonResult; } else { if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HBack"]) == 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å®¡æ ¸å¤±è´¥ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]); objJsonResult.data = null; return objJsonResult; } } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "æåï¼"; objJsonResult.data = ds.Tables[0].Rows[0]["HRemark"]; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¥è¯¢å表信æ¯å¤±è´¥ï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion WebAPI/Controllers/ÌõÂë¹ÜÀí/WEBSController.cs
@@ -16,6 +16,7 @@ using WebAPI; using WebAPI.Models; using WebAPI.Service; using WebAPI.Utility; namespace WebAPI.Controllers { @@ -4294,6 +4295,239 @@ sJXCode = POStockInBillController.JX_Json(sBarCode, HInterID, HBillType, HStockOrgID, HBillNo, HMaker); SourceFlag = true; } else if(oSystemParameter.omodel.WMS_CampanyName == "添康" && HSourceBillType == "1241") { DataSet ds; string sql = "select HBarCode,HSourceInterID,HSourceEntryID,HSourceBillNo from Gy_BarCodeBill with(nolock) where HBarCode = '" + sBarCode + "'"; string HDataBaseName = Util.GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "/Config/kdapi.config", "DataBaseName");//è·åéè¶æ°æ®åºåç§° string HSourceBillNo_TB = ""; Int64 HSourceInterID = 0; ds = oCn.RunProcReturn(sql, "Gy_BarCodeBill"); //夿æ¡ç ä¿¡æ¯æ¯å¦å¨æ¡ç æ¡£æ¡ä¸ if (ds == null || ds.Tables[0].Rows.Count < 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¡ç æ¡£æ¡ä¸ä¸å卿¤æ¡ç ç¼å·ï¼" + sBarCode; objJsonResult.data = null; return objJsonResult; } else { //è·åå ¥åºç³è¯·ååå·/主ID HSourceBillNo_TB = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HSourceBillNo"]); HSourceInterID = DBUtility.ClsPub.isInt(ds.Tables[0].Rows[0]["HSourceInterID"]); //æ ¹æ®å ¥åºç³è¯·ååå·å¤æåæ®ä¿¡æ¯æ¯å¦å·²ç»åæ¥å°éè¶ sql = string.Format(@"select * from FROM {0}..TFKO_t_Cust100009 with(nolock) where FBILLNO = '" + HSourceBillNo_TB + "'", HDataBaseName); LogService.Write("å ¶ä»å ¥åºæ¥è¯¢å ¥åºç³è¯·åæ¯å¦åå¨ï¼" + sql); ds = oCn.RunProcReturn(sql, "TFKO_t_Cust100009"); //å ¥åºç³è¯·å没æåæ¥å°éè¶åè¿è¡åæ¥ if (ds == null || ds.Tables[0].Rows.Count < 1) { sql = "exec h_p_Kf_StockInRequestBillToErp '" + HSourceInterID + "','" + HSourceBillNo_TB + "'"; ds = oCn.RunProcReturn(sql, "h_p_Kf_StockInRequestBillToErp"); if (ds == null || ds.Tables[0].Rows.Count == 0) { oCn.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "webapiå ¥åºç³è¯·å忥ï¼è·åä¿¡æ¯å¤±è´¥"; objJsonResult.data = null; return objJsonResult; } else { JObject model = new JObject(); //model.Add("FBillType", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["FBillType"]) }); //åæ®ç±»å model.Add("FDate", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æ¥æ"])); //åæ®æ¥æ model.Add("FStockOrgId", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["åºåç»ç»ä»£ç "]) }); //åºåç»ç»ä»£ç model.Add("FBillNo", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["åæ®å·"])); //åæ®å· model.Add("FStockDirect", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["åºåæ¹å"])); //åºåæ¹å model.Add("FDEPTID", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["é¨é¨ä»£ç "]) }); //çäº§è½¦é´ model.Add("F_paez_Text", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["å ¥åºç å"])); //å ¥åºç å model.Add("F_paez_Integer2", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["çåæ°"])); //çåæ° model.Add("F_paez_Integer1", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["çç®¡åªæ°"])); //çç®¡åªæ° model.Add("F_paez_Integer3", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["å®é¿"])); //å®é¿ //model.Add("F_paez_BaseProperty4", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["çé"])); //çé model.Add("F_paez_Base", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["å·¥å·"])); //å·¥å· model.Add("F_paez_Combo", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["çæ¬¡ä»£ç "])); //çæ¬¡ //model.Add("F_paez_BaseProperty1", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æ¹å·"])); //æ¹å· model.Add("F_paez_Integer", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ç®±æ°"])); //ç®±æ° model.Add("F_paez_Decimal2", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æ»é"])); //æ»é //model.Add("F_paez_BaseProperty2", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æåç¼ç "])); //æåç¼ç //model.Add("F_paez_BaseProperty5", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["åå"])); //åå model.Add("F_paez_Base1", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["线å·"])); //çº¿å· //model.Add("F_paez_BaseProperty", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æºå°"])); //æºå° model.Add("F_paez_Decimal", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ç®±é"])); //ç®±é //model.Add("F_WJUK_Text", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æ¥æº"])); //æ¥æº model.Add("FDEPTID1", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["é¨é¨ä»£ç "]) });//é¨é¨ //model.Add("F_paez_BaseProperty6", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æ»å"])); //æ»å //model.Add("F_paez_BaseProperty7", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["管è²"])); //ç®¡è² model.Add("F_paez_Assistant", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ç级"])); //ç级 model.Add("F_paez_Text11", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æå°ç®±å·"])); //æå°ç®±å· //model.Add("F_paez_Text3", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ææ¬"])); //ææ¬ model.Add("F_paez_Text4", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æå¤§ç®±å·"])); //æå¤§ç®±å· //model.Add("F_paez_PrintTimes", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æå°æ¬¡æ°"])); //æå°æ¬¡æ° //model.Add("F_paez_Text5", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["线å·"])); //æ¡ç æå° //model.Add("F_paez_BaseProperty10", new JObject() { ["FNumber"] = Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["é¨é¨ä»£ç "]) }); //ç产é¨é¨ model.Add("F_paez_Combo1", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["æ¯å¦å å¤è´¸"])); //æ¯å¦å å¤è´¸ model.Add("F_paez_Combo2", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["产åç±»å"])); //产åç±»å model.Add("F_paez_Combo3", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["满çç¶æ"])); //满çç¶æ //model.Add("F_paez_BaseProperty11", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["è§æ ¼åå·"])); //è§æ ¼åå· //model.Add("F_paez_BaseProperty12", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ç½å«"])); //ç½å« //model.Add("F_TFKO_Text4", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ç®±å·åç¼"])); //ç®±å·åç¼ model.Add("F_paez_WB", Pub_Class.ClsPub.isStrNull(ds.Tables[0].Rows[0]["ç½å«"])); //ç½å«1 JArray Fentity = new JArray(); foreach (DataRow item in ds.Tables[0].Rows) { JObject FentityModel = new JObject(); FentityModel.Add("FMATERIALID", new JObject() { ["FNumber"] = item["ç©æä»£ç "].ToString() }); // ç©æä»£ç FentityModel.Add("FUnitID", new JObject() { ["FNumber"] = item["计éåä½ä»£ç "].ToString() }); // åä½ä»£ç FentityModel.Add("FQty", item["åé"].ToString()); //åé FentityModel.Add("FBASEUNITID", new JObject() { ["FNumber"] = item["åºæ¬è®¡éåä½ä»£ç "].ToString() }); // åºæ¬åä½ä»£ç FentityModel.Add("FBASEQTY", item["宿¶æ°é"].ToString()); //宿¶æ°é FentityModel.Add("FSecUNITID", new JObject() { ["FNumber"] = item["åºåè¾ è®¡éåä½ä»£ç "].ToString() }); // åºåè¾ è®¡éåä½ä»£ç FentityModel.Add("FSecQTY", item["åºåè¾ åä½å®æ¶æ°é"].ToString()); //宿¶æ°éï¼åºåè¾ åä½ï¼ FentityModel.Add("FOWNERTYPEID", item["货主类å"].ToString()); //货主类å FentityModel.Add("FOWNERID", new JObject() { ["FNumber"] = item["货主代ç "].ToString() }); // 货主代ç FentityModel.Add("FKEEPERTYPEID", item["ä¿ç®¡è ç±»å"].ToString()); //ä¿ç®¡è ç±»å FentityModel.Add("FKEEPERID", new JObject() { ["FNumber"] = item["ä¿ç®¡è 代ç "].ToString() }); // ä¿ç®¡è 代ç FentityModel.Add("FAuxPropId", new JObject() { ["FAUXPROPID__FF100003"] = new JObject() { ["FNumber"] = item["è¾ å©å±æ§ä»£ç "].ToString() } }); // è¾ å©å±æ§ FentityModel.Add("FExtAuxUnitId", new JObject() { ["FNumber"] = item["è¾ è®¡éåä½ä»£ç "].ToString() }); // è¾ è®¡éåä½ä»£ç FentityModel.Add("FExtAuxUnitQty", item["ç®±æ°"].ToString()); //ç®±æ° FentityModel.Add("F_TFKO_Assistant", new JObject() { ["FNumber"] = item["ç½å«ä»£ç "].ToString() }); // ç½å« FentityModel.Add("F_TFKO_Assistant1", new JObject() { ["FNumber"] = item["åå代ç "].ToString() }); // åå FentityModel.Add("F_TFKO_Assistant2", new JObject() { ["FNumber"] = item["è²æ³½ä»£ç "].ToString() }); // è²æ³½ FentityModel.Add("F_TFKO_Assistant3", new JObject() { ["FNumber"] = item["纤度代ç "].ToString() }); // 纤度 FentityModel.Add("F_paez_Qty", item["æ¯é"].ToString()); //æ¯é FentityModel.Add("F_TFKO_Text1", item["管è²"].ToString()); //ç®¡è² FentityModel.Add("F_TFKO_Text2", item["æ»å"].ToString()); //æ»å FentityModel.Add("FBoxcode", item["ç®±å·"].ToString()); //ç®±å· FentityModel.Add("F_PAEZ_SQSL", item["ç³è¯·åæ°é"].ToString()); //ç³è¯·åæ°é FentityModel.Add("F_paez_Integer4", item["çåæ°"].ToString()); //çåæ° FentityModel.Add("F_paez_BaseQty", item["å®åæ°é"].ToString()); //å®åæ°é FentityModel.Add("F_paez_Qty1", item["宿¶æ°é"].ToString()); //宿¶æ°é FentityModel.Add("F_paez_Text2", item["ç®±å·"].ToString()); //ç®±å· //JArray Fentity2 = new JArray(); //JObject FentityModel2 = new JObject(); //FentityModel2.Add("FEntity_Link_FFlowId", item["FEntity_Link_FFlowId"].ToString()); //FentityModel2.Add("FEntity_Link_FFlowLineId", item["FEntity_Link_FFlowLineId"].ToString()); //FentityModel2.Add("FEntity_Link_FRuleId", item["FEntity_Link_FRuleId"].ToString()); //FentityModel2.Add("FEntity_Link_FSTableName", item["FEntity_Link_FSTableName"].ToString()); //FentityModel2.Add("FEntity_Link_FSBillId", item["FEntity_Link_FSBillId"].ToString()); //FentityModel2.Add("FEntity_Link_FSId", item["FEntity_Link_FSId"].ToString()); //Fentity2.Add(FentityModel2); //FentityModel.Add("FEntity_Link", Fentity2); //FentityModel.Add("FBFLowId", new JObject() { ["FID"] = item["FBFLOWID"].ToString() }); Fentity.Add(FentityModel); } model.Add("FEntity", Fentity); //æç»ä¿¡æ¯ JObject jsonRoot = new JObject() { ["Creator"] = "", ["NeedUpDateFields"] = new JArray(), ["NeedReturnFields"] = new JArray(), //["IsDeleteEntry"] = "true", //["SubSystemId"] = "", //["IsVerifyBaseDataField"] = "false", ["IsDeleteEntry"] = "true", ["SubSystemId"] = "", ["IsVerifyBaseDataField"] = "true", ["IsEntryBatchFill"] = "false", ["ValidateFlag"] = "true", ["NumberSearch"] = "true", ["IsAutoAdjustField"] = "false", ["InterationFlags"] = "", ["IgnoreInterationFlag"] = "", //["IsAutoSubmitAndAudit"] = true,//èªå¨è°ç¨æäº¤åå®¡æ ¸åè½ ["Model"] = model }; //ä»é ç½®æä»¶è·å CLOUDç½åãè´¦å¥ä¿¡æ¯ãç»å½ç¨æ·ãç»å½å¯ç if (!Pub_Class.ClsPub.GetCLOUDLoginInfo(ref Pub_Class.ClsPub.sExeReturnInfo)) { oCn.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å ¥åºç³è¯·å忥è·åç»å½è´¦å·å¯ç 失败ï¼"; objJsonResult.data = null; return objJsonResult; } var loginRet = InvokeHelper.Login(); var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>(); if (isSuccess == 0) { oCn.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ç»å½éè¶å¤±è´¥ï¼"; objJsonResult.data = null; return objJsonResult; } else { string result = InvokeHelper.Save("k18d2ab4f14034c569576ec8e0835a80c", JsonConvert.SerializeObject(jsonRoot));//ä¿å if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") { LogService.Write(JsonConvert.SerializeObject(jsonRoot)); oCn.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å ¥åºç³è¯·å忥éè¶äºå¤±è´¥ï¼åå·:" + HSourceBillNo_TB + result + jsonRoot; objJsonResult.data = null; return objJsonResult; } //æäº¤å®¡æ ¸ string result1 = string.Empty; string result2 = string.Empty; var fID = JObject.Parse(result)["Result"]["Id"].ToString(); var fBillNo = JObject.Parse(result)["Result"]["Number"].ToString(); var json = new { Ids = fID, }; if (oSystemParameter.omodel.Kf_StockInRequestBill_AutoCheck == "Y") //ç³»ç»åæ° èªå¨å®¡æ ¸ { result1 = InvokeHelper.Submit("k18d2ab4f14034c569576ec8e0835a80c", JsonConvert.SerializeObject(json));//æäº¤ result2 = InvokeHelper.Audit("k18d2ab4f14034c569576ec8e0835a80c", JsonConvert.SerializeObject(json));//å®¡æ ¸ if (JObject.Parse(result1)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") { oCn.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å ¥åºç³è¯·ååå·:" + ",æäº¤å¤±è´¥" + result1; objJsonResult.data = null; return objJsonResult; } if (JObject.Parse(result2)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") { oCn.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å ¥åºç³è¯·ååå·:" + ",å®¡æ ¸å¤±è´¥" + result2; objJsonResult.data = null; return objJsonResult; } } } } } } } else { sJXCode = sBarCode; WebAPI/Properties/PublishProfiles/FolderProfilewtt.pubxml.user
@@ -4,7 +4,7 @@ --> <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <PropertyGroup> <History>True|2024-11-05T07:54:24.8374699Z;False|2024-11-05T15:53:24.4214141+08:00;True|2024-10-25T16:51:46.3066612+08:00;True|2024-10-25T12:16:27.8737941+08:00;True|2024-10-25T10:12:38.8056269+08:00;False|2024-10-25T10:11:44.1117608+08:00;True|2024-10-25T09:54:06.8572059+08:00;True|2024-10-25T08:21:42.6333993+08:00;True|2024-10-24T17:56:19.5319332+08:00;True|2024-10-24T17:50:10.0801119+08:00;False|2024-10-24T17:49:21.0726954+08:00;True|2024-10-24T17:40:46.0577697+08:00;False|2024-10-24T17:39:53.3743103+08:00;True|2024-10-24T14:57:00.6752320+08:00;True|2024-10-24T10:08:39.8269595+08:00;False|2024-10-24T10:07:47.3834032+08:00;True|2024-10-22T10:33:10.1961964+08:00;True|2024-10-21T08:43:54.1422810+08:00;False|2024-10-21T08:43:00.6574201+08:00;True|2024-10-18T14:56:55.6749850+08:00;True|2024-10-18T14:47:05.1073813+08:00;True|2024-10-18T11:24:23.9069952+08:00;True|2024-10-18T11:14:57.8486575+08:00;False|2024-10-18T11:14:07.5289704+08:00;True|2024-10-18T10:57:00.2425175+08:00;False|2024-10-18T10:56:04.8949960+08:00;True|2024-10-15T16:44:32.6189434+08:00;True|2024-10-15T14:38:49.8658311+08:00;True|2024-10-15T09:49:55.2197004+08:00;False|2024-10-15T09:49:14.8790668+08:00;False|2024-10-12T15:28:24.1303695+08:00;True|2024-10-10T10:59:36.7878419+08:00;False|2024-10-10T10:58:40.9900315+08:00;True|2024-10-03T10:57:02.9299524+08:00;True|2024-10-03T10:02:10.1156720+08:00;True|2024-09-30T11:07:22.5376794+08:00;True|2024-09-30T10:15:40.3990343+08:00;True|2024-09-30T10:04:38.1942221+08:00;True|2024-09-29T19:22:01.5340857+08:00;False|2024-09-29T19:21:12.2387012+08:00;True|2024-09-26T09:50:22.2637977+08:00;True|2024-09-25T20:44:33.3994634+08:00;True|2024-09-25T16:07:23.2747063+08:00;True|2024-09-25T14:55:37.9194143+08:00;True|2024-09-24T20:03:43.9841995+08:00;True|2024-09-24T19:42:48.7479102+08:00;True|2024-09-24T19:38:31.5777012+08:00;True|2024-09-24T16:26:58.5969765+08:00;True|2024-09-24T15:31:00.7140362+08:00;True|2024-09-24T10:17:46.7830753+08:00;True|2024-09-24T09:40:19.5788062+08:00;False|2024-09-24T09:39:27.4521802+08:00;True|2024-09-23T19:35:55.3572583+08:00;True|2024-09-23T18:53:15.4480118+08:00;False|2024-09-23T18:52:22.0135173+08:00;True|2024-09-20T09:59:12.9943442+08:00;False|2024-09-20T09:58:18.6945854+08:00;True|2024-09-12T20:40:58.7161451+08:00;False|2024-09-12T20:40:00.0672966+08:00;True|2024-09-12T16:47:22.7671323+08:00;True|2024-09-12T16:34:18.5850144+08:00;True|2024-09-12T16:13:32.1929032+08:00;True|2024-09-12T09:12:54.4456999+08:00;False|2024-09-12T09:12:06.1002866+08:00;False|2024-09-11T21:06:15.4423786+08:00;True|2024-09-10T15:26:48.7055081+08:00;True|2024-09-10T09:26:36.8509916+08:00;True|2024-09-09T19:51:32.6059511+08:00;True|2024-09-09T19:05:47.5349922+08:00;True|2024-09-09T09:26:23.2022383+08:00;False|2024-09-09T09:25:27.3736749+08:00;True|2024-09-06T15:32:52.1865278+08:00;True|2024-09-06T15:16:01.1405794+08:00;True|2024-09-06T14:21:05.7482343+08:00;True|2024-09-06T14:09:17.1494566+08:00;True|2024-09-06T13:49:56.4128481+08:00;True|2024-09-06T13:11:53.0863947+08:00;True|2024-09-06T09:34:54.5934463+08:00;True|2024-09-06T08:47:19.9744092+08:00;True|2024-09-05T15:01:38.6968629+08:00;True|2024-09-05T14:56:09.3505818+08:00;True|2024-09-05T14:49:56.8774757+08:00;True|2024-09-05T08:14:13.2359921+08:00;False|2024-09-05T08:13:11.8797534+08:00;True|2024-09-03T16:52:02.8227375+08:00;False|2024-09-03T16:51:32.4250926+08:00;True|2024-09-03T16:33:05.7269609+08:00;True|2024-09-03T16:00:15.0288548+08:00;True|2024-08-29T08:06:32.4732067+08:00;False|2024-08-29T08:06:02.4801886+08:00;True|2024-08-26T10:17:08.7733750+08:00;False|2024-08-26T10:11:05.1864217+08:00;False|2024-08-26T09:50:31.1539306+08:00;False|2024-08-26T09:47:37.4351309+08:00;True|2024-08-16T16:55:32.0918962+08:00;True|2024-08-16T16:53:23.3505641+08:00;False|2024-08-16T16:49:30.4579212+08:00;False|2024-08-16T16:47:01.9799743+08:00;</History> <History>True|2024-11-06T06:13:46.3129972Z;False|2024-11-06T14:12:47.9022879+08:00;False|2024-11-05T20:45:28.3960353+08:00;True|2024-11-05T19:04:11.0417788+08:00;False|2024-11-05T19:03:03.9263878+08:00;True|2024-11-05T15:54:24.8374699+08:00;False|2024-11-05T15:53:24.4214141+08:00;True|2024-10-25T16:51:46.3066612+08:00;True|2024-10-25T12:16:27.8737941+08:00;True|2024-10-25T10:12:38.8056269+08:00;False|2024-10-25T10:11:44.1117608+08:00;True|2024-10-25T09:54:06.8572059+08:00;True|2024-10-25T08:21:42.6333993+08:00;True|2024-10-24T17:56:19.5319332+08:00;True|2024-10-24T17:50:10.0801119+08:00;False|2024-10-24T17:49:21.0726954+08:00;True|2024-10-24T17:40:46.0577697+08:00;False|2024-10-24T17:39:53.3743103+08:00;True|2024-10-24T14:57:00.6752320+08:00;True|2024-10-24T10:08:39.8269595+08:00;False|2024-10-24T10:07:47.3834032+08:00;True|2024-10-22T10:33:10.1961964+08:00;True|2024-10-21T08:43:54.1422810+08:00;False|2024-10-21T08:43:00.6574201+08:00;True|2024-10-18T14:56:55.6749850+08:00;True|2024-10-18T14:47:05.1073813+08:00;True|2024-10-18T11:24:23.9069952+08:00;True|2024-10-18T11:14:57.8486575+08:00;False|2024-10-18T11:14:07.5289704+08:00;True|2024-10-18T10:57:00.2425175+08:00;False|2024-10-18T10:56:04.8949960+08:00;True|2024-10-15T16:44:32.6189434+08:00;True|2024-10-15T14:38:49.8658311+08:00;True|2024-10-15T09:49:55.2197004+08:00;False|2024-10-15T09:49:14.8790668+08:00;False|2024-10-12T15:28:24.1303695+08:00;True|2024-10-10T10:59:36.7878419+08:00;False|2024-10-10T10:58:40.9900315+08:00;True|2024-10-03T10:57:02.9299524+08:00;True|2024-10-03T10:02:10.1156720+08:00;True|2024-09-30T11:07:22.5376794+08:00;True|2024-09-30T10:15:40.3990343+08:00;True|2024-09-30T10:04:38.1942221+08:00;True|2024-09-29T19:22:01.5340857+08:00;False|2024-09-29T19:21:12.2387012+08:00;True|2024-09-26T09:50:22.2637977+08:00;True|2024-09-25T20:44:33.3994634+08:00;True|2024-09-25T16:07:23.2747063+08:00;True|2024-09-25T14:55:37.9194143+08:00;True|2024-09-24T20:03:43.9841995+08:00;True|2024-09-24T19:42:48.7479102+08:00;True|2024-09-24T19:38:31.5777012+08:00;True|2024-09-24T16:26:58.5969765+08:00;True|2024-09-24T15:31:00.7140362+08:00;True|2024-09-24T10:17:46.7830753+08:00;True|2024-09-24T09:40:19.5788062+08:00;False|2024-09-24T09:39:27.4521802+08:00;True|2024-09-23T19:35:55.3572583+08:00;True|2024-09-23T18:53:15.4480118+08:00;False|2024-09-23T18:52:22.0135173+08:00;True|2024-09-20T09:59:12.9943442+08:00;False|2024-09-20T09:58:18.6945854+08:00;True|2024-09-12T20:40:58.7161451+08:00;False|2024-09-12T20:40:00.0672966+08:00;True|2024-09-12T16:47:22.7671323+08:00;True|2024-09-12T16:34:18.5850144+08:00;True|2024-09-12T16:13:32.1929032+08:00;True|2024-09-12T09:12:54.4456999+08:00;False|2024-09-12T09:12:06.1002866+08:00;False|2024-09-11T21:06:15.4423786+08:00;True|2024-09-10T15:26:48.7055081+08:00;True|2024-09-10T09:26:36.8509916+08:00;True|2024-09-09T19:51:32.6059511+08:00;True|2024-09-09T19:05:47.5349922+08:00;True|2024-09-09T09:26:23.2022383+08:00;False|2024-09-09T09:25:27.3736749+08:00;True|2024-09-06T15:32:52.1865278+08:00;True|2024-09-06T15:16:01.1405794+08:00;True|2024-09-06T14:21:05.7482343+08:00;True|2024-09-06T14:09:17.1494566+08:00;True|2024-09-06T13:49:56.4128481+08:00;True|2024-09-06T13:11:53.0863947+08:00;True|2024-09-06T09:34:54.5934463+08:00;True|2024-09-06T08:47:19.9744092+08:00;True|2024-09-05T15:01:38.6968629+08:00;True|2024-09-05T14:56:09.3505818+08:00;True|2024-09-05T14:49:56.8774757+08:00;True|2024-09-05T08:14:13.2359921+08:00;False|2024-09-05T08:13:11.8797534+08:00;True|2024-09-03T16:52:02.8227375+08:00;False|2024-09-03T16:51:32.4250926+08:00;True|2024-09-03T16:33:05.7269609+08:00;True|2024-09-03T16:00:15.0288548+08:00;True|2024-08-29T08:06:32.4732067+08:00;False|2024-08-29T08:06:02.4801886+08:00;True|2024-08-26T10:17:08.7733750+08:00;False|2024-08-26T10:11:05.1864217+08:00;False|2024-08-26T09:50:31.1539306+08:00;False|2024-08-26T09:47:37.4351309+08:00;True|2024-08-16T16:55:32.0918962+08:00;True|2024-08-16T16:53:23.3505641+08:00;False|2024-08-16T16:49:30.4579212+08:00;False|2024-08-16T16:47:01.9799743+08:00;</History> <_PublishTargetUrl>G:\issWeb\ç½ç«åå¸\API</_PublishTargetUrl> </PropertyGroup> <ItemGroup> @@ -45,28 +45,28 @@ <publishTime>02/22/2013 16:43:40</publishTime> </File> <File Include="bin/BLL.dll"> <publishTime>11/05/2024 15:53:47</publishTime> <publishTime>11/06/2024 15:05:51</publishTime> </File> <File Include="bin/BLL.pdb"> <publishTime>11/05/2024 15:53:47</publishTime> <publishTime>11/06/2024 15:05:51</publishTime> </File> <File Include="bin/BouncyCastle.Crypto.dll"> <publishTime>12/18/2020 05:32:28</publishTime> </File> <File Include="bin/DAL.dll"> <publishTime>11/05/2024 15:53:44</publishTime> <publishTime>11/06/2024 15:05:49</publishTime> </File> <File Include="bin/DAL.pdb"> <publishTime>11/05/2024 15:53:44</publishTime> <publishTime>11/06/2024 15:05:49</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 22:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> <publishTime>10/31/2024 10:55:03</publishTime> <publishTime>11/05/2024 19:03:14</publishTime> </File> <File Include="bin/DBUtility.pdb"> <publishTime>10/31/2024 10:55:03</publishTime> <publishTime>11/05/2024 19:03:14</publishTime> </File> <File Include="bin/Grpc.Core.Api.dll"> <publishTime>03/22/2022 13:17:26</publishTime> @@ -111,10 +111,10 @@ <publishTime>07/25/2012 19:48:56</publishTime> </File> <File Include="bin/Model.dll"> <publishTime>11/05/2024 15:53:37</publishTime> <publishTime>11/06/2024 14:13:05</publishTime> </File> <File Include="bin/Model.pdb"> <publishTime>11/05/2024 15:53:37</publishTime> <publishTime>11/06/2024 14:13:05</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> <publishTime>04/15/2024 12:55:45</publishTime> @@ -147,34 +147,34 @@ <publishTime>10/23/2021 17:07:54</publishTime> </File> <File Include="bin/Pub_Class.dll"> <publishTime>10/31/2024 10:55:00</publishTime> <publishTime>11/05/2024 19:03:11</publishTime> </File> <File Include="bin/Pub_Class.pdb"> <publishTime>10/31/2024 10:55:00</publishTime> <publishTime>11/05/2024 19:03:11</publishTime> </File> <File Include="bin/Pub_Control.dll"> <publishTime>10/31/2024 10:55:01</publishTime> <publishTime>11/05/2024 19:03:13</publishTime> </File> <File Include="bin/Pub_Control.pdb"> <publishTime>10/31/2024 10:55:01</publishTime> <publishTime>11/05/2024 19:03:13</publishTime> </File> <File Include="bin/RestSharp.dll"> <publishTime>08/31/2012 06:22:50</publishTime> </File> <File Include="bin/SQLHelper.dll"> <publishTime>10/31/2024 10:55:02</publishTime> <publishTime>11/05/2024 19:03:13</publishTime> </File> <File Include="bin/SQLHelper.pdb"> <publishTime>10/31/2024 10:55:02</publishTime> <publishTime>11/05/2024 19:03:13</publishTime> </File> <File Include="bin/Swashbuckle.Core.dll"> <publishTime>02/16/2015 01:57:08</publishTime> </File> <File Include="bin/SyntacticSugar.dll"> <publishTime>10/30/2024 16:45:07</publishTime> <publishTime>11/05/2024 17:27:43</publishTime> </File> <File Include="bin/SyntacticSugar.pdb"> <publishTime>10/30/2024 16:45:07</publishTime> <publishTime>11/05/2024 17:27:43</publishTime> </File> <File Include="bin/System.Buffers.dll"> <publishTime>07/19/2017 18:01:28</publishTime> @@ -285,19 +285,19 @@ <publishTime>05/09/2023 10:43:40</publishTime> </File> <File Include="bin/TopSdk.dll"> <publishTime>11/05/2024 15:50:29</publishTime> <publishTime>11/05/2024 17:49:50</publishTime> </File> <File Include="bin/TopSdk.pdb"> <publishTime>11/05/2024 15:50:29</publishTime> <publishTime>11/05/2024 16:13:00</publishTime> </File> <File Include="bin/WebActivatorEx.dll"> <publishTime>11/24/2014 19:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> <publishTime>11/05/2024 15:54:23</publishTime> <publishTime>11/07/2024 18:43:55</publishTime> </File> <File Include="bin/WebAPI.pdb"> <publishTime>11/05/2024 15:54:23</publishTime> <publishTime>11/07/2024 18:43:55</publishTime> </File> <File Include="bin/WebAPI.XmlSerializers.dll"> <publishTime>08/16/2024 16:55:28</publishTime>