private SNObject GetSN(ProcCore.Business.SNType tab) { SNObject sn = new SNObject(); using (var tx = new TransactionScope()) { var get_sn_db = getDB0; try { get_sn_db = getDB0; string tab_name = Enum.GetName(typeof(ProcCore.Business.SNType), tab); var items = get_sn_db.i_SN.Single(x => x.sn_type == tab_name); if (items.y == DateTime.Now.Year && items.m == DateTime.Now.Month && items.d == DateTime.Now.Day ) { int now_max = items.sn_max; now_max++; items.sn_max = now_max; } else { items.y = DateTime.Now.Year; items.m = DateTime.Now.Month; items.d = DateTime.Now.Day; items.sn_max = 1; } get_sn_db.SaveChanges(); tx.Complete(); sn.y = items.y; sn.m = items.m; sn.d = items.d; sn.sn_max = items.sn_max; } catch (Exception ex) { Console.WriteLine(ex.Message); } finally { get_sn_db.Dispose(); } } return sn; }
public int GetNewId(ProcCore.Business.CodeTable tab) { int i = 0; using (var tx = new TransactionScope()) { var get_id_db = getDB0; try { string tab_name = Enum.GetName(typeof(ProcCore.Business.CodeTable), tab); var item = get_id_db.i_IDX.Where(x => x.table_name == tab_name) .ToList() .FirstOrDefault(); if (item != null) { item.IDX++; get_id_db.SaveChanges(); tx.Complete(); i = item.IDX; } } catch (Exception ex) { Log.Write(ex.ToString()); } finally { get_id_db.Dispose(); } return i; } }