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