DAL/Éú²ú¹ÜÀí/Ä£¾ß¹ÜÀí/ClsSc_MouldRepairOutBill.cs
@@ -141,18 +141,17 @@ oCn.BeginTran(); //主表 oCn.RunProc("Insert Into Sc_MouldStockBillMain " + "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + ",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" + ",HRepairType" + ") " + " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + ", " + 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) + ",'"+omodel.HRepairType.ToString()+"'"+ ") "); "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + ",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 + "','" + omodel.HDate + "'" + ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + ", " + 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) + ") "); //æå ¥å表 foreach (Model.ClsSc_MouldStockBillSub oSub in DetailColl) { @@ -161,8 +160,8 @@ ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + ",HMaterID,HPropertyID,HSecUnitID,HSecUnitRate,HUnitID,HQtyMust" + ",HQty,HPrice,HMoney,HWHID,HSCWHID,HSPID" + ",HDesignLife,HLeaveLife,HUseLife,HNowModel,HNowLife" + ",HSCSPID,HSPGroupID,HBatchNo" + ",HDesignLife,HLeaveLife,HUseLife,HNewLifeQty" + ",HSCSPID,HSPGroupID,HBatchNo,HBackFlag,HNowModel,HNowLife" + ",HNewModel,HLastProdModel,HWallThickness,HHardness,HDiameter,HQtyRel" + ",HMouldType,HInitModel,HInitDesignLife,HLifeUnitID" + ") values(" @@ -170,16 +169,16 @@ "," + 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.HDesignLife.ToString() + "," + oSub.HLeaveLife.ToString() + "," + oSub.HUseLife.ToString() + ",'" + oSub.HNowModel + "'," + oSub.HNowLife.ToString() + "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'" + "," + oSub.HDesignLife.ToString() + "," + oSub.HLeaveLife.ToString() + "," + oSub.HUseLife.ToString() + "," + oSub.HNewLifeQty.ToString() + "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "','" + oSub.HBackFlag + "','" + oSub.HNowModel + "'," + oSub.HNowLife.ToString() + ",'" + oSub.HNewModel + "','" + oSub.HLastProdModel + "','" + oSub.HWallThickness + "','" + oSub.HHardness + "','" + oSub.HDiameter + "'," + oSub.HQtyRel.ToString() + "," + oSub.HMouldType.ToString() + ",'" + oSub.HInitModel + "'," + oSub.HInitDesignLife.ToString() + "," + oSub.HLifeUnitID.ToString() + ") "); "," + oSub.HMouldType.ToString() + ",'" + oSub.HInitModel + "'," + oSub.HInitDesignLife.ToString() + "," + oSub.HLifeUnitID.ToString() + ") "); oCn.RunProc("exec h_p_Sc_MouldFileChangeStatus " + oSub.HMaterID.ToString() + ",'" + oSub.HNowModel.ToString() + "'," + oSub.HNowLife.ToString() + ",'æ¹å¶ä¸'"); } //foreach (Model.ClsSc_MouldStockBillSub oSub in DetailColl) //{ // Ds = oCn.RunProcReturn("exec h_p_Sc_MouldRepairOutBill_Qty " + oSub.HICMOInterID, ""); @@ -195,7 +194,7 @@ DataSet Ds; foreach (Model.ClsSc_MouldStockBillSub oSub in DetailColl) { Ds = oCn.RunProcReturn("exec h_p_Kf_ICStockBill_CheckKF " + omodel.HInterID + "," + oSub.HMaterID + "," + oSub.HWHID + "," + oSub.HSPID + ", -1", "gy_czygl"); Ds = oCn.RunProcReturn("exec h_p_Kf_ICStockBill_CheckKF " + omodel.HInterID + "," + oSub.HMaterID + "," + oSub.HWHID + "," + oSub.HSPID + ", 1", "gy_czygl"); if (Ds.Tables[0].Rows.Count == 0) { oCn.RollBack(); DBUtility/obj/Release/DBUtility.csprojAssemblyReference.cacheBinary files differ
MES/bin/Debug/AxInterop.gregn6Lib.dllBinary files differ
MES/bin/Debug/BLL.dllBinary files differ
MES/bin/Debug/BLL.pdbBinary files differ
MES/bin/Debug/DAL.dllBinary files differ
MES/bin/Debug/DAL.pdbBinary files differ
MES/bin/Debug/DBUtility.dllBinary files differ
MES/bin/Debug/Interop.Excel.dllBinary files differ
MES/bin/Debug/Interop.gregn6Lib.dllBinary files differ
MES/bin/Debug/Kingdee.BOS.WebApi.Client.dllBinary files differ
MES/bin/Debug/MES.exeBinary files differ
MES/bin/Debug/MES.pdbBinary files differ
MES/bin/Debug/Model.dllBinary files differ
MES/bin/Debug/Model.pdbBinary files differ
MES/bin/Debug/Newtonsoft.Json.dllBinary files differ
MES/bin/Debug/Pub_Class.dllBinary files differ
MES/bin/Debug/Pub_Control.dllBinary files differ
MES/bin/Debug/SQLHelper.dllBinary files differ
MES/bin/Debug/WarM.dllBinary files differ
MES/bin/Debug/WarM.dll.config
File was deleted MES/bin/Debug/WarM.pdbBinary files differ
MES/bin/Debug/stdole.dllBinary files differ
Model/Model.csproj
@@ -501,7 +501,13 @@ <Compile Include="ç产管ç\æ¨¡å ·ç®¡ç\ClsSc_MouldMaintainRuleBillSub_Item.cs" /> <Compile Include="ç产管ç\æ¨¡å ·ç®¡ç\ClsSc_MouldMoveStockStepOutBillSub.cs" /> <Compile Include="ç产管ç\æ¨¡å ·ç®¡ç\ClsSc_MouldMoveStockStepOutBillMain.cs" /> <Compile Include="ç产管ç\æ¨¡å ·ç®¡ç\ClsSc_MouldScrapInBillMain.cs" /> <Compile Include="ç产管ç\æ¨¡å ·ç®¡ç\ClsSc_MouldScrapInBillSub.cs" /> <Compile Include="ç产管ç\æ¨¡å ·ç®¡ç\ClsSc_MouldRepairOutBillMain.cs" /> <Compile Include="ç产管ç\æ¨¡å ·ç®¡ç\ClsSc_MouldRepairInBillMain.cs" /> <Compile Include="ç产管ç\æ¨¡å ·ç®¡ç\ClsSc_MouldOtherInBillMain.cs" /> <Compile Include="ç产管ç\æ¨¡å ·ç®¡ç\ClsSc_MouldRepairOutBillSub.cs" /> <Compile Include="ç产管ç\æ¨¡å ·ç®¡ç\ClsSc_MouldRepairInBillSub.cs" /> <Compile Include="ç产管ç\æ¨¡å ·ç®¡ç\ClsSc_MouldOtherInBillSub.cs" /> <Compile Include="ç产管ç\æ¨¡å ·ç®¡ç\ClsSc_MouldOtherOutBillMain.cs" /> <Compile Include="ç产管ç\æ¨¡å ·ç®¡ç\ClsSc_MouldOtherOutBillSub.cs" /> Model/Éú²ú¹ÜÀí/Ä£¾ß¹ÜÀí/ClsSc_MouldRepairInBillMain.cs
New file @@ -0,0 +1,22 @@ using System; using System.Collections.Generic; using System.Text; namespace Model { public class ClsSc_MouldRepairInBillMain : DBUtility.ClsXt_BaseBillMain { public Int64 HSupID;// int --ä¾åºå public Int64 HWHID;// int --ä»åº public Int64 HSCWHID;// int --è°åºä»åº public Int64 HEmpID;// int --ä¸å¡å public Int64 HManagerID;// int --è´è´£äºº public Int64 HSecManagerID;// int --éªæ¶ public Int64 HKeeperID;// int --ä¿ç®¡å public Int64 HDeptID;// int --é¨é¨ public string HExplanation;// varchar(200) --ÕªÒª public string HInnerBillNo;// varchar(50) --å é¨åæ®å· public string HRemark; //å å·¥è¦æ± public bool HRedBlueFlag;// bit --红èå } } Model/Éú²ú¹ÜÀí/Ä£¾ß¹ÜÀí/ClsSc_MouldRepairInBillSub.cs
New file @@ -0,0 +1,55 @@ using System; using System.Collections.Generic; using System.Text; namespace Model { public class ClsSc_MouldRepairInBillSub : DBUtility.ClsXt_BaseBillSub { public DateTime HEntryCloseDate;// datetime --è¡å ³é (é»è®¤ä¸º'') new public string HRemark;// varchar(200) --夿³¨ public Int64 HMaterID;// int --ç©æID public Int64 HPropertyID;// int --è¾ å©å±æ§ public Int64 HSecUnitID;// int --è¾ å©è®¡éåä½ public Single HSecUnitRate;// money --æ¢ç®ç public Int64 HUnitID;// int --计éåä½ public double HDesignLife;// dec(18,8) --è®¾è®¡å¯¿å½ public double HLeaveLife;// dec(18,8) --å©ä½å¯¿å½ public double HUseLifeQty;// dec(18,8) --æ¬æ¬¡ä½¿ç¨å¯¿å½ public double HUseLife;// dec(18,8) --使ç¨å¯¿å½ public double HQtyMust;// dec(18,8) --åºæ¶æ°é public double HQty;// dec(18,8) --宿¶æ°é public double HPrice;// dec(18,8) --åä»· public double HMoney;// dec(18,8) --éé¢ public Int64 HWHID;// int --æ¶æä»åº public Int64 HSCWHID;// int --è°åºä»åºID public Int64 HSPID;// int --ä»ä½ID public Int64 HSCSPID;// int --è°åºä»ä½ID public Int64 HSPGroupID;// int --ä»ä½ç»ID(ä»åºéæ©å®èªå¨å¸¦åº) public string HBatchNo;// varchar(50) --æ¹æ¬¡ public string HEngineNum;// varchar(50) --å卿ºå· public string HUnderPanNum;// varchar(50) --å°çå· public string HLeaveFactCard;// varchar(50) --åºåè¯ public Int64 HPOOrderInterID;// int --éè´è®¢å主å ç public Int64 HPOOrderEntryID;// int --éè´è®¢ååå ç public string HPOOrderBillNo;// varchar(50) --éè´è®¢åå· public Int64 HSeOrderInterID;// int --éå®è®¢å主å ç public Int64 HSeOrderEntryID;// int --éå®è®¢ååå ç public string HSeOrderBillNo;// varchar(50) --éå®è®¢åå· public string HBarCode; public string HNewModel;// varchar(100) --æ°è§æ ¼ addnew public string HWallThickness;// varchar(100) --å£å addnew public string HHardness;// varchar(100) --硬度 addnew public string HLastProdModel;// varchar(100) --æåç产产å addnew public string HDiameter;// varchar(100) --ç´å¾ addnew public string HBackFlag;// varchar(100)--éåºç±»åï¼æ£å¸¸ä½¿ç¨ï¼è°è¯ä¸åæ ¼ï¼ addnew public string HInitModel; public Single HInitDesignLife; public Int64 HLifeUnitID; public Int64 HMouldType; public double HNewLifeQty; } } Model/Éú²ú¹ÜÀí/Ä£¾ß¹ÜÀí/ClsSc_MouldRepairOutBillMain.cs
New file @@ -0,0 +1,22 @@ using System; using System.Collections.Generic; using System.Text; namespace Model { public class ClsSc_MouldRepairOutBillMain : DBUtility.ClsXt_BaseBillMain { public Int64 HSupID;// int --ä¾åºå public Int64 HWHID;// int --ä»åº public Int64 HSCWHID;// int --è°åºä»åº public Int64 HEmpID;// int --ä¸å¡å public Int64 HManagerID;// int --è´è´£äºº public Int64 HSecManagerID;// int --éªæ¶ public Int64 HKeeperID;// int --ä¿ç®¡å public Int64 HDeptID;// int --é¨é¨ public string HExplanation;// varchar(200) --ÕªÒª public string HInnerBillNo;// varchar(50) --å é¨åæ®å· public string HRemark; //å å·¥è¦æ± public bool HRedBlueFlag;// bit --红èå } } Model/Éú²ú¹ÜÀí/Ä£¾ß¹ÜÀí/ClsSc_MouldRepairOutBillSub.cs
New file @@ -0,0 +1,55 @@ using System; using System.Collections.Generic; using System.Text; namespace Model { public class ClsSc_MouldRepairOutBillSub : DBUtility.ClsXt_BaseBillSub { public DateTime HEntryCloseDate;// datetime --è¡å ³é (é»è®¤ä¸º'') new public string HRemark;// varchar(200) --夿³¨ public Int64 HMaterID;// int --ç©æID public Int64 HPropertyID;// int --è¾ å©å±æ§ public Int64 HSecUnitID;// int --è¾ å©è®¡éåä½ public Single HSecUnitRate;// money --æ¢ç®ç public Int64 HUnitID;// int --计éåä½ public double HDesignLife;// dec(18,8) --è®¾è®¡å¯¿å½ public double HLeaveLife;// dec(18,8) --å©ä½å¯¿å½ public double HUseLifeQty;// dec(18,8) --æ¬æ¬¡ä½¿ç¨å¯¿å½ public double HUseLife;// dec(18,8) --使ç¨å¯¿å½ public double HQtyMust;// dec(18,8) --åºæ¶æ°é public double HQty;// dec(18,8) --宿¶æ°é public double HPrice;// dec(18,8) --åä»· public double HMoney;// dec(18,8) --éé¢ public Int64 HWHID;// int --æ¶æä»åº public Int64 HSCWHID;// int --è°åºä»åºID public Int64 HSPID;// int --ä»ä½ID public Int64 HSCSPID;// int --è°åºä»ä½ID public Int64 HSPGroupID;// int --ä»ä½ç»ID(ä»åºéæ©å®èªå¨å¸¦åº) public string HBatchNo;// varchar(50) --æ¹æ¬¡ public string HEngineNum;// varchar(50) --å卿ºå· public string HUnderPanNum;// varchar(50) --å°çå· public string HLeaveFactCard;// varchar(50) --åºåè¯ public Int64 HPOOrderInterID;// int --éè´è®¢å主å ç public Int64 HPOOrderEntryID;// int --éè´è®¢ååå ç public string HPOOrderBillNo;// varchar(50) --éè´è®¢åå· public Int64 HSeOrderInterID;// int --éå®è®¢å主å ç public Int64 HSeOrderEntryID;// int --éå®è®¢ååå ç public string HSeOrderBillNo;// varchar(50) --éå®è®¢åå· public string HBarCode; public string HNewModel;// varchar(100) --æ°è§æ ¼ addnew public string HWallThickness;// varchar(100) --å£å addnew public string HHardness;// varchar(100) --硬度 addnew public string HLastProdModel;// varchar(100) --æåç产产å addnew public string HDiameter;// varchar(100) --ç´å¾ addnew public string HBackFlag;// varchar(100)--éåºç±»åï¼æ£å¸¸ä½¿ç¨ï¼è°è¯ä¸åæ ¼ï¼ addnew public string HInitModel; public Single HInitDesignLife; public Int64 HLifeUnitID; public Int64 HMouldType; public double HNewLifeQty; } } Model/Éú²ú¹ÜÀí/Ä£¾ß¹ÜÀí/ClsSc_MouldScrapInBillMain.cs
New file @@ -0,0 +1,22 @@ using System; using System.Collections.Generic; using System.Text; namespace Model { public class ClsSc_MouldScrapInBillMain : DBUtility.ClsXt_BaseBillMain { public Int64 HSupID;// int --ä¾åºå public Int64 HWHID;// int --ä»åº public Int64 HSCWHID;// int --è°åºä»åº public Int64 HEmpID;// int --ä¸å¡å public Int64 HManagerID;// int --è´è´£äºº public Int64 HSecManagerID;// int --éªæ¶ public Int64 HKeeperID;// int --ä¿ç®¡å public Int64 HDeptID;// int --é¨é¨ public string HExplanation;// varchar(200) --ÕªÒª public string HInnerBillNo;// varchar(50) --å é¨åæ®å· public string HRemark; //å å·¥è¦æ± public bool HRedBlueFlag;// bit --红èå } } Model/Éú²ú¹ÜÀí/Ä£¾ß¹ÜÀí/ClsSc_MouldScrapInBillSub.cs
New file @@ -0,0 +1,55 @@ using System; using System.Collections.Generic; using System.Text; namespace Model { public class ClsSc_MouldScrapInBillSub : DBUtility.ClsXt_BaseBillSub { public DateTime HEntryCloseDate;// datetime --è¡å ³é (é»è®¤ä¸º'') new public string HRemark;// varchar(200) --夿³¨ public Int64 HMaterID;// int --ç©æID public Int64 HPropertyID;// int --è¾ å©å±æ§ public Int64 HSecUnitID;// int --è¾ å©è®¡éåä½ public Single HSecUnitRate;// money --æ¢ç®ç public Int64 HUnitID;// int --计éåä½ public double HDesignLife;// dec(18,8) --è®¾è®¡å¯¿å½ public double HLeaveLife;// dec(18,8) --å©ä½å¯¿å½ public double HUseLifeQty;// dec(18,8) --æ¬æ¬¡ä½¿ç¨å¯¿å½ public double HUseLife;// dec(18,8) --使ç¨å¯¿å½ public double HQtyMust;// dec(18,8) --åºæ¶æ°é public double HQty;// dec(18,8) --宿¶æ°é public double HPrice;// dec(18,8) --åä»· public double HMoney;// dec(18,8) --éé¢ public Int64 HWHID;// int --æ¶æä»åº public Int64 HSCWHID;// int --è°åºä»åºID public Int64 HSPID;// int --ä»ä½ID public Int64 HSCSPID;// int --è°åºä»ä½ID public Int64 HSPGroupID;// int --ä»ä½ç»ID(ä»åºéæ©å®èªå¨å¸¦åº) public string HBatchNo;// varchar(50) --æ¹æ¬¡ public string HEngineNum;// varchar(50) --å卿ºå· public string HUnderPanNum;// varchar(50) --å°çå· public string HLeaveFactCard;// varchar(50) --åºåè¯ public Int64 HPOOrderInterID;// int --éè´è®¢å主å ç public Int64 HPOOrderEntryID;// int --éè´è®¢ååå ç public string HPOOrderBillNo;// varchar(50) --éè´è®¢åå· public Int64 HSeOrderInterID;// int --éå®è®¢å主å ç public Int64 HSeOrderEntryID;// int --éå®è®¢ååå ç public string HSeOrderBillNo;// varchar(50) --éå®è®¢åå· public string HBarCode; public string HNewModel;// varchar(100) --æ°è§æ ¼ addnew public string HWallThickness;// varchar(100) --å£å addnew public string HHardness;// varchar(100) --硬度 addnew public string HLastProdModel;// varchar(100) --æåç产产å addnew public string HDiameter;// varchar(100) --ç´å¾ addnew public string HBackFlag;// varchar(100)--éåºç±»åï¼æ£å¸¸ä½¿ç¨ï¼è°è¯ä¸åæ ¼ï¼ addnew public string HInitModel; public Single HInitDesignLife; public Int64 HLifeUnitID; public Int64 HMouldType; public double HNewLifeQty; } } WebAPI/Controllers/BaseSet/Gy_ClassTimePrjController.cs
New file @@ -0,0 +1,386 @@ 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.Web.Http; using WebAPI.Models; namespace WebAPI.Controllers { public class Gy_ClassTimePrjController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus; private json objJsonResult = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); DataSet ds; /// <summary> /// è¿åå表 ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Gy_ClassTimePrj/list")] [HttpGet] public object list(string sWhere) { try { if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_Gy_ClassTimePrjList where 1=1 ", "h_v_Gy_ClassTimePrjList"); } else { string sql1 = "select * from h_v_Gy_ClassTimePrjList where 1=1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "h_v_Gy_ClassTimePrjList"); } 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; } } /// <summary> /// æ ¹æ®åºç¡èµæID æ¥æ¾è®°å½ ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Gy_ClassTimePrj/cx")] [HttpGet] public object cx(long HInterID) { try { ds = oCN.RunProcReturn("select * from h_v_Gy_ClassTimePrjListDetail where HitemID=" + HInterID, "h_v_Gy_ClassTimePrjListDetail"); 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; } } // /// <summary> ///// æ°å¢åæ®-ä¿åæé® /////åæ°ï¼string sqlã /////è¿åå¼ï¼objectã ///// </summary> //[Route("Gy_ClassTimePrj/AddNew")] //[HttpPost] //public object AddNew([FromBody] JObject oMain) //{ // try // { // var _value = oMain["oMain"].ToString(); // string msg1 = _value.ToString(); // //ååºåå // msg1 = "[" + msg1.ToString() + "]"; // DAL.ClsGy_ClassTimePrj_Ctl oDept = new DAL.ClsGy_ClassTimePrj_Ctl(); // DAL.ClsGy_ClassTimePrj_View oDeptHlp = new DAL.ClsGy_ClassTimePrj_View(); // List<Gy_ClassTimePrj> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_ClassTimePrj>>(msg1); // long HItemID = list[0].HItemID; // string HNumber = list[0].HNumber; // string HName = list[0].HName; // long hparentid = list[0].hparentid; ; // long HDeptID = list[0].HDeptID; ; // long HGroupID = list[0].HGroupID; // bool HStopflag = list[0].HStopflag; // string HRemark = list[0].HRemark; // if (!DBUtility.ClsPub.AllowNumber(HNumber)) // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "代ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; // objJsonResult.data = null; // return objJsonResult; // } // //è¥MAINDIéå¤åéæ°è·å // oCN.BeginTran(); // //主表 // oCN.RunProc("Insert into Gy_ClassTimePrj" + // " (HNumber,HName,HParentID" + // ",HStopflag,HRemark,HDeptID,HGroupID) " + // " Values('" + HNumber + "','" + HName + "'," + hparentid.ToString() + // "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HDeptID.ToString() + "," + HGroupID.ToString() + ")" // , ref DBUtility.ClsPub.sExeReturnInfo); // //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç // oCN.RunProc("Update Gy_ClassTimePrj set HEndflag=0 where HItemID=" + hparentid, ref DBUtility.ClsPub.sExeReturnInfo); // 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.Message; // objJsonResult.data = null; // return objJsonResult; // } //} /// <summary> /// ä¿åæé® ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Gy_ClassTimePrj/ModifyByID")] [HttpPost] public object ModifyByID([FromBody] JObject oMain) { try { DAL.ClsGy_ClassTimePrj_Ctl oDept = new DAL.ClsGy_ClassTimePrj_Ctl(); DAL.ClsGy_ClassTimePrj_View oDeptHlp = new DAL.ClsGy_ClassTimePrj_View(); var _value = oMain["oMain"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); //string msg3 = sArray[1].ToString(); //string msg4 = sArray[2].ToString(); //string msg5 = sArray[3].ToString(); //ååºåå msg2 = "[" + msg2.ToString() + "]"; List<Gy_ClassTimePrj> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_ClassTimePrj>>(msg2); long HItemID = list[0].HItemID; string HNumber = list[0].HNumber; string HName = list[0].HName; long hparentid = list[0].hparentid; ; long HDeptID = list[0].HDeptID; ; long HGroupID = list[0].HGroupID; bool HStopflag = list[0].HStopflag; string HRemark = list[0].HRemark; ////夿æé //if (!ClsPub.Security_Log(msg5, 1, true, msg4)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æ²¡ææ¾å°è¯¥åè½æ¨¡åï¼"; // objJsonResult.data = null; // return objJsonResult; //} //if (!DBUtility.ClsPub.AllowNumber(HNumber)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "代ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; // objJsonResult.data = null; // return objJsonResult; //} //if (oDept.HavSameNumber(HItemID, HNumber)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "代ç éå¤ï¼"; // objJsonResult.data = null; // return objJsonResult; //} //ä¿å //ä¿å宿¯åå¤ç if (HItemID == 0) { oCN.BeginTran(); oCN.RunProc("Insert into Gy_ClassTimePrj" + " (HNumber,HName,hparentid" + ",HStopflag,HRemark,HDeptID,HGroupID) " + " Values('" + HNumber + "','" + HName + "'," + hparentid.ToString() + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HDeptID.ToString() + "," + HGroupID.ToString() + ")" , ref DBUtility.ClsPub.sExeReturnInfo); //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç oCN.RunProc("Update Gy_ClassTimePrj set HStopflag=0 where HItemID=" + hparentid, ref DBUtility.ClsPub.sExeReturnInfo); oCN.Commit(); } else { //è¥MAINDIéå¤åéæ°è·å oCN.BeginTran(); //主表 oCN.RunProc("Update Gy_ClassTimePrj set " + " HNumber='" + HNumber + "'" + ",HName='" + HName + "'" + ",hparentid=" + hparentid.ToString() + ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + ",HDeptID=" + HDeptID.ToString() + ",HGroupID=" + HGroupID.ToString() + ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); //ä¿®æ¹å项ç®ä»£ç //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Warehouse,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); //å°ä¸çº§ ä¸ºéæ«çº§ oCN.RunProc("Update Gy_ClassTimePrj set HStopflag=0 where HItemID=" + hparentid, ref DBUtility.ClsPub.sExeReturnInfo); // oCN.Commit(); } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "ä¿åæåï¼"; //WebAPIController.Add_Log("éè´§å䏿¨", UserName, "çæéè´§å"); objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.Message; objJsonResult.data = null; return objJsonResult; } } /// <summary> /// ä»åºå表å é¤åè½ /// </summary> /// <returns></returns> [Route("DeltetGy_ClassTimePrj")] [HttpGet] public object DeltetGy_ClassTimePrj(string HItemID) { DataSet ds; DataSet ds1; try { //å 餿é //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "å®¡æ ¸å¤±è´¥ï¼æ æéï¼"; // objJsonResult.data = null; // return objJsonResult; //} SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HItemID为空ï¼"; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran();//å¼å§äºå¡ ds = oCN.RunProcReturn("select * from Gy_ClassTimePrj where HItemID=" + HItemID, "Gy_ClassTimePrj"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ²¡ææ°æ®ï¼æ æ³å é¤ï¼"; objJsonResult.data = null; return objJsonResult; ; } //var HStopflag = Convert.ToBoolean(ds.Tables[0].Rows[0]["HStopflag"]); //if (HStopflag) //{ // oCN.RollBack();//åæ»äºå¡ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æ°æ®å·²å 餿 æ³å次å é¤ï¼"; // objJsonResult.data = null; // return objJsonResult; //} ds1 = oCN.RunProcReturn("Select HItemID from Gy_ClassTimePrj Where HParentID='" + HItemID + "'", "Gy_ClassTimePrj"); if (ds1.Tables[0].Rows.Count != 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¤é¡¹ç®åå¨å项ç®ï¼ä¸è½å é¤ï¼"; objJsonResult.data = null; return objJsonResult; } string HUseFlag = Convert.ToString(ds.Tables[0].Rows[0]["HUseFlag"]); if (HUseFlag == "已使ç¨") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¤é¡¹ç®å·²ä½¿ç¨ï¼ä¸è½å é¤ï¼"; objJsonResult.data = null; return objJsonResult; } oCN.RunProc("delete from Gy_ClassTimePrj where HItemID=" + HItemID); oCN.Commit();//æäº¤äºå¡ objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "* æ°æ®å 餿åï¼"; objJsonResult.data = null; return objJsonResult; ; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å é¤å¤±è´¥ï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } } } WebAPI/Controllers/BaseSet/Xt_DataDictionary_ProcController.cs
New file @@ -0,0 +1,411 @@ 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.Web.Http; using WebAPI.Models; namespace WebAPI.Controllers { public class Xt_DataDictionary_ProcController : ApiController { public DBUtility.ClsPub.Enum_BillStatus BillStatus; private json objJsonResult = new json(); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); DataSet ds; /// <summary> /// è¿åå表 ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Xt_DataDictionary_Proc/list")] [HttpGet] public object list(string sWhere) { try { if (sWhere == null || sWhere.Equals("")) { ds = oCN.RunProcReturn("select * from h_v_IF_DataDictionary_Proc where 1=1 ", "h_v_IF_DataDictionary_Proc"); } else { string sql1 = "select * from h_v_IF_DataDictionary_Proc where 1=1 "; string sql = sql1 + sWhere; ds = oCN.RunProcReturn(sql, "h_v_IF_DataDictionary_Proc"); } 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; } } /// <summary> /// æ ¹æ®åºç¡èµæID æ¥æ¾è®°å½ ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Xt_DataDictionary_Proc/cx")] [HttpGet] public object cx(long HInterID) { try { ds = oCN.RunProcReturn("select * from h_v_IF_DataDictionary_ProcDetail where HitemID = " + HInterID, "h_v_IF_DataDictionary_ProcDetail"); 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; } } /// <summary> /// å é¤åè½ /// </summary> /// <returns></returns> [Route("DeltetXt_DataDictionary_Proc")] [HttpGet] public object DeltetXt_DataDictionary_Proc(string HItemID) { DataSet ds; //DataSet ds1; try { //å 餿é //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "å®¡æ ¸å¤±è´¥ï¼æ æéï¼"; // objJsonResult.data = null; // return objJsonResult; //} SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (string.IsNullOrWhiteSpace(HItemID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "HItemID为空ï¼"; objJsonResult.data = null; return objJsonResult; } oCN.BeginTran();//å¼å§äºå¡ ds = oCN.RunProcReturn("select * from h_v_IF_DataDictionary_Proc where HItemID=" + HItemID, "h_v_IF_DataDictionary_Proc"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ²¡ææ°æ®ï¼æ æ³å é¤ï¼"; objJsonResult.data = null; return objJsonResult; ; } //ds1 = oCN.RunProcReturn("Select HItemID from h_v_IF_DataDictionary_View Where HParentID='" + HItemID + "'", "h_v_IF_DataDictionary_View"); //if (ds1.Tables[0].Rows.Count != 0) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æ¤é¡¹ç®åå¨å项ç®ï¼ä¸è½å é¤ï¼"; // objJsonResult.data = null; // return objJsonResult; //} oCN.RunProc("delete from h_v_IF_DataDictionary_Proc where HItemID=" + HItemID); oCN.Commit();//æäº¤äºå¡ objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "* æ°æ®å 餿åï¼"; objJsonResult.data = null; return objJsonResult; ; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å é¤å¤±è´¥ï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } /// <summary> /// ç¦ç¨æé® ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Xt_DataDictionary_Proc/JY_Json")] [HttpGet] public object JY_Json(long HItemID) { try { ds = oCN.RunProcReturn("update Xt_DataDictionary_Proc set HStopFlag = 1 where HItemID = " + HItemID, "Xt_DataDictionary_Proc"); 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; } } /// <summary> /// åç¦ç¨æé® ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Xt_DataDictionary_Proc/FJY_Json")] [HttpGet] public object FJY_Json(long HItemID) { try { ds = oCN.RunProcReturn("update Xt_DataDictionary_Proc set HStopFlag = 0 where HItemID = " + HItemID, "Xt_DataDictionary_Proc"); 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; } } ///// <summary> ///// æ°å¢åæ®-ä¿åæé® /////åæ°ï¼string sqlã /////è¿åå¼ï¼objectã ///// </summary> //[Route("Xt_DataDictionary_View/AddBill")] //[HttpPost] //public object AddBill([FromBody] JObject oMain) //{ // try // { // var _value = oMain["oMain"].ToString(); // string msg1 = _value.ToString(); // //ååºåå // msg1 = "[" + msg1.ToString() + "]"; // //DAL.ClsGy_Department_Ctl oDept = new DAL.ClsGy_Department_Ctl(); // //DAL.ClsGy_Department_View oDeptHlp = new DAL.ClsGy_Department_View(); // List<Xt_DataDictionary_View> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Xt_DataDictionary_View>>(msg1); // long HItemID = list[0].HItemID; // long HModNameID = list[0].HModNameID; // long HBillTypeID = list[0].HBillTypeID; // string HViewName = list[0].HViewName; // string HViewCaption = list[0].HViewCaption; // string HRemark = list[0].HRemark; // bool HStopflag = list[0].HStopflag; // DateTime HMakeTime = list[0].HMakeTime; // string HMakeEmp = list[0].HMakeEmp; // DateTime HModifyTime = list[0].HModifyTime; // string HModifyEmp = list[0].HModifyEmp; // //è¥MAINDIéå¤åéæ°è·å // oCN.BeginTran(); // //主表 // oCN.RunProc("Insert Into Xt_DataDictionary_View " + // "(HModNameID,HBillTypeID,HViewName,HViewCaption,HRemark" + // ",HStopflag,HMakeTime,HMakeEmp,HModifyTime" + // ",HModifyEmp" + // ") " + // " values(" + HModNameID + "," + HBillTypeID + "," + HBillTypeID + ",'" + HViewName + "','" + HViewCaption + "'"+ // ",'" + HRemark + "'," + Convert.ToString(HStopflag ? 1 : 0) + "" + // ",'" + HMakeTime + "','" + HMakeEmp + "','" + HModifyTime + "','" + HModifyEmp + "'" + // ") "); // //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç // objJsonResult.code = "1"; // objJsonResult.count = 1; // objJsonResult.Message = null; // objJsonResult.data = null; // return objJsonResult; // } // catch (Exception e) // { // oCN.RollBack(); // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "Exceptionï¼" + e.Message; // objJsonResult.data = null; // return objJsonResult; // } //} /// <summary> /// ä¿åæé® ///åæ°ï¼string sqlã ///è¿åå¼ï¼objectã /// </summary> [Route("Xt_DataDictionary_Proc/AddBill1")] [HttpPost] public object AddBill1([FromBody] JObject oMain) { try { //DAL.ClsGy_Department_Ctl oDept = new DAL.ClsGy_Department_Ctl(); //DAL.ClsGy_Department_View oDeptHlp = new DAL.ClsGy_Department_View(); var _value = oMain["oMain"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); //string msg3 = sArray[1].ToString(); //string msg4 = sArray[2].ToString(); //string msg5 = sArray[3].ToString(); //ååºåå msg2 = "[" + msg2.ToString() + "]"; List<Xt_DataDictionary_Proc> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Xt_DataDictionary_Proc>>(msg2); long HItemID = list[0].HItemID; long HModNameID = list[0].HModNameID; long HBillTypeID = list[0].HBillTypeID; string HProcName = list[0].HProcName; string HProcCaption = list[0].HProcCaption; string HRemark = list[0].HRemark; bool HStopflag = list[0].HStopflag; DateTime HMakeTime = list[0].HMakeTime; string HMakeEmp = list[0].HMakeEmp; DateTime HModifyTime = list[0].HModifyTime; string HModifyEmp = list[0].HModifyEmp; //ä¿å //ä¿å宿¯åå¤ç if (HItemID == 0) { //æ°å¢ oCN.BeginTran(); oCN.RunProc("Insert Into Xt_DataDictionary_Proc " + "(HModNameID,HBillTypeID,HProcName,HProcCaption,HRemark" + ",HStopflag,HMakeTime,HMakeEmp,HModifyTime" + ",HModifyEmp" + ") " + " values(" + HModNameID + "," + HBillTypeID + ",'" + HProcName + "','" + HProcCaption + "'" + ",'" + HRemark + "'," + Convert.ToString(HStopflag ? 1 : 0) + "" + ",'" + HMakeTime + "','" + HMakeEmp + "','" + HModifyTime + "','" + HModifyEmp + "'" + ") ", ref DBUtility.ClsPub.sExeReturnInfo); //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç oCN.RunProc("Update Xt_DataDictionary_Proc set HStopflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); oCN.Commit(); } else { oCN.BeginTran(); //主表 oCN.RunProc("Update Xt_DataDictionary_Proc set " + " HModNameID= "+ HModNameID + " HBillTypeID= " + HBillTypeID + ",HProcName='" + HProcName + "'" + ",HProcCaption='" + HProcCaption + "'" + ",HRemark='" + HRemark + "'" + ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + ",HMakeTime='" + HMakeTime + "'" + ",HMakeEmp='" + HMakeEmp + "'" + ",HModifyTime='" + HModifyTime + "'" + ",HModifyEmp='" + HModifyEmp + "'" + //",HUpdater='" + HUpdater + "'" + //",HUpdateDate= getdate()" + ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); //ä¿®æ¹å项ç®ä»£ç //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Department,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); //å°ä¸çº§ ä¸ºéæ«çº§ oCN.RunProc("Update Xt_DataDictionary_Proc set HStopflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); oCN.Commit(); } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "ä¿åæåï¼"; //WebAPIController.Add_Log("éè´§å䏿¨", UserName, "çæéè´§å"); objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.Message; objJsonResult.data = null; return objJsonResult; } } // } } WebAPI/Controllers/BaseSet/Xt_DataDictionary_TableController.cs
@@ -114,7 +114,7 @@ public object DeltetXt_DataDictionary_Table(string HItemID) { DataSet ds; DataSet ds1; //DataSet ds1; try { //å 餿é @@ -146,15 +146,15 @@ objJsonResult.data = null; return objJsonResult; ; } ds1 = oCN.RunProcReturn("Select HItemID from Xt_DataDictionary_Table Where HParentID='" + HItemID + "'", "Xt_DataDictionary_Table"); if (ds1.Tables[0].Rows.Count != 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¤é¡¹ç®åå¨å项ç®ï¼ä¸è½å é¤ï¼"; objJsonResult.data = null; return objJsonResult; } //ds1 = oCN.RunProcReturn("Select HItemID from Xt_DataDictionary_Table Where HParentID='" + HItemID + "'", "Xt_DataDictionary_Table"); //if (ds1.Tables[0].Rows.Count != 0) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æ¤é¡¹ç®åå¨å项ç®ï¼ä¸è½å é¤ï¼"; // objJsonResult.data = null; // return objJsonResult; //} oCN.RunProc("delete from Xt_DataDictionary_Table where HItemID=" + HItemID); @@ -285,7 +285,7 @@ ",HStopflag,HMakeTime,HMakeEmp,HModifyTime" + ",HModifyEmp" + ") " + " values(" + HModNameID + "," + HBillTypeID + "," + HBillTypeID + ",'" + HTableName + "'"+ " values(" + HModNameID + "," + HBillTypeID + ",'" + HTableName + "'"+ ",'" + HTableCaption + "','" + HFieldName + "','" + HFieldCaption + "','" + HDataType + "'" + ",'" + HDefaultValue + "','" + HRemark + "'," + Convert.ToString(HStopflag ? 1 : 0) + "" + ",'" + HMakeTime + "','" + HMakeEmp + "','" + HModifyTime + "','" + HModifyEmp + "'" + @@ -328,7 +328,7 @@ string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); //string msg3 = sArray[1].ToString(); //string msg4 = sArray[2].ToString(); //string msg5 = sArray[3].ToString(); //ååºåå @@ -362,7 +362,7 @@ ",HFieldName,HFieldCaption,HDataType,HDefaultValue,HRemark" + ",HStopflag,HMakeTime,HMakeEmp,HModifyTime" + ",HModifyEmp" + ") " + " values(" + HModNameID + "," + HBillTypeID + "," + HBillTypeID + ",'" + HTableName + "'" + ") " + " values(" + HModNameID + "," + HBillTypeID + ",'" + HTableName + "'" + ",'" + HTableCaption + "','" + HFieldName + "','" + HFieldCaption + "','" + HDataType + "'" + ",'" + HDefaultValue + "','" + HRemark + "'," + Convert.ToString(HStopflag ? 1 : 0) + "" + ",'" + HMakeTime + "','" + HMakeEmp + "','" + HModifyTime + "','" + HModifyEmp + "'" + @@ -378,19 +378,18 @@ oCN.RunProc("Update Xt_DataDictionary_Table set " + " HModNameID= "+ HModNameID + " HBillTypeID= " + HBillTypeID + " HBillTypeID= " + HBillTypeID + ",HTableName='" + HTableName + "'" + ",HTableCaption='" + HTableCaption + "'" + ",HFieldName='" + HFieldName + "'" + ",HDataType='" + HDataType + "'" + ",HFieldName='" + HFieldName + "'" + ",HFieldCaption='" + HFieldCaption + "'" + ",HRemark='" + HRemark + "'" + //",HRemark='" + HRemark + "'" + ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + ",HMakeTime='" + HMakeTime + "'" + ",HMakeEmp='" + HMakeEmp + "'" + ",HModifyTime='" + HModifyTime + "'" + ",HModifyEmp='" + HModifyEmp + "'" + ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + //",HUpdater='" + HUpdater + "'" + //",HUpdateDate= getdate()" + ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); WebAPI/Controllers/BaseSet/Xt_DataDictionary_ViewController.cs
@@ -114,7 +114,7 @@ public object DeltetXt_DataDictionary_View(string HItemID) { DataSet ds; DataSet ds1; //DataSet ds1; try { //å 餿é @@ -146,15 +146,15 @@ objJsonResult.data = null; return objJsonResult; ; } ds1 = oCN.RunProcReturn("Select HItemID from h_v_IF_DataDictionary_View Where HParentID='" + HItemID + "'", "h_v_IF_DataDictionary_View"); if (ds1.Tables[0].Rows.Count != 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¤é¡¹ç®åå¨å项ç®ï¼ä¸è½å é¤ï¼"; objJsonResult.data = null; return objJsonResult; } //ds1 = oCN.RunProcReturn("Select HItemID from h_v_IF_DataDictionary_View Where HParentID='" + HItemID + "'", "h_v_IF_DataDictionary_View"); //if (ds1.Tables[0].Rows.Count != 0) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æ¤é¡¹ç®åå¨å项ç®ï¼ä¸è½å é¤ï¼"; // objJsonResult.data = null; // return objJsonResult; //} oCN.RunProc("delete from h_v_IF_DataDictionary_View where HItemID=" + HItemID); @@ -322,7 +322,7 @@ string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string msg3 = sArray[1].ToString(); //string msg3 = sArray[1].ToString(); //string msg4 = sArray[2].ToString(); //string msg5 = sArray[3].ToString(); //ååºåå @@ -352,30 +352,29 @@ ",HStopflag,HMakeTime,HMakeEmp,HModifyTime" + ",HModifyEmp" + ") " + " values(" + HModNameID + "," + HBillTypeID + "," + HBillTypeID + ",'" + HViewName + "','" + HViewCaption + "'" + " values(" + HModNameID + "," + HBillTypeID + ",'" + HViewName + "','" + HViewCaption + "'" + ",'" + HRemark + "'," + Convert.ToString(HStopflag ? 1 : 0) + "" + ",'" + HMakeTime + "','" + HMakeEmp + "','" + HModifyTime + "','" + HModifyEmp + "'" + ") ", ref DBUtility.ClsPub.sExeReturnInfo); //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç oCN.RunProc("Update Xt_DataDictionary_Table set HStopflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); oCN.RunProc("Update Xt_DataDictionary_View set HStopflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); oCN.Commit(); } else { oCN.BeginTran(); //主表 oCN.RunProc("Update Xt_DataDictionary_Table set " + oCN.RunProc("Update Xt_DataDictionary_View set " + " HModNameID= "+ HModNameID + " HBillTypeID= " + HBillTypeID + " HBillTypeID= " + HBillTypeID + ",HViewName='" + HViewName + "'" + ",HViewCaption='" + HViewCaption + "'" + ",HRemark='" + HRemark + "'" + ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + ",HMakeTime='" + HMakeTime + "'" + ",HMakeEmp='" + HMakeEmp + "'" + ",HModifyTime='" + HModifyTime + "'" + ",HModifyEmp='" + HModifyEmp + "'" + ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + //",HUpdater='" + HUpdater + "'" + //",HUpdateDate= getdate()" + ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); WebAPI/Controllers/CGGL/Cg_POOrderBillController.cs
@@ -144,7 +144,44 @@ } [Route("POOrderBack")] [HttpGet] /// <summary> /// 订ååé¦ç¶æ /// </summary> /// <param name=""></param> /// <returns></returns> public object POOrderBack(string HmainidList, string OrderBackId) { try { string sql = ""; for (int i = 0; i < HmainidList.Split(',').Length; i++) { var Hmainid = HmainidList.Split(',')[i]; sql = string.Format(@" update Cg_POOrderBillSub set HFeedback ='{0}' where HInterID = '{1}' and HEntryID = '{2}' ", OrderBackId, Hmainid.Split('-')[0], Hmainid.Split('-')[1]); oCN.RunProc(sql); } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "æä½æåï¼"; //objJsonResult.Message = string.Join(",", HmainidList.ToArray()); objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "失败ï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } //夿æ¯å¦å卿é,å¹¶åå ¥æ¥å¿ public static bool Security_Log(string gnsy, int LogTF, bool Msg, string CurUserName) WebAPI/Controllers/MJJY/Mj_PDA_MoudlCheckController.cs
@@ -33,8 +33,70 @@ #region æ ¹æ®æ¨¡æ²»å ·æ¡ç æ¥æ¾æ¨¡å ·æ¡£æ¡ä¿¡æ¯ [Route("Mj_PDA_MoudlCheckBill/txtHBarCode_KeyDown")] [HttpGet] public object txtHBarCode_KeyDown(string HBarCode,long HInterID,long HWHID,long HSPID) public object txtHBarCode_KeyDown(string HBarCode) { //try //{ // if (HBarCode == null || HBarCode.Equals("")) // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æ¡å½¢ç ä¸è½ä¸ºç©ºï¼"; // objJsonResult.data = null; // return objJsonResult; // } // //å¾å°ä¿¡æ¯ // ds = oCN.RunProcReturn("select top 1 * from h_v_IF_Mould where HBarCode = '" + HBarCode + "'", "h_v_IF_Mould"); // //ds = oWebs.get_InfoByBarCode(HBarCode, ref DBUtility.ClsPub.sErrInfo); // //åå ¥ä¿¡æ¯ // if (ds == null ) // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æªæ¥è¯¢å°æ¨¡å ·ä¿¡æ¯ï¼"; // objJsonResult.data = null; // return objJsonResult; // } // else // { // omodel.HInterID = HInterID; // omodel.HBillType = "3796"; // omodel.HMaker = DBUtility.ClsPub.CurUserName; // omodel.HMaterID = Convert.ToInt64(ds.Tables[0].Rows[0]["HMaterID"]); // omodel.HQty = 0; // omodel.HBarCode = Convert.ToString(ds.Tables[0].Rows[0]["HBarCode"]); // omodel.HWhID = HWHID; // omodel.HStockPlaceID = HSPID; // omodel.HSourceBillNo = "1"; // omodel.HSourceBillType = "1"; // omodel.HSourceEntryID = 0; // omodel.HSourceInterID = 0; // if (set_SavePonderationBillMain_Temp(omodel, ref DBUtility.ClsPub.sErrInfo)) // { // objJsonResult.code = "1"; // objJsonResult.count = 1; // objJsonResult.Message = "æ«ç æåï¼"; // objJsonResult.data = ds.Tables[0]; // return objJsonResult; // } // else // { // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "åå ¥ç¼å表失败ï¼"; // objJsonResult.data = null; // return objJsonResult; // } // } //} //catch (Exception e) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "Exceptionï¼" + e.ToString(); // objJsonResult.data = null; // return objJsonResult; //} try { if (HBarCode == null || HBarCode.Equals("")) @@ -49,7 +111,7 @@ ds = oCN.RunProcReturn("select top 1 * from h_v_IF_Mould where HBarCode = '" + HBarCode + "'", "h_v_IF_Mould"); //ds = oWebs.get_InfoByBarCode(HBarCode, ref DBUtility.ClsPub.sErrInfo); //åå ¥ä¿¡æ¯ if (ds == null ) if (ds == null) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -59,34 +121,57 @@ } else { omodel.HInterID = HInterID; omodel.HBillType = "3796"; omodel.HMaker = DBUtility.ClsPub.CurUserName; omodel.HMaterID = Convert.ToInt64(ds.Tables[0].Rows[0]["HMaterID"]); omodel.HQty = 0; omodel.HBarCode = Convert.ToString(ds.Tables[0].Rows[0]["HBarCode"]); omodel.HWhID = HWHID; omodel.HStockPlaceID = HSPID; omodel.HSourceBillNo = "1"; omodel.HSourceBillType = "1"; omodel.HSourceEntryID = 0; omodel.HSourceInterID = 0; if (set_SavePonderationBillMain_Temp(omodel, ref DBUtility.ClsPub.sErrInfo)) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "æ«ç æåï¼"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åå ¥ç¼å表失败ï¼"; objJsonResult.data = null; return objJsonResult; } objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "è·åä¿¡æ¯æåï¼"; 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; } } [Route("EquipMaintainBill/txtHBarCode")] [HttpGet] public object txtHBarCode(string HBarCode) { try { if (HBarCode == null || HBarCode.Equals("")) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¡å½¢ç ä¸è½ä¸ºç©ºï¼"; objJsonResult.data = null; return objJsonResult; } //å¾å°ä¿¡æ¯ ds = oCN.RunProcReturn("select top 1 * from h_v_Gy_EquipFileMainList where HBarCode = '" + HBarCode + "'", "h_v_Gy_EquipFileMainList"); //ds = oWebs.get_InfoByBarCode(HBarCode, ref DBUtility.ClsPub.sErrInfo); //åå ¥ä¿¡æ¯ if (ds == null) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æªæ¥è¯¢å°è®¾å¤ä¿¡æ¯ï¼"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "è·åä¿¡æ¯æåï¼"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } } catch (Exception e) @@ -207,6 +292,7 @@ //oItem.HInnerBillNo = ""; // --å é¨åæ®å· oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd")); oItem.HMouldID = DBUtility.ClsPub.isLong(lsmain[0].HMouldID); //oItem.HEquipID = 0; //设å¤ID(Gy_EquipMent) //oItem.HPeriod = 0; //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); // --ç»´ä¿®æ¥æ @@ -250,6 +336,289 @@ //oItemSub.HRemark = ""; //夿³¨ oItemSub.HSourceInterID = 0; // æºå主å ç oItemSub.HSourceEntryID = 0; //æºååå ç oItemSub.HDotCheckItemID = DBUtility.ClsPub.isLong(ls[0].HDotCheckItemID); oItemSub.HDotCheckItem = DBUtility.ClsPub.isStrNull(ls[0].HDotCheckItem); oItemSub.HDotCheckPart = DBUtility.ClsPub.isStrNull(ls[0].HDotCheckPart); //oItemSub.HSourceBillNo = ""; //æºååå· //oItemSub.HSourceBillType = ""; //æºåç±»å //oItemSub.HRelationQty = 0; //å ³èæ°é //oItemSub.HRelationMoney = 0; //å ³èéé¢ //oItemSub.HRepairID = 0; //ç»´ä¿®é¡¹ç® //oItemSub.HRepairExplanation =""; //ç»´ä¿®è¦æ± //oItemSub.HMoney = 0; //ç»´ä¿®è´¹ç¨ oBill.DetailColl.Add(oItemSub); } //ä¿å //ä¿å宿¯åå¤ç bool bResult; if (oBill.omodel.HInterID == 0) { // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); } else { bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); } 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("Sb_EquipDotCheckBill/savebill")] [HttpPost] public object savebill([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 UserName = ""; ListModels oListModels = new ListModels(); try { DLL.ClsSb_EquipDotCheckBill oBill = new DLL.ClsSb_EquipDotCheckBill(); List<Models.ClsSb_EquipDotCheckBillMain> lsmain = new List<Models.ClsSb_EquipDotCheckBillMain>(); msg2 = msg2.Replace("\\", ""); msg2 = msg2.Replace("\n", ""); //\n lsmain = oListModels.getObjectByJson_Gy_EquipCheckBillMain(msg2); foreach (Models.ClsSb_EquipDotCheckBillMain oItem in lsmain) { //忮巿¯å¦éå¤ if (BillNew.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®å·éå¤ï¼ä¸å 许ä¿åï¼"; objJsonResult.data = 1; return objJsonResult; } //oItem.HMaker = ""; UserName = oItem.HMaker; //å¶å人 oItem.HBillType = "3903"; oItem.HBillSubType = "3903"; //oItem.HBillNo = ""; //åæ®å· //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --æ¥æ //oItem.HInnerBillNo = ""; // --å é¨åæ®å· oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd")); oItem.HEquipID = DBUtility.ClsPub.isLong(lsmain[0].HEquipID); //oItem.HEquipID = 0; //设å¤ID(Gy_EquipMent) //oItem.HPeriod = 0; //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); // --ç»´ä¿®æ¥æ //oItem.HCheckResult = ""; //éªæ¶ç»è®º--(æ£å¸¸ï¼å¼å¸¸) //oItem.HEmpID = 0; //éªæ¶äºº(Gy_Employee) //oItem.HManagerID = 0; //è´è´£äºº(Gy_Employee) //oItem.HDeptID = 0; //éªæ¶é¨é¨(Gy_Department) //oItem.HExplanation = ""; //æè¦(æ éæè¿°) //oItem.HRemark = ""; //夿³¨ //oItem.HMainSourceInterID = oItem.HInterID; //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo); if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿åå¤±è´¥ï¼æ²¡æåæ®æ¥æï¼æ æ³ä¿åï¼"; objJsonResult.data = 1; return objJsonResult; } oBill.omodel = oItem; } //åè¡¨ä½æ°æ® List<Models.ClsSb_EquipDotCheckBillSub> ls = new List<Models.ClsSb_EquipDotCheckBillSub>(); ls = oListModels.getObjectByJson_Gy_EquipDotCheckBillSub(msg2); int i = 0; foreach (Models.ClsSb_EquipDotCheckBillSub oItemSub in ls) { i++; oItemSub.HEntryID = i; //oItemSub.HRepairCheckID = 0; //éªæ¶é¡¹ç®ID //oItemSub.HRepairCheckContent = ""; //éªæ¶å 容 //oItemSub.HManagerID = 0; //è´è´£äººID //oItemSub.HCloseMan = ""; //è¡å ³é oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); oItemSub.HCloseType = false; //å ³éç±»å //oItemSub.HRemark = ""; //夿³¨ oItemSub.HSourceInterID = 0; // æºå主å ç oItemSub.HSourceEntryID = 0; //æºååå ç oItemSub.HDotCheckItemID = DBUtility.ClsPub.isLong(ls[0].HDotCheckItemID); oItemSub.HDotCheckItem = DBUtility.ClsPub.isStrNull(ls[0].HDotCheckItem); oItemSub.HDotCheckPart = DBUtility.ClsPub.isStrNull(ls[0].HDotCheckPart); //oItemSub.HSourceBillNo = ""; //æºååå· //oItemSub.HSourceBillType = ""; //æºåç±»å //oItemSub.HRelationQty = 0; //å ³èæ°é //oItemSub.HRelationMoney = 0; //å ³èéé¢ //oItemSub.HRepairID = 0; //ç»´ä¿®é¡¹ç® //oItemSub.HRepairExplanation =""; //ç»´ä¿®è¦æ± //oItemSub.HMoney = 0; //ç»´ä¿®è´¹ç¨ oBill.DetailColl.Add(oItemSub); } //ä¿å //ä¿å宿¯åå¤ç bool bResult; if (oBill.omodel.HInterID == 0) { // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); } else { bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); } 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("Sb_EquipRepairWorkBill/savebill1")] [HttpPost] public object savebill1([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 UserName = ""; ListModels oListModels = new ListModels(); try { DLL.ClsSb_EquipRepairWorkBill oBill = new DLL.ClsSb_EquipRepairWorkBill(); List<Models.ClsSb_EquipRepairWorkBillMain> lsmain = new List<Models.ClsSb_EquipRepairWorkBillMain>(); msg2 = msg2.Replace("\\", ""); msg2 = msg2.Replace("\n", ""); //\n lsmain = oListModels.wxmain(msg2); foreach (Models.ClsSb_EquipRepairWorkBillMain oItem in lsmain) { //忮巿¯å¦éå¤ if (BillNew.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®å·éå¤ï¼ä¸å 许ä¿åï¼"; objJsonResult.data = 1; return objJsonResult; } //oItem.HMaker = ""; UserName = oItem.HMaker; //å¶å人 oItem.HBillType = "3903"; oItem.HBillSubType = "3903"; //oItem.HBillNo = ""; //åæ®å· //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --æ¥æ //oItem.HInnerBillNo = ""; // --å é¨åæ®å· oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd")); oItem.HEquipID = DBUtility.ClsPub.isLong(lsmain[0].HEquipID); //oItem.HEquipID = 0; //设å¤ID(Gy_EquipMent) //oItem.HPeriod = 0; //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); // --ç»´ä¿®æ¥æ //oItem.HCheckResult = ""; //éªæ¶ç»è®º--(æ£å¸¸ï¼å¼å¸¸) //oItem.HEmpID = 0; //éªæ¶äºº(Gy_Employee) //oItem.HManagerID = 0; //è´è´£äºº(Gy_Employee) //oItem.HDeptID = 0; //éªæ¶é¨é¨(Gy_Department) //oItem.HExplanation = ""; //æè¦(æ éæè¿°) //oItem.HRemark = ""; //夿³¨ //oItem.HMainSourceInterID = oItem.HInterID; //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo); if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿åå¤±è´¥ï¼æ²¡æåæ®æ¥æï¼æ æ³ä¿åï¼"; objJsonResult.data = 1; return objJsonResult; } oBill.omodel = oItem; } //åè¡¨ä½æ°æ® List<Models.ClsSb_EquipRepairWorkBillSub> ls = new List<Models.ClsSb_EquipRepairWorkBillSub>(); ls = oListModels.wxsub(msg2); int i = 0; foreach (Models.ClsSb_EquipRepairWorkBillSub oItemSub in ls) { i++; oItemSub.HEntryID = i; //oItemSub.HRepairCheckID = 0; //éªæ¶é¡¹ç®ID //oItemSub.HRepairCheckContent = ""; //éªæ¶å 容 //oItemSub.HManagerID = 0; //è´è´£äººID //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; //å ³èæ°é WebAPI/Controllers/Sc_MouldController.cs
@@ -165,6 +165,607 @@ #endregion #region æ¨¡å ·æ¹å¶å ¥åºå #region æ¨¡å ·æ¹å¶å ¥åºåä¿å [Route("Sc_MouldRepairInBill/MouldRepairInBill_Save")] [HttpPost] public object MouldRepairInBillAdd([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); //ä¿ååæ® return objJsonResult = MouldRepairInAddBill(msg1); } public json MouldRepairInAddBill(string msg1) { //string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); //string msg2 = sArray[0].ToString(); //string msg3 = sArray[0].ToString(); bool bResult; try { //msg2 = "[" + msg2.ToString() + "]"; msg1 = "[" + msg1.ToString() + "]"; DAL.ClsSc_MouldRepairInBill BillNew = new DAL.ClsSc_MouldRepairInBill(); List<Model.ClsSc_MouldRepairInBillMain> mainList = Newtonsoft .Json .JsonConvert .DeserializeObject<List<Model.ClsSc_MouldRepairInBillMain>>(msg1); List<Model.ClsSc_MouldStockBillSub> subList = Newtonsoft .Json .JsonConvert .DeserializeObject<List<Model.ClsSc_MouldStockBillSub>>(msg1); //夿ä¼è®¡ææ¯å¦åç string s = ""; int sYear = 0; int sPeriod = 0; DateTime HDate = mainList[0].HDate;//æ¥æ if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = s; objJsonResult.data = null; return objJsonResult; } BillNew.omodel.HYear = sYear; BillNew.omodel.HPeriod = sPeriod; BillNew.omodel.HBillNo = mainList[0].HBillNo.Trim(); BillNew.omodel.HMaker = mainList[0].HMaker; BillNew.omodel.HDate = HDate; BillNew.omodel.HWHID = mainList[0].HWHID; BillNew.omodel.HSupID = 0; BillNew.omodel.HSCWHID = 0; BillNew.omodel.HEmpID = 0; BillNew.omodel.HManagerID = mainList[0].HManagerID; BillNew.omodel.HSecManagerID = mainList[0].HSecManagerID; BillNew.omodel.HKeeperID = mainList[0].HKeeperID; BillNew.omodel.HDeptID = mainList[0].HDeptID; BillNew.omodel.HExplanation = mainList[0].HExplanation; BillNew.omodel.HInnerBillNo = mainList[0].HInnerBillNo; BillNew.omodel.HRedBlueFlag = mainList[0].HRedBlueFlag; BillNew.DetailColl = new List<Model.ClsSc_MouldStockBillSub>(); Model.ClsSc_MouldStockBillSub oSub = new Model.ClsSc_MouldStockBillSub(); oSub.HEntryID = 1; oSub.HRemark = DBUtility.ClsPub.isStrNull(subList[0].HRemark); oSub.HSourceInterID = DBUtility.ClsPub.isLong(subList[0].HSourceInterID); oSub.HSourceEntryID = DBUtility.ClsPub.isLong(subList[0].HSourceEntryID); oSub.HSourceBillType = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillType); oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillNo); oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[0].HRelationQty); oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[0].HRelationMoney); oSub.HCloseMan = DBUtility.ClsPub.isStrNull(subList[0].HCloseMan); oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(subList[0].HEntryCloseDate); oSub.HCloseType = DBUtility.ClsPub.isBool(subList[0].HCloseType); oSub.HMaterID = DBUtility.ClsPub.isLong(subList[0].HMaterID); oSub.HPropertyID = DBUtility.ClsPub.isLong(subList[0].HPropertyID); oSub.HSecUnitID = DBUtility.ClsPub.isLong(subList[0].HSecUnitID); oSub.HSecUnitRate = DBUtility.ClsPub.isSingle(subList[0].HSecUnitRate); oSub.HUnitID = DBUtility.ClsPub.isLong(subList[0].HUnitID); oSub.HQtyMust = DBUtility.ClsPub.isDoule(subList[0].HQtyMust); oSub.HQty = DBUtility.ClsPub.isDoule(subList[0].HQty); oSub.HBarCode = DBUtility.ClsPub.isStrNull(subList[0].HBarCode); if (oSub.HQty <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æµè½¬å¡æ°éä¸è½ä¸º0æè å°äº0"; objJsonResult.data = null; return objJsonResult; } oSub.HDesignLife = DBUtility.ClsPub.isLong(subList[0].HDesignLife); if (oSub.HDesignLife < 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "设计寿å½ä¸è½ä¸º0æè å°äº0"; objJsonResult.data = null; return objJsonResult; } oSub.HLeaveLife = DBUtility.ClsPub.isLong(subList[0].HLeaveLife); oSub.HPrice = DBUtility.ClsPub.isDoule(subList[0].HPrice); oSub.HWHID = DBUtility.ClsPub.isLong(subList[0].HWHID); oSub.HSPID = DBUtility.ClsPub.isLong(subList[0].HSPID); oSub.HSCWHID = 0; oSub.HSCSPID = 0; oSub.HSPGroupID = DBUtility.ClsPub.isLong(subList[0].HSPGroupID); oSub.HBatchNo = DBUtility.ClsPub.isStrNull(subList[0].HBatchNo); oSub.HNewModel = DBUtility.ClsPub.isStrNull(subList[0].HNewModel); oSub.HWallThickness = DBUtility.ClsPub.isStrNull(subList[0].HWallThickness); oSub.HHardness = DBUtility.ClsPub.isStrNull(subList[0].HHardness); oSub.HLastProdModel = DBUtility.ClsPub.isStrNull(subList[0].HLastProdModel); oSub.HDiameter = DBUtility.ClsPub.isStrNull(subList[0].HDiameter); oSub.HBackFlag = DBUtility.ClsPub.isStrNull(subList[0].HBackFlag); BillNew.DetailColl.Add(oSub); bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo); //æç¤º if (bResult == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = ClsPub.sExeReturnInfo + "åæ®å·:" + mainList[0].HBillNo.Trim(); objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败!åå :" + ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #endregion #region æ¨¡å ·éè´å ¥åºå #region æ¨¡å ·éè´å ¥åºåä¿å [Route("Sc_MouldProdInBill/MouldProdInBill_Save")] [HttpPost] public object MouldProdInBillAdd([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); //ä¿ååæ® return objJsonResult = MouldProdInAddBill(msg1); } public json MouldProdInAddBill(string msg1) { //string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); //string msg2 = sArray[0].ToString(); //string msg3 = sArray[0].ToString(); bool bResult; try { //msg2 = "[" + msg2.ToString() + "]"; msg1 = "[" + msg1.ToString() + "]"; DAL.ClsSc_MouldProdInBill BillNew = new DAL.ClsSc_MouldProdInBill(); List<Model.ClsSc_MouldProdInBillMain> mainList = Newtonsoft .Json .JsonConvert .DeserializeObject<List<Model.ClsSc_MouldProdInBillMain>>(msg1); List<Model.ClsSc_MouldStockBillSub> subList = Newtonsoft .Json .JsonConvert .DeserializeObject<List<Model.ClsSc_MouldStockBillSub>>(msg1); //夿ä¼è®¡ææ¯å¦åç string s = ""; int sYear = 0; int sPeriod = 0; DateTime HDate = mainList[0].HDate;//æ¥æ if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = s; objJsonResult.data = null; return objJsonResult; } BillNew.omodel.HYear = sYear; BillNew.omodel.HPeriod = sPeriod; BillNew.omodel.HBillNo = mainList[0].HBillNo.Trim(); BillNew.omodel.HMaker = mainList[0].HMaker; BillNew.omodel.HDate = HDate; BillNew.omodel.HWHID = mainList[0].HWHID; BillNew.omodel.HSupID = 0; BillNew.omodel.HSCWHID = 0; BillNew.omodel.HEmpID = 0; BillNew.omodel.HManagerID = mainList[0].HManagerID; BillNew.omodel.HSecManagerID = mainList[0].HSecManagerID; BillNew.omodel.HKeeperID = mainList[0].HKeeperID; BillNew.omodel.HDeptID = mainList[0].HDeptID; BillNew.omodel.HExplanation = mainList[0].HExplanation; BillNew.omodel.HInnerBillNo = mainList[0].HInnerBillNo; BillNew.omodel.HRedBlueFlag = mainList[0].HRedBlueFlag; BillNew.DetailColl = new List<Model.ClsSc_MouldStockBillSub>(); Model.ClsSc_MouldStockBillSub oSub = new Model.ClsSc_MouldStockBillSub(); oSub.HEntryID = 1; oSub.HRemark = DBUtility.ClsPub.isStrNull(subList[0].HRemark); oSub.HSourceInterID = DBUtility.ClsPub.isLong(subList[0].HSourceInterID); oSub.HSourceEntryID = DBUtility.ClsPub.isLong(subList[0].HSourceEntryID); oSub.HSourceBillType = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillType); oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillNo); oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[0].HRelationQty); oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[0].HRelationMoney); oSub.HCloseMan = DBUtility.ClsPub.isStrNull(subList[0].HCloseMan); oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(subList[0].HEntryCloseDate); oSub.HCloseType = DBUtility.ClsPub.isBool(subList[0].HCloseType); oSub.HMaterID = DBUtility.ClsPub.isLong(subList[0].HMaterID); oSub.HPropertyID = DBUtility.ClsPub.isLong(subList[0].HPropertyID); oSub.HSecUnitID = DBUtility.ClsPub.isLong(subList[0].HSecUnitID); oSub.HSecUnitRate = DBUtility.ClsPub.isSingle(subList[0].HSecUnitRate); oSub.HUnitID = DBUtility.ClsPub.isLong(subList[0].HUnitID); oSub.HQtyMust = DBUtility.ClsPub.isDoule(subList[0].HQtyMust); oSub.HQty = DBUtility.ClsPub.isDoule(subList[0].HQty); oSub.HBarCode = DBUtility.ClsPub.isStrNull(subList[0].HBarCode); if (oSub.HQty <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æµè½¬å¡æ°éä¸è½ä¸º0æè å°äº0"; objJsonResult.data = null; return objJsonResult; } oSub.HDesignLife = DBUtility.ClsPub.isLong(subList[0].HDesignLife); if (oSub.HDesignLife < 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "设计寿å½ä¸è½ä¸º0æè å°äº0"; objJsonResult.data = null; return objJsonResult; } oSub.HLeaveLife = DBUtility.ClsPub.isLong(subList[0].HLeaveLife); oSub.HPrice = DBUtility.ClsPub.isDoule(subList[0].HPrice); oSub.HWHID = DBUtility.ClsPub.isLong(subList[0].HWHID); oSub.HSPID = DBUtility.ClsPub.isLong(subList[0].HSPID); oSub.HSCWHID = 0; oSub.HSCSPID = 0; oSub.HSPGroupID = DBUtility.ClsPub.isLong(subList[0].HSPGroupID); oSub.HBatchNo = DBUtility.ClsPub.isStrNull(subList[0].HBatchNo); oSub.HNewModel = DBUtility.ClsPub.isStrNull(subList[0].HNewModel); oSub.HWallThickness = DBUtility.ClsPub.isStrNull(subList[0].HWallThickness); oSub.HHardness = DBUtility.ClsPub.isStrNull(subList[0].HHardness); oSub.HLastProdModel = DBUtility.ClsPub.isStrNull(subList[0].HLastProdModel); oSub.HDiameter = DBUtility.ClsPub.isStrNull(subList[0].HDiameter); oSub.HBackFlag = DBUtility.ClsPub.isStrNull(subList[0].HBackFlag); BillNew.DetailColl.Add(oSub); bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo); //æç¤º if (bResult == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = ClsPub.sExeReturnInfo + "åæ®å·:" + mainList[0].HBillNo.Trim(); objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败!åå :" + ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #endregion #region æ¨¡å ·æ¹å¶åºåºå #region æ¨¡å ·æ¹å¶åºåºåä¿å [Route("Sc_MouldRepairOutBill/MouldRepairOutBill_Save")] [HttpPost] public object MouldRepairOutBillAdd([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); //ä¿ååæ® return objJsonResult = MouldRepairOutAddBill(msg1); } public json MouldRepairOutAddBill(string msg1) { //string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); //string msg2 = sArray[0].ToString(); //string msg3 = sArray[0].ToString(); bool bResult; try { //msg2 = "[" + msg2.ToString() + "]"; msg1 = "[" + msg1.ToString() + "]"; DAL.ClsSc_MouldRepairOutBill BillNew = new DAL.ClsSc_MouldRepairOutBill(); List<Model.ClsSc_MouldRepairOutBillMain> mainList = Newtonsoft .Json .JsonConvert .DeserializeObject<List<Model.ClsSc_MouldRepairOutBillMain>>(msg1); List<Model.ClsSc_MouldStockBillSub> subList = Newtonsoft .Json .JsonConvert .DeserializeObject<List<Model.ClsSc_MouldStockBillSub>>(msg1); //夿ä¼è®¡ææ¯å¦åç string s = ""; int sYear = 0; int sPeriod = 0; DateTime HDate = mainList[0].HDate;//æ¥æ if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = s; objJsonResult.data = null; return objJsonResult; } BillNew.omodel.HYear = sYear; BillNew.omodel.HPeriod = sPeriod; BillNew.omodel.HBillNo = mainList[0].HBillNo.Trim(); BillNew.omodel.HMaker = mainList[0].HMaker; BillNew.omodel.HDate = HDate; BillNew.omodel.HWHID = mainList[0].HWHID; BillNew.omodel.HSupID = 0; BillNew.omodel.HSCWHID = 0; BillNew.omodel.HEmpID = 0; BillNew.omodel.HManagerID = mainList[0].HManagerID; BillNew.omodel.HSecManagerID = mainList[0].HSecManagerID; BillNew.omodel.HKeeperID = mainList[0].HKeeperID; BillNew.omodel.HDeptID = mainList[0].HDeptID; BillNew.omodel.HExplanation = mainList[0].HExplanation; BillNew.omodel.HInnerBillNo = mainList[0].HInnerBillNo; BillNew.omodel.HRedBlueFlag = mainList[0].HRedBlueFlag; BillNew.DetailColl = new List<Model.ClsSc_MouldStockBillSub>(); Model.ClsSc_MouldStockBillSub oSub = new Model.ClsSc_MouldStockBillSub(); oSub.HEntryID = 1; oSub.HRemark = DBUtility.ClsPub.isStrNull(subList[0].HRemark); oSub.HSourceInterID = DBUtility.ClsPub.isLong(subList[0].HSourceInterID); oSub.HSourceEntryID = DBUtility.ClsPub.isLong(subList[0].HSourceEntryID); oSub.HSourceBillType = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillType); oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillNo); oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[0].HRelationQty); oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[0].HRelationMoney); oSub.HCloseMan = DBUtility.ClsPub.isStrNull(subList[0].HCloseMan); oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(subList[0].HEntryCloseDate); oSub.HCloseType = DBUtility.ClsPub.isBool(subList[0].HCloseType); oSub.HMaterID = DBUtility.ClsPub.isLong(subList[0].HMaterID); oSub.HPropertyID = DBUtility.ClsPub.isLong(subList[0].HPropertyID); oSub.HSecUnitID = DBUtility.ClsPub.isLong(subList[0].HSecUnitID); oSub.HSecUnitRate = DBUtility.ClsPub.isSingle(subList[0].HSecUnitRate); oSub.HUnitID = DBUtility.ClsPub.isLong(subList[0].HUnitID); oSub.HQtyMust = DBUtility.ClsPub.isDoule(subList[0].HQtyMust); oSub.HQty = DBUtility.ClsPub.isDoule(subList[0].HQty); oSub.HBarCode = DBUtility.ClsPub.isStrNull(subList[0].HBarCode); if (oSub.HQty <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æµè½¬å¡æ°éä¸è½ä¸º0æè å°äº0"; objJsonResult.data = null; return objJsonResult; } oSub.HDesignLife = DBUtility.ClsPub.isLong(subList[0].HDesignLife); if (oSub.HDesignLife < 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "设计寿å½ä¸è½ä¸º0æè å°äº0"; objJsonResult.data = null; return objJsonResult; } oSub.HLeaveLife = DBUtility.ClsPub.isLong(subList[0].HLeaveLife); oSub.HPrice = DBUtility.ClsPub.isDoule(subList[0].HPrice); oSub.HWHID = DBUtility.ClsPub.isLong(subList[0].HWHID); oSub.HSPID = DBUtility.ClsPub.isLong(subList[0].HSPID); oSub.HSCWHID = 0; oSub.HSCSPID = 0; oSub.HSPGroupID = DBUtility.ClsPub.isLong(subList[0].HSPGroupID); oSub.HBatchNo = DBUtility.ClsPub.isStrNull(subList[0].HBatchNo); oSub.HNewModel = DBUtility.ClsPub.isStrNull(subList[0].HNewModel); oSub.HWallThickness = DBUtility.ClsPub.isStrNull(subList[0].HWallThickness); oSub.HHardness = DBUtility.ClsPub.isStrNull(subList[0].HHardness); oSub.HLastProdModel = DBUtility.ClsPub.isStrNull(subList[0].HLastProdModel); oSub.HDiameter = DBUtility.ClsPub.isStrNull(subList[0].HDiameter); oSub.HBackFlag = DBUtility.ClsPub.isStrNull(subList[0].HBackFlag); BillNew.DetailColl.Add(oSub); bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo); //æç¤º if (bResult == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = ClsPub.sExeReturnInfo + "åæ®å·:" + mainList[0].HBillNo.Trim(); objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败!åå :" + ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #endregion #region æ¨¡å ·æ¥åºå ¥åºå #region æ¨¡å ·æ¥åºå ¥åºåä¿å [Route("Sc_MouldScrapInBill/MouldScrapInBill_Save")] [HttpPost] public object MouldScrapInBillAdd([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); //ä¿ååæ® return objJsonResult = MouldScrapInAddBill(msg1); } public json MouldScrapInAddBill(string msg1) { //string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); //string msg2 = sArray[0].ToString(); //string msg3 = sArray[0].ToString(); bool bResult; try { //msg2 = "[" + msg2.ToString() + "]"; msg1 = "[" + msg1.ToString() + "]"; DAL.ClsSc_MouldScrapInBill BillNew = new DAL.ClsSc_MouldScrapInBill(); List<Model.ClsSc_MouldScrapInBillMain> mainList = Newtonsoft .Json .JsonConvert .DeserializeObject<List<Model.ClsSc_MouldScrapInBillMain>>(msg1); List<Model.ClsSc_MouldStockBillSub> subList = Newtonsoft .Json .JsonConvert .DeserializeObject<List<Model.ClsSc_MouldStockBillSub>>(msg1); //夿ä¼è®¡ææ¯å¦åç string s = ""; int sYear = 0; int sPeriod = 0; DateTime HDate = mainList[0].HDate;//æ¥æ if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = s; objJsonResult.data = null; return objJsonResult; } BillNew.omodel.HYear = sYear; BillNew.omodel.HPeriod = sPeriod; BillNew.omodel.HBillNo = mainList[0].HBillNo.Trim(); BillNew.omodel.HMaker = mainList[0].HMaker; BillNew.omodel.HDate = HDate; BillNew.omodel.HWHID = mainList[0].HWHID; BillNew.omodel.HSupID = 0; BillNew.omodel.HSCWHID = 0; BillNew.omodel.HEmpID = 0; BillNew.omodel.HManagerID = mainList[0].HManagerID; BillNew.omodel.HSecManagerID = mainList[0].HSecManagerID; BillNew.omodel.HKeeperID = mainList[0].HKeeperID; BillNew.omodel.HDeptID = mainList[0].HDeptID; BillNew.omodel.HExplanation = mainList[0].HExplanation; BillNew.omodel.HInnerBillNo = mainList[0].HInnerBillNo; BillNew.omodel.HRedBlueFlag = mainList[0].HRedBlueFlag; BillNew.DetailColl = new List<Model.ClsSc_MouldStockBillSub>(); Model.ClsSc_MouldStockBillSub oSub = new Model.ClsSc_MouldStockBillSub(); oSub.HEntryID = 1; oSub.HRemark = DBUtility.ClsPub.isStrNull(subList[0].HRemark); oSub.HSourceInterID = DBUtility.ClsPub.isLong(subList[0].HSourceInterID); oSub.HSourceEntryID = DBUtility.ClsPub.isLong(subList[0].HSourceEntryID); oSub.HSourceBillType = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillType); oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillNo); oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[0].HRelationQty); oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[0].HRelationMoney); oSub.HCloseMan = DBUtility.ClsPub.isStrNull(subList[0].HCloseMan); oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(subList[0].HEntryCloseDate); oSub.HCloseType = DBUtility.ClsPub.isBool(subList[0].HCloseType); oSub.HMaterID = DBUtility.ClsPub.isLong(subList[0].HMaterID); oSub.HPropertyID = DBUtility.ClsPub.isLong(subList[0].HPropertyID); oSub.HSecUnitID = DBUtility.ClsPub.isLong(subList[0].HSecUnitID); oSub.HSecUnitRate = DBUtility.ClsPub.isSingle(subList[0].HSecUnitRate); oSub.HUnitID = DBUtility.ClsPub.isLong(subList[0].HUnitID); oSub.HQtyMust = DBUtility.ClsPub.isDoule(subList[0].HQtyMust); oSub.HQty = DBUtility.ClsPub.isDoule(subList[0].HQty); oSub.HBarCode = DBUtility.ClsPub.isStrNull(subList[0].HBarCode); if (oSub.HQty <= 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æµè½¬å¡æ°éä¸è½ä¸º0æè å°äº0"; objJsonResult.data = null; return objJsonResult; } oSub.HDesignLife = DBUtility.ClsPub.isLong(subList[0].HDesignLife); if (oSub.HDesignLife < 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "设计寿å½ä¸è½ä¸º0æè å°äº0"; objJsonResult.data = null; return objJsonResult; } oSub.HLeaveLife = DBUtility.ClsPub.isLong(subList[0].HLeaveLife); oSub.HPrice = DBUtility.ClsPub.isDoule(subList[0].HPrice); oSub.HWHID = DBUtility.ClsPub.isLong(subList[0].HWHID); oSub.HSPID = DBUtility.ClsPub.isLong(subList[0].HSPID); oSub.HSCWHID = 0; oSub.HSCSPID = 0; oSub.HSPGroupID = DBUtility.ClsPub.isLong(subList[0].HSPGroupID); oSub.HBatchNo = DBUtility.ClsPub.isStrNull(subList[0].HBatchNo); oSub.HNewModel = DBUtility.ClsPub.isStrNull(subList[0].HNewModel); oSub.HWallThickness = DBUtility.ClsPub.isStrNull(subList[0].HWallThickness); oSub.HHardness = DBUtility.ClsPub.isStrNull(subList[0].HHardness); oSub.HLastProdModel = DBUtility.ClsPub.isStrNull(subList[0].HLastProdModel); oSub.HDiameter = DBUtility.ClsPub.isStrNull(subList[0].HDiameter); oSub.HBackFlag = DBUtility.ClsPub.isStrNull(subList[0].HBackFlag); BillNew.DetailColl.Add(oSub); bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo); //æç¤º if (bResult == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = ClsPub.sExeReturnInfo + "åæ®å·:" + mainList[0].HBillNo.Trim(); objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败!åå :" + ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #endregion #region æ¨¡å ·ç产é¢ç¨å #region æ¨¡å ·ç产é¢ç¨åä¿å @@ -283,7 +884,7 @@ oSub.HDiameter = DBUtility.ClsPub.isStrNull(subList[0].HDiameter); oSub.HBackFlag = DBUtility.ClsPub.isStrNull(subList[0].HBackFlag); BillNew.DetailColl.Add(oSub); bResult = BillNew.AddBill_PDA(ref ClsPub.sExeReturnInfo); bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo); //æç¤º if (bResult == true) { @@ -434,7 +1035,7 @@ oSub.HDesignLife = DBUtility.ClsPub.isLong(subList[0].HDesignLife); oSub.HUseLife = DBUtility.ClsPub.isLong(subList[0].HUseLife); BillNew.DetailColl.Add(oSub); bResult = BillNew.AddBill_PDA(ref ClsPub.sExeReturnInfo); bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo); //æç¤º if (bResult == true) { @@ -879,6 +1480,116 @@ #endregion #region 设å¤ç»´ä¿®è®°å½åä¿å [Route("Sb_EquipMaintainBill/EquipMaintainBill_Save")] [HttpPost] public object EquipMaintainBill_Save([FromBody] JObject sMainSub) { var _value = sMainSub["sMainSub"].ToString(); string msg1 = _value.ToString(); return objJsonResult = EquipMaintainAddBill(msg1); } public json EquipMaintainAddBill(string msg1) { bool bResult; try { msg1 = "[" + msg1.ToString() + "]"; DAL.ClsSb_MouldRepairWorkBill BillNew = new DAL.ClsSb_MouldRepairWorkBill(); List<Model.ClsSb_MouldRepairWorkBillMain> mainList = Newtonsoft .Json .JsonConvert .DeserializeObject<List<Model.ClsSb_MouldRepairWorkBillMain>>(msg1); List<Model.ClsSb_MouldRepairWorkBillSub> subList = Newtonsoft .Json .JsonConvert .DeserializeObject<List<Model.ClsSb_MouldRepairWorkBillSub>>(msg1); string s = ""; int sYear = 0; int sPeriod = 0; DateTime HDate = mainList[0].HDate; if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = s; objJsonResult.data = null; return objJsonResult; } BillNew.omodel.HYear = sYear; BillNew.omodel.HPeriod = sPeriod; BillNew.omodel.HBillNo = mainList[0].HBillNo.Trim(); BillNew.omodel.HMaker = mainList[0].HMaker; BillNew.omodel.HDate = HDate; BillNew.omodel.HMouldID = mainList[0].HMouldID; BillNew.omodel.HDeptID = mainList[0].HDeptID; BillNew.omodel.HEmpID = mainList[0].HEmpID; BillNew.omodel.HRepairID = mainList[0].HRepairID; BillNew.omodel.HManagerID = mainList[0].HManagerID; BillNew.omodel.HRepairBeginDate = mainList[0].HRepairBeginDate; BillNew.omodel.HRepairEndDate = mainList[0].HRepairEndDate; BillNew.omodel.HRepairContent = mainList[0].HRepairContent; BillNew.omodel.HCycleUnit = mainList[0].HCycleUnit; BillNew.omodel.HPlanTimes = mainList[0].HPlanTimes; BillNew.omodel.HTimes = mainList[0].HTimes; BillNew.omodel.HExplanation = mainList[0].HExplanation; BillNew.omodel.HInnerBillNo = mainList[0].HInnerBillNo; BillNew.omodel.HMouldID = mainList[0].HMouldID; BillNew.omodel.HSupID = mainList[0].HSupID; BillNew.omodel.HRepairType = mainList[0].HRepairType; BillNew.omodel.HNewModel = mainList[0].HNewModel; BillNew.omodel.HNewDesignLife = mainList[0].HNewDesignLife; BillNew.omodel.HEquipID = mainList[0].HEquipID; BillNew.DetailColl = new List<Model.ClsSb_MouldRepairWorkBillSub>(); Model.ClsSb_MouldRepairWorkBillSub oSub = new Model.ClsSb_MouldRepairWorkBillSub(); oSub.HEntryID = 1; oSub.HRemark = DBUtility.ClsPub.isStrNull(subList[0].HRemark); oSub.HSourceInterID = DBUtility.ClsPub.isLong(subList[0].HSourceInterID); oSub.HSourceEntryID = DBUtility.ClsPub.isLong(subList[0].HSourceEntryID); oSub.HSourceBillType = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillType); oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillNo); oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[0].HRelationQty); oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[0].HRelationMoney); oSub.HCloseMan = DBUtility.ClsPub.isStrNull(subList[0].HCloseMan); oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(subList[0].HEntryCloseDate); oSub.HCloseType = DBUtility.ClsPub.isBool(subList[0].HCloseType); oSub.HRepairID = DBUtility.ClsPub.isLong(subList[0].HRepairID); oSub.HManagerID = DBUtility.ClsPub.isLong(subList[0].HManagerID); oSub.HMoney = DBUtility.ClsPub.isDoule(subList[0].HMoney); oSub.HRepairExplanation = DBUtility.ClsPub.isStrNull(subList[0].HRepairExplanation); BillNew.DetailColl.Add(oSub); bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo); if (bResult == true) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = ClsPub.sExeReturnInfo + "åæ®å·:" + mainList[0].HBillNo.Trim(); objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败!åå :" + ClsPub.sExeReturnInfo; objJsonResult.data = null; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #endregion #region æ¨¡å ·å¯¿å½è°æ´å WebAPI/DLL/DAL.dllBinary files differ
WebAPI/ListModels.cs
@@ -1315,7 +1315,7 @@ /// <summary> /// å¤çæ°å¢ç¹æ£è®°å½è¡¨å表çjson /// å¤çæ°å¢æ¨¡å ·ç¹æ£è®°å½è¡¨å表çjson /// </summary> /// <param name="jsonString"></param> /// <returns></returns> @@ -1328,7 +1328,20 @@ /// <summary> /// å¤çæ°å¢ç¹æ£è®°å½åå表çjson /// å¤çæ°å¢è®¾å¤ç¹æ£è®°å½è¡¨å表çjson /// </summary> /// <param name="jsonString"></param> /// <returns></returns> public List<Models.ClsSb_EquipDotCheckBillMain> getObjectByJson_Gy_EquipCheckBillMain(string jsonString) { jsonString = "[" + jsonString.ToString() + "]"; List<Models.ClsSb_EquipDotCheckBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSb_EquipDotCheckBillMain>>(jsonString); return list; } /// <summary> /// å¤çæ°å¢æ¨¡å ·ç¹æ£è®°å½åå表çjson /// </summary> /// <param name="jsonString"></param> /// <returns></returns> @@ -1341,6 +1354,45 @@ /// <summary> /// å¤çæ°å¢è®¾å¤ç»´ä¿®è®°å½è¡¨å表çjson /// </summary> /// <param name="jsonString"></param> /// <returns></returns> public List<Models.ClsSb_EquipRepairWorkBillMain> wxmain(string jsonString) { jsonString = "[" + jsonString.ToString() + "]"; List<Models.ClsSb_EquipRepairWorkBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSb_EquipRepairWorkBillMain>>(jsonString); return list; } /// <summary> /// å¤çæ°å¢æ¨¡å ·ç»´ä¿®å½åå表çjson /// </summary> /// <param name="jsonString"></param> /// <returns></returns> public List<Models.ClsSb_EquipRepairWorkBillSub> wxsub(string jsonString) { jsonString = "[" + jsonString.ToString() + "]"; List<Models.ClsSb_EquipRepairWorkBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSb_EquipRepairWorkBillSub>>(jsonString); return list; } /// <summary> /// å¤çæ°å¢è®¾å¤ç¹æ£è®°å½åå表çjson /// </summary> /// <param name="jsonString"></param> /// <returns></returns> public List<Models.ClsSb_EquipDotCheckBillSub> getObjectByJson_Gy_EquipDotCheckBillSub(string jsonString) { jsonString = "[" + jsonString.ToString() + "]"; List<Models.ClsSb_EquipDotCheckBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSb_EquipDotCheckBillSub>>(jsonString); return list; } /// <summary> /// å¤çæ°å¢ä¿å »è®°å½è¡¨å表çjson /// </summary> /// <param name="jsonString"></param> WebAPI/Models/ClsSb_EquipDotCheckBillSub.cs
@@ -16,6 +16,7 @@ public string HMaterNumber; public string HMaterName; public string HMaterModel; public Int64 HDotCheckItemID; public string HDotCheckItem; public string HDotCheckPart; public string HClaim; WebAPI/Models/ClsSc_MouldDotCheckBillSub.cs
@@ -11,6 +11,8 @@ public string HDotCheckPart;// varchar(100) --ç¹æ£é¨ä½ public string HClaim;// varchar(100) --å ·ä½è¦æ± public long HManagerID;// int --è´è´£äººid(h_v_IF_Employee) public long HDotCheckItemID;// int --è´è´£äººid(h_v_IF_Employee) } } WebAPI/Models/Xt_DataDictionary_Proc.cs
New file @@ -0,0 +1,33 @@ using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace WebAPI.Models { public class Xt_DataDictionary_Proc { public long HItemID { get; set; } public long HModNameID { get; set; } public long HBillTypeID { get; set; } public string HProcName { get; set; } public string HProcCaption { get; set; } public string HRemark { get; set; } public bool HStopflag { get; set; } public DateTime HMakeTime { get; set; } public string HMakeEmp { get; set; } public DateTime HModifyTime { get; set; } public string HModifyEmp { get; set; } public DateTime HStopTime { get; set; } public string HStopEmp { get; set; } } } WebAPI/Models/»ù´¡×ÊÁÏ/Gy_ClassTimePrj.cs
New file @@ -0,0 +1,24 @@ using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace WebAPI.Models { public class Gy_ClassTimePrj { public long HItemID { get; set; } public string HName { get; set; } public string HNumber { get; set; } public long hparentid { get; set; } public string HRemark { get; set; } public long HDeptID { get; set; } public long HGroupID { get; set; } public bool HStopflag { get; set; } } } WebAPI/Properties/PublishProfiles/FolderProfile.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|2021-10-22T05:46:49.7207066Z;True|2021-10-22T10:06:33.3130089+08:00;True|2021-10-20T14:32:10.1235516+08:00;True|2021-10-20T14:16:18.6496291+08:00;True|2021-10-20T14:08:49.2443715+08:00;True|2021-10-20T14:05:14.6847950+08:00;True|2021-10-20T13:30:21.6057636+08:00;True|2021-10-20T10:55:22.2151716+08:00;True|2021-10-19T10:42:13.4198267+08:00;True|2021-10-19T10:01:41.0018108+08:00;True|2021-10-19T09:59:11.2127619+08:00;True|2021-10-19T09:54:04.8472874+08:00;True|2021-10-15T11:19:15.5327495+08:00;True|2021-10-15T11:17:41.0686485+08:00;True|2021-10-15T11:12:11.8295042+08:00;True|2021-10-15T10:33:31.5670079+08:00;True|2021-10-15T10:27:45.0815146+08:00;True|2021-10-14T14:51:28.5331025+08:00;True|2021-10-14T14:37:28.3276051+08:00;True|2021-10-14T14:23:39.0606792+08:00;True|2021-10-14T14:21:03.8140347+08:00;True|2021-10-13T10:31:10.6628977+08:00;True|2021-10-13T10:12:24.4238027+08:00;True|2021-10-13T08:47:43.9314486+08:00;True|2021-10-12T14:07:18.6065183+08:00;True|2021-10-12T10:34:10.1682362+08:00;True|2021-10-12T10:27:14.3073332+08:00;True|2021-10-12T10:22:08.0004619+08:00;True|2021-10-12T10:21:03.0275378+08:00;True|2021-10-12T10:11:54.9812692+08:00;True|2021-10-11T16:59:07.3568342+08:00;True|2021-10-11T16:53:14.2016138+08:00;True|2021-10-11T16:21:35.0133775+08:00;True|2021-10-11T15:34:19.5731935+08:00;True|2021-10-11T15:31:07.5780983+08:00;True|2021-10-11T15:06:47.1145237+08:00;True|2021-10-11T15:03:25.5000280+08:00;True|2021-10-11T10:12:57.6416898+08:00;True|2021-10-09T10:15:17.9235165+08:00;True|2021-10-09T10:13:51.3318441+08:00;True|2021-10-09T10:01:21.6661542+08:00;True|2021-10-09T09:58:41.9225837+08:00;True|2021-10-08T14:56:49.7935800+08:00;True|2021-10-08T14:35:41.4490063+08:00;True|2021-10-08T14:02:42.6990656+08:00;True|2021-09-29T15:48:55.1547397+08:00;True|2021-09-29T15:48:23.5567191+08:00;True|2021-09-27T16:17:35.7180978+08:00;True|2021-09-27T15:51:50.4240134+08:00;True|2021-09-23T20:55:27.3554447+08:00;True|2021-09-23T14:14:44.0572017+08:00;True|2021-09-23T13:51:56.2344673+08:00;True|2021-09-23T10:46:16.7417007+08:00;True|2021-09-23T10:42:23.2117537+08:00;True|2021-09-22T15:21:22.9615672+08:00;True|2021-09-22T14:23:32.7907754+08:00;True|2021-09-22T13:48:03.4780947+08:00;True|2021-09-22T11:05:24.5249356+08:00;True|2021-09-22T10:00:19.0962943+08:00;True|2021-09-22T09:30:26.2686514+08:00;True|2021-09-17T11:22:34.5692792+08:00;True|2021-09-16T16:11:27.5372277+08:00;True|2021-09-16T14:53:40.8396557+08:00;True|2021-09-16T14:32:29.7905500+08:00;True|2021-09-16T14:26:46.2224219+08:00;True|2021-09-16T10:32:24.4244440+08:00;True|2021-09-15T11:10:35.3529360+08:00;True|2021-09-15T11:08:30.0857376+08:00;True|2021-09-15T11:05:56.7191571+08:00;True|2021-09-14T01:24:39.8041136+08:00;True|2021-09-14T01:05:01.1593327+08:00;True|2021-09-14T00:44:14.7233198+08:00;True|2021-09-13T23:48:19.4506233+08:00;True|2021-09-13T20:30:31.3243872+08:00;True|2021-09-13T19:45:35.9108911+08:00;False|2021-09-13T19:44:59.2779092+08:00;True|2021-09-13T18:09:22.4994381+08:00;True|2021-09-10T14:18:27.5788854+08:00;True|2021-09-09T15:57:01.7407207+08:00;True|2021-09-09T15:49:34.2598998+08:00;True|2021-09-09T11:32:10.7853024+08:00;True|2021-09-09T11:10:48.6840025+08:00;True|2021-09-09T10:35:37.3883078+08:00;True|2021-09-07T14:11:49.8497588+08:00;True|2021-09-07T13:34:48.4693349+08:00;True|2021-09-06T14:33:48.7549675+08:00;True|2021-09-03T16:27:51.1888520+08:00;True|2021-09-03T16:19:35.9003465+08:00;True|2021-09-03T15:46:28.1828032+08:00;True|2021-09-03T15:34:21.9362871+08:00;True|2021-09-03T11:24:49.8749819+08:00;True|2021-09-03T11:21:17.8373159+08:00;True|2021-09-03T11:16:53.2208136+08:00;True|2021-09-03T11:12:23.9063804+08:00;True|2021-09-03T09:11:09.2435721+08:00;True|2021-09-02T11:16:15.1370453+08:00;True|2021-09-02T10:35:39.1171879+08:00;True|2021-09-01T10:17:09.4536285+08:00;True|2021-09-01T09:46:28.4581776+08:00;True|2021-08-31T08:54:26.8588887+08:00;True|2021-08-31T08:39:08.3685693+08:00;True|2021-08-30T17:11:56.8438985+08:00;True|2021-08-30T15:59:42.0820292+08:00;True|2021-08-30T15:45:18.1868510+08:00;True|2021-08-30T14:56:08.3958863+08:00;True|2021-08-30T14:37:11.5379830+08:00;True|2021-08-30T14:35:34.8775934+08:00;True|2021-08-30T14:24:36.5111821+08:00;True|2021-08-30T10:05:49.6945200+08:00;True|2021-08-30T10:03:28.4064538+08:00;True|2021-08-30T10:00:16.8360929+08:00;True|2021-08-30T09:56:09.4434379+08:00;True|2021-08-30T09:55:36.1725334+08:00;True|2021-08-30T09:52:04.8600054+08:00;True|2021-08-30T09:47:46.4225655+08:00;True|2021-08-30T09:45:20.4894962+08:00;False|2021-08-27T17:17:34.2646751+08:00;False|2021-08-27T16:01:21.2791979+08:00;False|2021-08-27T15:58:06.9667160+08:00;False|2021-08-27T15:38:37.4818036+08:00;False|2021-08-27T15:21:02.8863114+08:00;False|2021-08-27T15:20:28.6828668+08:00;True|2021-08-26T16:00:44.3162145+08:00;True|2021-08-26T08:57:31.3842587+08:00;True|2021-08-23T08:43:41.1549775+08:00;True|2021-08-22T09:24:12.7210871+08:00;True|2021-08-22T09:19:53.8300229+08:00;True|2021-08-20T20:00:52.0140407+08:00;True|2021-08-20T19:40:14.7712765+08:00;True|2021-08-19T17:37:54.9748049+08:00;True|2021-08-19T17:20:11.0515687+08:00;True|2021-08-19T16:12:35.4392809+08:00;True|2021-08-19T16:06:50.6204587+08:00;True|2021-08-19T16:03:53.0824286+08:00;True|2021-08-19T15:56:01.3498791+08:00;True|2021-08-19T10:18:50.8113630+08:00;True|2021-08-19T09:58:06.2784035+08:00;True|2021-08-19T09:56:54.0619777+08:00;True|2021-08-19T00:32:08.3503093+08:00;True|2021-08-19T00:11:18.3150227+08:00;True|2021-08-19T00:02:49.4827718+08:00;True|2021-08-18T23:54:45.4845900+08:00;True|2021-08-18T23:39:51.6147977+08:00;True|2021-08-18T23:16:42.7214379+08:00;True|2021-08-18T22:38:57.4681929+08:00;True|2021-08-18T21:41:58.7560707+08:00;True|2021-08-18T21:11:52.2369249+08:00;True|2021-08-18T21:01:49.5669106+08:00;True|2021-08-18T20:47:46.5352688+08:00;False|2021-08-18T20:46:36.7956141+08:00;False|2021-08-18T20:46:01.0502138+08:00;True|2021-08-18T19:39:12.8186242+08:00;False|2021-08-18T19:38:12.6839708+08:00;True|2021-08-18T19:15:51.4626694+08:00;True|2021-08-18T16:07:20.4350886+08:00;True|2021-08-18T14:29:41.7171934+08:00;True|2021-08-18T14:20:36.3647361+08:00;True|2021-08-16T09:08:58.3617662+08:00;True|2021-08-15T20:44:29.9214083+08:00;True|2021-08-15T20:36:17.0958549+08:00;True|2021-08-15T20:29:34.3879773+08:00;True|2021-08-15T20:23:47.4052038+08:00;True|2021-08-15T15:01:19.7830862+08:00;True|2021-08-15T12:15:18.3433782+08:00;True|2021-08-13T20:59:11.3947130+08:00;True|2021-08-06T22:49:09.9538339+08:00;True|2021-08-06T22:35:19.0418168+08:00;True|2021-08-06T20:29:47.4241975+08:00;True|2021-08-06T14:08:16.4791827+08:00;True|2021-08-06T13:59:28.9874611+08:00;True|2021-08-06T13:57:34.3723977+08:00;True|2021-08-06T13:36:03.4816652+08:00;True|2021-08-06T12:22:52.5055221+08:00;True|2021-08-06T09:31:58.1272499+08:00;True|2021-08-06T09:26:51.6310039+08:00;True|2021-08-06T09:24:22.2899244+08:00;True|2021-08-06T09:06:30.6477912+08:00;True|2021-08-06T09:00:55.5101612+08:00;True|2021-08-06T08:49:59.9616490+08:00;True|2021-08-06T08:45:18.8586902+08:00;True|2021-08-05T20:09:25.8861998+08:00;True|2021-08-04T19:14:27.2396953+08:00;True|2021-08-04T19:11:47.5849093+08:00;True|2021-08-04T16:42:54.0149043+08:00;True|2021-08-04T15:02:11.5056561+08:00;True|2021-08-04T14:58:37.1435509+08:00;True|2021-08-04T14:55:34.7380132+08:00;True|2021-08-04T14:47:42.5933921+08:00;True|2021-08-04T14:45:17.9911874+08:00;True|2021-08-04T13:52:20.9601351+08:00;True|2021-08-04T09:48:28.8796992+08:00;True|2021-08-03T18:14:13.1894998+08:00;True|2021-08-03T17:45:35.1349721+08:00;True|2021-08-03T17:21:52.6028977+08:00;True|2021-08-03T17:20:35.4423020+08:00;True|2021-08-03T17:03:33.1667669+08:00;True|2021-08-03T17:01:54.2656787+08:00;True|2021-08-03T17:00:22.2778374+08:00;True|2021-08-03T16:56:58.8902582+08:00;True|2021-08-03T15:02:21.8601533+08:00;True|2021-08-03T14:57:34.0186758+08:00;True|2021-08-03T14:28:47.2242515+08:00;True|2021-08-03T14:22:22.4554236+08:00;True|2021-08-03T14:21:51.1339715+08:00;True|2021-08-03T13:37:33.9697131+08:00;True|2021-08-03T13:28:29.7591095+08:00;True|2021-08-03T11:35:09.5118324+08:00;True|2021-08-03T11:11:23.3051573+08:00;True|2021-08-02T13:14:42.3663755+08:00;True|2021-07-30T22:50:19.9749878+08:00;True|2021-07-30T22:49:31.2150970+08:00;True|2021-07-28T19:12:05.8381075+08:00;True|2021-07-28T18:59:45.4808797+08:00;True|2021-07-28T18:15:58.8301509+08:00;True|2021-07-28T18:04:54.8613546+08:00;True|2021-07-28T17:53:48.6225611+08:00;True|2021-07-28T17:42:50.9171563+08:00;True|2021-07-28T17:17:16.3137677+08:00;True|2021-07-28T17:11:46.8925200+08:00;True|2021-07-28T16:28:27.6823943+08:00;True|2021-07-28T16:23:00.3385836+08:00;True|2021-07-28T09:57:55.4237411+08:00;True|2021-07-28T08:38:29.6691541+08:00;True|2021-07-27T23:16:32.0331671+08:00;True|2021-07-27T23:06:08.1947249+08:00;True|2021-07-27T23:05:58.4619176+08:00;True|2021-07-27T18:42:09.5358261+08:00;True|2021-07-27T18:30:04.8532823+08:00;True|2021-07-27T18:29:43.5775092+08:00;True|2021-07-27T15:16:49.8356224+08:00;True|2021-07-27T15:05:27.8453220+08:00;True|2021-07-27T14:59:15.9519440+08:00;True|2021-07-27T09:23:32.6111337+08:00;True|2021-07-27T08:27:41.6395353+08:00;True|2021-07-27T08:25:56.7378296+08:00;True|2021-07-26T11:18:46.0856966+08:00;True|2021-07-26T11:18:02.0751924+08:00;True|2021-07-26T11:13:49.6285395+08:00;True|2021-07-21T21:08:25.9898902+08:00;True|2021-07-21T20:09:26.2258104+08:00;True|2021-07-13T16:17:25.8407435+08:00;True|2021-07-13T13:46:13.4309531+08:00;True|2021-07-13T12:29:04.5082461+08:00;True|2021-06-29T13:55:01.6864637+08:00;True|2021-06-29T10:38:52.2206472+08:00;True|2021-06-29T10:10:13.1540749+08:00;True|2021-06-28T14:37:56.3853273+08:00;False|2021-06-28T14:36:57.5726124+08:00;True|2021-06-25T14:17:57.5196108+08:00;True|2021-06-25T13:56:38.9522535+08:00;True|2021-06-24T19:38:32.8766933+08:00;True|2021-06-24T18:26:35.6118833+08:00;True|2021-06-24T18:02:52.8136877+08:00;True|2021-06-24T17:48:49.5851948+08:00;True|2021-06-24T17:45:46.7527572+08:00;True|2021-06-24T15:05:20.1592723+08:00;True|2021-06-23T16:18:15.6814625+08:00;True|2021-06-23T16:05:24.6112343+08:00;True|2021-06-23T15:14:08.2489658+08:00;True|2021-06-23T13:52:58.6029788+08:00;True|2021-06-22T16:11:20.4726923+08:00;True|2021-06-22T16:04:53.7231389+08:00;True|2021-06-22T15:50:59.2583262+08:00;True|2021-06-22T15:38:15.3016140+08:00;True|2021-06-22T15:34:42.9185543+08:00;True|2021-06-22T15:21:55.1419108+08:00;True|2021-06-22T15:07:21.5357494+08:00;True|2021-06-22T15:03:35.0535733+08:00;True|2021-06-22T14:54:47.8802969+08:00;True|2021-06-22T11:19:38.7303011+08:00;True|2021-06-22T08:53:49.2882695+08:00;True|2021-06-22T08:47:54.8286530+08:00;True|2021-06-21T16:27:19.3017700+08:00;True|2021-06-21T15:32:28.7237952+08:00;True|2021-06-21T12:34:02.6329555+08:00;True|2021-06-21T12:24:17.5427495+08:00;True|2021-06-21T10:47:30.6423502+08:00;True|2021-06-21T08:43:20.3026558+08:00;True|2021-06-19T15:10:06.8335499+08:00;True|2021-06-18T15:37:29.5009930+08:00;True|2021-06-18T13:46:35.6283432+08:00;True|2021-06-18T10:00:37.1474954+08:00;True|2021-06-18T09:55:21.8551780+08:00;True|2021-06-18T09:22:27.8432927+08:00;True|2021-06-17T11:17:43.2166430+08:00;True|2021-06-17T09:24:09.8350403+08:00;True|2021-06-16T16:10:47.8564888+08:00;True|2021-06-16T16:04:09.8286582+08:00;True|2021-06-16T15:12:29.9427169+08:00;True|2021-06-16T14:58:45.6801892+08:00;True|2021-06-16T14:46:01.6873221+08:00;True|2021-06-16T11:02:06.1272477+08:00;True|2021-06-16T09:33:56.0223915+08:00;True|2021-06-16T08:50:07.6995413+08:00;True|2021-06-16T08:28:38.7692635+08:00;True|2021-06-16T01:04:19.6282474+08:00;True|2021-06-16T01:03:50.5058323+08:00;False|2021-06-16T01:02:15.3819672+08:00;False|2021-06-16T01:01:38.6171098+08:00;True|2021-06-16T00:34:54.9902044+08:00;True|2021-06-15T23:55:36.2003828+08:00;True|2021-06-15T22:47:17.2192750+08:00;True|2021-06-15T22:42:41.1512585+08:00;True|2021-06-15T22:38:01.7390462+08:00;True|2021-06-15T22:14:11.2060782+08:00;True|2021-06-15T22:12:27.0615357+08:00;True|2021-06-15T22:07:59.9280871+08:00;True|2021-06-15T22:04:21.5051427+08:00;True|2021-06-15T21:25:55.0099814+08:00;True|2021-06-15T19:13:51.3494172+08:00;True|2021-06-15T19:02:17.6844742+08:00;True|2021-06-15T18:47:37.1629411+08:00;False|2021-06-15T18:47:11.0828111+08:00;True|2021-06-15T18:38:26.6620668+08:00;True|2021-06-15T18:33:45.2069831+08:00;True|2021-06-15T18:24:52.0550838+08:00;True|2021-06-15T18:19:43.6999796+08:00;True|2021-06-15T18:08:17.2464506+08:00;True|2021-06-15T18:03:51.3952624+08:00;True|2021-06-15T18:01:20.6141766+08:00;True|2021-06-15T17:59:04.4479416+08:00;True|2021-06-15T17:41:44.6389379+08:00;True|2021-06-15T17:39:03.1565124+08:00;True|2021-06-15T17:34:41.0634638+08:00;True|2021-06-15T17:33:50.4853178+08:00;True|2021-06-15T17:25:38.5914037+08:00;True|2021-06-15T17:22:21.3611360+08:00;True|2021-06-15T17:16:49.4970813+08:00;True|2021-06-15T17:05:28.9389484+08:00;True|2021-06-15T16:52:54.6372199+08:00;True|2021-06-15T16:51:23.9081030+08:00;True|2021-06-15T16:45:40.6017997+08:00;True|2021-06-15T16:41:05.0218887+08:00;True|2021-06-15T16:38:02.8541862+08:00;True|2021-06-15T16:22:10.3118721+08:00;True|2021-06-15T16:12:11.1552506+08:00;True|2021-06-15T15:33:42.0100494+08:00;True|2021-06-15T15:28:39.7145659+08:00;True|2021-06-15T15:15:02.7939125+08:00;True|2021-06-15T14:49:14.2300396+08:00;True|2021-06-15T14:42:28.1198064+08:00;True|2021-06-15T13:30:12.7997686+08:00;True|2021-06-15T13:25:37.7284670+08:00;True|2021-06-15T13:23:43.6207813+08:00;False|2021-06-15T13:23:19.4190232+08:00;True|2021-06-15T13:16:38.5062674+08:00;True|2021-06-15T13:03:31.2055635+08:00;True|2021-06-15T12:58:43.1653215+08:00;True|2021-06-15T12:39:22.8442109+08:00;True|2021-06-15T12:35:09.1288556+08:00;False|2021-06-15T12:33:50.0723143+08:00;True|2021-06-15T11:28:01.9733727+08:00;True|2021-06-15T11:26:26.6569392+08:00;True|2021-06-15T11:22:43.0366435+08:00;True|2021-06-15T11:07:50.1610580+08:00;True|2021-06-15T10:32:59.1925931+08:00;True|2021-06-10T17:16:57.9552310+08:00;True|2021-06-10T16:44:42.2731836+08:00;True|2021-06-10T14:39:27.6745737+08:00;True|2021-06-10T12:15:05.1524413+08:00;True|2021-06-09T18:19:24.1005606+08:00;True|2021-06-09T17:56:09.5646288+08:00;True|2021-06-09T13:34:06.1882292+08:00;True|2021-06-09T13:29:54.5924933+08:00;True|2021-06-09T13:25:55.7520662+08:00;True|2021-06-09T13:07:47.6686811+08:00;True|2021-06-09T12:59:41.2595048+08:00;True|2021-06-09T12:45:27.1305548+08:00;True|2021-06-09T12:29:52.1418191+08:00;True|2021-06-09T12:24:12.7610588+08:00;True|2021-06-09T11:31:25.3409568+08:00;True|2021-06-09T09:57:44.4387175+08:00;True|2021-06-09T09:54:26.5161307+08:00;True|2021-06-09T09:14:14.7288045+08:00;True|2021-06-09T09:10:25.1812139+08:00;True|2021-06-09T08:46:21.6585123+08:00;True|2021-06-08T19:56:55.7192062+08:00;True|2021-06-08T19:52:59.0326821+08:00;True|2021-06-08T19:49:13.6274217+08:00;True|2021-06-08T19:09:22.1038939+08:00;True|2021-06-08T15:28:41.3716247+08:00;True|2021-06-08T15:26:47.2621178+08:00;True|2021-06-08T13:49:45.8936617+08:00;True|2021-06-08T13:43:18.8115502+08:00;True|2021-06-08T10:04:06.2200731+08:00;True|2021-06-08T09:17:10.0470792+08:00;True|2021-06-08T08:44:37.4395849+08:00;True|2021-06-08T00:01:09.3745613+08:00;True|2021-06-07T23:49:31.5196888+08:00;True|2021-06-07T23:41:00.8017855+08:00;True|2021-06-07T23:21:53.1371134+08:00;True|2021-06-07T23:01:27.5712153+08:00;True|2021-06-07T22:36:12.9274014+08:00;True|2021-06-07T22:23:00.6545134+08:00;True|2021-06-07T17:44:47.5686346+08:00;True|2021-06-07T17:17:01.3431233+08:00;True|2021-06-07T16:53:28.9989587+08:00;True|2021-06-07T16:41:10.4975607+08:00;True|2021-06-07T14:21:06.8176477+08:00;True|2021-06-07T14:10:39.0355659+08:00;True|2021-06-07T12:34:31.4562732+08:00;True|2021-06-07T12:28:44.9629488+08:00;True|2021-06-07T10:30:26.9387988+08:00;True|2021-06-07T09:12:14.7658099+08:00;True|2021-06-07T08:37:19.6353792+08:00;True|2021-06-07T08:35:25.2031954+08:00;True|2021-06-05T07:07:32.0541266+08:00;True|2021-06-05T06:44:35.9475270+08:00;True|2021-06-05T06:37:27.4595197+08:00;True|2021-06-05T06:26:59.7663998+08:00;True|2021-06-05T05:43:12.8699318+08:00;True|2021-06-04T17:00:41.2426007+08:00;True|2021-06-04T16:08:03.8078072+08:00;True|2021-06-04T15:47:21.6412616+08:00;True|2021-06-04T15:21:02.4239800+08:00;True|2021-06-04T15:20:37.8641854+08:00;True|2021-06-04T13:38:51.5088395+08:00;True|2021-06-04T10:20:01.7784282+08:00;True|2021-06-04T10:13:50.3548857+08:00;True|2021-06-04T10:11:25.5017821+08:00;True|2021-06-04T10:09:51.6792228+08:00;True|2021-06-04T10:02:39.5851057+08:00;True|2021-06-04T09:30:40.4495494+08:00;True|2021-06-03T13:16:36.0317546+08:00;True|2021-06-03T13:12:47.0402047+08:00;True|2021-06-02T14:37:08.9683351+08:00;True|2021-06-02T14:10:15.7439829+08:00;True|2021-06-02T13:59:46.5841931+08:00;True|2021-06-02T13:25:18.7962660+08:00;True|2021-06-02T13:23:16.2261980+08:00;True|2021-06-01T15:37:32.2495085+08:00;True|2021-06-01T15:21:01.2856122+08:00;True|2021-06-01T15:13:36.7262365+08:00;True|2021-06-01T15:10:26.8905629+08:00;True|2021-06-01T14:56:17.5231551+08:00;True|2021-06-01T14:38:39.7895927+08:00;True|2021-06-01T14:23:12.3265287+08:00;True|2021-03-01T09:11:31.3226422+08:00;True|2021-05-26T14:54:56.9426462+08:00;True|2021-05-26T13:57:33.7780451+08:00;True|2021-05-26T13:39:02.8043358+08:00;True|2021-02-25T16:01:40.2917200+08:00;True|2021-02-25T15:49:46.6681205+08:00;True|2021-02-25T15:16:30.9372640+08:00;True|2021-05-25T13:10:21.7831921+08:00;True|2021-05-25T11:21:38.5224475+08:00;True|2021-05-25T11:12:52.0637175+08:00;True|2021-05-25T11:02:18.4164663+08:00;True|2021-05-25T10:52:06.8998521+08:00;True|2021-05-25T10:50:45.0929606+08:00;True|2021-05-25T10:45:54.1498313+08:00;True|2021-05-25T10:39:27.8602249+08:00;True|2021-05-25T10:34:49.5771162+08:00;True|2021-05-25T10:17:30.3009163+08:00;True|2021-05-25T10:14:03.8512581+08:00;True|2021-05-25T10:05:33.4343836+08:00;True|2021-05-24T17:01:23.3221168+08:00;True|2021-05-24T10:11:24.0197347+08:00;False|2021-05-24T10:11:07.6338995+08:00;</History> <History>True|2021-10-28T08:27:53.9728270Z;True|2021-10-28T16:03:59.5629998+08:00;True|2021-10-28T08:51:04.2549186+08:00;True|2021-10-27T15:14:53.5506098+08:00;True|2021-10-27T15:00:44.9100320+08:00;True|2021-10-27T13:14:46.7921647+08:00;True|2021-10-27T11:24:49.4550753+08:00;True|2021-10-27T10:10:10.3545125+08:00;True|2021-10-27T10:02:24.9248610+08:00;True|2021-10-27T09:59:40.3795897+08:00;True|2021-10-27T09:56:30.6629207+08:00;True|2021-10-27T09:10:48.3883432+08:00;True|2021-10-27T09:03:31.9191991+08:00;True|2021-10-27T08:59:59.7651159+08:00;True|2021-10-27T08:36:11.8620997+08:00;True|2021-10-27T08:26:40.2533014+08:00;True|2021-10-26T09:19:35.5674748+08:00;True|2021-10-26T09:17:17.6900747+08:00;True|2021-10-26T09:14:32.3999220+08:00;True|2021-10-25T15:08:21.2581763+08:00;True|2021-10-25T10:01:57.8524903+08:00;True|2021-10-25T09:28:51.6294879+08:00;True|2021-10-25T09:25:50.3373336+08:00;True|2021-10-25T09:23:37.0203978+08:00;True|2021-10-25T09:18:23.3380608+08:00;True|2021-10-25T09:15:10.5292071+08:00;True|2021-10-25T08:56:30.4632027+08:00;True|2021-10-25T08:50:11.4697392+08:00;True|2021-10-22T13:46:49.7207066+08:00;True|2021-10-22T10:06:33.3130089+08:00;True|2021-10-20T14:32:10.1235516+08:00;True|2021-10-20T14:16:18.6496291+08:00;True|2021-10-20T14:08:49.2443715+08:00;True|2021-10-20T14:05:14.6847950+08:00;True|2021-10-20T13:30:21.6057636+08:00;True|2021-10-20T10:55:22.2151716+08:00;True|2021-10-19T10:42:13.4198267+08:00;True|2021-10-19T10:01:41.0018108+08:00;True|2021-10-19T09:59:11.2127619+08:00;True|2021-10-19T09:54:04.8472874+08:00;True|2021-10-15T11:19:15.5327495+08:00;True|2021-10-15T11:17:41.0686485+08:00;True|2021-10-15T11:12:11.8295042+08:00;True|2021-10-15T10:33:31.5670079+08:00;True|2021-10-15T10:27:45.0815146+08:00;True|2021-10-14T14:51:28.5331025+08:00;True|2021-10-14T14:37:28.3276051+08:00;True|2021-10-14T14:23:39.0606792+08:00;True|2021-10-14T14:21:03.8140347+08:00;True|2021-10-13T10:31:10.6628977+08:00;True|2021-10-13T10:12:24.4238027+08:00;True|2021-10-13T08:47:43.9314486+08:00;True|2021-10-12T14:07:18.6065183+08:00;True|2021-10-12T10:34:10.1682362+08:00;True|2021-10-12T10:27:14.3073332+08:00;True|2021-10-12T10:22:08.0004619+08:00;True|2021-10-12T10:21:03.0275378+08:00;True|2021-10-12T10:11:54.9812692+08:00;True|2021-10-11T16:59:07.3568342+08:00;True|2021-10-11T16:53:14.2016138+08:00;True|2021-10-11T16:21:35.0133775+08:00;True|2021-10-11T15:34:19.5731935+08:00;True|2021-10-11T15:31:07.5780983+08:00;True|2021-10-11T15:06:47.1145237+08:00;True|2021-10-11T15:03:25.5000280+08:00;True|2021-10-11T10:12:57.6416898+08:00;True|2021-10-09T10:15:17.9235165+08:00;True|2021-10-09T10:13:51.3318441+08:00;True|2021-10-09T10:01:21.6661542+08:00;True|2021-10-09T09:58:41.9225837+08:00;True|2021-10-08T14:56:49.7935800+08:00;True|2021-10-08T14:35:41.4490063+08:00;True|2021-10-08T14:02:42.6990656+08:00;True|2021-09-29T15:48:55.1547397+08:00;True|2021-09-29T15:48:23.5567191+08:00;True|2021-09-27T16:17:35.7180978+08:00;True|2021-09-27T15:51:50.4240134+08:00;True|2021-09-23T20:55:27.3554447+08:00;True|2021-09-23T14:14:44.0572017+08:00;True|2021-09-23T13:51:56.2344673+08:00;True|2021-09-23T10:46:16.7417007+08:00;True|2021-09-23T10:42:23.2117537+08:00;True|2021-09-22T15:21:22.9615672+08:00;True|2021-09-22T14:23:32.7907754+08:00;True|2021-09-22T13:48:03.4780947+08:00;True|2021-09-22T11:05:24.5249356+08:00;True|2021-09-22T10:00:19.0962943+08:00;True|2021-09-22T09:30:26.2686514+08:00;True|2021-09-17T11:22:34.5692792+08:00;True|2021-09-16T16:11:27.5372277+08:00;True|2021-09-16T14:53:40.8396557+08:00;True|2021-09-16T14:32:29.7905500+08:00;True|2021-09-16T14:26:46.2224219+08:00;True|2021-09-16T10:32:24.4244440+08:00;True|2021-09-15T11:10:35.3529360+08:00;True|2021-09-15T11:08:30.0857376+08:00;True|2021-09-15T11:05:56.7191571+08:00;True|2021-09-14T01:24:39.8041136+08:00;True|2021-09-14T01:05:01.1593327+08:00;True|2021-09-14T00:44:14.7233198+08:00;True|2021-09-13T23:48:19.4506233+08:00;True|2021-09-13T20:30:31.3243872+08:00;True|2021-09-13T19:45:35.9108911+08:00;False|2021-09-13T19:44:59.2779092+08:00;True|2021-09-13T18:09:22.4994381+08:00;True|2021-09-10T14:18:27.5788854+08:00;True|2021-09-09T15:57:01.7407207+08:00;True|2021-09-09T15:49:34.2598998+08:00;True|2021-09-09T11:32:10.7853024+08:00;True|2021-09-09T11:10:48.6840025+08:00;True|2021-09-09T10:35:37.3883078+08:00;True|2021-09-07T14:11:49.8497588+08:00;True|2021-09-07T13:34:48.4693349+08:00;True|2021-09-06T14:33:48.7549675+08:00;True|2021-09-03T16:27:51.1888520+08:00;True|2021-09-03T16:19:35.9003465+08:00;True|2021-09-03T15:46:28.1828032+08:00;True|2021-09-03T15:34:21.9362871+08:00;True|2021-09-03T11:24:49.8749819+08:00;True|2021-09-03T11:21:17.8373159+08:00;True|2021-09-03T11:16:53.2208136+08:00;True|2021-09-03T11:12:23.9063804+08:00;True|2021-09-03T09:11:09.2435721+08:00;True|2021-09-02T11:16:15.1370453+08:00;True|2021-09-02T10:35:39.1171879+08:00;True|2021-09-01T10:17:09.4536285+08:00;True|2021-09-01T09:46:28.4581776+08:00;True|2021-08-31T08:54:26.8588887+08:00;True|2021-08-31T08:39:08.3685693+08:00;True|2021-08-30T17:11:56.8438985+08:00;True|2021-08-30T15:59:42.0820292+08:00;True|2021-08-30T15:45:18.1868510+08:00;True|2021-08-30T14:56:08.3958863+08:00;True|2021-08-30T14:37:11.5379830+08:00;True|2021-08-30T14:35:34.8775934+08:00;True|2021-08-30T14:24:36.5111821+08:00;True|2021-08-30T10:05:49.6945200+08:00;True|2021-08-30T10:03:28.4064538+08:00;True|2021-08-30T10:00:16.8360929+08:00;True|2021-08-30T09:56:09.4434379+08:00;True|2021-08-30T09:55:36.1725334+08:00;True|2021-08-30T09:52:04.8600054+08:00;True|2021-08-30T09:47:46.4225655+08:00;True|2021-08-30T09:45:20.4894962+08:00;False|2021-08-27T17:17:34.2646751+08:00;False|2021-08-27T16:01:21.2791979+08:00;False|2021-08-27T15:58:06.9667160+08:00;False|2021-08-27T15:38:37.4818036+08:00;False|2021-08-27T15:21:02.8863114+08:00;False|2021-08-27T15:20:28.6828668+08:00;True|2021-08-26T16:00:44.3162145+08:00;True|2021-08-26T08:57:31.3842587+08:00;True|2021-08-23T08:43:41.1549775+08:00;True|2021-08-22T09:24:12.7210871+08:00;True|2021-08-22T09:19:53.8300229+08:00;True|2021-08-20T20:00:52.0140407+08:00;True|2021-08-20T19:40:14.7712765+08:00;True|2021-08-19T17:37:54.9748049+08:00;True|2021-08-19T17:20:11.0515687+08:00;True|2021-08-19T16:12:35.4392809+08:00;True|2021-08-19T16:06:50.6204587+08:00;True|2021-08-19T16:03:53.0824286+08:00;True|2021-08-19T15:56:01.3498791+08:00;True|2021-08-19T10:18:50.8113630+08:00;True|2021-08-19T09:58:06.2784035+08:00;True|2021-08-19T09:56:54.0619777+08:00;True|2021-08-19T00:32:08.3503093+08:00;True|2021-08-19T00:11:18.3150227+08:00;True|2021-08-19T00:02:49.4827718+08:00;True|2021-08-18T23:54:45.4845900+08:00;True|2021-08-18T23:39:51.6147977+08:00;True|2021-08-18T23:16:42.7214379+08:00;True|2021-08-18T22:38:57.4681929+08:00;True|2021-08-18T21:41:58.7560707+08:00;True|2021-08-18T21:11:52.2369249+08:00;True|2021-08-18T21:01:49.5669106+08:00;True|2021-08-18T20:47:46.5352688+08:00;False|2021-08-18T20:46:36.7956141+08:00;False|2021-08-18T20:46:01.0502138+08:00;True|2021-08-18T19:39:12.8186242+08:00;False|2021-08-18T19:38:12.6839708+08:00;True|2021-08-18T19:15:51.4626694+08:00;True|2021-08-18T16:07:20.4350886+08:00;True|2021-08-18T14:29:41.7171934+08:00;True|2021-08-18T14:20:36.3647361+08:00;True|2021-08-16T09:08:58.3617662+08:00;True|2021-08-15T20:44:29.9214083+08:00;True|2021-08-15T20:36:17.0958549+08:00;True|2021-08-15T20:29:34.3879773+08:00;True|2021-08-15T20:23:47.4052038+08:00;True|2021-08-15T15:01:19.7830862+08:00;True|2021-08-15T12:15:18.3433782+08:00;True|2021-08-13T20:59:11.3947130+08:00;True|2021-08-06T22:49:09.9538339+08:00;True|2021-08-06T22:35:19.0418168+08:00;True|2021-08-06T20:29:47.4241975+08:00;True|2021-08-06T14:08:16.4791827+08:00;True|2021-08-06T13:59:28.9874611+08:00;True|2021-08-06T13:57:34.3723977+08:00;True|2021-08-06T13:36:03.4816652+08:00;True|2021-08-06T12:22:52.5055221+08:00;True|2021-08-06T09:31:58.1272499+08:00;True|2021-08-06T09:26:51.6310039+08:00;True|2021-08-06T09:24:22.2899244+08:00;True|2021-08-06T09:06:30.6477912+08:00;True|2021-08-06T09:00:55.5101612+08:00;True|2021-08-06T08:49:59.9616490+08:00;True|2021-08-06T08:45:18.8586902+08:00;True|2021-08-05T20:09:25.8861998+08:00;True|2021-08-04T19:14:27.2396953+08:00;True|2021-08-04T19:11:47.5849093+08:00;True|2021-08-04T16:42:54.0149043+08:00;True|2021-08-04T15:02:11.5056561+08:00;True|2021-08-04T14:58:37.1435509+08:00;True|2021-08-04T14:55:34.7380132+08:00;True|2021-08-04T14:47:42.5933921+08:00;True|2021-08-04T14:45:17.9911874+08:00;True|2021-08-04T13:52:20.9601351+08:00;True|2021-08-04T09:48:28.8796992+08:00;True|2021-08-03T18:14:13.1894998+08:00;True|2021-08-03T17:45:35.1349721+08:00;True|2021-08-03T17:21:52.6028977+08:00;True|2021-08-03T17:20:35.4423020+08:00;True|2021-08-03T17:03:33.1667669+08:00;True|2021-08-03T17:01:54.2656787+08:00;True|2021-08-03T17:00:22.2778374+08:00;True|2021-08-03T16:56:58.8902582+08:00;True|2021-08-03T15:02:21.8601533+08:00;True|2021-08-03T14:57:34.0186758+08:00;True|2021-08-03T14:28:47.2242515+08:00;True|2021-08-03T14:22:22.4554236+08:00;True|2021-08-03T14:21:51.1339715+08:00;True|2021-08-03T13:37:33.9697131+08:00;True|2021-08-03T13:28:29.7591095+08:00;True|2021-08-03T11:35:09.5118324+08:00;True|2021-08-03T11:11:23.3051573+08:00;True|2021-08-02T13:14:42.3663755+08:00;True|2021-07-30T22:50:19.9749878+08:00;True|2021-07-30T22:49:31.2150970+08:00;True|2021-07-28T19:12:05.8381075+08:00;True|2021-07-28T18:59:45.4808797+08:00;True|2021-07-28T18:15:58.8301509+08:00;True|2021-07-28T18:04:54.8613546+08:00;True|2021-07-28T17:53:48.6225611+08:00;True|2021-07-28T17:42:50.9171563+08:00;True|2021-07-28T17:17:16.3137677+08:00;True|2021-07-28T17:11:46.8925200+08:00;True|2021-07-28T16:28:27.6823943+08:00;True|2021-07-28T16:23:00.3385836+08:00;True|2021-07-28T09:57:55.4237411+08:00;True|2021-07-28T08:38:29.6691541+08:00;True|2021-07-27T23:16:32.0331671+08:00;True|2021-07-27T23:06:08.1947249+08:00;True|2021-07-27T23:05:58.4619176+08:00;True|2021-07-27T18:42:09.5358261+08:00;True|2021-07-27T18:30:04.8532823+08:00;True|2021-07-27T18:29:43.5775092+08:00;True|2021-07-27T15:16:49.8356224+08:00;True|2021-07-27T15:05:27.8453220+08:00;True|2021-07-27T14:59:15.9519440+08:00;True|2021-07-27T09:23:32.6111337+08:00;True|2021-07-27T08:27:41.6395353+08:00;True|2021-07-27T08:25:56.7378296+08:00;True|2021-07-26T11:18:46.0856966+08:00;True|2021-07-26T11:18:02.0751924+08:00;True|2021-07-26T11:13:49.6285395+08:00;True|2021-07-21T21:08:25.9898902+08:00;True|2021-07-21T20:09:26.2258104+08:00;True|2021-07-13T16:17:25.8407435+08:00;True|2021-07-13T13:46:13.4309531+08:00;True|2021-07-13T12:29:04.5082461+08:00;True|2021-06-29T13:55:01.6864637+08:00;True|2021-06-29T10:38:52.2206472+08:00;True|2021-06-29T10:10:13.1540749+08:00;True|2021-06-28T14:37:56.3853273+08:00;False|2021-06-28T14:36:57.5726124+08:00;True|2021-06-25T14:17:57.5196108+08:00;True|2021-06-25T13:56:38.9522535+08:00;True|2021-06-24T19:38:32.8766933+08:00;True|2021-06-24T18:26:35.6118833+08:00;True|2021-06-24T18:02:52.8136877+08:00;True|2021-06-24T17:48:49.5851948+08:00;True|2021-06-24T17:45:46.7527572+08:00;True|2021-06-24T15:05:20.1592723+08:00;True|2021-06-23T16:18:15.6814625+08:00;True|2021-06-23T16:05:24.6112343+08:00;True|2021-06-23T15:14:08.2489658+08:00;True|2021-06-23T13:52:58.6029788+08:00;True|2021-06-22T16:11:20.4726923+08:00;True|2021-06-22T16:04:53.7231389+08:00;True|2021-06-22T15:50:59.2583262+08:00;True|2021-06-22T15:38:15.3016140+08:00;True|2021-06-22T15:34:42.9185543+08:00;True|2021-06-22T15:21:55.1419108+08:00;True|2021-06-22T15:07:21.5357494+08:00;True|2021-06-22T15:03:35.0535733+08:00;True|2021-06-22T14:54:47.8802969+08:00;True|2021-06-22T11:19:38.7303011+08:00;True|2021-06-22T08:53:49.2882695+08:00;True|2021-06-22T08:47:54.8286530+08:00;True|2021-06-21T16:27:19.3017700+08:00;True|2021-06-21T15:32:28.7237952+08:00;True|2021-06-21T12:34:02.6329555+08:00;True|2021-06-21T12:24:17.5427495+08:00;True|2021-06-21T10:47:30.6423502+08:00;True|2021-06-21T08:43:20.3026558+08:00;True|2021-06-19T15:10:06.8335499+08:00;True|2021-06-18T15:37:29.5009930+08:00;True|2021-06-18T13:46:35.6283432+08:00;True|2021-06-18T10:00:37.1474954+08:00;True|2021-06-18T09:55:21.8551780+08:00;True|2021-06-18T09:22:27.8432927+08:00;True|2021-06-17T11:17:43.2166430+08:00;True|2021-06-17T09:24:09.8350403+08:00;True|2021-06-16T16:10:47.8564888+08:00;True|2021-06-16T16:04:09.8286582+08:00;True|2021-06-16T15:12:29.9427169+08:00;True|2021-06-16T14:58:45.6801892+08:00;True|2021-06-16T14:46:01.6873221+08:00;True|2021-06-16T11:02:06.1272477+08:00;True|2021-06-16T09:33:56.0223915+08:00;True|2021-06-16T08:50:07.6995413+08:00;True|2021-06-16T08:28:38.7692635+08:00;True|2021-06-16T01:04:19.6282474+08:00;True|2021-06-16T01:03:50.5058323+08:00;False|2021-06-16T01:02:15.3819672+08:00;False|2021-06-16T01:01:38.6171098+08:00;True|2021-06-16T00:34:54.9902044+08:00;True|2021-06-15T23:55:36.2003828+08:00;True|2021-06-15T22:47:17.2192750+08:00;True|2021-06-15T22:42:41.1512585+08:00;True|2021-06-15T22:38:01.7390462+08:00;True|2021-06-15T22:14:11.2060782+08:00;True|2021-06-15T22:12:27.0615357+08:00;True|2021-06-15T22:07:59.9280871+08:00;True|2021-06-15T22:04:21.5051427+08:00;True|2021-06-15T21:25:55.0099814+08:00;True|2021-06-15T19:13:51.3494172+08:00;True|2021-06-15T19:02:17.6844742+08:00;True|2021-06-15T18:47:37.1629411+08:00;False|2021-06-15T18:47:11.0828111+08:00;True|2021-06-15T18:38:26.6620668+08:00;True|2021-06-15T18:33:45.2069831+08:00;True|2021-06-15T18:24:52.0550838+08:00;True|2021-06-15T18:19:43.6999796+08:00;True|2021-06-15T18:08:17.2464506+08:00;True|2021-06-15T18:03:51.3952624+08:00;True|2021-06-15T18:01:20.6141766+08:00;True|2021-06-15T17:59:04.4479416+08:00;True|2021-06-15T17:41:44.6389379+08:00;True|2021-06-15T17:39:03.1565124+08:00;True|2021-06-15T17:34:41.0634638+08:00;True|2021-06-15T17:33:50.4853178+08:00;True|2021-06-15T17:25:38.5914037+08:00;True|2021-06-15T17:22:21.3611360+08:00;True|2021-06-15T17:16:49.4970813+08:00;True|2021-06-15T17:05:28.9389484+08:00;True|2021-06-15T16:52:54.6372199+08:00;True|2021-06-15T16:51:23.9081030+08:00;True|2021-06-15T16:45:40.6017997+08:00;True|2021-06-15T16:41:05.0218887+08:00;True|2021-06-15T16:38:02.8541862+08:00;True|2021-06-15T16:22:10.3118721+08:00;True|2021-06-15T16:12:11.1552506+08:00;True|2021-06-15T15:33:42.0100494+08:00;True|2021-06-15T15:28:39.7145659+08:00;True|2021-06-15T15:15:02.7939125+08:00;True|2021-06-15T14:49:14.2300396+08:00;True|2021-06-15T14:42:28.1198064+08:00;True|2021-06-15T13:30:12.7997686+08:00;True|2021-06-15T13:25:37.7284670+08:00;True|2021-06-15T13:23:43.6207813+08:00;False|2021-06-15T13:23:19.4190232+08:00;True|2021-06-15T13:16:38.5062674+08:00;True|2021-06-15T13:03:31.2055635+08:00;True|2021-06-15T12:58:43.1653215+08:00;True|2021-06-15T12:39:22.8442109+08:00;True|2021-06-15T12:35:09.1288556+08:00;False|2021-06-15T12:33:50.0723143+08:00;True|2021-06-15T11:28:01.9733727+08:00;True|2021-06-15T11:26:26.6569392+08:00;True|2021-06-15T11:22:43.0366435+08:00;True|2021-06-15T11:07:50.1610580+08:00;True|2021-06-15T10:32:59.1925931+08:00;True|2021-06-10T17:16:57.9552310+08:00;True|2021-06-10T16:44:42.2731836+08:00;True|2021-06-10T14:39:27.6745737+08:00;True|2021-06-10T12:15:05.1524413+08:00;True|2021-06-09T18:19:24.1005606+08:00;True|2021-06-09T17:56:09.5646288+08:00;True|2021-06-09T13:34:06.1882292+08:00;True|2021-06-09T13:29:54.5924933+08:00;True|2021-06-09T13:25:55.7520662+08:00;True|2021-06-09T13:07:47.6686811+08:00;True|2021-06-09T12:59:41.2595048+08:00;True|2021-06-09T12:45:27.1305548+08:00;True|2021-06-09T12:29:52.1418191+08:00;True|2021-06-09T12:24:12.7610588+08:00;True|2021-06-09T11:31:25.3409568+08:00;True|2021-06-09T09:57:44.4387175+08:00;True|2021-06-09T09:54:26.5161307+08:00;True|2021-06-09T09:14:14.7288045+08:00;True|2021-06-09T09:10:25.1812139+08:00;True|2021-06-09T08:46:21.6585123+08:00;True|2021-06-08T19:56:55.7192062+08:00;True|2021-06-08T19:52:59.0326821+08:00;True|2021-06-08T19:49:13.6274217+08:00;True|2021-06-08T19:09:22.1038939+08:00;True|2021-06-08T15:28:41.3716247+08:00;True|2021-06-08T15:26:47.2621178+08:00;True|2021-06-08T13:49:45.8936617+08:00;True|2021-06-08T13:43:18.8115502+08:00;True|2021-06-08T10:04:06.2200731+08:00;True|2021-06-08T09:17:10.0470792+08:00;True|2021-06-08T08:44:37.4395849+08:00;True|2021-06-08T00:01:09.3745613+08:00;True|2021-06-07T23:49:31.5196888+08:00;True|2021-06-07T23:41:00.8017855+08:00;True|2021-06-07T23:21:53.1371134+08:00;True|2021-06-07T23:01:27.5712153+08:00;True|2021-06-07T22:36:12.9274014+08:00;True|2021-06-07T22:23:00.6545134+08:00;True|2021-06-07T17:44:47.5686346+08:00;True|2021-06-07T17:17:01.3431233+08:00;True|2021-06-07T16:53:28.9989587+08:00;True|2021-06-07T16:41:10.4975607+08:00;True|2021-06-07T14:21:06.8176477+08:00;True|2021-06-07T14:10:39.0355659+08:00;True|2021-06-07T12:34:31.4562732+08:00;True|2021-06-07T12:28:44.9629488+08:00;True|2021-06-07T10:30:26.9387988+08:00;True|2021-06-07T09:12:14.7658099+08:00;True|2021-06-07T08:37:19.6353792+08:00;True|2021-06-07T08:35:25.2031954+08:00;True|2021-06-05T07:07:32.0541266+08:00;True|2021-06-05T06:44:35.9475270+08:00;True|2021-06-05T06:37:27.4595197+08:00;True|2021-06-05T06:26:59.7663998+08:00;True|2021-06-05T05:43:12.8699318+08:00;True|2021-06-04T17:00:41.2426007+08:00;True|2021-06-04T16:08:03.8078072+08:00;True|2021-06-04T15:47:21.6412616+08:00;True|2021-06-04T15:21:02.4239800+08:00;True|2021-06-04T15:20:37.8641854+08:00;True|2021-06-04T13:38:51.5088395+08:00;True|2021-06-04T10:20:01.7784282+08:00;True|2021-06-04T10:13:50.3548857+08:00;True|2021-06-04T10:11:25.5017821+08:00;True|2021-06-04T10:09:51.6792228+08:00;True|2021-06-04T10:02:39.5851057+08:00;True|2021-06-04T09:30:40.4495494+08:00;True|2021-06-03T13:16:36.0317546+08:00;True|2021-06-03T13:12:47.0402047+08:00;True|2021-06-02T14:37:08.9683351+08:00;True|2021-06-02T14:10:15.7439829+08:00;True|2021-06-02T13:59:46.5841931+08:00;True|2021-06-02T13:25:18.7962660+08:00;True|2021-06-02T13:23:16.2261980+08:00;True|2021-06-01T15:37:32.2495085+08:00;True|2021-06-01T15:21:01.2856122+08:00;True|2021-06-01T15:13:36.7262365+08:00;True|2021-06-01T15:10:26.8905629+08:00;True|2021-06-01T14:56:17.5231551+08:00;True|2021-06-01T14:38:39.7895927+08:00;True|2021-06-01T14:23:12.3265287+08:00;True|2021-03-01T09:11:31.3226422+08:00;True|2021-05-26T14:54:56.9426462+08:00;True|2021-05-26T13:57:33.7780451+08:00;True|2021-05-26T13:39:02.8043358+08:00;True|2021-02-25T16:01:40.2917200+08:00;True|2021-02-25T15:49:46.6681205+08:00;True|2021-02-25T15:16:30.9372640+08:00;True|2021-05-25T13:10:21.7831921+08:00;True|2021-05-25T11:21:38.5224475+08:00;True|2021-05-25T11:12:52.0637175+08:00;True|2021-05-25T11:02:18.4164663+08:00;True|2021-05-25T10:52:06.8998521+08:00;True|2021-05-25T10:50:45.0929606+08:00;True|2021-05-25T10:45:54.1498313+08:00;True|2021-05-25T10:39:27.8602249+08:00;True|2021-05-25T10:34:49.5771162+08:00;True|2021-05-25T10:17:30.3009163+08:00;True|2021-05-25T10:14:03.8512581+08:00;True|2021-05-25T10:05:33.4343836+08:00;True|2021-05-24T17:01:23.3221168+08:00;True|2021-05-24T10:11:24.0197347+08:00;False|2021-05-24T10:11:07.6338995+08:00;</History> </PropertyGroup> <ItemGroup> <File Include="apiapp.json"> <publishTime>08/16/2021 17:23:16</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="bin/Antlr3.Runtime.dll"> <publishTime>02/22/2013 08:43:40</publishTime> @@ -18,31 +18,31 @@ <publishTime>02/22/2013 08:43:40</publishTime> </File> <File Include="bin/BLL.dll"> <publishTime>10/29/2021 19:33:03</publishTime> <publishTime>10/28/2021 16:27:35</publishTime> </File> <File Include="bin/BLL.pdb"> <publishTime>10/29/2021 19:33:03</publishTime> <publishTime>10/28/2021 16:27:35</publishTime> </File> <File Include="bin/DAL.dll"> <publishTime>10/29/2021 19:33:02</publishTime> <publishTime>10/28/2021 16:27:33</publishTime> </File> <File Include="bin/DAL.pdb"> <publishTime>10/29/2021 19:33:02</publishTime> <publishTime>10/28/2021 16:27:33</publishTime> </File> <File Include="bin/Dapper.dll"> <publishTime>07/22/2016 14:52:40</publishTime> </File> <File Include="bin/DBUtility.dll"> <publishTime>10/29/2021 19:32:58</publishTime> <publishTime>10/28/2021 16:27:30</publishTime> </File> <File Include="bin/DBUtility.pdb"> <publishTime>10/29/2021 19:32:58</publishTime> <publishTime>10/28/2021 16:27:30</publishTime> </File> <File Include="bin/Interop.gregn6Lib.dll"> <publishTime>08/25/2021 10:28:25</publishTime> </File> <File Include="bin/Kingdee.BOS.WebApi.Client.dll"> <publishTime>08/16/2021 17:23:13</publishTime> <publishTime>10/14/2021 09:42:44</publishTime> </File> <File Include="bin/Kingdee.BOS.WebApi.FormService.dll"> <publishTime>09/20/2018 19:23:20</publishTime> @@ -60,34 +60,34 @@ <publishTime>07/25/2012 11:48:56</publishTime> </File> <File Include="bin/Model.dll"> <publishTime>10/29/2021 19:32:59</publishTime> <publishTime>10/28/2021 16:27:30</publishTime> </File> <File Include="bin/Model.pdb"> <publishTime>10/29/2021 19:32:59</publishTime> <publishTime>10/28/2021 16:27:30</publishTime> </File> <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="bin/Newtonsoft.Json.dll"> <publishTime>08/03/2014 20:33:56</publishTime> </File> <File Include="bin/Pub_Class.dll"> <publishTime>10/29/2021 19:32:57</publishTime> <publishTime>10/28/2021 16:27:27</publishTime> </File> <File Include="bin/Pub_Class.pdb"> <publishTime>10/29/2021 19:32:57</publishTime> <publishTime>10/28/2021 16:27:27</publishTime> </File> <File Include="bin/Pub_Control.dll"> <publishTime>10/29/2021 19:32:58</publishTime> <publishTime>10/28/2021 16:27:28</publishTime> </File> <File Include="bin/Pub_Control.pdb"> <publishTime>10/29/2021 19:32:58</publishTime> <publishTime>10/28/2021 16:27:28</publishTime> </File> <File Include="bin/SQLHelper.dll"> <publishTime>10/29/2021 19:32:58</publishTime> <publishTime>10/28/2021 16:27:29</publishTime> </File> <File Include="bin/SQLHelper.pdb"> <publishTime>10/29/2021 19:32:58</publishTime> <publishTime>10/28/2021 16:27:29</publishTime> </File> <File Include="bin/stdole.dll"> <publishTime>05/09/2021 13:35:37</publishTime> @@ -156,7 +156,7 @@ <publishTime>11/28/2018 13:01:00</publishTime> </File> <File Include="bin/System.Web.Http.WebHost.dll"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="bin/System.Web.Mvc.dll"> <publishTime>01/28/2015 04:02:18</publishTime> @@ -189,10 +189,10 @@ <publishTime>11/24/2014 11:18:48</publishTime> </File> <File Include="bin/WebAPI.dll"> <publishTime>10/29/2021 19:33:06</publishTime> <publishTime>10/28/2021 16:27:38</publishTime> </File> <File Include="bin/WebAPI.pdb"> <publishTime>10/29/2021 19:33:06</publishTime> <publishTime>10/28/2021 16:27:38</publishTime> </File> <File Include="bin/WebGrease.dll"> <publishTime>07/17/2013 17:03:52</publishTime> @@ -204,166 +204,166 @@ <publishTime>11/29/2018 13:26:30</publishTime> </File> <File Include="Content/bootstrap.css"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Content/bootstrap.min.css"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Content/Site.css"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="DLL/BLL.dll"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="DLL/DAL.dll"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/27/2021 13:49:58</publishTime> </File> <File Include="DLL/DBUtility.dll"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="DLL/Kingdee.BOS.WebApi.Client.dll"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="DLL/Model.dll"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="DLL/Newtonsoft.Json.Net35.dll"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="DLL/Pub_Class.dll"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="DLL/Pub_Control.dll"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="DLL/SQLHelper.dll"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.eot"> <publishTime>08/16/2021 17:23:16</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.svg"> <publishTime>08/16/2021 17:23:16</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.ttf"> <publishTime>08/16/2021 17:23:16</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="fonts/glyphicons-halflings-regular.woff"> <publishTime>08/16/2021 17:23:16</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Global.asax"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Index.html"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="packages.config"> <publishTime>08/16/2021 17:23:16</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Views/Scripts/bootstrap.js"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Views/Scripts/bootstrap.min.js"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.js"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.min.js"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Views/Scripts/jquery-1.10.2.min.map"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Views/Scripts/jquery.validate.js"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Views/Scripts/jquery.validate.min.js"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Views/Scripts/jquery.validate.unobtrusive.js"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Views/Scripts/modernizr-2.6.2.js"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Views/Shared/Error.cshtml"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Views/Shared/_Layout.cshtml"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Views/web.config"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Views/_ViewStart.cshtml"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Department_Model.datasource"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/ClsGy_Customer_Model.datasource"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/ClsGy_Department_Model.datasource"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/ClsGy_Employee_Model.datasource"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/ClsGy_Group_Model.datasource"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/ClsGy_Source_Model.datasource"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource"> <publishTime>08/16/2021 17:23:15</publishTime> <publishTime>10/14/2021 09:42:47</publishTime> </File> <File Include="Web References/WebS/Reference.map"> <publishTime>08/06/2021 22:57:28</publishTime> </File> <File Include="Web.config"> <publishTime>10/29/2021 19:33:14</publishTime> <publishTime>10/28/2021 16:27:52</publishTime> </File> </ItemGroup> </Project> WebAPI/WebAPI.csproj
@@ -278,7 +278,11 @@ <Compile Include="App_Start\RouteConfig.cs" /> <Compile Include="App_Start\SwaggerConfig.cs" /> <Compile Include="App_Start\WebApiConfig.cs" /> <Compile Include="Controllers\BaseSet\Xt_DataDictionary_ViewController.cs" /> <Compile Include="Controllers\BaseSet\Gy_ClassTimePrjController.cs" /> <Compile Include="Controllers\BaseSet\Gy_OrderBackInfoController.cs" /> <Compile Include="Controllers\BaseSet\Gy_OrderLevController.cs" /> <Compile Include="Controllers\BaseSet\Gy_WorkPayTypeController.cs" /> <Compile Include="Controllers\BaseSet\Gy_WorkTypeController.cs" /> <Compile Include="Controllers\BaseSet\Xt_DataDictionary_TableController.cs" /> <Compile Include="Controllers\BaseSet\Gy_ModelTypeController.cs" /> <Compile Include="Controllers\BaseSet\Gy_QCCheckClassController.cs" /> @@ -429,6 +433,8 @@ <Compile Include="Models\ApiConfig.cs" /> <Compile Include="Models\ApiResult.cs" /> <Compile Include="Models\CheckItem.cs" /> <Compile Include="Models\Gy_OrderBackInfo.cs" /> <Compile Include="Models\Gy_OrderLevList.cs" /> <Compile Include="Models\ClsGy_EquipFileMain.cs" /> <Compile Include="Models\ClsGy_EquipFileType.cs" /> <Compile Include="Models\ClsGy_Material_Model.cs" /> @@ -446,10 +452,13 @@ <Compile Include="Models\ClsSc_MouldRepairOutBillMain.cs" /> <Compile Include="Models\ClsSc_MouldRepairOutBillSub.cs" /> <Compile Include="Models\ClsGy_ProcPrice.cs" /> <Compile Include="Models\Xt_DataDictionary_Proc.cs" /> <Compile Include="Models\Xt_DataDictionary_View.cs" /> <Compile Include="Models\Xt_DataDictionary_Table.cs" /> <Compile Include="Models\Gy_User.cs" /> <Compile Include="Models\Gy_UserSupper.cs" /> <Compile Include="Models\Gy_WorkPayType.cs" /> <Compile Include="Models\Gy_WorkType.cs" /> <Compile Include="Models\Menu.cs" /> <Compile Include="Models\ModelConvertHelper.cs" /> <Compile Include="Models\Pay_OtherBalBill.cs" /> @@ -528,8 +537,10 @@ <Compile Include="Models\WWSendOutBillViewModel.cs" /> <Compile Include="Models\WW_EntrustProcSendWorkViewModel.cs" /> <Compile Include="Models\WW_EntrustWorkOrderViewModel.cs" /> <Compile Include="Models\åºç¡èµæ\Gy_ClassTimePrj.cs" /> <Compile Include="Models\åºç¡èµæ\Gy_Employee.cs" /> <Compile Include="Models\åºç¡èµæ\Gy_Process.cs" /> <Compile Include="Models\åºç¡èµæ\Gy_ClassTimePrj.cs" /> <Compile Include="Models\åºç¡èµæ\Warehouse.cs" /> <Compile Include="Properties\Resources.Designer.cs"> <AutoGen>True</AutoGen>