From 2664bc8558e62e0413e39c113d43dfa99ad6ddc2 Mon Sep 17 00:00:00 2001
From: ouyangqing <ouyangqing@DESKTOP-B85SG1D>
Date: 星期一, 18 一月 2021 14:12:04 +0800
Subject: [PATCH] 出站单保存
---
WebAPI/Service/YqnQbService.cs | 52 +++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 51 insertions(+), 1 deletions(-)
diff --git a/WebAPI/Service/YqnQbService.cs b/WebAPI/Service/YqnQbService.cs
index d046f5b..087f849 100644
--- a/WebAPI/Service/YqnQbService.cs
+++ b/WebAPI/Service/YqnQbService.cs
@@ -1,4 +1,6 @@
-锘縰sing System;
+锘縰sing DBUtility;
+using System;
+using System.Collections.Concurrent;
using System.Collections.Generic;
using System.Data;
using System.Linq;
@@ -96,6 +98,16 @@
}
return new ApiResult { code = 1, msg = "鎿嶄綔鎴愬姛" };
}
+ /// <summary>
+ /// 鍑虹珯鎺ユ敹鍗�
+ /// </summary>
+ public static ApiResult SetStationOutBill(Model.ClsSc_StationOutBillMain omodel)
+ {
+ WebS.WebService1 oWebs = new WebS.WebService1();
+ string sErrMsg = string.Empty;
+ var result = SetOutBill(omodel);
+ return result;
+ }
#region sql璇彞
public static DataSet GetBarCodeDb(string billBarCode)
{
@@ -133,6 +145,44 @@
var dataSet = oCN.RunProcReturn("Select HItemID,HNumber 宸ヤ綔涓績浠ｇ爜,HName 宸ヤ綔涓績 from Gy_Group where HStopflag=0 " + sWhere + " Order by HItemID ", "Gy_Source");
return dataSet;
}
+ private static ConcurrentDictionary<string,string> dicLock=new System.Collections.Concurrent.ConcurrentDictionary<string,string>();//骞跺彂閿�
+ public static ApiResult SetOutBill(Model.ClsSc_StationOutBillMain 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);
+ oCN.BeginTran();
+ var sql = "Insert Into Sc_StationOutBillMain " +
+ "(HBillType,HBillSubType,HInterID,HBillNo,HBillStatus,HDate,HMaker,HMakeDate" +
+ ",HYear,HPeriod,HRemark" +
+ ",HICMOInterID,HICMOBillNo,HProcPlanInterID,HProcPlanEntryID,HProcPlanBillNo,HProcExchInterID,HProcExchEntryID" +
+ ",HProcExchBillNo,HMaterID,HProcID,HICMOQty,HPlanQty,HStationOutTime,HSourceID" +
+ ",HGroupID,HDeptID,HEmpID,HBarCode,HAddr,HBarCodeMaker,HBarCodeMakeDate" +
+ ",HSupID,HQty,HPrice,HMoney" +
+ ") " +
+ " values('3791','3791'," + omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "'," + omodel.HBillStatus.ToString() + ",getdate(),'" + DBUtility.ClsPub.CurUserName + "',getdate()" +
+ "," + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "'" +
+ "," + omodel.HICMOInterID.ToString() + ",'" + omodel.HICMOBillNo + "'," + omodel.HProcPlanInterID.ToString() + "," + omodel.HProcPlanEntryID.ToString() + ",'" + omodel.HProcPlanBillNo + "'," + omodel.HProcExchInterID.ToString() + "," + omodel.HProcExchEntryID.ToString() +
+ ",'" + omodel.HProcExchBillNo + "'," + omodel.HMaterID.ToString() + "," + omodel.HProcID.ToString() + "," + omodel.HICMOQty.ToString() + "," + omodel.HPlanQty.ToString() + ",getdate()," + omodel.HSourceID.ToString() +
+ "," + omodel.HGroupID.ToString() + "," + omodel.HDeptID.ToString() + "," + omodel.HEmpID.ToString() + ",'" + omodel.HBarCode + "','" + omodel.HAddr + "','" + omodel.HBarCodeMaker + "',getdate()" +
+ "," + omodel.HSupID.ToString() + "," + omodel.HQty.ToString() + "," + omodel.HPrice.ToString() + "," + omodel.HMoney.ToString() +
+ ") ";
+ oCN.RunProc(sql);
+ oCN.Commit();
+ return new ApiResult { code = 1, msg = "鏂板鎴愬姛" };
+ }
+ catch (Exception ex)
+ {
+ return new ApiResult { code = -1, msg = "淇濆瓨閿欒/"+ex.ToString() };
+ }
+ finally
+ {
+ dicLock.TryRemove(omodel.HBillNo, out string key);
+ }
+ }
#endregion
}
--
Gitblit v1.9.1