ad88/Rx/SyRole.aspx.cs

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

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Collections.Generic;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
using CSA.DAL;
using CSA.Control;
using CSA.IO;
public partial class Rx_SyRole : Page
{
    StringBuilder sbs = null;
    string ChkBoxParas = "", type = "", msg="", pkid="";
    string TblName = "Sy_RoleMnu";
    List<string> sqlList = new List<string>();

    protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
            if (!IsPostBack)
            {
                switch (Request["action"])
                {
                    case "save":        //设置权限
                        try
                        {
                            string pkids = Request["para1"];        //role ids
                            pkid = Request["pkid"];
                            
                            //delete old RoleMnu set 

                            sqlList.Add(string.Format("DELETE FROM Sy_RoleMnu WHERE Sy_RoleFK = '{0}'", pkid));
                            //insert new RoleMnu 
                            SQLBuilder builder = new SQLBuilder(TblName);
                            pkids = pkids.Replace("root", "");
                            foreach (string _pkid in pkids.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries))
                            {
                                builder.Clear();
                                builder.TblName = TblName;
                                builder.AddData("ModUser", BLL.User.AdminUser.UserID);
                                builder.AddData("ModTime", DateTime.Now.ToString());
                                builder.AddData("Sy_RoleFK", pkid);
                                builder.AddData("Sy_MenuFK",_pkid.Trim());
                                sqlList.Add(builder.InsertSql);
                            }

                            DBAccess.ExecuteSqlTran(sqlList);

                            msg = "权限已成功更新到服务器！";
                        }
                        catch (Exception ex)
                        {
                            msg = "保存到服务器时出现错误！" + ex.Message;