private void button1_Click(object sender, EventArgs e) { request_mas_of_base_elements(); int start = Convert.ToInt32(start_Tbox.Text); int stop = Convert.ToInt32(stop_Tbox.Text); List <int> del_index = new List <int>(); for (int i = start; i < stop; i++) { Compare_Element el = Compare_Element.get_el_as_xls_el_for_cmp(mcl, i).CloneElement(); string serial2 = el.Serial2; int index = mas.Serial2_base.IndexOf(serial2); if (index != -1) { Compare_Pare pr = mas.pre_mas[index].CloneComparePare(); pr.xls_el = el.CloneElement(); pr.check_equalence(Serial1_cm.Checked, Serial2_cm.Checked, Place_cm.Checked, Mark_cm.Checked, Date_cm.Checked, Prise_cm.Checked); mas.dual_mas.Add(pr.CloneComparePare()); del_index.Add(index); } else { Compare_Pare pr = new Compare_Pare(); pr.xls_el = el.CloneElement(); pr.check_equalence(Serial1_cm.Checked, Serial2_cm.Checked, Place_cm.Checked, Mark_cm.Checked, Date_cm.Checked, Prise_cm.Checked); mas.xls_only_mas.Add(pr.CloneComparePare()); } } for (int i = 0; i < mas.pre_mas.Count; i++) { if (!del_index.Contains(i)) { mas.pre_mas[i].check_equalence(Serial1_cm.Checked, Serial2_cm.Checked, Place_cm.Checked, Mark_cm.Checked, Date_cm.Checked, Prise_cm.Checked); mas.base_only_mas.Add(mas.pre_mas[i]); } } mas.all_mas = new List <Compare_Pare>(); mas.all_mas.AddRange(mas.dual_mas); mas.all_mas.AddRange(mas.xls_only_mas); mas.all_mas.AddRange(mas.base_only_mas); base_and_xls_dgv.Rows.Clear(); base_only_dgv.Rows.Clear(); xls_only_dgv.Rows.Clear(); fill_dgv_with_list(mas.dual_mas, false, base_and_xls_dgv); fill_dgv_with_list(mas.xls_only_mas, true, xls_only_dgv); fill_dgv_with_list(mas.base_only_mas, false, base_only_dgv); all_lab.Text += " " + (mas.base_only_mas.Count + mas.dual_mas.Count + mas.xls_only_mas.Count); full_lab.Text += " " + mas.dual_mas.Count; base_lab.Text += " " + mas.base_only_mas.Count; xls_lab.Text += " " + mas.xls_only_mas.Count; }
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 bool add_Element(Compare_Element el) { string zap = "insert into itemtable (itemtable.Serial,itemtable.Serial2," + "itemtable.Mark,itemtable.Type,itemtable.Status,itemtable.Place," + "itemtable.Text,itemtable.Text2,itemtable.Text3,itemtable.Text4,itemtable.Text5,itemtable.Text6 " + ",itemtable.Place2, itemtable.Prise, itemtable.OS, itemtable.Date,itemtable.Owner,itemtable.Status2)"; zap += " values(" + "'" + el.Serial + "'," + "'" + el.Serial2 + "'," + el.Markid + "," + el.Typeid + "," + el.Statusid + "," + el.Placeid + "," + "'" + el.Text + "'," + "'" + el.Text2 + "'," + "'" + el.Text3 + "'," + "'" + el.Text4 + "'," + "'" + el.Text5 + "'," + "'" + el.Text6 + "'," + el.Place2id + "," + "'" + el.Prise + "'," + el.OSID + "," + "'" + el.date + "'," + el.OwnerID + "," + el.Status2id + ")"; try { return(SQL_Class.Execute(zap)); } catch (Exception) { return(false); } }
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_Pare_Mas get_base_elements(int ownerID)//-- { Compare_Pare_Mas rett = new Compare_Pare_Mas(); string zap = "Select itemtable.ID,itemtable.Serial,itemtable.Serial2," + "itemtable.Mark,itemtable.Type,itemtable.Status,itemtable.Place," + "itemtable.Text,itemtable.Text2,itemtable.Text3,itemtable.Text4,itemtable.Text5,itemtable.Text6 " + ",itemtable.Place2, itemtable.Prise, itemtable.OS, itemtable.Date from itemtable where itemtable.Owner=" + ownerID; SQL_Class cl = new SQL_Class(); cl.ReadValues(zap); while (cl.SQL_DataReader.Read()) { Compare_Element el = new Compare_Element(); el.ID = cl.get_int(0); el.Serial = cl.get_string(1); el.Serial2 = cl.get_string(2); el.Markid = cl.get_int(3); el.Typeid = cl.get_int(4); el.Statusid = cl.get_int(5); el.Placeid = cl.get_int(6); el.Place2id = cl.get_int(13); el.Prise = cl.get_string(14); el.OSID = cl.get_int(15); el.date = cl.get_string(16); el.Text = cl.get_string(7); el.Text2 = cl.get_string(8); el.Text3 = cl.get_string(9); el.Text4 = cl.get_string(10); el.Text5 = cl.get_string(11); el.Text6 = cl.get_string(12); el.read_other_names_base(); Compare_Pare pare = new Compare_Pare(); pare.base_el = el; rett.pre_mas.Add(pare); rett.Serial2_base.Add(el.Serial2); } cl.Manualy_Close_Connection2(); for (int i = 0; i < rett.pre_mas.Count; i++) { rett.pre_mas[i].base_el.read_other_names_base(); } return(rett); }
public ElementWorkForm(Compare_Element el) { //edit InitializeComponent(); prepare_CmBox(); pr = new Compare_Pare(); pr.base_el = el; pr.xls_el = null; pr.full_pair = false; up_panel.Visible = false; load_data_from_pair(); }
} // for string public void reload_base_el() { changed = true; int id = pr.base_el.ID; Compare_Element el = FuncClass.get_Element(id); if (el != null) { pr.base_el = el; load_data_from_pair(); } }
public static Compare_Element get_Element(int id) { string zap = "Select itemtable.ID,itemtable.Serial,itemtable.Serial2," + "itemtable.Mark,itemtable.Type,itemtable.Status,itemtable.Place," + "itemtable.Text,itemtable.Text2,itemtable.Text3,itemtable.Text4,itemtable.Text5,itemtable.Text6 " + ",itemtable.Place2, itemtable.Prise, itemtable.OS, itemtable.Date, itemtable.Owner,itemtable.Status2 from itemtable where itemtable.ID=" + id; SQL_Class cl = new SQL_Class(); cl.ReadValues(zap); Compare_Element el = null; while (cl.SQL_DataReader.Read()) { el = new Compare_Element(); el.ID = cl.get_int(0); el.Serial = cl.get_string(1); el.Serial2 = cl.get_string(2); el.Markid = cl.get_int(3); el.Typeid = cl.get_int(4); el.Statusid = cl.get_int(5); el.Placeid = cl.get_int(6); el.Place2id = cl.get_int(13); el.Prise = cl.get_string(14); el.OSID = cl.get_int(15); el.date = cl.SQL_DataReader.GetDateTime(16); el.Status2id = cl.get_int(18); el.OwnerID = cl.get_int(17); el.Text = cl.get_string(7); el.Text2 = cl.get_string(8); el.Text3 = cl.get_string(9); el.Text4 = cl.get_string(10); el.Text5 = cl.get_string(11); el.Text6 = cl.get_string(12); el.read_other_names_base(); } cl.Manualy_Close_Connection2(); return(el); }
private void FillBase_Click(object sender, EventArgs e) //-------- { int start = Convert.ToInt32(start_Tbox.Text); int stop = Convert.ToInt32(stop_Tbox.Text); for (int i = start; i < stop; i++) { Compare_Element el = Compare_Element.get_el_as_base_el(mcl, i); string zap = "insert into itemtable (itemtable.Serial,itemtable.Serial2, itemtable.Mark, itemtable.Type, itemtable.Status,itemtable.Place, itemtable.Text,itemtable.Text2,itemtable.Text3,itemtable.Text4,itemtable.Text5,itemtable.Text6,itemtable.Owner," + "itemtable.Place2,itemtable.OS,itemtable.Date,itemtable.Prise,itemtable.Status2" + ") Values ('" + el.Serial + "','" + el.Serial2 + "'," + el.Markid + "," + el.Typeid + "," + el.Statusid + "," + el.Placeid + ",'" + el.Text + "','" + el.Text2 + "','" + el.Text3 + "','" + el.Text4 + "','" + el.Text5 + "',''," + el.OwnerID + "," + el.Place2id + "," + el.OSID + ",'" + el.date.ToString("yyyy-MM-dd") + "','" + el.Prise + "'," + el.Status2id + ")"; SQL_Class.Execute(zap); } }
private void Add_But_Click(object sender, EventArgs e) { Compare_Element el = new Compare_Element(); el.Serial = ser1.Text; el.Serial2 = ser21.Text; el.Text = t1.Text; el.Text2 = t2.Text; el.Text3 = t3.Text; el.Text4 = t4.Text; el.Text5 = t5.Text; el.Text6 = t6.Text; el.Prise = prise1.Text; el.date = date1.Value; el.Status2id = SQL_Class.ReadValueInt32("select ID from status2table where Status2 ='" + status21.SelectedItem + "'"); el.Typeid = SQL_Class.ReadValueInt32("select ID from typetable where Type ='" + type1.SelectedItem + "'"); el.Markid = SQL_Class.ReadValueInt32("select ID from marktable where Mark ='" + mark1.SelectedItem + "'"); el.Statusid = SQL_Class.ReadValueInt32("select ID from statustable where Status ='" + status1.SelectedItem + "'"); el.Placeid = SQL_Class.ReadValueInt32("select ID from placetable where Place ='" + place1.SelectedItem + "'"); el.Place2id = SQL_Class.ReadValueInt32("select ID from place2table where PLace2 ='" + place21.SelectedItem + "'"); el.OSID = SQL_Class.ReadValueInt32("select ID from ostable where OS ='" + os1.SelectedItem + "'"); el.OwnerID = SQL_Class.ReadValueInt32("select ID from ownertable where Owner ='" + owner1.SelectedItem + "'"); if (FuncClass.add_Element(el)) { Close(); } else { MessageBox.Show("Элемент не добавлен"); } }