private void frmF3_Load(object sender, EventArgs e) { Tag = IdF3; WithSave = true; my.RdStream(NMrab, my.Login + "ActsZak1.txt"); RdWr(my.Dostup); listBox1.SelectedIndex = listBox1.Items.Count - 1; Edneeis.Controls.MultiColumnComboBox.Column i1 = new Edneeis.Controls.MultiColumnComboBox.Column(); i1.ColumnMember = "PersName"; i1.AutoSize = true; i1.Header = ""; FromIsp.Columns.Add(i1); Edneeis.Controls.MultiColumnComboBox.Column i2 = new Edneeis.Controls.MultiColumnComboBox.Column(); i2.ColumnMember = "PostName"; i2.AutoSize = false; i2.Header = ""; i2.Width = 200; FromIsp.Columns.Add(i2); FromIsp.ShowColumnHeader = false; FromIsp.ShowColumns = true; Edneeis.Controls.MultiColumnComboBox.Column i3 = new Edneeis.Controls.MultiColumnComboBox.Column(); i3.ColumnMember = "PersName"; i3.AutoSize = true; i3.Header = ""; FromZak.Columns.Add(i3); Edneeis.Controls.MultiColumnComboBox.Column i4 = new Edneeis.Controls.MultiColumnComboBox.Column(); i4.ColumnMember = "PostName"; i4.AutoSize = false; i4.Header = ""; i4.Width = 200; FromZak.Columns.Add(i4); FromZak.ShowColumnHeader = false; FromZak.ShowColumns = true; }
private void frmActsSub_Load(object sender, EventArgs e) { //Set objRowLoop = new clsRowLoop(); string strsql = ""; //SSRow Row1 = null; //ПриОткрытии = true; this.Top = 0; this.Left = 0; switch (my.Nbut) { case 4: Text = "Субподряд " + my.UpredName; gp = my.Upred; break; case 0: gp = my.Szap; break; default: my.sc.CommandText = "SELECT Name, pred FROM dbo.VidGPDog WHERE IdVidDog = " + my.Nbut.ToString(); my.cn.Open(); SqlDataReader dr = my.sc.ExecuteReader(); if (!dr.Read()) { MessageBox.Show(@"Нет данных по выбранному договору!"); my.cn.Close(); } else { Text = "Субподряд " + dr[0].ToString().Substring(10, dr[0].ToString().Length - 10); gp = dr[1].ToString(); my.cn.Close(); dr.Close(); } break; } //Set rs = null; //this.ркн_ТекМес = true; rbTekMes.Checked = true; strsql = "SELECT iddog,Zak, RegNomer, ZakName, IspName, Date_1,Isp,PredmetDog,Srok FROM v_DogForAktSub WHERE ((Zak='" + ((gp == "1726" | gp == "1725") ? "002" : gp) + "' and Vnut=1)"; strsql = strsql + " or (Zak='" + gp + "' and VneshDog=1)) order by ZakName, IspName,RegNomer"; //rs.CursorLocation = adUseClient; SqlDataAdapter sda = new SqlDataAdapter(strsql, my.sconn); DataSet ds = new DataSet(); sda.Fill(ds); idDog.DataSource = ds.Tables[0]; idDog.ValueMember = "IdDog"; idDog.DisplayMember = "RegNomer"; Edneeis.Controls.MultiColumnComboBox.Column i3 = new Edneeis.Controls.MultiColumnComboBox.Column(); i3.ColumnMember = "RegNomer"; i3.AutoSize = true; this.idDog.Columns.Add(i3); Edneeis.Controls.MultiColumnComboBox.Column i4 = new Edneeis.Controls.MultiColumnComboBox.Column(); i4.ColumnMember = "ZakName"; i4.Width = 100; this.idDog.Columns.Add(i4); Edneeis.Controls.MultiColumnComboBox.Column i5 = new Edneeis.Controls.MultiColumnComboBox.Column(); i5.ColumnMember = "IspName"; i5.Width = 100; this.idDog.Columns.Add(i5); Edneeis.Controls.MultiColumnComboBox.Column i6 = new Edneeis.Controls.MultiColumnComboBox.Column(); i6.ColumnMember = "Date_1"; i6.Width = 100; this.idDog.Columns.Add(i6); Edneeis.Controls.MultiColumnComboBox.Column i7 = new Edneeis.Controls.MultiColumnComboBox.Column(); i7.ColumnMember = "PredmetDog"; i7.Width = 400; this.idDog.Columns.Add(i7); idDog.ShowColumns = true; sda.Dispose(); ds.Dispose(); idDog.SelectedValue = 0; my.FillDC(idIstFin, 18, ""); //DgvActs.DataSource = ds.Tables[0]; SpisokObj(); SpisokUsF2(); SelAkts(); checkBox1_CheckedChanged(null, null); RdWr(my.Dostup); }