BLL/bin/Release/BLL.dllBinary files differ
BLL/bin/Release/BLL.pdbBinary files differ
BLL/bin/Release/DAL.dllBinary files differ
BLL/bin/Release/DAL.pdbBinary files differ
BLL/bin/Release/DBUtility.dllBinary files differ
BLL/bin/Release/DBUtility.pdbBinary files differ
BLL/bin/Release/Model.dllBinary files differ
BLL/bin/Release/Model.pdbBinary files differ
BLL/bin/Release/Pub_Class.dllBinary files differ
BLL/bin/Release/Pub_Class.pdbBinary files differ
BLL/bin/Release/Pub_Control.dllBinary files differ
BLL/bin/Release/Pub_Control.pdbBinary files differ
BLL/bin/Release/SQLHelper.dllBinary files differ
BLL/bin/Release/SQLHelper.pdbBinary files differ
DAL/ClsWL_YayBillMain.cs
@@ -77,7 +77,7 @@ //========================================================= //æ´æ°ä¸»è¡¨ oCn.RunProc("UpDate WL_YayBillMain set " + string sqlMain = "UpDate WL_YayBillMain set " + " HBillNo='" + omodel.HBillNo + "'" + //åºå®èµå¼=============== ",HDate='" + omodel.HDate + "'" + ",HYear='" + omodel.HYear.ToString() + "'" + @@ -86,7 +86,7 @@ ",HUpDater='" + DBUtility.ClsPub.CurUserName + "'" + ",HUpDateDate=getdate()" + //======================================== ",HChecker='" + omodel.HChecker.ToString()+ "'" + ",HChecker='" + omodel.HChecker.ToString() + "'" + ",HMainSourceBillType='" + omodel.HMainSourceBillType + "'" + ",HMainSourceBillNo='" + omodel.HMainSourceBillNo + "'" + ",HMainSourceInterID='" + omodel.HMainSourceInterID.ToString() + "'" + @@ -111,25 +111,9 @@ ",HMoney='" + omodel.HMoney.ToString() + "'" + ",HDateForRequestedPick='" + omodel.HDateForRequestedPick.ToString() + "'" + ",HDataForRequestedArrived='" + omodel.HDataForRequestedArrived.ToString() + "'" + ",HCarryStatus='" + omodel.HCarryStatus.ToString() + "'" + ",HDate_CarrierSure='" + omodel.HDate_CarrierSure.ToString() + "'" + ",HDate_AllocationDriver='" + omodel.HDate_AllocationDriver.ToString() + "'" + ",HCarID='" + omodel.HCarID.ToString() + "'" + ",HDriverID='" + omodel.HDriverID.ToString() + "'" + ",HSurer_Arrive='" + omodel.HSurer_Arrive.ToString() + "'" + ",HDate_Arrive='" + omodel.HDate_Arrive.ToString() + "'" + ",HSurer_Pick='" + omodel.HSurer_Pick.ToString() + "'" + ",HDate_Pick='" + omodel.HDate_Pick.ToString() + "'" + ",HSurer_Trans='" + omodel.HSurer_Trans.ToString() + "'" + ",HDate_Trans='" + omodel.HDate_Trans.ToString() + "'" + ",HSurer_Receive='" + omodel.HSurer_Receive.ToString() + "'" + ",HExRate='" + omodel.HExRate.ToString() + "'" + ",HDate_Receive='" + omodel.HDate_Receive.ToString() + "'" + ",HSurer_Accounting='" + omodel.HSurer_Accounting.ToString() + "'" + ",HDate_Accounting='" + omodel.HDate_Accounting.ToString() + "'" + " where HInterID=" + lngBillKey.ToString()); " where HInterID=" + lngBillKey.ToString(); oCn.RunProc(sqlMain); //å é¤å ³è DeleteRelation(ref sReturn, lngBillKey); oCn.RunProc("delete from WL_YayBillSub_Material where HInterID=" + lngBillKey); @@ -142,7 +126,7 @@ "(HInterID,HBillNo_bak,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + ",HMaterID,HUnitID,HMouldID,HMouldLength,HMouldHeight,HMouldWidth" + ",HMouldFoldHeight,HVolume,HQty,HSNP,HScatteredVolume,HMouldQtym,HCusID,HPickAddr,HArriverAddr) values(" ",HMouldFoldHeight,HVolume,HQty,HSNP,HScatteredVolume,HMouldQty,HCusID,HPickAddr,HArriverAddr) values(" + SafeInt(omodel.HInterID.ToString(), 0) + ",'" // HInterID int + SafeString(omodel.HBillNo.ToString()) + "'," // HBillNo_bak varchar(50) + (oSub.HEntryID) + ",'" // HEntryID int @@ -166,7 +150,7 @@ + (oSub.HVolume.ToString() == "" ? 0 : oSub.HVolume) + "," // HVolume dec(18,8) + (oSub.HQty.ToString() == "" ? 0 : oSub.HQty) + "," // HQty dec(18,8) + (oSub.HSNP.ToString() == "" ? 0 : oSub.HSNP) + "," // HSNP dec(18,8) + (oSub.HScatteredVolume) + "," // HSNP dec(18,8) + "'" + (oSub.HScatteredVolume ?? "0") + "'," + (oSub.HMouldQty.ToString() == "" ? 0 : oSub.HMouldQty) + "," + (oSub.HCusID) + "," // HSNP dec(18,8) + "'" + SafeString(oSub.HPickAddr?.ToString(), "") + "'," DAL/bin/Release/DAL.dllBinary files differ
DAL/bin/Release/DAL.pdbBinary files differ
DAL/bin/Release/DBUtility.dllBinary files differ
DAL/bin/Release/DBUtility.pdbBinary files differ
DAL/bin/Release/Model.dllBinary files differ
DAL/bin/Release/Model.pdbBinary files differ
DAL/bin/Release/Pub_Class.dllBinary files differ
DAL/bin/Release/Pub_Class.pdbBinary files differ
DAL/bin/Release/Pub_Control.dllBinary files differ
DAL/bin/Release/Pub_Control.pdbBinary files differ
DAL/bin/Release/SQLHelper.dllBinary files differ
DAL/bin/Release/SQLHelper.pdbBinary files differ
DAL/²Ö¿â¹ÜÀí/ClsKf_POStockInBill1.cs
New file @@ -0,0 +1,1051 @@ using System; using System.Collections.Generic; using System.Text; using System.Data; namespace DAL { public class ClsKf_POStockInBill1 : DBUtility.ClsXt_BaseBill { public Model.ClsKf_SellOutBillMain omodel = new Model.ClsKf_SellOutBillMain(); public List<Model.ClsKf_SellOutBillSub> DetailColl = new List<Model.ClsKf_SellOutBillSub>(); public List<Model.ClsKf_SellOutBillScheme> DetailSubColl = new List<Model.ClsKf_SellOutBillScheme>(); public ClsKf_POStockInBill1() { base.MvarItemKeySub = "Kf_ICStockBillSub"; base.MvarItemKeySub2 = ""; base.MvarItemKeySub3 = ""; base.MvarItemKeySub4 = ""; base.MvarItemKey = "Kf_ICStockBillMain"; base.MvarReportTitle = "éè´å ¥åºåºå"; base.BillType = "1201"; base.HBillSubType = "1201"; } #region åºå®ä»£ç ~ClsKf_POStockInBill1() { DetailColl = null; } #endregion èªå®ä¹æ¹æ³ //å é¤å ³è public override void DeleteRelation(ref string sReturn, Int64 lngBillKey) { //æ¶æéç¥å éæéç¥å å ³èæ°é try { if (omodel.HMainSourceBillType == "åè´§éç¥å") { oCn.RunProc("exec h_p_Xs_UpDateSeOutStockRelation_Del " + lngBillKey.ToString()); } else if (omodel.HMainSourceBillType == "éè´§éç¥å") { oCn.RunProc("exec h_p_Xs_UpDateSeOutStockRelation_Back_Del " + lngBillKey.ToString()); } else if (DetailColl[0].HSourceBillType == "1401") //éå®è®¢å { oCn.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToSellOut_Delete " + lngBillKey.ToString()); } else if (DetailColl[0].HSourceBillType == "1402") //åè´§éç¥å { oCn.RunProc("exec h_p_Xs_UpDateRelation_SeOutStockToPOStockIn_Delete " + lngBillKey.ToString()); } else { } } catch (Exception e) { throw (e); } } //æ°å¢å ³è public override void AddNewRelation(ref string sReturn, Int64 lngBillKey) { //æ¶æéç¥å éæéç¥å å ³èæ°é try { if (omodel.HMainSourceBillType == "åè´§éç¥å") { oCn.RunProc("exec h_p_Xs_UpDateSeOutStockRelation_Add " + lngBillKey.ToString()); } else if (omodel.HMainSourceBillType == "éè´§éç¥å") { oCn.RunProc("exec h_p_Xs_UpDateSeOutStockRelation_Back_Add " + lngBillKey.ToString()); } else if (DetailColl[0].HSourceBillType == "1401") //éå®è®¢å { oCn.RunProc("exec h_p_Xs_UpDateRelation_SeOrderToSellOut_Add " + lngBillKey.ToString()); } else if (DetailColl[0].HSourceBillType == "1402") //åè´§éç¥å { oCn.RunProc("exec h_p_Xs_UpDateRelation_SeOutStockToPOStockIn_Add " + lngBillKey.ToString()); } else { } } catch (Exception e) { throw (e); } } //ä¿®æ¹åæ® public override bool ModifyBill(Int64 lngBillKey, ref string sReturn) { try { //ä¿ååæ§å¶========================================= string HBillNote = ""; DataSet ds = oCn.RunProcReturn("Exec h_p_Kf_SellOutBill_BeforeSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "','" + HBillNote + "',1 ", "h_p_Kf_SellOutBill_BeforeSaveCtrl"); if (ds == null) { sReturn = "ä¿ååå¤æå¤±è´¥ï¼"; return false; } if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0") { sReturn = "ä¿å失败ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]); return false; } //========================================================= // oCn.BeginTran(); //string mainSql = "UpDate Kf_ICStockBillMain set " + //" HBillNo='" + omodel.HBillNo + "'" + //åºå®èµå¼=============== //",HDate='" + omodel.HDate + "'" + //",HYear='" + omodel.HYear.ToString() + "'" + //",HPeriod='" + omodel.HPeriod.ToString() + "'" + //",HRemark='" + omodel.HRemark + "'" + //",HUpDater='" + DBUtility.ClsPub.CurUserName + "'" + //",HUpDateDate=getdate()" + ////======================================== //",HOrgID=" + omodel.HOrgID + //",HStockORGID=" + omodel.HOrgID + //",HEmpID=" + omodel.HEmpID.ToString() + //",HSupID=" + omodel.HSupID.ToString() + //",HWHID=" + omodel.HWHID.ToString() + //",HSellSID=" + omodel.HSellSID.ToString() + //",HDeptID=" + omodel.HDeptID.ToString() + //",HSecManagerID=" + omodel.HSecManagerID.ToString() + //",HKeeperID=" + omodel.HKeeperID.ToString() + //",HManagerID=" + omodel.HManagerID.ToString() + //",HCheckStatusMan='" + omodel.HCheckStatusMan.ToString() + "'" + //",HConveyCompID=" + omodel.HConveyCompID.ToString() + //",HConveyTypeID=" + omodel.HConveyTypeID.ToString() + //",HCarriage=" + omodel.HCarriage.ToString() + //",HExplanation='" + omodel.HExplanation + "'" + //",HSeOrderBillNo='" + omodel.HSeOrderBillNo + "'" + //",HCurID=" + omodel.HCurID.ToString() + //",HSCWHID=" + omodel.HSCWHID.ToString() + //",HInnerBillNo='" + omodel.HInnerBillNo + "'" + //",HLinkPhone='" + omodel.HLinkPhone + "'" + //",HLinkMan='" + omodel.HLinkMan + "'" + //",HConveyMoney=" + omodel.HConveyMoney.ToString() + //",HRedBlueFlag=" + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) + //" where HInterID=" + lngBillKey.ToString(); string mainSql = "update Kf_ICStockBillMain set " + "HDate = '" + omodel.HDate + "'" + ",HYear = " + omodel.HDate.Year + "" + ",HPeriod = " + omodel.HDate.Month + "" + ",HRemark = '" + omodel.HRemark + "'" + ",HUpDater = '" + omodel.HUpDater + "'" + ",HUpDateDate = " + "getdate()" + "" + ",HSTOCKORGID = " + omodel.HOrgID + "" + ",HOWNERID = " + omodel.HOrgID + "" + ",HOrgID = " + omodel.HOrgID + "" + ",HBillNo='" + omodel.HBillNo + "'" + ",HMainSourceInterID = " + omodel.HMainSourceInterID + "" + ",HMainSourceEntryID = " + omodel.HMainSourceEntryID + "" + ",HMainSourceBillNo = '" + omodel.HMainSourceBillNo + "'" + ",HMainSourceBillType = '" + omodel.HMainSourceBillType + "'" + ",HDeptID = " + omodel.HDeptID + "" + ",HManagerID = " + omodel.HManagerID + "" + ",HEmpID = " + omodel.HEmpID + "" + ",HSupID = " + omodel.HSupID + "" + ",HSecManagerID = " + omodel.HSecManagerID + "" + ",HKeeperID = " + omodel.HKeeperID + "" + ",HWHID = " + omodel.HWHID + "" + ",HSCWHID = " + omodel.HSCWHID + "" + ",HCurID = " + omodel.HCurID + "" + ",HExRate = " + omodel.HExRate + "" + ",HSellSID = " + omodel.HSellSID + "" + ",HLinkMan = '" + omodel.HLinkMan + "'" + ",HLinkPhone = '" + omodel.HLinkPhone + "'" + ",HSeOrderBillNo = '" + omodel.HSeOrderBillNo + "'" + ",HConVeyCompID = " + omodel.HConveyCompID + "" + ",HConveyTypeID = " + omodel.HConveyTypeID + "" + ",HConveyMoney = " + omodel.HConveyMoney + "" + ",HExplanation = '" + omodel.HExplanation + "'" + ",HInnerBillNo = '" + omodel.HInnerBillNo + "'" + ",HCarriage = " + omodel.HCarriage + "" + ",HCheckStatusMan = '" + omodel.HCheckStatusMan + "'" + ",HProjectID = '" + omodel.HProjectID.ToString() + "'" + ",HGroupID = '" + omodel.HGroupID.ToString() + "'" + ",HPriceType = '" + omodel.HPriceType + "'" + ",HInvoiceBillNo = '" + omodel.HInvoiceBillNo + "'" + " where HInterID = " + lngBillKey; //æ´æ°ä¸»è¡¨ oCn.RunProc(mainSql); //å é¤å ³è DeleteRelation(ref sReturn, lngBillKey); //å é¤å表 DeleteBillSub(lngBillKey); //æå ¥å表 omodel.HInterID = lngBillKey; int HEntryID = 1; foreach (Model.ClsKf_SellOutBillSub oSub in DetailColl) { string subSql = "Insert into Kf_ICStockBillSub" + " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + ",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo" + ",HMaterID,HUnitID,HQtyMust,HQty,HPieceQty,HPrice,HMoney,HTaxPrice,HTaxRate,HTaxMoney,HWHID" + ",HSPID,HSCWHID,HSCSPID,HSPGroupID,HBatchNo,HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo" + ",HQty_Full,HQty_Empty,HQty_Back,HCostPrice,HCostMoney,HSalePrice" + ",HPropertyID,HSecUnitID,HSecUnitRate" + ",HEngineNum,HUnderPanNum,HLeaveFactCard,HReqBuyQty,HReqOutQty,HCurrentInventory" + ") values(" + "" + omodel.HInterID.ToString() + "" + "," + (HEntryID++) + "" + ",'" + oSub.HCloseMan + "'" + ",'" + oSub.HEntryCloseDate.ToShortDateString() + "'" + "," + Convert.ToString(oSub.HCloseType ? 1 : 0) + "" + ",'" + oSub.HRemark + "'" + "," + oSub.HSourceInterID.ToString() + "" + "," + oSub.HSourceEntryID.ToString() + "" + ",'" + oSub.HSourceBillNo + "'" + ",'" + oSub.HSourceBillType + "'" + "," + oSub.HRelationQty.ToString() + "" + "," + oSub.HRelationMoney.ToString() + "" + "," + oSub.HSeOrderInterID.ToString() + "" + "," + oSub.HSeOrderEntryID.ToString() + "" + ",'" + oSub.HSeOrderBillNo + "'" + "," + oSub.HMaterID.ToString() + "" + "," + oSub.HUnitID.ToString() + "" + "," + oSub.HQtyMust.ToString() + "" + "," + oSub.HQty.ToString() + "" + "," + oSub.HPieceQty.ToString() + "" + "," + oSub.HPrice.ToString() + "" + "," + oSub.HMoney.ToString() + "" + "," + oSub.HTaxPrice.ToString() + "" + "," + oSub.HTaxRate.ToString() + "" + "," + oSub.HTaxMoney.ToString() + "" + "," + oSub.HWHID.ToString() + "" + "," + oSub.HSPID.ToString() + "" + "," + oSub.HSCWHID.ToString() + "" + "," + oSub.HSCSPID.ToString() + "" + "," + oSub.HSPGroupID.ToString() + "" + ",'" + oSub.HBatchNo + "'" + "," + oSub.HPOOrderInterID.ToString() + "" + "," + oSub.HPOOrderEntryID.ToString() + "" + ",'" + oSub.HPOOrderBillNo + "'" + "," + oSub.HQty_Full + "" + "," + oSub.HQty_Empty + "" + "," + oSub.HQty_Back + "" + "," + oSub.HCostPrice.ToString() + "" + "," + oSub.HCostMoney.ToString() + "" + "," + oSub.HSalePrice.ToString() + "" + "," + oSub.HPropertyID.ToString() + "" + "," + oSub.HSecUnitID.ToString() + "" + "," + oSub.HSecUnitRate.ToString() + "" + ",'" + oSub.HEngineNum + "'" + ",'" + oSub.HUnderPanNum + "'" + ",'" + oSub.HLeaveFactCard + "'" + "," + oSub.HReqBuyQty + "," + oSub.HReqOutQty + "," + oSub.HCurrentInventory + ") "; oCn.RunProc(subSql); //oCn.RunProc("Insert into Kf_ICStockBillSub " + // " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" + // ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + // ",HMaterID,HPropertyID,HSecUnitID,HSecUnitRate,HUnitID,HQtyMust" + // ",HQty,HPrice,HMoney,HWHID,HSCWHID,HSPID" + // ",HCostPrice,HCostMoney,HSalePrice" + // ",HEngineNum,HUnderPanNum,HLeaveFactCard" + // ",HSCSPID,HSPGroupID,HBatchNo,HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo" + // ",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo,HQty_Full,HQty_Empty,HQty_Back" + // ") values(" // + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + // "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + // "," + oSub.HMaterID.ToString() + "," + oSub.HPropertyID.ToString() + "," + oSub.HSecUnitID.ToString() + "," + oSub.HSecUnitRate.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HQtyMust.ToString() + // "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HMoney.ToString() + "," + oSub.HWHID.ToString() + "," + oSub.HSCWHID.ToString() + "," + oSub.HSPID.ToString() + // "," + oSub.HCostPrice.ToString() + "," + oSub.HCostMoney.ToString() + "," + oSub.HSalePrice.ToString() + // ",'" + oSub.HEngineNum + "','" + oSub.HUnderPanNum + "','" + oSub.HLeaveFactCard + "'" + // "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'," + oSub.HPOOrderInterID.ToString() + "," + oSub.HPOOrderEntryID.ToString() + ",'" + oSub.HPOOrderBillNo + "'" + // "," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'," + oSub.HQty_Full + // "," + oSub.HQty_Empty + "," + oSub.HQty_Back + // ") "); } //æ´æ°è®¢åå ³èæ°é AddNewRelation(ref sReturn, omodel.HInterID); //æ§å¶å ³èæ°é //=========================ä¿ååæ§å¶ DataSet ds2 = oCn.RunProcReturn("Exec h_p_Kf_SellOutBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',1 ", "h_p_Kf_SellOutBill_AfterSaveCtrl"); if (ds2 == null) { sReturn = "ä¿ååæ§å¶å¤æå¤±è´¥ï¼"; oCn.RollBack(); return false; } if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0") { sReturn = "ä¿å失败2ï¼" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]); oCn.RollBack(); return false; } //============================ // sReturn = "ä¿®æ¹åæ®æåï¼"; oCn.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //æ°å¢åæ® public override bool AddBill(ref string sReturn) { try { //å¾å°mainid //omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); //omodel.HBillNo = DBUtility.ClsPub.CreateBillCode(BillType, ref DBUtility.ClsPub.sExeReturnInfo, true); //è¥MAINDIéå¤åéæ°è·å if (IsExistBillNo(ref DBUtility.ClsPub.sExeReturnInfo, omodel.HBillNo, Pub_Class.ClsPub.Enum_BillStatus.BillStatus_AddNew, omodel.HInterID)) { omodel.HBillNo = DBUtility.ClsPub.CreateBillCode(BillType, ref DBUtility.ClsPub.sExeReturnInfo, true); } if (IsExistMainID(ref DBUtility.ClsPub.sExeReturnInfo, omodel.HInterID, Pub_Class.ClsPub.Enum_BillStatus.BillStatus_AddNew)) { omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); } //ä¿ååæ§å¶========================================= string HBillNote = ""; DataSet ds = oCn.RunProcReturn("Exec h_p_Kf_SellOutBill_BeforeSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "','" + HBillNote + "',1 ", "h_p_Kf_SellOutBill_BeforeSaveCtrl"); if (ds == null) { sReturn = "ä¿ååå¤æå¤±è´¥ï¼"; return false; } if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0") { sReturn = "ä¿å失败ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]); return false; } //========================================================= // oCn.BeginTran(); //主表 string mainSql = "Insert Into Kf_ICStockBillMain" + "(HInterID,HBillNo,HDate,HYear,HPeriod,HBillType,HBillSubType,HRemark,HMaker,HMakeDate,HBillStatus,HSTOCKORGID,HOWNERID,HOrgID" + ",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType" + ",HDeptID,HManagerID,HEmpID,HSupID,HSecManagerID,HKeeperID,HWHID,HSCWHID,HCurID,HExRate,HSellSID,HLinkMan,HLinkPhone" + ",HSeOrderBillNo" + ",HConveyCompID,HConveyTypeID,HConveyMoney" + ",HExplanation,HInnerBillNo,HRedBlueFlag,HCarriage,HCheckStatusMan,HProjectID,HGroupID,HPriceType,HInvoiceBillNo" + ") " + "values(" + "" + omodel.HInterID.ToString() + "" + ",'" + omodel.HBillNo + "'" + ",'" + omodel.HDate + "'" + "," + omodel.HYear.ToString() + "" + "," + omodel.HPeriod.ToString() + "" + ",'" + this.BillType + "'" + ",'" + omodel.HBillSubType + "'" + ",'" + omodel.HRemark + "'" + ",'" + omodel.HMaker + "'" + "," + "getdate()" + "" + "," + "1" + "" + "," + omodel.HOrgID + "" + "," + omodel.HOrgID + "" + "," + omodel.HOrgID + "" + "," + omodel.HMainSourceInterID + "" + "," + omodel.HMainSourceEntryID + "" + ",'" + omodel.HMainSourceBillNo + "'" + ",'" + omodel.HMainSourceBillType + "'" + "," + omodel.HDeptID.ToString() + "" + "," + omodel.HManagerID.ToString() + "," + omodel.HEmpID.ToString() + "" + ", " + omodel.HSupID.ToString() + "" + "," + omodel.HSecManagerID.ToString() + "" + ", " + omodel.HKeeperID.ToString() + "" + "," + omodel.HWHID.ToString() + "" + "," + omodel.HSCWHID.ToString() + "" + "," + omodel.HCurID.ToString() + "" + "," + omodel.HExRate.ToString() + "" + "," + omodel.HSellSID.ToString() + "" + ",'" + omodel.HLinkMan + "'" + ",'" + omodel.HLinkPhone + "'" + ",'" + omodel.HSeOrderBillNo + "'" + "," + omodel.HConveyCompID.ToString() + "" + "," + omodel.HConveyTypeID.ToString() + "" + "," + omodel.HConveyMoney.ToString() + "" + ",'" + omodel.HExplanation + "'" + ",'" + omodel.HInnerBillNo + "'" + "," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) + "" + "," + omodel.HCarriage + "" + ",'" + omodel.HCheckStatusMan + "'" + ",'" + omodel.HProjectID.ToString() + "'" + ",'" + omodel.HGroupID.ToString() + "'" + ",'" + omodel.HPriceType + "'" + ",'" + omodel.HInvoiceBillNo + "'" + ") "; oCn.RunProc(mainSql); //oCn.RunProc("Insert Into Kf_ICStockBillMain " + //"(HBillType,HBillSubType,HInterID,HBillNo,HDate" + //",HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo,HMainSourceBillType" + //",HYear,HPeriod,HRemark,HMaker,HMakeDate,HOrgID,HStockORGID" + //",HSupID,HWHID,HSCWHID,HEmpID,HManagerID" + //",HSecManagerID,HSellSID,HCurID" + //",HLinkMan,HLinkPhone" + //",HSeOrderBillNo,HConveyCompID,HConveyTypeID,HConveyMoney" + //",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag,HCarriage,HCheckStatusMan" + //") " + //" values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + //"," + omodel.HMainSourceInterID + "," + omodel.HMainSourceEntryID + ",'" + omodel.HMainSourceBillNo + "','" + omodel.HMainSourceBillType + "'" + //", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HMaker + "',getdate()" + "," + omodel.HOrgID + "," + omodel.HOrgID + //", " + omodel.HSupID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HSCWHID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + //"," + omodel.HSecManagerID.ToString() + "," + omodel.HSellSID.ToString() + "," + omodel.HCurID.ToString() + //",'" + omodel.HLinkMan + "','" + omodel.HLinkPhone + "'" + //",'" + omodel.HSeOrderBillNo + "'," + omodel.HConveyCompID.ToString() + "," + omodel.HConveyTypeID.ToString() + "," + omodel.HConveyMoney.ToString() + //", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) + "," + omodel.HCarriage + ",'" + omodel.HCheckStatusMan + "'" + //") "); //æå ¥å表 int HEntryID = 1; foreach (Model.ClsKf_SellOutBillSub oSub in DetailColl) { string subSql = "Insert into Kf_ICStockBillSub" + " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" + ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + ",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo" + ",HMaterID,HUnitID,HQtyMust,HQty,HPieceQty,HPrice,HMoney,HTaxPrice,HTaxRate,HTaxMoney,HWHID" + ",HSPID,HSCWHID,HSCSPID,HSPGroupID,HBatchNo,HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo" + ",HQty_Full,HQty_Empty,HQty_Back,HCostPrice,HCostMoney,HSalePrice" + ",HPropertyID,HSecUnitID,HSecUnitRate" + ",HEngineNum,HUnderPanNum,HLeaveFactCard,HReqBuyQty,HReqOutQty,HCurrentInventory" + ") values(" + "" + omodel.HInterID.ToString() + "" + "," + (HEntryID++) + "" + ",'" + oSub.HCloseMan + "'" + ",'" + oSub.HEntryCloseDate.ToShortDateString() + "'" + "," + Convert.ToString(oSub.HCloseType ? 1 : 0) + "" + ",'" + oSub.HRemark + "'" + "," + oSub.HSourceInterID.ToString() + "" + "," + oSub.HSourceEntryID.ToString() + "" + ",'" + oSub.HSourceBillNo + "'" + ",'" + oSub.HSourceBillType + "'" + "," + oSub.HRelationQty.ToString() + "" + "," + oSub.HRelationMoney.ToString() + "" + "," + oSub.HSeOrderInterID.ToString() + "" + "," + oSub.HSeOrderEntryID.ToString() + "" + ",'" + oSub.HSeOrderBillNo + "'" + "," + oSub.HMaterID.ToString() + "" + "," + oSub.HUnitID.ToString() + "" + "," + oSub.HQtyMust.ToString() + "" + "," + oSub.HQty.ToString() + "" + "," + oSub.HPieceQty.ToString() + "" + "," + oSub.HPrice.ToString() + "" + "," + oSub.HMoney.ToString() + "" + "," + oSub.HTaxPrice.ToString() + "" + "," + oSub.HTaxRate.ToString() + "" + "," + oSub.HTaxMoney.ToString() + "" + "," + oSub.HWHID.ToString() + "" + "," + oSub.HSPID.ToString() + "" + "," + oSub.HSCWHID.ToString() + "" + "," + oSub.HSCSPID.ToString() + "" + "," + oSub.HSPGroupID.ToString() + "" + ",'" + oSub.HBatchNo + "'" + "," + oSub.HPOOrderInterID.ToString() + "" + "," + oSub.HPOOrderEntryID.ToString() + "" + ",'" + oSub.HPOOrderBillNo + "'" + "," + oSub.HQty_Full + "" + "," + oSub.HQty_Empty + "" + "," + oSub.HQty_Back + "" + "," + oSub.HCostPrice.ToString() + "" + "," + oSub.HCostMoney.ToString() + "" + "," + oSub.HSalePrice.ToString() + "" + "," + oSub.HPropertyID.ToString() + "" + "," + oSub.HSecUnitID.ToString() + "" + "," + oSub.HSecUnitRate.ToString() + "" + ",'" + oSub.HEngineNum + "'" + ",'" + oSub.HUnderPanNum + "'" + ",'" + oSub.HLeaveFactCard + "'" + "," + oSub.HReqBuyQty + "," + oSub.HReqOutQty + "," + oSub.HCurrentInventory + ") "; oCn.RunProc(subSql); //oCn.RunProc("Insert into Kf_ICStockBillSub " + // " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" + // ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + // ",HMaterID,HPropertyID,HSecUnitID,HSecUnitRate,HUnitID,HQtyMust" + // ",HQty,HPrice,HMoney,HWHID,HSCWHID,HSPID" + // ",HCostPrice,HCostMoney,HSalePrice" + // ",HEngineNum,HUnderPanNum,HLeaveFactCard" + // ",HSCSPID,HSPGroupID,HBatchNo,HPOOrderInterID,HPOOrderEntryID,HPOOrderBillNo" + // ",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo,HQty_Full,HQty_Empty,HQty_Back" + // ") values(" // + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + // "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + // "," + oSub.HMaterID.ToString() + "," + oSub.HPropertyID.ToString() + "," + oSub.HSecUnitID.ToString() + "," + oSub.HSecUnitRate.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HQtyMust.ToString() + // "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HMoney.ToString() + "," + oSub.HWHID.ToString() + "," + oSub.HSCWHID.ToString() + "," + oSub.HSPID.ToString() + // "," + oSub.HCostPrice.ToString() + "," + oSub.HCostMoney.ToString() + "," + oSub.HSalePrice.ToString() + // ",'" + oSub.HEngineNum + "','" + oSub.HUnderPanNum + "','" + oSub.HLeaveFactCard + "'" + // "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'," + oSub.HPOOrderInterID.ToString() + "," + oSub.HPOOrderEntryID.ToString() + ",'" + oSub.HPOOrderBillNo + "'" + // "," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'," + oSub.HQty_Full + // "," + oSub.HQty_Empty + "," + oSub.HQty_Back + // ") "); } //æ´æ°è®¢åå ³èæ°é AddNewRelation(ref sReturn, omodel.HInterID); //æ§å¶å ³èæ°é // //=========================ä¿ååæ§å¶ DataSet ds2 = oCn.RunProcReturn("Exec h_p_Kf_SellOutBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',1 ", "h_p_Kf_SellOutBill_AfterSaveCtrl"); if (ds2 == null) { sReturn = "ä¿ååæ§å¶å¤æå¤±è´¥ï¼"; oCn.RollBack(); return false; } if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0") { sReturn = "ä¿å失败2ï¼" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]); oCn.RollBack(); return false; } //============================ sReturn = "æ°å¢åæ®æåï¼"; oCn.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //æ¾ç¤ºåæ® public override bool ShowBill(Int64 lngBillKey, ref string sReturn) { try { //æ¥è¯¢ä¸»è¡¨ DataSet Ds; Ds = oCn.RunProcReturn("Select * from Kf_ICStockBillMain Where HInterID=" + lngBillKey.ToString(), "Kf_ICStockBillMain"); if (Ds.Tables[0].Rows.Count == 0) { sReturn = "åæ®æªæ¾å°ï¼"; return false; } //åºå®èµå¼=========================================== omodel.HMainSourceBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HMainSourceBillType"]); omodel.HYear = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HYear"]); omodel.HPeriod = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HPeriod"]); omodel.HBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillType"]); omodel.HBillSubType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillSubType"]); omodel.HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"]); omodel.HDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HDate"]); omodel.HBillNo = Ds.Tables[0].Rows[0]["HBillNo"].ToString().Trim(); omodel.HBillStatus = DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[0]["HBillStatus"]); omodel.HCheckItemNowID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckItemNowID"]); omodel.HCheckItemNextID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckItemNextID"]); omodel.HCheckFlowID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckFlowID"]); omodel.HRemark = Ds.Tables[0].Rows[0]["HRemark"].ToString().Trim(); omodel.HBackDate = Ds.Tables[0].Rows[0]["HBackDate"].ToString().Trim(); omodel.HBacker = Ds.Tables[0].Rows[0]["HBacker"].ToString().Trim(); omodel.HCheckDate = Ds.Tables[0].Rows[0]["HCheckDate"].ToString().Trim(); omodel.HChecker = Ds.Tables[0].Rows[0]["HChecker"].ToString().Trim(); omodel.HMaker = Ds.Tables[0].Rows[0]["HMaker"].ToString().Trim(); omodel.HMakeDate = Ds.Tables[0].Rows[0]["HMakeDate"].ToString().Trim(); omodel.HUpDateDate = Ds.Tables[0].Rows[0]["HUpDateDate"].ToString().Trim(); omodel.HUpDater = Ds.Tables[0].Rows[0]["HUpDater"].ToString().Trim(); omodel.HCloseDate = Ds.Tables[0].Rows[0]["HCloseDate"].ToString().Trim(); omodel.HCloseMan = Ds.Tables[0].Rows[0]["HCloseMan"].ToString().Trim(); omodel.HCloseType = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["HCloseType"]); omodel.HDeleteDate = Ds.Tables[0].Rows[0]["HDeleteDate"].ToString().Trim(); omodel.HDeleteMan = Ds.Tables[0].Rows[0]["HDeleteMan"].ToString().Trim(); //======================================================== omodel.HOrgID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HOrgID"]); omodel.HSellSID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSellSID"]); omodel.HCurID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCurID"]); omodel.HSupID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSupID"]); omodel.HWHID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HWHID"]); omodel.HSCWHID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSCWHID"]); omodel.HEmpID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HEmpID"]); omodel.HManagerID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HManagerID"]); omodel.HSecManagerID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSecManagerID"]); omodel.HKeeperID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HKeeperID"]); omodel.HDeptID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HDeptID"]); omodel.HExplanation = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HExplanation"]); omodel.HInnerBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HInnerBillNo"]); omodel.HRedBlueFlag = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["HRedBlueFlag"]); omodel.HLinkMan = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HLinkMan"]); omodel.HLinkPhone = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HLinkPhone"]); // omodel.HConveyCompID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HConveyCompID"]); omodel.HConveyTypeID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HConveyTypeID"]); omodel.HConveyMoney = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0]["HConveyMoney"]); omodel.HSeOrderBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HSeOrderBillNo"]); // //å¾ªç¯ DataSet DsSub; DsSub = oCn.RunProcReturn("Select * from Kf_ICStockBillSub Where HInterID=" + lngBillKey.ToString(), "Kf_ICStockBillSub"); DetailColl.Clear();//æ¸ ç©º for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++) { Model.ClsKf_SellOutBillSub oSub = new Model.ClsKf_SellOutBillSub(); // åºå®èµå¼=============================================== oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]); oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]); oSub.HSourceInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSourceInterID"]); oSub.HSourceEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSourceEntryID"]); oSub.HSourceBillType = DsSub.Tables[0].Rows[i]["HSourceBillType"].ToString().Trim(); oSub.HSourceBillNo = DsSub.Tables[0].Rows[i]["HSourceBillNo"].ToString().Trim(); oSub.HRelationQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HRelationQty"]); oSub.HRelationMoney = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HRelationMoney"]); oSub.HCloseMan = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HCloseMan"]); oSub.HCloseType = DBUtility.ClsPub.isBool(DsSub.Tables[0].Rows[i]["HCloseType"]); oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[i]["HEntryCloseDate"]); oSub.HRemark = DsSub.Tables[0].Rows[i]["HRemark"].ToString().Trim(); //=================================================== oSub.HMaterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HMaterID"]); oSub.HPropertyID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HPropertyID"]); oSub.HSecUnitID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSecUnitID"]); oSub.HSecUnitRate = DBUtility.ClsPub.isSingle(DsSub.Tables[0].Rows[i]["HSecUnitRate"]); oSub.HUnitID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HUnitID"]); oSub.HQtyMust = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HQtyMust"]); oSub.HQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HQty"]); oSub.HPieceQty = DBUtility.ClsPub.isInt(DsSub.Tables[0].Rows[i]["HPieceQty"]); oSub.HPrice = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HPrice"]); oSub.HMoney = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HMoney"]); oSub.HSalePrice = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HSalePrice"]); oSub.HCostMoney = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HCostMoney"]); oSub.HCostPrice = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HCostPrice"]); oSub.HWHID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HWHID"]); oSub.HSCWHID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSCWHID"]); oSub.HSPID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSPID"]); oSub.HSCSPID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSCSPID"]); oSub.HSPGroupID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSPGroupID"]); oSub.HBatchNo = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HBatchNo"]); oSub.HEngineNum = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HEngineNum"]); oSub.HUnderPanNum = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HUnderPanNum"]); oSub.HLeaveFactCard = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HLeaveFactCard"]); oSub.HPOOrderInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HPOOrderInterID"]); oSub.HPOOrderEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HPOOrderEntryID"]); oSub.HPOOrderBillNo = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HPOOrderBillNo"]); oSub.HSeOrderInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSeOrderInterID"]); oSub.HSeOrderEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSeOrderEntryID"]); oSub.HSeOrderBillNo = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HSeOrderBillNo"]); DetailColl.Add(oSub); } sReturn = "æ¾ç¤ºåæ®æåï¼"; return true; } catch (Exception e) { sReturn = e.Message; throw (e); } } //æ¾ç¤ºåæ®æ¡ç ä¿¡æ¯ public bool ShowBill_Scheme(Int64 lngBillKey, ref string sReturn) { try { //循ç¯å表2 DataSet DsSubSec; DsSubSec = oCn.RunProcReturn("Select * from Kf_ICStockBillSub_WMS with (nolock) Where HInterID=" + lngBillKey.ToString() + " and HBillType='" + this.BillType + "'", "Kf_ICStockBillSub_WMS"); DetailSubColl.Clear();//æ¸ ç©º for (int i = 0; i < DsSubSec.Tables[0].Rows.Count; i++) { Model.ClsKf_SellOutBillScheme oSubSec = new Model.ClsKf_SellOutBillScheme(); oSubSec.HInterID = DBUtility.ClsPub.isLong(DsSubSec.Tables[0].Rows[i]["HInterID"].ToString()); oSubSec.HEntryID = DBUtility.ClsPub.isLong(DsSubSec.Tables[0].Rows[i]["HEntryID"].ToString()); oSubSec.HItemID = DBUtility.ClsPub.isLong(DsSubSec.Tables[0].Rows[i]["HItemID"].ToString()); oSubSec.HBillType = DsSubSec.Tables[0].Rows[i]["HBillType"].ToString(); oSubSec.HMaterID = DBUtility.ClsPub.isLong(DsSubSec.Tables[0].Rows[i]["HMaterID"].ToString()); oSubSec.HProcID = DBUtility.ClsPub.isLong(DsSubSec.Tables[0].Rows[i]["HProcID"].ToString()); oSubSec.HWhID = DBUtility.ClsPub.isLong(DsSubSec.Tables[0].Rows[i]["HWhID"].ToString()); oSubSec.HGroupID = DBUtility.ClsPub.isLong(DsSubSec.Tables[0].Rows[i]["HGroupID"].ToString()); oSubSec.HQty = DBUtility.ClsPub.isDoule(DsSubSec.Tables[0].Rows[i]["HQty"].ToString()); oSubSec.HBarCode = DsSubSec.Tables[0].Rows[i]["HBarCode"].ToString(); oSubSec.HAddr = DsSubSec.Tables[0].Rows[i]["HAddr"].ToString(); oSubSec.HMaker = DsSubSec.Tables[0].Rows[i]["HMaker"].ToString(); oSubSec.HMakeDate = DBUtility.ClsPub.isDate(DsSubSec.Tables[0].Rows[i]["HMakeDate"].ToString()); oSubSec.HSourceInterID = DBUtility.ClsPub.isLong(DsSubSec.Tables[0].Rows[i]["HSourceInterID"].ToString()); oSubSec.HSourceEntryID = DBUtility.ClsPub.isLong(DsSubSec.Tables[0].Rows[i]["HSourceEntryID"].ToString()); oSubSec.HSourceBillType = DsSubSec.Tables[0].Rows[i]["HSourceBillType"].ToString(); oSubSec.HSourceBillNo = DsSubSec.Tables[0].Rows[i]["HSourceBillNo"].ToString(); oSubSec.HSourceItemID = DBUtility.ClsPub.isLong(DsSubSec.Tables[0].Rows[i]["HSourceItemID"].ToString()); // DetailSubColl.Add(oSubSec); } sReturn = "æ¾ç¤ºåæ®æåï¼"; return true; } catch (Exception e) { sReturn = e.Message; throw (e); } } public bool IsSave(Int64 HMaterID, string sBatchNo, ref string sReturn) { try { //æ¥è¯¢ä¸»è¡¨ DataSet Ds; Ds = oCn.RunProcReturn("Select * from Crm_CusAppealBillSub Where HMaterID=" + HMaterID.ToString() + " and HBatchNo='" + sBatchNo + "'", "Crm_CusAppealBillSub"); if (Ds.Tables[0].Rows.Count == 0) { sReturn = "æè¯è®°å½åæ®æªæ¾å°ï¼"; return true; } DataSet DsSub; DsSub = oCn.RunProcReturn("Select HBackType from Crm_CusAppealDisposeBillMain Where HSourceInterID=" + DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"]).ToString() + " and HSourceEntryID=" + DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HEntryID"]).ToString(), "Crm_CusAppealDisposeBillMain"); if (DsSub.Tables[0].Rows.Count == 0) { sReturn = "æè¯å¤çåæ®æªæ¾å°ï¼"; return true; } if (DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[0][0]) == "订ééå") { sReturn = "æè¯å¤çå ç±»å为 订ééåï¼"; return false; } sReturn = "æ¾ç¤ºåæ®æåï¼"; return true; } catch (Exception e) { sReturn = e.Message; throw (e); } } public long Get_CusBySeOutStockBackBillNo(string sBatchNo) { try { //æ¥è¯¢ä¸»è¡¨ DataSet Ds; Ds = oCn.RunProcReturn("Select * from h_v_Xs_SeOutStockBackBillList_K3 Where åæ®å·='" + sBatchNo + "'", "h_v_Xs_SeOutStockBackBillList_K3"); if (Ds.Tables[0].Rows.Count == 0) { return 0; } //åºå®èµå¼=========================================== // long HCusID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCusID"]); return HCusID; } catch (Exception e) { throw (e); } } public bool CheckStockQty(long HMaterID, long HWhID, string sBatchNo) { try { //æ¥è¯¢ä¸»è¡¨ DataSet Ds; Ds = oCn.RunProcReturn("Select 峿¶åºå from h_v_KF_ICInventoryList Where HMaterID=" + HMaterID.ToString() + " and HWHID=" + HWhID.ToString() + " and æ¹æ¬¡='" + sBatchNo + "'", "h_v_KF_ICInventoryList"); if (Ds.Tables[0].Rows.Count == 0) { return false; } //夿æ¯å¦è´åºåæ0åºå if (DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[0][0]) <= 0) { return false; } return true; } catch (Exception e) { throw (e); } } public bool SplitQty(long HMainID, long HSubID, string HBillNo, double HSplitQty) { try { long HNewInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); string HMaker = DBUtility.ClsPub.CurUserName; //æ¥è¯¢ä¸»è¡¨ oCn.RunProc("exec h_p_Kf_ICStockBill_Split " + HMainID.ToString() + "," + HSubID.ToString() + ",'" + HBillNo + "'," + HSplitQty.ToString() + "," + HNewInterID.ToString() + ",'" + HMaker + "'"); // return true; } catch (Exception e) { throw (e); } } public bool ChangePrice(long HMainID, long HSubID, double HNewPrice) { try { string HMaker = DBUtility.ClsPub.CurUserName; //æ¥è¯¢ä¸»è¡¨ oCn.RunProc("exec h_p_Kf_ICStockBill_ChangePrice " + HMainID.ToString() + "," + HSubID.ToString() + "," + HNewPrice.ToString() + ",'" + HMaker + "'"); // return true; } catch (Exception e) { throw (e); } } //å 餿¡ç public bool Sub_DelBarCode(Int64 lngBillKey, ref string sReturn) { try { oCn.RunProc("Delete from Kf_ICStockBillSub_WMS where HitemID= " + lngBillKey.ToString() + ""); return true; } catch (Exception e) { sReturn = e.Message; return false; } } //夿 è´åºå public bool CheckKF(Int64 lngBillKey, int iType, ref string sReturn) { try { DataSet oDs = new DataSet(); oDs = oCn.RunProcReturn("exec h_p_Kf_ICStockBill_CheckKF " + lngBillKey.ToString() + "," + iType.ToString(), "gy_czygl"); if (oDs == null || oDs.Tables[0].Rows.Count == 0) { return false; } if (DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0][0]) == "N") { sReturn = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0][1]); return false; } else { sReturn = DBUtility.ClsPub.isStrNull(oDs.Tables[0].Rows[0][1]); return true; } } catch (Exception e) { sReturn = e.Message; throw (e); } } //æ¡ç æ«æè®°å½,æ°å¢å°éå®åºåº (æºåï¼åè´§éç¥å) public bool AddBill_PDA(ref string sReturn) { try { //夿ä¼è®¡ææ¯å¦åç string s = ""; int sYear = 0; int sPeriod = 0; if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(omodel.HDate, ref sYear, ref sPeriod, ref s) == false) { sReturn = s; return false; } omodel.HYear = sYear; omodel.HPeriod = sPeriod; oCn.BeginTran(); //å é¤ä¸»è¡¨ oCn.RunProc("Delete From Kf_ICStockBillMain where HInterID=" + omodel.HInterID.ToString()); //æå ¥å表 oCn.RunProc("EXEC h_p_Kf_SellOutBillSub_Insert " + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'"); //æå ¥ä¸»è¡¨ oCn.RunProc("Insert Into Kf_ICStockBillMain " + "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMainSourceBillType" + ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + ",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" + ") " + " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "',convert(varchar(10),getdate(),120),'" + omodel.HMainSourceBillType + "'" + ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HMaker + "',convert(varchar(10),getdate(),120)" + ", " + omodel.HSupID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HSCWHID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HSecManagerID.ToString() + ", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) + ") "); //æ´æ°å ³èæ°é oCn.RunProc("exec h_p_Xs_UpDateSeOutStockRelation_Add " + omodel.HInterID.ToString()); //å®¡æ ¸åæ® oCn.RunProc("Update Kf_ICStockBillMain Set HChecker='" + omodel.HMaker + "',HCheckDate=convert(varchar(10),getdate(),120),HBillStatus=2 where HInterID= " + omodel.HInterID.ToString()); //çæK3åæ® //æ°å¢å表ã主表 oCn.RunProc("exec h_p_IFK3_ToERP_SellOutBill_Insert " + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'," + omodel.HBillerID.ToString()); //åå¡«å ³èæ°é oCn.RunProc("exec h_p_IFK3_ToERP_SellOutBill_UpdateBillRelateData " + omodel.HInterID.ToString()); //å®¡æ ¸åæ® oCn.RunProc("exec h_p_IFK3_ToERP_SellOutBill_Check " + omodel.HInterID.ToString() + "," + omodel.HBillerID.ToString()); //æ´æ°åºå oCn.RunProc("exec h_p_IFK3_ToERP_SellOutBill_UpdateStock " + omodel.HInterID.ToString()); oCn.RunProc("exec h_p_IFK3_ToERP_SellOutBill_UpdateOrderStock " + omodel.HInterID.ToString()); //夿æ¡ç åºåæ¯å¦å¼å¸¸ï¼è´åºåãåºåå¤§äºæ¡ç åå§åï¼ DataSet Ds; Ds = oCn.RunProcReturn("EXEC h_p_KF_ICInventoryBarCodeQtyCtrl " + omodel.HInterID.ToString(), "h_p_KF_ICInventoryBarCodeQtyCtrl"); if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 1) { } else { sReturn = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0][1]); oCn.RollBack(); return false; } sReturn = "æ°å¢åæ®æåï¼"; oCn.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //æ¡ç æ«æè®°å½,æ°å¢å°éå®åºåº (红å) (æºåï¼éè´§éç¥å) public bool AddBill_PDA_Red(ref string sReturn) { try { //夿ä¼è®¡ææ¯å¦åç string s = ""; int sYear = 0; int sPeriod = 0; if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(omodel.HDate, ref sYear, ref sPeriod, ref s) == false) { sReturn = s; return false; } omodel.HYear = sYear; omodel.HPeriod = sPeriod; DataSet Ds; oCn.BeginTran(); //å é¤ä¸»è¡¨ oCn.RunProc("Delete From Kf_ICStockBillMain where HInterID=" + omodel.HInterID.ToString()); //æå ¥å表 oCn.RunProc("EXEC h_p_Kf_SellOutBillSub_Red_Insert " + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'"); //æå ¥ä¸»è¡¨ oCn.RunProc("Insert Into Kf_ICStockBillMain " + "(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMainSourceBillType" + ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + ",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" + ") " + " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "',convert(varchar(10),getdate(),120),'" + omodel.HMainSourceBillType + "'" + ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + omodel.HMaker + "',convert(varchar(10),getdate(),120)" + ", " + omodel.HSupID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HSCWHID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HSecManagerID.ToString() + ", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) + ") "); //æ´æ°å ³èæ°é oCn.RunProc("exec h_p_Xs_UpDateSeOutStockBackRelation_Add " + omodel.HInterID.ToString()); //å®¡æ ¸åæ® oCn.RunProc("Update Kf_ICStockBillMain Set HChecker='" + omodel.HMaker + "',HCheckDate=convert(varchar(10),getdate(),120),HBillStatus=2 where HInterID= " + omodel.HInterID.ToString()); sReturn = "æ°å¢åæ®æåï¼"; oCn.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } } } DAL/Éú²ú¹ÜÀí/Ä£¾ß¹ÜÀí/ClsSc_MouldProdOutBill.cs
@@ -247,6 +247,7 @@ ", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HSCWHID.ToString() + "," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + omodel.HSTOCKORGID.ToString() + ") "); //æå ¥å表 foreach (Model.ClsSc_MouldProdOutBillSub oSub in DetailColl) { DBUtility/bin/Release/DBUtility.dllBinary files differ
DBUtility/bin/Release/DBUtility.pdbBinary files differ
DBUtility/bin/Release/Pub_Class.dllBinary files differ
DBUtility/bin/Release/Pub_Class.pdbBinary files differ
DBUtility/bin/Release/Pub_Control.dllBinary files differ
DBUtility/bin/Release/Pub_Control.pdbBinary files differ
DBUtility/bin/Release/SQLHelper.dllBinary files differ
DBUtility/bin/Release/SQLHelper.pdbBinary files differ
DBUtility/obj/Release/DBUtility.Gy_UserSelect.resourcesBinary files differ
DBUtility/obj/Release/DBUtility.Xt_BillType.resourcesBinary files differ
DBUtility/obj/Release/DBUtility.Xt_CheckFlow.resourcesBinary files differ
DBUtility/obj/Release/DBUtility.Xt_CheckFlowList.resourcesBinary files differ
DBUtility/obj/Release/DBUtility.Xt_CheckItem.resourcesBinary files differ
DBUtility/obj/Release/DBUtility.Xt_CheckUserRight.resourcesBinary files differ
DBUtility/obj/Release/DBUtility.csproj.AssemblyReference.cacheBinary files differ
DBUtility/obj/Release/DBUtility.csproj.GenerateResource.CacheBinary files differ
DBUtility/obj/Release/DBUtility.csproj.ResolveComReference.cacheBinary files differ
DBUtility/obj/Release/DBUtility.dllBinary files differ
DBUtility/obj/Release/DBUtility.pdbBinary files differ
LMES/obj/x86/Release/LMES.csproj.AssemblyReference.cacheBinary files differ
Model/bin/Release/DBUtility.dllBinary files differ
Model/bin/Release/DBUtility.pdbBinary files differ
Model/bin/Release/Model.dllBinary files differ
Model/bin/Release/Model.pdbBinary files differ
Model/bin/Release/Pub_Class.dllBinary files differ
Model/bin/Release/Pub_Class.pdbBinary files differ
Model/bin/Release/Pub_Control.dllBinary files differ
Model/bin/Release/Pub_Control.pdbBinary files differ
Model/bin/Release/SQLHelper.dllBinary files differ
Model/bin/Release/SQLHelper.pdbBinary files differ
Model/obj/Release/Model.csproj.AssemblyReference.cacheBinary files differ
Model/obj/Release/Model.dllBinary files differ
Model/obj/Release/Model.pdbBinary files differ
Model/²Ö¿â¹ÜÀí/ClsKf_SellOutBillMain.cs
@@ -45,5 +45,6 @@ public Int64 HERPInterID; public string HERPBillType; public string HERPBillNo; public string HInvoiceBillNo; } } Pub_Class/bin/Release/Pub_Class.dllBinary files differ
Pub_Class/bin/Release/Pub_Class.pdbBinary files differ
Pub_Class/bin/Release/SyntacticSugar.dllBinary files differ
Pub_Class/bin/Release/SyntacticSugar.pdbBinary files differ
Pub_Control/bin/Release/Pub_Class.dllBinary files differ
Pub_Control/bin/Release/Pub_Class.pdbBinary files differ
Pub_Control/bin/Release/Pub_Control.dllBinary files differ
Pub_Control/bin/Release/Pub_Control.pdbBinary files differ
SQLHelper/bin/Release/Pub_Class.dllBinary files differ
SQLHelper/bin/Release/Pub_Class.pdbBinary files differ
SQLHelper/bin/Release/SQLHelper.dllBinary files differ
SQLHelper/bin/Release/SQLHelper.pdbBinary files differ
SQLHelper/obj/Release/SQLHelper.csproj.AssemblyReference.cacheBinary files differ
SQLHelper/obj/Release/SQLHelper.dllBinary files differ
SQLHelper/obj/Release/SQLHelper.pdbBinary files differ
SyntacticSugar/bin/Debug/SyntacticSugar.dllBinary files differ
SyntacticSugar/bin/Debug/SyntacticSugar.pdbBinary files differ
SyntacticSugar/bin/Release/SyntacticSugar.dllBinary files differ
SyntacticSugar/bin/Release/SyntacticSugar.pdbBinary files differ
SyntacticSugar/obj/Debug/SyntacticSugar.csproj.CoreCompileInputs.cache
File was deleted SyntacticSugar/obj/Debug/SyntacticSugar.csproj.FileListAbsolute.txt
@@ -1,6 +1,5 @@ D:\ç½ç«åå¸\å端代ç \MES-WEB-API\MES-WEB-API\SyntacticSugar\bin\Debug\SyntacticSugar.dll D:\ç½ç«åå¸\å端代ç \MES-WEB-API\MES-WEB-API\SyntacticSugar\bin\Debug\SyntacticSugar.pdb D:\ç½ç«åå¸\å端代ç \MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.AssemblyReference.cache D:\ç½ç«åå¸\å端代ç \MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.CoreCompileInputs.cache D:\ç½ç«åå¸\å端代ç \MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.dll D:\ç½ç«åå¸\å端代ç \MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.pdb @@ -10,8 +9,3 @@ C:\Users\19858\Desktop\æºäºè¿æ\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.CoreCompileInputs.cache C:\Users\19858\Desktop\æºäºè¿æ\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.dll C:\Users\19858\Desktop\æºäºè¿æ\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.pdb D:\WorkBench\MES-WEB-API\SyntacticSugar\bin\Debug\SyntacticSugar.dll D:\WorkBench\MES-WEB-API\SyntacticSugar\bin\Debug\SyntacticSugar.pdb D:\WorkBench\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.csproj.CoreCompileInputs.cache D:\WorkBench\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.dll D:\WorkBench\MES-WEB-API\SyntacticSugar\obj\Debug\SyntacticSugar.pdb SyntacticSugar/obj/Debug/SyntacticSugar.dllBinary files differ
SyntacticSugar/obj/Debug/SyntacticSugar.pdbBinary files differ
SyntacticSugar/obj/Release/SyntacticSugar.csproj.FileListAbsolute.txt
@@ -3,3 +3,8 @@ D:\ç½ç«åå¸\å端代ç \MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Release\SyntacticSugar.csproj.CoreCompileInputs.cache D:\ç½ç«åå¸\å端代ç \MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Release\SyntacticSugar.dll D:\ç½ç«åå¸\å端代ç \MES-WEB-API\MES-WEB-API\SyntacticSugar\obj\Release\SyntacticSugar.pdb D:\WorkBench\MES-WEB-API\SyntacticSugar\bin\Release\SyntacticSugar.dll D:\WorkBench\MES-WEB-API\SyntacticSugar\bin\Release\SyntacticSugar.pdb D:\WorkBench\MES-WEB-API\SyntacticSugar\obj\Release\SyntacticSugar.csproj.CoreCompileInputs.cache D:\WorkBench\MES-WEB-API\SyntacticSugar\obj\Release\SyntacticSugar.dll D:\WorkBench\MES-WEB-API\SyntacticSugar\obj\Release\SyntacticSugar.pdb SyntacticSugar/obj/Release/SyntacticSugar.dllBinary files differ
SyntacticSugar/obj/Release/SyntacticSugar.pdbBinary files differ
WebAPI/App_Start/WebApiConfig.cs
@@ -31,10 +31,10 @@ ); // å ¨å±å¯ç¨ JWT è®¤è¯ // config.Filters.Add(new JwtAuthorizeAttribute()); config.Filters.Add(new JwtAuthorizeAttribute()); // å¯ç¨JWTååºæ¦æªå¨ï¼èªå¨å·æ°JWT // config.MessageHandlers.Add(new TokenAppendHandler()); config.MessageHandlers.Add(new TokenAppendHandler()); } } } WebAPI/Controllers/BaseSet/Kf_WIPBalController.cs
@@ -385,11 +385,11 @@ // æå ¥ä¸»è¡¨ string insertMainSql = $@" insert into Kf_WIPBalMain ( HYear, HPeriod, HCostCenterID, HWorkShopID, HCostObjID, (HInterID, HYear, HPeriod, HCostCenterID, HWorkShopID, HCostObjID, HICMOInterID, HProcExchInterID, HProcExchEntryID, HIsBack, HBatchNo, HMaker, HMakeDate, HOrgID) values ( {HYear}, {HPeriod}, 0, {HWorkShopID}, {HCostObjID}, ({HInterID},{HYear}, {HPeriod}, 0, {HWorkShopID}, {HCostObjID}, 0, 0, 0, 0, '', '{user}', getdate(), '{HOrgID}')"; WebAPI/Controllers/CGGL/Cg_POInStockBillController.cs
@@ -10,9 +10,11 @@ using System.Web.Http; using WebAPI.Models; using SyntacticSugar.constant; using WebAPI.Utility; namespace WebAPI.Controllers { [Permission(HModName = "Cg_POInStockBill")] //æ¶æéç¥åController public class Cg_POInStockBillController : ApiController { @@ -129,6 +131,7 @@ /// </summary> [Route("Cg_POInStockBill/list")] [HttpGet] [Permission(HModName = "Cg_POInStockBillQuery")] public object list(string sWhere, string user) { try WebAPI/Controllers/CGGL/Kf_POStockInBillController.cs
@@ -148,6 +148,188 @@ #endregion #region éè´å ¥åºä¿å /// <summary> /// ä¿åéå®åºåºå /// </summary> /// <param name="msg"></param> /// <returns></returns> [Route("Kf_POStockInBill/SaveSellOutBillList")] [HttpPost] public object SaveSellOutBillList([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(); string user = sArray[2].ToString(); string OperationType = sArray[3].ToString(); ListModels oListModels = new ListModels(); try { //夿æé //if (!DBUtility.ClsPub.Security_Log("Kf_SellOutBill_Edit", 1, false, user)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æ ä¿åæé"; // objJsonResult.data = null; // return objJsonResult; //} DAL.ClsKf_POStockInBill1 oBill = new DAL.ClsKf_POStockInBill1(); List<Model.ClsKf_SellOutBillMain> lsmain = new List<Model.ClsKf_SellOutBillMain>(); msg2 = msg2.Replace("\\", ""); msg2 = msg2.Replace("\n", ""); //\n lsmain = oListModels.getSellOutBillMainByJson(msg2); foreach (Model.ClsKf_SellOutBillMain oItem in lsmain) { oItem.HMaker = user; oItem.HUpDater = user; if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿åå¤±è´¥ï¼æ²¡æåæ®æ¥æï¼æ æ³ä¿åï¼"; objJsonResult.data = 1; return objJsonResult; } oBill.omodel = oItem; } //è¡¨ä½æ°æ® //æ },{æ¥æåæ°ç» //廿ãåã msg3 = msg3.Substring(1, msg3.Length - 2); msg3 = msg3.Replace("\\", ""); msg3 = msg3.Replace("\n", ""); //\n List<Model.ClsKf_SellOutBillSub> ls = new List<Model.ClsKf_SellOutBillSub>(); ls = oListModels.getSellOutBillSubByJson(msg3); int i = 0; foreach (Model.ClsKf_SellOutBillSub oItemSub in ls) { i++; oItemSub.HEntryID = i; oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); oItemSub.HCloseType = false; oItemSub.HCloseMan = ""; oBill.DetailColl.Add(oItemSub); } //è¿è¡ ä¼è®¡æé´ ç»è´¦ çå¤æåæ§å¶ string s = ""; int sYear = 0; int sPeriod = 0; DateTime HDate = DateTime.Now; if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) { objJsonResult.Message = s; return objJsonResult; } //ä¿å //ä¿å宿¯åå¤ç bool bResult; if (Convert.ToInt32(OperationType) == 1) //æ°å¢ä¿å { bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); } else if (Convert.ToInt32(OperationType) == 4) //䏿¨ä¿å { bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); } else //ç¼è¾ä¿å { if (BillOld.ShowBill(lsmain[0].HInterID, ref s) == false) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¤åæ®æè¯¯ï¼"; objJsonResult.data = 1; return objJsonResult; } //夿æ¯å¦å¯ç¼è¾ if (BillOld.omodel.HChecker != "" && BillOld.omodel.HChecker != null) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¤åæ®å·²ç»è¢«å®¡æ ¸ï¼ä¸å 许修æ¹ï¼"; objJsonResult.data = 1; return objJsonResult; } if (BillOld.omodel.HBillStatus > 1) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¤åæ®å¤äºä¸å¯ç¼è¾ç¶æï¼ä¸å 许修æ¹ï¼"; objJsonResult.data = 1; return objJsonResult; } if (!DBUtility.Xt_BaseBillFun.Fun_AllowEditBill(BillOld, ref s)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = s + "ï¼ä¸å 许修æ¹"; objJsonResult.data = 1; return objJsonResult; } bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); } //èªå¨å®¡æ ¸è®¾ç½® if (Convert.ToInt32(OperationType) == 1 || Convert.ToInt32(OperationType) == 4) { objJsonResult.HInterID = oBill.omodel.HInterID.ToString(); //è¿å主ID //ç³»ç»åæ° èªå¨å®¡æ ¸ string sReturn = ""; if (oSystemParameter.ShowBill(ref sReturn) == true) { if (oSystemParameter.omodel.Kf_SellOutBill_AutoCheck == "Y") //ç³»ç»åæ° èªå¨å®¡æ ¸ { objJsonResult.Verify = "Y"; } else { objJsonResult.Verify = "N"; } } } else { objJsonResult.HInterID = oBill.omodel.HInterID.ToString(); //è¿å主ID objJsonResult.Verify = "N"; } if (bResult) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "ä¿åæåï¼"; objJsonResult.data = 1; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败ï¼" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = 1; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败ï¼" + e.ToString(); objJsonResult.data = 1; return objJsonResult; } } #endregion #region éè´å ¥åºå ä¿å/ç¼è¾åè½ [Route("Kf_POStockInBill/POStockInBillEdit")] [HttpPost] WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs
@@ -239,19 +239,20 @@ } //夿客æ·ä¸ä¸ºé¾å±±æ±½é if (oSystemParameter.omodel.WMS_CampanyName != "é¾å±±æ±½é " && oSystemParameter.omodel.WMS_CampanyName != "çä¸ç¥º" && oSystemParameter.omodel.WMS_CampanyName != "æ·»åº·ç§æ" && oSystemParameter.omodel.WMS_CampanyName != "æµ·è¯") //ç³»ç»åæ° { if (HSourceID == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "[0000-2-006]çäº§èµæºæ²¡æéæ©ï¼"; objJsonResult.data = null; return objJsonResult; } } //夿客æ·ä¸ºé¾å±±æ±½é else if (oSystemParameter.omodel.WMS_CampanyName == "é¾å±±æ±½é ") //if (oSystemParameter.omodel.WMS_CampanyName != "é¾å±±æ±½é " && oSystemParameter.omodel.WMS_CampanyName != "çä¸ç¥º" && oSystemParameter.omodel.WMS_CampanyName != "æ·»åº·ç§æ" && oSystemParameter.omodel.WMS_CampanyName != "æµ·è¯") //ç³»ç»åæ° //{ // if (HSourceID == 0) // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "[0000-2-006]çäº§èµæºæ²¡æéæ©ï¼"; // objJsonResult.data = null; // return objJsonResult; // } //} ////夿客æ·ä¸ºé¾å±±æ±½é //else if (oSystemParameter.omodel.WMS_CampanyName == "é¾å±±æ±½é ") { //夿æ¯å¦ä¸ºå¤å·¥ä½ ds = oCN.RunProcReturn("select * from h_v_GetStationOutBill_Detail where å·¥åºID = " + HProcID + " and ç©æID = " + HMaterID + " and æµè½¬å¡å· = '" + HProcExchBillNo + "'", "h_v_GetStationOutBill_Detail"); WebAPI/Controllers/Cg_ContractTransportBillListController.cs
@@ -83,6 +83,62 @@ #endregion #region æ¿è¿åååå页å表 [Route("Cg_ContractTransportBillListController/page")] [HttpGet] public json Sc_MouldProdOutBillPage(string sWhere, string user, int page, int size, string Type) { try { List<object> columnNameList = new List<object>(); //å表è¿å ¥æ¶å¤ææéï¼éæºåè¿å ¥ä¸å¤ææé if (!DBUtility.ClsPub.Security_Log("Cg_ContractTransportBill_Query", 3, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¨æ²¡æè¯¥æ¨¡åæé,请ä¸ç®¡çåèç³»ï¼"; objJsonResult.data = null; return objJsonResult; } sWhere = sWhere.Replace("'", "''"); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("exec h_p_Cg_ContractTransportBillList " + page + "," + size + ",'','" + Type + "'", "h_p_Cg_ContractTransportBillList"); } else { ds = oCN.RunProcReturn("exec h_p_Cg_ContractTransportBillList " + page + "," + size + ",'" + sWhere + "','" + Type + "'", "h_p_Cg_ContractTransportBillList"); } //æ·»å åå 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 = "0"; objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString()); objJsonResult.Message = "æåï¼"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¥è¯¢å表信æ¯å¤±è´¥ï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region å é¤ [Route("Cg_ContractTransportBillListController/DeleteBill")] [HttpGet] WebAPI/Controllers/NewApiController.cs
@@ -31,6 +31,17 @@ public ApiResult<DataSet> GetHbarCodeDetail(string sBillBarCode) { var model = YqnQbService.GetHbarCodeDetail(sBillBarCode); // éè¿model ä¸çdataæ¥å¤æ å·¥åå· æ¯å¦å±äºå¼å·¥ç¶æï¼å¦æå±äºå¼å·¥ç¶æï¼åæ¥é // string HProcExchBillStatus = model.data.Tables[0].Rows[0]["åæ®ç¶æ"]?.ToString(); // if(HProcExchBillStatus != null && HProcExchBillStatus != "3") // { // // åªæå¼å·¥ç¶æå 许çæåæ ·å // model.data = null; // model.code = 0; // model.count = 0; // model.msg = $"å·¥åï¼{model.data.Tables[0].Rows[0]["åæ®å·"].ToString()} ä¸ä¸ºå¼å·¥ç¶æ! ä¸å 许çæåæ ·å!"; // return model; // } return model; } /// <summary> WebAPI/Controllers/QC_ManagementController.cs
@@ -126,12 +126,12 @@ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Gy_QCCheckProjectList_Main order by æ¥æ desc ", "h_v_Gy_QCCheckProjectList_Main"); ds = oCN.RunProcReturn("select * from h_v_Gy_QCCheckProjectList_Main order by æ¥æ desc,åæ®å· DESC ", "h_v_Gy_QCCheckProjectList_Main"); } else { string sql1 = "select * from h_v_Gy_QCCheckProjectList_Main where 1=1"; string sql = sql1 + sWhere + " order by æ¥æ desc "; string sql = sql1 + sWhere + " order by æ¥æ desc,åæ®å· DESC "; ds = oCN.RunProcReturn(sql, "h_v_Gy_QCCheckProjectList_Main"); } } WebAPI/Controllers/SCGL/Sc_MESBeginWorkBillController.cs
@@ -465,7 +465,8 @@ /// <returns></returns> [Route("Sc_MESBeginWorkBill/SaveGetMESBeginWorkFrom_KS")] [HttpGet] public object SaveGetMESBeginWorkFrom_KS(string HBillType,int HSourceInterID,int HSourceEntryID,string HSourceBillNo,string user,string HSourceBillType) public object SaveGetMESBeginWorkFrom_KS(string HBillType,int HSourceInterID,int HSourceEntryID, string HSourceBillNo,string user,string HSourceBillType) { @@ -1618,7 +1619,8 @@ #region æ¥å·¥å¹³å°å¿«æ·å¼å·¥ [Route("Sc_MESBeginWorkBill/FastBeginWorkBill")] [HttpGet] public object FastBeginWorkBill(string HBillType, int HSourceInterID, int HSourceEntryID, string HSourceBillNo, string HSourceBillType,string user) public object FastBeginWorkBill(string HBillType, int HSourceInterID, int HSourceEntryID, string HSourceBillNo, string HSourceBillType,string user) { @@ -1675,7 +1677,7 @@ { ClsSc_MESBeginWorkBillMain.HWorkShiftID = int.Parse(set.Tables[0].Rows[0]["HInterID"].ToString()); } ds = oCN.RunProcReturn("select * from h_v_Cj_GetDefValByUser where ç¨æ·åç§°='" + user + "'", "h_v_xt_UserAssociationSelect"); ds = oCN.RunProcReturn("select * from h_v_Cj_GetDefValByUser where ç¨æ·åç§°='" + user + "'", "h_v_Cj_GetDefValByUser"); //if (ds.Tables[0].Rows[0]["HGroupID"].ToString() == "0") //{ @@ -1732,16 +1734,16 @@ bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); } //ds = oCN.RunProcReturn("select * from Sc_MESBeginWorkBillMain where HBillNo='" + oBill.omodel.HBillNo + "'", "Sc_MESBeginWorkBillMain"); //if (ds.Tables[0].Rows.Count == 0) //{ // oCN.RollBack(); // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æ¥æ åæ®!"; // objJsonResult.data = 1; // return objJsonResult; //} ds = oCN.RunProcReturn("select * from Sc_MESBeginWorkBillMain where HBillNo='" + oBill.omodel.HBillNo + "'", "Sc_MESBeginWorkBillMain"); if (ds.Tables[0].Rows.Count == 0) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¥æ åæ®!"; objJsonResult.data = 1; return objJsonResult; } string sAutoCheck = oClsXt_SystemParameter.GetSingleSystemParameter("Sc_MESBeginWorkBill_AutoCheck", ref DBUtility.ClsPub.sExeReturnInfo); if (sAutoCheck == "Y") WebAPI/Controllers/WebAPIController.cs
@@ -20473,7 +20473,7 @@ { objjson.code = "0"; objjson.count = 0; objjson.Message = "è·å失败" + ex.ToString(); objjson.Message = "è·å失败" + ex.Message.ToString(); objjson.data = null; return objjson; } WebAPI/Controllers/²Ö´æ¹ÜÀí/ÑéÊÕÈë¿â/Kf_ProductInBillController.cs
@@ -127,7 +127,7 @@ } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString()); objJsonResult.Message = "æåï¼"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; WebAPI/Controllers/ÌõÂë¹ÜÀí/MouldController.cs
@@ -599,6 +599,7 @@ BillNew.omodel.HYear = sYear; BillNew.omodel.HPeriod = sPeriod; BillNew.omodel.HBillType = "3802"; BillNew.omodel.HBillSubType = "3802"; BillNew.omodel.HInterID = mainList[0].HInterID; BillNew.omodel.HBillNo = mainList[0].HBillNo; BillNew.omodel.HDate = mainList[0].HDate; @@ -759,6 +760,7 @@ BillNew.omodel.HYear = sYear; BillNew.omodel.HPeriod = sPeriod; BillNew.omodel.HBillType = "3803"; BillNew.omodel.HBillSubType = "3803"; BillNew.omodel.HInterID = mainList[0].HInterID; BillNew.omodel.HBillNo = mainList[0].HBillNo; BillNew.omodel.HDate = mainList[0].HDate; WebAPI/Controllers/ÌõÂë¹ÜÀí/WEBSController.cs
@@ -20,6 +20,7 @@ namespace WebAPI.Controllers { public class WEBSController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus; @@ -1646,7 +1647,7 @@ { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ´æ°æ¡ç åºå ¥åºç¼åå表æ¡ç è®°å½å¤±è´¥ï¼" + e.ToString(); objJsonResult.Message = "æ´æ°æ¡ç åºå ¥åºç¼åå表æ¡ç è®°å½å¤±è´¥ï¼" + e.Message.ToString(); objJsonResult.data = null; return objJsonResult; } @@ -3033,6 +3034,7 @@ /// <returns></returns> [Route("WEBSController/set_SavePOStockInBill_Json")] [HttpPost] [Permission(HModName = "Kf_POStockInBill", Operate = "_Edit")] public object set_SavePOStockInBill_Json([FromBody] JObject oMain) { var _value = oMain["oMain"].ToString(); WebAPI/Controllers/ÎïÁ÷¹ÜÀí/³öÔ˵¥/WLYayBillController.cs
@@ -79,6 +79,62 @@ } #endregion #region åºè¿å å页å表2 [Route("WLYayBillController/page")] [HttpGet] public json page(string sWhere, string user, int page, int size, string Type) { try { List<object> columnNameList = new List<object>(); //å表è¿å ¥æ¶å¤ææéï¼éæºåè¿å ¥ä¸å¤ææé if (!DBUtility.ClsPub.Security_Log("WLYayBill_Query", 3, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¨æ²¡æè¯¥æ¨¡åæé,请ä¸ç®¡çåèç³»ï¼"; objJsonResult.data = null; return objJsonResult; } sWhere = sWhere.Replace("'", "''"); if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("exec h_p_WL_YayBill " + page + "," + size + ",'','" + Type + "'", "h_p_WL_YayBill"); } else { ds = oCN.RunProcReturn("exec h_p_WL_YayBill " + page + "," + size + ",'" + sWhere + "','" + Type + "'", "h_p_WL_YayBill"); } //æ·»å åå 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 = "0"; objJsonResult.count = int.Parse(ds.Tables[1].Rows[0]["count"].ToString()); objJsonResult.Message = "æåï¼"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¥è¯¢å表信æ¯å¤±è´¥ï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region åºè¿å æ ¹æ®æºåä¼ ç©æå表 [Route("WLYayBillController/GetMesByOrginBill")] [HttpGet] @@ -577,7 +633,7 @@ var HName = ds.Tables[0].Rows[0]["HName"].ToString(); var HIDCard = ds.Tables[0].Rows[0]["HIDCard"].ToString(); oCN.BeginTran(); oCN.RunProc("update WL_YayBillMain set HDriverID='" + HcheckID + "', DriverHName='" + HName + "', DriverHIDCard='" + HIDCard + "' where HInterID=" + HInterID); oCN.RunProc("update WL_YayBillMain set HDriverID='" + HcheckID + "', DriverHName='" + HName + "', DriverHIDCard='" + HIDCard + "',HDate_AllocationDriver=getdate() where HInterID=" + HInterID); oCN.Commit(); objJsonResult.code = "1"; @@ -816,9 +872,62 @@ } #endregion #region åºè¿å è·ååè¡¨æ°æ® [Route("WLYayBillController/GetList")] [HttpGet] public object GetList(string hmainid_hsubid, string user) { try { List<object> columnNameList = new List<object>(); if (!DBUtility.ClsPub.Security_Log("WLYayBill_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ æ¥çæéï¼"; objJsonResult.data = null; return objJsonResult; } string sql = $"select * from h_v_Gy_MaterialPackingRelation where hmainid_hsubid in (" + hmainid_hsubid + ")"; // æ§è¡æ¥è¯¢ DataSet ds = oCN.RunProcReturn(sql, "WL_YayBillMain"); //æ·»å åå 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/ÏîÄ¿¹ÜÀí/¹¤×÷ÈÎÎñ/PM_WorkTaskBillController.cs
@@ -13,6 +13,7 @@ using System.Threading.Tasks; using DLL; using SyntacticSugar.constant; using System.IO; namespace WebAPI.Controllers.项ç®ç®¡ç.å·¥ä½ä»»å¡ { @@ -1342,7 +1343,10 @@ public int HSourceEntryID; public string HSourceBillNo; public string HSourceBillType; public bool HFinishFlag; public bool HFinishFlag; public string HWeekProDays; // æ¬å¨æ¶è宿½äººå¤©(ç±»éé¢ä½¿ç¨stringåï¼åé¢è½¬å为decimal) public string HWeekReportFileName; // 人天åæä»¶åç§° public string HWeekReportFileAddr; // 人天åæä»¶è·¯å¾ } #endregion #region 任塿±æ¥ æ°å¢/ç¼è¾-ä¿å @@ -1604,7 +1608,9 @@ string HSourceBillNo = oSub.HSourceBillNo; string HSourceBillType = oSub.HSourceBillType; bool HFinishFlag = oSub.HFinishFlag; string HWeekProDays = oSub.HWeekProDays; string HWeekReportFileAddr = oSub.HWeekReportFileAddr; string HWeekReportFileName = oSub.HWeekReportFileName; if (HFinishFlag==true) { //夿忮æ¯å¦åå¨ @@ -1647,7 +1653,8 @@ string HTaskDescription = ds.Tables[0].Rows[0]["ä»»å¡æè¿°"].ToString(); //æå ¥å表sql string sql = "insert into PM_WorkTaskReportBillSub" + "(HInterID,HBillNo_bak,HEntryID,HRemark,HProjectID,HProNumber,HProjectStageID,HName,HTaskNote,HType,HRelTimes,HReportNote,HAdv,HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo,HFinishFlag) " + "(HInterID,HBillNo_bak,HEntryID,HRemark,HProjectID,HProNumber,HProjectStageID,HName,HTaskNote,HType,HRelTimes,HReportNote,HAdv,HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo,HFinishFlag " + ", HWeekProDays,HWeekReportFileName,HWeekReportFileAddr) " + "values(" + "" + HInterID + ",'" + HBillNo + @@ -1667,6 +1674,7 @@ ",'" + HSourceBillType + "','" + HSourceBillNo + "'," + DBUtility.ClsPub.BoolToString(HFinishFlag) + $",CONVERT(MONEY, '{HWeekProDays}'), '{HWeekReportFileName}', '{HWeekReportFileAddr}'" + ")"; oCN.RunProc(sql); string messageContext = "åæ®æ¥æ= " + HWorkTaskDate + ",æ±æ¥äºº=" + reportMan + ",æ±æ¥å 容=" + HReportNote +",ä»»å¡æè¿° ="+ HTaskDescription +",宿æ è®°="+ (HFinishFlag?"æ¯":"å¦") + ",èªè¯å·¥æ¶=" + HSelfTimes + "å°æ¶,èç¨å·¥æ¶=" + HRelTimes + "å°æ¶,ä»»å¡åç§°=" + HName + ",项ç®åç§°=" + HProjectName; ; @@ -4259,5 +4267,123 @@ // } //} //#endregion #region 任塿±æ¥ ä¸ä¼ 人天å [Route("PM_WorkTaskReportBill/UploadFile")] [HttpPost] public object UploadFile() { string HNumber = HttpContext.Current.Request.Params["HNumber"]; //人天åæä»¶å string HRemark = HttpContext.Current.Request.Params["HRemark"]; //夿³¨ string HUserName = HttpContext.Current.Request.Params["HUserName"]; //å建人 HttpPostedFile files = HttpContext.Current.Request.Files["file"]; string path = HttpContext.Current.Server.MapPath("~/../Files/WorkTaskReportBill/" + HNumber); dynamic dyResult = UpLoadFile(files, path, HNumber, HRemark, HUserName); if (dyResult != null && dyResult.result == 1) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "ä¸ä¼ æåï¼"; objJsonResult.data = "Files/WorkTaskReportBill/" + HNumber + "/"; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = dyResult.returnval; objJsonResult.data = null; return objJsonResult; } } public dynamic UpLoadFile(HttpPostedFile files, string path, string HNumber, string HRemark, string HUserName) { dynamic Result_Ob = new { result = 1, returnval = "ä¸ä¼ æåï¼" }; string filePath = Path.GetFullPath(files.FileName);//æä»¶ä¸ä¼ è·¯å¾ string fileExtension = Path.GetExtension(files.FileName);// æä»¶æ©å±å string filename = files.FileName;//æä»¶å string fileSavePath = path;// ä¸ä¼ ä¿åè·¯å¾ int filesize = files.ContentLength;//è·åä¸ä¼ æä»¶ç大å°åä½ä¸ºåèbyte int Maxsize = 40000 * 1024;//å®ä¹ä¸ä¼ æä»¶çæå¤§ç©ºé´å¤§å°ä¸º40M try { if (files == null || files.ContentLength <= 0) { Result_Ob = new { result = 0, returnval = "æä»¶ä¸è½ä¸ºç©º!" }; return Result_Ob; } if (filesize >= Maxsize) { Result_Ob = new { result = 0, returnval = "ä¸ä¼ æä»¶è¶ è¿40Mï¼ä¸è½ä¸ä¼ ï¼" }; return Result_Ob; } string fileurl = Path.Combine(fileSavePath, filename); if (Directory.Exists(fileurl) == true) //妿åå¨éåæä»¶å°±æç¤º { Result_Ob = new { result = 0, returnval = "åå¨ååæä»¶ï¼" }; return Result_Ob; } //å 餿°æ®è¡¨æ°æ® ds = oCN.RunProcReturn("delete from MES_AccessoriesList where HSourceBillNo ='" + HNumber + "' and HFileName='" + filename + "'", "MES_AccessoriesList"); if (Directory.Exists(path)) { File.Delete(fileurl); //å 餿宿件 files.SaveAs(fileurl); string StrPath = "/files/WorkTaskReportBill/" + HNumber + "/" + filename; if (File.Exists(fileurl)) { //è¿éå¯ä»¥æ§è¡ä¸äºå ¶å®çæä½ï¼æ¯å¦æ´æ°æ°æ®åº //åå ¥æ°æ®è¡¨ oCN.RunProc("Insert into MES_AccessoriesList (HFileName,HFilePath,HFilePath_Cus,HFileType" + ",HLoadMan,HLoadDate,HRemark,HVerNum,HFileSize" + ",HFileClsID,HSourceBillNo" + ") values('" + filename.ToString() + "','" + StrPath.ToString() + "','" + filePath.ToString() + "','" + fileExtension.ToString() + "'" + ",'" + HUserName + "',getdate(),'" + HRemark + "','V1','" + filesize + "','" + 0 + "','" + HNumber + "') "); } else { Result_Ob = new { result = 0, returnval = "ä¸ä¼ å¤±è´¥ï¼æ¤æä»¶ä¸ºæ¶ææä»¶" }; } } else { Directory.CreateDirectory(fileSavePath); //æ·»å æä»¶å¤¹ files.SaveAs(fileurl); string StrPath = "/files/WorkTaskReportBill/" + HNumber + "/" + filename; if (File.Exists(fileurl)) { //è¿éå¯ä»¥æ§è¡ä¸äºå ¶å®çæä½ï¼æ¯å¦æ´æ°æ°æ®åº //åå ¥æ°æ®è¡¨ oCN.RunProc("Insert into MES_AccessoriesList (HFileName,HFilePath,HFilePath_Cus,HFileType" + ",HLoadMan,HLoadDate,HRemark,HVerNum,HFileSize" + ",HFileClsID,HSourceBillNo" + ") values('" + filename.ToString() + "','" + StrPath.ToString() + "','" + filePath.ToString() + "','" + fileExtension.ToString() + "'" + ",'" + HUserName + "',getdate(),'" + HRemark + "','V1','" + filesize + "','" + 0 + "','" + HNumber + "') "); } else { Result_Ob = new { result = 0, returnval = "ä¸ä¼ å¤±è´¥ï¼æ¤æä»¶ä¸ºæ¶ææä»¶" }; } } } catch (Exception e) { Result_Ob = new { result = 0, returnval = e.Message }; } return Result_Ob; } #endregion } } WebAPI/Properties/PublishProfiles/FolderProfile2.pubxml.user
@@ -5,11 +5,11 @@ <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <PropertyGroup> <_PublishTargetUrl>D:\ç½ç«åå¸\æºäºMESWMS\API</_PublishTargetUrl> <History>True|2026-03-27T06:26:07.9321307Z;False|2026-03-27T14:25:22.5010392+08:00;True|2026-03-27T13:35:36.8292396+08:00;False|2026-03-27T13:31:46.3527084+08:00;True|2026-03-24T15:10:02.2143243+08:00;True|2026-03-24T14:44:30.5286229+08:00;True|2026-03-24T10:24:40.8361153+08:00;False|2026-03-24T10:23:42.4160796+08:00;True|2026-03-23T19:05:41.2442007+08:00;False|2026-03-23T19:05:02.6358374+08:00;True|2026-03-23T15:35:21.7391934+08:00;False|2026-03-23T15:33:14.3621736+08:00;True|2026-03-21T11:27:25.8485662+08:00;True|2026-03-21T10:51:07.0416520+08:00;False|2026-03-21T10:50:30.0808809+08:00;True|2026-03-20T15:21:25.3928861+08:00;False|2026-03-20T15:20:18.7323151+08:00;True|2026-03-19T17:53:04.0599612+08:00;False|2026-03-19T17:49:34.2586338+08:00;True|2026-03-18T16:36:39.3459012+08:00;False|2026-03-18T16:33:44.2834015+08:00;True|2026-03-18T09:14:46.8169365+08:00;False|2026-03-18T09:11:29.5956354+08:00;True|2026-03-17T21:02:32.6298438+08:00;False|2026-03-17T21:01:51.7259809+08:00;True|2026-03-17T17:42:17.6095943+08:00;True|2026-03-17T17:22:22.7829010+08:00;True|2026-03-17T17:07:30.0424197+08:00;True|2026-03-17T17:00:25.9496446+08:00;True|2026-03-17T16:57:34.7454437+08:00;False|2026-03-17T16:55:25.6389756+08:00;True|2026-03-16T17:53:15.9567970+08:00;False|2026-03-16T17:52:38.5476276+08:00;True|2026-03-14T17:08:45.9696477+08:00;False|2026-03-14T17:07:54.0759419+08:00;True|2026-03-13T15:56:58.9781226+08:00;True|2026-03-13T14:54:12.0380800+08:00;True|2026-03-13T14:45:10.9471893+08:00;True|2026-03-13T14:34:35.7792308+08:00;True|2026-03-13T13:28:54.0165676+08:00;True|2026-03-13T13:04:26.7960852+08:00;True|2026-03-13T12:32:40.4056776+08:00;True|2026-03-13T12:00:38.5403236+08:00;True|2026-03-13T11:58:15.7212751+08:00;False|2026-03-13T11:56:03.1608711+08:00;True|2026-03-12T12:56:09.1798557+08:00;True|2026-03-12T12:10:38.6579078+08:00;True|2026-03-12T12:00:41.1216693+08:00;True|2026-03-12T10:49:25.6657932+08:00;True|2026-03-12T10:34:42.0132081+08:00;False|2026-03-12T10:34:21.1374537+08:00;True|2026-03-12T09:49:04.2791476+08:00;False|2026-03-12T09:48:32.0226441+08:00;True|2026-03-11T21:37:22.2202127+08:00;False|2026-03-11T21:35:48.4959239+08:00;True|2026-03-11T20:47:52.7636338+08:00;False|2026-03-11T20:47:20.3374534+08:00;True|2026-03-10T09:03:48.7681627+08:00;False|2026-03-10T09:02:36.0583806+08:00;True|2026-03-09T22:57:55.3577018+08:00;False|2026-03-09T22:55:54.8997804+08:00;True|2026-03-09T17:08:10.5420450+08:00;True|2026-03-09T16:57:28.4177680+08:00;True|2026-03-09T16:50:59.8251070+08:00;True|2026-03-09T10:23:55.4999880+08:00;False|2026-03-09T10:23:00.0281682+08:00;True|2026-03-06T09:15:06.5024218+08:00;True|2026-03-06T08:54:38.7087070+08:00;False|2026-03-06T08:53:23.6823346+08:00;True|2026-03-05T17:26:43.5908847+08:00;False|2026-03-05T17:25:48.2804326+08:00;True|2026-03-05T16:04:43.1077406+08:00;False|2026-03-05T16:02:11.7881116+08:00;True|2026-03-03T16:16:26.8635275+08:00;True|2026-03-03T15:54:24.2283621+08:00;True|2026-03-03T12:32:30.4495356+08:00;False|2026-03-03T12:31:06.0560910+08:00;True|2026-03-02T12:18:24.6587456+08:00;True|2026-03-02T09:35:22.6172462+08:00;False|2026-03-02T09:32:04.1416982+08:00;True|2026-02-28T12:04:01.7406133+08:00;True|2026-02-28T08:47:36.7167331+08:00;False|2026-02-28T08:46:49.1748795+08:00;True|2026-02-27T17:21:35.6897064+08:00;True|2026-02-27T17:00:03.2447893+08:00;True|2026-02-27T14:26:49.0714379+08:00;True|2026-02-27T13:57:50.9161682+08:00;False|2026-02-27T13:54:58.3092086+08:00;True|2026-02-26T16:30:22.6331887+08:00;True|2026-02-26T15:56:54.4778359+08:00;False|2026-02-26T15:55:53.2808802+08:00;False|2026-02-26T15:55:27.7501008+08:00;True|2026-02-26T12:42:10.3734658+08:00;True|2026-02-26T12:01:13.4363491+08:00;True|2026-02-26T10:24:02.2555254+08:00;True|2026-02-03T11:56:14.3086755+08:00;True|2026-02-03T11:51:19.6091315+08:00;True|2026-02-03T10:42:35.4774950+08:00;False|2026-02-03T10:40:57.1735351+08:00;True|2026-02-03T09:30:22.5235073+08:00;False|2026-02-03T09:27:21.6917147+08:00;True|2026-02-02T15:31:07.3762944+08:00;True|2026-02-02T14:13:20.5690146+08:00;True|2026-02-02T10:42:22.4804584+08:00;False|2026-02-02T10:41:48.7402434+08:00;True|2026-02-01T17:40:21.0538069+08:00;True|2026-02-01T15:44:12.2393909+08:00;False|2026-02-01T15:40:37.6456544+08:00;True|2026-01-31T12:05:50.6946479+08:00;False|2026-01-31T12:04:44.5273342+08:00;True|2026-01-29T17:14:07.3795568+08:00;True|2026-01-29T17:11:48.4286289+08:00;True|2026-01-29T16:10:42.7141082+08:00;True|2026-01-29T14:41:38.0583611+08:00;True|2026-01-29T14:36:18.1975177+08:00;True|2026-01-29T14:34:43.7423264+08:00;True|2026-01-29T14:09:16.2701844+08:00;True|2026-01-29T13:17:37.0708838+08:00;True|2026-01-29T10:21:51.3074443+08:00;False|2026-01-29T10:20:12.1418198+08:00;True|2026-01-28T13:52:59.2210650+08:00;True|2026-01-28T10:34:06.8152564+08:00;False|2026-01-28T10:32:51.4478083+08:00;True|2026-01-27T12:19:58.2090999+08:00;True|2026-01-27T12:18:40.9255150+08:00;True|2026-01-27T12:10:45.0784359+08:00;True|2026-01-27T11:45:58.2218602+08:00;True|2026-01-27T08:54:11.2473398+08:00;False|2026-01-27T08:50:52.3900508+08:00;True|2026-01-25T16:51:10.8469862+08:00;True|2026-01-25T16:15:55.3063785+08:00;False|2026-01-25T16:13:47.1609576+08:00;False|2026-01-25T16:10:27.3797138+08:00;True|2026-01-22T19:26:11.1120981+08:00;False|2026-01-22T19:21:59.7591077+08:00;True|2026-01-21T20:10:38.2264542+08:00;True|2026-01-21T20:05:52.6769930+08:00;False|2026-01-21T20:04:52.2864808+08:00;True|2026-01-20T10:09:22.6558754+08:00;True|2026-01-20T09:43:16.9535139+08:00;False|2026-01-20T09:40:14.5080297+08:00;True|2026-01-19T17:23:36.9963060+08:00;True|2026-01-19T17:18:41.7602029+08:00;True|2026-01-19T17:05:35.1663057+08:00;True|2026-01-19T16:49:48.9497194+08:00;True|2026-01-19T12:35:09.4063486+08:00;False|2026-01-19T12:33:25.3260660+08:00;True|2026-01-17T20:21:42.3497625+08:00;True|2026-01-17T20:17:40.8631870+08:00;True|2026-01-17T20:13:16.6618986+08:00;False|2026-01-17T20:10:39.7099356+08:00;False|2026-01-17T20:10:01.5198461+08:00;False|2026-01-17T20:09:07.5632818+08:00;True|2026-01-17T20:06:07.7085249+08:00;True|2026-01-17T17:50:38.6295526+08:00;False|2026-01-17T17:48:59.9531552+08:00;True|2026-01-16T16:22:22.3525933+08:00;True|2026-01-16T14:14:39.4187185+08:00;False|2026-01-16T14:10:47.6350779+08:00;True|2026-01-15T17:33:04.8867687+08:00;True|2026-01-15T17:13:07.4827420+08:00;False|2026-01-15T17:11:32.8298249+08:00;True|2026-01-15T16:34:04.8984638+08:00;True|2026-01-15T14:12:39.3677563+08:00;False|2026-01-15T14:10:25.0842475+08:00;True|2026-01-14T19:47:01.2486856+08:00;False|2026-01-14T19:46:15.5380497+08:00;True|2026-01-14T15:49:22.6528911+08:00;True|2026-01-14T10:24:06.5942562+08:00;False|2026-01-14T10:22:32.4884475+08:00;False|2026-01-12T09:27:01.9297704+08:00;True|2026-01-11T14:27:58.9407325+08:00;False|2026-01-11T14:26:47.1324504+08:00;True|2026-01-11T13:54:38.7697615+08:00;True|2026-01-11T12:39:56.1396008+08:00;False|2026-01-11T12:37:59.5059421+08:00;True|2026-01-09T15:34:00.7959753+08:00;False|2026-01-09T15:32:33.3223847+08:00;True|2026-01-09T10:27:04.4418230+08:00;False|2026-01-09T10:24:55.6104648+08:00;True|2026-01-08T18:05:09.8950096+08:00;False|2026-01-08T18:03:49.6828377+08:00;True|2026-01-08T15:53:31.8458993+08:00;True|2026-01-08T15:43:35.4452984+08:00;True|2026-01-08T15:16:09.2797564+08:00;True|2026-01-08T15:09:12.1761272+08:00;False|2026-01-08T15:08:31.8053125+08:00;True|2026-01-08T12:28:32.3839432+08:00;False|2026-01-08T12:28:06.4930402+08:00;False|2026-01-06T13:05:41.4537127+08:00;True|2026-01-04T11:27:03.6003486+08:00;True|2026-01-04T11:16:09.0856233+08:00;True|2026-01-04T11:09:33.9721372+08:00;True|2026-01-04T10:59:57.5111892+08:00;False|2026-01-04T10:57:57.5312203+08:00;True|2025-12-30T14:23:14.0889784+08:00;True|2025-12-29T09:12:05.7081903+08:00;False|2025-12-29T09:11:27.9082848+08:00;True|2025-07-01T16:53:57.8492332+08:00;True|2025-07-01T16:14:28.8419744+08:00;True|2025-07-01T15:15:43.3121091+08:00;True|2025-07-01T14:48:00.3454856+08:00;True|2025-07-01T09:17:46.2541717+08:00;False|2025-07-01T09:17:07.0648196+08:00;True|2025-06-23T14:30:28.6691264+08:00;False|2025-06-23T14:27:45.6002040+08:00;True|2025-06-23T11:02:08.3020700+08:00;True|2025-06-23T10:47:44.4654541+08:00;True|2025-06-23T09:46:24.9049910+08:00;False|2025-06-23T09:45:40.5195919+08:00;True|2025-06-20T14:33:10.9210583+08:00;True|2025-06-20T13:22:54.5321865+08:00;False|2025-06-20T13:21:30.8643897+08:00;True|2025-06-20T08:36:32.6695266+08:00;False|2025-06-20T08:35:57.8274069+08:00;True|2025-06-19T08:14:35.0623669+08:00;False|2025-06-19T08:12:57.2451557+08:00;True|2025-06-18T16:56:03.4555368+08:00;True|2025-06-18T16:42:43.2441845+08:00;False|2025-06-18T16:42:02.6907205+08:00;True|2025-06-16T16:13:03.2956026+08:00;False|2025-06-16T16:12:23.8438917+08:00;True|2025-06-16T15:21:32.7370852+08:00;True|2025-06-16T15:08:57.7166003+08:00;True|2025-06-16T14:02:18.4224630+08:00;True|2025-06-16T11:00:03.6375429+08:00;False|2025-06-16T10:59:26.0956296+08:00;True|2025-06-09T16:45:52.0865612+08:00;True|2025-06-09T16:38:47.2182194+08:00;True|2025-06-09T16:17:50.9170601+08:00;False|2025-06-09T16:17:43.0333396+08:00;True|2025-06-09T15:25:17.0429161+08:00;True|2025-06-09T15:00:15.0058791+08:00;True|2025-06-09T14:50:02.1370115+08:00;True|2025-06-09T14:38:10.9037045+08:00;True|2025-06-09T14:34:53.2826267+08:00;True|2025-06-09T14:07:24.5341951+08:00;True|2025-06-09T13:39:17.5042542+08:00;True|2025-06-09T09:30:31.8197114+08:00;True|2025-01-10T13:10:47.2046185+08:00;True|2025-01-10T11:11:49.4016910+08:00;True|2025-01-10T10:59:12.3481721+08:00;False|2025-01-10T10:58:24.5033898+08:00;True|2025-01-04T14:35:42.2792864+08:00;</History> <History>True|2026-04-01T03:48:50.5292235Z;True|2026-04-01T11:38:01.4330956+08:00;True|2026-04-01T11:10:56.0438060+08:00;False|2026-04-01T11:10:46.7232028+08:00;True|2026-04-01T10:56:38.9083881+08:00;False|2026-04-01T10:56:07.7574345+08:00;True|2026-03-27T14:26:07.9321307+08:00;False|2026-03-27T14:25:22.5010392+08:00;True|2026-03-27T13:35:36.8292396+08:00;False|2026-03-27T13:31:46.3527084+08:00;True|2026-03-24T15:10:02.2143243+08:00;True|2026-03-24T14:44:30.5286229+08:00;True|2026-03-24T10:24:40.8361153+08:00;False|2026-03-24T10:23:42.4160796+08:00;True|2026-03-23T19:05:41.2442007+08:00;False|2026-03-23T19:05:02.6358374+08:00;True|2026-03-23T15:35:21.7391934+08:00;False|2026-03-23T15:33:14.3621736+08:00;True|2026-03-21T11:27:25.8485662+08:00;True|2026-03-21T10:51:07.0416520+08:00;False|2026-03-21T10:50:30.0808809+08:00;True|2026-03-20T15:21:25.3928861+08:00;False|2026-03-20T15:20:18.7323151+08:00;True|2026-03-19T17:53:04.0599612+08:00;False|2026-03-19T17:49:34.2586338+08:00;True|2026-03-18T16:36:39.3459012+08:00;False|2026-03-18T16:33:44.2834015+08:00;True|2026-03-18T09:14:46.8169365+08:00;False|2026-03-18T09:11:29.5956354+08:00;True|2026-03-17T21:02:32.6298438+08:00;False|2026-03-17T21:01:51.7259809+08:00;True|2026-03-17T17:42:17.6095943+08:00;True|2026-03-17T17:22:22.7829010+08:00;True|2026-03-17T17:07:30.0424197+08:00;True|2026-03-17T17:00:25.9496446+08:00;True|2026-03-17T16:57:34.7454437+08:00;False|2026-03-17T16:55:25.6389756+08:00;True|2026-03-16T17:53:15.9567970+08:00;False|2026-03-16T17:52:38.5476276+08:00;True|2026-03-14T17:08:45.9696477+08:00;False|2026-03-14T17:07:54.0759419+08:00;True|2026-03-13T15:56:58.9781226+08:00;True|2026-03-13T14:54:12.0380800+08:00;True|2026-03-13T14:45:10.9471893+08:00;True|2026-03-13T14:34:35.7792308+08:00;True|2026-03-13T13:28:54.0165676+08:00;True|2026-03-13T13:04:26.7960852+08:00;True|2026-03-13T12:32:40.4056776+08:00;True|2026-03-13T12:00:38.5403236+08:00;True|2026-03-13T11:58:15.7212751+08:00;False|2026-03-13T11:56:03.1608711+08:00;True|2026-03-12T12:56:09.1798557+08:00;True|2026-03-12T12:10:38.6579078+08:00;True|2026-03-12T12:00:41.1216693+08:00;True|2026-03-12T10:49:25.6657932+08:00;True|2026-03-12T10:34:42.0132081+08:00;False|2026-03-12T10:34:21.1374537+08:00;True|2026-03-12T09:49:04.2791476+08:00;False|2026-03-12T09:48:32.0226441+08:00;True|2026-03-11T21:37:22.2202127+08:00;False|2026-03-11T21:35:48.4959239+08:00;True|2026-03-11T20:47:52.7636338+08:00;False|2026-03-11T20:47:20.3374534+08:00;True|2026-03-10T09:03:48.7681627+08:00;False|2026-03-10T09:02:36.0583806+08:00;True|2026-03-09T22:57:55.3577018+08:00;False|2026-03-09T22:55:54.8997804+08:00;True|2026-03-09T17:08:10.5420450+08:00;True|2026-03-09T16:57:28.4177680+08:00;True|2026-03-09T16:50:59.8251070+08:00;True|2026-03-09T10:23:55.4999880+08:00;False|2026-03-09T10:23:00.0281682+08:00;True|2026-03-06T09:15:06.5024218+08:00;True|2026-03-06T08:54:38.7087070+08:00;False|2026-03-06T08:53:23.6823346+08:00;True|2026-03-05T17:26:43.5908847+08:00;False|2026-03-05T17:25:48.2804326+08:00;True|2026-03-05T16:04:43.1077406+08:00;False|2026-03-05T16:02:11.7881116+08:00;True|2026-03-03T16:16:26.8635275+08:00;True|2026-03-03T15:54:24.2283621+08:00;True|2026-03-03T12:32:30.4495356+08:00;False|2026-03-03T12:31:06.0560910+08:00;True|2026-03-02T12:18:24.6587456+08:00;True|2026-03-02T09:35:22.6172462+08:00;False|2026-03-02T09:32:04.1416982+08:00;True|2026-02-28T12:04:01.7406133+08:00;True|2026-02-28T08:47:36.7167331+08:00;False|2026-02-28T08:46:49.1748795+08:00;True|2026-02-27T17:21:35.6897064+08:00;True|2026-02-27T17:00:03.2447893+08:00;True|2026-02-27T14:26:49.0714379+08:00;True|2026-02-27T13:57:50.9161682+08:00;False|2026-02-27T13:54:58.3092086+08:00;True|2026-02-26T16:30:22.6331887+08:00;True|2026-02-26T15:56:54.4778359+08:00;False|2026-02-26T15:55:53.2808802+08:00;False|2026-02-26T15:55:27.7501008+08:00;True|2026-02-26T12:42:10.3734658+08:00;True|2026-02-26T12:01:13.4363491+08:00;True|2026-02-26T10:24:02.2555254+08:00;True|2026-02-03T11:56:14.3086755+08:00;True|2026-02-03T11:51:19.6091315+08:00;True|2026-02-03T10:42:35.4774950+08:00;False|2026-02-03T10:40:57.1735351+08:00;True|2026-02-03T09:30:22.5235073+08:00;False|2026-02-03T09:27:21.6917147+08:00;True|2026-02-02T15:31:07.3762944+08:00;True|2026-02-02T14:13:20.5690146+08:00;True|2026-02-02T10:42:22.4804584+08:00;False|2026-02-02T10:41:48.7402434+08:00;True|2026-02-01T17:40:21.0538069+08:00;True|2026-02-01T15:44:12.2393909+08:00;False|2026-02-01T15:40:37.6456544+08:00;True|2026-01-31T12:05:50.6946479+08:00;False|2026-01-31T12:04:44.5273342+08:00;True|2026-01-29T17:14:07.3795568+08:00;True|2026-01-29T17:11:48.4286289+08:00;True|2026-01-29T16:10:42.7141082+08:00;True|2026-01-29T14:41:38.0583611+08:00;True|2026-01-29T14:36:18.1975177+08:00;True|2026-01-29T14:34:43.7423264+08:00;True|2026-01-29T14:09:16.2701844+08:00;True|2026-01-29T13:17:37.0708838+08:00;True|2026-01-29T10:21:51.3074443+08:00;False|2026-01-29T10:20:12.1418198+08:00;True|2026-01-28T13:52:59.2210650+08:00;True|2026-01-28T10:34:06.8152564+08:00;False|2026-01-28T10:32:51.4478083+08:00;True|2026-01-27T12:19:58.2090999+08:00;True|2026-01-27T12:18:40.9255150+08:00;True|2026-01-27T12:10:45.0784359+08:00;True|2026-01-27T11:45:58.2218602+08:00;True|2026-01-27T08:54:11.2473398+08:00;False|2026-01-27T08:50:52.3900508+08:00;True|2026-01-25T16:51:10.8469862+08:00;True|2026-01-25T16:15:55.3063785+08:00;False|2026-01-25T16:13:47.1609576+08:00;False|2026-01-25T16:10:27.3797138+08:00;True|2026-01-22T19:26:11.1120981+08:00;False|2026-01-22T19:21:59.7591077+08:00;True|2026-01-21T20:10:38.2264542+08:00;True|2026-01-21T20:05:52.6769930+08:00;False|2026-01-21T20:04:52.2864808+08:00;True|2026-01-20T10:09:22.6558754+08:00;True|2026-01-20T09:43:16.9535139+08:00;False|2026-01-20T09:40:14.5080297+08:00;True|2026-01-19T17:23:36.9963060+08:00;True|2026-01-19T17:18:41.7602029+08:00;True|2026-01-19T17:05:35.1663057+08:00;True|2026-01-19T16:49:48.9497194+08:00;True|2026-01-19T12:35:09.4063486+08:00;False|2026-01-19T12:33:25.3260660+08:00;True|2026-01-17T20:21:42.3497625+08:00;True|2026-01-17T20:17:40.8631870+08:00;True|2026-01-17T20:13:16.6618986+08:00;False|2026-01-17T20:10:39.7099356+08:00;False|2026-01-17T20:10:01.5198461+08:00;False|2026-01-17T20:09:07.5632818+08:00;True|2026-01-17T20:06:07.7085249+08:00;True|2026-01-17T17:50:38.6295526+08:00;False|2026-01-17T17:48:59.9531552+08:00;True|2026-01-16T16:22:22.3525933+08:00;True|2026-01-16T14:14:39.4187185+08:00;False|2026-01-16T14:10:47.6350779+08:00;True|2026-01-15T17:33:04.8867687+08:00;True|2026-01-15T17:13:07.4827420+08:00;False|2026-01-15T17:11:32.8298249+08:00;True|2026-01-15T16:34:04.8984638+08:00;True|2026-01-15T14:12:39.3677563+08:00;False|2026-01-15T14:10:25.0842475+08:00;True|2026-01-14T19:47:01.2486856+08:00;False|2026-01-14T19:46:15.5380497+08:00;True|2026-01-14T15:49:22.6528911+08:00;True|2026-01-14T10:24:06.5942562+08:00;False|2026-01-14T10:22:32.4884475+08:00;False|2026-01-12T09:27:01.9297704+08:00;True|2026-01-11T14:27:58.9407325+08:00;False|2026-01-11T14:26:47.1324504+08:00;True|2026-01-11T13:54:38.7697615+08:00;True|2026-01-11T12:39:56.1396008+08:00;False|2026-01-11T12:37:59.5059421+08:00;True|2026-01-09T15:34:00.7959753+08:00;False|2026-01-09T15:32:33.3223847+08:00;True|2026-01-09T10:27:04.4418230+08:00;False|2026-01-09T10:24:55.6104648+08:00;True|2026-01-08T18:05:09.8950096+08:00;False|2026-01-08T18:03:49.6828377+08:00;True|2026-01-08T15:53:31.8458993+08:00;True|2026-01-08T15:43:35.4452984+08:00;True|2026-01-08T15:16:09.2797564+08:00;True|2026-01-08T15:09:12.1761272+08:00;False|2026-01-08T15:08:31.8053125+08:00;True|2026-01-08T12:28:32.3839432+08:00;False|2026-01-08T12:28:06.4930402+08:00;False|2026-01-06T13:05:41.4537127+08:00;True|2026-01-04T11:27:03.6003486+08:00;True|2026-01-04T11:16:09.0856233+08:00;True|2026-01-04T11:09:33.9721372+08:00;True|2026-01-04T10:59:57.5111892+08:00;False|2026-01-04T10:57:57.5312203+08:00;True|2025-12-30T14:23:14.0889784+08:00;True|2025-12-29T09:12:05.7081903+08:00;False|2025-12-29T09:11:27.9082848+08:00;True|2025-07-01T16:53:57.8492332+08:00;True|2025-07-01T16:14:28.8419744+08:00;True|2025-07-01T15:15:43.3121091+08:00;True|2025-07-01T14:48:00.3454856+08:00;True|2025-07-01T09:17:46.2541717+08:00;False|2025-07-01T09:17:07.0648196+08:00;True|2025-06-23T14:30:28.6691264+08:00;False|2025-06-23T14:27:45.6002040+08:00;True|2025-06-23T11:02:08.3020700+08:00;True|2025-06-23T10:47:44.4654541+08:00;True|2025-06-23T09:46:24.9049910+08:00;False|2025-06-23T09:45:40.5195919+08:00;True|2025-06-20T14:33:10.9210583+08:00;True|2025-06-20T13:22:54.5321865+08:00;False|2025-06-20T13:21:30.8643897+08:00;True|2025-06-20T08:36:32.6695266+08:00;False|2025-06-20T08:35:57.8274069+08:00;True|2025-06-19T08:14:35.0623669+08:00;False|2025-06-19T08:12:57.2451557+08:00;True|2025-06-18T16:56:03.4555368+08:00;True|2025-06-18T16:42:43.2441845+08:00;False|2025-06-18T16:42:02.6907205+08:00;True|2025-06-16T16:13:03.2956026+08:00;False|2025-06-16T16:12:23.8438917+08:00;True|2025-06-16T15:21:32.7370852+08:00;True|2025-06-16T15:08:57.7166003+08:00;True|2025-06-16T14:02:18.4224630+08:00;True|2025-06-16T11:00:03.6375429+08:00;False|2025-06-16T10:59:26.0956296+08:00;True|2025-06-09T16:45:52.0865612+08:00;True|2025-06-09T16:38:47.2182194+08:00;True|2025-06-09T16:17:50.9170601+08:00;False|2025-06-09T16:17:43.0333396+08:00;True|2025-06-09T15:25:17.0429161+08:00;True|2025-06-09T15:00:15.0058791+08:00;True|2025-06-09T14:50:02.1370115+08:00;True|2025-06-09T14:38:10.9037045+08:00;True|2025-06-09T14:34:53.2826267+08:00;True|2025-06-09T14:07:24.5341951+08:00;True|2025-06-09T13:39:17.5042542+08:00;True|2025-06-09T09:30:31.8197114+08:00;True|2025-01-10T13:10:47.2046185+08:00;True|2025-01-10T11:11:49.4016910+08:00;True|2025-01-10T10:59:12.3481721+08:00;False|2025-01-10T10:58:24.5033898+08:00;True|2025-01-04T14:35:42.2792864+08:00;</History> </PropertyGroup> <ItemGroup> <File Include="apiapp.json"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="bin/AlibabaCloud.EndpointUtil.dll"> <publishTime>04/07/2020 16:33:48</publishTime> @@ -45,40 +45,40 @@ <publishTime>02/22/2013 16:43:40</publishTime> </File> <File Include="bin/BLL.dll"> <publishTime>03/27/2026 14:34:48</publishTime> <publishTime>04/01/2026 11:48:11</publishTime> </File> <File Include="bin/BLL.pdb"> <publishTime>03/27/2026 14:34:48</publishTime> <publishTime>04/01/2026 11:48:11</publishTime> </File> <File Include="bin/BouncyCastle.Crypto.dll"> <publishTime>12/18/2020 05:32:28</publishTime> </File> <File Include="bin/DAL.dll"> <publishTime>03/27/2026 14:34:45</publishTime> <publishTime>04/01/2026 11:48:09</publishTime> </File> <File Include="bin/DAL.pdb"> <publishTime>03/27/2026 14:34:45</publishTime> <publishTime>04/01/2026 11:48:09</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 22:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> <publishTime>03/27/2026 13:33:24</publishTime> <publishTime>04/01/2026 11:48:05</publishTime> </File> <File Include="bin/DBUtility.pdb"> <publishTime>03/27/2026 13:33:24</publishTime> <publishTime>04/01/2026 11:48:05</publishTime> </File> <File Include="bin/Fleck.dll"> <publishTime>04/22/2021 11:48:12</publishTime> </File> <File Include="bin/GetuiServerApiSDK.dll"> <publishTime>01/19/2026 18:29:10</publishTime> <publishTime>01/27/2026 10:11:35</publishTime> </File> <File Include="bin/GetuiServerApiSDK.dll.config"> <publishTime>01/19/2026 18:29:10</publishTime> <publishTime>01/27/2026 10:11:35</publishTime> </File> <File Include="bin/Google.ProtocolBuffers.dll"> <publishTime>01/19/2026 18:29:10</publishTime> <publishTime>01/27/2026 10:11:35</publishTime> </File> <File Include="bin/Grpc.Core.Api.dll"> <publishTime>03/22/2022 13:17:26</publishTime> @@ -105,7 +105,7 @@ <publishTime>05/09/2021 01:08:30</publishTime> </File> <File Include="bin/Kingdee.BOS.WebApi.Client.dll"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="bin/libgrpc_csharp_ext.x64.dylib"> <publishTime>03/19/2022 07:38:44</publishTime> @@ -150,13 +150,13 @@ <publishTime>07/25/2012 19:48:56</publishTime> </File> <File Include="bin/Model.dll"> <publishTime>03/27/2026 13:33:46</publishTime> <publishTime>04/01/2026 11:48:06</publishTime> </File> <File Include="bin/Model.pdb"> <publishTime>03/27/2026 13:33:46</publishTime> <publishTime>04/01/2026 11:48:06</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="bin/Newtonsoft.Json.dll"> <publishTime>03/08/2023 15:09:56</publishTime> @@ -189,34 +189,34 @@ <publishTime>11/13/2012 20:19:34</publishTime> </File> <File Include="bin/Pub_Class.dll"> <publishTime>03/27/2026 13:33:06</publishTime> <publishTime>04/01/2026 11:48:03</publishTime> </File> <File Include="bin/Pub_Class.pdb"> <publishTime>03/27/2026 13:33:06</publishTime> <publishTime>04/01/2026 11:48:03</publishTime> </File> <File Include="bin/Pub_Control.dll"> <publishTime>03/27/2026 13:33:15</publishTime> <publishTime>04/01/2026 11:48:04</publishTime> </File> <File Include="bin/Pub_Control.pdb"> <publishTime>03/27/2026 13:33:15</publishTime> <publishTime>04/01/2026 11:48:04</publishTime> </File> <File Include="bin/RestSharp.dll"> <publishTime>08/31/2012 06:22:50</publishTime> </File> <File Include="bin/SQLHelper.dll"> <publishTime>03/27/2026 13:33:17</publishTime> <publishTime>04/01/2026 11:48:04</publishTime> </File> <File Include="bin/SQLHelper.pdb"> <publishTime>03/27/2026 13:33:17</publishTime> <publishTime>04/01/2026 11:48:04</publishTime> </File> <File Include="bin/Swashbuckle.Core.dll"> <publishTime>02/16/2015 01:57:08</publishTime> </File> <File Include="bin/SyntacticSugar.dll"> <publishTime>03/25/2026 10:40:27</publishTime> <publishTime>04/01/2026 11:48:02</publishTime> </File> <File Include="bin/SyntacticSugar.pdb"> <publishTime>03/25/2026 10:40:27</publishTime> <publishTime>04/01/2026 11:48:02</publishTime> </File> <File Include="bin/System.Buffers.dll"> <publishTime>07/19/2017 18:01:28</publishTime> @@ -297,7 +297,7 @@ <publishTime>01/28/2015 12:03:16</publishTime> </File> <File Include="bin/System.Web.Http.WebHost.dll"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="bin/System.Web.Mvc.dll"> <publishTime>01/28/2015 12:02:18</publishTime> @@ -330,19 +330,19 @@ <publishTime>05/09/2023 10:43:40</publishTime> </File> <File Include="bin/TopSdk.dll"> <publishTime>03/25/2026 10:40:27</publishTime> <publishTime>04/01/2026 11:48:05</publishTime> </File> <File Include="bin/TopSdk.pdb"> <publishTime>03/25/2026 10:40:27</publishTime> <publishTime>04/01/2026 11:48:05</publishTime> </File> <File Include="bin/WebActivatorEx.dll"> <publishTime>11/24/2014 19:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> <publishTime>03/27/2026 14:49:17</publishTime> <publishTime>04/01/2026 11:48:20</publishTime> </File> <File Include="bin/WebAPI.pdb"> <publishTime>03/27/2026 14:49:17</publishTime> <publishTime>04/01/2026 11:48:20</publishTime> </File> <File Include="bin/WebAPI.XmlSerializers.dll"> <publishTime>07/01/2025 16:53:56</publishTime> @@ -372,61 +372,61 @@ <publishTime>11/29/2018 21:26:30</publishTime> </File> <File Include="Config/kdapi.config"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:01</publishTime> </File> <File Include="Content/bootstrap.css"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:01</publishTime> </File> <File Include="Content/bootstrap.min.css"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:01</publishTime> </File> <File Include="Content/Site.css"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:01</publishTime> </File> <File Include="DLL/BLL.dll"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="DLL/DAL.dll"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="DLL/DBUtility.dll"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="DLL/Interop.grsvr6Lib.dll"> <publishTime>12/16/2025 16:29:36</publishTime> <publishTime>01/04/2026 18:33:49</publishTime> </File> <File Include="DLL/Kingdee.BOS.WebApi.Client.dll"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="DLL/Model.dll"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="DLL/Newtonsoft.Json.Net35.dll"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="DLL/Pub_Class.dll"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="DLL/Pub_Control.dll"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="DLL/SQLHelper.dll"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.eot"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.svg"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.ttf"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.woff"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Global.asax"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="grpc_csharp_ext.x64.dll"> <publishTime>03/22/2022 13:17:22</publishTime> @@ -435,7 +435,7 @@ <publishTime>03/22/2022 13:17:22</publishTime> </File> <File Include="Index.html"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="libgrpc_csharp_ext.x64.dylib"> <publishTime>03/19/2022 07:38:44</publishTime> @@ -444,133 +444,133 @@ <publishTime>03/19/2022 07:38:42</publishTime> </File> <File Include="libman.json"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>07/12/2023 08:14:21</publishTime> </File> <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="packages.config"> <publishTime>03/25/2026 10:40:27</publishTime> <publishTime>03/24/2026 21:43:36</publishTime> </File> <File Include="Properties/PublishProfiles/JFAPI.pubxml.user"> <publishTime>12/10/2025 17:08:59</publishTime> <publishTime>12/08/2025 16:05:47</publishTime> </File> <File Include="Scripts/jquery.signalR-2.2.2.js"> <publishTime>01/28/2026 14:08:07</publishTime> <publishTime>03/02/2026 10:25:32</publishTime> </File> <File Include="Scripts/jquery.signalR-2.2.2.min.js"> <publishTime>01/28/2026 14:08:07</publishTime> <publishTime>03/02/2026 10:25:32</publishTime> </File> <File Include="Template/barCodeTemplateStorage.json"> <publishTime>09/05/2025 16:16:48</publishTime> <publishTime>09/01/2025 08:23:20</publishTime> </File> <File Include="Utility/Barcode.ashx"> <publishTime>12/16/2025 16:29:36</publishTime> <publishTime>01/04/2026 18:33:49</publishTime> </File> <File Include="Views/Scripts/bootstrap.js"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Views/Scripts/bootstrap.min.js"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.js"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.min.js"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.min.map"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Views/Scripts/jquery.validate.js"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Views/Scripts/jquery.validate.min.js"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Views/Scripts/jquery.validate.unobtrusive.js"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Views/Scripts/modernizr-2.6.2.js"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Views/Shared/Error.cshtml"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Views/Shared/_Layout.cshtml"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Views/web.config"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Views/_ViewStart.cshtml"> <publishTime>05/23/2025 10:00:25</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource"> <publishTime>08/21/2025 15:39:36</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Department_Model.datasource"> <publishTime>08/21/2025 15:39:36</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource"> <publishTime>08/21/2025 15:39:37</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource"> <publishTime>08/21/2025 15:39:36</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource"> <publishTime>08/21/2025 15:39:36</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource"> <publishTime>08/21/2025 15:39:36</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource"> <publishTime>08/21/2025 15:39:37</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model.datasource"> <publishTime>08/21/2025 15:39:37</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource"> <publishTime>08/21/2025 15:39:37</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsGy_Customer_Model.datasource"> <publishTime>08/21/2025 15:39:37</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsGy_Department_Model.datasource"> <publishTime>08/21/2025 15:39:37</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsGy_Employee_Model.datasource"> <publishTime>08/21/2025 15:39:37</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsGy_Group_Model.datasource"> <publishTime>08/21/2025 15:39:37</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource"> <publishTime>08/21/2025 15:39:37</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsGy_Source_Model.datasource"> <publishTime>08/21/2025 15:39:37</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource"> <publishTime>08/21/2025 15:39:37</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource"> <publishTime>08/21/2025 15:39:37</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource"> <publishTime>08/21/2025 15:39:37</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsKf_ICStockBill_Mould.datasource"> <publishTime>08/21/2025 15:39:36</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource"> <publishTime>08/21/2025 15:39:37</publishTime> <publishTime>04/06/2023 15:57:02</publishTime> </File> <File Include="Web.config"> <publishTime>03/27/2026 13:35:29</publishTime> <publishTime>04/01/2026 11:48:48</publishTime> </File> </ItemGroup> </Project> WebAPI/Properties/PublishProfiles/FolderProfile4.pubxml.user
@@ -5,7 +5,7 @@ <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <PropertyGroup> <_PublishTargetUrl>D:\ç½ç«åå¸\æºäºMESWMS\API</_PublishTargetUrl> <History>True|2026-03-26T12:47:36.0014933Z;True|2026-03-26T20:36:42.9412464+08:00;False|2026-03-26T20:35:57.6706859+08:00;True|2026-03-26T16:53:58.9000777+08:00;True|2026-03-26T16:40:36.2552936+08:00;True|2026-03-26T16:23:05.5255533+08:00;True|2026-03-26T10:31:55.8901206+08:00;False|2026-03-26T10:30:23.1420038+08:00;True|2026-03-25T16:35:08.8050103+08:00;True|2026-03-25T15:37:15.6317912+08:00;True|2026-03-25T15:27:23.3932111+08:00;True|2026-03-25T15:11:11.1967438+08:00;True|2026-03-25T15:00:30.5147369+08:00;True|2026-03-25T14:52:56.0204639+08:00;True|2026-03-25T14:47:51.3529176+08:00;True|2026-03-25T14:46:04.5196908+08:00;True|2026-03-25T14:40:04.4992796+08:00;True|2026-03-25T14:38:45.0508837+08:00;True|2026-03-25T13:40:00.6412255+08:00;True|2026-03-25T13:17:17.5126232+08:00;True|2026-03-25T13:05:28.8923666+08:00;True|2026-03-25T11:16:11.6477493+08:00;True|2026-03-25T10:56:54.5866590+08:00;False|2026-03-25T10:55:40.1765744+08:00;True|2026-03-24T08:56:28.1340424+08:00;True|2026-03-24T08:11:40.8167004+08:00;False|2026-03-24T08:10:24.5227115+08:00;True|2026-03-23T16:52:06.1962112+08:00;True|2026-03-23T10:48:43.9146974+08:00;False|2026-03-23T10:47:37.6567528+08:00;True|2026-03-23T10:21:45.2785227+08:00;False|2026-03-23T10:21:38.6946638+08:00;True|2026-03-20T13:20:00.4199413+08:00;False|2026-03-20T13:19:48.2280600+08:00;True|2026-03-19T16:53:44.5050326+08:00;True|2026-03-19T10:10:35.5101923+08:00;False|2026-03-19T10:10:15.7270659+08:00;True|2026-03-18T19:51:55.1022153+08:00;True|2026-03-18T19:41:13.5178535+08:00;False|2026-03-18T19:40:38.2085412+08:00;True|2026-03-18T09:40:21.0697989+08:00;True|2026-03-18T09:34:25.1335941+08:00;False|2026-03-18T09:33:56.8767961+08:00;False|2026-03-17T11:45:46.0943251+08:00;True|2026-03-16T14:55:19.5092172+08:00;True|2026-03-16T14:39:12.2885876+08:00;True|2026-03-16T13:20:59.6155796+08:00;True|2026-03-16T12:53:38.9806066+08:00;False|2026-03-16T12:53:28.1149911+08:00;True|2026-03-16T10:21:54.6583129+08:00;False|2026-03-16T10:20:22.8166196+08:00;True|2026-03-13T13:56:44.7436815+08:00;True|2026-03-13T13:48:09.2962246+08:00;True|2026-03-13T10:01:06.8006672+08:00;False|2026-03-13T09:59:31.4203821+08:00;True|2026-03-09T01:54:24.1336085+08:00;False|2026-03-09T01:53:17.3398700+08:00;True|2026-03-09T01:28:43.0746681+08:00;True|2026-03-09T00:35:43.7572081+08:00;False|2026-03-09T00:34:44.1380553+08:00;True|2026-03-02T10:58:08.4918461+08:00;True|2026-02-28T14:36:37.1813756+08:00;True|2026-02-28T09:10:06.2035727+08:00;True|2026-02-28T08:45:06.8758170+08:00;False|2026-02-28T08:45:00.2780485+08:00;True|2026-02-27T16:29:24.9278951+08:00;False|2026-02-27T16:29:01.8985145+08:00;True|2026-02-27T15:25:58.1156917+08:00;False|2026-02-27T15:25:50.1203408+08:00;True|2026-02-27T08:48:32.3741487+08:00;False|2026-02-27T08:47:49.7647299+08:00;True|2026-02-26T13:55:29.1843761+08:00;True|2026-02-26T10:17:02.6775428+08:00;False|2026-02-26T10:15:56.8080083+08:00;True|2026-02-25T16:35:36.1616346+08:00;False|2026-02-25T16:35:02.7930400+08:00;True|2026-02-25T15:14:31.7665279+08:00;True|2026-02-25T15:06:38.2831461+08:00;True|2026-02-25T14:53:16.9553043+08:00;True|2026-02-25T14:18:12.0055193+08:00;True|2026-02-25T14:11:45.2316738+08:00;True|2026-02-25T14:02:16.3161429+08:00;True|2026-02-25T13:47:25.4930099+08:00;False|2026-02-25T13:46:34.1837894+08:00;True|2026-02-24T10:25:01.2146652+08:00;True|2026-02-24T10:16:06.3505078+08:00;True|2026-02-24T10:08:41.7064926+08:00;False|2026-02-24T10:07:25.4868308+08:00;True|2026-02-21T14:56:37.2206752+08:00;True|2026-02-21T14:53:44.6277903+08:00;True|2026-02-21T14:40:10.4687091+08:00;False|2026-02-21T14:39:13.1736140+08:00;True|2026-02-11T11:45:25.6746436+08:00;True|2026-02-11T11:44:47.3185555+08:00;True|2026-02-11T10:54:59.0679758+08:00;True|2026-02-11T10:43:35.2341241+08:00;True|2026-02-11T10:36:26.6768242+08:00;True|2026-02-11T10:26:54.7470684+08:00;True|2026-02-11T10:26:14.5696000+08:00;True|2026-02-11T10:19:17.3267746+08:00;True|2026-02-11T10:03:08.9096446+08:00;True|2026-02-11T10:00:03.1731421+08:00;False|2026-02-11T09:58:47.2916714+08:00;True|2026-02-10T15:11:02.0203382+08:00;True|2026-02-10T15:07:21.6761915+08:00;True|2026-02-10T14:56:44.3660951+08:00;True|2026-02-10T14:42:24.1573010+08:00;True|2026-02-10T14:17:49.6012996+08:00;True|2026-02-10T10:54:27.8849732+08:00;True|2026-02-10T10:37:09.4615737+08:00;True|2026-02-10T10:32:50.2882198+08:00;True|2026-02-10T10:16:38.5004114+08:00;True|2026-02-10T10:04:58.3653257+08:00;False|2026-02-10T10:04:05.6938724+08:00;True|2026-02-09T11:58:12.9122757+08:00;True|2026-02-09T11:52:51.2402774+08:00;True|2026-02-09T11:47:15.5230979+08:00;True|2026-02-09T10:53:15.6587025+08:00;False|2026-02-09T10:52:01.4586729+08:00;True|2026-02-05T12:04:14.1139398+08:00;True|2026-02-05T10:00:41.8883921+08:00;False|2026-02-05T09:59:49.2086159+08:00;True|2026-02-04T13:30:53.8564398+08:00;True|2026-02-04T13:30:06.5486103+08:00;True|2026-02-04T13:21:44.7322601+08:00;True|2026-02-04T13:15:45.0093895+08:00;True|2026-02-04T13:06:30.4891537+08:00;False|2026-02-04T13:05:35.5287589+08:00;True|2026-02-04T12:39:42.2682329+08:00;True|2026-02-04T12:21:52.9722100+08:00;True|2026-02-04T12:16:07.8303016+08:00;True|2026-02-04T12:08:43.8268899+08:00;True|2026-02-04T12:03:26.1174616+08:00;True|2026-02-04T10:33:15.5394044+08:00;False|2026-02-04T10:32:30.7038502+08:00;True|2026-02-02T15:42:04.9554792+08:00;True|2026-02-02T15:39:28.7017318+08:00;True|2026-02-02T15:38:33.5592835+08:00;True|2026-02-02T15:34:24.8450917+08:00;True|2026-02-02T15:30:36.5990146+08:00;True|2026-02-02T15:09:46.1965065+08:00;True|2026-02-02T15:09:24.9794288+08:00;True|2026-02-02T15:05:46.0763516+08:00;True|2026-02-02T14:56:30.1210013+08:00;True|2026-02-02T14:52:50.7435709+08:00;True|2026-02-02T14:47:49.5891710+08:00;True|2026-02-02T14:43:23.0006294+08:00;True|2026-02-02T14:31:10.1220612+08:00;True|2026-02-02T14:21:15.6540317+08:00;True|2026-02-02T14:15:41.6183116+08:00;True|2026-02-02T14:11:32.1234982+08:00;True|2026-02-02T14:01:34.6298901+08:00;True|2026-02-02T13:55:03.4760402+08:00;True|2026-02-02T13:49:00.0420220+08:00;True|2026-02-02T13:17:17.0678676+08:00;False|2026-02-02T13:15:46.0360589+08:00;False|2026-02-02T13:15:27.1689505+08:00;False|2026-02-02T13:14:27.3078641+08:00;True|2026-02-02T12:55:41.9272586+08:00;True|2026-02-02T12:55:22.0826476+08:00;True|2026-02-02T12:09:21.8247404+08:00;True|2026-02-02T12:03:58.9256304+08:00;True|2026-02-02T11:56:01.5744871+08:00;True|2026-02-02T11:42:30.2218073+08:00;True|2026-02-02T10:59:29.6077968+08:00;False|2026-02-02T10:59:08.7803594+08:00;True|2026-01-29T14:40:47.4658031+08:00;True|2026-01-29T14:36:18.2141550+08:00;True|2026-01-29T14:32:52.4872179+08:00;True|2026-01-29T14:32:06.4197291+08:00;True|2026-01-29T14:09:33.9372276+08:00;True|2026-01-29T14:08:17.6503129+08:00;True|2026-01-29T14:06:27.5784162+08:00;True|2026-01-29T13:10:48.6581055+08:00;True|2026-01-29T13:07:28.5589276+08:00;True|2026-01-29T12:44:24.3707488+08:00;True|2026-01-29T12:42:34.6204068+08:00;True|2026-01-29T12:39:55.3867683+08:00;True|2026-01-29T12:29:41.8565928+08:00;True|2026-01-29T12:17:04.5932345+08:00;True|2026-01-29T10:08:23.4550691+08:00;True|2026-01-29T10:04:05.4236307+08:00;False|2026-01-29T10:03:18.4044168+08:00;True|2026-01-28T16:00:38.3698743+08:00;True|2026-01-28T14:15:04.1203132+08:00;True|2026-01-28T14:03:32.3230252+08:00;False|2026-01-28T14:02:41.6157812+08:00;True|2026-01-28T13:18:24.5590390+08:00;True|2026-01-28T13:10:49.5716734+08:00;True|2026-01-28T12:25:03.3201915+08:00;True|2026-01-28T12:24:37.6029904+08:00;True|2026-01-28T12:16:13.3862190+08:00;True|2026-01-28T11:43:57.8268938+08:00;True|2026-01-28T10:57:22.9246991+08:00;True|2026-01-28T10:49:34.6185686+08:00;True|2026-01-28T10:44:07.6308515+08:00;True|2026-01-28T10:36:00.0391721+08:00;True|2026-01-28T10:27:26.1658915+08:00;False|2026-01-28T10:27:00.5898601+08:00;True|2026-01-27T15:02:41.1819512+08:00;True|2026-01-27T14:55:32.3962262+08:00;True|2026-01-27T14:31:09.0105130+08:00;True|2026-01-27T13:19:08.8705541+08:00;True|2026-01-27T11:43:17.0109305+08:00;True|2026-01-27T10:53:13.5941761+08:00;True|2026-01-27T10:49:18.5740094+08:00;True|2026-01-27T10:43:29.4337654+08:00;True|2026-01-27T10:00:49.1779297+08:00;False|2026-01-27T10:00:34.2083888+08:00;True|2026-01-26T16:29:09.5100352+08:00;False|2026-01-26T16:29:04.6554601+08:00;False|2026-01-26T14:39:05.7640208+08:00;True|2026-01-26T09:57:23.8775907+08:00;False|2026-01-26T09:56:43.8599383+08:00;True|2026-01-26T09:37:16.8828589+08:00;False|2026-01-26T09:36:35.9597492+08:00;True|2026-01-25T15:20:11.0096169+08:00;True|2026-01-25T14:52:25.7167654+08:00;True|2026-01-25T14:28:16.6779637+08:00;False|2026-01-25T14:27:32.6753765+08:00;True|2026-01-23T16:17:17.9227805+08:00;True|2026-01-23T14:37:25.7929932+08:00;True|2026-01-23T14:32:25.7611106+08:00;False|2026-01-23T14:31:28.4811198+08:00;True|2026-01-22T09:55:07.0908298+08:00;True|2026-01-22T09:38:49.9102490+08:00;False|2026-01-22T09:37:53.0384929+08:00;True|2026-01-21T16:50:27.5625267+08:00;True|2026-01-21T10:50:18.7634322+08:00;True|2026-01-21T10:47:56.7913811+08:00;True|2026-01-21T10:41:46.5883817+08:00;True|2026-01-21T09:29:22.5824101+08:00;False|2026-01-21T09:28:13.4362586+08:00;True|2026-01-20T14:26:36.7806712+08:00;True|2026-01-20T13:13:01.3064754+08:00;False|2026-01-20T13:12:08.1800841+08:00;True|2026-01-20T10:28:19.5250951+08:00;True|2026-01-20T10:27:41.5947282+08:00;True|2026-01-20T10:23:10.6474490+08:00;True|2026-01-20T10:07:24.8412652+08:00;True|2026-01-20T09:53:19.8583529+08:00;True|2026-01-20T08:21:20.5302494+08:00;False|2026-01-20T08:20:24.6093320+08:00;True|2026-01-19T15:58:34.1439056+08:00;True|2026-01-19T15:56:47.6488483+08:00;True|2026-01-19T15:12:36.9286562+08:00;True|2026-01-19T14:55:17.2807312+08:00;True|2026-01-19T14:47:03.8892836+08:00;True|2026-01-19T14:36:15.0507410+08:00;True|2026-01-19T14:26:05.5060287+08:00;True|2026-01-19T13:50:54.8654304+08:00;True|2026-01-19T13:37:47.2294303+08:00;True|2026-01-19T13:20:13.3781676+08:00;True|2026-01-19T13:07:18.8111360+08:00;True|2026-01-19T13:01:15.1432453+08:00;True|2026-01-19T11:54:26.6582081+08:00;True|2026-01-19T11:23:28.6100843+08:00;True|2026-01-19T08:41:23.8724527+08:00;True|2026-01-19T08:34:06.3247836+08:00;True|2026-01-19T07:48:11.5052413+08:00;False|2026-01-19T07:47:21.4586297+08:00;True|2026-01-18T14:27:24.9640228+08:00;True|2026-01-18T13:21:44.9690334+08:00;False|2026-01-18T13:20:08.6314025+08:00;False|2026-01-16T16:53:24.3290896+08:00;True|2026-01-16T09:03:14.4122067+08:00;True|2026-01-16T08:44:23.0342932+08:00;False|2026-01-16T08:43:34.3488415+08:00;True|2026-01-15T16:27:10.8480719+08:00;False|2026-01-15T16:26:06.6002625+08:00;True|2026-01-15T13:04:43.0602637+08:00;</History> <History>True|2026-04-03T06:05:10.8271838Z;True|2026-04-03T13:56:57.4108062+08:00;True|2026-04-03T13:46:36.2877883+08:00;True|2026-04-03T13:28:23.3420709+08:00;True|2026-04-03T13:14:14.0982238+08:00;True|2026-04-03T13:13:22.7976908+08:00;True|2026-04-03T11:11:53.2967992+08:00;True|2026-04-03T09:17:10.9514503+08:00;False|2026-04-03T09:16:20.1941964+08:00;True|2026-04-02T15:14:19.4671991+08:00;True|2026-04-02T14:10:03.3310495+08:00;True|2026-04-02T10:49:14.7944631+08:00;True|2026-04-02T10:14:53.0350051+08:00;True|2026-04-02T10:10:07.9073159+08:00;True|2026-04-02T10:04:32.1401696+08:00;True|2026-04-02T09:38:46.9980674+08:00;True|2026-04-02T09:25:02.8575431+08:00;True|2026-04-02T09:14:52.2381092+08:00;True|2026-04-02T09:02:34.3741716+08:00;True|2026-04-02T08:54:09.4800267+08:00;False|2026-04-02T08:53:19.5882988+08:00;True|2026-04-01T16:51:44.2792316+08:00;False|2026-04-01T16:50:28.2488041+08:00;True|2026-03-31T15:20:30.7796552+08:00;True|2026-03-31T14:03:54.1439708+08:00;True|2026-03-31T12:58:04.2987775+08:00;True|2026-03-31T12:51:58.7139334+08:00;True|2026-03-31T12:44:07.4892623+08:00;False|2026-03-31T12:43:26.1204678+08:00;True|2026-03-30T15:32:55.4845094+08:00;True|2026-03-30T15:28:33.4553037+08:00;True|2026-03-30T15:20:59.1242879+08:00;False|2026-03-30T15:20:51.0966016+08:00;True|2026-03-30T09:26:34.1819844+08:00;False|2026-03-30T09:25:48.0695684+08:00;True|2026-03-27T15:38:44.5130512+08:00;True|2026-03-27T14:06:58.5921008+08:00;False|2026-03-27T14:05:16.1222292+08:00;True|2026-03-26T20:47:36.0014933+08:00;True|2026-03-26T20:36:42.9412464+08:00;False|2026-03-26T20:35:57.6706859+08:00;True|2026-03-26T16:53:58.9000777+08:00;True|2026-03-26T16:40:36.2552936+08:00;True|2026-03-26T16:23:05.5255533+08:00;True|2026-03-26T10:31:55.8901206+08:00;False|2026-03-26T10:30:23.1420038+08:00;True|2026-03-25T16:35:08.8050103+08:00;True|2026-03-25T15:37:15.6317912+08:00;True|2026-03-25T15:27:23.3932111+08:00;True|2026-03-25T15:11:11.1967438+08:00;True|2026-03-25T15:00:30.5147369+08:00;True|2026-03-25T14:52:56.0204639+08:00;True|2026-03-25T14:47:51.3529176+08:00;True|2026-03-25T14:46:04.5196908+08:00;True|2026-03-25T14:40:04.4992796+08:00;True|2026-03-25T14:38:45.0508837+08:00;True|2026-03-25T13:40:00.6412255+08:00;True|2026-03-25T13:17:17.5126232+08:00;True|2026-03-25T13:05:28.8923666+08:00;True|2026-03-25T11:16:11.6477493+08:00;True|2026-03-25T10:56:54.5866590+08:00;False|2026-03-25T10:55:40.1765744+08:00;True|2026-03-24T08:56:28.1340424+08:00;True|2026-03-24T08:11:40.8167004+08:00;False|2026-03-24T08:10:24.5227115+08:00;True|2026-03-23T16:52:06.1962112+08:00;True|2026-03-23T10:48:43.9146974+08:00;False|2026-03-23T10:47:37.6567528+08:00;True|2026-03-23T10:21:45.2785227+08:00;False|2026-03-23T10:21:38.6946638+08:00;True|2026-03-20T13:20:00.4199413+08:00;False|2026-03-20T13:19:48.2280600+08:00;True|2026-03-19T16:53:44.5050326+08:00;True|2026-03-19T10:10:35.5101923+08:00;False|2026-03-19T10:10:15.7270659+08:00;True|2026-03-18T19:51:55.1022153+08:00;True|2026-03-18T19:41:13.5178535+08:00;False|2026-03-18T19:40:38.2085412+08:00;True|2026-03-18T09:40:21.0697989+08:00;True|2026-03-18T09:34:25.1335941+08:00;False|2026-03-18T09:33:56.8767961+08:00;False|2026-03-17T11:45:46.0943251+08:00;True|2026-03-16T14:55:19.5092172+08:00;True|2026-03-16T14:39:12.2885876+08:00;True|2026-03-16T13:20:59.6155796+08:00;True|2026-03-16T12:53:38.9806066+08:00;False|2026-03-16T12:53:28.1149911+08:00;True|2026-03-16T10:21:54.6583129+08:00;False|2026-03-16T10:20:22.8166196+08:00;True|2026-03-13T13:56:44.7436815+08:00;True|2026-03-13T13:48:09.2962246+08:00;True|2026-03-13T10:01:06.8006672+08:00;False|2026-03-13T09:59:31.4203821+08:00;True|2026-03-09T01:54:24.1336085+08:00;False|2026-03-09T01:53:17.3398700+08:00;True|2026-03-09T01:28:43.0746681+08:00;True|2026-03-09T00:35:43.7572081+08:00;False|2026-03-09T00:34:44.1380553+08:00;True|2026-03-02T10:58:08.4918461+08:00;True|2026-02-28T14:36:37.1813756+08:00;True|2026-02-28T09:10:06.2035727+08:00;True|2026-02-28T08:45:06.8758170+08:00;False|2026-02-28T08:45:00.2780485+08:00;True|2026-02-27T16:29:24.9278951+08:00;False|2026-02-27T16:29:01.8985145+08:00;True|2026-02-27T15:25:58.1156917+08:00;False|2026-02-27T15:25:50.1203408+08:00;True|2026-02-27T08:48:32.3741487+08:00;False|2026-02-27T08:47:49.7647299+08:00;True|2026-02-26T13:55:29.1843761+08:00;True|2026-02-26T10:17:02.6775428+08:00;False|2026-02-26T10:15:56.8080083+08:00;True|2026-02-25T16:35:36.1616346+08:00;False|2026-02-25T16:35:02.7930400+08:00;True|2026-02-25T15:14:31.7665279+08:00;True|2026-02-25T15:06:38.2831461+08:00;True|2026-02-25T14:53:16.9553043+08:00;True|2026-02-25T14:18:12.0055193+08:00;True|2026-02-25T14:11:45.2316738+08:00;True|2026-02-25T14:02:16.3161429+08:00;True|2026-02-25T13:47:25.4930099+08:00;False|2026-02-25T13:46:34.1837894+08:00;True|2026-02-24T10:25:01.2146652+08:00;True|2026-02-24T10:16:06.3505078+08:00;True|2026-02-24T10:08:41.7064926+08:00;False|2026-02-24T10:07:25.4868308+08:00;True|2026-02-21T14:56:37.2206752+08:00;True|2026-02-21T14:53:44.6277903+08:00;True|2026-02-21T14:40:10.4687091+08:00;False|2026-02-21T14:39:13.1736140+08:00;True|2026-02-11T11:45:25.6746436+08:00;True|2026-02-11T11:44:47.3185555+08:00;True|2026-02-11T10:54:59.0679758+08:00;True|2026-02-11T10:43:35.2341241+08:00;True|2026-02-11T10:36:26.6768242+08:00;True|2026-02-11T10:26:54.7470684+08:00;True|2026-02-11T10:26:14.5696000+08:00;True|2026-02-11T10:19:17.3267746+08:00;True|2026-02-11T10:03:08.9096446+08:00;True|2026-02-11T10:00:03.1731421+08:00;False|2026-02-11T09:58:47.2916714+08:00;True|2026-02-10T15:11:02.0203382+08:00;True|2026-02-10T15:07:21.6761915+08:00;True|2026-02-10T14:56:44.3660951+08:00;True|2026-02-10T14:42:24.1573010+08:00;True|2026-02-10T14:17:49.6012996+08:00;True|2026-02-10T10:54:27.8849732+08:00;True|2026-02-10T10:37:09.4615737+08:00;True|2026-02-10T10:32:50.2882198+08:00;True|2026-02-10T10:16:38.5004114+08:00;True|2026-02-10T10:04:58.3653257+08:00;False|2026-02-10T10:04:05.6938724+08:00;True|2026-02-09T11:58:12.9122757+08:00;True|2026-02-09T11:52:51.2402774+08:00;True|2026-02-09T11:47:15.5230979+08:00;True|2026-02-09T10:53:15.6587025+08:00;False|2026-02-09T10:52:01.4586729+08:00;True|2026-02-05T12:04:14.1139398+08:00;True|2026-02-05T10:00:41.8883921+08:00;False|2026-02-05T09:59:49.2086159+08:00;True|2026-02-04T13:30:53.8564398+08:00;True|2026-02-04T13:30:06.5486103+08:00;True|2026-02-04T13:21:44.7322601+08:00;True|2026-02-04T13:15:45.0093895+08:00;True|2026-02-04T13:06:30.4891537+08:00;False|2026-02-04T13:05:35.5287589+08:00;True|2026-02-04T12:39:42.2682329+08:00;True|2026-02-04T12:21:52.9722100+08:00;True|2026-02-04T12:16:07.8303016+08:00;True|2026-02-04T12:08:43.8268899+08:00;True|2026-02-04T12:03:26.1174616+08:00;True|2026-02-04T10:33:15.5394044+08:00;False|2026-02-04T10:32:30.7038502+08:00;True|2026-02-02T15:42:04.9554792+08:00;True|2026-02-02T15:39:28.7017318+08:00;True|2026-02-02T15:38:33.5592835+08:00;True|2026-02-02T15:34:24.8450917+08:00;True|2026-02-02T15:30:36.5990146+08:00;True|2026-02-02T15:09:46.1965065+08:00;True|2026-02-02T15:09:24.9794288+08:00;True|2026-02-02T15:05:46.0763516+08:00;True|2026-02-02T14:56:30.1210013+08:00;True|2026-02-02T14:52:50.7435709+08:00;True|2026-02-02T14:47:49.5891710+08:00;True|2026-02-02T14:43:23.0006294+08:00;True|2026-02-02T14:31:10.1220612+08:00;True|2026-02-02T14:21:15.6540317+08:00;True|2026-02-02T14:15:41.6183116+08:00;True|2026-02-02T14:11:32.1234982+08:00;True|2026-02-02T14:01:34.6298901+08:00;True|2026-02-02T13:55:03.4760402+08:00;True|2026-02-02T13:49:00.0420220+08:00;True|2026-02-02T13:17:17.0678676+08:00;False|2026-02-02T13:15:46.0360589+08:00;False|2026-02-02T13:15:27.1689505+08:00;False|2026-02-02T13:14:27.3078641+08:00;True|2026-02-02T12:55:41.9272586+08:00;True|2026-02-02T12:55:22.0826476+08:00;True|2026-02-02T12:09:21.8247404+08:00;True|2026-02-02T12:03:58.9256304+08:00;True|2026-02-02T11:56:01.5744871+08:00;True|2026-02-02T11:42:30.2218073+08:00;True|2026-02-02T10:59:29.6077968+08:00;False|2026-02-02T10:59:08.7803594+08:00;True|2026-01-29T14:40:47.4658031+08:00;True|2026-01-29T14:36:18.2141550+08:00;True|2026-01-29T14:32:52.4872179+08:00;True|2026-01-29T14:32:06.4197291+08:00;True|2026-01-29T14:09:33.9372276+08:00;True|2026-01-29T14:08:17.6503129+08:00;True|2026-01-29T14:06:27.5784162+08:00;True|2026-01-29T13:10:48.6581055+08:00;True|2026-01-29T13:07:28.5589276+08:00;True|2026-01-29T12:44:24.3707488+08:00;True|2026-01-29T12:42:34.6204068+08:00;True|2026-01-29T12:39:55.3867683+08:00;True|2026-01-29T12:29:41.8565928+08:00;True|2026-01-29T12:17:04.5932345+08:00;True|2026-01-29T10:08:23.4550691+08:00;True|2026-01-29T10:04:05.4236307+08:00;False|2026-01-29T10:03:18.4044168+08:00;True|2026-01-28T16:00:38.3698743+08:00;True|2026-01-28T14:15:04.1203132+08:00;True|2026-01-28T14:03:32.3230252+08:00;False|2026-01-28T14:02:41.6157812+08:00;True|2026-01-28T13:18:24.5590390+08:00;True|2026-01-28T13:10:49.5716734+08:00;True|2026-01-28T12:25:03.3201915+08:00;True|2026-01-28T12:24:37.6029904+08:00;True|2026-01-28T12:16:13.3862190+08:00;True|2026-01-28T11:43:57.8268938+08:00;True|2026-01-28T10:57:22.9246991+08:00;True|2026-01-28T10:49:34.6185686+08:00;True|2026-01-28T10:44:07.6308515+08:00;True|2026-01-28T10:36:00.0391721+08:00;True|2026-01-28T10:27:26.1658915+08:00;False|2026-01-28T10:27:00.5898601+08:00;True|2026-01-27T15:02:41.1819512+08:00;True|2026-01-27T14:55:32.3962262+08:00;True|2026-01-27T14:31:09.0105130+08:00;True|2026-01-27T13:19:08.8705541+08:00;True|2026-01-27T11:43:17.0109305+08:00;True|2026-01-27T10:53:13.5941761+08:00;True|2026-01-27T10:49:18.5740094+08:00;True|2026-01-27T10:43:29.4337654+08:00;True|2026-01-27T10:00:49.1779297+08:00;False|2026-01-27T10:00:34.2083888+08:00;True|2026-01-26T16:29:09.5100352+08:00;False|2026-01-26T16:29:04.6554601+08:00;False|2026-01-26T14:39:05.7640208+08:00;True|2026-01-26T09:57:23.8775907+08:00;False|2026-01-26T09:56:43.8599383+08:00;True|2026-01-26T09:37:16.8828589+08:00;False|2026-01-26T09:36:35.9597492+08:00;True|2026-01-25T15:20:11.0096169+08:00;True|2026-01-25T14:52:25.7167654+08:00;True|2026-01-25T14:28:16.6779637+08:00;False|2026-01-25T14:27:32.6753765+08:00;True|2026-01-23T16:17:17.9227805+08:00;True|2026-01-23T14:37:25.7929932+08:00;True|2026-01-23T14:32:25.7611106+08:00;False|2026-01-23T14:31:28.4811198+08:00;True|2026-01-22T09:55:07.0908298+08:00;True|2026-01-22T09:38:49.9102490+08:00;False|2026-01-22T09:37:53.0384929+08:00;True|2026-01-21T16:50:27.5625267+08:00;True|2026-01-21T10:50:18.7634322+08:00;True|2026-01-21T10:47:56.7913811+08:00;True|2026-01-21T10:41:46.5883817+08:00;True|2026-01-21T09:29:22.5824101+08:00;False|2026-01-21T09:28:13.4362586+08:00;True|2026-01-20T14:26:36.7806712+08:00;True|2026-01-20T13:13:01.3064754+08:00;False|2026-01-20T13:12:08.1800841+08:00;True|2026-01-20T10:28:19.5250951+08:00;True|2026-01-20T10:27:41.5947282+08:00;True|2026-01-20T10:23:10.6474490+08:00;True|2026-01-20T10:07:24.8412652+08:00;True|2026-01-20T09:53:19.8583529+08:00;True|2026-01-20T08:21:20.5302494+08:00;False|2026-01-20T08:20:24.6093320+08:00;True|2026-01-19T15:58:34.1439056+08:00;True|2026-01-19T15:56:47.6488483+08:00;True|2026-01-19T15:12:36.9286562+08:00;True|2026-01-19T14:55:17.2807312+08:00;True|2026-01-19T14:47:03.8892836+08:00;True|2026-01-19T14:36:15.0507410+08:00;True|2026-01-19T14:26:05.5060287+08:00;True|2026-01-19T13:50:54.8654304+08:00;True|2026-01-19T13:37:47.2294303+08:00;True|2026-01-19T13:20:13.3781676+08:00;True|2026-01-19T13:07:18.8111360+08:00;True|2026-01-19T13:01:15.1432453+08:00;True|2026-01-19T11:54:26.6582081+08:00;True|2026-01-19T11:23:28.6100843+08:00;True|2026-01-19T08:41:23.8724527+08:00;True|2026-01-19T08:34:06.3247836+08:00;True|2026-01-19T07:48:11.5052413+08:00;False|2026-01-19T07:47:21.4586297+08:00;True|2026-01-18T14:27:24.9640228+08:00;True|2026-01-18T13:21:44.9690334+08:00;False|2026-01-18T13:20:08.6314025+08:00;False|2026-01-16T16:53:24.3290896+08:00;True|2026-01-16T09:03:14.4122067+08:00;True|2026-01-16T08:44:23.0342932+08:00;False|2026-01-16T08:43:34.3488415+08:00;True|2026-01-15T16:27:10.8480719+08:00;False|2026-01-15T16:26:06.6002625+08:00;True|2026-01-15T13:04:43.0602637+08:00;</History> </PropertyGroup> <ItemGroup> <File Include="apiapp.json"> @@ -45,28 +45,28 @@ <publishTime>02/22/2013 16:43:40</publishTime> </File> <File Include="bin/BLL.dll"> <publishTime>03/26/2026 10:30:47</publishTime> <publishTime>04/03/2026 09:16:39</publishTime> </File> <File Include="bin/BLL.pdb"> <publishTime>03/26/2026 10:30:47</publishTime> <publishTime>04/03/2026 09:16:39</publishTime> </File> <File Include="bin/BouncyCastle.Crypto.dll"> <publishTime>12/18/2020 05:32:28</publishTime> </File> <File Include="bin/DAL.dll"> <publishTime>03/26/2026 10:30:42</publishTime> <publishTime>04/03/2026 09:16:36</publishTime> </File> <File Include="bin/DAL.pdb"> <publishTime>03/26/2026 10:30:42</publishTime> <publishTime>04/03/2026 09:16:36</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 22:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> <publishTime>03/26/2026 10:30:34</publishTime> <publishTime>03/30/2026 15:31:51</publishTime> </File> <File Include="bin/DBUtility.pdb"> <publishTime>03/26/2026 10:30:34</publishTime> <publishTime>03/30/2026 15:31:51</publishTime> </File> <File Include="bin/Fleck.dll"> <publishTime>04/22/2021 11:48:12</publishTime> @@ -150,10 +150,10 @@ <publishTime>07/25/2012 19:48:56</publishTime> </File> <File Include="bin/Model.dll"> <publishTime>03/26/2026 10:30:36</publishTime> <publishTime>04/01/2026 16:50:57</publishTime> </File> <File Include="bin/Model.pdb"> <publishTime>03/26/2026 10:30:36</publishTime> <publishTime>04/01/2026 16:50:57</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> <publishTime>04/21/2025 11:46:16</publishTime> @@ -189,34 +189,34 @@ <publishTime>11/13/2012 20:19:34</publishTime> </File> <File Include="bin/Pub_Class.dll"> <publishTime>03/26/2026 10:30:31</publishTime> <publishTime>03/30/2026 15:31:48</publishTime> </File> <File Include="bin/Pub_Class.pdb"> <publishTime>03/26/2026 10:30:31</publishTime> <publishTime>03/30/2026 15:31:48</publishTime> </File> <File Include="bin/Pub_Control.dll"> <publishTime>03/26/2026 10:30:33</publishTime> <publishTime>03/30/2026 15:31:50</publishTime> </File> <File Include="bin/Pub_Control.pdb"> <publishTime>03/26/2026 10:30:33</publishTime> <publishTime>03/30/2026 15:31:50</publishTime> </File> <File Include="bin/RestSharp.dll"> <publishTime>08/31/2012 06:22:50</publishTime> </File> <File Include="bin/SQLHelper.dll"> <publishTime>03/26/2026 10:30:33</publishTime> <publishTime>03/30/2026 15:31:50</publishTime> </File> <File Include="bin/SQLHelper.pdb"> <publishTime>03/26/2026 10:30:33</publishTime> <publishTime>03/30/2026 15:31:50</publishTime> </File> <File Include="bin/Swashbuckle.Core.dll"> <publishTime>02/16/2015 01:57:08</publishTime> </File> <File Include="bin/SyntacticSugar.dll"> <publishTime>03/24/2026 08:16:10</publishTime> <publishTime>03/30/2026 15:31:46</publishTime> </File> <File Include="bin/SyntacticSugar.pdb"> <publishTime>03/24/2026 08:16:10</publishTime> <publishTime>03/30/2026 15:31:46</publishTime> </File> <File Include="bin/System.Buffers.dll"> <publishTime>07/19/2017 18:01:28</publishTime> @@ -330,22 +330,22 @@ <publishTime>05/09/2023 10:43:40</publishTime> </File> <File Include="bin/TopSdk.dll"> <publishTime>03/25/2026 17:05:04</publishTime> <publishTime>03/30/2026 15:31:53</publishTime> </File> <File Include="bin/TopSdk.pdb"> <publishTime>03/25/2026 17:05:04</publishTime> <publishTime>03/30/2026 15:31:53</publishTime> </File> <File Include="bin/WebActivatorEx.dll"> <publishTime>11/24/2014 19:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> <publishTime>03/26/2026 20:47:21</publishTime> <publishTime>04/03/2026 14:04:53</publishTime> </File> <File Include="bin/WebAPI.pdb"> <publishTime>03/26/2026 20:47:21</publishTime> <publishTime>04/03/2026 14:04:53</publishTime> </File> <File Include="bin/WebAPI.XmlSerializers.dll"> <publishTime>03/26/2026 20:47:32</publishTime> <publishTime>04/03/2026 14:05:03</publishTime> </File> <File Include="bin/WebGrease.dll"> <publishTime>07/18/2013 01:03:52</publishTime> @@ -570,7 +570,7 @@ <publishTime>04/21/2025 11:46:17</publishTime> </File> <File Include="Web.config"> <publishTime>03/25/2026 10:56:54</publishTime> <publishTime>03/30/2026 15:32:54</publishTime> </File> </ItemGroup> </Project> WebAPI/Properties/PublishProfiles/WTTFolder.pubxml.user
@@ -5,7 +5,7 @@ <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <PropertyGroup> <_PublishTargetUrl>D:\ç½ç«åå¸\API</_PublishTargetUrl> <History>True|2026-03-25T08:10:29.4610079Z;False|2026-03-25T16:10:15.2610463+08:00;True|2026-03-25T16:05:31.2437927+08:00;False|2026-03-25T16:04:42.8165129+08:00;True|2026-03-25T15:51:12.3488143+08:00;True|2026-03-25T15:41:15.4809614+08:00;True|2026-03-25T15:36:47.6377104+08:00;True|2026-03-25T15:24:05.9533971+08:00;True|2026-03-25T15:08:09.4213443+08:00;True|2026-03-25T15:02:35.5966546+08:00;True|2026-03-25T14:39:57.1426058+08:00;True|2026-03-23T22:27:05.9947039+08:00;True|2026-03-23T22:17:02.8820923+08:00;True|2026-03-23T21:52:15.7333002+08:00;True|2026-03-23T21:47:32.5007616+08:00;True|2026-03-23T21:40:56.5048061+08:00;True|2026-03-23T13:19:40.2829571+08:00;True|2026-03-23T12:21:19.4345768+08:00;True|2026-03-23T12:18:14.1029044+08:00;True|2026-03-23T12:14:30.8931394+08:00;True|2026-03-23T11:21:56.8156303+08:00;True|2026-03-23T11:12:41.0316561+08:00;True|2026-03-23T11:08:54.1270716+08:00;True|2026-03-23T09:56:08.8942090+08:00;True|2026-03-20T10:11:11.2023901+08:00;True|2026-03-17T09:33:58.4998522+08:00;True|2026-03-13T14:39:56.2046419+08:00;True|2026-03-13T10:45:44.5969827+08:00;False|2026-03-13T10:45:39.0031185+08:00;True|2026-03-13T10:33:50.6454960+08:00;True|2026-03-13T10:13:54.8054151+08:00;False|2026-03-13T10:13:48.7433858+08:00;True|2026-03-13T08:27:44.0365848+08:00;False|2026-03-13T08:27:15.7236925+08:00;True|2026-03-10T13:21:23.4020454+08:00;False|2026-03-10T13:20:37.7978257+08:00;True|2026-03-09T16:23:37.1957075+08:00;False|2026-03-09T16:23:09.1793900+08:00;True|2026-03-08T19:14:49.7700862+08:00;False|2026-03-08T19:13:57.9637951+08:00;True|2026-03-07T15:31:56.3119377+08:00;True|2026-03-07T15:27:26.3686205+08:00;True|2026-03-07T15:20:44.8497962+08:00;True|2026-03-07T15:16:09.1126972+08:00;True|2026-03-07T15:13:14.8502726+08:00;True|2026-03-07T15:00:35.5106409+08:00;True|2026-03-06T09:17:38.4826562+08:00;False|2026-03-06T09:17:12.2137124+08:00;True|2026-03-04T10:37:38.3542826+08:00;True|2026-03-04T10:35:38.0033181+08:00;False|2026-03-04T10:35:21.6139985+08:00;True|2026-03-04T10:10:33.7184690+08:00;False|2026-03-04T10:10:13.6608297+08:00;True|2026-02-28T14:44:48.8921146+08:00;True|2026-02-28T13:49:09.3417790+08:00;True|2026-02-28T13:36:36.7808689+08:00;True|2026-02-28T13:07:59.4097968+08:00;True|2026-02-28T11:22:16.2244092+08:00;False|2026-02-28T11:21:50.3452184+08:00;True|2026-02-27T15:15:26.7008273+08:00;False|2026-02-27T15:15:03.5165987+08:00;True|2026-02-24T13:26:35.7198126+08:00;True|2026-02-24T13:17:50.6475487+08:00;False|2026-02-24T13:17:16.4754994+08:00;True|2026-02-09T09:03:02.9552827+08:00;False|2026-02-09T09:02:19.7888361+08:00;True|2026-01-23T16:43:00.5233443+08:00;True|2026-01-23T15:52:34.0578166+08:00;True|2026-01-23T15:18:26.9929522+08:00;True|2026-01-23T14:54:41.7989523+08:00;True|2026-01-23T14:20:36.5052445+08:00;False|2026-01-23T13:57:17.0723425+08:00;True|2026-01-23T08:08:55.5799949+08:00;False|2026-01-23T08:08:18.0965301+08:00;True|2026-01-21T13:46:11.7257946+08:00;True|2026-01-20T09:22:33.7255529+08:00;False|2026-01-20T08:33:10.2890987+08:00;True|2026-01-19T13:53:48.2079321+08:00;False|2026-01-19T13:53:24.9464993+08:00;True|2026-01-16T15:23:46.2649561+08:00;True|2026-01-16T09:00:43.1528772+08:00;</History> <History>True|2026-03-27T06:21:25.0796115Z;True|2026-03-26T11:06:46.4787179+08:00;False|2026-03-26T11:06:35.4166660+08:00;True|2026-03-25T16:10:29.4610079+08:00;False|2026-03-25T16:10:15.2610463+08:00;True|2026-03-25T16:05:31.2437927+08:00;False|2026-03-25T16:04:42.8165129+08:00;True|2026-03-25T15:51:12.3488143+08:00;True|2026-03-25T15:41:15.4809614+08:00;True|2026-03-25T15:36:47.6377104+08:00;True|2026-03-25T15:24:05.9533971+08:00;True|2026-03-25T15:08:09.4213443+08:00;True|2026-03-25T15:02:35.5966546+08:00;True|2026-03-25T14:39:57.1426058+08:00;True|2026-03-23T22:27:05.9947039+08:00;True|2026-03-23T22:17:02.8820923+08:00;True|2026-03-23T21:52:15.7333002+08:00;True|2026-03-23T21:47:32.5007616+08:00;True|2026-03-23T21:40:56.5048061+08:00;True|2026-03-23T13:19:40.2829571+08:00;True|2026-03-23T12:21:19.4345768+08:00;True|2026-03-23T12:18:14.1029044+08:00;True|2026-03-23T12:14:30.8931394+08:00;True|2026-03-23T11:21:56.8156303+08:00;True|2026-03-23T11:12:41.0316561+08:00;True|2026-03-23T11:08:54.1270716+08:00;True|2026-03-23T09:56:08.8942090+08:00;True|2026-03-20T10:11:11.2023901+08:00;True|2026-03-17T09:33:58.4998522+08:00;True|2026-03-13T14:39:56.2046419+08:00;True|2026-03-13T10:45:44.5969827+08:00;False|2026-03-13T10:45:39.0031185+08:00;True|2026-03-13T10:33:50.6454960+08:00;True|2026-03-13T10:13:54.8054151+08:00;False|2026-03-13T10:13:48.7433858+08:00;True|2026-03-13T08:27:44.0365848+08:00;False|2026-03-13T08:27:15.7236925+08:00;True|2026-03-10T13:21:23.4020454+08:00;False|2026-03-10T13:20:37.7978257+08:00;True|2026-03-09T16:23:37.1957075+08:00;False|2026-03-09T16:23:09.1793900+08:00;True|2026-03-08T19:14:49.7700862+08:00;False|2026-03-08T19:13:57.9637951+08:00;True|2026-03-07T15:31:56.3119377+08:00;True|2026-03-07T15:27:26.3686205+08:00;True|2026-03-07T15:20:44.8497962+08:00;True|2026-03-07T15:16:09.1126972+08:00;True|2026-03-07T15:13:14.8502726+08:00;True|2026-03-07T15:00:35.5106409+08:00;True|2026-03-06T09:17:38.4826562+08:00;False|2026-03-06T09:17:12.2137124+08:00;True|2026-03-04T10:37:38.3542826+08:00;True|2026-03-04T10:35:38.0033181+08:00;False|2026-03-04T10:35:21.6139985+08:00;True|2026-03-04T10:10:33.7184690+08:00;False|2026-03-04T10:10:13.6608297+08:00;True|2026-02-28T14:44:48.8921146+08:00;True|2026-02-28T13:49:09.3417790+08:00;True|2026-02-28T13:36:36.7808689+08:00;True|2026-02-28T13:07:59.4097968+08:00;True|2026-02-28T11:22:16.2244092+08:00;False|2026-02-28T11:21:50.3452184+08:00;True|2026-02-27T15:15:26.7008273+08:00;False|2026-02-27T15:15:03.5165987+08:00;True|2026-02-24T13:26:35.7198126+08:00;True|2026-02-24T13:17:50.6475487+08:00;False|2026-02-24T13:17:16.4754994+08:00;True|2026-02-09T09:03:02.9552827+08:00;False|2026-02-09T09:02:19.7888361+08:00;True|2026-01-23T16:43:00.5233443+08:00;True|2026-01-23T15:52:34.0578166+08:00;True|2026-01-23T15:18:26.9929522+08:00;True|2026-01-23T14:54:41.7989523+08:00;True|2026-01-23T14:20:36.5052445+08:00;False|2026-01-23T13:57:17.0723425+08:00;True|2026-01-23T08:08:55.5799949+08:00;False|2026-01-23T08:08:18.0965301+08:00;True|2026-01-21T13:46:11.7257946+08:00;True|2026-01-20T09:22:33.7255529+08:00;False|2026-01-20T08:33:10.2890987+08:00;True|2026-01-19T13:53:48.2079321+08:00;False|2026-01-19T13:53:24.9464993+08:00;True|2026-01-16T15:23:46.2649561+08:00;True|2026-01-16T09:00:43.1528772+08:00;</History> </PropertyGroup> <ItemGroup> <File Include="apiapp.json"> @@ -45,28 +45,28 @@ <publishTime>02/22/2013 16:43:40</publishTime> </File> <File Include="bin/BLL.dll"> <publishTime>03/25/2026 16:09:20</publishTime> <publishTime>03/27/2026 14:19:44</publishTime> </File> <File Include="bin/BLL.pdb"> <publishTime>03/25/2026 16:09:20</publishTime> <publishTime>03/27/2026 14:19:44</publishTime> </File> <File Include="bin/BouncyCastle.Crypto.dll"> <publishTime>12/18/2020 05:32:28</publishTime> </File> <File Include="bin/DAL.dll"> <publishTime>03/25/2026 16:09:15</publishTime> <publishTime>03/27/2026 14:19:39</publishTime> </File> <File Include="bin/DAL.pdb"> <publishTime>03/25/2026 16:09:15</publishTime> <publishTime>03/27/2026 14:19:39</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 22:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> <publishTime>03/25/2026 16:09:10</publishTime> <publishTime>03/27/2026 14:19:33</publishTime> </File> <File Include="bin/DBUtility.pdb"> <publishTime>03/25/2026 16:09:10</publishTime> <publishTime>03/27/2026 14:19:33</publishTime> </File> <File Include="bin/Fleck.dll"> <publishTime>04/22/2021 11:48:12</publishTime> @@ -150,10 +150,10 @@ <publishTime>07/25/2012 19:48:56</publishTime> </File> <File Include="bin/Model.dll"> <publishTime>03/25/2026 16:09:13</publishTime> <publishTime>03/27/2026 14:19:36</publishTime> </File> <File Include="bin/Model.pdb"> <publishTime>03/25/2026 16:09:13</publishTime> <publishTime>03/27/2026 14:19:36</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> <publishTime>08/18/2025 16:11:18</publishTime> @@ -189,34 +189,34 @@ <publishTime>11/13/2012 20:19:34</publishTime> </File> <File Include="bin/Pub_Class.dll"> <publishTime>03/25/2026 16:09:07</publishTime> <publishTime>03/27/2026 14:19:29</publishTime> </File> <File Include="bin/Pub_Class.pdb"> <publishTime>03/25/2026 16:09:07</publishTime> <publishTime>03/27/2026 14:19:29</publishTime> </File> <File Include="bin/Pub_Control.dll"> <publishTime>03/25/2026 16:09:08</publishTime> <publishTime>03/27/2026 14:19:31</publishTime> </File> <File Include="bin/Pub_Control.pdb"> <publishTime>03/25/2026 16:09:08</publishTime> <publishTime>03/27/2026 14:19:31</publishTime> </File> <File Include="bin/RestSharp.dll"> <publishTime>08/31/2012 06:22:50</publishTime> </File> <File Include="bin/SQLHelper.dll"> <publishTime>03/25/2026 16:09:08</publishTime> <publishTime>03/27/2026 14:19:31</publishTime> </File> <File Include="bin/SQLHelper.pdb"> <publishTime>03/25/2026 16:09:08</publishTime> <publishTime>03/27/2026 14:19:31</publishTime> </File> <File Include="bin/Swashbuckle.Core.dll"> <publishTime>02/16/2015 01:57:08</publishTime> </File> <File Include="bin/SyntacticSugar.dll"> <publishTime>03/25/2026 16:08:11</publishTime> <publishTime>03/27/2026 14:19:27</publishTime> </File> <File Include="bin/SyntacticSugar.pdb"> <publishTime>03/25/2026 16:08:11</publishTime> <publishTime>03/27/2026 14:19:27</publishTime> </File> <File Include="bin/System.Buffers.dll"> <publishTime>07/19/2017 18:01:28</publishTime> @@ -330,19 +330,19 @@ <publishTime>05/09/2023 10:43:40</publishTime> </File> <File Include="bin/TopSdk.dll"> <publishTime>03/25/2026 16:08:11</publishTime> <publishTime>03/27/2026 14:19:30</publishTime> </File> <File Include="bin/TopSdk.pdb"> <publishTime>03/25/2026 16:08:11</publishTime> <publishTime>03/27/2026 14:19:30</publishTime> </File> <File Include="bin/WebActivatorEx.dll"> <publishTime>11/24/2014 19:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> <publishTime>03/25/2026 16:10:25</publishTime> <publishTime>03/27/2026 14:19:53</publishTime> </File> <File Include="bin/WebAPI.pdb"> <publishTime>03/25/2026 16:10:25</publishTime> <publishTime>03/27/2026 14:19:53</publishTime> </File> <File Include="bin/WebGrease.dll"> <publishTime>07/18/2013 01:03:52</publishTime> @@ -567,7 +567,7 @@ <publishTime>10/27/2025 08:51:29</publishTime> </File> <File Include="Web.config"> <publishTime>03/25/2026 16:10:26</publishTime> <publishTime>03/27/2026 14:21:20</publishTime> </File> </ItemGroup> </Project> WebAPI/Service/JwtAuthorizeAttribute.cs
@@ -2,6 +2,7 @@ using System.Linq; using System.Net; using System.Net.Http; using System.Reflection; using System.Security.Claims; using System.Threading; using System.Threading.Tasks; @@ -32,7 +33,7 @@ { try { // æ£æ¥å¿åè®¿é® // æ£æ¥å¿å访é®(认è¯) if (IsAnonymousAllowed(actionContext)) return; // è·åToken @@ -52,28 +53,63 @@ return; } // éªè¯æ¯å¦æ¥æè®¿é®æ¨¡åçæé // æä¸¤ç§å¤ææ¹å¼ ä¸ç§æ¯éè¿è§è²å»å¤æï¼ä¸ç§æ¯éè¿ç¨æ·å»å¤æ ç®åææ¶ä¸ååºåï¼åç»å¯å¢å ç³»ç»åæ°æ¥è¿è¡åºå //string HModName = actionContext.Request.Headers.GetValues("x-hmodname")?.FirstOrDefault(); // if (!string.IsNullOrWhiteSpace(HModName)) // å¦ææ²¡æé 置模ç»ååæ®µï¼åé»è®¤ä¸ºä¸éè¦é´æ // { // //var operateAttr = actionContext.ActionDescriptor // //.GetCustomAttributes<ModOperateAttribute>() // //.FirstOrDefault(); // //if(!string.IsNullOrWhiteSpace(operateAttr.Operate)) // //{ // //HModName += operateAttr.Operate; // //} // if (!DBUtility.ClsPub.Security_Log(HModName, 1, false, JWTHelper.getUserName(token))) // { // HandleForbidden(actionContext); // return; // } // } // è®¾ç½®ç¨æ· actionContext.RequestContext.Principal = principal; // éªè¯æ¯å¦æ¥æè®¿é®æ¨¡åçæé // æä¸¤ç§å¤ææ¹å¼ ä¸ç§æ¯éè¿è§è²å»å¤æï¼ä¸ç§æ¯éè¿ç¨æ·å»å¤æ ç®åææ¶ä¸ååºåï¼åç»å¯å¢å ç³»ç»åæ°æ¥è¿è¡åºå // å®å ¨æ§å¶å¨ææ ç¾ var controllerAttr = actionContext.ControllerContext?.ControllerDescriptor?.GetCustomAttributes<PermissionAttribute>().FirstOrDefault(); // å®å ¨è·åActionæ ç¾ var actionAttr = actionContext.ActionDescriptor?.GetCustomAttributes<PermissionAttribute>().FirstOrDefault(); string PermissionStr = string.Empty; // 夿æ§å¶å¨çº§å«ä¸æ¯å¦å¯ç¨äºé´ææ ç¾ if(controllerAttr != null && !string.IsNullOrWhiteSpace(controllerAttr?.HModName)) { PermissionStr += controllerAttr.HModName; // æ¥çæ¯å¦éè¦æ´ç»ç²åº¦çæ§å¶ if(actionAttr != null && !string.IsNullOrWhiteSpace(actionAttr?.Operate)) { // 该å¨ä½å¯¹åºç模åååæ§å¶å¨åæ¯å¦ä¸ä¸è´ if (string.IsNullOrWhiteSpace(actionAttr.HModName)) { PermissionStr = actionAttr.HModName + actionAttr.Operate; } else { PermissionStr += actionAttr.Operate; } } if(!string.IsNullOrWhiteSpace(PermissionStr)) { if (!DBUtility.ClsPub.Security_Log(PermissionStr, 1, false, JWTHelper.getUserName(token))) { HandleForbidden(actionContext); return; } } }else if (actionAttr != null && !string.IsNullOrWhiteSpace(actionAttr?.HModName) && !string.IsNullOrWhiteSpace(actionAttr?.Operate)) { // åç¬å¨å¨ä½ä¸å¯ç¨é´æåè½ PermissionStr = actionAttr.HModName + actionAttr.Operate; if (!string.IsNullOrWhiteSpace(PermissionStr)) { if (!DBUtility.ClsPub.Security_Log(PermissionStr, 1, false, JWTHelper.getUserName(token))) { HandleForbidden(actionContext); return; } } } } catch (Exception e) { WebAPI/Utility/JWTHelper.cs
@@ -81,9 +81,9 @@ { var jwt = new JwtSecurityTokenHandler().ReadJwtToken(token); var czybm = jwt.Claims.FirstOrDefault(c => c.Type == ClaimTypes.NameIdentifier)?.Value; var zymm = jwt.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Name)?.Value; var czymc = jwt.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Name)?.Value; // éè¿ä¸ä¸ä¸ªtokençå¼å·æ°token return GenerateToken(czybm, zymm); return GenerateToken(czybm, czymc); } // 夿Token æ¯å¦å³å°è¿æ @@ -92,7 +92,7 @@ var jwt = new JwtSecurityTokenHandler().ReadJwtToken(token); var validTo = jwt.ValidTo; if(validTo.Subtract(DateTime.UtcNow).TotalMinutes < 5) if(validTo.Subtract(DateTime.UtcNow).TotalMinutes < 30) { return true; } @@ -103,7 +103,6 @@ { var jwt = new JwtSecurityTokenHandler().ReadJwtToken(token); var userName = jwt.Claims.FirstOrDefault(c => c.Type == ClaimTypes.Name)?.Value; // éè¿ä¸ä¸ä¸ªtokençå¼å·æ°token return userName; } } WebAPI/Utility/PermissionAttribute.cs
@@ -5,11 +5,17 @@ namespace WebAPI.Utility { [AttributeUsage(AttributeTargets.Class | AttributeTargets.Method)] [AttributeUsage(AttributeTargets.Class | AttributeTargets.Method, AllowMultiple = false)] public class PermissionAttribute : Attribute { public string HModName { get; } public string Operate { get; } public string HModName { get; set; } public string Operate { get; set; } /// <summary> /// æ åæé ï¼æ¯æåç¬èµå¼å±æ§ï¼ /// </summary> public PermissionAttribute() { } public PermissionAttribute(string hModName,string operate) { HModName = hModName; WebAPI/WebAPI.csproj.user
@@ -14,7 +14,31 @@ <NameOfLastUsedPublishProfile>D:\gz\MES-WEB-API\MES-WEB-API\WebAPI\Properties\PublishProfiles\FolderProfile8.pubxml</NameOfLastUsedPublishProfile> <NameOfLastUsedPublishProfile>D:\WorkBench\MES-WEB-API\WebAPI\Properties\PublishProfiles\FolderProfile4.pubxml</NameOfLastUsedPublishProfile> <ProjectView>ShowAllFiles</ProjectView> <NameOfLastUsedPublishProfile>D:\å·¥ä½ä»£ç \æºäºè¿æ\MES\MES-WEB-API\WebAPI\Properties\PublishProfiles\FolderProfile2.pubxml</NameOfLastUsedPublishProfile> <NameOfLastUsedPublishProfile>D:\WorkBench\MES-WEB-API\WebAPI\Properties\PublishProfiles\FolderProfile4.pubxml</NameOfLastUsedPublishProfile> </PropertyGroup> <ProjectExtensions /> <ProjectExtensions> <VisualStudio> <FlavorProperties GUID="{349c5851-65df-11da-9384-00065b846f21}"> <WebProjectProperties> <StartPageUrl> </StartPageUrl> <StartAction>CurrentPage</StartAction> <AspNetDebugging>True</AspNetDebugging> <SilverlightDebugging>False</SilverlightDebugging> <NativeDebugging>False</NativeDebugging> <SQLDebugging>False</SQLDebugging> <ExternalProgram> </ExternalProgram> <StartExternalURL> </StartExternalURL> <StartCmdLineArguments> </StartCmdLineArguments> <StartWorkingDirectory> </StartWorkingDirectory> <EnableENC>True</EnableENC> <AlwaysStartWebServerOnDebug>False</AlwaysStartWebServerOnDebug> </WebProjectProperties> </FlavorProperties> </VisualStudio> </ProjectExtensions> </Project> sdk_dingding/TopSdk/bin/Debug/TopSdk.dllBinary files differ
sdk_dingding/TopSdk/bin/Debug/TopSdk.pdbBinary files differ
sdk_dingding/TopSdk/bin/Release/TopSdk.dllBinary files differ
sdk_dingding/TopSdk/bin/Release/TopSdk.pdbBinary files differ
sdk_dingding/TopSdk/obj/Debug/TopSdk.csproj.AssemblyReference.cacheBinary files differ
sdk_dingding/TopSdk/obj/Debug/TopSdk.csproj.CoreCompileInputs.cache
File was deleted sdk_dingding/TopSdk/obj/Debug/TopSdk.csproj.FileListAbsolute.txt
@@ -10,9 +10,3 @@ C:\Users\19858\Desktop\æºäºè¿æ\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.csproj.CoreCompileInputs.cache C:\Users\19858\Desktop\æºäºè¿æ\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.dll C:\Users\19858\Desktop\æºäºè¿æ\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.pdb D:\WorkBench\MES-WEB-API\sdk_dingding\TopSdk\bin\Debug\TopSdk.dll D:\WorkBench\MES-WEB-API\sdk_dingding\TopSdk\bin\Debug\TopSdk.pdb D:\WorkBench\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.csproj.AssemblyReference.cache D:\WorkBench\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.csproj.CoreCompileInputs.cache D:\WorkBench\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.dll D:\WorkBench\MES-WEB-API\sdk_dingding\TopSdk\obj\Debug\TopSdk.pdb sdk_dingding/TopSdk/obj/Debug/TopSdk.dllBinary files differ
sdk_dingding/TopSdk/obj/Debug/TopSdk.pdbBinary files differ
sdk_dingding/TopSdk/obj/Release/TopSdk.csproj.AssemblyReference.cacheBinary files differ
sdk_dingding/TopSdk/obj/Release/TopSdk.csproj.FileListAbsolute.txt
@@ -4,3 +4,8 @@ D:\ç½ç«åå¸\å端代ç \MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Release\TopSdk.csproj.CoreCompileInputs.cache D:\ç½ç«åå¸\å端代ç \MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Release\TopSdk.dll D:\ç½ç«åå¸\å端代ç \MES-WEB-API\MES-WEB-API\sdk_dingding\TopSdk\obj\Release\TopSdk.pdb D:\WorkBench\MES-WEB-API\sdk_dingding\TopSdk\bin\Release\TopSdk.dll D:\WorkBench\MES-WEB-API\sdk_dingding\TopSdk\bin\Release\TopSdk.pdb D:\WorkBench\MES-WEB-API\sdk_dingding\TopSdk\obj\Release\TopSdk.csproj.CoreCompileInputs.cache D:\WorkBench\MES-WEB-API\sdk_dingding\TopSdk\obj\Release\TopSdk.dll D:\WorkBench\MES-WEB-API\sdk_dingding\TopSdk\obj\Release\TopSdk.pdb sdk_dingding/TopSdk/obj/Release/TopSdk.dllBinary files differ
sdk_dingding/TopSdk/obj/Release/TopSdk.pdbBinary files differ