Files

1702 lines
99 KiB
C#
Executable File

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<TController> : Controller
where TController : BaseApiController<TController>
{
protected ILogger Logger { get; }
public IMapper Mapper { get; }
public BaseApiController(IMapper mapper, ILogger<TController> 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<BaseResponse<TOut>> TryProcess<TIn, TOut>(Func<TIn, Task<TOut>> coreProcess, TIn input, string requestId = "", [CallerMemberName] string callerName = "")
{
if (input == null)
{
return new BaseResponse<TOut>() { Success = false, Message = "参数不能为空" };
}
Dictionary<string, dynamic> extraInfo = new Dictionary<string, dynamic>();
//调查卡顿问题,原本记录的数据信息暂时停掉 20220223
//extraInfo.Add("Request", input);
Stopwatch stopwatch = new Stopwatch();
BaseResponse<TOut> response = new BaseResponse<TOut>();
//记录请求过的时间点
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<BaseResponse> TryProcess<TIn>(Func<TIn, Task> coreProcess, TIn input, string requestId = "", [CallerMemberName] string callerName = "")
{
if (input == null)
{
return new BaseResponse() { Success = false, Message = "参数不能是空" };
}
Dictionary<string, dynamic> extraInfo = new Dictionary<string, dynamic>();
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<TOut> LogWrapper<TIn, TOut>(Func<TIn, Task<TOut>> coreProcess, TIn input, string requestId = "", [CallerMemberName] string callerName = "")
{
Dictionary<string, dynamic> extraInfo = new Dictionary<string, dynamic>();
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 ================= 扩展函数===========================================
/// <summary>
///
/// </summary>
/// <param name="strJSON"></param>
/// <param name="wPrgKey"></param>
/// <param name="TableName"></param>
/// <param name="FBillNOField"></param>
/// <param name="KeyList"></param>
/// <param name="ValueList"></param>
/// <returns></returns>
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;
}
}
}
/// <summary>
///
/// </summary>
/// <param name="strJSON"></param>
/// <param name="wPrgKey"></param>
/// <param name="TableName"></param>
/// <param name="FBillNOField"></param>
/// <param name="KeyList"></param>
/// <param name="ValueList"></param>
/// <returns></returns>
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;
}
}
}
/// <summary>
///
/// </summary>
/// <param name="strJSON"></param>
/// <param name="wPrgKey"></param>
/// <param name="TableName"></param>
/// <param name="FBillNOField"></param>
/// <param name="KeyList"></param>
/// <param name="ValueList"></param>
/// <returns></returns>
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 ================= 扩展函数===========================================
}
}