| | |
|---|
| | | double HStdSourceQty = mainList[0].HStdSourceQty;//标准资源数 |
|---|
| | | double HAddSourceRate = mainList[0].HAddSourceRate;//加资源增量 |
|---|
| | | double HDelSourceRate = mainList[0].HDelSourceRate;//减资源减量 |
|---|
| | | int HPRDORGID = mainList[0].HPRDORGID; //组织 |
|---|
| | | |
|---|
| | | //主表 |
|---|
| | | oCN.RunProc("Insert Into Gy_RoutingBillMain " + |
|---|
| | |
|---|
| | | ",HYear,HPeriod,HRemark,HMaker,Hmakedate,HMaterID,HName,HMaterTypeID" + |
|---|
| | | ",HRoutingGroupID,HUnitID,HMaterNumber,HUnitNumber,HStandard" + |
|---|
| | | ",HMainGroupID,HMainProcID,HMainCenterID,HMainTimeUnit,HMainUnitTime,HMainWorkQty" + |
|---|
| | | ",HMainPrice,HStdSourceQty,HAddSourceRate,HDelSourceRate" + |
|---|
| | | ",HMainPrice,HStdSourceQty,HAddSourceRate,HPRDORGID,HDelSourceRate" + |
|---|
| | | ") " + |
|---|
| | | " values('" + BillType + "'," + HInterID + ",'" + HBillNo + "','" + HDate + "'" + |
|---|
| | | "," + HYear + "," + HPeriod + ",'" + HRemark + "','" + HMaker + "',getdate()," + HMaterID + ",'" + HName + "'," + HMaterTypeID + |
|---|
| | | "," + HRoutingGroupID + "," + HUnitID + ",'" + HMaterNumber + "','" + HUnitNumber + "'," + Convert.ToString(HStandard ? 1 : 0) + |
|---|
| | | "," + HMainGroupID + "," + HMainProcID + "," + HMainCenterID + ",'" + HMainTimeUnit + "'," + HMainUnitTime + "," + HMainWorkQty + |
|---|
| | | "," + HMainPrice + "," + HStdSourceQty + "," + HAddSourceRate + "," + HDelSourceRate + |
|---|
| | | "," + HMainPrice + "," + HStdSourceQty + "," + HAddSourceRate + "," + HPRDORGID + "," + HDelSourceRate + |
|---|
| | | ") "); |
|---|
| | | |
|---|
| | | //保存子表 |
|---|
