/// <summary>
/// 增加一条数据
/// </summary>
public int Add(GameCategory model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into usta_GameCategory(");
strSql.Append("gameTitle,gameContent,attachmentIds,updateTime,startTime,endTime)");
strSql.Append(" values (");
strSql.Append("@gameTitle,@gameContent,@attachmentIds,@updateTime,@startTime,@endTime)");
SqlParameter[] parameters = {
new SqlParameter("@gameTitle", SqlDbType.NVarChar,50),
new SqlParameter("@gameContent", SqlDbType.NVarChar,2000),
new SqlParameter("@attachmentIds", SqlDbType.NVarChar,200),
new SqlParameter("@updateTime", SqlDbType.NChar,10),
new SqlParameter("@startTime", SqlDbType.DateTime),
new SqlParameter("@endTime", SqlDbType.DateTime)};
parameters[0].Value = model.gameTitle;
parameters[1].Value = model.gameContent;
parameters[2].Value = model.attachmentIds;
parameters[3].Value = model.updateTime;
parameters[4].Value = model.startTime;
parameters[5].Value = model.endTime;
return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
/// 更新抽签状态
/// </summary>
public int UpdateDrawState(GameCategory model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update usta_GameCategory set ");
strSql.Append("isOpenDraw=@isOpenDraw");
strSql.Append(" where gameCategoryId=@gameCategoryId");
SqlParameter[] parameters = {
new SqlParameter("@gameCategoryId", SqlDbType.Int,4),
new SqlParameter("@isOpenDraw", SqlDbType.TinyInt,1)};
parameters[0].Value = model.gameCategoryId;
parameters[1].Value = model.isOpenDraw;
return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(GameCategory model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update usta_GameCategory set ");
strSql.Append("gameTitle=@gameTitle,");
strSql.Append("gameContent=@gameContent,");
strSql.Append("attachmentIds=@attachmentIds,");
strSql.Append("updateTime=@updateTime,");
strSql.Append("startTime=@startTime,");
strSql.Append("endTime=@endTime,");
strSql.Append("isOpenDraw=@isOpenDraw ");
strSql.Append(" where gameCategoryId=@gameCategoryId");
SqlParameter[] parameters = {
new SqlParameter("@gameTitle", SqlDbType.NVarChar,50),
new SqlParameter("@gameContent", SqlDbType.NVarChar,2000),
new SqlParameter("@attachmentIds", SqlDbType.NVarChar,200),
new SqlParameter("@updateTime", SqlDbType.DateTime),
new SqlParameter("@startTime", SqlDbType.DateTime),
new SqlParameter("@endTime", SqlDbType.DateTime),
new SqlParameter("@gameCategoryId", SqlDbType.Int,4),
new SqlParameter("@isOpenDraw", SqlDbType.TinyInt,1)};
parameters[0].Value = model.gameTitle;
parameters[1].Value = model.gameContent;
parameters[2].Value = model.attachmentIds;
parameters[3].Value = model.updateTime;
parameters[4].Value = model.startTime;
parameters[5].Value = model.endTime;
parameters[6].Value = model.gameCategoryId;
parameters[7].Value = model.isOpenDraw;
return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters);
}
