/// <summary>
/// 取得每页记录
/// </summary>
/// <param name="p_pageIndex">当前页</param>
/// <param name="p_pageSize">分页大小</param>
/// <param name="p_recordCount">返回总记录数</param>
/// <param name="strWhere">查询条件</param>
/// <returns>IList tb_ZQLists</returns>
public IList <BCW.Model.tb_ZQLists> Gettb_ZQListss2(int p_pageIndex, int p_pageSize, string strWhere, string strOrder, out int p_recordCount)
{
IList <BCW.Model.tb_ZQLists> listtb_ZQListss = new List <BCW.Model.tb_ZQLists>();
string sTable = "tb_ZQLists";
string sPkey = "id";
string sField = "* ";
string sCondition = strWhere;
string sOrder = strOrder;
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_ZQListss);
}
while (reader.Read())
{
BCW.Model.tb_ZQLists objtb_ZQLists = new BCW.Model.tb_ZQLists();
objtb_ZQLists.Id = reader.GetInt32(0);
objtb_ZQLists.ft_bianhao = reader.GetInt32(1);
objtb_ZQLists.ft_didian = reader.GetString(2);
objtb_ZQLists.ft_teamStyle = reader.GetString(3);
objtb_ZQLists.ft_team1 = reader.GetString(4);
objtb_ZQLists.ft_team2 = reader.GetString(5);
objtb_ZQLists.ft_result = reader.GetString(6);
objtb_ZQLists.ft_state = reader.GetString(7);
objtb_ZQLists.ft_time = reader.GetDateTime(8);
objtb_ZQLists.ft_caipan = reader.GetString(9);
objtb_ZQLists.ft_news = reader.GetString(10);
objtb_ZQLists.ft_otherNews = reader.GetString(11);
objtb_ZQLists.ft_hit = reader.GetInt32(12);
objtb_ZQLists.ft_glod = reader.GetInt32(13);
objtb_ZQLists.ft_team1Explain = reader.GetString(14);
objtb_ZQLists.ft_team2Explain = reader.GetString(15);
objtb_ZQLists.isDone = reader.GetInt32(16);
objtb_ZQLists.ft_addTime = reader.GetDateTime(17);
objtb_ZQLists.ft_overTime = reader.GetDateTime(18);
objtb_ZQLists.ft_state1 = reader.GetString(19);
objtb_ZQLists.ft_state2 = reader.GetString(20);
objtb_ZQLists.Identification = reader.GetInt32(21);
objtb_ZQLists.ft_beiyong = reader.GetString(22);
listtb_ZQListss.Add(objtb_ZQLists);
}
}
return(listtb_ZQListss);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public BCW.Model.tb_ZQLists Gettb_ZQLists(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,ft_bianhao,ft_didian,ft_teamStyle,ft_team1,ft_team2,ft_result,ft_state,ft_time,ft_caipan,ft_news,ft_otherNews,ft_hit,ft_glod,ft_team1Explain,ft_team2Explain,isDone,ft_addTime,ft_overTime,ft_state1,ft_state2,Identification,ft_beiyong from tb_ZQLists ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
BCW.Model.tb_ZQLists model = new BCW.Model.tb_ZQLists();
using (SqlDataReader reader = SqlHelper.ExecuteReader(strSql.ToString(), parameters))
{
if (reader.HasRows)
{
reader.Read();
model.Id = reader.GetInt32(0);
model.ft_bianhao = reader.GetInt32(1);
model.ft_didian = reader.GetString(2);
model.ft_teamStyle = reader.GetString(3);
model.ft_team1 = reader.GetString(4);
model.ft_team2 = reader.GetString(5);
model.ft_result = reader.GetString(6);
model.ft_state = reader.GetString(7);
model.ft_time = reader.GetDateTime(8);
model.ft_caipan = reader.GetString(9);
model.ft_news = reader.GetString(10);
model.ft_otherNews = reader.GetString(11);
model.ft_hit = reader.GetInt32(12);
model.ft_glod = reader.GetInt32(13);
model.ft_team1Explain = reader.GetString(14);
model.ft_team2Explain = reader.GetString(15);
model.isDone = reader.GetInt32(16);
model.ft_addTime = reader.GetDateTime(17);
model.ft_overTime = reader.GetDateTime(18);
model.ft_state1 = reader.GetString(19);
model.ft_state2 = reader.GetString(20);
model.Identification = reader.GetInt32(21);
model.ft_beiyong = reader.GetString(22);
return(model);
}
else
{
return(null);
}
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BCW.Model.tb_ZQLists model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_ZQLists(");
strSql.Append("ft_bianhao,ft_didian,ft_teamStyle,ft_team1,ft_team2,ft_result,ft_state,ft_time,ft_caipan,ft_news,ft_otherNews,ft_hit,ft_glod,ft_team1Explain,ft_team2Explain,isDone,ft_addTime,ft_overTime,ft_state1,ft_state2,Identification,ft_beiyong)");
strSql.Append(" values (");
strSql.Append("@ft_bianhao,@ft_didian,@ft_teamStyle,@ft_team1,@ft_team2,@ft_result,@ft_state,@ft_time,@ft_caipan,@ft_news,@ft_otherNews,@ft_hit,@ft_glod,@ft_team1Explain,@ft_team2Explain,@isDone,@ft_addTime,@ft_overTime,@ft_state1,@ft_state2,@Identification,@ft_beiyong)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@ft_bianhao", SqlDbType.Int, 4),
new SqlParameter("@ft_didian", SqlDbType.NVarChar, 50),
new SqlParameter("@ft_teamStyle", SqlDbType.NVarChar, 50),
new SqlParameter("@ft_team1", SqlDbType.NVarChar, 200),
new SqlParameter("@ft_team2", SqlDbType.NVarChar, 200),
new SqlParameter("@ft_result", SqlDbType.NVarChar, 50),
new SqlParameter("@ft_state", SqlDbType.NChar, 10),
new SqlParameter("@ft_time", SqlDbType.DateTime, 3),
new SqlParameter("@ft_caipan", SqlDbType.NChar, 10),
new SqlParameter("@ft_news", SqlDbType.NVarChar),
new SqlParameter("@ft_otherNews", SqlDbType.NVarChar),
new SqlParameter("@ft_hit", SqlDbType.Int, 4),
new SqlParameter("@ft_glod", SqlDbType.Int, 4),
new SqlParameter("@ft_team1Explain", SqlDbType.NVarChar),
new SqlParameter("@ft_team2Explain", SqlDbType.NVarChar),
new SqlParameter("@isDone", SqlDbType.Int, 4),
new SqlParameter("@ft_addTime", SqlDbType.DateTime),
new SqlParameter("@ft_overTime", SqlDbType.DateTime),
new SqlParameter("@ft_state1", SqlDbType.NVarChar),
new SqlParameter("@ft_state2", SqlDbType.NVarChar),
new SqlParameter("@Identification", SqlDbType.Int, 4),
new SqlParameter("@ft_beiyong", SqlDbType.NVarChar)
};
parameters[0].Value = model.ft_bianhao;
parameters[1].Value = model.ft_didian;
parameters[2].Value = model.ft_teamStyle;
parameters[3].Value = model.ft_team1;
parameters[4].Value = model.ft_team2;
parameters[5].Value = model.ft_result;
parameters[6].Value = model.ft_state;
parameters[7].Value = model.ft_time;
parameters[8].Value = model.ft_caipan;
parameters[9].Value = model.ft_news;
parameters[10].Value = model.ft_otherNews;
parameters[11].Value = model.ft_hit;
parameters[12].Value = model.ft_glod;
parameters[13].Value = model.ft_team1Explain;
parameters[14].Value = model.ft_team2Explain;
parameters[15].Value = model.isDone;
parameters[16].Value = model.ft_addTime;
parameters[17].Value = model.ft_overTime;
parameters[18].Value = model.ft_state1;
parameters[19].Value = model.ft_state2;
parameters[20].Value = model.Identification;
parameters[21].Value = model.ft_beiyong;
object obj = SqlHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(BCW.Model.tb_ZQLists model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_ZQLists set ");
strSql.Append("ft_bianhao=@ft_bianhao,");
strSql.Append("ft_didian=@ft_didian,");
strSql.Append("ft_teamStyle=@ft_teamStyle,");
strSql.Append("ft_team1=@ft_team1,");
strSql.Append("ft_team2=@ft_team2,");
strSql.Append("ft_result=@ft_result,");
strSql.Append("ft_state=@ft_state,");
strSql.Append("ft_time=@ft_time,");
strSql.Append("ft_caipan=@ft_caipan,");
strSql.Append("ft_news=@ft_news,");
strSql.Append("ft_otherNews=@ft_otherNews,");
strSql.Append("ft_hit=@ft_hit,");
strSql.Append("ft_glod=@ft_glod,");
strSql.Append("ft_team1Explain=@ft_team1Explain,");
strSql.Append("ft_team2Explain=@ft_team2Explain,");
strSql.Append("isDone=@isDone,");
strSql.Append("ft_addTime=@ft_addTime,");
strSql.Append("ft_overTime=@ft_overTime,");
strSql.Append("ft_state1=@ft_state1,");
strSql.Append("ft_state2=@ft_state2,");
strSql.Append("Identification=@Identification,");
strSql.Append("ft_beiyong=@ft_beiyong");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@ft_bianhao", SqlDbType.Int, 4),
new SqlParameter("@ft_didian", SqlDbType.NVarChar, 50),
new SqlParameter("@ft_teamStyle", SqlDbType.NVarChar, 50),
new SqlParameter("@ft_team1", SqlDbType.NVarChar, 200),
new SqlParameter("@ft_team2", SqlDbType.NVarChar, 200),
new SqlParameter("@ft_result", SqlDbType.NVarChar, 50),
new SqlParameter("@ft_state", SqlDbType.NChar, 10),
new SqlParameter("@ft_time", SqlDbType.DateTime, 3),
new SqlParameter("@ft_caipan", SqlDbType.NChar, 10),
new SqlParameter("@ft_news", SqlDbType.NVarChar),
new SqlParameter("@ft_otherNews", SqlDbType.NVarChar),
new SqlParameter("@ft_hit", SqlDbType.Int, 4),
new SqlParameter("@ft_glod", SqlDbType.Int, 4),
new SqlParameter("@ft_team1Explain", SqlDbType.NVarChar),
new SqlParameter("@ft_team2Explain", SqlDbType.NVarChar),
new SqlParameter("@isDone", SqlDbType.Int, 4),
new SqlParameter("@ft_addTime", SqlDbType.DateTime),
new SqlParameter("@ft_overTime", SqlDbType.DateTime),
new SqlParameter("@ft_state1", SqlDbType.NVarChar),
new SqlParameter("@ft_state2", SqlDbType.NVarChar),
new SqlParameter("@Identification", SqlDbType.Int, 4),
new SqlParameter("@ft_beiyong", SqlDbType.NVarChar)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.ft_bianhao;
parameters[2].Value = model.ft_didian;
parameters[3].Value = model.ft_teamStyle;
parameters[4].Value = model.ft_team1;
parameters[5].Value = model.ft_team2;
parameters[6].Value = model.ft_result;
parameters[7].Value = model.ft_state;
parameters[8].Value = model.ft_time;
parameters[9].Value = model.ft_caipan;
parameters[10].Value = model.ft_news;
parameters[11].Value = model.ft_otherNews;
parameters[12].Value = model.ft_hit;
parameters[13].Value = model.ft_glod;
parameters[14].Value = model.ft_team1Explain;
parameters[15].Value = model.ft_team2Explain;
parameters[16].Value = model.isDone;
parameters[17].Value = model.ft_addTime;
parameters[18].Value = model.ft_overTime;
parameters[19].Value = model.ft_state1;
parameters[20].Value = model.ft_state2;
parameters[21].Value = model.Identification;
parameters[22].Value = model.ft_beiyong;
SqlHelper.ExecuteSql(strSql.ToString(), parameters);
}
