20个文件已删除
28个文件已修改
14个文件已添加
| | |
| | | <ErrorReportUrlHistory /> |
| | | <FallbackCulture>zh-CN</FallbackCulture> |
| | | <VerifyUploadedFiles>false</VerifyUploadedFiles> |
| | | <ProjectView>ShowAllFiles</ProjectView> |
| | | </PropertyGroup> |
| | | </Project> |
| | |
| | | oCn.BeginTran(); |
| | | //主表 |
| | | oCn.RunProc("Insert Into Sc_MouldStockBillMain " + |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + |
| | | ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + |
| | | ",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + |
| | | ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" + |
| | | ",HRepairType" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + |
| | | ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + |
| | | ", " + omodel.HSupID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HSCWHID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HSecManagerID.ToString() + |
| | | ", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) + |
| | | ",'"+omodel.HRepairType.ToString()+"'"+ |
| | | ") "); |
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HDate" + |
| | | ",HYear,HPeriod,HRemark,HMaker,HMakeDate" + |
| | | ",HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID" + |
| | | ",HKeeperID,HDeptID,HExplanation,HInnerBillNo,HRedBlueFlag" + |
| | | "" + |
| | | ") " + |
| | | " values('" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + |
| | | ", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" + |
| | | ", " + omodel.HSupID.ToString() + "," + omodel.HWHID.ToString() + "," + omodel.HSCWHID.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HSecManagerID.ToString() + |
| | | ", " + omodel.HKeeperID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'," + DBUtility.ClsPub.BoolToString(omodel.HRedBlueFlag) + |
| | | ") "); |
| | | //æå
¥å表 |
| | | foreach (Model.ClsSc_MouldStockBillSub oSub in DetailColl) |
| | | { |
| | |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" + |
| | | ",HMaterID,HPropertyID,HSecUnitID,HSecUnitRate,HUnitID,HQtyMust" + |
| | | ",HQty,HPrice,HMoney,HWHID,HSCWHID,HSPID" + |
| | | ",HDesignLife,HLeaveLife,HUseLife,HNowModel,HNowLife" + |
| | | ",HSCSPID,HSPGroupID,HBatchNo" + |
| | | ",HDesignLife,HLeaveLife,HUseLife,HNewLifeQty" + |
| | | ",HSCSPID,HSPGroupID,HBatchNo,HBackFlag,HNowModel,HNowLife" + |
| | | ",HNewModel,HLastProdModel,HWallThickness,HHardness,HDiameter,HQtyRel" + |
| | | ",HMouldType,HInitModel,HInitDesignLife,HLifeUnitID" + |
| | | ") values(" |
| | |
| | | "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() + |
| | | "," + oSub.HMaterID.ToString() + "," + oSub.HPropertyID.ToString() + "," + oSub.HSecUnitID.ToString() + "," + oSub.HSecUnitRate.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HQtyMust.ToString() + |
| | | "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HMoney.ToString() + "," + oSub.HWHID.ToString() + "," + oSub.HSCWHID.ToString() + "," + oSub.HSPID.ToString() + |
| | | "," + oSub.HDesignLife.ToString() + "," + oSub.HLeaveLife.ToString() + "," + oSub.HUseLife.ToString() + ",'" + oSub.HNowModel + "'," + oSub.HNowLife.ToString() + |
| | | "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "'" + |
| | | "," + oSub.HDesignLife.ToString() + "," + oSub.HLeaveLife.ToString() + "," + oSub.HUseLife.ToString() + "," + oSub.HNewLifeQty.ToString() + |
| | | "," + oSub.HSCSPID.ToString() + "," + oSub.HSPGroupID.ToString() + ",'" + oSub.HBatchNo + "','" + oSub.HBackFlag + "','" + oSub.HNowModel + "'," + oSub.HNowLife.ToString() + |
| | | ",'" + oSub.HNewModel + "','" + oSub.HLastProdModel + "','" + oSub.HWallThickness + "','" + oSub.HHardness + "','" + oSub.HDiameter + "'," + oSub.HQtyRel.ToString() + |
| | | "," + oSub.HMouldType.ToString() + ",'" + oSub.HInitModel + "'," + oSub.HInitDesignLife.ToString() + "," + oSub.HLifeUnitID.ToString() + |
| | | ") "); |
| | | "," + oSub.HMouldType.ToString() + ",'" + oSub.HInitModel + "'," + oSub.HInitDesignLife.ToString() + "," + oSub.HLifeUnitID.ToString() + |
| | | ") "); |
| | | |
| | | |
| | | oCn.RunProc("exec h_p_Sc_MouldFileChangeStatus " + oSub.HMaterID.ToString() + ",'" + oSub.HNowModel.ToString() + "'," + oSub.HNowLife.ToString() + ",'æ¹å¶ä¸'"); |
| | | } |
| | | |
| | | |
| | | //foreach (Model.ClsSc_MouldStockBillSub oSub in DetailColl) |
| | | //{ |
| | | // Ds = oCn.RunProcReturn("exec h_p_Sc_MouldRepairOutBill_Qty " + oSub.HICMOInterID, ""); |
| | |
| | | DataSet Ds; |
| | | foreach (Model.ClsSc_MouldStockBillSub oSub in DetailColl) |
| | | { |
| | | Ds = oCn.RunProcReturn("exec h_p_Kf_ICStockBill_CheckKF " + omodel.HInterID + "," + oSub.HMaterID + "," + oSub.HWHID + "," + oSub.HSPID + ", -1", "gy_czygl"); |
| | | Ds = oCn.RunProcReturn("exec h_p_Kf_ICStockBill_CheckKF " + omodel.HInterID + "," + oSub.HMaterID + "," + oSub.HWHID + "," + oSub.HSPID + ", 1", "gy_czygl"); |
| | | if (Ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | oCn.RollBack(); |
| | |
| | | return; |
| | | try |
| | | { |
| | | MessageBox.Show("gnsy:"+gnsy + "gnmc:"+ gnmc); |
| | | switch (gnsy.ToLower()) |
| | | { |
| | | case "gy_dotcheck"://ç¹æ£é¡¹ç® |
| | | Gy_DotCheck oGy_DotCheck = new Gy_DotCheck(); |
| | | oGy_DotCheck.MdiParent = oMain; |
| | | oGy_DotCheck.Show(); |
| | | oMainForm.AddTabPage(oGy_DotCheck); |
| | | break; |
| | | case "gy_basedemo": |
| | | //æé |
| | | Gy_BaseDemo oGy_BaseDemo = new Gy_BaseDemo(); |
| | |
| | | oGy_QCCheckItem.Show(); |
| | | oMainForm.AddTabPage(oGy_QCCheckItem); |
| | | break; |
| | | |
| | | case "": |
| | | // |
| | | break; |
| | |
| | | <AssemblyName>LMES</AssemblyName> |
| | | <TargetFrameworkVersion>v4.0</TargetFrameworkVersion> |
| | | <FileAlignment>512</FileAlignment> |
| | | <IsWebBootstrapper>false</IsWebBootstrapper> |
| | | <PublishUrl>publish\</PublishUrl> |
| | | <Install>true</Install> |
| | | <InstallFrom>Disk</InstallFrom> |
| | | <UpdateEnabled>false</UpdateEnabled> |
| | | <UpdateMode>Foreground</UpdateMode> |
| | | <UpdateInterval>7</UpdateInterval> |
| | | <UpdateIntervalUnits>Days</UpdateIntervalUnits> |
| | | <UpdatePeriodically>false</UpdatePeriodically> |
| | | <UpdateRequired>false</UpdateRequired> |
| | | <MapFileExtensions>true</MapFileExtensions> |
| | | <ApplicationRevision>0</ApplicationRevision> |
| | | <ApplicationVersion>1.0.0.%2a</ApplicationVersion> |
| | | <UseApplicationTrust>false</UseApplicationTrust> |
| | | <BootstrapperEnabled>true</BootstrapperEnabled> |
| | | </PropertyGroup> |
| | | <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' "> |
| | | <PlatformTarget>AnyCPU</PlatformTarget> |
| | |
| | | <Name>WorkM</Name> |
| | | </ProjectReference> |
| | | </ItemGroup> |
| | | <ItemGroup> |
| | | <BootstrapperPackage Include="Microsoft.Net.Framework.3.5.SP1"> |
| | | <Visible>False</Visible> |
| | | <ProductName>.NET Framework 3.5 SP1</ProductName> |
| | | <Install>false</Install> |
| | | </BootstrapperPackage> |
| | | </ItemGroup> |
| | | <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" /> |
| | | <!-- To modify your build process, add your task inside one of the targets below and uncomment it. |
| | | Other similar extension points exist, see Microsoft.Common.targets. |
New file |
| | |
| | | <?xml version="1.0" encoding="utf-8"?> |
| | | <Project ToolsVersion="Current" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> |
| | | <PropertyGroup> |
| | | <PublishUrlHistory /> |
| | | <InstallUrlHistory /> |
| | | <SupportUrlHistory /> |
| | | <UpdateUrlHistory /> |
| | | <BootstrapperUrlHistory /> |
| | | <ErrorReportUrlHistory /> |
| | | <FallbackCulture>zh-CN</FallbackCulture> |
| | | <VerifyUploadedFiles>false</VerifyUploadedFiles> |
| | | </PropertyGroup> |
| | | </Project> |
| | |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldMaintainRuleBillSub_Item.cs" /> |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldMoveStockStepOutBillSub.cs" /> |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldMoveStockStepOutBillMain.cs" /> |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldScrapInBillMain.cs" /> |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldScrapInBillSub.cs" /> |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldRepairOutBillMain.cs" /> |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldRepairInBillMain.cs" /> |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldOtherInBillMain.cs" /> |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldRepairOutBillSub.cs" /> |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldRepairInBillSub.cs" /> |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldOtherInBillSub.cs" /> |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldOtherOutBillMain.cs" /> |
| | | <Compile Include="ç产管ç\模å
·ç®¡ç\ClsSc_MouldOtherOutBillSub.cs" /> |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Text; |
| | | |
| | | namespace Model |
| | | { |
| | | public class ClsSc_MouldRepairInBillMain : DBUtility.ClsXt_BaseBillMain |
| | | { |
| | | public Int64 HSupID;// int --ä¾åºå |
| | | public Int64 HWHID;// int --ä»åº |
| | | public Int64 HSCWHID;// int --è°åºä»åº |
| | | public Int64 HEmpID;// int --ä¸å¡å |
| | | public Int64 HManagerID;// int --è´è´£äºº |
| | | public Int64 HSecManagerID;// int --éªæ¶ |
| | | public Int64 HKeeperID;// int --ä¿ç®¡å |
| | | public Int64 HDeptID;// int --é¨é¨ |
| | | public string HExplanation;// varchar(200) --ÕªÒª |
| | | public string HInnerBillNo;// varchar(50) --å
é¨åæ®å· |
| | | public string HRemark; //å å·¥è¦æ± |
| | | public bool HRedBlueFlag;// bit --红èå |
| | | } |
| | | } |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Text; |
| | | |
| | | namespace Model |
| | | { |
| | | public class ClsSc_MouldRepairInBillSub : DBUtility.ClsXt_BaseBillSub |
| | | { |
| | | public DateTime HEntryCloseDate;// datetime --è¡å
³é (é»è®¤ä¸º'') new |
| | | public string HRemark;// varchar(200) --夿³¨ |
| | | public Int64 HMaterID;// int --ç©æID |
| | | public Int64 HPropertyID;// int --è¾
å©å±æ§ |
| | | public Int64 HSecUnitID;// int --è¾
å©è®¡éåä½ |
| | | public Single HSecUnitRate;// money --æ¢ç®ç |
| | | public Int64 HUnitID;// int --计éåä½ |
| | | public double HDesignLife;// dec(18,8) --è®¾è®¡å¯¿å½ |
| | | public double HLeaveLife;// dec(18,8) --å©ä½å¯¿å½ |
| | | public double HUseLifeQty;// dec(18,8) --æ¬æ¬¡ä½¿ç¨å¯¿å½ |
| | | public double HUseLife;// dec(18,8) --使ç¨å¯¿å½ |
| | | public double HQtyMust;// dec(18,8) --åºæ¶æ°é |
| | | public double HQty;// dec(18,8) --宿¶æ°é |
| | | public double HPrice;// dec(18,8) --åä»· |
| | | public double HMoney;// dec(18,8) --éé¢ |
| | | public Int64 HWHID;// int --æ¶æä»åº |
| | | public Int64 HSCWHID;// int --è°åºä»åºID |
| | | public Int64 HSPID;// int --ä»ä½ID |
| | | public Int64 HSCSPID;// int --è°åºä»ä½ID |
| | | public Int64 HSPGroupID;// int --ä»ä½ç»ID(ä»åºéæ©å®èªå¨å¸¦åº) |
| | | public string HBatchNo;// varchar(50) --æ¹æ¬¡ |
| | | public string HEngineNum;// varchar(50) --å卿ºå· |
| | | public string HUnderPanNum;// varchar(50) --å°çå· |
| | | public string HLeaveFactCard;// varchar(50) --åºåè¯ |
| | | public Int64 HPOOrderInterID;// int --éè´è®¢å主å
ç |
| | | public Int64 HPOOrderEntryID;// int --éè´è®¢ååå
ç |
| | | public string HPOOrderBillNo;// varchar(50) --éè´è®¢åå· |
| | | public Int64 HSeOrderInterID;// int --éå®è®¢å主å
ç |
| | | public Int64 HSeOrderEntryID;// int --éå®è®¢ååå
ç |
| | | public string HSeOrderBillNo;// varchar(50) --éå®è®¢åå· |
| | | public string HBarCode; |
| | | |
| | | public string HNewModel;// varchar(100) --æ°è§æ ¼ addnew |
| | | public string HWallThickness;// varchar(100) --å£å addnew |
| | | public string HHardness;// varchar(100) --硬度 addnew |
| | | public string HLastProdModel;// varchar(100) --æåç产产å addnew |
| | | public string HDiameter;// varchar(100) --ç´å¾ addnew |
| | | public string HBackFlag;// varchar(100)--éåºç±»åï¼æ£å¸¸ä½¿ç¨ï¼è°è¯ä¸åæ ¼ï¼ addnew |
| | | |
| | | public string HInitModel; |
| | | public Single HInitDesignLife; |
| | | public Int64 HLifeUnitID; |
| | | public Int64 HMouldType; |
| | | public double HNewLifeQty; |
| | | |
| | | } |
| | | } |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Text; |
| | | |
| | | namespace Model |
| | | { |
| | | public class ClsSc_MouldRepairOutBillMain : DBUtility.ClsXt_BaseBillMain |
| | | { |
| | | public Int64 HSupID;// int --ä¾åºå |
| | | public Int64 HWHID;// int --ä»åº |
| | | public Int64 HSCWHID;// int --è°åºä»åº |
| | | public Int64 HEmpID;// int --ä¸å¡å |
| | | public Int64 HManagerID;// int --è´è´£äºº |
| | | public Int64 HSecManagerID;// int --éªæ¶ |
| | | public Int64 HKeeperID;// int --ä¿ç®¡å |
| | | public Int64 HDeptID;// int --é¨é¨ |
| | | public string HExplanation;// varchar(200) --ÕªÒª |
| | | public string HInnerBillNo;// varchar(50) --å
é¨åæ®å· |
| | | public string HRemark; //å å·¥è¦æ± |
| | | public bool HRedBlueFlag;// bit --红èå |
| | | } |
| | | } |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Text; |
| | | |
| | | namespace Model |
| | | { |
| | | public class ClsSc_MouldRepairOutBillSub : DBUtility.ClsXt_BaseBillSub |
| | | { |
| | | public DateTime HEntryCloseDate;// datetime --è¡å
³é (é»è®¤ä¸º'') new |
| | | public string HRemark;// varchar(200) --夿³¨ |
| | | public Int64 HMaterID;// int --ç©æID |
| | | public Int64 HPropertyID;// int --è¾
å©å±æ§ |
| | | public Int64 HSecUnitID;// int --è¾
å©è®¡éåä½ |
| | | public Single HSecUnitRate;// money --æ¢ç®ç |
| | | public Int64 HUnitID;// int --计éåä½ |
| | | public double HDesignLife;// dec(18,8) --è®¾è®¡å¯¿å½ |
| | | public double HLeaveLife;// dec(18,8) --å©ä½å¯¿å½ |
| | | public double HUseLifeQty;// dec(18,8) --æ¬æ¬¡ä½¿ç¨å¯¿å½ |
| | | public double HUseLife;// dec(18,8) --使ç¨å¯¿å½ |
| | | public double HQtyMust;// dec(18,8) --åºæ¶æ°é |
| | | public double HQty;// dec(18,8) --宿¶æ°é |
| | | public double HPrice;// dec(18,8) --åä»· |
| | | public double HMoney;// dec(18,8) --éé¢ |
| | | public Int64 HWHID;// int --æ¶æä»åº |
| | | public Int64 HSCWHID;// int --è°åºä»åºID |
| | | public Int64 HSPID;// int --ä»ä½ID |
| | | public Int64 HSCSPID;// int --è°åºä»ä½ID |
| | | public Int64 HSPGroupID;// int --ä»ä½ç»ID(ä»åºéæ©å®èªå¨å¸¦åº) |
| | | public string HBatchNo;// varchar(50) --æ¹æ¬¡ |
| | | public string HEngineNum;// varchar(50) --å卿ºå· |
| | | public string HUnderPanNum;// varchar(50) --å°çå· |
| | | public string HLeaveFactCard;// varchar(50) --åºåè¯ |
| | | public Int64 HPOOrderInterID;// int --éè´è®¢å主å
ç |
| | | public Int64 HPOOrderEntryID;// int --éè´è®¢ååå
ç |
| | | public string HPOOrderBillNo;// varchar(50) --éè´è®¢åå· |
| | | public Int64 HSeOrderInterID;// int --éå®è®¢å主å
ç |
| | | public Int64 HSeOrderEntryID;// int --éå®è®¢ååå
ç |
| | | public string HSeOrderBillNo;// varchar(50) --éå®è®¢åå· |
| | | public string HBarCode; |
| | | |
| | | public string HNewModel;// varchar(100) --æ°è§æ ¼ addnew |
| | | public string HWallThickness;// varchar(100) --å£å addnew |
| | | public string HHardness;// varchar(100) --硬度 addnew |
| | | public string HLastProdModel;// varchar(100) --æåç产产å addnew |
| | | public string HDiameter;// varchar(100) --ç´å¾ addnew |
| | | public string HBackFlag;// varchar(100)--éåºç±»åï¼æ£å¸¸ä½¿ç¨ï¼è°è¯ä¸åæ ¼ï¼ addnew |
| | | |
| | | public string HInitModel; |
| | | public Single HInitDesignLife; |
| | | public Int64 HLifeUnitID; |
| | | public Int64 HMouldType; |
| | | public double HNewLifeQty; |
| | | |
| | | } |
| | | } |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Text; |
| | | |
| | | namespace Model |
| | | { |
| | | public class ClsSc_MouldScrapInBillMain : DBUtility.ClsXt_BaseBillMain |
| | | { |
| | | public Int64 HSupID;// int --ä¾åºå |
| | | public Int64 HWHID;// int --ä»åº |
| | | public Int64 HSCWHID;// int --è°åºä»åº |
| | | public Int64 HEmpID;// int --ä¸å¡å |
| | | public Int64 HManagerID;// int --è´è´£äºº |
| | | public Int64 HSecManagerID;// int --éªæ¶ |
| | | public Int64 HKeeperID;// int --ä¿ç®¡å |
| | | public Int64 HDeptID;// int --é¨é¨ |
| | | public string HExplanation;// varchar(200) --ÕªÒª |
| | | public string HInnerBillNo;// varchar(50) --å
é¨åæ®å· |
| | | public string HRemark; //å å·¥è¦æ± |
| | | public bool HRedBlueFlag;// bit --红èå |
| | | } |
| | | } |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Text; |
| | | |
| | | namespace Model |
| | | { |
| | | public class ClsSc_MouldScrapInBillSub : DBUtility.ClsXt_BaseBillSub |
| | | { |
| | | public DateTime HEntryCloseDate;// datetime --è¡å
³é (é»è®¤ä¸º'') new |
| | | public string HRemark;// varchar(200) --夿³¨ |
| | | public Int64 HMaterID;// int --ç©æID |
| | | public Int64 HPropertyID;// int --è¾
å©å±æ§ |
| | | public Int64 HSecUnitID;// int --è¾
å©è®¡éåä½ |
| | | public Single HSecUnitRate;// money --æ¢ç®ç |
| | | public Int64 HUnitID;// int --计éåä½ |
| | | public double HDesignLife;// dec(18,8) --è®¾è®¡å¯¿å½ |
| | | public double HLeaveLife;// dec(18,8) --å©ä½å¯¿å½ |
| | | public double HUseLifeQty;// dec(18,8) --æ¬æ¬¡ä½¿ç¨å¯¿å½ |
| | | public double HUseLife;// dec(18,8) --使ç¨å¯¿å½ |
| | | public double HQtyMust;// dec(18,8) --åºæ¶æ°é |
| | | public double HQty;// dec(18,8) --宿¶æ°é |
| | | public double HPrice;// dec(18,8) --åä»· |
| | | public double HMoney;// dec(18,8) --éé¢ |
| | | public Int64 HWHID;// int --æ¶æä»åº |
| | | public Int64 HSCWHID;// int --è°åºä»åºID |
| | | public Int64 HSPID;// int --ä»ä½ID |
| | | public Int64 HSCSPID;// int --è°åºä»ä½ID |
| | | public Int64 HSPGroupID;// int --ä»ä½ç»ID(ä»åºéæ©å®èªå¨å¸¦åº) |
| | | public string HBatchNo;// varchar(50) --æ¹æ¬¡ |
| | | public string HEngineNum;// varchar(50) --å卿ºå· |
| | | public string HUnderPanNum;// varchar(50) --å°çå· |
| | | public string HLeaveFactCard;// varchar(50) --åºåè¯ |
| | | public Int64 HPOOrderInterID;// int --éè´è®¢å主å
ç |
| | | public Int64 HPOOrderEntryID;// int --éè´è®¢ååå
ç |
| | | public string HPOOrderBillNo;// varchar(50) --éè´è®¢åå· |
| | | public Int64 HSeOrderInterID;// int --éå®è®¢å主å
ç |
| | | public Int64 HSeOrderEntryID;// int --éå®è®¢ååå
ç |
| | | public string HSeOrderBillNo;// varchar(50) --éå®è®¢åå· |
| | | public string HBarCode; |
| | | |
| | | public string HNewModel;// varchar(100) --æ°è§æ ¼ addnew |
| | | public string HWallThickness;// varchar(100) --å£å addnew |
| | | public string HHardness;// varchar(100) --硬度 addnew |
| | | public string HLastProdModel;// varchar(100) --æåç产产å addnew |
| | | public string HDiameter;// varchar(100) --ç´å¾ addnew |
| | | public string HBackFlag;// varchar(100)--éåºç±»åï¼æ£å¸¸ä½¿ç¨ï¼è°è¯ä¸åæ ¼ï¼ addnew |
| | | |
| | | public string HInitModel; |
| | | public Single HInitDesignLife; |
| | | public Int64 HLifeUnitID; |
| | | public Int64 HMouldType; |
| | | public double HNewLifeQty; |
| | | |
| | | } |
| | | } |
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 |
| | | { |
| | | public class Gy_ClassTimePrjController : ApiController |
| | | { |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
| | | |
| | | private json objJsonResult = new json(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | | |
| | | |
| | | /// <summary> |
| | | /// è¿åå表 |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Gy_ClassTimePrj/list")] |
| | | [HttpGet] |
| | | public object list(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_ClassTimePrjList where 1=1 ", "h_v_Gy_ClassTimePrjList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_ClassTimePrjList where 1=1 "; |
| | | string sql = sql1 + sWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_ClassTimePrjList"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "falseï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | /// <summary> |
| | | /// æ ¹æ®åºç¡èµæID æ¥æ¾è®°å½ |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Gy_ClassTimePrj/cx")] |
| | | [HttpGet] |
| | | public object cx(long HInterID) |
| | | { |
| | | try |
| | | { |
| | | |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_ClassTimePrjList where HitemID=" + HInterID, "h_v_Gy_ClassTimePrjList"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "falseï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | // |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// æ°å¢åæ®-ä¿åæé® |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Gy_ClassTimePrj/AddNew")] |
| | | [HttpPost] |
| | | public object AddNew([FromBody] JObject oMain) |
| | | { |
| | | try |
| | | { |
| | | var _value = oMain["oMain"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | //ååºåå |
| | | msg1 = "[" + msg1.ToString() + "]"; |
| | | |
| | | DAL.ClsGy_ClassTimePrj_Ctl oDept = new DAL.ClsGy_ClassTimePrj_Ctl(); |
| | | DAL.ClsGy_ClassTimePrj_View oDeptHlp = new DAL.ClsGy_ClassTimePrj_View(); |
| | | List<Gy_ClassTimePrj> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_ClassTimePrj>>(msg1); |
| | | |
| | | long HItemID = list[0].HItemID; |
| | | string HNumber = list[0].HNumber; |
| | | string HName = list[0].HName; |
| | | long HParentID = list[0].HParentID; ; |
| | | long HDeptID = list[0].HDeptID; ; |
| | | long HGroupID = list[0].HGroupID; |
| | | bool HStopflag = list[0].HStopflag; |
| | | string HRemark = list[0].HRemark; |
| | | |
| | | if (!DBUtility.ClsPub.AllowNumber(HNumber)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "代ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //è¥MAINDIéå¤åéæ°è·å |
| | | oCN.BeginTran(); |
| | | //主表 |
| | | oCN.RunProc("Insert into Gy_ClassTimePrj" + |
| | | " (HNumber,HName,HParentID" + |
| | | ",HStopflag,HRemark,HDeptID,HGroupID) " + |
| | | " Values('" + HNumber + "','" + HName + "'," + HParentID.ToString() + |
| | | "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HDeptID.ToString() + "," + HGroupID.ToString() + ")" |
| | | , ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCN.RunProc("Update Gy_ClassTimePrj set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "æ°å¢åæ®æåï¼"; |
| | | //objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.Message; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// ä¿åæé® |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Gy_ClassTimePrj/ModifyByID")] |
| | | [HttpPost] |
| | | public object ModifyByID([FromBody] JObject oMain) |
| | | { |
| | | try |
| | | { |
| | | DAL.ClsGy_ClassTimePrj_Ctl oDept = new DAL.ClsGy_ClassTimePrj_Ctl(); |
| | | DAL.ClsGy_ClassTimePrj_View oDeptHlp = new DAL.ClsGy_ClassTimePrj_View(); |
| | | |
| | | var _value = oMain["oMain"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | //string msg3 = sArray[1].ToString(); |
| | | //string msg4 = sArray[2].ToString(); |
| | | //string msg5 = sArray[3].ToString(); |
| | | //ååºåå |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | | List<Gy_ClassTimePrj> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_ClassTimePrj>>(msg2);//è¿å¥æé®é¢ |
| | | |
| | | long HItemID = list[0].HItemID; |
| | | string HNumber = list[0].HNumber; |
| | | string HName = list[0].HName; |
| | | long HParentID = list[0].HParentID; ; |
| | | long HDeptID = list[0].HDeptID; ; |
| | | long HGroupID = list[0].HGroupID; |
| | | bool HStopflag = list[0].HStopflag; |
| | | string HRemark = list[0].HRemark; |
| | | |
| | | ////夿æé |
| | | //if (!ClsPub.Security_Log(msg5, 1, true, msg4)) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "æ²¡ææ¾å°è¯¥åè½æ¨¡åï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | //if (!DBUtility.ClsPub.AllowNumber(HNumber)) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "代ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | //if (oDept.HavSameNumber(HItemID, HNumber)) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "代ç éå¤ï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | //ä¿å |
| | | //ä¿å宿¯åå¤ç |
| | | if (HItemID == 0) |
| | | { |
| | | oCN.BeginTran(); |
| | | oCN.RunProc("Insert into Gy_ClassTimePrj" + |
| | | " (HNumber,HName,HParentID" + |
| | | ",HStopflag,HRemark,HDeptID,HGroupID) " + |
| | | " Values('" + HNumber + "','" + HName + "'," + HParentID.ToString() + |
| | | "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HDeptID.ToString() + "," + HGroupID.ToString() + ")" |
| | | , ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCN.RunProc("Update Gy_ClassTimePrj set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | | } |
| | | else { |
| | | //è¥MAINDIéå¤åéæ°è·å |
| | | oCN.BeginTran(); |
| | | //主表 |
| | | oCN.RunProc("Update Gy_Warehouse set " + |
| | | " HNumber='" + HNumber + "'" + |
| | | ",HName='" + HName + "'" + |
| | | ",HParentID=" + HParentID.ToString() + |
| | | ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + |
| | | ",HDeptID=" + HDeptID.ToString() + |
| | | ",HGroupID=" + HGroupID.ToString() + |
| | | ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹å项ç®ä»£ç |
| | | //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Warehouse,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //å°ä¸çº§ ä¸ºéæ«çº§ |
| | | oCN.RunProc("Update Gy_ClassTimePrj set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | // |
| | | oCN.Commit(); |
| | | } |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ä¿åæåï¼"; |
| | | //WebAPIController.Add_Log("éè´§å䏿¨", UserName, "çæéè´§å"); |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.Message; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | /// <summary> |
| | | /// ä»åºå表å é¤åè½ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("DeltetGy_ClassTimePrj")] |
| | | [HttpGet] |
| | | public object DeltetGy_ClassTimePrj(string HItemID) |
| | | { |
| | | DataSet ds; |
| | | DataSet ds1; |
| | | try |
| | | { |
| | | //å 餿é |
| | | //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "å®¡æ ¸å¤±è´¥ï¼æ æéï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (string.IsNullOrWhiteSpace(HItemID)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "HItemID为空ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | oCN.BeginTran();//å¼å§äºå¡ |
| | | ds = oCN.RunProcReturn("select * from Gy_ClassTimePrj where HItemID=" + HItemID, "Gy_ClassTimePrj"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ²¡ææ°æ®ï¼æ æ³å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | } |
| | | //var HStopflag = Convert.ToBoolean(ds.Tables[0].Rows[0]["HStopflag"]); |
| | | //if (HStopflag) |
| | | //{ |
| | | // oCN.RollBack();//åæ»äºå¡ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "æ°æ®å·²å 餿 æ³å次å é¤ï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | ds1 = oCN.RunProcReturn("Select HItemID from Gy_ClassTimePrj Where HParentID='" + HItemID + "'", "Gy_ClassTimePrj"); |
| | | if (ds1.Tables[0].Rows.Count != 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¤é¡¹ç®åå¨å项ç®ï¼ä¸è½å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | string HUseFlag = Convert.ToString(ds.Tables[0].Rows[0]["HUseFlag"]); |
| | | if (HUseFlag == "已使ç¨") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¤é¡¹ç®å·²ä½¿ç¨ï¼ä¸è½å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | oCN.RunProc("delete from Gy_ClassTimePrj where HItemID=" + HItemID); |
| | | oCN.Commit();//æäº¤äºå¡ |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "* æ°æ®å 餿åï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å é¤å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | } |
| | | } |
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 |
| | | { |
| | | public class Xt_DataDictionary_ProcController : ApiController |
| | | { |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
| | | |
| | | private json objJsonResult = new json(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | | |
| | | |
| | | /// <summary> |
| | | /// è¿åå表 |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Xt_DataDictionary_Proc/list")] |
| | | [HttpGet] |
| | | public object list(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_DataDictionary_Proc where 1=1 ", "h_v_IF_DataDictionary_Proc"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_DataDictionary_Proc where 1=1 "; |
| | | string sql = sql1 + sWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_DataDictionary_Proc"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "falseï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// æ ¹æ®åºç¡èµæID æ¥æ¾è®°å½ |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Xt_DataDictionary_Proc/cx")] |
| | | [HttpGet] |
| | | public object cx(long HInterID) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_DataDictionary_ProcDetail where HitemID = " + HInterID, "h_v_IF_DataDictionary_ProcDetail"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "falseï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// å é¤åè½ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("DeltetXt_DataDictionary_Proc")] |
| | | [HttpGet] |
| | | public object DeltetXt_DataDictionary_Proc(string HItemID) |
| | | { |
| | | DataSet ds; |
| | | //DataSet ds1; |
| | | try |
| | | { |
| | | //å 餿é |
| | | //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "å®¡æ ¸å¤±è´¥ï¼æ æéï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (string.IsNullOrWhiteSpace(HItemID)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "HItemID为空ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | oCN.BeginTran();//å¼å§äºå¡ |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_DataDictionary_Proc where HItemID=" + HItemID, "h_v_IF_DataDictionary_Proc"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ²¡ææ°æ®ï¼æ æ³å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | } |
| | | //ds1 = oCN.RunProcReturn("Select HItemID from h_v_IF_DataDictionary_View Where HParentID='" + HItemID + "'", "h_v_IF_DataDictionary_View"); |
| | | //if (ds1.Tables[0].Rows.Count != 0) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "æ¤é¡¹ç®åå¨å项ç®ï¼ä¸è½å é¤ï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | |
| | | oCN.RunProc("delete from h_v_IF_DataDictionary_Proc where HItemID=" + HItemID); |
| | | oCN.Commit();//æäº¤äºå¡ |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "* æ°æ®å 餿åï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å é¤å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// ç¦ç¨æé® |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Xt_DataDictionary_Proc/JY_Json")] |
| | | [HttpGet] |
| | | public object JY_Json(long HItemID) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("update Xt_DataDictionary_Proc set HStopFlag = 1 where HItemID = " + HItemID, "Xt_DataDictionary_Proc"); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ç¦ç¨æå"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// åç¦ç¨æé® |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Xt_DataDictionary_Proc/FJY_Json")] |
| | | [HttpGet] |
| | | public object FJY_Json(long HItemID) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("update Xt_DataDictionary_Proc set HStopFlag = 0 where HItemID = " + HItemID, "Xt_DataDictionary_Proc"); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "åç¦ç¨æå"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | ///// <summary> |
| | | ///// æ°å¢åæ®-ä¿åæé® |
| | | /////åæ°ï¼string sqlã |
| | | /////è¿åå¼ï¼objectã |
| | | ///// </summary> |
| | | //[Route("Xt_DataDictionary_View/AddBill")] |
| | | //[HttpPost] |
| | | //public object AddBill([FromBody] JObject oMain) |
| | | //{ |
| | | // try |
| | | // { |
| | | // var _value = oMain["oMain"].ToString(); |
| | | // string msg1 = _value.ToString(); |
| | | // //ååºåå |
| | | // msg1 = "[" + msg1.ToString() + "]"; |
| | | |
| | | // //DAL.ClsGy_Department_Ctl oDept = new DAL.ClsGy_Department_Ctl(); |
| | | // //DAL.ClsGy_Department_View oDeptHlp = new DAL.ClsGy_Department_View(); |
| | | |
| | | |
| | | |
| | | // List<Xt_DataDictionary_View> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Xt_DataDictionary_View>>(msg1); |
| | | |
| | | // long HItemID = list[0].HItemID; |
| | | // long HModNameID = list[0].HModNameID; |
| | | // long HBillTypeID = list[0].HBillTypeID; |
| | | // string HViewName = list[0].HViewName; |
| | | // string HViewCaption = list[0].HViewCaption; |
| | | // string HRemark = list[0].HRemark; |
| | | // bool HStopflag = list[0].HStopflag; |
| | | // DateTime HMakeTime = list[0].HMakeTime; |
| | | // string HMakeEmp = list[0].HMakeEmp; |
| | | // DateTime HModifyTime = list[0].HModifyTime; |
| | | // string HModifyEmp = list[0].HModifyEmp; |
| | | |
| | | |
| | | // //è¥MAINDIéå¤åéæ°è·å |
| | | // oCN.BeginTran(); |
| | | // //主表 |
| | | // oCN.RunProc("Insert Into Xt_DataDictionary_View " + |
| | | // "(HModNameID,HBillTypeID,HViewName,HViewCaption,HRemark" + |
| | | // ",HStopflag,HMakeTime,HMakeEmp,HModifyTime" + |
| | | // ",HModifyEmp" + |
| | | // ") " + |
| | | // " values(" + HModNameID + "," + HBillTypeID + "," + HBillTypeID + ",'" + HViewName + "','" + HViewCaption + "'"+ |
| | | // ",'" + HRemark + "'," + Convert.ToString(HStopflag ? 1 : 0) + "" + |
| | | // ",'" + HMakeTime + "','" + HMakeEmp + "','" + HModifyTime + "','" + HModifyEmp + "'" + |
| | | // ") "); |
| | | // //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | // objJsonResult.code = "1"; |
| | | // objJsonResult.count = 1; |
| | | // objJsonResult.Message = null; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | // } |
| | | // catch (Exception e) |
| | | // { |
| | | // oCN.RollBack(); |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "Exceptionï¼" + e.Message; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | // } |
| | | //} |
| | | |
| | | |
| | | /// <summary> |
| | | /// ä¿åæé® |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Xt_DataDictionary_Proc/AddBill1")] |
| | | [HttpPost] |
| | | public object AddBill1([FromBody] JObject oMain) |
| | | { |
| | | |
| | | try |
| | | { |
| | | //DAL.ClsGy_Department_Ctl oDept = new DAL.ClsGy_Department_Ctl(); |
| | | //DAL.ClsGy_Department_View oDeptHlp = new DAL.ClsGy_Department_View(); |
| | | |
| | | var _value = oMain["oMain"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | //string msg3 = sArray[1].ToString(); |
| | | //string msg4 = sArray[2].ToString(); |
| | | //string msg5 = sArray[3].ToString(); |
| | | //ååºåå |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | | List<Xt_DataDictionary_Proc> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Xt_DataDictionary_Proc>>(msg2); |
| | | |
| | | long HItemID = list[0].HItemID; |
| | | long HModNameID = list[0].HModNameID; |
| | | long HBillTypeID = list[0].HBillTypeID; |
| | | string HProcName = list[0].HProcName; |
| | | string HProcCaption = list[0].HProcCaption; |
| | | string HRemark = list[0].HRemark; |
| | | bool HStopflag = list[0].HStopflag; |
| | | DateTime HMakeTime = list[0].HMakeTime; |
| | | string HMakeEmp = list[0].HMakeEmp; |
| | | DateTime HModifyTime = list[0].HModifyTime; |
| | | string HModifyEmp = list[0].HModifyEmp; |
| | | |
| | | //ä¿å |
| | | //ä¿å宿¯åå¤ç |
| | | if (HItemID == 0) |
| | | { |
| | | //æ°å¢ |
| | | oCN.BeginTran(); |
| | | oCN.RunProc("Insert Into Xt_DataDictionary_Proc " + |
| | | "(HModNameID,HBillTypeID,HProcName,HProcCaption,HRemark" + |
| | | ",HStopflag,HMakeTime,HMakeEmp,HModifyTime" + |
| | | ",HModifyEmp" + |
| | | ") " + |
| | | " values(" + HModNameID + "," + HBillTypeID + ",'" + HProcName + "','" + HProcCaption + "'" + |
| | | ",'" + HRemark + "'," + Convert.ToString(HStopflag ? 1 : 0) + "" + |
| | | ",'" + HMakeTime + "','" + HMakeEmp + "','" + HModifyTime + "','" + HModifyEmp + "'" + |
| | | ") ", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCN.RunProc("Update Xt_DataDictionary_Proc set HStopflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | | } |
| | | else |
| | | { |
| | | oCN.BeginTran(); |
| | | //主表 |
| | | oCN.RunProc("Update Xt_DataDictionary_Proc set " + |
| | | " HModNameID= "+ HModNameID + |
| | | " HBillTypeID= " + HBillTypeID + |
| | | ",HProcName='" + HProcName + "'" + |
| | | ",HProcCaption='" + HProcCaption + "'" + |
| | | ",HRemark='" + HRemark + "'" + |
| | | ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + |
| | | ",HMakeTime='" + HMakeTime + "'" + |
| | | ",HMakeEmp='" + HMakeEmp + "'" + |
| | | ",HModifyTime='" + HModifyTime + "'" + |
| | | ",HModifyEmp='" + HModifyEmp + "'" + |
| | | //",HUpdater='" + HUpdater + "'" + |
| | | //",HUpdateDate= getdate()" + |
| | | ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹å项ç®ä»£ç |
| | | //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Department,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //å°ä¸çº§ ä¸ºéæ«çº§ |
| | | oCN.RunProc("Update Xt_DataDictionary_Proc set HStopflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | | } |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ä¿åæåï¼"; |
| | | //WebAPIController.Add_Log("éè´§å䏿¨", UserName, "çæéè´§å"); |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.Message; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | // |
| | | } |
| | | } |
| | |
| | | |
| | | |
| | | /// <summary> |
| | | /// è¿åé¨é¨å表 |
| | | /// è¿åå表 |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Xt_DataDictionary_Table/list")] |
| | | [HttpGet] |
| | | public object list(string sWhere,string Organization) |
| | | public object list(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | string sql1 = string.Format(@"select * from h_v_IF_DepartmentList where ç»ç»åç§°='" + Organization + "'"); |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn(sql1 + sWhere + "order by HItemID desc", "h_v_IF_DepartmentList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_DataDictionary_Table where 1=1 ", "h_v_IF_DataDictionary_Table"); |
| | | } |
| | | else |
| | | { |
| | | string sql = sql1 + sWhere + "order by HItemID desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_DepartmentList"); |
| | | string sql1 = "select * from h_v_IF_DataDictionary_Table where 1=1 "; |
| | | string sql = sql1 + sWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_DataDictionary_Table"); |
| | | } |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// æ ¹æ®åºç¡èµæID æ¥æ¾è®°å½ |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Gy_Department/cx")] |
| | | [HttpGet] |
| | | public object cx(long HInterID) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_DepartmentListDetail where HitemID = " + HInterID, "h_v_IF_DepartmentListDetail"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// é¨é¨å表å é¤åè½ |
| | | /// æ ¹æ®åºç¡èµæID æ¥æ¾è®°å½ |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Xt_DataDictionary_Table/cx")] |
| | | [HttpGet] |
| | | public object cx(long HInterID) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_DataDictionary_TableDetail where HitemID = " + HInterID, "h_v_IF_DataDictionary_TableDetail"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "falseï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// å é¤åè½ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("DeltetGy_Department")] |
| | | [Route("DeltetXt_DataDictionary_Table")] |
| | | [HttpGet] |
| | | public object DeltetGy_Department(string HItemID) |
| | | public object DeltetXt_DataDictionary_Table(string HItemID) |
| | | { |
| | | DataSet ds; |
| | | DataSet ds1; |
| | | //DataSet ds1; |
| | | try |
| | | { |
| | | //å 餿é |
| | |
| | | return objJsonResult; |
| | | } |
| | | oCN.BeginTran();//å¼å§äºå¡ |
| | | ds = oCN.RunProcReturn("select * from Gy_Department where HItemID=" + HItemID, "Gy_Department"); |
| | | ds = oCN.RunProcReturn("select * from Xt_DataDictionary_Table where HItemID=" + HItemID, "Xt_DataDictionary_Table"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | } |
| | | ds1 = oCN.RunProcReturn("Select HItemID from Gy_Department Where HParentID='" + HItemID + "'", "Gy_Department"); |
| | | if (ds1.Tables[0].Rows.Count != 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¤é¡¹ç®åå¨å项ç®ï¼ä¸è½å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | string HUseFlag = Convert.ToString(ds.Tables[0].Rows[0]["HUseFlag"]); |
| | | if (HUseFlag == "已使ç¨") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¤é¡¹ç®å·²ä½¿ç¨ï¼ä¸è½å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //v |
| | | //var HStopflag = Convert.ToBoolean(ds.Tables[0].Rows[0]["HStopflag"]); |
| | | //if (HStopflag) |
| | | //ds1 = oCN.RunProcReturn("Select HItemID from Xt_DataDictionary_Table Where HParentID='" + HItemID + "'", "Xt_DataDictionary_Table"); |
| | | //if (ds1.Tables[0].Rows.Count != 0) |
| | | //{ |
| | | // oCN.RollBack();//åæ»äºå¡ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "æ°æ®å·²å 餿 æ³å次å é¤ï¼"; |
| | | // objJsonResult.Message = "æ¤é¡¹ç®åå¨å项ç®ï¼ä¸è½å é¤ï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | oCN.RunProc("delete from Gy_Department where HItemID=" + HItemID); |
| | | |
| | | |
| | | oCN.RunProc("delete from Xt_DataDictionary_Table where HItemID=" + HItemID); |
| | | oCN.Commit();//æäº¤äºå¡ |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | |
| | | } |
| | | } |
| | | |
| | | //[Route("Gy_Department/LoadTree")] |
| | | //[HttpGet] |
| | | //public object LoadTree_Json() |
| | | //{ |
| | | // DBUtility.Gy_BaseFun.LoadTree(tv, imageList1, this.Text, BillName); |
| | | //} |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// é¨é¨å表ç¦ç¨æé® |
| | | /// ç¦ç¨æé® |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Gy_Department/JY_Json")] |
| | | [Route("Xt_DataDictionary_Table/JY_Json")] |
| | | [HttpGet] |
| | | public object JY_Json(long HItemID) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("update Gy_Department set HStopFlag = 1 where HItemID = " + HItemID, "Gy_Department"); |
| | | ds = oCN.RunProcReturn("update Xt_DataDictionary_Table set HStopFlag = 1 where HItemID = " + HItemID, "Xt_DataDictionary_Table"); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | } |
| | | |
| | | /// <summary> |
| | | /// é¨é¨å表åç¦ç¨æé® |
| | | /// åç¦ç¨æé® |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Gy_Department/FJY_Json")] |
| | | [Route("Xt_DataDictionary_Table/FJY_Json")] |
| | | [HttpGet] |
| | | public object FJY_Json(long HItemID) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("update Gy_Department set HStopFlag = 0 where HItemID = " + HItemID, "Gy_Department"); |
| | | ds = oCN.RunProcReturn("update Xt_DataDictionary_Table set HStopFlag = 0 where HItemID = " + HItemID, "Xt_DataDictionary_Table"); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Gy_Department/AddBill")] |
| | | [Route("Xt_DataDictionary_Table/AddBill")] |
| | | [HttpPost] |
| | | public object AddBill([FromBody] JObject oMain) |
| | | { |
| | |
| | | //ååºåå |
| | | msg1 = "[" + msg1.ToString() + "]"; |
| | | |
| | | DAL.ClsGy_Department_Ctl oDept = new DAL.ClsGy_Department_Ctl(); |
| | | DAL.ClsGy_Department_View oDeptHlp = new DAL.ClsGy_Department_View(); |
| | | //DAL.ClsGy_Department_Ctl oDept = new DAL.ClsGy_Department_Ctl(); |
| | | //DAL.ClsGy_Department_View oDeptHlp = new DAL.ClsGy_Department_View(); |
| | | |
| | | |
| | | |
| | | List<Department> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Department>>(msg1); |
| | | List<Xt_DataDictionary_Table> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Xt_DataDictionary_Table>>(msg1); |
| | | |
| | | long HItemID = list[0].HItemID; |
| | | string HNumber = list[0].HNumber; |
| | | string HName = list[0].HName; |
| | | string HShortNumber = list[0].HShortNumber; |
| | | long HModNameID = list[0].HModNameID; |
| | | long HBillTypeID = list[0].HBillTypeID; |
| | | string HTableName = list[0].HTableName; |
| | | string HTableCaption = list[0].HTableCaption; |
| | | string HFieldName = list[0].HFieldName; |
| | | string HFieldCaption = list[0].HFieldCaption; |
| | | string HDataType = list[0].HDataType; |
| | | string HDefaultValue = list[0].HDefaultValue; |
| | | string HRemark = list[0].HRemark; |
| | | string HUseFlag = list[0].HUseFlag; |
| | | long HParentID = list[0].HParentID; |
| | | string HBarCode = list[0].HBarCode; |
| | | string HHelpCode = list[0].HHelpCode; |
| | | long HSecManagerID = list[0].HSecManagerID; |
| | | string HCreator = list[0].HCreator; |
| | | long HCreateOrgID = list[0].HCreateOrgID; |
| | | //DateTime HCreateDate = list[0].HCreateDate; |
| | | long HUseOrgID = list[0].HUseOrgID; |
| | | string HUpdater = list[0].HUpDater; |
| | | //DateTime HUpdateDate = list[0].HUpDateDate; |
| | | string HChecker = list[0].HChecker; |
| | | //DateTime HCheckDate = list[0].HCheckDate; |
| | | string HDeleteMan = list[0].HDeleteMan; |
| | | //DateTime HDeleteDate = list[0].HDeleteDate; |
| | | |
| | | |
| | | if (!DBUtility.ClsPub.AllowNumber(HNumber)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "代ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | bool HStopflag = list[0].HStopflag; |
| | | DateTime HMakeTime = list[0].HMakeTime; |
| | | string HMakeEmp = list[0].HMakeEmp; |
| | | DateTime HModifyTime = list[0].HModifyTime; |
| | | string HModifyEmp = list[0].HModifyEmp; |
| | | |
| | | |
| | | //è¥MAINDIéå¤åéæ°è·å |
| | | oCN.BeginTran(); |
| | | //主表 |
| | | oCN.RunProc("Insert Into Gy_Department " + |
| | | "(HNumber,HShortNumber,HName,HParentID" + |
| | | ",HLevel,HEndFlag,HRemark,HStopFlag,HUseFlag" + |
| | | ",HCREATEORGID,HUSEORGID,HBarCode,HCreator" + |
| | | ",HUpdater,HChecker,HDeleteMan" + |
| | | ",HSecManagerID,HCreateDate" + |
| | | oCN.RunProc("Insert Into Xt_DataDictionary_Table " + |
| | | "(HModNameID,HBillTypeID,HTableName,HTableCaption" + |
| | | ",HFieldName,HFieldCaption,HDataType,HDefaultValue,HRemark" + |
| | | ",HStopflag,HMakeTime,HMakeEmp,HModifyTime" + |
| | | ",HModifyEmp" + |
| | | ") " + |
| | | " values('" + HNumber + "','" + HShortNumber + "','" + HName + "',0" + |
| | | ",'',0,'" + HRemark + "',0,''" + |
| | | "," + HCreateOrgID + "," + HUseOrgID + ",'" + HBarCode + "','" + HCreator + "'" + |
| | | ",'" + HUpdater + "','" + HChecker + "','" + HDeleteMan + "'" + |
| | | "," + HSecManagerID + ", getdate()" + |
| | | " values(" + HModNameID + "," + HBillTypeID + ",'" + HTableName + "'"+ |
| | | ",'" + HTableCaption + "','" + HFieldName + "','" + HFieldCaption + "','" + HDataType + "'" + |
| | | ",'" + HDefaultValue + "','" + HRemark + "'," + Convert.ToString(HStopflag ? 1 : 0) + "" + |
| | | ",'" + HMakeTime + "','" + HMakeEmp + "','" + HModifyTime + "','" + HModifyEmp + "'" + |
| | | ") "); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCN.RunProc("Update Gy_Department set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "æ°å¢åæ®æåï¼"; |
| | | //objJsonResult.data = null; |
| | | objJsonResult.Message = null; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Gy_Department/AddBill1")] |
| | | [Route("Xt_DataDictionary_Table/AddBill1")] |
| | | [HttpPost] |
| | | public object AddBill1([FromBody] JObject oMain) |
| | | { |
| | | |
| | | try |
| | | { |
| | | DAL.ClsGy_Department_Ctl oDept = new DAL.ClsGy_Department_Ctl(); |
| | | DAL.ClsGy_Department_View oDeptHlp = new DAL.ClsGy_Department_View(); |
| | | //DAL.ClsGy_Department_Ctl oDept = new DAL.ClsGy_Department_Ctl(); |
| | | //DAL.ClsGy_Department_View oDeptHlp = new DAL.ClsGy_Department_View(); |
| | | |
| | | var _value = oMain["oMain"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | string msg3 = sArray[1].ToString(); |
| | | //string msg3 = sArray[1].ToString(); |
| | | //string msg4 = sArray[2].ToString(); |
| | | //string msg5 = sArray[3].ToString(); |
| | | //ååºåå |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | | List<Department> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Department>>(msg2); |
| | | List<Xt_DataDictionary_Table> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Xt_DataDictionary_Table>>(msg2); |
| | | |
| | | long HItemID = list[0].HItemID; |
| | | string HNumber = list[0].HNumber; |
| | | string HName = list[0].HName; |
| | | string HShortNumber = list[0].HShortNumber; |
| | | long HModNameID = list[0].HModNameID; |
| | | long HBillTypeID = list[0].HBillTypeID; |
| | | string HTableName = list[0].HTableName; |
| | | string HTableCaption = list[0].HTableCaption; |
| | | string HFieldName = list[0].HFieldName; |
| | | string HFieldCaption = list[0].HFieldCaption; |
| | | string HDataType = list[0].HDataType; |
| | | string HDefaultValue = list[0].HDefaultValue; |
| | | string HRemark = list[0].HRemark; |
| | | string HUseFlag = list[0].HUseFlag; |
| | | long HParentID = list[0].HParentID; |
| | | string HBarCode = list[0].HBarCode; |
| | | string HHelpCode = list[0].HHelpCode; |
| | | string HUpDater = list[0].HUpDater; |
| | | long HEmpID = list[0].HEmpID; |
| | | bool HStopflag = list[0].HStopflag; |
| | | long HSecManagerID = list[0].HSecManagerID; |
| | | //string HCreator = list[0].HCreator; |
| | | long HCreateOrgID = list[0].HCreateOrgID; |
| | | //DateTime HCreateDate = list[0].HCreateDate; |
| | | long HUseOrgID = list[0].HUseOrgID; |
| | | string HUpdater = list[0].HUpDater; |
| | | //DateTime HUpdateDate = list[0].HUpDateDate; |
| | | string HChecker = list[0].HChecker; |
| | | //DateTime HCheckDate = list[0].HCheckDate; |
| | | string HDeleteMan = list[0].HDeleteMan; |
| | | //DateTime HDeleteDate = list[0].HDeleteDate; |
| | | long HLevel = 1; |
| | | bool HEndFlag = true; |
| | | long HEntityID = 1; |
| | | |
| | | //夿æé |
| | | //if (!ClsPub.Security_Log(msg5, 1, true, msg4)) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "æ²¡ææ¾å°è¯¥åè½æ¨¡åï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | |
| | | //if (!DBUtility.ClsPub.AllowNumber(HNumber)) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "代ç ä¸ä¸è½åºç°è¿ç»â.âå¹¶ä¸é¦ä½æ«ä½ä¸è½ä¸ºâ.âï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | //if (oDept.HavSameNumber(HItemID, HNumber)) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "代ç éå¤ï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | DateTime HMakeTime = list[0].HMakeTime; |
| | | string HMakeEmp = list[0].HMakeEmp; |
| | | DateTime HModifyTime = list[0].HModifyTime; |
| | | string HModifyEmp = list[0].HModifyEmp; |
| | | |
| | | //ä¿å |
| | | //ä¿å宿¯åå¤ç |
| | |
| | | { |
| | | //æ°å¢ |
| | | oCN.BeginTran(); |
| | | oCN.RunProc("Insert into Gy_Department " + |
| | | " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HEmpID,HBarCodeForBase,HEntityID,HUSEORGID) " + |
| | | " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() + |
| | | "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HEmpID + ",'" + HBarCode + "'" + |
| | | "," + HEntityID.ToString() + "," + HUseOrgID + ")", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.RunProc("Insert Into Xt_DataDictionary_Table " + |
| | | "(HModNameID,HBillTypeID,HTableName,HTableCaption" + |
| | | ",HFieldName,HFieldCaption,HDataType,HDefaultValue,HRemark" + |
| | | ",HStopflag,HMakeTime,HMakeEmp,HModifyTime" + |
| | | ",HModifyEmp" + |
| | | ") " + " values(" + HModNameID + "," + HBillTypeID + ",'" + HTableName + "'" + |
| | | ",'" + HTableCaption + "','" + HFieldName + "','" + HFieldCaption + "','" + HDataType + "'" + |
| | | ",'" + HDefaultValue + "','" + HRemark + "'," + Convert.ToString(HStopflag ? 1 : 0) + "" + |
| | | ",'" + HMakeTime + "','" + HMakeEmp + "','" + HModifyTime + "','" + HModifyEmp + "'" + |
| | | ") ", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCN.RunProc("Update Gy_Department set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.RunProc("Update Xt_DataDictionary_Table set HStopflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | | } |
| | | else |
| | | { |
| | | oCN.BeginTran(); |
| | | //主表 |
| | | oCN.RunProc("Update Gy_Department set " + |
| | | " HNumber='" + HNumber + "'" + |
| | | ",HName='" + HName + "'" + |
| | | ",HHelpCode='" + HHelpCode + "'" + |
| | | ",HShortNumber='" + HShortNumber + "'" + |
| | | ",HParentID=" + HParentID + |
| | | ",HEmpID=" + HEmpID.ToString() + |
| | | oCN.RunProc("Update Xt_DataDictionary_Table set " + |
| | | " HModNameID= "+ HModNameID + |
| | | " HBillTypeID= " + HBillTypeID + |
| | | ",HTableName='" + HTableName + "'" + |
| | | ",HTableCaption='" + HTableCaption + "'" + |
| | | ",HFieldName='" + HFieldName + "'" + |
| | | ",HDataType='" + HDataType + "'" + |
| | | ",HFieldName='" + HFieldName + "'" + |
| | | ",HFieldCaption='" + HFieldCaption + "'" + |
| | | //",HRemark='" + HRemark + "'" + |
| | | ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + |
| | | ",HMakeTime='" + HMakeTime + "'" + |
| | | ",HMakeEmp='" + HMakeEmp + "'" + |
| | | ",HModifyTime='" + HModifyTime + "'" + |
| | | ",HModifyEmp='" + HModifyEmp + "'" + |
| | | //",HUpdater='" + HUpdater + "'" + |
| | | //",HUpdateDate= getdate()" + |
| | | ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹å项ç®ä»£ç |
| | | //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Department,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //å°ä¸çº§ ä¸ºéæ«çº§ |
| | | oCN.RunProc("Update Gy_Department set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.RunProc("Update Xt_DataDictionary_Table set HStopflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | | } |
| | | objJsonResult.code = "0"; |
| | |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// è·åæå¤§åºç¡èµæID |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Gy_Department/GetMAXBillID")] |
| | | [HttpGet] |
| | | public object GetMAXBillID() |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("select max(hitemid)+1 hitemid from Gy_Department", "Gy_Department"); |
| | | |
| | | 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 = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// é¨é¨åè¡¨ä¿®æ¹æé®æ¹æ³ |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Gy_Department/xg")] |
| | | [HttpGet] |
| | | public object xg(long HInterID) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("select * from Gy_Department where HItemID=" + HInterID, "Gy_Department"); |
| | | |
| | | 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 = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | [Route("Gy_Department/LoadTree")] |
| | | [HttpGet] |
| | | public object LoadTree_Json(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 * from h_v_DepartmentLoadTree", "h_v_DepartmentLoadTree"); |
| | | 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; |
| | | } |
| | | } |
| | | |
| | | |
| | | |
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 |
| | | { |
| | | public class Xt_DataDictionary_ViewController : ApiController |
| | | { |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
| | | |
| | | private json objJsonResult = new json(); |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | | |
| | | |
| | | /// <summary> |
| | | /// è¿åå表 |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Xt_DataDictionary_View/list")] |
| | | [HttpGet] |
| | | public object list(string sWhere) |
| | | { |
| | | try |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_DataDictionary_View where 1=1 ", "h_v_IF_DataDictionary_View"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_DataDictionary_View where 1=1 "; |
| | | string sql = sql1 + sWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_DataDictionary_View"); |
| | | } |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "falseï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// æ ¹æ®åºç¡èµæID æ¥æ¾è®°å½ |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Xt_DataDictionary_View/cx")] |
| | | [HttpGet] |
| | | public object cx(long HInterID) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_DataDictionary_ViewDetail where HitemID = " + HInterID, "h_v_IF_DataDictionary_ViewDetail"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "falseï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// å é¤åè½ |
| | | /// </summary> |
| | | /// <returns></returns> |
| | | [Route("DeltetXt_DataDictionary_View")] |
| | | [HttpGet] |
| | | public object DeltetXt_DataDictionary_View(string HItemID) |
| | | { |
| | | DataSet ds; |
| | | //DataSet ds1; |
| | | try |
| | | { |
| | | //å 餿é |
| | | //if (!DBUtility.ClsPub.Security_Log(ModRightNameCheck, 1, true, CurUserName)) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "å®¡æ ¸å¤±è´¥ï¼æ æéï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (string.IsNullOrWhiteSpace(HItemID)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "HItemID为空ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | oCN.BeginTran();//å¼å§äºå¡ |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_DataDictionary_View where HItemID=" + HItemID, "h_v_IF_DataDictionary_View"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ²¡ææ°æ®ï¼æ æ³å é¤ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | } |
| | | //ds1 = oCN.RunProcReturn("Select HItemID from h_v_IF_DataDictionary_View Where HParentID='" + HItemID + "'", "h_v_IF_DataDictionary_View"); |
| | | //if (ds1.Tables[0].Rows.Count != 0) |
| | | //{ |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "æ¤é¡¹ç®åå¨å项ç®ï¼ä¸è½å é¤ï¼"; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | //} |
| | | |
| | | |
| | | oCN.RunProc("delete from h_v_IF_DataDictionary_View where HItemID=" + HItemID); |
| | | oCN.Commit();//æäº¤äºå¡ |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "* æ°æ®å 餿åï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å é¤å¤±è´¥ï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | /// <summary> |
| | | /// ç¦ç¨æé® |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Xt_DataDictionary_View/JY_Json")] |
| | | [HttpGet] |
| | | public object JY_Json(long HItemID) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("update Xt_DataDictionary_View set HStopFlag = 1 where HItemID = " + HItemID, "Xt_DataDictionary_View"); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ç¦ç¨æå"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | /// <summary> |
| | | /// åç¦ç¨æé® |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Xt_DataDictionary_View/FJY_Json")] |
| | | [HttpGet] |
| | | public object FJY_Json(long HItemID) |
| | | { |
| | | try |
| | | { |
| | | ds = oCN.RunProcReturn("update Xt_DataDictionary_View set HStopFlag = 0 where HItemID = " + HItemID, "Xt_DataDictionary_View"); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "åç¦ç¨æå"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | ///// <summary> |
| | | ///// æ°å¢åæ®-ä¿åæé® |
| | | /////åæ°ï¼string sqlã |
| | | /////è¿åå¼ï¼objectã |
| | | ///// </summary> |
| | | //[Route("Xt_DataDictionary_View/AddBill")] |
| | | //[HttpPost] |
| | | //public object AddBill([FromBody] JObject oMain) |
| | | //{ |
| | | // try |
| | | // { |
| | | // var _value = oMain["oMain"].ToString(); |
| | | // string msg1 = _value.ToString(); |
| | | // //ååºåå |
| | | // msg1 = "[" + msg1.ToString() + "]"; |
| | | |
| | | // //DAL.ClsGy_Department_Ctl oDept = new DAL.ClsGy_Department_Ctl(); |
| | | // //DAL.ClsGy_Department_View oDeptHlp = new DAL.ClsGy_Department_View(); |
| | | |
| | | |
| | | |
| | | // List<Xt_DataDictionary_View> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Xt_DataDictionary_View>>(msg1); |
| | | |
| | | // long HItemID = list[0].HItemID; |
| | | // long HModNameID = list[0].HModNameID; |
| | | // long HBillTypeID = list[0].HBillTypeID; |
| | | // string HViewName = list[0].HViewName; |
| | | // string HViewCaption = list[0].HViewCaption; |
| | | // string HRemark = list[0].HRemark; |
| | | // bool HStopflag = list[0].HStopflag; |
| | | // DateTime HMakeTime = list[0].HMakeTime; |
| | | // string HMakeEmp = list[0].HMakeEmp; |
| | | // DateTime HModifyTime = list[0].HModifyTime; |
| | | // string HModifyEmp = list[0].HModifyEmp; |
| | | |
| | | |
| | | // //è¥MAINDIéå¤åéæ°è·å |
| | | // oCN.BeginTran(); |
| | | // //主表 |
| | | // oCN.RunProc("Insert Into Xt_DataDictionary_View " + |
| | | // "(HModNameID,HBillTypeID,HViewName,HViewCaption,HRemark" + |
| | | // ",HStopflag,HMakeTime,HMakeEmp,HModifyTime" + |
| | | // ",HModifyEmp" + |
| | | // ") " + |
| | | // " values(" + HModNameID + "," + HBillTypeID + "," + HBillTypeID + ",'" + HViewName + "','" + HViewCaption + "'"+ |
| | | // ",'" + HRemark + "'," + Convert.ToString(HStopflag ? 1 : 0) + "" + |
| | | // ",'" + HMakeTime + "','" + HMakeEmp + "','" + HModifyTime + "','" + HModifyEmp + "'" + |
| | | // ") "); |
| | | // //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | // objJsonResult.code = "1"; |
| | | // objJsonResult.count = 1; |
| | | // objJsonResult.Message = null; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | // } |
| | | // catch (Exception e) |
| | | // { |
| | | // oCN.RollBack(); |
| | | // objJsonResult.code = "0"; |
| | | // objJsonResult.count = 0; |
| | | // objJsonResult.Message = "Exceptionï¼" + e.Message; |
| | | // objJsonResult.data = null; |
| | | // return objJsonResult; |
| | | // } |
| | | //} |
| | | |
| | | |
| | | /// <summary> |
| | | /// ä¿åæé® |
| | | ///åæ°ï¼string sqlã |
| | | ///è¿åå¼ï¼objectã |
| | | /// </summary> |
| | | [Route("Xt_DataDictionary_View/AddBill1")] |
| | | [HttpPost] |
| | | public object AddBill1([FromBody] JObject oMain) |
| | | { |
| | | |
| | | try |
| | | { |
| | | //DAL.ClsGy_Department_Ctl oDept = new DAL.ClsGy_Department_Ctl(); |
| | | //DAL.ClsGy_Department_View oDeptHlp = new DAL.ClsGy_Department_View(); |
| | | |
| | | var _value = oMain["oMain"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | //string msg3 = sArray[1].ToString(); |
| | | //string msg4 = sArray[2].ToString(); |
| | | //string msg5 = sArray[3].ToString(); |
| | | //ååºåå |
| | | msg2 = "[" + msg2.ToString() + "]"; |
| | | List<Xt_DataDictionary_View> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Xt_DataDictionary_View>>(msg2); |
| | | |
| | | long HItemID = list[0].HItemID; |
| | | long HModNameID = list[0].HModNameID; |
| | | long HBillTypeID = list[0].HBillTypeID; |
| | | string HViewName = list[0].HViewName; |
| | | string HViewCaption = list[0].HViewCaption; |
| | | string HRemark = list[0].HRemark; |
| | | bool HStopflag = list[0].HStopflag; |
| | | DateTime HMakeTime = list[0].HMakeTime; |
| | | string HMakeEmp = list[0].HMakeEmp; |
| | | DateTime HModifyTime = list[0].HModifyTime; |
| | | string HModifyEmp = list[0].HModifyEmp; |
| | | |
| | | //ä¿å |
| | | //ä¿å宿¯åå¤ç |
| | | if (HItemID == 0) |
| | | { |
| | | //æ°å¢ |
| | | oCN.BeginTran(); |
| | | oCN.RunProc("Insert Into Xt_DataDictionary_View " + |
| | | "(HModNameID,HBillTypeID,HViewName,HViewCaption,HRemark" + |
| | | ",HStopflag,HMakeTime,HMakeEmp,HModifyTime" + |
| | | ",HModifyEmp" + |
| | | ") " + |
| | | " values(" + HModNameID + "," + HBillTypeID + ",'" + HViewName + "','" + HViewCaption + "'" + |
| | | ",'" + HRemark + "'," + Convert.ToString(HStopflag ? 1 : 0) + "" + |
| | | ",'" + HMakeTime + "','" + HMakeEmp + "','" + HModifyTime + "','" + HModifyEmp + "'" + |
| | | ") ", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹ä¸çº§ä¸ºéæ«çº§ä»£ç |
| | | oCN.RunProc("Update Xt_DataDictionary_View set HStopflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | | } |
| | | else |
| | | { |
| | | oCN.BeginTran(); |
| | | //主表 |
| | | oCN.RunProc("Update Xt_DataDictionary_View set " + |
| | | " HModNameID= "+ HModNameID + |
| | | " HBillTypeID= " + HBillTypeID + |
| | | ",HViewName='" + HViewName + "'" + |
| | | ",HViewCaption='" + HViewCaption + "'" + |
| | | ",HRemark='" + HRemark + "'" + |
| | | ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + |
| | | ",HMakeTime='" + HMakeTime + "'" + |
| | | ",HMakeEmp='" + HMakeEmp + "'" + |
| | | ",HModifyTime='" + HModifyTime + "'" + |
| | | ",HModifyEmp='" + HModifyEmp + "'" + |
| | | //",HUpdater='" + HUpdater + "'" + |
| | | //",HUpdateDate= getdate()" + |
| | | ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //ä¿®æ¹å项ç®ä»£ç |
| | | //oCN.RunProc("exec h_p_Gy_UpdateNumber Gy_Department,'" + HNumber + ".','" + this.HOldNumber + ".'", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //å°ä¸çº§ ä¸ºéæ«çº§ |
| | | oCN.RunProc("Update Xt_DataDictionary_View set HStopflag=0 where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | | } |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ä¿åæåï¼"; |
| | | //WebAPIController.Add_Log("éè´§å䏿¨", UserName, "çæéè´§å"); |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.Message; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | // |
| | | } |
| | | } |
| | |
| | | /// </summary> |
| | | [Route("Cg_POOrderBill/list")] |
| | | [HttpGet] |
| | | public object list(string sWhere) |
| | | public object list(string sWhere, string user) |
| | | { |
| | | try |
| | | { |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | //夿æ¯å¦æéè´ç»çæé |
| | | bool isCgjl = Security_Log("Cg_POOrderBill_PurchasManager", 1, true, user); |
| | | if (!isCgjl) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_IF_POOrderBillList " + sWhere, "h_v_IF_POOrderBillList"); |
| | | sWhere += " and HEmpID in (select HEmpID from Gy_Czygl where Czymc='Admin' )"; |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_IF_POOrderBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_POOrderBillList"); |
| | | } |
| | | string sql = "select * from h_v_IF_POOrderBillList where 1 = 1 " + sWhere; |
| | | ds = oCN.RunProcReturn(sql, "h_v_IF_POOrderBillList"); |
| | | |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "Sucessï¼"; |
| | |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | |
| | | //夿æ¯å¦å卿é,å¹¶åå
¥æ¥å¿ |
| | | public static bool Security_Log(string gnsy, int LogTF, bool Msg, string CurUserName) |
| | | { |
| | | //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) |
| | | { |
| | | //MessageBox.Show("æ²¡ææ¾å°è¯¥åè½æ¨¡åï¼", "æç¤º"); |
| | | } |
| | | 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) |
| | | { |
| | | //MessageBox.Show("æ²¡ææ¾å°å½åæä½åï¼", "æç¤º"); |
| | | } |
| | | 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) |
| | | { |
| | | //MessageBox.Show("æ¨æ²¡ææé,请ä¸ç®¡çåèç³»ï¼", "æç¤º"); |
| | | } |
| | | } |
| | | } |
| | | //éè¦åå
¥æ¥å¿ |
| | | 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); |
| | | } |
| | | return HavRight; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | if (Msg == true) |
| | | { |
| | | //MessageBox.Show("夿æéæ¶åç°é误,请ä¸ç®¡çåèç³»ï¼", "æç¤º"); |
| | | } |
| | | return false; |
| | | } |
| | | } |
| | | |
| | | // |
| | | } |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ æ¥çæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ²¡ææ¥çæé"; |
| | | objJsonResult.Message = "没æä¿åæé"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ æ¥çæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ²¡ææ¥çæé"; |
| | | objJsonResult.Message = "没æä¿åæé"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ æ¥çæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ ä¿åæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ æ¥çæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | public object Sc_MouldScrapInProdBillListProjectDetai(string sqlWhere) |
| | | { |
| | | DataSet ds; |
| | | DataSet ds1; |
| | | try |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | |
| | | 宿¶æ°é HQty, åä»· HPrice, éé¢ HMoney,hwhid1 HWHID, æ¶æä»åºä»£ç HWHCode,æ¶æä»åº HWHName, |
| | | HSPID, æ¶æä»ä½ä»£ç HSPCode,æ¶æä»ä½ HSPName,表ä½å¤æ³¨ HRemark,HStockOrgID |
| | | FROM h_v_Sc_MouldProdInHouseBillList"), "h_v_Sc_MouldProdInHouseBillList"); |
| | | //æ¥æ±æ» |
| | | ds1 = oCN.RunProcReturn(string.Format(@"select 模å
·ä»£ç ,模å
·åç§°,åæ®å·,è§æ ¼åå·,æ¹æ¬¡,宿¶æ°é,hwhid1,æ¶æä»åºä»£ç , |
| | | æ¶æä»åº,表ä½å¤æ³¨,sum(HMaterID) from h_v_Sc_MouldProdInHouseBillList group by 模å
·ä»£ç , |
| | | 模å
·åç§°,åæ®å·,è§æ ¼åå·,æ¹æ¬¡,宿¶æ°é,hwhid1,æ¶æä»åºä»£ç ,æ¶æä»åº,表ä½å¤æ³¨"), |
| | | "h_v_Sc_MouldProdInHouseBillList"); |
| | | |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ ä¿åæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ æ¥çæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ²¡ææ¥çæé"; |
| | | objJsonResult.Message = "没æä¿åæé"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ æ¥çæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ ä¿åæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | //oItem.HDeptID = 0; //éªæ¶é¨é¨(Gy_Department) |
| | | //oItem.HExplanation = ""; //æè¦(æ
éæè¿°) |
| | | //oItem.HRemark = ""; //夿³¨ |
| | | |
| | | |
| | | //oItem.HMainSourceInterID = oItem.HInterID; |
| | | |
| | | //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo); |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ æ¥çæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ ä¿åæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ æ¥çæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | } |
| | | } |
| | | |
| | | |
| | | [Route("EquipMaintainBill/txtHBarCode")] |
| | | [HttpGet] |
| | | public object txtHBarCode(string HBarCode) |
| | | { |
| | | try |
| | | { |
| | | if (HBarCode == null || HBarCode.Equals("")) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ¡å½¢ç ä¸è½ä¸ºç©ºï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //å¾å°ä¿¡æ¯ |
| | | ds = oCN.RunProcReturn("select top 1 * from h_v_Gy_EquipFileMainList where HBarCode = '" + HBarCode + "'", "h_v_Gy_EquipFileMainList"); |
| | | //ds = oWebs.get_InfoByBarCode(HBarCode, ref DBUtility.ClsPub.sErrInfo); |
| | | //åå
¥ä¿¡æ¯ |
| | | if (ds == null) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æªæ¥è¯¢å°è®¾å¤ä¿¡æ¯ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "è·åä¿¡æ¯æåï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | public bool set_SavePonderationBillMain_Temp(Model.ClsKF_PonderationBillMain_Temp oMain, ref string sErrMsg) |
| | | { |
| | | DAL.ClsKF_PonderationBillMain_Temp_Ctl dal = new DAL.ClsKF_PonderationBillMain_Temp_Ctl(); |
| | |
| | | //oItem.HInnerBillNo = ""; // --å
é¨åæ®å· |
| | | oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd")); |
| | | oItem.HMouldID = DBUtility.ClsPub.isLong(lsmain[0].HMouldID); |
| | | //oItem.HEquipID = 0; //设å¤ID(Gy_EquipMent) |
| | | //oItem.HPeriod = 0; |
| | | //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); // --ç»´ä¿®æ¥æ |
| | |
| | | //oItemSub.HRemark = ""; //夿³¨ |
| | | oItemSub.HSourceInterID = 0; // æºå主å
ç |
| | | oItemSub.HSourceEntryID = 0; //æºååå
ç |
| | | oItemSub.HDotCheckItemID = DBUtility.ClsPub.isLong(ls[0].HDotCheckItemID); |
| | | oItemSub.HDotCheckItem = DBUtility.ClsPub.isStrNull(ls[0].HDotCheckItem); |
| | | oItemSub.HDotCheckPart = DBUtility.ClsPub.isStrNull(ls[0].HDotCheckPart); |
| | | //oItemSub.HSourceBillNo = ""; //æºååå· |
| | | //oItemSub.HSourceBillType = ""; //æºåç±»å |
| | | //oItemSub.HRelationQty = 0; //å
³èæ°é |
| | | //oItemSub.HRelationMoney = 0; //å
³èéé¢ |
| | | //oItemSub.HRepairID = 0; //ç»´ä¿®é¡¹ç® |
| | | //oItemSub.HRepairExplanation =""; //ç»´ä¿®è¦æ± |
| | | //oItemSub.HMoney = 0; //ç»´ä¿®è´¹ç¨ |
| | | oBill.DetailColl.Add(oItemSub); |
| | | |
| | | } |
| | | //ä¿å |
| | | //ä¿å宿¯åå¤ç |
| | | bool bResult; |
| | | if (oBill.omodel.HInterID == 0) |
| | | { |
| | | // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | else |
| | | { |
| | | bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | if (bResult) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ä¿åæåï¼"; |
| | | //WebAPIController.Add_Log("éè´§å䏿¨", UserName, "çæéè´§å"); |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼" + DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼" + e.ToString(); |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | #region 设å¤ç¹æ£è®°å½æäº¤ |
| | | |
| | | [Route("Sb_EquipDotCheckBill/savebill")] |
| | | [HttpPost] |
| | | public object savebill([FromBody] JObject msg) |
| | | { |
| | | var _value = msg["msg"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | |
| | | string UserName = ""; |
| | | |
| | | ListModels oListModels = new ListModels(); |
| | | try |
| | | { |
| | | DLL.ClsSb_EquipDotCheckBill oBill = new DLL.ClsSb_EquipDotCheckBill(); |
| | | List<Models.ClsSb_EquipDotCheckBillMain> lsmain = new List<Models.ClsSb_EquipDotCheckBillMain>(); |
| | | msg2 = msg2.Replace("\\", ""); |
| | | msg2 = msg2.Replace("\n", ""); //\n |
| | | lsmain = oListModels.getObjectByJson_Gy_EquipCheckBillMain(msg2); |
| | | foreach (Models.ClsSb_EquipDotCheckBillMain oItem in lsmain) |
| | | { |
| | | //忮巿¯å¦éå¤ |
| | | if (BillNew.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®å·éå¤ï¼ä¸å
许ä¿åï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //oItem.HMaker = ""; |
| | | UserName = oItem.HMaker; //å¶å人 |
| | | oItem.HBillType = "3903"; |
| | | oItem.HBillSubType = "3903"; |
| | | //oItem.HBillNo = ""; //åæ®å· |
| | | //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --æ¥æ |
| | | //oItem.HInnerBillNo = ""; // --å
é¨åæ®å· |
| | | oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd")); |
| | | oItem.HEquipID = DBUtility.ClsPub.isLong(lsmain[0].HEquipID); |
| | | //oItem.HEquipID = 0; //设å¤ID(Gy_EquipMent) |
| | | //oItem.HPeriod = 0; |
| | | //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); // --ç»´ä¿®æ¥æ |
| | | //oItem.HCheckResult = ""; //éªæ¶ç»è®º--(æ£å¸¸ï¼å¼å¸¸) |
| | | //oItem.HEmpID = 0; //éªæ¶äºº(Gy_Employee) |
| | | //oItem.HManagerID = 0; //è´è´£äºº(Gy_Employee) |
| | | //oItem.HDeptID = 0; //éªæ¶é¨é¨(Gy_Department) |
| | | //oItem.HExplanation = ""; //æè¦(æ
éæè¿°) |
| | | //oItem.HRemark = ""; //夿³¨ |
| | | |
| | | //oItem.HMainSourceInterID = oItem.HInterID; |
| | | |
| | | //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿åå¤±è´¥ï¼æ²¡æåæ®æ¥æï¼æ æ³ä¿åï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | oBill.omodel = oItem; |
| | | } |
| | | //åè¡¨ä½æ°æ® |
| | | |
| | | List<Models.ClsSb_EquipDotCheckBillSub> ls = new List<Models.ClsSb_EquipDotCheckBillSub>(); |
| | | ls = oListModels.getObjectByJson_Gy_EquipDotCheckBillSub(msg2); |
| | | int i = 0; |
| | | foreach (Models.ClsSb_EquipDotCheckBillSub oItemSub in ls) |
| | | { |
| | | |
| | | i++; |
| | | oItemSub.HEntryID = i; |
| | | |
| | | //oItemSub.HRepairCheckID = 0; //éªæ¶é¡¹ç®ID |
| | | //oItemSub.HRepairCheckContent = ""; //éªæ¶å
容 |
| | | //oItemSub.HManagerID = 0; //è´è´£äººID |
| | | //oItemSub.HCloseMan = ""; //è¡å
³é |
| | | oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); |
| | | oItemSub.HCloseType = false; //å
³éç±»å |
| | | //oItemSub.HRemark = ""; //夿³¨ |
| | | oItemSub.HSourceInterID = 0; // æºå主å
ç |
| | | oItemSub.HSourceEntryID = 0; //æºååå
ç |
| | | oItemSub.HDotCheckItemID = DBUtility.ClsPub.isLong(ls[0].HDotCheckItemID); |
| | | oItemSub.HDotCheckItem = DBUtility.ClsPub.isStrNull(ls[0].HDotCheckItem); |
| | | oItemSub.HDotCheckPart = DBUtility.ClsPub.isStrNull(ls[0].HDotCheckPart); |
| | | //oItemSub.HSourceBillNo = ""; //æºååå· |
| | | //oItemSub.HSourceBillType = ""; //æºåç±»å |
| | | //oItemSub.HRelationQty = 0; //å
³èæ°é |
| | | //oItemSub.HRelationMoney = 0; //å
³èéé¢ |
| | | //oItemSub.HRepairID = 0; //ç»´ä¿®é¡¹ç® |
| | | //oItemSub.HRepairExplanation =""; //ç»´ä¿®è¦æ± |
| | | //oItemSub.HMoney = 0; //ç»´ä¿®è´¹ç¨ |
| | | oBill.DetailColl.Add(oItemSub); |
| | | |
| | | } |
| | | //ä¿å |
| | | //ä¿å宿¯åå¤ç |
| | | bool bResult; |
| | | if (oBill.omodel.HInterID == 0) |
| | | { |
| | | // bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | else |
| | | { |
| | | bResult = oBill.ModifyBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | if (bResult) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "ä¿åæåï¼"; |
| | | //WebAPIController.Add_Log("éè´§å䏿¨", UserName, "çæéè´§å"); |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼" + DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败ï¼" + e.ToString(); |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #region 设å¤ç»´ä¿®è®°å½æäº¤ |
| | | |
| | | [Route("Sb_EquipRepairWorkBill/savebill1")] |
| | | [HttpPost] |
| | | public object savebill1([FromBody] JObject msg) |
| | | { |
| | | var _value = msg["msg"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | string msg2 = sArray[0].ToString(); |
| | | |
| | | string UserName = ""; |
| | | |
| | | ListModels oListModels = new ListModels(); |
| | | try |
| | | { |
| | | DLL.ClsSb_EquipRepairWorkBill oBill = new DLL.ClsSb_EquipRepairWorkBill(); |
| | | List<Models.ClsSb_EquipRepairWorkBillMain> lsmain = new List<Models.ClsSb_EquipRepairWorkBillMain>(); |
| | | msg2 = msg2.Replace("\\", ""); |
| | | msg2 = msg2.Replace("\n", ""); //\n |
| | | lsmain = oListModels.wxmain(msg2); |
| | | foreach (Models.ClsSb_EquipRepairWorkBillMain oItem in lsmain) |
| | | { |
| | | //忮巿¯å¦éå¤ |
| | | if (BillNew.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®å·éå¤ï¼ä¸å
许ä¿åï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | //oItem.HMaker = ""; |
| | | UserName = oItem.HMaker; //å¶å人 |
| | | oItem.HBillType = "3903"; |
| | | oItem.HBillSubType = "3903"; |
| | | //oItem.HBillNo = ""; //åæ®å· |
| | | //oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd"));// --æ¥æ |
| | | //oItem.HInnerBillNo = ""; // --å
é¨åæ®å· |
| | | oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd")); |
| | | oItem.HEquipID = DBUtility.ClsPub.isLong(lsmain[0].HEquipID); |
| | | //oItem.HEquipID = 0; //设å¤ID(Gy_EquipMent) |
| | | //oItem.HPeriod = 0; |
| | | //oItem.HCheckBeginDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); // --ç»´ä¿®æ¥æ |
| | | //oItem.HCheckResult = ""; //éªæ¶ç»è®º--(æ£å¸¸ï¼å¼å¸¸) |
| | | //oItem.HEmpID = 0; //éªæ¶äºº(Gy_Employee) |
| | | //oItem.HManagerID = 0; //è´è´£äºº(Gy_Employee) |
| | | //oItem.HDeptID = 0; //éªæ¶é¨é¨(Gy_Department) |
| | | //oItem.HExplanation = ""; //æè¦(æ
éæè¿°) |
| | | //oItem.HRemark = ""; //夿³¨ |
| | | |
| | | //oItem.HMainSourceInterID = oItem.HInterID; |
| | | |
| | | //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿åå¤±è´¥ï¼æ²¡æåæ®æ¥æï¼æ æ³ä¿åï¼"; |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | oBill.omodel = oItem; |
| | | } |
| | | //åè¡¨ä½æ°æ® |
| | | |
| | | List<Models.ClsSb_EquipRepairWorkBillSub> ls = new List<Models.ClsSb_EquipRepairWorkBillSub>(); |
| | | ls = oListModels.wxsub(msg2); |
| | | int i = 0; |
| | | foreach (Models.ClsSb_EquipRepairWorkBillSub oItemSub in ls) |
| | | { |
| | | |
| | | i++; |
| | | oItemSub.HEntryID = i; |
| | | |
| | | //oItemSub.HRepairCheckID = 0; //éªæ¶é¡¹ç®ID |
| | | //oItemSub.HRepairCheckContent = ""; //éªæ¶å
容 |
| | | //oItemSub.HManagerID = 0; //è´è´£äººID |
| | | //oItemSub.HCloseMan = ""; //è¡å
³é |
| | | oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); |
| | | oItemSub.HCloseType = false; //å
³éç±»å |
| | | //oItemSub.HRemark = ""; //夿³¨ |
| | | oItemSub.HSourceInterID = 0; // æºå主å
ç |
| | | oItemSub.HSourceEntryID = 0; //æºååå
ç |
| | | //oItemSub.HSourceBillNo = ""; //æºååå· |
| | | //oItemSub.HSourceBillType = ""; //æºåç±»å |
| | | //oItemSub.HRelationQty = 0; //å
³èæ°é |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ æ¥çæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ ä¿åæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | |
| | | #endregion |
| | | |
| | | #region 模å
·æ¹å¶å
¥åºå |
| | | |
| | | #region 模å
·æ¹å¶å
¥åºåä¿å |
| | | |
| | | [Route("Sc_MouldRepairInBill/MouldRepairInBill_Save")] |
| | | [HttpPost] |
| | | public object MouldRepairInBillAdd([FromBody] JObject sMainSub) |
| | | { |
| | | var _value = sMainSub["sMainSub"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | //ä¿ååæ® |
| | | return objJsonResult = MouldRepairInAddBill(msg1); |
| | | } |
| | | |
| | | public json MouldRepairInAddBill(string msg1) |
| | | { |
| | | //string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | //string msg2 = sArray[0].ToString(); |
| | | //string msg3 = sArray[0].ToString(); |
| | | bool bResult; |
| | | try |
| | | { |
| | | //msg2 = "[" + msg2.ToString() + "]"; |
| | | msg1 = "[" + msg1.ToString() + "]"; |
| | | DAL.ClsSc_MouldRepairInBill BillNew = new DAL.ClsSc_MouldRepairInBill(); |
| | | List<Model.ClsSc_MouldRepairInBillMain> mainList = Newtonsoft |
| | | .Json |
| | | .JsonConvert |
| | | .DeserializeObject<List<Model.ClsSc_MouldRepairInBillMain>>(msg1); |
| | | List<Model.ClsSc_MouldStockBillSub> subList = Newtonsoft |
| | | .Json |
| | | .JsonConvert |
| | | .DeserializeObject<List<Model.ClsSc_MouldStockBillSub>>(msg1); |
| | | //夿ä¼è®¡ææ¯å¦åç |
| | | string s = ""; |
| | | int sYear = 0; |
| | | int sPeriod = 0; |
| | | DateTime HDate = mainList[0].HDate;//æ¥æ |
| | | if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = s; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | BillNew.omodel.HYear = sYear; |
| | | BillNew.omodel.HPeriod = sPeriod; |
| | | BillNew.omodel.HBillNo = mainList[0].HBillNo.Trim(); |
| | | BillNew.omodel.HMaker = mainList[0].HMaker; |
| | | BillNew.omodel.HDate = HDate; |
| | | BillNew.omodel.HWHID = mainList[0].HWHID; |
| | | BillNew.omodel.HSupID = 0; |
| | | BillNew.omodel.HSCWHID = 0; |
| | | BillNew.omodel.HEmpID = 0; |
| | | BillNew.omodel.HManagerID = mainList[0].HManagerID; |
| | | BillNew.omodel.HSecManagerID = mainList[0].HSecManagerID; |
| | | BillNew.omodel.HKeeperID = mainList[0].HKeeperID; |
| | | BillNew.omodel.HDeptID = mainList[0].HDeptID; |
| | | BillNew.omodel.HExplanation = mainList[0].HExplanation; |
| | | BillNew.omodel.HInnerBillNo = mainList[0].HInnerBillNo; |
| | | BillNew.omodel.HRedBlueFlag = mainList[0].HRedBlueFlag; |
| | | BillNew.DetailColl = new List<Model.ClsSc_MouldStockBillSub>(); |
| | | Model.ClsSc_MouldStockBillSub oSub = new Model.ClsSc_MouldStockBillSub(); |
| | | |
| | | oSub.HEntryID = 1; |
| | | oSub.HRemark = DBUtility.ClsPub.isStrNull(subList[0].HRemark); |
| | | oSub.HSourceInterID = DBUtility.ClsPub.isLong(subList[0].HSourceInterID); |
| | | oSub.HSourceEntryID = DBUtility.ClsPub.isLong(subList[0].HSourceEntryID); |
| | | oSub.HSourceBillType = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillType); |
| | | oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillNo); |
| | | oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[0].HRelationQty); |
| | | oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[0].HRelationMoney); |
| | | oSub.HCloseMan = DBUtility.ClsPub.isStrNull(subList[0].HCloseMan); |
| | | oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(subList[0].HEntryCloseDate); |
| | | oSub.HCloseType = DBUtility.ClsPub.isBool(subList[0].HCloseType); |
| | | oSub.HMaterID = DBUtility.ClsPub.isLong(subList[0].HMaterID); |
| | | oSub.HPropertyID = DBUtility.ClsPub.isLong(subList[0].HPropertyID); |
| | | oSub.HSecUnitID = DBUtility.ClsPub.isLong(subList[0].HSecUnitID); |
| | | oSub.HSecUnitRate = DBUtility.ClsPub.isSingle(subList[0].HSecUnitRate); |
| | | oSub.HUnitID = DBUtility.ClsPub.isLong(subList[0].HUnitID); |
| | | oSub.HQtyMust = DBUtility.ClsPub.isDoule(subList[0].HQtyMust); |
| | | oSub.HQty = DBUtility.ClsPub.isDoule(subList[0].HQty); |
| | | oSub.HBarCode = DBUtility.ClsPub.isStrNull(subList[0].HBarCode); |
| | | if (oSub.HQty <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æµè½¬å¡æ°éä¸è½ä¸º0æè
å°äº0"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | oSub.HDesignLife = DBUtility.ClsPub.isLong(subList[0].HDesignLife); |
| | | if (oSub.HDesignLife < 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "设计寿å½ä¸è½ä¸º0æè
å°äº0"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | oSub.HLeaveLife = DBUtility.ClsPub.isLong(subList[0].HLeaveLife); |
| | | oSub.HPrice = DBUtility.ClsPub.isDoule(subList[0].HPrice); |
| | | oSub.HWHID = DBUtility.ClsPub.isLong(subList[0].HWHID); |
| | | oSub.HSPID = DBUtility.ClsPub.isLong(subList[0].HSPID); |
| | | oSub.HSCWHID = 0; |
| | | oSub.HSCSPID = 0; |
| | | oSub.HSPGroupID = DBUtility.ClsPub.isLong(subList[0].HSPGroupID); |
| | | oSub.HBatchNo = DBUtility.ClsPub.isStrNull(subList[0].HBatchNo); |
| | | oSub.HNewModel = DBUtility.ClsPub.isStrNull(subList[0].HNewModel); |
| | | oSub.HWallThickness = DBUtility.ClsPub.isStrNull(subList[0].HWallThickness); |
| | | oSub.HHardness = DBUtility.ClsPub.isStrNull(subList[0].HHardness); |
| | | oSub.HLastProdModel = DBUtility.ClsPub.isStrNull(subList[0].HLastProdModel); |
| | | oSub.HDiameter = DBUtility.ClsPub.isStrNull(subList[0].HDiameter); |
| | | oSub.HBackFlag = DBUtility.ClsPub.isStrNull(subList[0].HBackFlag); |
| | | BillNew.DetailColl.Add(oSub); |
| | | bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo); |
| | | //æç¤º |
| | | if (bResult == true) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = ClsPub.sExeReturnInfo + "åæ®å·:" + mainList[0].HBillNo.Trim(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败!åå :" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #endregion |
| | | |
| | | |
| | | #region 模å
·éè´å
¥åºå |
| | | |
| | | #region 模å
·éè´å
¥åºåä¿å |
| | | |
| | | [Route("Sc_MouldProdInBill/MouldProdInBill_Save")] |
| | | [HttpPost] |
| | | public object MouldProdInBillAdd([FromBody] JObject sMainSub) |
| | | { |
| | | var _value = sMainSub["sMainSub"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | //ä¿ååæ® |
| | | return objJsonResult = MouldProdInAddBill(msg1); |
| | | } |
| | | |
| | | public json MouldProdInAddBill(string msg1) |
| | | { |
| | | //string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | //string msg2 = sArray[0].ToString(); |
| | | //string msg3 = sArray[0].ToString(); |
| | | bool bResult; |
| | | try |
| | | { |
| | | //msg2 = "[" + msg2.ToString() + "]"; |
| | | msg1 = "[" + msg1.ToString() + "]"; |
| | | DAL.ClsSc_MouldProdInBill BillNew = new DAL.ClsSc_MouldProdInBill(); |
| | | List<Model.ClsSc_MouldProdInBillMain> mainList = Newtonsoft |
| | | .Json |
| | | .JsonConvert |
| | | .DeserializeObject<List<Model.ClsSc_MouldProdInBillMain>>(msg1); |
| | | List<Model.ClsSc_MouldStockBillSub> subList = Newtonsoft |
| | | .Json |
| | | .JsonConvert |
| | | .DeserializeObject<List<Model.ClsSc_MouldStockBillSub>>(msg1); |
| | | //夿ä¼è®¡ææ¯å¦åç |
| | | string s = ""; |
| | | int sYear = 0; |
| | | int sPeriod = 0; |
| | | DateTime HDate = mainList[0].HDate;//æ¥æ |
| | | if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = s; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | BillNew.omodel.HYear = sYear; |
| | | BillNew.omodel.HPeriod = sPeriod; |
| | | BillNew.omodel.HBillNo = mainList[0].HBillNo.Trim(); |
| | | BillNew.omodel.HMaker = mainList[0].HMaker; |
| | | BillNew.omodel.HDate = HDate; |
| | | BillNew.omodel.HWHID = mainList[0].HWHID; |
| | | BillNew.omodel.HSupID = 0; |
| | | BillNew.omodel.HSCWHID = 0; |
| | | BillNew.omodel.HEmpID = 0; |
| | | BillNew.omodel.HManagerID = mainList[0].HManagerID; |
| | | BillNew.omodel.HSecManagerID = mainList[0].HSecManagerID; |
| | | BillNew.omodel.HKeeperID = mainList[0].HKeeperID; |
| | | BillNew.omodel.HDeptID = mainList[0].HDeptID; |
| | | BillNew.omodel.HExplanation = mainList[0].HExplanation; |
| | | BillNew.omodel.HInnerBillNo = mainList[0].HInnerBillNo; |
| | | BillNew.omodel.HRedBlueFlag = mainList[0].HRedBlueFlag; |
| | | BillNew.DetailColl = new List<Model.ClsSc_MouldStockBillSub>(); |
| | | Model.ClsSc_MouldStockBillSub oSub = new Model.ClsSc_MouldStockBillSub(); |
| | | |
| | | oSub.HEntryID = 1; |
| | | oSub.HRemark = DBUtility.ClsPub.isStrNull(subList[0].HRemark); |
| | | oSub.HSourceInterID = DBUtility.ClsPub.isLong(subList[0].HSourceInterID); |
| | | oSub.HSourceEntryID = DBUtility.ClsPub.isLong(subList[0].HSourceEntryID); |
| | | oSub.HSourceBillType = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillType); |
| | | oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillNo); |
| | | oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[0].HRelationQty); |
| | | oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[0].HRelationMoney); |
| | | oSub.HCloseMan = DBUtility.ClsPub.isStrNull(subList[0].HCloseMan); |
| | | oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(subList[0].HEntryCloseDate); |
| | | oSub.HCloseType = DBUtility.ClsPub.isBool(subList[0].HCloseType); |
| | | oSub.HMaterID = DBUtility.ClsPub.isLong(subList[0].HMaterID); |
| | | oSub.HPropertyID = DBUtility.ClsPub.isLong(subList[0].HPropertyID); |
| | | oSub.HSecUnitID = DBUtility.ClsPub.isLong(subList[0].HSecUnitID); |
| | | oSub.HSecUnitRate = DBUtility.ClsPub.isSingle(subList[0].HSecUnitRate); |
| | | oSub.HUnitID = DBUtility.ClsPub.isLong(subList[0].HUnitID); |
| | | oSub.HQtyMust = DBUtility.ClsPub.isDoule(subList[0].HQtyMust); |
| | | oSub.HQty = DBUtility.ClsPub.isDoule(subList[0].HQty); |
| | | oSub.HBarCode = DBUtility.ClsPub.isStrNull(subList[0].HBarCode); |
| | | if (oSub.HQty <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æµè½¬å¡æ°éä¸è½ä¸º0æè
å°äº0"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | oSub.HDesignLife = DBUtility.ClsPub.isLong(subList[0].HDesignLife); |
| | | if (oSub.HDesignLife < 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "设计寿å½ä¸è½ä¸º0æè
å°äº0"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | oSub.HLeaveLife = DBUtility.ClsPub.isLong(subList[0].HLeaveLife); |
| | | oSub.HPrice = DBUtility.ClsPub.isDoule(subList[0].HPrice); |
| | | oSub.HWHID = DBUtility.ClsPub.isLong(subList[0].HWHID); |
| | | oSub.HSPID = DBUtility.ClsPub.isLong(subList[0].HSPID); |
| | | oSub.HSCWHID = 0; |
| | | oSub.HSCSPID = 0; |
| | | oSub.HSPGroupID = DBUtility.ClsPub.isLong(subList[0].HSPGroupID); |
| | | oSub.HBatchNo = DBUtility.ClsPub.isStrNull(subList[0].HBatchNo); |
| | | oSub.HNewModel = DBUtility.ClsPub.isStrNull(subList[0].HNewModel); |
| | | oSub.HWallThickness = DBUtility.ClsPub.isStrNull(subList[0].HWallThickness); |
| | | oSub.HHardness = DBUtility.ClsPub.isStrNull(subList[0].HHardness); |
| | | oSub.HLastProdModel = DBUtility.ClsPub.isStrNull(subList[0].HLastProdModel); |
| | | oSub.HDiameter = DBUtility.ClsPub.isStrNull(subList[0].HDiameter); |
| | | oSub.HBackFlag = DBUtility.ClsPub.isStrNull(subList[0].HBackFlag); |
| | | BillNew.DetailColl.Add(oSub); |
| | | bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo); |
| | | //æç¤º |
| | | if (bResult == true) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = ClsPub.sExeReturnInfo + "åæ®å·:" + mainList[0].HBillNo.Trim(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败!åå :" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #endregion |
| | | |
| | | |
| | | #region 模å
·æ¹å¶åºåºå |
| | | |
| | | #region 模å
·æ¹å¶åºåºåä¿å |
| | | |
| | | [Route("Sc_MouldRepairOutBill/MouldRepairOutBill_Save")] |
| | | [HttpPost] |
| | | public object MouldRepairOutBillAdd([FromBody] JObject sMainSub) |
| | | { |
| | | var _value = sMainSub["sMainSub"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | //ä¿ååæ® |
| | | return objJsonResult = MouldRepairOutAddBill(msg1); |
| | | } |
| | | |
| | | public json MouldRepairOutAddBill(string msg1) |
| | | { |
| | | //string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | //string msg2 = sArray[0].ToString(); |
| | | //string msg3 = sArray[0].ToString(); |
| | | bool bResult; |
| | | try |
| | | { |
| | | //msg2 = "[" + msg2.ToString() + "]"; |
| | | msg1 = "[" + msg1.ToString() + "]"; |
| | | DAL.ClsSc_MouldRepairOutBill BillNew = new DAL.ClsSc_MouldRepairOutBill(); |
| | | List<Model.ClsSc_MouldRepairOutBillMain> mainList = Newtonsoft |
| | | .Json |
| | | .JsonConvert |
| | | .DeserializeObject<List<Model.ClsSc_MouldRepairOutBillMain>>(msg1); |
| | | List<Model.ClsSc_MouldStockBillSub> subList = Newtonsoft |
| | | .Json |
| | | .JsonConvert |
| | | .DeserializeObject<List<Model.ClsSc_MouldStockBillSub>>(msg1); |
| | | //夿ä¼è®¡ææ¯å¦åç |
| | | string s = ""; |
| | | int sYear = 0; |
| | | int sPeriod = 0; |
| | | DateTime HDate = mainList[0].HDate;//æ¥æ |
| | | if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = s; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | BillNew.omodel.HYear = sYear; |
| | | BillNew.omodel.HPeriod = sPeriod; |
| | | BillNew.omodel.HBillNo = mainList[0].HBillNo.Trim(); |
| | | BillNew.omodel.HMaker = mainList[0].HMaker; |
| | | BillNew.omodel.HDate = HDate; |
| | | BillNew.omodel.HWHID = mainList[0].HWHID; |
| | | BillNew.omodel.HSupID = 0; |
| | | BillNew.omodel.HSCWHID = 0; |
| | | BillNew.omodel.HEmpID = 0; |
| | | BillNew.omodel.HManagerID = mainList[0].HManagerID; |
| | | BillNew.omodel.HSecManagerID = mainList[0].HSecManagerID; |
| | | BillNew.omodel.HKeeperID = mainList[0].HKeeperID; |
| | | BillNew.omodel.HDeptID = mainList[0].HDeptID; |
| | | BillNew.omodel.HExplanation = mainList[0].HExplanation; |
| | | BillNew.omodel.HInnerBillNo = mainList[0].HInnerBillNo; |
| | | BillNew.omodel.HRedBlueFlag = mainList[0].HRedBlueFlag; |
| | | BillNew.DetailColl = new List<Model.ClsSc_MouldStockBillSub>(); |
| | | Model.ClsSc_MouldStockBillSub oSub = new Model.ClsSc_MouldStockBillSub(); |
| | | |
| | | oSub.HEntryID = 1; |
| | | oSub.HRemark = DBUtility.ClsPub.isStrNull(subList[0].HRemark); |
| | | oSub.HSourceInterID = DBUtility.ClsPub.isLong(subList[0].HSourceInterID); |
| | | oSub.HSourceEntryID = DBUtility.ClsPub.isLong(subList[0].HSourceEntryID); |
| | | oSub.HSourceBillType = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillType); |
| | | oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillNo); |
| | | oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[0].HRelationQty); |
| | | oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[0].HRelationMoney); |
| | | oSub.HCloseMan = DBUtility.ClsPub.isStrNull(subList[0].HCloseMan); |
| | | oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(subList[0].HEntryCloseDate); |
| | | oSub.HCloseType = DBUtility.ClsPub.isBool(subList[0].HCloseType); |
| | | oSub.HMaterID = DBUtility.ClsPub.isLong(subList[0].HMaterID); |
| | | oSub.HPropertyID = DBUtility.ClsPub.isLong(subList[0].HPropertyID); |
| | | oSub.HSecUnitID = DBUtility.ClsPub.isLong(subList[0].HSecUnitID); |
| | | oSub.HSecUnitRate = DBUtility.ClsPub.isSingle(subList[0].HSecUnitRate); |
| | | oSub.HUnitID = DBUtility.ClsPub.isLong(subList[0].HUnitID); |
| | | oSub.HQtyMust = DBUtility.ClsPub.isDoule(subList[0].HQtyMust); |
| | | oSub.HQty = DBUtility.ClsPub.isDoule(subList[0].HQty); |
| | | oSub.HBarCode = DBUtility.ClsPub.isStrNull(subList[0].HBarCode); |
| | | if (oSub.HQty <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æµè½¬å¡æ°éä¸è½ä¸º0æè
å°äº0"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | oSub.HDesignLife = DBUtility.ClsPub.isLong(subList[0].HDesignLife); |
| | | if (oSub.HDesignLife < 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "设计寿å½ä¸è½ä¸º0æè
å°äº0"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | oSub.HLeaveLife = DBUtility.ClsPub.isLong(subList[0].HLeaveLife); |
| | | oSub.HPrice = DBUtility.ClsPub.isDoule(subList[0].HPrice); |
| | | oSub.HWHID = DBUtility.ClsPub.isLong(subList[0].HWHID); |
| | | oSub.HSPID = DBUtility.ClsPub.isLong(subList[0].HSPID); |
| | | oSub.HSCWHID = 0; |
| | | oSub.HSCSPID = 0; |
| | | oSub.HSPGroupID = DBUtility.ClsPub.isLong(subList[0].HSPGroupID); |
| | | oSub.HBatchNo = DBUtility.ClsPub.isStrNull(subList[0].HBatchNo); |
| | | oSub.HNewModel = DBUtility.ClsPub.isStrNull(subList[0].HNewModel); |
| | | oSub.HWallThickness = DBUtility.ClsPub.isStrNull(subList[0].HWallThickness); |
| | | oSub.HHardness = DBUtility.ClsPub.isStrNull(subList[0].HHardness); |
| | | oSub.HLastProdModel = DBUtility.ClsPub.isStrNull(subList[0].HLastProdModel); |
| | | oSub.HDiameter = DBUtility.ClsPub.isStrNull(subList[0].HDiameter); |
| | | oSub.HBackFlag = DBUtility.ClsPub.isStrNull(subList[0].HBackFlag); |
| | | BillNew.DetailColl.Add(oSub); |
| | | bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo); |
| | | //æç¤º |
| | | if (bResult == true) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = ClsPub.sExeReturnInfo + "åæ®å·:" + mainList[0].HBillNo.Trim(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败!åå :" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #endregion |
| | | |
| | | |
| | | #region 模å
·æ¥åºå
¥åºå |
| | | |
| | | #region 模å
·æ¥åºå
¥åºåä¿å |
| | | |
| | | [Route("Sc_MouldScrapInBill/MouldScrapInBill_Save")] |
| | | [HttpPost] |
| | | public object MouldScrapInBillAdd([FromBody] JObject sMainSub) |
| | | { |
| | | var _value = sMainSub["sMainSub"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | //ä¿ååæ® |
| | | return objJsonResult = MouldScrapInAddBill(msg1); |
| | | } |
| | | |
| | | public json MouldScrapInAddBill(string msg1) |
| | | { |
| | | //string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); |
| | | //string msg2 = sArray[0].ToString(); |
| | | //string msg3 = sArray[0].ToString(); |
| | | bool bResult; |
| | | try |
| | | { |
| | | //msg2 = "[" + msg2.ToString() + "]"; |
| | | msg1 = "[" + msg1.ToString() + "]"; |
| | | DAL.ClsSc_MouldScrapInBill BillNew = new DAL.ClsSc_MouldScrapInBill(); |
| | | List<Model.ClsSc_MouldScrapInBillMain> mainList = Newtonsoft |
| | | .Json |
| | | .JsonConvert |
| | | .DeserializeObject<List<Model.ClsSc_MouldScrapInBillMain>>(msg1); |
| | | List<Model.ClsSc_MouldStockBillSub> subList = Newtonsoft |
| | | .Json |
| | | .JsonConvert |
| | | .DeserializeObject<List<Model.ClsSc_MouldStockBillSub>>(msg1); |
| | | //夿ä¼è®¡ææ¯å¦åç |
| | | string s = ""; |
| | | int sYear = 0; |
| | | int sPeriod = 0; |
| | | DateTime HDate = mainList[0].HDate;//æ¥æ |
| | | if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = s; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | BillNew.omodel.HYear = sYear; |
| | | BillNew.omodel.HPeriod = sPeriod; |
| | | BillNew.omodel.HBillNo = mainList[0].HBillNo.Trim(); |
| | | BillNew.omodel.HMaker = mainList[0].HMaker; |
| | | BillNew.omodel.HDate = HDate; |
| | | BillNew.omodel.HWHID = mainList[0].HWHID; |
| | | BillNew.omodel.HSupID = 0; |
| | | BillNew.omodel.HSCWHID = 0; |
| | | BillNew.omodel.HEmpID = 0; |
| | | BillNew.omodel.HManagerID = mainList[0].HManagerID; |
| | | BillNew.omodel.HSecManagerID = mainList[0].HSecManagerID; |
| | | BillNew.omodel.HKeeperID = mainList[0].HKeeperID; |
| | | BillNew.omodel.HDeptID = mainList[0].HDeptID; |
| | | BillNew.omodel.HExplanation = mainList[0].HExplanation; |
| | | BillNew.omodel.HInnerBillNo = mainList[0].HInnerBillNo; |
| | | BillNew.omodel.HRedBlueFlag = mainList[0].HRedBlueFlag; |
| | | BillNew.DetailColl = new List<Model.ClsSc_MouldStockBillSub>(); |
| | | Model.ClsSc_MouldStockBillSub oSub = new Model.ClsSc_MouldStockBillSub(); |
| | | |
| | | oSub.HEntryID = 1; |
| | | oSub.HRemark = DBUtility.ClsPub.isStrNull(subList[0].HRemark); |
| | | oSub.HSourceInterID = DBUtility.ClsPub.isLong(subList[0].HSourceInterID); |
| | | oSub.HSourceEntryID = DBUtility.ClsPub.isLong(subList[0].HSourceEntryID); |
| | | oSub.HSourceBillType = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillType); |
| | | oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillNo); |
| | | oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[0].HRelationQty); |
| | | oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[0].HRelationMoney); |
| | | oSub.HCloseMan = DBUtility.ClsPub.isStrNull(subList[0].HCloseMan); |
| | | oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(subList[0].HEntryCloseDate); |
| | | oSub.HCloseType = DBUtility.ClsPub.isBool(subList[0].HCloseType); |
| | | oSub.HMaterID = DBUtility.ClsPub.isLong(subList[0].HMaterID); |
| | | oSub.HPropertyID = DBUtility.ClsPub.isLong(subList[0].HPropertyID); |
| | | oSub.HSecUnitID = DBUtility.ClsPub.isLong(subList[0].HSecUnitID); |
| | | oSub.HSecUnitRate = DBUtility.ClsPub.isSingle(subList[0].HSecUnitRate); |
| | | oSub.HUnitID = DBUtility.ClsPub.isLong(subList[0].HUnitID); |
| | | oSub.HQtyMust = DBUtility.ClsPub.isDoule(subList[0].HQtyMust); |
| | | oSub.HQty = DBUtility.ClsPub.isDoule(subList[0].HQty); |
| | | oSub.HBarCode = DBUtility.ClsPub.isStrNull(subList[0].HBarCode); |
| | | if (oSub.HQty <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æµè½¬å¡æ°éä¸è½ä¸º0æè
å°äº0"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | oSub.HDesignLife = DBUtility.ClsPub.isLong(subList[0].HDesignLife); |
| | | if (oSub.HDesignLife < 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "设计寿å½ä¸è½ä¸º0æè
å°äº0"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | oSub.HLeaveLife = DBUtility.ClsPub.isLong(subList[0].HLeaveLife); |
| | | oSub.HPrice = DBUtility.ClsPub.isDoule(subList[0].HPrice); |
| | | oSub.HWHID = DBUtility.ClsPub.isLong(subList[0].HWHID); |
| | | oSub.HSPID = DBUtility.ClsPub.isLong(subList[0].HSPID); |
| | | oSub.HSCWHID = 0; |
| | | oSub.HSCSPID = 0; |
| | | oSub.HSPGroupID = DBUtility.ClsPub.isLong(subList[0].HSPGroupID); |
| | | oSub.HBatchNo = DBUtility.ClsPub.isStrNull(subList[0].HBatchNo); |
| | | oSub.HNewModel = DBUtility.ClsPub.isStrNull(subList[0].HNewModel); |
| | | oSub.HWallThickness = DBUtility.ClsPub.isStrNull(subList[0].HWallThickness); |
| | | oSub.HHardness = DBUtility.ClsPub.isStrNull(subList[0].HHardness); |
| | | oSub.HLastProdModel = DBUtility.ClsPub.isStrNull(subList[0].HLastProdModel); |
| | | oSub.HDiameter = DBUtility.ClsPub.isStrNull(subList[0].HDiameter); |
| | | oSub.HBackFlag = DBUtility.ClsPub.isStrNull(subList[0].HBackFlag); |
| | | BillNew.DetailColl.Add(oSub); |
| | | bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo); |
| | | //æç¤º |
| | | if (bResult == true) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = ClsPub.sExeReturnInfo + "åæ®å·:" + mainList[0].HBillNo.Trim(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败!åå :" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #region 模å
·ç产é¢ç¨å |
| | | |
| | | #region 模å
·ç产é¢ç¨åä¿å |
| | |
| | | oSub.HDiameter = DBUtility.ClsPub.isStrNull(subList[0].HDiameter); |
| | | oSub.HBackFlag = DBUtility.ClsPub.isStrNull(subList[0].HBackFlag); |
| | | BillNew.DetailColl.Add(oSub); |
| | | bResult = BillNew.AddBill_PDA(ref ClsPub.sExeReturnInfo); |
| | | bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo); |
| | | //æç¤º |
| | | if (bResult == true) |
| | | { |
| | |
| | | oSub.HDesignLife = DBUtility.ClsPub.isLong(subList[0].HDesignLife); |
| | | oSub.HUseLife = DBUtility.ClsPub.isLong(subList[0].HUseLife); |
| | | BillNew.DetailColl.Add(oSub); |
| | | bResult = BillNew.AddBill_PDA(ref ClsPub.sExeReturnInfo); |
| | | bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo); |
| | | //æç¤º |
| | | if (bResult == true) |
| | | { |
| | |
| | | |
| | | #endregion |
| | | |
| | | #region 设å¤ç»´ä¿®è®°å½åä¿å |
| | | |
| | | [Route("Sb_EquipMaintainBill/EquipMaintainBill_Save")] |
| | | [HttpPost] |
| | | public object EquipMaintainBill_Save([FromBody] JObject sMainSub) |
| | | { |
| | | var _value = sMainSub["sMainSub"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | | return objJsonResult = EquipMaintainAddBill(msg1); |
| | | } |
| | | |
| | | public json EquipMaintainAddBill(string msg1) |
| | | { |
| | | bool bResult; |
| | | try |
| | | { |
| | | msg1 = "[" + msg1.ToString() + "]"; |
| | | DAL.ClsSb_MouldRepairWorkBill BillNew = new DAL.ClsSb_MouldRepairWorkBill(); |
| | | List<Model.ClsSb_MouldRepairWorkBillMain> mainList = Newtonsoft |
| | | .Json |
| | | .JsonConvert |
| | | .DeserializeObject<List<Model.ClsSb_MouldRepairWorkBillMain>>(msg1); |
| | | List<Model.ClsSb_MouldRepairWorkBillSub> subList = Newtonsoft |
| | | .Json |
| | | .JsonConvert |
| | | .DeserializeObject<List<Model.ClsSb_MouldRepairWorkBillSub>>(msg1); |
| | | string s = ""; |
| | | int sYear = 0; |
| | | int sPeriod = 0; |
| | | DateTime HDate = mainList[0].HDate; |
| | | if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = s; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | BillNew.omodel.HYear = sYear; |
| | | BillNew.omodel.HPeriod = sPeriod; |
| | | BillNew.omodel.HBillNo = mainList[0].HBillNo.Trim(); |
| | | BillNew.omodel.HMaker = mainList[0].HMaker; |
| | | BillNew.omodel.HDate = HDate; |
| | | BillNew.omodel.HMouldID = mainList[0].HMouldID; |
| | | BillNew.omodel.HDeptID = mainList[0].HDeptID; |
| | | BillNew.omodel.HEmpID = mainList[0].HEmpID; |
| | | BillNew.omodel.HRepairID = mainList[0].HRepairID; |
| | | BillNew.omodel.HManagerID = mainList[0].HManagerID; |
| | | BillNew.omodel.HRepairBeginDate = mainList[0].HRepairBeginDate; |
| | | BillNew.omodel.HRepairEndDate = mainList[0].HRepairEndDate; |
| | | BillNew.omodel.HRepairContent = mainList[0].HRepairContent; |
| | | BillNew.omodel.HCycleUnit = mainList[0].HCycleUnit; |
| | | BillNew.omodel.HPlanTimes = mainList[0].HPlanTimes; |
| | | BillNew.omodel.HTimes = mainList[0].HTimes; |
| | | BillNew.omodel.HExplanation = mainList[0].HExplanation; |
| | | BillNew.omodel.HInnerBillNo = mainList[0].HInnerBillNo; |
| | | BillNew.omodel.HMouldID = mainList[0].HMouldID; |
| | | BillNew.omodel.HSupID = mainList[0].HSupID; |
| | | BillNew.omodel.HRepairType = mainList[0].HRepairType; |
| | | BillNew.omodel.HNewModel = mainList[0].HNewModel; |
| | | BillNew.omodel.HNewDesignLife = mainList[0].HNewDesignLife; |
| | | BillNew.omodel.HEquipID = mainList[0].HEquipID; |
| | | BillNew.DetailColl = new List<Model.ClsSb_MouldRepairWorkBillSub>(); |
| | | Model.ClsSb_MouldRepairWorkBillSub oSub = new Model.ClsSb_MouldRepairWorkBillSub(); |
| | | oSub.HEntryID = 1; |
| | | oSub.HRemark = DBUtility.ClsPub.isStrNull(subList[0].HRemark); |
| | | oSub.HSourceInterID = DBUtility.ClsPub.isLong(subList[0].HSourceInterID); |
| | | oSub.HSourceEntryID = DBUtility.ClsPub.isLong(subList[0].HSourceEntryID); |
| | | oSub.HSourceBillType = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillType); |
| | | oSub.HSourceBillNo = DBUtility.ClsPub.isStrNull(subList[0].HSourceBillNo); |
| | | oSub.HRelationQty = DBUtility.ClsPub.isDoule(subList[0].HRelationQty); |
| | | oSub.HRelationMoney = DBUtility.ClsPub.isDoule(subList[0].HRelationMoney); |
| | | oSub.HCloseMan = DBUtility.ClsPub.isStrNull(subList[0].HCloseMan); |
| | | oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(subList[0].HEntryCloseDate); |
| | | oSub.HCloseType = DBUtility.ClsPub.isBool(subList[0].HCloseType); |
| | | oSub.HRepairID = DBUtility.ClsPub.isLong(subList[0].HRepairID); |
| | | oSub.HManagerID = DBUtility.ClsPub.isLong(subList[0].HManagerID); |
| | | oSub.HMoney = DBUtility.ClsPub.isDoule(subList[0].HMoney); |
| | | oSub.HRepairExplanation = DBUtility.ClsPub.isStrNull(subList[0].HRepairExplanation); |
| | | BillNew.DetailColl.Add(oSub); |
| | | bResult = BillNew.AddBill(ref ClsPub.sExeReturnInfo); |
| | | if (bResult == true) |
| | | { |
| | | objJsonResult.code = "1"; |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = ClsPub.sExeReturnInfo + "åæ®å·:" + mainList[0].HBillNo.Trim(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "ä¿å失败!åå :" + ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "Exceptionï¼" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #endregion |
| | | |
| | | #region 模å
·å¯¿å½è°æ´å |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ æ¥çæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ ä¿åæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | |
| | | #region 模å
·æ¥åºå
¥åºå |
| | | |
| | | |
| | | |
| | | #region[模å
·æ¥åºå
¥åºåç¼è¾æ¶è·åè¡¨å¤´æ°æ®] |
| | | [Route("Sc_MouldScrapInHouseBill/Sc_MouldScrapInHouseBillListCheckDetai")] |
| | | [HttpGet] |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ ä¿åæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | } |
| | | #endregion |
| | | |
| | | |
| | | |
| | | |
| | | #region 模å
·æ¥åºå
¥åºåä¿å |
| | | |
| | | [Route("Sc_MouldScrapInHouseBill/SaveGetMouldScrapInHouseBillList_PDA")] |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ æ¥çæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ å 餿éï¼"; |
| | | objJsonResult.Message = "æ ä¿åæéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ²¡ææ¥çæé"; |
| | | objJsonResult.Message = "没æä¿åæé"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "æ²¡ææ¥çæé"; |
| | | objJsonResult.Message = "没æä¿åæé"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HBillNo,HDate," + |
| | | "HMaker,HMakeDate,HInnerBillNo,HRepairID,HDeptID,HRepairBeginDate,HRepairEndDate," + |
| | | "HCycleUnit,HPlanTimes,HTimes,HChangeNum,HEmpID,HManagerID,HRepairType,HSupID," + |
| | | "HNewMaterID,HNewName,HNewModel,HNewModel2,HExplanation,HRepairContent,HRemark" + |
| | | "HNewMaterID,HNewName,HNewModel,HNewModel2,HExplanation,HRepairContent,HRemark,HChangeType" + |
| | | ") " + |
| | | " values("+omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + this.BillType + "','" + this.HBillSubType + "'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" + |
| | | ",'" + omodel.HMaker + "',getdate()" + |
| | | ",'" + omodel.HInnerBillNo+"',"+ omodel.HRepairID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HRepairBeginDate + "','" + omodel.HRepairEndDate + |
| | | "','" + omodel.HCycleUnit + "'," + omodel.HPlanTimes.ToString() + "," + omodel.HTimes.ToString() + "," + omodel.HChangeNum.ToString() + "," + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + |
| | | ",'" + omodel.HRepairType + "'," + omodel.HSupID.ToString() + "," + omodel.HNewMaterID.ToString() + ",'"+ omodel.HNewName + "','" + omodel.HNewModel + "','" + omodel.HNewModel2 + "','" + omodel.HExplanation + "','" + omodel.HRepairContent + "','" + omodel.HRemark+ |
| | | "') "); |
| | | "','"+omodel.HChangeType + "') "); |
| | | //æå
¥å表 |
| | | foreach (Models.ClsSc_MouldRepairChangeBillSub oSub in DetailColl) |
| | | { |
| | |
| | | |
| | | |
| | | /// <summary> |
| | | /// å¤çæ°å¢ç¹æ£è®°å½è¡¨å表çjson |
| | | /// å¤çæ°å¢æ¨¡å
·ç¹æ£è®°å½è¡¨å表çjson |
| | | /// </summary> |
| | | /// <param name="jsonString"></param> |
| | | /// <returns></returns> |
| | |
| | | |
| | | |
| | | /// <summary> |
| | | /// å¤çæ°å¢ç¹æ£è®°å½åå表çjson |
| | | /// å¤çæ°å¢è®¾å¤ç¹æ£è®°å½è¡¨å表çjson |
| | | /// </summary> |
| | | /// <param name="jsonString"></param> |
| | | /// <returns></returns> |
| | | public List<Models.ClsSb_EquipDotCheckBillMain> getObjectByJson_Gy_EquipCheckBillMain(string jsonString) |
| | | { |
| | | jsonString = "[" + jsonString.ToString() + "]"; |
| | | List<Models.ClsSb_EquipDotCheckBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSb_EquipDotCheckBillMain>>(jsonString); |
| | | return list; |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// å¤çæ°å¢æ¨¡å
·ç¹æ£è®°å½åå表çjson |
| | | /// </summary> |
| | | /// <param name="jsonString"></param> |
| | | /// <returns></returns> |
| | |
| | | |
| | | |
| | | /// <summary> |
| | | /// å¤çæ°å¢è®¾å¤ç»´ä¿®è®°å½è¡¨å表çjson |
| | | /// </summary> |
| | | /// <param name="jsonString"></param> |
| | | /// <returns></returns> |
| | | public List<Models.ClsSb_EquipRepairWorkBillMain> wxmain(string jsonString) |
| | | { |
| | | jsonString = "[" + jsonString.ToString() + "]"; |
| | | List<Models.ClsSb_EquipRepairWorkBillMain> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSb_EquipRepairWorkBillMain>>(jsonString); |
| | | return list; |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// å¤çæ°å¢æ¨¡å
·ç»´ä¿®å½åå表çjson |
| | | /// </summary> |
| | | /// <param name="jsonString"></param> |
| | | /// <returns></returns> |
| | | public List<Models.ClsSb_EquipRepairWorkBillSub> wxsub(string jsonString) |
| | | { |
| | | jsonString = "[" + jsonString.ToString() + "]"; |
| | | List<Models.ClsSb_EquipRepairWorkBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSb_EquipRepairWorkBillSub>>(jsonString); |
| | | return list; |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// å¤çæ°å¢è®¾å¤ç¹æ£è®°å½åå表çjson |
| | | /// </summary> |
| | | /// <param name="jsonString"></param> |
| | | /// <returns></returns> |
| | | public List<Models.ClsSb_EquipDotCheckBillSub> getObjectByJson_Gy_EquipDotCheckBillSub(string jsonString) |
| | | { |
| | | jsonString = "[" + jsonString.ToString() + "]"; |
| | | List<Models.ClsSb_EquipDotCheckBillSub> list = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Models.ClsSb_EquipDotCheckBillSub>>(jsonString); |
| | | return list; |
| | | } |
| | | |
| | | |
| | | /// <summary> |
| | | /// å¤çæ°å¢ä¿å
»è®°å½è¡¨å表çjson |
| | | /// </summary> |
| | | /// <param name="jsonString"></param> |
| | |
| | | public string HMaterNumber; |
| | | public string HMaterName; |
| | | public string HMaterModel; |
| | | public Int64 HDotCheckItemID; |
| | | public string HDotCheckItem; |
| | | public string HDotCheckPart; |
| | | public string HClaim; |
| | |
| | | public string HDotCheckPart;// varchar(100) --ç¹æ£é¨ä½ |
| | | public string HClaim;// varchar(100) --å
·ä½è¦æ± |
| | | public long HManagerID;// int --è´è´£äººid(h_v_IF_Employee) |
| | | public long HDotCheckItemID;// int --è´è´£äººid(h_v_IF_Employee) |
| | | |
| | | |
| | | } |
| | | } |
| | |
| | | public string HNewBarCode; /*--æ¹å¶åæ°æ¡ç */ |
| | | public string HNewDesignLife; /*--æ°è®¾è®¡å¯¿å½*/ |
| | | public string HExplanation; /* --æ¹å¶è¦æ±*/ |
| | | public string HChangeType; /* --æ¹åç±»å*/ |
| | | public string HRemark; /* --夿³¨*/ |
| | | public string HInnerBillNo; /* --å
é¨åæ®å·*/ |
| | | } |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using System.Web; |
| | | |
| | | namespace WebAPI.Models |
| | | { |
| | | public class Xt_DataDictionary_Proc |
| | | { |
| | | public long HItemID { get; set; } |
| | | public long HModNameID { get; set; } |
| | | public long HBillTypeID { get; set; } |
| | | public string HProcName { get; set; } |
| | | |
| | | public string HProcCaption { get; set; } |
| | | public string HRemark { get; set; } |
| | | public bool HStopflag { get; set; } |
| | | |
| | | public DateTime HMakeTime { get; set; } |
| | | |
| | | public string HMakeEmp { get; set; } |
| | | public DateTime HModifyTime { get; set; } |
| | | |
| | | public string HModifyEmp { get; set; } |
| | | public DateTime HStopTime { get; set; } |
| | | |
| | | public string HStopEmp { get; set; } |
| | | |
| | | |
| | | |
| | | |
| | | } |
| | | } |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using System.Web; |
| | | |
| | | namespace WebAPI.Models |
| | | { |
| | | public class Xt_DataDictionary_Table |
| | | { |
| | | public long HItemID { get; set; } |
| | | public long HModNameID { get; set; } |
| | | public long HBillTypeID { get; set; } |
| | | public string HTableName { get; set; } |
| | | |
| | | public string HTableCaption { get; set; } |
| | | |
| | | public string HFieldName { get; set; } |
| | | |
| | | public string HFieldCaption { get; set; } |
| | | |
| | | public string HDataType { get; set; } |
| | | |
| | | public string HDefaultValue { get; set; } |
| | | |
| | | public string HRemark { get; set; } |
| | | public bool HStopflag { get; set; } |
| | | |
| | | public DateTime HMakeTime { get; set; } |
| | | |
| | | public string HMakeEmp { get; set; } |
| | | public DateTime HModifyTime { get; set; } |
| | | |
| | | public string HModifyEmp { get; set; } |
| | | public DateTime HStopTime { get; set; } |
| | | |
| | | public string HStopEmp { get; set; } |
| | | |
| | | |
| | | |
| | | |
| | | } |
| | | } |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using System.Web; |
| | | |
| | | namespace WebAPI.Models |
| | | { |
| | | public class Xt_DataDictionary_View |
| | | { |
| | | public long HItemID { get; set; } |
| | | public long HModNameID { get; set; } |
| | | public long HBillTypeID { get; set; } |
| | | public string HViewName { get; set; } |
| | | |
| | | public string HViewCaption { get; set; } |
| | | public string HRemark { get; set; } |
| | | public bool HStopflag { get; set; } |
| | | |
| | | public DateTime HMakeTime { get; set; } |
| | | |
| | | public string HMakeEmp { get; set; } |
| | | public DateTime HModifyTime { get; set; } |
| | | |
| | | public string HModifyEmp { get; set; } |
| | | public DateTime HStopTime { get; set; } |
| | | |
| | | public string HStopEmp { get; set; } |
| | | |
| | | |
| | | |
| | | |
| | | } |
| | | } |
New file |
| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using System.Web; |
| | | |
| | | namespace WebAPI.Models |
| | | { |
| | | public class Gy_ClassTimePrj |
| | | { |
| | | public long HItemID { get; set; } |
| | | |
| | | public string HName { get; set; } |
| | | public string HNumber { get; set; } |
| | | public long HParentID { get; set; } |
| | | public string HRemark { get; set; } |
| | | |
| | | public long HDeptID { get; set; } |
| | | public long HGroupID { get; set; } |
| | | public bool HStopflag { get; set; } |
| | | |
| | | |
| | | |
| | | } |
| | | } |
| | |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | | <File Include="apiapp.json"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="bin/Antlr3.Runtime.dll"> |
| | | <publishTime>02/22/2013 16:43:40</publishTime> |
| | | <publishTime>02/22/2013 08:43:40</publishTime> |
| | | </File> |
| | | <File Include="bin/Antlr3.Runtime.pdb"> |
| | | <publishTime>02/22/2013 16:43:40</publishTime> |
| | | <publishTime>02/22/2013 08:43:40</publishTime> |
| | | </File> |
| | | <File Include="bin/BLL.dll"> |
| | | <publishTime>10/25/2021 15:05:07</publishTime> |
| | | <publishTime>10/27/2021 13:50:19</publishTime> |
| | | </File> |
| | | <File Include="bin/BLL.pdb"> |
| | | <publishTime>10/25/2021 15:05:07</publishTime> |
| | | <publishTime>10/27/2021 13:50:19</publishTime> |
| | | </File> |
| | | <File Include="bin/DAL.dll"> |
| | | <publishTime>10/25/2021 15:05:03</publishTime> |
| | | <publishTime>10/27/2021 13:50:17</publishTime> |
| | | </File> |
| | | <File Include="bin/DAL.pdb"> |
| | | <publishTime>10/25/2021 15:05:03</publishTime> |
| | | <publishTime>10/27/2021 13:50:17</publishTime> |
| | | </File> |
| | | <File Include="bin/Dapper.dll"> |
| | | <publishTime>07/22/2016 22:52:40</publishTime> |
| | | <publishTime>07/22/2016 14:52:40</publishTime> |
| | | </File> |
| | | <File Include="bin/DBUtility.dll"> |
| | | <publishTime>10/25/2021 15:04:54</publishTime> |
| | | <publishTime>10/25/2021 09:28:38</publishTime> |
| | | </File> |
| | | <File Include="bin/DBUtility.pdb"> |
| | | <publishTime>10/25/2021 15:04:54</publishTime> |
| | | <publishTime>10/25/2021 09:28:38</publishTime> |
| | | </File> |
| | | <File Include="bin/Interop.gregn6Lib.dll"> |
| | | <publishTime>08/25/2021 10:28:25</publishTime> |
| | | </File> |
| | | <File Include="bin/Kingdee.BOS.WebApi.Client.dll"> |
| | | <publishTime>08/09/2021 15:55:13</publishTime> |
| | | <publishTime>10/14/2021 09:42:44</publishTime> |
| | | </File> |
| | | <File Include="bin/Kingdee.BOS.WebApi.FormService.dll"> |
| | | <publishTime>09/20/2018 19:23:20</publishTime> |
| | |
| | | <publishTime>09/20/2018 19:28:34</publishTime> |
| | | </File> |
| | | <File Include="bin/Microsoft.Azure.AppService.ApiApps.Service.dll"> |
| | | <publishTime>03/19/2015 01:02:50</publishTime> |
| | | <publishTime>03/18/2015 17: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 19:48:56</publishTime> |
| | | <publishTime>07/25/2012 11:48:56</publishTime> |
| | | </File> |
| | | <File Include="bin/Model.dll"> |
| | | <publishTime>10/25/2021 15:04:56</publishTime> |
| | | <publishTime>10/26/2021 10:32:42</publishTime> |
| | | </File> |
| | | <File Include="bin/Model.pdb"> |
| | | <publishTime>10/25/2021 15:04:56</publishTime> |
| | | <publishTime>10/26/2021 10:32:42</publishTime> |
| | | </File> |
| | | <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="bin/Newtonsoft.Json.dll"> |
| | | <publishTime>08/04/2014 04:33:56</publishTime> |
| | | <publishTime>08/03/2014 20:33:56</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Class.dll"> |
| | | <publishTime>10/25/2021 15:04:51</publishTime> |
| | | <publishTime>10/25/2021 09:28:37</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Class.pdb"> |
| | | <publishTime>10/25/2021 15:04:51</publishTime> |
| | | <publishTime>10/25/2021 09:28:37</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Control.dll"> |
| | | <publishTime>10/25/2021 15:04:52</publishTime> |
| | | <publishTime>10/25/2021 09:28:38</publishTime> |
| | | </File> |
| | | <File Include="bin/Pub_Control.pdb"> |
| | | <publishTime>10/25/2021 15:04:52</publishTime> |
| | | <publishTime>10/25/2021 09:28:38</publishTime> |
| | | </File> |
| | | <File Include="bin/SQLHelper.dll"> |
| | | <publishTime>10/25/2021 15:04:53</publishTime> |
| | | <publishTime>10/25/2021 09:28:38</publishTime> |
| | | </File> |
| | | <File Include="bin/SQLHelper.pdb"> |
| | | <publishTime>10/25/2021 15:04:53</publishTime> |
| | | <publishTime>10/25/2021 09:28:38</publishTime> |
| | | </File> |
| | | <File Include="bin/stdole.dll"> |
| | | <publishTime>05/09/2021 13:35:37</publishTime> |
| | | </File> |
| | | <File Include="bin/Swashbuckle.Core.dll"> |
| | | <publishTime>02/16/2015 01:57:08</publishTime> |
| | | <publishTime>02/15/2015 17: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 18:03:34</publishTime> |
| | | <publishTime>08/19/2014 10: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 21:00:36</publishTime> |
| | | <publishTime>11/28/2018 13: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 20:58:44</publishTime> |
| | | <publishTime>11/28/2018 12: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 12:04:30</publishTime> |
| | | <publishTime>01/28/2015 04:04:30</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Http.Cors.dll"> |
| | | <publishTime>11/28/2018 21:01:26</publishTime> |
| | | <publishTime>11/28/2018 13:01:26</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Http.dll"> |
| | | <publishTime>11/28/2018 21:01:00</publishTime> |
| | | <publishTime>11/28/2018 13:01:00</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Http.WebHost.dll"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Mvc.dll"> |
| | | <publishTime>01/28/2015 12:02:18</publishTime> |
| | | <publishTime>01/28/2015 04:02:18</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Optimization.dll"> |
| | | <publishTime>02/11/2014 23:26:04</publishTime> |
| | | <publishTime>02/11/2014 15:26:04</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.Razor.dll"> |
| | | <publishTime>01/28/2015 12:02:32</publishTime> |
| | | <publishTime>01/28/2015 04: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 12:04:30</publishTime> |
| | | <publishTime>01/28/2015 04:04:30</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.WebPages.dll"> |
| | | <publishTime>01/28/2015 12:04:30</publishTime> |
| | | <publishTime>01/28/2015 04:04:30</publishTime> |
| | | </File> |
| | | <File Include="bin/System.Web.WebPages.Razor.dll"> |
| | | <publishTime>01/28/2015 12:04:30</publishTime> |
| | | <publishTime>01/28/2015 04: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 19:18:48</publishTime> |
| | | <publishTime>11/24/2014 11:18:48</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.dll"> |
| | | <publishTime>10/25/2021 15:05:11</publishTime> |
| | | <publishTime>10/29/2021 00:14:13</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.pdb"> |
| | | <publishTime>10/25/2021 15:05:11</publishTime> |
| | | <publishTime>10/29/2021 00:14:13</publishTime> |
| | | </File> |
| | | <File Include="bin/WebGrease.dll"> |
| | | <publishTime>07/18/2013 01:03:52</publishTime> |
| | | <publishTime>07/17/2013 17:03:52</publishTime> |
| | | </File> |
| | | <File Include="bin/zh-Hans/System.Net.Http.Formatting.resources.dll"> |
| | | <publishTime>11/29/2018 21:26:02</publishTime> |
| | | <publishTime>11/29/2018 13:26:02</publishTime> |
| | | </File> |
| | | <File Include="bin/zh-Hans/System.Web.Http.resources.dll"> |
| | | <publishTime>11/29/2018 21:26:30</publishTime> |
| | | <publishTime>11/29/2018 13:26:30</publishTime> |
| | | </File> |
| | | <File Include="Content/bootstrap.css"> |
| | | <publishTime>08/09/2021 15:55:23</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Content/bootstrap.min.css"> |
| | | <publishTime>08/09/2021 15:55:23</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Content/Site.css"> |
| | | <publishTime>08/09/2021 15:55:23</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="DLL/BLL.dll"> |
| | | <publishTime>08/09/2021 15:55:23</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="DLL/DAL.dll"> |
| | | <publishTime>08/09/2021 15:55:23</publishTime> |
| | | <publishTime>10/27/2021 13:49:58</publishTime> |
| | | </File> |
| | | <File Include="DLL/DBUtility.dll"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="DLL/Kingdee.BOS.WebApi.Client.dll"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="DLL/Model.dll"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="DLL/Newtonsoft.Json.Net35.dll"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="DLL/Pub_Class.dll"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="DLL/Pub_Control.dll"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="DLL/SQLHelper.dll"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.eot"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.svg"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.ttf"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="fonts/glyphicons-halflings-regular.woff"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Global.asax"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Index.html"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Metadata/deploymentTemplates/apiappconfig.azureresource.json"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="packages.config"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/bootstrap.js"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/bootstrap.min.js"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.js"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.min.js"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery-1.10.2.min.map"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.js"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.min.js"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.unobtrusive.js"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/jquery.validate.unobtrusive.min.js"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Views/Scripts/modernizr-2.6.2.js"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Views/Shared/Error.cshtml"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Views/Shared/_Layout.cshtml"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Views/web.config"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Views/_ViewStart.cshtml"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Customer_Model.datasource"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Department_Model.datasource"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Employee_Model.datasource"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_StockPlace_Model.datasource"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Supplier_Model.datasource"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsCLD_Warehouse_Model.datasource"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_BadReason_Model.datasource"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_BarCodeBill_WMS_Model_View.datasource"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Customer_Model.datasource"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Department_Model.datasource"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Employee_Model.datasource"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Group_Model.datasource"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Item30JiTai_Model.datasource"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Source_Model.datasource"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_StockPlace_Model.datasource"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Supplier_Model.datasource"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsGy_Warehouse_Model.datasource"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/ClsKf_ICStockBill_WMS.datasource"> |
| | | <publishTime>08/09/2021 15:55:25</publishTime> |
| | | <publishTime>10/14/2021 09:42:47</publishTime> |
| | | </File> |
| | | <File Include="Web References/WebS/Reference.map"> |
| | | <publishTime>08/06/2021 22:57:28</publishTime> |
| | | </File> |
| | | <File Include="Web.config"> |
| | | <publishTime>10/25/2021 15:08:19</publishTime> |
| | | <publishTime>10/25/2021 09:28:44</publishTime> |
| | | </File> |
| | | </ItemGroup> |
| | | </Project> |
| | |
| | | <Compile Include="App_Start\RouteConfig.cs" /> |
| | | <Compile Include="App_Start\SwaggerConfig.cs" /> |
| | | <Compile Include="App_Start\WebApiConfig.cs" /> |
| | | <Compile Include="Controllers\BaseSet\Gy_ClassTimePrjController.cs" /> |
| | | <Compile Include="Controllers\BaseSet\Xt_DataDictionary_ProcController.cs" /> |
| | | <Compile Include="Controllers\BaseSet\Xt_DataDictionary_ViewController.cs" /> |
| | | <Compile Include="Controllers\BaseSet\Xt_DataDictionary_TableController.cs" /> |
| | | <Compile Include="Controllers\BaseSet\Gy_ModelTypeController.cs" /> |
| | | <Compile Include="Controllers\BaseSet\Gy_QCCheckClassController.cs" /> |
| | |
| | | <Compile Include="Models\ClsSc_MouldRepairOutBillMain.cs" /> |
| | | <Compile Include="Models\ClsSc_MouldRepairOutBillSub.cs" /> |
| | | <Compile Include="Models\ClsGy_ProcPrice.cs" /> |
| | | <Compile Include="Models\Xt_DataDictionary_Proc.cs" /> |
| | | <Compile Include="Models\Xt_DataDictionary_View.cs" /> |
| | | <Compile Include="Models\Xt_DataDictionary_Table.cs" /> |
| | | <Compile Include="Models\Gy_User.cs" /> |
| | | <Compile Include="Models\Gy_UserSupper.cs" /> |
| | | <Compile Include="Models\Menu.cs" /> |
| | |
| | | <Compile Include="Models\WW_EntrustWorkOrderViewModel.cs" /> |
| | | <Compile Include="Models\åºç¡èµæ\Gy_Employee.cs" /> |
| | | <Compile Include="Models\åºç¡èµæ\Gy_Process.cs" /> |
| | | <Compile Include="Models\åºç¡èµæ\Gy_ClassTimePrj.cs" /> |
| | | <Compile Include="Models\åºç¡èµæ\Warehouse.cs" /> |
| | | <Compile Include="Properties\Resources.Designer.cs"> |
| | | <AutoGen>True</AutoGen> |