Ejemplos de TANK_usp_sel_EquipmentInfo_spParams en C# (CSharp)

Ejemplo n.º 1

Archivo: InvoiceListController.cs Proyecto: dowtankttp/DOWTank

        private DataTable GetEquipmentInfo(string equipment)
        {
            // database call
            var TANK_usp_sel_EquipmentInfo_spParams = new TANK_usp_sel_EquipmentInfo_spParams();

            TANK_usp_sel_EquipmentInfo_spParams.EquipmentAN = equipment;

            DataTable data = _utilityService.ExecStoredProcedureForDataTable("TANK_usp_sel_EquipmentInfo", TANK_usp_sel_EquipmentInfo_spParams);

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

Ejemplo n.º 2

Archivo: TankHistoryController.cs Proyecto: dowtankttp/DOWTank

        private DataTable GetEquipmentInfo(bool showColumnsOnly, int majorLocationID, string equipment)
        {
            // database call
            var TANK_usp_sel_EquipmentInfo_spParams = new TANK_usp_sel_EquipmentInfo_spParams();

            //TANK_usp_sel_EquipmentInfo_spParams.EquipmentID = equipmentId;
            TANK_usp_sel_EquipmentInfo_spParams.EquipmentAN     = equipment;
            TANK_usp_sel_EquipmentInfo_spParams.MajorLocationID = majorLocationID;

            DataTable data = _utilityService.ExecStoredProcedureForDataTable("TANK_usp_sel_EquipmentInfo", TANK_usp_sel_EquipmentInfo_spParams);

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

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