///<summary>
///添加方法，返回Boolean类型，为true表示操作成功，否则操作失败
///生成时间：2011-1-21 20:22:47
///</summary>
public Boolean AddOrderdetaillive(Orderdetaillive orderdetaillive)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?UserName", orderdetaillive.UserName),
new MySqlParameter("?OrderID", orderdetaillive.OrderID),
new MySqlParameter("?time", orderdetaillive.Time),
new MySqlParameter("?leaguecn", orderdetaillive.Leaguecn),
new MySqlParameter("?leaguetw", orderdetaillive.Leaguetw),
new MySqlParameter("?leagueen", orderdetaillive.Leagueen),
new MySqlParameter("?leagueth", orderdetaillive.Leagueth),
new MySqlParameter("?leaguevn", orderdetaillive.Leaguevn),
new MySqlParameter("?Homecn", orderdetaillive.Homecn),
new MySqlParameter("?Hometw", orderdetaillive.Hometw),
new MySqlParameter("?Homeen", orderdetaillive.Homeen),
new MySqlParameter("?Hometh", orderdetaillive.Hometh),
new MySqlParameter("?Homevn", orderdetaillive.Homevn),
new MySqlParameter("?Awaycn", orderdetaillive.Awaycn),
new MySqlParameter("?Awaytw", orderdetaillive.Awaytw),
new MySqlParameter("?Awayen", orderdetaillive.Awayen),
new MySqlParameter("?Awayth", orderdetaillive.Awayth),
new MySqlParameter("?Awayvn", orderdetaillive.Awayvn),
new MySqlParameter("?BeginTime", orderdetaillive.BeginTime),
new MySqlParameter("?BetType", orderdetaillive.BetType),
new MySqlParameter("?IsHalf", orderdetaillive.IsHalf),
new MySqlParameter("?BetItem", orderdetaillive.BetItem),
new MySqlParameter("?Score", orderdetaillive.Score),
new MySqlParameter("?Handicap", orderdetaillive.Handicap),
new MySqlParameter("?Odds", orderdetaillive.Odds),
new MySqlParameter("?OddsType", orderdetaillive.OddsType),
new MySqlParameter("?Amount", orderdetaillive.Amount),
new MySqlParameter("?ValidAmount", orderdetaillive.ValidAmount),
new MySqlParameter("?Status", orderdetaillive.Status),
new MySqlParameter("?Agent", orderdetaillive.Agent),
new MySqlParameter("?AgentPercent", orderdetaillive.AgentPercent),
new MySqlParameter("?AgentCommission", orderdetaillive.AgentCommission),
new MySqlParameter("?ZAgentPercent", orderdetaillive.ZAgentPercent),
new MySqlParameter("?ZAgent", orderdetaillive.ZAgent),
new MySqlParameter("?ZAgentCommission", orderdetaillive.ZAgentCommission),
new MySqlParameter("?PartnerPercent", orderdetaillive.PartnerPercent),
new MySqlParameter("?PartnerCommission", orderdetaillive.PartnerCommission),
new MySqlParameter("?Partner", orderdetaillive.Partner),
new MySqlParameter("?CompanyPercent", orderdetaillive.CompanyPercent),
new MySqlParameter("?CompanyCommission", orderdetaillive.CompanyCommission),
new MySqlParameter("?IP", orderdetaillive.IP),
new MySqlParameter("?SubCompany", orderdetaillive.SubCompany),
new MySqlParameter("?SubCompanyCommission", orderdetaillive.SubCompanyCommission),
new MySqlParameter("?SubCompanyPercent", orderdetaillive.SubCompanyPercent),
new MySqlParameter("?WebSiteiID", orderdetaillive.WebSiteiID),
new MySqlParameter("?UserLevel", orderdetaillive.UserLevel),
new MySqlParameter("?Coefficient", orderdetaillive.Coefficient),
new MySqlParameter("?Proportion", orderdetaillive.Proportion),
new MySqlParameter("?Currency", orderdetaillive.Currency),
new MySqlParameter("?Reason", orderdetaillive.Reason),
new MySqlParameter("?gameid", orderdetaillive.Gameid),
new MySqlParameter("?betflag", orderdetaillive.Betflag),
new MySqlParameter("?MemberPercent", orderdetaillive.MemberPercent),
new MySqlParameter("?MemberCommission", orderdetaillive.MemberCommission)
};
return(MySqlHelper.ExecuteNonQuery(SQL_INSERT, param) > 0);
}
///<sumary>
///修改信息
///时间：2010-9-24 21:00:48
///</sumary>
public static Boolean UpdateOrderdetaillive(Orderdetaillive orderdetaillive)
{
try
{
return(orderdetailliveService.UpdateOrderdetaillive(orderdetaillive));
}
catch (Exception ex)
{
//可以记录到异常日志
return(false);
}
}
public string setUpData(string id, string type, string info, string typeInfo)
{
if (Session[Util.ProjectConfig.ADMINUSER] == null)
{
return("");
}
string[] idlist = id.Split(';');
string[] typeInfolist = typeInfo.Split(';');
for (int i = 0; i < idlist.Length; i++)
{
Orderdetaillive live = OrderdetailliveManager.GetOrderdetailliveByPK(int.Parse(idlist[i]));
if (typeInfolist[i] == "走地全场让球")
{
Orderdetailhdpl hdpl = new Orderdetailhdpl();
hdpl.Agent = live.Agent;
hdpl.AgentCommission = live.AgentCommission;
hdpl.AgentPercent = live.AgentPercent;
hdpl.Amount = live.Amount;
hdpl.Awaycn = live.Awaycn;
hdpl.Awayen = live.Awayen;
hdpl.Awayth = live.Awayth;
hdpl.Awaytw = live.Awaytw;
hdpl.Awayvn = live.Awayvn;
hdpl.BeginTime = live.BeginTime;
hdpl.BetItem = live.BetItem;
hdpl.BetType = live.BetType;
hdpl.Coefficient = live.Coefficient;
hdpl.CompanyCommission = live.CompanyCommission;
hdpl.CompanyPercent = live.CompanyPercent;
hdpl.Currency = live.Currency;
hdpl.Gameid = live.Gameid;
hdpl.Handicap = live.Handicap;
hdpl.Homecn = live.Homecn;
hdpl.Homeen = live.Homeen;
hdpl.Hometh = live.Hometh;
hdpl.Hometw = live.Hometw;
hdpl.Homevn = live.Homevn;
hdpl.IP = live.IP;
hdpl.IsHalf = live.IsHalf;
hdpl.Leaguecn = live.Leaguecn;
hdpl.Leagueen = live.Leagueen;
hdpl.Leagueth = live.Leagueth;
hdpl.Leaguetw = live.Leaguetw;
hdpl.Leaguevn = live.Leaguevn;
hdpl.Odds = live.Odds;
hdpl.OddsType = live.OddsType;
hdpl.OrderID = live.OrderID;
hdpl.Partner = live.Partner;
hdpl.PartnerCommission = live.PartnerCommission;
hdpl.PartnerPercent = live.PartnerPercent;
hdpl.Proportion = live.Proportion;
hdpl.Reason = info;
hdpl.Score = live.Score;
hdpl.Status = type;
hdpl.SubCompany = live.SubCompany;
hdpl.SubCompanyCommission = live.SubCompanyCommission;
hdpl.SubCompanyPercent = live.SubCompanyPercent;
hdpl.Time = live.Time;
hdpl.UserLevel = live.UserLevel;
hdpl.UserName = live.UserName;
hdpl.ValidAmount = live.ValidAmount;
hdpl.WebSiteiID = live.WebSiteiID;
hdpl.ZAgent = live.ZAgent;
hdpl.ZAgentCommission = live.ZAgentCommission;
hdpl.ZAgentPercent = live.ZAgentPercent;
hdpl.Betflag = live.Betflag;
OrderdetailhdplManager.AddOrderdetailhdpl(hdpl);
}
else if (typeInfolist[i] == "走地全场大小")
{
Orderdetailoul loul = new Orderdetailoul();
loul.Agent = live.Agent;
loul.AgentCommission = live.AgentCommission;
loul.AgentPercent = live.AgentPercent;
loul.Amount = live.Amount;
loul.Awaycn = live.Awaycn;
loul.Awayen = live.Awayen;
loul.Awayth = live.Awayth;
loul.Awaytw = live.Awaytw;
loul.Awayvn = live.Awayvn;
loul.BeginTime = live.BeginTime;
loul.BetItem = live.BetItem;
loul.BetType = live.BetType;
loul.Coefficient = live.Coefficient;
loul.CompanyCommission = live.CompanyCommission;
loul.CompanyPercent = live.CompanyPercent;
loul.Currency = live.Currency;
loul.Gameid = live.Gameid;
loul.Handicap = live.Handicap;
loul.Homecn = live.Homecn;
loul.Homeen = live.Homeen;
loul.Hometh = live.Hometh;
loul.Hometw = live.Hometw;
loul.Homevn = live.Homevn;
loul.IP = live.IP;
loul.IsHalf = live.IsHalf;
loul.Leaguecn = live.Leaguecn;
loul.Leagueen = live.Leagueen;
loul.Leagueth = live.Leagueth;
loul.Leaguetw = live.Leaguetw;
loul.Leaguevn = live.Leaguevn;
loul.Odds = live.Odds;
loul.OddsType = live.OddsType;
loul.OrderID = live.OrderID;
loul.Partner = live.Partner;
loul.PartnerCommission = live.PartnerCommission;
loul.PartnerPercent = live.PartnerPercent;
loul.Proportion = live.Proportion;
loul.Reason = info;
loul.Score = live.Score;
loul.Status = type;
loul.SubCompany = live.SubCompany;
loul.SubCompanyCommission = live.SubCompanyCommission;
loul.SubCompanyPercent = live.SubCompanyPercent;
loul.Time = live.Time;
loul.UserLevel = live.UserLevel;
loul.UserName = live.UserName;
loul.ValidAmount = live.ValidAmount;
loul.WebSiteiID = live.WebSiteiID;
loul.ZAgent = live.ZAgent;
loul.ZAgentCommission = live.ZAgentCommission;
loul.ZAgentPercent = live.ZAgentPercent;
loul.Betflag = live.Betflag;
OrderdetailoulManager.AddOrderdetailoul(loul);
}
else if (typeInfolist[i] == "走地全场标准")
{
Orderdetail1x2l lx2l = new Orderdetail1x2l();
lx2l.Agent = live.Agent;
lx2l.AgentCommission = live.AgentCommission;
lx2l.AgentPercent = live.AgentPercent;
lx2l.Amount = live.Amount;
lx2l.Awaycn = live.Awaycn;
lx2l.Awayen = live.Awayen;
lx2l.Awayth = live.Awayth;
lx2l.Awaytw = live.Awaytw;
lx2l.Awayvn = live.Awayvn;
lx2l.BeginTime = live.BeginTime;
lx2l.BetItem = live.BetItem;
lx2l.BetType = live.BetType;
lx2l.Coefficient = live.Coefficient;
lx2l.CompanyCommission = live.CompanyCommission;
lx2l.CompanyPercent = live.CompanyPercent;
lx2l.Currency = live.Currency;
lx2l.Gameid = live.Gameid;
lx2l.Handicap = live.Handicap;
lx2l.Homecn = live.Homecn;
lx2l.Homeen = live.Homeen;
lx2l.Hometh = live.Hometh;
lx2l.Hometw = live.Hometw;
lx2l.Homevn = live.Homevn;
lx2l.IP = live.IP;
lx2l.IsHalf = live.IsHalf;
lx2l.Leaguecn = live.Leaguecn;
lx2l.Leagueen = live.Leagueen;
lx2l.Leagueth = live.Leagueth;
lx2l.Leaguetw = live.Leaguetw;
lx2l.Leaguevn = live.Leaguevn;
lx2l.Odds = live.Odds;
lx2l.OddsType = live.OddsType;
lx2l.OrderID = live.OrderID;
lx2l.Partner = live.Partner;
lx2l.PartnerCommission = live.PartnerCommission;
lx2l.PartnerPercent = live.PartnerPercent;
lx2l.Proportion = live.Proportion;
lx2l.Reason = info;
lx2l.Score = live.Score;
lx2l.Status = type;
lx2l.SubCompany = live.SubCompany;
lx2l.SubCompanyCommission = live.SubCompanyCommission;
lx2l.SubCompanyPercent = live.SubCompanyPercent;
lx2l.Time = live.Time;
lx2l.UserLevel = live.UserLevel;
lx2l.UserName = live.UserName;
lx2l.ValidAmount = live.ValidAmount;
lx2l.WebSiteiID = live.WebSiteiID;
lx2l.ZAgent = live.ZAgent;
lx2l.ZAgentCommission = live.ZAgentCommission;
lx2l.ZAgentPercent = live.ZAgentPercent;
lx2l.Betflag = live.Betflag;
Orderdetail1x2lManager.AddOrderdetail1x2l(lx2l);
}
else if (typeInfolist[i] == "走地半场让球")
{
Orderdetailhdphfl hdphfl = new Orderdetailhdphfl();
hdphfl.Agent = live.Agent;
hdphfl.AgentCommission = live.AgentCommission;
hdphfl.AgentPercent = live.AgentPercent;
hdphfl.Amount = live.Amount;
hdphfl.Awaycn = live.Awaycn;
hdphfl.Awayen = live.Awayen;
hdphfl.Awayth = live.Awayth;
hdphfl.Awaytw = live.Awaytw;
hdphfl.Awayvn = live.Awayvn;
hdphfl.BeginTime = live.BeginTime;
hdphfl.BetItem = live.BetItem;
hdphfl.BetType = live.BetType;
hdphfl.Coefficient = live.Coefficient;
hdphfl.CompanyCommission = live.CompanyCommission;
hdphfl.CompanyPercent = live.CompanyPercent;
hdphfl.Currency = live.Currency;
hdphfl.Gameid = live.Gameid;
hdphfl.Handicap = live.Handicap;
hdphfl.Homecn = live.Homecn;
hdphfl.Homeen = live.Homeen;
hdphfl.Hometh = live.Hometh;
hdphfl.Hometw = live.Hometw;
hdphfl.Homevn = live.Homevn;
hdphfl.IP = live.IP;
hdphfl.IsHalf = live.IsHalf;
hdphfl.Leaguecn = live.Leaguecn;
hdphfl.Leagueen = live.Leagueen;
hdphfl.Leagueth = live.Leagueth;
hdphfl.Leaguetw = live.Leaguetw;
hdphfl.Leaguevn = live.Leaguevn;
hdphfl.Odds = live.Odds;
hdphfl.OddsType = live.OddsType;
hdphfl.OrderID = live.OrderID;
hdphfl.Partner = live.Partner;
hdphfl.PartnerCommission = live.PartnerCommission;
hdphfl.PartnerPercent = live.PartnerPercent;
hdphfl.Proportion = live.Proportion;
hdphfl.Reason = info;
hdphfl.Score = live.Score;
hdphfl.Status = type;
hdphfl.SubCompany = live.SubCompany;
hdphfl.SubCompanyCommission = live.SubCompanyCommission;
hdphfl.SubCompanyPercent = live.SubCompanyPercent;
hdphfl.Time = live.Time;
hdphfl.UserLevel = live.UserLevel;
hdphfl.UserName = live.UserName;
hdphfl.ValidAmount = live.ValidAmount;
hdphfl.WebSiteiID = live.WebSiteiID;
hdphfl.ZAgent = live.ZAgent;
hdphfl.ZAgentCommission = live.ZAgentCommission;
hdphfl.ZAgentPercent = live.ZAgentPercent;
hdphfl.Betflag = live.Betflag;
OrderdetailhdphflManager.AddOrderdetailhdphfl(hdphfl);
}
else if (typeInfolist[i] == "走地半场大小")
{
Orderdetailouhfl louhfl = new Orderdetailouhfl();
louhfl.Agent = live.Agent;
louhfl.AgentCommission = live.AgentCommission;
louhfl.AgentPercent = live.AgentPercent;
louhfl.Amount = live.Amount;
louhfl.Awaycn = live.Awaycn;
louhfl.Awayen = live.Awayen;
louhfl.Awayth = live.Awayth;
louhfl.Awaytw = live.Awaytw;
louhfl.Awayvn = live.Awayvn;
louhfl.BeginTime = live.BeginTime;
louhfl.BetItem = live.BetItem;
louhfl.BetType = live.BetType;
louhfl.Coefficient = live.Coefficient;
louhfl.CompanyCommission = live.CompanyCommission;
louhfl.CompanyPercent = live.CompanyPercent;
louhfl.Currency = live.Currency;
louhfl.Gameid = live.Gameid;
louhfl.Handicap = live.Handicap;
louhfl.Homecn = live.Homecn;
louhfl.Homeen = live.Homeen;
louhfl.Hometh = live.Hometh;
louhfl.Hometw = live.Hometw;
louhfl.Homevn = live.Homevn;
louhfl.IP = live.IP;
louhfl.IsHalf = live.IsHalf;
louhfl.Leaguecn = live.Leaguecn;
louhfl.Leagueen = live.Leagueen;
louhfl.Leagueth = live.Leagueth;
louhfl.Leaguetw = live.Leaguetw;
louhfl.Leaguevn = live.Leaguevn;
louhfl.Odds = live.Odds;
louhfl.OddsType = live.OddsType;
louhfl.OrderID = live.OrderID;
louhfl.Partner = live.Partner;
louhfl.PartnerCommission = live.PartnerCommission;
louhfl.PartnerPercent = live.PartnerPercent;
louhfl.Proportion = live.Proportion;
louhfl.Reason = info;
louhfl.Score = live.Score;
louhfl.Status = type;
louhfl.SubCompany = live.SubCompany;
louhfl.SubCompanyCommission = live.SubCompanyCommission;
louhfl.SubCompanyPercent = live.SubCompanyPercent;
louhfl.Time = live.Time;
louhfl.UserLevel = live.UserLevel;
louhfl.UserName = live.UserName;
louhfl.ValidAmount = live.ValidAmount;
louhfl.WebSiteiID = live.WebSiteiID;
louhfl.ZAgent = live.ZAgent;
louhfl.ZAgentCommission = live.ZAgentCommission;
louhfl.ZAgentPercent = live.ZAgentPercent;
louhfl.Betflag = live.Betflag;
OrderdetailouhflManager.AddOrderdetailouhfl(louhfl);
}
else if (typeInfolist[i] == "走地半场标准")
{
Orderdetail1x2hfl lx2hfl = new Orderdetail1x2hfl();
lx2hfl.Agent = live.Agent;
lx2hfl.AgentCommission = live.AgentCommission;
lx2hfl.AgentPercent = live.AgentPercent;
lx2hfl.Amount = live.Amount;
lx2hfl.Awaycn = live.Awaycn;
lx2hfl.Awayen = live.Awayen;
lx2hfl.Awayth = live.Awayth;
lx2hfl.Awaytw = live.Awaytw;
lx2hfl.Awayvn = live.Awayvn;
lx2hfl.BeginTime = live.BeginTime;
lx2hfl.BetItem = live.BetItem;
lx2hfl.BetType = live.BetType;
lx2hfl.Coefficient = live.Coefficient;
lx2hfl.CompanyCommission = live.CompanyCommission;
lx2hfl.CompanyPercent = live.CompanyPercent;
lx2hfl.Currency = live.Currency;
lx2hfl.Gameid = live.Gameid;
lx2hfl.Handicap = live.Handicap;
lx2hfl.Homecn = live.Homecn;
lx2hfl.Homeen = live.Homeen;
lx2hfl.Hometh = live.Hometh;
lx2hfl.Hometw = live.Hometw;
lx2hfl.Homevn = live.Homevn;
lx2hfl.IP = live.IP;
lx2hfl.IsHalf = live.IsHalf;
lx2hfl.Leaguecn = live.Leaguecn;
lx2hfl.Leagueen = live.Leagueen;
lx2hfl.Leagueth = live.Leagueth;
lx2hfl.Leaguetw = live.Leaguetw;
lx2hfl.Leaguevn = live.Leaguevn;
lx2hfl.Odds = live.Odds;
lx2hfl.OddsType = live.OddsType;
lx2hfl.OrderID = live.OrderID;
lx2hfl.Partner = live.Partner;
lx2hfl.PartnerCommission = live.PartnerCommission;
lx2hfl.PartnerPercent = live.PartnerPercent;
lx2hfl.Proportion = live.Proportion;
lx2hfl.Reason = info;
lx2hfl.Score = live.Score;
lx2hfl.Status = type;
lx2hfl.SubCompany = live.SubCompany;
lx2hfl.SubCompanyCommission = live.SubCompanyCommission;
lx2hfl.SubCompanyPercent = live.SubCompanyPercent;
lx2hfl.Time = live.Time;
lx2hfl.UserLevel = live.UserLevel;
lx2hfl.UserName = live.UserName;
lx2hfl.ValidAmount = live.ValidAmount;
lx2hfl.WebSiteiID = live.WebSiteiID;
lx2hfl.ZAgent = live.ZAgent;
lx2hfl.ZAgentCommission = live.ZAgentCommission;
lx2hfl.ZAgentPercent = live.ZAgentPercent;
lx2hfl.Betflag = live.Betflag;
Orderdetail1x2hflManager.AddOrderdetail1x2hfl(lx2hfl);
}
if (type == "0")
{
Orderdetail1x2hflManager.setBalance(live.UserName, live.Odds < 0 ? live.ValidAmount.ToString() : live.Amount.ToString());
}
OrderdetailliveManager.DeleteOrderdetailliveByPK(int.Parse(idlist[i]));
}
return("none");
}
public List <Orderdetaillive> GetOrderAllByWhere(string whereSql)
{
List <Orderdetaillive> order = new List <Orderdetaillive>();
if (whereSql == "")
{
return(order);
}
string str = "select * from orderdetaillive where " + whereSql;
MySqlDataReader reder = MySqlHelper.ExecuteReader(str);
while (reder.Read())
{
Orderdetaillive or = new Orderdetaillive();
or.ID = Convert.ToInt32(reder.GetString("ID"));
or.Agent = Convert.ToString(reder.GetString("Agent"));
or.AgentCommission = Convert.ToDecimal(reder.GetString("AgentCommission"));
or.AgentPercent = Convert.ToDecimal(reder.GetString("AgentPercent"));
or.Amount = Convert.ToDecimal(reder.GetString("Amount"));
or.Awaycn = Convert.ToString(reder.GetString("Awaycn"));
or.Awayen = Convert.ToString(reder.GetString("Awayen"));
or.Awayth = Convert.ToString(reder.GetString("Awayth"));
or.Awaytw = Convert.ToString(reder.GetString("Awaytw"));
or.Awayvn = Convert.ToString(reder.GetString("Awayvn"));
or.BeginTime = Convert.ToDateTime(reder.GetString("BeginTime"));
or.BetItem = Convert.ToString(reder.GetString("BetItem"));
or.BetType = Convert.ToString(reder.GetString("BetType"));
or.Coefficient = Convert.ToDecimal(reder.GetString("Coefficient"));
or.CompanyCommission = Convert.ToDecimal(reder.GetString("CompanyCommission"));
or.CompanyPercent = Convert.ToDecimal(reder.GetString("CompanyPercent"));
or.Currency = Convert.ToString(reder.GetString("Currency"));
or.Gameid = Convert.ToInt32(reder.GetString("gameid"));
or.Handicap = Convert.ToString(reder.GetString("Handicap"));
or.Homecn = Convert.ToString(reder.GetString("Homecn"));
or.Homeen = Convert.ToString(reder.GetString("Homeen"));
or.Hometh = Convert.ToString(reder.GetString("Hometh"));
or.Hometw = Convert.ToString(reder.GetString("Hometw"));
or.Homevn = Convert.ToString(reder.GetString("Homevn"));
or.IP = Convert.ToString(reder.GetString("IP"));
or.IsHalf = Convert.ToString(reder.GetString("IsHalf"));
or.Leaguecn = Convert.ToString(reder.GetString("leaguecn"));
or.Leagueen = Convert.ToString(reder.GetString("leagueen"));
or.Leagueth = Convert.ToString(reder.GetString("leagueth"));
or.Leaguetw = Convert.ToString(reder.GetString("leaguetw"));
or.Leaguevn = Convert.ToString(reder.GetString("leaguevn"));
or.Odds = Convert.ToDecimal(reder.GetString("Odds"));
or.OddsType = Convert.ToString(reder.GetString("OddsType"));
or.OrderID = Convert.ToString(reder.GetString("OrderID"));
or.Partner = Convert.ToString(reder.GetString("Partner"));
or.PartnerCommission = Convert.ToDecimal(reder.GetString("PartnerCommission"));
or.PartnerPercent = Convert.ToDecimal(reder.GetString("PartnerPercent"));
or.Proportion = Convert.ToDecimal(reder.GetString("Proportion"));
or.Reason = Convert.ToString(reder.GetString("Reason"));
or.Score = Convert.ToString(reder.GetString("Score"));
or.Status = Convert.ToString(reder.GetString("Status"));
or.SubCompany = Convert.ToString(reder.GetString("SubCompany"));
or.SubCompanyCommission = Convert.ToDecimal(reder.GetString("SubCompanyCommission"));
or.SubCompanyPercent = Convert.ToDecimal(reder.GetString("SubCompanyPercent"));
or.Time = Convert.ToDateTime(reder.GetString("time"));
or.UserLevel = Convert.ToString(reder.GetString("UserLevel"));
or.UserName = Convert.ToString(reder.GetString("UserName"));
or.ValidAmount = Convert.ToDecimal(reder.GetString("ValidAmount"));
or.WebSiteiID = Convert.ToInt32(reder.GetString("WebSiteiID"));
or.ZAgent = Convert.ToString(reder.GetString("ZAgent"));
or.ZAgentCommission = Convert.ToDecimal(reder.GetString("ZAgentCommission"));
or.ZAgentPercent = Convert.ToDecimal(reder.GetString("ZAgentPercent"));
or.Betflag = Convert.ToString(reder.GetString("betflag"));
or.MemberPercent = Convert.ToDecimal(reder.GetString("MemberPercent"));
or.MemberCommission = Convert.ToDecimal(reder.GetString("MemberCommission"));
order.Add(or);
}
return(order);
}
