Пример #1
0
        public CResult Load_DropDownList(ComboBox OCombobox, EntityCommon.DropDownName oDropDownName)
        {
            DataSet   oDataSet   = new DataSet();
            DataTable oDataTable = new DataTable();

            switch (oDropDownName)
            {
            case EntityCommon.DropDownName.GSM:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct GsmGSMName,GsmGSMId from GSM order by GsmGSMName");
                break;

            case EntityCommon.DropDownName.Measurement:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct MesMeasurementName,MesMeasurementId from Measurement order by MesMeasurementName");
                break;

            case EntityCommon.DropDownName.UnitType:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct untUnitName,untUnitID from UnitType order by untUnitName");
                break;

            case EntityCommon.DropDownName.Item:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct ItmItemName,ItmItemCode from Item order by ItmItemName");
                break;

            case EntityCommon.DropDownName.Buyer:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct BuyBuyerName,BuyBuyerID from Buyer where BuyType = 'Buyer' order by BuyBuyerName");
                break;

            case EntityCommon.DropDownName.Customer:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct BuyBuyerName,BuyBuyerID from Buyer where BuyType = 'Customer' order by BuyBuyerName");
                break;

            case EntityCommon.DropDownName.Supplier:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct SupSupplierName,SupSupplierID from Supplier order by SupSupplierName");
                break;

            case EntityCommon.DropDownName.Bank:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct BnkBankName,BnkBankID from Bank order by BnkBankName");
                break;

            case EntityCommon.DropDownName.ExportLC:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct EilLCNo,EilLCNo from ExportImportLC Where EilType='E' order by EilLCNo");
                break;

            case EntityCommon.DropDownName.Style:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct StyStyleName,StyStyleId from Style order by StyStyleName");
                break;

            case EntityCommon.DropDownName.Order:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct PorOrderNo,PorOrderNo from PurchaseOrder order by PorOrderNo");
                break;

            case EntityCommon.DropDownName.Country:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct CntCountryName,CntCountryID from Country order by CntCountryName");
                break;

            case EntityCommon.DropDownName.Designation:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct DsgDesignationName,DsgDesignationID from Designation order by DsgDesignationName");
                break;

            case EntityCommon.DropDownName.JobNo:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct PinJobNo,PinJobNo from ProformaInvoice order by PinJobNo");
                break;

            case EntityCommon.DropDownName.User:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct UsrUserName,UsrUserName from SecurityUser order by UsrUserName");
                break;

            case EntityCommon.DropDownName.Order_INV:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct IisOrderNo,IisOrderNo from ItemIssue,ItemIssueDetail Where IisIssueNo = IidIssueNo order by IisOrderNo");
                break;

            case EntityCommon.DropDownName.ItemIssueOrderNo:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct IisOrderNo,IisOrderNo from ItemIssue  order by IisOrderNo");
                break;

            case EntityCommon.DropDownName.ProformaInvoiceOrderNo:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct PinOrderNo,PinOrderNo from ProformaInvoice  order by PinOrderNo");
                break;

            case EntityCommon.DropDownName.PurchaseOrderNo:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct PorOrderNo,PorOrderNo from PurchaseOrder  order by PorOrderNo");
                break;

            case EntityCommon.DropDownName.WorkOrderNo:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct WorOrderNo,WorOrderNo from WorkOrder  order by WorOrderNo");
                break;

            case EntityCommon.DropDownName.OinOrderNo:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct OinOrderNo,OinOrderNo from OrderInvoice  order by OinOrderNo");
                break;

            case EntityCommon.DropDownName.MreOrderNo:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct MreOrderNo,MreOrderNo from MaterialReceive  order by MreOrderNo");
                break;

            case EntityCommon.DropDownName.CltCollectionID:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct CltCollectionID,CltCollectionID from Collection  order by CltCollectionID");
                break;

            case EntityCommon.DropDownName.PmtPaymentID:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct PmtPaymentID,PmtPaymentID from Payment  order by PmtPaymentID");
                break;

            case EntityCommon.DropDownName.CollectionReportBuyerName:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select  distinct BuyBuyerName,BuyBuyerID from Buyer ");
                break;

            case EntityCommon.DropDownName.PaymentReportSupplyerName:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select  distinct SupSupplierName,SupSupplierID from Supplier ");
                break;

            case EntityCommon.DropDownName.BuyerReportBuyerName:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select  distinct BuyBuyerName,BuyBuyerID from Buyer ");
                break;

            case EntityCommon.DropDownName.MobileNo:
                oCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select  distinct MmrMobileNo,MmrMobileNo from ReceivedMessage Order By MmrMobileNo");
                break;
            }
            try
            {
                OCombobox.DataSource = null;
                OCombobox.Items.Clear();
                OCombobox.DataSource    = oCResult.DataTableContainerSub;
                OCombobox.DisplayMember = oCResult.DataTableContainerSub.Columns[0].ToString();
                OCombobox.ValueMember   = oCResult.DataTableContainerSub.Columns[1].ToString();
            }
            catch (Exception ex) { }
            return(oCResult);
        }
