public ActionResult <ApiResult <string> > SaveCodeType([FromForm] CodeTypeViewModel model)
{
var result = new ApiResult <string>();
JsonResult errorResult = base.ValidateModel(model.Id);
if (errorResult != null)
{
return(errorResult);
}
CodeType codetype = new CodeType()
{
Id = Convert.ToInt32(model.Id),
CSharepType = model.CSharepType,
Name = model.Name,
Sort = model.Sort.Value
};
try
{
codetype.DbType = Newtonsoft.Json.JsonConvert.DeserializeObject <DbTypeInfo[]>(model.DbType);
}
catch
{
result.IsSuccess = false;
result.Data = model.DbType + "格式不正确";
return(result);
}
var x = Db.Storageable(codetype).ToStorage();
x.AsUpdateable.ExecuteCommand();
x.AsInsertable.ExecuteCommand();
result.IsSuccess = true;
result.Data = x.InsertList.Any()? Pubconst.MESSAGEADDSUCCESS:Pubconst.MESSAGESAVESUCCESS;
return(result);
}
public static CodeTypeViewModel MapToCodeTypeViewModel(CodeTypeModel source)
{
var target = new CodeTypeViewModel();
Map(source, target);
return(target);
}
/// <summary>
/// Extension method for mapping <see cref="CodeModel"/> to <see cref="CodeTypeViewModel"/>.
/// </summary>
/// <param name="codeModel"><see cref="CodeModel"/> instance.</param>
/// <returns>Instance of <see cref="CodeTypeViewModel"/>.</returns>
public static CodeTypeViewModel ToCodeTypeViewModel(this CodeModel codeModel)
{
if (codeModel == null)
{
return(null);
}
var model = new CodeTypeViewModel()
{
// SET Defaults:
ShowIntColumns = false,
ShowListCodeColumns = true,
CodeType = codeModel.Code,
CurrencyEndDate = codeModel.EndDate,
CurrencyStartDate = codeModel.StartDate,
LongDescription = codeModel.Description,
ShortDescription = codeModel.ShortDescription
};
if (codeModel.CurrencyEnd != null)
{
model.CurrencyEnd = codeModel.CurrencyEnd.Value;
model.ShowListCodeColumns = false; // To Hide Date columns.
model.ShowIntColumns = true;
}
if (codeModel.CurrencyStart != null)
{
model.CurrencyStart = codeModel.CurrencyStart.Value;
model.ShowListCodeColumns = false; // To Hide Date columns.
model.ShowIntColumns = true;
}
return(model);
}
public ActionResult <ApiResult <TableModel <CodeTypeGridViewModel> > > GetCodeTypeList([FromForm] CodeTypeViewModel model)
{
model.PageSize = 20;
var result = new ApiResult <TableModel <CodeTypeGridViewModel> >();
result.Data = new TableModel <CodeTypeGridViewModel>();
int count = 0;
var list = CodeTypeDb.AsSugarClient().Queryable <CodeType>()
.WhereIF(!string.IsNullOrEmpty(model.Name), it => it.Name.Contains(model.Name) || it.CSharepType.Contains(model.Name))
.OrderBy(it => it.Sort)
.OrderBy(it => it.Id)
.ToPageList(model.PageIndex, model.PageSize, ref count);
var codeGridList = mapper.Map <List <CodeTypeGridViewModel> >(list);
foreach (var item in codeGridList)
{
var dbType = list.First(it => it.Id == item.Id).DbType;
item.DbType = Newtonsoft.Json.JsonConvert.SerializeObject(dbType);
}
result.Data.Rows = codeGridList;
result.Data.Total = count;
result.Data.PageSize = model.PageSize;
result.Data.PageNumber = model.PageIndex;
result.IsSuccess = true;
return(result);
}
public static void Map(CodeTypeModel source, CodeTypeViewModel target)
{
target.CodeType = source.CodeType;
target.ShortDescription = source.ShortDescription;
target.LongDescription = source.LongDescription;
}
