private void gridView_CustomUnboundColumnData(object sender, DevExpress.XtraGrid.Views.Base.CustomColumnDataEventArgs e) { if (m_isHwgr) { WorldToHwgr row = gridView.GetRow(e.RowHandle) as WorldToHwgr; if (e.IsGetData && row != null) { if (e.Column == gc_Parent) { e.Value = m_context.TakeStoreStructure.GetWorld(row.WorldID).Name; } } } else { HwgrToWgr row = gridView.GetRow(e.RowHandle) as HwgrToWgr; if (e.IsGetData && row != null) { if (e.Column == gc_Parent) { e.Value = m_context.TakeStoreStructure.GetHwgr(row).Name; } } } }
public _HwgrToWorld(WorldToHwgr entity) { _entity = entity; if (!_entity.IsNew) { _state = RecordState.UnModified; } }
public _HwgrToWorld CreateCopy() { WorldToHwgr wth = new WorldToHwgr(); BaseEntity.CopyTo(_entity, wth); wth.ID = 0; return(new _HwgrToWorld(wth)); }
public AssignResult HWGRToWorldAssign(long storeID, long world_id, long hwgr_id, DateTime beginTime, DateTime endTime) { AssignResult result = new AssignResult(); result.Result = AResult.Error; using (IDbCommand command = CreateCommand()) { command.CommandText = "spHWGR_World_Assign"; command.CommandType = CommandType.StoredProcedure; SqlParameter p1 = new SqlParameter("@StoreID", SqlDbType.BigInt, 8); p1.Value = storeID; command.Parameters.Add(p1); SqlParameter p2 = new SqlParameter("@World_ID", SqlDbType.BigInt, 8); p2.Value = world_id; command.Parameters.Add(p2); SqlParameter p3 = new SqlParameter("@HWGR_ID", SqlDbType.BigInt, 8); p3.Value = hwgr_id; command.Parameters.Add(p3); SqlParameter p4 = new SqlParameter("@BeginTime", SqlDbType.SmallDateTime, 4); p4.Value = beginTime; command.Parameters.Add(p4); SqlParameter p5 = new SqlParameter("@EndTime", SqlDbType.SmallDateTime, 4); p5.Value = endTime; command.Parameters.Add(p5); SqlParameter importResult = new SqlParameter("@result", SqlDbType.Int, 4); importResult.Direction = ParameterDirection.Output; command.Parameters.Add(importResult); using (IDataReader reader = command.ExecuteReader(CommandBehavior.SequentialAccess)) { List <WorldToHwgr> list = new List <WorldToHwgr>(); while (reader.Read()) { WorldToHwgr value = new WorldToHwgr(); value.ID = reader.GetInt64(0); value.StoreID = reader.GetInt64(1); value.WorldID = reader.GetInt64(2); value.HWGR_ID = reader.GetInt64(3); value.BeginTime = reader.GetDateTime(4); value.EndTime = reader.GetDateTime(5); value.Import = reader.GetBoolean(6); list.Add(value); } reader.NextResult(); int res = (int)importResult.Value; if (res < 0) { result.Result = AResult.Error; } result.Data = list; } } _WorldToHwgrDao.OnDaoInvalidateWholeCache(); return(result); }
public override bool Commit() { long worldID = (long)edWorld.EditValue; WorldToHwgr attach = ClientEnvironment.WorldToHWGRService.CreateEntity(); attach.BeginTime = uc.BeginTime; attach.EndTime = uc.EndTime; attach.HWGR_ID = (long)EditHWGR.EditValue; attach.Import = false; attach.StoreID = worldID; m_entityName = EditHWGR.Text; m_attached = attach = ClientEnvironment.WorldToHWGRService.Save(attach); return(true); }
internal static HWGR GetHwgrEntity(WorldToHwgr hwgr) { HWGR entity = GetHWGRByID(hwgr.HWGR_ID); if (entity == null) { foreach (HWGR var in Instance.m_diction.Values) { if (var.ID == hwgr.HWGR_ID) { entity = var; break; } } } return(entity); }
public WorldToHwgr GetEntityByHwgrAndDate(long worldid, long hwgrid, DateTime date) { WorldToHwgr wth = null; for (int i = 0; i < _innerlist.Count; i++) { wth = _innerlist[i]; if (wth.WorldID == worldid && wth.HWGR_ID == hwgrid) { if (wth.BeginTime.Date <= date && date <= wth.EndTime.Date) { return(wth); } } } return(null); }
public void ReBuildByHwgr(long hwgrid, BindingTemplate <BaseTreeItem> lst) { if (lst != null && lst.Count > 0) { WorldToHwgr entity = hwgrList.GetEntityByHwgrAndDate(WorldID, hwgrid, m_filterDate); for (int i = 0; i < lst.Count; i++) { if (lst[i].IsHwgr) { HwgrTreeItem item = (lst[i] as HwgrTreeItem); if (item.Hwgr.HWGR_ID == hwgrid) { if (entity != null) { item.Hwgr = entity; } else { RemoveChilds(item.ID, lst); lst.Remove(item); lst.ClearRemoveList(); } return; } } } // new item if (entity != null) { HwgrTreeItem item = new HwgrTreeItem(entity, 0); lst.Add(item); foreach (HwgrToWgr htw in wgrList) { if (htw.HWGR_ID == hwgrid) { if (htw.BeginTime.Date <= m_filterDate && m_filterDate <= htw.EndTime.Date) { lst.Add(new WgrTreeItem(htw, item.ID)); } } } } } }
public List <WorldToHwgr> GetHwgrByWorldAndDate(long worldid, DateTime date) { List <WorldToHwgr> resultList = new List <WorldToHwgr>(10); WorldToHwgr wth = null; for (int i = 0; i < _innerlist.Count; i++) { wth = _innerlist[i]; if (wth.WorldID == worldid) { if (wth.BeginTime.Date <= date && date <= wth.EndTime.Date) { resultList.Add(wth); } } } return(resultList); }
protected void StopWorkingHwgr() { dragHWGR.EndTime = DateTime.Now; try { WorldToHwgr first = ClientEnvironment.WorldToHWGRService.FindById(dragHWGR.ID); if (first != null) { first.EndTime = DateTime.Now; ClientEnvironment.WorldToHWGRService.SaveOrUpdate(first); } } catch (Exception ex) { XtraMessageBox.Show(ex.Message, ex.GetType().ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error); } }
protected override void EntityChanged() { WorldToHwgr hwgr = Entity as WorldToHwgr; HwgrToWgr wgr = Entity as HwgrToWgr; if (hwgr != null) { List <WorldToHwgr> list = ClientEnvironment.WorldToHWGRService .GetWorldToHwgrFiltered(hwgr.StoreID, hwgr.WorldID, hwgr.HWGR_ID); gridControl.DataSource = list; lbCaption.Text = string.Format("{0} -> {1} -> {2}", ClientEnvironment.StoreService.FindById(hwgr.StoreID).Name, ClientEnvironment.WorldService.FindById(hwgr.WorldID).Name, ClientEnvironment.HWGRService.FindById(hwgr.HWGR_ID).Name); } else if (wgr != null) { } }
public void NewAssignHwgrToWorld() { HwgrTreeItem item = null; if (IsHwgrFocused) { item = FocusedEntity as HwgrTreeItem; } WorldToHwgr newitem = new WorldToHwgr(); newitem.StoreID = m_context.Store.ID; if (item != null) { newitem.HWGR_ID = item.Hwgr.HWGR_ID; newitem.WorldID = item.Hwgr.WorldID; newitem.BeginTime = DateTimeHelper.GetNextMonday(DateTime.Today); newitem.EndTime = DateTimeSql.SmallDatetimeMax; } else { newitem.BeginTime = DateTime.Today; newitem.EndTime = DateTimeSql.SmallDatetimeMax; newitem.HWGR_ID = m_context.WorldToHwgr.HWGR_ID; newitem.WorldID = m_context.WorldToHwgr.WorldID; } using (FormAssignHwgrToWorld form = new FormAssignHwgrToWorld()) { form.Context = m_context; form.Entity = newitem; if (form.ShowDialog() == DialogResult.OK) { treeList.BeginUpdate(); m_context.TakeStoreStructure.ReBuildByHwgr(newitem.HWGR_ID, (treeList.DataSource as BindingTemplate <BaseTreeItem>)); EntityChanged(); treeList.EndUpdate(); } } }
/* private void CopyEntity(WorldToHwgr source, WorldToHwgr dest) * { * * dest.ID = source.ID; * dest.HWGR_ID = source.HWGR_ID; * dest.HwgrName = source.HwgrName; * dest.Import = source.Import; * dest.StoreID = source.StoreID; * dest.WorldID = source.WorldID; * dest.BeginTime = source.BeginTime; * dest.EndTime = source.EndTime; * * } */ public override bool Commit() { if (IsValid()) { if (IsModified()) { WorldToHwgr entity = new WorldToHwgr(); WorldToHwgr.CopyTo(EntityWorldToHwgr, entity); //CopyEntity(EntityWorldToHwgr, entity); entity.ID = 0; entity.WorldID = WorldId; entity.HWGR_ID = HwgrId; entity.BeginTime = BeginTime; entity.EndTime = EndTime; try { List <WorldToHwgr> lst = ClientEnvironment.WorldToHWGRService.InsertRelation(entity); if (lst != null) { Context.TakeStoreStructure.MergeWorldToHwgr(lst); } //CopyEntity(entity, EntityWorldToHwgr); WorldToHwgr.CopyTo(entity, EntityWorldToHwgr); EntityWorldToHwgr.HwgrName = hwgrLookUpCtrl.Text; Modified = true; return(base.Commit()); } catch (ValidationException) { ErrorMessage(GetLocalized("ErrorDateRangeIntersect")); return(false); } } else { return(base.Commit()); } } return(false); }
public HWGR GetHwgr(WorldToHwgr hwgr) { return(HwgrManager.GetHwgrEntity(hwgr)); }
public override bool Commit() { try { DateTime begin = BeginTime, end = EndTime; Utility.AssignWeek(ref begin, ref end); BeginTime = begin; EndTime = end; switch (m_assignEnum) { case AssignEnum.ThisHwgrToWgr: case AssignEnum.ThisWgrToHWGR: HwgrToWgr assign = ClientEnvironment.HwgrToWgrService.CreateEntity(); assign.BeginTime = BeginTime; assign.EndTime = EndTime; assign.HWGR_ID = (long)edParent.EditValue; assign.Import = false; assign.StoreID = m_storeID; assign.WGR_ID = (long)edChild.EditValue; ClientEnvironment.HwgrToWgrService.Save(assign); m_assigned = new WgrTreeItem(assign, assign.HWGR_ID); break; case AssignEnum.ThisHwgrToWorld: WorldToHwgr assign2 = ClientEnvironment.WorldToHWGRService.CreateEntity(); assign2.BeginTime = BeginTime; assign2.EndTime = EndTime; assign2.HWGR_ID = (long)edChild.EditValue; assign2.Import = false; assign2.StoreID = m_storeID; assign2.WorldID = (Entity as WorldToHwgr).WorldID; ClientEnvironment.WorldToHWGRService.Save(assign2); m_assigned = new HwgrTreeItem(assign2, 0); break; case AssignEnum.WorldHwgrDisable: DateTime t1 = timeRange.BeginTime, t2 = timeRange.EndTime; Utility.AssignWeek(ref begin, ref end); timeRange.BeginTime = t1; timeRange.EndTime = t2; WorldToHwgr vice = Entity as WorldToHwgr; WorldToHwgr first = ClientEnvironment.WorldToHWGRService.FindById(vice.ID); first.BeginTime = timeRange.BeginTime; first.EndTime = timeRange.EndTime; ClientEnvironment.WorldToHWGRService.Update(first); break; case AssignEnum.HwgrWgrDisable: HwgrToWgr vice2 = Entity as HwgrToWgr; Domain.HwgrToWgr first2 = ClientEnvironment.HwgrToWgrService.FindById(vice2.ID); first2.EndTime = timeRange.EndTime; first2.BeginTime = timeRange.BeginTime; ClientEnvironment.HwgrToWgrService.Update(first2); break; } } catch (ValidationException) { XtraMessageBox.Show(Baumax.Localization.Localizer.GetLocalized("InvalidTimeRange")); return(false); }/* * catch (Exception ex) * { * XtraMessageBox.Show (ex.Message); * return false; * }*/ return(true); }
public override bool Commit() { try { DateTime begin = timeRange.BeginTime, end = timeRange.EndTime; Utility.AssignWeek(ref begin, ref end); timeRange.BeginTime = begin; timeRange.EndTime = end; if (m_vice is HwgrTreeItem) { HwgrTreeItem vice = m_vice as HwgrTreeItem; List <WorldToHwgr> saveList = new List <WorldToHwgr>(); WorldToHwgr first = ClientEnvironment.WorldToHWGRService.FindById(vice.Hwgr.ID); saveList.Add(first); if (first.Import) { first.EndTime = DateTime.Now; WorldToHwgr second = ClientEnvironment.WorldToHWGRService.CreateEntity(); second.Import = false; second.BeginTime = timeRange.BeginTime; second.EndTime = timeRange.EndTime; second.HWGR_ID = vice.Hwgr.HWGR_ID; second.WorldID = vice.Hwgr.WorldID; second.StoreID = m_storeID; saveList.Add(second); if (vice.EndTime > timeRange.EndTime) { WorldToHwgr third = ClientEnvironment.WorldToHWGRService.CreateEntity(); third.Import = true; third.BeginTime = timeRange.EndTime + m_oneSecond; third.EndTime = m_endTime; third.HWGR_ID = vice.Hwgr.HWGR_ID; third.WorldID = vice.Hwgr.WorldID; third.StoreID = m_storeID; saveList.Add(third); } } else { first.BeginTime = timeRange.BeginTime; first.EndTime = timeRange.EndTime; } ClientEnvironment.WorldToHWGRService.SaveOrUpdateList(saveList); } else { WgrTreeItem vice = m_vice as WgrTreeItem; List <Domain.HwgrToWgr> saveList = new List <HwgrToWgr>(); Domain.HwgrToWgr first = ClientEnvironment.HwgrToWgrService.FindById(vice.Wgr.ID); saveList.Add(first); if (first.Import) { first.EndTime = DateTime.Now; Domain.HwgrToWgr second = ClientEnvironment.HwgrToWgrService.CreateEntity(); second.Import = false; second.BeginTime = timeRange.BeginTime; second.EndTime = timeRange.EndTime; second.WGR_ID = vice.Wgr.WGR_ID; second.HWGR_ID = vice.Wgr.HWGR_ID; second.StoreID = m_storeID; saveList.Add(second); if (vice.EndTime > timeRange.EndTime) { Domain.HwgrToWgr third = ClientEnvironment.HwgrToWgrService.CreateEntity(); third.Import = true; third.BeginTime = timeRange.EndTime + m_oneSecond; third.EndTime = m_endTime; third.WGR_ID = vice.Wgr.WGR_ID; third.HWGR_ID = vice.Wgr.HWGR_ID; third.StoreID = m_storeID; saveList.Add(third); } } else { first.EndTime = timeRange.EndTime; first.BeginTime = timeRange.BeginTime; } ClientEnvironment.HwgrToWgrService.SaveOrUpdateList(saveList); } } catch { return(false); } return(true); }
public static void FillWorldToHwgr(WorldToHwgr entity) { entity.HwgrName = Instance.GetHwgrName(entity.HWGR_ID); }
public HwgrTreeItem(WorldToHwgr entity, long parentID) : base(entity, parentID) { ID = _nextID++; }
public HwgrDateRangeManager(IWorldToHwgrDao dao, WorldToHwgr newentity) : this(dao) { _entity = newentity; }