//修改查询 public async Task <IActionResult> change(int id) { config_file_second_kindModel1 cfskm = await icfsb.Up(id); ViewData.Model = cfskm; return(View()); }
//查询 public Task <List <config_file_second_kindModel1> > Load() { var list = tescDbContext.second.ToList(); List <config_file_second_kindModel1> list2 = new List <config_file_second_kindModel1>(); var zhi = Task.Run(() => { foreach (var item in list) { config_file_second_kindModel1 cffkm = new config_file_second_kindModel1() { first_kind_id = item.first_kind_id, first_kind_name = item.first_kind_name, fsk_id = item.fsk_id, second_kind_id = item.second_kind_id, second_kind_name = item.second_kind_name, second_salary_id = item.second_salary_id, second_sale_id = item.second_sale_id }; list2.Add(cffkm); } return(list2); }); return(zhi); }
//添加 public async Task <int> ADD(config_file_second_kindModel1 cffskm) { config_file_second_kind cffsk = new config_file_second_kind() { first_kind_id = cffskm.first_kind_id, first_kind_name = cffskm.first_kind_name, fsk_id = cffskm.fsk_id, second_kind_id = cffskm.second_kind_id, second_kind_name = cffskm.second_kind_name, second_salary_id = cffskm.second_salary_id, second_sale_id = cffskm.second_sale_id }; tescDbContext.second.Add(cffsk); return(await tescDbContext.SaveChangesAsync()); }
//修改 public async Task <int> Update(config_file_second_kindModel1 cffskm) { config_file_second_kind cfsk = new config_file_second_kind() { fsk_id = cffskm.fsk_id, first_kind_id = cffskm.first_kind_id, first_kind_name = cffskm.first_kind_name, second_kind_id = cffskm.second_kind_id, second_kind_name = cffskm.second_kind_name, second_salary_id = cffskm.second_salary_id, second_sale_id = cffskm.second_sale_id }; tescDbContext.second.Attach(cfsk); tescDbContext.Entry(cfsk).State = Microsoft.EntityFrameworkCore.EntityState.Modified; return(await tescDbContext.SaveChangesAsync()); }
//修改查询 public async Task <config_file_second_kindModel1> Up(int id) { config_file_second_kind cffsk = await tescDbContext.second.FindAsync(id); config_file_second_kindModel1 cffskm = new config_file_second_kindModel1() { fsk_id = cffsk.fsk_id, first_kind_id = cffsk.first_kind_id, first_kind_name = cffsk.first_kind_name, second_kind_id = cffsk.second_kind_id, second_kind_name = cffsk.second_kind_name, second_salary_id = cffsk.second_salary_id, second_sale_id = cffsk.second_sale_id }; return(cffskm); }
//添加 public async Task <IActionResult> Add(config_file_second_kindModel1 cffskm) { if (ModelState.IsValid) { string[] z = cffskm.first_kind_id.Split(','); cffskm.first_kind_id = z[0]; cffskm.first_kind_name = z[1]; int result = await icfsb.ADD(cffskm); if (result > 0) { return(RedirectToAction("Index")); } else { List <config_file_first_kindModel1> list = await icfsb.SelectYiJiJG(); List <SelectListItem> list2 = new List <SelectListItem>(); foreach (var item in list) { list2.Add(new SelectListItem { Text = item.first_kind_name, Value = item.first_kind_id.ToString() + "," + item.first_kind_name }); } ViewBag.a = list2; return(View(cffskm)); } } else { List <config_file_first_kindModel1> list = await icfsb.SelectYiJiJG(); List <SelectListItem> list2 = new List <SelectListItem>(); foreach (var item in list) { list2.Add(new SelectListItem { Text = item.first_kind_name, Value = item.first_kind_id.ToString() + "," + item.first_kind_name }); } ViewBag.a = list2; return(View(cffskm)); } return(View()); }
//修改 public async Task <IActionResult> Update(config_file_second_kindModel1 cfskm) { if (ModelState.IsValid) { int result = await icfsb.Update(cfskm); if (result > 0) { return(RedirectToAction("Index")); } else { return(View(cfskm)); } } else { return(View(cfskm)); } }
public List <config_file_second_kindModel1> Loads() { var list = tescDbContext.second.ToList(); List <config_file_second_kindModel1> list2 = new List <config_file_second_kindModel1>(); foreach (var item in list) { config_file_second_kindModel1 cffkm = new config_file_second_kindModel1() { first_kind_id = item.first_kind_id, first_kind_name = item.first_kind_name, fsk_id = item.fsk_id, second_kind_id = item.second_kind_id, second_kind_name = item.second_kind_name, second_salary_id = item.second_salary_id, second_sale_id = item.second_sale_id }; list2.Add(cffkm); } return(list2); }
//修改 public Task <int> Update(config_file_second_kindModel1 cffskm) { return(iconfig.Update(cffskm)); }
//添加 public Task <int> ADD(config_file_second_kindModel1 cffskm) { return(iconfig.ADD(cffskm)); }