/// <summary> /// 添加视图 /// </summary> /// <param name="moduleButtonEntity">视图实体</param> public void AddEntity(ModuleColumnEntity moduleColumnEntity) { moduleColumnEntity.Create(); Base_ModuleColumn moduleColumn = new Base_ModuleColumn(); moduleColumn = EntityConvertTools.CopyToModel <ModuleColumnEntity, Base_ModuleColumn>(moduleColumnEntity, null); moduleColumn.Insert(); }
/// <summary> /// 视图列表 /// </summary> /// <returns></returns> public List <ModuleColumnEntity> GetList() { var sql = PetaPoco.Sql.Builder.Append(@"select * from Base_ModuleColumn where 1=1 "); sql.Append(" order by SortCode"); var list = Base_ModuleColumn.Query(sql); return(EntityConvertTools.CopyToList <Base_ModuleColumn, ModuleColumnEntity>(list.ToList())); }
/// <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> /// <param name="moduleId">功能Id</param> /// <returns></returns> public List <ModuleColumnEntity> GetList(string moduleId) { var sql = PetaPoco.Sql.Builder.Append(@"select * from Base_ModuleColumn where 1=1 "); //if (!string.IsNullOrEmpty(moduleId)) //{ sql.Append(" and ModuleId=@0", moduleId); //} sql.Append(" order by SortCode"); var list = Base_ModuleColumn.Query(sql); return(EntityConvertTools.CopyToList <Base_ModuleColumn, ModuleColumnEntity>(list.ToList())); }
/// <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 ModuleColumnEntity GetEntity(string keyValue) { var model = Base_ModuleColumn.SingleOrDefault("where ModuleColumnId=@0", keyValue); return(EntityConvertTools.CopyToModel <Base_ModuleColumn, ModuleColumnEntity>(model, null)); }