/// <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);
}
