public static int GetPO(OleDbConnection connection, int compID,int locationID) { string[] mycolumnHeadings = {"PO","Date","Status","Mill","Customer","Customer Location"}; string[] myfieldNames = {"PONumber","PODate","Status","MillName","CustomerName","CustomerLocation"}; FieldType[] myfieldTypes = {FieldType.String,FieldType.Date,FieldType.String, FieldType.String,FieldType.String,FieldType.String}; int[] mycolumnWidths = {150,150,60,150,150,200}; string filterName = "Status"; string[] filterValues = new string[]{"All","Open","Closed","Cancelled"}; int initialFilterValue = 1; if (compID != -1 && locationID != -1) { using (new OpenConnection(IsWrite.No,AdapterHelper.Connection)) { EMDataSet tmpSet = new EMDataSet(); tmpSet.EnforceConstraints = false; AdapterHelper.FillCompanyFromCompID(tmpSet,compID); AdapterHelper.FillLocationFromLocationID(tmpSet,locationID); } } Chooser dlg = new Chooser(connection,"POID",mycolumnHeadings,mycolumnWidths, myfieldNames,myfieldTypes,filterName,filterValues,initialFilterValue, new POFindButtonClick(compID,locationID)); DialogResult res = dlg.ShowDialog(); if (res == DialogResult.OK) return dlg.KeyValue; else return 0; }
public static int GetContainer(OleDbConnection connection) { string[] mycolumnHeadings = {"Container#","Ship Date","ETA","Status","Customer", "Completed","PONumbers"}; string[] myfieldNames = {"ContNumber","ShipDate","ETA","Status","Customer","Completed","PONumbers"}; FieldType[] myfieldTypes = {FieldType.String,FieldType.Date,FieldType.Date, FieldType.String,FieldType.String,FieldType.String, FieldType.String}; int[] mycolumnWidths = {100,100,100,60,100,100,400}; string filterName = "Status"; string[] filterValues = new string[]{"All","Open","Closed","Cancelled"}; int initialFilterValue = 1; Chooser dlg = new Chooser(connection,"ContID",mycolumnHeadings,mycolumnWidths, myfieldNames,myfieldTypes,filterName,filterValues,initialFilterValue, new ContainerFindButtonClick()); dlg.showPOInfo.Visible = true; DialogResult res = dlg.ShowDialog(); if (res == DialogResult.OK) return dlg.KeyValue; else return 0; }