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