//public List<SalaryGrantModel> SalaryGrantSelectEJ()
//{
// string sql = "select * from dbo.SalaryGrant where Secondkindname!='' and Checkstatus=1";
// DataTable dt = DBHelper.select(sql);
// List<SalaryGrantModel> list2 = new List<SalaryGrantModel>();
// foreach (DataRow item in dt.Rows)
// {
// SalaryGrantModel sm = new SalaryGrantModel()
// {
// Id = (int)item["Id"],
// Salarygrantid = item["Salarygrantid"].ToString(),
// Salarystandardid = item["Salarystandardid"].ToString(),
// Firstkindid = item["Firstkindid"].ToString(),
// Firstkindname = item["Firstkindname"].ToString(),
// Secondkindid = item["Secondkindid"].ToString(),
// Secondkindname = item["Secondkindname"].ToString(),
// Thirdkindid = item["Thirdkindid"].ToString(),
// Thirdkindname = item["Thirdkindname"].ToString(),
// Humanamount = (int)item["Humanamount"],
// Salarystandardsum = (decimal)item["Salarystandardsum"],
// Salarypaidsum = (decimal)item["Salarypaidsum"],
// Register = item["Register"].ToString(),
// Registtime = (DateTime)item["Registtime"]
// };
// list2.Add(sm);
// }
// return list2;
//}
public List <SalaryGrantModel> SalaryGrantSelectEJA(string zz)
{
string sql = string.Format("select * from dbo.SalaryGrant where '{0}'!='' and Checkstatus=1", zz);
DataTable dt = DBHelper.select(sql);
List <SalaryGrantModel> list2 = new List <SalaryGrantModel>();
foreach (DataRow item in dt.Rows)
{
SalaryGrantModel sm = new SalaryGrantModel()
{
Id = (int)item["Id"],
Salarygrantid = item["Salarygrantid"].ToString(),
Salarystandardid = item["Salarystandardid"].ToString(),
Firstkindid = item["Firstkindid"].ToString(),
Firstkindname = item["Firstkindname"].ToString(),
Secondkindid = item["Secondkindid"].ToString(),
Secondkindname = item["Secondkindname"].ToString(),
Thirdkindid = item["Thirdkindid"].ToString(),
Thirdkindname = item["Thirdkindname"].ToString(),
Humanamount = (int)item["Humanamount"],
Salarystandardsum = (decimal)item["Salarystandardsum"],
Salarypaidsum = (decimal)item["Salarypaidsum"],
Register = item["Register"].ToString(),
Registtime = (DateTime)item["Registtime"]
};
list2.Add(sm);
}
return(list2);
}
/// <summary>
/// 薪酬发放登记
/// </summary>
/// <param name="id"></param>
/// <param name="sid"></param>
/// <param name="Humanamount"></param>
/// <param name="Salarypaidsum"></param>
/// <param name="Salarystandardsum"></param>
/// <param name="Firstkindid"></param>
/// <param name="Secondkindid"></param>
/// <param name="Thirdkindid"></param>
/// <param name="Thirdkindname"></param>
/// <param name="Firstkindname"></param>
/// <param name="Secondkindname"></param>
/// <returns></returns>
public ActionResult Commit(string id, int sid, int Humanamount, decimal Salarypaidsum, decimal Salarystandardsum, string Firstkindid, string Secondkindid, string Thirdkindid, string Thirdkindname, string Firstkindname, string Secondkindname)
{
SalaryGrantModel sg = new SalaryGrantModel();
sg.Salarygrantid = id;
sg.Firstkindid = Firstkindid;
sg.Firstkindname = Firstkindname;
sg.Secondkindid = Secondkindid;
sg.Secondkindname = Secondkindname;
sg.Thirdkindid = Thirdkindid;
sg.Thirdkindname = Thirdkindname;
sg.Humanamount = Humanamount;
sg.Salarypaidsum = Salarystandardsum;
sg.Salarystandardsum = Salarypaidsum;
int pd = isb.SelectPD(Firstkindid, Secondkindid, Thirdkindid);
if (pd > 0)
{
}
else
{
int i = isb.SalaryGrantAdd(sg);
}
ViewBag.Humanamount = Humanamount;
ViewBag.Firstkindid = Firstkindid;
ViewBag.Secondkindid = Secondkindid;
ViewBag.Thirdkindid = Thirdkindid;
ViewBag.id = id;
ViewBag.sid = sid;
return(View());
}
public List <SalaryGrantModel> SalaryGrantSelect()
{
List <SalaryGrant> list = Select();
List <SalaryGrantModel> list2 = new List <SalaryGrantModel>();
foreach (SalaryGrant item in list)
{
SalaryGrantModel ckm = new SalaryGrantModel()
{
Id = item.Id,
Salarygrantid = item.Salarygrantid,
Salarystandardid = item.Salarystandardid,
Firstkindid = item.Firstkindid,
Firstkindname = item.Firstkindname,
Secondkindid = item.Secondkindid,
Secondkindname = item.Secondkindname,
Thirdkindid = item.Thirdkindid,
Thirdkindname = item.Thirdkindname,
Humanamount = item.Humanamount,
Salarystandardsum = item.Salarystandardsum,
Salarypaidsum = item.Salarypaidsum,
Register = item.Register,
Registtime = item.Registtime,
Checker = item.Checker,
Checktime = item.Checktime,
Checkstatus = item.Checkstatus
};
list2.Add(ckm);
}
return(list2);
}
public int SalaryGrantUpdate2(SalaryGrantModel ck)
{
MyDbContext db = CreateContext();
string sql = string.Format(@"update dbo.SalaryGrant set Salarypaidsum='{0}',Register='{1}',Registtime='{2}',Checker='{3}',
Checktime = '{4}',Checkstatus='{5}' where Id='{6}' ", ck.Salarypaidsum, ck.Register, ck.Registtime, ck.Checker, ck.Checktime, ck.Checkstatus, ck.Id);
int list = db.Database.ExecuteSqlCommand(sql);
return(list);
}
public List <SalaryGrantModel> SalaryGrantFYW(int currentPage, int pageSize, out int rows, string xcid, string gjz, string year, string months)
{
string sql = "select * from dbo.SalaryGrant where 1=1";
if (xcid != null && xcid != "")
{
sql += string.Format(" and Salarygrantid='{0}'", xcid);
}
if (gjz != null && gjz != "")
{
sql += string.Format(" and Register like '%{0}%'", gjz);
}
if (year != null && year != "" && gjz != months && months != "")
{
if (year != "全部")
{
sql += string.Format(" and datepart(YEAR,Registtime)='{0}'", year);
}
if (months != "全部")
{
sql += string.Format(" and datepart(MONTH,Registtime)='{0}'", months);
}
}
var list = CreateContext().SalaryGrant.SqlQuery(sql).OrderBy(e => e.Id).ToList();
rows = list.Count();
var data = list.Skip((currentPage - 1) * pageSize).Take(pageSize).ToList();
List <SalaryGrantModel> list2 = new List <SalaryGrantModel>();
foreach (var p in data)
{
SalaryGrantModel pp = new SalaryGrantModel()
{
Id = p.Id,
Salarygrantid = p.Salarygrantid,
Salarystandardid = p.Salarystandardid,
Firstkindid = p.Firstkindid,
Firstkindname = p.Firstkindname,
Secondkindid = p.Secondkindid,
Secondkindname = p.Secondkindname,
Thirdkindid = p.Thirdkindid,
Thirdkindname = p.Thirdkindname,
Humanamount = p.Humanamount,
Salarystandardsum = p.Salarystandardsum,
Salarypaidsum = p.Salarypaidsum,
Register = p.Register,
Registtime = p.Registtime,
Checker = p.Checker,
Checktime = p.Checktime,
Checkstatus = p.Checkstatus
};
list2.Add(pp);
}
return(list2);
}
/// <summary>
/// 薪酬发放登记点击提交的方法
/// </summary>
/// <returns></returns>
public ActionResult xg()
{
SalaryGrantModel sg = new SalaryGrantModel();
sg.Firstkindid = Request["Fid"];
sg.Secondkindid = Request["Seid"];
sg.Thirdkindid = Request["Thid"];
sg.Register = Request["Register"];
sg.Registtime = Convert.ToDateTime(Request["Registtime"]);
sg.Checker = Request["Checker"];
sg.Checktime = DateTime.Now;
sg.Checkstatus = 2;
int r1 = isb.SalaryGrantUpdate(sg);
string arry = Request["arry"];
List <Dictionary <string, object> > sdm = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(arry);
int r2 = 0;
foreach (var item in sdm)
{
SalaryGrantdetailsModel sm = new SalaryGrantdetailsModel();
sm.Id = int.Parse(item["Id"].ToString());
sm.Salarygrantid = item["SalaryId"].ToString();
sm.Humanid = item["HumanId"].ToString();
sm.Humanname = item["HumanName"].ToString();
object ass = item["Bounssum"];
sm.Bounssum = item["Bounssum"] == null || item["Bounssum"] == ""? sm.Bounssum: Convert.ToDecimal(item["Bounssum"]);
sm.Salesum = item["Salesum"] == null || item["Salesum"] == "" ? sm.Salesum : Convert.ToDecimal(item["Salesum"]);
sm.Deductsum = item["Deductsum"] == null || item["Deductsum"] == "" ? sm.Deductsum : Convert.ToDecimal(item["Deductsum"]);
sm.Salarypaidsum = item["Salarypaidsum"] == null || item["Salarypaidsum"] == "" ? sm.Salarypaidsum : Convert.ToDecimal(item["Salarypaidsum"]);
HumanFileModel hf = new HumanFileModel();
hf.Id = Convert.ToInt32(item["Id"]);
ihb.HumanFileUpdate1(hf);
//判断薪酬发放表是否添加过这条数据
if (isb.SelectPDSID(sm.Salarygrantid, sm.Humanid) > 0)
{
r2++;
}
else
{
if (igb.SalaryGrantdetailsAdd(sm) > 0)
{
r2++;
}
}
}
string flag = "false";
if (r1 > 0 && r2 == sdm.Count)
{
flag = "true";
}
return(Content(flag));
}
//public List<SalaryGrantModel> SalaryGrantSelectSJ()
//{
// string sql = "select * from dbo.SalaryGrant where Thirdkindname!='' and Checkstatus=1";
// DataTable dt = DBHelper.select(sql);
// List<SalaryGrantModel> list2 = new List<SalaryGrantModel>();
// foreach (DataRow item in dt.Rows)
// {
// SalaryGrantModel sm = new SalaryGrantModel()
// {
// Id = (int)item["Id"],
// Salarygrantid = item["Salarygrantid"].ToString(),
// Salarystandardid = item["Salarystandardid"].ToString(),
// Firstkindid = item["Firstkindid"].ToString(),
// Firstkindname = item["Firstkindname"].ToString(),
// Secondkindid = item["Secondkindid"].ToString(),
// Secondkindname = item["Secondkindname"].ToString(),
// Thirdkindid = item["Thirdkindid"].ToString(),
// Thirdkindname = item["Thirdkindname"].ToString(),
// Humanamount = (int)item["Humanamount"],
// Salarystandardsum = (decimal)item["Salarystandardsum"],
// Salarypaidsum = (decimal)item["Salarypaidsum"],
// Register = item["Register"].ToString(),
// Registtime = (DateTime)item["Registtime"]
// };
// list2.Add(sm);
// }
// return list2;
//}
//public List<SalaryGrantModel> SalaryGrantSelectYJ()
//{
// string sql = "select * from dbo.SalaryGrant where Firstkindname!='' and Checkstatus=1";
// DataTable dt = DBHelper.select(sql);
// List<SalaryGrantModel> list2 = new List<SalaryGrantModel>();
// foreach (DataRow item in dt.Rows)
// {
// SalaryGrantModel sm = new SalaryGrantModel();
// sm.Id = (int)item["Id"];
// sm.Salarygrantid = item["Salarygrantid"].ToString();
// sm.Salarystandardid = item["Salarystandardid"].ToString();
// sm.Firstkindid = item["Firstkindid"].ToString();
// sm.Firstkindname = item["Firstkindname"].ToString();
// sm.Secondkindid = item["Secondkindid"].ToString();
// sm.Secondkindname = item["Secondkindname"].ToString();
// sm.Thirdkindid = item["Thirdkindid"].ToString();
// sm.Thirdkindname = item["Thirdkindname"].ToString();
// sm.Humanamount = (int)item["Humanamount"];
// sm.Salarystandardsum = (decimal)item["Salarystandardsum"];
// sm.Salarypaidsum = (decimal)item["Salarypaidsum"];
// sm.Register = item["Register"].ToString();
// sm.Registtime = (DateTime)item["Registtime"];
// list2.Add(sm);
// }
// return list2;
//}
public int SalaryGrantUpdate(SalaryGrantModel ck)
{
MyDbContext db = CreateContext();
string sql = string.Format(@"update dbo.SalaryGrant set Salarypaidsum='{0}',Register='{1}',Registtime='{2}',Checker='{3}',
Checktime = '{4}',Checkstatus='{5}' ", ck.Salarypaidsum, ck.Register, ck.Registtime, ck.Checker, ck.Checktime, ck.Checkstatus);
if (ck.Firstkindid != null && ck.Secondkindid == "")
{
sql += string.Format(" where Firstkindid='{0}'", ck.Firstkindid);
}
else
{
sql += string.Format(" where Secondkindid='{0}'", ck.Secondkindid);
}
int list = db.Database.ExecuteSqlCommand(sql);
return(list);
}
public int SalaryGrantDelete(SalaryGrantModel ck)
{
SalaryGrant cmj = new SalaryGrant();
cmj.Salarygrantid = ck.Salarygrantid;
cmj.Salarystandardid = ck.Salarystandardid;
cmj.Firstkindid = ck.Firstkindid;
cmj.Firstkindname = ck.Firstkindname;
cmj.Secondkindid = ck.Secondkindid;
cmj.Secondkindname = ck.Secondkindname;
cmj.Thirdkindid = ck.Thirdkindid;
cmj.Thirdkindname = ck.Thirdkindname;
cmj.Humanamount = ck.Humanamount;
cmj.Salarystandardsum = ck.Salarystandardsum;
cmj.Salarypaidsum = ck.Salarypaidsum;
cmj.Register = ck.Register;
cmj.Registtime = ck.Registtime;
cmj.Checker = ck.Checker;
cmj.Checktime = ck.Checktime;
cmj.Checkstatus = ck.Checkstatus;
cmj.Id = ck.Id;
return(Delete(cmj));
}
/// <summary>
/// 薪酬发放复核点击提交的方法
/// </summary>
/// <returns></returns>
public ActionResult xg2()
{
SalaryGrantModel sg = new SalaryGrantModel();
sg.Id = Convert.ToInt32(Request["Id"]);
sg.Register = Request["Register"];
sg.Registtime = DateTime.Now;
sg.Checker = Request["Checker"];
sg.Checktime = Convert.ToDateTime(Request["Checktime"]);
sg.Checkstatus = 3;
int r1 = isb.SalaryGrantUpdate2(sg);
string arry = Request["arry"];
List <Dictionary <string, object> > sdm = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(arry);
int r2 = 0;
foreach (var item in sdm)
{
SalaryGrantdetailsModel sm = new SalaryGrantdetailsModel();
sm.Id = int.Parse(item["Id"].ToString());
sm.Bounssum = item["Bounssum"] == null || item["Bounssum"] == "" ? sm.Bounssum : Convert.ToDecimal(item["Bounssum"]);
sm.Salesum = item["Salesum"] == null || item["Salesum"] == "" ? sm.Salesum : Convert.ToDecimal(item["Salesum"]);
sm.Deductsum = item["Deductsum"] == null || item["Deductsum"] == "" ? sm.Deductsum : Convert.ToDecimal(item["Deductsum"]);
sm.Salarypaidsum = item["Salarypaidsum"] == null || item["Salarypaidsum"] == "" ? sm.Salarypaidsum : Convert.ToDecimal(item["Salarypaidsum"]);
if (igb.SalaryGrantdetailsUpdate(sm) > 0)
{
r2++;
}
}
string flag = "false";
if (r1 > 0 && r2 == sdm.Count)
{
flag = "true";
}
return(Content(flag));
}
public List <SalaryGrantModel> SalaryGrantFY(int currentPage, int pageSize, out int rows)
{
string sql = "select * from dbo.SalaryGrant where Checkstatus=2";
var list = CreateContext().SalaryGrant.SqlQuery(sql).OrderBy(e => e.Id).ToList();
rows = list.Count();
var data = list.Skip((currentPage - 1) * pageSize).Take(pageSize).ToList();
List <SalaryGrantModel> list2 = new List <SalaryGrantModel>();
foreach (var p in data)
{
SalaryGrantModel pp = new SalaryGrantModel()
{
Id = p.Id,
Salarygrantid = p.Salarygrantid,
Salarystandardid = p.Salarystandardid,
Firstkindid = p.Firstkindid,
Firstkindname = p.Firstkindname,
Secondkindid = p.Secondkindid,
Secondkindname = p.Secondkindname,
Thirdkindid = p.Thirdkindid,
Thirdkindname = p.Thirdkindname,
Humanamount = p.Humanamount,
Salarystandardsum = p.Salarystandardsum,
Salarypaidsum = p.Salarypaidsum,
Register = p.Register,
Registtime = p.Registtime,
Checker = p.Checker,
Checktime = p.Checktime,
Checkstatus = p.Checkstatus
};
list2.Add(pp);
}
return(list2);
}
public List <SalaryGrantModel> SalaryGrantSelectBy(int id)
{
MyDbContext db = CreateContext();
List <SalaryGrant> list = db.SalaryGrant.AsNoTracking()
// List<SalaryGrant> list = db.SalaryGrant.SqlQuery().AsNoTracking()
.Where(e => e.Id == id)
.Select(e => e)
.ToList();
List <SalaryGrantModel> list2 = new List <SalaryGrantModel>();
foreach (SalaryGrant item in list)
{
SalaryGrantModel sm = new SalaryGrantModel()
{
Id = item.Id,
Salarygrantid = item.Salarygrantid,
Salarystandardid = item.Salarystandardid,
Firstkindid = item.Firstkindid,
Firstkindname = item.Firstkindname,
Secondkindid = item.Secondkindid,
Secondkindname = item.Secondkindname,
Thirdkindid = item.Thirdkindid,
Thirdkindname = item.Thirdkindname,
Humanamount = item.Humanamount,
Salarystandardsum = item.Salarystandardsum,
Salarypaidsum = item.Salarypaidsum,
Register = item.Register,
Registtime = item.Registtime,
Checker = item.Checker,
Checktime = item.Checktime,
Checkstatus = item.Checkstatus
};
list2.Add(sm);
}
return(list2);
}
public int SalaryGrantUpdate2(SalaryGrantModel ck)
{
return(icd.SalaryGrantUpdate2(ck));
}
public int SalaryGrantDelete(SalaryGrantModel ck)
{
return(icd.SalaryGrantDelete(ck));
}
public int SalaryGrantAdd(SalaryGrantModel ck)
{
return(icd.SalaryGrantAdd(ck));
}
