| | |
| | | //long HCREATEORGID = list[0].HCREATEORGID; |
| | | string HUpDater = list[0].HUpDater; |
| | | long HSPFlag = list[0].HSPFlag; |
| | | string HWarehouseType = list[0].HWarehouseType; |
| | | //得到短代码 |
| | | string HShortNumber = DBUtility.ClsPub.GetShortNumber(HNumber); |
| | | if (HShortNumber.Trim() == "") |
| | |
| | | oCN.BeginTran(); |
| | | oCN.RunProc("Insert into Gy_Warehouse " + |
| | | " (HNumber,HName,HHelpCode,HShortNumber,HParentID" + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HEmpID,HAddress,HPhone,HUSEORGID,HSPFlag,HCREATEORGID,HMaker,HMakeTime,HStockCtrlFlag) " + |
| | | ",HLevel,HEndFlag,HStopflag,HRemark,HEmpID,HAddress,HPhone,HUSEORGID,HSPFlag,HCREATEORGID,HMaker,HMakeTime,HStockCtrlFlag" + |
| | | ",HWarehouseType) " + |
| | | " Values('" + HNumber + "','" + HName + "','" + HHelpCode + "','" + HShortNumber + "'," + HParentID.ToString() + |
| | | "," + HLevel.ToString() + "," + HEndFlag + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HEmpID.ToString() + ",'" + HAddress + "','" + HPhone + "','"+ HUSEORGID + "',"+ HSPFlag + ","+ HUSEORGID + ",'"+msg3+"',getdate(),"+ Convert.ToString(HStockCtrlFlag ? 1 : 0)+")", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | "," + HLevel.ToString() + "," + HEndFlag + "," + Convert.ToString(HStopflag ? 1 : 0) + ",'" + HRemark + "'," + HEmpID.ToString() + ",'" + HAddress + "','" + HPhone + "','"+ HUSEORGID + "',"+ HSPFlag + ","+ HUSEORGID + ",'"+msg3+"',getdate(),"+ Convert.ToString(HStockCtrlFlag ? 1 : 0)+"" + |
| | | ",'"+ HWarehouseType + "')", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //修改上级为非末级代码 |
| | | oCN.RunProc("Update Gy_Warehouse set HEndflag=0 where HItemID=" + HParentID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //启用仓位 |
| | |
| | | ",HAddress='" + HAddress + "'" + |
| | | ",HPhone='" + HPhone + "'" + |
| | | ",HUSEORGID='" + HUSEORGID + "'" + |
| | | ",HWarehouseType='" + HWarehouseType + "'" + |
| | | ",HCREATEORGID='" + HUSEORGID + "'" + |
| | | ",HSPFlag='" + HSPFlag + "'" + |
| | | //",HSPGroupID='" + HSPGroupID + "'" + |