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;
}
}