public List <salary_grantModel> GetPageList(int pageIndex, int pageSize, ref int totalCount)
{
string strSql = "select * from salary_grant";
string orderfied = "order by sgr_id desc";
var data = SelectPageList <salary_grant>(strSql, pageIndex, pageSize, orderfied, ref totalCount);
List <salary_grant> list = data.ToList();
List <salary_grantModel> list2 = new List <salary_grantModel>();
//需要把ED->DTO
foreach (salary_grant item in list)
{
salary_grantModel bjm = new salary_grantModel()
{
salary_grant_id = item.salary_grant_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,
human_amount = item.human_amount,
salary_standard_sum = item.salary_standard_sum,
salary_paid_sum = item.salary_paid_sum,
register = item.register,
regist_time = item.regist_time,
checker = item.checker,
check_time = item.check_time,
check_status = item.check_status
};
list2.Add(bjm);
}
return(list2);
}
public List <salary_grantModel> GetPageList2(int pageIndex, int pageSize, ref int totalCount, string gid, string name, string time, string time2)
{
string strSql = $"select * from [dbo].[salary_grant] where [salary_grant_id] like '%{gid}%' and([first_kind_name] like '%{name}%' or[second_kind_name] like '%{name}%' or[third_kind_name] like '%{name}%')and[regist_time] > '{time}' and[regist_time] < '{time2}' ";
string orderfied = "order by sgr_id desc";
var data = SelectPageList <salary_grant>(strSql, pageIndex, pageSize, orderfied, ref totalCount);
List <salary_grant> list = data.ToList();
List <salary_grantModel> list2 = new List <salary_grantModel>();
//需要把ED->DTO
foreach (salary_grant item in list)
{
salary_grantModel bjm = new salary_grantModel()
{
salary_grant_id = item.salary_grant_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,
human_amount = item.human_amount,
salary_standard_sum = item.salary_standard_sum,
salary_paid_sum = item.salary_paid_sum,
register = item.register,
regist_time = item.regist_time,
checker = item.checker,
check_time = item.check_time,
check_status = item.check_status
};
list2.Add(bjm);
}
return(list2);
}
public int BJEdit(salary_grantModel bjm)
{
salary_grant bj = new salary_grant()
{
sgr_id = bjm.sgr_id,
salary_grant_id = bjm.salary_grant_id,
salary_standard_id = bjm.salary_standard_id,
first_kind_id = bjm.first_kind_id,
first_kind_name = bjm.first_kind_name,
second_kind_id = bjm.second_kind_id,
second_kind_name = bjm.second_kind_name,
third_kind_id = bjm.third_kind_id,
third_kind_name = bjm.third_kind_name,
human_amount = bjm.human_amount,
salary_standard_sum = bjm.salary_standard_sum,
salary_paid_sum = bjm.salary_paid_sum,
register = bjm.register,
regist_time = bjm.regist_time,
checker = bjm.checker,
check_time = bjm.check_time,
check_status = bjm.check_status
};
return(Edit(bj));
}
public List <salary_grantModel> SelectById2(int id)
{
List <salary_grant> bj = SelectGrant3(id);
List <salary_grantModel> list = new List <salary_grantModel>();
//把EO->DTO
foreach (salary_grant item in bj)
{
salary_grantModel bjm = new salary_grantModel()
{
salary_grant_id = item.salary_grant_id,
sgr_id = item.sgr_id,
salary_standard_id = item.salary_standard_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,
human_amount = item.human_amount,
salary_standard_sum = item.salary_standard_sum,
salary_paid_sum = item.salary_paid_sum,
register = item.register,
regist_time = item.regist_time,
checker = item.checker,
check_time = item.check_time,
check_status = item.check_status
};
list.Add(bjm);
}
return(list);
}
public async Task <List <salary_grantModel> > Select()
{
List <salary_grant> list = await Task.Run(() => { return(tescDbContext.sg.ToList()); });
List <salary_grantModel> listm = new List <salary_grantModel>();
foreach (salary_grant item in list)
{
salary_grantModel sgm = new salary_grantModel()
{
salary_grant_id = item.salary_grant_id,
salary_paid_sum = item.salary_paid_sum,
salary_standard_id = item.salary_standard_id,
salary_standard_sum = item.salary_standard_sum,
second_kind_id = item.second_kind_id,
second_kind_name = item.second_kind_name,
sgr_id = item.sgr_id,
checker = item.checker,
check_status = item.check_status,
check_time = item.check_time,
first_kind_id = item.first_kind_id,
first_kind_name = item.first_kind_name,
human_amount = item.human_amount,
third_kind_id = item.third_kind_id,
third_kind_name = item.third_kind_name,
register = item.register,
regist_time = item.regist_time
};
listm.Add(sgm);
}
return(listm);
}
public List <salary_grantModel> select()
{
List <salary_grant> list = SelectAll();
List <salary_grantModel> li = new List <salary_grantModel>();
foreach (salary_grant item in list)
{
salary_grantModel ko = new salary_grantModel();
ko.sgr_id = item.id;
ko.salary_grant_id = item.salary_grant_id;
ko.salary_standard_id = item.salary_standard_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_amount = item.human_amount;
ko.salary_standard_sum = item.salary_standard_sum;
ko.salary_paid_sum = item.salary_paid_sum;
ko.register = item.register;
ko.regist_time = item.regist_time;
ko.checker = item.checker;
ko.check_time = item.check_time;
ko.check_status = item.check_status; li.Add(ko);
}
return(li);
}
public int updateFan(salary_grantModel item)
{
salary_grant ko = db.salary_grant.Where(e => e.id.Equals(item.sgr_id)).FirstOrDefault();
ko.id = item.sgr_id;
ko.human_amount = item.human_amount;
ko.salary_standard_sum = item.salary_standard_sum;
ko.salary_paid_sum = item.salary_paid_sum;
return(db.SaveChanges());
}
public int update(salary_grantModel item)
{
salary_grant ko = db.salary_grant.Where(e => e.id.Equals(item.sgr_id)).FirstOrDefault();
ko.id = item.sgr_id;
ko.human_amount = item.human_amount;
ko.salary_standard_sum = item.salary_standard_sum;
ko.salary_paid_sum = item.salary_paid_sum;
ko.register = item.register;
ko.regist_time = item.regist_time;
ko.check_status = item.check_status;
return(db.SaveChanges());
}
public ActionResult Shuju11()
{
string ha = Session["register_commitID1"].ToString();
List <salary_grantModel> item = sa.selectupdateda(ha);
salary_grantModel ko = new salary_grantModel();
ko.salary_standard_id = item[0].salary_standard_id;
ko.third_kind_name = "III级结构";
ko.human_amount = item[0].human_amount;
ko.salary_standard_sum = item[0].salary_standard_sum;
ko.salary_paid_sum = item[0].salary_paid_sum;
string aa = JsonConvert.SerializeObject(ko);
return(Content(aa));
}
public int Add(salary_grantModel item)
{
string sql = "dj";
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();
salary_grant ko = new salary_grant();
ko.salary_grant_id = r;
string sql1 = "FF";
SqlParameter ji1 = new SqlParameter()
{
ParameterName = "@danhao", Size = 14, SqlDbType = SqlDbType.VarChar, Direction = ParameterDirection.Output
};
DataTable dt1 = DBHaipu.SelectProc1(sql1, ji1, "");
//获取值
string r1 = ji1.Value.ToString();
ko.salary_standard_id = r1;
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_amount = item.human_amount;
ko.salary_standard_sum = item.salary_standard_sum;
ko.salary_paid_sum = item.salary_paid_sum;
ko.regist_time = DateTime.Now;
ko.check_time = DateTime.Now;
ko.check_status = item.check_status;
return(Add(ko));
}
public ActionResult TiJiao()
{
//查询发放详细表
string ha = Session["register_commitID"].ToString();
//获取其中详细信息
List <salary_grant_detailsModel> li = de.selectsalary_grant_id(ha);
List <salary_grantModel> item = sa.selectupdateda(ha);
salary_grantModel sala = new salary_grantModel();
sala.sgr_id = item[0].sgr_id;
int zrs = 0;
//基本总额
decimal jbze = 0m;
decimal sfze = 0m;
for (int i = 0; i < li.Count; i++)
{
zrs = zrs + 1;
salary_grant_detailsModel mode = new salary_grant_detailsModel();
mode.id = li[i].id;
jbze = jbze + li[i].salary_standard_sum;
mode.bouns_sum = decimal.Parse(Request["grantDetails[" + i + "].bounsSum"].ToString());
mode.sale_sum = decimal.Parse(Request["grantDetails[" + i + "].saleSum"].ToString());
mode.deduct_sum = decimal.Parse(Request["grantDetails[" + i + "].deductSum"].ToString());
mode.salary_paid_sum = decimal.Parse(Request["grantDetails[" + i + "].salaryPaidSum"].ToString());
sfze = sfze + decimal.Parse(Request["grantDetails[" + i + "].salaryPaidSum"].ToString());
int p = de.update1(mode);
}
sala.human_amount = zrs;
sala.salary_standard_sum = jbze;
sala.salary_paid_sum = sfze;
sala.register = Request["register"];
sala.regist_time = DateTime.Parse(Request["salaryGrant.registTime"].ToString());
sala.check_status = 0;
int pd = sa.update1(sala);
if (pd > 0)
{
return(JavaScript("alert('修改成功');window.location = '/salary_grant/register_locate'"));
}
else
{
return(JavaScript("alert('修改失败');"));
}
}
public int Add(salary_grantModel item)
{
salary_grant ko = new salary_grant();
ko.salary_grant_id = item.salary_grant_id;
ko.salary_standard_id = item.salary_standard_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.human_amount = item.human_amount;
ko.salary_standard_sum = item.salary_standard_sum;
ko.salary_paid_sum = item.salary_paid_sum;
ko.register = item.register;
ko.regist_time = DateTime.Now;
ko.check_time = DateTime.Now;
ko.check_status = item.check_status;
return(Add(ko));
}
public salary_grantCan fenye2(query_locateCan va, int dqy, int rl)
{
string hu = va.year + "-" + va.month + "-1";
string hu2 = va.year + "-" + va.month + "-30";
DateTime t1 = DateTime.Parse(hu);
DateTime t2 = DateTime.Parse(hu2);
salary_grantCan cs = new salary_grantCan();
List <salary_grantModel> li = new List <salary_grantModel>();
int rows = 0;
var data = db.Set <salary_grant>().OrderBy(e => e.id).Where(e => e.salary_standard_id.Contains(va.salaryGrant) && e.check_time >= t1 && e.check_time <= t2).AsNoTracking();
rows = data.Count();//获取总行数
List <salary_grant> list = FenYe <int>(e => e.id, e => e.salary_standard_id.Contains(va.salaryGrant) && e.check_time >= t1 && e.check_time <= t2, ref rows, dqy, rl);
foreach (salary_grant item in list)
{
salary_grantModel ko = new salary_grantModel();
ko.sgr_id = item.id;
ko.salary_grant_id = item.salary_grant_id;
ko.salary_standard_id = item.salary_standard_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_amount = item.human_amount;
ko.salary_standard_sum = item.salary_standard_sum;
ko.salary_paid_sum = item.salary_paid_sum;
ko.register = item.register;
ko.regist_time = item.regist_time;
ko.checker = item.checker;
ko.check_time = item.check_time;
ko.check_status = item.check_status;
li.Add(ko);
}
cs.li = li;
cs.MyProperty = rows;
cs.zys = (rows % rl == 0 ? rows / rl : rows / rl + 1);
return(cs);
}
public salary_grantCan fenye(int dqy, int rl)
{
salary_grantCan cs = new salary_grantCan();
List <salary_grantModel> li = new List <salary_grantModel>();
int rows = 0;
var data = db.Set <salary_grant>().OrderBy(e => e.id).Where(e => e.check_status == 0).AsNoTracking();
rows = data.Count();//获取总行数
List <salary_grant> list = FenYe <int>(e => e.id, e => e.check_status == 0, ref rows, dqy, rl);
foreach (salary_grant item in list)
{
salary_grantModel ko = new salary_grantModel();
ko.sgr_id = item.id;
ko.salary_grant_id = item.salary_grant_id;
ko.salary_standard_id = item.salary_standard_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_amount = item.human_amount;
ko.salary_standard_sum = item.salary_standard_sum;
ko.salary_paid_sum = item.salary_paid_sum;
ko.register = item.register;
ko.regist_time = item.regist_time;
ko.checker = item.checker;
ko.check_time = item.check_time;
ko.check_status = item.check_status;
li.Add(ko);
}
cs.li = li;
cs.MyProperty = rows;
cs.zys = (rows % rl == 0 ? rows / rl : rows / rl + 1);
return(cs);
}
public ActionResult third_kind_register(FormCollection collection)
{
if (ModelState.IsValid)
{
string id = collection["first_kind_id"];
if (Request["first_kind_id"] == "")
{
return(JavaScript("alert('请选择I级机构名称');"));
}
else
{
List <config_file_first_kindModel> list = cfb.select1();
string mc = "";
foreach (config_file_first_kindModel item in list)
{
if (id.Equals(item.first_kind_id))
{
mc = item.first_kind_name;
}
}
string id1 = collection["cftk.secondKindId"];
if (id1 == "0")
{
return(JavaScript("alert('请选择II级机构名称');"));
}
else
{
List <config_file_second_kindModel> list2 = csb.select1();
string mc1 = "";
foreach (config_file_second_kindModel item in list2)
{
if (id1.Equals(item.second_kind_id))
{
mc1 = item.second_kind_name;
}
}
config_file_third_kindModel ctm = new config_file_third_kindModel()
{
first_kind_id = id,
first_kind_name = mc,
second_kind_id = id1,
second_kind_name = mc1,
third_kind_id = Request["third_kind_id"],
third_kind_name = Request["third_kind_name"],
third_kind_sale_id = Request["third_kind_sale_id"],
third_kind_is_retail = Request["third_kind_is_retail"]
};
int i1 = ctb.Add1(ctm);
if (i1 > 0)
{
//新增发放表数据
salary_grantIBLL sa = iocComm.salary_grantBLL();
salary_grantModel grant = new salary_grantModel();
grant.first_kind_id = id;
grant.first_kind_name = mc;
grant.second_kind_id = id1;
grant.second_kind_name = mc1;
grant.third_kind_id = Request["third_kind_id"];
grant.third_kind_name = Request["third_kind_name"];
grant.human_amount = 0;
grant.salary_standard_sum = 0;
grant.salary_paid_sum = 0;
grant.check_status = 0;
int iii = sa.Add1(grant);
return(JavaScript("window.location='/config_file_third_kind/third_kind_register_success'"));
}
else
{
return(View());
}
}
}
}
else
{
return(View());
}
}
public ActionResult TiJiao()
{
string ha = Session["register_commitID"].ToString();
List <salary_grantANDsalary_grant_details> la = Session["salary_grantANDsalary_grant_details"] as List <salary_grantANDsalary_grant_details>;
List <salary_grant_detailsModel> mm = new List <salary_grant_detailsModel>();
salary_grantModel lala = new salary_grantModel();
foreach (salary_grantANDsalary_grant_details h in la)
{
if (h.id == int.Parse(ha))
{
mm = h.salary_grant_details;
lala = h.salary_grant;
}
}
//获取编号
List <string> sr = sa.bianHao();
//查询发放详细表
int zrs = 0;
//基本总额
decimal jbze = 0m;
decimal sfze = 0m;
for (int i = 0; i < mm.Count; i++)
{
zrs = zrs + 1;
salary_grant_detailsModel mode = new salary_grant_detailsModel();
//mode.id = mm[i].id;
mode.human_id = mm[i].human_id;
mode.human_name = mm[i].human_name;
mode.salary_grant_id = sr[0];
jbze = jbze + mm[i].salary_standard_sum;
mode.salary_standard_sum = mm[i].salary_standard_sum;
mode.bouns_sum = decimal.Parse(Request["grantDetails[" + i + "].bounsSum"].ToString());
mode.sale_sum = decimal.Parse(Request["grantDetails[" + i + "].saleSum"].ToString());
mode.deduct_sum = decimal.Parse(Request["grantDetails[" + i + "].deductSum"].ToString());
mode.salary_paid_sum = decimal.Parse(Request["grantDetails[" + i + "].salaryPaidSum"].ToString());
sfze = sfze + decimal.Parse(Request["grantDetails[" + i + "].salaryPaidSum"].ToString());
int p = de.Add1(mode);
//if (p > 0) {
// //删除人力资源 列表
// //根据human_id 查id;
// List<human_fileModel> lall= hu.selectupdate(mm[i].human_id);
// int sc=hu.delete( lall[0].id);
//}
}
lala.salary_grant_id = sr[0];
lala.salary_standard_id = sr[1];
lala.salary_standard_sum = jbze;
lala.salary_paid_sum = sfze;
lala.register = Request["register"];
lala.regist_time = DateTime.Parse(Request["salaryGrant.registTime"].ToString());
lala.check_status = 0;
int pd = sa.Add1(lala);
if (pd > 0)
{
return(JavaScript("alert('提交成功');window.location = '/salary_grant/register_locate'"));
}
else
{
return(JavaScript("alert('提交失败');"));
}
}
public int Add1(salary_grantModel st)
{
return(st1.Add(st));
}
public ActionResult QueryList(FormCollection collection)
{
string cxid = collection["xcid"];
string jg = collection["jg"];
string countr = collection["countr"];
string sum = collection["sum"];
string sfsum = collection["sfsum"];
string djr = collection["djr"];
string bid = collection["bid"];
string rows = collection["row"];
string djtime = collection["djtime"];
List <HumenModel> list2 = hu.SelectById4(Convert.ToInt32(bid));
DateTime dt = System.DateTime.Now;
string strTime = dt.ToString("yyyyMMdd");
Random rn = new Random();
int num = rn.Next(1, 100000);
int bum = rn.Next(6, 10000);
salary_grantModel gan = new salary_grantModel()
{
salary_grant_id = Convert.ToInt32(strTime) + num + bum,
salary_standard_id = Convert.ToInt32(cxid),
first_kind_id = list2[0].first_kind_id,
first_kind_name = list2[0].first_kind_name,
second_kind_id = list2[0].second_kind_id,
second_kind_name = list2[0].second_kind_name,
third_kind_id = list2[0].third_kind_id,
third_kind_name = list2[0].third_kind_name,
human_amount = Convert.ToInt32(countr),
salary_standard_sum = Convert.ToDouble(sum),
salary_paid_sum = Convert.ToDouble(sfsum),
register = djr,
regist_time = Convert.ToDateTime(djtime),
check_status = 1
};
int id = 0;
if (jg == "一级机构")
{
id = 1;
}
if (jg == "二级机构")
{
id = 2;
}
if (jg == "三级机构")
{
id = 3;
}
if (MyProperty5.BJCreate(gan) > 0)
{
for (int i = 1; i <= Convert.ToInt32(rows); i++)
{
string namep = "name" + i;
string name = collection[namep];
string didp = "did" + i;
string did = collection[didp];
string jlp = "jl" + i;
string jl = collection[jlp];
string jxp = "jx" + i;
string jx = collection[jxp];
string ykp = "yk" + i;
string yk = collection[ykp];
string salaryPaidSump = "salaryPaidSum" + i;
string salaryPaidSum = collection[salaryPaidSump];
string salaryPaidSum2p = "salaryPaidSum2" + i;
string salaryPaidSum2 = collection[salaryPaidSum2p];
if (jl == "")
{
jl = "0.00";
}
if (jx == "")
{
jx = "0.00";
}
if (yk == "")
{
yk = "0.00";
}
salary_grant_detailsModel gra = new salary_grant_detailsModel()
{
salary_grant_id = gan.salary_grant_id,
salary_standard_id = gan.salary_standard_id,
human_name = name,
human_id = Convert.ToInt32(did),
bouns_sum = Convert.ToDouble(jl),
sale_sum = Convert.ToDouble(jx),
deduct_sum = Convert.ToDouble(yk),
salary_standard_sum = Convert.ToDouble(salaryPaidSum),
salary_paid_sum = Convert.ToDouble(salaryPaidSum2),
};
MyProperty6.BJCreate(gra);
List <HumenModel> huid = hu.SelectHid(gra.human_id);
huid[0].statu = 1;
hu.BJEdit(huid[0]);
}
return(Content("<script>alert('登记成功');window.location.href='/SalaryGrant/Index/" + id + "'</script>"));
}
else
{
return(Content("<script>alert('登记失败');window.location.href='/SalaryGrant/Index/" + id + "'</script>"));
}
}
public int BJEdit(salary_grantModel bjm)
{
return(MyProperty.BJEdit(bjm));
}
public int BJCreate(salary_grantModel bjm)
{
return(MyProperty.BJCreate(bjm));
}
public int update1(salary_grantModel st)
{
return(st1.update(st));
}
//发放方式
public ActionResult dj()
{
string nn = Request["submitType"];
Session["fANSE"] = nn;
//一级发放方式
if (nn.Equals("1"))
{
//一级发放 查询所有人力资源列表
List <human_fileModel> mo = hu.select1();
//对应编号
//拿取所有一级机构不同
List <string> str = new List <string>();
str.Add(mo[0].first_kind_name);
foreach (human_fileModel item in mo)
{
if (item.first_kind_name.Equals(str[0]))
{
}
else
{
str.Add(item.first_kind_name);
}
}
//参数类id 用于判断类
int iddid = 0;
//参数类集合
List <salary_grantANDsalary_grant_details> ca = new List <salary_grantANDsalary_grant_details>();
foreach (string item1 in str)
{
//查询所有一级结构相同的人
salary_grantANDsalary_grant_details ta = new salary_grantANDsalary_grant_details();
//人总数
int zrs = 0;
//标准薪酬总金额
decimal ko = 0m;
string bian = "";
List <salary_grant_detailsModel> yyy = new List <salary_grant_detailsModel>();
foreach (human_fileModel item in mo)
{
if (item.first_kind_name.Equals(item1))
{
//赋值
zrs = zrs + 1;
ko = ko + item.salary_sum;
bian = item.first_kind_id;
//做详情表做数据添加
salary_grant_detailsModel detal = new salary_grant_detailsModel();
detal.human_id = item.human_id;
detal.human_name = item.human_name;
detal.salary_standard_sum = item.salary_sum;
detal.salary_paid_sum = item.salary_sum;
yyy.Add(detal);
}
}
//创建对象
salary_grantModel salary_mo = new salary_grantModel();
salary_mo.first_kind_id = bian;
salary_mo.first_kind_name = item1;
salary_mo.human_amount = zrs;
salary_mo.salary_standard_sum = ko;
salary_mo.salary_paid_sum = ko;
iddid = iddid + 1;
ta.id = iddid;
ta.salary_grant = salary_mo;
ta.salary_grant_details = yyy;
ca.Add(ta);
}
Session["salary_grantANDsalary_grant_details"] = ca;
//查询所有人力资源一级机构不同的列表 获取一级机构名称
//如果一级机构相同 放到同一个发放列表中 通过sesetion 保存
return(RedirectToAction("register_list"));
}
//2级发放方式
else if (nn.Equals("2"))
{
//一级发放 查询所有人力资源列表
List <human_fileModel> mo = hu.select1();
//对应编号
//拿取所有2级机构不同
List <string> str = new List <string>();
str.Add(mo[0].second_kind_name);
foreach (human_fileModel item in mo)
{
if (item.second_kind_name.Equals(str[0]))
{
}
else
{
str.Add(item.second_kind_name);
}
}
//参数类id 用于判断类
int iddid = 0;
//参数类集合
List <salary_grantANDsalary_grant_details> ca = new List <salary_grantANDsalary_grant_details>();
foreach (string item1 in str)
{
//查询所有2级结构相同的人
salary_grantANDsalary_grant_details ta = new salary_grantANDsalary_grant_details();
//人总数
int zrs = 0;
//标准薪酬总金额
decimal ko = 0m;
string bian = "";
string yi = "";
string yiID = "";
List <salary_grant_detailsModel> yyy = new List <salary_grant_detailsModel>();
foreach (human_fileModel item in mo)
{
if (item.second_kind_name.Equals(item1))
{
//赋值
zrs = zrs + 1;
ko = ko + item.salary_sum;
yi = item.first_kind_name;
yiID = item.first_kind_id;
bian = item.first_kind_id;
//做详情表做数据添加
salary_grant_detailsModel detal = new salary_grant_detailsModel();
detal.human_id = item.human_id;
detal.human_name = item.human_name;
detal.salary_standard_sum = item.salary_sum;
detal.salary_paid_sum = item.salary_sum;
yyy.Add(detal);
}
}
//创建对象
salary_grantModel salary_mo = new salary_grantModel();
salary_mo.first_kind_id = yi;
salary_mo.first_kind_name = yiID;
salary_mo.second_kind_id = bian;
salary_mo.second_kind_name = item1;
salary_mo.human_amount = zrs;
salary_mo.salary_standard_sum = ko;
salary_mo.salary_paid_sum = ko;
iddid = iddid + 1;
ta.id = iddid;
ta.salary_grant = salary_mo;
ta.salary_grant_details = yyy;
ca.Add(ta);
}
Session["salary_grantANDsalary_grant_details"] = ca;
return(RedirectToAction("register_list2"));
}
//3级发放方式
else
{
}
return(View());
}
public int updateFan(salary_grantModel item)
{
return(st1.updateFan(item));
}
