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); }
public void Close_form() { this.Close(); Class_SQL.CloseConnection(); }