public void Add() { try { if (this.tree_Module.FocusedNode != null) { Base_Module BM = this.tree_Module.FocusedNode.Tag as Base_Module; Base_Button BB = new Base_Button(); BB.ModuleId = BM.ModuleId; EditForm form = new EditForm(BB, modolueName, true); form.IsAdd = true; if (form.ShowDialog() == DialogResult.OK) { listEntity.Add(form.Entity); } } else { MsgShowInfor("请选择父系统模块"); } } catch (Exception ex) { MsgShowException(ex); } }
public void GetDataSource() { if (DataSource == null) { DataSource = new Base_Module(); } DataSource.ParentId = ParentID; DataSource.AllowButton = ckAllowButton.Checked ? 1 : 0; DataSource.AllowForm = ckAllowForm.Checked ? 1 : 0; DataSource.AllowView = ckAllowView.Checked ? 1 : 0; DataSource.Authority = ckAuthority.Checked ? 1 : 0; DataSource.Code = txtCode.Text; DataSource.Category = txtCategory.Text; DataSource.DataScope = ckDataScope.Checked ? 1 : 0; DataSource.Enabled = ckEnabled.Checked ? 1 : 0; DataSource.Target = txtTarget.Text; DataSource.Icon = txtIcon.Text; DataSource.FullName = txtName.Text; DataSource.Isexpand = ckIsexpand.Checked ? 1 : 0; DataSource.SortCode = int.Parse(txtSort.Text); DataSource.Level = int.Parse(txtLevel.Text); DataSource.Location = txtLocation.Text; DataSource.Remark = txtRemark.Text; }
/// <summary> /// 功能列表 /// </summary> /// <returns></returns> public IEnumerable <ModuleEntity> GetList() { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM Base_Module Order By SortCode"); var list = Base_Module.Query(strSql.ToString()); return(EntityConvertTools.CopyToList <Base_Module, ModuleEntity>(list.ToList())); }
/// <summary> /// 模块设置表获取对象返回JSON /// </summary> /// <param name="key">主键</param> /// <returns></returns> public ActionResult GetBase_ModuleForm(string key) { if (!string.IsNullOrEmpty(key)) { base_module = base_modulebll.GetEntity(key); string strJson = JsonHelper.ObjectToJson(base_module); return(Content(strJson)); } return(null); }
/// <summary> /// 获取最大编号 /// </summary> /// <returns></returns> public int GetSortCode() { int sortCode = Base_Module.Query("select * from Base_Module").Max(t => t.SortCode).ToInt(); if (!string.IsNullOrEmpty(sortCode.ToString())) { return(sortCode + 1); } return(100001); }
/// <summary> /// 保存表单(新增、修改) /// </summary> /// <param name="keyValue">主键值</param> /// <param name="moduleEntity">功能实体</param> /// <param name="moduleButtonList">按钮实体列表</param> /// <param name="moduleColumnList">视图实体列表</param> /// <returns></returns> public void SaveForm(string keyValue, ModuleEntity moduleEntity, List <ModuleButtonEntity> moduleButtonList, List <ModuleColumnEntity> moduleColumnList) { try { using (var tran = QSDMS_SQLDB.GetInstance().GetTransaction()) { if (!string.IsNullOrEmpty(keyValue)) { moduleEntity.Modify(keyValue); Base_Module moudle = Base_Module.SingleOrDefault("where ModuleId=@0", keyValue); //if (moduleEntity.UrlAddress == null) //{ // moduleEntity.UrlAddress = ""; //} moudle = EntityConvertTools.CopyToModel <ModuleEntity, Base_Module>(moduleEntity, moudle); moudle.ModuleId = keyValue; moudle.Update(); } else { moduleEntity.Create(); Base_Module moudle = new Base_Module(); moudle = EntityConvertTools.CopyToModel <ModuleEntity, Base_Module>(moduleEntity, null); moudle.Insert(); } //删除操作按钮 Base_ModuleButton.Delete("where ModuleId=@0", keyValue); if (moduleButtonList != null) { foreach (ModuleButtonEntity buttonItem in moduleButtonList) { Base_ModuleButton modulebutton = new Base_ModuleButton(); modulebutton = EntityConvertTools.CopyToModel <ModuleButtonEntity, Base_ModuleButton>(buttonItem, null); modulebutton.Insert(); } } //删除字段 Base_ModuleColumn.Delete("where ModuleId=@0", keyValue); if (moduleColumnList != null) { foreach (ModuleColumnEntity columnItem in moduleColumnList) { Base_ModuleColumn modulecolumn = new Base_ModuleColumn(); modulecolumn = EntityConvertTools.CopyToModel <ModuleColumnEntity, Base_ModuleColumn>(columnItem, null); modulecolumn.Insert(); } } tran.Complete(); } } catch (Exception) { throw; } }
/// <summary> /// 激活对象窗口 /// </summary> private void ShowOleFile(string moduleID) { foreach (DevExpress.XtraTabbedMdi.XtraMdiTabPage page in xtraTabbedMdiManager.Pages) { Base_Module BM = (page.MdiChild as BaseFormEx).Tag as Base_Module; if (BM != null && BM.ModuleId == moduleID) { xtraTabbedMdiManager.SelectedPage = page; return; } } }
/// <summary> /// 点击树形节点 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tree_Module_Click(object sender, EventArgs e) { if (this.tree_Module.FocusedNode == null || this.tree_Module.FocusedNode.ImageIndex == 0) { return; } Base_Module BM = this.tree_Module.FocusedNode.Tag as Base_Module; if (BM != null) { OpenOleFile(BM.ModuleId); } }
private void tree_Module_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e) { if (this.tree_Module.FocusedNode != null) { Base_Module BM = this.tree_Module.FocusedNode.Tag as Base_Module; if (BM != null && BM.Category == "页面") { modolueName = BM.FullName; listEntity = butonBll.GetBindButtonList("", BM.ModuleId); this.grid_Main.DataSource = listEntity; } } }
/// <summary> /// 功能名称不能重复 /// </summary> /// <param name="fullName">名称</param> /// <param name="keyValue">主键</param> /// <returns></returns> public bool ExistFullName(string fullName, string keyValue) { var sql = PetaPoco.Sql.Builder.Append(@"select * from Base_Module where 1=1 "); if (!string.IsNullOrEmpty(fullName)) { sql.Append(" and FullName=@0", fullName); } if (!string.IsNullOrEmpty(keyValue)) { sql.Append(" and ModuleId!=@0", keyValue); } return(Base_Module.Query(sql).Count() == 0 ? true : false); }
private void btn_OK_Click(object sender, EventArgs e) { try { if (IsAdd) { string ParentId = Entity.ModuleId; Entity = new Base_Module(); Entity.ParentId = ParentId; } List <IParameterAble> listControl = new List <IParameterAble>(); listControl.Add(txtSortCode); listControl.Add(comCategory); listControl.Add(txtFullName); IDatabase database = new Database(); if (!CheckPara(listControl, Erro)) { return; } Entity.Category = comCategory.Text; Entity.Code = txtCode.Text; Entity.FullName = txtFullName.Text; Entity.Icon = txtIcon.Text; Entity.SortCode = Convert.ToInt32(txtSortCode.Text); Entity.DLL = txtDLL.Text; Entity.CLASS = txtCLASS.Text; Entity.IsOffLine = chkIsOffLine.Checked; if (IsAdd) { Entity.Create(); database.Insert <Base_Module>(Entity); } else { Entity.Modify(Entity.ModuleId); database.Update <Base_Module>(Entity); } this.DialogResult = DialogResult.OK; this.Close(); } catch (Exception ex) { MsgShowException(ex); } }
/// <summary> /// 创建子窗体 /// </summary> /// <param name="form">窗体</param> /// <param name="module">模块</param> private void CreateOleFile(BaseFormEx form, Base_Module module) { form.FormClosed += form_FormClosed; form.FormClosing += form_FormClosing; form.Text = module.FullName; form.Tag = module; form.MdiParent = this; form.ShowIcon = true; form.Show(); XtraMdiTabPage page = this.xtraTabbedMdiManager.Pages[form]; if (module.Icon != null) { page.Image = this.Img_Module.Images[module.Icon]; } showModels.Add(module); }
public EditForm(Base_Module BM, string parentFullName, bool isAdd) { InitializeComponent(); IsAdd = isAdd; Entity = BM; txtParentName.Text = parentFullName; if (!IsAdd) { comCategory.Text = Entity.Category; txtCode.Text = Entity.Code; txtFullName.Text = Entity.FullName; txtIcon.Text = Entity.Icon; txtSortCode.Text = Entity.SortCode.ToString(); txtDLL.Text = Entity.DLL; txtCLASS.Text = Entity.CLASS; chkIsOffLine.Checked = Entity.IsOffLine; } }
/// <summary> /// 加载树 /// </summary> /// <param name="p_TreeNode"></param> /// <param name="p_Module"></param> private void Build_Tree(TreeListNode p_TreeNode, Base_Module p_Module) { List <Base_Module> baseModule = listModule.Where(item => item.ParentId == p_Module.ModuleId).ToList(); foreach (Base_Module module in baseModule) { TreeListNode treeNode = p_TreeNode.Nodes.Add(new object[] { module.FullName }); treeNode.Tag = module; if (module.Icon != null) { if (!this.Img_Module.Images.ContainsKey(module.Icon)) { this.Img_Module.Images.Add(module.Icon, Image.FromFile(ConstString.Images16 + module.Icon, true)); } treeNode.ImageIndex = this.Img_Module.Images.IndexOfKey(module.Icon); treeNode.SelectImageIndex = this.Img_Module.Images.IndexOfKey(module.Icon); } Build_Tree(treeNode, module); } }
/// <summary> /// 模块设置表提交表单信息 /// </summary> /// <param name="base_module">模块设置表实体</param> /// <returns></returns> public ActionResult SubmitBase_ModuleForm(Base_Module base_module) { string key = Request["key"]; //主键 bool IsOk = false; if (!string.IsNullOrEmpty(key))//判断是否编辑 { base_module.ModuleId = key; base_module.ModifyDate = DateTime.Now; base_module.ModifyUserId = SessionHelper.GetSessionUser().UserId; base_module.ModifyUserName = SessionHelper.GetSessionUser().UserName; IsOk = base_modulebll.UpdateEntity(base_module); } else { base_module.ModuleId = CommonHelper.GetGuid; base_module.CreateUserId = SessionHelper.GetSessionUser().UserId; base_module.CreateUserName = SessionHelper.GetSessionUser().UserName; base_module.SortCode = CommonHelper.GetInt(base_modulebll.GetMaxCode()); IsOk = base_modulebll.AddEntity(base_module); } return(Content(IsOk.ToString())); }
/// <summary> /// 打开窗体 /// </summary> /// <param name="moduleID"></param> private void OpenOleFile(string moduleID) { Base_Module BM = listModule.Find(item => item.ModuleId == moduleID); if (BM == null || BM.Category == "目录") { return; } if (ManagerUser.IsOffLine && BM.IsOffLine == false) { MsgWarning("该界面不支持脱机"); return; } Assembly assembly = Assembly.LoadFrom(Application.StartupPath + "\\" + BM.DLL + ".dll"); object form = assembly.CreateInstance(BM.CLASS); if (form == null) { return; } ShowWaitForm("正在加载窗体..."); BaseFormEx homeForm = (BaseFormEx)form; Build_ToolMenu(BM.ModuleId, homeForm); if (showModels.Contains(BM)) { ShowOleFile(BM.ModuleId); } else { CreateOleFile(homeForm, BM); } this.ToolMenu.Visible = true; this.DefaultMenu.Visible = false; CloseWaitForm(); }
/// <summary> /// 删除功能 /// </summary> /// <param name="keyValue">主键</param> public void RemoveForm(string keyValue) { try { QSDMS_SQLDB db = QSDMS_SQLDB.GetInstance(); using (var tran = db.GetTransaction()) { int count = db.Fetch <Base_Module>("select * from Base_Module").FindAll(t => t.ParentId == keyValue).Count(); if (count > 0) { throw new Exception("当前所选数据有子节点数据!"); } Base_Module.Delete("where ModuleId=@0", keyValue); Base_ModuleButton.Delete("where ModuleId=@0", keyValue); Base_ModuleColumn.Delete("where ModuleId=@0", keyValue); //提交事务 tran.Complete(); } } catch (Exception) { throw; } }
/// <summary> /// 功能实体 /// </summary> /// <param name="keyValue">主键值</param> /// <returns></returns> public ModuleEntity GetEntity(string keyValue) { var model = Base_Module.SingleOrDefault("where ModuleId=@0", keyValue); return(EntityConvertTools.CopyToModel <Base_Module, ModuleEntity>(model, null)); }
public void DeleteBase_Module(Base_Module model) { _dbSession.Base_ModuleDal.Delete(model); _dbSession.UnitWork.Commit(); }
public void AddBase_Module(Base_Module model) { _dbSession.Base_ModuleDal.Add(model); _dbSession.UnitWork.Commit(); }
public bool SaveOrUpdate(Base_Module data) { try { if (string.IsNullOrEmpty(data.Moduleno)) { data.Moduleno = GenerateModuleNo(data.Pguid); } CommonDao.SaveOrUpdate(data); return true; } catch (Exception e) { Log.Error("用户数据编辑", e); return false; } }