public static List <string> check(XLS_Class xls, int start, int stop, int col, string table, string name, bool xls_marker) { List <string> rett = new List <string>(); string element; if (xls_marker) { if (name != "Owner") { element = "xls" + name; } else { element = name; } } else { element = name; } for (int i = start; i < stop; i++) { if ( SQL_Class.ReadValueInt32("select count(*) from " + table + " where " + element + " like '%" + xls.read_val(i, col).ToString() + "%'") <= 0) { if (!rett.Contains(xls.read_val(i, col).ToString())) { rett.Add(xls.read_val(i, col).ToString()); } } } return(rett); }
public List <string> check(XLS_Class xls, int start, int stop, int col, string table, string name) { List <string> rett = new List <string>(); string element; if (XLS_Rbut.Checked) { element = "xls" + name; } else { element = name; } for (int i = start; i < stop; i++) { if ( SQL_Class.ReadValueInt32("select count(*) from " + table + " where " + element + " like '%" + xls.read_val(i, col).ToString() + "%'") <= 0) { if (xls.read_val(i, col).ToString() == "СКЛАД") { MessageBox.Show(i.ToString()); } if (!rett.Contains(xls.read_val(i, col).ToString())) { rett.Add(xls.read_val(i, col).ToString()); } } } return(rett); }
private void Check_Start_Stop_Mark_Click(object sender, EventArgs e) { start_Tbox.Text = ""; stop_Tbox.Text = ""; for (int i = 1; i < 9000; i++) { string str = mcl.read_val(i, 1).ToString(); if (str == "#start") { start_Tbox.Text = (i + 1).ToString(); } if (str == "#stop") { stop_Tbox.Text = (i).ToString(); break; } } if (start_Tbox.Text == "") { MessageBox.Show("No Start Mark Found!!"); } else { if (stop_Tbox.Text == "") { MessageBox.Show("No Stop Mark Found!!"); } else { MessageBox.Show("OK!!"); } } }
public static Compare_Element get_el_as_xls_el_for_cmp(XLS_Class mcl, int i) //++ { Compare_Element el = new Compare_Element(); el.Mark = mcl.read_val(i, Properties.Settings.Default.xls_Mark).ToString(); el.Type = mcl.read_val(i, Properties.Settings.Default.xls_Type).ToString(); el.Status = mcl.read_val(i, Properties.Settings.Default.xls_Status).ToString(); el.Place = mcl.read_val(i, Properties.Settings.Default.xls_Place).ToString(); el.Owner = mcl.read_val(i, Properties.Settings.Default.xls_Owner).ToString(); el.Serial = mcl.read_val(i, Properties.Settings.Default.xls_Serial).ToString(); el.Serial2 = mcl.read_val(i, Properties.Settings.Default.xls_Serial2).ToString(); el.Prise = (mcl.read_val(i, Properties.Settings.Default.xls_Prise)).ToString(); el.date = (mcl.read_val(i, Properties.Settings.Default.xls_Date)).ToString(); el.OS = mcl.read_val(i, Properties.Settings.Default.xls_OS).ToString(); el.Place2 = mcl.read_val(i, Properties.Settings.Default.xls_Place2).ToString(); el.read_other_xls(); return(el); }
public static Compare_Element get_el_as_xls_el(XLS_Class mcl, int i)//++ { Compare_Element el = new Compare_Element(); el.Mark = mcl.read_val(i, Properties.Settings.Default.xls_Mark).ToString(); el.Type = mcl.read_val(i, Properties.Settings.Default.xls_Type).ToString(); el.Status = mcl.read_val(i, Properties.Settings.Default.xls_Status).ToString(); el.Status2 = ""; el.Place = mcl.read_val(i, Properties.Settings.Default.xls_Place).ToString(); el.Text = mcl.read_val(i, Properties.Settings.Default.xls_Text).ToString(); el.Text2 = mcl.read_val(i, Properties.Settings.Default.xls_Text2).ToString(); el.Text3 = mcl.read_val(i, Properties.Settings.Default.xls_Text3).ToString(); el.Text4 = mcl.read_val(i, Properties.Settings.Default.xls_Text4).ToString(); el.Text5 = mcl.read_val(i, Properties.Settings.Default.xls_Text5).ToString(); el.Serial = mcl.read_val(i, Properties.Settings.Default.xls_Serial).ToString(); el.Serial2 = mcl.read_val(i, Properties.Settings.Default.xls_Serial2).ToString(); el.Prise = mcl.read_val(i, Properties.Settings.Default.xls_Prise).ToString(); el.date = FuncClass.get_Date(mcl.read_val(i, Properties.Settings.Default.xls_Date).ToString()); el.OS = mcl.read_val(i, Properties.Settings.Default.xls_OS).ToString(); el.Place2 = mcl.read_val(i, Properties.Settings.Default.xls_Place2).ToString(); el.Status2id = RandomFull.get_rand_int(); el.read_other_xls(); return(el); }