public void ShowLookupForm() { FrmLookup_LookupHide(null, null); frmLookup = new LookupForm(); switch (lookupColName) { case QUOTATIONITEMS.PRODUCT_ID: { frmLookup.LookupColNames = new string[] { PRODUCT.PRODUCT_NAME }; frmLookup.SelectedPkValue = editgrid[QUOTATIONITEMS.PRODUCT_ID, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; if (txt_party_id.Text != "") { frmLookup.LookupList = CProduct_exten.GetforLookup(new DAL()); frmLookup.LoadLookupList(); } } break; case QUOTATIONITEMS.SIZES_ID: frmLookup.LookupColNames = new string[] { SIZES.SIZES_NAME }; frmLookup.SelectedPkValue = editgrid[QUOTATIONITEMS.SIZES_ID, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = CSizes_exten.GetforLookup(new DAL()); frmLookup.LoadLookupList(); break; default: throw new Exception("'" + lookupColName + "' Not Found"); } frmLookup.LookupSelected += new EventHandler(FrmLookup_LookupSelected); frmLookup.AfterSelection += new EventHandler(FrmLookup_AfterSelection); frmLookup.LookupHide += new EventHandler(FrmLookup_LookupHide); frmLookup.NewEntryNeeded += new LookupForm.NewEntryHandler(FrmLookup_NewEntryNeeded); frmLookup.Owner = this.FindForm(); ////////// frmLookup.Show(); ////////// int vWidth = frmLookup.GetAutoWidth(); int vCellWidth = editgrid.Columns[lookupColName].Width; if (vWidth < vCellWidth) { vWidth = vCellWidth; } frmLookup.AutoFillLastColumn(); int vHeight = frmLookup.GetAutoHeight(); Rectangle screenRect = Global.GetScreenRect(editgrid); frmLookup.Bounds = Global.GetSnapRect(screenRect, vWidth, vHeight); }
public void ShowLookupForm() { FrmLookup_LookupHide(null, null); frmLookup = new LookupForm(); switch (lookupColName) { case INWARDITEMS.STYLE_ID: frmLookup.LookupColNames = new string[] { STYLE.STYLE_NO }; frmLookup.SelectedPkValue = editgrid[INWARDITEMS.STYLE_ID, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = CStyle_exten.LookupNo(); frmLookup.LoadLookupList(); break; case INWARDITEMS.ARTICLE_ID: frmLookup.LookupColNames = new string[] { ARTICLE.ARTICLE_NO }; frmLookup.SelectedPkValue = editgrid[INWARDITEMS.ARTICLE_ID, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = CArticle_exten.GetforLookup(); frmLookup.LoadLookupList(); break; default: throw new Exception("'" + lookupColName + "' Not Found"); } frmLookup.LookupSelected += new EventHandler(FrmLookup_LookupSelected); frmLookup.AfterSelection += new EventHandler(FrmLookup_AfterSelection); frmLookup.LookupHide += new EventHandler(FrmLookup_LookupHide); frmLookup.NewEntryNeeded += new LookupForm.NewEntryHandler(FrmLookup_NewEntryNeeded); frmLookup.Owner = this.FindForm(); ////////// frmLookup.Show(); ////////// int vWidth = frmLookup.GetAutoWidth(); int vCellWidth = editgrid.Columns[lookupColName].Width; if (vWidth < vCellWidth) { vWidth = vCellWidth; } frmLookup.AutoFillLastColumn(); int vHeight = frmLookup.GetAutoHeight(); Rectangle screenRect = Global.GetScreenRect(editgrid); frmLookup.Bounds = Global.GetSnapRect(screenRect, vWidth, vHeight); }
public void ShowLookupForm() { FrmLookup_LookupHide(null, null); frmLookup = new LookupForm(); switch (lookupColName) { case PAYMENTITEMS.PAYMENT_BY: { frmLookup.LookupColNames = new string[] { PAYMENTITEMS.PAYMENT_BY, PAYMENTITEMS.PURCHASE_NO, PAYMENTITEMS.PURCHASE_AMOUNT, PAYMENTITEMS.PAYMENT_AMOUNT }; frmLookup.SelectedPkValue = editgrid[PAYMENTITEMS.PAYMENT_BY, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; if (txt_party_id.Text != "") { frmLookup.LookupList = CPayment_manual.PaymentLookup(txt_party_id.Text); frmLookup.LoadLookupList(); } } break; default: throw new System.Exception("'" + lookupColName + "' Not Found"); } frmLookup.LookupSelected += new EventHandler(FrmLookup_LookupSelected); frmLookup.AfterSelection += new EventHandler(FrmLookup_AfterSelection); frmLookup.LookupHide += new EventHandler(FrmLookup_LookupHide); frmLookup.Owner = this.FindForm(); ////////// frmLookup.Show(); ////////// int vWidth = frmLookup.GetAutoWidth(); int vCellWidth = editgrid.Columns[lookupColName].Width; if (vWidth < vCellWidth) { vWidth = vCellWidth; } frmLookup.AutoFillLastColumn(); int vHeight = frmLookup.GetAutoHeight(); Rectangle screenRect = Global.GetScreenRect(editgrid); frmLookup.Bounds = Global.GetSnapRect(screenRect, vWidth, vHeight); }
public void ShowLookupForm() { FrmLookup_LookupHide(null, null); frmLookup = new LookupForm(); switch (lookupColName) { case MASTERTABLESITEMS.DATATYPE: { frmLookup.LookupColNames = new string[] { MASTERTABLESITEMS.DATATYPE }; frmLookup.SelectedPkValue = editgrid[MASTERTABLESITEMS.DATATYPE, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = Datatypes.Lookups(); frmLookup.LoadLookupList(); } break; case MASTERTABLESITEMS.INPUTTYPE: { frmLookup.LookupColNames = new string[] { MASTERTABLESITEMS.INPUTTYPE }; frmLookup.SelectedPkValue = editgrid[MASTERTABLESITEMS.INPUTTYPE, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = AutoCode.InputType(); frmLookup.LoadLookupList(); } break; case MASTERTABLESITEMS.WIDTH: { frmLookup.LookupColNames = new string[] { MASTERTABLESITEMS.WIDTH }; frmLookup.SelectedPkValue = editgrid[MASTERTABLESITEMS.WIDTH, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = AutoCode.Width(); frmLookup.LoadLookupList(); } break; case MASTERTABLESITEMS.HEIGHT: { frmLookup.LookupColNames = new string[] { MASTERTABLESITEMS.HEIGHT }; frmLookup.SelectedPkValue = editgrid[MASTERTABLESITEMS.HEIGHT, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = AutoCode.Height(); frmLookup.LoadLookupList(); } break; case MASTERTABLESITEMS.CPOSITION: { frmLookup.LookupColNames = new string[] { MASTERTABLESITEMS.CPOSITION }; frmLookup.SelectedPkValue = editgrid[MASTERTABLESITEMS.CPOSITION, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = AutoCode.Cposition(); frmLookup.LoadLookupList(); } break; case MASTERTABLESITEMS.RPOSITION: { frmLookup.LookupColNames = new string[] { MASTERTABLESITEMS.RPOSITION }; frmLookup.SelectedPkValue = editgrid[MASTERTABLESITEMS.RPOSITION, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = AutoCode.Rposition(); frmLookup.LoadLookupList(); } break; case MASTERTABLESITEMS.ALIGNTO: { frmLookup.LookupColNames = new string[] { MASTERTABLESITEMS.ALIGNTO }; frmLookup.SelectedPkValue = editgrid[MASTERTABLESITEMS.ALIGNTO, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = AutoCode.Alignto(); frmLookup.LoadLookupList(); } break; case MASTERTABLESITEMS.VALIDATE: { frmLookup.LookupColNames = new string[] { MASTERTABLESITEMS.VALIDATE }; frmLookup.SelectedPkValue = editgrid[MASTERTABLESITEMS.VALIDATE, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = AutoCode.Validate(); frmLookup.LoadLookupList(); } break; case MASTERTABLESITEMS.ISDEFAULT: { frmLookup.LookupColNames = new string[] { MASTERTABLESITEMS.ISDEFAULT }; frmLookup.SelectedPkValue = editgrid[MASTERTABLESITEMS.ISDEFAULT, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; // frmLookup.LookupList = AutoCode.IsDefault(); frmLookup.LoadLookupList(); } break; case MASTERTABLESITEMS.PLACEMENT: { frmLookup.LookupColNames = new string[] { MASTERTABLESITEMS.PLACEMENT }; frmLookup.SelectedPkValue = editgrid[MASTERTABLESITEMS.PLACEMENT, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; // frmLookup.LookupList = AutoCode.Placement(); frmLookup.LoadLookupList(); } break; default: throw new System.Exception("'" + lookupColName + "' Not Found"); } frmLookup.LookupSelected += new EventHandler(FrmLookup_LookupSelected); frmLookup.AfterSelection += new EventHandler(FrmLookup_AfterSelection); frmLookup.LookupHide += new EventHandler(FrmLookup_LookupHide); frmLookup.Owner = this.FindForm(); //////////// frmLookup.Show(); //////////// int vWidth = frmLookup.GetAutoWidth(); int vCellWidth = editgrid.Columns[lookupColName].Width; if (vWidth < vCellWidth) { vWidth = vCellWidth; } frmLookup.AutoFillLastColumn(); // int vHeight = frmLookup.GetAutoHeight(); // Rectangle screenRect = Global.GetScreenRect(editgrid); frmLookup.Bounds = Global.GetSnapRect(screenRect, vWidth, vHeight); }
public void ShowLookupForm() { FrmLookup_LookupHide(null, null); frmLookup = new LookupForm(); switch (lookupColName) { //case PURCHASEITEMS.PO_ID: // { // if (Customise.Purchase_poid_dcid == true) // { // frmLookup.LookupColNames = new string[] { PO.PO_NO, DC.DC_NO, DCITEMS.PRODUCT_ID, DCITEMS.QTY, DCITEMS.REFERED_QTY, POITEMS.PRICE }; // frmLookup.SelectedPkValue = editgrid[PURCHASEITEMS.PO_ID, lookupRow].Value; // frmLookup.AllowNewEntry = true; // frmLookup.AllowEmptySelection = true; // // // if (txt_party_id.Text != "") // { // frmLookup.LookupList = CPo_lookup.LookupbyPono(txt_party_id.Text); // //frmLookup.LookupList = CPo_lookup.LookupPObyPartyforPurchase(CParty_exten.GetId_Name(txt_party_id.Text)); // frmLookup.LoadLookupList(); // } // // // } // } // break; //// //case PURCHASEITEMS.DC_ID: // { // if (Customise.Purchase_poid_dcid == true) // { // frmLookup.LookupColNames = new string[] { DC.DC_NO, DCITEMS.PRODUCT_ID, DCITEMS.QTY, DCITEMS.REFERED_QTY, POITEMS.PRICE }; // frmLookup.SelectedPkValue = editgrid[PURCHASEITEMS.DC_ID, lookupRow].Value; // frmLookup.AllowNewEntry = true; // frmLookup.AllowEmptySelection = true; // // // if (txt_party_id.Text != "") // { // if (editgrid[DCITEMS.PO_ID, lookupRow].Value != null) // { // if (editgrid[DCITEMS.PO_ID, lookupRow].Value.ToString() != "") // { // if (editgrid[DCITEMS.PO_ID, lookupRow].Value.ToString() != Core.Without_Po) // { } // else // { // frmLookup.LookupList = CDc_Lookup.LookupDC_Party_forPurchase(CParty_exten.GetId_Name(txt_party_id.Text)); // frmLookup.LoadLookupList(); // } // } // else // { // frmLookup.LookupList = CDc_Lookup.LookupDC_Party_forPurchase(CParty_exten.GetId_Name(txt_party_id.Text)); // frmLookup.LoadLookupList(); // } // } // else // { // frmLookup.LookupList = CDc_Lookup.LookupDC_Party_forPurchase(CParty_exten.GetId_Name(txt_party_id.Text)); // frmLookup.LoadLookupList(); // } // } // // // } // } // break; case PURCHASEITEMS.PRODUCT_ID: { frmLookup.LookupColNames = new string[] { PRODUCT.PRODUCT_NAME }; frmLookup.SelectedPkValue = editgrid[PURCHASEITEMS.PRODUCT_ID, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; if (txt_party_id.Text != "") { //if (Customise.Purchase_poid_dcid == true) //{ // if (editgrid[DCITEMS.PO_ID, lookupRow].Value != null) // { // if (editgrid[DCITEMS.DC_ID, lookupRow].Value != null) // { // if (editgrid[DCITEMS.PO_ID, lookupRow].Value.ToString() == Core.Without_Po) // { // if (editgrid[DCITEMS.DC_ID, lookupRow].Value.ToString() == Core.Without_Dc) // { // frmLookup.LookupList = CProduct_exten.GetforLookup(new DAL()); // frmLookup.LoadLookupList(); // } // } // } // else // { // frmLookup.LookupList = CProduct_exten.GetforLookup(new DAL()); // frmLookup.LoadLookupList(); // } // } // else // { frmLookup.LookupList = CProduct_exten.GetforLookup(new DAL()); frmLookup.LoadLookupList(); //} // } //if ((Customise.Purchase_pono_dcno == true) || (Customise.Purchase_Without_podc == true)) //{ // frmLookup.LookupList = CProduct_exten.GetforLookup(new DAL()); // frmLookup.LoadLookupList(); //} } } break; default: throw new Exception("'" + lookupColName + "' Not Found"); } frmLookup.LookupSelected += new EventHandler(FrmLookup_LookupSelected); frmLookup.AfterSelection += new EventHandler(FrmLookup_AfterSelection); frmLookup.LookupHide += new EventHandler(FrmLookup_LookupHide); frmLookup.NewEntryNeeded += new LookupForm.NewEntryHandler(FrmLookup_NewEntryNeeded); frmLookup.Owner = this.FindForm(); ////////// frmLookup.Show(); ////////// int vWidth = frmLookup.GetAutoWidth(); int vCellWidth = editgrid.Columns[lookupColName].Width; if (vWidth < vCellWidth) { vWidth = vCellWidth; } frmLookup.AutoFillLastColumn(); int vHeight = frmLookup.GetAutoHeight(); Rectangle screenRect = Global.GetScreenRect(editgrid); frmLookup.Bounds = Global.GetSnapRect(screenRect, vWidth, vHeight); }
public void ShowLookupForm() { FrmLookup_LookupHide(null, null); frmLookup = new LookupForm(); switch (lookupColName) { case UPVC_INVOICEITEMS.PRODUCT_ID: { frmLookup.LookupColNames = new string[] { PRODUCT.PRODUCT_NAME }; frmLookup.SelectedPkValue = editgrid[UPVC_INVOICEITEMS.PRODUCT_ID, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; if (txt_party_id.Text != "") { frmLookup.LookupList = CProduct_exten.GetforLookup(new DAL()); frmLookup.LoadLookupList(); } } break; case UPVC_INVOICEITEMS.PCRATE: { frmLookup.LookupColNames = new string[] { UPVC_INVOICEITEMS.PCRATE }; frmLookup.SelectedPkValue = editgrid[UPVC_INVOICEITEMS.PCRATE, lookupRow].Value; frmLookup.AllowNewEntry = false; frmLookup.AllowEmptySelection = true; DataTable dt = new DataTable(); dt.Columns.Add(UPVC_INVOICEITEMS.PCRATE); dt.Rows.Add(Core.InSqFt); dt.Rows.Add(Core.Inpcsrate); if (txt_party_id.Text != "") { frmLookup.LookupList = dt; frmLookup.LoadLookupList(); } } break; case UPVC_INVOICEITEMS.MSM: { frmLookup.LookupColNames = new string[] { UPVC_INVOICEITEMS.MSM }; frmLookup.SelectedPkValue = editgrid[UPVC_INVOICEITEMS.MSM, lookupRow].Value; frmLookup.AllowNewEntry = false; frmLookup.AllowEmptySelection = true; DataTable dt1 = new DataTable(); dt1.Columns.Add(UPVC_INVOICEITEMS.MSM); dt1.Rows.Add(Core.InMM); dt1.Rows.Add(Core.InInch); if (txt_party_id.Text != "") { frmLookup.LookupList = dt1; frmLookup.LoadLookupList(); } } break; default: throw new System.Exception("'" + lookupColName + "' Not Found"); } frmLookup.LookupSelected += new EventHandler(FrmLookup_LookupSelected); frmLookup.AfterSelection += new EventHandler(FrmLookup_AfterSelection); frmLookup.LookupHide += new EventHandler(FrmLookup_LookupHide); frmLookup.NewEntryNeeded += new LookupForm.NewEntryHandler(FrmLookup_NewEntryNeeded); frmLookup.Owner = this.FindForm(); ////////// frmLookup.Show(); ////////// int vWidth = frmLookup.GetAutoWidth(); int vCellWidth = editgrid.Columns[lookupColName].Width; if (vWidth < vCellWidth) { vWidth = vCellWidth; } frmLookup.AutoFillLastColumn(); int vHeight = frmLookup.GetAutoHeight(); Rectangle screenRect = Global.GetScreenRect(editgrid); frmLookup.Bounds = Global.GetSnapRect(screenRect, vWidth, vHeight); }
public void ShowLookupForm_2() { FrmLookup_2_LookupHide(null, null); frmLookup = new LookupForm(); switch (lookupColName) { case SFIELDS.DATATYPE: { frmLookup.LookupColNames = new string[] { SFIELDS.DATATYPE }; frmLookup.SelectedPkValue = editgrid_2[SFIELDS.DATATYPE, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = Datatypes.Lookups(); frmLookup.LoadLookupList(); } break; //case SFIELDS.PKEYS: // { // frmLookup.LookupColNames = new string[] { SFIELDS.PKEYS }; // frmLookup.SelectedPkValue = editgrid_2[SFIELDS.PKEYS, lookupRow].Value; // frmLookup.AllowNewEntry = true; // frmLookup.AllowEmptySelection = true; // frmLookup.LookupList = AutoCode.Pkeys(); // frmLookup.LoadLookupList(); // } // break; //case SFIELDS.IFNULL: // { // frmLookup.LookupColNames = new string[] { SFIELDS.IFNULL }; // frmLookup.SelectedPkValue = editgrid_2[SFIELDS.IFNULL, lookupRow].Value; // frmLookup.AllowNewEntry = true; // frmLookup.AllowEmptySelection = true; // frmLookup.LookupList = AutoCode.Ifnull(); // frmLookup.LoadLookupList(); // } // break; //case SFIELDS.REFEREDTBL: // { // frmLookup.LookupColNames = new string[] { STABLES.STABLES_NAME, STABLES.STABLES_ID }; // frmLookup.SelectedPkValue = editgrid_2[SFIELDS.REFEREDTBL, lookupRow].Value; // frmLookup.AllowNewEntry = true; // frmLookup.AllowEmptySelection = true; // frmLookup.LookupList = CStables_exten.GetforLookup(new SQLITE_DAL()); // frmLookup.LoadLookupList(); // } // break; case SFIELDS.INPUTTYPE: { frmLookup.LookupColNames = new string[] { SFIELDS.INPUTTYPE }; frmLookup.SelectedPkValue = editgrid_2[SFIELDS.INPUTTYPE, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = AutoCode.InputType(); frmLookup.LoadLookupList(); } break; case SFIELDS.WIDTH: { frmLookup.LookupColNames = new string[] { SFIELDS.WIDTH }; frmLookup.SelectedPkValue = editgrid_2[SFIELDS.WIDTH, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = AutoCode.Width(); frmLookup.LoadLookupList(); } break; case SFIELDS.HEIGHT: { frmLookup.LookupColNames = new string[] { SFIELDS.HEIGHT }; frmLookup.SelectedPkValue = editgrid_2[SFIELDS.HEIGHT, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = AutoCode.Height(); frmLookup.LoadLookupList(); } break; case SFIELDS.ALIGNTO: { frmLookup.LookupColNames = new string[] { SFIELDS.ALIGNTO }; frmLookup.SelectedPkValue = editgrid_2[SFIELDS.ALIGNTO, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = AutoCode.Alignto(); frmLookup.LoadLookupList(); } break; case SFIELDS.VALIDATE: { frmLookup.LookupColNames = new string[] { SFIELDS.VALIDATE }; frmLookup.SelectedPkValue = editgrid_2[SFIELDS.VALIDATE, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; frmLookup.LookupList = AutoCode.Validate(); frmLookup.LoadLookupList(); } break; case SFIELDS.ISDEFAULT: { frmLookup.LookupColNames = new string[] { SFIELDS.ISDEFAULT }; frmLookup.SelectedPkValue = editgrid_2[SFIELDS.ISDEFAULT, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; // frmLookup.LookupList = AutoCode.IsDefault(); frmLookup.LoadLookupList(); } break; case SFIELDS.PLACEMENT: { frmLookup.LookupColNames = new string[] { SFIELDS.PLACEMENT }; frmLookup.SelectedPkValue = editgrid_2[SFIELDS.PLACEMENT, lookupRow].Value; frmLookup.AllowNewEntry = true; frmLookup.AllowEmptySelection = true; // frmLookup.LookupList = AutoCode.Placement(); frmLookup.LoadLookupList(); } break; default: throw new System.Exception("'" + lookupColName + "' Not Found"); } frmLookup.LookupSelected += new EventHandler(FrmLookup_2_LookupSelected); frmLookup.AfterSelection += new EventHandler(FrmLookup_2_AfterSelection); frmLookup.LookupHide += new EventHandler(FrmLookup_2_LookupHide); frmLookup.Owner = this.FindForm(); //////////// frmLookup.Show(); //////////// int vWidth = frmLookup.GetAutoWidth(); int vCellWidth = editgrid_2.Columns[lookupColName].Width; if (vWidth < vCellWidth) { vWidth = vCellWidth; } frmLookup.AutoFillLastColumn(); // int vHeight = frmLookup.GetAutoHeight(); // Rectangle screenRect = Global.GetScreenRect(editgrid_2); frmLookup.Bounds = Global.GetSnapRect(screenRect, vWidth, vHeight); }