public SQLDBConnectLite() { OleDbConnectionStringBuilder bldr = new OleDbConnectionStringBuilder(); bldr.DataSource = IVRShared.GetDBPath(); bldr.Provider = DataProvider; // ”казываем провайдера bldr.Add("Jet OLEDB:Database Password", "ivr32a"); OleDbCon = new OleDbConnection(bldr.ConnectionString); }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { backgroundWorker.ReportProgress(0, "Загрузка данных..."); newDBcon = new MainDBConnect(IVRShared.GetDBPath()); IsPresentView = new DataView(newDBcon.GetDataTable("spec")); IsPresentView.RowFilter = "is_present = true"; backgroundWorker.ReportProgress(100, "Загрузка завершена!"); }
private void dgSpr_UserDeletingRow(object sender, DataGridViewRowCancelEventArgs e) { if (!IVRShared.IsCurrentUserAdmin()) { MessageBox.Show("Удалять записи может только Пользователь с правами Администратора!"); e.Cancel = true; } else { newDBcon.UpdateDataTable(nameSpr); } }
//public SQLDBConnect(String tableName, String stringSQL) public SQLDBConnect() { OleDbConnectionStringBuilder bldr = new OleDbConnectionStringBuilder(); bldr.DataSource = IVRShared.GetDBPath(); bldr.Provider = DataProvider; // Указываем провайдера bldr.Add("Jet OLEDB:Database Password", "ivr32a"); OleDbCon = new OleDbConnection(bldr.ConnectionString); //dataAdapter = new OleDbDataAdapter(); da = new Dictionary <string, OleDbDataAdapter>(); sprSet = new DataSet(); }
private void bnDel_Click(object sender, EventArgs e) { if (((DataView)dgArchive.DataSource).Count == 0) { return; } if (!IVRShared.IsCurrentUserAdmin()) { MessageBox.Show("Удалять записи может только Пользователь с правами Администратора!"); return; } DialogResult result = MessageBox.Show("Вы действительно хотите удалить запись из архива? Дальнейшее восстановление будет невозможно!", "Сообщение", MessageBoxButtons.YesNo); if (result == DialogResult.No) { return; } int RowIndex = 0; RowIndex = dgArchive.CurrentRow.Index; DataRow row = ((DataView)dgArchive.DataSource)[RowIndex].Row; SQLDBConnectLite sqlCon = new SQLDBConnectLite(); sqlCon.DoQuery("DELETE FROM spec_psycho WHERE (id_spec=" + row["id"].ToString() + ")"); sqlCon.DoQuery("DELETE FROM relations WHERE (id_spec=" + row["id"].ToString() + ")"); sqlCon.DoQuery("DELETE FROM prev_conv WHERE (id_spec=" + row["id"].ToString() + ")"); sqlCon.DoQuery("DELETE FROM party WHERE (id_spec=" + row["id"].ToString() + ")"); sqlCon.DoQuery("DELETE FROM profilact_ychet WHERE (id_spec=" + row["id"].ToString() + ")"); sqlCon.DoQuery("DELETE FROM bonus WHERE (id_spec=" + row["id"].ToString() + ")"); sqlCon.DoQuery("DELETE FROM penalty WHERE (id_spec=" + row["id"].ToString() + ")"); sqlCon.DoQuery("DELETE FROM ivr WHERE (id_spec=" + row["id"].ToString() + ")"); sqlCon.DoQuery("DELETE FROM psycho_char WHERE (id_spec=" + row["id"].ToString() + ")"); sqlCon.DoQuery("DELETE FROM resolution WHERE (id_spec=" + row["id"].ToString() + ")"); sqlCon.DoQuery("DELETE FROM results WHERE (id_spec=" + row["id"].ToString() + ")"); sqlCon.DoQuery("DELETE FROM spec WHERE (id=" + row["id"].ToString() + ")"); RefreshDG(); }
private Boolean GetControlStatus(String formName, String ctlName) { String rolID = IVRShared.GetCurrentUserRol().ToString(); String ctlID = null; String result = null; //DataTable dt = sqlCon.GetDataTable("spr_user_controls", "SELECT * FROM spr_user_controls"); DataTable dt = sqlCon.GetDataTable("spr_user_controls"); foreach (DataRow row in dt.Select("name_form='" + formName + "' AND name='" + ctlName + "'")) { ctlID = Convert.ToString(row["id"]); } if (String.IsNullOrEmpty(ctlID)) { return(false); } DataTable dtURA = sqlCon.GetDataTable("user_rol_access"); foreach (DataRow row in dtURA.Select("id_user_rol=" + rolID + " AND id_user_controls=" + ctlID + "")) { result = Convert.ToString(row["enabled"]); } // String result = sqlCon.GetValue("enabled", @"SELECT enabled FROM user_rol_access // WHERE (id_user_rol=" + rolID + ") AND " + // "(id_user_controls=" + ctlID + ")"); if (String.IsNullOrEmpty(result)) { return(false); } Boolean status = Convert.ToBoolean(result); return(status); }
private void tsbDelete_Click(object sender, EventArgs e) { if (!IVRShared.IsCurrentUserAdmin()) { MessageBox.Show("Удалять записи может только Пользователь с правами Администратора!"); return; } int index = dgListProfilact.CurrentRow.Index; if ((index != -1) & (index != dgListProfilact.NewRowIndex)) { try { dgListProfilact.Rows.RemoveAt(index); newDBcon.UpdateDataTable("spr_profilact_ychet"); } catch { MessageBox.Show("Запись в базе не обнаружена!!!", "Сообщение о базе", MessageBoxButtons.OK, MessageBoxIcon.Hand); } } }
public void SetFormControlStatus(Form f) { if (IVRShared.IsCurrentUserAdmin()) { return; } ArrayList ctlList = GetAllControls(f); String formName = f.Name; foreach (Object obj in ctlList) { if (obj is Button) { String name = ((Button)obj).Name; ((Button)obj).Enabled = GetControlStatus(formName, name); // ((Button)obj).Update(); } else if (obj is ToolStripItem) { String name = ((ToolStripItem)obj).Name; ((ToolStripItem)obj).Enabled = GetControlStatus(formName, name); } } }