//me_取得每个玩家投注的记录进行排序33
public IList <BCW.XinKuai3.Model.XK3_Bet> GetXK3_Bet_playnum3(int p_pageIndex, int p_pageSize, string strWhere, out int p_recordCount)
{
IList <BCW.XinKuai3.Model.XK3_Bet> listXK3_Bets = new List <BCW.XinKuai3.Model.XK3_Bet>();
string sTable = "tb_XK3_Bet";
string sPkey = "";
string sField = "UsID,count(UsID) as bb";
string sCondition = strWhere;
string sOrder = "";
int iSCounts = 0;
using (SqlDataReader reader = SqlHelper.RunProcedureMe(sTable, sPkey, sField, p_pageIndex, p_pageSize, sCondition, sOrder, iSCounts, out p_recordCount))
{
//计算总页数
if (p_recordCount > 0)
{
int pageCount = BasePage.CalcPageCount(p_recordCount, p_pageSize, ref p_pageIndex);
}
else
{
return(listXK3_Bets);
}
while (reader.Read())
{
BCW.XinKuai3.Model.XK3_Bet objXK3_Bet = new BCW.XinKuai3.Model.XK3_Bet();
objXK3_Bet.UsID = reader.GetInt32(0);
objXK3_Bet.bb = reader.GetInt32(1);
listXK3_Bets.Add(objXK3_Bet);
}
}
return(listXK3_Bets);
}
/// <summary>
/// me_根据所点的历史记录，通过开奖期号查询相应的投注情况
/// </summary>
public BCW.XinKuai3.Model.XK3_Bet GetXK3_Bet_hounum(string Lottery_issue)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select COUNT(*) as aa from tb_XK3_Bet ");
strSql.Append(" where Lottery_issue=@Lottery_issue ");
SqlParameter[] parameters =
{
new SqlParameter("@Lottery_issue", SqlDbType.VarChar, 20)
};
parameters[0].Value = Lottery_issue;
BCW.XinKuai3.Model.XK3_Bet model = new BCW.XinKuai3.Model.XK3_Bet();
using (SqlDataReader reader = SqlHelper.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
model.aa = reader.GetInt32(0);
return(model);
}
else
{
return(null);
}
}
}
/// <summary>
/// me_取得每页记录
/// </summary>
/// <param name="p_pageIndex">当前页</param>
/// <param name="p_pageSize">分页大小</param>
/// <param name="p_recordCount">返回总记录数</param>
/// <param name="strWhere">查询条件</param>
/// <returns>IList XK3_Bet</returns>
public IList <BCW.XinKuai3.Model.XK3_Bet> GetXK3_Bets(int p_pageIndex, int p_pageSize, string strWhere, out int p_recordCount)
{
IList <BCW.XinKuai3.Model.XK3_Bet> listXK3_Bets = new List <BCW.XinKuai3.Model.XK3_Bet>();
string sTable = "tb_XK3_Bet";
string sPkey = "id";
string sField = "ID,UsID,Play_Way,Sum,Three_Same_All,Three_Same_Single,Three_Same_Not,Three_Continue_All,Two_Same_All,Two_Same_Single,Two_dissame,Input_Time,DanTuo,Zhu,GetMoney,PutGold,State,Lottery_issue,Zhu_money,DaXiao,DanShuang";
string sCondition = strWhere;
string sOrder = "ID Desc";
int iSCounts = 0;
using (SqlDataReader reader = SqlHelper.RunProcedureMe(sTable, sPkey, sField, p_pageIndex, p_pageSize, sCondition, sOrder, iSCounts, out p_recordCount))
{
//计算总页数
if (p_recordCount > 0)
{
int pageCount = BasePage.CalcPageCount(p_recordCount, p_pageSize, ref p_pageIndex);
}
else
{
return(listXK3_Bets);
}
while (reader.Read())
{
BCW.XinKuai3.Model.XK3_Bet objXK3_Bet = new BCW.XinKuai3.Model.XK3_Bet();
objXK3_Bet.ID = reader.GetInt32(0);
objXK3_Bet.UsID = reader.GetInt32(1);
objXK3_Bet.Play_Way = reader.GetInt32(2);
objXK3_Bet.Sum = reader.GetString(3);
objXK3_Bet.Three_Same_All = reader.GetString(4);
objXK3_Bet.Three_Same_Single = reader.GetString(5);
objXK3_Bet.Three_Same_Not = reader.GetString(6);
objXK3_Bet.Three_Continue_All = reader.GetString(7);
objXK3_Bet.Two_Same_All = reader.GetString(8);
objXK3_Bet.Two_Same_Single = reader.GetString(9);
objXK3_Bet.Two_dissame = reader.GetString(10);
objXK3_Bet.Input_Time = reader.GetDateTime(11);
objXK3_Bet.DanTuo = reader.GetString(12);
objXK3_Bet.Zhu = reader.GetInt32(13);
objXK3_Bet.GetMoney = reader.GetInt64(14);
objXK3_Bet.PutGold = reader.GetInt64(15);
objXK3_Bet.State = reader.GetInt32(16);
objXK3_Bet.Lottery_issue = reader.GetString(17);
objXK3_Bet.Zhu_money = reader.GetInt64(18);
objXK3_Bet.DaXiao = reader.GetString(19);
objXK3_Bet.DanShuang = reader.GetString(20);
//objXK3_Bet.Odds = reader.GetDecimal(21);
listXK3_Bets.Add(objXK3_Bet);
}
}
return(listXK3_Bets);
}
/// <summary>
/// me_根据所点的历史记录，通过开奖期号查询相应的投注情况
/// </summary>
public BCW.XinKuai3.Model.XK3_Bet GetXK3_Bet_num(string Lottery_issue)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select * from tb_XK3_Bet ");
strSql.Append(" where Lottery_issue=@Lottery_issue ");
SqlParameter[] parameters =
{
new SqlParameter("@Lottery_issue", SqlDbType.VarChar, 20)
};
parameters[0].Value = Lottery_issue;
BCW.XinKuai3.Model.XK3_Bet model = new BCW.XinKuai3.Model.XK3_Bet();
using (SqlDataReader reader = SqlHelper.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
model.ID = reader.GetInt32(0);
model.UsID = reader.GetInt32(1);
model.Play_Way = reader.GetInt32(2);
model.Sum = reader.GetString(3);
model.Three_Same_All = reader.GetString(4);
model.Three_Same_Single = reader.GetString(5);
model.Three_Same_Not = reader.GetString(6);
model.Three_Continue_All = reader.GetString(7);
model.Two_Same_All = reader.GetString(8);
model.Two_Same_Single = reader.GetString(9);
model.Two_dissame = reader.GetString(10);
model.Input_Time = reader.GetDateTime(11);
model.DanTuo = reader.GetString(12);
model.Zhu = reader.GetInt32(13);
model.GetMoney = reader.GetInt64(14);
model.PutGold = reader.GetInt64(15);
model.State = reader.GetInt32(16);
model.Lottery_issue = reader.GetString(17);
model.Zhu_money = reader.GetInt64(18);
model.DaXiao = reader.GetString(19);
model.DanShuang = reader.GetString(20);
//model.Odds = reader.GetDecimal(21);
return(model);
}
else
{
return(null);
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BCW.XinKuai3.Model.XK3_Bet model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_XK3_Bet(");
strSql.Append("UsID,Play_Way,Sum,Three_Same_All,Three_Same_Single,Three_Same_Not,Three_Continue_All,Two_Same_All,Two_Same_Single,Two_dissame,Input_Time,DanTuo,Zhu,GetMoney,PutGold,State,Lottery_issue,Zhu_money,DaXiao,DanShuang,Odds)");
strSql.Append(" values (");
strSql.Append("@UsID,@Play_Way,@Sum,@Three_Same_All,@Three_Same_Single,@Three_Same_Not,@Three_Continue_All,@Two_Same_All,@Two_Same_Single,@Two_dissame,@Input_Time,@DanTuo,@Zhu,@GetMoney,@PutGold,@State,@Lottery_issue,@Zhu_money,@DaXiao,@DanShuang,@Odds)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UsID", SqlDbType.Int, 4),
new SqlParameter("@Play_Way", SqlDbType.Int, 4),
new SqlParameter("@Sum", SqlDbType.VarChar, 60),
new SqlParameter("@Three_Same_All", SqlDbType.VarChar, 30),
new SqlParameter("@Three_Same_Single", SqlDbType.VarChar, 30),
new SqlParameter("@Three_Same_Not", SqlDbType.VarChar, 100),
new SqlParameter("@Three_Continue_All", SqlDbType.VarChar, 30),
new SqlParameter("@Two_Same_All", SqlDbType.VarChar, 30),
new SqlParameter("@Two_Same_Single", SqlDbType.VarChar, 100),
new SqlParameter("@Two_dissame", SqlDbType.VarChar, 100),
new SqlParameter("@Input_Time", SqlDbType.DateTime),
new SqlParameter("@DanTuo", SqlDbType.VarChar, 20),
new SqlParameter("@Zhu", SqlDbType.Int, 4),
new SqlParameter("@GetMoney", SqlDbType.BigInt, 8),
new SqlParameter("@PutGold", SqlDbType.BigInt, 8),
new SqlParameter("@State", SqlDbType.Int, 4),
new SqlParameter("@Lottery_issue", SqlDbType.VarChar, 20),
new SqlParameter("@Zhu_money", SqlDbType.BigInt, 8),
new SqlParameter("@DaXiao", SqlDbType.VarChar, 10),
new SqlParameter("@DanShuang", SqlDbType.VarChar, 10),
new SqlParameter("@Odds", SqlDbType.Float, 8)
};
parameters[0].Value = model.UsID;
parameters[1].Value = model.Play_Way;
parameters[2].Value = model.Sum;
parameters[3].Value = model.Three_Same_All;
parameters[4].Value = model.Three_Same_Single;
parameters[5].Value = model.Three_Same_Not;
parameters[6].Value = model.Three_Continue_All;
parameters[7].Value = model.Two_Same_All;
parameters[8].Value = model.Two_Same_Single;
parameters[9].Value = model.Two_dissame;
parameters[10].Value = model.Input_Time;
parameters[11].Value = model.DanTuo;
parameters[12].Value = model.Zhu;
parameters[13].Value = model.GetMoney;
parameters[14].Value = model.PutGold;
parameters[15].Value = model.State;
parameters[16].Value = model.Lottery_issue;
parameters[17].Value = model.Zhu_money;
parameters[18].Value = model.DaXiao;
parameters[19].Value = model.DanShuang;
parameters[20].Value = model.Odds;
object obj = SqlHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(BCW.XinKuai3.Model.XK3_Bet model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_XK3_Bet set ");
strSql.Append("UsID=@UsID,");
strSql.Append("Play_Way=@Play_Way,");
strSql.Append("Sum=@Sum,");
strSql.Append("Three_Same_All=@Three_Same_All,");
strSql.Append("Three_Same_Single=@Three_Same_Single,");
strSql.Append("Three_Same_Not=@Three_Same_Not,");
strSql.Append("Three_Continue_All=@Three_Continue_All,");
strSql.Append("Two_Same_All=@Two_Same_All,");
strSql.Append("Two_Same_Single=@Two_Same_Single,");
strSql.Append("Two_dissame=@Two_dissame,");
strSql.Append("Input_Time=@Input_Time,");
strSql.Append("DanTuo=@DanTuo,");
strSql.Append("Zhu=@Zhu,");
strSql.Append("GetMoney=@GetMoney,");
strSql.Append("PutGold=@PutGold,");
strSql.Append("State=@State,");
strSql.Append("Lottery_issue=@Lottery_issue,");
strSql.Append("Zhu_money=@Zhu_money,");
strSql.Append("DaXiao=@DaXiao,");
strSql.Append("DanShuang=@DanShuang,");
strSql.Append("Odds=@Odds");
strSql.Append(" where ID=@ID ");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@UsID", SqlDbType.Int, 4),
new SqlParameter("@Play_Way", SqlDbType.Int, 4),
new SqlParameter("@Sum", SqlDbType.VarChar, 60),
new SqlParameter("@Three_Same_All", SqlDbType.VarChar, 30),
new SqlParameter("@Three_Same_Single", SqlDbType.VarChar, 30),
new SqlParameter("@Three_Same_Not", SqlDbType.VarChar, 100),
new SqlParameter("@Three_Continue_All", SqlDbType.VarChar, 30),
new SqlParameter("@Two_Same_All", SqlDbType.VarChar, 30),
new SqlParameter("@Two_Same_Single", SqlDbType.VarChar, 100),
new SqlParameter("@Two_dissame", SqlDbType.VarChar, 100),
new SqlParameter("@Input_Time", SqlDbType.DateTime),
new SqlParameter("@DanTuo", SqlDbType.VarChar, 20),
new SqlParameter("@Zhu", SqlDbType.Int, 4),
new SqlParameter("@GetMoney", SqlDbType.BigInt, 8),
new SqlParameter("@PutGold", SqlDbType.BigInt, 8),
new SqlParameter("@State", SqlDbType.Int, 4),
new SqlParameter("@Lottery_issue", SqlDbType.VarChar, 20),
new SqlParameter("@Zhu_money", SqlDbType.BigInt, 8),
new SqlParameter("@DaXiao", SqlDbType.VarChar, 10),
new SqlParameter("@DanShuang", SqlDbType.VarChar, 10),
new SqlParameter("@Odds", SqlDbType.Float, 8)
};
parameters[0].Value = model.ID;
parameters[1].Value = model.UsID;
parameters[2].Value = model.Play_Way;
parameters[3].Value = model.Sum;
parameters[4].Value = model.Three_Same_All;
parameters[5].Value = model.Three_Same_Single;
parameters[6].Value = model.Three_Same_Not;
parameters[7].Value = model.Three_Continue_All;
parameters[8].Value = model.Two_Same_All;
parameters[9].Value = model.Two_Same_Single;
parameters[10].Value = model.Two_dissame;
parameters[11].Value = model.Input_Time;
parameters[12].Value = model.DanTuo;
parameters[13].Value = model.Zhu;
parameters[14].Value = model.GetMoney;
parameters[15].Value = model.PutGold;
parameters[16].Value = model.State;
parameters[17].Value = model.Lottery_issue;
parameters[18].Value = model.Zhu_money;
parameters[19].Value = model.DaXiao;
parameters[20].Value = model.DanShuang;
parameters[21].Value = model.Odds;
SqlHelper.ExecuteSql(strSql.ToString(), parameters);
}
