| | |
| | | oCn.RunProc("Insert into " + MvarItemKey + " " + |
| | | " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HTypeFlow,HTypeCount,HDeptNumber,HSNo,HBadWHID,HWasterWHID" + |
| | | ",HBadCountDevelopWHID" + |
| | | ",HBadCountDevelopWHID,HWWBadWHID,HWWWasterWHID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HDeptID,HBarCodeForBase,HProcessID_K3,HBillSubType,HAutoTrunFlag" + |
| | | ",HFixPrice,HOverFixPrice,HProcMulID,HProcCheckNote) " + |
| | | " Values('" + oModel.HNumber + "','" + oModel.HName + "','" + oModel.HHelpCode + "','" + oModel.HShortNumber + "'," + oModel.HParentID.ToString() + |
| | | "," + Convert.ToString(oModel.HTypeFlow ? 1 : 0) + "," + Convert.ToString(oModel.HTypeCount ? 1 : 0) + ",'" + oModel.HDeptNumber + "'," + oModel.HSNo.ToString() + "," + oModel.HBadWHID.ToString() + "," + oModel.HWasterWHID.ToString() + |
| | | "," + oModel.HBadCountDevelopWHID.ToString() + |
| | | "," + oModel.HBadCountDevelopWHID.ToString() + "," + oModel.HWWBadWHID.ToString() + "," + oModel.HWWWasterWHID.ToString() + |
| | | "," + oModel.HLevel.ToString() + "," + Convert.ToString(oModel.HEndFlag ? 1 : 0) + "," + Convert.ToString(oModel.HStopflag ? 1 : 0) + ",'" + oModel.HRemark + "'," + oModel.HDeptID + |
| | | ",'" + oModel.HBarCode + "'," + oModel.HProcessID_K3 + ",'" + oModel.HBillSubType + "'," + Convert.ToString(oModel.HAutoTrunFlag ? 1 : 0) + |
| | | "," + oModel.HFixPrice.ToString() + "," + oModel.HOverFixPrice.ToString() + "," + oModel.HProcMulID.ToString() +",'"+ oModel.HProcCheckNote.ToString() + "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | |
| | | ",HBadWHID=" + oModel.HBadWHID.ToString() + |
| | | ",HWasterWHID=" + oModel.HWasterWHID.ToString() + |
| | | ",HBadCountDevelopWHID=" + oModel.HBadCountDevelopWHID.ToString() + |
| | | ",HWWBadWHID=" + oModel.HWWBadWHID.ToString() + |
| | | ",HWWWasterWHID=" + oModel.HWWWasterWHID.ToString() + |
| | | ",HProcessID_K3=" +oModel.HProcessID_K3+ |
| | | ",HBillSubType='" + oModel.HBillSubType + "'" + |
| | | ",HDeptNumber='" + oModel.HDeptNumber + "'" + |