public override Task <AddColumnReply> AddColumn(AddColumnRequest request, ServerCallContext context)
{
engine.SetServerDatabase(request.DatabaseName);
engine.SetServerTable(request.DatabaseName, request.TableName);
engine.CreateColumn(request.ColumnName, request.ColumnType);
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("===============================================================================================================");
Console.WriteLine("Column added:");
Console.WriteLine("database name = " + request.DatabaseName + ", table = " + request.TableName +
", column name = " + request.ColumnName + ", column type = " + request.ColumnType);
Console.WriteLine("===============================================================================================================");
return(Task.FromResult(new AddColumnReply
{
DatabaseName = request.DatabaseName,
TableName = request.TableName,
ColumnName = request.ColumnName,
ColumnType = request.ColumnType
}));
}
public void AddColumn_Test()
{
var ci = GetContainer();
var tableInfoService = ci.Resolve <ITableInfoService>();
var request = new AddColumnRequest();
request.Name = "Order";
List <ColumnInfoDto> cols = new List <ColumnInfoDto>();
cols.Add(new ColumnInfoDto()
{
Name = "FullName",
Desc = "收货人",
FormItemType = FormItemType.Text,
IsPrimaryKey = false,
IsSystem = false
});
cols.Add(new ColumnInfoDto()
{
Name = "Tel",
Desc = "电话",
FormItemType = FormItemType.Text,
IsPrimaryKey = false,
IsSystem = false
});
request.ColumnInfos = cols;
var res = tableInfoService.AddColumn(request);
res.CheckErrorAndThrowIt();
}
public override async Task <BaseReply> AddColumn(AddColumnRequest request, ServerCallContext context)
{
try
{
var field = new Dto.Field
{
Name = request.ColumnName,
Type = (SupportedTypes)request.DataValueType,
Validators = _grpcModelMapper.GetValidatorsDtoFromGrpcValidators(request.Validators)
};
await _tableDal.AddField(request.TableName, request.DbName, field);
var response = new BaseReply()
{
Code = 200
};
Console.WriteLine();
Console.WriteLine();
Console.WriteLine("***************************************************************************************************************");
Console.WriteLine("Column added: " + request.TableName + ", " + request.ColumnName);
Console.WriteLine("***************************************************************************************************************");
return(response);
}
catch (Exception ex)
{
return(new BaseReply()
{
Code = 400, Message = ex.Message, StackTrace = ex.StackTrace
});
}
}
public ResultObject AddColumn(AddColumnRequest request)
{
var core = new AddColumnCore(request, _uow, _tableInfoRepository);
return(core.DoExecute());
}
