//安排时间
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));
}
