public Object StockModify([FromBody] List <Gift> giftTable) { try { using (DDContext context = new DDContext()) { foreach (var gift in giftTable) { context.Entry <Gift>(gift).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } return(new NewErrorModel() { error = new Error(0, "修改成功", "") { }, }); } } catch (Exception ex) { throw ex; } }
public NewErrorModel DownloadFileModel(DownloadFileModel downloadFileModel) { try { using (DDContext context = new DDContext()) { string url = string.Empty; if (ConfigurationManager.AppSettings["hao"].ToString() == "2") { url = "17e245o364.imwork.net:49415"; } else { url = System.Web.HttpContext.Current.Request.Url.Authority; } //生成下载链接 string downLoadLink = string.Format("{0}/ProjectNew/DownLoad?path=~/{1}", url, downloadFileModel.path); //推送盯盘下载链接 return(new NewErrorModel() { data = downLoadLink, error = new Error(0, "请复制链接到浏览器中下载!", "1") { }, }); } } catch (Exception ex) { throw ex; } }
public NewErrorModel ChangeBom([FromBody] List <Purchase> listPurchase) { try { using (DDContext context = new DDContext()) { string TaskId = listPurchase[0].TaskId.ToString(); List <Purchase> purchases = context.Purchase.Where(t => t.TaskId == TaskId).ToList(); context.Purchase.RemoveRange(purchases); context.SaveChanges(); context.Purchase.AddRange(listPurchase); context.SaveChanges(); return(new NewErrorModel() { error = new Error(0, "更新成功!", "") { }, }); } } catch (Exception ex) { return(new NewErrorModel() { error = new Error(2, ex.Message, "") { }, }); } }
public NewErrorModel Ding(string taskId) { try { using (DDContext context = new DDContext()) { FlowInfoServer flowInfoServer = new FlowInfoServer(); if (flowInfoServer.GetTasksState(taskId) == "已完成") { return(new NewErrorModel() { error = new Error(0, "流程已完成!", "") { }, }); } else { Tasks tasks = context.Tasks.Where(t => t.TaskId.ToString() == taskId && t.IsSend != true && t.State == 0).OrderBy(s => s.NodeId).FirstOrDefault(); return(new NewErrorModel() { data = tasks, error = new Error(0, "流程被退回!", "") { }, }); } } } catch (Exception ex) { throw ex; } }
public NewErrorModel GetAllProJect(string ApplyManId = null) { try { DDContext context = new DDContext(); List <ProjectInfo> listProjectInfo = new List <ProjectInfo>(); if (string.IsNullOrEmpty(ApplyManId)) { listProjectInfo = context.ProjectInfo.Where(p => p.ProjectState == "在研").ToList(); } else { listProjectInfo = context.ProjectInfo.Where(u => u.ApplyManId == ApplyManId && u.ProjectState == "在研").ToList(); } return(new NewErrorModel() { data = listProjectInfo, error = new Error(0, "读取成功!", "") { }, }); } catch (Exception ex) { throw ex; } }
public object DeleteById(int id) { try { EFHelper <NewsAndCases> eFHelper = new EFHelper <NewsAndCases>(); NewsAndCases newsAndCases = new NewsAndCases(); using (DDContext context = new DDContext()) { newsAndCases = context.NewsAndCases.Find(id); context.NewsAndCases.Remove(newsAndCases); context.SaveChanges(); } return(new NewErrorModel() { data = newsAndCases, error = new Error(0, "删除成功!", "") { }, }); } catch (Exception ex) { return(new NewErrorModel() { error = new Error(1, ex.Message, "") { }, }); } }
public NewErrorModel GetICItem(string Key) { try { //using (KisContext context = new KisContext()) //{ // var Quary = context.Database.SqlQuery<DingTalk.Models.KisModels.t_ICItem> // (string.Format("SELECT * FROM t_ICItem WHERE FName like '%{0}%' or FNumber like '%{1}%' or FModel like '%{2}%'", Key, Key, Key)).ToList(); // return JsonConvert.SerializeObject(Quary); //} using (DDContext context = new DDContext()) { var Quary = context.KisPurchase.Where(k => k.FName.Contains(Key) || k.FNumber.Contains(Key) || k.FModel.Contains(Key)).ToList(); return(new NewErrorModel() { data = Quary, error = new Error(0, "读取成功!", "") { }, }); } } catch (Exception ex) { return(new NewErrorModel() { error = new Error(2, ex.Message, "") { }, }); } }
public string ModifyPurchaseTable([FromBody] List <PurchaseTable> purchaseTableList) { try { using (DDContext context = new DDContext()) { foreach (PurchaseTable purchaseTable in purchaseTableList) { context.Entry <PurchaseTable>(purchaseTable).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } } return(JsonConvert.SerializeObject(new ErrorModel { errorCode = 0, errorMessage = "修改成功" })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new ErrorModel { errorCode = 1, errorMessage = ex.Message })); } }
public string SavePurchaseTable([FromBody] List <PurchaseTable> purchaseTableList) { try { using (DDContext context = new DDContext()) { foreach (PurchaseTable purchaseTable in purchaseTableList) { context.PurchaseTable.Add(purchaseTable); context.SaveChanges(); } } return(JsonConvert.SerializeObject(new ErrorModel { errorCode = 0, errorMessage = "保存成功" })); } catch (Exception ex) { return(JsonConvert.SerializeObject(new ErrorModel { errorCode = 1, errorMessage = ex.Message })); } }
/// <summary> /// 项目信息读取接口 /// </summary> /// <param name="ApplyManId">创建者Id(不传时默认查所有项目信息)</param> /// <returns></returns> /// 测试数据:/Project/GetAllProJect?ApplyManId=0935455445756597 public string GetAllProJect(string ApplyManId) { try { using (DDContext context = new DDContext()) { List <ProjectInfo> listProjectInfo = new List <ProjectInfo>(); if (string.IsNullOrEmpty(ApplyManId)) { listProjectInfo = context.ProjectInfo.Where(p => p.ProjectState == "在研").ToList(); } else { listProjectInfo = context.ProjectInfo.Where(u => u.ApplyManId == ApplyManId && u.ProjectState == "在研").ToList(); } return(JsonConvert.SerializeObject(listProjectInfo)); } } catch (Exception ex) { return(JsonConvert.SerializeObject(new ErrorModel { errorCode = 2, errorMessage = ex.Message })); } }
public string ProjectInfoModify(ProjectInfo projectInfo) { try { if (projectInfo != null) { using (DDContext context = new DDContext()) { context.Entry <ProjectInfo>(projectInfo).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } return(JsonConvert.SerializeObject(new ErrorModel { errorCode = 0, errorMessage = "修改成功" })); } else { return(JsonConvert.SerializeObject(new ErrorModel { errorCode = 1, errorMessage = "参数未传递" })); } } catch (Exception ex) { return(JsonConvert.SerializeObject(new ErrorModel { errorCode = 1, errorMessage = ex.Message })); } }
/// <summary> /// 流程大类读取 /// </summary> /// <returns></returns> public object GetFlowSort() { DDContext context = new DDContext(); var FlowSort = context.FlowSort.Where(u => u.IsEnable == 1 && u.State == 1 && u.DEPT_ID == "ALL"); return(FlowSort); }
/// <summary> /// 获取流程信息 /// </summary> /// <param name="FlowId"></param> /// <returns></returns> public Flows GetFlow(string FlowId) { using (DDContext context = new DDContext()) { return(context.Flows.Where(f => f.FlowId.ToString() == FlowId).FirstOrDefault()); } }
/// <summary> /// 获取当前流程状态 /// </summary> /// <param name="TaskId">流水号</param> /// <returns>0 未完成 1 已完成 2 被退回</returns> public string GetTasksState(string TaskId) { using (DDContext context = new DDContext()) { List <Tasks> tasksListBack = context.Tasks.Where(t => t.TaskId.ToString() == TaskId && t.IsBacked == true).ToList(); if (tasksListBack.Count > 0) { foreach (Tasks task in tasksListBack) { if (task.NodeId == 0) { return("已撤回"); } else { return("被退回"); } } } List <Tasks> tasksListFinished = context.Tasks.Where(t => t.TaskId.ToString() == TaskId && t.State == 0 && t.IsSend != true).ToList(); if (tasksListFinished.Count > 0) { return("未完成"); } else { return("已完成"); } } }
public object Add(Car car) { try { using (DDContext context = new DDContext()) { car.FinnalStartTime = DateTime.Now; car.FinnalEndTime = DateTime.Now; context.Car.Add(car); context.SaveChanges(); } return(new ErrorModel() { errorCode = 0, errorMessage = "添加成功" }); } catch (Exception ex) { return(new ErrorModel() { errorCode = 1, errorMessage = ex.Message }); } }
public string PurseTableRead(string TaskId, string PurchaseManId = "") { try { List <PurchaseTable> PurchaseTableList = new List <PurchaseTable>(); using (DDContext context = new DDContext()) { if (string.IsNullOrEmpty(PurchaseManId)) { PurchaseTableList = context.PurchaseTable.Where (p => p.TaskId == TaskId).ToList(); } else { PurchaseTableList = context.PurchaseTable.Where (p => p.TaskId == TaskId && p.PurchaseManId == PurchaseManId).ToList(); } } return(JsonConvert.SerializeObject(PurchaseTableList)); } catch (Exception ex) { return(JsonConvert.SerializeObject(new ErrorModel { errorCode = 1, errorMessage = ex.Message })); } }
public object Delete(dynamic obj) { try { using (DDContext context = new DDContext()) { var Id = Convert.ToInt32(obj.Id); Car car = context.Car.Find(Id); context.Car.Remove(car); context.SaveChanges(); } return(new ErrorModel() { errorCode = 0, errorMessage = "删除成功" }); } catch (Exception ex) { return(new ErrorModel() { errorCode = 1, errorMessage = ex.Message }); } }
public NewErrorModel Save(ProductionOrderTable productionOrderTable) { try { DDContext dDContext = new DDContext(); if (productionOrderTable.ProductionOrderDetails == null || productionOrderTable.ProductionOrderDetails.Count == 0) { return(new NewErrorModel() { error = new Error(1, "ProductionOrderDetail参数有误!", "") { }, }); } else { dDContext.ProductionOrderTable.Add(productionOrderTable); dDContext.ProductionOrderDetail.AddRange(productionOrderTable.ProductionOrderDetails); dDContext.SaveChanges(); } return(new NewErrorModel() { error = new Error(0, "保存成功!", "") { }, }); } catch (Exception ex) { throw ex; } }
public NewErrorModel ModifyPurchaseTable([FromBody] List <PurchaseTable> purchaseTableList) { try { using (DDContext context = new DDContext()) { foreach (PurchaseTable purchaseTable in purchaseTableList) { context.Entry <PurchaseTable>(purchaseTable).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } } return(new NewErrorModel() { error = new Error(0, "修改成功!", "") { }, }); } catch (Exception ex) { return(new NewErrorModel() { error = new Error(2, ex.Message, "") { }, }); } }
public NewErrorModel Modify(ProductionOrderTable productionOrderTable) { try { DDContext dDContext = new DDContext(); dDContext.Entry <ProductionOrderTable>(productionOrderTable).State = System.Data.Entity.EntityState.Modified; if (productionOrderTable.ProductionOrderDetails != null && productionOrderTable.ProductionOrderDetails.Count > 0) { foreach (var item in productionOrderTable.ProductionOrderDetails) { dDContext.Entry <ProductionOrderDetail>(item).State = System.Data.Entity.EntityState.Modified; } } dDContext.SaveChanges(); return(new NewErrorModel() { error = new Error(0, "修改成功!", "") { }, }); } catch (Exception ex) { throw ex; } }
public NewErrorModel SavePurchaseTable([FromBody] List <PurchaseTable> purchaseTableList) { try { using (DDContext context = new DDContext()) { foreach (PurchaseTable purchaseTable in purchaseTableList) { context.PurchaseTable.Add(purchaseTable); context.SaveChanges(); } } return(new NewErrorModel() { error = new Error(0, "保存成功!", "") { }, }); } catch (Exception ex) { return(new NewErrorModel() { error = new Error(2, ex.Message, "") { }, }); } }
public object GetRoleInfo(string RoleName) { try { using (DDContext context = new DDContext()) { if (string.IsNullOrEmpty(RoleName)) { var RoleList = context.Roles.ToList(); return(RoleList); } else { var RoleList = context.Roles.Where(r => r.RoleName.Contains(RoleName)).ToList(); var Quary = from r in RoleList select new { RoleName = r.RoleName, name = r.UserName, emplId = r.UserId }; return(Quary); } } } catch (Exception ex) { return(new ErrorModel() { errorCode = 0, errorMessage = ex.Message }); } }
public NewErrorModel CreatepProjectFiles() { DDContext dDContext = new DDContext(); List <ProjectInfo> projectInfoList = dDContext.ProjectInfo.ToList(); //矫正项目路径 foreach (var item in projectInfoList) { item.FilePath = $"\\UploadFile\\ProjectFile\\{item.CompanyName}\\{item.ProjectType}\\{item.ProjectSmallType}\\{item.ProjectName}\\"; dDContext.Entry <ProjectInfo>(item).State = System.Data.Entity.EntityState.Modified; } dDContext.SaveChanges(); List <ProjectInfo> projectInfoListNew = dDContext.ProjectInfo.ToList(); foreach (var item in projectInfoListNew) { AddProjectFile(item.FilePath); } return(new NewErrorModel() { error = new Error(0, "创建成功!", "") { }, }); }
public NewErrorModel Read(int pageSize = 5, int pageIndex = 1, string key = "") { using (DDContext context = new DDContext()) { int count = 0; List <ContextError> contextErrors = new List <ContextError>(); if (key == "") { count = context.ContextError.ToList().Count; contextErrors = context.ContextError.OrderByDescending(c => c.Id).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList(); } else { count = context.ContextError.Where(c => c.RequestUrl.Contains(key) || c.Id.ToString() == key).ToList().Count; contextErrors = context.ContextError.Where(c => c.RequestUrl.Contains(key) || c.Id.ToString() == key).OrderByDescending(c => c.Id).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList(); } return(new NewErrorModel() { count = count, data = contextErrors, error = new Error(0, "读取成功!", "") { }, }); } }
public NewErrorModel ProjectInfoModify(ProjectInfo projectInfo) { try { using (DDContext context = new DDContext()) { ProjectInfo projectInfoQuery = context.ProjectInfo.AsNoTracking().Where(p => p.ProjectId == projectInfo.ProjectId).FirstOrDefault(); if (projectInfoQuery.ProjectName != projectInfo.ProjectName) { //修改项目路径 projectInfo.FilePath = projectInfo.FilePath.Replace(projectInfoQuery.ProjectName, projectInfo.ProjectName); System.IO.Directory.Move(HttpContext.Current.Server.MapPath(projectInfoQuery.FilePath), HttpContext.Current.Server.MapPath(projectInfo.FilePath)); //projectInfoQuery = projectInfo; } context.Entry <ProjectInfo>(projectInfo).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } return(new NewErrorModel() { error = new Error(0, "修改成功!", "") { }, }); } catch (Exception ex) { throw ex; } }
public NewErrorModel Read(string TaskId) { try { using (DDContext context = new DDContext()) { List <DrawingChange> DrawingChangeList = context.DrawingChange.Where(c => c.TaskId == TaskId).ToList(); FileChange fileChange = context.FileChange.Where(c => c.TaskId == TaskId).FirstOrDefault(); return(new NewErrorModel() { data = new DrawingChangeTable() { DrawingChangeList = DrawingChangeList, fileChange = fileChange, }, error = new Error(0, "读取成功!", "") { }, }); } } catch (Exception ex) { throw ex; } }
public object QuaryVote(int?Id = 0) { try { using (DDContext context = new DDContext()) { if (Id == 0) { List <Vote> vote = context.Vote.ToList(); return(vote); } else { Vote vote = context.Vote.Find(Id); return(vote); } } } catch (Exception ex) { return(new ErrorModel() { errorCode = 1, errorMessage = ex.Message }); } }
public object Quary(string key) { try { using (DDContext context = new DDContext()) { if (string.IsNullOrEmpty(key)) { var Quary = context.Car.ToList(); return(Quary); } else { var Quary = context.Car.Where(c => c.Name.Contains(key) || c.CarNumber.Contains(key) || c.Color.Contains(key) || c.Type.Contains(key)).ToList(); return(Quary); } } } catch (Exception ex) { return(new ErrorModel() { errorCode = 1, errorMessage = ex.Message }); } }
public NewErrorModel LoadPurchase([FromBody] List <Purchase> listPurchase) { try { foreach (Purchase item in listPurchase) { using (DDContext context = new DDContext()) { context.Purchase.Add(item); context.SaveChanges(); } } return(new NewErrorModel() { error = new Error(0, "保存成功!", "") { }, }); } catch (Exception ex) { return(new NewErrorModel() { error = new Error(2, ex.Message, "") { }, }); } }
public NewErrorModel GetStock(string key = "") { try { using (DDContext context = new DDContext()) { List <Gift> giftTable = new List <Gift>(); if (key == "") { giftTable = context.Gift.ToList(); } else { giftTable = context.Gift.Where(g => g.GiftName.Contains(key) || g.Type.Contains(key)).ToList(); } return(new NewErrorModel() { count = giftTable.Count, data = giftTable, error = new Error(0, "读取成功!", "") { }, }); } } catch (Exception ex) { throw ex; } }