Beispiel #1
0
 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();
 }
Beispiel #2
0
        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();
        }