/// <summary> /// 事务处理终端发放 /// </summary> /// <param name="tbTBUKeyList"></param> /// <param name="userId"></param> /// <param name="userName"></param> public void Grant(List <TBUKey> tbTBUKeyList, string userId, string userName, string siteId) { ComTransaction trans = null; try { db.Open(); trans = db.BeginTransaction(); string agentId = new TBSiteDAO().Get(siteId).agentId; foreach (var uKey in tbTBUKeyList) { uKey.status = ((int)UKeyStatus.Draw).ToString(); uKey.agentId = agentId; uKey.siteId = siteId; Edit(db, uKey); TBUKeyLog tbUKeyLog = new TBUKeyLog(); tbUKeyLog.uKeyId = uKey.uKeyId; //终端号 tbUKeyLog.operateType = "1"; //操作类型 tbUKeyLog.summary = "发放到[代理商编号:" + agentId + ",门店编号:" + siteId + "]"; tbUKeyLog.operateTime = DateTime.Now.ToString(); //操作时间 tbUKeyLog.operatorId = userId; //操作人编号 tbUKeyLog.operatorName = userName; //操作人名称 new TBUKeyLogDAO().Add(db, tbUKeyLog); } trans.Commit(); } catch (Exception e) { trans.Rollback(); throw e; } finally { db.Close(); } }
private DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接 /// <summary> /// 事务增加快开厅员工 /// <param name="tbStaff">快开厅员工</param> /// </summary> public void AddTrans(TBStaff tbStaff, TSAgentUser tsAgentUser) { ComTransaction trans = null; try { db.Open(); trans = db.BeginTransaction(); Add(db, tbStaff); tsAgentUser.userId = tbStaff.staffId; tsAgentUser.userPwd = Encrypt.ConvertPwd(tsAgentUser.userId, tsAgentUser.userPwd); new TSAgentUserDAO().Add(db, tsAgentUser); trans.Commit(); } catch (Exception e) { trans.Rollback(); throw e; } finally { db.Close(); } }
/// <summary> /// 事务处理终端发放 /// </summary> /// <param name="tbTBTerminalList"></param> /// <param name="userId"></param> /// <param name="userName"></param> public void Grant(List <TBTerminal> tbTBTerminalList, string userId, string userName, string siteId) { ComTransaction trans = null; try { db.Open(); trans = db.BeginTransaction(); string agentId = new TBSiteDAO().Get(siteId).agentId; foreach (var terminal in tbTBTerminalList) { terminal.status = ((int)TerminalStatus.Used).ToString(); terminal.agentId = agentId; terminal.siteId = siteId; TBTerminalLog tbTerminalLog = new TBTerminalLog(); tbTerminalLog.terminalId = terminal.terminalId; //终端号 tbTerminalLog.operateType = "1"; //操作类型 tbTerminalLog.summary = "发放到[代理商编号:" + agentId + ",门店编号:" + siteId + "]"; tbTerminalLog.operateTime = DateTime.Now.ToString(); //操作时间 tbTerminalLog.operatorId = userId; //操作人编号 tbTerminalLog.operatorName = userName; //操作人名称 Edit(db, terminal); new TBTerminalLogDAO().Add(db, tbTerminalLog); } trans.Commit(); } catch (Exception e) { trans.Rollback(); throw e; } finally { db.Close(); } }
/// <summary> /// 事务处理卡片发放 /// </summary> /// <param name="tbCardList"></param> /// <param name="userId"></param> /// <param name="userName"></param> public void Grant(List <TBCard> tbCardList, string userId, string userName, string siteId) { ComTransaction trans = null; try { db.Open(); trans = db.BeginTransaction(); string agentId = new TBSiteDAO().Get(siteId).agentId; foreach (var card in tbCardList) { card.status = ((int)CardStatus.StayBinding).ToString(); card.agentId = agentId; card.siteId = siteId; TBCardLog tbCardLog = new TBCardLog(); tbCardLog.cardId = card.cardId; //卡号 tbCardLog.operateType = "2"; //操作类型 tbCardLog.summary = "发放到[代理商编号:" + agentId + ",门店编号:" + siteId + "]"; tbCardLog.operateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //操作时间 tbCardLog.operatorId = userId; //操作人编号 tbCardLog.operatorName = userName; //操作人名称 Edit(db, card); new TBCardLogDAO().Add(db, tbCardLog); } trans.Commit(); } catch (Exception e) { trans.Rollback(); throw e; } finally { db.Close(); } }