| | |
|---|
| | | |
|---|
| | | long HInterID = mainList[0].HInterID;//閫掑叆type寰楀埌鐨勫崟鎹甀D |
|---|
| | | string HBillNo = mainList[0].HBillNo;//閫掑叆type寰楀埌鐨勫崟鎹彿 |
|---|
| | | string HMainSourceBillSubType = mainList[0].HMainSourceBillSubType; |
|---|
| | | long HPRDORGID = mainList[0].HPRDORGID;//缁勭粐 |
|---|
| | | DateTime HDate = mainList[0].HDate;//鏃ユ湡 |
|---|
| | | string HRemark = mainList[0].HRemark;//澶囨敞 |
|---|
| | |
|---|
| | | { |
|---|
| | | //涓昏〃 |
|---|
| | | oCN.RunProc(@"Insert Into Sc_ICMOBillMain |
|---|
| | | (HBillType,HBillStatus,HInterID,HBillNo,HDate,HPRDORGID |
|---|
| | | (HBillType,HMainSourceBillSubType,HBillStatus,HInterID,HBillNo,HDate,HPRDORGID |
|---|
| | | ,HYear,HPeriod,HRemark,HMaker,HMakeDate |
|---|
| | | ,HSeOrderBillNo,HSeOrderInterID,HSeOrderEntryID,HEmpID,HCusID |
|---|
| | | ,HCenterID,HPlanQty,HDeptID,HMaterID,HUnitID,HBomID,HPlanBeginDate,HPlanEndDate |
|---|
| | | ,HIsStockQty,HRemark3) |
|---|
| | | values('3710',1," + HInterID + ",'" + HBillNo + "','" + HDate + "'," + HPRDORGID + |
|---|
| | | values('3710','" + (HMainSourceBillSubType==null?"":HMainSourceBillSubType) + "',1," + HInterID + ",'" + HBillNo + "','" + HDate + "'," + HPRDORGID + |
|---|
| | | "," + DateTime.Now.Year + "," + DateTime.Now.Month + ",'" + HRemark + "','" + HMaker + "',getdate()" + |
|---|
| | | ",'" + HSeOrderBillNo + "'," + HSeOrderInterID + "," + HSeOrderEntryID + "," + HEmpID + "," + HCusID + |
|---|
| | | "," + HCenterID + ",0,0,0,0," + HBomID + ",'',''" + |
|---|
| | |
|---|
| | | |
|---|
| | | //淇敼 |
|---|
| | | oCN.RunProc("update Sc_ICMOBillMain set " + |
|---|
| | | "HMainSourceBillSubType='" + (HMainSourceBillSubType == null ? "" : HMainSourceBillSubType) + "'," + |
|---|
| | | "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + |
|---|
| | | ", HSeOrderBillNo='" + HSeOrderBillNo + "', HSeOrderInterID=" + HSeOrderInterID + ", HSeOrderEntryID=" + HSeOrderEntryID + ", HEmpID=" + HEmpID + ", HCusID=" + HCusID + |
|---|
| | | ", HCenterID=" + HCenterID + ",HBomID=" + HBomID + ",HIsStockQty='"+ HIsStockQty + "',HRemark3='" + HRemark3 + "' where HInterID=" + HInterID); |
|---|
