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