Beispiel #1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public bool BasModuleAdd(BasModule model)
        {
            StringBuilder strb = new StringBuilder();
            strb.Append(" Insert Into Bas_Module ");
            strb.Append(" ( ");
            //strb.Append("module_id, ");
            strb.Append("module_father, ");
            strb.Append("module_code, ");
            strb.Append("module_name, ");
            strb.Append("module_icon, ");
            strb.Append("module_width, ");
            strb.Append("module_height, ");
            strb.Append("module_url, ");
            strb.Append("module_sort, ");
            strb.Append("enable_flag, ");
            strb.Append("toolbar_flag, ");
            strb.Append("module_purview ");
            strb.Append(" )");
            strb.Append(" Values( ");
            //strb.Append("" + model.ModuleId + ", ");
            strb.Append("" + model.ModuleFather + ", ");
            strb.Append("'" + model.ModuleCode + "', ");
            strb.Append("'" + model.ModuleName + "', ");
            strb.Append("'" + model.ModuleIcon + "', ");
            strb.Append("" + model.ModuleWidth + ", ");
            strb.Append("" + model.ModuleHeight + ", ");
            strb.Append("'" + model.ModuleUrl + "', ");
            strb.Append("'" + model.ModuleSort + "', ");
            strb.Append("'" + model.EnableFlag + "', ");
            strb.Append("'" + model.ToolbarFlag + "', ");
            strb.Append("'" + model.ModulePurview + "' ");
            strb.Append(" )");

            return DataBase.ExecuteNonQuery(strb.ToString()) > 0 ? true : false;
        }
Beispiel #2
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public bool BasModuleUpdate(BasModule model)
        {
            StringBuilder strb = new StringBuilder();
            strb.Append(" Update Bas_Module ");
            strb.Append(" Set ");
            //strb.Append("module_id       = " + model.ModuleId + ",");
            strb.Append("module_father   = " + model.ModuleFather + ",");
            strb.Append("module_code     = '" + model.ModuleCode + "',");
            strb.Append("module_name     = '" + model.ModuleName + "',");
            strb.Append("module_icon     = '" + model.ModuleIcon + "',");
            strb.Append("module_width    = " + model.ModuleWidth + ",");
            strb.Append("module_height   = " + model.ModuleHeight + ",");
            strb.Append("module_url      = '" + model.ModuleUrl + "',");
            strb.Append("module_sort     = '" + model.ModuleSort + "',");
            strb.Append("enable_flag     = '" + model.EnableFlag + "',");
            strb.Append("toolbar_flag    = '" + model.ToolbarFlag + "',");
            strb.Append("module_purview  = '" + model.ModulePurview + "'");
            strb.Append(" where module_id = " + model.ModuleId);

            return DataBase.ExecuteNonQuery(strb.ToString()) > 0 ? true : false;
        }
Beispiel #3
0
 public bool BasModuleUpdate(BasModule model)
 {
     return dal.BasModuleUpdate(model);
 }
Beispiel #4
0
        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;
        }
Beispiel #5
0
 public bool BasModuleAdd(BasModule model)
 {
     return dal.BasModuleAdd(model);
 }