private void bnLoad_Click(object sender, EventArgs e) { DataTable dt_buf = sqlCon.GetDataTable("spec"); String str = null; foreach (DataRow row in dt_buf.Rows) { if (Convert.IsDBNull(row["selected"])) { continue; } if (Convert.ToBoolean(row["selected"]) == true) { str = (str == null) ? str + Convert.ToInt32(row["id"]) : str + ", " + Convert.ToInt32(row["id"]); } } if (str == null) { MessageBox.Show("Выберите осужденных, которых вы хотите выгрузить"); return; } //MessageBox.Show(str); IVRTransfer ivr = new IVRTransfer(); ivr.UploadData(str, cbMoveToArh.Checked); }
public IVRReceiveForm(FormMode fm) { InitializeComponent(); this.fm = fm; DataGridViewTextBoxColumn textColumn = new DataGridViewTextBoxColumn(); { textColumn.DataPropertyName = "id"; textColumn.HeaderText = "код"; textColumn.Width = 30; textColumn.MinimumWidth = 50; textColumn.Visible = false; textColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; } dgIVRList.Columns.Add(textColumn); textColumn = new DataGridViewTextBoxColumn(); { textColumn.DataPropertyName = "last_name"; textColumn.HeaderText = "Фамилия"; textColumn.Width = 100; textColumn.MinimumWidth = 90; textColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; } dgIVRList.Columns.Add(textColumn); textColumn = new DataGridViewTextBoxColumn(); { textColumn.DataPropertyName = "first_name"; textColumn.HeaderText = "Имя"; textColumn.Width = 100; textColumn.MinimumWidth = 90; textColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; } dgIVRList.Columns.Add(textColumn); textColumn = new DataGridViewTextBoxColumn(); { textColumn.DataPropertyName = "patronymic"; textColumn.HeaderText = "Отчество"; textColumn.Width = 100; textColumn.MinimumWidth = 90; textColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill; } dgIVRList.Columns.Add(textColumn); textColumn = new DataGridViewTextBoxColumn(); { textColumn.DataPropertyName = "birthdate"; textColumn.HeaderText = "Дата рождения"; textColumn.Width = 80; textColumn.MinimumWidth = 80; textColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; } dgIVRList.Columns.Add(textColumn); DataGridViewCheckBoxColumn columnCheck = new DataGridViewCheckBoxColumn(); { columnCheck.Name = "selected"; columnCheck.DataPropertyName = "selected"; columnCheck.HeaderText = "Метка"; columnCheck.Width = 50; columnCheck.AutoSizeMode = DataGridViewAutoSizeColumnMode.None; } dgIVRList.Columns.Add(columnCheck); dgIVRList.AutoGenerateColumns = false; bnLoad.Enabled = false; ivr = new IVRTransfer(); }