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()); }