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