/// <summary>
/// 更新一条数据
/// </summary>
public void Update(BCW.Model.tb_WinnersLists model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_WinnersLists set ");
strSql.Append("awardId=@awardId,");
strSql.Append("UserId=@UserId,");
strSql.Append("winGold=@winGold,");
strSql.Append("GetId=@GetId,");
strSql.Append("FromId=@FromId,");
strSql.Append("TabelId=@TabelId,");
strSql.Append("GameName=@GameName,");
strSql.Append("AddTime=@AddTime,");
strSql.Append("isGet=@isGet,");
strSql.Append("overTime=@overTime,");
strSql.Append("Remarks=@Remarks,");
strSql.Append("Ident=@Ident");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.BigInt, 8),
new SqlParameter("@awardId", SqlDbType.Int, 4),
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@winGold", SqlDbType.Int, 4),
new SqlParameter("@GetId", SqlDbType.Int, 4),
new SqlParameter("@FromId", SqlDbType.Int, 4),
new SqlParameter("@TabelId", SqlDbType.Int, 4),
new SqlParameter("@GameName", SqlDbType.NChar, 10),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@isGet", SqlDbType.Int, 4),
new SqlParameter("@overTime", SqlDbType.Int, 4),
new SqlParameter("@Remarks", SqlDbType.NVarChar, 50),
new SqlParameter("@Ident", SqlDbType.Int, 4)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.awardId;
parameters[2].Value = model.UserId;
parameters[3].Value = model.winGold;
parameters[4].Value = model.GetId;
parameters[5].Value = model.FromId;
parameters[6].Value = model.TabelId;
parameters[7].Value = model.GameName;
parameters[8].Value = model.AddTime;
parameters[9].Value = model.isGet;
parameters[10].Value = model.overTime;
parameters[11].Value = model.Remarks;
parameters[12].Value = model.Ident;
SqlHelper.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BCW.Model.tb_WinnersLists model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_WinnersLists(");
strSql.Append("awardId,UserId,winGold,GetId,FromId,TabelId,GameName,AddTime,isGet,overTime,Remarks,Ident)");
strSql.Append(" values (");
strSql.Append("@awardId,@UserId,@winGold,@GetId,@FromId,@TabelId,@GameName,@AddTime,@isGet,@overTime,@Remarks,@Ident)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@awardId", SqlDbType.Int, 4),
new SqlParameter("@UserId", SqlDbType.Int, 4),
new SqlParameter("@winGold", SqlDbType.Int, 4),
new SqlParameter("@GetId", SqlDbType.Int, 4),
new SqlParameter("@FromId", SqlDbType.Int, 4),
new SqlParameter("@TabelId", SqlDbType.Int, 4),
new SqlParameter("@GameName", SqlDbType.NChar, 10),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@isGet", SqlDbType.Int, 4),
new SqlParameter("@overTime", SqlDbType.Int, 4),
new SqlParameter("@Remarks", SqlDbType.NVarChar, 50),
new SqlParameter("@Ident", SqlDbType.Int, 4)
};
parameters[0].Value = model.awardId;
parameters[1].Value = model.UserId;
parameters[2].Value = model.winGold;
parameters[3].Value = model.GetId;
parameters[4].Value = model.FromId;
parameters[5].Value = model.TabelId;
parameters[6].Value = model.GameName;
parameters[7].Value = model.AddTime;
parameters[8].Value = model.isGet;
parameters[9].Value = model.overTime;
parameters[10].Value = model.Remarks;
parameters[11].Value = model.Ident;
object obj = SqlHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个数据的次数（isGet）字段
/// </summary>
public BCW.Model.tb_WinnersLists GetLastIsGet(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select TOP 1 * isGet from tb_WinnersLists ");
strSql.Append(" where Id=@Id order by AddTime desc");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.BigInt)
};
parameters[0].Value = Id;
//object obj = SqlHelperUser.GetSingle(strSql.ToString(), parameters);
//if (obj == null)
//{
// return 0;
//}
//else
//{
// return Convert.ToInt32(obj);
//}
BCW.Model.tb_WinnersLists model = new BCW.Model.tb_WinnersLists();
using (SqlDataReader reader = SqlHelper.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
model.Id = reader.GetInt64(0);
model.awardId = reader.GetInt32(1);
model.UserId = reader.GetInt32(2);
model.winGold = reader.GetInt32(3);
model.GetId = reader.GetInt32(4);
model.FromId = reader.GetInt32(5);
model.TabelId = reader.GetInt32(6);
model.GameName = reader.GetString(7);
model.AddTime = reader.GetDateTime(8);
model.isGet = reader.GetInt32(9);
model.overTime = reader.GetInt32(10);
model.Remarks = reader.GetString(11);
model.Ident = reader.GetInt32(12);
return(model);
}
else
{
return(null);
}
}
}
/// <summary>
/// 取得每页记录
/// </summary>
/// <param name="p_pageIndex">当前页</param>
/// <param name="p_pageSize">分页大小</param>
/// <param name="p_recordCount">返回总记录数</param>
/// <param name="strWhere">查询条件</param>
/// <returns>IList tb_WinnersLists</returns>
public IList <BCW.Model.tb_WinnersLists> Gettb_WinnersListss(int p_pageIndex, int p_pageSize, string strWhere, out int p_recordCount)
{
IList <BCW.Model.tb_WinnersLists> listtb_WinnersListss = new List <BCW.Model.tb_WinnersLists>();
string sTable = "tb_WinnersLists";
string sPkey = "id";
string sField = "Id,awardId,UserId,winGold,GetId,FromId,TabelId,GameName,AddTime,isGet,overTime,Remarks,Ident";
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(listtb_WinnersListss);
}
while (reader.Read())
{
BCW.Model.tb_WinnersLists objtb_WinnersLists = new BCW.Model.tb_WinnersLists();
objtb_WinnersLists.Id = reader.GetInt64(0);
objtb_WinnersLists.awardId = reader.GetInt32(1);
objtb_WinnersLists.UserId = reader.GetInt32(2);
objtb_WinnersLists.winGold = reader.GetInt32(3);
objtb_WinnersLists.GetId = reader.GetInt32(4);
objtb_WinnersLists.FromId = reader.GetInt32(5);
objtb_WinnersLists.TabelId = reader.GetInt32(6);
objtb_WinnersLists.GameName = reader.GetString(7);
objtb_WinnersLists.AddTime = reader.GetDateTime(8);
objtb_WinnersLists.isGet = reader.GetInt32(9);
objtb_WinnersLists.overTime = reader.GetInt32(10);
objtb_WinnersLists.Remarks = reader.GetString(11);
objtb_WinnersLists.Ident = reader.GetInt32(12);
listtb_WinnersListss.Add(objtb_WinnersLists);
}
}
return(listtb_WinnersListss);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BCW.Model.tb_WinnersLists Gettb_WinnersLists(long Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,awardId,UserId,winGold,GetId,FromId,TabelId,GameName,AddTime,isGet,overTime,Remarks,Ident from tb_WinnersLists ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.BigInt)
};
parameters[0].Value = Id;
BCW.Model.tb_WinnersLists model = new BCW.Model.tb_WinnersLists();
using (SqlDataReader reader = SqlHelper.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
model.Id = reader.GetInt64(0);
model.awardId = reader.GetInt32(1);
model.UserId = reader.GetInt32(2);
model.winGold = reader.GetInt32(3);
model.GetId = reader.GetInt32(4);
model.FromId = reader.GetInt32(5);
model.TabelId = reader.GetInt32(6);
model.GameName = reader.GetString(7);
model.AddTime = reader.GetDateTime(8);
model.isGet = reader.GetInt32(9);
model.overTime = reader.GetInt32(10);
model.Remarks = reader.GetString(11);
model.Ident = reader.GetInt32(12);
return(model);
}
else
{
return(null);
}
}
}
