コード例 #1
0
ファイル: DAL_SysModule.cs プロジェクト: a157591984/jiguang
        public bool AddSysModule(Model_SysModule model)
        {
            StringBuilder builder = new StringBuilder();

            builder.Append("insert into SysModule(");
            builder.Append("MODULEID,SYSCODE,MODULENAME,PARENTID,SLEVEL,URL,QUERYFORM,OTHKEY,REMARK,IMGICON,ISINTREE,MODULETYPE,ATTACH_SQL,ISINTAB,Depth,isLast,DefaultOrder)");
            builder.Append(" values (");
            builder.Append("@MODULEID,@SYSCODE,@MODULENAME,@PARENTID,@SLEVEL,@URL,@QUERYFORM,@OTHKEY,@REMARK,@IMGICON,@ISINTREE,@MODULETYPE,@ATTACH_SQL,@ISINTAB,@Depth,@isLast,@DefaultOrder)");
            SqlParameter[] cmdParms = new SqlParameter[] {
                new SqlParameter("@MODULEID", SqlDbType.VarChar, 20), new SqlParameter("@SYSCODE", SqlDbType.NChar, 5), new SqlParameter("@MODULENAME", SqlDbType.VarChar, 200), new SqlParameter("@PARENTID", SqlDbType.VarChar, 20), new SqlParameter("@SLEVEL", SqlDbType.VarChar, 0xff), new SqlParameter("@URL", SqlDbType.VarChar, 0xff), new SqlParameter("@QUERYFORM", SqlDbType.VarChar, 0xff), new SqlParameter("@OTHKEY", SqlDbType.VarChar, 0xff), new SqlParameter("@REMARK", SqlDbType.VarChar, 0xff), new SqlParameter("@IMGICON", SqlDbType.VarChar, 50), new SqlParameter("@ISINTREE", SqlDbType.Char, 1), new SqlParameter("@MODULETYPE", SqlDbType.VarChar, 50), new SqlParameter("@ATTACH_SQL", SqlDbType.VarChar, 0xff), new SqlParameter("@ISINTAB", SqlDbType.Char, 1), new SqlParameter("@Depth", SqlDbType.Int, 4), new SqlParameter("@isLast", SqlDbType.Int, 4),
                new SqlParameter("@DefaultOrder", SqlDbType.Int, 4)
            };
            cmdParms[0].Value    = model.MODULEID;
            cmdParms[1].Value    = "00001";
            cmdParms[2].Value    = model.MODULENAME;
            cmdParms[3].Value    = model.PARENTID;
            cmdParms[4].Value    = model.SLEVEL;
            cmdParms[5].Value    = model.URL;
            cmdParms[6].Value    = model.QUERYFORM;
            cmdParms[7].Value    = model.OTHKEY;
            cmdParms[8].Value    = model.REMARK;
            cmdParms[9].Value    = model.IMGICON;
            cmdParms[10].Value   = model.ISINTREE;
            cmdParms[11].Value   = model.MODULETYPE;
            cmdParms[12].Value   = model.ATTACH_SQL;
            cmdParms[13].Value   = model.ISINTAB;
            cmdParms[14].Value   = model.Depth;
            cmdParms[15].Value   = model.isLast;
            cmdParms[0x10].Value = model.DefaultOrder;
            return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }
コード例 #2
0
 /// <summary>
 /// 判断是否存在
 /// </summary>
 /// <param name="type">1添加时,2修改时</param>
 /// <returns>已存在返回true</returns>
 private bool CheckExists(Model_SysModule model, string type)
 {
     try
     {
         return(sysModuleBll.ExistsSysModule(model, type));
     }
     catch (Exception)
     {
         return(true);
     }
 }
