/// <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; }