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); }