| | |
|---|
| | | public static DataSet GetGroupDb(string sWhere) |
|---|
| | | { |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | var dataSet = oCN.RunProcReturn("Select HItemID,HNumber 生产班组代码,HName 生产班组 from Gy_Group where HStopflag=0 " + sWhere + " Order by HItemID ", "Gy_Source"); |
|---|
| | | var dataSet = oCN.RunProcReturn("Select HItemID,HNumber 工作中心代码,HName 工作中心 from Gy_WorkCenter where HStopflag=0 " + sWhere + " Order by HItemID ", "Gy_Source"); |
|---|
| | | return dataSet; |
|---|
| | | } |
|---|
| | | |
|---|
| | |
|---|
| | | if (!dicLock.TryAdd(omodel.HBillNo, omodel.HBillNo)) |
|---|
| | | return new ApiResult { code = -1, msg = "服务器繁忙" }; |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | omodel.HInterID = DBUtility.ClsPub.CreateBillID("3791", ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
| | | omodel.HInterID = DBUtility.ClsPub.CreateBillID("4788", ref DBUtility.ClsPub.sExeReturnInfo); |
|---|
| | | oCN.BeginTran(); |
|---|
| | | var sql = "Insert Into Sc_StationOutBillMain " + |
|---|
| | | "(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" + |
|---|
