| | |
| | | /// <summary> |
| | | /// 出站接收单 |
| | | /// </summary> |
| | | public static ApiResult SetStationOutBill(Model.ClsSc_StationOutBillMain omodel) |
| | | public static ApiResult SetStationOutBill(StationOutBillView omodel) |
| | | { |
| | | WebS.WebService1 oWebs = new WebS.WebService1(); |
| | | omodel.HYear = 2021; |
| | |
| | | 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; |
| | | } |
| | | |
| | |
| | | return dataSet; |
| | | } |
| | | private static ConcurrentDictionary<string,string> dicLock=new System.Collections.Concurrent.ConcurrentDictionary<string,string>();//并发锁 |
| | | public static ApiResult SetOutBill(Model.ClsSc_StationOutBillMain omodel) |
| | | public static ApiResult SetOutBill(StationOutBillView omodel) |
| | | { |
| | | try |
| | | { |
| | | 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" + |