| | |
| | | public class PM_ProjectBill_Main |
| | | { |
| | | public int HInterID; |
| | | public string HBillSubType; |
| | | public string HBillNo; |
| | | public string HProNumber; |
| | | public string HProName; |
| | |
| | | int HYear = int.Parse(mainList[0].HDate.Split('-')[0]); |
| | | int HPeriod = int.Parse(mainList[0].HDate.Split('-')[1]); |
| | | string HBillType = "4750"; |
| | | string HBillSubType = ""; |
| | | string HBillSubType = mainList[0].HBillSubType; |
| | | int HInterID = mainList[0].HInterID; |
| | | string HDate = mainList[0].HDate; |
| | | string HBillNo = mainList[0].HBillNo; |
| | |
| | | else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) //缂栬緫 |
| | | { |
| | | string sql = "update PM_ProjectBillMain set " + |
| | | "HYear = " + HYear + |
| | | ",HPeriod = " + HPeriod + |
| | | ",HBillType = '" + HBillType + |
| | | "',HBillSubType = '" + HBillSubType + |
| | | "',HDate = '" + HDate + |
| | | "',HBillNo = '" + HBillNo + |
| | | "',HBillStatus = " + HBillStatus + |
| | | ",HRemark = '" + HRemark + |
| | | //"HYear = " + HYear + |
| | | //",HPeriod = " + HPeriod + |
| | | //",HBillType = '" + HBillType + |
| | | //"',HBillSubType = '" + HBillSubType + |
| | | //"',HDate = '" + HDate + |
| | | "HBillNo = '" + HBillNo + |
| | | //"',HBillStatus = " + HBillStatus + |
| | | "',HRemark = '" + HRemark + |
| | | "',HUpdater = '" + HUpdater + |
| | | "',HUpdateDate = '" + HUpdaterDate + |
| | | "',HProNumber = '" + HProNumber + |