| | |
| | | public string HBackerDate; |
| | | public string HBackRemark; |
| | | public string HChangeType; |
| | | public string HChangeValue; |
| | | public Double HChangeValue; |
| | | } |
| | | #endregion |
| | | #region å表 |
| | |
| | | public double HRelationMoney; |
| | | public string HCloseMan; |
| | | public string HEntryCloseDate; |
| | | public int HWorkCenterID; |
| | | } |
| | | #endregion |
| | | #region å®é¢ç³è¯·å æ°å¢/ç¼è¾ |
| | |
| | | string HBackerDate = mainList[0].HBackerDate; |
| | | string HBackRemark = mainList[0].HBackRemark; |
| | | string HChangeType = mainList[0].HChangeType; |
| | | string HChangeValue = mainList[0].HChangeValue; |
| | | Double HChangeValue = mainList[0].HChangeValue; |
| | | //ä¿ååæ§å¶ |
| | | DataSet BeforeDs = oCn.RunProcReturn("Exec h_p_Pay_ProcPriceRequestBill_BeforeSaveCtrl " + HInterID.ToString() + ",'" + HBillNo + "'," + OperationType.ToString(), "h_p_Pay_ProcPriceRequestBill_BeforeSaveCtrl"); |
| | | if (BeforeDs == null || BeforeDs.Tables[0].Rows.Count == 0) |
| | |
| | | } |
| | | else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) //ç¼è¾ |
| | | { |
| | | |
| | | string sql = "update Pay_ProcPriceRequestBillMain set " + |
| | | "HYear = " + HYear + |
| | | ", HPeriod = " + HPeriod + |
| | |
| | | string HSourceBillType = oSub.HSourceBillType; |
| | | double HRelationQty = oSub.HRelationQty; |
| | | double HRelationMoney = oSub.HRelationMoney; |
| | | |
| | | int HWorkCenterID = oSub.HWorkCenterID; |
| | | |
| | | |
| | | string sql = "insert into Pay_ProcPriceRequestBillSub" + |
| | | "(HInterID,HEntryID,HMaterID,HProcID,HSourceID,HOldPrice,HPrice,HOldFixPrice,HFixPrice,HBeginDate,HEndDate,HCostFlag,HRemark,HSourceInterID,HSourceEntryID,HSourceBillNo" + |
| | | ",HSourceBillType,HRelationQty,HRelationMoney) " + |
| | | ",HSourceBillType,HRelationQty,HRelationMoney,HWorkCenterID) " + |
| | | "values(" + |
| | | "" + HInterID + |
| | | "," + HEntryID + |
| | |
| | | "','" + HSourceBillType + |
| | | "'," + HRelationQty + |
| | | "," + HRelationMoney + |
| | | "," + HWorkCenterID + |
| | | ")"; |
| | | |
| | | oCn.RunProc(sql); |