///<summary>
///添加方法，返回Boolean类型，为true表示操作成功，否则操作失败
///生成时间：2011-1-21 20:17:30
///</summary>
public Boolean AddOrderdetail1x2(Orderdetail1x2 orderdetail1x2)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?UserName", orderdetail1x2.UserName),
new MySqlParameter("?OrderID", orderdetail1x2.OrderID),
new MySqlParameter("?time", orderdetail1x2.Time),
new MySqlParameter("?leaguecn", orderdetail1x2.Leaguecn),
new MySqlParameter("?leaguetw", orderdetail1x2.Leaguetw),
new MySqlParameter("?leagueen", orderdetail1x2.Leagueen),
new MySqlParameter("?leagueth", orderdetail1x2.Leagueth),
new MySqlParameter("?leaguevn", orderdetail1x2.Leaguevn),
new MySqlParameter("?Homecn", orderdetail1x2.Homecn),
new MySqlParameter("?Hometw", orderdetail1x2.Hometw),
new MySqlParameter("?Homeen", orderdetail1x2.Homeen),
new MySqlParameter("?Hometh", orderdetail1x2.Hometh),
new MySqlParameter("?Homevn", orderdetail1x2.Homevn),
new MySqlParameter("?Awaycn", orderdetail1x2.Awaycn),
new MySqlParameter("?Awaytw", orderdetail1x2.Awaytw),
new MySqlParameter("?Awayen", orderdetail1x2.Awayen),
new MySqlParameter("?Awayth", orderdetail1x2.Awayth),
new MySqlParameter("?Awayvn", orderdetail1x2.Awayvn),
new MySqlParameter("?BeginTime", orderdetail1x2.BeginTime),
new MySqlParameter("?BetType", orderdetail1x2.BetType),
new MySqlParameter("?IsHalf", orderdetail1x2.IsHalf),
new MySqlParameter("?BetItem", orderdetail1x2.BetItem),
new MySqlParameter("?Score", orderdetail1x2.Score),
new MySqlParameter("?Handicap", orderdetail1x2.Handicap),
new MySqlParameter("?Odds", orderdetail1x2.Odds),
new MySqlParameter("?OddsType", orderdetail1x2.OddsType),
new MySqlParameter("?Amount", orderdetail1x2.Amount),
new MySqlParameter("?ValidAmount", orderdetail1x2.ValidAmount),
new MySqlParameter("?Status", orderdetail1x2.Status),
new MySqlParameter("?Agent", orderdetail1x2.Agent),
new MySqlParameter("?AgentPercent", orderdetail1x2.AgentPercent),
new MySqlParameter("?AgentCommission", orderdetail1x2.AgentCommission),
new MySqlParameter("?ZAgentPercent", orderdetail1x2.ZAgentPercent),
new MySqlParameter("?ZAgent", orderdetail1x2.ZAgent),
new MySqlParameter("?ZAgentCommission", orderdetail1x2.ZAgentCommission),
new MySqlParameter("?PartnerPercent", orderdetail1x2.PartnerPercent),
new MySqlParameter("?PartnerCommission", orderdetail1x2.PartnerCommission),
new MySqlParameter("?Partner", orderdetail1x2.Partner),
new MySqlParameter("?CompanyPercent", orderdetail1x2.CompanyPercent),
new MySqlParameter("?CompanyCommission", orderdetail1x2.CompanyCommission),
new MySqlParameter("?IP", orderdetail1x2.IP),
new MySqlParameter("?SubCompany", orderdetail1x2.SubCompany),
new MySqlParameter("?SubCompanyCommission", orderdetail1x2.SubCompanyCommission),
new MySqlParameter("?SubCompanyPercent", orderdetail1x2.SubCompanyPercent),
new MySqlParameter("?WebSiteiID", orderdetail1x2.WebSiteiID),
new MySqlParameter("?UserLevel", orderdetail1x2.UserLevel),
new MySqlParameter("?Coefficient", orderdetail1x2.Coefficient),
new MySqlParameter("?Proportion", orderdetail1x2.Proportion),
new MySqlParameter("?Currency", orderdetail1x2.Currency),
new MySqlParameter("?Reason", orderdetail1x2.Reason),
new MySqlParameter("?gameid", orderdetail1x2.Gameid),
new MySqlParameter("?betflag", orderdetail1x2.Betflag),
new MySqlParameter("?MemberPercent", orderdetail1x2.MemberPercent),
new MySqlParameter("?MemberCommission", orderdetail1x2.MemberCommission)
};
return(MySqlHelper.ExecuteNonQuery(SQL_INSERT, param) > 0);
}
///<sumary>
///修改信息
///时间：2010-9-24 20:55:49
///</sumary>
public static Boolean UpdateOrderdetail1x2(Orderdetail1x2 orderdetail1x2)
{
try
{
return(orderdetail1x2Service.UpdateOrderdetail1x2(orderdetail1x2));
}
catch (Exception ex)
{
//可以记录到异常日志
return(false);
}
}
public List <Orderdetail1x2> getOrderAllByWhere(string whereSql)
{
List <Orderdetail1x2> order = new List <Orderdetail1x2>();
if (whereSql == "")
{
return(order);
}
string str = "select * from orderall_v where " + whereSql;
MySqlDataReader reder = MySqlHelper.ExecuteReader(str);
while (reder.Read())
{
Orderdetail1x2 or = new Orderdetail1x2();
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"));
or.Rate = Convert.ToDecimal(reder.GetString("rate"));
order.Add(or);
}
return(order);
}
