///<sumary>
///修改信息
///时间：2010-9-24 21:04:21
///</sumary>
public static Boolean UpdateOrderother(Orderother orderother)
{
try
{
return(orderotherService.UpdateOrderother(orderother));
}
catch (Exception ex)
{
//可以记录到异常日志
return(false);
}
}
public List <Orderother> getorderotherAll(int id)
{
List <Orderother> order = new List <Orderother>();
string str = "select * from orderother where gameid=" + id + "";
MySqlDataReader reder = MySqlHelper.ExecuteReader(str);
while (reder.Read())
{
Orderother or = new Orderother();
or.ID = Convert.ToInt32(reder.GetString("ID"));
or.Agent = Convert.ToString(reder.GetString("Agent"));
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.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.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.Score = Convert.ToString(reder.GetString("Score"));
or.Status = Convert.ToString(reder.GetString("Status"));
or.Time = Convert.ToDateTime(reder.GetString("time"));
or.UserName = Convert.ToString(reder.GetString("UserName"));
or.ValidAmount = Convert.ToDecimal(reder.GetString("ValidAmount"));
or.WebSiteiID = Convert.ToInt32(reder.GetString("WebSiteiID"));
or.Betflag = Convert.ToString(reder.GetString("betflag"));
order.Add(or);
}
return(order);
}
///<summary>
///修改方法，返回Boolean类型，为true表示操作成功，否则操作失败
///生成时间：2010-9-24 21:04:12
///</summary>
public Boolean UpdateOrderother(Orderother orderother)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?UserName", orderother.UserName),
new MySqlParameter("?WebUserName", orderother.WebUserName),
new MySqlParameter("?OrderID", orderother.OrderID),
new MySqlParameter("?WebOrderID", orderother.WebOrderID),
new MySqlParameter("?time", orderother.Time),
new MySqlParameter("?leaguecn", orderother.Leaguecn),
new MySqlParameter("?leaguetw", orderother.Leaguetw),
new MySqlParameter("?leagueen", orderother.Leagueen),
new MySqlParameter("?leagueth", orderother.Leagueth),
new MySqlParameter("?leaguevn", orderother.Leaguevn),
new MySqlParameter("?BeginTime", orderother.BeginTime),
new MySqlParameter("?BetType", orderother.BetType),
new MySqlParameter("?IsHalf", orderother.IsHalf),
new MySqlParameter("?BetItem", orderother.BetItem),
new MySqlParameter("?Score", orderother.Score),
new MySqlParameter("?Awaycn", orderother.Awaycn),
new MySqlParameter("?Awaytw", orderother.Awaytw),
new MySqlParameter("?Awayen", orderother.Awayen),
new MySqlParameter("?Awayth", orderother.Awayth),
new MySqlParameter("?Awayvn", orderother.Awayvn),
new MySqlParameter("?Homecn", orderother.Homecn),
new MySqlParameter("?Hometw", orderother.Hometw),
new MySqlParameter("?Homeen", orderother.Homeen),
new MySqlParameter("?Hometh", orderother.Hometh),
new MySqlParameter("?Homevn", orderother.Homevn),
new MySqlParameter("?Handicap", orderother.Handicap),
new MySqlParameter("?OddsType", orderother.OddsType),
new MySqlParameter("?Odds", orderother.Odds),
new MySqlParameter("?Amount", orderother.Amount),
new MySqlParameter("?ValidAmount", orderother.ValidAmount),
new MySqlParameter("?Status", orderother.Status),
new MySqlParameter("?WebSiteiID", orderother.WebSiteiID),
new MySqlParameter("?agent", orderother.Agent),
new MySqlParameter("?websitepossess", orderother.Websitepossess),
new MySqlParameter("?selfpossess", orderother.Selfpossess),
new MySqlParameter("?commission", orderother.Commission),
new MySqlParameter("?multiple", orderother.Multiple),
new MySqlParameter("?gameid", orderother.Gameid),
new MySqlParameter("?ID", orderother.ID)
};
return(MySqlHelper.ExecuteNonQuery(SQL_UPDATE, param) > 0);
}
