public ActionResult check_success(salary_grant sg, FormCollection fc)
{
for (int i = 0; i < sg.human_amount; i++)
{
string s = fc["grantDetails[" + i + "].human_id"];
string human_name = fc["grantDetails[" + i + "].human_name"];
decimal bouns_sum = decimal.Parse(fc["grantDetails[" + i + "].bounsSum"]);
decimal deduct_sum = decimal.Parse(fc["grantDetails[" + i + "].deductSum"]);
decimal sale_sum = decimal.Parse(fc["grantDetails[" + i + "].saleSum"]);
decimal salary_paid_sum = decimal.Parse(fc["grantDetails[" + i + "].salaryPaidSum"]);
decimal salary_standard_sum = decimal.Parse(fc["grantDetails[" + i + "].salary_standard_sum"]);
salary_grant_details sgd = new salary_grant_details()
{
grd_id = short.Parse(fc["grantDetails[" + i + "].grd_id"]),
human_id = s,
human_name = human_name,
bouns_sum = bouns_sum,
deduct_sum = deduct_sum,
sale_sum = sale_sum,
salary_paid_sum = salary_paid_sum,
salary_grant_id = sg.salary_grant_id,
salary_standard_sum = salary_standard_sum
};
sgds.Upd(sgd);
}
sgs.Upd(sg);
return(View());
}
public List <salary_grant> SelectGrant3(int id)
{
List <salary_grant> list = new List <salary_grant>();
var persons = hrdb.sg.Where(p => p.salary_grant_id == id).AsNoTracking();
foreach (var item in persons)
{
salary_grant bj = new salary_grant()
{
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(bj);
}
return(list);
}
public ActionResult register_commit(salary_grant sg, salary_grant_details [] sgd)
{
int num = 0;
int j = 0;
using (TransactionScope ts = new TransactionScope()) {
foreach (salary_grant_details item in sgd)
{
if (item.salary_paid_sum > 0)
{
j++;
item.salary_grant_id = sg.salary_grant_id;
num += sgdbll.salary_grant_detailsInsert(item);
}
}
if (sgbll.salary_grantInsert(sg) > 0 && num == j)
{
ts.Complete();
return(RedirectToAction("register_success", "salaryGrant"));
}
else
{
return(View());
}
};
}
public ActionResult check_success(salary_grant sg, salary_grant_details[] grantDetails)
{
int num = 0;
int j = 0;
salary_grant sg2 = grant.FindAll().Where(e => e.sgr_id == sg.sgr_id).FirstOrDefault();
using (TransactionScope ts = new TransactionScope())
{
foreach (salary_grant_details item in grantDetails)
{
item.bouns_sum = item.bouns_sum.HasValue == true ? item.bouns_sum : (decimal)0.0;
item.sale_sum = item.sale_sum.HasValue == true ? item.sale_sum : (decimal)0.0;
item.deduct_sum = item.deduct_sum.HasValue == true ? item.deduct_sum : (decimal)0.0;
j++;
num += details2.Change(item);
}
sg2.check_status = 1;
sg2.salary_paid_sum = sg.salary_paid_sum;
sg2.checker = sg.checker;
sg2.check_time = sg.check_time;
if (grant.Change(sg2) > 0 && num == j)
{
ts.Complete();
return(View());
}
return(Content("<script>alert('真抱歉~复核失败了噢');</script>"));
}
}
public ActionResult query(string id)
{
salary_grant sg = sgs.SelectOne(id);
List <salary_grant_details> lsgd = sgds.SelectBy(id);
return(View(Tuple.Create(sg, lsgd)));
}
public ActionResult query(int id)
{
salary_grant sg = grant.SelectWhere((short)id).FirstOrDefault();
ViewBag.item = item.FindAll().OrderBy(e => e.item_id).ToList();
ViewBag.sg = sg;
ViewBag.details = details.FindAll();
return(View(details2.SelectWhere(sg.salary_grant_id)));
}
// GET: salaryGrant
public ActionResult check(string id)
{
salary_grant sg = sgs.SelectOne(id);
List <salary_standard_details> lssd = new List <salary_standard_details>();
lssd = ssds.Select();
List <salary_grant_details> lsgd = sgds.SelectBy(id);
return(View(Tuple.Create(sg, lssd, lsgd)));
}
public ActionResult check(int id)
{
salary_grant sg = grant.SelectWhere((short)id).FirstOrDefault();
ViewBag.item = item.FindAll().OrderBy(e => e.item_id).ToList();
ViewBag.sg = sg;
users u = Session["user"] as users;
ViewBag.user = u.u_name;
ViewBag.details = details.FindAll();
return(View(details2.SelectWhere(sg.salary_grant_id)));
}
public ActionResult check(salary_grant sg, salary_grant_details [] sgd)
{
int num = 0;
int j = 0;
salary_grant sg2 = new salary_grant()
{
sgr_id = sg.sgr_id,
salary_grant_id = sg.salary_grant_id,
salary_standard_id = sg.salary_standard_id,
first_kind_id = sg.first_kind_id,
first_kind_name = sg.first_kind_name,
second_kind_id = sg.second_kind_id,
second_kind_name = sg.second_kind_name,
third_kind_id = sg.third_kind_id,
third_kind_name = sg.third_kind_name,
human_amount = sg.human_amount,
salary_standard_sum = sg.salary_standard_sum,
salary_paid_sum = sg.salary_paid_sum,
register = sg.register,
regist_time = sg.regist_time,
checker = sg.register,
check_time = sg.check_time,
check_status = 1,
};
using (TransactionScope ts = new TransactionScope()) {
foreach (salary_grant_details item in sgd)
{
j++;
num += sgdbll.salary_grant_detailsUpdate(item, item.grd_id);
}
if (sgbll.salary_grantUpdate(sg2, sg2.sgr_id) > 0 && num == j)
{
ts.Complete();
return(RedirectToAction("check_success", "salaryGrant"));
}
else
{
return(View());
}
};
}
public ActionResult register_success(salary_grant sg, salary_grant_details[] grantDetails)
{
int num = 0;
int j = 0;
using (TransactionScope ts = new TransactionScope())
{
foreach (salary_grant_details item in grantDetails)
{
item.bouns_sum = item.bouns_sum.HasValue == true ? item.bouns_sum : (decimal)0.0;
item.sale_sum = item.sale_sum.HasValue == true ? item.sale_sum : (decimal)0.0;
item.deduct_sum = item.deduct_sum.HasValue == true ? item.deduct_sum : (decimal)0.0;
j++;
num += details2.Add(item);
}
sg.check_status = 0;
if (grant.Add(sg) > 0 && num == j)
{
ts.Complete();
return(View());
}
return(Content("<script>alert('真抱歉~提交失败了噢');</script>"));
}
}
public int Del(salary_grant t)
{
return(dao.Del(t));
}
public int Change(salary_grant t)
{
return(dao.Change(t));
}
//薪酬发放复核（修改）
public int salary_grantUpdate(salary_grant sg, object keyValue)
{
return(dao.salary_grantUpdate(sg, keyValue));
}
public bool Upd(salary_grant us)
{
return(ist.Upd(us));
}
public bool Add(salary_grant us)
{
return(ist.Add(us));
}
public bool Del(salary_grant us)
{
return(ist.Del(us));
}
public int Add(salary_grant t)
{
return(dao.Add(t));
}
//薪酬发放新增
public int salary_grantInsert(salary_grant sg)
{
return(dao.salary_grantInsert(sg));
}
