//void View_UpdateFilter(object sender, DataEventArgs<IqReportColumn> e) //{ // View.Model.AllColumns.Where(f => f.ReportColumnId == e.Value.ReportColumnId).First().Options = e.Value.Options; // View.Model.AllColumns = View.Model.AllColumns; //} void View_AddToSelected(object sender, DataEventArgs <IqColumn> e) { if (e.Value == null) { return; } try { IqReportColumn rc = new IqReportColumn { Column = e.Value, Alias = e.Value.Name, CreatedBy = "system", CreationDate = DateTime.Now, ReportTable = View.Model.CurTable }; service.SaveIqReportColumn(rc); View.Model.CurTable.ReportColumns = service.GetIqReportColumn( new IqReportColumn { ReportTable = new IqReportTable { ReportTableId = View.Model.CurTable.ReportTableId } }).ToList(); } catch (Exception ex) { Util.ShowError("Error processing record.\n" + ex.Message); } }
private void ProcessDrag(DataGridControl lvSource, DataGridControl lvDest, GetPositionDelegate mousePoint) { sourceIndex = this.GetCurrentIndex(mousePoint, lvSource); curSource = lvSource; if (sourceIndex < 0) { return; } lvSource.SelectedIndex = sourceIndex; selectedItem = lvSource.Items[sourceIndex] as IqReportColumn; if (selectedItem == null) { return; } // this will create the drag "rectangle" DragDropEffects allowedEffects = DragDropEffects.Move; if (DragDrop.DoDragDrop(lvSource, selectedItem, allowedEffects) != DragDropEffects.None) { // The item was dropped into a new location, // so make it the new selected item. lvDest.SelectedItem = selectedItem; } }
//INQUIRY SHORTCUT public bool LoadShortCut(string look, int iqRepCol) { IqReportColumn rc = service.GetIqReportColumn(new IqReportColumn { ReportColumnId = iqRepCol, IsSelected = true }).First(); View.Model.ReportSystem = service.GetIqReport(new IqReport { ReportId = rc.ReportTable.Report.ReportId }).First(); ReportSelectedChange(View.Model.ReportSystem); //Load The Filter - El filtro por la opcion escogida. View.Model.AllColumns.Where(f => f.ReportColumnId == iqRepCol).First().Options = "F: = _val:" + look; //Adicionalmente adicionando el filtro de la bodega. 47 (valor fixed) View.Model.AllColumns.Where(f => f.ReportColumnId == 47).First().Options = "F: = _val:" + App.curLocation.ErpCode; View.Model.AllColumns = View.Model.AllColumns; //View.LvFilters.Items.Refresh(); RunReport("", false); return((View.Model.Details != null && View.Model.Details.Rows.Count > 0) ? true : false); }
public override IQuery GetHsql(Object data) { StringBuilder sql = new StringBuilder("select a from IqReportColumn a where "); IqReportColumn iqreportcolumn = (IqReportColumn)data; if (iqreportcolumn != null) { Parms = new List <Object[]>(); if (iqreportcolumn.ReportColumnId != 0) { sql.Append(" a.ReportColumnId = :id and "); Parms.Add(new Object[] { "id", iqreportcolumn.ReportColumnId }); } //if (iqreportcolumn.IsSelected != null) //{ sql.Append(" a.IsSelected = :nom2 and "); Parms.Add(new Object[] { "nom2", iqreportcolumn.IsSelected }); //} if (!String.IsNullOrEmpty(iqreportcolumn.Alias)) { sql.Append(" a.Alias = :nom3 and "); Parms.Add(new Object[] { "nom3", iqreportcolumn.Alias }); } if (iqreportcolumn.IsFiltered != null) { sql.Append(" a.IsFiltered = :nom4 and "); Parms.Add(new Object[] { "nom4", iqreportcolumn.IsFiltered }); } if (!String.IsNullOrEmpty(iqreportcolumn.FilteredValue)) { sql.Append(" a.FilteredValue = :nom5 and "); Parms.Add(new Object[] { "nom5", iqreportcolumn.FilteredValue }); } if (iqreportcolumn.Column != null && iqreportcolumn.Column.ColumnId != 0) { sql.Append(" a.Column.ColumnId = :idd6 and "); Parms.Add(new Object[] { "idd6", iqreportcolumn.Column.ColumnId }); } if (iqreportcolumn.ReportTable != null && iqreportcolumn.ReportTable.ReportTableId != 0) { sql.Append(" a.ReportTable.ReportTableId = :idd7 and "); Parms.Add(new Object[] { "idd7", iqreportcolumn.ReportTable.ReportTableId }); } } sql = new StringBuilder(sql.ToString()); sql.Append("1=1 order by a.ReportColumnId asc "); IQuery query = Factory.Session.CreateQuery(sql.ToString()); SetParameters(query); return(query); }
public IList <IqReportColumn> Select(IqReportColumn data) { IList <IqReportColumn> datos = new List <IqReportColumn>(); datos = GetHsql(data).List <IqReportColumn>(); if (!Factory.IsTransactional) { Factory.Commit(); } return(datos); }
private void ProcessDrag(DataGridControl lvSource, DataGridControl lvDest, GetPositionDelegate mousePoint) { sourceIndex = this.GetCurrentIndex(mousePoint, lvSource); curSource = lvSource; if (sourceIndex < 0) return; lvSource.SelectedIndex = sourceIndex; selectedItem = lvSource.Items[sourceIndex] as IqReportColumn; if (selectedItem == null) return; // this will create the drag "rectangle" DragDropEffects allowedEffects = DragDropEffects.Move; if (DragDrop.DoDragDrop(lvSource, selectedItem, allowedEffects) != DragDropEffects.None) { // The item was dropped into a new location, // so make it the new selected item. lvDest.SelectedItem = selectedItem; } }
public void DeleteIqReportColumn(IqReportColumn data) { try { SetService(); SerClient.DeleteIqReportColumn(data); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
public IqReportColumn SaveIqReportColumn(IqReportColumn data) { try { SetService(); return SerClient.SaveIqReportColumn(data); } finally { SerClient.Close(); if (SerClient.State == CommunicationState.Faulted) SerClient.Abort(); } }
int countType = -1; //0 = Bin , 1 = PRODUCT public InventoryCountPresenter(IUnityContainer container, IInventoryCountView view) { View = view; this.container = container; this.service = new WMSServiceClient(); View.Model = this.container.Resolve<InventoryCountModel>(); View.FilterByBin += new EventHandler<DataEventArgs<string>>(View_FilterByBin); View.AddToAssigned += new EventHandler<EventArgs>(View_AddToAssigned); View.RemoveFromList += new EventHandler<EventArgs>(View_RemoveFromList); View.CreateNewTask += new EventHandler<EventArgs>(View_CreateNewTask); View.LoadDetails += new EventHandler<DataEventArgs<Document>>(View_LoadDetails); View.ShowTicket += new EventHandler<EventArgs>(View_ShowTicket); View.ChangeStatus += new EventHandler<EventArgs>(view_ChangeStatus); //View.BinTaskSelected += new EventHandler<DataEventArgs<ProductStock>>(View_BinTaskSelected); View.ChangeCountedQty += new EventHandler<DataEventArgs<object[]>>(View_ChangeCountedQty); View.ConfirmCountTask += new EventHandler<EventArgs>(View_ConfirmCountTask); View.CancelTask += new EventHandler<EventArgs>(View_CancelTask); View.SearchDocument += new EventHandler<DataEventArgs<string>>(View_SearchDocument); View.RefreshDocuments += new EventHandler<EventArgs>(View_RefreshDocuments); View.ReloadDocument += new EventHandler<EventArgs>(View_ReloadDocument); View.FilterByProduct += new EventHandler<DataEventArgs<Product>>(View_FilterByProduct); View.UpdateDocumentOption += new EventHandler<DataEventArgs<int>>(View_UpdateDocumentOption); View.ShowInitialTicket += new EventHandler<EventArgs>(View_ShowInitialTicket); View.LoadNoCountBalance += new EventHandler<EventArgs>(View_LoadNoCountBalance); View.SendAdjustment += new EventHandler<EventArgs>(View_SendAdjustment); View.ChangeSendOption += new EventHandler<EventArgs>(OnChangeSendOption); view.SelectAll += new EventHandler<EventArgs>(OnSelectAll); view.UnSelectAll += new EventHandler<EventArgs>(OnUnSelectAll); //DocType docType = new DocumentType { DocClass = new DocumentClass { DocClassID = SDocClass.Task } }; docType.DocTypeID = SDocType.CountTask; ProcessWindow pw = new ProcessWindow("Loading Bin List ..."); //oriAvailableBin = service.GetBin(new Bin { Location = App.curLocation }).OrderBy(f=> f.BinCode).ToList(); oriAvailableBin = service.GetBin(new Bin()).OrderBy(f => f.BinCode).ToList(); pw.Close(); RefreshDocuments(); //Product Categories try { IList<ProductCategory> list = service.GetProductCategory(new ProductCategory()); list.Add(new ProductCategory { Name = "... Any Category"}); View.Model.ProductCategories = list.OrderBy(f=>f.Name).ToList(); } catch { } // CAA [2010/07/07] Carga los filtros de busq de bines. IqReportColumn rc = new IqReportColumn(); rc.Alias = "Filter by Bin"; rc.FilteredValue = ""; View.BFilters.cboStrComp.SelectedValue = " = _val"; View.BFilters.RepColumn = rc; }
int countType = -1; //0 = Bin , 1 = PRODUCT public InventoryCountPresenter(IUnityContainer container, IInventoryCountView view) { View = view; this.container = container; this.service = new WMSServiceClient(); View.Model = this.container.Resolve <InventoryCountModel>(); View.FilterByBin += new EventHandler <DataEventArgs <string> >(View_FilterByBin); View.AddToAssigned += new EventHandler <EventArgs>(View_AddToAssigned); View.RemoveFromList += new EventHandler <EventArgs>(View_RemoveFromList); View.CreateNewTask += new EventHandler <EventArgs>(View_CreateNewTask); View.LoadDetails += new EventHandler <DataEventArgs <Document> >(View_LoadDetails); View.ShowTicket += new EventHandler <EventArgs>(View_ShowTicket); View.ChangeStatus += new EventHandler <EventArgs>(view_ChangeStatus); //View.BinTaskSelected += new EventHandler<DataEventArgs<ProductStock>>(View_BinTaskSelected); View.ChangeCountedQty += new EventHandler <DataEventArgs <object[]> >(View_ChangeCountedQty); View.ConfirmCountTask += new EventHandler <EventArgs>(View_ConfirmCountTask); View.CancelTask += new EventHandler <EventArgs>(View_CancelTask); View.SearchDocument += new EventHandler <DataEventArgs <string> >(View_SearchDocument); View.RefreshDocuments += new EventHandler <EventArgs>(View_RefreshDocuments); View.ReloadDocument += new EventHandler <EventArgs>(View_ReloadDocument); View.FilterByProduct += new EventHandler <DataEventArgs <Product> >(View_FilterByProduct); View.UpdateDocumentOption += new EventHandler <DataEventArgs <int> >(View_UpdateDocumentOption); View.ShowInitialTicket += new EventHandler <EventArgs>(View_ShowInitialTicket); View.LoadNoCountBalance += new EventHandler <EventArgs>(View_LoadNoCountBalance); View.SendAdjustment += new EventHandler <EventArgs>(View_SendAdjustment); View.ChangeSendOption += new EventHandler <EventArgs>(OnChangeSendOption); view.SelectAll += new EventHandler <EventArgs>(OnSelectAll); view.UnSelectAll += new EventHandler <EventArgs>(OnUnSelectAll); //DocType docType = new DocumentType { DocClass = new DocumentClass { DocClassID = SDocClass.Task } }; docType.DocTypeID = SDocType.CountTask; ProcessWindow pw = new ProcessWindow("Loading Bin List ..."); //oriAvailableBin = service.GetBin(new Bin { Location = App.curLocation }).OrderBy(f=> f.BinCode).ToList(); oriAvailableBin = service.GetBin(new Bin()).OrderBy(f => f.BinCode).ToList(); pw.Close(); RefreshDocuments(); //Product Categories try { IList <ProductCategory> list = service.GetProductCategory(new ProductCategory()); list.Add(new ProductCategory { Name = "... Any Category" }); View.Model.ProductCategories = list.OrderBy(f => f.Name).ToList(); } catch { } // CAA [2010/07/07] Carga los filtros de busq de bines. IqReportColumn rc = new IqReportColumn(); rc.Alias = "Filter by Bin"; rc.FilteredValue = ""; View.BFilters.cboStrComp.SelectedValue = " = _val"; View.BFilters.RepColumn = rc; }
//void View_UpdateFilter(object sender, DataEventArgs<IqReportColumn> e) //{ // View.Model.AllColumns.Where(f => f.ReportColumnId == e.Value.ReportColumnId).First().Options = e.Value.Options; // View.Model.AllColumns = View.Model.AllColumns; //} void View_AddToSelected(object sender, DataEventArgs<IqColumn> e) { if (e.Value == null) return; try { IqReportColumn rc = new IqReportColumn { Column = e.Value, Alias = e.Value.Name, CreatedBy = "system", CreationDate = DateTime.Now, ReportTable = View.Model.CurTable }; service.SaveIqReportColumn(rc); View.Model.CurTable.ReportColumns = service.GetIqReportColumn( new IqReportColumn { ReportTable = new IqReportTable { ReportTableId = View.Model.CurTable.ReportTableId } }).ToList(); } catch (Exception ex) { Util.ShowError("Error processing record.\n" + ex.Message); } }
public IqReportColumn SelectById(IqReportColumn data) { return((IqReportColumn)base.SelectById(data)); }
public Boolean Delete(IqReportColumn data) { return(base.Delete(data)); }
public Boolean Update(IqReportColumn data) { return(base.Update(data)); }
public IqReportColumn Save(IqReportColumn data) { return((IqReportColumn)base.Save(data)); }