User/Dal/UserPower.cs

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

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

using System;
using System.Data;
using Common;

namespace User.Dal
{
    /// <summary>
    /// 用户权限
    /// </summary>
    /// <remarks></remarks>
    internal class UserPower
    {
        private string str;
        /// <summary>
        /// 创建实例
        /// </summary>
        /// <returns></returns>
        /// <remarks></remarks>
        public static UserPower Create()
        {
            return new UserPower();
        }

        public void Delete(int Id, System.Data.Common.DbCommand cmd)
        {
            str = "delete from __UserPower where Id=" + Id;
            DataBase.execCmd(str, cmd);
        }

        public void Insert(Model.UserPowerInfo mdl, System.Data.Common.DbCommand cmd)
        {
            string bLuRu = DataBase.getBoolean(mdl.Nuke().A04_bLuRu);
            string bCheck = DataBase.getBoolean(mdl.Nuke().A05_bCheck);
            string bBianGeng = DataBase.getBoolean(mdl.Nuke().A06_bBianGeng);
            string bClose = DataBase.getBoolean(mdl.Nuke().A07_bClose);
            str = "insert into __UserPower(cUserName,cMenuId,bLuRu,bCheck,bBianGeng,bClose) values(" + DataBase.getString(mdl.Nuke().A02_cUserName) + "," + DataBase.getString(mdl.Nuke().A03_cMenuId) + "," + bLuRu + "," + bCheck + "," + bBianGeng + "," + bClose + ")";
            DataBase.execCmd(str, cmd);
        }

        public void Update(Model.UserPowerInfo mdl, System.Data.Common.DbCommand cmd)
        {
            string bLuRu = DataBase.getBoolean(mdl.Nuke().A04_bLuRu);
            string bCheck = DataBase.getBoolean(mdl.Nuke().A05_bCheck);
            string bBianGeng = DataBase.getBoolean(mdl.Nuke().A06_bBianGeng);
            string bClose = DataBase.getBoolean(mdl.Nuke().A07_bClose);
            str = "update __UserPower set cUserName=" + DataBase.getString(mdl.Nuke().A02_cUserName) + ",cMenuId=" + DataBase.getString(mdl.Nuke().A03_cMenuId) + ",bLuRu=" + bLuRu + ",bCheck=" + bCheck + ",bBianGeng=" + bBianGeng + ",bClose=" + bClose + " where Id=" + mdl.Nuke().A01_Id;
            DataBase.execCmd(str, cmd);
        }

        public Model.UserPowerInfoCollection Query(System.Data.Common.DbCommand cmd)
        {
            return myQuery("", cmd);
        }

        public Model.UserPowerInfoCollection Query(string cUserName, System.Data.Common.DbCommand cmd)
        {
            string Filter = "cUserName=" + DataBase.getString(cUserName);
            return myQuery(Filter, cmd);
        }