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