public canshulei fenye2(Cansh ji)
{
Expression <Func <human_file, bool> > expr = n => GetCondition(n, ji);
canshulei cs = new canshulei();
List <human_fileModel> li = new List <human_fileModel>();
int rows = 0;
var data = db.Set <human_file>().OrderBy(e => e.id).Where(expr.Compile()).ToList();
rows = data.Count();//获取总行数
List <human_file> list = data.Skip((ji.dqy - 1) * ji.rl)
.Take(ji.rl)
.ToList();
foreach (human_file item in list)
{
human_fileModel mo = new human_fileModel();
mo.id = item.id;
mo.human_name = item.human_name;
mo.human_id = item.human_id;
mo.human_sex = item.human_sex;
mo.first_kind_name = item.first_kind_name;
mo.second_kind_name = item.second_kind_name;
mo.third_kind_name = item.third_kind_name;
mo.hunma_major_name = item.hunma_major_name;
mo.human_major_kind_name = item.human_major_kind_name;
li.Add(mo);
}
cs.li = li;
cs.MyProperty = rows;
cs.zys = (rows % ji.rl == 0 ? rows / ji.rl : rows % ji.rl + 1);
return(cs);
}
//删除分页
public canshulei fenye4(int dqy, int rl)
{
canshulei cs = new canshulei();
List <human_fileModel> li = new List <human_fileModel>();
int rows = 0;
var data = db.Set <human_file>().OrderBy(e => e.id).Where(e => e.human_file_status == true && e.check_status == 1).AsNoTracking();
rows = data.Count();//获取总行数
List <human_file> list = FenYe <int>(e => e.id, e => e.human_file_status == true && e.check_status == 1, ref rows, dqy, rl);
foreach (human_file item in list)
{
human_fileModel mo = new human_fileModel();
mo.id = item.id;
mo.human_name = item.human_name;
mo.human_id = item.human_id;
mo.human_sex = item.human_sex;
mo.first_kind_name = item.first_kind_name;
mo.second_kind_name = item.second_kind_name;
mo.third_kind_name = item.third_kind_name;
mo.hunma_major_name = item.hunma_major_name;
mo.human_major_kind_name = item.human_major_kind_name;
li.Add(mo);
}
cs.li = li;
cs.MyProperty = rows;
cs.zys = (rows % rl == 0 ? rows / rl : rows / rl + 1);
return(cs);
}
public ActionResult Add(human_fileModel hm)
{
config_file_second_kindModel csm = new config_file_second_kindModel
{
second_kind_id = hm.second_kind_id
};
config_file_first_kindModel cfm = new config_file_first_kindModel
{
first_kind_id = hm.first_kind_id
};
config_file_third_kindModel css = new config_file_third_kindModel
{
third_kind_id = hm.third_kind_id
};
List <config_file_second_kindModel> lists = sb.SelectByName(csm);
List <config_file_first_kindModel> listf = ib.SelectByName(cfm);
List <config_file_third_kindModel> lis = isb.SelectByName(css);
hm.second_kind_name = lists[0].second_kind_name;
hm.first_kind_name = listf[0].first_kind_name;
hm.third_kind_name = lis[0].third_kind_name;
hm.human_file_status = 1;
if (hfb.Add(hm) > 0)
{
return(Content("<script>window.location='WJSC/" + hm.human_id + "'</script>"));
}
return(View(hm));
}
public int update(human_fileModel item)
{
human_file st = db.human_file.Where(e => e.id.Equals(item.id)).FirstOrDefault();
//修改名称
st.human_picture = item.human_picture;
return(db.SaveChanges());;
}
public int Update(human_fileModel st)
{
human_file est = new human_file()
{
Id = st.Id
};
return(Update(est));
}
public ActionResult Update(human_fileModel hfm)
{
hfm.check_status = 1;
hfm.human_file_status = 1;
hfm.check_time = DateTime.Now;
if (hfb.Update(hfm) > 0)
{
return(Content("<script>alert('复核成功!');window.location='/human_file/Index'</script>"));
}
return(View(hfm));
}
public List <human_fileModel> Fenye(int dqy)
{
int rows = 0;
List <human_file> list = FenYe <int>(e => e.Id, e => e.Id > 0, ref rows, dqy, 3);
List <human_fileModel> list2 = new List <human_fileModel>();
foreach (human_file item in list)
{
human_fileModel um = new human_fileModel()
{
Id = item.Id,
human_id = item.human_id,
first_kind_id = item.first_kind_id,
first_kind_name = item.first_kind_name,
second_kind_id = item.second_kind_id,
second_kind_name = item.second_kind_name,
third_kind_id = item.third_kind_id,
third_kind_name = item.third_kind_name,
register = item.register,
changer = item.changer,
regist_time = item.regist_time,
change_time = item.change_time,
human_name = item.human_name,
human_address = item.human_address,
human_postcode = item.human_postcode,
human_major_kind_id = item.human_major_kind_id,
human_major_kind_name = item.human_major_kind_name,
human_major_id = item.human_major_id,
hunma_major_name = item.hunma_major_name,
human_telephone = item.human_telephone,
human_mobilephone = item.human_mobilephone,
human_email = item.human_email,
human_hobby = item.human_hobby,
human_speciality = item.human_speciality,
human_sex = item.human_sex,
human_religion = item.human_religion,
human_party = item.human_party,
human_nationality = item.human_nationality,
human_race = item.human_race,
human_birthday = item.human_birthday,
human_age = item.human_age,
human_birthplace = item.human_birthplace,
human_educated_degree = item.human_educated_degree,
human_educated_years = item.human_educated_years,
human_educated_major = item.human_educated_major,
human_id_card = item.human_id_card,
remark = item.remark,
check_status = item.check_status
};
list2.Add(um);
}
return(list2);
}
public int update13(human_fileModel item)
{
human_file ko = db.human_file.Where(e => e.id.Equals(item.id)).FirstOrDefault();
//修改名称
ko.human_pro_designation = item.human_pro_designation;
ko.human_name = item.human_name;
ko.human_sex = item.human_sex;
ko.human_email = item.human_email;
ko.human_telephone = item.human_telephone;
ko.human_qq = item.human_qq;
ko.human_mobilephone = item.human_mobilephone;
ko.human_address = item.human_address;
ko.human_postcode = item.human_postcode;
ko.human_nationality = item.human_nationality;
ko.human_birthplace = item.human_birthplace;
ko.human_birthday = item.human_birthday;
ko.human_race = item.human_race;
ko.human_religion = item.human_religion;
ko.human_party = item.human_party;
ko.human_id_card = item.human_id_card;
ko.human_society_security_id = item.human_society_security_id;
ko.human_age = item.human_age;
ko.human_educated_degree = item.human_educated_degree;
ko.human_educated_years = item.human_educated_years;
ko.human_educated_major = item.human_educated_major;
ko.salary_standard_id = item.salary_standard_id;
ko.human_bank = item.human_bank;
ko.human_account = item.human_account;
ko.changer = item.changer;
ko.change_time = item.change_time;
ko.human_speciality = item.human_speciality;
ko.human_hobby = item.human_hobby;
ko.human_histroy_records = item.human_histroy_records;
ko.human_family_membership = item.human_family_membership;
ko.remark = item.remark;
ko.check_status = item.check_status;
ko.human_file_status = false;
ko.lastly_change_time = item.lastly_change_time;
return(db.SaveChanges());
}
public ActionResult DEL1(int id)
{
human_fileModel hfm = new human_fileModel
{
Id = id
};
if (hfb.Del(hfm) > 0)
{
return(Content("<script>alert('删除成功');window.location='DEL'</script>"));
}
return(Content("<script>alert('删除失败');window.location='DEL'</script>"));
}
public ActionResult DJ(engage_resumeModel erm)
{
List <config_file_first_kindModel> list = ib.Select();
List <SelectListItem> listyj = new List <SelectListItem>();
for (int i = 0; i < list.Count; i++)
{
SelectListItem sl = new SelectListItem()
{
Text = list[i].first_kind_name.ToString(),
Value = list[i].first_kind_id.ToString()
};
listyj.Add(sl);
}
ViewData["yj"] = listyj;
human_fileModel hfm = new human_fileModel
{
human_id = erm.Id.ToString(),
human_name = erm.human_name,
human_address = erm.human_address,
human_age = erm.human_age,
human_email = erm.human_email,
human_major_id = erm.human_major_id,
human_major_kind_id = erm.human_major_kind_id,
human_major_kind_name = erm.human_major_kind_name,
hunma_major_name = erm.human_major_name,
human_telephone = erm.human_telephone,
human_mobilephone = erm.human_mobilephone,
human_hobby = erm.human_hobby,
human_speciality = erm.human_specility,
human_religion = erm.human_religion,
human_party = erm.human_party,
human_nationality = erm.human_nationality,
human_race = erm.human_race,
human_birthday = erm.human_birthday,
human_birthplace = erm.human_birthplace,
human_educated_degree = erm.human_educated_degree,
human_educated_years = erm.human_educated_years,
human_educated_major = erm.human_educated_major,
human_id_card = erm.human_idcard,
human_postcode = erm.human_postcode,
register = Session["us"].ToString(),
remark = erm.remark
};
ZC();
XZBZ();
return(View(hfm));
}
public List <human_fileModel> SelectBy(human_fileModel st)
{
List <human_file> list = SelectBy(e => e.Id.Equals(st.Id));
List <human_fileModel> list2 = new List <human_fileModel>();
foreach (var item in list)
{
human_fileModel sd = new human_fileModel()
{
Id = item.Id
};
list2.Add(sd);
}
return(list2);
}
public List <Model.human_fileModel> Select()
{
List <human_file> list = SelectAll();
List <human_fileModel> list2 = new List <human_fileModel>();
foreach (human_file item in list)
{
human_fileModel sm = new human_fileModel()
{
Id = item.Id
};
list2.Add(sm);
}
return(list2);
}
public int Add(human_fileModel st)
{
int i = int.Parse(Se().ToString()) + 1;
//把DTO转为EO
human_file est = new human_file()
{
Id = st.Id,
human_id = i.ToString(),
human_name = st.human_name,
human_address = st.human_address,
human_postcode = st.human_postcode,
human_major_kind_id = st.human_major_kind_id,
human_major_kind_name = st.human_major_kind_name,
human_major_id = st.human_major_id,
hunma_major_name = st.hunma_major_name,
human_telephone = st.human_telephone,
human_mobilephone = st.human_mobilephone,
human_email = st.human_email,
human_hobby = st.human_hobby,
human_speciality = st.human_speciality,
human_sex = st.human_sex,
human_religion = st.human_religion,
human_party = st.human_party,
human_nationality = st.human_nationality,
human_race = st.human_race,
human_birthday = st.human_birthday,
human_age = st.human_age,
human_birthplace = st.human_birthplace,
human_educated_degree = st.human_educated_degree,
human_educated_years = st.human_educated_years,
human_educated_major = st.human_educated_major,
human_id_card = st.human_id_card,
remark = st.remark,
regist_time = DateTime.Now,
check_time = DateTime.Now,
change_time = DateTime.Now,
lastly_change_time = DateTime.Now,
delete_time = DateTime.Now,
recovery_time = DateTime.Now,
check_status = "待复核"
};
return(Add(est));
}
//状态修改
public int updateztai(human_fileModel item)
{
human_file st = db.human_file.Where(e => e.id.Equals(item.id)).FirstOrDefault();
if (item.delete_time == DateTime.MinValue)
{
st.recovery_time = item.recovery_time;
}
if (item.recovery_time == DateTime.MinValue)
{
st.delete_time = item.delete_time;
}
//修改名称
st.human_file_status = item.human_file_status;
return(db.SaveChanges());;
}
public int Update(human_fileModel st)
{
return(ist.Update(st));
}
public List <human_fileModel> FenYe(FenYeModel fen)
{
List <human_fileModel> list = new List <human_fileModel>();
SqlParameter[] ps =
{
new SqlParameter()
{
ParameterName = "@pageSize", Value = fen.PageSize
},
new SqlParameter()
{
ParameterName = "@keyName", Value = fen.KeyName
},
new SqlParameter()
{
ParameterName = "@tableName", Value = fen.TableName
},
new SqlParameter()
{
ParameterName = "@where", Value = fen.Where
},
new SqlParameter()
{
ParameterName = "@currentPage", Value = fen.CurrentPage
},
new SqlParameter()
{
ParameterName = "@rows", Direction = ParameterDirection.Output, SqlDbType = SqlDbType.Int
},
new SqlParameter()
{
ParameterName = "@pages", Direction = ParameterDirection.Output, SqlDbType = SqlDbType.Int
}
};
var sql = tescDbContext.hf.FromSqlRaw($@"exec dbo.FenYeWhere @pageSize,@keyName,@tableName,@where,@currentPage,@rows out,@pages out", ps).ToList();
foreach (var ad in sql)
{
human_fileModel h = new human_fileModel()
{
huf_id = ad.huf_id,
human_id = ad.human_id,
first_kind_id = ad.first_kind_id,
first_kind_name = ad.first_kind_name,
second_kind_id = ad.second_kind_id,
second_kind_name = ad.second_kind_name,
third_kind_id = ad.third_kind_id,
third_kind_name = ad.third_kind_name,
human_name = ad.human_name,
human_address = ad.human_address,
human_postcode = ad.human_postcode,
human_pro_designation = ad.human_pro_designation,
human_major_kind_id = ad.human_major_kind_id,
human_major_kind_name = ad.human_major_kind_name,
human_major_id = ad.human_major_id,
hunma_major_name = ad.hunma_major_name,
human_telephone = ad.human_telephone,
human_mobilephone = ad.human_mobilephone,
human_bank = ad.human_bank,
human_account = ad.human_account,
human_qq = ad.human_qq,
human_email = ad.human_email,
human_hobby = ad.human_hobby,
human_speciality = ad.human_speciality,
human_sex = ad.human_sex,
human_religion = ad.human_religion,
human_party = ad.human_party,
human_nationality = ad.human_nationality,
human_race = ad.human_race,
human_birthday = ad.human_birthday,
human_birthplace = ad.human_birthplace,
vhuman_age = ad.vhuman_age,
human_educated_degree = ad.human_educated_degree,
human_educated_years = ad.human_educated_years,
human_educated_major = ad.human_educated_major,
human_society_security_id = ad.human_society_security_id,
human_id_card = ad.human_id_card,
remark = ad.remark,
salary_standard_id = ad.salary_standard_id,
salary_standard_name = ad.salary_standard_name,
salary_sum = ad.salary_sum,
demand_salaray_sum = ad.demand_salaray_sum,
paid_salary_sum = ad.paid_salary_sum,
major_change_amount = ad.major_change_amount,
bonus_amount = ad.bonus_amount,
training_amount = ad.training_amount,
file_chang_amount = ad.file_chang_amount,
human_histroy_records = ad.human_histroy_records,
human_family_membership = ad.human_family_membership,
human_picture = ad.human_picture,
attachment_name = ad.attachment_name,
check_status = ad.check_status,
register = ad.register,
checker = ad.checker,
changer = ad.changer,
regist_time = ad.regist_time,
check_time = ad.check_time,
change_time = ad.change_time,
lastly_change_time = ad.lastly_change_time,
delete_time = ad.delete_time,
recovery_time = ad.recovery_time,
human_file_status = ad.human_file_status
};
list.Add(h);
}
fen.Pages = (int)ps[6].Value;
fen.Rows = (int)ps[5].Value;
return(list);
}
public human_fileModel SelByID02(int id)
{
List <human_file> item1 = tescDbContext.hf.Where(e => e.huf_id == id).ToList();
human_file h = item1[0];
human_fileModel model = new human_fileModel()
{
huf_id = id,
human_id = h.human_id,
first_kind_id = h.first_kind_id,
first_kind_name = h.first_kind_name,
second_kind_id = h.second_kind_id,
second_kind_name = h.second_kind_name,
third_kind_id = h.third_kind_id,
third_kind_name = h.third_kind_name,
human_name = h.human_name,
human_address = h.human_address,
human_postcode = h.human_postcode,
human_pro_designation = h.human_pro_designation,
human_major_kind_id = h.human_major_kind_id,
human_major_kind_name = h.human_major_kind_name,
human_major_id = h.human_major_id,
hunma_major_name = h.hunma_major_name,
human_telephone = h.human_telephone,
human_mobilephone = h.human_mobilephone,
human_bank = h.human_bank,
human_account = h.human_account,
human_qq = h.human_qq,
human_email = h.human_email,
human_hobby = h.human_hobby,
human_speciality = h.human_speciality,
human_sex = h.human_sex,
human_religion = h.human_religion,
human_party = h.human_party,
human_nationality = h.human_nationality,
human_race = h.human_race,
human_birthday = h.human_birthday,
human_birthplace = h.human_birthplace,
vhuman_age = h.vhuman_age,
human_educated_degree = h.human_educated_degree,
human_educated_years = h.human_educated_years,
human_educated_major = h.human_educated_major,
human_society_security_id = h.human_society_security_id,
human_id_card = h.human_id_card,
//v = h.v,
salary_standard_id = h.salary_standard_id,
salary_standard_name = h.salary_standard_name,
salary_sum = h.salary_sum,
demand_salaray_sum = h.demand_salaray_sum,
paid_salary_sum = h.paid_salary_sum,
major_change_amount = h.major_change_amount,
bonus_amount = h.bonus_amount,
training_amount = h.training_amount,
file_chang_amount = h.file_chang_amount,
human_histroy_records = h.human_histroy_records,
human_family_membership = h.human_family_membership,
human_picture = h.human_picture,
attachment_name = h.attachment_name,
check_status = h.check_status,
register = h.register,
checker = h.checker,
changer = h.changer,
regist_time = h.regist_time,
check_time = h.check_time,
change_time = h.change_time,
lastly_change_time = h.lastly_change_time,
delete_time = h.delete_time,
recovery_time = h.recovery_time,
human_file_status = h.human_file_status
};
return(model);
}
public List <human_fileModel> selectupdate(string id)
{
List <human_file> list = SeleteBy(e => e.human_id.Equals(id));
List <human_fileModel> li = new List <human_fileModel>();
foreach (human_file item in list)
{
human_fileModel ko = new human_fileModel();
ko.id = item.id;
ko.human_id = item.human_id;
ko.first_kind_id = item.first_kind_id;
ko.first_kind_name = item.first_kind_name;
ko.second_kind_id = item.second_kind_id;
ko.second_kind_name = item.second_kind_name;
ko.third_kind_id = item.third_kind_id;
ko.third_kind_name = item.third_kind_name;
ko.human_name = item.human_name;
ko.human_address = item.human_address;
ko.human_postcode = item.human_postcode;
ko.human_pro_designation = item.human_pro_designation;
ko.human_major_kind_id = item.human_major_kind_id;
ko.human_major_kind_name = item.human_major_kind_name;
ko.human_major_id = item.human_major_id;
ko.hunma_major_name = item.hunma_major_name;
ko.human_telephone = item.human_telephone;
ko.human_mobilephone = item.human_mobilephone;
ko.human_bank = item.human_bank;
ko.human_account = item.human_account;
ko.human_qq = item.human_qq;
ko.human_email = item.human_email;
ko.human_hobby = item.human_hobby;
ko.human_speciality = item.human_speciality;
ko.human_sex = item.human_sex;
ko.human_religion = item.human_religion;
ko.human_party = item.human_party;
ko.human_nationality = item.human_nationality;
ko.human_race = item.human_race;
ko.human_birthday = item.human_birthday;
ko.human_birthplace = item.human_birthplace;
ko.human_age = item.human_age;
ko.human_educated_degree = item.human_educated_degree;
ko.human_educated_years = item.human_educated_years;
ko.human_educated_major = item.human_educated_major;
ko.human_society_security_id = item.human_society_security_id;
ko.human_id_card = item.human_id_card;
ko.remark = item.remark;
ko.salary_standard_id = item.salary_standard_id;
ko.salary_standard_name = item.salary_standard_name;
ko.salary_sum = item.salary_sum;
ko.demand_salaray_sum = item.demand_salaray_sum;
ko.paid_salary_sum = item.paid_salary_sum;
ko.major_change_amount = item.major_change_amount;
ko.bonus_amount = item.bonus_amount;
ko.training_amount = item.training_amount;
ko.file_chang_amount = item.file_chang_amount;
ko.human_histroy_records = item.human_histroy_records;
ko.human_family_membership = item.human_family_membership;
ko.human_picture = item.human_picture;
ko.attachment_name = item.attachment_name;
ko.check_status = item.check_status;
ko.register = item.register;
ko.checker = item.checker;
ko.changer = item.changer;
ko.regist_time = item.regist_time;
ko.check_time = item.check_time;
ko.change_time = item.change_time;
ko.lastly_change_time = item.lastly_change_time;
ko.delete_time = item.delete_time;
ko.recovery_time = item.recovery_time;
ko.human_file_status = item.human_file_status; li.Add(ko);
}
return(li);
}
public ActionResult Update(int id)
{
human_fileModel hm = new human_fileModel()
{
Id = id
};
List <human_fileModel> list = hfb.SelectById(hm);
human_fileModel st = new human_fileModel()
{
Id = list[0].Id,
human_id = list[0].human_id,
first_kind_id = list[0].first_kind_id,
first_kind_name = list[0].first_kind_name,
second_kind_id = list[0].second_kind_id,
second_kind_name = list[0].second_kind_name,
third_kind_id = list[0].third_kind_id,
third_kind_name = list[0].third_kind_name,
human_name = list[0].human_name,
human_address = list[0].human_address,
human_postcode = list[0].human_postcode,
human_pro_designation = list[0].human_pro_designation,
human_major_kind_id = list[0].human_major_kind_id,
human_major_kind_name = list[0].human_major_kind_name,
human_major_id = list[0].human_major_id,
hunma_major_name = list[0].hunma_major_name,
human_telephone = list[0].human_telephone,
human_mobilephone = list[0].human_mobilephone,
human_bank = list[0].human_bank,
human_account = list[0].human_account,
human_qq = list[0].human_qq,
human_email = list[0].human_email,
human_hobby = list[0].human_hobby,
human_speciality = list[0].human_speciality,
human_sex = list[0].human_sex,
human_religion = list[0].human_religion,
human_party = list[0].human_party,
human_nationality = list[0].human_nationality,
human_race = list[0].human_race,
human_birthday = list[0].human_birthday,
human_birthplace = list[0].human_birthplace,
human_age = list[0].human_age,
human_educated_degree = list[0].human_educated_degree,
human_educated_years = list[0].human_educated_years,
human_educated_major = list[0].human_educated_major,
human_society_security_id = list[0].human_society_security_id,
human_id_card = list[0].human_id_card,
remark = list[0].remark,
salary_standard_id = list[0].salary_standard_id,
salary_standard_name = list[0].salary_standard_name,
salary_sum = list[0].salary_sum,
major_change_amount = list[0].major_change_amount,
training_amount = list[0].training_amount,
file_chang_amount = list[0].file_chang_amount,
human_histroy_records = list[0].human_histroy_records,
regist_time = list[0].regist_time,
check_time = list[0].check_time,
change_time = list[0].change_time,
lastly_change_time = list[0].lastly_change_time,
delete_time = list[0].delete_time,
recovery_time = list[0].recovery_time,
register = list[0].register,
checker = list[0].checker,
changer = list[0].changer,
human_family_membership = list[0].human_family_membership
};
ViewData["url"] = list[0].human_picture;
List <usersModel> listum = iub.Select();
List <SelectListItem> user = new List <SelectListItem>();
for (int i = 0; i < listum.Count; i++)
{
SelectListItem sli = new SelectListItem()
{
Text = listum[i].u_name.ToString(),
Value = listum[i].u_name.ToString()
};
user.Add(sli);
}
ViewData["user"] = user;
ZC();
Fillgj();
Fillmz();
Fillzjxy();
Fillzzmm();
Fillxl();
Filljiaoyu();
Fillxuelizy();
XZBZ();
Filltechang();
Fillaih();
return(View(st));
}
public string Add(human_fileModel item)
{
human_file ko = new human_file();
string sql = "bd";
SqlParameter[] ji =
{
new SqlParameter()
{
ParameterName = "@danhao", Size = 14, SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Output
},
};
DataTable dt = DBHaipu.SelectProc(sql, ji, "");
//获取值
string r = ji[0].Value.ToString();
ko.human_id = r;
// ko.human_id = item.human_id;
ko.first_kind_id = item.first_kind_id;
ko.first_kind_name = item.first_kind_name;
ko.second_kind_id = item.second_kind_id;
ko.second_kind_name = item.second_kind_name;
ko.third_kind_id = item.third_kind_id;
ko.third_kind_name = item.third_kind_name;
ko.human_name = item.human_name;
ko.human_address = item.human_address;
ko.human_postcode = item.human_postcode;
ko.human_pro_designation = item.human_pro_designation;
ko.human_major_kind_id = item.human_major_kind_id;
ko.human_major_kind_name = item.human_major_kind_name;
ko.human_major_id = item.human_major_id;
ko.hunma_major_name = item.hunma_major_name;
ko.human_telephone = item.human_telephone;
ko.human_mobilephone = item.human_mobilephone;
ko.human_bank = item.human_bank;
ko.human_account = item.human_account;
ko.human_qq = item.human_qq;
ko.human_email = item.human_email;
ko.human_hobby = item.human_hobby;
ko.human_speciality = item.human_speciality;
ko.human_sex = item.human_sex;
ko.human_religion = item.human_religion;
ko.human_party = item.human_party;
ko.human_nationality = item.human_nationality;
ko.human_race = item.human_race;
ko.human_birthday = item.human_birthday;
ko.human_birthplace = item.human_birthplace;
ko.human_age = item.human_age;
ko.human_educated_degree = item.human_educated_degree;
ko.human_educated_years = item.human_educated_years;
ko.human_educated_major = item.human_educated_major;
ko.human_society_security_id = item.human_society_security_id;
ko.human_id_card = item.human_id_card;
ko.remark = item.remark;
ko.salary_standard_id = item.salary_standard_id;
ko.salary_standard_name = item.salary_standard_name;
ko.salary_sum = item.salary_sum;
ko.demand_salaray_sum = item.demand_salaray_sum;
ko.paid_salary_sum = item.paid_salary_sum;
ko.major_change_amount = item.major_change_amount;
ko.bonus_amount = item.bonus_amount;
ko.training_amount = item.training_amount;
ko.file_chang_amount = item.file_chang_amount;
ko.human_histroy_records = item.human_histroy_records;
ko.human_family_membership = item.human_family_membership;
ko.human_picture = item.human_picture;
//
ko.attachment_name = item.attachment_name;
ko.check_status = item.check_status;
ko.register = item.register;
ko.checker = item.checker;
ko.changer = item.changer;
//
ko.regist_time = item.regist_time;
ko.check_time = DateTime.Now;
ko.change_time = DateTime.Now;
ko.lastly_change_time = DateTime.Now;
ko.delete_time = DateTime.Now;
ko.recovery_time = DateTime.Now;
ko.human_file_status = item.human_file_status;
ko.salary_standard_name = item.salary_standard_name;
ko.salary_standard_id = item.salary_standard_id;
ko.salary_sum = item.salary_sum;
ko.register = item.register;
if (Add(ko) > 0)
{
return(r);
}
else
{
return(null);
}
}
public List <human_fileModel> select()
{
List <human_fileModel> list2 = new List <human_fileModel>();
List <human_file> list = tescDbContext.hf.ToList();
foreach (human_file item in list)
{
human_fileModel tm = new human_fileModel()
{
attachment_name = item.attachment_name,
bonus_amount = item.bonus_amount,
changer = item.changer,
change_time = item.change_time,
checker = item.checker,
check_status = item.check_status,
check_time = item.check_time,
delete_time = item.delete_time,
demand_salaray_sum = item.demand_salaray_sum,
file_chang_amount = item.file_chang_amount,
first_kind_id = item.first_kind_id,
first_kind_name = item.first_kind_name,
huf_id = item.huf_id,
human_account = item.human_account,
human_address = item.human_address,
vhuman_age = item.vhuman_age,
human_bank = item.human_bank,
human_birthday = item.human_birthday,
human_birthplace = item.human_birthplace,
human_educated_degree = item.human_educated_degree,
human_educated_major = item.human_educated_major,
human_educated_years = item.human_educated_years,
human_email = item.human_email,
human_family_membership = item.human_family_membership,
human_file_status = item.human_file_status,
human_histroy_records = item.human_histroy_records,
human_hobby = item.human_hobby,
human_id = item.human_id,
human_id_card = item.human_id_card,
human_major_id = item.human_major_id,
human_major_kind_id = item.human_major_kind_id,
human_major_kind_name = item.human_major_kind_name,
human_mobilephone = item.human_mobilephone,
human_name = item.human_name,
human_nationality = item.human_nationality,
human_party = item.human_party,
human_picture = item.human_picture,
human_postcode = item.human_postcode,
human_pro_designation = item.human_pro_designation,
human_qq = item.human_qq,
human_race = item.human_race,
human_religion = item.human_religion,
human_sex = item.human_sex,
human_society_security_id = item.human_society_security_id,
human_speciality = item.human_speciality,
human_telephone = item.human_telephone,
hunma_major_name = item.hunma_major_name,
lastly_change_time = item.lastly_change_time,
major_change_amount = item.major_change_amount,
paid_salary_sum = item.paid_salary_sum,
recovery_time = item.recovery_time,
register = item.register,
regist_time = item.regist_time,
remark = item.remark,
salary_standard_id = item.salary_standard_id,
salary_standard_name = item.salary_standard_name,
salary_sum = item.salary_sum,
second_kind_id = item.second_kind_id,
second_kind_name = item.second_kind_name,
third_kind_id = item.third_kind_id,
third_kind_name = item.third_kind_name,
training_amount = item.training_amount,
};
list2.Add(tm);
}
return(list2);
}
public ActionResult WJSC1(int uid, HttpPostedFileBase file)
{
string name = Md5String.Md5CreateName(file.InputStream); //文件名
string ext = Path.GetExtension(file.FileName); //后缀名
//1 获得上传文件的完整路径
string path = $"/Uploader/{DateTime.Now.ToString("yyyy/MM/dd")}/" + name + ext;
string fullPath = Server.MapPath(path);
new FileInfo(fullPath).Directory.Create();//创建文件夹
//2 调用file.SaveAs(完整路径)
file.SaveAs(fullPath);
//根据uid做表的修改
human_fileModel hm = new human_fileModel
{
human_id = uid.ToString()
};
List <human_fileModel> list = hfb.SelectBy(hm);
var MyDate = DateTime.Now;
string year = MyDate.Year.ToString();
string month = (MyDate.Month + 1).ToString();
string Day = MyDate.Day.ToString();
string h = MyDate.Hour.ToString();
string m = MyDate.Minute.ToString();
string s = MyDate.Second.ToString();
string Number = "bt" + year + month + Day + h + m + s;
human_fileModel hfm = new human_fileModel
{
Id = list[0].Id,
human_id = Number,
first_kind_id = list[0].first_kind_id,
first_kind_name = list[0].first_kind_name,
second_kind_id = list[0].second_kind_id,
second_kind_name = list[0].second_kind_name,
third_kind_id = list[0].third_kind_id,
third_kind_name = list[0].third_kind_name,
human_name = list[0].human_name,
human_address = list[0].human_address,
human_postcode = list[0].human_postcode,
human_pro_designation = list[0].human_pro_designation,
human_major_kind_id = list[0].human_major_kind_id,
human_major_kind_name = list[0].human_major_kind_name,
human_major_id = list[0].human_major_id,
hunma_major_name = list[0].hunma_major_name,
human_telephone = list[0].human_telephone,
human_mobilephone = list[0].human_mobilephone,
human_bank = list[0].human_bank,
human_account = list[0].human_account,
human_qq = list[0].human_qq,
human_email = list[0].human_email,
human_hobby = list[0].human_hobby,
human_speciality = list[0].human_speciality,
human_sex = list[0].human_sex,
human_religion = list[0].human_religion,
human_party = list[0].human_party,
human_nationality = list[0].human_nationality,
human_race = list[0].human_race,
human_birthday = list[0].human_birthday,
human_birthplace = list[0].human_birthplace,
human_age = list[0].human_age,
human_educated_degree = list[0].human_educated_degree,
human_educated_years = list[0].human_educated_years,
human_educated_major = list[0].human_educated_major,
human_society_security_id = list[0].human_society_security_id,
human_id_card = list[0].human_id_card,
remark = list[0].remark,
salary_standard_id = list[0].salary_standard_id,
salary_standard_name = list[0].salary_standard_name,
salary_sum = list[0].salary_sum,
major_change_amount = list[0].major_change_amount,
training_amount = list[0].training_amount,
file_chang_amount = list[0].file_chang_amount,
human_histroy_records = list[0].human_histroy_records,
human_family_membership = list[0].human_family_membership,
regist_time = list[0].regist_time,
check_time = list[0].check_time,
change_time = list[0].change_time,
lastly_change_time = list[0].lastly_change_time,
delete_time = list[0].delete_time,
recovery_time = list[0].recovery_time,
human_file_status = list[0].human_file_status,
check_status = list[0].check_status,
register = list[0].register,
changer = list[0].changer,
checker = list[0].checker,
human_picture = path
};
hfm.human_file_status = 1;
if (hfb.Update(hfm) > 0)
{
return(Content("<script>alert('上传成功!')</script>"));
}
else
{
return(View(uid));
}
}
public int human_fileUpdate(human_fileModel h)
{
throw new NotImplementedException();
}
public ActionResult SCSelect1(int id)
{
human_fileModel hfm = new human_fileModel
{
Id = id
};
List <human_fileModel> list = hfb.SelectById(hfm);
human_fileModel st = new human_fileModel()
{
Id = list[0].Id,
human_id = list[0].human_id,
first_kind_id = list[0].first_kind_id,
first_kind_name = list[0].first_kind_name,
second_kind_id = list[0].second_kind_id,
second_kind_name = list[0].second_kind_name,
third_kind_id = list[0].third_kind_id,
third_kind_name = list[0].third_kind_name,
human_name = list[0].human_name,
human_address = list[0].human_address,
human_postcode = list[0].human_postcode,
human_pro_designation = list[0].human_pro_designation,
human_major_kind_id = list[0].human_major_kind_id,
human_major_kind_name = list[0].human_major_kind_name,
human_major_id = list[0].human_major_id,
hunma_major_name = list[0].hunma_major_name,
human_telephone = list[0].human_telephone,
human_mobilephone = list[0].human_mobilephone,
human_bank = list[0].human_bank,
human_account = list[0].human_account,
human_qq = list[0].human_qq,
human_email = list[0].human_email,
human_hobby = list[0].human_hobby,
human_speciality = list[0].human_speciality,
human_sex = list[0].human_sex,
human_religion = list[0].human_religion,
human_party = list[0].human_party,
human_nationality = list[0].human_nationality,
human_race = list[0].human_race,
human_birthday = list[0].human_birthday,
human_birthplace = list[0].human_birthplace,
human_age = list[0].human_age,
human_educated_degree = list[0].human_educated_degree,
human_educated_years = list[0].human_educated_years,
human_educated_major = list[0].human_educated_major,
human_society_security_id = list[0].human_society_security_id,
human_id_card = list[0].human_id_card,
remark = list[0].remark,
salary_standard_id = list[0].salary_standard_id,
salary_standard_name = list[0].salary_standard_name,
salary_sum = list[0].salary_sum,
major_change_amount = list[0].major_change_amount,
training_amount = list[0].training_amount,
file_chang_amount = list[0].file_chang_amount,
human_histroy_records = list[0].human_histroy_records,
regist_time = list[0].regist_time,
check_time = list[0].check_time,
change_time = list[0].change_time,
lastly_change_time = list[0].lastly_change_time,
delete_time = list[0].delete_time,
recovery_time = list[0].recovery_time,
register = list[0].register,
checker = list[0].checker,
changer = list[0].changer,
human_family_membership = list[0].human_family_membership
};
ViewData["url"] = list[0].human_picture;
return(View(st));
}
public ActionResult SCUpdate(human_fileModel hfm)
{
return(Content(""));
}
public int HREdit(human_fileModel h)
{
throw new NotImplementedException();
}
public int Add(human_fileModel st)
{
return(ist.Add(st));
}
public List <human_fileModel> SelectById(human_fileModel st)
{
return(ist.SelectById(st));
}
public int Del(human_fileModel st)
{
return(ist.Del(st));
}
public IActionResult register(int id)
{
human_fileModel hfm = hum.SelByID02(id);
ViewBag.User_name = HttpContext.Session.GetString("User_name");
major_changeModel mcm = new major_changeModel()
{
first_kind_id = hfm.first_kind_id,
first_kind_name = hfm.first_kind_name,
second_kind_id = hfm.second_kind_id,
second_kind_name = hfm.second_kind_name,
third_kind_id = hfm.third_kind_id,
third_kind_name = hfm.third_kind_name,
major_id = hfm.human_major_id,
major_name = hfm.hunma_major_name,
major_kind_id = hfm.human_major_kind_id,
major_kind_name = hfm.human_major_kind_name,
human_id = hfm.human_id,
human_name = hfm.human_name,
salary_standard_id = hfm.salary_standard_id,
salary_standard_name = hfm.salary_standard_name,
salary_sum = hfm.salary_sum,
regist_time = DateTime.Now,
register = HttpContext.Session.GetString("User_name")
};
//1
List <config_file_first_kindModel1> list = icf.Selects();
List <config_file_first_kindModel1> lis = icf.Selects().Where(e => e.first_kind_name == mcm.first_kind_name).ToList();
for (int i = 0; i < lis.Count; i++)
{
if (list[i].first_kind_name == lis[0].first_kind_name)
{
list.Remove(list[i]);
break;
}
}
List <config_major_kindModel1> list3 = cmk.Select();
List <config_major_kindModel1> lis4 = cmk.Select().Where(e => e.major_kind_id == mcm.major_kind_id).ToList();
for (int i = 0; i < list3.Count; i++)
{
if (list3[i].major_kind_id == lis4[0].major_kind_id)
{
list3.Remove(list3[i]);
break;
}
}
List <salary_standardModel> list5 = ss.Select().Where(e => e.check_status == 1).ToList();
SelectList sl = new SelectList(list, "first_kind_name", "first_kind_name", "请选择");
SelectList sl3 = new SelectList(list3, "major_kind_name", "major_kind_name", "请选择");
SelectList sl5 = new SelectList(list5, "standard_name", "standard_name", "请选择");
ViewData["majork"] = sl3;
ViewData["standard"] = sl5;
ViewData["first"] = sl;
ViewData.Model = mcm;
return(View());
}
