/// <summary> /// 保存角色权限 /// </summary> /// <param name="roleId">角色编号</param> /// <param name="moduleIdList">模块编号列表</param> public void Save(string roleId, List <string> moduleIdList) { ComTransaction trans = null; try { db.Open(); trans = db.BeginTransaction(); this.Delete(roleId); foreach (string moduleId in moduleIdList) { this.Add(roleId, moduleId); } trans.Commit(); } catch (Exception e) { trans.Rollback(); throw e; } finally { db.Close(); } }
/// <summary> /// 保存角色权限【新增】 /// </summary> /// <param name="roleId">角色编号</param> /// <param name="moduleIdList">模块编号列表</param> public void Save(string roleId, List <string> moduleIdList) { ComTransaction trans = null; try { db.Open(); trans = db.BeginTransaction(); this.Delete(db, roleId); foreach (string moduleId in moduleIdList) { TSRight tsRight = new TSRight(); tsRight.roleId = roleId; tsRight.moduleId = moduleId; this.Add(db, tsRight); } 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 Recycle(List <TBTerminal> tbTBTerminalList, string userId, string userName) { ComTransaction trans = null; try { db.Open(); trans = db.BeginTransaction(); foreach (var terminal in tbTBTerminalList) { terminal.status = ((int)TerminalStatus.InStore).ToString(); RecycleEdit(db, terminal); TBTerminalLog tbTerminalLog = new TBTerminalLog(); tbTerminalLog.terminalId = terminal.terminalId; //终端号 tbTerminalLog.operateType = "1"; //操作类型 tbTerminalLog.summary = "回收[代理商编号:" + terminal.agentId + ",门店编号:" + terminal.siteId + "]"; tbTerminalLog.operateTime = DateTime.Now.ToString(); //操作时间 tbTerminalLog.operatorId = userId; //操作人编号 tbTerminalLog.operatorName = userName; //操作人名称 new TBTerminalLogDAO().Add(db, tbTerminalLog); } trans.Commit(); } catch (Exception e) { trans.Rollback(); throw e; } finally { db.Close(); } }
/// <summary> /// 修改代理商提现申请 /// <param name="ttAgentTakeCashApply">代理商提现申请</param> /// </summary> public void Edit(TTAgentTakeCashApply ttAgentTakeCashApply, TTAgentTakeCash ttAgentTakeCash, TBAgent tbAgent) { ComTransaction trans = null; try { db.Open(); trans = db.BeginTransaction(); //当只有申请通过才进行增加提现明细以及账户明细信息 if (ttAgentTakeCashApply.dealWithStatus == ((int)DealWithStatus.HaveToDo).ToString()) { //增加到提现申请明细以及账户明细并修改代理商的余额信息 new TTAgentTakeCashDAO().Add(db, ttAgentTakeCash, tbAgent); } Edit(db, ttAgentTakeCashApply);//修改提现申请状态已经信息 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 string Recycle(List <TBCard> tbCardList, string userId, string userName) { ComTransaction trans = null; string cardId = ""; db.Open(); foreach (var card in tbCardList) { try { trans = db.BeginTransaction(); card.status = ((int)CardStatus.StayUsed).ToString(); RecycleEdit(db, card); TBCardLog tbCardLog = new TBCardLog(); tbCardLog.cardId = card.cardId; //卡号 tbCardLog.operateType = "2"; //操作类型 tbCardLog.summary = "回收[代理商编号:" + card.agentId + ",门店编号:" + card.siteId + "]"; tbCardLog.operateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //操作时间 tbCardLog.operatorId = userId; //操作人编号 tbCardLog.operatorName = userName; //操作人名称 new TBCardLogDAO().Add(db, tbCardLog); trans.Commit(); } catch (Exception e) { trans.Rollback(); cardId = card.cardId; throw e; } } db.Close(); return(cardId); }
/// <summary> /// 增加代理商充值 /// <param name="ttAgentRecharge">代理商充值</param> /// </summary> public void Add(TTAgentRecharge ttAgentRecharge, TTAgentPreRechg ttAgentPreRechg) { ComTransaction trans = null; try { db.Open(); trans = db.BeginTransaction(); TBAgentDAO tbAgentDAO = new TBAgentDAO(); TBAgent tbAgent = new TBAgent(); tbAgent = tbAgentDAO.Get(db, ttAgentRecharge.agentId);//获取代理商信息 //修改代理商信息表的当前余额 tbAgent.sumRecharge = tbAgent.sumRecharge + ttAgentRecharge.fee; tbAgent.balanceValue = tbAgent.balanceValue + ttAgentRecharge.fee; new TBAgentDAO().EditBalance(db, tbAgent); ttAgentRecharge.agentName = tbAgent.agentName; //代理商名称 ttAgentRecharge.lastBalance = tbAgent.balanceValue - ttAgentRecharge.fee; //代理商上次余额 ttAgentRecharge.balance = tbAgent.balanceValue; //代理商当前余额 Add(db, ttAgentRecharge); //添加代理商充值账户明细 TTAgentAccDetail ttAgentAccDetail = new TTAgentAccDetail(); ttAgentAccDetail.agentId = ttAgentRecharge.agentId; ttAgentAccDetail.agentName = ttAgentRecharge.agentName; ttAgentAccDetail.lastBalance = ttAgentRecharge.lastBalance; ttAgentAccDetail.fee = ttAgentRecharge.fee; ttAgentAccDetail.balance = ttAgentRecharge.balance; ttAgentAccDetail.createTime = ttAgentRecharge.createTime; ttAgentAccDetail.remark = ttAgentRecharge.description; new TTAgentAccDetailDAO().Add(db, ttAgentAccDetail); new TTAgentPreRechgDAO().Edit(db, ttAgentPreRechg);//修改状态 trans.Commit(); } catch (Exception e) { trans.Rollback(); throw e; } finally { db.Close(); } }
/// <summary> /// 激活 /// </summary> /// <param name="uKeyId"></param> public void Activation(string uKeyId, string rowSiteId, string userId, string userName) { ComTransaction trans = null; try { Param param = null; List <TBUKey> ukeyList = GetList("select * from TBUKey where siteId=" + rowSiteId + " and status='" + (int)UKeyStatus.Activation + "' and ukeyId!='" + uKeyId + "'", param); TBUKey tbUKeyAc = Get(uKeyId); db.Open(); trans = db.BeginTransaction(); //讲已经激活的修改为已领并记录日志 foreach (var tbUKey in ukeyList) { tbUKey.status = ((int)UKeyStatus.Draw).ToString(); Edit(db, tbUKey); TBUKeyLog tbUKeyLog = new TBUKeyLog(); tbUKeyLog.uKeyId = tbUKey.uKeyId; //终端号 tbUKeyLog.operateType = "1"; //操作类型 tbUKeyLog.summary = "发放到[代理商编号:" + tbUKey.agentId + ",门店编号:" + tbUKey.siteId + "]"; tbUKeyLog.operateTime = DateTime.Now.ToString(); //操作时间 tbUKeyLog.operatorId = userId; //操作人编号 tbUKeyLog.operatorName = userName; //操作人名称 new TBUKeyLogDAO().Add(db, tbUKeyLog); } //激活 tbUKeyAc.status = ((int)UKeyStatus.Activation).ToString(); Edit(db, tbUKeyAc); TBUKeyLog tbUKeyLogA = new TBUKeyLog(); tbUKeyLogA.uKeyId = tbUKeyAc.uKeyId; //终端号 tbUKeyLogA.operateType = "1"; //操作类型 tbUKeyLogA.summary = "发放到[代理商编号:" + tbUKeyAc.agentId + ",门店编号:" + tbUKeyAc.siteId + "]"; tbUKeyLogA.operateTime = DateTime.Now.ToString(); //操作时间 tbUKeyLogA.operatorId = userId; //操作人编号 tbUKeyLogA.operatorName = userName; //操作人名称 new TBUKeyLogDAO().Add(db, tbUKeyLogA); trans.Commit(); } catch (Exception e) { trans.Rollback(); throw e; } finally { db.Close(); } }
public void AddList(List <TTAgentSettlement> agentSettlementList, string startDate, string endDate, string userId, string userName) { ComTransaction trans = null; try { db.Open(); trans = db.BeginTransaction(); foreach (var agentSettlement in agentSettlementList) { TTAgentSettlement ttAgentSettlement = new TTAgentSettlement(); ttAgentSettlement.agentId = agentSettlement.agentId; ttAgentSettlement.agentName = agentSettlement.agentName; ttAgentSettlement.startDate = agentSettlement.startDate; ttAgentSettlement.endDate = agentSettlement.endDate; ttAgentSettlement.saleFee = agentSettlement.saleFee; ttAgentSettlement.rebate = agentSettlement.rebate; ttAgentSettlement.commissionFee = agentSettlement.commissionFee; ttAgentSettlement.settlementId = userId; ttAgentSettlement.settlementName = userName; this.Add(db, ttAgentSettlement); } //根据时间更改订单的状态 string strSQL = @"update TTLotteryOrder set settleStatus='1',settleTime=sysdate" + " where bettime>='" + startDate + " 00:00:00' " + " and bettime<='" + endDate + " 23:59:59' " + " and orderstatus='" + (int)OrderStatus.Ticket + "' " + " and settleStatus='0'"; Param param = new Param(); db.ExecuteNonQuery(CommandType.Text, strSQL, param); trans.Commit(); } catch (Exception e) { trans.Rollback(); throw e; } finally { db.Close(); } }
/// <summary> /// 事务修改快开厅员工 /// <param name="tbStaff">快开厅员工</param> /// </summary> public void EditTrans(TBStaff tbStaff, TSAgentUser tsAgentUser) { ComTransaction trans = null; try { db.Open(); trans = db.BeginTransaction(); new TSAgentUserDAO().Edit(db, tsAgentUser, "1");//1为门店员工 Edit(db, tbStaff); trans.Commit(); } catch (Exception e) { trans.Rollback(); throw e; } finally { db.Close(); } }
/// <summary> /// 删除代理商信息 /// <param name="agentId">代理商编号</param> /// </summary> public void Delete(string agentId) { ComTransaction trans = null; try { db.Open(); trans = db.BeginTransaction(); new TSAgentUserDAO().Delete(db, agentId, "001"); Delete(db, agentId); trans.Commit(); } catch (Exception e) { trans.Rollback(); throw e; } finally { db.Close(); } }
/// <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="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(); } }