| | |
| | | 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); |
| | | |