private bool checkModelStateCreateEdit(ActionEnumForm action, sys_factory_line_item_capacity_model item) { //if (item.db.quantity ==null || item.db.quantity == 0) //{ // ModelState.AddModelError("db.quantity", "required"); //} if (item.db.productTime == null || item.db.productTime == 0) { ModelState.AddModelError("db.productTime", "required"); } if (string.IsNullOrEmpty(item.db.id_item)) { ModelState.AddModelError("db.id_item", "required"); } var searchName = repo.FindAll().Where(d => d.db.id_sys_factory_line == item.db.id_sys_factory_line && d.db.id_item == item.db.id_item && d.db.id_specification == item.db.id_specification && d.db.id != item.db.id).Count(); if (searchName > 0) { ModelState.AddModelError("db.id_item", "existed"); ModelState.AddModelError("db.id_specification", "existed"); } return(ModelState.IsValid); }
public int update(sys_factory_line_item_capacity_model model) { var db = _context.sys_factory_line_item_capacitys.Where(d => d.id == model.db.id).FirstOrDefault(); db.quantity = model.db.quantity; db.quantity_unit_main = model.db.quantity_unit_main; db.energy = 100 / model.db.quantity; db.update_by = model.db.update_by; db.update_date = model.db.update_date; db.productTime = model.db.productTime; _context.SaveChanges(); return(1); }
public async Task <IActionResult> create([FromBody] JObject json) { sys_factory_line_item_capacity_model model = JsonConvert.DeserializeObject <sys_factory_line_item_capacity_model>(json.GetValue("data").ToString()); var check = checkModelStateCreate(model); if (!check) { return(generateError()); } model.db.create_by = getUserId(); model.db.id = 0; model.db.create_date = DateTime.Now; await repo.insert(model); return(Json(model)); }
public async Task <int> insert(sys_factory_line_item_capacity_model model) { if ((model.db.id_specification ?? 0) != 0) { var specification = _context.sys_item_specifications.Where(t => t.id == model.db.id_specification).SingleOrDefault(); model.db.id_unit = specification.id_unit; model.db.id_unit_main = _context.sys_items.Where(t => t.id == model.db.id_item).Select(t => t.id_unit).SingleOrDefault(); model.db.quantity_unit_main = specification.conversion_factor * model.db.quantity; model.db.conversion_factor = specification.conversion_factor; } model.db.energy = 100 / model.db.quantity; await _context.sys_factory_line_item_capacitys.AddAsync(model.db); _context.SaveChanges(); return(1); }
private bool checkModelStateEdit(sys_factory_line_item_capacity_model item) { return(checkModelStateCreateEdit(ActionEnumForm.edit, item)); }