| | |
| | | string HHelpCode = list[0].HHelpCode; |
| | | string HModifyEmp = msg3; |
| | | string HMakeEmp = msg3; |
| | | bool HStopflag = list[0].HStopflag==null?false:true; |
| | | int HStopflag = list[0].HStopflag==0?0:1; |
| | | long HCREATEORGID = list[0].HCREATEORGID; |
| | | long HUSEORGID = HUSEORGID_1; |
| | | long HCompID = list[0].HCompID; |
| | |
| | | " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HUSEORGID,HCREATEORGID,HMakeEmp,HMakeTime,HIDCard,HPhone,HDriverCardPic,HDriverCardType,HIDCardPic,HEmpType,HCompID) " + |
| | | " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() + |
| | | "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'" + |
| | | "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + HStopflag + ",'" + HRemark + "'" + |
| | | "," + HUSEORGID + "," + HCREATEORGID + ",'" + msg3 + "',getdate()," +"'"+ HIDCard +"',"+ |
| | | "'"+ HPhone+"','"+ HDriverCardPic+"','"+ HDriverCardType + "','"+ HIDCardPic +"','"+ HEmpType+"',"+ HCompID+ |
| | | ")", ref DBUtility.ClsPub.sExeReturnInfo); |
| | |
| | | ",HParentID=" + HParentID + |
| | | ",HUSEORGID=" + HUSEORGID.ToString() + |
| | | ",HCREATEORGID=" + HCREATEORGID.ToString() + |
| | | ",HStopflag=" + Convert.ToString(HStopflag ? 1 : 0) + |
| | | ",HStopflag=" + HStopflag + |
| | | ",HModifyEmp='" + HModifyEmp + "'" + |
| | | ",HModifyTime='" + DateTime.Now + "'" + |
| | | ",HIDCard='" + HIDCard + "'" + |
| | |
| | | ",HIDCardPic='" + HIDCardPic + "'" + |
| | | ",HEmpType='" + HEmpType + "'" + |
| | | ",HCompID=" + HCompID + "" + |
| | | |
| | | |
| | | ",HRemark= '" + HRemark + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //修改子项目代码 |