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