1702 lines
99 KiB
C#
Executable File
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 ================= 扩展函数===========================================
|
|
}
|
|
} |