/// <summary> /// 服务分配 /// </summary> /// <returns></returns> public ActionResult ServiceAdmeasure() { cst_service searchEntity = new cst_service(); searchEntity.svr_status = "新创建"; ViewData["pagerHelper"] = new PageHelper <cst_service>(new LinqHelper().Db.cst_service.Where(s => true).ToList(), 1, 3); //服务类型 ViewData["serviceType"] = new SelectList(new bas_dictService().GetDictsByType("服务类型"), "dict_value", "dict_item"); //客服经理 ViewData["userList"] = new SelectList(new sys_userService().GetAllWaiter(), "usr_id", "usr_name"); ViewData["date1"] = ""; ViewData["date2"] = ""; var list = new LinqHelper().Db.cst_customer.Where(c => true); List <SelectListItem> selectLists = new List <SelectListItem>(); foreach (var item in list) { selectLists.Add(new SelectListItem { Text = item.cust_name, Value = item.cust_name }); } ViewData["cst_name"] = selectLists; return(View(searchEntity)); }
/// <summary> /// 根据查询对象获得服务集合 /// </summary> /// <param name="searchEntity"></param> /// <returns></returns> public List <cst_service> GetServicesBySearchEntity(cst_service searchEntity) { return((from s in LinqHelper.GetDataContext().cst_service where s.svr_cust_name.Contains(searchEntity.svr_cust_name == null ? "" : searchEntity.svr_cust_name) && s.svr_title.Contains(searchEntity.svr_title == null ? "" : searchEntity.svr_title) && s.svr_type.Contains(searchEntity.svr_type == null ? "" : searchEntity.svr_type) && s.svr_status == searchEntity.svr_status select s).ToList()); }
public ActionResult ServiceCreation(FormCollection forms) { cst_service newObj = new cst_service(); UpdateModel <cst_service>(newObj); newObj.svr_create_date = DateTime.Now; newObj.svr_create_id = (Session["user"] as sys_user).usr_id; newObj.svr_create_by = (Session["user"] as sys_user).usr_name; newObj.svr_status = "新创建"; newObj.svr_cust_no = new cst_customerService().GetCustomerByName(newObj.svr_cust_name).cust_no; new cst_serviceService().AddService(newObj); return(RedirectToAction("ServiceCreation")); }
public ActionResult ServiceDisposing(int?id, FormCollection forms) { var db = new LinqHelper().Db; //实例化新对象用于接收请求的数据 cst_service newObj = db.cst_service.Where(s => s.svr_id == id).FirstOrDefault(); //将页面数据添加到对象中 newObj.svr_deal = forms["svr_deal"]; newObj.svr_deal_date = DateTime.Now; newObj.svr_deal_by = (Session["user"] as sys_user).usr_name; newObj.svr_deal_id = (Session["user"] as sys_user).usr_id; newObj.svr_status = "已处理"; db.Entry(newObj).Property("svr_deal").IsModified = true; db.Entry(newObj).Property("svr_deal_date").IsModified = true; db.Entry(newObj).Property("svr_deal_by").IsModified = true; db.Entry(newObj).Property("svr_deal_id").IsModified = true; db.Entry(newObj).Property("svr_status").IsModified = true; //修改 db.SaveChanges(); return(RedirectToAction("ServiceDispose")); }
public ActionResult ServiceDispose(FormCollection forms) { Expression <Func <cst_service, bool> > exp = null; int curPage = int.Parse(forms["curPage"]); exp = Search(forms); exp = ExpressionUtils.And <cst_service>(exp, s => s.svr_status == "已分配"); var list = new LinqHelper().Db.cst_service.Where(exp.Compile()).ToList(); cst_service searchEntity = new cst_service(); searchEntity.svr_status = "已分配"; UpdateModel <cst_service>(searchEntity); ViewData["pagerHelper"] = new PageHelper <cst_service>(list, curPage, 3); //服务类型 ViewData["serviceType"] = new SelectList(new bas_dictService().GetDictsByType("服务类型"), "dict_value", "dict_item"); //客服经理 ViewData["userList"] = new SelectList(new sys_userService().GetAllWaiter(), "usr_id", "usr_name"); ViewData["date1"] = forms["date1"]; ViewData["date2"] = forms["date2"]; var l = new LinqHelper().Db.cst_customer.Where(c => true); List <SelectListItem> selectLists = new List <SelectListItem>(); foreach (var item in l) { selectLists.Add(new SelectListItem { Text = item.cust_name, Value = item.cust_name }); } ViewData["cst_name"] = selectLists; return(View(searchEntity)); }
/// <summary> /// 修改服务 /// </summary> /// <param name="newObj"></param> public void UpdateService(cst_service newObj) { new LinqHelper().UpadateEntity <cst_service>(newObj); }
/// <summary> /// 添加服务 /// </summary> /// <param name="newObj"></param> public void AddService(cst_service newObj) { new LinqHelper().InsertEntity <cst_service>(newObj); }
/// <summary> /// 修改服务 /// </summary> /// <param name="newObj"></param> public void UpdateService(cst_service newObj) { new cst_serviceRepository().UpdateService(newObj); }
/// <summary> /// 根据查询对象获得服务集合 /// </summary> /// <param name="searchEntity"></param> /// <returns></returns> public List <cst_service> GetServicesBySearchEntity(cst_service searchEntity) { return(new cst_serviceRepository().GetServicesBySearchEntity(searchEntity)); }
/// <summary> /// 添加服务 /// </summary> /// <param name="newObj"></param> public void AddService(cst_service newObj) { new cst_serviceRepository().AddService(newObj); }