public static Compare_Element get_el_as_xls_el_for_cmp(XLS_Class mcl, int i) //++11
{
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.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 = 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);
}
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.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 = (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 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 bool Check_and_Fill_DGV(XLS_Class xls, int start, int stop, int col, string table, string name)
{
disable_all_update();
List <string> lst = FuncClass.check(xls, start, stop, col, table, name, XLS_Rbut.Checked);
Buffer.buffer = lst;
DataGridViewComboBoxCell tmp = new DataGridViewComboBoxCell();
List <string> tmp2 = new List <string>();
tmp2.Add("----");
tmp2.AddRange(CMB.get_ordered_datasource(name, table));
tmp.DataSource = tmp2;
dgv.Columns[1].CellTemplate = tmp;
dgv.Rows.Clear();
dgv.RowCount = lst.Count;
for (int i = 0; i < lst.Count; i++)
{
dgv.Rows[i].Cells[0].Value = lst[i];
}
if (lst.Count != 0)
{
lab_but.Text = "Working with table :" + table;
return(false);
}
else
{
lab_but.Text = "";
return(true);
}
}
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 get_File_Click(object sender, EventArgs e)
{
XLS_Class cl = XLS_Class.get_xls();
if (cl != null)
{
get_File.BackColor = Color.Green;
mcl = cl;
}
}
public void get_File_Func()
{
XLS_Class cl = XLS_Class.get_xls();
if (cl != null)
{
get_File.BackColor = Color.Green;
mcl = cl;
}
}
public void get_File_Func(string path)
{
XLS_Class cl = new XLS_Class(path);
if (cl != null)
{
get_File.BackColor = Color.Green;
mcl = cl;
}
}
public static bool Check_without_Fill_DGV(XLS_Class xls, int start, int stop, int col, string table, string name, bool xls_marker)
{
List <string> lst = check(xls, start, stop, col, table, name, xls_marker);
if (lst.Count != 0)
{
return(false);
}
else
{
return(true);
}
}
public bool Check_and_Fill_DGV(XLS_Class xls, int start, int stop, int col, string table, string name)
{
List <string> lst = check(xls, start, stop, col, table, name);
dgv.RowCount = lst.Count;
Buffer.buffer = lst;
for (int i = 0; i < lst.Count; i++)
{
dgv.Rows[i].Cells[0].Value = lst[i];
}
if (lst.Count != 0)
{
return(false);
}
else
{
return(true);
}
}
private void Export_But_Click(object sender, EventArgs e)
{
if (Place_ChBox.Checked)
{
if (TempDirectory.AllowWork && TempDirectory.ShablonsEnabled)
{
string postfix = DateTime.Now.ToString("yyyy-MM-dd HH-mm-ss");
string filename = "Export-" + postfix + ".xlsx";
string path = TempDirectory.Path + "\\" + filename;
File.Copy(TempDirectory.Path + "\\xls.xlsx", path);
if (File.Exists(path))
{
int row = 4;
int j = 1;
XLS_Class cl = new XLS_Class(path);
cl.set_val(1, 2, DateTime.Now.ToString("D"));
cl.set_val(2, 2, Place2_CmBox.SelectedItem.ToString());
for (int i = 0; i < dgv.RowCount; i++)
{
cl.set_val(row, 0, j.ToString());
cl.set_val(row, 1, dgv.Rows[i].Cells[4].Value.ToString());
cl.set_val(row, 2, dgv.Rows[i].Cells[3].Value.ToString());
cl.set_val(row, 3, dgv.Rows[i].Cells[1].Value.ToString());
cl.set_val(row, 4, dgv.Rows[i].Cells[2].Value.ToString());
cl.set_val(row, 5, dgv.Rows[i].Cells[17].Value.ToString());
cl.set_val(row, 6, dgv.Rows[i].Cells[8].Value.ToString());
row++;
j++;
}
cl.save_as(path);
}
}
}
else
{
MessageBox.Show(
"Для создания инвентаризационного документа по аппаратной включите фильтр по аппаратной (Place2)");
}
}
private void Export_But_Click(object sender, EventArgs e)
{
string bp = "D:\\DocumentAssistant";
if (!Directory.Exists(bp))
{
Directory.CreateDirectory(bp);
}
if (File.Exists(bp + "\\xls.xlsx"))
{
string postfix = DateTime.Now.ToString("yyyy-MM-dd HH-mm-ss");
string filename = "Export-" + postfix + ".xlsx";
string path = bp + "\\" + filename;
File.Copy(bp + "\\xls.xlsx", path);
if (File.Exists(path))
{
int row = 4;
int j = 1;
XLS_Class cl = new XLS_Class(path);
cl.set_val(1, 2, DateTime.Now.ToString("D"));
cl.set_val(2, 2, Place2_CmBox.SelectedItem.ToString());
for (int i = 0; i < dgv.RowCount; i++)
{
cl.set_val(row, 0, j.ToString());
cl.set_val(row, 1, dgv.Rows[i].Cells[4].Value.ToString());
cl.set_val(row, 2, dgv.Rows[i].Cells[3].Value.ToString());
cl.set_val(row, 3, dgv.Rows[i].Cells[1].Value.ToString());
cl.set_val(row, 4, dgv.Rows[i].Cells[2].Value.ToString());
cl.set_val(row, 5, dgv.Rows[i].Cells[17].Value.ToString());
cl.set_val(row, 6, dgv.Rows[i].Cells[8].Value.ToString());
//cl.set_val(j, 7, dgv.Rows[i].Cells[4].Value.ToString());
row++;
j++;
}
cl.save_as(path);
}
}
}
public static bool Check_Both(XLS_Class xls, int start, int stop, int col, string table, string name)
{
return(Check_without_Fill_DGV(xls, start, stop, col, table, name, true) &&
Check_without_Fill_DGV(xls, start, stop, col, table, name, false));
}
