分布式调入单、分布式调出单:增加字段 项目HProjectID
| | |
| | | public string HExplanation; // varchar(200) --ÕªÒª |
| | | public string HInnerBillNo; // varchar(50) --å
é¨åæ®å· |
| | | |
| | | public Int64 HProjectID; //-é¡¹ç® |
| | | |
| | | public Int64 HCurID; |
| | | } |
| | | } |
| | |
| | | public Int64 HCurID; |
| | | public Int64 HPSStyleID; |
| | | |
| | | public Int64 HProjectID; //-é¡¹ç® |
| | | |
| | | } |
| | | } |
| | |
| | | string HCloseMan = mainList[0].HCloseMan; |
| | | string HCloseDate = mainList[0].HCloseDate; |
| | | long HCurID = mainList[0].HCurID; |
| | | long HProjectID = mainList[0].HProjectID; //-é¡¹ç® |
| | | |
| | | //è¿è¡ ä¼è®¡æé´ ç»è´¦ çå¤æåæ§å¶ |
| | | string s = ""; |
| | | //è¿è¡ ä¼è®¡æé´ ç»è´¦ çå¤æåæ§å¶ |
| | | string s = ""; |
| | | int sYear = 0; |
| | | int sPeriod = 0; |
| | | if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) |
| | |
| | | ,HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID,HKeeperID,HDeptID |
| | | ,HMaker,HMakeDate,HChecker,HUpDater |
| | | ,HDeleteMan,HCloseMan |
| | | ,HRemark,HExplanation,HInnerBillNo,HCurID) |
| | | ,HRemark,HExplanation,HInnerBillNo,HCurID,HProjectID) |
| | | values(" + HInterID + ",'" + HBillNo + "','" + HDate + "','" + 1250 + "','" + |
| | | 1250 + "'," + HBillStatus + "," + DateTime.Now.Year + "," + DateTime.Now.Month + "," + HSupID + |
| | | "," + HWHID + "," + HSCWHID + "," + HEmpID + "," + HManagerID + "," + HSecManagerID + |
| | | "," + HKeeperID + "," + HDeptID + ",'" + HMaker + "','" + HMakeDate + "','" + HChecker + "','" + HUpDater + "','" + HDeleteMan + "','" + HCloseMan + "','" |
| | | + HRemark + "','" + HExplanation + "','" + HInnerBillNo + "'," + HCurID + "" + ")"); |
| | | + HRemark + "','" + HExplanation + "','" + HInnerBillNo + "'," + HCurID + "," + HProjectID + "" + ")"); |
| | | } |
| | | else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) |
| | | { //ä¿®æ¹ |
| | |
| | | String sql="update Kf_ICStockBillMain set " + |
| | | "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + |
| | | ",HSupID=" + HSupID + ",HWHID=" + HWHID + ",HSCWHID=" + HSCWHID + ", HEmpID=" + HEmpID + ",HManagerID=" + HManagerID + ",HSecManagerID = " + HSecManagerID |
| | | + ",HKeeperID=" + HKeeperID + ",HDeptID=" + HDeptID + " where HInterID=" + HInterID; |
| | | + ",HKeeperID=" + HKeeperID + ",HDeptID=" + HDeptID + ",HProjectID=" + HProjectID + " where HInterID=" + HInterID; |
| | | |
| | | oCn.RunProc(sql); |
| | | //å é¤å表 |
| | |
| | | string HCloseMan = mainList[0].HCloseMan; |
| | | string HCloseDate = mainList[0].HCloseDate; |
| | | long HCurID = mainList[0].HCurID; |
| | | long HProjectID = mainList[0].HProjectID; //-é¡¹ç® |
| | | |
| | | //è¿è¡ ä¼è®¡æé´ ç»è´¦ çå¤æåæ§å¶ |
| | | string s = ""; |
| | |
| | | ,HSupID,HWHID,HSCWHID,HEmpID,HManagerID,HSecManagerID,HKeeperID,HDeptID |
| | | ,HMaker,HMakeDate,HChecker,HUpDater |
| | | ,HDeleteMan,HCloseMan |
| | | ,HRemark,HExplanation,HInnerBillNo,HCurID) |
| | | ,HRemark,HExplanation,HInnerBillNo,HCurID,HProjectID) |
| | | values(" + HInterID + ",'" + HBillNo + "','" + HDate + "','" + 1251 + "','" + |
| | | 1251 + "'," + HBillStatus + "," + DateTime.Now.Year + "," + DateTime.Now.Month + "," + HSupID + |
| | | "," + HWHID + "," + HSCWHID + "," + HEmpID + "," + HManagerID + "," + HSecManagerID + |
| | | "," + HKeeperID + "," + HDeptID + ",'" + HMaker + "','" + HMakeDate + "','" + HChecker + "','" + HUpDater + "','" + HDeleteMan + "','" + HCloseMan + "','" |
| | | + HRemark + "','" + HExplanation + "','" + HInnerBillNo + "'," + HCurID + "" + ")"); |
| | | + HRemark + "','" + HExplanation + "','" + HInnerBillNo + "'," + HCurID + "," + HProjectID + "" + ")"); |
| | | } |
| | | else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) |
| | | { //ä¿®æ¹ |
| | |
| | | String sql = "update Kf_ICStockBillMain set " + |
| | | "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + |
| | | ",HSupID=" + HSupID + ",HWHID=" + HWHID + ",HSCWHID=" + HSCWHID + ", HEmpID=" + HEmpID + ",HManagerID=" + HManagerID + ",HSecManagerID = " + HSecManagerID |
| | | + ",HKeeperID=" + HKeeperID + ",HDeptID=" + HDeptID + " where HInterID=" + HInterID; |
| | | + ",HKeeperID=" + HKeeperID + ",HDeptID=" + HDeptID + ",HProjectID=" + HProjectID + " where HInterID=" + HInterID; |
| | | |
| | | oCN.RunProc(sql); |
| | | |
| | |
| | | --> |
| | | <Project ToolsVersion="4.0" xmlns="http://schemas.microsoft.com/developer/msbuild/2003"> |
| | | <PropertyGroup> |
| | | <History>True|2024-11-26T00:24:31.3112433Z;False|2024-11-26T08:23:46.0894924+08:00;True|2024-11-20T10:16:03.7893118+08:00;False|2024-11-20T10:15:23.2632533+08:00;True|2024-11-20T09:06:55.2799108+08:00;False|2024-11-20T09:05:45.8751214+08:00;True|2024-11-15T10:50:02.2079520+08:00;False|2024-11-15T10:49:22.4156447+08:00;True|2024-11-11T16:53:33.6615343+08:00;False|2024-11-11T16:52:17.7499691+08:00;False|2024-11-06T11:32:23.8339166+08:00;True|2024-10-24T20:08:16.1196372+08:00;True|2024-10-24T14:53:21.0804405+08:00;False|2024-10-24T14:50:14.4659302+08:00;</History> |
| | | <History>True|2024-11-26T00:55:53.9125170Z;True|2024-11-26T08:24:31.3112433+08:00;False|2024-11-26T08:23:46.0894924+08:00;True|2024-11-20T10:16:03.7893118+08:00;False|2024-11-20T10:15:23.2632533+08:00;True|2024-11-20T09:06:55.2799108+08:00;False|2024-11-20T09:05:45.8751214+08:00;True|2024-11-15T10:50:02.2079520+08:00;False|2024-11-15T10:49:22.4156447+08:00;True|2024-11-11T16:53:33.6615343+08:00;False|2024-11-11T16:52:17.7499691+08:00;False|2024-11-06T11:32:23.8339166+08:00;True|2024-10-24T20:08:16.1196372+08:00;True|2024-10-24T14:53:21.0804405+08:00;False|2024-10-24T14:50:14.4659302+08:00;</History> |
| | | <_PublishTargetUrl>D:\ç½ç«åå¸\æºäºMESWMS\API</_PublishTargetUrl> |
| | | </PropertyGroup> |
| | | <ItemGroup> |
| | |
| | | <publishTime>02/22/2013 16:43:40</publishTime> |
| | | </File> |
| | | <File Include="bin/BLL.dll"> |
| | | <publishTime>11/26/2024 08:24:01</publishTime> |
| | | <publishTime>11/26/2024 08:55:11</publishTime> |
| | | </File> |
| | | <File Include="bin/BLL.pdb"> |
| | | <publishTime>11/26/2024 08:24:01</publishTime> |
| | | <publishTime>11/26/2024 08:55:11</publishTime> |
| | | </File> |
| | | <File Include="bin/BouncyCastle.Crypto.dll"> |
| | | <publishTime>12/18/2020 05:32:28</publishTime> |
| | | </File> |
| | | <File Include="bin/DAL.dll"> |
| | | <publishTime>11/26/2024 08:23:59</publishTime> |
| | | <publishTime>11/26/2024 08:55:07</publishTime> |
| | | </File> |
| | | <File Include="bin/DAL.pdb"> |
| | | <publishTime>11/26/2024 08:23:59</publishTime> |
| | | <publishTime>11/26/2024 08:55:07</publishTime> |
| | | </File> |
| | | <File Include="bin/Dapper.dll"> |
| | | <publishTime>07/22/2016 22:52:40</publishTime> |
| | |
| | | <publishTime>07/25/2012 19:48:56</publishTime> |
| | | </File> |
| | | <File Include="bin/Model.dll"> |
| | | <publishTime>11/26/2024 08:23:56</publishTime> |
| | | <publishTime>11/26/2024 08:55:02</publishTime> |
| | | </File> |
| | | <File Include="bin/Model.pdb"> |
| | | <publishTime>11/26/2024 08:23:56</publishTime> |
| | | <publishTime>11/26/2024 08:55:02</publishTime> |
| | | </File> |
| | | <File Include="bin/Models/ClsSc_MouldScrapOutBillMain.cs"> |
| | | <publishTime>04/06/2023 15:57:02</publishTime> |
| | |
| | | <publishTime>11/24/2014 19:18:48</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.dll"> |
| | | <publishTime>11/26/2024 08:24:26</publishTime> |
| | | <publishTime>11/26/2024 08:55:48</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.pdb"> |
| | | <publishTime>11/26/2024 08:24:26</publishTime> |
| | | <publishTime>11/26/2024 08:55:48</publishTime> |
| | | </File> |
| | | <File Include="bin/WebAPI.XmlSerializers.dll"> |
| | | <publishTime>11/26/2024 08:24:30</publishTime> |
| | | <publishTime>11/26/2024 08:55:52</publishTime> |
| | | </File> |
| | | <File Include="bin/WebGrease.dll"> |
| | | <publishTime>07/18/2013 01:03:52</publishTime> |