private void Load_Transaction(string Tid)
{
Console.WriteLine(" tid = " + Tid);
Class_SQL.LoadGridDB(DGW_list, "select tid, add_date_time, messanger, USER_NAME from bi.dbo.ABS_TRANSACTION_HISTORY where hdr_tid = N'" + Tid + "' order by tid");
DGW_list.Columns["add_date_time"].HeaderText = "Дата и время изменения";
DGW_list.Columns["tid"].Visible = false;
DGW_list.Columns["messanger"].Visible = false;
DGW_list.Columns["USER_NAME"].Visible = false;
DGW_list.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
}
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;
}
