From 20f0478d39110034363d852d6d0594cea325617f Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期一, 27 六月 2022 16:43:55 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- Pub_Class/CustomerCls/ClsPub.cs | 135 ++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 133 insertions(+), 2 deletions(-) diff --git a/Pub_Class/CustomerCls/ClsPub.cs b/Pub_Class/CustomerCls/ClsPub.cs index f87582c..615388e 100644 --- a/Pub_Class/CustomerCls/ClsPub.cs +++ b/Pub_Class/CustomerCls/ClsPub.cs @@ -418,7 +418,7 @@ } return sBillNo; - case 1://鏍规嵁 YY骞�+MM鏈� + 娴佹按鍙� 鐢熸垚鍗曟嵁鍙� + case 1://鏍规嵁 YY骞�+MM鏈� 鏃� + 娴佹按鍙� 鐢熸垚鍗曟嵁鍙� 锛堟棩 閲囩敤浜� 浠撳簱鐨勫瓧娈碉級 sKjYear = sKjYear.Substring(2, 2); sPeriod = "0" + sPeriod; sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2); @@ -440,7 +440,6 @@ oCn.RunProc("update Gy_Maxnum set NowNumBer=NowNumBer+1 where BillCode='" + BillCode.Trim() + "' and KjYear='" + sKjYear + "' and Period='" + sPeriod + "' and whcode='" + sDay + "'"); } return sBillNo; - case 2: //鏍规嵁骞�+鏈�+鏃� 鐢熸垚鍗曟嵁鍙� Ds = oCn.RunProcReturn("Select * from Gy_MaxNum where BillCode='" + BillCode.Trim() + "' and KjYear='" + sKjYear + "' and Period='" + sPeriod + "' and whcode='" + sDay + "'", "Gy_MaxNum"); if (Ds.Tables[0].Rows.Count != 0) @@ -476,6 +475,138 @@ oCn = null; } + //寰楀埌鏈�澶у崟鎹彿 + public static string CreateBillCode(string BillCode,string HOrgNumber,Int64 HOrgID,string HWhNumber, ref string sReturn, bool Add) + { + Int64 BillCodeMode; + string Profix; + Int64 Glida; + Int32 CodeLen; + string sBillNo = ""; + char c = Convert.ToChar("0"); + string sKjYear = DateTime.Today.Year.ToString(); + string sPeriod = DateTime.Today.Month.ToString(); + string sDay = DateTime.Today.Day.ToString(); + //寰楀埌鍗曟嵁鍙疯〃 淇℃伅 + ClsSqlHelper oCn = new ClsSqlHelper(); + DataSet Ds = new DataSet(); + Ds = oCn.RunProcReturn("Select * from Gy_BillNumber where BillCode='" + BillCode.Trim() + "'", "Gy_BillNumber"); + if (Ds.Tables[0].Rows.Count != 0) + { + BillCodeMode = ClsPub.isLong(Ds.Tables[0].Rows[0]["BillCodeMode"].ToString()); + Profix = ClsPub.isStrNull(Ds.Tables[0].Rows[0]["Profix"].ToString()); + Glida = ClsPub.isLong(Ds.Tables[0].Rows[0]["Glida"].ToString()); + CodeLen = ClsPub.isInt(Ds.Tables[0].Rows[0]["CodeLen"].ToString()); + } + else + { + return ""; + } + // + string sStr; + switch (BillCodeMode) + { + case 0: + switch (Glida) + { + case 0://绾祦姘村彿 + Ds = oCn.RunProcReturn("Select * from Gy_MaxNum where BillCode='" + BillCode.Trim() + "'", "Gy_MaxNum"); + if (Ds.Tables[0].Rows.Count != 0) + { + sStr = new string(c, CodeLen - (Ds.Tables[0].Rows[0]["NowNumBer"].ToString()).Length); + sBillNo = Profix.Trim() + sStr + Ds.Tables[0].Rows[0]["NowNumBer"].ToString().Trim(); + } + else //鎻掑叆鏂拌褰� + { + sStr = new string(c, CodeLen - 1); + oCn.RunProc("insert into Gy_MaxNum(BillCode,NowNumber) values('" + BillCode.Trim() + "',1)"); + sBillNo = Profix.Trim() + sStr + 1; + } + if (Add == true) + { + oCn.RunProc("update Gy_Maxnum set NowNumBer=NowNumBer+1 where BillCode='" + BillCode.Trim() + "'"); + } + return sBillNo; + + case 1://鏍规嵁 YY骞�+MM鏈� 鏃� + 娴佹按鍙� 鐢熸垚鍗曟嵁鍙� 锛堟棩 閲囩敤浜� 浠撳簱鐨勫瓧娈碉級 + sKjYear = sKjYear.Substring(2, 2); + sPeriod = "0" + sPeriod; + sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2); + sDay = ""; + Ds = oCn.RunProcReturn("Select * from Gy_MaxNum where BillCode='" + BillCode.Trim() + "' and KjYear='" + sKjYear + "' and Period='" + sPeriod + "' and whcode='" + sDay + "'", "Gy_MaxNum"); + if (Ds.Tables[0].Rows.Count != 0) + { + sStr = new string(c, CodeLen - (Ds.Tables[0].Rows[0]["NowNumBer"].ToString()).Length); + sBillNo = Profix.Trim() + sKjYear + sPeriod + sDay + sStr + Ds.Tables[0].Rows[0]["NowNumBer"].ToString().Trim(); + } + else //鎻掑叆鏂拌褰� + { + sStr = new string(c, CodeLen - 1); + oCn.RunProc("insert into Gy_Maxnum(BillCode,Kjyear,Period,whcode,NowNumber) values('" + BillCode.Trim() + "','" + sKjYear + "','" + sPeriod + "','" + sDay + "',1)"); + sBillNo = Profix.Trim() + sKjYear + sPeriod + sDay + sStr + "1"; + } + if (Add == true) + { + oCn.RunProc("update Gy_Maxnum set NowNumBer=NowNumBer+1 where BillCode='" + BillCode.Trim() + "' and KjYear='" + sKjYear + "' and Period='" + sPeriod + "' and whcode='" + sDay + "'"); + } + return sBillNo; + case 2: //鏍规嵁骞�+鏈�+鏃� 鐢熸垚鍗曟嵁鍙� (杩欏姛鑳� 濂藉儚鏄綔搴熶簡锛� + Ds = oCn.RunProcReturn("Select * from Gy_MaxNum where BillCode='" + BillCode.Trim() + "' and KjYear='" + sKjYear + "' and Period='" + sPeriod + "' and whcode='" + sDay + "'", "Gy_MaxNum"); + if (Ds.Tables[0].Rows.Count != 0) + { + sStr = new string(c, CodeLen - (Ds.Tables[0].Rows[0]["NowNumBer"].ToString()).Length); + sBillNo = Profix.Trim() + sKjYear + ClsPub.isStrNull(("0" + sPeriod)).Substring(ClsPub.isStrNull(("0" + sPeriod)).Length - 2, 2) + ClsPub.isStrNull(("0" + sDay)).Substring(ClsPub.isStrNull(("0" + sDay)).Length - 2, 2) + sStr + Ds.Tables[0].Rows[0]["NowNumBer"].ToString().Trim(); + } + else //鎻掑叆鏂拌褰� + { + sStr = new string(c, CodeLen - 1); + oCn.RunProc("insert into Gy_Maxnum(BillCode,Kjyear,Period,whcode,NowNumber) values('" + BillCode.Trim() + "','" + sKjYear + "','" + sPeriod + "','" + sDay + "',1)"); + sBillNo = Profix.Trim() + sKjYear + ClsPub.isStrNull(("0" + sPeriod)).Substring(ClsPub.isStrNull(("0" + sPeriod)).Length - 2, 2) + ClsPub.isStrNull(("0" + sDay)).Substring(ClsPub.isStrNull(("0" + sDay)).Length - 2, 2) + sStr + 1; + } + if (Add == true) + { + oCn.RunProc("update Gy_Maxnum set NowNumBer=NowNumBer+1 where BillCode='" + BillCode.Trim() + "' and KjYear='" + sKjYear + "' and Period='" + sPeriod + "' and whcode='" + sDay + "'"); + } + return sBillNo; + case 3://鏍规嵁 鍓嶇紑+缁勭粐+ YY骞�+MM鏈� + 娴佹按鍙� 鐢熸垚鍗曟嵁鍙� 锛堢粍缁� 閲囩敤浜� 浠撳簱鐨勫瓧娈碉級 + sKjYear = sKjYear.Substring(2, 2); + sPeriod = "0" + sPeriod; + sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2); + + Ds = oCn.RunProcReturn("Select * from Gy_MaxNum where BillCode='" + BillCode.Trim() + "' and KjYear='" + sKjYear + "' and Period='" + sPeriod + "' and whcode='" + HOrgNumber + "'", "Gy_MaxNum"); + if (Ds.Tables[0].Rows.Count != 0) + { + sStr = new string(c, CodeLen - (Ds.Tables[0].Rows[0]["NowNumBer"].ToString()).Length); + sBillNo = Profix.Trim() + HOrgNumber + sKjYear + sPeriod + sStr + Ds.Tables[0].Rows[0]["NowNumBer"].ToString().Trim(); + } + else //鎻掑叆鏂拌褰� + { + sStr = new string(c, CodeLen - 1); + oCn.RunProc("insert into Gy_Maxnum(BillCode,Kjyear,Period,whcode,NowNumber) values('" + BillCode.Trim() + "','" + sKjYear + "','" + sPeriod + "','" + HOrgNumber + "',1)"); + sBillNo = Profix.Trim() + sKjYear + sPeriod + sDay + sStr + "1"; + } + if (Add == true) + { + oCn.RunProc("update Gy_Maxnum set NowNumBer=NowNumBer+1 where BillCode='" + BillCode.Trim() + "' and KjYear='" + sKjYear + "' and Period='" + sPeriod + "' and whcode='" + HOrgNumber + "'"); + } + return sBillNo; + default: + return sBillNo; + + } + + case 1: + return sBillNo; + + default: + return sBillNo; + + } + oCn.CnClose(); + oCn.CnDispose(); + oCn = null; + } + //寰楀埌鏈�澶у崟鎹彿2 public static string CreateBillCode(string BillCode, ref string sReturn, bool Add,ClsSqlHelper oCn) -- Gitblit v1.9.1