| | |
| | | long HProcID = list[0].HProcID; |
| | | int HUSEORGID = list[0].HUSEORGID; |
| | | string HCompName = list[0].HCompName; |
| | | string HPayMentType = list[0].HPayMentType; |
| | | var HDeptNumber = ""; |
| | | //var HEndFlag = 0; |
| | | long HLevel = 1; |
| | |
| | | oCN.RunProc("Insert into Gy_Group " + |
| | | " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HEmpQty,HDeptID,HDeptNumber,HProcID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HBarCodeForBase,HUSEORGID,HCompName) " + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HBarCodeForBase,HUSEORGID,HCompName,HPayMentType) " + |
| | | " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() + |
| | | "," + HEmpQty.ToString() + "," + HDeptID.ToString() + ",'" + HDeptNumber + "'," + HProcID.ToString() + |
| | | "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "','" + HBarCodeForBase + "',"+ HUSEORGID + ",'" + HCompName + "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | "," + HLevel.ToString() + "," + Convert.ToString(HEndFlag ? 1 : 0) + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "','" + HBarCodeForBase + "',"+ HUSEORGID + ",'" + HCompName +"','"+ HPayMentType + "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //修改上级为非末级代码 |
| | | oCN.RunProc("Update Gy_Group set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.Commit(); |
| | |
| | | ",HRemark= '" + HRemark + "'" + |
| | | ",HDeptID=" + HDeptID + |
| | | ",HEmpQty=" + HEmpQty + |
| | | ",HCompName='"+ HCompName+ |
| | | ",HCompName='"+ HCompName+"'"+ |
| | | ",HPayMentType='" + HPayMentType + |
| | | "',HBarCodeForBase='" + HBarCodeForBase + "' " + |
| | | ", HProcID = '" + HProcID + "' Where HItemID=" + HItemID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCN.RunProc("Update Gy_Group set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |