public void AddProductUPHInfo(UPHInfo itemui) { string methodName = MethodBase.GetCurrentMethod().Name; BaseLog.LoggingBegin(logger, methodName); try { Entity.Repository.Meta.IMESSKU.UPH items = new Entity.Repository.Meta.IMESSKU.UPH { Process = itemui.Process, Attend_normal = itemui.Attend_normal, Family = itemui.Family, ST = itemui.ST, NormalUPH = itemui.NormalUPH, Cycle = itemui.Cycle, Remark = itemui.Remark, Special = itemui.Special, Editor = itemui.Editor, Cdt = itemui.Cdt, Udt = itemui.Udt }; using (UnitOfWork uow = new UnitOfWork()) { IRepository<Entity.Repository.Meta.IMESSKU.UPH> ecoModelRep = new Repository<Entity.Repository.Meta.IMESSKU.UPH>("UPHDBServer"); ecoModelRep.Insert(items); uow.Commit(); } } catch (Exception e) { BaseLog.LoggingError(logger, MethodBase.GetCurrentMethod(), e); throw; } finally { BaseLog.LoggingEnd(logger, methodName); } }
public IList<ProductUPHInfo> GetProductUPHInfoList(DateTime fromtime, DateTime totime) { string methodName = MethodBase.GetCurrentMethod().Name; BaseLog.LoggingBegin(logger, methodName); IList<ProductUPHInfo> ret = new List<ProductUPHInfo>(); try { using (UnitOfWork uow = new UnitOfWork()) { IRepository<ProductUPH> ecoModelRep = new Repository<ProductUPH>("UPHDBServer");//连接字符串 查询ProductUPH 表的数据 ret = (from q in ecoModelRep.Query() where q.Date >= fromtime && q.Date <= totime select new ProductUPHInfo { ID = q.ID, Date = q.Date, Line = q.Line, Lesson = q.Lesson, TimeRange = q.TimeRange, Family = q.Family, ProductRatio = q.ProductRatio }).ToList(); } return ret; } catch (Exception e) { BaseLog.LoggingError(logger, MethodBase.GetCurrentMethod(), e); throw; } finally { BaseLog.LoggingEnd(logger, methodName); } }
public IList<AlarmInfo> GetAllAlarmInfo() { string methodName = MethodBase.GetCurrentMethod().Name; BaseLog.LoggingBegin(logger, methodName); IList<AlarmInfo> ret = new List<AlarmInfo>(); try { using (UnitOfWork uow = new UnitOfWork()) { IRepository<Alarm> ecoModelRep = new Repository<Alarm>("UPHDBServer");//连接字符串 查询ProductUPH 表的数据 ret = (from q in ecoModelRep.Query() select new AlarmInfo { ID = q.ID, process = q.Process, Class = q.Class, PdLine = q.PdLine, BeginTime = q.BeginTime, EndTime = q.EndTime, Status = q.Status, Remark = q.Remark, Editor = q.Editor, Cdt = q.Cdt, Udt = q.Udt }).ToList(); } return ret; } catch (Exception e) { BaseLog.LoggingError(logger, MethodBase.GetCurrentMethod(), e); throw; } finally { BaseLog.LoggingEnd(logger, methodName); } }
public void AddAlarmlog(AlarmInfoLog itemui) { string methodName = MethodBase.GetCurrentMethod().Name; BaseLog.LoggingBegin(logger, methodName); try { AlarmLog items = new AlarmLog { Process = itemui.process, Class = itemui.Class, PdLine = itemui.PdLine, BeginTime = itemui.BeginTime, EndTime = itemui.EndTime, Status = itemui.Status, Remark = itemui.Remark, Editor = itemui.Editor, Cdt = itemui.Cdt, }; using (UnitOfWork uow = new UnitOfWork()) { IRepository<AlarmLog> ecoModelRep = new Repository<AlarmLog>("UPHDBServer"); ecoModelRep.Insert(items); uow.Commit(); } } catch (Exception e) { BaseLog.LoggingError(logger, MethodBase.GetCurrentMethod(), e); throw; } finally { BaseLog.LoggingEnd(logger, methodName); } }
public void DelAlarmInfo(AlarmInfo itemui) { string methodName = MethodBase.GetCurrentMethod().Name; BaseLog.LoggingBegin(logger, methodName); try { Alarm items = new Alarm { ID=itemui.ID }; using (UnitOfWork uow = new UnitOfWork()) { IRepository<Alarm> ecoModelRep = new Repository<Alarm>("UPHDBServer"); ecoModelRep.Delete(items, true);//删掉记录 根据设置的条件 uow.Commit(); } } catch (Exception e) { BaseLog.LoggingError(logger, MethodBase.GetCurrentMethod(), e); throw; } finally { BaseLog.LoggingEnd(logger, methodName); } }
public void AddProductUPHInfo(ProductUPHInfo itemui) { string methodName = MethodBase.GetCurrentMethod().Name; BaseLog.LoggingBegin(logger, methodName); try { ProductUPH items = new ProductUPH { Date = itemui.Date, Line = itemui.Line, Lesson = itemui.Lesson, TimeRange = itemui.TimeRange, Family = itemui.Family, ProductRatio = itemui.ProductRatio }; using (UnitOfWork uow = new UnitOfWork()) { IRepository<ProductUPH> ecoModelRep = new Repository<ProductUPH>("UPHDBServer"); ecoModelRep.Insert(items); uow.Commit(); } } catch (Exception e) { BaseLog.LoggingError(logger, MethodBase.GetCurrentMethod(), e); throw; } finally { BaseLog.LoggingEnd(logger, methodName); } }
public List<ProductQty> GetProductQty() { string methodName = MethodBase.GetCurrentMethod().Name; BaseLog.LoggingBegin(logger, methodName); List<ProductQty> ret = new List<ProductQty>(); try { using (UnitOfWork uow = new UnitOfWork()) { IRepository<ProductQty> ecoModelRep = new Repository<ProductQty>("UPHDBServer");//连接字符串 查询ProductUPH 表的数据 ret = (from q in ecoModelRep.Query() select q).OrderBy(x => x.ShipDate).ToList(); } return ret; } catch (Exception e) { BaseLog.LoggingError(logger, MethodBase.GetCurrentMethod(), e); throw; } finally { BaseLog.LoggingEnd(logger, methodName); } }
public List<Efficiency_Process_Hour> GetEfficiency_Process_Hour(string Process, DateTime begin, DateTime end) { string methodName = MethodBase.GetCurrentMethod().Name; BaseLog.LoggingBegin(logger, methodName); List<Efficiency_Process_Hour> ret = new List<Efficiency_Process_Hour>(); try { using (UnitOfWork uow = new UnitOfWork()) { IRepository<Efficiency_Process_Hour> ecoModelRep = new Repository<Efficiency_Process_Hour>("UPHDBServer");//连接字符串 查询ProductUPH 表的数据 ret = (from q in ecoModelRep.Query() where Convert.ToDateTime(q.Dt + " " + q.Hour.Trim().PadLeft(2, '0') + ":00") >= begin && Convert.ToDateTime(q.Dt + " " + q.Hour.Trim().PadLeft(2, '0') + ":00") <= end && q.Process == Process select q).OrderBy(x=>x.Dt).ThenBy(y=>Convert.ToInt32(y.Hour)).ToList(); } return ret; } catch (Exception e) { BaseLog.LoggingError(logger, MethodBase.GetCurrentMethod(), e); throw; } finally { BaseLog.LoggingEnd(logger, methodName); } }
public List<Efficiency_Day> GetEfficiency_Day(string line, string Process, DateTime begin, DateTime end) { string methodName = MethodBase.GetCurrentMethod().Name; BaseLog.LoggingBegin(logger, methodName); List<Efficiency_Day> ret = new List<Efficiency_Day>(); try { using (UnitOfWork uow = new UnitOfWork()) { IRepository<Efficiency_Day> ecoModelRep = new Repository<Efficiency_Day>("UPHDBServer");//连接字符串 查询ProductUPH 表的数据 ret = (from q in ecoModelRep.Query() where Convert.ToDateTime(q.Dt) >= begin && Convert.ToDateTime(q.Dt) <= end && q.PdLine == line && q.Process == Process select q).OrderBy(x=>x.Dt).ToList(); } return ret; } catch (Exception e) { BaseLog.LoggingError(logger, MethodBase.GetCurrentMethod(), e); throw; } finally { BaseLog.LoggingEnd(logger, methodName); } }
public void DelProductUPHInfo(UPHInfo itemui) { string methodName = MethodBase.GetCurrentMethod().Name; BaseLog.LoggingBegin(logger, methodName); try { Entity.Repository.Meta.IMESSKU.UPH items = new Entity.Repository.Meta.IMESSKU.UPH { Process = itemui.Process, Family = itemui.Family, Special = itemui.Remark, }; using (UnitOfWork uow = new UnitOfWork()) { IRepository<Entity.Repository.Meta.IMESSKU.UPH> ecoModelRep = new Repository<Entity.Repository.Meta.IMESSKU.UPH>("UPHDBServer"); var ret = from q in ecoModelRep.Query() where q.Process == itemui.Process && q.Family == itemui.Family && q.Special == itemui.Special select new UPHInfo { ID = q.ID, Process = q.Process, Attend_normal = q.Attend_normal, Family = q.Family, ST = q.ST.ToString(), NormalUPH = q.NormalUPH, Cycle = q.Cycle.ToString(), Remark = q.Remark, Special = q.Special, Editor = q.Editor, Cdt = q.Cdt, Udt = q.Udt }; var first = ret.First(); items.ID = first.ID; items.Process = first.Process; items.Attend_normal = first.Attend_normal; items.ST = first.ST; items.NormalUPH = first.NormalUPH; items.Cycle = first.Cycle; items.Remark = first.Remark; items.Special = first.Special; items.Editor = first.Editor; items.Cdt = first.Cdt; items.Udt = first.Udt; //IRepository<Entity.Repository.Meta.IMESSKU.UPH> ecoModelRep = new Repository<Entity.Repository.Meta.IMESSKU.UPH>("UPHDBServer"); ecoModelRep.Delete(items, true);//删掉记录 根据设置的条件 uow.Commit(); } } catch (Exception e) { BaseLog.LoggingError(logger, MethodBase.GetCurrentMethod(), e); throw; } finally { BaseLog.LoggingEnd(logger, methodName); } }
public IList<UPHInfo> GetProductUPHInfoList(UPHInfo item) { string methodName = MethodBase.GetCurrentMethod().Name; BaseLog.LoggingBegin(logger, methodName); IList<UPHInfo> ret = new List<UPHInfo>(); try { using (UnitOfWork uow = new UnitOfWork()) { IRepository<Entity.Repository.Meta.IMESSKU.UPH> ecoModelRep = new Repository<Entity.Repository.Meta.IMESSKU.UPH>("UPHDBServer");//连接字符串 查询ProductUPH 表的数据 ret = (from q in ecoModelRep.Query() where q.Process == item.Process && q.Family == item.Family && q.Special == item.Special select new UPHInfo { Process = q.Process, Attend_normal = q.Attend_normal, Family = q.Family, ST = q.ST.ToString(), NormalUPH = q.NormalUPH, Cycle = q.Cycle.ToString(), Remark = q.Remark, Special = q.Special, Editor = q.Editor, Cdt = q.Cdt, Udt = q.Udt }).ToList(); } return ret; } catch (Exception e) { BaseLog.LoggingError(logger, MethodBase.GetCurrentMethod(), e); throw; } finally { BaseLog.LoggingEnd(logger, methodName); } }
public void UpdateProductUPHInfo(UPHInfo itemui) { string methodName = MethodBase.GetCurrentMethod().Name; BaseLog.LoggingBegin(logger, methodName); try { IRepository<Entity.Repository.Meta.IMESSKU.UPH> ecoModelRep = new Repository<Entity.Repository.Meta.IMESSKU.UPH>("UPHDBServer"); var ret = from q in ecoModelRep.Query() where q.Process == itemui.Process && q.Family == itemui.Family && q.Special == itemui.Special select new UPHInfo { ID = q.ID, Process = q.Process, Attend_normal = q.Attend_normal, Family = q.Family, ST = q.ST.ToString(), NormalUPH = q.NormalUPH, Cycle = q.Cycle.ToString(), Remark = q.Remark, Special = q.Remark, Editor = q.Editor, Cdt = q.Cdt, Udt = q.Udt }; var first = ret.First(); Entity.Repository.Meta.IMESSKU.UPH items = new Entity.Repository.Meta.IMESSKU.UPH { ID = first.ID, Process = itemui.Process, Attend_normal = itemui.Attend_normal, Family = itemui.Family, ST = itemui.ST, NormalUPH = itemui.NormalUPH, Cycle = itemui.Cycle, Remark = itemui.Remark, Special = itemui.Special, Editor = itemui.Editor, Cdt = first.Cdt, Udt = itemui.Udt }; using (UnitOfWork uow = new UnitOfWork()) { ecoModelRep.Update(items); uow.Commit(); } } catch (Exception e) { BaseLog.LoggingError(logger, MethodBase.GetCurrentMethod(), e); throw; } finally { BaseLog.LoggingEnd(logger, methodName); } }
public void AddDinnerLogInfo(DinnerLogInfo q) { string methodName = MethodBase.GetCurrentMethod().Name; BaseLog.LoggingBegin(logger, methodName); try { DinnerLog items = new DinnerLog { ID = q.ID, Process = q.Process, Type = q.Type, Class = q.Class, PdLine = q.PdLine, BeginTime = q.BeginTime, EndTime = q.EndTime, Remark = q.Remark, Editor = q.Editor, Cdt = q.Cdt }; using (UnitOfWork uow = new UnitOfWork()) { IRepository<DinnerLog> ecoModelRep = new Repository<DinnerLog>("UPHDBServer"); ecoModelRep.Insert(items); uow.Commit(); } } catch (Exception e) { BaseLog.LoggingError(logger, MethodBase.GetCurrentMethod(), e); throw; } finally { BaseLog.LoggingEnd(logger, methodName); } }