public async Task <IActionResult> Upd(salary_standardModel1 ssm)
{
string[] sdt_id = HttpContext.Request.Form["sdt_id"];
string[] item_name = HttpContext.Request.Form["item_name"];
string[] salary = HttpContext.Request.Form["salary"];
string ssid = HttpContext.Request.Form["ssid"];
ssm.ssd_id = int.Parse(ssid);
int result = await issb.Upd(ssm);
if (result > 0)
{
for (int i = 0; i < sdt_id.Length; i++)
{
salary_standard_detailsModel ssdm = new salary_standard_detailsModel()
{
standard_id = ssm.standard_id,
standard_name = ssm.standard_name,
sdt_id = int.Parse(sdt_id[i]),
item_name = item_name[i],
salary = double.Parse(salary[i])
};
await issdb.Update(ssdm);
}
return(RedirectToAction("change_success"));
}
else
{
return(RedirectToAction("change_success"));
}
}
//添加
public async Task <IActionResult> register_Add(salary_standardModel1 ssm)
{
if (ModelState.IsValid)
{
string[] item_id = HttpContext.Request.Form["details.itemId"];
string[] item_name = HttpContext.Request.Form["details.itemName"];
string[] salary = HttpContext.Request.Form["details.salary"];
int result = await issb.salary_standardAdd(ssm);
if (result > 0)
{
for (int i = 0; i < item_id.Length; i++)
{
salary_standard_detailsModel ssdm = new salary_standard_detailsModel()
{
item_id = int.Parse(item_id[i].ToString()),
item_name = item_name[i].ToString(),
salary = double.Parse(salary[i].ToString()),
standard_id = ssm.standard_id,
standard_name = ssm.standard_name
};
int result2 = await issdb.salary_standard_detailsAdd(ssdm);
}
}
return(View("register_success"));
}
else
{
return(View(ssm));
}
}
//变更修改
public async Task <int> Upd(salary_standardModel1 s)
{
salary_standard ss = new salary_standard()
{
ssd_id = s.ssd_id,
changer = s.changer,
salary_sum = s.salary_sum,
change_time = s.check_time,
remark = s.remark,
check_status = 1,
designer = s.designer,
standard_id = s.standard_id,
standard_name = s.standard_name
};
tescDbContext.ss.Attach(ss);
//修改指定的列
tescDbContext.Entry(ss).Property(p => p.changer).IsModified = true;
tescDbContext.Entry(ss).Property(p => p.salary_sum).IsModified = true;
tescDbContext.Entry(ss).Property(p => p.change_time).IsModified = true;
tescDbContext.Entry(ss).Property(p => p.remark).IsModified = true;
tescDbContext.Entry(ss).Property(p => p.check_status).IsModified = true;
tescDbContext.Entry(ss).Property(p => p.designer).IsModified = true;
tescDbContext.Entry(ss).Property(p => p.standard_id).IsModified = true;
tescDbContext.Entry(ss).Property(p => p.standard_name).IsModified = true;
return(await tescDbContext.SaveChangesAsync());
}
//分页查询
public DBFenYe <salary_standardModel1> Fenye(int dqy, string tablename, string where, string keyname, int pagesize)
{
SqlParameter[] pt =
{
new SqlParameter()
{
ParameterName = "@pageSize", Value = pagesize
},
new SqlParameter()
{
ParameterName = "@keyName", Value = keyname
},
new SqlParameter()
{
ParameterName = "@tabelName", Value = tablename
},
new SqlParameter()
{
ParameterName = "@where", Value = where
},
new SqlParameter()
{
ParameterName = "@currentPage", Value = dqy
},
new SqlParameter()
{
ParameterName = "@rows", Direction = ParameterDirection.Output, SqlDbType = SqlDbType.Int
},
new SqlParameter()
{
ParameterName = "@pages", Direction = ParameterDirection.Output, SqlDbType = SqlDbType.Int
}
};
var list = tescDbContext.ss.FromSqlRaw($@"exec proc_FenYe @pageSize,@keyName,@tabelName,@where,@currentPage,@rows out,@pages out", pt).ToList();
DBFenYe <salary_standardModel1> page = new DBFenYe <salary_standardModel1>();
page.li = new List <salary_standardModel1>();
foreach (var sr in list)
{
salary_standardModel1 ss = new salary_standardModel1()
{
ssd_id = sr.ssd_id,
standard_id = sr.standard_id,
standard_name = sr.standard_name,
designer = sr.designer,
regist_time = sr.regist_time,
salary_sum = sr.salary_sum
};
page.li.Add(ss);
}
page.Pages = (int)pt[5].Value;
page.Rows = (int)pt[6].Value;
return(page);
}
//复核修改
public async Task <IActionResult> Update(salary_standardModel1 ssm)
{
string[] sdt_id = HttpContext.Request.Form["sdt_id"];
string[] item_name = HttpContext.Request.Form["item_name"];
string[] salary = HttpContext.Request.Form["salary"];
string ssid = HttpContext.Request.Form["ssid"];
ssm.ssd_id = int.Parse(ssid);
int result = await issb.Update(ssm);
if (result > 0)
{
for (int i = 0; i < sdt_id.Length; i++)
{
salary_standard_detailsModel ssdm = new salary_standard_detailsModel()
{
standard_id = ssm.standard_id,
standard_name = ssm.standard_name,
sdt_id = int.Parse(sdt_id[i]),
item_name = item_name[i],
salary = double.Parse(salary[i])
};
await issdb.Update(ssdm);
}
return(RedirectToAction("check_success"));
}
else
{
List <salary_standardModel1> list = issb.Select().Where(e => e.standard_id == ssm.standard_id).ToList();
List <salary_standard_detailsModel> list2 = issdb.Select().Where(e => e.standard_id == ssm.standard_id).ToList();
ViewTable vt = new ViewTable()
{
salary_standardModel = list,
salary_standard_detailsModel = list2
};
return(View(vt));
}
}
//添加
public async Task <int> salary_standardAdd(salary_standardModel1 ssm)
{
salary_standard ss1 = new salary_standard()
{
salary_sum = ssm.salary_sum,
ssd_id = ssm.ssd_id,
standard_id = ssm.standard_id,
standard_name = ssm.standard_name,
change_status = ssm.change_status,
changer = ssm.changer,
change_time = ssm.change_time,
checker = ssm.checker,
check_comment = ssm.check_comment,
check_status = 0,
check_time = ssm.check_time,
designer = ssm.designer,
register = ssm.register,
regist_time = ssm.regist_time,
remark = ssm.remark
};
tescDbContext.ss.Add(ss1);
return(await tescDbContext.SaveChangesAsync());
}
//查询
public List <salary_standardModel1> Select()
{
List <salary_standard> ss = tescDbContext.ss.ToList();
List <salary_standardModel1> ssm = new List <salary_standardModel1>()
{
};
foreach (var item in ss)
{
salary_standardModel1 sm = new salary_standardModel1()
{
ssd_id = item.ssd_id,
standard_name = item.standard_name,
standard_id = item.standard_id,
designer = item.designer,
salary_sum = item.salary_sum,
checker = item.checker,
change_time = item.change_time,
check_comment = item.check_comment
};
ssm.Add(sm);
}
return(ssm);
}
//复核修改
public Task <int> Update(salary_standardModel1 s)
{
return(issd.Update(s));
}
//添加
public Task <int> salary_standardAdd(salary_standardModel1 ssm)
{
return(issd.salary_standardAdd(ssm));
}
