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