public IActionResult list(FenYeModel fen)
{
string firstKindId = HttpContext.Session.GetString("firstKindId");
string secondKindId = HttpContext.Session.GetString("secondKindId");
string thirdKindId = HttpContext.Session.GetString("thirdKindId");
string Major_kindId = HttpContext.Session.GetString("Major_kindId");
string Major_Id = HttpContext.Session.GetString("Major_Id");
DateTime starttime = Convert.ToDateTime(HttpContext.Session.GetString("starttime"));
DateTime endtime = Convert.ToDateTime(HttpContext.Session.GetString("endtime"));
string currentPage = Request.Form["currentPage"];
fen.CurrentPage = int.Parse(currentPage.ToString());
fen.PageSize = 3;
fen.Where = $@" new_first_kind_id='{firstKindId}' and new_second_kind_id='{secondKindId}' and new_third_kind_id='{thirdKindId}' and major_kind_name='{Major_kindId}' and major_name='{Major_Id}' and regist_time>= '{starttime}' and check_time<= '{endtime}' and check_status=1";
//and regist_time>= '{starttime}' and check_time<= '{endtime}'
fen.KeyName = "mch_id";
fen.TableName = "major_change";
List <major_changeModel> page = mc.FenYe(fen);
Dictionary <string, object> di = new Dictionary <string, object>();
di["dt"] = page;
di["pages"] = fen.Pages;
di["rows"] = fen.Rows;
di["PageSize"] = fen.PageSize;
return(Content(JsonConvert.SerializeObject(di)));
}
public ActionResult position_change_update2()
{
int rl = int.Parse(Request["rl"]);
IsoDateTimeConverter timeConverter = new IsoDateTimeConverter {
DateTimeFormat = "yyyy'-'MM'-'dd HH':'mm':'ss"
};
int currentPage = int.Parse(Request["currentPage"]);
FenYeModel fy = eng.Fenye(currentPage, rl);
string aa = JsonConvert.SerializeObject(fy, Formatting.Indented, timeConverter);
return(Content(aa));
}
public List <roleModel> FenYe(FenYeModel fen)
{
List <roleModel> list = new List <roleModel>();
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 = qx.Roles.FromSqlRaw($@"exec dbo.FenYeWhere @pageSize,@keyName,@tableName,@where,@currentPage,@rows out,@pages out", ps).ToList();
foreach (var ad in sql)
{
roleModel h = new roleModel()
{
r_id = ad.r_id,
r_sm = ad.r_sm,
r_status = ad.r_status,
user_identity = ad.user_identity
};
list.Add(h);
}
fen.Pages = (int)ps[6].Value;
fen.Rows = (int)ps[5].Value;
return(list);
}
public IActionResult right_list(FenYeModel fen)
{
string currentPage = Request.Form["currentPage"];
fen.CurrentPage = int.Parse(currentPage.ToString());
fen.PageSize = 3;
fen.Where = "";
fen.KeyName = "r_id";
fen.TableName = "role";
List <roleModel> page = irb.FenYe(fen);
Dictionary <string, object> di = new Dictionary <string, object>();
di["dt"] = page;
di["pages"] = fen.Pages;
di["rows"] = fen.Rows;
di["PageSize"] = fen.PageSize;
return(Content(JsonConvert.SerializeObject(di)));
}
public FenYeModel Fenye(int currentPage, int rl)
{
FenYeModel fym = new FenYeModel();
List <engage_major_releaseModel> list = new List <engage_major_releaseModel>();
int rows = 0;
var data = db.Set <engage_major_release>().OrderBy(e => e.id).AsNoTracking();
rows = data.Count();
List <engage_major_release> list2 = FenYe <int>(e => e.id, e => e.id > 0, ref rows, currentPage, rl);
foreach (engage_major_release item in list2)
{
engage_major_releaseModel emrm = new engage_major_releaseModel();
emrm.id = item.id;
emrm.first_kind_id = item.first_kind_id;
emrm.first_kind_name = item.first_kind_name;
emrm.second_kind_id = item.second_kind_id;
emrm.second_kind_name = item.second_kind_name;
emrm.third_kind_id = item.third_kind_id;
emrm.third_kind_name = item.third_kind_name;
emrm.major_kind_id = item.major_kind_id;
emrm.major_kind_name = item.major_kind_name;
emrm.major_id = item.major_id;
emrm.major_name = item.major_name;
emrm.human_amount = item.human_amount;
emrm.engage_type = item.engage_type;
emrm.deadline = item.deadline;
emrm.register = item.register;
emrm.changer = item.changer;
emrm.regist_time = item.regist_time;
emrm.change_time = item.change_time;
emrm.major_describe = item.major_describe;
emrm.engage_required = item.engage_required;
list.Add(emrm);
}
fym.rows = rows;
fym.list = list;
fym.pageSize = (rows % rl == 0 ? rows / rl : rows % rl + 1);
return(fym);
}
public IActionResult register_list(FenYeModel fen)
{
string currentPage = Request.Form["currentPage"];
string yiji = HttpContext.Session.GetString("yiji");
string erji = HttpContext.Session.GetString("erji");
string sanji = HttpContext.Session.GetString("sanji");
string sj1 = HttpContext.Session.GetString("sj1");
string sj2 = HttpContext.Session.GetString("sj2");
fen.CurrentPage = int.Parse(currentPage.ToString());
fen.PageSize = 3;
fen.Where = $@" first_kind_id='{yiji}' and second_kind_id='{erji}' and third_kind_id='{sanji}' and regist_time>='{sj1}' and regist_time<='{sj2}'";
fen.KeyName = "huf_id";
fen.TableName = "human_file";
List <human_fileModel> page = hum.FenYe(fen);
Dictionary <string, object> di = new Dictionary <string, object>();
di["dt"] = page;
di["pages"] = fen.Pages;
di["rows"] = fen.Rows;
di["PageSize"] = fen.PageSize;
return(Content(JsonConvert.SerializeObject(di)));
}
public List <usersModel> FenYe(FenYeModel fen)
{
return(iusersDAO.FenYe(fen));
}
public List <major_changeModel> FenYe(FenYeModel fen)
{
List <major_changeModel> list = new List <major_changeModel>();
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 = hr.major_Changes.FromSqlRaw($@"exec dbo.FenYeWhere @pageSize,@keyName,@tableName,@where,@currentPage,@rows out,@pages out", ps).ToList();
foreach (var ad in sql)
{
major_changeModel h = new major_changeModel()
{
mch_id = ad.mch_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,
major_id = ad.major_id,
major_name = ad.major_name,
major_kind_id = ad.major_kind_id,
major_kind_name = ad.major_kind_name,
new_first_kind_id = ad.new_first_kind_id,
new_first_kind_name = ad.new_first_kind_name,
new_second_kind_id = ad.new_second_kind_id,
new_second_kind_name = ad.new_second_kind_name,
new_third_kind_id = ad.new_third_kind_id,
new_third_kind_name = ad.new_third_kind_name,
new_major_id = ad.new_major_id,
new_major_name = ad.new_major_name,
new_major_kind_id = ad.new_major_kind_id,
new_major_kind_name = ad.new_major_kind_name,
human_id = ad.human_id,
human_name = ad.human_name,
salary_standard_id = ad.salary_standard_id,
salary_standard_name = ad.salary_standard_name,
salary_sum = ad.new_salary_sum,
new_salary_standard_id = ad.new_salary_standard_id,
new_salary_standard_name = ad.new_salary_standard_name,
new_salary_sum = ad.new_salary_sum,
change_reason = ad.change_reason,
check_reason = ad.check_reason,
check_status = ad.check_status,
register = ad.register,
checker = ad.checker,
regist_time = ad.regist_time,
check_time = ad.check_time
};
list.Add(h);
}
fen.Pages = (int)ps[6].Value;
fen.Rows = (int)ps[5].Value;
return(list);
}
public List <human_fileModel> FenYe(FenYeModel fen)
{
return(hm.FenYe(fen));
}
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 List <roleModel> FenYe(FenYeModel fen)
{
return(rd.FenYe(fen));
}
public List <major_changeModel> FenYe(FenYeModel fen)
{
return(mc.FenYe(fen));
}
public List <usersModel> FenYe(FenYeModel fen)
{
List <usersModel> list = new List <usersModel>();
//int PageSize = fen.PageSize;
//string KeyName = fen.KeyName;
//string Table = fen.TableName;
//string Where = fen.Where;
//int CurrentPage = fen.CurrentPage;
//SqlParameter[] ps = {
// //new SqlParameter(){ParameterName="@pageSize",Value=PageSize},
// // new SqlParameter(){ParameterName="@keyName",Value=KeyName},
// // new SqlParameter(){ParameterName="@tableName",Value=KeyName},
// // new SqlParameter(){ParameterName="@where",Value=Where},
// // new SqlParameter(){ParameterName="@currentPage",Value=CurrentPage},
// new SqlParameter(){ParameterName="@rows",Direction=ParameterDirection.Output,SqlDbType=SqlDbType.Int},
// new SqlParameter(){ParameterName="@pages",Direction=ParameterDirection.Output,SqlDbType=SqlDbType.Int},
// };
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 = tesc.u.FromSqlRaw($@"exec dbo.FenYeWhere @pageSize,@keyName,@tableName,@where,@currentPage,@rows out,@pages out", ps).ToList();
foreach (var ad in sql)
{
usersModel h = new usersModel()
{
User_id = ad.user_id,
User_true_name = ad.user_true_name,
user_identity = ad.user_identity,
User_name = ad.user_name,
User_password = ad.user_password
};
list.Add(h);
}
fen.Pages = (int)ps[6].Value;
fen.Rows = (int)ps[5].Value;
return(list);
}