コード例 #3
0
 //绑定控件
 protected void BindData(string moduleID, string sysCode)
 {
     try
     {
         Model_SysModule model = sysModuleBll.GetSysModuleModelBySyscodeAndModuleID(sysCode, moduleID);
         //如果是类似新增
         if (actionType == "1")
         {
             txtMODULEID.Text = model.MODULEID;
         }
         else
         {
             txtMODULEID.Text    = model.MODULEID;
             txtMODULEID.Enabled = false;
         }
         txtMODULENAME.Text = model.MODULENAME;
         txtPARENTID.Text   = model.PARENTID;
         txtSLEVEL.Text     = model.SLEVEL;
         txtURL.Text        = model.URL;
         if (model.ISINTREE == "Y")
         {
             rbtISINTREE1.Checked = true;
         }
         else
         {
             rbtISINTREE0.Checked = true;
         }
         txtDepth.Text            = model.Depth.ToString().Trim();
         ddlSysCode.SelectedValue = model.SYSCODE;
         //修改时
         if (actionType == "2")
         {
             ddlSysCode.Enabled = false;
         }
         if (model.isLast == 1)
         {
             rbtisLast1.Checked = true;
         }
         else
         {
             rbtisLast0.Checked = true;
         }
         txtDefaultOrder.Text = model.DefaultOrder.ToString().Trim();
     }
     catch (Exception ex)
     {
         Rc.Common.SystemLog.SystemLog.AddLogErrorFromBS(loginUser.SysUser_ID, Module_Id, string.Format("类:{0},方法:{1},错误信息:{2}, 详细:{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace));
         throw ex;
     }
 }
コード例 #4
0
ファイル: DAL_SysModule.cs プロジェクト: a157591984/jiguang
        public bool Update(Model_SysModule model)
        {
            StringBuilder builder = new StringBuilder();

            builder.Append("update SysModule set ");
            builder.Append("MODULEID=@MODULEID,");
            builder.Append("MODULENAME=@MODULENAME,");
            builder.Append("PARENTID=@PARENTID,");
            builder.Append("SLEVEL=@SLEVEL,");
            builder.Append("URL=@URL,");
            builder.Append("QUERYFORM=@QUERYFORM,");
            builder.Append("OTHKEY=@OTHKEY,");
            builder.Append("REMARK=@REMARK,");
            builder.Append("IMGICON=@IMGICON,");
            builder.Append("ISINTREE=@ISINTREE,");
            builder.Append("MODULETYPE=@MODULETYPE,");
            builder.Append("ATTACH_SQL=@ATTACH_SQL,");
            builder.Append("ISINTAB=@ISINTAB,");
            builder.Append("Depth=@Depth,");
            builder.Append("isLast=@isLast,");
            builder.Append("DefaultOrder=@DefaultOrder,");
            builder.Append("syscode=@syscode");
            builder.Append(" where ");
            SqlParameter[] cmdParms = new SqlParameter[] {
                new SqlParameter("@MODULEID", SqlDbType.VarChar, 20), new SqlParameter("@MODULENAME", SqlDbType.VarChar, 200), new SqlParameter("@PARENTID", SqlDbType.VarChar, 20), new SqlParameter("@SLEVEL", SqlDbType.VarChar, 0xff), new SqlParameter("@URL", SqlDbType.VarChar, 0xff), new SqlParameter("@QUERYFORM", SqlDbType.VarChar, 0xff), new SqlParameter("@OTHKEY", SqlDbType.VarChar, 0xff), new SqlParameter("@REMARK", SqlDbType.VarChar, 0xff), new SqlParameter("@IMGICON", SqlDbType.VarChar, 50), new SqlParameter("@ISINTREE", SqlDbType.Char, 1), new SqlParameter("@MODULETYPE", SqlDbType.VarChar, 50), new SqlParameter("@ATTACH_SQL", SqlDbType.VarChar, 0xff), new SqlParameter("@ISINTAB", SqlDbType.Char, 1), new SqlParameter("@Depth", SqlDbType.Int, 4), new SqlParameter("@isLast", SqlDbType.Int, 4), new SqlParameter("@DefaultOrder", SqlDbType.Int, 4),
                new SqlParameter("@syscode", SqlDbType.NChar, 5)
            };
            cmdParms[0].Value    = model.MODULEID;
            cmdParms[1].Value    = model.MODULENAME;
            cmdParms[2].Value    = model.PARENTID;
            cmdParms[3].Value    = model.SLEVEL;
            cmdParms[4].Value    = model.URL;
            cmdParms[5].Value    = model.QUERYFORM;
            cmdParms[6].Value    = model.OTHKEY;
            cmdParms[7].Value    = model.REMARK;
            cmdParms[8].Value    = model.IMGICON;
            cmdParms[9].Value    = model.ISINTREE;
            cmdParms[10].Value   = model.MODULETYPE;
            cmdParms[11].Value   = model.ATTACH_SQL;
            cmdParms[12].Value   = model.ISINTAB;
            cmdParms[13].Value   = model.Depth;
            cmdParms[14].Value   = model.isLast;
            cmdParms[15].Value   = model.DefaultOrder;
            cmdParms[0x10].Value = model.syscode;
            return(DbHelperSQL.ExecuteSql(builder.ToString(), cmdParms) > 0);
        }
コード例 #5
0
 //绑定模块
 protected Model_SysModule InsertOrUpdate()
 {
     try
     {
         Model_SysModule model = new Model_SysModule();
         model.MODULEID   = txtMODULEID.Text.Trim();
         model.MODULENAME = txtMODULENAME.Text.Trim();
         model.PARENTID   = txtPARENTID.Text.Trim();
         model.SLEVEL     = txtSLEVEL.Text.Trim();
         model.URL        = txtURL.Text.Trim();
         if (rbtISINTREE1.Checked)
         {
             model.ISINTREE = "Y";
         }
         else
         {
             model.ISINTREE = "N";
         }
         if (!string.IsNullOrEmpty(txtDepth.Text.Trim()) && IsInt(txtDepth.Text.Trim()))
         {
             model.Depth = int.Parse(txtDepth.Text.Trim());
         }
         if (rbtisLast1.Checked)
         {
             model.isLast = 1;
         }
         else
         {
             model.isLast = 0;
         }
         if (ddlSysCode.SelectedValue.Trim() != null && ddlSysCode.SelectedValue.Trim() != "" && ddlSysCode.SelectedValue.Trim() != "-1")
         {
             model.SYSCODE = ddlSysCode.SelectedValue.Trim();
         }
         if (txtDefaultOrder.Text.Trim() != "" && IsInt(txtDefaultOrder.Text.Trim()))
         {
             model.DefaultOrder = int.Parse(txtDefaultOrder.Text.Trim());
         }
         return(model);
     }
     catch (Exception ex)
     {
         Rc.Common.SystemLog.SystemLog.AddLogErrorFromBS(loginUser.SysUser_ID, Module_Id, string.Format("类:{0},方法:{1},错误信息:{2}, 详细:{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace));
         throw ex;
     }
 }
コード例 #6
0
        //绑定控件
        protected void BindData(string moduleID)
        {
            try
            {
                Model_SysModule model = sysModuleBll.GetSysModuleModelBySyscodeAndModuleID(moduleID);
                //如果是类似新增
                if (actionType == "1")
                {
                    txtMODULEID.Text = model.MODULEID;
                }
                else
                {
                    txtMODULEID.Text    = model.MODULEID;
                    txtMODULEID.Enabled = false;
                }
                txtMODULENAME.Text = model.MODULENAME;
                txtPARENTID.Text   = model.PARENTID;
                txtSLEVEL.Text     = model.SLEVEL;
                txtURL.Text        = model.URL;
                if (model.ISINTREE == "Y")
                {
                    rbtISINTREE1.Checked = true;
                }
                else
                {
                    rbtISINTREE0.Checked = true;
                }
                txtDepth.Text = model.Depth.ToString().Trim();

                if (model.isLast == 1)
                {
                    rbtisLast1.Checked = true;
                }
                else
                {
                    rbtisLast0.Checked = true;
                }
                txtDefaultOrder.Text = model.DefaultOrder.ToString().Trim();
            }
            catch (Exception ex)
            {
                new BLL_clsAuth().AddLogErrorFromBS(Module_Id, string.Format("类:{0},方法:{1},错误信息:{2}, 详细:{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace));
                throw ex;
            }
        }
コード例 #7
0
        public List <Model_SysModule> DataTableToList(DataTable dt)
        {
            List <Model_SysModule> list = new List <Model_SysModule>();
            int count = dt.Rows.Count;

            if (count > 0)
            {
                for (int i = 0; i < count; i++)
                {
                    Model_SysModule item = this.dal.DataRowToModel(dt.Rows[i]);
                    if (item != null)
                    {
                        list.Add(item);
                    }
                }
            }
            return(list);
        }
コード例 #8
0
ファイル: DAL_SysModule.cs プロジェクト: a157591984/jiguang
        public bool ExistsSysModule(Model_SysModule model, string type)
        {
            StringBuilder builder = new StringBuilder();
            bool          flag    = false;

            if (type == "1")
            {
                builder.AppendFormat("SELECT COUNT(*) FROM SysModule WHERE SysCode='{0}' and  MODULEID='{1}'", model.SYSCODE, model.MODULEID);
            }
            else if (type == "2")
            {
                builder.AppendFormat("SELECT COUNT(*) FROM SysModule WHERE SysCode='{0}' and  MODULEID!='{1}'", model.SYSCODE, model.MODULEID);
            }
            if (int.Parse(DbHelperSQL.GetSingle(builder.ToString()).ToString()) > 0)
            {
                flag = true;
            }
            return(flag);
        }
コード例 #9
0
        //绑定模块
        protected Model_SysModule InsertOrUpdate()
        {
            try
            {
                Model_SysModule model = new Model_SysModule();
                model.MODULEID   = txtMODULEID.Text.Trim();
                model.MODULENAME = txtMODULENAME.Text.Trim();
                model.PARENTID   = txtPARENTID.Text.Trim();
                model.SLEVEL     = txtSLEVEL.Text.Trim();
                model.URL        = txtURL.Text.Trim();
                if (rbtISINTREE1.Checked)
                {
                    model.ISINTREE = "Y";
                }
                else
                {
                    model.ISINTREE = "N";
                }
                if (!string.IsNullOrEmpty(txtDepth.Text.Trim()) && txtDepth.Text.Trim().IsInt())
                {
                    model.Depth = int.Parse(txtDepth.Text.Trim());
                }
                if (rbtisLast1.Checked)
                {
                    model.isLast = 1;
                }
                else
                {
                    model.isLast = 0;
                }

                if (txtDefaultOrder.Text.Trim() != "" && txtDefaultOrder.Text.Trim().IsInt())
                {
                    model.DefaultOrder = int.Parse(txtDefaultOrder.Text.Trim());
                }
                return(model);
            }
            catch (Exception ex)
            {
                new BLL_clsAuth().AddLogErrorFromBS(Module_Id, string.Format("类:{0},方法:{1},错误信息:{2}, 详细:{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace));
                throw ex;
            }
        }
コード例 #10
0
 protected void btn_Search_Click(object sender, EventArgs e)
 {
     try
     {
         CheckInput();
         Model_SysModule model = InsertOrUpdate();
         if (module_ID != null && module_ID != "" && actionType == "2")
         {
             if (sysModuleBll.UpdateSysModuleBySyscodeAndModuleID(model))
             {
                 ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>parent.Handel('操作成功', '');</script>");
             }
             else
             {
                 ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>parent.showTipsErr('修改模块失败!', '4');</script>");
             }
         }
         else
         {
             if (CheckExists(model, "1"))
             {
                 ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>parent.showTipsErr('此模块ID已存在', '4');</script>");
             }
             else
             {
                 if (sysModuleBll.AddSysModule(model))
                 {
                     ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>parent.Handel('操作成功', '');</script>");
                 }
                 else
                 {
                     ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>parent.showTipsErr('新增模块失败!', '4');</script>");
                 }
             }
         }
     }
     catch (Exception ex)
     {
         Rc.Common.SystemLog.SystemLog.AddLogErrorFromBS(loginUser.SysUser_ID, Module_Id, string.Format("类:{0},方法:{1},错误信息:{2}, 详细:{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace));
         throw ex;
     }
 }
コード例 #11
0
 protected void btn_Search_Click(object sender, EventArgs e)
 {
     try
     {
         Model_SysModule model = InsertOrUpdate();
         if (module_ID != null && module_ID != "" && actionType == "2")
         {
             if (sysModuleBll.UpdateSysModuleBySyscodeAndModuleID(model))
             {
                 ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>$(function(){layer.ready(function(){layer.msg('编辑成功',{icon:1,time:1000},function(){parent.window.location.href=window.parent.pageUrl})})})</script>");
             }
             else
             {
                 ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>$(function(){layer.ready(function(){layer.msg('修改失败',{icon:2})})})</script>");
             }
         }
         else
         {
             if (CheckExists(model, "1"))
             {
                 ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>$(function(){layer.ready(function(){layer.msg('此模块ID已存在',{icon:4})})})</script>");
             }
             else
             {
                 if (sysModuleBll.AddSysModule(model))
                 {
                     ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>$(function(){layer.ready(function(){layer.msg('操作成功',{icon:1,time:1000},function(){parent.window.location.href=window.parent.pageUrl})})})</script>");
                 }
                 else
                 {
                     ClientScript.RegisterStartupScript(this.GetType(), "fildSave", "<script type='text/javascript'>$(function(){layer.ready(function(){layer.msg('新增模块失败',{icon:2})})})</script>");
                 }
             }
         }
     }
     catch (Exception ex)
     {
         new BLL_clsAuth().AddLogErrorFromBS(Module_Id, string.Format("类:{0},方法:{1},错误信息:{2}, 详细:{3}", ex.TargetSite.DeclaringType.ToString(), ex.TargetSite.Name.ToString(), ex.Message, ex.StackTrace));
         throw ex;
     }
 }
コード例 #12
0
        //
        // 摘要:
        //     在过程请求授权时调用。
        //
        // 参数:
        //   filterContext:
        //     筛选器上下文,它封装有关使用 System.Web.Mvc.AuthorizeAttribute 的信息。
        //
        // 异常:
        //   T:System.ArgumentNullException:
        //     filterContext 参数为 null。
        public override void OnAuthorization(AuthorizationContext filterContext)
        {
            // base.OnAuthorization(filterContext);

            /**
             * 如果请求的区域包含area并且area的名称等于Admin
             * 那么就进行权限验证
             * */
            if (filterContext.RouteData.DataTokens.Keys.Contains("area"))
            //  && filterContext.RouteData.DataTokens["area"].ToString().ToLower().IndexOf("_area")>0)
            {
                /*
                 * Action方法本身以及它所属的控制器都没有定义Skip特性
                 * 那么就进行权限验证
                 */
                if (!filterContext.ActionDescriptor.IsDefined(typeof(SkipAttribute), false) &&
                    !filterContext.ActionDescriptor.ControllerDescriptor.IsDefined(typeof(SkipAttribute), false))
                {
                    /*
                     * 判断有没有登录
                     */
                    if (!Model_UserInfo.IsLogin())
                    {
                        filterContext.Result = new BaseController().Redirect("/AdminLogin/Login", filterContext.ActionDescriptor, AjaxStatu.nologin);
                        return;
                    }
                    string        areaName    = filterContext.RouteData.DataTokens["area"].ToString();
                    string        actionName  = filterContext.ActionDescriptor.ActionName;
                    string        controlName = filterContext.ActionDescriptor.ControllerDescriptor.ControllerName;
                    string        httpMethod  = filterContext.RequestContext.HttpContext.Request.HttpMethod;
                    RequestMethod method      = httpMethod.ToLower().Equals("get") ? RequestMethod.GET : httpMethod.ToLower().Equals("post") ? RequestMethod.POST : RequestMethod.HEAD;
                    if (!Model_SysModule.ExistsPermission(areaName, controlName, actionName, method))
                    {
                        filterContext.Result = new BaseController().Redirect("/AdminLogin/Login", filterContext.ActionDescriptor, AjaxStatu.nopermission);
                        return;
                    }
                }
            }
        }
コード例 #13
0
 public bool ExistsSysModule(Model_SysModule model, string type)
 {
     return(this.DAL.ExistsSysModule(model, type));
 }
コード例 #14
0
ファイル: BLL_SysModule.cs プロジェクト: a157591984/jiguang
 public bool Update(Model_SysModule model)
 {
     return(this.dal.Update(model));
 }
コード例 #15
0
ファイル: BLL_SysModule.cs プロジェクト: a157591984/jiguang
 public bool Add(Model_SysModule model)
 {
     return(this.dal.Add(model));
 }
コード例 #16
0
ファイル: DAL_SysModule.cs プロジェクト: a157591984/jiguang
        public Model_SysModule DataRowToModel(DataRow row)
        {
            Model_SysModule module = new Model_SysModule();

            if (row != null)
            {
                if (row["MODULEID"] != null)
                {
                    module.MODULEID = row["MODULEID"].ToString();
                }
                if (row["SYSCODE"] != null)
                {
                    module.SYSCODE = row["SYSCODE"].ToString();
                }
                if (row["MODULENAME"] != null)
                {
                    module.MODULENAME = row["MODULENAME"].ToString();
                }
                if (row["PARENTID"] != null)
                {
                    module.PARENTID = row["PARENTID"].ToString();
                }
                if (row["SLEVEL"] != null)
                {
                    module.SLEVEL = row["SLEVEL"].ToString();
                }
                if (row["URL"] != null)
                {
                    module.URL = row["URL"].ToString();
                }
                if (row["QUERYFORM"] != null)
                {
                    module.QUERYFORM = row["QUERYFORM"].ToString();
                }
                if (row["OTHKEY"] != null)
                {
                    module.OTHKEY = row["OTHKEY"].ToString();
                }
                if (row["REMARK"] != null)
                {
                    module.REMARK = row["REMARK"].ToString();
                }
                if (row["IMGICON"] != null)
                {
                    module.IMGICON = row["IMGICON"].ToString();
                }
                if (row["ISINTREE"] != null)
                {
                    module.ISINTREE = row["ISINTREE"].ToString();
                }
                if (row["MODULETYPE"] != null)
                {
                    module.MODULETYPE = row["MODULETYPE"].ToString();
                }
                if (row["ATTACH_SQL"] != null)
                {
                    module.ATTACH_SQL = row["ATTACH_SQL"].ToString();
                }
                if (row["ISINTAB"] != null)
                {
                    module.ISINTAB = row["ISINTAB"].ToString();
                }
                if ((row["Depth"] != null) && (row["Depth"].ToString() != ""))
                {
                    module.Depth = new int?(int.Parse(row["Depth"].ToString()));
                }
                if ((row["isLast"] != null) && (row["isLast"].ToString() != ""))
                {
                    module.isLast = new int?(int.Parse(row["isLast"].ToString()));
                }
                if ((row["DefaultOrder"] != null) && (row["DefaultOrder"].ToString() != ""))
                {
                    module.DefaultOrder = new int?(int.Parse(row["DefaultOrder"].ToString()));
                }
            }
            return(module);
        }
コード例 #17
0
ファイル: DAL_SysModule.cs プロジェクト: a157591984/jiguang
        internal Model_SysModule GetSysModuleModelBySyscodeAndModuleID(DbTransaction tran, string moduleid)
        {
            StringBuilder builder = new StringBuilder();

            builder.Append(" SELECT ");
            builder.Append(" TOP 1 * ");
            builder.Append(" FROM ");
            builder.Append(" SysModule ");
            builder.Append(" WHERE ");
            builder.Append(" MODULEID=@MODULEID  ");
            SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@MODULEID", SqlDbType.VarChar, 20) };
            cmdParms[0].Value = moduleid;
            DataSet         set    = DbHelperSQL.Query(builder.ToString(), cmdParms);
            Model_SysModule module = null;

            if (set.Tables[0].Rows.Count > 0)
            {
                DataRow row = set.Tables[0].Rows[0];
                module = new Model_SysModule();
                if (row["MODULEID"] != null)
                {
                    module.MODULEID = row["MODULEID"].ToString();
                }
                if (row["MODULENAME"] != null)
                {
                    module.MODULENAME = row["MODULENAME"].ToString();
                }
                if (row["PARENTID"] != null)
                {
                    module.PARENTID = row["PARENTID"].ToString();
                }
                if (row["SLEVEL"] != null)
                {
                    module.SLEVEL = row["SLEVEL"].ToString();
                }
                if (row["URL"] != null)
                {
                    module.URL = row["URL"].ToString();
                }
                if (row["QUERYFORM"] != null)
                {
                    module.QUERYFORM = row["QUERYFORM"].ToString();
                }
                if (row["OTHKEY"] != null)
                {
                    module.OTHKEY = row["OTHKEY"].ToString();
                }
                if (row["REMARK"] != null)
                {
                    module.REMARK = row["REMARK"].ToString();
                }
                if (row["IMGICON"] != null)
                {
                    module.IMGICON = row["IMGICON"].ToString();
                }
                if (row["ISINTREE"] != null)
                {
                    module.ISINTREE = row["ISINTREE"].ToString();
                }
                if (row["MODULETYPE"] != null)
                {
                    module.MODULETYPE = row["MODULETYPE"].ToString();
                }
                if (row["ATTACH_SQL"] != null)
                {
                    module.ATTACH_SQL = row["ATTACH_SQL"].ToString();
                }
                if (row["ISINTAB"] != null)
                {
                    module.ISINTAB = row["ISINTAB"].ToString();
                }
                if (row["Depth"] != null)
                {
                    if (string.IsNullOrWhiteSpace(row["Depth"].ToString()))
                    {
                        module.Depth = null;
                    }
                    else
                    {
                        module.Depth = new int?(int.Parse(row["Depth"].ToString()));
                    }
                }
                if (row["isLast"] != null)
                {
                    if (string.IsNullOrWhiteSpace(row["isLast"].ToString()))
                    {
                        module.isLast = null;
                    }
                    else
                    {
                        module.isLast = new int?(int.Parse(row["isLast"].ToString()));
                    }
                }
                if (row["DefaultOrder"] == null)
                {
                    return(module);
                }
                if (string.IsNullOrWhiteSpace(row["DefaultOrder"].ToString()))
                {
                    module.DefaultOrder = null;
                    return(module);
                }
                module.DefaultOrder = new int?(int.Parse(row["DefaultOrder"].ToString()));
            }
            return(module);
        }
コード例 #18
0
 public bool AddSysModule(Model_SysModule model)
 {
     return(this.DAL.AddSysModule(model));
 }
コード例 #19
0
 public bool UpdateSysModuleBySyscodeAndModuleID(Model_SysModule model)
 {
     return(this.DAL.UpdateSysModuleBySyscodeAndModuleID(model));
 }