public List <salary_grant_detailsModel> select()
{
List <salary_grant_details> list = SelectAll();
List <salary_grant_detailsModel> li = new List <salary_grant_detailsModel>();
foreach (salary_grant_details item in list)
{
salary_grant_detailsModel ko = new salary_grant_detailsModel();
ko.id = item.id;
ko.salary_grant_id = item.salary_grant_id;
ko.human_id = item.human_id;
ko.human_name = item.human_name;
ko.bouns_sum = item.bouns_sum;
ko.sale_sum = item.sale_sum;
ko.deduct_sum = item.deduct_sum;
ko.salary_standard_sum = item.salary_standard_sum;
ko.salary_paid_sum = item.salary_paid_sum; li.Add(ko);
}
return(li);
}
//复核提交
public ActionResult Tio()
{
//查询发放详细表
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.checker = Request["checker"];
sala.check_time = DateTime.Parse(Request["salaryGrant.registTime"].ToString());
sala.check_status = 1;
int pd = sa.updateChenk(sala);
return(JavaScript("window.location = '/salary_grant/check_success'"));
}
public int update1(salary_grant_detailsModel st)
{
return(st1.update(st));
}
public int Add1(salary_grant_detailsModel 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_grant_detailsModel bjm)
{
return(MyProperty.BJEdit(bjm));
}
public int BJCreate(salary_grant_detailsModel bjm)
{
return(MyProperty.BJCreate(bjm));
}
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 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());
}
