APSM/bin/Release/APSM.dllBinary files differ
APSM/bin/Release/APSM.pdbBinary files differ
APSM/bin/Release/BLL.dllBinary files differ
APSM/bin/Release/BLL.pdbBinary files differ
APSM/bin/Release/BaseSet.dllBinary files differ
APSM/bin/Release/BaseSet.pdbBinary files differ
APSM/bin/Release/DAL.dllBinary files differ
APSM/bin/Release/DAL.pdbBinary files differ
APSM/bin/Release/Model.dllBinary files differ
APSM/bin/Release/Model.pdbBinary files differ
APSM/bin/Release/PlanM.dllBinary files differ
APSM/bin/Release/PlanM.pdbBinary files differ
APSM/bin/Release/WarM.dllBinary files differ
APSM/bin/Release/WarM.pdbBinary files differ
APSM/bin/Release/WorkM.dllBinary files differ
APSM/bin/Release/WorkM.pdbBinary files differ
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/Model.dllBinary files differ
BLL/bin/Release/Model.pdbBinary files differ
BaseSet/bin/Release/BLL.dllBinary files differ
BaseSet/bin/Release/BLL.pdbBinary files differ
BaseSet/bin/Release/BaseSet.dllBinary files differ
BaseSet/bin/Release/BaseSet.pdbBinary files differ
BaseSet/bin/Release/DAL.dllBinary files differ
BaseSet/bin/Release/DAL.pdbBinary files differ
BaseSet/bin/Release/Model.dllBinary files differ
BaseSet/bin/Release/Model.pdbBinary files differ
DAL/DAL.csproj
@@ -812,6 +812,7 @@ <Compile Include="车é´ç®¡ç\ClsSc_ProcExchQualityReport.cs" /> <Compile Include="车é´ç®¡ç\ClsSc_ProcExchReport.cs" /> <Compile Include="éå®ç®¡ç\ClsKf_ICStockBackBill.cs" /> <Compile Include="éå®ç®¡ç\ClsXs_OutDoorBill.cs" /> <Compile Include="éå®ç®¡ç\ClsXs_SellOutChangeBill.cs" /> <Compile Include="éå®ç®¡ç\ClsXs_ReceivableBill.cs" /> <Compile Include="éå®ç®¡ç\ClsXs_OutDoorCheckBill.cs" /> DAL/bin/Release/DAL.dllBinary files differ
DAL/bin/Release/DAL.pdbBinary files differ
DAL/bin/Release/Model.dllBinary files differ
DAL/bin/Release/Model.pdbBinary files differ
DAL/ÏúÊÛ¹ÜÀí/ClsXs_OutDoorBill.cs
New file @@ -0,0 +1,444 @@ using System; using System.Collections.Generic; using System.Text; using System.Data; namespace DAL { public class ClsXs_OutDoorBill : DBUtility.ClsXt_BaseBill { public Model.ClsXs_OutDoorBillMain omodel = new Model.ClsXs_OutDoorBillMain(); public List<Model.ClsXs_OutDoorBillSub> DetailColl = new List<Model.ClsXs_OutDoorBillSub>(); public ClsXs_OutDoorBill() { base.MvarItemKeySub = "Xs_OutDoorBillSub"; base.MvarItemKeySub2 = ""; base.MvarItemKeySub3 = ""; base.MvarItemKeySub4 = ""; base.MvarItemKey = "Xs_OutDoorBillMain"; base.MvarReportTitle = "åºé¨ç¡®è®¤å"; base.BillType = "1427"; base.HBillSubType = "1427"; } #region åºå®ä»£ç ~ClsXs_OutDoorBill() { DetailColl = null; } #endregion èªå®ä¹æ¹æ³ //ä¿®æ¹åæ® public override bool ModifyBill(Int64 lngBillKey, ref string sReturn) { try { //ä¿ååæ§å¶========================================= string HBillNote = ""; DataSet ds = oCn.RunProcReturn("Exec h_p_Xs_OutDoorBill_BeforeSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "','" + HBillNote + "',1 ", "h_p_Xs_OutDoorBill_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 Xs_OutDoorBillMain set " + " HBillSubType='" + omodel.HBillSubType + "'" + ",HBillNo='" + omodel.HBillNo + "'" + //åºå®èµå¼=============== ",HDate='" + omodel.HDate + "'" + ",HYear='" + omodel.HDate.Year + "'" + ",HPeriod='" + omodel.HDate.Month + "'" + ",HRemark='" + omodel.HRemark + "'" + ",HUpDater='" + omodel.HUpDater + "'" + ",HUpDateDate=getdate()" + ",HStockOrgID=" + omodel.HStockOrgID + //======================================== ",HCusID=" + omodel.HCusID.ToString() + ",HEmpID=" + omodel.HEmpID + "" + ",HShipper='" + omodel.HShipper + "'" + ",HCarNumber='" + omodel.HCarNumber + "'" + ",HPhone='" + omodel.HPhone + "'" + ",HOutReason='" + omodel.HOutReason + "'" + ",HOutAddress='" + omodel.HOutAddress + "'" + ",HMaterName='" + omodel.HMaterName + "'" + " where HInterID=" + lngBillKey.ToString(); oCn.RunProc(mainSql); //å é¤å ³è DeleteRelation(ref sReturn, lngBillKey); //å é¤å表 DeleteBillSub(lngBillKey); //æå ¥å表 omodel.HInterID = lngBillKey; foreach (Model.ClsXs_OutDoorBillSub oSub in DetailColl) { string subSql = "Insert into Xs_OutDoorBillSub" + "(HInterID,HBillNo_bak,HEntryID,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaterID,HQty,HPieceQty" + ") " + "values(" + "" + omodel.HInterID + "" + ",'" + omodel.HBillNo + "'" + "," + oSub.HEntryID + "" + ",'" + oSub.HRemark + "'" + "," + oSub.HSourceInterID + "" + "," + oSub.HSourceEntryID + "" + ",'" + (oSub.HSourceBillNo == null ? "" : oSub.HSourceBillNo) + "'" + ",'" + (oSub.HSourceBillType == null ? "" : oSub.HSourceBillType) + "'" + "," + oSub.HRelationQty + "" + "," + oSub.HRelationMoney + "" + "," + oSub.HMaterID + "" + "," + oSub.HQty + "" + "," + oSub.HPieceQty + "" + ")"; oCn.RunProc(subSql); } //=========================ä¿ååæ§å¶ DataSet ds2 = oCn.RunProcReturn("h_p_Xs_OutDoorBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',1 ", "h_p_Xs_OutDoorBill_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; } //============================================================================== //ååæºåå ³èæ°é oCn.RunProc("exec h_p_Xs_OutDoorBill_RewriteSellOutBill " + omodel.HInterID.ToString()); sReturn = "ä¿®æ¹åæ®æåï¼"; oCn.Commit(); return true; } catch (Exception e) { sReturn = e.Message; oCn.RollBack(); throw (e); } } //æ°å¢åæ® public override bool AddBill(ref string sReturn) { try { //ä¿ååæ§å¶========================================= string HBillNote = ""; DataSet ds = oCn.RunProcReturn("Exec h_p_Xs_OutDoorBill_BeforeSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "','" + HBillNote + "',1 ", "h_p_Xs_OutDoorBill_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(); //æ£æ¥ä¸»è¡¨å ç æ¯å¦éå¤ï¼è¥éå¤åéæ°çæå¹¶ç»§ç»æ£æ¥ï¼ç´å°ä¸åéå¤ while (true) { ds = oCn.RunProcReturn("select * from Xs_OutDoorBillMain where HInterID = " + omodel.HInterID, "Xs_OutDoorBillMain"); if (ds != null && ds.Tables[0].Rows.Count > 0) { omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); } else { break; } } //æå ¥ä¸»è¡¨ string mainSql = "Insert Into Xs_OutDoorBillMain" + "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HBillNo,HDate,HBillStatus,HMaker,HMakeDate,HRemark,HStockOrgID" + ",HCusID,HEmpID,HShipper,HCarNumber,HPhone,HOutReason,HOutAddress,HMaterName) " + "values(" + "" + omodel.HDate.Year + "" + "," + omodel.HDate.Month + "" + ",'" + this.BillType + "'" + ",'" + omodel.HBillSubType + "'" + "," + omodel.HInterID + "" + ",'" + omodel.HBillNo + "'" + ",'" + omodel.HDate + "'" + "," + "1" + "" + ",'" + omodel.HMaker + "'" + "," + "getdate()" + "" + ",'" + omodel.HRemark + "'" + "," + omodel.HStockOrgID + "" + "," + omodel.HCusID + "" + "," + omodel.HEmpID + "" + ",'" + omodel.HShipper + "'" + ",'" + omodel.HCarNumber + "'" + ",'" + omodel.HPhone + "'" + ",'" + omodel.HOutReason + "'" + ",'" + omodel.HOutAddress + "'" + ",'" + omodel.HMaterName + "'" + ")"; oCn.RunProc(mainSql); //æå ¥å表 foreach (Model.ClsXs_OutDoorBillSub oSub in DetailColl) { string subSql = "Insert into Xs_OutDoorBillSub" + "(HInterID,HBillNo_bak,HEntryID,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HMaterID,HQty,HPieceQty" + ") " + "values(" + "" + omodel.HInterID + "" + ",'" + omodel.HBillNo + "'" + "," + oSub.HEntryID + "" + ",'" + oSub.HRemark + "'" + "," + oSub.HSourceInterID + "" + "," + oSub.HSourceEntryID + "" + ",'" + (oSub.HSourceBillNo == null ? "" : oSub.HSourceBillNo) + "'" + ",'" + (oSub.HSourceBillType == null ? "" : oSub.HSourceBillType) + "'" + "," + oSub.HRelationQty + "" + "," + oSub.HRelationMoney + "" + "," + oSub.HMaterID + "" + "," + oSub.HQty + "" + "," + oSub.HPieceQty + "" + ")"; oCn.RunProc(subSql); } //=========================ä¿ååæ§å¶ DataSet ds2 = oCn.RunProcReturn("h_p_Xs_OutDoorBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',1 ", "h_p_Xs_OutDoorBill_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; } //=============================================================== //ååæºåå ³èæ°é oCn.RunProc("exec h_p_Xs_OutDoorBill_RewriteSellOutBill " + omodel.HInterID.ToString()); 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 Xs_OutDoorBillMain Where HInterID=" + lngBillKey.ToString(), "Xs_OutDoorBillMain"); if (Ds.Tables[0].Rows.Count == 0) { sReturn = "åæ®æªæ¾å°ï¼"; return false; } //åºå®èµå¼=========================================== 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.HPrintQty = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HPrintQty"]); omodel.HStockOrgID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HStockOrgID"]); //======================================================== omodel.HCusID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCusID"]); omodel.HEmpID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HEmpID"]); omodel.HShipper = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HShipper"]); omodel.HCarNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HCarNumber"]); omodel.HPhone = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HPhone"]); omodel.HOutReason = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HOutReason"]); omodel.HOutAddress = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HOutAddress"]); omodel.HMaterName = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HMaterName"]); omodel.HOutCheckMan = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HOutCheckMan"]); omodel.HOutCheckDate = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HOutCheckDate"]); // //å¾ªç¯ DataSet DsSub; DsSub = oCn.RunProcReturn("Select * from Xs_OutDoorBillSub Where HInterID=" + lngBillKey.ToString(), "Xs_OutDoorBillSub"); DetailColl.Clear();//æ¸ ç©º for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++) { Model.ClsXs_OutDoorBillSub oSub = new Model.ClsXs_OutDoorBillSub(); // åºå®èµå¼=============================================== oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]); oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]); oSub.HBillNo_bak = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HBillNo_bak"]); 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.HQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HQty"]); oSub.HPieceQty = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HPieceQty"]); DetailColl.Add(oSub); } sReturn = "æ¾ç¤ºåæ®æåï¼"; return true; } catch (Exception e) { sReturn = e.Message; throw (e); } } public void BackPrintQty(Int64 sInterID) { //åå¡«æå°æ¬¡æ° oCn.RunProc("update " + this.MvarItemKey + " set HPrintQty=HPrintQty + 1 Where HInterID= " + sInterID.ToString()); } //åèµ·å®¡æ¹ public bool startCheckFlow(Int64 lngBillKey, Int64 HCheckFlowID_select, ref string sReturn) { try { string HBillNo = ""; //åæ®å· string HCheckFlowID = ""; //å®¡æ¹æµID string HCheckItemNowID = ""; //å½åå®¡æ ¸é¡¹ç®ID string HCheckItemNextID = ""; //å¾ å®¡æ ¸é¡¹ç®ID //夿æ¯å¦å·²ç»åèµ·å®¡æ¹ string sql0 = "select * from Xt_BillCheckFlowStatus where HBillInterID = " + lngBillKey + " and HBillTypeID = '" + this.BillType + "'"; DataSet ds0 = oCn.RunProcReturn(sql0, "Xt_BillCheckFlowStatus"); if (ds0 != null && ds0.Tables[0].Rows.Count > 0) { sReturn = "忮已å起审æ¹ï¼ä¸å¯éå¤å®¡æ¹ï¼"; return false; } //è·ååæ®æ°æ® string sql = "select * from " + this.MvarItemKey + " where HInterID = " + lngBillKey; DataSet ds = oCn.RunProcReturn(sql, this.MvarItemKey); if (ds == null || ds.Tables[0].Rows.Count == 0) { sReturn = "åæ®ä¸åå¨ï¼"; return false; } HBillNo = ds.Tables[0].Rows[0]["HBillNo"].ToString(); //è·ååæ®ç±»å对åºçé»è®¤å®¡æ¹æµ string sql1 = "select b.HInterID,b.HCheckItemID from Xt_CheckFlowMain as a " + "inner join Xt_CheckFlowSub as b on a.HInterID = b.HInterID " + "where a.HBillTypeID = '" + this.BillType + "' " + "and a.HInterID = " + HCheckFlowID_select + " " + "order by b.HFlowNo asc"; DataSet ds1 = oCn.RunProcReturn(sql1, "Xt_CheckFlowMain"); if (ds1 == null || ds1.Tables[0].Rows.Count == 0) { sReturn = "é»è®¤å®¡æ¹æµä¸åå¨ï¼"; return false; } HCheckFlowID = ds1.Tables[0].Rows[0]["HInterID"].ToString(); HCheckItemNowID = ds1.Tables[0].Rows[0]["HCheckItemID"].ToString(); if (ds1.Tables[0].Rows.Count >= 2) { HCheckItemNextID = ds1.Tables[0].Rows[1]["HCheckItemID"].ToString(); } else { HCheckItemNextID = "0"; } oCn.BeginTran(); //å¢å 忮审æ¹ç¶æè¡¨ æ°æ® for (int i = 0; i < ds1.Tables[0].Rows.Count; i++) { string sql2 = "insert into Xt_BillCheckFlowStatus" + "(HBillTypeID,HBillInterID,HBillNo,HCheckFlowID,HCheckItemID,HChecker,HCheckDate,HCheckNote) " + "values(" + "'" + this.BillType + "'," + "" + lngBillKey + "," + "'" + HBillNo + "'," + "" + ds1.Tables[0].Rows[i]["HInterID"].ToString() + "," + "" + ds1.Tables[0].Rows[i]["HCheckItemID"].ToString() + "," + "" + "''" + "," + "" + "''" + "," + "" + "''" + "" + ")"; oCn.RunProc(sql2); } //æ´æ°ä¸»è¡¨ å®¡æ¹æµ æ°æ® string sql3 = "update " + this.MvarItemKey + " set HCheckFlowID = " + HCheckFlowID + ",HCheckItemNowID=" + HCheckItemNowID + ",HCheckItemNextID=" + HCheckItemNextID + " where HInterID = " + lngBillKey; oCn.RunProc(sql3); oCn.Commit(); return true; } catch (Exception e) { sReturn += e.Message; return false; } } } } DBUtility/obj/Release/DBUtility.csproj.AssemblyReference.cacheBinary files differ
Model/Model.csproj
@@ -1036,6 +1036,8 @@ <Compile Include="éè¶åæ®\éå®ç®¡ç\ClsXs_SeOutStockBackBillSub_K3.cs" /> <Compile Include="éè¶åæ®\éå®ç®¡ç\ClsXs_SeOutStockBillMain_K3.cs" /> <Compile Include="éè¶åæ®\éå®ç®¡ç\ClsXs_SeOutStockBillSub_K3.cs" /> <Compile Include="éå®ç®¡ç\ClsXs_OutDoorBillMain.cs" /> <Compile Include="éå®ç®¡ç\ClsXs_OutDoorBillSub.cs" /> <Compile Include="éå®ç®¡ç\ClsXs_SellOutChangeBillSub.cs" /> <Compile Include="éå®ç®¡ç\ClsXs_SellOutChangeBillMain.cs" /> <Compile Include="éå®ç®¡ç\ClsKf_ICStockBackBillMain.cs" /> Model/bin/Release/Model.dllBinary files differ
Model/bin/Release/Model.pdbBinary files differ
Model/obj/Release/Model.dllBinary files differ
Model/obj/Release/Model.pdbBinary files differ
Model/ÏúÊÛ¹ÜÀí/ClsXs_OutDoorBillMain.cs
New file @@ -0,0 +1,23 @@ using System; using System.Collections.Generic; using System.Text; namespace Model { public class ClsXs_OutDoorBillMain : DBUtility.ClsXt_BaseBillMain { public Int64 HEmpID; //ä¸å¡å public Int64 HCusID;// int --å®¢æ· public string HShipper; //varchar 叿º public string HCarNumber; //车çå· public string HPhone; //èç³»çµè¯ public string HOutReason; //åºé¨åå public string HMaterName; //è£ è¿ä½ç© public string HOutAddress; //åºé¨å°ç¹ public string HOutCheckMan; //åºé¨ç¡®è®¤äºº public string HOutCheckDate; //åºé¨ç¡®è®¤æ¶é´ public Int64 HStockOrgID; public Int64 HPrintQty; //æå°æ¬¡æ° } } Model/ÏúÊÛ¹ÜÀí/ClsXs_OutDoorBillSub.cs
New file @@ -0,0 +1,13 @@ using System; using System.Collections.Generic; using System.Text; namespace Model { public class ClsXs_OutDoorBillSub : DBUtility.ClsXt_BaseBillSub { public Int64 HMaterID; public Double HQty; public Int64 HPieceQty; } } PlanM/bin/Release/BLL.dllBinary files differ
PlanM/bin/Release/BLL.pdbBinary files differ
PlanM/bin/Release/DAL.dllBinary files differ
PlanM/bin/Release/DAL.pdbBinary files differ
PlanM/bin/Release/Model.dllBinary files differ
PlanM/bin/Release/Model.pdbBinary files differ
PlanM/bin/Release/PlanM.dllBinary files differ
PlanM/bin/Release/PlanM.pdbBinary files differ
SyntacticSugar/obj/Debug/SyntacticSugar.csproj.AssemblyReference.cacheBinary files differ
SyntacticSugar/obj/Release/.NETFramework,Version=v4.5.AssemblyAttributes.cs
New file @@ -0,0 +1,4 @@ // <autogenerated /> using System; using System.Reflection; [assembly: global::System.Runtime.Versioning.TargetFrameworkAttribute(".NETFramework,Version=v4.5", FrameworkDisplayName = ".NET Framework 4.5")] SyntacticSugar/obj/Release/SyntacticSugar.csproj.AssemblyReference.cacheBinary files differ
SyntacticSugar/obj/Release/SyntacticSugar.csproj.CoreCompileInputs.cache
New file @@ -0,0 +1 @@ 5dd9c82feb12f833c78ecebea7d9a46c99f29e3f SyntacticSugar/obj/Release/SyntacticSugar.csproj.FileListAbsolute.txt
New file @@ -0,0 +1,6 @@ E:\æºäºmes\mes\MES-WEB-API\SyntacticSugar\bin\Release\SyntacticSugar.dll E:\æºäºmes\mes\MES-WEB-API\SyntacticSugar\bin\Release\SyntacticSugar.pdb E:\æºäºmes\mes\MES-WEB-API\SyntacticSugar\obj\Release\SyntacticSugar.csproj.AssemblyReference.cache E:\æºäºmes\mes\MES-WEB-API\SyntacticSugar\obj\Release\SyntacticSugar.csproj.CoreCompileInputs.cache E:\æºäºmes\mes\MES-WEB-API\SyntacticSugar\obj\Release\SyntacticSugar.dll E:\æºäºmes\mes\MES-WEB-API\SyntacticSugar\obj\Release\SyntacticSugar.pdb SyntacticSugar/obj/Release/SyntacticSugar.dllBinary files differ
SyntacticSugar/obj/Release/SyntacticSugar.pdbBinary files differ
WarM/bin/Release/BLL.dllBinary files differ
WarM/bin/Release/BLL.pdbBinary files differ
WarM/bin/Release/DAL.dllBinary files differ
WarM/bin/Release/DAL.pdbBinary files differ
WarM/bin/Release/Model.dllBinary files differ
WarM/bin/Release/Model.pdbBinary files differ
WarM/bin/Release/WarM.dllBinary files differ
WarM/bin/Release/WarM.pdbBinary files differ
WarM/ÌõÂë´òÓ¡/Gy_BarCodeBill_automaticallyByPLC_New.cs
@@ -2520,6 +2520,21 @@ #endregion #endregion #region 建ç«é讯åï¼ä¸æåæå¡å¨åéæ°æ®ï¼ç¨äºå¸®å©æå¡ç«¯ç¡®å®è¿æ¥ç¶æ private void timer4_Tick(object sender, EventArgs e) { if (getTargetInternetStatus()&& socket!=null && socket.Connected) { try { socket.Send(Encoding.ASCII.GetBytes("1")); } catch (Exception ex) { } } } #endregion } } WarM/ÌõÂë´òÓ¡/Gy_BarCodeBill_automaticallyByPLC_New.designer.cs
@@ -64,6 +64,9 @@ this.tabControl_MainInfo = new System.Windows.Forms.TabControl(); this.tabPage_BillInfo = new System.Windows.Forms.TabPage(); this.gbUp = new System.Windows.Forms.GroupBox(); this.groupBox1 = new System.Windows.Forms.GroupBox(); this.radioButton_IsPrint_No = new System.Windows.Forms.RadioButton(); this.radioButton_IsPrint_Yes = new System.Windows.Forms.RadioButton(); this.cmdSourceBillNo = new System.Windows.Forms.Button(); this.cmbHWorksNumber = new System.Windows.Forms.ComboBox(); this.label4 = new System.Windows.Forms.Label(); @@ -148,14 +151,13 @@ this.printPreviewDialog1 = new System.Windows.Forms.PrintPreviewDialog(); this.timer2 = new System.Windows.Forms.Timer(this.components); this.timer3 = new System.Windows.Forms.Timer(this.components); this.groupBox1 = new System.Windows.Forms.GroupBox(); this.radioButton_IsPrint_Yes = new System.Windows.Forms.RadioButton(); this.radioButton_IsPrint_No = new System.Windows.Forms.RadioButton(); this.timer4 = new System.Windows.Forms.Timer(this.components); this.Tool.SuspendLayout(); this.P1.SuspendLayout(); this.tabControl_MainInfo.SuspendLayout(); this.tabPage_BillInfo.SuspendLayout(); this.gbUp.SuspendLayout(); this.groupBox1.SuspendLayout(); this.tabPage_ParamsInfo.SuspendLayout(); this.groupBox_ParamsInfo.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.pic1)).BeginInit(); @@ -171,7 +173,6 @@ this.tabControl1.SuspendLayout(); this.tabPage4.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.grdBillBarCodeList)).BeginInit(); this.groupBox1.SuspendLayout(); this.SuspendLayout(); // // Tool @@ -596,6 +597,38 @@ this.gbUp.Size = new System.Drawing.Size(1775, 310); this.gbUp.TabIndex = 33; this.gbUp.TabStop = false; // // groupBox1 // this.groupBox1.Controls.Add(this.radioButton_IsPrint_No); this.groupBox1.Controls.Add(this.radioButton_IsPrint_Yes); this.groupBox1.Location = new System.Drawing.Point(24, 162); this.groupBox1.Name = "groupBox1"; this.groupBox1.Size = new System.Drawing.Size(200, 100); this.groupBox1.TabIndex = 45; this.groupBox1.TabStop = false; // // radioButton_IsPrint_No // this.radioButton_IsPrint_No.AutoSize = true; this.radioButton_IsPrint_No.Location = new System.Drawing.Point(6, 68); this.radioButton_IsPrint_No.Name = "radioButton_IsPrint_No"; this.radioButton_IsPrint_No.Size = new System.Drawing.Size(87, 22); this.radioButton_IsPrint_No.TabIndex = 1; this.radioButton_IsPrint_No.Text = "䏿å°"; this.radioButton_IsPrint_No.UseVisualStyleBackColor = true; // // radioButton_IsPrint_Yes // this.radioButton_IsPrint_Yes.AutoSize = true; this.radioButton_IsPrint_Yes.Checked = true; this.radioButton_IsPrint_Yes.Location = new System.Drawing.Point(7, 13); this.radioButton_IsPrint_Yes.Name = "radioButton_IsPrint_Yes"; this.radioButton_IsPrint_Yes.Size = new System.Drawing.Size(69, 22); this.radioButton_IsPrint_Yes.TabIndex = 0; this.radioButton_IsPrint_Yes.TabStop = true; this.radioButton_IsPrint_Yes.Text = "æå°"; this.radioButton_IsPrint_Yes.UseVisualStyleBackColor = true; // // cmdSourceBillNo // @@ -1508,37 +1541,10 @@ this.timer3.Interval = 5000; this.timer3.Tick += new System.EventHandler(this.timer3_Tick); // // groupBox1 // timer4 // this.groupBox1.Controls.Add(this.radioButton_IsPrint_No); this.groupBox1.Controls.Add(this.radioButton_IsPrint_Yes); this.groupBox1.Location = new System.Drawing.Point(24, 162); this.groupBox1.Name = "groupBox1"; this.groupBox1.Size = new System.Drawing.Size(200, 100); this.groupBox1.TabIndex = 45; this.groupBox1.TabStop = false; // // radioButton_IsPrint_Yes // this.radioButton_IsPrint_Yes.AutoSize = true; this.radioButton_IsPrint_Yes.Checked = true; this.radioButton_IsPrint_Yes.Location = new System.Drawing.Point(7, 13); this.radioButton_IsPrint_Yes.Name = "radioButton_IsPrint_Yes"; this.radioButton_IsPrint_Yes.Size = new System.Drawing.Size(69, 22); this.radioButton_IsPrint_Yes.TabIndex = 0; this.radioButton_IsPrint_Yes.TabStop = true; this.radioButton_IsPrint_Yes.Text = "æå°"; this.radioButton_IsPrint_Yes.UseVisualStyleBackColor = true; // // radioButton_IsPrint_No // this.radioButton_IsPrint_No.AutoSize = true; this.radioButton_IsPrint_No.Location = new System.Drawing.Point(6, 68); this.radioButton_IsPrint_No.Name = "radioButton_IsPrint_No"; this.radioButton_IsPrint_No.Size = new System.Drawing.Size(87, 22); this.radioButton_IsPrint_No.TabIndex = 1; this.radioButton_IsPrint_No.Text = "䏿å°"; this.radioButton_IsPrint_No.UseVisualStyleBackColor = true; this.timer4.Enabled = true; this.timer4.Tick += new System.EventHandler(this.timer4_Tick); // // Gy_BarCodeBill_automaticallyByPLC_New // @@ -1572,6 +1578,8 @@ this.tabPage_BillInfo.ResumeLayout(false); this.gbUp.ResumeLayout(false); this.gbUp.PerformLayout(); this.groupBox1.ResumeLayout(false); this.groupBox1.PerformLayout(); this.tabPage_ParamsInfo.ResumeLayout(false); this.groupBox_ParamsInfo.ResumeLayout(false); this.groupBox_ParamsInfo.PerformLayout(); @@ -1589,8 +1597,6 @@ this.tabControl1.ResumeLayout(false); this.tabPage4.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.grdBillBarCodeList)).EndInit(); this.groupBox1.ResumeLayout(false); this.groupBox1.PerformLayout(); this.ResumeLayout(false); } @@ -1718,5 +1724,6 @@ private System.Windows.Forms.GroupBox groupBox1; private System.Windows.Forms.RadioButton radioButton_IsPrint_No; private System.Windows.Forms.RadioButton radioButton_IsPrint_Yes; private System.Windows.Forms.Timer timer4; } } WarM/ÌõÂë´òÓ¡/Gy_BarCodeBill_automaticallyByPLC_New.resx
@@ -763,6 +763,9 @@ <metadata name="timer3.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> <value>1177, 17</value> </metadata> <metadata name="timer4.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> <value>17, 64</value> </metadata> <metadata name="$this.TrayHeight" type="System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> <value>64</value> </metadata> WebAPI/Controllers/CJGL/Cj_StationOutBillController.cs
@@ -226,6 +226,12 @@ string Ret = ""; if (oSystemParameter.ShowBill(ref Ret)) { //夿客æ·ä¸ºä¹ä¸ if(oSystemParameter.omodel.WMS_CampanyName == "ä¹ä¸") { HDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); } //夿客æ·ä¸ä¸ºé¾å±±æ±½é if (oSystemParameter.omodel.WMS_CampanyName != "é¾å±±æ±½é " && oSystemParameter.omodel.WMS_CampanyName != "çä¸ç¥º" && oSystemParameter.omodel.WMS_CampanyName != "æ·»åº·ç§æ") //ç³»ç»åæ° { WebAPI/Controllers/JHGL/Gy_RoutingBillController.cs
@@ -286,11 +286,11 @@ DataSet dss; dss = oCN.RunProcReturn("select * from Gy_RoutingBillMain where HInterID=" + HInterID + " and HBillNo='" + HBillNo + "'", "Gy_RoutingBillMain"); //夿æ¯å¦å¯ç¼è¾ if ((dss.Tables[0].Rows[0]["HChecker"].ToString() != "" && dss.Tables[0].Rows[0]["HChecker"] != null) || dss.Tables[0].Rows[0]["HBillStatus"].ToString() != "1") if ((dss.Tables[0].Rows[0]["HChecker"].ToString() != "" && dss.Tables[0].Rows[0]["HChecker"] != null) || (dss.Tables[0].Rows[0]["HBillStatus"].ToString() != "1" && dss.Tables[0].Rows[0]["HBillStatus"].ToString() != "5" && dss.Tables[0].Rows[0]["HBillStatus"].ToString() != "0")) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¤åæ®ç¶ææªå¨å建ï¼ä¸å 许修æ¹ï¼"; objJsonResult.Message = "æ¤åæ®ç¶ææªå¨å建æéåï¼ä¸å 许修æ¹ï¼"; objJsonResult.data = 1; return objJsonResult; } WebAPI/Controllers/XSGL/Kf_SellOutBillController.cs
@@ -1257,7 +1257,7 @@ { List<object> columnNameListSum = new List<object>(); List<object> columnNameList0 = new List<object>(); //List<object> columnNameList1 = new List<object>(); List<object> columnNameList1 = new List<object>(); //List<object> columnNameList2 = new List<object>(); //List<object> columnNameList3 = new List<object>(); //List<object> columnNameList4 = new List<object>(); @@ -1273,13 +1273,13 @@ columnNameList0.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå } ////æ·»å ç产订å åå //foreach (DataColumn col in ds.Tables[1].Columns) //{ // Type dataType = col.DataType; // string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; // columnNameList1.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå //} //æ·»å ç产订å åå foreach (DataColumn col in ds.Tables[1].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList1.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå } ////æ·»å ç¹æ¹ç³è¯·å åå //foreach (DataColumn col in ds.Tables[2].Columns) @@ -1306,7 +1306,7 @@ //} columnNameListSum.Add(columnNameList0); //columnNameListSum.Add(columnNameList1); columnNameListSum.Add(columnNameList1); //columnNameListSum.Add(columnNameList2); //columnNameListSum.Add(columnNameList3); //columnNameListSum.Add(columnNameList4); WebAPI/Controllers/XSGL/Xs_OutDoorBillController.cs
New file @@ -0,0 +1,1270 @@ using Newtonsoft.Json; using Newtonsoft.Json.Linq; using Pub_Class; using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Net; using System.Web.Http; using System.Windows.Forms; using WebAPI.Models; namespace WebAPI.Controllers { //åºé¨ç¡®è®¤åController public class Xs_OutDoorBillController : ApiController { //è·åç³»ç»åæ° Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter(); public DBUtility.ClsPub.Enum_BillStatus BillStatus; public DAL.ClsXs_OutDoorBill BillOld = new DAL.ClsXs_OutDoorBill(); public DAL.ClsXs_OutDoorBill BillNew0 = new DAL.ClsXs_OutDoorBill(); private json objJsonResult = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); DataSet ds; #region åºé¨ç¡®è®¤åå表 æ¥è¯¢ /// <summary> ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Xs_OutDoorBill/list")] [HttpGet] public object getXs_OutDoorBill(string sWhere, string user) { try { List<object> columnNameList = new List<object>(); //æ¥çæé if (!DBUtility.ClsPub.Security_Log("Xs_OutDoorCheckBillList", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ æ¥çæéï¼"; objJsonResult.data = null; return objJsonResult; } if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Xs_OutDoorBillList_Query order by åæ®å· desc", "h_v_Xs_OutDoorBillList_Query"); } else { string sql1 = "select * from h_v_Xs_OutDoorBillList_Query where 1 = 1 "; string sql = sql1 + sWhere + " order by åæ®å· desc"; ds = oCN.RunProcReturn(sql, "h_v_Xs_OutDoorBillList_Query"); } //æ·»å åå foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region åºé¨ç¡®è®¤åå表 已确认åºé¨å表æ¥è¯¢ /// <summary> ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Xs_OutDoorBill/list_checked")] [HttpGet] public object getXs_OutDoorBill_Checked(string sWhere, string user) { try { List<object> columnNameList = new List<object>(); //æ¥çæé if (!DBUtility.ClsPub.Security_Log("Xs_OutDoorCheckBillList", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ æ¥çæéï¼"; objJsonResult.data = null; return objJsonResult; } if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Xs_OutDoorBillList_Checked_Query order by åæ®å· desc", "h_v_Xs_OutDoorBillList_Checked_Query"); } else { string sql1 = "select * from h_v_Xs_OutDoorBillList_Checked_Query where 1 = 1 "; string sql = sql1 + sWhere + " order by åæ®å· desc"; ds = oCN.RunProcReturn(sql, "h_v_Xs_OutDoorBillList_Checked_Query"); } //æ·»å åå foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region åºé¨ç¡®è®¤åä¿å æ°å¢/ç¼è¾ [Route("Xs_OutDoorBill/SaveXs_OutDoorBill")] [HttpPost] public object SaveXs_OutDoorBill([FromBody] JObject msg) { var _value = msg["msg"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); //è¡¨å¤´æ°æ® string msg3 = sArray[1].ToString(); //å表1æ°æ® string refSav = sArray[2].ToString(); //æä½æ¹å¼ string msg4 = sArray[3].ToString(); //ç¨æ· DBUtility.ClsPub.CurUserName = msg4; string UserName = ""; string s = ""; ListModels oListModels = new ListModels(); try { //ç¼è¾æé if (!DBUtility.ClsPub.Security_Log_second("Xs_OutDoorCheckBill_Edit", 1, false, msg4)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ ä¿åæéï¼"; objJsonResult.data = null; return objJsonResult; } DAL.ClsXs_OutDoorBill oBill = new DAL.ClsXs_OutDoorBill(); List<Model.ClsXs_OutDoorBillMain> lsmain = new List<Model.ClsXs_OutDoorBillMain>(); msg2 = msg2.Replace("\\", ""); msg2 = msg2.Replace("\n", ""); //\n lsmain = oListModels.getObjectByJson_Xs_OutDoorBillMain(msg2); foreach (Model.ClsXs_OutDoorBillMain oItem in lsmain) { if (refSav == "Add") { //忮巿¯å¦éå¤ if (BillNew0.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®å·éå¤ï¼ä¸å 许ä¿åï¼"; objJsonResult.data = 1; return objJsonResult; } } if (refSav == "Update") { if (BillOld.ShowBill(oItem.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; } } oItem.HMaker = msg4; oItem.HUpDater = msg4; 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 //msg2 = msg2.Replace("'", "â"); List<Model.ClsXs_OutDoorBillSub> ls = new List<Model.ClsXs_OutDoorBillSub>(); ls = oListModels.getObjectByJson_Xs_OutDoorBillSub(msg3); int i = 0; foreach (Model.ClsXs_OutDoorBillSub oItemSub in ls) { i++; oItemSub.HEntryID = i; //oItemSub.HCloseMan = ""; //è¡å ³é //oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); //oItemSub.HCloseType = false; //å ³éç±»å //oItemSub.HRemark = ""; //夿³¨ //oItemSub.HSourceInterID = 0; // æºå主å ç //oItemSub.HSourceEntryID = 0; //æºååå ç //oItemSub.HSourceBillNo = ""; //æºååå· //oItemSub.HSourceBillType = ""; //æºåç±»å //oItemSub.HRelationQty = 0; //å ³èæ°é //oItemSub.HRelationMoney = 0; //å ³èéé¢ oBill.DetailColl.Add(oItemSub); } //è¿è¡ ä¼è®¡æé´ ç»è´¦ çå¤æåæ§å¶ 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 (refSav == "Add") { // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); } else if (refSav == "Update") { bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); } else { bResult = false; } if (bResult) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "ä¿åæåï¼"; //WebAPIController.Add_Log("éè´§å䏿¨", UserName, "çæéè´§å"); 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("Xs_OutDoorBill/cx")] [HttpGet] public object cx(long HInterID) { try { ds = oCN.RunProcReturn("select * from h_v_Xs_OutDoorBillList where hmainid=" + HInterID, "h_v_Xs_OutDoorBillList"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "falseï¼"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region åºé¨ç¡®è®¤å å é¤ /// <summary> ///åæ°ï¼string HInterIDã ///è¿åå¼ï¼objectã /// </summary> [Route("Xs_OutDoorBill/delete")] [HttpGet] public object deleteXs_OutDoorBill(string HInterID, string user) { try { string s = ""; //æ¥çæé if (!DBUtility.ClsPub.Security_Log("Xs_OutDoorCheckBill_Drop", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ å 餿éï¼"; objJsonResult.data = null; return objJsonResult; } if (HInterID == null || HInterID.Equals("")) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HInterIDä¸è½ä¸ºç©ºï¼"; objJsonResult.data = null; return objJsonResult; } if (BillOld.ShowBill(long.Parse(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; } //å é¤åæ§å¶========================================= string sql1 = "exec h_p_Xs_OutDoorBill_BeforeDelCtrl " + BillOld.omodel.HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'"; ds = oCN.RunProcReturn(sql1, "h_p_Xs_OutDoorBill_BeforeDelCtrl"); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "å é¤å¤±è´¥!åå :å é¤åå¤æå¤±è´¥ï¼è¯·ä¸ç½ç»ç®¡ç人åèç³»"; objJsonResult.data = null; return objJsonResult; } if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "å é¤å¤±è´¥!åå :" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ; objJsonResult.data = null; return objJsonResult; } //================================================================================== //è¿è¡ ä¼è®¡æé´ ç»è´¦ çå¤æåæ§å¶ 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; } oCN.BeginTran(); //ååæºåå ³èæ°é oCN.RunProc("exec h_p_Xs_OutDoorBill_RewriteSellOutBillDelete " + HInterID); oCN.RunProc("delete from Xs_OutDoorBillMain where HInterID = " + HInterID); oCN.RunProc("delete from Xs_OutDoorBillSub where HInterID= " + HInterID); //å é¤åæ§å¶================================================================================== string sql2 = "exec h_p_Xs_OutDoorBill_AfterDelCtrl " + BillOld.omodel.HInterID + ",'" + BillOld.omodel.HBillNo + "','" + user + "'"; ds = oCN.RunProcReturn(sql2, "h_p_Xs_OutDoorBill_AfterDelCtrl"); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { s = "å é¤åå¤æå¤±è´¥ï¼è¯·ä¸ç½ç»ç®¡ç人åèç³»"; objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "å é¤å¤±è´¥!åå :" + s; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") { s = ds.Tables[0].Rows[0]["HRemark"].ToString(); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "å é¤å¤±è´¥!åå :" + s; objJsonResult.data = null; oCN.RollBack(); return objJsonResult; } //============================================================================================== oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "å 餿åï¼"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region åºé¨ç¡®è®¤å å®¡æ ¸/åå®¡æ ¸ /// <summary> /// </summary> /// <param name="HInterID">åæ®ID</param> /// <param name="IsAudit">å®¡æ ¸(0),åå®¡æ ¸(1)</param> /// <param name="CurUserName">å®¡æ ¸äºº</param> /// <returns></returns> [Route("Xs_OutDoorBill/AuditXs_OutDoorBill")] [HttpGet] public object AuditXs_OutDoorBill(int HInterID, int IsAudit, string CurUserName) { string ModRightNameCheck = "Xs_OutDoorCheckBill_Check"; DBUtility.ClsPub.CurUserName = CurUserName; try { //å®¡æ ¸æé if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å®¡æ ¸å¤±è´¥ï¼æ æéï¼"; objJsonResult.data = null; return objJsonResult; } //HInterIDæ°æ®å¤æ if (HInterID <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HInterIDå°äº0ï¼"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); //对HInterIDè¿è¡ç±»åçè½¬æ¢ DAL.ClsXs_OutDoorBill oBill = new DAL.ClsXs_OutDoorBill(); //å®ä¾ååæ®æä½ç±»ï¼ç¨äºè¿è¡ç¸å ³æä½ //é对éè¦è¿è¡çæä½ï¼æ£éªå½ååæ®çç¶ææ¯å¦æ¯æéè¦è¿è¡çæä½ if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //æ ¹æ®HInterIDè·åè¯¥åæ®çæ°æ® { if (oBill.omodel.HCloseMan.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®å·²å ³é!ä¸è½åæ¬¡å®¡æ ¸ï¼"; objJsonResult.data = null; return objJsonResult; } if (oBill.omodel.HDeleteMan.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "忮已ä½åº!ä¸è½åæ¬¡å®¡æ ¸ï¼"; objJsonResult.data = null; return objJsonResult; } if (IsAudit == 0) //å®¡æ ¸å¤æ { if (oBill.omodel.HChecker.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®å·²å®¡æ ¸!ä¸è½åæ¬¡å®¡æ ¸ï¼"; objJsonResult.data = null; return objJsonResult; } } if (IsAudit == 1) //åå®¡æ ¸å¤æ { if (oBill.omodel.HChecker.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®æªå®¡æ ¸!ä¸éè¦åå®¡æ ¸!"; objJsonResult.data = null; return objJsonResult; } } for(int i = 0; i < oBill.DetailColl.Count; i++) { //æ£æ¥æºåæ¯å¦åå¨ string sql = "select * from Kf_ICStockBillMain where HInterID = " + oBill.DetailColl[i].HSourceInterID; ds = oCN.RunProcReturn(sql, "Kf_ICStockBillMain"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å®¡æ ¸å¤±è´¥!åå :æºå[" + oBill.DetailColl[i].HSourceBillNo + "]æ°æ®ä¸åå¨ï¼"; objJsonResult.data = null; return objJsonResult; } else if (ds.Tables[0].Rows[0]["HBillStatus"].ToString() != "2") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å®¡æ ¸å¤±è´¥!åå :æºå[" + oBill.DetailColl[i].HSourceBillNo + "]æªå¤äºå·²å®¡æ ¸ç¶æ!"; objJsonResult.data = null; return objJsonResult; } } } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®ä¸åå¨!åå :" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } //è¿è¡éè¦è¿è¡çå®¡æ ¸/åå®¡æ ¸æä½ if (IsAudit == 0) //å®¡æ ¸æäº¤ { //è¿è¡ ä¼è®¡æé´ ç»è´¦ çå¤æåæ§å¶ 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; } //å®¡æ ¸åæ§å¶========================================= string sql1 = "exec h_p_Xs_OutDoorBill_BeforeCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'"; ds = oCN.RunProcReturn(sql1, "h_p_Xs_OutDoorBill_BeforeCheckCtrl"); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å®¡æ ¸å¤±è´¥!åå :å®¡æ ¸åå¤æå¤±è´¥ï¼è¯·ä¸ç½ç»ç®¡ç人åèç³»"; objJsonResult.data = null; return objJsonResult; } if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å®¡æ ¸å¤±è´¥!åå :" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ; objJsonResult.data = null; return objJsonResult; } //================================================================================== oCN.BeginTran(); //å®¡æ ¸æäº¤ if (oBill.CheckBill(oCN,oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Xs_OutDoorBill_AfterCheckCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true) { oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "å®¡æ ¸æå"; objJsonResult.data = null; return objJsonResult; } else { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å®¡æ ¸å¤±è´¥!åå :" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } if (IsAudit == 1) //åå®¡æ ¸æäº¤ { //è¿è¡ ä¼è®¡æé´ ç»è´¦ çå¤æåæ§å¶ 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; } //åå®¡æ ¸åæ§å¶========================================= string sql1 = "exec h_p_Xs_OutDoorBill_BeforeUnCheckCtrl " + oBill.omodel.HInterID + ",'" + oBill.omodel.HBillNo + "','" + CurUserName + "'"; ds = oCN.RunProcReturn(sql1, "h_p_Xs_OutDoorBill_BeforeUnCheckCtrl"); if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åå®¡æ ¸å¤±è´¥!åå :åå®¡æ ¸åå¤æå¤±è´¥ï¼è¯·ä¸ç½ç»ç®¡ç人åèç³»"; objJsonResult.data = null; return objJsonResult; } if (ds.Tables[0].Rows[0]["HBack"].ToString() != "0") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åå®¡æ ¸å¤±è´¥!åå :" + ds.Tables[0].Rows[0]["HRemark"].ToString(); ; objJsonResult.data = null; return objJsonResult; } //=========================================================== oCN.BeginTran(); //åå®¡æ ¸æäº¤AbandonCheck if (oBill.AbandonCheck(oCN,oBill.omodel.HInterID, oBill.omodel.HBillNo, "h_p_Xs_OutDoorBill_AfterUnCheckCtrl", CurUserName, ref DBUtility.ClsPub.sExeReturnInfo) == true) { oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "åå®¡æ ¸æå"; objJsonResult.data = null; return objJsonResult; } else { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åå®¡æ ¸å¤±è´¥!åå :" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å®¡æ ¸å¤±è´¥æè åå®¡æ ¸å¤±è´¥ï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region åºé¨ç¡®è®¤å å ³é/åå ³é /// <summary> /// </summary> /// <param name="HInterID">åæ®ID</param> /// <param name="IsAudit">å ³é(0),åå ³é(1)</param> /// <param name="CurUserName">å ³é人</param> /// <returns></returns> [Route("Xs_OutDoorBill/CloseXs_OutDoorBill")] [HttpGet] public object CloseXs_OutDoorBill(int HInterID, int IsAudit, string CurUserName) { string ModRightNameCheck = "Xs_OutDoorCheckBill_Close"; DBUtility.ClsPub.CurUserName = CurUserName; try { //æ£æ¥æé if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å ³éå¤±è´¥ï¼æ æéï¼"; objJsonResult.data = null; return objJsonResult; } //HInterIDæ°æ®å¤æ if (HInterID <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HInterIDå°äº0ï¼"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); //对HInterIDè¿è¡ç±»åçè½¬æ¢ DAL.ClsXs_OutDoorBill oBill = new DAL.ClsXs_OutDoorBill(); //å®ä¾ååæ®æä½ç±»ï¼ç¨äºè¿è¡ç¸å ³æä½ //é对éè¦è¿è¡çæä½ï¼æ£éªå½ååæ®çç¶ææ¯å¦æ¯æéè¦è¿è¡çæä½ if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //æ ¹æ®HInterIDè·åè¯¥åæ®çæ°æ® { if (oBill.omodel.HDeleteMan.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "忮已ä½åº!ä¸è½è¿è¡å ³éï¼"; objJsonResult.data = null; return objJsonResult; } if (oBill.omodel.HChecker.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®æªå®¡æ ¸!ä¸è½è¿è¡å ³éï¼"; objJsonResult.data = null; return objJsonResult; } if (IsAudit == 0) //å ³é夿 { if (oBill.omodel.HCloseMan.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®å·²å ³é!ä¸è½åæ¬¡å ³éï¼"; objJsonResult.data = null; return objJsonResult; } } if (IsAudit == 1) //åå ³é夿 { if (oBill.omodel.HCloseMan.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®æªå ³é!ä¸éè¦åå ³éï¼"; objJsonResult.data = null; return objJsonResult; } } } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®ä¸åå¨!åå :" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } //è¿è¡éè¦è¿è¡çå ³é/åå ³éæä½ if (IsAudit == 0) //å ³éæäº¤ { //å ³éæäº¤ if (oBill.CloseBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "å ³éæå"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å ³é失败!åå :" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } if (IsAudit == 1) //åå ³éæäº¤ { //åå ³éæäº¤ if (oBill.CancelClose(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "åå ³éæå"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åå ³é失败!åå :" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å ³é失败æè åå ³é失败ï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region åºé¨ç¡®è®¤å ä½åº/åä½åº /// <summary> /// </summary> /// <param name="HInterID">åæ®ID</param> /// <param name="IsAudit">ä½åº(0),åä½åº(1)</param> /// <param name="CurUserName">ä½åºäºº</param> /// <returns></returns> [Route("Xs_OutDoorBill/DeleteXs_OutDoorBill")] [HttpGet] public object DeleteXs_OutDoorBill(int HInterID, int IsAudit, string CurUserName) { string ModRightNameCheck = "Xs_OutDoorCheckBill_Delete"; DBUtility.ClsPub.CurUserName = CurUserName; try { //æ£æ¥æé if (!DBUtility.ClsPub.Security_Log_second(ModRightNameCheck, 1, false, CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä½åºå¤±è´¥ï¼æ æéï¼"; objJsonResult.data = null; return objJsonResult; } //HInterIDæ°æ®å¤æ if (HInterID <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HInterIDå°äº0ï¼"; objJsonResult.data = null; return objJsonResult; } Int64 lngBillKey = 0; lngBillKey = DBUtility.ClsPub.isLong(HInterID); //对HInterIDè¿è¡ç±»åçè½¬æ¢ DAL.ClsXs_OutDoorBill oBill = new DAL.ClsXs_OutDoorBill(); //å®ä¾ååæ®æä½ç±»ï¼ç¨äºè¿è¡ç¸å ³æä½ //é对éè¦è¿è¡çæä½ï¼æ£éªå½ååæ®çç¶ææ¯å¦æ¯æéè¦è¿è¡çæä½ if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) //æ ¹æ®HInterIDè·åè¯¥åæ®çæ°æ® { if (oBill.omodel.HChecker.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®å·²å®¡æ ¸!ä¸è½è¿è¡ä½åºï¼"; objJsonResult.data = null; return objJsonResult; } if (IsAudit == 0) //ä½åºå¤æ { if (oBill.omodel.HDeleteMan.Trim() != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "忮已ä½åº!ä¸è½åä½åºï¼"; objJsonResult.data = null; return objJsonResult; } } if (IsAudit == 1) //åä½åºå¤æ { if (oBill.omodel.HDeleteMan.Trim() == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®æªä½åº!ä¸éè¦åä½åºï¼"; objJsonResult.data = null; return objJsonResult; } } } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®ä¸åå¨!åå :" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } //è¿è¡éè¦è¿è¡çä½åº/åä½åºæä½ if (IsAudit == 0) //ä½åºæäº¤ { //ä½åºæäº¤ if (oBill.Cancelltion(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "ä½åºæå"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä½åºå¤±è´¥!åå :" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } if (IsAudit == 1) //åå ³éæäº¤ { //åå ³éæäº¤ if (oBill.AbandonCancelltion(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo) == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "åä½åºæå"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åä½åºå¤±è´¥!åå :" + DBUtility.ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä½åºå¤±è´¥æè åä½åºå¤±è´¥ï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region åºé¨ç¡®è®¤åå表 确认åºé¨-æ¤é /// <summary> ///åæ°ï¼string HInterIDã ///è¿åå¼ï¼objectã /// </summary> [Route("Xs_OutDoorBill/revoke")] [HttpGet] public object revokeXs_OutDoorBill(string HInterID,string HBillNo, string user) { try { oCN.BeginTran(); string sql = " update Xs_OutDoorBillMain set HOutCheckMan = '',HOutCheckDate = null where HInterID = " + HInterID; oCN.RunProc(sql); //åå ¥æ¥å¿ string WorkList = "æ¤éåæ®-åºé¨ç¡®è®¤ï¼åæ®å·ï¼" + HBillNo; string MvarReportTitle = BillNew0.MvarReportTitle; string SystemName = "LMES-" + MvarReportTitle + "模å"; string ComputerName = SystemInformation.ComputerName; string IPAddress = Dns.GetHostEntry(Dns.GetHostName()).AddressList[0].ToString(); oCN.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + "(getdate(),'" + user + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','æ¤é')" ); oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "æ¤éæåï¼"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region åºé¨ç¡®è®¤å æ«ç åºé¨ç¡®è®¤-è·ååæ®ä¿¡æ¯ [Route("Xs_OutDoorBill/cx_PDA")] [HttpGet] public object cx_PDA(string HBillNo,int HStockOrgID) { try { List<object> columnNameList = new List<object>(); ds = oCN.RunProcReturn("select * from h_v_Xs_OutDoorBillList_PDA where åæ®å·='" + HBillNo + "' and HStockOrgID = " + HStockOrgID, "h_v_Xs_OutDoorBillList_PDA"); //æ·»å åå foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = ds.Tables[0]; objJsonResult.list = columnNameList; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region åºé¨ç¡®è®¤å æ«ç åºé¨ç¡®è®¤-æäº¤ [Route("Xs_OutDoorBill/OutDoorCheck_Xs_OutDoorBill")] [HttpPost] public object OutDoorCheck_Xs_OutDoorBill([FromBody] JObject msg) { var _value = msg["msg"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); //è¡¨å¤´æ°æ® string msg3 = sArray[1].ToString(); //å表1æ°æ® string msg4 = sArray[2].ToString(); //ç¨æ· DBUtility.ClsPub.CurUserName = msg4; string UserName = ""; string s = ""; ListModels oListModels = new ListModels(); try { DAL.ClsXs_OutDoorBill oBill = new DAL.ClsXs_OutDoorBill(); List<Model.ClsXs_OutDoorBillMain> lsmain = new List<Model.ClsXs_OutDoorBillMain>(); msg2 = msg2.Replace("\\", ""); msg2 = msg2.Replace("\n", ""); //\n lsmain = oListModels.getObjectByJson_Xs_OutDoorBillMain(msg2); oCN.BeginTran(); Model.ClsXs_OutDoorBillMain oItem = lsmain[0]; if (BillOld.ShowBill(oItem.HInterID, ref s) == false) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¤åæ®æè¯¯ï¼"; objJsonResult.data = 1; return objJsonResult; } //夿æ¯å¦ä¸ºå·²å®¡æ ¸ç¶æ if (BillOld.omodel.HBillStatus != 2) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æäº¤å¤±è´¥ï¼æ¤åæ®å½åç¶æä¸ä¸ºâå·²å®¡æ ¸âï¼"; objJsonResult.data = 1; return objJsonResult; } if (BillOld.omodel.HOutCheckMan != "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æäº¤å¤±è´¥ï¼æ¤åæ®å·²ç»æäº¤ï¼æ ééå¤æäº¤ï¼"; objJsonResult.data = 1; return objJsonResult; } string HShipper = oItem.HShipper; string HCarNumber = oItem.HCarNumber; string HPhone = oItem.HPhone; string HOutReason = oItem.HOutReason; string HMaterName = oItem.HMaterName; string HRemark = oItem.HRemark; string HOutCheckMan = msg4; string sql = "update Xs_OutDoorBillMain set " + //"HShipper = '" + HShipper + "'" + //",HCarNumber = '" + HCarNumber + "'" + //",HPhone = '" + HPhone + "'" + //",HOutReason='" + HOutReason + "'" + //",HMaterName ='" + HMaterName + "'" + //",HRemark = '" + HRemark + "'" + "HOutCheckMan = '" + HOutCheckMan + "'" + ",HOutCheckDate = getdate() " + "where HInterID = " + oItem.HInterID; oCN.RunProc(sql); //==============================åå ¥æ¥å¿ string WorkList = "åæ®-åºé¨ç¡®è®¤ï¼åæ®å·ï¼" + oItem.HBillNo; string MvarReportTitle = BillNew0.MvarReportTitle; string SystemName = "LMES-" + MvarReportTitle + "模å"; string ComputerName = SystemInformation.ComputerName; string IPAddress = Dns.GetHostEntry(Dns.GetHostName()).AddressList[0].ToString(); oCN.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + "(getdate(),'" + msg4 + "','" + ComputerName + "','" + WorkList + "','" + SystemName + "','" + IPAddress + "','åºé¨ç¡®è®¤')" ); //======================================= oCN.Commit(); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "æäº¤æåï¼"; objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败ï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region åºé¨ç¡®è®¤åæ¥è¡¨ [Route("Xs_OutDoorBill/Xs_OutDoorBillReport")] [HttpGet] public object Xs_OutDoorBillReport(string HBeginDate, string HEndDate, string sWhere, string user,int HOperationType) { try { if (!DBUtility.ClsPub.Security_Log("Xs_OutDoorBillReport", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ æ¥çæéï¼"; objJsonResult.data = null; return objJsonResult; } string sql = "exec h_p_Xs_OutDoorBillReport '" + HBeginDate + "','" + HEndDate + "','" + sWhere + "'," + HOperationType; ds = oCN.RunProcReturn(sql, "h_p_Xs_OutDoorBillReport"); DataTable dt = ds.Tables[0]; //è·ååå List<object> columnNameList = new List<object>(); //æ·»å åå foreach (DataColumn col in ds.Tables[0].Columns) { Type dataType = col.DataType; string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}"; columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//è·åå°DataColumnå对象çåå } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.list = columnNameList; objJsonResult.data = ds.Tables; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion } } WebAPI/ListModels.cs
@@ -4152,6 +4152,21 @@ } #endregion #region åºé¨ç¡®è®¤å_æ° public List<Model.ClsXs_OutDoorBillMain> getObjectByJson_Xs_OutDoorBillMain(string jsonString) { jsonString = "[" + jsonString.ToString() + "]"; List<Model.ClsXs_OutDoorBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXs_OutDoorBillMain>>(jsonString); return list; } public List<Model.ClsXs_OutDoorBillSub> getObjectByJson_Xs_OutDoorBillSub(string jsonString) { jsonString = "[" + jsonString.ToString() + "]"; List<Model.ClsXs_OutDoorBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsXs_OutDoorBillSub>>(jsonString); return list; } #endregion #region åºæ¶é款å /// <summary> /// åºæ¶é款å主表json WebAPI/Properties/PublishProfiles/FolderProfile6.pubxml.user
@@ -4,7 +4,7 @@ --> <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <PropertyGroup> <History>True|2024-10-11T08:49:55.1188159Z;True|2024-10-11T16:11:04.2021026+08:00;True|2024-10-11T15:48:50.7687290+08:00;True|2024-10-11T15:33:27.8527915+08:00;True|2024-10-11T14:49:01.6142514+08:00;False|2024-10-11T14:48:33.6149374+08:00;True|2024-10-11T13:50:33.4424142+08:00;False|2024-10-11T13:41:53.6580199+08:00;False|2024-10-11T13:41:39.5167380+08:00;False|2024-10-11T13:37:52.6531605+08:00;False|2024-10-11T13:37:11.7263329+08:00;</History> <History>True|2024-10-18T08:43:35.1364495Z;False|2024-10-18T16:42:59.5332813+08:00;True|2024-10-18T11:56:15.8267584+08:00;False|2024-10-18T11:55:41.7667883+08:00;True|2024-10-17T16:35:21.5250546+08:00;True|2024-10-17T15:39:45.6140281+08:00;True|2024-10-17T15:13:04.7104524+08:00;True|2024-10-17T14:54:20.5672206+08:00;True|2024-10-17T13:03:49.0562978+08:00;True|2024-10-16T11:57:09.2205029+08:00;True|2024-10-16T11:47:09.1175797+08:00;True|2024-10-16T11:12:45.2631759+08:00;False|2024-10-16T11:11:57.2236500+08:00;True|2024-10-15T16:20:02.9116206+08:00;True|2024-10-15T15:58:43.2926050+08:00;True|2024-10-15T15:42:21.7936803+08:00;True|2024-10-15T15:08:43.2300880+08:00;True|2024-10-15T14:57:53.1025144+08:00;True|2024-10-15T14:49:52.0203753+08:00;True|2024-10-15T13:43:28.4322672+08:00;True|2024-10-15T13:02:51.9833820+08:00;True|2024-10-15T10:35:13.3052884+08:00;True|2024-10-15T10:31:23.7280933+08:00;True|2024-10-15T10:16:45.0292893+08:00;True|2024-10-15T09:59:30.2256849+08:00;True|2024-10-15T09:53:37.7284098+08:00;True|2024-10-15T09:45:34.6928334+08:00;False|2024-10-15T09:45:08.0828173+08:00;True|2024-10-15T09:20:15.0444151+08:00;False|2024-10-15T09:18:15.4388995+08:00;True|2024-10-14T15:31:49.0978922+08:00;False|2024-10-14T15:31:08.3741419+08:00;True|2024-10-14T15:09:44.3508500+08:00;True|2024-10-14T14:45:34.5430843+08:00;True|2024-10-14T14:04:11.8258435+08:00;True|2024-10-14T13:54:24.2353356+08:00;True|2024-10-14T13:48:16.0893349+08:00;False|2024-10-14T13:47:57.1909782+08:00;True|2024-10-14T11:12:14.9583385+08:00;False|2024-10-14T11:11:21.0058133+08:00;True|2024-10-11T16:49:55.1188159+08:00;True|2024-10-11T16:11:04.2021026+08:00;True|2024-10-11T15:48:50.7687290+08:00;True|2024-10-11T15:33:27.8527915+08:00;True|2024-10-11T14:49:01.6142514+08:00;False|2024-10-11T14:48:33.6149374+08:00;True|2024-10-11T13:50:33.4424142+08:00;False|2024-10-11T13:41:53.6580199+08:00;False|2024-10-11T13:41:39.5167380+08:00;False|2024-10-11T13:37:52.6531605+08:00;False|2024-10-11T13:37:11.7263329+08:00;</History> <_PublishTargetUrl>D:\ç½ç«åå¸\æºäºMESWMS\API</_PublishTargetUrl> </PropertyGroup> <ItemGroup> @@ -45,19 +45,19 @@ <publishTime>02/22/2013 16:43:40</publishTime> </File> <File Include="bin/BLL.dll"> <publishTime>10/11/2024 13:37:29</publishTime> <publishTime>10/17/2024 15:39:03</publishTime> </File> <File Include="bin/BLL.pdb"> <publishTime>10/11/2024 13:37:29</publishTime> <publishTime>10/17/2024 15:39:03</publishTime> </File> <File Include="bin/BouncyCastle.Crypto.dll"> <publishTime>12/18/2020 05:32:28</publishTime> </File> <File Include="bin/DAL.dll"> <publishTime>10/11/2024 13:37:28</publishTime> <publishTime>10/17/2024 15:39:00</publishTime> </File> <File Include="bin/DAL.pdb"> <publishTime>10/11/2024 13:37:28</publishTime> <publishTime>10/17/2024 15:39:00</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 22:52:40</publishTime> @@ -111,10 +111,10 @@ <publishTime>07/25/2012 19:48:56</publishTime> </File> <File Include="bin/Model.dll"> <publishTime>10/11/2024 13:37:24</publishTime> <publishTime>10/17/2024 14:53:25</publishTime> </File> <File Include="bin/Model.pdb"> <publishTime>10/11/2024 13:37:24</publishTime> <publishTime>10/17/2024 14:53:25</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> <publishTime>04/06/2023 15:57:02</publishTime> @@ -294,13 +294,13 @@ <publishTime>11/24/2014 19:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> <publishTime>10/11/2024 16:49:47</publishTime> <publishTime>10/18/2024 16:43:27</publishTime> </File> <File Include="bin/WebAPI.pdb"> <publishTime>10/11/2024 16:49:47</publishTime> <publishTime>10/18/2024 16:43:27</publishTime> </File> <File Include="bin/WebAPI.XmlSerializers.dll"> <publishTime>10/11/2024 16:49:54</publishTime> <publishTime>10/18/2024 16:43:32</publishTime> </File> <File Include="bin/WebGrease.dll"> <publishTime>07/18/2013 01:03:52</publishTime> @@ -495,7 +495,7 @@ <publishTime>05/06/2024 13:47:57</publishTime> </File> <File Include="Web.config"> <publishTime>10/11/2024 13:50:30</publishTime> <publishTime>10/17/2024 11:19:31</publishTime> </File> </ItemGroup> </Project> WebAPI/Properties/PublishProfiles/FolderProfilewtt.pubxml.user
@@ -4,7 +4,7 @@ --> <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> <PropertyGroup> <History>True|2024-10-24T09:50:10.0801119Z;False|2024-10-24T17:49:21.0726954+08:00;True|2024-10-24T17:40:46.0577697+08:00;False|2024-10-24T17:39:53.3743103+08:00;True|2024-10-24T14:57:00.6752320+08:00;True|2024-10-24T10:08:39.8269595+08:00;False|2024-10-24T10:07:47.3834032+08:00;True|2024-10-22T10:33:10.1961964+08:00;True|2024-10-21T08:43:54.1422810+08:00;False|2024-10-21T08:43:00.6574201+08:00;True|2024-10-18T14:56:55.6749850+08:00;True|2024-10-18T14:47:05.1073813+08:00;True|2024-10-18T11:24:23.9069952+08:00;True|2024-10-18T11:14:57.8486575+08:00;False|2024-10-18T11:14:07.5289704+08:00;True|2024-10-18T10:57:00.2425175+08:00;False|2024-10-18T10:56:04.8949960+08:00;True|2024-10-15T16:44:32.6189434+08:00;True|2024-10-15T14:38:49.8658311+08:00;True|2024-10-15T09:49:55.2197004+08:00;False|2024-10-15T09:49:14.8790668+08:00;False|2024-10-12T15:28:24.1303695+08:00;True|2024-10-10T10:59:36.7878419+08:00;False|2024-10-10T10:58:40.9900315+08:00;True|2024-10-03T10:57:02.9299524+08:00;True|2024-10-03T10:02:10.1156720+08:00;True|2024-09-30T11:07:22.5376794+08:00;True|2024-09-30T10:15:40.3990343+08:00;True|2024-09-30T10:04:38.1942221+08:00;True|2024-09-29T19:22:01.5340857+08:00;False|2024-09-29T19:21:12.2387012+08:00;True|2024-09-26T09:50:22.2637977+08:00;True|2024-09-25T20:44:33.3994634+08:00;True|2024-09-25T16:07:23.2747063+08:00;True|2024-09-25T14:55:37.9194143+08:00;True|2024-09-24T20:03:43.9841995+08:00;True|2024-09-24T19:42:48.7479102+08:00;True|2024-09-24T19:38:31.5777012+08:00;True|2024-09-24T16:26:58.5969765+08:00;True|2024-09-24T15:31:00.7140362+08:00;True|2024-09-24T10:17:46.7830753+08:00;True|2024-09-24T09:40:19.5788062+08:00;False|2024-09-24T09:39:27.4521802+08:00;True|2024-09-23T19:35:55.3572583+08:00;True|2024-09-23T18:53:15.4480118+08:00;False|2024-09-23T18:52:22.0135173+08:00;True|2024-09-20T09:59:12.9943442+08:00;False|2024-09-20T09:58:18.6945854+08:00;True|2024-09-12T20:40:58.7161451+08:00;False|2024-09-12T20:40:00.0672966+08:00;True|2024-09-12T16:47:22.7671323+08:00;True|2024-09-12T16:34:18.5850144+08:00;True|2024-09-12T16:13:32.1929032+08:00;True|2024-09-12T09:12:54.4456999+08:00;False|2024-09-12T09:12:06.1002866+08:00;False|2024-09-11T21:06:15.4423786+08:00;True|2024-09-10T15:26:48.7055081+08:00;True|2024-09-10T09:26:36.8509916+08:00;True|2024-09-09T19:51:32.6059511+08:00;True|2024-09-09T19:05:47.5349922+08:00;True|2024-09-09T09:26:23.2022383+08:00;False|2024-09-09T09:25:27.3736749+08:00;True|2024-09-06T15:32:52.1865278+08:00;True|2024-09-06T15:16:01.1405794+08:00;True|2024-09-06T14:21:05.7482343+08:00;True|2024-09-06T14:09:17.1494566+08:00;True|2024-09-06T13:49:56.4128481+08:00;True|2024-09-06T13:11:53.0863947+08:00;True|2024-09-06T09:34:54.5934463+08:00;True|2024-09-06T08:47:19.9744092+08:00;True|2024-09-05T15:01:38.6968629+08:00;True|2024-09-05T14:56:09.3505818+08:00;True|2024-09-05T14:49:56.8774757+08:00;True|2024-09-05T08:14:13.2359921+08:00;False|2024-09-05T08:13:11.8797534+08:00;True|2024-09-03T16:52:02.8227375+08:00;False|2024-09-03T16:51:32.4250926+08:00;True|2024-09-03T16:33:05.7269609+08:00;True|2024-09-03T16:00:15.0288548+08:00;True|2024-08-29T08:06:32.4732067+08:00;False|2024-08-29T08:06:02.4801886+08:00;True|2024-08-26T10:17:08.7733750+08:00;False|2024-08-26T10:11:05.1864217+08:00;False|2024-08-26T09:50:31.1539306+08:00;False|2024-08-26T09:47:37.4351309+08:00;True|2024-08-16T16:55:32.0918962+08:00;True|2024-08-16T16:53:23.3505641+08:00;False|2024-08-16T16:49:30.4579212+08:00;False|2024-08-16T16:47:01.9799743+08:00;</History> <History>True|2024-10-25T01:54:06.8572059Z;True|2024-10-25T08:21:42.6333993+08:00;True|2024-10-24T17:56:19.5319332+08:00;True|2024-10-24T17:50:10.0801119+08:00;False|2024-10-24T17:49:21.0726954+08:00;True|2024-10-24T17:40:46.0577697+08:00;False|2024-10-24T17:39:53.3743103+08:00;True|2024-10-24T14:57:00.6752320+08:00;True|2024-10-24T10:08:39.8269595+08:00;False|2024-10-24T10:07:47.3834032+08:00;True|2024-10-22T10:33:10.1961964+08:00;True|2024-10-21T08:43:54.1422810+08:00;False|2024-10-21T08:43:00.6574201+08:00;True|2024-10-18T14:56:55.6749850+08:00;True|2024-10-18T14:47:05.1073813+08:00;True|2024-10-18T11:24:23.9069952+08:00;True|2024-10-18T11:14:57.8486575+08:00;False|2024-10-18T11:14:07.5289704+08:00;True|2024-10-18T10:57:00.2425175+08:00;False|2024-10-18T10:56:04.8949960+08:00;True|2024-10-15T16:44:32.6189434+08:00;True|2024-10-15T14:38:49.8658311+08:00;True|2024-10-15T09:49:55.2197004+08:00;False|2024-10-15T09:49:14.8790668+08:00;False|2024-10-12T15:28:24.1303695+08:00;True|2024-10-10T10:59:36.7878419+08:00;False|2024-10-10T10:58:40.9900315+08:00;True|2024-10-03T10:57:02.9299524+08:00;True|2024-10-03T10:02:10.1156720+08:00;True|2024-09-30T11:07:22.5376794+08:00;True|2024-09-30T10:15:40.3990343+08:00;True|2024-09-30T10:04:38.1942221+08:00;True|2024-09-29T19:22:01.5340857+08:00;False|2024-09-29T19:21:12.2387012+08:00;True|2024-09-26T09:50:22.2637977+08:00;True|2024-09-25T20:44:33.3994634+08:00;True|2024-09-25T16:07:23.2747063+08:00;True|2024-09-25T14:55:37.9194143+08:00;True|2024-09-24T20:03:43.9841995+08:00;True|2024-09-24T19:42:48.7479102+08:00;True|2024-09-24T19:38:31.5777012+08:00;True|2024-09-24T16:26:58.5969765+08:00;True|2024-09-24T15:31:00.7140362+08:00;True|2024-09-24T10:17:46.7830753+08:00;True|2024-09-24T09:40:19.5788062+08:00;False|2024-09-24T09:39:27.4521802+08:00;True|2024-09-23T19:35:55.3572583+08:00;True|2024-09-23T18:53:15.4480118+08:00;False|2024-09-23T18:52:22.0135173+08:00;True|2024-09-20T09:59:12.9943442+08:00;False|2024-09-20T09:58:18.6945854+08:00;True|2024-09-12T20:40:58.7161451+08:00;False|2024-09-12T20:40:00.0672966+08:00;True|2024-09-12T16:47:22.7671323+08:00;True|2024-09-12T16:34:18.5850144+08:00;True|2024-09-12T16:13:32.1929032+08:00;True|2024-09-12T09:12:54.4456999+08:00;False|2024-09-12T09:12:06.1002866+08:00;False|2024-09-11T21:06:15.4423786+08:00;True|2024-09-10T15:26:48.7055081+08:00;True|2024-09-10T09:26:36.8509916+08:00;True|2024-09-09T19:51:32.6059511+08:00;True|2024-09-09T19:05:47.5349922+08:00;True|2024-09-09T09:26:23.2022383+08:00;False|2024-09-09T09:25:27.3736749+08:00;True|2024-09-06T15:32:52.1865278+08:00;True|2024-09-06T15:16:01.1405794+08:00;True|2024-09-06T14:21:05.7482343+08:00;True|2024-09-06T14:09:17.1494566+08:00;True|2024-09-06T13:49:56.4128481+08:00;True|2024-09-06T13:11:53.0863947+08:00;True|2024-09-06T09:34:54.5934463+08:00;True|2024-09-06T08:47:19.9744092+08:00;True|2024-09-05T15:01:38.6968629+08:00;True|2024-09-05T14:56:09.3505818+08:00;True|2024-09-05T14:49:56.8774757+08:00;True|2024-09-05T08:14:13.2359921+08:00;False|2024-09-05T08:13:11.8797534+08:00;True|2024-09-03T16:52:02.8227375+08:00;False|2024-09-03T16:51:32.4250926+08:00;True|2024-09-03T16:33:05.7269609+08:00;True|2024-09-03T16:00:15.0288548+08:00;True|2024-08-29T08:06:32.4732067+08:00;False|2024-08-29T08:06:02.4801886+08:00;True|2024-08-26T10:17:08.7733750+08:00;False|2024-08-26T10:11:05.1864217+08:00;False|2024-08-26T09:50:31.1539306+08:00;False|2024-08-26T09:47:37.4351309+08:00;True|2024-08-16T16:55:32.0918962+08:00;True|2024-08-16T16:53:23.3505641+08:00;False|2024-08-16T16:49:30.4579212+08:00;False|2024-08-16T16:47:01.9799743+08:00;</History> <_PublishTargetUrl>G:\issWeb\ç½ç«åå¸\API</_PublishTargetUrl> </PropertyGroup> <ItemGroup> @@ -45,28 +45,28 @@ <publishTime>02/22/2013 16:43:40</publishTime> </File> <File Include="bin/BLL.dll"> <publishTime>10/24/2024 17:49:38</publishTime> <publishTime>10/25/2024 09:53:32</publishTime> </File> <File Include="bin/BLL.pdb"> <publishTime>10/24/2024 17:49:38</publishTime> <publishTime>10/25/2024 09:53:32</publishTime> </File> <File Include="bin/BouncyCastle.Crypto.dll"> <publishTime>12/18/2020 05:32:28</publishTime> </File> <File Include="bin/DAL.dll"> <publishTime>10/24/2024 17:49:36</publishTime> <publishTime>10/25/2024 09:53:30</publishTime> </File> <File Include="bin/DAL.pdb"> <publishTime>10/24/2024 17:49:36</publishTime> <publishTime>10/25/2024 09:53:30</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 22:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> <publishTime>10/24/2024 17:49:31</publishTime> <publishTime>10/25/2024 09:53:23</publishTime> </File> <File Include="bin/DBUtility.pdb"> <publishTime>10/24/2024 17:49:31</publishTime> <publishTime>10/25/2024 09:53:23</publishTime> </File> <File Include="bin/Grpc.Core.Api.dll"> <publishTime>03/22/2022 13:17:26</publishTime> @@ -111,10 +111,10 @@ <publishTime>07/25/2012 19:48:56</publishTime> </File> <File Include="bin/Model.dll"> <publishTime>10/24/2024 17:49:32</publishTime> <publishTime>10/25/2024 09:53:25</publishTime> </File> <File Include="bin/Model.pdb"> <publishTime>10/24/2024 17:49:32</publishTime> <publishTime>10/25/2024 09:53:25</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> <publishTime>04/15/2024 12:55:45</publishTime> @@ -147,34 +147,34 @@ <publishTime>10/23/2021 17:07:54</publishTime> </File> <File Include="bin/Pub_Class.dll"> <publishTime>10/24/2024 17:49:29</publishTime> <publishTime>10/25/2024 09:53:21</publishTime> </File> <File Include="bin/Pub_Class.pdb"> <publishTime>10/24/2024 17:49:29</publishTime> <publishTime>10/25/2024 09:53:21</publishTime> </File> <File Include="bin/Pub_Control.dll"> <publishTime>10/24/2024 17:49:30</publishTime> <publishTime>10/25/2024 09:53:22</publishTime> </File> <File Include="bin/Pub_Control.pdb"> <publishTime>10/24/2024 17:49:30</publishTime> <publishTime>10/25/2024 09:53:22</publishTime> </File> <File Include="bin/RestSharp.dll"> <publishTime>08/31/2012 06:22:50</publishTime> </File> <File Include="bin/SQLHelper.dll"> <publishTime>10/24/2024 17:49:30</publishTime> <publishTime>10/25/2024 09:53:22</publishTime> </File> <File Include="bin/SQLHelper.pdb"> <publishTime>10/24/2024 17:49:30</publishTime> <publishTime>10/25/2024 09:53:22</publishTime> </File> <File Include="bin/Swashbuckle.Core.dll"> <publishTime>02/16/2015 01:57:08</publishTime> </File> <File Include="bin/SyntacticSugar.dll"> <publishTime>10/24/2024 17:47:35</publishTime> <publishTime>10/25/2024 09:50:38</publishTime> </File> <File Include="bin/SyntacticSugar.pdb"> <publishTime>10/24/2024 17:47:35</publishTime> <publishTime>10/25/2024 09:50:38</publishTime> </File> <File Include="bin/System.Buffers.dll"> <publishTime>07/19/2017 18:01:28</publishTime> @@ -285,19 +285,19 @@ <publishTime>05/09/2023 10:43:40</publishTime> </File> <File Include="bin/TopSdk.dll"> <publishTime>10/24/2024 17:47:41</publishTime> <publishTime>10/25/2024 09:50:44</publishTime> </File> <File Include="bin/TopSdk.pdb"> <publishTime>10/24/2024 17:47:41</publishTime> <publishTime>10/25/2024 09:50:44</publishTime> </File> <File Include="bin/WebActivatorEx.dll"> <publishTime>11/24/2014 19:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> <publishTime>10/24/2024 17:50:07</publishTime> <publishTime>10/25/2024 09:54:04</publishTime> </File> <File Include="bin/WebAPI.pdb"> <publishTime>10/24/2024 17:50:07</publishTime> <publishTime>10/25/2024 09:54:04</publishTime> </File> <File Include="bin/WebAPI.XmlSerializers.dll"> <publishTime>08/16/2024 16:55:28</publishTime> WebAPI/WebAPI.csproj
@@ -443,6 +443,7 @@ <Compile Include="Controllers\SBGL\SBBB\Sb_EquipMentCollectionTechParamController.cs" /> <Compile Include="Controllers\SBGL\SBBB\Sb_EquipMentCollectionTechParam_TempController.cs" /> <Compile Include="Controllers\SCGL\Sc_ProductionReportsController.cs" /> <Compile Include="Controllers\XSGL\Xs_OutDoorBillController.cs" /> <Compile Include="Controllers\ZLGL\BaseSet\Gy_InspectBasisController.cs" /> <Compile Include="Controllers\ZLGL\BaseSet\Gy_InspectMethodController.cs" /> <Compile Include="Controllers\ZLGL\BaseSet\Gy_QualityController.cs" /> WorkM/bin/Release/BLL.dllBinary files differ
WorkM/bin/Release/BLL.pdbBinary files differ
WorkM/bin/Release/DAL.dllBinary files differ
WorkM/bin/Release/DAL.pdbBinary files differ
WorkM/bin/Release/Model.dllBinary files differ
WorkM/bin/Release/Model.pdbBinary files differ
WorkM/bin/Release/WarM.dllBinary files differ
WorkM/bin/Release/WarM.pdbBinary files differ
WorkM/bin/Release/WorkM.dllBinary files differ
WorkM/bin/Release/WorkM.pdbBinary files differ
sdk_dingding/TopSdk/bin/Debug/TopSdk.dllBinary files differ
sdk_dingding/TopSdk/bin/Debug/TopSdk.pdbBinary files differ
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.CoreCompileInputs.cache
New file @@ -0,0 +1 @@ eb64bc61f5da8fdd8ad56e04c391e3a377d8ca59 sdk_dingding/TopSdk/obj/Release/TopSdk.csproj.FileListAbsolute.txt
New file @@ -0,0 +1,5 @@ E:\æºäºmes\mes\MES-WEB-API\sdk_dingding\TopSdk\bin\Release\TopSdk.dll E:\æºäºmes\mes\MES-WEB-API\sdk_dingding\TopSdk\bin\Release\TopSdk.pdb E:\æºäºmes\mes\MES-WEB-API\sdk_dingding\TopSdk\obj\Release\TopSdk.csproj.CoreCompileInputs.cache E:\æºäºmes\mes\MES-WEB-API\sdk_dingding\TopSdk\obj\Release\TopSdk.dll E:\æºäºmes\mes\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