/// <summary> /// 向权限表添加一条信息 /// </summary> /// <param name="sq"></param> /// <returns></returns> public int Add(Model.tab_powers mopower) { StringBuilder str = new StringBuilder(); str.Append("insert into tab_powers (powerName,powerContent,powerUrl,powerPID) values("); str.AppendFormat("'{0}','{1}','{2}','{3}')", mopower.PowerName, mopower.PowerContent, mopower.PowerUrl, mopower.PowerPID); return(sql.ExecuteNonQuery(str.ToString())); }
/// <summary> /// 修改权限表 /// </summary> /// <param name="mopower"></param> /// <returns></returns> public int PowerUpdate(Model.tab_powers mopower) { StringBuilder strsql = new StringBuilder(); strsql.Append("update tab_powers set "); strsql.AppendFormat("powerName='{0}',", mopower.PowerName); strsql.AppendFormat("powerContent='{0}',", mopower.PowerContent); strsql.AppendFormat("powerUrl='{0}',", mopower.PowerUrl); strsql.AppendFormat("powerPID='{0}'", mopower.PowerPID); strsql.AppendFormat("where powerID={0}", mopower.PowerID); return(sql.ExecuteNonQuery(strsql.ToString())); }
/// <summary> /// 修改权限 /// </summary> /// <param name="sq"></param> /// <returns></returns> public int UpdataPrower(Model.tab_powers sq) { return(itu.PowerUpdate(sq)); }
/// <summary> /// 向权限表添加一条信息 /// </summary> /// <param name="tab_power"></param> /// <returns></returns> public int AddPrower(Model.tab_powers tab_power) { return(itu.Add(tab_power)); }