| | |
| | | long HWHID = list[0].HWHID; //良品仓库 |
| | | string HMakeEmp = user; |
| | | string HPayMentType = list[0].HPayMentType; //计件工资类型 |
| | | decimal HStandardWages = list[0].HStandardWages; //标准工价 |
| | | |
| | | |
| | | //判断权限 |
| | |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HDeptID,HBarCodeForBase,HProcessID_K3,HBillSubType,HAutoTrunFlag" + |
| | | ",HFixPrice,HOverFixPrice,HProcMulID,HProcCheckNote" + |
| | | ",HUSEORGID,HCREATEORGID,HWorkCenterID,HBadWHID,HWasterWHID,HBadCountDevelopWHID,HWWBadWHID,HWWWasterWHID,HWHID,HTProcessFlag" + |
| | | ",HQCSchemeID_Fst,HQCSchemeID_Proc,HQCSchemeID_Patrol,HPayMentType,HMakeTime,HMakeEmp) " + |
| | | ",HQCSchemeID_Fst,HQCSchemeID_Proc,HQCSchemeID_Patrol,HPayMentType,HMakeTime,HMakeEmp,HStandardWages) " + |
| | | " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() + |
| | | "," + Convert.ToString(HTypeFlow ? 1 : 0) + "," + Convert.ToString(HTypeCount ? 1 : 0) + ",'" + HDeptNumber + "','" + HSNo.ToString() + "','" + HUseFlag.ToString() + |
| | | "'," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HDeptID + |
| | | ",'" + HBarCodeForBase + "'," + HProcessID_K3 + ",'" + HBillSubType + "'," + Convert.ToString(HAutoTrunFlag ? 1 : 0) + |
| | | ",'" + HFixPrice.ToString() + "'," + HOverFixPrice.ToString() + "," + HProcMulID.ToString() + ",'" + HProcCheckNote.ToString() + "'" + |
| | | "," + HUSEORGID + "," + HCREATEORGID + "," + HWorkCenterID + "," + HBadWHID + "," + HWasterWHID + "," + HBadCountDevelopWHID + "," + HWWBadWHID + "," + HWWWasterWHID + "," + HWHID + "," + Convert.ToString(HTProcessFlag ? 1 : 0) + "," + HQCSchemeID_Fst + "," + HQCSchemeID_Proc + "," + HQCSchemeID_Patrol |
| | | + ",'" + HPayMentType + "',getdate(),'" + HMakeEmp + "'" + ")", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | + ",'" + HPayMentType + "',getdate(),'" + HMakeEmp + "'," + HStandardWages + ")", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | //修改上级为非末级代码 |
| | | oCN.RunProc("Update Gy_Process set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | |
| | | ",HTypeCount= '" + HTypeCount + "'" + |
| | | ",HDeptNumber='" + HDeptNumber + "'" + |
| | | ",HSNo= " + HSNo + |
| | | ",HUseFlag= " + HUseFlag + |
| | | ",HUseFlag= '" + HUseFlag + "'" + |
| | | ",HLevel= " + HLevel + |
| | | ",HEndFlag= '" + HEndFlag + "'" + |
| | | ",HTProcessFlag= '" + HTProcessFlag + "'" + |
| | |
| | | ",HQCSchemeID_Proc= " + HQCSchemeID_Proc + |
| | | ",HQCSchemeID_Patrol= " + HQCSchemeID_Patrol + |
| | | ",HPayMentType= '" + HPayMentType + "'" + |
| | | ",HStandardWages= " + HStandardWages + |
| | | ",HModifyTime= getdate()" + |
| | | ",HModifyEmp='" + HMakeEmp + "'" + |
| | | ",HProcCheckNote='" + HProcCheckNote + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |