public Response Update(AddOrUpdateBuilderTableReq obj)
{
var result = new Response();
try
{
_app.Update(obj);
}
catch (Exception ex)
{
result.Code = 500;
result.Message = ex.InnerException?.Message ?? ex.Message;
}
return(result);
}
public string Add(AddOrUpdateBuilderTableReq req)
{
if (string.IsNullOrEmpty(req.TableName))
{
throw new Exception("英文表名不能为空");
}
if (string.IsNullOrEmpty(req.ModuleName))
{
throw new Exception("模块名称不能为空");
}
if (string.IsNullOrEmpty(req.Namespace))
{
throw new Exception("命名空间不能为空");
}
var obj = AddTableAndColumns(req.MapTo <BuilderTable>());
UnitWork.Save();
return(obj.Id);
}
public void Update(AddOrUpdateBuilderTableReq obj)
{
var user = _auth.GetCurrentUser().User;
UnitWork.Update <BuilderTable>(u => u.Id == obj.Id, u => new BuilderTable
{
TableName = obj.TableName,
Comment = obj.Comment,
DetailTableName = obj.DetailTableName,
DetailComment = obj.DetailComment,
ClassName = obj.ClassName,
Namespace = obj.Namespace,
ModuleCode = obj.ModuleCode,
ModuleName = obj.ModuleName,
Folder = obj.Folder,
Options = obj.Options,
TypeId = obj.TypeId,
TypeName = obj.TypeName,
UpdateTime = DateTime.Now,
UpdateUserId = user.Id,
UpdateUserName = user.Name
//todo:补充或调整自己需要的字段
});
}
public void Update(AddOrUpdateBuilderTableReq obj)
{
var user = _auth.GetCurrentUser().User;
UnitWork.Update <BuilderTable>(u => u.Id == obj.Id, u => new BuilderTable
{
TableName = obj.TableName,
Comment = obj.Comment,
ClassName = obj.ClassName,
Namespace = obj.Namespace,
ModuleCode = obj.ModuleCode,
ModuleName = obj.ModuleName,
Folder = obj.Folder,
Options = obj.Options,
TypeId = obj.TypeId,
TypeName = obj.TypeName,
IsDynamicHeader = obj.IsDynamicHeader,
ForeignKey = obj.ForeignKey,
ParentTableId = obj.ParentTableId,
UpdateTime = DateTime.Now,
UpdateUserId = user.Id,
UpdateUserName = user.Name
});
}
public string Add(AddOrUpdateBuilderTableReq req)
{
if (string.IsNullOrEmpty(req.TableName))
{
throw new Exception("英文表名不能为空");
}
if (string.IsNullOrEmpty(req.ModuleName))
{
throw new Exception("模块名称不能为空");
}
if (string.IsNullOrEmpty(req.Namespace))
{
throw new Exception("命名空间不能为空");
}
var columns = _dbExtension.GetDbTableStructure(req.TableName);
if (!columns.Any())
{
throw new Exception($"未能找到{req.TableName}表结构定义");
}
var obj = req.MapTo <BuilderTable>();
if (string.IsNullOrEmpty(obj.ClassName))
{
obj.ClassName = obj.TableName;
}
if (string.IsNullOrEmpty(obj.ModuleCode))
{
obj.ModuleCode = obj.TableName;
}
//todo:补充或调整自己需要的字段
obj.CreateTime = DateTime.Now;
var user = _auth.GetCurrentUser().User;
obj.CreateUserId = user.Id;
obj.CreateUserName = user.Name;
UnitWork.Add(obj);
foreach (var column in columns)
{
var builderColumn = new BuilderTableColumn
{
ColumnName = column.ColumnName,
Comment = column.Comment,
ColumnType = column.ColumnType,
EntityType = column.EntityType,
EntityName = column.ColumnName,
IsKey = column.IsKey == 1,
IsRequired = column.IsNull != 1,
IsEdit = true,
IsInsert = true,
IsList = true,
MaxLength = column.MaxLength,
TableName = obj.TableName,
TableId = obj.Id,
CreateUserId = user.Id,
CreateUserName = user.Name,
CreateTime = DateTime.Now
};
UnitWork.Add(builderColumn);
}
UnitWork.Save();
return(obj.Id);
}
