/// <summary>
/// 根据条件，获取T_FB_ORDERCODE信息
/// </summary>
/// <param name="strVacName"></param>
/// <param name="strVacYear"></param>
/// <param name="strCountyType"></param>
/// <param name="strSortKey"></param>
/// <returns></returns>
public static IQueryable<T_FB_ORDERCODE> GetAllOrderCodeRdListByMultSearch(string strFilter, List<object> objArgs, string strSortKey)
{
OrderCodeDAL dalOrderCode = new OrderCodeDAL();
string strOrderBy = string.Empty;
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = " TABLENAME ";
}
var q = dalOrderCode.GetOrderCodeRdListByMultSearch(strOrderBy, strFilter, objArgs.ToArray());
return q;
}
/// <summary>
/// 根据条件，获取T_FB_ORDERCODE信息
/// </summary>
/// <param name="strVacName"></param>
/// <param name="strVacYear"></param>
/// <param name="strCountyType"></param>
/// <param name="strSortKey"></param>
/// <returns></returns>
public static IQueryable <T_FB_ORDERCODE> GetAllOrderCodeRdListByMultSearch(string strFilter, List <object> objArgs, string strSortKey)
{
OrderCodeDAL dalOrderCode = new OrderCodeDAL();
string strOrderBy = string.Empty;
if (!string.IsNullOrEmpty(strSortKey))
{
strOrderBy = strSortKey;
}
else
{
strOrderBy = " TABLENAME ";
}
var q = dalOrderCode.GetOrderCodeRdListByMultSearch(strOrderBy, strFilter, objArgs.ToArray());
return(q);
}
/// <summary>
/// 获取T_FB_ORDERCODE信息
/// </summary>
/// <param name="strOrderCodeId">主键索引</param>
/// <returns></returns>
public T_FB_ORDERCODE GetOrderCodeByID(string strOrderCodeId)
{
if (string.IsNullOrEmpty(strOrderCodeId))
{
return null;
}
OrderCodeDAL dalOrderCode = new OrderCodeDAL();
StringBuilder strFilter = new StringBuilder();
List<string> objArgs = new List<string>();
if (!string.IsNullOrEmpty(strOrderCodeId))
{
strFilter.Append(" TABLENAME == @0");
objArgs.Add(strOrderCodeId);
}
T_FB_ORDERCODE entRd = dalOrderCode.GetOrderCodeRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
return entRd;
}
/// <summary>
/// 获取T_FB_ORDERCODE信息
/// </summary>
/// <param name="strOrderCodeId">主键索引</param>
/// <returns></returns>
public T_FB_ORDERCODE GetOrderCodeByID(string strOrderCodeId)
{
if (string.IsNullOrEmpty(strOrderCodeId))
{
return(null);
}
OrderCodeDAL dalOrderCode = new OrderCodeDAL();
StringBuilder strFilter = new StringBuilder();
List <string> objArgs = new List <string>();
if (!string.IsNullOrEmpty(strOrderCodeId))
{
strFilter.Append(" TABLENAME == @0");
objArgs.Add(strOrderCodeId);
}
T_FB_ORDERCODE entRd = dalOrderCode.GetOrderCodeRdByMultSearch(strFilter.ToString(), objArgs.ToArray());
return(entRd);
}
/// <summary>
/// 获取单据编号
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
//public static string GetAutoOrderCode(EntityObject entity)
//{
// string strRes = string.Empty;
// string tablename = GetTableName(entity);
// if (string.IsNullOrWhiteSpace(tablename))
// {
// return strRes;
// }
// OrderCodeDAL dalOrderCode = new OrderCodeDAL();
// var ents = from n in dalOrderCode.GetObjects<T_FB_ORDERCODE>()
// where n.TABLENAME == tablename
// select n;
// T_FB_ORDERCODE orderCode = ents.FirstOrDefault();
// if (orderCode == null)
// {
// return strRes;
// }
// DateTime CurrentDate = orderCode.CURRENTDATE.Value;
// if (CurrentDate.Date != System.DateTime.Now.Date)
// {
// orderCode.CURRENTDATE = System.DateTime.Now.Date;
// orderCode.RUNNINGNUMBER = 1;
// }
// string shortName = orderCode.PRENAME;
// decimal curNumber = orderCode.RUNNINGNUMBER.Value;
// string strDate = orderCode.CURRENTDATE.Value.ToString("yyyyMMdd");
// string code = shortName + "_" + strDate + curNumber.ToString().PadLeft(6, '0');
// orderCode.RUNNINGNUMBER = curNumber + 1;
// dalOrderCode.Update(orderCode);
// return code;
//}
/// <summary>
/// 获取单据编号
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public string GetAutoOrderCode(EntityObject entity)
{
string strRes = string.Empty;
string tablename = GetTableName(entity);
if (string.IsNullOrWhiteSpace(tablename))
{
return(strRes);
}
OrderCodeDAL dalOrderCode = new OrderCodeDAL();
var ents = from n in dalOrderCode.GetObjects <T_FB_ORDERCODE>()
where n.TABLENAME == tablename
select n;
T_FB_ORDERCODE orderCode = ents.FirstOrDefault();
if (orderCode == null)
{
return(strRes);
}
string shortName = orderCode.PRENAME;
DateTime CurrentDate = orderCode.CURRENTDATE.Value;
if (CurrentDate.Date != System.DateTime.Now.Date)
{
orderCode.CURRENTDATE = System.DateTime.Now.Date;
orderCode.RUNNINGNUMBER = 1;
lock (this)
{
string strclear = @"declare n number(10); tsql varchar2(1000); begin select "
+ tablename + "_SEQ.nextval into n from dual; "
+ " n:=-(n);"
+ " tsql:= 'alter sequence " + tablename + "_SEQ increment by '|| n;"
+ " execute immediate tsql; "
+ " select " + tablename + "_SEQ.nextval into n from dual; "
+ " tsql:= 'alter sequence " + tablename + "_SEQ increment by 1 '; "
+ " execute immediate tsql; "
+ " end; ";
dalOrderCode.ExecuteCustomerSql(strclear);
//string strclear = " DROP SEQUENCE T_FB_CHARGEAPPLYMASTER_SEQ ";
//dalOrderCode.ExecuteCustomerSql(strclear);
//strclear = " create sequence T_FB_CHARGEAPPLYMASTER_SEQ minvalue 0 maxvalue 999999999999999999999999999 start with 1 increment by 1 cache 20 ";
//dalOrderCode.ExecuteCustomerSql(strclear);
}
}
decimal curNumber = 0;
string strNextSqense = @" select " + tablename + "_SEQ.nextval from dual";
curNumber = decimal.Parse(dalOrderCode.ExecuteCustomerSql(strNextSqense).ToString());
string strDate = orderCode.CURRENTDATE.Value.ToString("yyyyMMdd");
string code = shortName + "_" + strDate + curNumber.ToString().PadLeft(6, '0');
orderCode.RUNNINGNUMBER = Convert.ToInt32(curNumber + 1);
dalOrderCode.Update(orderCode);
return(code);
}
/// <summary>
/// 获取单据编号
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
//public static string GetAutoOrderCode(EntityObject entity)
//{
// string strRes = string.Empty;
// string tablename = GetTableName(entity);
// if (string.IsNullOrWhiteSpace(tablename))
// {
// return strRes;
// }
// OrderCodeDAL dalOrderCode = new OrderCodeDAL();
// var ents = from n in dalOrderCode.GetObjects<T_FB_ORDERCODE>()
// where n.TABLENAME == tablename
// select n;
// T_FB_ORDERCODE orderCode = ents.FirstOrDefault();
// if (orderCode == null)
// {
// return strRes;
// }
// DateTime CurrentDate = orderCode.CURRENTDATE.Value;
// if (CurrentDate.Date != System.DateTime.Now.Date)
// {
// orderCode.CURRENTDATE = System.DateTime.Now.Date;
// orderCode.RUNNINGNUMBER = 1;
// }
// string shortName = orderCode.PRENAME;
// decimal curNumber = orderCode.RUNNINGNUMBER.Value;
// string strDate = orderCode.CURRENTDATE.Value.ToString("yyyyMMdd");
// string code = shortName + "_" + strDate + curNumber.ToString().PadLeft(6, '0');
// orderCode.RUNNINGNUMBER = curNumber + 1;
// dalOrderCode.Update(orderCode);
// return code;
//}
/// <summary>
/// 获取单据编号
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
public string GetAutoOrderCode(EntityObject entity)
{
string strRes = string.Empty;
string tablename = GetTableName(entity);
if (string.IsNullOrWhiteSpace(tablename))
{
return strRes;
}
OrderCodeDAL dalOrderCode = new OrderCodeDAL();
var ents = from n in dalOrderCode.GetObjects<T_FB_ORDERCODE>()
where n.TABLENAME == tablename
select n;
T_FB_ORDERCODE orderCode = ents.FirstOrDefault();
if (orderCode == null)
{
return strRes;
}
string shortName = orderCode.PRENAME;
DateTime CurrentDate = orderCode.CURRENTDATE.Value;
if (CurrentDate.Date != System.DateTime.Now.Date)
{
orderCode.CURRENTDATE = System.DateTime.Now.Date;
orderCode.RUNNINGNUMBER = 1;
lock (this)
{
string strclear = @"declare n number(10); tsql varchar2(1000); begin select "
+ tablename + "_SEQ.nextval into n from dual; "
+ " n:=-(n);"
+ " tsql:= 'alter sequence " + tablename + "_SEQ increment by '|| n;"
+ " execute immediate tsql; "
+ " select " + tablename + "_SEQ.nextval into n from dual; "
+ " tsql:= 'alter sequence " + tablename + "_SEQ increment by 1 '; "
+ " execute immediate tsql; "
+ " end; ";
dalOrderCode.ExecuteCustomerSql(strclear);
//string strclear = " DROP SEQUENCE T_FB_CHARGEAPPLYMASTER_SEQ ";
//dalOrderCode.ExecuteCustomerSql(strclear);
//strclear = " create sequence T_FB_CHARGEAPPLYMASTER_SEQ minvalue 0 maxvalue 999999999999999999999999999 start with 1 increment by 1 cache 20 ";
//dalOrderCode.ExecuteCustomerSql(strclear);
}
}
decimal curNumber = 0;
string strNextSqense = @" select " + tablename + "_SEQ.nextval from dual";
curNumber = decimal.Parse(dalOrderCode.ExecuteCustomerSql(strNextSqense).ToString());
string strDate = orderCode.CURRENTDATE.Value.ToString("yyyyMMdd");
string code = shortName + "_" + strDate + curNumber.ToString().PadLeft(6, '0');
orderCode.RUNNINGNUMBER = Convert.ToInt32(curNumber + 1);
dalOrderCode.Update(orderCode);
return code;
}
