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 TableModify(CarTable carTable) { try { using (DDContext context = new DDContext()) { carTable.FactKilometre = carTable.UseKilometres; Tasks tasks = context.Tasks.Where(t => t.TaskId.ToString() == carTable.TaskId && t.State == 0 && t.IsEnable == 1).FirstOrDefault(); if (tasks.NodeId == 4) { if (!string.IsNullOrEmpty(carTable.OccupyCarId) && !string.IsNullOrEmpty(carTable.FactKilometre)) { CarTable carTableOld = context.CarTable.Find(int.Parse(carTable.OccupyCarId)); carTableOld.FactKilometre = (float.Parse(carTableOld.FactKilometre) - float.Parse(carTable.FactKilometre)).ToString(); context.Entry <CarTable>(carTableOld).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } } context.Entry <CarTable>(carTable).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } return(new NewErrorModel() { error = new Error(0, "修改成功!", "") { }, }); } catch (Exception ex) { throw ex; } }
public object Modify(Car car) { try { using (DDContext context = new DDContext()) { if (context.Roles.Where(r => r.RoleName.Contains("车辆管理员") && r.UserId == car.ApplyManId).ToList().Count > 0 || context.Roles.Where(r => r.RoleName.Contains("超级管理员") && r.UserId == car.ApplyManId).ToList().Count > 0) { context.Entry <Car>(car).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); return(new NewErrorModel() { error = new Error(0, "修改成功!", "") { }, }); } else { return(new NewErrorModel() { error = new Error(1, "用户没有权限进行操作!", "") { }, }); } } } catch (Exception ex) { throw ex; } }
public NewErrorModel ChangeRemark(ChangeRemark changeRemark) { try { using (DDContext context = new DDContext()) { Tasks tasks = context.Tasks.Find(Int32.Parse(changeRemark.Id)); tasks.Remark = changeRemark.Remark; context.Entry <Tasks>(tasks).State = EntityState.Modified; context.SaveChanges(); } return(new NewErrorModel() { error = new Error(0, "修改成功!", "") { }, }); } catch (Exception ex) { return(new NewErrorModel() { error = new Error(1, ex.Message, "") { }, }); } }
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 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 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 async Task <IActionResult> PutPlayer(int id, Player player) { if (id != player.Id) { return(BadRequest()); } _context.Entry(player).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PlayerExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public NewErrorModel ModifyTable([FromBody] List <OfficeSupplies> officeSuppliesTableList) { try { using (DDContext context = new DDContext()) { foreach (OfficeSupplies officeSupplies in officeSuppliesTableList) { context.Entry <OfficeSupplies>(officeSupplies).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } } return(new NewErrorModel() { error = new Error(0, "修改成功!", "") { }, }); } catch (Exception ex) { return(new NewErrorModel() { error = new Error(1, 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 })); } }
public string ModifyTable([FromBody] List <OfficeSuppliesPurchase> officeSuppliesPurchaseTableList) { try { using (DDContext context = new DDContext()) { foreach (OfficeSuppliesPurchase officeSuppliesPurchase in officeSuppliesPurchaseTableList) { context.Entry <OfficeSuppliesPurchase>(officeSuppliesPurchase).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 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 StockReduce([FromBody] List <GiftTable> giftTable) { try { using (DDContext context = new DDContext()) { foreach (var gift in giftTable) { Gift gifts = context.Gift.Find(Int32.Parse(gift.GiftNo)); gifts.Stock = (Int32.Parse(gifts.Stock) - Int32.Parse(gift.GiftCount)).ToString(); context.Entry <Gift>(gifts).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } context.SaveChanges(); return(new NewErrorModel() { error = new Error(0, "消减成功", "") { }, }); } } catch (Exception ex) { throw ex; } }
public object Modify([FromBody] CreateProject createProject) { try { using (DDContext context = new DDContext()) { context.Entry <CreateProject>(createProject).State = EntityState.Modified; context.SaveChanges(); } return(new NewErrorModel() { error = new Error(0, "修改成功!", "") { }, }); } catch (Exception ex) { return(new NewErrorModel() { error = new Error(1, ex.Message, "") { }, }); } }
public object UpdatePDFState(string TaskId, string PDFState) { try { using (DDContext context = new DDContext()) { Tasks tasks = context.Tasks.Where(t => t.TaskId.ToString() == TaskId && t.NodeId == 0).First(); tasks.PdfState = PDFState; context.Entry <Tasks>(tasks).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); return(new ErrorModel() { errorCode = 0, errorMessage = "修改成功" }); } } catch (Exception ex) { return(new ErrorModel() { errorCode = 1, errorMessage = ex.Message }); } }
public Object TableModify([FromBody] List <Code> codeList) { try { using (DDContext context = new DDContext()) { foreach (var code in codeList) { context.Entry <Code>(code).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } return(new ErrorModel { errorCode = 0, errorMessage = "保存成功" }); } } catch (Exception ex) { return(new ErrorModel() { errorCode = 1, errorMessage = ex.Message }); } }
public NewErrorModel AsyncData() { try { DDContext dDContext = new DDContext(); while (true) { List <Evection> evections = dDContext.Database.SqlQuery <Evection>("select * from Evection where ContactPeople is null").ToList(); if (evections.Count > 0) { foreach (var item in evections) { item.ContactPeople = ""; dDContext.Entry <Evection>(item).State = EntityState.Modified; } dDContext.SaveChanges(); } Thread.Sleep(3000); } } catch (Exception) { throw; } }
public NewErrorModel ModifyRole(RoleOperator roleOperator) { try { using (DDContext context = new DDContext()) { if (context.Roles.Where(r => r.UserId == roleOperator.applyManId && r.RoleName == "超级管理员").ToList().Count > 0) { foreach (var item in roleOperator.roles) { if (item.RoleName.Contains("超级管理员")) { return(new NewErrorModel() { error = new Error(1, $"角色 {item.RoleName} 不允许修改!", "") { }, }); } context.Entry <Role>(item).State = System.Data.Entity.EntityState.Modified; } List <Roles> roles = context.Roles.ToList(); if (roleOperator.roles.Count > 0) { foreach (var item in roleOperator.roles) { List <Roles> rolesNew = roles.Where(t => t.RoleId == item.Id).ToList(); context.Roles.RemoveRange(rolesNew); foreach (var items in item.roles) { items.RoleName = item.RoleName; context.Roles.Add(items); } } } context.SaveChanges(); return(new NewErrorModel() { error = new Error(0, "修改成功!", "") { }, }); } else { return(new NewErrorModel() { error = new Error(1, "没有修改权限!", "") { }, }); } } } catch (Exception ex) { throw ex; } }
public object GetMonthReport(string StartTime, string EndTime, string UserId) { try { using (DDContext context = new DDContext()) { //查询时间段内的数据 List <CarTable> carTables = context.CarTable.Where(c => c.StartTime > DateTime.Parse(StartTime) && c.EndTime < DateTime.Parse(EndTime)).ToList(); //更新实际行驶路程 foreach (CarTable carTable in carTables) { if (!string.IsNullOrEmpty(carTable.OccupyCarId)) { CarTable catTb = context.CarTable.Find(carTable.OccupyCarId); catTb.UseKilometres = (Int32.Parse(catTb.UseKilometres) - Int32.Parse(carTable.UseKilometres)).ToString(); context.Entry <CarTable>(catTb).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } } //计算公里数 List <CarTable> carTableList = context.CarTable.ToList(); List <Tasks> tasksList = FlowInfoServer.ReturnUnFinishedTaskId("13"); //公车任务流 List <Tasks> taskList = new List <Tasks>(); List <Car> carList = context.Car.ToList(); foreach (Tasks tasks in tasksList) { if (tasks.NodeId == 0) { taskList.Add(tasks); } } var Quary = from t in taskList join c in carTableList on t.TaskId.ToString() equals c.TaskId join cars in carList on c.CarId equals cars.Id.ToString() select new { t.Dept, t.ApplyMan, c.StartTime, c.EndTime, cars.Name, c.MainContent, c.UseKilometres, cars.UnitPricePerKilometre, Price = Int32.Parse(c.UseKilometres) * cars.UnitPricePerKilometre }; return(JsonConvert.SerializeObject(Quary)); } } catch (Exception ex) { throw ex; } }
public object TableSave(CarTable carTable) { try { using (DDContext context = new DDContext()) { context.CarTable.Add(carTable); context.SaveChanges(); Car car = context.Car.Find(Int32.Parse(carTable.CarId)); //只保留五条最新数据 if (!string.IsNullOrEmpty(car.UseTimes)) { if (car.UseTimes.Split(',').Length < 5) { car.UseTimes = car.UseTimes + "," + carTable.StartTime + "~" + carTable.EndTime; car.UseMan = car.UseMan + "," + carTable.DrivingMan; } else { car.UseTimes = car.UseTimes.Substring(car.UseTimes.IndexOf(','), car.UseTimes.Length - car.UseTimes.IndexOf(',')); car.UseMan = car.UseMan.Substring(car.UseMan.IndexOf(','), car.UseMan.Length - car.UseMan.IndexOf(',')); car.UseTimes = car.UseTimes + "," + carTable.StartTime + "~" + carTable.EndTime; car.UseMan = car.UseMan + "," + carTable.DrivingMan; } } else { car.UseTimes = carTable.StartTime + "-" + carTable.EndTime; car.UseMan = carTable.DrivingMan; } car.OccupyCarId = carTable.CarId; car.FinnalStartTime = carTable.StartTime; car.FinnalEndTime = carTable.EndTime; context.Entry <Car>(car).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } return(new ErrorModel() { errorCode = 0, errorMessage = "添加成功" }); } catch (Exception ex) { return(new ErrorModel() { errorCode = 1, errorMessage = ex.Message }); } }
public string LoadUserInfo() { try { var sr = new StreamReader(Request.InputStream); var stream = sr.ReadToEnd(); if (stream == null) { string filepath = Server.MapPath("~/UserInfoConfig.json"); string json = JsonHelper.GetFileJson(filepath); if (!string.IsNullOrEmpty(json)) //数据不为空存储对象到Session { UserInfo userInfo = JsonHelper.JsonToObject <UserInfo>(json); Session["userInfo"] = userInfo; } return(JsonConvert.SerializeObject(new ErrorModel { errorCode = 0, errorMessage = "载入测试用户数据成功" })); } else { UserInfo userInfo = JsonHelper.JsonToObject <UserInfo>(stream); userInfo.FinnalLoginTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); //保存实体 using (DDContext context = new DDContext()) { DbEntityEntry <UserInfo> entityEntry = context.Entry <UserInfo>(userInfo); entityEntry.State = EntityState.Added; context.SaveChanges(); } Session["userInfo"] = userInfo; return(JsonConvert.SerializeObject(new ErrorModel { errorCode = 1, errorMessage = "载入用户数据成功" })); } } catch (Exception ex) { return(JsonConvert.SerializeObject(new ErrorModel { errorCode = 2, errorMessage = ex.Message })); } }
public object OverTimeTableModify([FromBody] OverTime overTime) { try { using (DDContext context = new DDContext()) { context.Entry <OverTime>(overTime).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } return(new ErrorModel() { errorCode = 0, errorMessage = "修改成功" }); } catch (Exception ex) { throw ex; } }
public object Modify([FromBody] Cooperate cooperate) { try { using (DDContext context = new DDContext()) { context.Entry <Cooperate>(cooperate).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } return(new NewErrorModel() { error = new Error(0, "修改成功!", "") { }, }); } catch (Exception ex) { throw ex; } }
public Object StockMove(Gift gift) { try { using (DDContext context = new DDContext()) { context.Entry <Gift>(gift).State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); return(new NewErrorModel() { error = new Error(0, "修改成功", "") { }, }); } } catch (Exception ex) { throw ex; } }
public object Modify([FromBody] MaterialRelease evection) { try { using (DDContext context = new DDContext()) { context.Entry <MaterialRelease>(evection).State = EntityState.Modified; context.SaveChanges(); } return(new NewErrorModel() { error = new Error(0, "修改成功!", "") { }, }); } catch (Exception ex) { throw ex; } }
public NewErrorModel UpdatePDFState(string TaskId, string PDFState) { try { using (DDContext context = new DDContext()) { Tasks tasks = context.Tasks.Where(t => t.TaskId.ToString() == TaskId && t.NodeId == 0).First(); tasks.PdfState = PDFState; context.Entry <Tasks>(tasks).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); return(new NewErrorModel() { error = new Error(0, "更新成功!", "") { }, }); } } catch (Exception ex) { throw ex; } }
public object TableModify(CarTable carTable) { try { using (DDContext context = new DDContext()) { context.Entry <CarTable>(carTable).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } return(new ErrorModel() { errorCode = 0, errorMessage = "修改成功" }); } catch (Exception ex) { return(new ErrorModel() { errorCode = 1, errorMessage = ex.Message }); } }
/// <summary> /// 4.0 修改,如: /// T u = new T() { uId = 1, uLoginName = "asdfasdf" }; /// this.Modify(u, "uLoginName"); /// </summary> /// <param name="model">要修改的实体对象</param> /// <param name="proNames">要修改的 属性 名称</param> /// <returns></returns> public int Modify(T model, params string[] proNames) { //4.1将 对象 添加到 EF中 DbEntityEntry entry = db.Entry <T>(model); if (proNames.Length == 0) { entry.State = EntityState.Modified; return(db.SaveChanges()); } else { //4.2先设置 对象的包装 状态为 Unchanged entry.State = EntityState.Unchanged; //4.3循环 被修改的属性名 数组 foreach (string proName in proNames) { //4.4将每个 被修改的属性的状态 设置为已修改状态;后面生成update语句时,就只为已修改的属性 更新 entry.Property(proName).IsModified = true; } //4.4一次性 生成sql语句到数据库执行 return(db.SaveChanges()); } }
public object ChangeVote([FromBody] Vote vote) { try { using (DDContext context = new DDContext()) { context.Entry <Vote>(vote).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); } return(new ErrorModel() { errorCode = 0, errorMessage = "修改投票成功" }); } catch (Exception ex) { return(new ErrorModel() { errorCode = 1, errorMessage = ex.Message }); } }
public NewErrorModel Mofify(Tables tablle) { try { using (DDContext dataContext = new DDContext()) { if (tablle != null) { if (tablle.operateType == OperateType.None) { return(new NewErrorModel() { error = new Error(1, "请尝试修改OperateType参数!", "") { }, });; } if (tablle.operateType == OperateType.Add) { return(Save(tablle)); } //动态拼接创建表Sql SqlHelper sqlHelper = new SqlHelper(); string strSql = string.Empty; Tables tablleOld = dataContext.Tables.AsNoTracking().Where(t => t.ID == tablle.ID).FirstOrDefault(); if (tablle.operateType == OperateType.Modify) { strSql = sqlHelper.ModifyTable(tablle, tablleOld); } //删除表处理 if (tablle.operateType == OperateType.Delete) { //判断表是否存在防止误操作 if (dataContext.Tables.Where(t => t.TableName == tablle.TableName).ToList().Count == 0) { return(new NewErrorModel() { error = new Error(0, "表不存在!", "") { }, }); } } int iResult = dataContext.Database.ExecuteSqlCommand(strSql); //删除表处理 if (tablle.operateType == OperateType.Delete) { dataContext.Tables.Remove(dataContext.Tables.Find(tablle.ID)); dataContext.TableInfo.RemoveRange(dataContext.TableInfo.Where(t => t.TableID == tablle.ID)); dataContext.SaveChanges(); return(new NewErrorModel() { error = new Error(0, "删除成功!", "") { }, }); } //记录执行Sql sqlHelper.SaveSqlExe(tablle, strSql, dataContext); //修改实体信息 tablleOld = tablle; dataContext.Entry <Tables>(tablleOld).State = System.Data.Entity.EntityState.Modified; dataContext.SaveChanges(); string strSqltablleInfos = string.Empty; if (tablle.tableInfos != null && tablle.tableInfos.Count > 0) { strSqltablleInfos = sqlHelper.ModifyTableInfo(tablle.tableInfos, tablle); int iResultstrSqltablleInfos = dataContext.Database.ExecuteSqlCommand(strSqltablleInfos); //记录执行Sql sqlHelper.SaveSqlExe(tablle, strSqltablleInfos, dataContext); //修改实体信息 foreach (var item in tablle.tableInfos) { switch (item.operateType) { case OperateType.Add: dataContext.TableInfo.Add(item); break; case OperateType.Delete: dataContext.TableInfo.Remove(dataContext.TableInfo.Find(item.ID)); break; case OperateType.Modify: dataContext.Entry <TableInfo>(item).State = System.Data.Entity.EntityState.Modified; break; default: break; } } dataContext.SaveChanges(); } } else { return(new NewErrorModel() { error = new Error(1, "表参数格式有误!", "") { }, }); } } return(new NewErrorModel() { error = new Error(0, "修改成功!", "") { }, }); } catch (Exception) { throw; } }