/// <summary> /// 读取代理商信息信息 /// <param name="dr">记录指针</param> /// </summary> /// <returns>代理商信息对象</returns> private TBAgentClon ReadDataClon(ComDataReader dr) { TBAgentClon tbAgent = new TBAgentClon(); tbAgent.agentId = dr["agentId"].ToString(); //代理商编号 tbAgent.agentName = dr["agentName"].ToString(); //代理商名称 tbAgent.rebate = double.Parse(dr["rebate"].ToString()); //返点比例 tbAgent.contact = dr["contact"].ToString(); //联系人 tbAgent.agentUserCode = dr["userCode"].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="agentId">代理商编号</param> /// </summary> public void Load(string agentId) { try { TBAgentClon tbAgent = tbAgentDAO.GetClon(agentId); tbAgent.status = "1".Equals(tbAgent.status) ? "on" : "off"; WebJson.ToJson(context, tbAgent); } catch (Exception e) { Message.error(context, e.Message); } }
public TBAgentClon Get(DataAccess data, string agentId) { TBAgentClon tbAgent = null; string strSQL = "select a.*,t.usercode from TBAgent a,TSAgentUser t where a.agentid=t.userid and t.roleid='001' and agentId=:agentId"; Param param = new Param(); param.Clear(); param.Add(":agentId", agentId); ComDataReader dr = data.ExecuteReader(CommandType.Text, strSQL, param); if (dr.Read()) { tbAgent = ReadDataClon(dr); } return(tbAgent); }
/// <summary> /// 获取代理商信息 /// <param name="agentId">代理商编号</param> /// </summary> /// <returns>代理商信息对象</returns> public TBAgentClon Get(string agentId) { TBAgentClon tbAgent = null; try { db.Open(); tbAgent = Get(db, agentId); } catch (Exception e) { throw e; } finally { db.Close(); } return(tbAgent); }