public EditUserRolForm()
{
InitializeComponent();
notSaved = false;
sqlCon = new SQLDBConnect();
newDBcon = new SprDbConnect("spr_user_rol");
dgUserRol.DataSource = newDBcon.GetDataTable("spr_user_rol");
dgUserRol.Columns[0].HeaderText = "Код";
dgUserRol.Columns[0].Visible = false;
dgUserRol.Columns[0].DataPropertyName = "id";
dgUserRol.Columns[1].HeaderText = "Наименование";
dgControls.AutoGenerateColumns = false;
DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
/*
* column.HeaderText = "Код";
* column.Visible = false;
* column.DataPropertyName = "id";
* column.Name = "id";
* dgControls.Columns.Add(column);
*/
column = new DataGridViewTextBoxColumn();
column.HeaderText = "Наименование";
column.Visible = true;
column.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
column.DataPropertyName = "opisanie";
dgControls.Columns.Add(column);
DataGridViewCheckBoxColumn columnCheck =
new DataGridViewCheckBoxColumn();
{
columnCheck.Name = "enabled";
columnCheck.DataPropertyName = "enabled";
columnCheck.HeaderText = "Разрешено";
columnCheck.Width = 80;
columnCheck.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
}
dgControls.Columns.Add(columnCheck);
//Заполняем таблицу user_rol_access на случай появления новых контролов или групп пользователей
sqlCon.DoQuery(@"INSERT INTO user_rol_access
SELECT spr_user_controls.id AS id_user_controls, spr_user_rol.id AS id_user_rol
FROM spr_user_controls, spr_user_rol
WHERE spr_user_controls.id NOT IN (SELECT DISTINCT id_user_controls FROM user_rol_access) OR
spr_user_rol.id NOT IN (SELECT DISTINCT id_user_rol FROM user_rol_access)");
DataTable dt = sqlCon.GetDataTable("user_access",
@"SELECT user_rol_access.id, user_rol_access.id_user_rol, user_rol_access.enabled, spr_user_controls.opisanie FROM user_rol_access
LEFT JOIN spr_user_controls ON (user_rol_access.id_user_controls = spr_user_controls.id)");
DataView dv = new DataView(dt);
dgControls.DataSource = dv;
}
public UsersForm()
{
InitializeComponent();
newDBcon = new SprDbConnect("users", "spr_user_rol");
LoadGrid(dgUsers);
dgUsers.DataSource = newDBcon.GetDataTable("users");
}
public SprControls()
{
fcm = new FormControlManager();
InitializeComponent();
newDBcon = new SprDbConnect("spr_user_controls");
dgControls.DataSource = newDBcon.GetDataTable("spr_user_controls");
dgControls.Columns[0].HeaderText = "Код";
dgControls.Columns[0].Width = 50;
dgControls.Columns[0].DataPropertyName = "id";
dgControls.Columns[0].Visible = false;
dgControls.Columns[1].HeaderText = "Наименование формы";
dgControls.Columns[1].Width = 100;
dgControls.Columns[1].DataPropertyName = "name_form";
dgControls.Columns[1].Visible = false;
dgControls.Columns[2].HeaderText = "Наименование системное";
dgControls.Columns[2].Width = 180;
dgControls.Columns[2].DataPropertyName = "name";
dgControls.Columns[2].Visible = false;
dgControls.Columns[3].HeaderText = "Наименование элемента";
dgControls.Columns[3].Width = 150;
dgControls.Columns[3].DataPropertyName = "name_rus";
dgControls.Columns[4].HeaderText = "Описание";
dgControls.Columns[4].Width = 150;
dgControls.Columns[4].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
dgControls.Columns[4].DataPropertyName = "opisanie";
}
//Удалить уже существующие записи
private int DelExistRec(DataTable dtakus_spec)
{
DataTable dt_buf = dtakus_spec.Copy();
SprDbConnect newDbCon = new SprDbConnect("spec");
DataTable dtivr_spec = newDbCon.GetDataTable("spec");
int count = CompareTables(dt_buf, dtivr_spec, "last_name", "first_name", "patronymic", "birthdate");
dtMarkedNotExist = dt_buf;
return(count);
}
//private string departmentID;
public EmployeeForm()
{
InitializeComponent();
newDBcon = new SprDbConnect("employee");
LoadGrid(dgEmployee);
dgEmployee.AutoGenerateColumns = false;
dgEmployee.DataSource = newDBcon.GetDataTable("employee");
RegistryKey regKey = Registry.CurrentUser;
regKey = regKey.OpenSubKey("Software\\UFSIN\\ivrJournal");
String dbPath = regKey.GetValue("dbPath", @"c:\Program files\ufsin_rk\Дневник ИВР\divr.mdb").ToString();
//this.departmentID = ((MainForm)this.MdiParent).departmentID;
}
private void AddSpecId(DataTable dtBuf)
{
SprDbConnect newDbCon = new SprDbConnect("spec");
DataTable dtivr_spec = newDbCon.GetDataTable("spec");
foreach (DataRow relRow in dtBuf.Rows)
{
foreach (DataRow specRow in dtivr_spec.Rows)
{
if (specRow["id_ptk_akus"].ToString().Trim() == relRow["id_ptk_akus"].ToString().Trim())
{
relRow["id_spec"] = Convert.ToInt32(specRow["id"]);
break;
}
}
}
}
/*
* protected override CreateParams CreateParams
* {
* get
* {
* CreateParams myCp = base.CreateParams;
* myCp.ClassStyle = myCp.ClassStyle | CP_NOCLOSE_BUTTON ;
* return myCp;
* }
* }
*/
public SprForm(String nameSpr, String TextSpr)
{
InitializeComponent();
//this.departmentID = ((MainForm)this.MdiParent).departmentID;
this.nameSpr = nameSpr;
newDBcon = new SprDbConnect(nameSpr);
this.Text = TextSpr;
dgSpr.Columns.Add(new DataGridViewTextBoxColumn());
dgSpr.Columns[0].HeaderText = "Код";
dgSpr.Columns[0].Visible = false;
dgSpr.Columns[0].DataPropertyName = "id";
dgSpr.Columns.Add(new DataGridViewTextBoxColumn());
dgSpr.Columns[1].HeaderText = "Наименование";
dgSpr.Columns[1].DataPropertyName = "name";
if (nameSpr == "spr_party_number")
{
SprDbConnect sprDBcon = new SprDbConnect("department");
DataGridViewComboBoxColumn column = new DataGridViewComboBoxColumn();
{
column.DataPropertyName = "department_id";
column.HeaderText = "Учреждение";
column.DropDownWidth = 100;
column.Width = 90;
column.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
column.MaxDropDownItems = 10;
column.FlatStyle = FlatStyle.Flat;
column.DataSource = sprDBcon.GetDataTable("department");
column.ValueMember = "id";
column.DisplayMember = "name";
column.ReadOnly = true;
}
dgSpr.Columns.Add(column);
}
dgSpr.DataSource = newDBcon.GetDataTable(nameSpr);
dgSpr.AutoGenerateColumns = false;
}
private void dgWhere_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
if (dgWhere.Columns[dgWhere.CurrentCell.ColumnIndex].Name != "fields")
{
return;
}
if (dgWhere.Rows[e.RowIndex].Cells["fields"].Value == null)
{
return;
}
String id = dgWhere.Rows[e.RowIndex].Cells["fields"].Value.ToString();
String sprName = null;
foreach (DataRow row in dtListField.Select("id = '" + id + "'"))
{
sprName = row["spr"].ToString();
}
//MessageBox.Show(sprName);
if (sprName == String.Empty)
{
DataGridViewTextBoxCell tbcell = new DataGridViewTextBoxCell();
dgWhere.Rows[e.RowIndex].Cells["value"] = tbcell;
dgWhere.Rows[e.RowIndex].Cells["conditions"].ReadOnly = false;
return;
}
SprDbConnect sprCon = new SprDbConnect(sprName);
DataGridViewComboBoxCell cell = new DataGridViewComboBoxCell();
cell.DataSource = sprCon.GetDataTable(sprName);
cell.ValueMember = "id";
cell.DisplayMember = "name";
cell.DropDownWidth = 100;
cell.MaxDropDownItems = 7;
dgWhere.Rows[e.RowIndex].Cells["value"] = cell;
dgWhere.Rows[e.RowIndex].Cells["conditions"].Value = 1;
dgWhere.Rows[e.RowIndex].Cells["conditions"].ReadOnly = true;
}
private void bnLoadSpr_Click(object sender, EventArgs e)
{
int nation_count = akusDbCon.mapDataSpr(dtMarked, mainDbCon.GetDataTable("spr_nation"), "nation_name");
mainDbCon.UpdateDataTable("spr_nation");
int edu_count = akusDbCon.mapDataSpr(dtMarked, mainDbCon.GetDataTable("spr_edu"), "edu_name");
mainDbCon.UpdateDataTable("spr_edu");
int profession_count = akusDbCon.mapDataSpr(dtMarked, mainDbCon.GetDataTable("spr_profession"), "profession_name");
mainDbCon.UpdateDataTable("spr_profession");
int mstatus_count = akusDbCon.mapDataMstatus(dtMarked, mainDbCon.GetDataTable("spr_mstatus"), mainDbCon);
//mainDbCon.UpdateDataTable("spr_mstatus");
int degree_count = akusDbCon.mapDataSpr(akusDbCon.GetDataTable("relations"),
mainDbCon.GetDataTable("spr_degree"), "degree_name");
mainDbCon.UpdateDataTable("spr_degree");
int bonus_type_count = akusDbCon.mapDataSpr(akusDbCon.GetDataTable("bonus"),
mainDbCon.GetDataTable("spr_bonus_type"), "bonus_type_name");
mainDbCon.UpdateDataTable("spr_bonus_type");
int penalty_type_count = akusDbCon.mapDataSpr(akusDbCon.GetDataTable("penalty"),
mainDbCon.GetDataTable("spr_penalty_type"), "penalty_type_name");
mainDbCon.UpdateDataTable("spr_penalty_type");
int performers_count = akusDbCon.mapDataSpr(akusDbCon.GetDataTable("penalty"),
mainDbCon.GetDataTable("spr_performers"), "performer");
mainDbCon.UpdateDataTable("spr_performers");
MessageBox.Show("Национальности: " + nation_count.ToString() + "\n" +
"Образования: " + edu_count.ToString() + "\n" +
"Профессии: " + profession_count.ToString() + "\n" +
"Семейные положения: " + mstatus_count.ToString() + "\n" +
"Виды поощрений: " + bonus_type_count.ToString() + "\n" +
"Виды взысканий: " + penalty_type_count.ToString() + "\n" +
"Сотрудники: " + performers_count.ToString() + "\n" +
"Родственные отношения: " + degree_count.ToString(), "Добавлено новых записей в справочники");
}
private void LoadGrid(DataGridView dg)
{
DataGridViewTextBoxColumn textColumn = new DataGridViewTextBoxColumn();
{
textColumn.DataPropertyName = "id";
textColumn.Visible = false;
}
dg.Columns.Add(textColumn);
textColumn = new DataGridViewTextBoxColumn();
{
textColumn.DataPropertyName = "login";
textColumn.HeaderText = "Логин";
textColumn.Width = 60;
textColumn.MinimumWidth = 50;
textColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
}
dg.Columns.Add(textColumn);
textColumn = new DataGridViewTextBoxColumn();
{
textColumn.DataPropertyName = "passwd";
textColumn.HeaderText = "Пароль";
textColumn.Width = 60;
textColumn.MinimumWidth = 50;
textColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
}
dg.Columns.Add(textColumn);
DataGridViewComboBoxColumn column =
new DataGridViewComboBoxColumn();
{
column.DataPropertyName = "user_rol_id";
column.HeaderText = "Статус пользователя";
column.DropDownWidth = 150;
column.Width = 110;
column.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
column.MaxDropDownItems = 5;
column.FlatStyle = FlatStyle.Flat;
column.DataSource = newDBcon.GetDataTable("spr_user_rol");
column.ValueMember = "id";
column.DisplayMember = "name";
}
dg.Columns.Add(column);
textColumn = new DataGridViewTextBoxColumn();
{
textColumn.DataPropertyName = "last_name";
textColumn.HeaderText = "Фамилия";
textColumn.Width = 100;
textColumn.MinimumWidth = 70;
textColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
}
dg.Columns.Add(textColumn);
textColumn = new DataGridViewTextBoxColumn();
{
textColumn.DataPropertyName = "first_name";
textColumn.HeaderText = "Имя";
textColumn.Width = 100;
textColumn.MinimumWidth = 70;
textColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
}
dg.Columns.Add(textColumn);
textColumn = new DataGridViewTextBoxColumn();
{
textColumn.DataPropertyName = "patronymic";
textColumn.HeaderText = "Отчество";
textColumn.Width = 100;
textColumn.MinimumWidth = 70;
textColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
dg.Columns.Add(textColumn);
}
public SprProfilactForm()
{
InitializeComponent();
newDBcon = new SprDbConnect("spr_profilact_ychet", "enum_period");
dgListProfilact.Columns.Add(new DataGridViewTextBoxColumn());
dgListProfilact.Columns[0].DataPropertyName = "id";
dgListProfilact.Columns[0].HeaderText = "код";
dgListProfilact.Columns[0].Visible = false;
dgListProfilact.Columns.Add(new DataGridViewTextBoxColumn());
dgListProfilact.Columns[1].DataPropertyName = "name";
dgListProfilact.Columns[1].HeaderText = "Наименование";
dgListProfilact.Columns[1].Width = 150;
dgListProfilact.Columns[1].MinimumWidth = 150;
dgListProfilact.Columns[1].AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
DataGridViewCheckBoxColumn columnCheck =
new DataGridViewCheckBoxColumn();
{
columnCheck.DataPropertyName = "pasport";
columnCheck.HeaderText = "Паспорт";
columnCheck.Width = 50;
columnCheck.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
}
dgListProfilact.Columns.Add(columnCheck);
columnCheck =
new DataGridViewCheckBoxColumn();
{
columnCheck.DataPropertyName = "plan";
columnCheck.HeaderText = "План";
columnCheck.Width = 50;
columnCheck.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
}
dgListProfilact.Columns.Add(columnCheck);
DataGridViewComboBoxColumn column =
new DataGridViewComboBoxColumn();
{
column.DataPropertyName = "psiho_korrec_id";
column.HeaderText = "Периодичность коррекции";
column.DropDownWidth = 100;
column.Width = 90;
columnCheck.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
column.MaxDropDownItems = 3;
column.FlatStyle = FlatStyle.Flat;
column.DataSource = newDBcon.GetDataTable("enum_period");
column.ValueMember = "id";
column.DisplayMember = "name";
}
dgListProfilact.Columns.Add(column);
column =
new DataGridViewComboBoxColumn();
{
column.DataPropertyName = "psiho_obsled_id";
column.HeaderText = "Периодичность обследования";
column.DropDownWidth = 100;
column.Width = 90;
columnCheck.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
column.MaxDropDownItems = 3;
column.FlatStyle = FlatStyle.Flat;
column.DataSource = newDBcon.GetDataTable("enum_period");
column.ValueMember = "id";
column.DisplayMember = "name";
}
dgListProfilact.Columns.Add(column);
dgListProfilact.DataSource = newDBcon.GetDataTable("spr_profilact_ychet");
}
private void LoadGrid(DataGridView dg)
{
DataGridViewTextBoxColumn textColumn = new DataGridViewTextBoxColumn();
{
textColumn.DataPropertyName = "id";
textColumn.Visible = false;
}
dg.Columns.Add(textColumn);
SprDbConnect sprDBcon = new SprDbConnect("department");
DataGridViewComboBoxColumn column = new DataGridViewComboBoxColumn();
{
column.DataPropertyName = "department_id";
column.HeaderText = "Учреждение";
column.DropDownWidth = 100;
column.Width = 90;
column.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
column.MaxDropDownItems = 10;
column.FlatStyle = FlatStyle.Flat;
column.DataSource = sprDBcon.GetDataTable("department");
column.ValueMember = "id";
column.DisplayMember = "name";
column.ReadOnly = true;
}
dg.Columns.Add(column);
// textColumn = new DataGridViewTextBoxColumn();
// {
// textColumn.DataPropertyName = "department_id";
// textColumn.Visible = false;
// }
// dg.Columns.Add(textColumn);
textColumn = new DataGridViewTextBoxColumn();
{
textColumn.DataPropertyName = "last_name";
textColumn.HeaderText = "Фамилия";
textColumn.Width = 80;
textColumn.MinimumWidth = 70;
textColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
}
dg.Columns.Add(textColumn);
textColumn = new DataGridViewTextBoxColumn();
{
textColumn.DataPropertyName = "first_name";
textColumn.HeaderText = "Имя";
textColumn.Width = 80;
textColumn.MinimumWidth = 70;
textColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
}
dg.Columns.Add(textColumn);
textColumn = new DataGridViewTextBoxColumn();
{
textColumn.DataPropertyName = "patronymic";
textColumn.HeaderText = "Отчество";
textColumn.Width = 80;
textColumn.MinimumWidth = 70;
textColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
}
dg.Columns.Add(textColumn);
textColumn = new DataGridViewTextBoxColumn();
{
textColumn.DataPropertyName = "rank";
textColumn.HeaderText = "Звание";
textColumn.Width = 80;
textColumn.MinimumWidth = 70;
textColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
}
dg.Columns.Add(textColumn);
textColumn = new DataGridViewTextBoxColumn();
{
textColumn.DataPropertyName = "post";
textColumn.HeaderText = "Должность";
textColumn.Width = 80;
textColumn.MinimumWidth = 70;
textColumn.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
}
dg.Columns.Add(textColumn);
}
