private static string UserName()
{
Class_SQL.OpenConnection();
IIdentity identity = WindowsIdentity.GetCurrent();
string ManhUser = (identity.Name).Substring(((identity.Name)).IndexOf(@"\") + 1, (identity.Name).Length - (((identity.Name)).IndexOf(@"\") + 1));
return(ManhUser);
}
public RegForm()
{
InitializeComponent();
ComboBox_Reg_Login.AutoCompleteMode = AutoCompleteMode.SuggestAppend;
ComboBox_Reg_Login.AutoCompleteSource = AutoCompleteSource.ListItems;
Class_SQL.OpenConnection();
this.ComboBox_Reg_Login.Focus();
Class_SQL.LoadComboBox(this.ComboBox_Reg_Login, "select user_name as 'ID', description as 'NAME' from bi.dbo.ABS_USER_PROFILE where active= 'Y' and DOSTUP_ABS = N'Y' order by description asc");
}
public void Load_Lib_EN()
{
Class_SQL.OpenConnection();
Class_SQL.LoadGridDB(dataGrid_Library, "select KEY_ID as TID,NAME,ACTIVE from bi.dbo.ABS_EN ");
Class_SQL.CloseConnection();
dataGrid_Library.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGrid_Library.Columns["NAME"].HeaderText = "Наименование";
dataGrid_Library.Columns["ACTIVE"].HeaderText = "Статус";
dataGrid_Library.Columns["TID"].Visible = false;
}
public void Load_Lib_Dop_Operation()
{
Class_SQL.OpenConnection();
Class_SQL.LoadGridDB(dataGrid_Library, "select o.TID, o.NAME, o.DOP_NAME as UROVEN2,e.NAME as NAME_EN ,o.ACTIVE,e.KEY_ID from bi.dbo.ABS_OPERATION o join bi.dbo.ABS_EN e on o.KEY_EN=e.KEY_ID");
Class_SQL.CloseConnection();
dataGrid_Library.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGrid_Library.Columns["NAME"].HeaderText = "Наименование";
dataGrid_Library.Columns["UROVEN2"].HeaderText = " Уровень 2";
dataGrid_Library.Columns["NAME_EN"].HeaderText = "Ед Измерения";
dataGrid_Library.Columns["ACTIVE"].HeaderText = "Статус";
dataGrid_Library.Columns["TID"].Visible = false;
dataGrid_Library.Columns["KEY_ID"].Visible = false;
}
public void Load_Lib_Dop_Material()
{
Class_SQL.OpenConnection();
Class_SQL.LoadGridDB(dataGrid_Library, "select m.TID, m.name as NAME , POD_NAME as UROVEN2, e.NAME as NAME_EN,m.ACTIVE, e.KEY_ID from bi.dbo.ABS_MATERIAL m join bi.dbo.ABS_EN e on m.KEY_EN=e.KEY_ID");
Class_SQL.CloseConnection();
dataGrid_Library.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dataGrid_Library.Columns["NAME"].HeaderText = "Наименование";
dataGrid_Library.Columns["UROVEN2"].HeaderText = " Уровень 2";
dataGrid_Library.Columns["NAME_EN"].HeaderText = "Ед Измерения";
dataGrid_Library.Columns["ACTIVE"].HeaderText = "Статус";
dataGrid_Library.Columns["TID"].Visible = false;
dataGrid_Library.Columns["KEY_ID"].Visible = false;
}
// Проверка уровня Администратора для снятия ограничения блокировок по заявкам
public static int DostupAdmin(string UserName)
{
int Result = 0;
int IdGroup = 0;
Class_SQL.OpenConnection();
IdGroup = Convert.ToInt32(Class_SQL.SelectString("select isnull(SECURITY_GROUP_ID,1) from aurora.ils.dbo.USER_PROFILE where USER_NAME = N'" + UserName + "'"));
if ((Class_SQL.SelectString("select isnull(SECURITY_GROUP,'n/a' ) from aurora.ils.dbo.SECURITY_GROUP where OBJECT_ID=" + IdGroup)) == "Administrators")
{
Result = 1;
}
Class_SQL.CloseConnection();
return(Result);
}
