//修改查询
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));
}
