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); }