public ActionResult Edit(FormCollection form)
{
string writeMsg = string.Empty;
Hotel item = new Hotel();
item.ID = int.Parse(Request.Form["ID"]);
item.Title = Request.Form["Title"];
item.Keywords = Request.Form["Keywords"];
item.Content = form["Content"];
item.CategoryID = int.Parse(Request.Form["CategoryID"]);
item.ModifyID = WebCookieHelper.GetEmployeeId();
item.ModifyTime = DateTime.Now;
item.ImagePath = HtmlContentHelper.GetFirstImgUrl(item.Content);
item.Summary = HtmlContentHelper.GetSummary(item.Content);
EnterRepository.GetRepositoryEnter().HotelRepository.Get(m => m.ID == item.ID);
bool result = EnterRepository.GetRepositoryEnter().HotelRepository.EditEntity(item, new string[] { "Title", "Keywords", "CategoryID", "Content", "ModifyID", "ModifyTime", "ImagePath", "Summary" });
if (EnterRepository.GetRepositoryEnter().SaveChange() > 0)
{
writeMsg = "修改成功!";
}
else
{
writeMsg = "修改失败!";
}
return(Content(writeMsg));
}
/// <summary>
/// 导入订房报名
/// </summary>
public ActionResult ImportOrder()
{
try
{
string writeMsg = "";
string selectID = Request.Form["cbx_select"] != "" ? Request.Form["cbx_select"] : "";
string[] ids = selectID.Split(',');
if (ids.Count() > 0)
{
int employeeid = WebCookieHelper.GetEmployeeId();
foreach (var item in ids)
{
int id = Convert.ToInt32(item);
var result = EnterRepository.GetRepositoryEnter().UsersRepository.LoadEntities(m => m.ID == id).FirstOrDefault();
result.EmployeeID = employeeid;
EnterRepository.GetRepositoryEnter().UsersRepository.EditEntity(result, new string[] { "EmployeeID" });
}
if (EnterRepository.GetRepositoryEnter().SaveChange() > 0)
{
writeMsg = string.Format("导入成功");
}
else
{
writeMsg = "导入失败";
}
}
return(Content(writeMsg));
}
catch (Exception ex)
{
log.Error(ex);
return(Content("导入失败！"));
}
}
public ActionResult Add(FormCollection form)
{
string writeMsg = string.Empty;
Hotel item = new Hotel();
item.Title = Request.Form["Title"];
item.Keywords = Request.Form["Keywords"];
item.CategoryID = int.Parse(Request.Form["CategoryID"]);
item.Content = form["Content"];
item.CreateID = WebCookieHelper.GetEmployeeId();
item.CreateTime = DateTime.Now;
item.ModifyID = WebCookieHelper.GetEmployeeId();
item.ModifyTime = DateTime.Now;
item.ImagePath = HtmlContentHelper.GetFirstImgUrl(item.Content);
item.Summary = HtmlContentHelper.GetSummary(item.Content);
EnterRepository.GetRepositoryEnter().HotelRepository.AddEntity(item);
if (EnterRepository.GetRepositoryEnter().SaveChange() > 0)
{
writeMsg = "{msg:\"保存成功!\",id:" + item.ID.ToString() + "}";
}
else
{
writeMsg = "{msg:\"保存失败!\",id:0}";
}
return(Content(writeMsg));
}
public ActionResult ChangePwd()
{
string szPwdOld = Request.Form["pwdold"] != "" ? Request.Form["pwdold"] : "";
string szPwdNew = Request.Form["pwdnew"] != "" ? Request.Form["pwdnew"] : "";
string szPwdConfirm = Request.Form["pwdconfirm"] != "" ? Request.Form["pwdconfirm"] : "";
int id = WebCookieHelper.GetEmployeeId();
var curUser = EnterRepository.GetRepositoryEnter().EmployeeRepository.LoadEntities(m => m.ID == id).FirstOrDefault();
if (curUser == null)
{
return(RedirectToAction("Login"));
}
string writeMsg = "更改失败！";
if (curUser.Pwd != szPwdOld)
{
writeMsg = "原始密码错误，无法更改密码！";
}
else
{
curUser.Pwd = szPwdNew;
EnterRepository.GetRepositoryEnter().EmployeeRepository.EditEntity(curUser, new string[] { "Pwd" });
if (EnterRepository.GetRepositoryEnter().SaveChange() > 0)
{
writeMsg = "更改成功!";
}
else
{
writeMsg = "更改失败!";
}
}
return(Content(writeMsg));
}
public ActionResult GetEmpMenu()
{
string strJson = string.Empty;
try
{
if (!WebCookieHelper.EmployeeCheckLogin())
{
return(RedirectToAction("Admin/Account/Login"));
}
int nEmpID = WebCookieHelper.GetEmployeeId();
var menus = MenuServices.GetMenuByEmpID(nEmpID);
if (menus.ToList().Count > 0)
{
strJson = JsonHelper.GetMenuJson(menus, 0);
strJson = "{" + strJson + "}";
}
else
{
strJson = "\"menus\":[]";
}
//string strJson = "[{\"id\":\"1\",\"text\":\"hello1\",\"checked\":\"true\",\"state\":\"open\",\"children\":[{\"id\":\"2\",\"text\":\"hello2\",\"state\":\"open\"}]},{\"id\":\"1\",\"text\":\"hello1\",\"state\":\"open\",\"children\":[{\"id\":\"2\",\"text\":\"hello2\",\"state\":\"open\"}]}]";
}
catch (Exception ex)
{
throw;
}
return(Content(strJson));
}
/// <summary>
/// 添加或修改数据
/// </summary>
public ActionResult UpdateData()
{
try
{
bool blResult = false;
int id = Request.Form["id"] != "" ? Convert.ToInt32(Request.Form["id"]) : 0;
Users model = GetData(id);
string writeMsg = "操作失败！";
if (model != null)
{
if (id < 1)
{
if (WebCookieHelper.EmployeeCheckLogin())
{
int empid = WebCookieHelper.GetEmployeeId();
model.EmployeeID = empid;
//判断是否已经有相同号码的考生
if (EnterRepository.GetRepositoryEnter().UsersRepository.LoadEntities(m => m.Tel == model.Tel).Count() > 0)
{
writeMsg = "存在相同的电话号码无法新增，请查看考生是否在预报名列表";
}
else
{
EnterRepository.GetRepositoryEnter().UsersRepository.AddEntity(model);
if (EnterRepository.GetRepositoryEnter().SaveChange() > 0)
{
writeMsg = "增加成功!";
}
}
}
else
{
writeMsg = "请重新登录！";
}
}
else
{
//EnterRepository.GetRepositoryEnter().UsersRepository.Get(m => m.ID == id);
EnterRepository.GetRepositoryEnter().UsersRepository.EditEntity(model, new string[] { "Name", "School", "ExamSchool", "Sequences", "Tel", "Baks", "PayMoney", "ExamPlace", "Room", "Hotel", "HotelExpense", "MoneyBack", "Gender", "Template", "PayPlace", "ExceptRoomie", "Status" });
if (EnterRepository.GetRepositoryEnter().SaveChange() > 0)
{
writeMsg = "更新成功!";
}
else
{
writeMsg = "更新失败!";
}
}
}
return(Content(writeMsg));
}
catch (Exception ex)
{
throw;
}
}
//
// GET: /Employee/
public ActionResult Index(int?id)
{
if (!WebCookieHelper.EmployeeCheckLogin())
{
string userAgent = Request.UserAgent;
if (userAgent.ToLower().Contains("micromessenger"))
{
Utility.CookieHelper.SetCookie("returnurl", Request.Url.ToString(), "", 1);
return(Redirect("/weixin/account"));
}
else
{
return(Redirect("/member/login?returnurl=" + Request.Url));
}
}
string tel = string.Empty;
string name = string.Empty;
string keyword = Request.QueryString["keyword"];
name = keyword;
Pagination pagination = new Pagination();
int page = 1;
if (id != null)
{
page = int.Parse(id.ToString());
}
int totalCount = 0;
pagination.Size = 30;
pagination.ActionUrl = "employee/index";
pagination.CurrentPageIndex = page;
DateTime startTime = DateTime.Now;
int szEmployeeIDs = 0;
int empid = WebCookieHelper.GetEmployeeId();
if (!RightServices.CheckAuthority(SystemContext.RightPoint.ViewAllUsers, empid))
{
szEmployeeIDs = empid;
}
var lstUsers = EnterRepository.GetRepositoryEnter().UsersRepository.LoadPageList(szEmployeeIDs, empid, tel, name, (page - 1) * pagination.Size, pagination.Size, out totalCount).ToList();
string time = (DateTime.Now - startTime).TotalSeconds.ToString();
pagination.TotalCount = totalCount;
pagination.Order = "Name";
pagination.Keyword = keyword;
ViewBag.time = time;
ViewBag.keyword = keyword;
ViewBag.users = lstUsers;
ViewBag.Pagination = pagination;
return(View());
}
public ActionResult QueryEmployeeIDs()
{
try
{
if (!WebCookieHelper.EmployeeCheckLogin())
{
return(RedirectToAction("Admin/Account/Login"));
}
JsonHelper json = new JsonHelper();
string strJson = string.Empty;
json.AddItem("id", "");
json.AddItem("text", "所有");
json.ItemOk();
int empid = WebCookieHelper.GetEmployeeId();
string Name = WebCookieHelper.GetEmployeeInfo((int)WebCookieHelper.EmployeeInfo.Name);
if (!RightServices.CheckAuthority(SystemContext.RightPoint.ViewAllUsers, empid))
{
json.AddItem("id", empid.ToString());
json.AddItem("text", Name);
json.ItemOk();
}
else
{
var result = UsersServices.GetStaffEmployee(empid);
foreach (Employee item in result)
{
json.AddItem("id", item.ID.ToString());
json.AddItem("text", item.Name);
json.ItemOk();
}
}
strJson = json.ToEasyuiListJsonString();
return(Content(strJson));
}
catch (Exception ex)
{
GlobalMethod.log.Error(ex);
throw;
}
}
public ActionResult Export()
{
string jsons = "";
JsonHelper jsonHelper = new JsonHelper();
var Template = Request.Form["Template"];
var Name = Request.Form["Name"];
var szEmployeeID = Request.Form["EmployeeID"];
string filePath = string.Format("{0}{1}"
, Server.MapPath(SystemContext.FilePath.Excel)
, "test.xls");
if (!WebCookieHelper.EmployeeCheckLogin())
{
return(Content(""));
}
int empid = WebCookieHelper.GetEmployeeId();
if (string.IsNullOrEmpty(szEmployeeID) || szEmployeeID == "所有")
{
szEmployeeID = "0";
}
if (!RightServices.CheckAuthority(SystemContext.RightPoint.ViewAllUsers, empid))
{
szEmployeeID = empid.ToString();
}
try
{
var lstUser = EnterRepository.GetRepositoryEnter().UsersRepository.GetUsersList(int.Parse(szEmployeeID), empid, null, null);
string templateValue = SystemContext.Template.GetTemplate(Template);
ExcelHelper excelOpr = new ExcelHelper();
string[] columnName = templateValue.Split(',');
List <ArrayList> values = new List <ArrayList>();
foreach (var user in lstUser)
{
ArrayList value = new ArrayList();
for (int j = 0; j < columnName.Length; j++)
{
value.Add(GetColumnValue(user, columnName[j]));
}
value.Add("");
values.Add(value);
}
excelOpr.ToExcel(filePath, columnName, values);
jsons = "[{\"success\":true,msg:\"导出成功\",filePath:\""
+ string.Format("{0}/{1}"
, SystemContext.FilePath.Excel
, "test.xls")
+ "\"}]";
}
catch (Exception ex)
{
GlobalMethod.log.Error(ex);
jsons = "[{\"success\":true,msg:\"导出失败\"}]";
}
return(Content(jsons));
}
/// <summary>
/// 查询数据
/// </summary>
public ActionResult QueryData()
{
try
{
int page = Request.Form["page"] != "" ? Convert.ToInt32(Request.Form["page"]) : 0;
int size = Request.Form["rows"] != "" ? Convert.ToInt32(Request.Form["rows"]) : 0;
string sort = Request.Form["sort"] != "" ? Request.Form["sort"] : "";
string order = Request.Form["order"] != "" ? Request.Form["order"] : "";
string Template = Request.Form["Template"] != "" ? Request.Form["Template"] : "";
string szEmployeeIDs = !string.IsNullOrEmpty(Request.Form["EmployeeID"]) ? Request.Form["EmployeeID"] : "0";
string Name = Request.Form["Name"] != "" ? Request.Form["Name"] : "";
string Tel = Request.Form["Tel"] != "" ? Request.Form["Tel"] : "";
if (page < 1)
{
return(Content(""));
}
if (Name == "所有")
{
Name = string.Empty;
}
if (szEmployeeIDs == "所有")
{
szEmployeeIDs = "0";
}
if (!WebCookieHelper.EmployeeCheckLogin())
{
return(Content(""));
}
int empid = WebCookieHelper.GetEmployeeId();
if (!RightServices.CheckAuthority(SystemContext.RightPoint.ViewAllUsers, empid))
{
szEmployeeIDs = empid.ToString();
}
int rowCount = 0;
var lstUsers = EnterRepository.GetRepositoryEnter().UsersRepository.LoadPageList(int.Parse(szEmployeeIDs), empid, Tel, Name, (page - 1) * size, size, out rowCount).ToList();
JsonHelper json = new JsonHelper();
string strJson = string.Empty;
try
{
foreach (Users item in lstUsers)
{
item.Hotel = item.Hotel == null?"":item.Hotel.Replace("\t", "");
item.Tel = item.Tel == null ? "" : item.Tel.Replace("\n", "");
item.Baks = item.Baks == null ? "" : item.Baks.Replace("\n", "");
json.AddItem("ID", item.ID.ToString());
json.AddItem("Name", item.Name);
json.AddItem("School", item.School);
json.AddItem("ExamSchool", item.ExamSchool);
json.AddItem("Sequences", item.Sequences.ToString());
json.AddItem("Tel", item.Tel);
json.AddItem("Baks", item.Baks);
json.AddItem("Pwd", item.Pwd);
json.AddItem("PayMoney", item.PayMoney);
json.AddItem("ExamPlace", item.ExamPlace);
json.AddItem("Hotel", item.Hotel);
json.AddItem("PassWord", item.Pwd);
json.AddItem("PayMoney", item.PayMoney);
json.AddItem("ExamPlace", item.ExamPlace);
json.AddItem("Room", item.Room);
json.AddItem("Hotel", item.Hotel);
json.AddItem("HotelExpense", item.HotelExpense);
json.AddItem("MoneyBack", item.MoneyBack);
json.AddItem("EmployeeID", item.EmployeeID.ToString());
json.AddItem("EmployeeName", item.EmployeeName);
json.AddItem("Gender", item.Gender);
json.AddItem("Template", item.Template);
json.AddItem("PayPlace", item.PayPlace);
json.AddItem("CreateTime", item.CreateTime == null?DateTime.Now.ToString():item.CreateTime.ToString());
json.AddItem("ExceptRoomie", item.ExceptRoomie);
json.AddItem("Status", item.Status);
json.AddItem("Prize", item.Prize);
json.ItemOk();
}
}
catch (Exception ex)
{
log.Error(ex);
}
json.totlalCount = rowCount;
if (json.totlalCount > 0)
{
strJson = json.ToEasyuiGridJsonString();
}
else
{
strJson = @"[]";
}
// json = "{ \"rows\":[ { \"ID\":\"48\",\"NewsTitle\":\"mr\",\"NewsContent\":\"mrsoft\",\"CreateTime\":\"2013-12-23\",\"CreateUser\":\"ceshi\",\"ModifyTime\":\"2013-12-23\",\"ModifyUser\":\"ceshi\"} ],\"total\":3}";
return(Content(strJson));
}
catch (Exception ex)
{
log.Error(ex);
throw;
}
}
public ActionResult ArticleBack()
{
int employeeID = WebCookieHelper.GetEmployeeId();
string writeMsg = "同步成功！";
try
{
string selectID = Request.Form["cbx_select"] != "" ? Request.Form["cbx_select"] : "";
if (selectID != string.Empty && selectID != "0")
{
string[] ids = selectID.Split(',');
foreach (var item in ids)
{
int id = int.Parse(item);
var blog = EnterRepository.GetRepositoryEnter().BlogRepository.LoadEntities(m => m.ID == id).FirstOrDefault();
if (blog.ArticleID == 0)
{
var article = new Article();
article.CategoryID = blog.CategoryID;
article.Content = blog.Content;
article.Title = blog.Title;
article.ViewCount = blog.ViewCount;
article.Summary = blog.Summary;
article.ModifyTime = blog.ModifyTime;
article.ModifyID = employeeID;
article.Keywords = blog.Keywords;
article.ImagePath = blog.ImagePath;
article.CreateID = employeeID;
article.CreateTime = blog.CreateTime;
EnterRepository.GetRepositoryEnter().ArticleRepository.AddEntity(article);
if (EnterRepository.GetRepositoryEnter().SaveChange() <= 0)
{
writeMsg = string.Format("同步失败");
break;
}
blog.ArticleID = article.ID;
EnterRepository.GetRepositoryEnter().BlogRepository.Get(m => m.ID == id);
EnterRepository.GetRepositoryEnter().BlogRepository.EditEntity(blog, new string[] { "ArticleID" });
if (EnterRepository.GetRepositoryEnter().SaveChange() <= 0)
{
writeMsg = string.Format("同步失败");
break;
}
}
else
{
var article = EnterRepository.GetRepositoryEnter().ArticleRepository.LoadEntities(m => m.ID == blog.ArticleID).FirstOrDefault();
if (article != null)
{
article.CategoryID = blog.CategoryID;
article.Content = blog.Content;
article.Title = blog.Title;
article.ViewCount = blog.ViewCount;
article.Summary = blog.Summary;
article.Keywords = blog.Keywords;
article.ModifyTime = blog.ModifyTime;
article.ModifyID = employeeID;
article.ImagePath = blog.ImagePath;
article.CreateID = employeeID;
article.CreateTime = blog.CreateTime;
EnterRepository.GetRepositoryEnter().ArticleRepository.Get(m => m.ID == article.ID);
EnterRepository.GetRepositoryEnter().ArticleRepository.EditEntity(article, new string[] {
"CategoryID"
, "Content"
, "Title"
, "ViewCount"
, "Summary"
, "Keywords"
, "ModifyTime"
, "ModifyID"
, "CreateID"
, "CreateTime"
, "ImagePath"
});
if (EnterRepository.GetRepositoryEnter().SaveChange() <= 0)
{
writeMsg = string.Format("同步失败");
break;
}
}
else
{
article = new Article();
article.CategoryID = blog.CategoryID;
article.Content = blog.Content;
article.Title = blog.Title;
article.ViewCount = blog.ViewCount;
article.Summary = blog.Summary;
article.Keywords = blog.Keywords;
article.ModifyTime = blog.ModifyTime;
article.ModifyID = employeeID;
article.ImagePath = blog.ImagePath;
article.CreateID = employeeID;
article.CreateTime = blog.CreateTime;
EnterRepository.GetRepositoryEnter().ArticleRepository.AddEntity(article);
if (EnterRepository.GetRepositoryEnter().SaveChange() <= 0)
{
writeMsg = string.Format("同步失败");
break;
}
blog.ArticleID = article.ID;
EnterRepository.GetRepositoryEnter().BlogRepository.Get(m => m.ID == id);
EnterRepository.GetRepositoryEnter().BlogRepository.EditEntity(blog, new string[] { "ArticleID" });
if (EnterRepository.GetRepositoryEnter().SaveChange() <= 0)
{
writeMsg = string.Format("同步失败");
break;
}
}
}
}
}
return(Content(writeMsg));
}
catch (Exception ex)
{
GlobalMethod.log.Error(ex);
writeMsg = "同步失败";
return(Content(writeMsg));
}
}