/// <summary> /// 增加代理商信息 /// <param name="tbAgent">代理商信息</param> /// </summary> public void Add(TBAgent tbAgent, TSAgentUser tsAgentUser) { TSAgentUserDAO tsAgentUserDAO = new TSAgentUserDAO(); //判断是否名称重复 if (tbAgentDAO.Exist("agentName", tbAgent.agentName)) { Message.error(context, "名称重复请重新输入!"); return; } //判断是否帐号重复 if (tsAgentUserDAO.Exist("userCode", tsAgentUser.userCode)) { Message.error(context, "用户帐号重复请重新输入!"); return; } try { tbAgent.agentId = commonDao.GetMaxNo("TBAgent", "", 6); tbAgent.status = tbAgent.status == null ? "0" : "1"; tbAgentDAO.AddTrans(tbAgent, tsAgentUser); Message.success(context, "代理商信息增加成功,默认密码为帐号,登录后建议修改"); loginSession.Log(tbAgent.agentName + "代理商信息增加成功"); } catch (Exception e) { Message.error(context, "代理商信息增加失败"); loginSession.Log(e.Message); } }
/// <summary> /// 增加代理商信息 /// <param name="data">数据库连接</param> /// <param name="tbAgent">代理商信息</param> /// </summary> public void Add(DataAccess data, TBAgent tbAgent) { //添加系统用户信息记录 string strSQL = "insert into TBAgent"; strSQL += "(agentId, agentName,rebate,warnValue, contact, telephone, areaId, address,IDNumber,bankCardId,bankName,status,fixedLine,remark) values "; strSQL += "(:agentId,:agentName,:rebate,:warnValue, :contact, :telephone, :areaId, :address,:IDNumber,:bankCardId,:bankName,:status,:fixedLine,:remark)"; Param param = new Param(); param.Clear(); param.Add(":agentId", tbAgent.agentId); param.Add(":agentName", tbAgent.agentName); param.Add(":rebate", tbAgent.rebate); param.Add(":warnValue", tbAgent.warnValue); param.Add(":contact", tbAgent.contact); param.Add(":telephone", tbAgent.telephone); param.Add(":areaId", tbAgent.areaId); param.Add(":address", tbAgent.address); param.Add(":IDNumber", tbAgent.IDNumber); param.Add(":bankCardId", tbAgent.bankCardId); param.Add(":bankName", tbAgent.bankName); param.Add(":warnValue", tbAgent.warnValue); param.Add(":status", "0"); param.Add(":fixedLine", tbAgent.fixedLine); param.Add(":remark", tbAgent.remark); data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 修改代理商信息 /// <param name="data">数据库连接</param> /// <param name="tbAgent">代理商信息</param> /// </summary> public override void Edit(DataAccess data, TBAgent tbAgent) { string strSQL = "update TBAgent set agentName=@agentName,rebate=@rebate, contact=@contact, telephone=@telephone, areaId=@areaId, address=@address,IDNumber=@IDNumber, "; strSQL += " bankCardId=@bankCardId,bankName=@bankName,warnValue=@warnValue,status=@status,auditStatus=@auditStatus,fixedLine=@fixedLine,remark=@remark where agentId =@agentId"; Param param = new Param(); param.Clear(); param.Add("@agentId", tbAgent.agentId); param.Add("@agentName", tbAgent.agentName); param.Add("@rebate", tbAgent.rebate); param.Add("@contact", tbAgent.contact); param.Add("@telephone", tbAgent.telephone); param.Add("@areaId", tbAgent.areaId); param.Add("@address", tbAgent.address); param.Add("@IDNumber", tbAgent.IDNumber); param.Add("@bankCardId", tbAgent.bankCardId); param.Add("@bankName", tbAgent.bankName); param.Add("@warnValue", tbAgent.warnValue); param.Add("@status", tbAgent.status); param.Add("@auditStatus", tbAgent.auditStatus); param.Add("@fixedLine", tbAgent.fixedLine); param.Add("@remark", tbAgent.remark); data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 读取代理商信息信息 /// </summary> /// <param name="dr">记录指针</param> /// <returns>代理商信息对象</returns> protected virtual TBAgent ReadData(ComDataReader dr) { TBAgent tbAgent = new TBAgent(); tbAgent.agentId = dr["agentId"].ToString(); //代理商编号 tbAgent.agentName = dr["agentName"].ToString(); //代理商名称 tbAgent.rebate = double.Parse(dr["rebate"].ToString()); //返点比例 tbAgent.contact = dr["contact"].ToString(); //联系人 tbAgent.telephone = dr["telephone"].ToString(); //手机号码 tbAgent.areaId = dr["areaId"].ToString(); //区域编号 tbAgent.address = dr["address"].ToString(); //详细地址 tbAgent.IDNumber = dr["IDNumber"].ToString(); //身份证号 tbAgent.bankName = dr["bankName"].ToString(); //开户银行 tbAgent.bankCardId = dr["bankCardId"].ToString(); //银行卡号 tbAgent.auditStatus = dr["auditStatus"].ToString(); //审批状态 tbAgent.clientSumDraw = double.Parse(dr["clientSumDraw"].ToString()); //客户提现总额 tbAgent.clientSumRecharge = double.Parse(dr["clientSumRecharge"].ToString()); //客户充值总额 tbAgent.sumDraw = double.Parse(dr["sumDraw"].ToString()); //提现总额 tbAgent.sumRecharge = double.Parse(dr["sumRecharge"].ToString()); //充值总额 tbAgent.warnValue = double.Parse(dr["warnValue"].ToString()); //预警金额 tbAgent.balanceValue = double.Parse(dr["balanceValue"].ToString()); //账户余额 tbAgent.status = dr["status"].ToString(); //使用状态 tbAgent.fixedLine = dr["fixedLine"].ToString(); //固定电话 tbAgent.remark = dr["remark"].ToString(); //备注说明 return(tbAgent); }
/// <summary> /// 修改代理商信息 /// <param name="data">数据库连接</param> /// <param name="tbAgent">代理商信息</param> /// </summary> public void Edit(DataAccess data, TBAgent tbAgent) { string strSQL = "update TBAgent set agentName=:agentName,rebate=:rebate, contact=:contact, telephone=:telephone, areaId=:areaId, address=:address,IDNumber=:IDNumber, "; strSQL += " bankCardId=:bankCardId,bankName=:bankName,warnValue=:warnValue,status=:status,auditStatus=:auditStatus,fixedLine=:fixedLine,remark=:remark where agentId =:agentId"; Param param = new Param(); param.Clear(); param.Add(":agentId", tbAgent.agentId); param.Add(":agentName", tbAgent.agentName); param.Add(":rebate", tbAgent.rebate); param.Add(":contact", tbAgent.contact); param.Add(":telephone", tbAgent.telephone); param.Add(":areaId", tbAgent.areaId); param.Add(":address", tbAgent.address); param.Add(":IDNumber", tbAgent.IDNumber); param.Add(":bankCardId", tbAgent.bankCardId); param.Add(":bankName", tbAgent.bankName); param.Add(":warnValue", tbAgent.warnValue); param.Add(":status", tbAgent.status); param.Add(":auditStatus", tbAgent.auditStatus); param.Add(":fixedLine", tbAgent.fixedLine); param.Add(":remark", tbAgent.remark); data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 获取代理商信息 /// </summary> /// <param name="agentId">代理商编号</param> /// <returns>代理商信息对象</returns> public virtual TBAgent Get(string agentId) { TBAgent tbAgent = null; try { string strSQL = "select * from TBAgent where agentId=@agentId"; Param param = new Param(); param.Clear(); param.Add("@agentId", agentId); db.Open(); ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param); if (dr.Read()) { tbAgent = ReadData(dr); } dr.Close(); } catch (Exception e) { throw e; } finally { db.Close(); } return(tbAgent); }
/// <summary> /// 修改代理商信息 /// </summary> /// <param name="data">数据库连接</param> /// <param name="tbAgent">代理商信息</param> public virtual void Edit(DataAccess data, TBAgent tbAgent) { string strSQL = "update TBAgent set agentName=@agentName,rebate=@rebate,contact=@contact,telephone=@telephone,areaId=@areaId,address=@address,IDNumber=@IDNumber,bankName=@bankName,bankCardId=@bankCardId,auditStatus=@auditStatus,clientSumDraw=@clientSumDraw,clientSumRecharge=@clientSumRecharge,sumDraw=@sumDraw,sumRecharge=@sumRecharge,warnValue=@warnValue,balanceValue=@balanceValue,status=@status,fixedLine=@fixedLine,remark=@remark where agentId=@agentId"; Param param = new Param(); param.Clear(); param.Add("@agentName", tbAgent.agentName); //代理商名称 param.Add("@rebate", tbAgent.rebate); //返点比例 param.Add("@contact", tbAgent.contact); //联系人 param.Add("@telephone", tbAgent.telephone); //手机号码 param.Add("@areaId", tbAgent.areaId); //区域编号 param.Add("@address", tbAgent.address); //详细地址 param.Add("@IDNumber", tbAgent.IDNumber); //身份证号 param.Add("@bankName", tbAgent.bankName); //开户银行 param.Add("@bankCardId", tbAgent.bankCardId); //银行卡号 param.Add("@auditStatus", tbAgent.auditStatus); //审批状态 param.Add("@clientSumDraw", tbAgent.clientSumDraw); //客户提现总额 param.Add("@clientSumRecharge", tbAgent.clientSumRecharge); //客户充值总额 param.Add("@sumDraw", tbAgent.sumDraw); //提现总额 param.Add("@sumRecharge", tbAgent.sumRecharge); //充值总额 param.Add("@warnValue", tbAgent.warnValue); //预警金额 param.Add("@balanceValue", tbAgent.balanceValue); //账户余额 param.Add("@status", tbAgent.status); //使用状态 param.Add("@fixedLine", tbAgent.fixedLine); //固定电话 param.Add("@remark", tbAgent.remark); //备注说明 param.Add("@agentId", tbAgent.agentId); //代理商编号 data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 增加代理商充值 /// <param name="ttAgentRecharge">代理商充值</param> /// </summary> public void Add(DataAccess db, TTAgentTakeCash ttAgentTakeCash, TBAgent tbAgent) { try { //修改代理商信息表的当前余额 tbAgent.sumDraw = tbAgent.sumDraw + ttAgentTakeCash.fee; tbAgent.balanceValue = tbAgent.balanceValue - ttAgentTakeCash.fee; new TBAgentDAO().EditBalance(db, tbAgent); ttAgentTakeCash.agentName = tbAgent.agentName; //代理商名称 ttAgentTakeCash.lastBalance = tbAgent.balanceValue + ttAgentTakeCash.fee; //代理商上次余额 ttAgentTakeCash.balance = tbAgent.balanceValue; //代理商当前余额 Add(db, ttAgentTakeCash); //添加代理商提现账户明细 TTAgentAccDetailDAO ttAgentAccDetailDAO = new TTAgentAccDetailDAO(); TTAgentAccDetail ttAgentAccDetail = new TTAgentAccDetail(); ttAgentAccDetail.agentId = ttAgentTakeCash.agentId; ttAgentAccDetail.agentName = ttAgentTakeCash.agentName; ttAgentAccDetail.lastBalance = ttAgentTakeCash.lastBalance; ttAgentAccDetail.fee = 0 - ttAgentTakeCash.fee; ttAgentAccDetail.balance = ttAgentTakeCash.balance; ttAgentAccDetail.createTime = ttAgentTakeCash.createTime; ttAgentAccDetail.remark = ttAgentTakeCash.description; new TTAgentAccDetailDAO().Add(db, ttAgentAccDetail); } catch (Exception e) { throw e; } }
public void ProcessRequest(HttpContext context) { try { LoginUser loginUser = new LoginUser(context, "AgentAudit"); if (!loginUser.Pass)//权限验证 { return; } AgentBLL bll = new AgentBLL(context, loginUser); if (context.Request["action"] == "gridLoad") { //加载DataGrid int page = int.Parse(context.Request["page"]); int rows = int.Parse(context.Request["rows"]); string agentId = context.Request["agentId"]; string agentName = context.Request["agentName"]; bll.LoadGrid(page, rows, agentName, agentId, "", ((int)AuditStauts.NotAudit).ToString()); } else if (context.Request["action"] == "areaListLoad") { //加载区域列表 Combobox com = new Combobox(context, loginUser); com.AreaCombobox(); } else if (context.Request["action"] == "auditListLoad") { //加载审核状态列表 Combobox com = new Combobox(context, loginUser); com.AuditCombobox(); } else if (context.Request["action"] == "load") { //加载信息 bll.Load(context.Request["agentId"]); } else if (context.Request["action"] == "audit") { //审核 TBAgent agent = new TBAgent(); agent.agentId = context.Request["agentId"]; agent.auditStatus = context.Request["auditStatus"]; agent.status = "0"; if (agent.auditStatus == ((int)AuditStauts.AuditSucces).ToString()) { agent.status = "1"; } agent.remark = context.Request["remark"]; bll.Audit(agent); } } catch (Exception e) { Message.error(context, e.Message); } }
/// <summary> /// 修改余额以及充值总额 /// </summary> /// <param name="tbAgent"></param> public void EditBalance(DataAccess data, TBAgent tbAgent) { string strSQL = "update TBAgent set balanceValue=:balanceValue,sumRecharge=:sumRecharge,sumDraw=:sumDraw where agentId =:agentId"; Param param = new Param(); param.Clear(); param.Add(":agentId", tbAgent.agentId); param.Add(":balanceValue", tbAgent.balanceValue); param.Add(":sumRecharge", tbAgent.sumRecharge); param.Add(":sumDraw", tbAgent.sumDraw); data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 修改 /// </summary> /// <param name="user">用户对象</param> public void Audit(TBAgent tbAgent) { try { tbAgentDAO.Audit(tbAgent); Message.success(context, "审核操作成功"); loginSession.Log(tbAgent.agentName + "[" + tbAgent.agentId + "]代理商审核操作成功"); } catch (Exception e) { Message.error(context, "代理商审核失败"); loginSession.Log(e.Message); } }
/// <summary> /// 获取指定代理商信息 /// <param name="agentId">代理商编号</param> /// </summary> public TBAgent Get(string agentId) { TBAgent tbAgent = new TBAgent(); try { tbAgent = tbAgentDAO.Get(agentId); } catch (Exception e) { Message.error(context, e.Message); } return(tbAgent); }
/// <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="tbAgent">代理商信息</param> public virtual void Add(TBAgent tbAgent) { try { db.Open(); Add(db, tbAgent); } catch (Exception e) { throw e; } finally { db.Close(); } }
/// <summary> /// 修改代理商信息 /// <param name="tbAgent">代理商信息</param> /// </summary> public void Edit(TBAgent tbAgent) { try { db.Open(); Edit(db, tbAgent); } catch (Exception e) { throw e; } finally { db.Close(); } }
/// <summary> /// 增加代理商充值 /// <param name="ttAgentRecharge">代理商充值</param> /// </summary> public void Add(DataAccess db, TTAgentTakeCash ttAgentTakeCash, TBAgent tbAgent) { //ComTransaction trans = null; try { //db.Open(); //trans = db.BeginTransaction(); ttAgentTakeCash.agentName = tbAgent.agentName; //代理商名称 ttAgentTakeCash.lastBalance = tbAgent.balanceValue; //代理商上次余额 ttAgentTakeCash.balance = ttAgentTakeCash.lastBalance - ttAgentTakeCash.fee; //代理商当前余额 Add(db, ttAgentTakeCash); //添加代理商提现账户明细 TTAgentAccDetailDAO ttAgentAccDetailDAO = new TTAgentAccDetailDAO(); TTAgentAccDetail ttAgentAccDetail = new TTAgentAccDetail(); ttAgentAccDetail.agentId = ttAgentTakeCash.agentId; ttAgentAccDetail.agentName = ttAgentTakeCash.agentName; ttAgentAccDetail.lastBalance = ttAgentTakeCash.lastBalance; ttAgentAccDetail.fee = 0 - ttAgentTakeCash.fee; ttAgentAccDetail.balance = ttAgentTakeCash.balance; ttAgentAccDetail.createTime = ttAgentTakeCash.createTime; ttAgentAccDetail.remark = ttAgentTakeCash.description; new TTAgentAccDetailDAO().Add(db, ttAgentAccDetail); //修改代理商信息表的当前余额 tbAgent.sumDraw = tbAgent.sumDraw + ttAgentTakeCash.fee; tbAgent.balanceValue = ttAgentTakeCash.balance; new TBAgentDAO().EditBalance(db, tbAgent); //trans.Commit(); } catch (Exception e) { //trans.Rollback(); throw e; } //finally //{ // db.Close(); //} }
private DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接 #region 新增代码 /// <summary> /// 事务增加代理商信息并添加代理商用户 /// <param name="tbAgent">代理商信息</param> /// <param name="tbAgent">代理商用户信息</param> /// </summary> public void AddTrans(TBAgent tbAgent, TSAgentUser tsAgentUser) { ComTransaction trans = null; try { db.Open(); trans = db.BeginTransaction(); Add(db, tbAgent); tsAgentUser.userId = tbAgent.agentId; 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="tbAgent"></param> public void Audit(TBAgent tbAgent) { string strSQL = "update TBAgent set auditStatus=:auditStatus,remark=:remark,status=:status where agentId =:agentId"; Param param = new Param(); param.Clear(); param.Add(":agentId", tbAgent.agentId); param.Add(":auditStatus", tbAgent.auditStatus); param.Add(":status", tbAgent.status); param.Add(":remark", tbAgent.remark); try { db.Open(); db.ExecuteNonQuery(CommandType.Text, strSQL, param); } catch (Exception e) { throw e; } finally { db.Close(); } }
/// <summary> /// 修改代理商提现申请 /// <param name="ttAgentTakeCashApply">代理商提现申请</param> /// </summary> public void Edit(TTAgentTakeCashApply ttAgentTakeCashApply, TTAgentTakeCash ttAgentTakeCash) { try { TBAgentDAO tbAgentDAO = new TBAgentDAO(); TBAgent tbAgent = new TBAgent(); tbAgent = tbAgentDAO.Get(ttAgentTakeCash.agentId);//获取代理商信息 if (tbAgent.balanceValue < ttAgentTakeCash.fee && ttAgentTakeCashApply.dealWithStatus == ((int)DealWithStatus.HaveToDo).ToString()) { Message.error(context, "代理商余额不足" + ttAgentTakeCash.fee); } else { ttAgentTakeCashApplyDAO.Edit(ttAgentTakeCashApply, ttAgentTakeCash, tbAgent); Message.success(context, "提现申请修改成功"); loginSession.Log("提现申请修改成功"); } } catch (Exception e) { Message.error(context, "代理商提现申请修改失败"); loginSession.Log(e.Message); } }
/// <summary> /// 修改代理商信息 /// <param name="tbAgent">代理商信息</param> /// </summary> public void Edit(TBAgent tbAgent) { //判断是否帐号重复 List <TBAgent> list = tbAgentDAO.GetList("agentName", tbAgent.agentName); if (list.Count > 0 && !tbAgent.agentId.Equals(list[0].agentId)) { Message.error(context, "名称重复请重新输入!"); return; } try { tbAgent.status = (tbAgent.status == null || tbAgent.status == "off") ? "0" : "1"; tbAgentDAO.Edit(tbAgent); Message.success(context, "代理商信息修改成功"); loginSession.Log(tbAgent.agentName + "[" + tbAgent.agentId + "]代理商信息修改成功"); } catch (Exception e) { Message.error(context, "代理商信息修改失败"); loginSession.Log(e.Message); } }
public void ProcessRequest(HttpContext context) { try { LoginUser loginUser = new LoginUser(context, "AgentAdd"); if (!loginUser.Pass)//权限验证 { return; } AgentBLL bll = new AgentBLL(context, loginUser); if (context.Request["action"] == "gridLoad") { //加载DataGrid int page = int.Parse(context.Request["page"]); int rows = int.Parse(context.Request["rows"]); string agentName = context.Request["agentName"]; string agentId = context.Request["agentId"]; string auditStatus = context.Request["auditStatus"]; bll.LoadGrid(page, rows, agentName, agentId, "", auditStatus); } else if (context.Request["action"] == "areaListLoad") { //加载区域列表 Combobox com = new Combobox(context, loginUser); com.AreaCombobox(); } else if (context.Request["action"] == "auditListLoad") { //加载审核状态列表 Combobox com = new Combobox(context, loginUser); com.AuditCombobox(); } else if (context.Request["action"] == "load") { //加载信息 bll.Load(context.Request["agentId"]); } else if (context.Request["action"] == "add") { //增加 TBAgent agent = new TBAgent(); TSAgentUser tsAgentUser = new TSAgentUser(); agent.agentId = context.Request["agentId"]; agent.agentName = context.Request["agentName"]; agent.rebate = double.Parse(context.Request["rebate"]); agent.warnValue = double.Parse(context.Request["warnValue"]); agent.contact = context.Request["contact"]; agent.telephone = context.Request["telephone"]; agent.areaId = context.Request["areaId"]; agent.address = context.Request["address"]; agent.IDNumber = context.Request["IDNumber"]; agent.bankCardId = context.Request["bankCardId"]; agent.bankName = context.Request["bankName"]; agent.status = "0"; agent.fixedLine = context.Request["fixedLine"]; agent.remark = context.Request["remark"]; tsAgentUser.roleId = "001"; tsAgentUser.userCode = context.Request["agentUserCode"]; tsAgentUser.userPwd = tsAgentUser.userCode; bll.Add(agent, tsAgentUser); } else if (context.Request["action"] == "edit") { //修改 TBAgent agent = new TBAgent(); agent.agentId = context.Request["agentId"]; agent.agentName = context.Request["agentName"]; agent.rebate = double.Parse(context.Request["rebate"]); agent.contact = context.Request["contact"]; agent.telephone = context.Request["telephone"]; agent.areaId = context.Request["areaId"]; agent.address = context.Request["address"]; agent.IDNumber = context.Request["IDNumber"]; agent.bankCardId = context.Request["bankCardId"]; agent.bankName = context.Request["bankName"]; agent.status = context.Request["status"]; agent.warnValue = double.Parse(context.Request["warnValue"]); agent.auditStatus = "0"; agent.fixedLine = context.Request["fixedLine"]; agent.remark = context.Request["remark"]; bll.Edit(agent); } else if (context.Request["action"] == "delete") { //删除 string agentId = context.Request["agentId"]; bll.Delete(agentId); } } catch (Exception e) { Message.error(context, e.Message); } }
public void ProcessRequest(HttpContext context) { try { LoginUser loginUser = new LoginUser(context, "AgentOam"); if (!loginUser.Pass)//权限验证 { return; } AgentBLL bll = new AgentBLL(context, loginUser); if (context.Request["action"] == "gridLoad") { //加载DataGrid int page = int.Parse(context.Request["page"]); int rows = int.Parse(context.Request["rows"]); string agentId = context.Request["agentId"]; string agentName = context.Request["agentName"]; bll.LoadGrid(page, rows, agentName, agentId, "", ((int)AuditStauts.AuditSucces).ToString()); } else if (context.Request["action"] == "areaListLoad") { //加载区域列表 bll.AreaCombobox(); } else if (context.Request["action"] == "auditListLoad") { //加载审核状态列表 bll.AuditCombobox(); } else if (context.Request["action"] == "load") { //加载信息 bll.Load(context.Request["agentId"]); } else if (context.Request["action"] == "edit") { //修改 TBAgent agent = new TBAgent(); agent.agentId = context.Request["agentId"]; agent.agentName = context.Request["agentName"]; agent.rebate = double.Parse(context.Request["rebate"]); agent.contact = context.Request["contact"]; agent.telephone = context.Request["telephone"]; agent.areaId = context.Request["areaId"]; agent.address = context.Request["address"]; agent.IDNumber = context.Request["IDNumber"]; agent.bankCardId = context.Request["bankCardId"]; agent.bankName = context.Request["bankName"]; agent.status = context.Request["status"]; agent.auditStatus = ((int)AuditStauts.AuditSucces).ToString(); agent.fixedLine = context.Request["fixedLine"]; agent.remark = context.Request["remark"]; bll.Edit(agent); } } catch (Exception e) { Message.error(context, e.Message); } }
/// <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(); } }