public void InsertSOUserAuditRatio(SOUserAuditRatioInfo oInfo) { new SOUserAuditRatioDac().Insert(oInfo); SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.UserRatio); ratioHash.Add(oInfo.UserSysNo, oInfo); }
public void DeleteSOUserAudit(SOUserAuditRatioInfo oInfo) { string sql = "delete from SO_User_AuditRatio where UserSysNo=" + oInfo.UserSysNo; SqlHelper.ExecuteDataSet(sql); SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.UserRatio); ratioHash.Remove(oInfo.UserSysNo); }
public static CurrencyManager GetInstance() { if (_instance == null) { _instance = new CurrencyManager(); _instance.Init(); SyncManager.GetInstance().RegisterLastVersion((int)AppEnum.Sync.Currency); } return(_instance); }
public static UserRatioManager GetInstance() { if (_instance == null) { _instance = new UserRatioManager(); _instance.Init(); _instance.InspectionInit(); SyncManager.GetInstance().RegisterLastVersion((int)AppEnum.Sync.UserRatio); } return(_instance); }
public void Update(CurrencyInfo oParam) { TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { new CurrencyDac().Update(oParam); SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.Currency); currencyHash.Remove(oParam.SysNo); currencyHash.Add(oParam.SysNo, oParam); scope.Complete(); } }
public int Update(StockInfo oParam) { string sql = " select top 1 sysno from Stock where StockID = " + Util.ToSqlString(oParam.StockID) + " and sysno <> " + oParam.SysNo; DataSet ds = SqlHelper.ExecuteDataSet(sql); if (Util.HasMoreRow(ds)) { throw new BizException("the same Stock ID exists already"); } int result = new StockDac().Update(oParam); SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.Stock); stockHash.Remove(oParam.SysNo); stockHash.Add(oParam.SysNo, oParam); return(result); }
public void Insert(CurrencyInfo oParam) { foreach (CurrencyInfo item in currencyHash.Values) { if (item.CurrencyID == oParam.CurrencyID) { throw new BizException("the same id exists"); } } TransactionOptions options = new TransactionOptions(); options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted; options.Timeout = TransactionManager.DefaultTimeout; using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options)) { string sql = "select isnull(max(sysno),0) as maxsysno from currency"; DataSet ds = SqlHelper.ExecuteDataSet(sql); int newSysNo = 0; if (!Util.HasMoreRow(ds)) { newSysNo = 0; } else { newSysNo = Util.TrimIntNull(ds.Tables[0].Rows[0]["maxsysno"]); } oParam.SysNo = newSysNo + 1; new CurrencyDac().Insert(oParam); SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.Currency); currencyHash.Add(oParam.SysNo, oParam); scope.Complete(); } }