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;
}
}
