| | |
|---|
| | | ",'" + HERPBillType + "'," + HDFflag + ")"; |
|---|
| | | |
|---|
| | | oCN.RunProc(sql); |
|---|
| | | |
|---|
| | | } |
|---|
| | | else if (OperationType == 3 || ds.Tables[0].Rows.Count != 0) |
|---|
| | | { //修改 |
|---|
| | | string sql = $@"update Xs_SeOutStockBillMain set " + |
|---|
| | | "HRemark='" + HRemark + "', HChecker='" + HMaker + "', HCheckDate=getdate()" + |
|---|
| | | ",HCurID=" + HCurID + ", HWHID = " + HWHID |
|---|
| | | + ",HExRate=" + HExRate + ",HEmpID=" + HEmpID + ",HSeOrderBillNo_M=" + HSeOrderBillNo_M + ",HManagerID=" + HManagerID + ",HDeptID=" + HDeptID + ",HOWNERID=" + HOWNERID |
|---|
| | | + ",HAddress='" + HAddress + "'where HInterID=" + HInterID; |
|---|
| | | "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + |
|---|
| | | ",HCusID='" + HCusID + "', HCurID='" + HCurID + "', HWHID = '" + HWHID |
|---|
| | | + "',HExRate='" + HExRate + "',HEmpID='" + HEmpID + "',HSeOrderBillNo_M='" + HSeOrderBillNo_M + "',HManagerID='" + HManagerID + "',HDeptID='" + HDeptID + "',HOWNERID='" + HOWNERID |
|---|
| | | + "',HAddress='" + HAddress + "' where HInterID=" + HInterID; |
|---|
| | | oCN.RunProc(sql); |
|---|
| | | |
|---|
| | | //删除子表 |
|---|