Пример #2
0
        public CResult Load_DropDownList(ComboBox OCombobox, EntityCommon.DropDownName oDropDownName, string SQLString)
        {
            CResult   oddlCResult = new CResult();
            DataSet   oDataSet    = new DataSet();
            DataTable oDataTable  = new DataTable();

            switch (oDropDownName)
            {
            case EntityCommon.DropDownName.GSM_Item:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct GsmGSMName,GsmGSMId from GSM,Item Where ItmGSM = GsmGSMId And ItmItemCode = '" + SQLString + "' order by GsmGSMName");
                break;

            case EntityCommon.DropDownName.Measurement_Item:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct MesMeasurementName,MesMeasurementId from Measurement,Item Where ItmMeasurement = MesMeasurementId And ItmItemCode = '" + SQLString + "' order by MesMeasurementName");
                break;

            case EntityCommon.DropDownName.UnitType_Item:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct untUnitName,untUnitID from UnitType,Item Where ItmUnitType = untUnitID And ItmItemCode = '" + SQLString + "' order by untUnitName");
                break;

            case EntityCommon.DropDownName.DeliveryPlace:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct BdpPlaceName,BdpPlaceID from DeliveryPlace Where BdpBuyerID ='" + SQLString + "' Order by BdpPlaceName");
                break;

            case EntityCommon.DropDownName.OrderStyle:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct StyStyleName,StyStyleId from OrderStyle,Style Where OrsStyleNo=StyStyleId " + SQLString + " order by StyStyleName");
                break;

            case EntityCommon.DropDownName.GSM_PO:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct GsmGSMName,GsmGSMId from GSM,PurchaseOrderDetail,PurchaseOrder Where PorPurchaseOrderNo=PodPurchaseOrderNo And GsmGSMId=PodGSM " + SQLString + " order by GsmGSMName");
                break;

            case EntityCommon.DropDownName.Measurement_PO:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct MesMeasurementName,MesMeasurementId from Measurement,PurchaseOrderDetail,PurchaseOrder Where PorPurchaseOrderNo=PodPurchaseOrderNo And MesMeasurementId=PodMeasurement " + SQLString + " order by MesMeasurementName");
                break;

            case EntityCommon.DropDownName.UnitType_PO:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct untUnitName,untUnitID from UnitType,PurchaseOrderDetail,PurchaseOrder Where PorPurchaseOrderNo=PodPurchaseOrderNo And untUnitID=PodUnitType " + SQLString + " order by untUnitName");
                break;

            case EntityCommon.DropDownName.Item_PO:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select Distinct ItmItemName,ItmItemCode from Item,PurchaseOrderDetail,PurchaseOrder Where PorPurchaseOrderNo=PodPurchaseOrderNo And ItmItemCode=PodItem " + SQLString + " order by ItmItemName");
                break;

            case EntityCommon.DropDownName.Order:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select PorOrderNo,PorOrderNo from PurchaseOrder Where PorApprove = 'Y'   " + SQLString + " order by PorOrderNo");
                break;

            case EntityCommon.DropDownName.ReceiveOrder:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("SELECT     MaterialReceive.MreOrderNo, MaterialReceive.MreOrderNo  FROM MaterialReceive INNER JOIN MaterialReceiveDetail ON MaterialReceive.MreReceiveNo = MaterialReceiveDetail.MrdReceiveNo WHERE     (MaterialReceive.MreApprove = 'Y')  " + SQLString + "  GROUP BY MaterialReceive.MreOrderNo");
                break;

            case EntityCommon.DropDownName.IisIssueNo:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select  IisIssueNo,IisIssueNo from ItemIssue Where IisOrderNo ='" + SQLString + "' order by IisOrderNo");
                break;

            case EntityCommon.DropDownName.PIInvoiceNo:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select  PinInvoiceNo,PinInvoiceNo from ProformaInvoice Where PinOrderNo ='" + SQLString + "' order by PinOrderNo");
                break;

            case EntityCommon.DropDownName.OidInvoiceNo:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select  OinInvoiceNo,OinInvoiceNo from OrderInvoice Where OinOrderNo ='" + SQLString + "' order by OinOrderNo");
                break;

            case EntityCommon.DropDownName.MreReceiveNo:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select  MreReceiveNo,MreReceiveNo from MaterialReceive Where MreOrderNo ='" + SQLString + "' order by MreOrderNo");
                break;

            case EntityCommon.DropDownName.WorWorkOrderNo:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select  WorWorkOrderNo,WorWorkOrderNo from WorkOrder Where WorOrderNo ='" + SQLString + "' order by WorOrderNo");
                break;

            case EntityCommon.DropDownName.CollRepCollectionId:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select CltCollectionID,CltCollectionID from Collection where CltBuyerID = '" + SQLString + "' Order By CltBuyerID");
                break;

            case EntityCommon.DropDownName.PaymentReportPaymentId:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select PmtPaymentID,PmtPaymentID from Payment where PmtSupplierID = '" + SQLString + "' Order By PmtSupplierID");
                break;

            case EntityCommon.DropDownName.PurchaseOrderSummary:
                oddlCResult = m_oCSQLCommandExecutor.LoadDropDownList("Select PorPurchaseOrderNo,PorPurchaseOrderNo from PurchaseOrder where PorBuyerID = '" + SQLString + "' Order By PorBuyerID");
                break;
            }
            try
            {
                OCombobox.DataSource = null;
                OCombobox.Items.Clear();
                OCombobox.DataSource    = oddlCResult.DataTableContainerSub;
                OCombobox.DisplayMember = oddlCResult.DataTableContainerSub.Columns[0].ToString();
                OCombobox.ValueMember   = oddlCResult.DataTableContainerSub.Columns[1].ToString();
            }
            catch (Exception ex) { }//MessageBox.Show(ex.ToString()); }
            return(oddlCResult);
        }