using Microsoft.AspNetCore.Mvc; using Newtonsoft.Json; using Newtonsoft.Json.Linq; using Opsoft.Data; using Opsoft.Data.Model; using Opsoft.NetCore.O3App.Domain; using Opsoft.NetCore.O3App.Domain.Models; using Opsoft.NetCore.O3App.Shared; using Opsoft.NetCore.O3App.WebApi.Models; using System; using System.Collections.Generic; using System.Data; using System.Diagnostics; using System.Linq; using System.Runtime.CompilerServices; using System.Threading.Tasks; namespace Opsoft.NetCore.O3App.WebApi.Controllers { //[ApiController] public abstract class BaseApiController : Controller where TController : BaseApiController { protected ILogger Logger { get; } public IMapper Mapper { get; } public BaseApiController(IMapper mapper, ILogger logger) { Mapper = mapper ?? throw new ArgumentNullException(nameof(mapper)); Logger = Guard.ArgumentNotNull(logger, nameof(logger)); } private LoginRequest _loginInfo = null; public LoginRequest LoginInfo { get { if (_loginInfo == null) { string token = Request.Headers["Authorization"].ToStringEx().Substring(7); _loginInfo = TokenAuthenticationService.GetLoinInfo(token); } return _loginInfo; } } protected async Task> TryProcess(Func> coreProcess, TIn input, string requestId = "", [CallerMemberName] string callerName = "") { if (input == null) { return new BaseResponse() { Success = false, Message = "参数不能为空" }; } Dictionary extraInfo = new Dictionary(); //调查卡顿问题,原本记录的数据信息暂时停掉 20220223 //extraInfo.Add("Request", input); Stopwatch stopwatch = new Stopwatch(); BaseResponse response = new BaseResponse(); //记录请求过的时间点 Logger.Info($"RequestStart:接收到请求信息开始!", requestId, "", callerName); try { stopwatch.Restart(); response.Data = await coreProcess(input); response.Success = true; response.Message = "执行成功"; response.StatusCode = StatusCodes.OK.ToInt32(); stopwatch.Stop(); //extraInfo.Add("Elapsed", stopwatch.ElapsedMilliseconds.ToString()); //extraInfo.Add("Response", response); Logger.Info(extraInfo, requestId, "", callerName); } catch (O3AppException ex) { response.Success = false; response.Message = ex.Message; response.StatusCode = ex.StatusCode; response.Data = ex.Additional == null ? default : (TOut)(ex.Additional); stopwatch.Stop(); //extraInfo.Add("Elapsed", stopwatch.ElapsedMilliseconds.ToString()); //extraInfo.Add("Response", response); Logger.Warn(ex, extraInfo, requestId, "", callerName); } catch (AggregateException ex) { response.Success = false; response.Message = string.Join(Constants.CharText.Semicolon, ex.Flatten().InnerExceptions.Select(ie => ie.Message)); response.StatusCode = StatusCodes.InternalServerError.ToInt32(); stopwatch.Stop(); //extraInfo.Add("Elapsed", stopwatch.ElapsedMilliseconds.ToString()); //extraInfo.Add("Response", response); Logger.Error(ex, extraInfo, requestId, "", callerName); } catch (Exception ex) { response.Success = false; response.Message = ex.Message; response.StatusCode = StatusCodes.InternalServerError.ToInt32(); stopwatch.Stop(); //extraInfo.Add("Elapsed", stopwatch.ElapsedMilliseconds.ToString()); //extraInfo.Add("Response", response); Logger.Error(ex, extraInfo, requestId, "", callerName); } return response; } protected async Task TryProcess(Func coreProcess, TIn input, string requestId = "", [CallerMemberName] string callerName = "") { if (input == null) { return new BaseResponse() { Success = false, Message = "参数不能是空" }; } Dictionary extraInfo = new Dictionary(); extraInfo.Add("Request", input); Stopwatch stopwatch = new Stopwatch(); BaseResponse response = new BaseResponse(); try { stopwatch.Restart(); await coreProcess(input); response.Success = true; response.Message = "执行成功"; response.StatusCode = StatusCodes.OK.ToInt32(); stopwatch.Stop(); extraInfo.Add("Elapsed", stopwatch.ElapsedMilliseconds.ToString()); extraInfo.Add("Response", response); Logger.Info(extraInfo, requestId, "", callerName); } catch (O3AppException ex) { response.Success = false; response.Message = ex.Message; response.StatusCode = ex.StatusCode; stopwatch.Stop(); extraInfo.Add("Elapsed", stopwatch.ElapsedMilliseconds.ToString()); extraInfo.Add("Response", response); Logger.Warn(ex, extraInfo, requestId, "", callerName); } catch (AggregateException ex) { response.Success = false; response.Message = string.Join(Constants.CharText.Semicolon, ex.Flatten().InnerExceptions.Select(ie => ie.Message)); response.StatusCode = StatusCodes.InternalServerError.ToInt32(); stopwatch.Stop(); extraInfo.Add("Elapsed", stopwatch.ElapsedMilliseconds.ToString()); extraInfo.Add("Response", response); Logger.Error(ex, extraInfo, requestId, "", callerName); } catch (Exception ex) { response.Success = false; response.Message = ex.Message; response.StatusCode = StatusCodes.InternalServerError.ToInt32(); stopwatch.Stop(); extraInfo.Add("Elapsed", stopwatch.ElapsedMilliseconds.ToString()); extraInfo.Add("Response", response); Logger.Error(ex, extraInfo, requestId, "", callerName); } return response; } protected async Task LogWrapper(Func> coreProcess, TIn input, string requestId = "", [CallerMemberName] string callerName = "") { Dictionary extraInfo = new Dictionary(); extraInfo.Add("Request", input); Stopwatch stopwatch = new Stopwatch(); TOut response = default(TOut); try { stopwatch.Restart(); response = await coreProcess(input); stopwatch.Stop(); extraInfo.Add("Elapsed", stopwatch.ElapsedMilliseconds.ToString()); extraInfo.Add("Response", response); Logger.Info(extraInfo, requestId, "", callerName); } catch (O3AppException ex) { stopwatch.Stop(); extraInfo.Add("Elapsed", stopwatch.ElapsedMilliseconds.ToString()); Logger.Warn(ex, extraInfo, requestId, "", callerName); throw; } catch (AggregateException ex) { stopwatch.Stop(); extraInfo.Add("Elapsed", stopwatch.ElapsedMilliseconds.ToString()); Logger.Error(ex, extraInfo, requestId, "", callerName); throw; } catch (Exception ex) { stopwatch.Stop(); extraInfo.Add("Elapsed", stopwatch.ElapsedMilliseconds.ToString()); Logger.Error(ex, extraInfo, requestId, "", callerName); throw; } return response; } #region ================= 扩展函数=========================================== /// /// /// /// /// /// /// /// /// /// protected string CreateBilllNO(string strJSON, string wPrgKey, string TableName, string FBillNOField, string KeyList, string ValueList) { using (APPServerContext DBContext = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID)) { try { JObject ICursor = (JObject)JsonConvert.DeserializeObject(strJSON); // 自动编单据编号 // 1. 首行得到单据编号规则 string wFBillNO = ""; string wFIeldID = "", wFValue = "", wFormatString = "", wFChar = ""; string wFCharAlignment = ""; int wFLenght = 0; string wCodeContrast = ""; //是否有编码对照表 bool wIsSerial = false, wIsMember = false; DataTable myCodeEntrys = DBContext.Database.SqlQuery( " select * from SYS_LISTCODEENTRY where FCLASSTYPEID ='" + wPrgKey + "' order by FENTRYID "); sysListCodeNO myCodeNo; bool IsAdd = true; DateTime wToDay = DateTime.Now; int iSEQ = 0; if (myCodeEntrys.Rows.Count > 0) { string wKeyCode = ""; //流水号编号依据 #region ================ 计算抓流水号资料 =========================== foreach (DataRow subCodeEntry in myCodeEntrys.Rows) { wFIeldID = subCodeEntry["FIELDID"].ToStringEx(); wFValue = subCodeEntry["FVALUE"].ToStringEx(); wIsSerial = subCodeEntry["ISSERIAL"].ToBoolean(); wFLenght = subCodeEntry["FLENGHT"].ToInt(); wFormatString = subCodeEntry["FORMATSTRING"].ToStringEx(); wFChar = subCodeEntry["FCHAR"].ToStringEx().Trim(); wIsMember = subCodeEntry["ISMEMBER"].ToBoolean(); wFCharAlignment = subCodeEntry["FCHARALIGNMENT"].ToStringEx(); wCodeContrast = subCodeEntry["FCODECONTRAST"].ToStringEx(); //1=常量, 2=文本字段 3= 日期字段 4=流水号 switch (subCodeEntry["FTYPE"].ToStringEx()) { case "1": //常量 if (wIsSerial) //如果为编流水号的依据 wKeyCode += wFValue; break; case "2": // 文本字段 if (wIsSerial) //如果为编流水号的依据 { string temp = ICursor[wFIeldID].ToStringEx(); if (wFLenght > 0) { temp = temp.SubStringEx(0, wFLenght, false); string mychar = " "; if (wFChar != "") { mychar = wFChar; } if (wFCharAlignment == "R") { temp = temp.PadRight(wFLenght, mychar[0]); } else { temp = temp.PadLeft(wFLenght, mychar[0]); } } switch (wFormatString.ToUpper()) { case "U": temp = temp.ToUpper(); break; case "L": temp = temp.ToLower(); break; default: break; } //如果存在编码对照表 if (!string.IsNullOrEmpty(wCodeContrast)) { DataTable tempTable = DBContext.Database.SqlQuery( " select T1.FCODE " + " from SYS_CODECONTRASTENTRY T1 " + " join SYS_CODECONTRAST T2 on T1.FInterID=T2.FInterID " + " where T2.FNUMBER=" + DBContext.GetDBParName("@PA1") + " and T1.FVALUE=" + DBContext.GetDBParName("@PA2") + " ", DBContext.CreateParameter("@PA1", wCodeContrast), DBContext.CreateParameter("@PA2", temp)); if (tempTable.Rows.Count > 0) { temp = tempTable.Rows[0]["FCODE"].ToStringEx(); } } wKeyCode += temp; } break; case "5": // 数值字段 if (wIsSerial) //如果为编流水号的依据 { string temp = ICursor[wFIeldID].ToDecimal().ToString("0.###################"); if (wFLenght > 0) { temp = temp.SubStringEx(0, wFLenght, false); string mychar = " "; if (wFChar != "") { mychar = wFChar; } if (wFCharAlignment == "R") { temp = temp.PadRight(wFLenght, mychar[0]); } else { temp = temp.PadLeft(wFLenght, mychar[0]); } } switch (wFormatString.ToUpper()) { case "U": temp = temp.ToUpper(); break; case "L": temp = temp.ToLower(); break; default: break; } //如果存在编码对照表 if (!string.IsNullOrEmpty(wCodeContrast)) { DataTable tempTable = DBContext.Database.SqlQuery( " select T1.FCODE " + " from SYS_CODECONTRASTENTRY T1 " + " join SYS_CODECONTRAST T2 on T1.FINTERID=T2.FINTERID " + " where T2.FNUMBER=" + DBContext.GetDBParName("@PA1") + " and T1.FVALUE=" + DBContext.GetDBParName("@PA2") + " ", DBContext.CreateParameter("@PA1", wCodeContrast), DBContext.CreateParameter("@PA2", temp)); if (tempTable.Rows.Count > 0) { temp = tempTable.Rows[0]["FCODE"].ToStringEx(); } } wKeyCode += temp; } break; case "3": // 3= 日期字段 if (wIsSerial) //如果为编流水号的依据 { DateTime temp = wToDay; try { if (!Convert.IsDBNull(ICursor[wFIeldID])) { temp = Convert.ToDateTime(ICursor[wFIeldID]); } } catch (System.Exception) { temp = wToDay; } string strtemp = ""; if (string.IsNullOrEmpty(wFormatString)) { strtemp = temp.ToString("yyyyMMdd"); } else { strtemp = temp.ToString(wFormatString); } strtemp = strtemp.SubStringEx(0, wFLenght); //如果存在编码对照表 if (!string.IsNullOrEmpty(wCodeContrast)) { DataTable tempTable = DBContext.Database.SqlQuery( " select T1.FCODE " + " from SYS_CODECONTRASTENTRY T1 " + " join SYS_CODECONTRAST T2 on T1.FINTERID=T2.FINTERID " + " where T2.FNUMBER=" + DBContext.GetDBParName("@PA1") + " and T1.FVALUE=" + DBContext.GetDBParName("@PA2") + " ", DBContext.CreateParameter("@PA1", wCodeContrast), DBContext.CreateParameter("@PA2", strtemp)); if (tempTable.Rows.Count > 0) { strtemp = tempTable.Rows[0]["FCODE"].ToStringEx(); } } wKeyCode += strtemp; } break; case "4": // 4=流水号 break; } } #endregion ================ 计算抓流水号资料 =========================== myCodeNo = DBContext.SYS_LISTCODENO.SingleOrDefault(o => o.FCLASSTYPEID.Equals(wPrgKey) && o.FBILLCODE.Equals(wKeyCode)); if (myCodeNo == null) { myCodeNo = new sysListCodeNO(); iSEQ = 0; myCodeNo.C_YMD = DateTime.Now; myCodeNo.UID = Guid.NewGuid().ToString(); myCodeNo.FINTERID = Guid.NewGuid().ToString(); myCodeNo.C_USER = LoginInfo.UserID; myCodeNo.FCLASSTYPEID = wPrgKey; myCodeNo.FBILLCODE = wKeyCode; myCodeNo.FSEQ = 0; IsAdd = true; } else { iSEQ = myCodeNo.FSEQ; IsAdd = false; } int icc = 0; while (true) { iSEQ++; icc++; if (icc > 1000) { throw new System.Exception("单据编号已经循环超过1千次,有可能是死循环!"); } #region ================ 计算编号资料 =========================== wFBillNO = ""; foreach (DataRow subCodeEntry in myCodeEntrys.Rows) { wFIeldID = subCodeEntry["FIELDID"].ToStringEx(); wFValue = subCodeEntry["FVALUE"].ToStringEx(); wIsSerial = subCodeEntry["ISSERIAL"].ToBoolean(); wFLenght = subCodeEntry["FLENGHT"].ToInt(); wFormatString = subCodeEntry["FORMATSTRING"].ToStringEx(); wFChar = subCodeEntry["FCHAR"].ToStringEx().Trim(); wIsMember = subCodeEntry["ISMEMBER"].ToBoolean(); wFCharAlignment = subCodeEntry["FCHARALIGNMENT"].ToStringEx(); wCodeContrast = subCodeEntry["FCODECONTRAST"].ToStringEx(); //1=常量, 2=文本字段 3= 日期字段 4=流水号 switch (subCodeEntry["FTYPE"].ToStringEx()) { case "1": if (wIsMember) //如果为编流水号的依据 wFBillNO += wFValue; break; case "2": if (wIsMember) //如果为编流水号的依据 { string temp = ICursor[wFIeldID].ToStringEx(); if (wFLenght > 0) { temp = temp.SubStringEx(0, wFLenght, false); string mychar = " "; if (wFChar != "") { mychar = wFChar; } if (wFCharAlignment == "R") { temp = temp.PadRight(wFLenght, mychar[0]); } else { temp = temp.PadLeft(wFLenght, mychar[0]); } } switch (wFormatString.ToUpper()) { case "U": temp = temp.ToUpper(); break; case "L": temp = temp.ToLower(); break; default: break; } //如果存在编码对照表 if (!string.IsNullOrEmpty(wCodeContrast)) { DataTable tempTable = DBContext.Database.SqlQuery( " select T1.FCODE " + " from SYS_CODECONTRASTENTRY T1 " + " join SYS_CODECONTRAST T2 on T1.FINTERID=T2.FINTERID " + " where T2.FNUMBER=" + DBContext.GetDBParName("@PA1") + " and T1.FVALUE=" + DBContext.GetDBParName("@PA2") + " ", DBContext.CreateParameter("@PA1", wCodeContrast), DBContext.CreateParameter("@PA2", temp)); if (tempTable.Rows.Count > 0) { temp = tempTable.Rows[0]["FCODE"].ToStringEx(); } } wFBillNO += temp; } break; case "5": // 数值字段 if (wIsMember) //如果为编流水号的依据 { string temp = ICursor[wFIeldID].ToDecimal().ToString("0.###################"); if (wFLenght > 0) { temp = temp.SubStringEx(0, wFLenght, false); string mychar = " "; if (wFChar != "") { mychar = wFChar; } if (wFCharAlignment == "R") { temp = temp.PadRight(wFLenght, mychar[0]); } else { temp = temp.PadLeft(wFLenght, mychar[0]); } } switch (wFormatString.ToUpper()) { case "U": temp = temp.ToUpper(); break; case "L": temp = temp.ToLower(); break; default: break; } //如果存在编码对照表 if (!string.IsNullOrEmpty(wCodeContrast)) { DataTable tempTable = DBContext.Database.SqlQuery( " select T1.FCODE " + " from SYS_CODECONTRASTENTRY T1 " + " join SYS_CODECONTRAST T2 on T1.FINTERID=T2.FINTERID " + " where T2.FNUMBER=" + DBContext.GetDBParName("@PA1") + " and T1.FVALUE=" + DBContext.GetDBParName("@PA2") + " ", DBContext.CreateParameter("@PA1", wCodeContrast), DBContext.CreateParameter("@PA2", temp)); if (tempTable.Rows.Count > 0) { temp = tempTable.Rows[0]["FCODE"].ToStringEx(); } } wFBillNO += temp; } break; case "3": // 3= 日期字段 if (wIsMember) //如果为编流水号的依据 { DateTime temp = wToDay; try { if (!Convert.IsDBNull(ICursor[wFIeldID])) { temp = Convert.ToDateTime(ICursor[wFIeldID]); } } catch (System.Exception) { temp = wToDay; } string strtemp = ""; if (string.IsNullOrEmpty(wFormatString)) { strtemp = temp.ToString("yyyyMMdd"); } else { strtemp = temp.ToString(wFormatString); } strtemp = strtemp.SubStringEx(0, wFLenght); //如果存在编码对照表 if (!string.IsNullOrEmpty(wCodeContrast)) { DataTable tempTable = DBContext.Database.SqlQuery( " select T1.FCODE " + " from SYS_CODECONTRASTENTRY T1 " + " join SYS_CODECONTRAST T2 on T1.FINTERID=T2.FINTERID " + " where T2.FNUMBER=" + DBContext.GetDBParName("@PA1") + " and T1.FVALUE=" + DBContext.GetDBParName("@PA2") + " ", DBContext.CreateParameter("@PA1", wCodeContrast), DBContext.CreateParameter("@PA2", strtemp)); if (tempTable.Rows.Count > 0) { strtemp = tempTable.Rows[0]["FCODE"].ToStringEx(); } } wFBillNO += strtemp; } break; case "4": // 4=流水号 wFBillNO += iSEQ.ToString().PadLeft(wFLenght, '0'); break; } } #endregion ================ 计算编号资料 =========================== string xSQL = ""; if (KeyList != "") xSQL = GetWhereSql(KeyList, ValueList, "="); string SQL = "select 1 from " + TableName + " nolock where " + FBillNOField + "='" + wFBillNO + "' " + (xSQL == "" ? "" : " and " + xSQL); DataTable TT = DBContext.Database.SqlQuery(SQL); if (TT.Rows.Count > 0) { continue; } else { break; } } myCodeNo.FSEQ = iSEQ; if (IsAdd) DBContext.Add(myCodeNo); else DBContext.Update(myCodeNo); } else { string mFBillCode = DateTime.Now.ToString("yyyyMMdd"); myCodeNo = DBContext.SYS_LISTCODENO.SingleOrDefault(o => o.FCLASSTYPEID.Equals(wPrgKey) && o.FBILLCODE.Equals(mFBillCode)); if (myCodeNo == null) { myCodeNo = new sysListCodeNO(); iSEQ = 0; myCodeNo.C_YMD = DateTime.Now; myCodeNo.UID = Guid.NewGuid().ToString(); myCodeNo.FINTERID = Guid.NewGuid().ToString(); myCodeNo.C_USER = LoginInfo.UserID; myCodeNo.FCLASSTYPEID = wPrgKey; myCodeNo.FBILLCODE = mFBillCode; myCodeNo.FSEQ = 0; IsAdd = true; } else { iSEQ = myCodeNo.FSEQ; IsAdd = false; } int icc = 0; while (true) { iSEQ++; icc++; if (icc > 1000) { throw new System.Exception("单据编号已经循环超过1千次,有可能是死循环!"); } #region ================ 计算编号资料 =========================== wFBillNO = mFBillCode + iSEQ.ToString().PadLeft(4, '0'); #endregion ================ 计算编号资料 =========================== string xSQL = ""; if (KeyList != "") xSQL = GetWhereSql(KeyList, ValueList, "="); string SQL = "select 1 from " + TableName + " nolock where " + FBillNOField + "='" + wFBillNO + "' " + (xSQL == "" ? "" : " and " + xSQL); DataTable TT = DBContext.Database.SqlQuery(SQL); if (TT.Rows.Count > 0) { continue; } else { break; } } myCodeNo.FSEQ = iSEQ; if (IsAdd) DBContext.Add(myCodeNo); else DBContext.Update(myCodeNo); } DBContext.SaveChanges(); return wFBillNO; } catch (System.Exception ex) { throw ex; } } } /// /// /// /// /// /// /// /// /// /// protected string CreateBatchNO(string strJSON, string wPrgKey, string TableName, string FBillNOField, string KeyList, string ValueList) { using (APPServerContext DBContext = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID)) { try { JObject ICursor = (JObject)JsonConvert.DeserializeObject(strJSON); // 自动编单据编号 // 1. 首行得到单据编号规则 string wFBillNO = ""; string wFIeldID = "", wFValue = "", wFormatString = "", wFChar = ""; int wFLenght = 0; bool wIsSerial = false, wIsMember = false; string wCodeContrast = ""; //是否有编码对照表 string wFCharAlignment = ""; DataTable myCodeEntrys = DBContext.Database.SqlQuery( "select * from SYS_BATCHCODEENTRY where FCLASSTYPEID ='" + wPrgKey + "' order by FENTRYID "); sysBatchCodeNO myCodeNo; bool IsAdd = true; DateTime wToDay = DateTime.Now; int iSEQ = 0; if (myCodeEntrys.Rows.Count > 0) { string wKeyCode = ""; //流水号编号依据 #region ================ 计算抓流水号资料 =========================== foreach (DataRow subCodeEntry in myCodeEntrys.Rows) { wFIeldID = subCodeEntry["FIELDID"].ToStringEx(); wFValue = subCodeEntry["FVALUE"].ToStringEx(); wIsSerial = subCodeEntry["ISSERIAL"].ToBoolean(); wFLenght = subCodeEntry["FLENGHT"].ToInt(); wFormatString = subCodeEntry["FORMATSTRING"].ToStringEx(); wFChar = subCodeEntry["FCHAR"].ToStringEx().Trim(); wIsMember = subCodeEntry["ISMEMBER"].ToBoolean(); wFCharAlignment = subCodeEntry["FCHARALIGNMENT"].ToStringEx(); wCodeContrast = subCodeEntry["FCODECONTRAST"].ToStringEx(); //1=常量, 2=文本字段 3= 日期字段 4=流水号 switch (subCodeEntry["FTYPE"].ToStringEx()) { case "1": //常量 if (wIsSerial) //如果为编流水号的依据 wKeyCode += wFValue; break; case "2": if (wIsSerial) //如果为编流水号的依据 { string temp = ICursor[wFIeldID].ToStringEx(); if (wFLenght > 0) { temp = temp.SubStringEx(0, wFLenght, false); string mychar = " "; if (wFChar != "") { mychar = wFChar; } if (wFCharAlignment == "R") { temp = temp.PadRight(wFLenght, mychar[0]); } else { temp = temp.PadLeft(wFLenght, mychar[0]); } } switch (wFormatString.ToUpper()) { case "U": temp = temp.ToUpper(); break; case "L": temp = temp.ToLower(); break; default: break; } //如果存在编码对照表 if (!string.IsNullOrEmpty(wCodeContrast)) { DataTable tempTable = DBContext.Database.SqlQuery( " select T1.FCODE " + " from SYS_CODECONTRASTENTRY T1 " + " join SYS_CODECONTRAST T2 on T1.FINTERID=T2.FINTERID " + " where T2.FNUMBER=" + DBContext.GetDBParName("@PA1") + " and T1.FVALUE=" + DBContext.GetDBParName("@PA2") + " ", DBContext.CreateParameter("@PA1", wCodeContrast), DBContext.CreateParameter("@PA2", temp)); if (tempTable.Rows.Count > 0) { temp = tempTable.Rows[0]["FCODE"].ToStringEx(); } } wKeyCode += temp; } break; case "5": // 数值字段 if (wIsSerial) //如果为编流水号的依据 { string temp = ICursor[wFIeldID].ToDecimal().ToString("0.###################"); if (wFLenght > 0) { temp = temp.SubStringEx(0, wFLenght, false); string mychar = " "; if (wFChar != "") { mychar = wFChar; } if (wFCharAlignment == "R") { temp = temp.PadRight(wFLenght, mychar[0]); } else { temp = temp.PadLeft(wFLenght, mychar[0]); } } switch (wFormatString.ToUpper()) { case "U": temp = temp.ToUpper(); break; case "L": temp = temp.ToLower(); break; default: break; } //如果存在编码对照表 if (!string.IsNullOrEmpty(wCodeContrast)) { DataTable tempTable = DBContext.Database.SqlQuery( " select T1.FCODE " + " from SYS_CODECONTRASTENTRY T1 " + " join SYS_CODECONTRAST T2 on T1.FINTERID=T2.FINTERID " + " where T2.FNUMBER=" + DBContext.GetDBParName("@PA1") + " and T1.FVALUE=" + DBContext.GetDBParName("@PA2") + " ", DBContext.CreateParameter("@PA1", wCodeContrast), DBContext.CreateParameter("@PA2", temp)); if (tempTable.Rows.Count > 0) { temp = tempTable.Rows[0]["FCODE"].ToStringEx(); } } wKeyCode += temp; } break; case "3": // 3= 日期字段 if (wIsSerial) //如果为编流水号的依据 { DateTime temp = wToDay; try { if (!Convert.IsDBNull(ICursor[wFIeldID])) { temp = Convert.ToDateTime(ICursor[wFIeldID]); } } catch (System.Exception) { temp = wToDay; } string strtemp = ""; if (string.IsNullOrEmpty(wFormatString)) { strtemp = temp.ToString("yyyyMMdd"); } else { strtemp = temp.ToString(wFormatString); } strtemp = strtemp.SubStringEx(0, wFLenght); //如果存在编码对照表 if (!string.IsNullOrEmpty(wCodeContrast)) { DataTable tempTable = DBContext.Database.SqlQuery( " select T1.FCODE " + " from SYS_CODECONTRASTENTRY T1 " + " join SYS_CODECONTRAST T2 on T1.FINTERID=T2.FINTERID " + " where T2.FNUMBER=" + DBContext.GetDBParName("@PA1") + " and T1.FVALUE=" + DBContext.GetDBParName("@PA2") + " ", DBContext.CreateParameter("@PA1", wCodeContrast), DBContext.CreateParameter("@PA2", strtemp)); if (tempTable.Rows.Count > 0) { strtemp = tempTable.Rows[0]["FCODE"].ToStringEx(); } } wKeyCode += strtemp; } break; case "4": // 4=流水号 break; } } #endregion ================ 计算抓流水号资料 =========================== myCodeNo = DBContext.SYS_BATCHCODENO.SingleOrDefault(o => o.FCLASSTYPEID.Equals(wPrgKey) && o.FBILLCODE.Equals(wKeyCode)); if (myCodeNo == null) { myCodeNo = new sysBatchCodeNO(); iSEQ = 0; myCodeNo.C_YMD = DateTime.Now; myCodeNo.UID = Guid.NewGuid().ToString(); myCodeNo.FINTERID = Guid.NewGuid().ToString(); myCodeNo.C_USER = LoginInfo.UserID; myCodeNo.FCLASSTYPEID = wPrgKey; myCodeNo.FBILLCODE = wKeyCode; myCodeNo.FSEQ = 0; IsAdd = true; } else { iSEQ = myCodeNo.FSEQ; IsAdd = false; } int icc = 0; while (true) { iSEQ++; icc++; if (icc > 1000) { throw new System.Exception("单据编号已经循环超过1千次,有可能是死循环!"); } #region ================ 计算编号资料 =========================== wFBillNO = ""; foreach (DataRow subCodeEntry in myCodeEntrys.Rows) { wFIeldID = subCodeEntry["FIELDID"].ToStringEx(); wFValue = subCodeEntry["FVALUE"].ToStringEx(); wIsSerial = subCodeEntry["ISSERIAL"].ToBoolean(); wFLenght = subCodeEntry["FLENGHT"].ToInt(); wFormatString = subCodeEntry["FORMATSTRING"].ToStringEx(); wFChar = subCodeEntry["FCHAR"].ToStringEx().Trim(); wIsMember = subCodeEntry["ISMEMBER"].ToBoolean(); wFCharAlignment = subCodeEntry["FCHARALIGNMENT"].ToStringEx(); wCodeContrast = subCodeEntry["FCODECONTRAST"].ToStringEx(); //1=常量, 2=文本字段 3= 日期字段 4=流水号 switch (subCodeEntry["FTYPE"].ToStringEx()) { case "1": if (wIsMember) //如果为编流水号的依据 wFBillNO += wFValue; break; case "2": if (wIsMember) //如果为编流水号的依据 { string temp = ICursor[wFIeldID].ToStringEx(); if (wFLenght > 0) { temp = temp.SubStringEx(0, wFLenght, false); string mychar = " "; if (wFChar != "") { mychar = wFChar; } if (wFCharAlignment == "R") { temp = temp.PadRight(wFLenght, mychar[0]); } else { temp = temp.PadLeft(wFLenght, mychar[0]); } } switch (wFormatString.ToUpper()) { case "U": temp = temp.ToUpper(); break; case "L": temp = temp.ToLower(); break; default: break; } //如果存在编码对照表 if (!string.IsNullOrEmpty(wCodeContrast)) { DataTable tempTable = DBContext.Database.SqlQuery( " select T1.FCODE " + " from SYS_CODECONTRASTENTRY T1 " + " join SYS_CODECONTRAST T2 on T1.FINTERID=T2.FINTERID " + " where T2.FNUMBER=" + DBContext.GetDBParName("@PA1") + " and T1.FVALUE=" + DBContext.GetDBParName("@PA2") + " ", DBContext.CreateParameter("@PA1", wCodeContrast), DBContext.CreateParameter("@PA2", temp)); if (tempTable.Rows.Count > 0) { temp = tempTable.Rows[0]["FCODE"].ToStringEx(); } } wFBillNO += temp; } break; case "5": // 数值字段 if (wIsMember) //如果为编流水号的依据 { string temp = ICursor[wFIeldID].ToDecimal().ToString("0.###################"); if (wFLenght > 0) { temp = temp.SubStringEx(0, wFLenght, false); string mychar = " "; if (wFChar != "") { mychar = wFChar; } if (wFCharAlignment == "R") { temp = temp.PadRight(wFLenght, mychar[0]); } else { temp = temp.PadLeft(wFLenght, mychar[0]); } } switch (wFormatString.ToUpper()) { case "U": temp = temp.ToUpper(); break; case "L": temp = temp.ToLower(); break; default: break; } //如果存在编码对照表 if (!string.IsNullOrEmpty(wCodeContrast)) { DataTable tempTable = DBContext.Database.SqlQuery( " select T1.FCODE " + " from SYS_CODECONTRASTENTRY T1 " + " join SYS_CODECONTRAST T2 on T1.FINTERID=T2.FINTERID " + " where T2.FNUMBER=" + DBContext.GetDBParName("@PA1") + " and T1.FVALUE=" + DBContext.GetDBParName("@PA2") + " ", DBContext.CreateParameter("@PA1", wCodeContrast), DBContext.CreateParameter("@PA2", temp)); if (tempTable.Rows.Count > 0) { temp = tempTable.Rows[0]["FCODE"].ToStringEx(); } } wFBillNO += temp; } break; case "3": // 3= 日期字段 if (wIsMember) //如果为编流水号的依据 { DateTime temp = wToDay; try { if (!Convert.IsDBNull(ICursor[wFIeldID])) { temp = Convert.ToDateTime(ICursor[wFIeldID]); } } catch (System.Exception) { temp = wToDay; } string strtemp = ""; if (string.IsNullOrEmpty(wFormatString)) { strtemp = temp.ToString("yyyyMMdd"); } else { strtemp = temp.ToString(wFormatString); } strtemp = strtemp.SubStringEx(0, wFLenght); //如果存在编码对照表 if (!string.IsNullOrEmpty(wCodeContrast)) { DataTable tempTable = DBContext.Database.SqlQuery( " select T1.FCODE " + " from SYS_CODECONTRASTENTRY T1 " + " join SYS_CODECONTRAST T2 on T1.FINTERID=T2.FINTERID " + " where T2.FNUMBER=" + DBContext.GetDBParName("@PA1") + " and T1.FVALUE=" + DBContext.GetDBParName("@PA2") + " ", DBContext.CreateParameter("@PA1", wCodeContrast), DBContext.CreateParameter("@PA2", strtemp)); if (tempTable.Rows.Count > 0) { strtemp = tempTable.Rows[0]["FCODE"].ToStringEx(); } } wFBillNO += strtemp; } break; case "4": // 4=流水号 wFBillNO += iSEQ.ToString().PadLeft(wFLenght, '0'); break; } } #endregion ================ 计算编号资料 =========================== string xSQL = ""; if (KeyList != "") xSQL = GetWhereSql(KeyList, ValueList, "="); string SQL = "select 1 from " + TableName + " nolock where " + FBillNOField + "='" + wFBillNO + "' " + (xSQL == "" ? "" : " and " + xSQL); DataTable TT = DBContext.Database.SqlQuery(SQL); if (TT.Rows.Count > 0) { continue; } else { break; } } myCodeNo.FSEQ = iSEQ; if (IsAdd) DBContext.Add(myCodeNo); else DBContext.Update(myCodeNo); } else { string mFBillCode = DateTime.Now.ToString("yyyyMMdd"); myCodeNo = DBContext.SYS_BATCHCODENO.SingleOrDefault(o => o.FCLASSTYPEID.Equals(wPrgKey) && o.FBILLCODE.Equals(mFBillCode)); if (myCodeNo == null) { myCodeNo = new sysBatchCodeNO(); iSEQ = 0; myCodeNo.C_YMD = DateTime.Now; myCodeNo.UID = Guid.NewGuid().ToString(); myCodeNo.FINTERID = Guid.NewGuid().ToString(); myCodeNo.C_USER = LoginInfo.UserID; myCodeNo.FCLASSTYPEID = wPrgKey; myCodeNo.FBILLCODE = mFBillCode; myCodeNo.FSEQ = 0; IsAdd = true; } else { iSEQ = myCodeNo.FSEQ.ToInt(); IsAdd = false; } int icc = 0; while (true) { iSEQ++; icc++; if (icc > 1000) { throw new System.Exception("单据编号已经循环超过1千次,有可能是死循环!"); } #region ================ 计算编号资料 =========================== wFBillNO = mFBillCode + iSEQ.ToString().PadLeft(4, '0'); #endregion ================ 计算编号资料 =========================== string xSQL = ""; if (KeyList != "") xSQL = GetWhereSql(KeyList, ValueList, "="); string SQL = "select 1 from " + TableName + " nolock where " + FBillNOField + "='" + wFBillNO + "' " + (xSQL == "" ? "" : " and " + xSQL); DataTable TT = DBContext.Database.SqlQuery(SQL); if (TT.Rows.Count > 0) { continue; } else { break; } } myCodeNo.FSEQ = iSEQ; if (IsAdd) DBContext.Add(myCodeNo); else DBContext.Update(myCodeNo); } DBContext.SaveChanges(); return wFBillNO; } catch (System.Exception ex) { throw ex; } } } /// /// /// /// /// /// /// /// /// /// protected string CreateBarCodeNo(string strJSON, string wPrgKey, string TableName, string FBillNOField, string KeyList, string ValueList) { using (APPServerContext DBContext = new APPServerContext(LoginInfo.DBAias, LoginInfo.UserID)) { try { JObject ICursor = (JObject)JsonConvert.DeserializeObject(strJSON); // 自动编单据编号 // 1. 首行得到单据编号规则 string wFBillNO = ""; string wFIeldID = "", wFValue = "", wFormatString = "", wFChar = ""; int wFLenght = 0; string wCodeContrast = ""; //是否有编码对照表 bool wIsSerial = false, wIsMember = false; string wFCharAlignment = ""; DataTable myCodeEntrys = DBContext.Database.SqlQuery( "select * from SYS_BARCODEENTRY where FCLASSTYPEID ='" + wPrgKey + "' order by FENTRYID "); sysBarCodeNO myCodeNo; bool IsAdd = true; DateTime wToDay = DateTime.Now; int iSEQ = 0; if (myCodeEntrys.Rows.Count > 0) { string wKeyCode = ""; //流水号编号依据 #region ================ 计算抓流水号资料 =========================== foreach (DataRow subCodeEntry in myCodeEntrys.Rows) { wFIeldID = subCodeEntry["FIELDID"].ToStringEx(); wFValue = subCodeEntry["FVALUE"].ToStringEx(); wIsSerial = subCodeEntry["ISSERIAL"].ToBoolean(); wFLenght = subCodeEntry["FLENGHT"].ToInt(); wFormatString = subCodeEntry["FORMATSTRING"].ToStringEx(); wFChar = subCodeEntry["FCHAR"].ToStringEx().Trim(); wIsMember = subCodeEntry["ISMEMBER"].ToBoolean(); wFCharAlignment = subCodeEntry["FCHARALIGNMENT"].ToStringEx(); wCodeContrast = subCodeEntry["FCODECONTRAST"].ToStringEx(); //1=常量, 2=文本字段 3= 日期字段 4=流水号 switch (subCodeEntry["FTYPE"].ToStringEx()) { case "1": //常量 if (wIsSerial) //如果为编流水号的依据 wKeyCode += wFValue; break; case "2": if (wIsSerial) //如果为编流水号的依据 { string temp = ICursor[wFIeldID].ToStringEx(); if (wFLenght > 0) { temp = temp.SubStringEx(0, wFLenght, false); string mychar = " "; if (wFChar != "") { mychar = wFChar; } if (wFCharAlignment == "R") { temp = temp.PadRight(wFLenght, mychar[0]); } else { temp = temp.PadLeft(wFLenght, mychar[0]); } } switch (wFormatString.ToUpper()) { case "U": temp = temp.ToUpper(); break; case "L": temp = temp.ToLower(); break; default: break; } //如果存在编码对照表 if (!string.IsNullOrEmpty(wCodeContrast)) { DataTable tempTable = DBContext.Database.SqlQuery( " select T1.FCODE " + " from SYS_CODECONTRASTENTRY T1 " + " join SYS_CODECONTRAST T2 on T1.FINTERID=T2.FINTERID " + " where T2.FNUMBER=" + DBContext.GetDBParName("@PA1") + " and T1.FVALUE=" + DBContext.GetDBParName("@PA2") + " ", DBContext.CreateParameter("@PA1", wCodeContrast), DBContext.CreateParameter("@PA2", temp)); if (tempTable.Rows.Count > 0) { temp = tempTable.Rows[0]["FCODE"].ToStringEx(); } } wKeyCode += temp; } break; case "5": // 数值字段 if (wIsSerial) //如果为编流水号的依据 { string temp = ICursor[wFIeldID].ToDecimal().ToString("0.###################"); if (wFLenght > 0) { temp = temp.SubStringEx(0, wFLenght, false); string mychar = " "; if (wFChar != "") { mychar = wFChar; } if (wFCharAlignment == "R") { temp = temp.PadRight(wFLenght, mychar[0]); } else { temp = temp.PadLeft(wFLenght, mychar[0]); } } switch (wFormatString.ToUpper()) { case "U": temp = temp.ToUpper(); break; case "L": temp = temp.ToLower(); break; default: break; } //如果存在编码对照表 if (!string.IsNullOrEmpty(wCodeContrast)) { DataTable tempTable = DBContext.Database.SqlQuery( " select T1.FCODE " + " from SYS_CODECONTRASTENTRY T1 " + " join SYS_CODECONTRAST T2 on T1.FINTERID=T2.FINTERID " + " where T2.FNUMBER=" + DBContext.GetDBParName("@PA1") + " and T1.FVALUE=" + DBContext.GetDBParName("@PA2") + " ", DBContext.CreateParameter("@PA1", wCodeContrast), DBContext.CreateParameter("@PA2", temp)); if (tempTable.Rows.Count > 0) { temp = tempTable.Rows[0]["FCODE"].ToStringEx(); } } wKeyCode += temp; } break; case "3": // 3= 日期字段 if (wIsSerial) //如果为编流水号的依据 { DateTime temp = wToDay; try { if (!Convert.IsDBNull(ICursor[wFIeldID])) { temp = Convert.ToDateTime(ICursor[wFIeldID]); } } catch (System.Exception) { temp = wToDay; } string strtemp = ""; if (string.IsNullOrEmpty(wFormatString)) { strtemp = temp.ToString("yyyyMMdd"); } else { strtemp = temp.ToString(wFormatString); } strtemp = strtemp.SubStringEx(0, wFLenght); //如果存在编码对照表 if (!string.IsNullOrEmpty(wCodeContrast)) { DataTable tempTable = DBContext.Database.SqlQuery( " select T1.FCODE " + " from SYS_CODECONTRASTENTRY T1 " + " join SYS_CODECONTRAST T2 on T1.FINTERID=T2.FINTERID " + " where T2.FNUMBER=" + DBContext.GetDBParName("@PA1") + " and T1.FVALUE=" + DBContext.GetDBParName("@PA2") + " ", DBContext.CreateParameter("@PA1", wCodeContrast), DBContext.CreateParameter("@PA2", strtemp)); if (tempTable.Rows.Count > 0) { strtemp = tempTable.Rows[0]["FCODE"].ToStringEx(); } } wKeyCode += strtemp; } break; case "4": // 4=流水号 break; } } #endregion ================ 计算抓流水号资料 =========================== myCodeNo = DBContext.SYS_BARCODENO.SingleOrDefault(o => o.FCLASSTYPEID.Equals(wPrgKey) && o.FBILLCODE.Equals(wKeyCode)); if (myCodeNo == null) { myCodeNo = new sysBarCodeNO(); iSEQ = 0; myCodeNo.C_YMD = DateTime.Now; myCodeNo.UID = Guid.NewGuid().ToString(); myCodeNo.FINTERID = Guid.NewGuid().ToString(); myCodeNo.C_USER = LoginInfo.UserID; myCodeNo.FCLASSTYPEID = wPrgKey; myCodeNo.FBILLCODE = wKeyCode; myCodeNo.FSEQ = 0; IsAdd = true; } else { iSEQ = myCodeNo.FSEQ; IsAdd = false; } int icc = 0; while (true) { iSEQ++; icc++; if (icc > 1000) { throw new System.Exception("单据编号已经循环超过1千次,有可能是死循环!"); } #region ================ 计算编号资料 =========================== wFBillNO = ""; foreach (DataRow subCodeEntry in myCodeEntrys.Rows) { wFIeldID = subCodeEntry["FIELDID"].ToStringEx(); wFValue = subCodeEntry["FVALUE"].ToStringEx(); wIsSerial = subCodeEntry["ISSERIAL"].ToBoolean(); wFLenght = subCodeEntry["FLENGHT"].ToInt(); wFormatString = subCodeEntry["FORMATSTRING"].ToStringEx(); wFChar = subCodeEntry["FCHAR"].ToStringEx().Trim(); wIsMember = subCodeEntry["ISMEMBER"].ToBoolean(); wFCharAlignment = subCodeEntry["FCHARALIGNMENT"].ToStringEx(); wCodeContrast = subCodeEntry["FCODECONTRAST"].ToStringEx(); //1=常量, 2=文本字段 3= 日期字段 4=流水号 switch (subCodeEntry["FTYPE"].ToStringEx()) { case "1": if (wIsMember) //如果为编流水号的依据 wFBillNO += wFValue; break; case "2": if (wIsMember) //如果为编流水号的依据 { string temp = ICursor[wFIeldID].ToStringEx(); if (wFLenght > 0) { temp = temp.SubStringEx(0, wFLenght, false); string mychar = " "; if (wFChar != "") { mychar = wFChar; } if (wFCharAlignment == "R") { temp = temp.PadRight(wFLenght, mychar[0]); } else { temp = temp.PadLeft(wFLenght, mychar[0]); } } switch (wFormatString.ToUpper()) { case "U": temp = temp.ToUpper(); break; case "L": temp = temp.ToLower(); break; default: break; } //如果存在编码对照表 if (!string.IsNullOrEmpty(wCodeContrast)) { DataTable tempTable = DBContext.Database.SqlQuery( " select T1.FCODE " + " from SYS_CODECONTRASTENTRY T1 " + " join SYS_CODECONTRAST T2 on T1.FINTERID=T2.FINTERID " + " where T2.FNUMBER=" + DBContext.GetDBParName("@PA1") + " and T1.FVALUE=" + DBContext.GetDBParName("@PA2") + " ", DBContext.CreateParameter("@PA1", wCodeContrast), DBContext.CreateParameter("@PA2", temp)); if (tempTable.Rows.Count > 0) { temp = tempTable.Rows[0]["FCODE"].ToStringEx(); } } wFBillNO += temp; } break; case "5": // 数值字段 if (wIsMember) //如果为编流水号的依据 { string temp = ICursor[wFIeldID].ToDecimal().ToString("0.###################"); if (wFLenght > 0) { temp = temp.SubStringEx(0, wFLenght, false); string mychar = " "; if (wFChar != "") { mychar = wFChar; } if (wFCharAlignment == "R") { temp = temp.PadRight(wFLenght, mychar[0]); } else { temp = temp.PadLeft(wFLenght, mychar[0]); } } switch (wFormatString.ToUpper()) { case "U": temp = temp.ToUpper(); break; case "L": temp = temp.ToLower(); break; default: break; } //如果存在编码对照表 if (!string.IsNullOrEmpty(wCodeContrast)) { DataTable tempTable = DBContext.Database.SqlQuery( " select T1.FCODE " + " from SYS_CODECONTRASTENTRY T1 " + " join SYS_CODECONTRAST T2 on T1.FINTERID=T2.FINTERID " + " where T2.FNUMBER=" + DBContext.GetDBParName("@PA1") + " and T1.FVALUE=" + DBContext.GetDBParName("@PA2") + " ", DBContext.CreateParameter("@PA1", wCodeContrast), DBContext.CreateParameter("@PA2", temp)); if (tempTable.Rows.Count > 0) { temp = tempTable.Rows[0]["FCODE"].ToStringEx(); } } wFBillNO += temp; } break; case "3": // 3= 日期字段 if (wIsMember) //如果为编流水号的依据 { DateTime temp = wToDay; try { if (!Convert.IsDBNull(ICursor[wFIeldID])) { temp = Convert.ToDateTime(ICursor[wFIeldID]); } } catch (System.Exception) { temp = wToDay; } string strtemp = ""; if (string.IsNullOrEmpty(wFormatString)) { strtemp = temp.ToString("yyyyMMdd"); } else { strtemp = temp.ToString(wFormatString); } strtemp = strtemp.SubStringEx(0, wFLenght); //如果存在编码对照表 if (!string.IsNullOrEmpty(wCodeContrast)) { DataTable tempTable = DBContext.Database.SqlQuery( " select T1.FCODE " + " from SYS_CODECONTRASTENTRY T1 " + " join SYS_CODECONTRAST T2 on T1.FINTERID=T2.FINTERID " + " where T2.FNUMBER=" + DBContext.GetDBParName("@PA1") + " and T1.FVALUE=" + DBContext.GetDBParName("@PA2") + " ", DBContext.CreateParameter("@PA1", wCodeContrast), DBContext.CreateParameter("@PA2", strtemp)); if (tempTable.Rows.Count > 0) { strtemp = tempTable.Rows[0]["FCODE"].ToStringEx(); } } wFBillNO += strtemp; } break; case "4": // 4=流水号 wFBillNO += iSEQ.ToString().PadLeft(wFLenght, '0'); break; } } #endregion ================ 计算编号资料 =========================== string xSQL = ""; if (KeyList != "") xSQL = GetWhereSql(KeyList, ValueList, "="); string SQL = "select 1 from " + TableName + " nolock where " + FBillNOField + "='" + wFBillNO + "' " + (xSQL == "" ? "" : " and " + xSQL); DataTable TT = DBContext.Database.SqlQuery(SQL); if (TT.Rows.Count > 0) { continue; } else { break; } } myCodeNo.FSEQ = iSEQ; if (IsAdd) DBContext.Add(myCodeNo); else DBContext.Update(myCodeNo); } else { string mFBillCode = DateTime.Now.ToString("yyyyMMdd"); myCodeNo = DBContext.SYS_BARCODENO.SingleOrDefault(o => o.FCLASSTYPEID.Equals(wPrgKey) && o.FBILLCODE.Equals(mFBillCode)); if (myCodeNo == null) { myCodeNo = new sysBarCodeNO(); iSEQ = 0; myCodeNo.C_YMD = DateTime.Now; myCodeNo.UID = Guid.NewGuid().ToString(); myCodeNo.FINTERID = Guid.NewGuid().ToString(); myCodeNo.C_USER = LoginInfo.UserID; myCodeNo.FCLASSTYPEID = wPrgKey; myCodeNo.FBILLCODE = mFBillCode; myCodeNo.FSEQ = 0; IsAdd = true; } else { iSEQ = myCodeNo.FSEQ; IsAdd = false; } int icc = 0; while (true) { iSEQ++; icc++; if (icc > 3000) { throw new System.Exception("单据编号已经循环超过3千次,有可能是死循环!"); } #region ================ 计算编号资料 =========================== wFBillNO = mFBillCode + iSEQ.ToString().PadLeft(4, '0'); #endregion ================ 计算编号资料 =========================== string xSQL = ""; if (KeyList != "") xSQL = GetWhereSql(KeyList, ValueList, "="); string SQL = "select 1 from " + TableName + " nolock where " + FBillNOField + "='" + wFBillNO + "' " + (xSQL == "" ? "" : " and " + xSQL); DataTable TT = DBContext.Database.SqlQuery(SQL); if (TT.Rows.Count > 0) { continue; } else { break; } } myCodeNo.FSEQ = iSEQ; if (IsAdd) DBContext.Add(myCodeNo); else DBContext.Update(myCodeNo); } DBContext.SaveChanges(); return wFBillNO; } catch (System.Exception ex) { throw ex; } } } string GetWhereSql(string KeyList, string ValueList, string flg_Type) { if (KeyList.Trim() == "") return " 1=1 "; string[] ArrKeyList, ArrValueList, NewKeyList, NewKeyTypeList; string strHorL = ""; string mWhereSQL = ""; if (flg_Type != "") strHorL = flg_Type; else strHorL = ">="; ArrKeyList = KeyList.Split(','); ArrValueList = ValueList.Split(','); NewKeyList = new string[ArrKeyList.GetLength(0)]; NewKeyTypeList = new string[ArrKeyList.GetLength(0)]; for (int i = 0; i < ArrKeyList.GetLength(0); i++) { string mKey = ArrKeyList[i]; if (mKey.Length < 3 || mKey.IndexOf('(') < 0) { NewKeyList[i] = mKey; NewKeyTypeList[i] = "C"; } else { NewKeyList[i] = mKey.Substring(0, mKey.Length - 3); NewKeyTypeList[i] = mKey.Substring(mKey.Length - 2, 1); } } for (int i = 0; i < ArrKeyList.GetLength(0) && i < ArrValueList.GetLength(0); i++) { if (i == 0) if (NewKeyTypeList[i].ToUpperEx() == "C" || NewKeyTypeList[i].ToUpperEx() == "D") mWhereSQL = " " + NewKeyList[i] + strHorL + "'" + ArrValueList[i] + "' "; else mWhereSQL = " " + NewKeyList[i] + strHorL + ArrValueList[i] + " "; else if (NewKeyTypeList[i].ToUpperEx() == "C" || NewKeyTypeList[i].ToUpperEx() == "D") mWhereSQL = mWhereSQL + " and " + NewKeyList[i] + strHorL + "'" + ArrValueList[i] + "' "; else mWhereSQL = mWhereSQL + " and " + NewKeyList[i] + strHorL + ArrValueList[i] + " "; } return mWhereSQL; } #endregion ================= 扩展函数=========================================== } }