public ArrayList GetMostrePaged(int pageIndex, int pageSize) { int startIdx = pageSize * pageIndex + 1; int endIdx = pageSize * (pageIndex + 1); ArrayList values = new ArrayList(); SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["fccl2ConnectionString"].ConnectionString); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnn; cmd.CommandText = GetSelectStatement(startIdx, endIdx); cmd.CommandTimeout = 300; cnn.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { VMostre vm = new VMostre(); vm.id = Convert.ToString(reader["ID"]); vm.codbare = Convert.ToString(reader["CodBare"]); vm.idzilnic = Convert.ToString(reader["IdZilnic"]); vm.datat = Convert.ToString(reader["DataTestare"]); vm.grasime = Convert.ToString(reader["Grasime"]); vm.proteina = Convert.ToString(reader["ProcentProteine"]); vm.lactoza = Convert.ToString(reader["ProcentLactoza"]); vm.substu = Convert.ToString(reader["SubstantaUscata"]); vm.pcti = Convert.ToString(reader["PunctInghet"]); vm.apaad = ""; if (!string.IsNullOrEmpty(vm.pcti) && vm.pcti != "0" && vm.pcti.IndexOf(".") < 0) { vm.apaad = UMostre.ApaAdaugata(vm.pcti); } vm.antib = Convert.ToString(reader["Antibiotice"]); if (vm.antib == "-1" || vm.antib == "1") { vm.antib = "Pozitiv"; } else if (vm.antib == "0") { vm.antib = "Negativ"; } vm.ncs = Convert.ToString(reader["NumarCeluleSomatice"]); vm.ntg = Convert.ToString(reader["IncarcaturaGermeni"]); vm.urea = Convert.ToString(reader["Urea"]); vm.ph = Convert.ToString(reader["PH"]); vm.casein = Convert.ToString(reader["Caseina"]); vm.validat = Convert.ToString(reader["Validat"]); vm.bvalidat = Convert.ToBoolean(reader["Validat"]); vm.bdefinitiv = Convert.ToBoolean(reader["Definitiv"]); vm.definitiv = Convert.ToString(reader["Definitiv"]); vm.dataf = Convert.ToString(reader["DataTestareFinala"]); values.Add(vm); } reader.Close(); cnn.Close(); return(values); }