示例#1
0
文件: User.cs 项目: fengxing1121/Hi
        private DataRow DetailFromId(string id)
        {
            string  strSql = "select * from bas_user where  user_id = " + id + "";
            DataRow dr     = DataBase.ExecuteDataRow(strSql);

            return(dr);
        }
示例#2
0
文件: User.cs 项目: fengxing1121/Hi
        private DataRow DetailFromCode(string user_code)
        {
            string  strSql = "select * from bas_user where  user_code = '" + user_code + "'";
            DataRow dr     = DataBase.ExecuteDataRow(strSql);

            return(dr);
        }
示例#3
0
        /// <summary>
        /// 得到一个实体内容
        /// </summary>
        public BasRole DetailRole(string id)
        {
            string  strSql = "select * from bas_role where  id = " + id;
            BasRole model  = new BasRole();
            DataRow dr     = DataBase.ExecuteDataRow(strSql);

            return(model);
        }
示例#4
0
        //部门详细信息 Added Liangsx 2010-12-15
        public Org Detail(int id)
        {
            string  strSql = "select * from bas_org_online where  org_id = " + id.ToString();
            Org     model  = new Org();
            DataRow dr     = DataBase.ExecuteDataRow(strSql);

            if (dr == null)
            {
                return(null);
            }
            model.Id      = int.Parse(dr["org_id"].ToString());
            model.OrgName = dr["org_name"].ToString().Trim();
            //model.LinkName = dr["link_name"].ToString().Trim();
            //model.LinkTel = dr["link_tel"].ToString().Trim();
            //model.LinkMobile = dr["link_mobile"].ToString().Trim();


            return(model);
        }
示例#5
0
        /// <summary>
        /// 得到一个实体内容
        /// </summary>
        public BasParam ParamDetail(string id)
        {
            string   strSql = "select * from bas_param where id = " + id;
            BasParam model  = new BasParam();
            DataRow  dr     = DataBase.ExecuteDataRow(strSql);

            model.Id       = dr["id"].ToString().Trim();
            model.ParentId = dr["parent_id"].ToString().Trim();
            model.Grade    = dr["grade"].ToString().Trim();
            model.Code     = dr["code"].ToString().Trim();
            model.Title    = dr["title"].ToString().Trim();

            model.Remark     = dr["remark"].ToString().Trim();
            model.Sort       = dr["sort"].ToString().Trim();
            model.EnableFlag = dr["enable_flag"].ToString().Trim();


            return(model);
        }
示例#6
0
        /// <summary>
        /// 获得数据详细信息
        /// </summary>
        #region 获得数据详细信息
        public BasModule BasModuleDetail(string id)
        {
            BasModule model  = new BasModule();
            string    strSql = " select * from Bas_Module where module_id=" + id;
            DataRow   dr     = DataBase.ExecuteDataRow(strSql);


            model.ModuleId      = dr["module_id"].ToString().Trim();
            model.ModuleFather  = dr["module_father"].ToString().Trim();
            model.ModuleCode    = dr["module_code"].ToString().Trim();
            model.ModuleName    = dr["module_name"].ToString().Trim();
            model.ModuleIcon    = dr["module_icon"].ToString().Trim();
            model.ModuleWidth   = dr["module_width"].ToString().Trim();
            model.ModuleHeight  = dr["module_height"].ToString().Trim();
            model.ModuleUrl     = dr["module_url"].ToString().Trim();
            model.ModuleSort    = dr["module_sort"].ToString().Trim();
            model.EnableFlag    = dr["enable_flag"].ToString().Trim();
            model.ToolbarFlag   = dr["toolbar_flag"].ToString().Trim();
            model.ModulePurview = dr["module_purview"].ToString().Trim();



            return(model);
        }