public JsonResult SaveRelation(string statsicName, List <string> infos) { Common.ResultInfo rInfo = new Common.ResultInfo(); if (string.IsNullOrWhiteSpace(statsicName) || infos == null) { rInfo.Message = "参数不正确"; return(Json(rInfo)); } try { var currentInfos = DBContext.StatsicRelation.Where(x => x.StatsicName == statsicName); DBContext.StatsicRelation.RemoveRange(currentInfos); foreach (var item in infos) { DBContext.StatsicRelation.Add(new StatsicRelation() { StatsicName = statsicName, GroupName = item }); } DBContext.SaveChanges(); rInfo.IsSuccess = true; } catch (Exception ex) { rInfo.Message = ex.Message; } return(Json(rInfo)); }
public JsonResult OpGroup(int id) { Common.ResultInfo rInfo = new Common.ResultInfo(); try { var currentInfo = DBContext.UploadInfo.FirstOrDefault(x => x.Id == id); if (currentInfo != null) { currentInfo.IsDel = 1; DBContext.SaveChanges(); rInfo.IsSuccess = true; } else { rInfo.Message = string.Format("没有 {0}", id); } } catch (Exception ex) { rInfo.Message = ex.Message; } return(Json(rInfo)); }
public JsonResult AddStatsicLine(string statsicName, int op) { Common.ResultInfo rInfo = new Common.ResultInfo(); if (string.IsNullOrWhiteSpace(statsicName)) { rInfo.Message = "参数不正确"; return(Json(rInfo)); } try { var currentInfo = DBContext.StatsicInfo.FirstOrDefault(x => x.StatsicName == statsicName); if (op == 1) { if (currentInfo == null) { int count = DBContext.StatsicInfo.Count(); currentInfo = new StatsicInfo() { StatsicName = statsicName, IsDel = 0, OrderIndex = count + 1 }; DBContext.StatsicInfo.Add(currentInfo); DBContext.SaveChanges(); rInfo.IsSuccess = true; } else if (currentInfo.IsDel == 1) { currentInfo.IsDel = 0; DBContext.SaveChanges(); rInfo.IsSuccess = true; } else { rInfo.Message = string.Format("{0} 已存在", statsicName); } } else { if (currentInfo != null) { currentInfo.IsDel = 1; DBContext.SaveChanges(); rInfo.IsSuccess = true; } else { rInfo.Message = string.Format("没有 {0}", statsicName); } } } catch (Exception ex) { rInfo.Message = ex.Message; } return(Json(rInfo)); }
public JsonResult OpGroup(string name, int op) { Common.ResultInfo rInfo = new Common.ResultInfo(); if (string.IsNullOrWhiteSpace(name)) { rInfo.Message = "参数不正确"; return(Json(rInfo)); } try { var currentInfo = DBContext.GroupInfo.FirstOrDefault(x => x.Name == name); if (op == 1) { if (currentInfo == null) { currentInfo = new GroupInfo() { Name = name, IsDel = 0 }; DBContext.GroupInfo.Add(currentInfo); DBContext.SaveChanges(); rInfo.IsSuccess = true; } else if (currentInfo.IsDel == 1) { currentInfo.IsDel = 0; DBContext.SaveChanges(); rInfo.IsSuccess = true; } else { rInfo.Message = string.Format("{0} 已存在", name); } } else { if (currentInfo != null) { currentInfo.IsDel = 1; DBContext.SaveChanges(); rInfo.IsSuccess = true; } else { rInfo.Message = string.Format("没有 {0}", name); } } } catch (Exception ex) { rInfo.Message = ex.Message; } return(Json(rInfo)); }
public JsonResult Refresh(RefreshParam info) { Common.ResultInfo rInfo = new Common.ResultInfo(); if (info == null) { rInfo.Message = "参数不正确"; return(Json(rInfo)); } try { string[] lines = info.Datas.Split(new string[] { "\n" }, StringSplitOptions.RemoveEmptyEntries); string dataPath = GetDataPath(info.Id.ToString()); List <StatsisLib.BaseDataInfo> infos = null; infos = infos.Deserialize(dataPath); var lineInfos = lines.Select(x => new { GroupName = x.Split('|')[0], PName = x.Split('|')[1], PValue = x.Split('|')[2] }).GroupBy(x => x.GroupName).ToDictionary(x => x.Key, x => x.ToList()); foreach (var line in lineInfos) { var lineInfo = infos.FirstOrDefault(x => x.技能组 == line.Key); if (lineInfo == null) { continue; } foreach (var item in line.Value) { int intValue = 0; if (int.TryParse(item.PValue, out intValue)) { var pInfo = lineInfo.GetType().GetProperty(item.PName); if (pInfo != null) { pInfo.SetValue(lineInfo, intValue, null); } } } } // DataProcess.ComputeV2(infos); DataProcess.Compute(infos); infos = infos.OrderByDescending(x => x.通过率).ThenByDescending(x => x.净满意度).ToList(); infos.Serialize(dataPath); rInfo.IsSuccess = true; } catch (Exception ex) { rInfo.Message = ex.Message; } return(Json(rInfo)); }
public JsonResult OpUser(UserInfo userInfo) { Common.ResultInfo rInfo = new Common.ResultInfo(); if (userInfo == null || userInfo.Id == 0) { rInfo.Message = "参数不正确"; return(Json(rInfo)); } try { int maxIndex = 1; if (DBContext.UserInfo.Count(x => x.GroupName == userInfo.GroupName) != 0) { maxIndex = DBContext.UserInfo.Where(x => x.GroupName == userInfo.GroupName).Max(x => x.OrderIndex).Value + 1; } var uInfo = DBContext.UserInfo.FirstOrDefault(x => x.Id == userInfo.Id); if (uInfo == null) { userInfo.OrderIndex = maxIndex; DBContext.UserInfo.Add(userInfo); } else { uInfo.Name = userInfo.Name; uInfo.InTime = userInfo.InTime; uInfo.IsShield = userInfo.IsShield; uInfo.IsTrimFromGroup = userInfo.IsTrimFromGroup; if (uInfo.GroupName != userInfo.GroupName) { uInfo.OrderIndex = maxIndex; uInfo.GroupName = userInfo.GroupName; } uInfo.Remark = userInfo.Remark ?? ""; uInfo.IsDel = 0; } DBContext.SaveChanges(); rInfo.IsSuccess = true; } catch (Exception ex) { rInfo.Message = ex.Message; } return(Json(rInfo)); }
public JsonResult ChangePostion(int id, int op) { Common.ResultInfo rInfo = new Common.ResultInfo(); //if (string.IsNullOrWhiteSpace(name)) //{ // rInfo.Message = "参数不正确"; // return Json(rInfo); //} try { var currentInfo = DBContext.UserInfo.FirstOrDefault(x => x.Id == id); if (currentInfo == null) { rInfo.Message = "参数不正确"; return(Json(rInfo)); } var nextList = DBContext.UserInfo.Where(x => x.GroupName == currentInfo.GroupName && (op == 1 ? (x.OrderIndex.Value > currentInfo.OrderIndex.Value) : (x.OrderIndex.Value < currentInfo.OrderIndex.Value))); if (nextList.Count() == 0) { rInfo.Message = "无需移动"; return(Json(rInfo)); } var nextInfo = new UserInfo(); if (op == 1) { nextInfo = nextList.OrderBy(x => x.OrderIndex).FirstOrDefault(); } else { nextInfo = nextList.OrderByDescending(x => x.OrderIndex).FirstOrDefault(); } int?tmpIndex = currentInfo.OrderIndex; currentInfo.OrderIndex = nextInfo.OrderIndex; nextInfo.OrderIndex = tmpIndex; DBContext.SaveChanges(); rInfo.IsSuccess = true; } catch (Exception ex) { rInfo.Message = ex.Message; } return(Json(rInfo)); }
public JsonResult UpLoad2() { Common.ResultInfo rInfo = new Common.ResultInfo(); try { var files = Request.Files; if (files != null && files.Count > 0) { foreach (string file in Request.Files) { HttpPostedFileBase item = Request.Files[file] as HttpPostedFileBase; if (item != null && item.ContentLength > 0) { //string saveName = string.Format("{0}_{1}", DateTime.Now.ToString().Replace("-", "_").Replace(":", "_").Replace("/", "_").Replace(" ", "_"), item.FileName); //DBContext.UploadInfo.Add(new DataService.UploadInfo() // { // CreateTime = DateTime.Now, // Name = item.FileName, // SaveName = saveName, // FromIP = Request.UserHostAddress, // FromUser = Request.UserHostName, // IsDel = 0 // }); //item.SaveAs(GetPath(saveName)); //using (BinaryReader br = new BinaryReader(item.InputStream)) //{ // byte[] datas = br.ReadBytes((int)item.InputStream.Length); // System.IO.File.WriteAllBytes(GetPath(saveName), datas); //} DBContext.SaveChanges(); rInfo.IsSuccess = true; } } } } catch (Exception ex) { rInfo.Message = ex.Message; Json(rInfo); } return(Json(rInfo)); }
public JsonResult DelUserById(long uid) { Common.ResultInfo rInfo = new Common.ResultInfo(); try { var uInfo = DBContext.UserInfo.FirstOrDefault(x => x.Id == uid); if (uInfo != null) { uInfo.IsDel = 1; DBContext.SaveChanges(); rInfo.IsSuccess = true; } } catch (Exception ex) { rInfo.Message = ex.Message; } return(Json(rInfo)); }
public JsonResult SendTo(int id) { Common.ResultInfo rInfo = new Common.ResultInfo(); try { var currentInfo = DBContext.UploadInfo.FirstOrDefault(x => x.Id == id); if (currentInfo != null) { string absoluFilePath = GetPath(currentInfo.SaveName); UnionLib.AnaysleService service = new UnionLib.AnaysleService(); string file = service.Create(absoluFilePath, GetAssistParams(id)); var msg = ""; var sendMail = new MailLib.MailHelper("smtp.163.com", 25, "*****@*****.**", "qwerty123", System.Configuration.ConfigurationManager.AppSettings["toUsers"].Split(','), "how are you", "body is xxxx", false); sendMail.IsSendAttachments = true; sendMail.Attachments = new string[] { file }; var s = sendMail.Send(out msg); if (s == MailLib.MailHelper.SendStatus.Success) { rInfo.IsSuccess = true; } else { rInfo.Message = msg; } } else { rInfo.Message = string.Format("没有 {0}", id); } } catch (Exception ex) { rInfo.Message = ex.Message; } return(Json(rInfo, JsonRequestBehavior.AllowGet)); }
public JsonResult UpLoad2() { Common.ResultInfo rInfo = new Common.ResultInfo(); try { var files = Request.Files; if (files == null && files.Count != 1) { rInfo.Message = "文件为空或者个数不正确"; } HttpPostedFileBase fileItem = Request.Files[0] as HttpPostedFileBase; if (fileItem != null && fileItem.ContentLength > 0) { StringBuilder str = new StringBuilder(); string saveName = string.Format("{0}_{1}", DateTime.Now.ToString().Replace("-", "_").Replace(":", "_").Replace("/", "_").Replace(" ", "_"), fileItem.FileName); var ds = StatsisLib.NPOIHelper.ImportExceltoDs(fileItem.InputStream); var dt = ds.Tables[0]; var urInfos = StatsisLib.Common.DTToList <StatsisLib.Models.URInfo>(dt); if (fileItem.FileName.Contains("time")) { //更新时间 str.Append("更新用户时间处理<br/>"); foreach (var item in urInfos) { var uuInfo = DBContext.UserInfo.FirstOrDefault(x => x.Id.ToString() == item.工号); if (uuInfo != null) { if (!string.IsNullOrWhiteSpace(item.入组时间)) { uuInfo.InTime = item.入组时间; } if (!string.IsNullOrWhiteSpace(item.特殊情况)) { uuInfo.Remark = item.特殊情况; } str.AppendFormat("更新用户:{0}<br/>", item.姓名); } } } else { List <StatsisLib.Models.URInfo> sheildInfos = new List <StatsisLib.Models.URInfo>(); if (ds.Tables.Count > 1) { sheildInfos = StatsisLib.Common.DTToList <StatsisLib.Models.URInfo>(ds.Tables[1]); foreach (var item in sheildInfos) { item.IsHiddenFromInGroup = true; } urInfos.AddRange(sheildInfos); } ///去掉组长本人 var gInfos = urInfos.Where(x => !x.组别.Contains(x.姓名)).GroupBy(x => x.组别).ToDictionary(x => x.Key, x => x.ToList()); int groupIndex = 1; foreach (var item in gInfos) { var gInfo = DBContext.GroupInfo.FirstOrDefault(x => x.Name == item.Key); if (gInfo == null) { str.AppendFormat("缺少组:{0}<br/>", item.Key); gInfo = new GroupInfo() { Name = item.Key, IsDel = 0, OrderIndex = groupIndex, IsLeaf = 1 }; DBContext.GroupInfo.Add(gInfo); } else { gInfo.OrderIndex = groupIndex; gInfo.IsDel = 0; } groupIndex++; #region u int index = 1; foreach (var uItem in item.Value) { var s = DBContext.UserInfo.FirstOrDefault(x => x.Id.ToString() == uItem.工号); if (s == null) { s = new UserInfo() { Id = int.Parse(uItem.工号), GroupName = uItem.组别, Name = uItem.姓名, OrderIndex = index, Remark = uItem.特殊情况, IsDel = 0, }; DBContext.UserInfo.Add(s); str.AppendFormat("缺少:{0}<br/>", uItem.工号); } else if (s.GroupName != uItem.组别) { str.AppendFormat("对不上:{0},{1}=>{2}<br/>", uItem.工号, s.GroupName, uItem.组别); s.GroupName = uItem.组别; } if (s.IsShield == 1) { str.AppendFormat("恢复:{0},{1}<br/>", uItem.组别, uItem.工号); } s.IsDel = 0; s.IsShield = 0; s.IsTrimFromGroup = uItem.IsHiddenFromInGroup ? 1 : 0; s.Remark = uItem.特殊情况; s.OrderIndex = index; if (string.IsNullOrWhiteSpace(s.InTime)) { s.InTime = GetInGroupTime(uItem.入组时间); } //if (string.IsNullOrWhiteSpace(s.InTime)) //{ var tTime = GetInGroupTime(uItem.特殊情况); if (!string.IsNullOrWhiteSpace(tTime)) { s.InTime = tTime; } //} index++; } #endregion } foreach (var dItem in DBContext.UserInfo.Where(x => x.IsDel == 0).ToList()) { var s = urInfos.FirstOrDefault(x => x.工号 == dItem.Id.ToString()); if (s == null && (dItem.IsShield ?? 0) == 0) { //var sheildItem = sheildInfos.FirstOrDefault(x => x.工号 == dItem.Id.ToString()); //if (sheildItem != null) //{ dItem.IsShield = 1; // dItem.Remark = sheildItem.特殊情况; str.AppendFormat("不考核:{1}——{0}<br/>", dItem.Id, dItem.GroupName); //} //else //{ // dItem.IsDel = 1; // dItem.IsShield = 1; // str.AppendFormat("多余(将删除):{1}——{0}<br/>", dItem.Id, dItem.GroupName); //} } else if (s == null && (dItem.IsShield ?? 0) == 1) { var sheildItem = sheildInfos.FirstOrDefault(x => x.工号 == dItem.Id.ToString()); if (sheildItem == null) { dItem.IsDel = 1; dItem.IsShield = 1; str.AppendFormat("清理(将删除):{1}——{0}<br/>", dItem.Id, dItem.GroupName); } } } } DBContext.SaveChanges(); rInfo.Message = str.ToString(); if (string.IsNullOrWhiteSpace(rInfo.Message)) { rInfo.Message = "没有更改"; } rInfo.IsSuccess = true; } } catch (Exception ex) { rInfo.Message = ex.Message; Json(rInfo); } return(Json(rInfo)); }