public ucMasterView(HMCon Connection, TUC_HMDevXManager.TUC_HMDevXManager DevXMgr) { this.Connection = Connection; this.DevXMgr = DevXMgr; CBOUtil = new ComboSearch.Util(DevXMgr); Popup = new frmPopup(DevXMgr); InitializeComponent(); RunSetups(); }
public frmLevySelect(HMConnection.HMCon Connection, TUC_HMDevXManager.TUC_HMDevXManager DevXMgr, int AP_INV_HEADER_ID) { this.Connection = Connection; this.DevXMgr = DevXMgr; this.AP_INV_HEADER_ID = AP_INV_HEADER_ID; CBOUtil = new ComboSearch.Util(DevXMgr); Popup = new WS_Popups.frmPopup(DevXMgr); string sSQL = @"select supplier_id from AP_INV_HEADER a join SUPPLIER_MASTER s on s.SUPPLIER=a.SUPPLIER where a.AP_INV_HEADER_ID=" + AP_INV_HEADER_ID; object oSupplier_ID = Connection.SQLExecutor.ExecuteScalar(sSQL, Connection.TRConnection); if (oSupplier_ID == null || oSupplier_ID == DBNull.Value) { oSupplier_ID = -1; } Supplier_ID = Convert.ToInt32(oSupplier_ID); sSQL = @"select count(*) from supplier_master where isnull(one_check,'F')='T' and supplier_id=" + Supplier_ID; object oCNT = Connection.SQLExecutor.ExecuteScalar(sSQL, Connection.TRConnection); if (oCNT == null || oCNT == DBNull.Value) { oCNT = 0; } if (Convert.ToInt32(oCNT) == 1) { MiscSupplier = true; } InitializeComponent(); daLevySearch.SelectCommand.Parameters["@username"].Value = Connection.MLUser; RunSetups(); }