internal DataTable Dl_GetGridRecord(PL_FilterInformation plobj) { try { con = Connection.SetConnection(); cmd = new SqlCommand("Sp_SelectCrt", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Ind", plobj.Ind); cmd.Parameters.AddWithValue("@CityCode", plobj.CityCode); cmd.Parameters.AddWithValue("@MonthCd", plobj.MonthCd); cmd.Parameters.AddWithValue("@SelectStringParameter", plobj.SelectStringParameter); cmd.Parameters.AddWithValue("@FilterStringParameter", plobj.FilterStringParameter); cmd.Parameters.AddWithValue("@OrderByStringParameter", plobj.OrderByStringParameter); da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); return(dt); } catch { return(dt); } finally { con.Close(); con.Dispose(); } }
public DataTable FilterGetData(PL_FilterInformation plobj) { DL_FilterInformation objdl = new DL_FilterInformation(); DataTable dt = new DataTable(); if (plobj.Ind == 0) { return(dt); } else { dt = objdl.Dl_GetGridRecord(plobj); return(dt); } }