public ArrayList createTable(DateTime tdata) { ArrayList values = new ArrayList(); SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["fccl2ConnectionString"].ConnectionString); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnn; cmd.CommandText = "select * from MostreTancuri where DataTestare = convert(date, '" + tdata.ToShortDateString() + "', 103) "; if (prelid.Text.Trim().Length > 0) { cmd.CommandText += " AND PrelevatorId =" + prelid.Text.Trim(); } if (codbare.Text.Trim().Length > 0) { cmd.CommandText += " AND CodBare Like '%" + codbare.Text.Trim() + "%'"; } cmd.CommandText += " ORDER BY IdZilnic ASC"; //SqlParameter p = new SqlParameter("@DataTestareFinala", tdata.ToShortDateString()); //cmd.Parameters.Add(p); cnn.Open(); SqlDataReader reader = cmd.ExecuteReader(); int nrrec = 0; 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.ToDateTime(reader["DataTestare"]); vm.casein = Convert.ToString(reader["Caseina"]); 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 = ""; vm.antib = Convert.ToString(reader["Antibiotice"]); 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.rasa = Convert.ToString(reader["Rasa"]); vm.validat = Convert.ToString(reader["Validat"]); vm.definitiv = Convert.ToString(reader["Definitiv"]); vm.sentsms = Convert.ToBoolean(reader["SentSms"]); vm.dataf = Convert.ToDateTime(reader["DataTestareFinala"]); vm.prelid = Convert.ToString(reader["PrelevatorId"]); values.Add(vm); // add to values nrrec++; } lcount.Text = nrrec + " mostre"; reader.Close(); cnn.Close(); return(values); }
public ArrayList createTable(DateTime tdata) { ArrayList values = new ArrayList(); SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["fccl2ConnectionString"].ConnectionString); SqlCommand cmd = new SqlCommand(); cmd.Connection = cnn; cmd.CommandText = "select * from MostreTancuri where DataTestare = convert(date, '"+tdata.ToShortDateString()+"', 103) "; if (prelid.Text.Trim().Length > 0) { cmd.CommandText += " AND PrelevatorId =" + prelid.Text.Trim(); } if (codbare.Text.Trim().Length > 0) { cmd.CommandText += " AND CodBare Like '%" + codbare.Text.Trim() + "%'"; } cmd.CommandText += " ORDER BY IdZilnic ASC"; //SqlParameter p = new SqlParameter("@DataTestareFinala", tdata.ToShortDateString()); //cmd.Parameters.Add(p); cnn.Open(); SqlDataReader reader = cmd.ExecuteReader(); int nrrec = 0; 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.ToDateTime(reader["DataTestare"]); vm.casein = Convert.ToString(reader["Caseina"]); 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 = ""; vm.antib = Convert.ToString(reader["Antibiotice"]); 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.rasa = Convert.ToString(reader["Rasa"]); vm.validat = Convert.ToString(reader["Validat"]); vm.definitiv = Convert.ToString(reader["Definitiv"]); vm.sentsms = Convert.ToBoolean(reader["SentSms"]); vm.dataf = Convert.ToDateTime(reader["DataTestareFinala"]); vm.prelid = Convert.ToString(reader["PrelevatorId"]); values.Add(vm); // add to values nrrec++; } lcount.Text = nrrec + " mostre"; reader.Close(); cnn.Close(); return values; }
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); }
void updateFlags() { ArrayList values = createTable(DateTime.Parse(datatestare.Text)); SqlConnection cnn = new SqlConnection(ConfigurationManager.ConnectionStrings["fccl2ConnectionString"].ConnectionString); string preleronati = ""; for (int i = 0; i < Repeater1.Items.Count; i++) { RepeaterItem item = Repeater1.Items[i]; VMostre vm = (VMostre)values[i]; Label lbcod = (Label)item.FindControl("codbare"); string codbare = lbcod.Text; Label lbdata = (Label)item.FindControl("datat"); string tdata = lbdata.Text; CheckBox chkdef = (CheckBox)item.FindControl("definitiv"); CheckBox chkval = (CheckBox)item.FindControl("validat"); int validat = 0; if (chkval != null && chkval.Checked) { validat = 1; } int definitiv = 0; if (chkdef.Checked) { definitiv = 1; } int sentsms = 0; if (!Page.User.IsInRole("admin")) { if (definitiv == 1) { validat = 1; } } else { if (validat == 0) { definitiv = 0; } } string grasime = NomalizeInput(((TextBox)item.FindControl("grasime")).Text); string proteina = NomalizeInput(((TextBox)item.FindControl("proteina")).Text); string caseina = NomalizeInput(((TextBox)item.FindControl("caseina")).Text); string lactoza = NomalizeInput(((TextBox)item.FindControl("lactoza")).Text); string substu = NomalizeInput(((TextBox)item.FindControl("substu")).Text); string pcti = "0.00001"; string antib = ""; string ncs = NomalizeInput(((TextBox)item.FindControl("ncs")).Text); string ph = NomalizeInput(((TextBox)item.FindControl("ph")).Text); string urea = NomalizeInput(((TextBox)item.FindControl("urea")).Text); string ntg = "0.00001"; TextBox tprelid = (TextBox)item.FindControl("prelid"); string prelid = tprelid.Text; if (prelid.Trim().Equals("")) { prelid = "0"; } if (prelid != "0") { if (!prelid.Trim().Equals(codbare.Substring(0, 5))) { if (!ExistaPrelevator(prelid)) { if (preleronati.Length > 0) { preleronati += "," + prelid; } else { preleronati += prelid; } } } } //update table //if changed update { string query = "UPDATE MostreTancuri SET Validat = " + validat + ",Definitiv = " + definitiv + ",Sentsms = " + sentsms + ",Grasime= " + grasime + ",ProcentProteine=" + proteina + ",Caseina=" + caseina + ",ProcentLactoza=" + lactoza + ",PunctInghet=" + pcti + ",SubstantaUscata=" + substu + ",NumarCeluleSomatice=" + ncs + ",IncarcaturaGermeni=" + ntg + ",PH=" + ph + ",Urea=" + urea + ",Antibiotice='" + antib + "',PrelevatorId=" + prelid + " WHERE ID = " + vm.Id; SqlCommand cmd = new SqlCommand(query, cnn); cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); } } if (preleronati.Length > 0) { Label4.Text = "Prelevatorii: " + preleronati + " nu exista!"; } }
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; }