public ProfilePsychoForm(ChildDBConnect newDbCon, int idSpec, string typeDoc, DataRow selRow)
{
InitializeComponent();
this.selRow = selRow;
pd = new PsychoData();
this.IsNew = false;
this.dbCon = newDbCon;
this.idSpec = idSpec;
this.typeDoc = typeDoc;
tbName.Text = selRow["name"].ToString();
// mtbDateDoc.Text = selRow["date_doc"].ToString();
dtDateDoc.Text = selRow["date_doc"].ToString();
if (selRow["psycho_doc"] == null)
{
bnOpen.Enabled = false;
}
else
if (!Convert.IsDBNull(selRow["psycho_doc"]))
{
bufferDoc = (Byte[])selRow["psycho_doc"]; //System.DBNull
}
else
{
bnOpen.Enabled = false;
}
}
public ProfilePsychoForm(ChildDBConnect newDbCon, int idSpec, string typeDoc)
{
InitializeComponent();
pd = new PsychoData();
this.IsNew = true;
this.dbCon = newDbCon;
this.idSpec = idSpec;
this.typeDoc = typeDoc;
bnOpen.Enabled = false;
}
private void LoadPsycho()
{
// dbCon = new ChildDBConnect(idSpec, "spec_psycho");
dbCon = new ChildDBConnect(idSpec, "spec_psycho", typeDoc);
dgPsycho.Columns.Add(new DataGridViewTextBoxColumn());
dgPsycho.Columns[0].DataPropertyName = "id";
dgPsycho.Columns[0].HeaderText = "код";
dgPsycho.Columns[0].Visible = false;
dgPsycho.Columns.Add(new DataGridViewTextBoxColumn());
dgPsycho.Columns[1].DataPropertyName = "id_spec";
dgPsycho.Columns[1].HeaderText = "код";
dgPsycho.Columns[1].Visible = false;
CalendarColumn col = new CalendarColumn();
{
col.DataPropertyName = "date_doc";
col.HeaderText = "Дата документа";
col.Width = 90;
col.MinimumWidth = 90;
col.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
}
dgPsycho.Columns.Add(col);
DataGridViewTextBoxColumn textColumn = new DataGridViewTextBoxColumn();
{
textColumn.DataPropertyName = "name";
textColumn.HeaderText = "Наименование документа";
textColumn.Width = 200;
textColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
dgPsycho.Columns.Add(textColumn);
dgPsycho.DataSource = new DataView(dbCon.GetDataTable("spec_psycho"));
}
