Exemplos de SQL_QUERIES.Sp_GatePassData_Daily_List em C# (CSharp)

Exemplo n.º 1

        public void LoadGatePassDataGrid()
        {
            PrintLogWin.PrintLog("LoadGatePassDataGrid => GlobalVariables.ProgCode ******************** : " + GlobalVariables.ProgCode);
            try
            {
                gridView_GatePassData.Columns.Clear();

                string _storedProcedre = SQL_QUERIES.Sp_GatePassData_Daily_List() + " '" + txtEmpCode.EditValue + "', '" + ConvertTo.DateFormatDb(DtDate.EditValue) + "'";
                //DataSet ds = ProgramMasterData.GetData(GlobalVariables.ProgCode, _params);
                DataSet _ds = ProjectFunctionsUtils.GetDataSet(_storedProcedre);

                if (_ds.Tables[0].Rows.Count > 0)
                {
                    gridControl_GatePassData.DataSource = _ds.Tables[0];
                    gridView_GatePassData.BestFitColumns();

                    ////////////////////


                    PrintPrivewButton.Enabled = true;
                    PrintButton.Enabled       = true;
                }
                else
                {
                    gridControl_GatePassData.DataSource = null;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString().Trim());
            }
        }