public int UpdateItem(MXAdminSysItem Model)
{
string sql = "update [MXAdminSysItem] set [ItemName]=@ItemName,[ItemURL]=@ItemURL,[ItemImage]=@ItemImage,[OrderIndex]=@OrderIndex,[ParentItemId]=@ParentItemId where ItemId=@ItemId";
SqlParameter[] par = (SqlParameter[])this.ValueParas(Model);
return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par));
}
public int InsertInfor(MXAdminSysItem Model)
{
StringBuilder sql = new StringBuilder();
sql.Append("Insert into [MXAdminSysItem] ([ItemName],[ItemURL],[OrderIndex],[ParentItemId],[ItemImage]) values (@ItemName,@ItemURL,@OrderIndex,@ParentItemId,@ItemImage)");
SqlParameter[] par = (SqlParameter[])this.ValueParas(Model);
return(Common.DbHelperSQL.ExecuteSql(sql.ToString(), par));
}
/// <summary>
/// 该数据访问对象的属性值装载到数据库更新参数数组
/// </summary>
/// <remarks></remarks>
protected IDbDataParameter[] ValueParas(MXAdminSysItem Model)
{
SqlParameter[] par =
{
new SqlParameter("@ItemId", SqlDbType.Int, 4),
new SqlParameter("@ItemName", SqlDbType.VarChar, 50),
new SqlParameter("@ParentItemId", SqlDbType.Int, 4),
new SqlParameter("@OrderIndex", SqlDbType.Int, 4),
new SqlParameter("@ItemImage", SqlDbType.Int, 4),
new SqlParameter("@ItemURL", SqlDbType.VarChar, 300)
};
par[0].Value = Model.ItemId;
par[1].Value = Model.ItemName;
par[2].Value = Model.ParentItemId;
par[3].Value = Model.OrderIndex;
par[4].Value = Model.ItemImage;
par[5].Value = Model.ItemURL;
return(par);
}
