CreateSQLSentence/PowerSentence.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using Model;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using DAL;
using IDAL;

namespace CreateSQLSentence
{
    public class PowerSentence : I_PowerManage
    {
        SQLAccess sqlManager = new SQLAccess();
        #region I_PowerManage 成员
        /// <summary>
        /// 获取所有的根权限
        /// </summary>
        /// <param name="dp"></param>
        public void GetPower(DropDownList dp)
        {
            DataTable dt = sqlManager.ExecuteDataSet("select PowerID,PowerName from Tab_Power where PowerPID=0").Tables[0];
            dp.DataSource = dt;
            dp.DataTextField = "PowerName";
            dp.DataValueField = "PowerID";
            dp.DataBind();
            dp.Items.Insert(0, new ListItem("------", "0"));
        }
        /// <summary>
        /// 添加一条权限
        /// </summary>
        /// <param name="mopower">权限信息对象</param>
        /// <returns>是否成功</returns>
        public int PowerAdd(Power mopower)
        {
            StringBuilder str = new StringBuilder();
            str.Append("insert into Tab_Power (PowerName,PowerContent,PowerUrl,PowerPID) values(");
            str.AppendFormat("'{0}','{1}','{2}','{3}')", mopower.PowerName1, mopower.PowerContent1, mopower.PowerUrl1, mopower.PowerPID1);

            return sqlManager.ExecuteNonQuery(str.ToString());
        }
        /// <summary>
        /// 权限的修改
        /// </summary>
        /// <param name="mopower">权限信息对象</param>
        /// <returns>是否成功</returns>
        public int PowerUpdate(Power mopower)
        {
            StringBuilder strsql = new StringBuilder();
            strsql.Append("update Tab_Power set ");
            strsql.AppendFormat("PowerName='{0}',", mopower.PowerName1);
            strsql.AppendFormat("PowerContent='{0}',", mopower.PowerContent1);

            strsql.AppendFormat("PowerUrl='{0}',", mopower.PowerUrl1);
            strsql.AppendFormat("PowerPID='{0}'", mopower.PowerPID1);
            strsql.AppendFormat("where PowerID={0}", mopower.PowerID1);