C#权限设计代码

最新推荐文章于 2024-07-03 14:55:19 发布

Name_456

最新推荐文章于 2024-07-03 14:55:19 发布

阅读量1.5k

点赞数

CC 4.0 BY-SA版权

文章标签： c# string insert sql null object

本文链接：https://blog.youkuaiyun.com/Name_456/article/details/7260794

本文介绍了如何在C#应用程序中设计和实现权限控制系统，包括关键的代码示例，涉及到字符串操作、数据库交互（如INSERT SQL语句的使用）以及对NULL和Object类型的处理。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

新增栏目；
using System;
using System.Data;
using System.Configuration;
using System.Collections;
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 Model;
using DAL.Main;

public partial class Main_AddProjectModel : System.Web.UI.Page
{
  
    DAL.Main.ProjectModel MPModel = new DAL.Main.ProjectModel();   //声明数据层对象
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!IsPostBack)
        {
            BindDDl();
        }
    }

    /// <summary>
    /// 绑定父级栏目
    /// </summary>
    public void BindDDl()
    {
        ddlModelList.DataSource = MPModel.GetProjectModel("0");
        ddlModelList.DataTextField = "ModelName";
        ddlModelList.DataValueField = "ModelId";
        ddlModelList.DataBind();
    }


    protected void btn_Add_Model_Click(object sender, EventArgs e)
    {
        Model.ProjectModel model = new Model.ProjectModel();
        model.ModelName = txtModelName.Text.ToString();
        model.ModelUrl = txtUrl.Text.ToString();
        model.IsFoot = Convert.ToBoolean(int.Parse(ROrNO.SelectedValue.ToString()));
        if (CheckBox1.Checked)
        {
            model.HightModelID = int.Parse(ddlModelList.SelectedValue.ToString());
        }
        else 
        {
            model.HightModelID = int.Parse("0");
        }

        if (MPModel.InsertProjectModel(model)!=0)
        {
            RegisterClientScriptBlock("","<script>alert('success！');</script>");
        }
       
    }

    protected void CheckBox1_CheckedChanged(object sender, EventArgs e)
    {
        if (CheckBox1.Checked)
        {
            lblIsModel.Visible = false;
            ddlModelList.Visible = true;
        }
        else
        {
            lblIsModel.Visible = true;
            ddlModelList.Visible = false;
        }
    }
}



数据



        /// <summary>
        /// 得到所有模块详细信息
        /// </summary>
        /// <returns></returns>
        public IList<Model.ProjectModel> GetProjectModel(string hightId)
        {
            IList<Model.ProjectModel> GetPModel = new List<Model.ProjectModel>();
            string SQL_GetProject="";
            if (hightId != null)
            {
                SQL_GetProject = "select * from project_model where HightModelId=" + Convert.ToInt32(hightId);
            }

            Model.ProjectModel Projects = null;

            using (SqlDataReader rdr = SQLHelper.ExecuteReader(SQLHelper.SQLConnString, CommandType.Text, SQL_GetProject, null))
            {
                while (rdr.Read())
                {
                    Projects = new Model.ProjectModel();
                    Projects.ModelName = rdr["ModelName"].ToString();
                    Projects.ModelId = int.Parse(rdr["ModelId"].ToString());
                    Projects.ModelUrl = rdr["ModelUrl"].ToString();
                    Projects.IsFoot = Convert.ToBoolean( rdr["IsFoot"].ToString());
                    Projects.HightModelID = int.Parse(rdr["HightModelID"].ToString());
                    GetPModel.Add(Projects);
                }
                return GetPModel;
            }
        }

        /// <summary>