/// <summary>
/// 修改数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(Model.Bbs.ContentType model)
{
if (model == null)
{
return(-1);
}
if (IsExist(model.TypeName, model.NumberID))
{
return(110);
}
//定义查询命令
string cmdText = @"update [ContentType] set TypeName = @TypeName,ParentID = @ParentID,Sort = @Sort,SameName = @SameName,LastUpdatedDate = @LastUpdatedDate where NumberID = @NumberID";
//创建查询命令参数集
SqlParameter[] parms =
{
new SqlParameter("@NumberID", SqlDbType.UniqueIdentifier),
new SqlParameter("@TypeName", SqlDbType.NVarChar, 256),
new SqlParameter("@ParentID", SqlDbType.UniqueIdentifier),
new SqlParameter("@Sort", SqlDbType.Int),
new SqlParameter("@SameName", SqlDbType.NVarChar, 10),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = model.NumberID;
parms[1].Value = model.TypeName;
parms[2].Value = model.ParentID;
parms[3].Value = model.Sort;
parms[4].Value = model.SameName;
parms[5].Value = model.LastUpdatedDate;
return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderBbsConnString, CommandType.Text, cmdText, parms));
}
/// <summary>
/// 添加数据到数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(Model.Bbs.ContentType model)
{
if (model == null)
{
return(-1);
}
//判断当前记录是否存在，如果存在则返回;
if (IsExist(model.TypeName, null))
{
return(110);
}
string cmdText = "insert into [ContentType] (TypeName,ParentID,Sort,SameName,LastUpdatedDate) values (@TypeName,@ParentID,@Sort,@SameName,@LastUpdatedDate)";
//创建查询命令参数集
SqlParameter[] parms =
{
new SqlParameter("@TypeName", SqlDbType.NVarChar, 256),
new SqlParameter("@ParentID", SqlDbType.UniqueIdentifier),
new SqlParameter("@Sort", SqlDbType.Int),
new SqlParameter("@SameName", SqlDbType.NVarChar, 10),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = model.TypeName;
parms[1].Value = model.ParentID;
parms[2].Value = model.Sort;
parms[3].Value = model.SameName;
parms[4].Value = model.LastUpdatedDate;
//执行数据库操作
return(SqlHelper.ExecuteNonQuery(SqlHelper.SqlProviderBbsConnString, CommandType.Text, cmdText, parms));
}
private void OnSave()
{
string sTypeName = txtTypeName.Value.Trim();
string sParent = txtParent.Value.Trim();
Guid parentId = Guid.Empty;
if (!string.IsNullOrEmpty(sParent))
{
Guid.TryParse(sParent, out parentId);
}
Model.Bbs.ContentType model = new Model.Bbs.ContentType();
model.TypeName = sTypeName;
model.ParentID = parentId;
model.Sort = 0;
model.SameName = "All";
model.LastUpdatedDate = DateTime.Now;
if (ctBll == null)
{
ctBll = new BLL.Bbs.ContentType();
}
int result = -1;
if (!string.IsNullOrEmpty(nId))
{
model.NumberID = nId;
result = ctBll.Update(model);
}
else
{
result = ctBll.Insert(model);
}
if (result == 110)
{
WebHelper.MessageBox.Messager(this.Page, lbtnPostBack, "已存在相同记录！");
return;
}
if (result > 0)
{
WebHelper.MessageBox.Messager(this.Page, lbtnPostBack, "提交成功！");
}
else
{
WebHelper.MessageBox.Messager(this.Page, lbtnPostBack, "提交失败,系统异常！", "温馨提醒", "error");
}
}
private void Bind()
{
if (!string.IsNullOrEmpty(nId))
{
if (ctBll == null)
{
ctBll = new BLL.Bbs.ContentType();
}
Model.Bbs.ContentType model = ctBll.GetModel(nId);
if (model != null)
{
txtTypeName.Value = model.TypeName;
txtParent.Value = model.ParentID.ToString();
}
}
}
/// <summary>
/// 获取数据分页列表，并返回所有记录数
/// </summary>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="totalCount"></param>
/// <param name="sqlWhere"></param>
/// <param name="commandParameters"></param>
/// <returns></returns>
public IList <Model.Bbs.ContentType> GetList(int pageIndex, int pageSize, out int totalCount, string sqlWhere, params SqlParameter[] commandParameters)
{
//获取数据集总数
string cmdText = "select count(*) from [ContentType] t1 ";
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += "where 1=1 " + sqlWhere;
}
totalCount = (int)SqlHelper.ExecuteScalar(SqlHelper.SqlProviderBbsConnString, CommandType.Text, cmdText, commandParameters);
//返回分页数据
int startIndex = (pageIndex - 1) * pageSize + 1;
int endIndex = pageIndex * pageSize;
cmdText = @"select * from(select row_number() over(order by LastUpdatedDate desc) as RowNumber,NumberID,TypeName,ParentID,Sort,SameName,LastUpdatedDate from [ContentType] ";
if (!string.IsNullOrEmpty(sqlWhere))
{
cmdText += "where 1=1 " + sqlWhere;
}
cmdText += ")as objTable where RowNumber between " + startIndex + " and " + endIndex + " ";
IList <Model.Bbs.ContentType> list = null;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderBbsConnString, CommandType.Text, cmdText, commandParameters))
{
if (reader != null && reader.HasRows)
{
list = new List <Model.Bbs.ContentType>();
while (reader.Read())
{
Model.Bbs.ContentType model = new Model.Bbs.ContentType();
model.NumberID = reader.GetGuid(1);
model.TypeName = reader.GetString(2);
model.ParentID = reader.GetGuid(3);
model.Sort = reader.GetInt32(4);
model.SameName = reader.GetString(5);
model.LastUpdatedDate = reader.GetDateTime(6);
list.Add(model);
}
}
}
return(list);
}
/// <summary>
/// 获取对应的数据
/// </summary>
/// <param name="numberId"></param>
/// <returns></returns>
public Model.Bbs.ContentType GetModel(object numberId)
{
Guid gId = Guid.Empty;
Guid.TryParse(numberId.ToString(), out gId);
if (gId == Guid.Empty)
{
return(null);
}
Model.Bbs.ContentType model = null;
string cmdText = @"select top 1 NumberID,TypeName,ParentID,Sort,SameName,LastUpdatedDate from [ContentType] where NumberID = @NumberID order by LastUpdatedDate desc ";
SqlParameter parm = new SqlParameter("@NumberID", SqlDbType.UniqueIdentifier);
parm.Value = gId;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.SqlProviderBbsConnString, CommandType.Text, cmdText, parm))
{
if (reader != null)
{
while (reader.Read())
{
model = new Model.Bbs.ContentType();
model.NumberID = reader.GetGuid(0);
model.TypeName = reader.GetString(1);
model.ParentID = reader.GetGuid(2);
model.Sort = reader.GetInt32(3);
model.SameName = reader.GetString(4);
model.LastUpdatedDate = reader.GetDateTime(5);
}
}
}
return(model);
}
/// <summary>
/// 修改数据
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Update(Model.Bbs.ContentType model)
{
return(dal.Update(model));
}
/// <summary>
/// 添加数据到数据库
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Insert(Model.Bbs.ContentType model)
{
return(dal.Insert(model));
}
