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