/// <summary>
/// 获取接口服务账号
/// </summary>
/// <param name="ConncetId">连接端编号</param>
/// <returns>接口服务账号对象</returns>
public virtual TSConnect Get(string ConncetId)
{
TSConnect tsConnect = null;
try
{
string strSQL = "select * from TSConnect where ConncetId=@ConncetId";
Param param = new Param();
param.Clear();
param.Add("@ConncetId", ConncetId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tsConnect = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tsConnect);
}
/// <summary>
/// 获取代理系统权限模块
/// </summary>
/// <param name="roleId">角色编号</param>
/// <param name="moduleId">模块编号</param>
/// <returns>代理系统权限模块对象</returns>
public virtual TSAgentRight Get(string roleId, string moduleId)
{
TSAgentRight tsAgentRight = null;
try
{
string strSQL = "select * from TSAgentRight where roleId=@roleId and moduleId=@moduleId";
Param param = new Param();
param.Clear();
param.Add("@roleId", roleId);
param.Add("@moduleId", moduleId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tsAgentRight = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tsAgentRight);
}
/// <summary>
/// 获取列表(客户提现)
/// </summary>
/// <param name="field">字段名</param>
/// <param name="value">字段值</param>
/// <returns>客户提现列表对象</returns>
public virtual List <TTClientTakeCash> GetList(string field, string value)
{
List <TTClientTakeCash> list = new List <TTClientTakeCash>();
try
{
string strSQL = "select * from TTClientTakeCash where " + field + "=@field";
Param param = new Param();
param.Clear();
param.Add("@field", value);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
while (dr.Read())
{
list.Add(ReadData(dr));
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(list);
}
/// <summary>
/// 读取客户账户明细信息
/// </summary>
/// <param name="dr">记录指针</param>
/// <returns>客户账户明细对象</returns>
protected virtual TTClientAccDetail ReadData(ComDataReader dr)
{
TTClientAccDetail ttClientAccDetail = new TTClientAccDetail();
ttClientAccDetail.flowId = long.Parse(dr["flowId"].ToString()); //流水号
ttClientAccDetail.cardId = dr["cardId"].ToString(); //卡号
ttClientAccDetail.clientId = long.Parse(dr["clientId"].ToString()); //客户编号
ttClientAccDetail.clientName = dr["clientName"].ToString(); //客户名称
ttClientAccDetail.agentId = dr["agentId"].ToString(); //代理商编号
ttClientAccDetail.siteId = dr["siteId"].ToString(); //门店编号
ttClientAccDetail.lastBalance = double.Parse(dr["lastBalance"].ToString()); //上次余额
ttClientAccDetail.fee = double.Parse(dr["fee"].ToString()); //发生金额
ttClientAccDetail.balance = double.Parse(dr["balance"].ToString()); //当前余额
ttClientAccDetail.remark = dr["remark"].ToString(); //信息摘要
ttClientAccDetail.changeTime = dr["changeTime"].ToString(); //发生时间
ttClientAccDetail.srcMode = dr["srcMode"].ToString(); //来源方式
if (dr["createTime"] == null)
{
ttClientAccDetail.createTime = "";//创建时间
}
else
{
ttClientAccDetail.createTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["createTime"]);//创建时间
}
return(ttClientAccDetail);
}
/// <summary>
/// 获取部门
/// <param name="deptId">部门编号</param>
/// </summary>
/// <returns>部门对象</returns>
public TSDept Get(string deptId)
{
TSDept tsDept = null;
try
{
string strSQL = "select * from TSDept where deptId=:deptId";
Param param = new Param();
param.Clear();
param.Add(":deptId", deptId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tsDept = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tsDept);
}
/// <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>
/// 获取代理佣金结算
/// <param name="Column_1">Column_1</param>
/// </summary>
/// <returns>代理佣金结算对象</returns>
public virtual TTClientRecharge3 Get(string Column_1)
{
TTClientRecharge3 ttClientRecharge3 = null;
try
{
string strSQL = "select * from TTClientRecharge3 where Column_1=@Column_1";
Param param = new Param();
param.Clear();
param.Add("@Column_1", Column_1);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
ttClientRecharge3 = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(ttClientRecharge3);
}
/// <summary>
/// 读取客户积分明细信息
/// </summary>
/// <param name="dr">记录指针</param>
/// <returns>客户积分明细对象</returns>
protected virtual TTClientPoint ReadData(ComDataReader dr)
{
TTClientPoint ttClientPoint = new TTClientPoint();
ttClientPoint.flowId = long.Parse(dr["flowId"].ToString()); //流水号
ttClientPoint.cardId = dr["cardId"].ToString(); //卡号
ttClientPoint.clientId = long.Parse(dr["clientId"].ToString()); //客户编号
ttClientPoint.clientName = dr["clientName"].ToString(); //客户名称
ttClientPoint.agentId = dr["agentId"].ToString(); //代理商编号
ttClientPoint.siteId = dr["siteId"].ToString(); //门店编号
ttClientPoint.lastPoint = long.Parse(dr["lastPoint"].ToString()); //上次积分
ttClientPoint.point = long.Parse(dr["point"].ToString()); //发生积分
ttClientPoint.remainingPoint = long.Parse(dr["remainingPoint"].ToString()); //剩余积分
ttClientPoint.changeTime = dr["changeTime"].ToString(); //发生时间
ttClientPoint.description = dr["description"].ToString(); //描述说明
if (dr["createTime"] == null)
{
ttClientPoint.createTime = "";//创建时间
}
else
{
ttClientPoint.createTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["createTime"]); //创建时间
}
ttClientPoint.srcMode = dr["srcMode"].ToString(); //来源方式
ttClientPoint.srcFlowId = dr["srcFlowId"].ToString(); //来源流水号
ttClientPoint.operatorId = dr["operatorId"].ToString(); //操作人编号
ttClientPoint.operatorName = dr["operatorName"].ToString(); //操作人名称
ttClientPoint.gameId = dr["gameId"].ToString(); //游戏编号
ttClientPoint.terminalId = dr["terminalId"].ToString(); //终端编号
return(ttClientPoint);
}
/// <summary>
/// 根据卡号获取客户信息
/// <param name="cardId">客户卡号</param>
/// </summary>
/// <returns>客户信息对象</returns>
public TBClient GetByCard(long cardId)
{
TBClient tbClient = null;
try
{
string strSQL = "select * from TBClient where status='0' and cardId=@cardId";
Param param = new Param();
param.Clear();
param.Add("@cardId", cardId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbClient = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbClient);
}
/// <summary>
/// 读取积分订单信息
/// <param name="dr">记录指针</param>
/// </summary>
/// <returns>积分订单对象</returns>
protected override TTPointOrder ReadData(ComDataReader dr)
{
TTPointOrder ttPointOrder = new TTPointOrder();
ttPointOrder.orderId = dr["orderId"].ToString(); //订单号
ttPointOrder.agentId = dr["agentId"].ToString(); //代理商编号
ttPointOrder.siteId = dr["siteId"].ToString(); //门店编号
ttPointOrder.terminalId = dr["terminalId"].ToString(); //终端编号
ttPointOrder.clientId = long.Parse(dr["clientId"].ToString()); //客户编号
ttPointOrder.clientName = dr["clientName"].ToString(); //客户名称
ttPointOrder.cardId = dr["cardId"].ToString(); //卡号
ttPointOrder.gameId = dr["gameName"].ToString(); //游戏编号
ttPointOrder.period = dr["period"].ToString(); //期次
ttPointOrder.betPoint = long.Parse(dr["betPoint"].ToString()); //投注金额
ttPointOrder.betTime = dr["betTime"].ToString(); //投注时间
ttPointOrder.orderStatus = dr["orderStatus"].ToString(); //订单状态
ttPointOrder.orderTime = dr["orderTime"].ToString(); //出票/撤销时间
ttPointOrder.awardResult = dr["awardResult"].ToString(); //中奖状态
ttPointOrder.awardPoint = long.Parse(dr["awardPoint"].ToString()); //中奖金额
ttPointOrder.awardTime = dr["awardTime"].ToString(); //返奖时间
ttPointOrder.srcType = dr["srcType"].ToString(); //数据来源方式
ttPointOrder.betCodes = BetCodesContext.GetBetCodes(dr["gameId"].ToString(), dr["betCodes"].ToString(), false); //用户投注串
if (dr["createTime"] == null)
{
ttPointOrder.createTime = "";//创建时间
}
else
{
ttPointOrder.createTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["createTime"]);//创建时间
}
return(ttPointOrder);
}
private DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接
/// <summary>
/// 根据卡号起始结束获取相应的卡片
/// </summary>
/// <param name="startCardId">起始卡号</param>
/// <param name="endCardId">结束卡号</param>
/// <returns></returns>
public List <TBCard> GetListByStartEndCard(string startCardId, string endCardId)
{
List <TBCard> list = new List <TBCard>();
try
{
string strSQL = "select * from TBCard where cardId>=:startCardId and cardId<=:endCardId and status='" + (int)CardStatus.StayUsed + "' order by cardId ";
Param param = new Param();
param.Clear();
param.Add(":startCardId", startCardId);
param.Add(":endCardId", endCardId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
while (dr.Read())
{
list.Add(ReadData(dr));
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(list);
}
/// <summary>
/// 获取系统用户
/// </summary>
/// <param name="userId">用户登录名</param>
/// <returns>系统用户对象</returns>
public virtual TSUser GetTSUser(string USERCODE)
{
TSUser tsUser = null;
try
{
string strSQL = "select * from TSUser where USERCODE=@USERCODE";
Param param = new Param();
param.Clear();
param.Add("@USERCODE", USERCODE);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tsUser = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tsUser);
}
/// <summary>
/// 获取最大值表
/// <param name="tabName">表名</param>
/// </summary>
/// <returns>最大值表对象</returns>
public TSMax Get(string tabName)
{
TSMax tsMax = null;
try
{
string strSQL = "select * from TSMax where tabName=:tabName";
Param param = new Param();
param.Clear();
param.Add(":tabName", tabName);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tsMax = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tsMax);
}
/// <summary>
/// 读取代理商充值信息
/// <param name="dr">记录指针</param>
/// </summary>
/// <returns>代理商充值对象</returns>
private TTAgentRecharge ReadData(ComDataReader dr)
{
TTAgentRecharge ttAgentRecharge = new TTAgentRecharge();
ttAgentRecharge.flowId = long.Parse(dr["flowId"].ToString()); //流水号
ttAgentRecharge.agentId = dr["agentId"].ToString(); //代理商编号
ttAgentRecharge.agentName = dr["agentName"].ToString(); //代理商名称
ttAgentRecharge.lastBalance = double.Parse(dr["lastBalance"].ToString()); //上次余额
ttAgentRecharge.fee = double.Parse(dr["fee"].ToString()); //发生金额
ttAgentRecharge.balance = double.Parse(dr["balance"].ToString()); //当前余额
ttAgentRecharge.operatorId = dr["operatorId"].ToString(); //操作人编号
ttAgentRecharge.operatorName = dr["operatorName"].ToString(); //操作人名称
if (dr["createTime"] == null)
{
ttAgentRecharge.createTime = "";//创建时间
}
else
{
ttAgentRecharge.createTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["createTime"]); //创建时间
}
ttAgentRecharge.handleMode = dr["handleMode"].ToString(); //充值方式
ttAgentRecharge.bankAccountId = dr["bankAccountId"].ToString(); //银行账号
ttAgentRecharge.bankFlowId = dr["bankFlowId"].ToString(); //银行流水号
ttAgentRecharge.description = dr["description"].ToString(); //说明
return(ttAgentRecharge);
}
/// <summary>
/// 获取开奖公告
/// </summary>
/// <param name="flowId">流水号</param>
/// <param name="gameId">游戏编号</param>
/// <returns>开奖公告对象</returns>
public virtual TBNumNotice Get(string flowId, string gameId)
{
TBNumNotice tbNumNotice = null;
try
{
string strSQL = "select * from TBNumNotice where flowId=@flowId and gameId=@gameId";
Param param = new Param();
param.Clear();
param.Add("@flowId", flowId);
param.Add("@gameId", gameId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbNumNotice = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbNumNotice);
}
/// <summary>
/// 获取客户账户明细
/// <param name="flowId">编号</param>
/// </summary>
/// <returns>客户账户明细对象</returns>
public TTClientAccDetail Get(long flowId)
{
TTClientAccDetail ttClientAccDetail = null;
try
{
string strSQL = "select * from TTClientAccDetail 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())
{
ttClientAccDetail = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(ttClientAccDetail);
}
/// <summary>
/// 获取系统角色
/// <param name="roleId">角色编号</param>
/// </summary>
/// <returns>系统角色对象</returns>
public TSRole Get(string roleId)
{
TSRole tsRole = null;
try
{
string strSQL = "select * from TSRole where roleId=:roleId";
Param param = new Param();
param.Clear();
param.Add(":roleId", roleId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tsRole = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tsRole);
}
private DataAccess db = new DataAccess(DataAccess.DBConn);//数据库连接
/// <summary>
/// 根据终端号起始结束获取相应的终端
/// </summary>
/// <param name="startCardId">起始终端</param>
/// <param name="endCardId">结束终端</param>
/// <returns></returns>
public List <TBTerminal> GetListByStartEndTerminal(string startTerminalId, string endTerminalId)
{
List <TBTerminal> list = new List <TBTerminal>();
try
{
string strSQL = "select * from TBTerminal where terminalId>=:startTerminalId and terminalId<=:endTerminalId and status='" + (int)TerminalStatus.InStore + "' order by terminalId ";
Param param = new Param();
param.Clear();
param.Add(":startTerminalId", startTerminalId);
param.Add(":endTerminalId", endTerminalId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
while (dr.Read())
{
list.Add(ReadData(dr));
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(list);
}
/// <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="userCode">用户帐号</param>
/// </summary>
/// <returns>代理快开厅用户对象</returns>
public TSAgentUser Get(string userId)
{
TSAgentUser tsAgentUser = null;
try
{
string strSQL = "select * from TSAgentUser where userId=:userId";
Param param = new Param();
param.Clear();
param.Add(":userId", userId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tsAgentUser = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tsAgentUser);
}
/// <summary>
/// 读取代理佣金结算信息
/// <param name="dr">记录指针</param>
/// </summary>
/// <returns>代理佣金结算对象</returns>
protected virtual TTClientRecharge3 ReadData(ComDataReader dr)
{
TTClientRecharge3 ttClientRecharge3 = new TTClientRecharge3();
ttClientRecharge3.Column_1 = dr["Column_1"].ToString();//Column_1
return(ttClientRecharge3);
}
/// <summary>
/// 获取快开厅员工
/// <param name="staffId">员工编号</param>
/// </summary>
/// <returns>快开厅员工对象</returns>
public TBStaff Get(string staffId)
{
TBStaff tbStaff = null;
try
{
string strSQL = "select * from TBStaff where staffId=:staffId";
Param param = new Param();
param.Clear();
param.Add(":staffId", staffId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbStaff = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbStaff);
}
/// <summary>
/// 获取终端日志
/// <param name="logId">日志编号</param>
/// </summary>
/// <returns>终端日志对象</returns>
public TBTerminalLog Get(long logId)
{
TBTerminalLog tbTerminalLog = null;
try
{
string strSQL = "select * from TBTerminalLog where logId=:logId";
Param param = new Param();
param.Clear();
param.Add(":logId", logId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbTerminalLog = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbTerminalLog);
}
/// <summary>
/// 获取快开厅员工
/// <param name="staffId">员工编号</param>
/// </summary>
/// <returns>快开厅员工对象</returns>
public TBStaffClon GetClon(string staffId)
{
TBStaffClon tbStaffClon = null;
try
{
string strSQL = "select a.*,b.roleId,b.userCode from TBStaff a,TSAgentUser b where a.staffId=b.userId and b.roleId!='001' and a.staffId=:staffId";
Param param = new Param();
param.Clear();
param.Add(":staffId", staffId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbStaffClon = ReadDataClon(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbStaffClon);
}
/// <summary>
/// 获取门店信息
/// </summary>
/// <param name="siteId">门店编号</param>
/// <returns>门店信息对象</returns>
public virtual TBEnforcementType Get(string EnforcementTypeId)
{
TBEnforcementType tbSite = null;
try
{
string strSQL = "select * from tbEnforcementType where statu=1 and EnforcementTypeId=@EnforcementTypeId";
Param param = new Param();
param.Clear();
param.Add("@EnforcementTypeId", EnforcementTypeId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
tbSite = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(tbSite);
}
/// <summary>
/// 获取列表(代理系统权限模块)
/// <param name="field">字段名</param>
/// <param name="value">字段值</param>
/// </summary>
/// <returns>代理系统权限模块列表对象</returns>
public List <TSAgentRight> GetList(string field, string value)
{
List <TSAgentRight> list = new List <TSAgentRight>();
try
{
string strSQL = "select * from TSAgentRight where " + field + "=:field";
Param param = new Param();
param.Clear();
param.Add(":field", value);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
while (dr.Read())
{
list.Add(ReadData(dr));
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(list);
}
/// <summary>
/// 获取客户提现
/// </summary>
/// <param name="flowId">流水号</param>
/// <returns>客户提现对象</returns>
public virtual TTClientTakeCash Get(long flowId)
{
TTClientTakeCash ttClientTakeCash = null;
try
{
string strSQL = "select * from TTClientTakeCash 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())
{
ttClientTakeCash = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(ttClientTakeCash);
}
/// <summary>
/// 获取指定角色的权限模块ID哈希表
/// </summary>
/// <param name="roleIds">角色编号(可以多项用逗号分隔)</param>
/// <returns>模块ID哈希表</returns>
public Hashtable GetAgentModuleIdHash(string roleIds)
{
Hashtable hashModuleId = new Hashtable();
hashModuleId.Clear();
string strSQL = " select distinct moduleId from TSAgentRight where roleId in ('" + roleIds.Replace(",", "','") + "')";
try
{
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, null);
while (dr.Read())
{
hashModuleId.Add(dr["moduleId"], dr["moduleId"]);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(hashModuleId);
}
/// <summary>
/// 读取客户提现信息
/// </summary>
/// <param name="dr">记录指针</param>
/// <returns>客户提现对象</returns>
protected virtual TTClientTakeCash ReadData(ComDataReader dr)
{
TTClientTakeCash ttClientTakeCash = new TTClientTakeCash();
ttClientTakeCash.flowId = long.Parse(dr["flowId"].ToString()); //流水号
ttClientTakeCash.clientId = long.Parse(dr["clientId"].ToString()); //客户编号
ttClientTakeCash.clientName = dr["clientName"].ToString(); //客户名称
ttClientTakeCash.agentId = dr["agentId"].ToString(); //代理商编号
ttClientTakeCash.siteId = dr["siteId"].ToString(); //门店编号
ttClientTakeCash.lastBalance = double.Parse(dr["lastBalance"].ToString()); //上次余额
ttClientTakeCash.fee = double.Parse(dr["fee"].ToString()); //发生金额
ttClientTakeCash.balance = double.Parse(dr["balance"].ToString()); //当前余额
ttClientTakeCash.handleMode = dr["handleMode"].ToString(); //提现方式
ttClientTakeCash.operatorId = dr["operatorId"].ToString(); //操作人编号
ttClientTakeCash.operatorName = dr["operatorName"].ToString(); //操作人名称
if (dr["createTime"] == null)
{
ttClientTakeCash.createTime = "";//创建时间
}
else
{
ttClientTakeCash.createTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["createTime"]); //创建时间
}
ttClientTakeCash.cardId = dr["cardId"].ToString(); //卡号
ttClientTakeCash.sourceType = dr["sourceType"].ToString(); //提现来源
ttClientTakeCash.timeStamp = dr["timeStamp"].ToString(); //时间戳
ttClientTakeCash.description = dr["description"].ToString(); //说明
return(ttClientTakeCash);
}
/// <summary>
/// 获取追号计划
/// </summary>
/// <param name="orderId">订单号</param>
/// <returns>追号计划对象</returns>
public virtual TTChasePlan Get(string orderId)
{
TTChasePlan ttChasePlan = null;
try
{
string strSQL = "select * from TTChasePlan where orderId=@orderId";
Param param = new Param();
param.Clear();
param.Add("@orderId", orderId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
ttChasePlan = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(ttChasePlan);
}
