public async Task <object> GetSrReestrView(ncelsEntities db, ModelRequest request, int type)
{
//Database query
var v = db.SrReestrViews.Where(m => m.type == type).AsQueryable();
//search
if (!string.IsNullOrEmpty(request.SearchValue))
{
v = v.Where(a => a.reg_number.Contains(request.SearchValue) ||
a.C_int_name.Contains(request.SearchValue) ||
a.name.Contains(request.SearchValue)
//|| a.concentration.Contains(request.SearchValue)
//|| a.C_dosage_form_name.Contains(request.SearchValue)
//|| a.C_atc_code.Contains(request.SearchValue)
|| a.C_producer_name.Contains(request.SearchValue)
);
}
int recordsTotal = await v.CountAsync();
var expertiseViews = v.OrderBy(o => o.id).Skip(request.Skip).Take(request.PageSize);
var list = await expertiseViews.AsNoTracking().ToListAsync();
return(new { draw = request.Draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, Data = list });
}
public async Task <IActionResult> updatePost([FromBody] ModelRequest dataRequest)
{
string comment = "";
comment = dataRequest.comment;
long idLong = dataRequest.id;
try
{
using (var dbCtx = new VircaContext())
{
var data = await dbCtx.Virca_Orders_Video.Where(item => item.Id == idLong).SingleOrDefaultAsync();
if (data == null)
{
return(Json(new { success = false, msg = NotFound() }));
}
else
{
data.Add_info = comment;
await dbCtx.SaveChangesAsync();
return(Json(new { success = true, msg = "" }));
}
}
}
catch (Exception ex)
{
//MvcApplication.getLogger().Error(ex, "AsyncController, updatePost");
return(Json(new { success = false, msg = ex.Message }));
}
}
public ActionResult GetStatements(ModelRequest request)
{
var query = _ctx.EMP_Statement.Select(x => new
{
Id = x.Id,
Kind = x.RegistrationKindValue == "1"
? "Регистрация"
: x.RegistrationKindValue == "2"
? "Перерегистрация"
: "Внесение изменений",
Type = x.RegistrationTypeValue == "1" ? "Ускоренная" : string.Empty,
MedicalDeviceName = x.MedicalDeviceNameRu,
Number = x.RegistrationCertificateNumber,
Status = "Черновик",
StartDate = x.RegistrationDate,
Actions = string.Empty
}).ToList();
return(Json(new
{
draw = request.Draw,
recordsFiltered = query.Count,
recordsTotal = query.Count,
Data = query
}, JsonRequestBehavior.AllowGet));
}
public async Task <object> GetOrphanDrugsViewView(ncelsEntities db, ModelRequest request)
{
//Database query
var v = db.OrphanDrugsIcdDeseasesViews.AsQueryable();
//var v = db.OrphanDrugsIcdDeseasesViews.AsQueryable();
//search
if (!string.IsNullOrEmpty(request.SearchValue))
{
v = v.Where(a => a.CodeICD.Contains(request.SearchValue) ||
a.Name.Contains(request.SearchValue) ||
a.DiseaseOfICD.Contains(request.SearchValue) ||
a.SysnonimAndRareDesease.Contains(request.SearchValue)
);
}
//sort
//if (!(string.IsNullOrEmpty(request.SortColumn) && string.IsNullOrEmpty(request.SortColumnDir))) {
// //for make sort simpler we will add Syste.Linq.Dynamic reference
// v = v.OrderBy(request.SortColumn + " " + request.SortColumnDir);
//}
int recordsTotal = await v.CountAsync();
var expertiseViews = v.OrderBy(o => o.Name).Skip(request.Skip).Take(request.PageSize);
return(new { draw = request.Draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, Data = await expertiseViews.ToListAsync() });
}
public ActionResult GetPriceType2(ModelRequest request, Guid id)
{
var items = db.PricesViews.Where(o => o.PriceProjectId == id && o.Type == 2 && o.MtPartsId != null).ToList();
var count = items.Count();
var sumItem = new PricesView
{
PartsName = "ВСЕГО",
ManufacturerPrice = items.Sum(x => x.ManufacturerPrice),
CipPrice = items.Sum(x => x.CipPrice),
RefPrice = items.Sum(x => x.RefPrice),
UnitPrice = items.Sum(x => x.UnitPrice),
RefPriceTypeName = "",
Id = Guid.Parse("11111111-1111-1111-1111-111111111111")
};
items.Add(sumItem);
var data = new
{
draw = request.Draw,
recordsFiltered = count,
recordsTotal = count,
Data = items.ToList()
};
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult Calcular([FromBody] ModelRequest <CalculoTimeModel> timeCommand)
{
CalculoTimeCommand timeCalculo = new CalculoTimeCommand();
if (timeCommand.Value.TipoCalculo.Equals("media", StringComparison.InvariantCultureIgnoreCase))
{
timeCalculo.TipoCalculo = TipoCalculo.MediaAnual;
timeCalculo.AnoInicio = timeCommand.Value.AnoInicio;
timeCalculo.AnoFim = timeCommand.Value.AnoFim;
}
else
{
timeCalculo.TipoCalculo = TipoCalculo.Media3Anos;
timeCalculo.AnoInicio = timeCommand.Value.AnoBase - 1;
timeCalculo.AnoFim = timeCommand.Value.AnoBase + 1;
}
timeCalculo.Categoria = EnumUtil.ParseEnum <TipoCategoria>(timeCommand.Value.Categoria.Replace(" ", ""));
timeCalculo.Criterio = timeCommand.Value.Criterio.Replace(" ", "") == "Por36minutos" ? TipoCriterio.EstatisticaPer36Minutes : TipoCriterio.EstatisticaPer36Oponente;
timeCalculo.Conferencia = EnumUtil.ParseEnum <TipoConferencia>(timeCommand.Value.Conferencia);
var times = _calculoTimeAppService.CalcularTime(timeCalculo).ToList();
ViewBag.dataSource = times;
var datasource = times;
return(Json(datasource));
}
public void QuickpurgeTest()
{
//Arrange
int cateId, objectId;
var objectRequest = new IdoitObjectInstance(idoitClient);
var categoryRequest = new ModelRequest();
var model = new IdoitSvcInstance <ModelResponse>(idoitClient);
//Act:Create the Object
objectRequest.CmdbStatus = IdoitCmdbStatus.INOPERATION;
objectRequest.Type = IdoitObjectTypes.CLIENT;
objectRequest.Value = "My Client";
objectId = objectRequest.Create();
//Act: Create the Category
categoryRequest.title = "Web GUI";
categoryRequest.description = "Web GUI description";
categoryRequest.manufacturer = 1;
model.ObjectId = objectId;
model.ObjectRequest = categoryRequest;
cateId = model.Create();
//Act
model.CateId = cateId;
model.Purge();
objectRequest.ObjectId = objectId;
objectRequest.Purge();
}
public async Task <IActionResult> updateStatus([FromBody] ModelRequest dataRequest)
{
byte status = dataRequest.status;
long idLong = dataRequest.id;
try
{
using (var dbCtx = new VircaContext())
{
var data = await dbCtx.Virca_Orders_Video.Where(item => item.Id == idLong).SingleOrDefaultAsync();
if (data == null)
{
return(Json(new { success = false, msg = "id:" + idLong + ". " + NotFound() + data.ToString() }));
}
else
{
data.Status = status;
await dbCtx.SaveChangesAsync();
return(Json(new { success = true, msg = "" }));
}
}
}
catch (Exception ex)
{
//MvcApplication.getLogger().Error(ex, "AsyncController, updateStatus");
return(Json(new { success = false, msg = ex.Message }));
}
}
public JsonResult ReadConclusion(ModelRequest request)
{
var data = new
{
draw = request.Draw,
recordsFiltered = 4,
recordsTotal = 4,
Data =
new List <object>()
{
new
{
Number = "1",
ApplicationDate = DateTime.Now,
NameRu = "test",
ProjectStateName = "test",
ExecutorName = "test",
SignEmployeeName = "test"
},
new
{
Number = "2",
ApplicationDate = DateTime.Now,
NameRu = "test",
ProjectStateName = "test",
ExecutorName = "test",
SignEmployeeName = "test"
}
}
};
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult GetPriceType3(ModelRequest request, Guid id)
{
var items = db.PricesViews.Where(o => o.PriceProjectId == id && o.Type == 3);
/* var count = items.Count();
*
* var data = new
* {
* draw = request.Draw,
* recordsFiltered = count,
* recordsTotal = count,
* Data = items.ToList()
* };*/
var countyDics = new ReadOnlyDictionaryRepository().GetDictionaries(CodeConstManager.DIC_COUNTRY_TYPE);
var list = countyDics.Where(e => CodeConstManager.LIST_COUNTY_CODE_FOR_PRICE.Contains(e.Code));
var prices = new ArrayList();
var ids = new List <Guid>();
foreach (var country in list)
{
var exist = items.FirstOrDefault(e => e.CountryId == country.Id);
if (exist != null)
{
prices.Add(exist);
ids.Add(exist.Id);
}
else
{
var price = new
{
Id = Guid.NewGuid(),
CountryName = country.Name,
ManufacturerPrice = "",
ManufacturerPriceNote = "",
Type = (int)PriceType.ImnPrice,
PriceProjectId = id,
CountryId = country.Id,
};
prices.Add(price);
}
}
foreach (var item in items.Where(e => !ids.Contains(e.Id)))
{
prices.Add(item);
}
var count = prices.Count;
var data = new
{
draw = request.Draw,
recordsFiltered = count,
recordsTotal = count,
Data = prices
};
return(Json(data, JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> Post([FromBody] ModelRequest request)
{
var entity = new ModelItem
{
EsCliente = true,
Nombre = request.Nombre
};
await _modelRepository.AddModelItem(entity);
return(Ok());
}
public async Task <object> GetPpPriceList(ncelsEntities db, ModelRequest request, int type)
{
//Database query
var v = db.PP_PharmaList.Where(m => m.Type == type).AsQueryable();
int recordsTotal = await v.CountAsync();
var preList = v.OrderBy(o => o.Id).Skip(request.Skip).Take(request.PageSize);
var list = await preList.AsNoTracking().ToListAsync();
return(new { draw = request.Draw, recordsFiltered = recordsTotal, recordsTotal = recordsTotal, Data = list });
}
public ActionResult GetPackageType(ModelRequest request, Guid id)
{
var items = db.PackagesViews.Where(o => o.ObjectId == id);
var count = items.Count();
var data = new {
draw = request.Draw,
recordsFiltered = count,
recordsTotal = count,
Data = items.ToList()
};
return(Json(data, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 删除待办项
/// </summary>
/// <param name="response"></param>
/// <param name="request"></param>
/// <param name="cancellationToken"></param>
public async Task Delete([Required] ResponseMessage <TodoItemJson> response, [FromBody] ModelRequest <TodoItemJson> request, CancellationToken cancellationToken = default(CancellationToken))
{
UserBase user = await UserChecck(response, request.User);
if (user == null)
{
return;
}
// 删除Todo
await Store.DeleteIfId(user.Id, request.model.Id, cancellationToken);
response.Extension = request.model;
}
public ActionResult ListComments(ModelRequest request, Guid contractId)
{
var result = db.ContractComments.Include(e => e.Author).AsNoTracking().Where(e => e.ContractId == contractId && e.Sended).ToDataSourceResult(request,
c => new
{
c.Id,
c.CreateDate,
Author = c.Author.DisplayName,
c.Comment
});
return(Json(result, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// загрузка списка заявлений
/// </summary>
/// <param name="request"></param>
/// <param name="isRegisterProject"></param>
/// <param name="type"></param>
/// <returns></returns>
public async Task <object> GetContractList(ModelRequest request, bool isRegisterProject)
{
try
{
var employeeId = UserHelper.GetCurrentEmployee().Id;
var v = AppContext.OBK_Contract.Where(x => x.EmployeeId == employeeId).AsQueryable();
//var v = AppContext.OBK_Contract.AsQueryable();
//search
if (!string.IsNullOrEmpty(request.SearchValue))
{
v =
v.Where(
a => a.Number.Contains(request.SearchValue));
}
//sort
if (!(string.IsNullOrEmpty(request.SortColumn) && string.IsNullOrEmpty(request.SortColumnDir)))
{
//v = v.OrderBy(request.SortColumn + " " + request.SortColumnDir);
v = v.OrderByDescending(x => x.CreatedDate);
}
int recordsTotal = await v.CountAsync();
var contractViews = v.Skip(request.Skip).Take(request.PageSize).Select(x => new
{
x.Id,
x.Number,
x.CreatedDate,
Status = x.OBK_Ref_Status.NameRu,
DeclarantName = x.OBK_Declarant.NameRu,
x.StartDate,
x.EndDate
}
);
return
(new
{
draw = request.Draw,
recordsFiltered = recordsTotal,
recordsTotal = recordsTotal,
Data = await contractViews.ToListAsync()
});
}
catch (Exception e)
{
return(new { IsError = true, Message = e.Message });
}
}
public void PlusTheory(int value1, int value2)
{
var body = new ModelRequest()
{
Value1 = value1,
Value2 = value2
};
var actionResult = _mathController.Plus(body);
var objectResult = (ObjectResult)actionResult.Result;
Assert.Equal(200, objectResult.StatusCode);
Assert.Equal(3, objectResult.Value);
}
public void Minus()
{
var body = new ModelRequest()
{
Value1 = 1,
Value2 = 2
};
var actionResult = _mathController.Minus(body);
var objectResult = (ObjectResult)actionResult.Result;
Assert.Equal(200, objectResult.StatusCode);
Assert.Equal(-1, objectResult.Value);
}
public async Task <object> ReadSigning(ncelsEntities db, ModelRequest request)
{
try
{
var employeeId = UserHelper.GetCurrentEmployee().Id.ToString();
//Database query
var v = db.Tasks
.Join(db.Documents, t => t.DocumentId, d => d.Id, (t, d) => new { t, d })
.Join(db.Contracts, cd => cd.d.Id, c => c.Id, (cd, c) => new { cd, c })
.Where(m => m.cd.t.Type == 6 && m.cd.t.State == 0 && m.cd.t.ExecutorId == employeeId).OrderBy(m => m.cd.t.CreatedDate).AsQueryable();
//search
if (!string.IsNullOrEmpty(request.SearchValue))
{
v =
v.Where(
a =>
a.cd.t.Number.Contains(request.SearchValue) || a.cd.t.Text.Contains(request.SearchValue)
);
}
//sort
//if (!(string.IsNullOrEmpty(request.SortColumn) && string.IsNullOrEmpty(request.SortColumnDir)))
//{
// //for make sort simpler we will add Syste.Linq.Dynamic reference
// v = v.OrderBy(request.SortColumn + " " + request.SortColumnDir);
//}
int recordsTotal = await v.CountAsync();
var expertiseViews = v.Skip(request.Skip).Take(request.PageSize);
return
(new
{
draw = request.Draw,
recordsFiltered = recordsTotal,
recordsTotal = recordsTotal,
Data = await expertiseViews.Select(m => new { m.cd.t.Id, m.cd.t.State, m.cd.t.Text, m.cd.t.DocumentId, m.cd.t.CreatedDate, m.cd.t.DocumentValue, m.cd.t.Number, m.c.Type }).ToListAsync()
});
}
catch (Exception e)
{
return(new { IsError = true, Message = e.Message });
}
}
public ActionResult GetOrganizationType(ModelRequest request, Guid id, int type)
{
var items = db.OrganizationsViews.Where(o => o.ObjectId == id && o.Type == type && o.OriginalOrgId == null);
var count = items.Count();
var data = new {
draw = request.Draw,
recordsFiltered = count,
recordsTotal = count,
Data = items.ToList()
};
return(Json(data, JsonRequestBehavior.AllowGet));
}
public ActionResult GetInWorkList(ModelRequest request)
{
var result = _contractRepository.GetContractsByStatuses(UserHelper.GetCurrentEmployee().Id, Database.DataModel.Contract.StatusesInWork).ToDataSourceResult(request, e => new
{
e.Id,
e.Type,
e.Number,
e.CreatedDate,
ManufactureOrgName = e.ContractId != null ? e.ParentContract.ManufacturerOrganization.NameRu : e.ManufacturerOrganization.NameRu,
StatusName = e.ContractStatus.Name
});
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ModelResult GetAdvertsings(ModelRequest request)
{
var modelResult = new ModelResult();
modelResult.Data = AdRepository.GetAdvertisings().
Select(x => new AdResult
{
ID = x.ID,
Image = x.Image,
Position = x.Position,
Url = x.Url
});
return(modelResult);
}
public async Task <object> GetCurrentList(ncelsEntities db, ModelRequest request, Guid id)
{
try
{
var employeeId = UserHelper.GetCurrentEmployee().Id.ToString();
//Database query
var v = db.Documents.Where(o => o.IsDeleted == false && o.AnswersId == id.ToString() && (o.DocumentType == 0 || o.DocumentType == 1)).AsQueryable();
//search
if (!string.IsNullOrEmpty(request.SearchValue))
{
v =
v.Where(
a =>
a.OutgoingNumber.Contains(request.SearchValue) || a.Summary.Contains(request.SearchValue)
);
}
//sort
if (!(string.IsNullOrEmpty(request.SortColumn) && string.IsNullOrEmpty(request.SortColumnDir)))
{
//for make sort simpler we will add Syste.Linq.Dynamic reference
v = v.OrderBy(request.SortColumn + " " + request.SortColumnDir);
}
int recordsTotal = await v.CountAsync();
var expertiseViews = v.Skip(request.Skip).Take(request.PageSize);
return
(new
{
draw = request.Draw,
recordsFiltered = recordsTotal,
recordsTotal = recordsTotal,
Data = expertiseViews.Select(m => new { m.Id, m.Summary, m.OutgoingNumber, m.DocumentDate, m.AttachPath }).ToList().Select(m => new {
m.Id,
m.Summary,
Number = m.OutgoingNumber,
m.DocumentDate,
Items = UploadHelper.GetFilesInfo(m.AttachPath, false)
})
});
}
catch (Exception e)
{
return(new { IsError = true, Message = e.Message });
}
}
public async Task <object> GetContracts(ncelsEntities db, ModelRequest request, int?code)
{
try
{
var employeeId = UserHelper.GetCurrentEmployee().Id;
//Database query
var v = code != null?db.ContractsViews.Where(m => m.Status == code && m.OwnerId == employeeId).AsQueryable() : db.ContractsViews.Where(m => m.OwnerId == employeeId).AsQueryable();
//search
if (!string.IsNullOrEmpty(request.SearchValue))
{
v =
v.Where(
a =>
a.Number.Contains(request.SearchValue) || a.ManufactureOrgName.Contains(request.SearchValue)
);
}
//sort
if (!(string.IsNullOrEmpty(request.SortColumn) && string.IsNullOrEmpty(request.SortColumnDir)))
{
//for make sort simpler we will add Syste.Linq.Dynamic reference
v = v.OrderBy(request.SortColumn + " " + request.SortColumnDir);
}
else
{
v = v.OrderByDescending(m => m.CreatedDate);
}
int recordsTotal = await v.CountAsync();
var expertiseViews = v.Skip(request.Skip).Take(request.PageSize);
return
(new
{
draw = request.Draw,
recordsFiltered = recordsTotal,
recordsTotal = recordsTotal,
Data = await expertiseViews.ToListAsync()
});
}
catch (Exception e)
{
return(new { IsError = true, Message = e.Message });
}
}
/// <summary>
/// загрузка списка заявлений
/// </summary>
/// <param name="request"></param>
/// <param name="isRegisterProject"></param>
/// <param name="type"></param>
/// <returns></returns>
public async Task <object> GetSafetyAssessmentDeclarationList(ModelRequest request, bool isRegisterProject,
int?type)
{
try
{
//Database query
var employeeId = UserHelper.GetCurrentEmployee().Id;
var org = UserHelper.GetCurrentEmployee();
var v = type != null
? AppContext.OBK_AssessmentDeclarationView.Where(m => m.OwnerId == employeeId)
.OrderByDescending(m => m.SortDate)
.AsQueryable()
: AppContext.OBK_AssessmentDeclarationView.Where(m => m.OwnerId == employeeId).AsQueryable();
//search
if (!string.IsNullOrEmpty(request.SearchValue))
{
v =
v.Where(
a => a.Number.Contains(request.SearchValue) || a.StausName.Contains(request.SearchValue));
}
//sort
if (!(string.IsNullOrEmpty(request.SortColumn) && string.IsNullOrEmpty(request.SortColumnDir)))
{
v = v.OrderBy(request.SortColumn + " " + request.SortColumnDir);
}
int recordsTotal = await v.CountAsync();
var expertiseViews = v.Skip(request.Skip).Take(request.PageSize);
return
(new
{
draw = request.Draw,
recordsFiltered = recordsTotal,
recordsTotal = recordsTotal,
Data = await expertiseViews.ToListAsync()
});
}
catch (Exception e)
{
return(new { IsError = true, Message = e.Message });
}
}
public void AlterRequest(ModelRequest request)
{
try
{
using (SqlConnection connection = new SqlConnection(sqlConnection()))
{
string queryString = "UPDATE REQUEST SET NUMBERREQUEST = '" + request.NumberRequest + "', REQUESTFOR = '" + request.RequestFor + "', STATUS = '" + request.Status + "', ITEM = '" + request.Item + "', WORKNOTES = '" + request.WorkNotes + "', SHORTDESCRIPTION = '" + request.ShortDescription + "' , Tecnico = '" + request.Tecnico + "' WHERE NUMBERREQUEST = '" + request.NumberRequest + "'";
SqlCommand command = new SqlCommand(queryString, connection);
command.Connection.Open();
command.ExecuteNonQuery();
}
}
catch (Exception ex)
{
}
}
public void Save(ModelRequest request)
{
try
{
using (SqlConnection connection = new SqlConnection(sqlConnection()))
{
string queryString = "INSERT INTO REQUEST(NUMBERREQUEST, REQUESTFOR, STATUS, ITEM, WORKNOTES, SHORTDESCRIPTION, TempoResolucao) VALUES('" + request.NumberRequest + "','" + request.RequestFor + "','" + request.Status + "','" + request.Item + "','" + request.WorkNotes + "','" + request.ShortDescription + "', '" + request.TempoResolucao + "')";
SqlCommand command = new SqlCommand(queryString, connection);
command.Connection.Open();
command.ExecuteNonQuery();
}
}
catch (Exception ex)
{
}
}
public async Task <object> GetPriceRework(ncelsEntities db, ModelRequest request, int type)
{
try
{
//Database query
var employeeId = UserHelper.GetCurrentEmployee().Id;
var org = UserHelper.GetCurrentEmployee();
var v = db.ProjectsViews.Where(m => m.Type == type && m.OwnerId == employeeId && (m.Status == 3 || m.Status == 5)).AsQueryable();
//search
if (!string.IsNullOrEmpty(request.SearchValue))
{
v =
v.Where(
a =>
a.Number.Contains(request.SearchValue) || a.NameRu.Contains(request.SearchValue) ||
a.TypeValue.Contains(request.SearchValue) || a.StausValue.Contains(request.SearchValue) ||
a.NameRu.Contains(request.SearchValue));
}
//sort
if (!(string.IsNullOrEmpty(request.SortColumn) && string.IsNullOrEmpty(request.SortColumnDir)))
{
//for make sort simpler we will add Syste.Linq.Dynamic reference
v = v.OrderBy(request.SortColumn + " " + request.SortColumnDir);
}
int recordsTotal = await v.CountAsync();
var expertiseViews = v.Skip(request.Skip).Take(request.PageSize);
return
(new
{
draw = request.Draw,
recordsFiltered = recordsTotal,
recordsTotal = recordsTotal,
Data = await expertiseViews.ToListAsync()
});
}
catch (Exception e)
{
return(new { IsError = true, Message = e.Message });
}
}
public async Task <object> GetOutgoing(ncelsEntities db, ModelRequest request, int type)
{
try
{
var employeeId = UserHelper.GetCurrentEmployee().Id.ToString();
//Database query
var v = db.Documents.Where(o => o.IsDeleted == false && type == 0 ? (((o.DocumentType == 0 && o.CreatedUserId == employeeId) || (o.DocumentType == 1 && o.ExecutorsId == employeeId)))
: (type == 1 ? o.DocumentType == 1 && o.ExecutorsId == employeeId : (o.DocumentType == 0 && o.CreatedUserId == employeeId))).AsQueryable();
//search
if (!string.IsNullOrEmpty(request.SearchValue))
{
v =
v.Where(
a =>
a.Number.Contains(request.SearchValue) || a.Summary.Contains(request.SearchValue)
);
}
//sort
if (!(string.IsNullOrEmpty(request.SortColumn) && string.IsNullOrEmpty(request.SortColumnDir)))
{
//for make sort simpler we will add Syste.Linq.Dynamic reference
v = v.OrderBy(request.SortColumn + " " + request.SortColumnDir);
}
int recordsTotal = await v.CountAsync();
var expertiseViews = v.Skip(request.Skip).Take(request.PageSize);
return
(new
{
draw = request.Draw,
recordsFiltered = recordsTotal,
recordsTotal = recordsTotal,
Data = await expertiseViews.Select(m => new { m.Id, m.Summary, m.Number, m.DocumentDate }).ToListAsync()
});
}
catch (Exception e)
{
return(new { IsError = true, Message = e.Message });
}
}
// POST api/<controller>
public dynamic Post(string id, [FromBody] dynamic value)
{
bool result = false;
if (id == "load")
{
ModelRequest model = JsonConvert.DeserializeObject <ModelRequest>(JsonConvert.SerializeObject(value));
var biz = new TestBiz.Master();
PageInationInfo pagination = model.pagination;
ModelResponse resultLoad = new ModelResponse {
conditions = model.conditions
};
resultLoad.data = biz.Load(ref pagination, model.conditions).AsEnumerable()
.Select(i => new TestMasterInfo
{
SID = i.Field <int>("SID"),
ID = i.Field <string>("ID"),
NO = i.Field <string>("NO"),
Name = i.Field <string>("Name"),
Address = i.Field <string>("Address"),
Phone = i.Field <string>("Phone"),
Age = i.Field <decimal?>("Age"),
Birthday = i.Field <DateTime?>("Birthday"),
CreateTime = i.Field <DateTime>("CreateTime"),
UpdaueTime = i.Field <DateTime>("UpdaueTime")
})
.ToList();
resultLoad.pagination = new ModelResponse.PaginationInfo {
Index = pagination.Index, Size = pagination.Size, Total = pagination.Total
};
return(resultLoad);
}
if (id == "create")
{
TestMasterInfo model = JsonConvert.DeserializeObject <TestMasterInfo>(JsonConvert.SerializeObject(value));
if (ModelState.IsValid)
{
var biz = new TestBiz.Master();
return(biz.Insert(model));
}
return("資料驗證錯誤");
}
return(result);
}
