2个文件已删除
33个文件已修改
9 文件已重命名
9个文件已添加
| | |
| | | /WorkM/obj/Debug |
| | | /WorkM/obj/Release |
| | | /WorkM/obj/x86/Debug |
| | | /WorkM/obj/x86/Release |
| | | /DBUtility/bin/x86/Debug |
| | | /DBUtility/obj/x86/Debug |
| | | /WorkM/obj/x86/Release |
| | |
| | | <ErrorReport>prompt</ErrorReport> |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <Reference Include="AxInterop.gregn6Lib"> |
| | | <HintPath>..\OCX\AxInterop.gregn6Lib.dll</HintPath> |
| | | </Reference> |
| | | <Reference Include="Interop.gregn6Lib"> |
| | | <HintPath>..\OCX\Interop.gregn6Lib.dll</HintPath> |
| | | <EmbedInteropTypes>True</EmbedInteropTypes> |
| | | </Reference> |
| | | <Reference Include="System" /> |
| | | <Reference Include="System.Data" /> |
| | | <Reference Include="System.Drawing" /> |
| | |
| | | </EmbeddedResource> |
| | | </ItemGroup> |
| | | <ItemGroup> |
| | | <COMReference Include="Axgregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>aximp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="gregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>tlbimp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="stdole"> |
| | | <Guid>{00020430-0000-0000-C000-000000000046}</Guid> |
| | | <VersionMajor>2</VersionMajor> |
| | |
| | | <ErrorReport>prompt</ErrorReport> |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <Reference Include="Interop.gregn6Lib"> |
| | | <HintPath>..\OCX\Interop.gregn6Lib.dll</HintPath> |
| | | <EmbedInteropTypes>True</EmbedInteropTypes> |
| | | </Reference> |
| | | <Reference Include="Kingdee.BOS.WebApi.Client"> |
| | | <HintPath>..\OCX\Kingdee.BOS.WebApi.Client.dll</HintPath> |
| | | </Reference> |
| | |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>aximp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="gregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>tlbimp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="stdole"> |
| | |
| | | <ErrorReport>prompt</ErrorReport> |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <Reference Include="AxInterop.gregn6Lib"> |
| | | <HintPath>..\OCX\AxInterop.gregn6Lib.dll</HintPath> |
| | | </Reference> |
| | | <Reference Include="Interop.gregn6Lib"> |
| | | <HintPath>..\OCX\Interop.gregn6Lib.dll</HintPath> |
| | | <EmbedInteropTypes>True</EmbedInteropTypes> |
| | | </Reference> |
| | | <Reference Include="NPOI, Version=2.1.3.1, Culture=neutral, PublicKeyToken=0df73ec7942b34e1, processorArchitecture=MSIL"> |
| | | <SpecificVersion>False</SpecificVersion> |
| | | <HintPath>..\OCX\NPOI.dll</HintPath> |
| | |
| | | </Compile> |
| | | </ItemGroup> |
| | | <ItemGroup> |
| | | <COMReference Include="Axgregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>aximp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="gregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>tlbimp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="stdole"> |
| | | <Guid>{00020430-0000-0000-C000-000000000046}</Guid> |
| | | <VersionMajor>2</VersionMajor> |
| | |
| | | DeleteBillSub2(lngBillKey); |
| | | omodel.HInterID = lngBillKey; |
| | | //æå
¥ä¿å
»é¡¹å表 |
| | | foreach (Model.ClsSc_MouldMaintainRuleBillSub_Item oSub in DetailCol) |
| | | foreach (Model.ClsSc_MouldMaintainRuleBillSub_Item Item in DetailCol) |
| | | { |
| | | oCn.RunProc("Insert into Sc_MouldMaintainBillSub " + |
| | | " (HInterID,HEntryID,HMaintainItemID" + |
| | | ",HMaintainPart,HClaim" + |
| | | ",HManagerID" + |
| | | ",HCloseMan,HCloseType,HRemark" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + "," + oSub.HMaintainItemID.ToString() + |
| | | ",'" + oSub.HMaintainPart.ToString() + "','" + oSub.HClaim.ToString() + "'" + |
| | | "," + oSub.HManagerID.ToString() + |
| | | ",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | ") "); |
| | | oCn.RunProc("Insert into Sc_MouldMaintainBillSub_Item" + |
| | | " (HInterID,HEntryID,HMaintainItemID,HMaintainItem" + |
| | | ",HMaintainPart,HClaim" + |
| | | ",HManagerID" + |
| | | ",HCloseMan,HCloseType,HRemark" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + Item.HEntryID.ToString() + "," + Item.HMaintainItemID.ToString() + ",'" + Item.HMaintainItem.ToString() + "'" + |
| | | ",'" + Item.HMaintainPart.ToString() + "','" + Item.HClaim.ToString() + "'" + |
| | | "," + Item.HManagerID.ToString() + |
| | | ",'" + Item.HCloseMan + "'," + Convert.ToString(Item.HCloseType ? 1 : 0) + ",'" + Item.HRemark + "'" + |
| | | "," + Item.HSourceInterID.ToString() + "," + Item.HSourceEntryID.ToString() + ",'" + Item.HSourceBillNo + "','" + Item.HSourceBillType + "'," + Item.HRelationQty.ToString() + "," + Item.HRelationMoney.ToString() + |
| | | ") "); |
| | | } |
| | | //æå
¥é
件项å表 |
| | | foreach (Model.ClsSc_MouldMaintainBillSub oSub in DetailColl) |
| | | { |
| | | |
| | | oCn.RunProc("Insert into Sc_MouldMaintainBillSub " + |
| | | " (HInterID,HEntryID,HMaterID" + |
| | | ",HQty,HUnitID" + |
| | |
| | | if (DetailCol.Count > 0) |
| | | { |
| | | //æå
¥ä¿å
»é¡¹å表 |
| | | foreach (Model.ClsSc_MouldMaintainRuleBillSub_Item oSub in DetailCol) |
| | | foreach (Model.ClsSc_MouldMaintainRuleBillSub_Item Item in DetailCol) |
| | | { |
| | | oCn.RunProc("Insert into Sc_MouldMaintainBillSub_Item" + |
| | | " (HInterID,HEntryID,HMaintainItemID,HMaintainItem" + |
| | |
| | | ",HCloseMan,HCloseType,HRemark" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + "," + oSub.HMaintainItemID.ToString() + ",'" + oSub.HMaintainItem.ToString() + "'" + |
| | | ",'" + oSub.HMaintainPart.ToString() + "','" + oSub.HClaim.ToString() + "'" + |
| | | "," + oSub.HManagerID.ToString() + |
| | | ",'" + oSub.HCloseMan + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" + |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | + omodel.HInterID.ToString() + "," + Item.HEntryID.ToString() + "," + Item.HMaintainItemID.ToString() + ",'" + Item.HMaintainItem.ToString() + "'" + |
| | | ",'" + Item.HMaintainPart.ToString() + "','" + Item.HClaim.ToString() + "'" + |
| | | "," + Item.HManagerID.ToString() + |
| | | ",'" + Item.HCloseMan + "'," + Convert.ToString(Item.HCloseType ? 1 : 0) + ",'" + Item.HRemark + "'" + |
| | | "," + Item.HSourceInterID.ToString() + "," + Item.HSourceEntryID.ToString() + ",'" + Item.HSourceBillNo + "','" + Item.HSourceBillType + "'," + Item.HRelationQty.ToString() + "," + Item.HRelationMoney.ToString() + |
| | | ") "); |
| | | } |
| | | } |
| | |
| | | //æå
¥å表 |
| | | foreach (Model.ClsSc_ProcessExchangeBillSub oSub in DetailColl) |
| | | { |
| | | |
| | | string HInterID = omodel.HInterID.ToString(); |
| | | string HEntryID = oSub.HEntryID.ToString(); |
| | | string HBillNo = omodel.HBillNo; |
| | | string HCloseMan = oSub.HCloseMan; |
| | | string HEntryCloseDate = oSub.HEntryCloseDate.ToString(); |
| | | string HCloseType = Convert.ToString(oSub.HCloseType ? 1 : 0); |
| | | string HRemark = oSub.HRemark; |
| | | string HSourceInterID = oSub.HSourceInterID.ToString(); |
| | | string HSourceEntryID = oSub.HSourceEntryID.ToString(); |
| | | string HSourceBillNo = oSub.HSourceBillNo; |
| | | string HSourceBillType = oSub.HSourceBillType; |
| | | string HRelationQty = oSub.HRelationQty.ToString(); |
| | | string HRelationMoney = oSub.HRelationMoney.ToString(); |
| | | string HProcNo = oSub.HProcNo.ToString(); |
| | | string HProcID = oSub.HProcID.ToString(); |
| | | string HProcNumber = oSub.HProcNumber; |
| | | string HWorkRemark = oSub.HWorkRemark; |
| | | string HCenterID = oSub.HCenterID.ToString(); |
| | | string HDeptID = oSub.HDeptID.ToString(); |
| | | string HDeptNumber = oSub.HDeptNumber; |
| | | string HGroupID = oSub.HGroupID.ToString(); |
| | | string HGroupNumber = oSub.HGroupNumber; |
| | | string HWorkerID = oSub.HWorkerID.ToString(); |
| | | string HWorkerNumber = oSub.HWorkerNumber; |
| | | string HSourceID = oSub.HSourceID.ToString(); |
| | | string HQty = oSub.HQty.ToString(); |
| | | string HTimeUnit = oSub.HTimeUnit; |
| | | string HPlanWorkTimes = oSub.HPlanWorkTimes.ToString(); |
| | | string HPlanBeginDate = oSub.HPlanBeginDate.ToShortDateString(); |
| | | string HPlanEndDate = oSub.HPlanEndDate.ToShortDateString(); |
| | | string HRelBeginDate = oSub.HRelBeginDate.ToShortDateString(); |
| | | string HRelEndDate = oSub.HRelEndDate.ToShortDateString(); |
| | | string HReadyTime = oSub.HReadyTime.ToString(); |
| | | string HQueueTime = oSub.HQueueTime.ToString(); |
| | | string HMoveTime = oSub.HMoveTime.ToString(); |
| | | string HBeginDayQty = oSub.HBeginDayQty.ToString(); |
| | | string HBeginFixQty = oSub.HBeginFixQty.ToString(); |
| | | string HFixWorkDays = oSub.HFixWorkDays.ToString(); |
| | | string HTrunWorkDays = oSub.HTrunWorkDays.ToString(); |
| | | string HReadyTimes = oSub.HReadyTimes.ToString(); |
| | | string HMyWorkDays = oSub.HMyWorkDays.ToString(); |
| | | string HOutPrice = oSub.HOutPrice.ToString(); |
| | | string HOutMoney = oSub.HOutMoney.ToString(); |
| | | string HPassRate = oSub.HPassRate.ToString(); |
| | | string HLastProc = oSub.HLastProc; |
| | | string HKeyProc = oSub.HKeyProc; |
| | | string HFstProc = oSub.HFstProc; |
| | | string HICMOInterID = oSub.HICMOInterID.ToString(); |
| | | string HICMOBillNo = oSub.HICMOBillNo; |
| | | string HWWOrderInterID = oSub.HWWOrderInterID.ToString(); |
| | | string HWWOrderEntryID = oSub.HWWOrderEntryID.ToString(); |
| | | string HWWOrderBillNo = oSub.HWWOrderBillNo; |
| | | string HReportQty = oSub.HReportQty.ToString(); |
| | | string HBackProc = Convert.ToString(oSub.HBackProc ? 1 : 0); |
| | | string HSupID = oSub.HSupID.ToString(); |
| | | string HSupFlag = Convert.ToString(oSub.HSupFlag ? 1 : 0); |
| | | string HOverRate = oSub.HOverRate.ToString(); |
| | | string HMaxQty = oSub.HMaxQty.ToString(); |
| | | string HTechnologyParameter = oSub.HTechnologyParameter; |
| | | string HProcCheckNote = oSub.HProcCheckNote; |
| | | string HPicNum = oSub.HPicNum; |
| | | string HMouldNo = oSub.HMouldNo.ToString(); |
| | | string HProcWorkNum = oSub.HProcWorkNum.ToString(); |
| | | |
| | | oCn.RunProc("Insert into Sc_ProcessExchangeBillSub " + |
| | | " (HInterID,HEntryID,HBillNo_bak," + |
| | | "HCloseMan,HEntryCloseDate,HCloseType,HRemark," + |
| | |
| | | <OutputPath>bin\x86\Release\</OutputPath> |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <Reference Include="AxInterop.gregn6Lib"> |
| | | <HintPath>..\OCX\AxInterop.gregn6Lib.dll</HintPath> |
| | | </Reference> |
| | | <Reference Include="Interop.gregn6Lib"> |
| | | <HintPath>..\OCX\Interop.gregn6Lib.dll</HintPath> |
| | | <EmbedInteropTypes>True</EmbedInteropTypes> |
| | | </Reference> |
| | | <Reference Include="System" /> |
| | | <Reference Include="System.Data" /> |
| | | <Reference Include="System.Drawing" /> |
| | |
| | | </ProjectReference> |
| | | </ItemGroup> |
| | | <ItemGroup> |
| | | <COMReference Include="Axgregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>aximp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="gregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>tlbimp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="stdole"> |
| | | <Guid>{00020430-0000-0000-C000-000000000046}</Guid> |
| | | <VersionMajor>2</VersionMajor> |
| | |
| | | <OutputPath>bin\x86\Release\</OutputPath> |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <Reference Include="AxInterop.gregn6Lib"> |
| | | <HintPath>..\OCX\AxInterop.gregn6Lib.dll</HintPath> |
| | | </Reference> |
| | | <Reference Include="Interop.gregn6Lib"> |
| | | <HintPath>..\OCX\Interop.gregn6Lib.dll</HintPath> |
| | | <EmbedInteropTypes>True</EmbedInteropTypes> |
| | | </Reference> |
| | | <Reference Include="System" /> |
| | | <Reference Include="System.Data" /> |
| | | <Reference Include="System.Drawing" /> |
| | |
| | | </EmbeddedResource> |
| | | </ItemGroup> |
| | | <ItemGroup> |
| | | <COMReference Include="Axgregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>aximp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="gregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>tlbimp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="stdole"> |
| | | <Guid>{00020430-0000-0000-C000-000000000046}</Guid> |
| | | <VersionMajor>2</VersionMajor> |
| | |
| | | { |
| | | //============ |
| | | |
| | | public Int64 HMaintainItemID;// int --ä¿å
»é¡¹ç®ID |
| | | public Int64 HMaintainItemID;// int --ä¿å
»é¡¹ç®ID |
| | | public string HMaintainItem;// varchar(100) --ä¿å
»é¡¹ç® |
| | | public string HMaintainPart;// varchar(100) --ä¿å
»é¨ä½ |
| | | public string HClaim;// varchar(100) --å
·ä½è¦æ± |
| | |
| | | public Single HSumPassRate;//累计è¯ç |
| | | public double HOverRate;// dec(18,4) --è¶
颿¯ä¾ |
| | | public double HMaxQty;// dec(18,4) --æé«ä¸é |
| | | public string HProcCheckNote; |
| | | public string HPicNum; |
| | | public string HTechnologyParameter; |
| | | public string HProcCheckNote;//æ¬å·¥åºç¡®è®¤è®°å½ |
| | | public string HPicNum;//å¾çº¸ç¼å· |
| | | public string HTechnologyParameter;//å·¥èºåæ° |
| | | public string HMouldNo;//模å
·ç¼å· |
| | | public string HProcWorkNum;//ç¨åºå· |
| | | } |
| | |
| | | <CodeAnalysisRuleSet>MinimumRecommendedRules.ruleset</CodeAnalysisRuleSet> |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <Reference Include="AxInterop.gregn6Lib"> |
| | | <HintPath>..\OCX\AxInterop.gregn6Lib.dll</HintPath> |
| | | </Reference> |
| | | <Reference Include="Interop.gregn6Lib"> |
| | | <HintPath>..\OCX\Interop.gregn6Lib.dll</HintPath> |
| | | <EmbedInteropTypes>True</EmbedInteropTypes> |
| | | </Reference> |
| | | <Reference Include="System" /> |
| | | <Reference Include="System.Data" /> |
| | | <Reference Include="System.Drawing" /> |
| | |
| | | </ProjectReference> |
| | | </ItemGroup> |
| | | <ItemGroup> |
| | | <COMReference Include="Axgregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>aximp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="gregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>tlbimp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="stdole"> |
| | | <Guid>{00020430-0000-0000-C000-000000000046}</Guid> |
| | | <VersionMajor>2</VersionMajor> |
| | |
| | | <ErrorReport>prompt</ErrorReport> |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <Reference Include="AxInterop.gregn6Lib"> |
| | | <HintPath>..\OCX\AxInterop.gregn6Lib.dll</HintPath> |
| | | </Reference> |
| | | <Reference Include="Interop.gregn6Lib"> |
| | | <HintPath>..\OCX\Interop.gregn6Lib.dll</HintPath> |
| | | <EmbedInteropTypes>True</EmbedInteropTypes> |
| | | </Reference> |
| | | <Reference Include="NPOI, Version=2.1.3.1, Culture=neutral, PublicKeyToken=0df73ec7942b34e1, processorArchitecture=MSIL"> |
| | | <SpecificVersion>False</SpecificVersion> |
| | | <HintPath>..\OCX\NPOI.dll</HintPath> |
| | |
| | | </Compile> |
| | | </ItemGroup> |
| | | <ItemGroup> |
| | | <COMReference Include="Axgregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>aximp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="gregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>tlbimp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="stdole"> |
| | | <Guid>{00020430-0000-0000-C000-000000000046}</Guid> |
| | | <VersionMajor>2</VersionMajor> |
| | |
| | | <ErrorReport>prompt</ErrorReport> |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <Reference Include="AxInterop.grdes6Lib"> |
| | | <HintPath>..\OCX\AxInterop.grdes6Lib.dll</HintPath> |
| | | </Reference> |
| | | <Reference Include="AxInterop.gregn6Lib"> |
| | | <HintPath>..\OCX\AxInterop.gregn6Lib.dll</HintPath> |
| | | </Reference> |
| | | <Reference Include="Interop.grdes6Lib"> |
| | | <HintPath>..\OCX\Interop.grdes6Lib.dll</HintPath> |
| | | <EmbedInteropTypes>True</EmbedInteropTypes> |
| | | </Reference> |
| | | <Reference Include="Interop.gregn6Lib"> |
| | | <HintPath>..\OCX\Interop.gregn6Lib.dll</HintPath> |
| | | <EmbedInteropTypes>True</EmbedInteropTypes> |
| | | </Reference> |
| | | <Reference Include="System" /> |
| | | <Reference Include="System.Data" /> |
| | | <Reference Include="System.Drawing" /> |
| | |
| | | </EmbeddedResource> |
| | | </ItemGroup> |
| | | <ItemGroup> |
| | | <COMReference Include="Axgrdes6Lib"> |
| | | <Guid>{C5A16330-A084-48C9-BC0F-0D0B37A14123}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>aximp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="Axgregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>aximp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="grdes6Lib"> |
| | | <Guid>{C5A16330-A084-48C9-BC0F-0D0B37A14123}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>tlbimp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="gregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>tlbimp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="stdole"> |
| | | <Guid>{00020430-0000-0000-C000-000000000046}</Guid> |
| | | <VersionMajor>2</VersionMajor> |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Data; |
| | | using System.Linq; |
| | | using System.Text; |
| | | |
| | | namespace Pub_Class |
| | | { |
| | | |
| | | public class WebClsPub |
| | | { |
| | | public static string ComputerName; |
| | | public static string IPAddress; |
| | | |
| | | //夿æ¯é½å卿é,å¹¶åå
¥æ¥å¿ |
| | | public static bool Security_Log(string gnsy, int LogTF, bool Msg, string CurUserName,ref string StrMessage) |
| | | { |
| | | //gnsy åè½ç´¢å¼,模å |
| | | //usercode å½åç¨æ·ä»£ç |
| | | //LogTF 1夿æé并忥å¿ï¼2åªåæ¥å¿ï¼3åªå¤ææé |
| | | //Msg 没ææéæ¶ æ¯å¦æç¤ºæ¡ |
| | | string UserID = CurUserName; |
| | | try |
| | | { |
| | | ClsSqlHelper oCn = new ClsSqlHelper(); |
| | | DataSet Ds = new DataSet(); |
| | | DataSet DsUser = new DataSet(); |
| | | DataSet DsJS = new DataSet();//è§è² |
| | | long ModID = 0; |
| | | bool HavRight = false; |
| | | //æ¾å°æ¨¡åæé |
| | | Ds = oCn.RunProcReturn("select * from xt_xtgnb where gnsy='" + gnsy.Trim() + "'", "xt_xtgnb"); |
| | | if (Ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | if (Msg == true) |
| | | { |
| | | StrMessage="æ²¡ææ¾å°è¯¥åè½æ¨¡åï¼"; |
| | | } |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | ModID = ClsPub.isLong(Ds.Tables[0].Rows[0]["ID"].ToString()); //è¿å模å |
| | | } |
| | | if (LogTF == 1 || LogTF == 3)//éè¦å¤ææé |
| | | { |
| | | //æ ¹æ®ç¨æ·åç§°å¤ææé |
| | | DsUser = oCn.RunProcReturn("select * from gy_czygl where czymc='" + UserID.Trim() + "'", "gy_czygl"); |
| | | if (DsUser.Tables[0].Rows.Count == 0) |
| | | { |
| | | if (Msg == true) |
| | | { |
| | | StrMessage = "æ²¡ææ¾å°å½åæä½åï¼"; |
| | | } |
| | | return false; |
| | | } |
| | | //æ ¹æ®ç¨æ·åç§°å¤ææé |
| | | if ((bool)DsUser.Tables[0].Rows[0]["ManagerFlag"]) //æ¯å¦ç®¡çå |
| | | { |
| | | HavRight = true; |
| | | } |
| | | else |
| | | { |
| | | if (DsUser.Tables[0].Rows[0]["AuthorityID"].ToString().Trim().Substring((int)ModID - 1, 1) == "1") |
| | | { |
| | | HavRight = true; |
| | | } |
| | | else |
| | | { |
| | | //è·åç¨æ·ç» 并循ç¯å¤ææé |
| | | //夿è§è²æ¯å¦ææé |
| | | DsJS = oCn.RunProcReturn("select isnull(AuthorityID,'') AuthorityID from System_UserGroupinfo a inner join System_UserGroup b on a.GroupID=b.GroupID " + |
| | | " Where a.USERID='" + UserID.Trim() + "'", "gy_czygl"); |
| | | if (DsJS == null) |
| | | { |
| | | HavRight = false; |
| | | } |
| | | else |
| | | { |
| | | HavRight = false; |
| | | for (int i = 0; i < DsJS.Tables[0].Rows.Count; i++) |
| | | { |
| | | if (ClsPub.isStrNull(DsJS.Tables[0].Rows[i]["AuthorityID"]).Length > ModID) |
| | | { |
| | | if (DsJS.Tables[0].Rows[i]["AuthorityID"].ToString().Trim().Substring((int)ModID - 1, 1) == "1") |
| | | { |
| | | HavRight = true; |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | |
| | | } |
| | | } |
| | | } |
| | | |
| | | if (HavRight == false) |
| | | { |
| | | if (Msg == true) |
| | | { |
| | | StrMessage = "æ¨æ²¡ææé,请ä¸ç®¡çåèç³»ï¼"; |
| | | } |
| | | } |
| | | } |
| | | //éè¦åå
¥æ¥å¿ |
| | | if ((LogTF == 1 && HavRight) || LogTF == 2) |
| | | { |
| | | Add_Log(Ds.Tables[0].Rows[0]["id"].ToString().Trim(), gnsy + "," + Ds.Tables[0].Rows[0]["gnmc"].ToString().Trim(), CurUserName, ref StrMessage); |
| | | } |
| | | return HavRight; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | if (Msg == true) |
| | | { |
| | | StrMessage = "夿æéæ¶åç°é误,请ä¸ç®¡çåèç³»ï¼"; |
| | | } |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | //åå
¥æ¥å¿ |
| | | /// <summary> |
| | | /// åå
¥æ¥å¿ |
| | | /// </summary> |
| | | /// <param name="UserID">æ ç¨</param> |
| | | /// <param name="WorkList">æä½æ¥å¿</param> |
| | | /// <param name="CurUserName">æä½å</param> |
| | | /// <returns></returns> |
| | | public static bool Add_Log(string UserID, string WorkList, string CurUserName,ref string StrMessage) |
| | | { |
| | | ClsSqlHelper oCn = new ClsSqlHelper(); |
| | | try |
| | | { |
| | | oCn.RunProc("Insert into System_Log(GeginDate,userid,WorkstationName,WorkList,SystemName,NetUserName,State) values " + |
| | | "(getdate(),'" + CurUserName + "','" + ComputerName + "','" + WorkList + "','ERPç³»ç»','" + IPAddress + "','è¿å
¥')" |
| | | ); |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | StrMessage = "åå
¥æ¥å¿æ¶åç°é,åå æ¯ï¼" + e.Message; |
| | | return false; |
| | | } |
| | | } |
| | | } |
| | | } |
| | |
| | | <Compile Include="CustomerCls\ClsPub.cs" /> |
| | | <Compile Include="CustomerCls\Cell.cs" /> |
| | | <Compile Include="Properties\AssemblyInfo.cs" /> |
| | | <Compile Include="CustomerCls\WebClsPub.cs" /> |
| | | </ItemGroup> |
| | | <ItemGroup> |
| | | <COMReference Include="stdole"> |
| | |
| | | <CodeAnalysisRuleSet>MinimumRecommendedRules.ruleset</CodeAnalysisRuleSet> |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <Reference Include="AxInterop.gregn6Lib"> |
| | | <HintPath>..\OCX\AxInterop.gregn6Lib.dll</HintPath> |
| | | </Reference> |
| | | <Reference Include="Interop.gregn6Lib"> |
| | | <HintPath>..\OCX\Interop.gregn6Lib.dll</HintPath> |
| | | <EmbedInteropTypes>True</EmbedInteropTypes> |
| | | </Reference> |
| | | <Reference Include="System" /> |
| | | <Reference Include="System.Data" /> |
| | | <Reference Include="System.Drawing" /> |
| | |
| | | </EmbeddedResource> |
| | | </ItemGroup> |
| | | <ItemGroup> |
| | | <COMReference Include="Axgregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>aximp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="gregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>tlbimp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="stdole"> |
| | | <Guid>{00020430-0000-0000-C000-000000000046}</Guid> |
| | | <VersionMajor>2</VersionMajor> |
| | |
| | | <ErrorReport>prompt</ErrorReport> |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <Reference Include="AxInterop.grdes6Lib"> |
| | | <HintPath>..\OCX\AxInterop.grdes6Lib.dll</HintPath> |
| | | </Reference> |
| | | <Reference Include="AxInterop.gregn6Lib"> |
| | | <HintPath>..\OCX\AxInterop.gregn6Lib.dll</HintPath> |
| | | </Reference> |
| | | <Reference Include="Interop.grdes6Lib"> |
| | | <HintPath>..\OCX\Interop.grdes6Lib.dll</HintPath> |
| | | <EmbedInteropTypes>True</EmbedInteropTypes> |
| | | </Reference> |
| | | <Reference Include="Interop.gregn6Lib"> |
| | | <HintPath>..\OCX\Interop.gregn6Lib.dll</HintPath> |
| | | <EmbedInteropTypes>True</EmbedInteropTypes> |
| | | </Reference> |
| | | <Reference Include="System" /> |
| | | <Reference Include="System.Data" /> |
| | | <Reference Include="System.Drawing" /> |
| | |
| | | </Compile> |
| | | </ItemGroup> |
| | | <ItemGroup> |
| | | <COMReference Include="Axgrdes6Lib"> |
| | | <Guid>{C5A16330-A084-48C9-BC0F-0D0B37A14123}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>aximp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="Axgregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>aximp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="grdes6Lib"> |
| | | <Guid>{C5A16330-A084-48C9-BC0F-0D0B37A14123}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>tlbimp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="gregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>tlbimp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="stdole"> |
| | | <Guid>{00020430-0000-0000-C000-000000000046}</Guid> |
| | | <VersionMajor>2</VersionMajor> |
| | |
| | | <ErrorReport>prompt</ErrorReport> |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <Reference Include="AxInterop.gregn6Lib"> |
| | | <HintPath>..\OCX\AxInterop.gregn6Lib.dll</HintPath> |
| | | </Reference> |
| | | <Reference Include="Interop.gregn6Lib"> |
| | | <HintPath>..\OCX\Interop.gregn6Lib.dll</HintPath> |
| | | <EmbedInteropTypes>True</EmbedInteropTypes> |
| | | </Reference> |
| | | <Reference Include="NPOI, Version=2.1.3.1, Culture=neutral, PublicKeyToken=0df73ec7942b34e1, processorArchitecture=MSIL"> |
| | | <SpecificVersion>False</SpecificVersion> |
| | | <HintPath>..\OCX\NPOI.dll</HintPath> |
| | |
| | | </Compile> |
| | | </ItemGroup> |
| | | <ItemGroup> |
| | | <COMReference Include="Axgregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>aximp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="gregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>tlbimp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="stdole"> |
| | | <Guid>{00020430-0000-0000-C000-000000000046}</Guid> |
| | | <VersionMajor>2</VersionMajor> |
| | |
| | | [HttpPost] |
| | | public object AddBill([FromBody] JObject sMainSub) |
| | | { |
| | | var _value = sMainSub["sMainSub"].ToString(); |
| | | var _value = sMainSub["oMain"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | oCN.BeginTran(); |
| | | //ä¿å主表 |
| | |
| | | { |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | | List<Gy_Mould> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Mould>>(msg2); |
| | | string BillType = "7507"; |
| | | long HInterID = mainList[0].HInterID;//éå
¥typeå¾å°çåæ®ID |
| | | string BillType = "3899"; |
| | | //å¾å°mainid |
| | | long HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | string HBillNo = mainList[0].HBillNo;//éå
¥typeå¾å°çåæ®å· |
| | | DateTime HDate = mainList[0].HDate;//æ¥æ |
| | | int HYear = 2021; |
| | | double HPeriod = 1; |
| | | int HYear = DBUtility.ClsPub.isInt(DateTime.Now.Year); |
| | | double HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month); |
| | | string HMouldNo = mainList[0].HMouldNo; |
| | | string HName = mainList[0].HName; |
| | | string HModel = mainList[0].HModel; |
| | |
| | | string HPICNo = mainList[0].HPICNo; |
| | | string HWorkMaterModel = mainList[0].HWorkMaterModel; |
| | | long HMaterID = mainList[0].HMaterID; |
| | | long HMouleTypeID = mainList[0].HMouldTypeID; |
| | | long HMouleTypeID = mainList[0].HMouleTypeID; |
| | | long HUnitID = mainList[0].HUnitID; |
| | | DateTime HOutComDate = mainList[0].HOutComDate; |
| | | string HOutComNo = mainList[0].HOutComNo; |
| | |
| | | string HSupNumber = mainList[0].HSupNumber; |
| | | long HPrintQty = mainList[0].HPrintQty; |
| | | |
| | | |
| | | //主表 |
| | | oCN.RunProc("Insert Into Gy_MouldFileMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + |
| | |
| | | " values('" + HInterID + "',0,''" + |
| | | ",0,0,'','',0,0 " + |
| | | ") "); |
| | | |
| | | if (objJsonResult.code == "0") |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | 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_Mould> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_Mould>>(msg2); |
| | | string BillType = "7507"; |
| | | |
| | | long HInterID = mainList[0].HInterID;//éå
¥typeå¾å°çåæ®ID |
| | | string HBillNo = mainList[0].HBillNo;//éå
¥typeå¾å°çåæ®å· |
| | | DateTime HDate = mainList[0].HDate;//æ¥æ |
| | | int HYear = 2021; |
| | | double HPeriod = 1; |
| | | int HYear = DBUtility.ClsPub.isInt(DateTime.Now.Year); |
| | | double HPeriod = DBUtility.ClsPub.isLong(DateTime.Now.Month); |
| | | string HMouldNo = mainList[0].HMouldNo; |
| | | string HName = mainList[0].HName; |
| | | string HModel = mainList[0].HModel; |
| | |
| | | string HPICNo = mainList[0].HPICNo; |
| | | string HWorkMaterModel = mainList[0].HWorkMaterModel; |
| | | long HMaterID = mainList[0].HMaterID; |
| | | long HMouleTypeID = mainList[0].HMouldTypeID; |
| | | long HMouleTypeID = mainList[0].HMouleTypeID; |
| | | long HUnitID = mainList[0].HUnitID; |
| | | DateTime HOutComDate = mainList[0].HOutComDate; |
| | | string HOutComNo = mainList[0].HOutComNo; |
| | |
| | | //è¥MAINDIéå¤åéæ°è·å |
| | | oCN.BeginTran(); |
| | | //主表 |
| | | oCN.RunProc("Update Gy_MouldFileMain set " + |
| | | " HMouldNo='" + HMouldNo + "'" + |
| | | ",HName='" + HName + "'" + |
| | | ",HModel='" + HModel + "'" + |
| | | ",HModel2= '" + HModel2 + "' Where HInterID=" + HInterID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.RunProc("UpDate Gy_MouldFileMain set " + |
| | | " HBillNo='" + HBillNo + "'" + //åºå®èµå¼=============== |
| | | ",HDate='" + HDate + "'" + |
| | | ",HYear='" + HYear.ToString() + "'" + |
| | | ",HPeriod='" + HPeriod.ToString() + "'" + |
| | | ",HRemark='" + HRemark + "'" + |
| | | ",HUpDater='" + HMaker + "'" + |
| | | ",HUpDateDate=getdate()" + |
| | | //======================================== |
| | | ",HMouldNo='" + HMouldNo + "'" + |
| | | ",HName='" + HName + "'" + |
| | | ",HModel='" + HModel + "'" + |
| | | ",HModel2='" + HModel2 + "'" + |
| | | ",HDiameter='" + HDiameter + "'" + |
| | | ",HSubjoin='" + HSubjoin + "'" + |
| | | ",HSubjoin2='" + HSubjoin2 + "'" + |
| | | ",HPICNo='" + HPICNo + "'" + |
| | | ",HWorkMaterModel='" + HWorkMaterModel + "'" + |
| | | ",HMaterID=" + HMaterID.ToString() + |
| | | ",HMaterNumber='" + HMaterNumber + "'" + |
| | | ",HMouldType=" + HMouleTypeID.ToString() + |
| | | ",HUnitID=" + HUnitID.ToString() + |
| | | ",HOutComDate='" + HOutComDate + "'" + |
| | | ",HOutComNo='" + HOutComNo + "'" + |
| | | ",HDeptID=" + HDeptID.ToString() + |
| | | ",HSupID=" + HSupID.ToString() + |
| | | ",HSupNumber='" + HSupNumber + "'" + |
| | | ",HPrintQty=" + HPrintQty.ToString() + |
| | | ",HMouldStatus='" + HMouldStatus + "'" + |
| | | ",HWhID=" + HWHID.ToString() + |
| | | ",HRoutingID=" + HRoutingID.ToString() + |
| | | ",HBomID=" + HBOMID.ToString() + |
| | | ",HVersion='" + HVersion + "'" + |
| | | ",HSPGroupID=" + HSPGroupID.ToString() + |
| | | ",HSPID=" + HSPID.ToString() + |
| | | ",HDesignLife=" + HDesignLife.ToString() + |
| | | ",HUseLife=" + HUseLife.ToString() + |
| | | ",HLeaveLife=" + HLeaveLife.ToString() + |
| | | ",HProdQty=" + HProdQty.ToString() + |
| | | ",HProdWeight=" + HProdWeight.ToString() + |
| | | " where HInterID=" + HInterID.ToString()); |
| | | |
| | | //ä¿®æ¹å项ç®ä»£ç |
| | | //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Department,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //å°ä¸çº§ ä¸ºéæ«çº§ |
| | | // oCN.RunProc("Update Gy_Department set HEndflag=0 where HItemID=" + HInterID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | // oCN.RunProc("Update Gy_Department set HEndflag=0 where HItemID=" + HInterID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | // |
| | | oCN.Commit(); |
| | | objJsonResult.code = "1"; |
| | |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// 磨å
·æ¡£æ¡ä¿®æ¹æé®æ¹æ³ |
| | | ///åæ°ï¼string sqlã |
| | |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("select * from Gy_MouldFileMain where HInterID=" + HInterID, "Gy_MouldFileMain"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_MouldFileList where hmainid=" + HInterID, "h_v_Gy_MouldFileList"); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | /// </summary> |
| | | [Route("Gy_Mould_Edit/Delete_Json")] |
| | | [HttpGet] |
| | | public object Delete_Json(long HItemID) |
| | | public object Delete_Json(long hmainid) |
| | | { |
| | | DAL.ClsGy_MouldFile oBill = new DAL.ClsGy_MouldFile(); |
| | | try |
| | | { |
| | | if (oBill.DeleteBill(HItemID, ref DBUtility.ClsPub.sExeReturnInfo)) |
| | | if (oBill.DeleteBill(hmainid, ref DBUtility.ClsPub.sExeReturnInfo)) |
| | | { |
| | | //åå
¥æ¥å¿ |
| | | ClsPub.Add_Log("", "å é¤é¡¹ç®ï¼ä»£ç ï¼" + oBill.omodel.HMouldNo + ",åç§°ï¼" + oBill.omodel.HName, ClsPub.CurUserName); |
| | |
| | | } |
| | | //ds = oCN.RunProcReturn("delete from Gy_Department where HItemID = " + HItemID, "Gy_Department"); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "å 餿å"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | return objJsonResult; |
| | | } |
| | | |
| | | // |
| | | } |
| | | } |
| | |
| | | "(HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HUseFlag) " + |
| | | " values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "','" + HItemID + "'" + |
| | | ",'1',0,'" + Convert.ToString(HStopflag ? 1 : 0) + "','" + HRemark + "','0')"); |
| | | ",'1',0,'" + Convert.ToString(HStopflag ? 1 : 0) + "','" + HRemark + "','æªä½¿ç¨')"); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | if (list[0].HItemID.ToString() != "") |
| | | { |
| | |
| | | } |
| | | #endregion |
| | | |
| | | #region åå®¡æ ¸ |
| | | [Route("Cj_StationInBill/set_AbandonCheck")] |
| | | [HttpGet] |
| | | public object set_AbandonCheck(int HInterID, string CurUserName) |
| | | { |
| | | try |
| | | { |
| | | if (HInterID == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®ID为0ï¼ä¸è½åå®¡æ ¸ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | DAL.ClsSc_StationInBill oBill = new DAL.ClsSc_StationInBill(); |
| | | //æ¥çæ¯å¦å·²å®¡æ ¸,å
³é,ä½åº |
| | | if (oBill.ShowBill(HInterID, ref DBUtility.ClsPub.sExeReturnInfo)) |
| | | { |
| | | if (oBill.omodel.HChecker.Trim() == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®æªå®¡æ ¸!ä¸éè¦åå®¡æ ¸!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®ä¸åå¨!åå :" + DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //åå®¡æ ¸ |
| | | if (Cj_StationInBillAbandonCheckBill(HInterID, CurUserName, ref DBUtility.ClsPub.sExeReturnInfo)) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "åå®¡æ ¸æå!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åå®¡æ ¸å¤±è´¥!åå :" + DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åå®¡æ ¸å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | //åå®¡æ ¸ |
| | | public bool Cj_StationInBillAbandonCheckBill(Int64 lngBillKey, string CurUserName, ref string sReturn) |
| | | { |
| | | if (Cj_StationInBillisUse(lngBillKey, ref sReturn)) |
| | | { |
| | | return false; |
| | | } |
| | | try |
| | | { |
| | | string HChecker = CurUserName; |
| | | string HCheckDate = DBUtility.ClsPub.GetServerDate(-1); |
| | | oCN.BeginTran(); |
| | | ds = oCN.RunProcReturn("Select * from Sc_StationInBillMain Where HInterID=" + lngBillKey.ToString(), "Sc_StationInBillMain"); |
| | | if (ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | sReturn = "åæ®æªæ¾å°ï¼"; |
| | | return false; |
| | | } |
| | | |
| | | oCN.RunProc(" Update Sc_StationInBillMain set HChecker='',HCheckDate=null Where HInterID=" + lngBillKey.ToString()); |
| | | oCN.RunProc("exec h_p_Mes_ProcessExchangeRelationQty_Check_In " + lngBillKey.ToString() + ",-1"); |
| | | //夿æ¯å¦æ¯ é¦éå·¥åº |
| | | DataSet ds1; |
| | | ds1 = oCN.RunProcReturn("select HLastProc,HFstProc " + |
| | | " from Sc_ProcessExchangeBillMain a " + |
| | | " inner join Sc_ProcessExchangeBillSub b on a.HInterID=b.HInterID " + |
| | | " Where a.HInterID=(Select HProcExchInterID from Sc_StationInBillMain Where HInterID=55) " + |
| | | " and b.HEntryID=(Select HProcExchEntryID from Sc_StationInBillMain Where HInterID=55)", "Sc_ProcessExchangeBillMain"); |
| | | if (ds1 == null || ds1.Tables[0].Rows.Count == 0) |
| | | { |
| | | } |
| | | else if (Pub_Class.ClsPub.isStrNull(ds1.Tables[0].Rows[0]["HFstProc"]) == "æ¯") |
| | | { |
| | | } |
| | | sReturn = sReturn + "åå®¡æ ¸åè½ï¼"; |
| | | oCN.Commit(); |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sReturn = e.Message; |
| | | oCN.RollBack(); |
| | | return false; ; |
| | | } |
| | | } |
| | | |
| | | //æ¯å¦è¢«å
³è |
| | | public bool Cj_StationInBillisUse(Int64 lngBillKey, ref string sReturn) |
| | | { |
| | | try |
| | | { |
| | | //æ¥è¯¢ä¸»è¡¨ |
| | | DataSet Ds; |
| | | //Ds = oCN.RunProcReturn("Select HinterID from " + MvarItemKeySub + " Where HInterID=" + lngBillKey.ToString() + " and isnull(HRelationQty,0)<>0 ", MvarItemKey); |
| | | //if (Ds.Tables[0].Rows.Count != 0) |
| | | //{ |
| | | // sReturn = "åæ®å·²è¢«å
³è,ä¸è½æä½ï¼"; |
| | | // return true; |
| | | //} |
| | | sReturn = ""; |
| | | return false; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sReturn = e.Message; |
| | | throw (e); |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | // |
| | | } |
| | |
| | | BillNew.omodel.HMaterIDD = ClsPub.isStrNull(mainList[0].HMaterIDD); |
| | | List<Model.ClsSc_ProcessExchangeBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsSc_ProcessExchangeBillSub>>(msg3); |
| | | BillNew.DetailColl = new List<Model.ClsSc_ProcessExchangeBillSub>(); |
| | | if (BillNew.omodel.HICMOInterID == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "è¯·éæ©ä»»å¡åï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | for (int i = 0; i < subList.ToArray().Length; i++) |
| | | { |
| | | if (DBUtility.ClsPub.isInt(subList[i].HProcID) != 0)//HQty |
| | |
| | | oSub.HTechnologyParameter = DBUtility.ClsPub.isStrNull(subList[i].HTechnologyParameter); |
| | | oSub.HPicNum = DBUtility.ClsPub.isStrNull(subList[i].HPicNum); |
| | | oSub.HProcCheckNote = DBUtility.ClsPub.isStrNull(subList[i].HProcCheckNote); |
| | | oSub.HMouldNo = ""; |
| | | oSub.HProcWorkNum = ""; |
| | | BillNew.DetailColl.Add(oSub); |
| | | } |
| | | } |
| | |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
| | | |
| | | private json objJsonResult = new json(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | /// <summary> |
| | | /// è¿åè¿ç«æ«æå表|å·¥åºè¿ç«æ¥æ¶åå表 |
| | | ///åæ°ï¼string sqlã |
| | |
| | | DataSet ds; |
| | | try |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select top 500 * from h_v_IF_ICMOBillList ", "h_v_IF_ICMOBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_ICMOBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_ICMOBillList"); |
| | | } |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_ICMOBillList where 1 = 1 " + sWhere + " order by hmainid desc", "h_v_IF_ICMOBillList"); |
| | | } |
| | | catch (Exception e) |
| | | { |
| | |
| | | |
| | | #endregion |
| | | |
| | | #region 鿩工èºè·¯çº¿åºç¡èµæ |
| | | |
| | | #region æ¡ä»¶æ¥è¯¢å·¥èºè·¯çº¿å表 |
| | | [Route("PublicPageMethod/RouteList")] |
| | | [HttpGet] |
| | | public object RouteList(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("select HItemID,'' HParentID,HNumber,HName from h_v_IF_MouldRouting " + sWhere + " Order by HItemID ", "h_v_IF_MouldRouting"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å·¥èºè·¯çº¿æ°æ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #endregion |
| | | |
| | | #region éæ©BOMç»åºç¡èµæ |
| | | |
| | | #region æ¡ä»¶æ¥è¯¢BOMç»å表 |
| | | [Route("PublicPageMethod/BomGroupList")] |
| | | [HttpGet] |
| | | public object BomGroupList(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("Select HItemID,HParentID,HNumber,HName from Gy_ICBomGroup " + sWhere + " Order by HItemID ", "Gy_ICBomGroup"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ BOMæ°æ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ ¹æ®æ åidæ¥æ¾BOMç»å表 |
| | | [Route("Gy_MaintenanceMode/BomGroupCX")] |
| | | [HttpGet] |
| | | public object BomGroupCX(long HInterID) |
| | | { |
| | | try |
| | | { |
| | | |
| | | ds = oCN.RunProcReturn(string.Format(@"WITH a AS (select * from Gy_ICBomGroup WHERE HitemID=" + HInterID + " UNION ALL select s.* from Gy_ICBomGroup AS s,a WHERE s.hparentid=a.HitemID) SELECT * FROM a"), "Gy_ICBomGroup"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "falseï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ åå表BOMç»åè¡¨æ°æ® |
| | | [Route("Gy_MaintenanceMode/BomGroupLoadTree")] |
| | | [HttpGet] |
| | | public object BomGroupLoadTree(string sWhere) |
| | | { |
| | | SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN(); |
| | | //ds = oCN.RunProcReturn("select * from h_v_IF_GroupList " + sWhere, "h_v_IF_GroupList"); |
| | | |
| | | ds = oCN.RunProcReturn("Select HItemID id,HNumber,(CAST(HNumber as varchar(100))+'-'+CAST(HName as varchar(100))) as title,HParentID ParentID,HLevel from Gy_ICBomGroup " + sWhere + "", "Gy_ICBomGroup"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ BOMæ°æ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #endregion |
| | | |
| | | #region éæ©ä»ä½ç»åºç¡èµæ |
| | | |
| | | #region æ¡ä»¶æ¥è¯¢ä»ä½ç»å表 |
| | | [Route("PublicPageMethod/HSPGroupList")] |
| | | [HttpGet] |
| | | public object HSPGroupList(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("Select HItemID,HParentID,HNumber,HName from Gy_StockPlaceGroup " + sWhere + " Order by HItemID ", "Gy_StockPlaceGroup"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ ä»ä½ç»æ°æ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ ¹æ®æ åidæ¥æ¾ä»ä½ç»å表 |
| | | [Route("Gy_MaintenanceMode/HSPGroupCX")] |
| | | [HttpGet] |
| | | public object HSPGroupCX(long HInterID) |
| | | { |
| | | try |
| | | { |
| | | |
| | | ds = oCN.RunProcReturn(string.Format(@"WITH a AS (select * from Gy_StockPlaceGroup WHERE HitemID=" + HInterID + " UNION ALL select s.* from Gy_StockPlaceGroup AS s,a WHERE s.hparentid=a.HitemID) SELECT * FROM a"), "Gy_StockPlaceGroup"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "falseï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ åå表ä»ä½ç»åè¡¨æ°æ® |
| | | [Route("Gy_MaintenanceMode/HSPGroupLoadTree")] |
| | | [HttpGet] |
| | | public object HSPGroupLoadTree(string sWhere) |
| | | { |
| | | SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN(); |
| | | //ds = oCN.RunProcReturn("select * from h_v_IF_GroupList " + sWhere, "h_v_IF_GroupList"); |
| | | |
| | | ds = oCN.RunProcReturn("Select HItemID id,HNumber,(CAST(HNumber as varchar(100))+'-'+CAST(HName as varchar(100))) as title,HParentID ParentID,HLevel from Gy_StockPlaceGroup " + sWhere + "", "Gy_StockPlaceGroup"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ ä»ä½ç»æ°æ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #endregion |
| | | |
| | | #region éæ©å°åºåºç¡èµæ |
| | | |
| | | #region æ¡ä»¶æ¥è¯¢å°åºå表 |
| | | [Route("PublicPageMethod/AreaList")] |
| | | [HttpGet] |
| | | public object AreaList(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("Select HItemID,HParentID,HNumber,HName from Gy_AreaSet " + sWhere + " Order by HItemID ", "Gy_AreaSet"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å°åºæ°æ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ ¹æ®æ åidæ¥æ¾å°åºå表 |
| | | [Route("Gy_MaintenanceMode/AreaCX")] |
| | | [HttpGet] |
| | | public object AreaCX(long HInterID) |
| | | { |
| | | try |
| | | { |
| | | |
| | | ds = oCN.RunProcReturn(string.Format(@"WITH a AS (select * from Gy_AreaSet WHERE HitemID=" + HInterID + " UNION ALL select s.* from Gy_AreaSet AS s,a WHERE s.hparentid=a.HitemID) SELECT * FROM a"), "Gy_AreaSet"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "falseï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ åå表å°åºåè¡¨æ°æ® |
| | | [Route("Gy_MaintenanceMode/AreaLoadTree")] |
| | | [HttpGet] |
| | | public object AreaLoadTree(string sWhere) |
| | | { |
| | | SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN(); |
| | | //ds = oCN.RunProcReturn("select * from h_v_IF_GroupList " + sWhere, "h_v_IF_GroupList"); |
| | | |
| | | ds = oCN.RunProcReturn("Select HItemID id,HNumber,(CAST(HNumber as varchar(100))+'-'+CAST(HName as varchar(100))) as title,HParentID ParentID,HLevel from Gy_AreaSet " + sWhere + "", "Gy_AreaSet"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ ä»ä½ç»æ°æ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #endregion |
| | | |
| | | #region éæ©è´§å¸åºç¡èµæ |
| | | |
| | | #region æ¡ä»¶æ¥è¯¢è´§å¸å表 |
| | | [Route("PublicPageMethod/CurrencyList")] |
| | | [HttpGet] |
| | | public object CurrencyList(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("Select HItemID,HParentID,HNumber,HName from Gy_Currency " + sWhere + " Order by HItemID ", "Gy_Currency"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ è´§å¸æ°æ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ ¹æ®æ åidæ¥æ¾è´§å¸å表 |
| | | [Route("Gy_MaintenanceMode/CurrencyCX")] |
| | | [HttpGet] |
| | | public object CurrencyCX(long HInterID) |
| | | { |
| | | try |
| | | { |
| | | |
| | | ds = oCN.RunProcReturn(string.Format(@"WITH a AS (select * from Gy_Currency WHERE HitemID=" + HInterID + " UNION ALL select s.* from Gy_Currency AS s,a WHERE s.hparentid=a.HitemID) SELECT * FROM a"), "Gy_Currency"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "falseï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ åå表货å¸åè¡¨æ°æ® |
| | | [Route("Gy_MaintenanceMode/CurrencyLoadTree")] |
| | | [HttpGet] |
| | | public object CurrencyLoadTree(string sWhere) |
| | | { |
| | | SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN(); |
| | | //ds = oCN.RunProcReturn("select * from h_v_IF_GroupList " + sWhere, "h_v_IF_GroupList"); |
| | | |
| | | ds = oCN.RunProcReturn("Select HItemID id,HNumber,(CAST(HNumber as varchar(100))+'-'+CAST(HName as varchar(100))) as title,HParentID ParentID,HLevel from Gy_Currency " + sWhere + "", "Gy_Currency"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ è´§å¸æ°æ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #endregion |
| | | |
| | | #region éæ©ç»ç®æ¹å¼åºç¡èµæ |
| | | |
| | | #region æ¡ä»¶æ¥è¯¢ç»ç®æ¹å¼å表 |
| | | [Route("PublicPageMethod/SettleStyleList")] |
| | | [HttpGet] |
| | | public object SettleStyleList(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("Select HItemID,HParentID,HNumber,HName from Gy_SettleStyle " + sWhere + " Order by HItemID ", "Gy_SettleStyle"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ ç»ç®æ¹å¼æ°æ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ ¹æ®æ åidæ¥æ¾ç»ç®æ¹å¼å表 |
| | | [Route("Gy_MaintenanceMode/SettleStyleCX")] |
| | | [HttpGet] |
| | | public object SettleStyleCX(long HInterID) |
| | | { |
| | | try |
| | | { |
| | | |
| | | ds = oCN.RunProcReturn(string.Format(@"WITH a AS (select * from Gy_SettleStyle WHERE HitemID=" + HInterID + " UNION ALL select s.* from Gy_SettleStyle AS s,a WHERE s.hparentid=a.HitemID) SELECT * FROM a"), "Gy_SettleStyle"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "falseï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ åå表ç»ç®æ¹å¼åè¡¨æ°æ® |
| | | [Route("Gy_MaintenanceMode/SettleStyleLoadTree")] |
| | | [HttpGet] |
| | | public object SettleStyleLoadTree(string sWhere) |
| | | { |
| | | SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN(); |
| | | //ds = oCN.RunProcReturn("select * from h_v_IF_GroupList " + sWhere, "h_v_IF_GroupList"); |
| | | |
| | | ds = oCN.RunProcReturn("Select HItemID id,HNumber,(CAST(HNumber as varchar(100))+'-'+CAST(HName as varchar(100))) as title,HParentID ParentID,HLevel from Gy_SettleStyle " + sWhere + "", "Gy_SettleStyle"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ è´§å¸æ°æ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #endregion |
| | | |
| | | #region 鿩客æ·åç±»åºç¡èµæ |
| | | |
| | | #region æ¡ä»¶æ¥è¯¢å®¢æ·åç±»å表 |
| | | [Route("PublicPageMethod/CusTypeList")] |
| | | [HttpGet] |
| | | public object CusTypeList(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("Select HItemID,HParentID,HNumber,HName from Gy_CusType " + sWhere + " Order by HItemID ", "Gy_CusType"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ 客æ·åç±»æ°æ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ ¹æ®æ åidæ¥æ¾å®¢æ·åç±»å表 |
| | | [Route("Gy_MaintenanceMode/CusTypeCX")] |
| | | [HttpGet] |
| | | public object CusTypeCX(long HInterID) |
| | | { |
| | | try |
| | | { |
| | | |
| | | ds = oCN.RunProcReturn(string.Format(@"WITH a AS (select * from Gy_CusType WHERE HitemID=" + HInterID + " UNION ALL select s.* from Gy_CusType AS s,a WHERE s.hparentid=a.HitemID) SELECT * FROM a"), "Gy_CusType"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "falseï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ åå表客æ·åç±»åè¡¨æ°æ® |
| | | [Route("Gy_MaintenanceMode/CusTypeLoadTree")] |
| | | [HttpGet] |
| | | public object CusTypeLoadTree(string sWhere) |
| | | { |
| | | SQLHelper.ClsCN SubCn = new SQLHelper.ClsCN(); |
| | | //ds = oCN.RunProcReturn("select * from h_v_IF_GroupList " + sWhere, "h_v_IF_GroupList"); |
| | | |
| | | ds = oCN.RunProcReturn("Select HItemID id,HNumber,(CAST(HNumber as varchar(100))+'-'+CAST(HName as varchar(100))) as title,HParentID ParentID,HLevel from Gy_CusType " + sWhere + "", "Gy_CusType"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ 客æ·åç±»æ°æ®ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #endregion |
| | | } |
| | | } |
| | |
| | | |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("select * from Gy_SourceRelationSet where HSourceID='" + HSourceID + "'", "Gy_SourceRelationSet"); |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | //ds = oCN.RunProcReturn("select * from Gy_SourceRelationSet where HSourceID='" + HSourceID + "'", "Gy_SourceRelationSet"); |
| | | //if (ds.Tables[0].Rows.Count > 0) |
| | | //{ |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "çäº§èµæºå·²åå¨ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | oCN.BeginTran(); |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "çäº§èµæºå·²åå¨ï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | //oCN.BeginTran(); |
| | | //åå
¥äº§çº¿ç»å® |
| | | string sql = string.Format(@"insert into Gy_SourceRelationSet (HSourceID,HUserName,HGroupID,HManagerID,HRemark,HCreateDate,HCreator,HNowFlag,HCheckManID) |
| | | values('" + HSourceID + "','" + HUserName + "','" + HGroupID + "','" + HManagerID + "','" + HRemark + "','" + DateTime.Parse(HCreateDate).ToShortDateString() + "','" + HUserName + "','0','')"); |
| | |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region [设å¤ç¹æ£è®°å½è¡¨å é¤åè½] |
| | | /// <summary> |
| | | /// 模å
·ç»´ä¿®åå é¤åè½ |
| | |
| | | return new ApiResult<DataSet> { code = 1, msg = "æ¥è¯¢æå", data = dataSet }; |
| | | } |
| | | #endregion |
| | | |
| | | #region[设å¤ç¹æ£è®°å½è¡¨ç¼è¾æ¶è·åè¡¨é¢æ°æ®] |
| | | [Route("Sb_EquipDotCheckBill/Sb_EquipDotCheckBillListProjectDetai")] |
| | | [HttpGet] |
| | |
| | | /// </summary> |
| | | /// <param name="msg"></param> |
| | | /// <returns></returns> |
| | | [Route("Sb_EqpRepairWorkBill/SaveGetEqpRepairWorkBillList")] |
| | | [Route("Sb_EqpRepairWorkBill/SaveGetEqpRepairWorkBillWebList")] |
| | | [HttpPost] |
| | | public object SaveGetMouldRepairWorkBillList([FromBody] JObject msg) |
| | | public object SaveGetEqpRepairWorkBillWebList([FromBody] JObject msg) |
| | | { |
| | | var _value = msg["msg"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | |
| | | |
| | | public static DataSet Sc_MouldMaintainBillList_s(string sWhere) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMaintainBillList ", "h_v_Sc_MouldMaintainBillList"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMaintain", "h_v_Sc_MouldMaintain"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_MouldMaintain where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MouldMaintain"); |
| | | |
| | | } |
| | | //return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MouldMaintainBillList ", "h_v_Sc_MouldMaintainBillList"); |
| | | } |
| | | #endregion |
| | | |
| | |
| | | #endregion |
| | | |
| | | #endregion |
| | | |
| | | #region 模å
·ä¿å
»è®°å½è¡¨ |
| | | |
| | | #region 模å
·ä¿å
»è®°å½è¡¨ ä¿å/ç¼è¾ |
| | |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region[模å
·ä¿å
»è®°å½è¡¨ç¼è¾æ¶è·åè¡¨å¤´æ°æ®] |
| | | [Route("Sc_MouldMaintainBill/Sc_MouldMaintainBillListCheckDetai")] |
| | | [HttpGet] |
| | |
| | | return new ApiResult<DataSet> { code = 1, msg = "æ¥è¯¢æå", data = dataSet }; |
| | | } |
| | | #endregion |
| | | |
| | | #region[模å
·ä¿å
»è®°å½è¡¨ç¼è¾æ¶è·åè¡¨é¢æ°æ®] |
| | | [Route("Sc_MouldMaintainBill/Sc_MouldMaintainBillListProjectDetai")] |
| | | [HttpGet] |
| | |
| | | string sql = "select HMaintainItemID, ä¿å
»é¡¹ç®ä»£ç HMaintainItemNumber,ä¿å
»é¡¹ç®åç§° HMaintainItem,ä¿å
»é¨ä½ HMaintainPart,å
·ä½è¦æ± HClaim,HManagerID,è´è´£äººä»£ç HManagerNumber,è´è´£äºº HManagerName,表ä½å¤æ³¨ HRemark from h_v_Sc_MouldMaintainBillListItem where 1 = 1 " + Swhere + ""; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_MouldMaintainBillListItem"); |
| | | //è·åé
件项ç®ç¼è¾æ°æ® |
| | | string sql1 = "select HMaterID, é
件代ç HMaterNumber,é
ä»¶åç§° HMaterName,è§æ ¼åå· HMaterSpec,HUnitID,åä½ä»£ç HUnitNumber,åä½åç§° HUnitName,å®é
ç¨é HQty,æ åç¨é HQtyMust,HManagerID,è´è´£äººä»£ç HManagerNumber,è´è´£äºº HManagerName,表ä½å¤æ³¨ HRemark from h_v_Sc_MouldMaintainBillListItem where 1 = 1 " + Swhere + ""; |
| | | ds1 = oCN.RunProcReturn(sql, "h_v_Sc_MouldMaintainBillListItem"); |
| | | string sql1 = "select HMaterID, é
件代ç HMaterNumber,é
ä»¶åç§° HMaterName,è§æ ¼åå· HMaterSpec,HUnitID,åä½ä»£ç HUnitNumber,åä½åç§° HUnitName,å®é
ç¨é HQty,æ åç¨é HQtyMust,HManagerID,è´è´£äººä»£ç HManagerNumber,è´è´£äºº HManagerName,表ä½å¤æ³¨ HRemark from h_v_Sc_MouldMaintainBillList where 1 = 1 " + Swhere + ""; |
| | | ds1 = oCN.RunProcReturn(sql1, "h_v_Sc_MouldMaintainBillList"); |
| | | list.Add(ds.Tables[0]); |
| | | list.Add(ds1.Tables[0]); |
| | | objJsonResult.code = "0"; |
| | |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region [模å
·ä¿å
»è®°å½è¡¨å é¤åè½] |
| | | #region [模å
·ä¿å
»è®°å½è¡¨å é¤åè½] |
| | | /// <summary> |
| | | /// 模å
·ç»´ä¿®åå é¤åè½ |
| | | /// </summary> |
| | |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #endregion |
| | | |
| | | #region 模å
·ç¹æ£è®°å½è¡¨ |
| | | |
| | | #region 模å
·ç¹æ£è®°å½è¡¨ ä¿å/ç¼è¾ |
| | |
| | | |
| | | |
| | | #endregion |
| | | |
| | | #region 模å
·ç¹æ£è®¡å表 |
| | | |
| | | #region 模å
·ç¹æ£è®¡å表 ä¿å/ç¼è¾ |
File was renamed from WebAPI/Controllers/SCGL/Sc_MESBeginWorkBillController.cs |
| | |
| | | [HttpGet] |
| | | public object MESProductAuditProcessReportList(int HSourceID,int HSourceInterID,int HSourceEntryID,string HSourceBillNo, int HICMOInterID,int HICMOEntryID, int HInterID, int IsAudit, string CurUserName) |
| | | { |
| | | string ModRightNameCheck = "Sc_ICMOReportBill_Check"; |
| | | string ModRightNameCheck = "MES_ProcExchReport_Check"; |
| | | DBUtility.ClsPub.CurUserName = CurUserName; |
| | | try |
| | | { |
| | | string StrMessage = ""; |
| | | //å®¡æ ¸æé |
| | | if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) |
| | | if (!WebClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName,ref StrMessage)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å®¡æ ¸å¤±è´¥ï¼æ æéï¼"; |
| | | objJsonResult.Message = StrMessage; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
New file |
| | |
| | | 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 |
| | | { |
| | | //è´¨éæ±æ¥åController |
| | | //æ°æ®åºä¸»è¡¨Sc_QualityReportBillMain |
| | | //æ°æ®åºå表Sc_QualityReportBillSub |
| | | public class Sc_QualityReportBillController : ApiController |
| | | { |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
| | | private json objJsonResult = new json(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | | |
| | | #region è¿åçäº§è´¨éæ±æ¥åå表 |
| | | [Route("Sc_QualityReportBill/list")] |
| | | [HttpGet] |
| | | public object list(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Sc_QualityReportBillList " + sWhere, "h_v_Sc_QualityReportBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_QualityReportBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_QualityReportBillList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "falseï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region è´¨éæ±æ¥åæ ¹æ®æºåç±»åè·åä¿¡æ¯-æºå为çäº§ç¶æä¸´æ¶è¡¨ï¼3722ï¼ |
| | | [Route("Sc_QualityReportBill/get_ICMOBillStatus_Tmp")] |
| | | [HttpGet] |
| | | public object get_ICMOBillStatus_Tmp(int HInterID, int HEntryID, string HBillType) |
| | | { |
| | | try |
| | | { |
| | | if (HInterID == 0 || HBillType.Equals("")) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ°ä¸å
¨ï¼è·åæºåä¿¡æ¯å¤±è´¥ï¼HInterIDï¼" + HInterID + "ï¼HEntryIDï¼" + HEntryID + "ï¼HBillTypeï¼" + HBillType + "ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | ds = oCN.RunProcReturn |
| | | ("select a.HInterID,a.HBillType,a.HICMOBillNo,a.HICMOInterID,a.HMaterID" + |
| | | ",m.HNumber HMaterNumber,m.HName HMaterName,m.HModel HMaterModel " + |
| | | " from Sc_ICMOBillStatus_Tmp a " + |
| | | " left join Gy_Material m on a.HMaterID=m.HItemID " + |
| | | " Where a.HInterID=" + HInterID + " and a.HBillType="+ HBillType, "Sc_ICMOBillStatus_Tmp"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¥è¯¢æ°æ®å¼å¸¸ï¼è¯·ä¸ç®¡çåèç³»ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è¿åè®°å½æåï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¥è¯¢æ°æ®å¼å¸¸ï¼è¯·ä¸ç®¡çåèç³»ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region è´¨éæ±æ¥åæ«ä¸è¯æ¡ç ä¿åä¿¡æ¯ |
| | | [Route("Sc_QualityReportBill/set_SaveBarCode")] |
| | | [HttpPost] |
| | | public object set_SaveBarCode([FromBody] JObject oMain) |
| | | { |
| | | var msg1 = oMain["oMain"].ToString(); |
| | | //ä¿ååæ® |
| | | return objJsonResult = AddBillMain(msg1); |
| | | } |
| | | |
| | | public json AddBillMain(string msg1) |
| | | { |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg = sArray[0].ToString(); |
| | | string msg3 = sArray[1].ToString(); |
| | | string OperationType = sArray[2].ToString().Trim(); |
| | | bool bResult; |
| | | try |
| | | { |
| | | msg = "[" + msg.ToString() + "]"; |
| | | List<Model.ClsQC_FirstPieceCheckBillMain> mainList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsQC_FirstPieceCheckBillMain>>(msg); |
| | | DAL.ClsQC_FirstPieceCheckBill BillNew = new DAL.ClsQC_FirstPieceCheckBill(); |
| | | //夿ä¼è®¡ææ¯å¦åç |
| | | 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.HInterID = mainList[0].HInterID;//éå
¥typeå¾å°çåæ®ID |
| | | BillNew.omodel.HBillNo = mainList[0].HBillNo;//éå
¥typeå¾å°çåæ®å· |
| | | BillNew.omodel.HDate = HDate; |
| | | BillNew.omodel.HRemark = mainList[0].HRemark;//夿³¨ |
| | | BillNew.omodel.HMaker = mainList[0].HMaker; |
| | | BillNew.omodel.HSourceID = ClsPub.isLong(mainList[0].HSourceID); |
| | | BillNew.omodel.HICMOInterID = ClsPub.isLong(mainList[0].HICMOInterID); |
| | | BillNew.omodel.HICMOBillNo = ClsPub.isStrNull(mainList[0].HICMOBillNo); |
| | | BillNew.omodel.HICMOInterID = ClsPub.isLong(mainList[0].HICMOInterID); |
| | | BillNew.omodel.HICMOQty = ClsPub.isLong(mainList[0].HICMOQty); |
| | | BillNew.omodel.HProcExchInterID = ClsPub.isLong(mainList[0].HProcExchInterID); |
| | | BillNew.omodel.HProcExchEntryID = ClsPub.isLong(mainList[0].HProcExchEntryID); |
| | | BillNew.omodel.HProcExchBillNo = ClsPub.isStrNull(mainList[0].HProcExchBillNo); |
| | | BillNew.omodel.HProcExchQty = ClsPub.isLong(mainList[0].HProcExchQty); |
| | | BillNew.omodel.HMaterID = ClsPub.isLong(mainList[0].HMaterID); |
| | | BillNew.omodel.HFirstCheckEmp = ClsPub.isLong(mainList[0].HFirstCheckEmp); |
| | | BillNew.omodel.HLastResult = ClsPub.isBool(mainList[0].HLastResult); |
| | | BillNew.omodel.HMainSourceInterID = ClsPub.isLong(mainList[0].HMainSourceInterID); |
| | | BillNew.omodel.HMainSourceEntryID = ClsPub.isLong(mainList[0].HMainSourceEntryID); |
| | | BillNew.omodel.HMainSourceBillNo = ClsPub.isStrNull(mainList[0].HMainSourceBillNo); |
| | | BillNew.omodel.HMainSourceBillType = ClsPub.isStrNull(mainList[0].HMainSourceBillType); |
| | | BillNew.omodel.HBillStatus = 1; |
| | | List<Model.ClsQC_FirstPieceCheckBillSub> subList = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsQC_FirstPieceCheckBillSub>>(msg3); |
| | | BillNew.DetailColl = new List<Model.ClsQC_FirstPieceCheckBillSub>(); |
| | | for (int i = 0; i < subList.ToArray().Length; i++) |
| | | { |
| | | if (i >= 0)//HQty |
| | | { |
| | | Model.ClsQC_FirstPieceCheckBillSub oSub = new Model.ClsQC_FirstPieceCheckBillSub(); |
| | | oSub.HEntryID = i + 1; |
| | | oSub.HRemark = ClsPub.isStrNull(subList[i].HRemark); |
| | | oSub.HSourceInterID = ClsPub.isLong(subList[i].HSourceInterID); |
| | | oSub.HSourceEntryID = ClsPub.isLong(subList[i].HSourceEntryID); |
| | | oSub.HSourceBillType = ClsPub.isStrNull(subList[i].HSourceBillType); |
| | | oSub.HSourceBillNo = ClsPub.isStrNull(subList[i].HSourceBillNo); |
| | | oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[i].HRelationQty); |
| | | oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[i].HRelationMoney); |
| | | oSub.HCloseMan = DBUtility.ClsPub.isStrNull(subList[i].HCloseMan); |
| | | oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(subList[i].HEntryCloseDate); |
| | | oSub.HCloseType = DBUtility.ClsPub.isBool(subList[i].HCloseType); |
| | | oSub.HQCCheckItemID = DBUtility.ClsPub.isLong(subList[i].HQCCheckItemID); |
| | | oSub.HQCStd = DBUtility.ClsPub.isStrNull(subList[i].HQCStd); |
| | | oSub.HUnit = DBUtility.ClsPub.isStrNull(subList[i].HUnit); |
| | | oSub.HQCNote = DBUtility.ClsPub.isStrNull(subList[i].HQCNote); |
| | | oSub.HResult = DBUtility.ClsPub.isStrNull(subList[i].HResult); |
| | | oSub.HMax = DBUtility.ClsPub.isStrNull(subList[i].HMax); |
| | | oSub.HMin = DBUtility.ClsPub.isStrNull(subList[i].HMin); |
| | | oSub.HAvg = DBUtility.ClsPub.isStrNull(subList[i].HAvg); |
| | | oSub.HBillNo_bak = DBUtility.ClsPub.isStrNull(mainList[0].HBillNo); |
| | | BillNew.DetailColl.Add(oSub); |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ æç»è¡ä¿¡æ¯!"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | //ä¿å宿¯åå¤ç |
| | | if (OperationType.Equals("1") || OperationType.Equals("2")) |
| | | { |
| | | bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo); |
| | | } |
| | | else |
| | | { |
| | | bResult = BillNew.ModifyBill(BillNew.omodel.HInterID, ref ClsPub.sExeReturnInfo); |
| | | } |
| | | //æç¤º |
| | | if (bResult == true) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | //objJsonResult.Message = "åæ®åç宿¯!åæ®å·:" + mainList[0].HBillNo.Trim(); |
| | | 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 |
| | | |
| | | } |
| | | } |
| | |
| | | List<Models.ClsSc_ICMOBillWorkQtyStatus_Tmp> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSc_ICMOBillWorkQtyStatus_Tmp>>(jsonString); |
| | | return list; |
| | | } |
| | | |
| | | } |
| | | } |
| | |
| | | |
| | | namespace WebAPI.Models |
| | | { |
| | | public class Gy_Mould |
| | | public class Gy_Mould : DBUtility.ClsXt_BaseBillMain |
| | | { |
| | | public long HInterID { get; set; } |
| | | public string HBillNo { get; set; } |
| | | public DateTime HDate { get; set; } |
| | | public string HRemark { get; set; } |
| | | |
| | | public string HMouldNo { get; set; } |
| | | public string HName { get; set; } |
| | | public string HModel { get; set; } |
| | |
| | | public string HWorkMaterModel { get; set; } |
| | | public long HMaterID { get; set; } |
| | | public string HMaterNumber { get; set; } |
| | | public long HMouldTypeID { get; set; } |
| | | public long HMouleTypeID { get; set; } |
| | | public long HUnitID { get; set; } |
| | | public DateTime HOutComDate { get; set; } |
| | | public string HOutComNo { get; set; } |
| | |
| | | public long HLifeUnitID { get; set; } |
| | | |
| | | public long HBOMID { get; set; } |
| | | |
| | | public string HMaker { get; set; } |
| | | |
| | | public long HPrintQty { get; set; } |
| | | |
| | |
| | | <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> |
| | | <PropertyGroup> |
| | | <_PublishTargetUrl>D:\ç½ç«åå¸\æºäºMESWMS\API</_PublishTargetUrl> |
| | | <History>True|2021-08-22T01:24:12.7210871Z;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-08-26T08:00:44.3162145Z;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>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="bin/Antlr3.Runtime.dll"> |
| | | <publishTime>02/22/2013 08:43:40</publishTime> |
| | | <publishTime>02/22/2013 16:43:40</publishTime> |
| | | </File> |
| | | <File Include="bin/Antlr3.Runtime.pdb"> |
| | | <publishTime>02/22/2013 08:43:40</publishTime> |
| | | <publishTime>02/22/2013 16:43:40</publishTime> |
| | | </File> |
| | | <File Include="bin/BLL.dll"> |
| | | <publishTime>08/27/2021 13:33:35</publishTime> |
| | | <publishTime>08/26/2021 16:00:33</publishTime> |
| | | </File> |
| | | <File Include="bin/BLL.pdb"> |
| | | <publishTime>08/27/2021 13:33:35</publishTime> |
| | | <publishTime>08/26/2021 16:00:33</publishTime> |
| | | </File> |
| | | <File Include="bin/DAL.dll"> |
| | | <publishTime>08/27/2021 13:33:33</publishTime> |
| | | <publishTime>08/26/2021 16:00:32</publishTime> |
| | | </File> |
| | | <File Include="bin/DAL.pdb"> |
| | | <publishTime>08/27/2021 13:33:33</publishTime> |
| | | <publishTime>08/26/2021 16:00:32</publishTime> |
| | | </File> |
| | | <File Include="bin/Dapper.dll"> |
| | | <publishTime>07/22/2016 14:52:40</publishTime> |
| | | <publishTime>07/22/2016 22:52:40</publishTime> |
| | | </File> |
| | | <File Include="bin/DBUtility.dll"> |
| | | <publishTime>08/27/2021 13:33:30</publishTime> |
| | | <publishTime>08/26/2021 16:00:30</publishTime> |
| | | </File> |
| | | <File Include="bin/DBUtility.pdb"> |
| | | <publishTime>08/27/2021 13:33:30</publishTime> |
| | | <publishTime>08/26/2021 16:00:30</publishTime> |
| | | </File> |
| | | <File Include="bin/Interop.gregn6Lib.dll"> |
| | | <publishTime>08/17/2021 09:09:33</publishTime> |
| | | <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>08/25/2021 20:46:09</publishTime> |
| | | </File> |
| | | <File Include="bin/Kingdee.BOS.WebApi.FormService.dll"> |
| | | <publishTime>09/20/2018 19:23:20</publishTime> |
| | |
| | | <publishTime>09/20/2018 19:28:34</publishTime> |
| | | </File> |
| | | <File Include="bin/Microsoft.Azure.AppService.ApiApps.Service.dll"> |
| | | <publishTime>03/18/2015 17:02:50</publishTime> |
| | | <publishTime>03/19/2015 01:02:50</publishTime> |
| | | </File> |
| | | <File Include="bin/Microsoft.CSharp.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/Microsoft.Web.Infrastructure.dll"> |
| | | <publishTime>07/25/2012 11:48:56</publishTime> |
| | | <publishTime>07/25/2012 19:48:56</publishTime> |
| | | </File> |
| | | <File Include="bin/Model.dll"> |
| | | <publishTime>08/27/2021 13:33:30</publishTime> |
| | | <publishTime>08/26/2021 16:00:30</publishTime> |
| | | </File> |
| | | <File Include="bin/Model.pdb"> |
| | | <publishTime>08/27/2021 13:33:30</publishTime> |
| | | <publishTime>08/26/2021 16:00:30</publishTime> |
| | | </File> |
| | | <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="bin/Newtonsoft.Json.dll"> |
| | | <publishTime>08/03/2014 20:33:56</publishTime> |
| | | <publishTime>08/04/2014 04:33:56</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Class.dll"> |
| | | <publishTime>08/20/2021 10:44:25</publishTime> |
| | | <publishTime>08/26/2021 16:00:29</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Class.pdb"> |
| | | <publishTime>08/20/2021 10:44:25</publishTime> |
| | | <publishTime>08/26/2021 16:00:29</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Control.dll"> |
| | | <publishTime>08/20/2021 10:44:25</publishTime> |
| | | <publishTime>08/26/2021 16:00:29</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Control.pdb"> |
| | | <publishTime>08/20/2021 10:44:25</publishTime> |
| | | <publishTime>08/26/2021 16:00:29</publishTime> |
| | | </File> |
| | | <File Include="bin/SQLHelper.dll"> |
| | | <publishTime>08/20/2021 10:44:25</publishTime> |
| | | <publishTime>08/26/2021 16:00:29</publishTime> |
| | | </File> |
| | | <File Include="bin/SQLHelper.pdb"> |
| | | <publishTime>08/20/2021 10:44:25</publishTime> |
| | | <publishTime>08/26/2021 16:00:29</publishTime> |
| | | </File> |
| | | <File Include="bin/stdole.dll"> |
| | | <publishTime>08/15/2021 14:25:35</publishTime> |
| | | <publishTime>05/09/2021 13:35:37</publishTime> |
| | | </File> |
| | | <File Include="bin/Swashbuckle.Core.dll"> |
| | | <publishTime>02/15/2015 17:57:08</publishTime> |
| | | <publishTime>02/16/2015 01:57:08</publishTime> |
| | | </File> |
| | | <File Include="bin/System.ComponentModel.DataAnnotations.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/System.IdentityModel.Tokens.Jwt.dll"> |
| | | <publishTime>08/19/2014 10:03:34</publishTime> |
| | | <publishTime>08/19/2014 18:03:34</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Net.Http.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Net.Http.Formatting.dll"> |
| | | <publishTime>11/28/2018 13:00:36</publishTime> |
| | | <publishTime>11/28/2018 21:00:36</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Runtime.Serialization.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Cors.dll"> |
| | | <publishTime>11/28/2018 12:58:44</publishTime> |
| | | <publishTime>11/28/2018 20:58:44</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Helpers.dll"> |
| | | <publishTime>01/28/2015 04:04:30</publishTime> |
| | | <publishTime>01/28/2015 12:04:30</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Http.Cors.dll"> |
| | | <publishTime>11/28/2018 13:01:26</publishTime> |
| | | <publishTime>11/28/2018 21:01:26</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Http.dll"> |
| | | <publishTime>11/28/2018 13:01:00</publishTime> |
| | | <publishTime>11/28/2018 21:01:00</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Http.WebHost.dll"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Mvc.dll"> |
| | | <publishTime>01/28/2015 04:02:18</publishTime> |
| | | <publishTime>01/28/2015 12:02:18</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Optimization.dll"> |
| | | <publishTime>02/11/2014 15:26:04</publishTime> |
| | | <publishTime>02/11/2014 23:26:04</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Razor.dll"> |
| | | <publishTime>01/28/2015 04:02:32</publishTime> |
| | | <publishTime>01/28/2015 12:02:32</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Services.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.WebPages.Deployment.dll"> |
| | | <publishTime>01/28/2015 04:04:30</publishTime> |
| | | <publishTime>01/28/2015 12:04:30</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.WebPages.dll"> |
| | | <publishTime>01/28/2015 04:04:30</publishTime> |
| | | <publishTime>01/28/2015 12:04:30</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.WebPages.Razor.dll"> |
| | | <publishTime>01/28/2015 04:04:30</publishTime> |
| | | <publishTime>01/28/2015 12:04:30</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Xml.dll"> |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | |
| | | <publishTime>09/26/2012 03:16:08</publishTime> |
| | | </File> |
| | | <File Include="bin/WebActivatorEx.dll"> |
| | | <publishTime>11/24/2014 11:18:48</publishTime> |
| | | <publishTime>11/24/2014 19:18:48</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.dll"> |
| | | <publishTime>08/27/2021 13:44:29</publishTime> |
| | | <publishTime>08/26/2021 16:00:35</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.pdb"> |
| | | <publishTime>08/27/2021 13:44:29</publishTime> |
| | | <publishTime>08/26/2021 16:00:35</publishTime> |
| | | </File> |
| | | <File Include="bin/WebGrease.dll"> |
| | | <publishTime>07/17/2013 17:03:52</publishTime> |
| | | <publishTime>07/18/2013 01:03:52</publishTime> |
| | | </File> |
| | | <File Include="bin/zh-Hans/System.Net.Http.Formatting.resources.dll"> |
| | | <publishTime>11/29/2018 13:26:02</publishTime> |
| | | <publishTime>11/29/2018 21:26:02</publishTime> |
| | | </File> |
| | | <File Include="bin/zh-Hans/System.Web.Http.resources.dll"> |
| | | <publishTime>11/29/2018 13:26:30</publishTime> |
| | | <publishTime>11/29/2018 21:26:30</publishTime> |
| | | </File> |
| | | <File Include="Content/bootstrap.css"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Content/bootstrap.min.css"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Content/Site.css"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="DLL/BLL.dll"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="DLL/DAL.dll"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="DLL/DBUtility.dll"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="DLL/Kingdee.BOS.WebApi.Client.dll"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="DLL/Model.dll"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="DLL/Newtonsoft.Json.Net35.dll"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="DLL/Pub_Class.dll"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="DLL/Pub_Control.dll"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="DLL/SQLHelper.dll"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.eot"> |
| | | <publishTime>08/16/2021 17:23:16</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.svg"> |
| | | <publishTime>08/16/2021 17:23:16</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.ttf"> |
| | | <publishTime>08/16/2021 17:23:16</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.woff"> |
| | | <publishTime>08/16/2021 17:23:16</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Global.asax"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Index.html"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="packages.config"> |
| | | <publishTime>08/16/2021 17:23:16</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/bootstrap.js"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/bootstrap.min.js"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.js"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.min.js"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.min.map"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.js"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.min.js"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.unobtrusive.js"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/modernizr-2.6.2.js"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Views/Shared/Error.cshtml"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Views/Shared/_Layout.cshtml"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Views/web.config"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Views/_ViewStart.cshtml"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Department_Model.datasource"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Customer_Model.datasource"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Department_Model.datasource"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Employee_Model.datasource"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Group_Model.datasource"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Source_Model.datasource"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource"> |
| | | <publishTime>08/16/2021 17:23:15</publishTime> |
| | | <publishTime>08/25/2021 20:46:11</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/Reference.map"> |
| | | <publishTime>08/06/2021 22:57:28</publishTime> |
| | | </File> |
| | | <File Include="Web.config"> |
| | | <publishTime>08/20/2021 11:01:21</publishTime> |
| | | <publishTime>08/26/2021 16:00:44</publishTime> |
| | | </File> |
| | | </ItemGroup> |
| | | </Project> |
| | |
| | | <Compile Include="Controllers\PublicPageMethodController.cs" /> |
| | | <Compile Include="Controllers\ReportFromController.cs" /> |
| | | <Compile Include="Controllers\ReportPlatFormController.cs" /> |
| | | <Compile Include="Controllers\SCGL\Sc_MESProductReportBillController.cs" /> |
| | | <Compile Include="Controllers\ç产管ç\Sc_MESProductReportBillController.cs" /> |
| | | <Compile Include="Controllers\Sc_MouldController.cs" /> |
| | | <Compile Include="Controllers\Sc_GroupOrderBillController.cs" /> |
| | | <Compile Include="Controllers\QC_ManagementController.cs" /> |
| | |
| | | <Compile Include="Controllers\SBGL\Sb_EquipMaintainPlanBillController.cs" /> |
| | | <Compile Include="Controllers\SBGL\Sb_EquipDotCheckPlanBillController.cs" /> |
| | | <Compile Include="Controllers\Sb_CheckEqpRepairWorkBillController.cs" /> |
| | | <Compile Include="Controllers\SCGL\Sc_MaterToSourceBillController.cs" /> |
| | | <Compile Include="Controllers\SCGL\Sc_MESEndWorkBillController.cs" /> |
| | | <Compile Include="Controllers\SCGL\Sc_MESStopWorkBillController.cs" /> |
| | | <Compile Include="Controllers\SCGL\Sc_MESBeginWorkBillController.cs" /> |
| | | <Compile Include="Controllers\SCGL\QC_LastPieceCheckBillController.cs" /> |
| | | <Compile Include="Controllers\SCGL\QC_OutCompCheckBillController.cs" /> |
| | | <Compile Include="Controllers\SCGL\Sc_QualityReportBillController.cs" /> |
| | | <Compile Include="Controllers\ç产管ç\Sc_MaterToSourceBillController.cs" /> |
| | | <Compile Include="Controllers\ç产管ç\Sc_MESEndWorkBillController.cs" /> |
| | | <Compile Include="Controllers\ç产管ç\Sc_MESStopWorkBillController.cs" /> |
| | | <Compile Include="Controllers\ç产管ç\Sc_MESBeginWorkBillController.cs" /> |
| | | <Compile Include="Controllers\ç产管ç\QC_LastPieceCheckBillController.cs" /> |
| | | <Compile Include="Controllers\ç产管ç\QC_OutCompCheckBillController.cs" /> |
| | | <Compile Include="Controllers\ç产管ç\Sc_ICMOReportBillController.cs" /> |
| | | <Compile Include="Controllers\Sc_MouldOtherInBillController.cs" /> |
| | | <Compile Include="Controllers\Sc_ProcessMangementController.cs" /> |
| | | <Compile Include="Controllers\CJGL\Cj_StationEntrustInBillController.cs" /> |
| | | <Compile Include="Controllers\LMESController.cs" /> |
| | | <Compile Include="Controllers\LookingForBillController.cs" /> |
| | | <Compile Include="Controllers\NewApiController.cs" /> |
| | | <Compile Include="Controllers\SCGL\Sc_ICMOReportBillController.cs" /> |
| | | <Compile Include="Controllers\SCGL\Sc_PPBomBillController.cs" /> |
| | | <Compile Include="Controllers\ç产管ç\Sc_PPBomBillController.cs" /> |
| | | <Compile Include="Controllers\Sc_CheckToolsRepairWorkBillController.cs" /> |
| | | <Compile Include="Controllers\XSGL\Xs_SeOutStockBackBillController.cs" /> |
| | | <Compile Include="Controllers\XSGL\Xs_SeOutStockBillController.cs" /> |
| | | <Compile Include="Controllers\XSGL\Xs_SeOrderBillController.cs" /> |
| | | <Compile Include="Controllers\å质管ç\å·¥åºæ£éªå\QC_ProcessCheckBillController.cs" /> |
| | | <Compile Include="Controllers\å质管ç\é¦ä»¶æ£éªå\QC_FirstPieceCheckBillController.cs" /> |
| | | <Compile Include="Controllers\ç产管ç\è´¨éæ±æ¥å\Sc_QualityReportBillController.cs" /> |
| | | <Compile Include="Dapper\SqlHelper.cs" /> |
| | | <Compile Include="Dapper\SqlPools.cs" /> |
| | | <Compile Include="DbUntil\DataFormatUntil.cs" /> |
| | |
| | | <WebStackScaffolding_IsReferencingScriptLibrariesSelected>True</WebStackScaffolding_IsReferencingScriptLibrariesSelected> |
| | | <WebStackScaffolding_LayoutPageFile /> |
| | | <WebStackScaffolding_IsAsyncSelected>False</WebStackScaffolding_IsAsyncSelected> |
| | | <NameOfLastUsedPublishProfile>FolderProfile</NameOfLastUsedPublishProfile> |
| | | <NameOfLastUsedPublishProfile>D:\Gitä»åº\MESWMS\MES-WEB-API\WebAPI\Properties\PublishProfiles\FolderProfile.pubxml</NameOfLastUsedPublishProfile> |
| | | <LastActiveSolutionConfig>Debug|Any CPU</LastActiveSolutionConfig> |
| | | <UseIISExpress>false</UseIISExpress> |
| | | <Use64BitIISExpress /> |
| | |
| | | <ErrorReport>prompt</ErrorReport> |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <Reference Include="AxInterop.grdes6Lib"> |
| | | <HintPath>..\OCX\AxInterop.grdes6Lib.dll</HintPath> |
| | | </Reference> |
| | | <Reference Include="AxInterop.gregn6Lib"> |
| | | <HintPath>..\OCX\AxInterop.gregn6Lib.dll</HintPath> |
| | | </Reference> |
| | | <Reference Include="Interop.grdes6Lib"> |
| | | <HintPath>..\OCX\Interop.grdes6Lib.dll</HintPath> |
| | | <EmbedInteropTypes>True</EmbedInteropTypes> |
| | | </Reference> |
| | | <Reference Include="Interop.gregn6Lib"> |
| | | <HintPath>..\OCX\Interop.gregn6Lib.dll</HintPath> |
| | | <EmbedInteropTypes>True</EmbedInteropTypes> |
| | | </Reference> |
| | | <Reference Include="System" /> |
| | | <Reference Include="System.Data" /> |
| | | <Reference Include="System.Drawing" /> |
| | |
| | | </Compile> |
| | | </ItemGroup> |
| | | <ItemGroup> |
| | | <COMReference Include="Axgrdes6Lib"> |
| | | <Guid>{C5A16330-A084-48C9-BC0F-0D0B37A14123}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>aximp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="Axgregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>aximp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="grdes6Lib"> |
| | | <Guid>{C5A16330-A084-48C9-BC0F-0D0B37A14123}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>tlbimp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="gregn6Lib"> |
| | | <Guid>{4018F953-1BFE-441E-8A04-DC8BA1FF060E}</Guid> |
| | | <VersionMajor>6</VersionMajor> |
| | | <VersionMinor>0</VersionMinor> |
| | | <Lcid>0</Lcid> |
| | | <WrapperTool>tlbimp</WrapperTool> |
| | | <Isolated>False</Isolated> |
| | | </COMReference> |
| | | <COMReference Include="stdole"> |
| | | <Guid>{00020430-0000-0000-C000-000000000046}</Guid> |
| | | <VersionMajor>2</VersionMajor> |