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); }
public void BindData() { GridView1.DataSource = GetMostrePaged(GridView1.PageIndex, GridView1.PageSize); GridView1.VirtualItemCount = GetMostreCount(); lcount.Text = GridView1.VirtualItemCount + " mostre"; GridView1.DataBind(); for (int i = 0; i < GridView1.Rows.Count; i++) { try { if (GridView1.Rows[i].Cells[4].Text.Trim() != "" && !GridView1.Rows[i].Cells[4].Text.StartsWith(" ")) { if (UMostre.VerificGrasime(GridView1.Rows[i].Cells[4].Text) == 1) { GridView1.Rows[i].Cells[4].BackColor = Color.Red; } string grasime = GridView1.Rows[i].Cells[4].Text.Trim(); GridView1.Rows[i].Cells[4].Text = (Convert.ToDouble(grasime) == 0) ? "" : (Convert.ToDouble(grasime) == 0.00001) ? "0" : grasime; } if (GridView1.Rows[i].Cells[5].Text.Trim() != "" && !GridView1.Rows[i].Cells[5].Text.StartsWith(" ")) { if (UMostre.VerificProteine(GridView1.Rows[i].Cells[5].Text) == 1) { GridView1.Rows[i].Cells[5].BackColor = Color.Red; } string proteine = GridView1.Rows[i].Cells[5].Text.Trim(); GridView1.Rows[i].Cells[5].Text = (Convert.ToDouble(proteine) == 0) ? "" : (Convert.ToDouble(proteine) == 0.00001) ? "0" : proteine; } if (GridView1.Rows[i].Cells[7].Text.Trim() != "" && !GridView1.Rows[i].Cells[7].Text.StartsWith(" ")) { if (UMostre.VerificLactoza(GridView1.Rows[i].Cells[7].Text) == 1) { GridView1.Rows[i].Cells[7].BackColor = Color.Red; } string lactoza = GridView1.Rows[i].Cells[7].Text.Trim(); GridView1.Rows[i].Cells[7].Text = (Convert.ToDouble(lactoza) == 0) ? "" : (Convert.ToDouble(lactoza) == 0.00001) ? "0" : lactoza; } if (GridView1.Rows[i].Cells[8].Text.Trim() != "" && !GridView1.Rows[i].Cells[8].Text.StartsWith(" ")) { if (UMostre.VerificSolids(GridView1.Rows[i].Cells[8].Text) == 1) { GridView1.Rows[i].Cells[8].BackColor = Color.Red; } string substu = GridView1.Rows[i].Cells[8].Text.Trim(); GridView1.Rows[i].Cells[8].Text = (Convert.ToDouble(substu) == 0) ? "" : (Convert.ToDouble(substu) == 0.00001) ? "0" : substu; } //ph if (GridView1.Rows[i].Cells[9].Text.Trim() != "" && !GridView1.Rows[i].Cells[9].Text.StartsWith(" ")) { if (UMostre.VerificPh(GridView1.Rows[i].Cells[9].Text) == 1) { GridView1.Rows[i].Cells[9].BackColor = Color.Red; } string ph = GridView1.Rows[i].Cells[9].Text.Trim(); GridView1.Rows[i].Cells[9].Text = (Convert.ToDouble(ph) == 0) ? "" : (Convert.ToDouble(ph) == 0.00001) ? "0" : ph; } string pcti = GridView1.Rows[i].Cells[10].Text.Trim(); if (pcti != "" && !pcti.StartsWith(" ") && Convert.ToDouble(pcti) != 0.00001) { if (UMostre.VerificPctInghet(pcti) == 1) { GridView1.Rows[i].Cells[10].BackColor = Color.Red; } GridView1.Rows[i].Cells[10].Text = (Convert.ToDouble(pcti) == 0) ? "" : (Convert.ToDouble(pcti) == 0.00001) ? "0" : "-0." + pcti; } //urea if (GridView1.Rows[i].Cells[13].Text.Trim() != "" && !GridView1.Rows[i].Cells[13].Text.StartsWith(" ")) { if (UMostre.VerificUrea(GridView1.Rows[i].Cells[13].Text) == 1) { GridView1.Rows[i].Cells[13].BackColor = Color.Red; } string urea = GridView1.Rows[i].Cells[13].Text.Trim(); GridView1.Rows[i].Cells[13].Text = (Convert.ToDouble(urea) == 0) ? "" : (Convert.ToDouble(urea) == 0.00001) ? "0" : urea; } if (GridView1.Rows[i].Cells[14].Text.Trim() != "" && !GridView1.Rows[i].Cells[14].Text.StartsWith(" ")) { if (UMostre.VerificNCS(GridView1.Rows[i].Cells[14].Text) == 1) { GridView1.Rows[i].Cells[14].BackColor = Color.Red; } string ncs = GridView1.Rows[i].Cells[14].Text.Trim(); GridView1.Rows[i].Cells[14].Text = (Convert.ToDouble(ncs) == 0) ? "" : (Convert.ToDouble(ncs) == 0.00001) ? "0" : ncs; } if (GridView1.Rows[i].Cells[15].Text.Trim() != "" && !GridView1.Rows[i].Cells[15].Text.StartsWith(" ")) { if (UMostre.VerificNTG(GridView1.Rows[i].Cells[15].Text) == 1) { GridView1.Rows[i].Cells[15].BackColor = Color.Red; } string ntg = GridView1.Rows[i].Cells[15].Text.Trim(); GridView1.Rows[i].Cells[15].Text = (Convert.ToDouble(ntg) == 0) ? "" : (Convert.ToDouble(ntg) == 0.00001) ? "0" : ntg; } } catch (Exception ex) { logger.Error(string.Format("BindData|ERROR:{0}", ex.Message)); } } }
public void BindData() { GridView1.DataSource = GetMostrePaged(GridView1.PageIndex, GridView1.PageSize); GridView1.VirtualItemCount = GetMostreCount(); lcount.Text = GridView1.VirtualItemCount + " mostre"; GridView1.DataBind(); for (int i = 0; i < GridView1.Rows.Count; i++) { try { if (GridView1.Rows[i].Cells[5].Text.Trim() != "" && !GridView1.Rows[i].Cells[5].Text.StartsWith(" ")) { if (UMostre.VerificGrasime(GridView1.Rows[i].Cells[5].Text) == 1) { GridView1.Rows[i].Cells[5].BackColor = Color.Red; } string grasime = GridView1.Rows[i].Cells[5].Text.Trim(); GridView1.Rows[i].Cells[5].Text = (Convert.ToDouble(grasime, CultureInfo.InvariantCulture) == 0) ? "" : (Convert.ToDouble(grasime, CultureInfo.InvariantCulture) == 0.00001) ? "0" : grasime; } if (GridView1.Rows[i].Cells[6].Text.Trim() != "" && !GridView1.Rows[i].Cells[6].Text.StartsWith(" ")) { if (UMostre.VerificProteine(GridView1.Rows[i].Cells[6].Text) == 1) { GridView1.Rows[i].Cells[6].BackColor = Color.Red; } string proteine = GridView1.Rows[i].Cells[6].Text.Trim(); GridView1.Rows[i].Cells[6].Text = (Convert.ToDouble(proteine, CultureInfo.InvariantCulture) == 0) ? "" : (Convert.ToDouble(proteine, CultureInfo.InvariantCulture) == 0.00001) ? "0" : proteine; } if (GridView1.Rows[i].Cells[7].Text.Trim() != "" && !GridView1.Rows[i].Cells[7].Text.StartsWith(" ")) { string cazeina = GridView1.Rows[i].Cells[7].Text.Trim(); GridView1.Rows[i].Cells[7].Text = (Convert.ToDouble(cazeina, CultureInfo.InvariantCulture) == 0) ? "" : (Convert.ToDouble(cazeina, CultureInfo.InvariantCulture) == 0.00001) ? "0" : cazeina; } if (GridView1.Rows[i].Cells[8].Text.Trim() != "" && !GridView1.Rows[i].Cells[8].Text.StartsWith(" ")) { if (UMostre.VerificLactoza(GridView1.Rows[i].Cells[8].Text) == 1) { GridView1.Rows[i].Cells[8].BackColor = Color.Red; } string lactoza = GridView1.Rows[i].Cells[8].Text.Trim(); GridView1.Rows[i].Cells[8].Text = (Convert.ToDouble(lactoza, CultureInfo.InvariantCulture) == 0) ? "" : (Convert.ToDouble(lactoza, CultureInfo.InvariantCulture) == 0.00001) ? "0" : lactoza; } if (GridView1.Rows[i].Cells[9].Text.Trim() != "" && !GridView1.Rows[i].Cells[9].Text.StartsWith(" ")) { if (UMostre.VerificSolids(GridView1.Rows[i].Cells[9].Text) == 1) { GridView1.Rows[i].Cells[9].BackColor = Color.Red; } string substu = GridView1.Rows[i].Cells[9].Text.Trim(); GridView1.Rows[i].Cells[9].Text = (Convert.ToDouble(substu, CultureInfo.InvariantCulture) == 0) ? "" : (Convert.ToDouble(substu, CultureInfo.InvariantCulture) == 0.00001) ? "0" : substu; } //ph if (GridView1.Rows[i].Cells[10].Text.Trim() != "" && !GridView1.Rows[i].Cells[10].Text.StartsWith(" ")) { if (UMostre.VerificPh(GridView1.Rows[i].Cells[10].Text) == 1) { GridView1.Rows[i].Cells[10].BackColor = Color.Red; } string ph = GridView1.Rows[i].Cells[10].Text.Trim(); GridView1.Rows[i].Cells[10].Text = (Convert.ToDouble(ph, CultureInfo.InvariantCulture) == 0) ? "" : (Convert.ToDouble(ph, CultureInfo.InvariantCulture) == 0.00001) ? "0" : ph; } //urea if (GridView1.Rows[i].Cells[11].Text.Trim() != "" && !GridView1.Rows[i].Cells[11].Text.StartsWith(" ")) { string urea = GridView1.Rows[i].Cells[11].Text.Trim(); if ((Convert.ToDouble(urea, CultureInfo.InvariantCulture) >= 0.1) && UMostre.VerificUrea(urea) == 1) { GridView1.Rows[i].Cells[11].BackColor = Color.Red; } GridView1.Rows[i].Cells[11].Text = (Convert.ToDouble(urea, CultureInfo.InvariantCulture) == 0) ? "" : (Convert.ToDouble(urea, CultureInfo.InvariantCulture) == 0.00001) ? "" : (Convert.ToDouble(urea, CultureInfo.InvariantCulture) < 0.1) ? "" : urea; } if (GridView1.Rows[i].Cells[12].Text.Trim() != "" && !GridView1.Rows[i].Cells[12].Text.StartsWith(" ")) { if (UMostre.VerificNCS(GridView1.Rows[i].Cells[12].Text) == 1) { GridView1.Rows[i].Cells[12].BackColor = Color.Red; } string ncs = GridView1.Rows[i].Cells[12].Text.Trim(); GridView1.Rows[i].Cells[12].Text = (Convert.ToDouble(ncs, CultureInfo.InvariantCulture) == 0) ? "" : (Convert.ToDouble(ncs, CultureInfo.InvariantCulture) == 0.00001) ? "0" : ncs; } } catch (Exception ex) { logger.Error(string.Format("BindData|ERROR:{0}", ex.Message)); } } }