/// <summary> /// 获取代理商充值预审 /// </summary> /// <param name="flowId">流水号</param> /// <returns>代理商充值预审对象</returns> public virtual TTAgentPreRechg Get(long flowId) { TTAgentPreRechg ttAgentPreRechg = null; try { string strSQL = "select * from TTAgentPreRechg where flowId=@flowId"; Param param = new Param(); param.Clear(); param.Add("@flowId", flowId); db.Open(); ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param); if (dr.Read()) { ttAgentPreRechg = ReadData(dr); } dr.Close(); } catch (Exception e) { throw e; } finally { db.Close(); } return(ttAgentPreRechg); }
/// <summary> /// 读取代理商充值预审信息 /// </summary> /// <param name="dr">记录指针</param> /// <returns>代理商充值预审对象</returns> protected virtual TTAgentPreRechg ReadData(ComDataReader dr) { TTAgentPreRechg ttAgentPreRechg = new TTAgentPreRechg(); ttAgentPreRechg.flowId = long.Parse(dr["flowId"].ToString()); //流水号 ttAgentPreRechg.agentId = dr["agentId"].ToString(); //代理商编号 ttAgentPreRechg.agentName = dr["agentName"].ToString(); //代理商名称 ttAgentPreRechg.fee = double.Parse(dr["fee"].ToString()); //发生金额 ttAgentPreRechg.operatorId = dr["operatorId"].ToString(); //操作人编号 ttAgentPreRechg.operatorName = dr["operatorName"].ToString(); //操作人名称 if (dr["createTime"] == null) { ttAgentPreRechg.createTime = "";//创建时间 } else { ttAgentPreRechg.createTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["createTime"]); //创建时间 } ttAgentPreRechg.handleMode = dr["handleMode"].ToString(); //充值方式 ttAgentPreRechg.bankAccountId = dr["bankAccountId"].ToString(); //银行账号 ttAgentPreRechg.bankFlowId = dr["bankFlowId"].ToString(); //银行流水号 ttAgentPreRechg.description = dr["description"].ToString(); //说明 ttAgentPreRechg.auditStatus = dr["auditStatus"].ToString(); //审核状态 return(ttAgentPreRechg); }
/// <summary> /// 修改代理商充值预审 /// </summary> /// <param name="data">数据库连接</param> /// <param name="ttAgentPreRechg">代理商充值预审</param> public override void Edit(DataAccess data, TTAgentPreRechg ttAgentPreRechg) { string strSQL = "update TTAgentPreRechg set auditStatus=@auditStatus where flowId=@flowId"; Param param = new Param(); param.Clear(); param.Add("@auditStatus", ttAgentPreRechg.auditStatus); //审核状态 param.Add("@flowId", ttAgentPreRechg.flowId); //流水号 data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 加载指定代理商充值预审 /// </summary> /// <param name="flowId">流水号</param> public void Load(long flowId) { try { TTAgentPreRechg ttAgentPreRechg = ttAgentPreRechgDAO.Get(flowId); WebJson.ToJson(context, ttAgentPreRechg); } catch (Exception e) { Message.error(context, e.Message); } }
/// <summary> /// 获取指定代理商充值预审信息 /// <param name="flowId">流水号</param> /// </summary> public TTAgentPreRechg Get(long flowId) { TTAgentPreRechg tbAgentPreRechg = new TTAgentPreRechg(); try { tbAgentPreRechg = ttAgentPreRechgDAO.Get(flowId); } catch (Exception e) { Message.error(context, e.Message); } return(tbAgentPreRechg); }
/// <summary> /// 修改代理商充值预审 /// </summary> /// <param name="ttAgentPreRechg">代理商充值预审</param> public void Edit(TTAgentPreRechg ttAgentPreRechg) { try { ttAgentPreRechgDAO.Edit(ttAgentPreRechg); Message.success(context, "审批成功"); loginUser.Log(ttAgentPreRechg.agentName + "代理商充值预审成功"); } catch (Exception e) { Message.error(context, "代理商充值预审修改失败"); loginUser.Log(e.Message); } }
/// <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="ttAgentPreRechg">代理商充值预审</param> public virtual void Edit(TTAgentPreRechg ttAgentPreRechg) { try { db.Open(); Edit(db, ttAgentPreRechg); } catch (Exception e) { throw e; } finally { db.Close(); } }
/// <summary> /// 增加代理商充值预审 /// </summary> /// <param name="data">数据库连接</param> /// <param name="ttAgentPreRechg">代理商充值预审</param> public override void Add(DataAccess data, TTAgentPreRechg ttAgentPreRechg) { string strSQL = "insert into TTAgentPreRechg (flowId,agentId,agentName,fee,operatorId,operatorName,handleMode,bankAccountId,bankFlowId,description) values (SAgentRecharge_flowId.Nextval,@agentId,@agentName,@fee,@operatorId,@operatorName,@handleMode,@bankAccountId,@bankFlowId,@description)"; Param param = new Param(); param.Clear(); //param.Add("@flowId", ttAgentPreRechg.flowId);//流水号 param.Add("@agentId", ttAgentPreRechg.agentId); //代理商编号 param.Add("@agentName", ttAgentPreRechg.agentName); //代理商名称 param.Add("@fee", ttAgentPreRechg.fee); //发生金额 param.Add("@operatorId", ttAgentPreRechg.operatorId); //操作人编号 param.Add("@operatorName", ttAgentPreRechg.operatorName); //操作人名称 param.Add("@handleMode", ttAgentPreRechg.handleMode); //充值方式 param.Add("@bankAccountId", ttAgentPreRechg.bankAccountId); //银行账号 param.Add("@bankFlowId", ttAgentPreRechg.bankFlowId); //银行流水号 param.Add("@description", ttAgentPreRechg.description); //说明 data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
/// <summary> /// 增加代理商充值 /// <param name="ttAgentRecharge">代理商充值</param> /// </summary> public void Add(TTAgentRecharge ttAgentRecharge, TTAgentPreRechg ttAgentPreRechg, double balanceValue) { try { if (ttAgentRecharge.fee < 0 && Math.Abs(ttAgentRecharge.fee) > balanceValue) { Message.success(context, "代理商账户余额不足"); return; } ttAgentRechargeDAO.Add(ttAgentRecharge, ttAgentPreRechg); Message.success(context, "代理商充值审批成功"); loginSession.Log(ttAgentRecharge.agentName + "代理商充值审批成功"); } catch (Exception e) { Message.error(context, "代理商充值审批失败"); loginSession.Log(e.Message); } }
/// <summary> /// 修改代理商充值预审 /// </summary> /// <param name="data">数据库连接</param> /// <param name="ttAgentPreRechg">代理商充值预审</param> public virtual void Edit(DataAccess data, TTAgentPreRechg ttAgentPreRechg) { string strSQL = "update TTAgentPreRechg set agentId=@agentId,agentName=@agentName,fee=@fee,operatorId=@operatorId,operatorName=@operatorName,createTime=To_date(@createTime,'yyyy-mm-dd hh24:mi:ss'),handleMode=@handleMode,bankAccountId=@bankAccountId,bankFlowId=@bankFlowId,description=@description,auditStatus=@auditStatus where flowId=@flowId"; Param param = new Param(); param.Clear(); param.Add("@agentId", ttAgentPreRechg.agentId); //代理商编号 param.Add("@agentName", ttAgentPreRechg.agentName); //代理商名称 param.Add("@fee", ttAgentPreRechg.fee); //发生金额 param.Add("@operatorId", ttAgentPreRechg.operatorId); //操作人编号 param.Add("@operatorName", ttAgentPreRechg.operatorName); //操作人名称 param.Add("@createTime", ttAgentPreRechg.createTime); //创建时间 param.Add("@handleMode", ttAgentPreRechg.handleMode); //充值方式 param.Add("@bankAccountId", ttAgentPreRechg.bankAccountId); //银行账号 param.Add("@bankFlowId", ttAgentPreRechg.bankFlowId); //银行流水号 param.Add("@description", ttAgentPreRechg.description); //说明 param.Add("@auditStatus", ttAgentPreRechg.auditStatus); //审核状态 param.Add("@flowId", ttAgentPreRechg.flowId); //流水号 data.ExecuteNonQuery(CommandType.Text, strSQL, param); }
public void ProcessRequest(HttpContext context) { try { LoginUser loginUser = new LoginUser(context, "AgentPreRechg"); if (!loginUser.Pass)//权限验证 { return; } //加载DataGrid if (context.Request["action"] == "gridLoad") { AgentBLL bll = new AgentBLL(context, loginUser); //加载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"]; string bankCardId = context.Request["bankCardId"]; bll.LoadGrid(page, rows, agentName, agentId, bankCardId, ((int)AuditStauts.AuditSucces).ToString()); return; } if (context.Request["action"] == "handleModeListLoad") { Combobox com = new Combobox(context, loginUser); com.HandleModeCombobox(); } //加载信息 if (context.Request["action"] == "load") { AgentBLL bll = new AgentBLL(context, loginUser); //加载信息 bll.Load(context.Request["agentId"]); } //增加 if (context.Request["action"] == "add") { AgentPreRechgBLL bll = new AgentPreRechgBLL(context, loginUser); TTAgentPreRechg ttAgentPreRechg = new TTAgentPreRechg(); ttAgentPreRechg.agentId = context.Request["agentId"]; //代理商编号 ttAgentPreRechg.agentName = context.Request["agentName"]; //代理商名称 ttAgentPreRechg.fee = double.Parse(context.Request["fee"]); //发生金额 ttAgentPreRechg.handleMode = context.Request["handleMode"]; //充值方式 ttAgentPreRechg.operatorId = loginUser.UserId;; //操作人编号 ttAgentPreRechg.operatorName = loginUser.UserName; //操作人名称 ttAgentPreRechg.bankAccountId = context.Request["bankCardId"]; //银行账号 ttAgentPreRechg.bankFlowId = context.Request["bankFlowId"]; //银行流水号 ttAgentPreRechg.description = context.Request["description"]; //说明 bll.Add(ttAgentPreRechg); return; } //修改 if (context.Request["action"] == "edit") { AgentPreRechgBLL bll = new AgentPreRechgBLL(context, loginUser); TTAgentPreRechg ttAgentPreRechg = new TTAgentPreRechg(); ttAgentPreRechg.flowId = long.Parse(context.Request["flowId"]); //流水号 ttAgentPreRechg.agentId = context.Request["agentId"]; //代理商编号 ttAgentPreRechg.agentName = context.Request["agentName"]; //代理商名称 ttAgentPreRechg.fee = double.Parse(context.Request["fee"]); //发生金额 ttAgentPreRechg.operatorId = context.Request["operatorId"]; //操作人编号 ttAgentPreRechg.operatorName = context.Request["operatorName"]; //操作人名称 ttAgentPreRechg.createTime = context.Request["createTime"]; //创建时间 ttAgentPreRechg.handleMode = context.Request["handleMode"]; //充值方式 ttAgentPreRechg.bankAccountId = context.Request["bankAccountId"]; //银行账号 ttAgentPreRechg.bankFlowId = context.Request["bankFlowId"]; //银行流水号 ttAgentPreRechg.description = context.Request["description"]; //说明 ttAgentPreRechg.auditStatus = context.Request["auditStatus"]; //审核状态 bll.Edit(ttAgentPreRechg); return; } //删除 if (context.Request["action"] == "delete") { AgentPreRechgBLL bll = new AgentPreRechgBLL(context, loginUser); long flowId = long.Parse(context.Request["flowId"]);//流水号 bll.Delete(flowId); return; } } catch (Exception e) { Message.error(context, e.Message); } }
public void ProcessRequest(HttpContext context) { try { LoginUser loginUser = new LoginUser(context, "AgentRecharge"); AgentPreRechgBLL bll = new AgentPreRechgBLL(context, loginUser); if (!loginUser.Pass)//权限验证 { return; } //加载DataGrid if (context.Request["action"] == "gridLoad") { int page = int.Parse(context.Request["page"]); int rows = int.Parse(context.Request["rows"]); string agentId = context.Request["agentId"]; string auditStatus = context.Request["auditStatus"]; string startDate = context.Request["startDate"]; string endDate = context.Request["endDate"]; bll.LoadGrid(page, rows, agentId, auditStatus, startDate, endDate); return; } if (context.Request["action"] == "load") { //加载信息 bll.Load(long.Parse(context.Request["flowId"])); } if (context.Request["action"] == "handleModeListLoad") { Combobox com = new Combobox(context, loginUser); com.HandleModeCombobox(); } //审核 if (context.Request["action"] == "audit") { AgentRechargeBLL agentRechargeBLL = new AgentRechargeBLL(context, loginUser); long flowId = long.Parse(context.Request["flowId"]); string remark = context.Request["remark"]; TTAgentPreRechg ttAgentPreRechg = bll.Get(flowId);//预审 ttAgentPreRechg.auditStatus = context.Request["auditStatus"]; if (ttAgentPreRechg.auditStatus == "1") { TTAgentRecharge ttAgentRecharge = new TTAgentRecharge(); //充值明细 ttAgentRecharge.agentId = ttAgentPreRechg.agentId; //代理商编号 ttAgentRecharge.fee = ttAgentPreRechg.fee; //发生金额 ttAgentRecharge.operatorId = loginUser.UserId; //操作人编号 ttAgentRecharge.operatorName = loginUser.UserName; //操作人名称 ttAgentRecharge.handleMode = ttAgentPreRechg.handleMode; //充值方式 ttAgentRecharge.bankAccountId = ttAgentPreRechg.bankAccountId; //银行账号 ttAgentRecharge.bankFlowId = ttAgentPreRechg.bankFlowId; //银行流水号 if (remark.Trim() == "") { ttAgentRecharge.description = ttAgentPreRechg.description;//说明 } else { ttAgentRecharge.description = remark; } agentRechargeBLL.Add(ttAgentRecharge, ttAgentPreRechg, ttAgentPreRechg.fee); } else { bll.Edit(ttAgentPreRechg); } return; } } catch (Exception e) { Message.error(context, e.Message); } }