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