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);
}
