public ActionResult index(human_file hf)
{
config_file_first_kind s = ifkb.selectWhere(e => e.first_kind_id == hf.first_kind_id).FirstOrDefault();
config_file_second_kind s1 = iskb.SelectWhere(e => e.second_kind_id == hf.second_kind_id).FirstOrDefault();
config_file_third_kind s2 = itkb.SelectWhere(e => e.third_kind_id == hf.third_kind_id).FirstOrDefault();
config_major s3 = imb.SelectWhere(e => e.major_id == hf.human_major_id).FirstOrDefault();
config_major_kind s4 = imkb.SelectWhere(e => e.major_kind_id == hf.human_major_kind_id).FirstOrDefault();
salary_standard ssd = issdb.SelectWhere(e => e.standard_id == hf.salary_standard_id).FirstOrDefault();
hf.salary_standard_name = ssd.standard_name;
hf.first_kind_name = s.first_kind_name;
hf.second_kind_name = s1.second_kind_name;
hf.third_kind_name = s2.third_kind_name;
hf.hunma_major_name = s3.major_name;
hf.human_major_kind_name = s4.major_kind_name;
hf.check_status = 0;
hf.salary_sum = ssd.salary_sum;
hf.demand_salaray_sum = ssd.salary_sum;
hf.paid_salary_sum = ssd.salary_sum;
hf.file_chang_amount = 0;
hf.lastly_change_time = DateTime.Now;
if (ihdb.Update(hf) > 0)
{
return(Content("<script>location.href='/Human_file/Top_file/" + hf.huf_id + "'</script>"));
}
else
{
return(Content("<script>alert('登记失败');location.href='/Human_file/index'</script>"));
}
}
//修改
public async Task <ActionResult> Edit(int id)
{
List <config_file_first_kind> list2 = await ifk.CFKSelect();
List <SelectListItem> list = new List <SelectListItem>();
foreach (var item in list2)
{
list.Add(new SelectListItem {
Text = item.first_kind_name, Value = item.first_kind_id.ToString() + "," + item.first_kind_name
});
}
ViewData["list"] = list;
Econfig_file_second_kind st = hr.Econfig_file_second_kind.AsNoTracking().Where(e => e.fsk_id.Equals(id)).FirstOrDefault();
config_file_second_kind st2 = new config_file_second_kind()
{
fsk_id = st.fsk_id,
first_kind_id = st.first_kind_id,
first_kind_name = st.first_kind_name,
second_kind_id = st.second_kind_id,
second_kind_name = st.second_kind_name,
second_salary_id = st.second_salary_id,
second_sale_id = st.second_sale_id
};
return(View(st2));
}
public Task <int> CSKDel(config_file_second_kind ck)
{
Econfig_file_second_kind cs = new Econfig_file_second_kind()
{
fsk_id = ck.fsk_id
};
return(Del(cs));
}
/// <summary>
/// 查询二级机构
/// </summary>
/// <returns>异步二级机构</returns>
public ActionResult secondKindIdVue()
{
config_file_second_kind second = new config_file_second_kind()
{
second_kind_id = Request["fatherId"]
};
List <config_file_second_kind> list = second_bll.SelectSecond_kind(second);
return(Content(JsonConvert.SerializeObject(list)));
}
/// <summary>
/// 查询二级机构
/// </summary>
/// <returns></returns>
public ActionResult GetTow()
{
config_file_second_kind sec = new config_file_second_kind()
{
first_kind_id = Request["fatherId"]
};
List <config_file_second_kind> list = sec_bll.SelectSecond_kind(sec);
return(Content(JsonConvert.SerializeObject(list)));
}
public ActionResult second_kind_change(short id)
{
config_file_second_kind cffk = new config_file_second_kind()
{
fsk_id = id
};
config_file_second_kind cff = cfsks.SelectOne(cffk);
ViewData.Model = cff;
return(View());
}
public ActionResult second_kind_register(config_file_second_kind t)
{
if (bll.Add(t) > 0)
{
return(Content("<script>window.location.href='/client/second_kind_register_success'</script>"));
}
else
{
return(Content("<script>alert('添加失败');window.location.href='/client/second_kind_register'</script>"));
}
}
//删除
public Task <int> Delete(int id)
{
config_file_second_kind cfsk = new config_file_second_kind()
{
fsk_id = id
};
tescDbContext.second.Attach(cfsk);
tescDbContext.second.Remove(cfsk);
return(tescDbContext.SaveChangesAsync());
}
public ActionResult second_kind_change_success(config_file_second_kind cffk)
{
bool pd = cfsks.Upd(cffk);
if (pd)
{
return(View());
}
else
{
return(RedirectToAction("second_kind"));
}
}
public ActionResult second_kind_register_success(config_file_second_kind cfsk)
{
bool pd = cfsks.Add(cfsk);
if (pd)
{
return(View());
}
else
{
return(RedirectToAction("second_kind"));
}
}
public ActionResult second_kind_change(config_file_second_kind second)
{
int num = secondbll.config_file_second_kindUpdate(second, second.fsk_id);
if (num > 0)
{
return(RedirectToAction("second_kind_change_success"));
}
else
{
return(View(num));
}
}
public ActionResult second_kind_register(config_file_second_kind second)
{
int num = secondbll.config_file_second_kindInsert(second);
if (num > 0)
{
return(RedirectToAction("second_kind_register_success"));
}
else
{
GetList();
return(View(num));
}
}
public Task <int> CSKUpdate(config_file_second_kind ck, params string[] ps)
{
Econfig_file_second_kind es = new Econfig_file_second_kind()
{
fsk_id = ck.fsk_id,
first_kind_id = ck.first_kind_id,
first_kind_name = ck.first_kind_name,
second_kind_id = ck.first_kind_id,
second_kind_name = ck.second_kind_name,
second_salary_id = ck.second_salary_id,
second_sale_id = ck.second_sale_id
};
return(Update(es, ps));
}
public Task <int> CSKAdd(config_file_second_kind ck)
{
Econfig_file_second_kind cs = new Econfig_file_second_kind()
{
fsk_id = ck.fsk_id,
first_kind_id = ck.first_kind_id,
first_kind_name = ck.first_kind_name,
second_kind_id = ck.first_kind_id,
second_kind_name = ck.second_kind_name,
second_salary_id = ck.second_salary_id,
second_sale_id = ck.second_sale_id
};
return(Add(cs));
}
//添加
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 <ActionResult> Delete(int id)
{
config_file_second_kind cc = new config_file_second_kind()
{
fsk_id = id
};
int result = await isk.CSKDel(cc);
if (result > 0)
{
return(Content("<script>alert('删除成功');window.location.href='/second_kind/Index'</script>"));
}
else
{
return(Content("<script>alert('删除失败');window.location.href='/second_kind/Index'</script>"));
}
}
public ActionResult second_delete_success(short id)
{
config_file_second_kind cffk = new config_file_second_kind()
{
fsk_id = id
};
bool pd = cfsks.Del(cffk);
if (pd)
{
return(View());
}
else
{
return(RedirectToAction("second_kind"));
}
}
static void Main(string[] args)
{
config_file_second_kind st = new config_file_second_kind()
{
first_kind_id = "1",
first_kind_name = "1级机构",
second_kind_id = "2",
second_kind_name = "2级机构",
second_salary_id = "2",
second_sale_id = "2"
};
DaoBase <config_file_second_kind> fs = new DaoBase <config_file_second_kind>();
if (fs.Add(st) > 0)
{
Console.WriteLine("ok");
}
}
public ActionResult second_kind_change(config_file_second_kind t)
{
config_file_second_kind list = bll.SelectWhere(t.fsk_id).FirstOrDefault();
list.first_kind_name = t.first_kind_name;
list.second_kind_id = t.second_kind_id;
list.second_kind_name = t.second_kind_name;
list.second_salary_id = t.second_salary_id;
list.second_sale_id = t.second_sale_id;
if (bll.Change(list) > 0)
{
return(Content("<script>window.location.href='/client/second_kind_change_success'</script>"));
}
else
{
return(Content("<script>alert('修改失败');window.location.href='/client/second_kind_change'</script>"));
}
}//更改
public async Task <List <config_file_second_kind> > CSKSelect()
{
List <Econfig_file_second_kind> cs = await GetAll();
List <config_file_second_kind> cs2 = new List <config_file_second_kind>();
foreach (var item in cs)
{
config_file_second_kind st = new config_file_second_kind()
{
fsk_id = item.fsk_id,
first_kind_id = item.first_kind_id,
first_kind_name = item.first_kind_name,
second_kind_id = item.first_kind_id,
second_kind_name = item.second_kind_name,
second_salary_id = item.second_salary_id,
second_sale_id = item.second_sale_id
};
cs2.Add(st);
}
return(cs2);
}
public async Task <ActionResult> Create(config_file_second_kind ck)
{
try
{
string[] sz = ck.first_kind_name.Split(',');
ck.first_kind_id = sz[0];
ck.first_kind_name = sz[1];
int result = await isk.CSKAdd(ck);
if (result > 0)
{
return(RedirectToAction("Index"));
}
else
{
return(View(ck));
}
}
catch (Exception)
{
return(View(ck));
}
}
public async Task <ActionResult> Edit(config_file_second_kind st)
{
try
{
string[] sz = st.first_kind_name.Split(',');
st.first_kind_id = sz[0];
st.first_kind_name = sz[1];
string[] ps = new string[] { "fsk_id", "first_kind_id", "first_kind_name", "second_kind_id", "second_kind_name", "second_salary_id", "second_sale_id" };
int result = await isk.CSKUpdate(st, ps);
if (result > 0)
{
return(RedirectToAction("Index"));
}
else
{
return(View(st));
}
}
catch (Exception)
{
return(View(st));
}
}
public ActionResult Carate(engage_major_release en)
{
config_file_first_kind s = ifkb.selectWhere(e => e.first_kind_id == en.first_kind_id).FirstOrDefault();
config_file_second_kind s1 = iskb.SelectWhere(e => e.second_kind_id == en.second_kind_id).FirstOrDefault();
config_file_third_kind s2 = itkb.SelectWhere(e => e.third_kind_id == en.third_kind_id).FirstOrDefault();
config_major s3 = imb.SelectWhere(e => e.major_id == en.major_id).FirstOrDefault();
config_major_kind s4 = imkb.SelectWhere(e => e.major_kind_id == en.major_kind_id).FirstOrDefault();
//string sa= ;
en.first_kind_name = s.first_kind_name;
en.second_kind_name = s1.second_kind_name;
en.third_kind_name = s2.third_kind_name;
en.major_name = s3.major_name;
en.major_kind_name = s4.major_kind_name;
if (imrb.Add(en) > 0)
{
return(Content("<script>alert('发布成功');location.href='/Major_release/Index2'</script>"));
}
else
{
return(Content("<script>alert('发布失败');location.href='/Major_release/Index'</script>"));
}
}
public Task <int> CSKUpdate(config_file_second_kind ck, params string[] ps)
{
return(ick.CSKUpdate(ck, ps));
}
public Task <int> CSKDel(config_file_second_kind ck)
{
return(ick.CSKDel(ck));
}
public int config_file_second_kindInsert(config_file_second_kind second)
{
return(dao.config_file_second_kindInsert(second));
}
/// <summary>
/// 查询二级机构
/// </summary>
/// <returns></returns>
public List <config_file_second_kind> SelectSecond_kind(config_file_second_kind second)
{
return(dao.SelectSecond_kind(second));
}
public int config_file_second_kindUpdate(config_file_second_kind second, object keyValue)
{
return(dao.config_file_second_kindUpdate(second, keyValue));
}
