C# (CSharp) TANK_usp_sel_EquipmentProduct_spParamsの例

コード例 #1

ファイル: InvoiceListController.cs プロジェクト: dowtankttp/DOWTank

        private DataTable GetEquipmentProduct(string equipment)
        {
            // database call
            var TANK_usp_sel_EquipmentProduct_spParams = new TANK_usp_sel_EquipmentProduct_spParams();

            TANK_usp_sel_EquipmentProduct_spParams.EquipmentAN = equipment;

            DataTable data = _utilityService.ExecStoredProcedureForDataTable("TANK_usp_sel_EquipmentProduct", TANK_usp_sel_EquipmentProduct_spParams);

            @ViewBag.TotalEquipmentProduct = data.Rows.Count;
            return(data);
        }

コード例 #2

ファイル: TankHistoryController.cs プロジェクト: dowtankttp/DOWTank

        private DataTable GetEquipmentProduct(bool showColumnsOnly, string equipment)
        {
            // database call
            var TANK_usp_sel_EquipmentProduct_spParams = new TANK_usp_sel_EquipmentProduct_spParams();

            //            TANK_usp_sel_EquipmentProduct_spParams.EquipmentID = equipmentId;
            TANK_usp_sel_EquipmentProduct_spParams.EquipmentAN = equipment;

            DataTable data = _utilityService.ExecStoredProcedureForDataTable("TANK_usp_sel_EquipmentProduct", TANK_usp_sel_EquipmentProduct_spParams);

            if (showColumnsOnly)
            {
                data.Clear();
            }

            @ViewBag.TotalEquipmentProduct = data.Rows.Count;
            return(data);
        }