public int UpdateJl(JlMondel jim)
{
Jl jl = new Jl()
{
Id = jim.Id,
JlYesNo = jim.JlYesNo,
JlTuiJianRen = jim.JlTuiJianRen,
JlTuiJianTime = jim.JlTuiJianTime
};
return(Update(jl));
}
public List <JlMondel> JlWhere(int Id)
{
MyDbContext md = CreateContext();
List <Jl> list = md.Jl.AsNoTracking()
.Where(e => e.Id == Id)
.Select(e => e).ToList();
List <JlMondel> list2 = new List <JlMondel>();
foreach (Jl item in list)
{
JlMondel jlm = new JlMondel()
{
Id = item.Id,
JlAdds = item.JlAdds,
JlAge = item.JlAge,
JlAiHoa = item.JlAiHoa,
JlBeiZhu = item.JlBeiZhu,
JlBiYanShooln = item.JlBiYanShooln,
JlBreathAdds = item.JlBreathAdds,
JlBreathDay = item.JlBreathDay,
JlDianHua = item.JlDianHua,
JlEmail = item.JlEmail,
JlEntityCond = item.JlEntityCond,
JlGeRenLvLi = item.JlGeRenLvLi,
JlGuoJi = item.JlGuoJi,
JlJiaoYvYean = item.JlJiaoYvYean,
JlJiaTingDianHua = item.JlJiaTingDianHua,
JlMingZu = item.JlMingZu,
JlName = item.JlName,
JlSex = item.JlSex,
JlShouJi = item.JlShouJi,
JlTeChang = item.JlTeChang,
JlXingZiYaoQiu = item.JlXingZiYaoQiu,
JlXueli = item.JlXueli,
JlXueLiZhuanYe = item.JlXueLiZhuanYe,
JlYouBian = item.JlYouBian,
JlZcTime = item.JlZcTime,
JlZcOverTime = item.JlZcTime.AddDays(3),
JlZhengZhiMianMao = item.JlZhengZhiMianMao,
JlZongJioaXingYang = item.JlZongJioaXingYang,
MCName = item.MCName,
MKName = item.MKName,
ZPName = item.ZPName,
JlYesNo = item.JlYesNo,
JlTuiJianRen = item.JlTuiJianRen,
JlTuiJianTime = item.JlTuiJianTime
};
list2.Add(jlm);
}
return(list2);
}
public ActionResult JlYouXiuIndexShow(JlMondel jl, string GuanJianZi) //显示有效简历
{
string sql = $@"SELECT TOP 1000 [Id]
,[MCName]
,[MKName]
,[JlName]
,[JlDianHua]
,[JlEntityCond]
,[JlZcTime]
FROM[T6].[dbo].[Jl] where MCName = '{jl.MCName}' and MKName = '{jl.MKName}'
and JlName like '%{GuanJianZi}%' and JlDianHua like '%{GuanJianZi}%' and JlEntityCond like '%{GuanJianZi}%' and JlGeRenLvLi like '%{GuanJianZi}%'
and JlZcOverTime > '{jl.JlZcTime}' and JlZcTime < '{jl.JlZcOverTime}' and JlYesNo = {0}";
return(View(DBHelper.GetTable(sql)));
}
public ActionResult JlShaiXueIndexUpdate(int Id) //筛选简历
{
JlMondel jl = null;
foreach (JlMondel item in ijl.JlWhere(Id))
{
jl = new JlMondel()
{
Id = item.Id,
JlAdds = item.JlAdds,
JlAge = item.JlAge,
JlAiHoa = item.JlAiHoa,
JlBeiZhu = item.JlBeiZhu,
JlBiYanShooln = item.JlBiYanShooln,
JlBreathAdds = item.JlBreathAdds,
JlBreathDay = item.JlBreathDay,
JlDianHua = item.JlDianHua,
JlEmail = item.JlEmail,
JlEntityCond = item.JlEntityCond,
JlGeRenLvLi = item.JlGeRenLvLi,
JlGuoJi = item.JlGuoJi,
JlJiaoYvYean = item.JlJiaoYvYean,
JlJiaTingDianHua = item.JlJiaTingDianHua,
JlMingZu = item.JlMingZu,
JlName = item.JlName,
JlSex = item.JlSex,
JlShouJi = item.JlShouJi,
JlTeChang = item.JlTeChang,
JlXingZiYaoQiu = item.JlXingZiYaoQiu,
JlXueli = item.JlXueli,
JlXueLiZhuanYe = item.JlXueLiZhuanYe,
JlYouBian = item.JlYouBian,
JlZcTime = item.JlZcTime,
JlZcOverTime = item.JlZcTime.AddDays(3),
JlZhengZhiMianMao = item.JlZhengZhiMianMao,
JlZongJioaXingYang = item.JlZongJioaXingYang,
MCName = item.MCName,
MKName = item.MKName,
ZPName = item.ZPName,
JlYesNo = item.JlYesNo
};
}
return(View(jl));
}
public int InsertJl(JlMondel jlm)
{
Jl jl = new Jl()
{
Id = jlm.Id,
JlAdds = jlm.JlAdds,
JlAge = jlm.JlAge,
JlAiHoa = jlm.JlAiHoa,
JlBeiZhu = jlm.JlBeiZhu,
JlBiYanShooln = jlm.JlBiYanShooln,
JlBreathAdds = jlm.JlBreathAdds,
JlBreathDay = jlm.JlBreathDay,
JlDianHua = jlm.JlDianHua,
JlEmail = jlm.JlEmail,
JlEntityCond = jlm.JlEntityCond,
JlGeRenLvLi = jlm.JlGeRenLvLi,
JlGuoJi = jlm.JlGuoJi,
JlJiaoYvYean = jlm.JlJiaoYvYean,
JlJiaTingDianHua = jlm.JlJiaTingDianHua,
JlMingZu = jlm.JlMingZu,
JlName = jlm.JlName,
JlSex = jlm.JlSex,
JlShouJi = jlm.JlShouJi,
JlTeChang = jlm.JlTeChang,
JlXingZiYaoQiu = jlm.JlXingZiYaoQiu,
JlXueli = jlm.JlXueli,
JlXueLiZhuanYe = jlm.JlXueLiZhuanYe,
JlYouBian = jlm.JlYouBian,
JlZcTime = jlm.JlZcTime,
JlZcOverTime = jlm.JlZcTime.AddDays(3),
JlZhengZhiMianMao = jlm.JlZhengZhiMianMao,
JlZongJioaXingYang = jlm.JlZongJioaXingYang,
MCName = jlm.MCName,
MKName = jlm.MKName,
ZPName = jlm.ZPName,
JlYesNo = 0
};
return(Add(jl));
}
public ActionResult JlShaiXueIndexShow(JlMondel jl, string GuanJianZi) //显示筛选简历
{
Session["MCName"] = jl.MCName;
Session["MKName"] = jl.MKName;
Session["GuanJianZi"] = GuanJianZi;
Session["JlZcTime"] = jl.JlZcTime;
Session["JlZcOverTime"] = jl.JlZcOverTime;
string sql = $@"SELECT TOP 1000 [Id]
,[MCName]
,[MKName]
,[JlName]
,[JlDianHua]
,[JlEntityCond]
,[JlZcTime]
FROM[T6].[dbo].[Jl] where MCName = '{jl.MCName.Replace(" ", "")}' and MKName = '{jl.MKName}'
and JlName like '%{GuanJianZi}%' and JlDianHua like '%{GuanJianZi}%' and JlEntityCond like '%{GuanJianZi}%' and JlGeRenLvLi like '%{GuanJianZi}%'
and JlZcOverTime > '{jl.JlZcTime}' and JlZcTime < '{jl.JlZcOverTime}'";
DataTable dd = DBHelper.GetTable(sql);
return(View(dd));
}
public ActionResult JlRegisterInsertIndex(string MKName, string MCName, string ZPName, string JlName, string JlSex, string JlEmail, string JlDianHua, string JlJiaTingDianHua, string JlShouJi, string JlAdds, string JlYouBian, string JlGuoJi, string JlBreathAdds, string JlBreathDay, string JlMingZu, string JlZongJioaXingYang, string JlZhengZhiMianMao, string JlEntityCond, int JlAge, string JlBiYanShooln, string JlXueli, string JlJiaoYvYean, string JlXueLiZhuanYe, double JlXingZiYaoQiu, DateTime JlZcTime, string JlTeChang, string JlAiHoa, string JlGeRenLvLi, string JlBeiZhu)
{
JlMondel jlm = new JlMondel()
{
JlAdds = JlAdds,
JlAge = JlAge,
JlAiHoa = JlAiHoa,
JlBeiZhu = JlBeiZhu,
JlBiYanShooln = JlBiYanShooln,
JlBreathAdds = JlBreathAdds,
JlBreathDay = JlBreathDay,
JlDianHua = JlDianHua,
JlEmail = JlEmail,
JlEntityCond = JlEntityCond,
JlGeRenLvLi = JlGeRenLvLi,
JlGuoJi = JlGuoJi,
JlJiaoYvYean = JlJiaoYvYean,
JlJiaTingDianHua = JlJiaTingDianHua,
JlMingZu = JlMingZu,
JlName = JlName,
JlSex = JlSex,
JlShouJi = JlShouJi,
JlTeChang = JlTeChang,
JlXingZiYaoQiu = JlXingZiYaoQiu,
JlXueli = JlXueli,
JlXueLiZhuanYe = JlXueLiZhuanYe,
JlYouBian = JlYouBian,
JlZcTime = JlZcTime,
JlZhengZhiMianMao = JlZhengZhiMianMao,
JlZongJioaXingYang = JlZongJioaXingYang,
MCName = MCName,
MKName = MKName,
ZPName = ZPName
};
return(Content(JsonConvert.SerializeObject(ijl.InsertJl(jlm))));
}
public int UpdateJl(JlMondel jim)
{
return(ijl.UpdateJl(jim));
}
public int InsertJl(JlMondel jlm)
{
return(ijl.InsertJl(jlm));
}
