/// <summary>
/// 获取追号订单
/// <param name="chaseOrderId">追号订单号</param>
/// </summary>
/// <returns>追号订单对象</returns>
public TTChaseOrder Get(string chaseOrderId)
{
TTChaseOrder ttChaseOrder = null;
try
{
string strSQL = "select * from TTChaseOrder where chaseOrderId=:chaseOrderId";
Param param = new Param();
param.Clear();
param.Add(":chaseOrderId", chaseOrderId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
ttChaseOrder = ReadData(dr);
}
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(ttChaseOrder);
}
/// <summary>
/// 加载指定追号订单
/// <param name="chaseOrderId">追号订单号</param>
/// </summary>
public void Load(string chaseOrderId)
{
try
{
TTChaseOrder ttChaseOrder = ttChaseOrderDAO.Get(chaseOrderId);
WebJson.ToJson(context, ttChaseOrder);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
}
/// <summary>
/// 获取快开厅信息
/// <param name="siteId">快开厅编号</param>
/// </summary>
/// <returns>快开厅信息对象</returns>
public TTChaseOrder Get(string chaseOrderId)
{
TTChaseOrder ttChaseOrder = new TTChaseOrder();
try
{
ttChaseOrder = ttChaseOrderDAO.Get(chaseOrderId);
}
catch (Exception e)
{
Message.error(context, e.Message);
}
return(ttChaseOrder);
}
/// <summary>
/// 增加追号订单
/// <param name="ttChaseOrder">追号订单</param>
/// </summary>
public void Add(TTChaseOrder ttChaseOrder)
{
try
{
db.Open();
Add(db, ttChaseOrder);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 修改追号订单
/// </summary>
/// <param name="ttChaseOrder">追号订单</param>
public virtual void Edit(TTChaseOrder ttChaseOrder)
{
try
{
db.Open();
Edit(db, ttChaseOrder);
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
}
/// <summary>
/// 读取追号订单信息
/// <param name="dr">记录指针</param>
/// </summary>
/// <returns>追号订单对象</returns>
protected override TTChaseOrder ReadData(ComDataReader dr)
{
TTChaseOrder ttChaseOrder = new TTChaseOrder();
ttChaseOrder.chaseOrderId = dr["chaseOrderId"].ToString(); //追号订单号
ttChaseOrder.chaseType = dr["chaseType"].ToString(); //追号订单类型
ttChaseOrder.agentId = dr["agentId"].ToString(); //代理商编号
ttChaseOrder.siteId = dr["siteId"].ToString(); //门店编号
ttChaseOrder.terminalId = dr["terminalId"].ToString(); //终端编号
ttChaseOrder.clientId = long.Parse(dr["clientId"].ToString()); //客户编号
ttChaseOrder.clientName = dr["clientName"].ToString(); //客户名称
ttChaseOrder.cardId = dr["cardId"].ToString(); //卡号
ttChaseOrder.gameId = dr["gameName"].ToString(); //游戏编号
ttChaseOrder.lotteryType = dr["lotteryType"].ToString(); //彩种
ttChaseOrder.period = dr["period"].ToString(); //下单期次
ttChaseOrder.userBetCodes = BetCodesContext.GetBetCodes(dr["gameId"].ToString(), dr["userBetCodes"].ToString(), true); //用户投注串
ttChaseOrder.centerBetCodes = BetCodesContext.GetBetCodes(dr["gameId"].ToString(), dr["centerBetCodes"].ToString(), true); //中心投注串
ttChaseOrder.betNum = int.Parse(dr["betNum"].ToString()); //投注期数
ttChaseOrder.chaseTotalFee = double.Parse(dr["chaseTotalFee"].ToString()); //订单总额
ttChaseOrder.chaseTime = dr["chaseTime"].ToString(); //追号时间
ttChaseOrder.endCondition = dr["endCondition"].ToString(); //停止条件
ttChaseOrder.conditionParam = int.Parse(dr["conditionParam"].ToString()); //停止参数
ttChaseOrder.usedPeriod = dr["usedPeriod"].ToString(); //运行期次
ttChaseOrder.usedNum = int.Parse(dr["usedNum"].ToString()); //已追期数
ttChaseOrder.usedFee = double.Parse(dr["usedFee"].ToString()); //已追金额
ttChaseOrder.backNum = int.Parse(dr["backNum"].ToString()); //退款期数
ttChaseOrder.backFee = double.Parse(dr["backFee"].ToString()); //退款金额
ttChaseOrder.awardMoney = double.Parse(dr["awardMoney"].ToString()); //中奖金额
ttChaseOrder.frozenFee = double.Parse(dr["frozenFee"].ToString()); //冻结金额
ttChaseOrder.chaseStatus = dr["chaseStatus"].ToString(); //追号状态
ttChaseOrder.srcType = dr["srcType"].ToString(); //数据来源方式
ttChaseOrder.overTime = dr["overTime"].ToString(); //结束时间
if (dr["createTime"] == null)
{
ttChaseOrder.createTime = "";//创建时间
}
else
{
ttChaseOrder.createTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", dr["createTime"]);//创建时间
}
return(ttChaseOrder);
}
/// <summary>
/// 获取追号订单
/// <param name="chaseOrderId">追号订单号</param>
/// </summary>
/// <returns>追号订单对象</returns>
public override TTChaseOrder Get(string chaseOrderId)
{
TTChaseOrder ttChaseOrder = null;
try
{
string strSQL = @"select c.chaseorderid,case c.chaseType when '0' then '普通追号' when '1' then '高级追号' end chaseType,
a.agentname agentid,s.sitename siteid, c.terminalid, c.clientid, c.clientname, c.cardid, g.gamename,g.gameid,
l.LotteryTypeName lotterytype, c.period, c.userBetCodes,c.centerBetCodes, c.betnum, c.chasetotalfee, c.chasetime,
case c.endcondition when '0' then '不停止' when '1' then '固定奖金停止' when '2' then '达到中奖率停止' end endcondition,
c.conditionparam,
c.usedperiod, c.usednum, c.usedfee, c.backnum, c.backfee, c.awardmoney, c.frozenfee,
case c.chasestatus when '0' then '正在追号' when '1' then '中奖停止' when '2' then '追期结束' when '3' then '手工停止'
when '4' then '追号撤单' when '5' then '异常停止' end chasestatus,
c.overtime, c.createtime,
case c.srcType when '0' then '游戏终端' when '1' then '手机APP' end srcType
from TTChaseOrder c,Tbgame g,TBlottery l,TBAgent a,TBSite s
where c.gameid=g.gameid and c.lotterytype=l.lotterytype
and c.agentid=a.agentid and c.siteid=s.siteid and chaseOrderId=@chaseOrderId";
Param param = new Param();
param.Clear();
param.Add("@chaseOrderId", chaseOrderId);
db.Open();
ComDataReader dr = db.ExecuteReader(CommandType.Text, strSQL, param);
if (dr.Read())
{
ttChaseOrder = ReadData(dr);
}
dr.Close();
}
catch (Exception e)
{
throw e;
}
finally
{
db.Close();
}
return(ttChaseOrder);
}
/// <summary>
/// 修改追号订单
/// <param name="data">数据库连接</param>
/// <param name="ttChaseOrder">追号订单</param>
/// </summary>
public void Edit(DataAccess data, TTChaseOrder ttChaseOrder)
{
string strSQL = "update TTChaseOrder set agentId=:agentId,siteId=:siteId,terminalId=:terminalId,clientId=:clientId,clientName=:clientName,cardId=:cardId,gameId=:gameId,lotteryType=:lotteryType,playType=:playType,period=:period,betCodes=:betCodes,multiple=:multiple,betNum=:betNum,chaseTotalFee=:chaseTotalFee,chaseTime=:chaseTime,endCondition=:endCondition,conditionParam=:conditionParam,usedPeriod=:usedPeriod,usedNum=:usedNum,usedFee=:usedFee,backNum=:backNum,backFee=:backFee,awardMoney=:awardMoney,frozenFee=:frozenFee,chaseStatus=:chaseStatus,overTime=:overTime,createTime=To_date(:createTime,'yyyy-mm-dd hh24:mi:ss'),batchId=:batchId where chaseOrderId=:chaseOrderId";
Param param = new Param();
param.Clear();
param.Add(":agentId", ttChaseOrder.agentId); //代理商编号
param.Add(":siteId", ttChaseOrder.siteId); //门店编号
param.Add(":terminalId", ttChaseOrder.terminalId); //终端编号
param.Add(":clientId", ttChaseOrder.clientId); //客户编号
param.Add(":clientName", ttChaseOrder.clientName); //客户名称
param.Add(":cardId", ttChaseOrder.cardId); //卡号
param.Add(":gameId", ttChaseOrder.gameId); //游戏编号
param.Add(":lotteryType", ttChaseOrder.lotteryType); //彩种
param.Add(":playType", ttChaseOrder.playType); //玩法
param.Add(":period", ttChaseOrder.period); //下单期次
param.Add(":betCodes", ttChaseOrder.betCodes); //投注串
param.Add(":multiple", ttChaseOrder.multiple); //倍数
param.Add(":betNum", ttChaseOrder.betNum); //投注期数
param.Add(":chaseTotalFee", ttChaseOrder.chaseTotalFee); //订单总额
param.Add(":chaseTime", ttChaseOrder.chaseTime); //追号时间
param.Add(":endCondition", ttChaseOrder.endCondition); //停止条件
param.Add(":conditionParam", ttChaseOrder.conditionParam); //停止参数
param.Add(":usedPeriod", ttChaseOrder.usedPeriod); //运行期次
param.Add(":usedNum", ttChaseOrder.usedNum); //已追期数
param.Add(":usedFee", ttChaseOrder.usedFee); //已追金额
param.Add(":backNum", ttChaseOrder.backNum); //退款期数
param.Add(":backFee", ttChaseOrder.backFee); //退款金额
param.Add(":awardMoney", ttChaseOrder.awardMoney); //中奖金额
param.Add(":frozenFee", ttChaseOrder.frozenFee); //冻结金额
param.Add(":chaseStatus", ttChaseOrder.chaseStatus); //追号状态
param.Add(":overTime", ttChaseOrder.overTime); //结束时间
param.Add(":createTime", ttChaseOrder.createTime); //创建时间
param.Add(":batchId", ttChaseOrder.batchId); //批处理编号
param.Add(":chaseOrderId", ttChaseOrder.chaseOrderId); //追号订单号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
/// <summary>
/// 修改追号订单
/// </summary>
/// <param name="data">数据库连接</param>
/// <param name="ttChaseOrder">追号订单</param>
public virtual void Edit(DataAccess data, TTChaseOrder ttChaseOrder)
{
string strSQL = "update TTChaseOrder set chaseType=@chaseType,agentId=@agentId,siteId=@siteId,terminalId=@terminalId,clientId=@clientId,clientName=@clientName,cardId=@cardId,gameId=@gameId,lotteryType=@lotteryType,period=@period,userBetCodes=@userBetCodes,centerBetCodes=@centerBetCodes,betNum=@betNum,chaseTotalFee=@chaseTotalFee,chaseTime=@chaseTime,endCondition=@endCondition,conditionParam=@conditionParam,usedPeriod=@usedPeriod,usedNum=@usedNum,usedFee=@usedFee,backNum=@backNum,backFee=@backFee,awardMoney=@awardMoney,frozenFee=@frozenFee,chaseStatus=@chaseStatus,overTime=@overTime,createTime=To_date(@createTime,'yyyy-mm-dd hh24:mi:ss'),srcType=@srcType where chaseOrderId=@chaseOrderId";
Param param = new Param();
param.Clear();
param.Add("@chaseType", ttChaseOrder.chaseType); //追号类型
param.Add("@agentId", ttChaseOrder.agentId); //代理商编号
param.Add("@siteId", ttChaseOrder.siteId); //门店编号
param.Add("@terminalId", ttChaseOrder.terminalId); //终端编号
param.Add("@clientId", ttChaseOrder.clientId); //客户编号
param.Add("@clientName", ttChaseOrder.clientName); //客户名称
param.Add("@cardId", ttChaseOrder.cardId); //卡号
param.Add("@gameId", ttChaseOrder.gameId); //游戏编号
param.Add("@lotteryType", ttChaseOrder.lotteryType); //彩种
param.Add("@period", ttChaseOrder.period); //下单期次
param.Add("@userBetCodes", ttChaseOrder.userBetCodes); //用户投注串
param.Add("@centerBetCodes", ttChaseOrder.centerBetCodes); //中心投注串
param.Add("@betNum", ttChaseOrder.betNum); //投注期数
param.Add("@chaseTotalFee", ttChaseOrder.chaseTotalFee); //订单总额
param.Add("@chaseTime", ttChaseOrder.chaseTime); //追号时间
param.Add("@endCondition", ttChaseOrder.endCondition); //停止条件
param.Add("@conditionParam", ttChaseOrder.conditionParam); //停止参数
param.Add("@usedPeriod", ttChaseOrder.usedPeriod); //运行期次
param.Add("@usedNum", ttChaseOrder.usedNum); //已追期数
param.Add("@usedFee", ttChaseOrder.usedFee); //已追金额
param.Add("@backNum", ttChaseOrder.backNum); //退款期数
param.Add("@backFee", ttChaseOrder.backFee); //退款金额
param.Add("@awardMoney", ttChaseOrder.awardMoney); //中奖金额
param.Add("@frozenFee", ttChaseOrder.frozenFee); //冻结金额
param.Add("@chaseStatus", ttChaseOrder.chaseStatus); //追号状态
param.Add("@overTime", ttChaseOrder.overTime); //结束时间
param.Add("@createTime", ttChaseOrder.createTime); //创建时间
param.Add("@srcType", ttChaseOrder.srcType); //数据来源方式
param.Add("@chaseOrderId", ttChaseOrder.chaseOrderId); //追号订单号
data.ExecuteNonQuery(CommandType.Text, strSQL, param);
}
