public ActionResult wyDaKa()
{
using (HrmDBEntities3 db = new HrmDBEntities3())
{
string name = Session["Email"].ToString();
ViewBag.name = name;
//List<qiandao> list = (from qd in db.qiandao where qd.QDZ == select qd).ToList();
//var dt4 = (from des in db.ModelsVehicleRecognition
// where (des.PlateNum.Contains("A3"))
// select new { plateMun = des.PlateNum });
//var var4 = dt4.ToList();
//var dt = (from qd in db.qiandao
// where (qd.QDZ.Contains(name))
// select new { qdz = qd.QDZ });
//var list = dt.ToList();
//List<qiandao> list = (from qd in db.qiandao
// where (qd.QDZ.Contains(name))
// select new { qdz = qd.QDZ }).ToList();
List <qiandao> list = (from qd in db.qiandao select qd).ToList();
// 在linq to sql实现where条件中in或exists的用法：
//from a in TableA where !(from b in TableB where 条件 select b.ID).Contains(a.ID)
return(Json(list, JsonRequestBehavior.AllowGet));
}
}
public ActionResult getqiandaostate()
{
using (HrmDBEntities3 db = new HrmDBEntities3())
{
List <qiandao> list = db.qiandao.ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
}
//部门、
public ActionResult GetBrand()
{
using (HrmDBEntities3 db = new HrmDBEntities3())
{
List <Dept_bumen> list = db.Dept_bumen.ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
}
//角色、
public ActionResult Getjuese()
{
using (HrmDBEntities3 db = new HrmDBEntities3())
{
List <Role_juese> list = db.Role_juese.ToList();
return(Json(list, JsonRequestBehavior.AllowGet));
}
}
//查询列表
public ActionResult list(int page, int rows, string sort, string order, string cname = "")
{
using (HrmDBEntities3 db = new HrmDBEntities3())
{
//排序
List <View_YG> list = db.View_YG.Where(c => c.UserName.Contains(cname)).ToList();
//排序的方式：order
switch (sort)
{
case "UserID":
if (order == "desc")
{
list = list.OrderByDescending(m => m.UserID).ToList();
}
else
{
list = list.OrderBy(m => m.UserID).ToList();
}
break;
case "Age":
if (order == "desc")
{
list = list.OrderByDescending(m => m.Age).ToList();
}
else
{
list = list.OrderBy(m => m.Age).ToList();
}
break;
default:
break;
}
//分页
//首先定义变量保存总行数
int zong = list.Count();
if (page == 1) //第一页直接取前三条
{
list = list.Take(rows).ToList(); //Take:取出指定序列的元素
}
else
{
list = list.Skip((page - 1) * rows).Take(rows).ToList();//Skip：跳过指定序列的元素
}
//转换json
var json = new
{
total = zong,
rows = list.ToArray()
};
return(Json(json, JsonRequestBehavior.AllowGet));
}
}
public ActionResult chongkaiqiandao(qiandao qd)
{
using (HrmDBEntities3 db = new HrmDBEntities3())
{
db.Entry(qd).State = EntityState.Modified;
db.SaveChanges();
// return Content("成功重开签到！");
// return Content("<script>alert('成功重开签到！')</script>");
return(Content("<script language='javascript' type='text/javascript'>alert('成功重开签到！');history.go(-1);location.reload();</script>"));
}
}
public ActionResult shanchuqiandao(int id)
{
using (HrmDBEntities3 db = new HrmDBEntities3())
{
db.qiandao.Remove(db.qiandao.Find(id));
db.SaveChanges();
//return Content("成功删除签到！");
//return Content("<script>alert('成功删除签到！')</script>");
return(Content("<script language='javascript' type='text/javascript'>alert('成功删除签到');history.go(-1);location.reload();</script>"));
}
}
//修改信息
public ActionResult Editcar(int GhaoID)
{
using (HrmDBEntities3 db = new HrmDBEntities3())
{
//int GhaoID, string UserName, int RoleID, string Sex, int DeptID, int Age, string Education, string UserPwd, string IDCar, int Salary, string mibaowenti, string mimapwd,int UserID
//int i = db.proc_update_yg(GhaoID, UserName, RoleID, Sex, DeptID, Age, Education, UserPwd, IDCar, Salary, mibaowenti, mimapwd, UserID);
//if (i > 0)
//{ return Content("修改成功！"); }
//else { return Content("修改失败！"); }
return(Content("修改成功！"));
}
}
//删除
/// <summary>
/// 删除 int?:可空（null）int类型
/// </summary>
/// <param name="cid"></param>
/// <returns></returns>
public ActionResult Del(IList <int?> cid)
{
using (HrmDBEntities3 db = new HrmDBEntities3())
{
foreach (int id in cid)
{
//删除
User_YG yg = db.User_YG.Find(id);
db.User_YG.Remove(yg);
}
int count = db.SaveChanges();
return(Content(count + "条删除成功！"));
}
}
//休假审核
public ActionResult XiuJiaShenHe(int id, string rad)
{
using (HrmDBEntities3 DB = new HrmDBEntities3())
{
Apply_jiludan jld = DB.Apply_jiludan.Find(id);
jld.XiaoquShenHe = rad;
int i = DB.SaveChanges();
var obj = new
{
success = "true",
message = "OK"
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
}
//出差审核
public ActionResult ChuchaiShenHeXQ(int id, string rad)
{
using (HrmDBEntities3 DB = new HrmDBEntities3())
{
Chuchai jld = DB.Chuchai.Find(id);
jld.XiaoquShenHe = rad;
int i = DB.SaveChanges();
var obj = new
{
success = "true",
message = "OK"
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
}
//外勤审核
public ActionResult WaiqinShenHe(int id, string rad)
{
using (HrmDBEntities3 DB = new HrmDBEntities3())
{
Waiqing jld = DB.Waiqing.Find(id);
jld.BumenShenHe = rad;
int i = DB.SaveChanges();
var obj = new
{
success = "true",
message = "OK"
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
}
//修改密码
public ActionResult update(string pwd2, string daan)
{
string name = Session["Email"].ToString();
using (HrmDBEntities3 db = new HrmDBEntities3())
{
int i = db.proc_update_mima(name, pwd2, daan);
if (i > 0)
{
return(Content("修改成功！"));
}
else
{
return(Content("修改失败！"));
}
}
}
//签到查看部分
public ActionResult chayue()
{
using (HrmDBEntities3 db = new HrmDBEntities3())
{
List <qiandao> list = (from qd in db.qiandao where qd.QDstate == false select qd).ToList();
// ViewBag.listxm = "张三,李四,王五,admin,麻子,张无忌,达到DAS,张明德,李逵,杨过";
var list2 = from user in db.User_YG select user.UserName;
List <string> jihe = list2.ToList();
//List转化为数组
//string[] shuzu = jihe.ToArray();
jihe.Sort(); //进行排序
var result = String.Join(",", jihe.ToArray()); //把List集合转化成string类型，变成一条字符串
ViewBag.list = list;
ViewBag.listxm2 = result;
return(View(new { list, jihe }));
}
}
public ActionResult FQQD(qiandao qd)
{
if (!ModelState.IsValid)
{
using (HrmDBEntities3 db = new HrmDBEntities3())
{
qd.QDtime = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
db.qiandao.Add(qd);
db.SaveChanges();
}
//return Content("<script>alert('发起签到成功！')</script>");
//return Json("发起签到成功！", JsonRequestBehavior.AllowGet);
return(Content("<script language='javascript' type='text/javascript'>alert('发起签到成功！');history.go(-1);location.reload();</script>"));
}
else
{
return(Content("失败"));
}
}
//休假查询
public ActionResult XiuJiaList(int page = 1, int rows = 5, string sort = "id", string order = "desc", string jldname = "")
{
using (HrmDBEntities3 db = new HrmDBEntities3())
{
// List<View_jiludan1> list = db.View_jiludan1.ToList();
IQueryable <View_QJlist> jld = db.View_QJlist.AsQueryable();
if (order == "asc")
{
switch (sort)
{
case "ApplyID":
jld = jld.OrderByDescending(u => u.ApplyID);
break;
case "UserID":
jld = jld.OrderByDescending(u => u.UserID);
break;
case "DeptName":
jld = jld.OrderByDescending(u => u.DeptName);
break;
case "Applykaishi":
jld = jld.OrderByDescending(u => u.Applykaishi);
break;
case "Applyjieshu":
jld = jld.OrderByDescending(u => u.Applyjieshu);
break;
case "Applyyuanyin":
jld = jld.OrderByDescending(u => u.Applyyuanyin);
break;
case "ApplyType":
jld = jld.OrderByDescending(u => u.ApplyType);
break;
default:
jld = jld.OrderByDescending(u => u.BumenShenHe);
break;
}
}
else
{
switch (sort)
{
case "ApplyID":
jld = jld.OrderBy(u => u.ApplyID);
break;
case "UserID":
jld = jld.OrderBy(u => u.UserID);
break;
case "DeptName":
jld = jld.OrderBy(u => u.DeptName);
break;
case "Applykaishi":
jld = jld.OrderBy(u => u.Applykaishi);
break;
case "Applyjieshu":
jld = jld.OrderBy(u => u.Applyjieshu);
break;
case "Applyyuanyin":
jld = jld.OrderBy(u => u.Applyyuanyin);
break;
case "ApplyType":
jld = jld.OrderBy(u => u.ApplyType);
break;
default:
jld = jld.OrderBy(u => u.BumenShenHe);
break;
}
}
//分页
int total = jld.Count();
if (total > 0)
{
if (page <= 1)
{
jld = jld.Take(rows);
}
else
{
jld = jld.Skip((page - 1) * rows).Take(rows);
}
}
var obj = new
{
total = total,
rows = jld.ToArray()
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
}
//出差查询
public ActionResult ChuchaiListXQ(int page = 1, int rows = 5, string sort = "id", string order = "desc")
{
using (HrmDBEntities3 db = new HrmDBEntities3())
{
// List<View_jiludan1> list = db.View_jiludan1.Where(u => u.BumenShenHe.Contains(rad1)).ToList();
string rad = "部门同意";
IQueryable <View_Chuchai> jld = db.View_Chuchai.Where(u => u.BumenShenHe.StartsWith(rad));
//IQueryable<View_jiludan1> jld = db.View_jiludan1.AsQueryable();
if (order == "asc")
{
switch (sort)
{
case "ApplyID":
jld = jld.OrderByDescending(u => u.ApplyID);
break;
case "UserID":
jld = jld.OrderByDescending(u => u.UserID);
break;
case "DeptName":
jld = jld.OrderByDescending(u => u.DeptName);
break;
case "Applykaishi":
jld = jld.OrderByDescending(u => u.Applykaishi);
break;
case "Applyjieshu":
jld = jld.OrderByDescending(u => u.Applyjieshu);
break;
case "ApplyLiyou":
jld = jld.OrderByDescending(u => u.ApplyLiyou);
break;
case "Applydizhi":
jld = jld.OrderByDescending(u => u.Applydizhi);
break;
default:
jld = jld.OrderByDescending(u => u.XiaoquShenHe);
break;
}
}
else
{
switch (sort)
{
case "ApplyID":
jld = jld.OrderBy(u => u.ApplyID);
break;
case "UserID":
jld = jld.OrderBy(u => u.UserID);
break;
case "DeptName":
jld = jld.OrderBy(u => u.DeptName);
break;
case "Applykaishi":
jld = jld.OrderBy(u => u.Applykaishi);
break;
case "Applyjieshu":
jld = jld.OrderBy(u => u.Applyjieshu);
break;
case "ApplyLiyou":
jld = jld.OrderBy(u => u.ApplyLiyou);
break;
case "Applydizhi":
jld = jld.OrderBy(u => u.Applydizhi);
break;
default:
jld = jld.OrderBy(u => u.XiaoquShenHe);
break;
}
}
//分页
int total = jld.Count();
if (total > 0)
{
if (page <= 1)
{
jld = jld.Take(rows);
}
else
{
jld = jld.Skip((page - 1) * rows).Take(rows);
}
}
var obj = new
{
total = total,
rows = jld.ToArray()
};
return(Json(obj, JsonRequestBehavior.AllowGet));
}
}
