//安排时间 public ActionResult SendCloseEmail(demand_list demand) { try { string sql = string.Format("Select * from user A where A.employeeNum = '{0}'", demand.from); List <user> mailto = db.users.SqlQuery(sql).ToList(); string sql1 = string.Format("Select * from user A where A.employeeNum = '{0}'", demand.to); List <user> mailfrom = db.users.SqlQuery(sql).ToList(); string cont = "Your demand about <B>" + demand.tab + "</B> have be Closed.</br></br>"; cont += "<table style=border-collapse:collapse border=1 bordercolor=DCDCDC ><tr align=center bgcolor=#F5F5F5><td><B>From</B></td><td><B>Topic</B></td><td><B>Tab</B></td><td><B>Content</B></td><td><B>To</B></td><td><B>Session Time</B></td><td><B>Session Location</B></td><td><B>Remark</B></td></tr>"; cont += string.Format("<tr align=center><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td><td>{4}</td><td>{5}</td><td>{6}</td><td>{7}</td></tr>", mailfrom[0].displayname, demand.senior_tab, demand.tab, demand.content, mailto[0].displayname, demand.session_time.Value.ToString("yyyy-MM-dd HH:mm:ss"), demand.session_location, demand.remark); cont += "</table>"; if (mailfrom.Count == 1) { mailHelper.SendEmail("", mailfrom[0].eMail, "", "e-Door Closed Message", cont); return(new HttpStatusCodeResult(200, "Send mail Success")); } else { return(new HttpStatusCodeResult(204, "Target Email address error" + mailfrom.Count)); } } catch (Exception err) { return(new HttpStatusCodeResult(400, err.Message)); } }
//发送请求 public ActionResult SendApplyEmail(demand_list demand) { try { string sql = string.Format("Select * from user A where A.employeeNum = '{0}'", demand.to); List <user> mailto = db.users.SqlQuery(sql).ToList(); string sql1 = string.Format("Select * from user A where A.employeeNum = '{0}'", demand.from); List <user> mailfrom = db.users.SqlQuery(sql).ToList(); string cont = "<table style=border-collapse:collapse border=1 bordercolor=DCDCDC ><tr align=center bgcolor=#F5F5F5><td><B>From</B></td><td><B>Topic</B></td><td><B>Tab</B></td><td><B>Content</B></td></tr>"; cont += string.Format("<tr align=center><td>{0}</td><td>{1}</td><td>{2}</td><td>{3}</td></tr>", mailfrom[0].displayname, demand.senior_tab, demand.tab, demand.content); cont += "</table>"; if (mailto.Count == 1) { mailHelper.SendEmail("", mailto[0].eMail, "", "e-Door Apply", cont); return(new HttpStatusCodeResult(200, "Send mail Success")); } else { return(new HttpStatusCodeResult(204, "Target Email address error" + mailto.Count)); } } catch (Exception err) { return(new HttpStatusCodeResult(400, err.Message)); } }
//GET: Demand/QueryIsTimeOK public JsonResult QueryIsTimeOK(demand_list demand) { string sql = "Select * from demand_list A where 1 "; sql += string.Format(" and A.to='{0}'", demand.to); sql += string.Format(" and A.session_time='{0}'", demand.session_time.Value.ToString("yyyy-MM-dd HH:mm:ss")); List <demand_list> items = db.demand_list.SqlQuery(sql).ToList(); return(Json(items, JsonRequestBehavior.AllowGet)); }
//POST:Edit public ActionResult Edit(demand_list demand) { try { if (!string.IsNullOrEmpty(demand.from)) { db.Entry(demand).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(new HttpStatusCodeResult(200, "Arrange Demand Success")); } else { return(new HttpStatusCodeResult(204, "No Content")); } } catch (Exception err) { return(new HttpStatusCodeResult(400, err.Message)); } }
//GET: Demand/QueryEnableDemand public JsonResult QueryEnableDemand(demand_list demand) { string sql = @"SELECT tmp.*,B.displayname as mailTo from (SELECT A.*,B.displayname AS mailFrom FROM demand_list A INNER JOIN `user` B ON A.`from` = B.employeeNum where 1 "; if (!string.IsNullOrEmpty(demand.from)) { sql += string.Format(" AND A.from='{0}'", demand.from); } if (!string.IsNullOrEmpty(demand.to)) { sql += string.Format(" AND A.to like '%{0}%'", demand.to); } sql += " AND A.status!='close'"; sql += " ) tmp INNER JOIN `user` B ON tmp.`to` = B.employeeNum ORDER BY tmp.`status`"; List <MyDemand> items = db.Database.SqlQuery <MyDemand>(sql).ToList(); return(Json(items, JsonRequestBehavior.AllowGet)); }
//[ValidateAntiForgeryToken] public ActionResult ApplyDemand(demand_list demand) { try { if (!string.IsNullOrEmpty(demand.from)) { db.demand_list.Add(demand); db.SaveChanges(); return(new HttpStatusCodeResult(200, "Apply Demand Success")); } else { return(new HttpStatusCodeResult(204, "No Content")); } } catch (Exception err) { return(new HttpStatusCodeResult(400, err.Message)); } }
// GET: Demand/Delete?id public ActionResult DeletebyID(int id) { try { demand_list item = db.demand_list.Find(id); if (item != null) { db.demand_list.Attach(item); db.demand_list.Remove(item); db.SaveChanges(); return(new HttpStatusCodeResult(200, "Delete Demand Success")); } else { return(new HttpStatusCodeResult(204, "No Content")); } } catch (Exception err) { return(new HttpStatusCodeResult(400, err.Message)); } }
//GET: Demand/QueryDemandbyRange public JsonResult QueryDemandbyRange(demand_list demand) { if (string.IsNullOrEmpty(demand.from) && string.IsNullOrEmpty(demand.to)) { int power = Convert.ToInt16(HttpContext.Request.Cookies["edoor-Power"].Value); string user = HttpContext.Request.Cookies["edoor-EmployeeID"].Value; if (power < 7) { demand.from = user; demand.to = user; } //string sql = @"SELECT A.* from demand_list A where 1 "; string sql = @"SELECT tmp.*,B.displayname as mailTo from (SELECT A.*,B.displayname AS mailFrom FROM demand_list A INNER JOIN `user` B ON A.`from` = B.employeeNum where 1 "; if (!string.IsNullOrEmpty(demand.from)) { sql += string.Format(" and A.from='{0}'", demand.from); } if (!string.IsNullOrEmpty(demand.to)) { sql += string.Format(" OR A.to like '%{0}%'", demand.to); } if (!string.IsNullOrEmpty(demand.senior_tab)) { sql += string.Format(" and A.senior_tab='{0}'", demand.senior_tab); } if (!string.IsNullOrEmpty(demand.tab)) { sql += string.Format(" and A.tab='{0}'", demand.tab); } if (!string.IsNullOrEmpty(demand.status)) { sql += string.Format(" and A.status='{0}'", demand.status); } sql += " ) tmp INNER JOIN `user` B ON tmp.`to` = B.employeeNum ORDER BY tmp.`status` DESC"; List <MyDemand> items = db.Database.SqlQuery <MyDemand>(sql).ToList(); //List<demand_list> items = db.demand_list.SqlQuery(sql).ToList(); return(Json(items, JsonRequestBehavior.AllowGet)); } else { string sql = @"SELECT tmp.*,B.displayname as mailTo from (SELECT A.*,B.displayname AS mailFrom FROM demand_list A INNER JOIN `user` B ON A.`from` = B.employeeNum where 1 "; if (!string.IsNullOrEmpty(demand.from)) { sql += string.Format(" and A.from ='{0}'", demand.from); } if (!string.IsNullOrEmpty(demand.to)) { sql += string.Format(" AND A.to like '%{0}%'", demand.to); } if (!string.IsNullOrEmpty(demand.senior_tab)) { sql += string.Format(" and A.senior_tab='{0}'", demand.senior_tab); } if (!string.IsNullOrEmpty(demand.tab)) { sql += string.Format(" and A.tab='{0}'", demand.tab); } if (!string.IsNullOrEmpty(demand.status)) { sql += string.Format(" and A.status='{0}'", demand.status); } sql += " ) tmp INNER JOIN `user` B ON tmp.`to` = B.employeeNum ORDER BY tmp.`status` DESC"; List <MyDemand> items = db.Database.SqlQuery <MyDemand>(sql).ToList(); return(Json(items, JsonRequestBehavior.AllowGet)); } }
//GET: Demand/QuerybyID?id public JsonResult QuerybyID(int id) { demand_list item = db.demand_list.Find(id); return(Json(item, JsonRequestBehavior.AllowGet)); }