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