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