public Main()
{
InitializeComponent();
db = new DBconnection();
db.DBConnection();
//db.GetCategory(TestTreeView);
}
public EmployeeList(string plant)
{
InitializeComponent();
DBconnection db = new DBconnection();
db.DBConnection();
EmployeeTreeView1.Nodes.Add("공장1");
/** ListView에 값 뿌려주기
*
* DataTable dt = db.GetEmployeeList(plant);
* employeeListView.BeginUpdate();
* foreach(DataRow dr in dt.Rows)
* {
* ListViewItem item = new ListViewItem();
* item.Text = dr[0].ToString();
* for(int i = 1; i < dt.Columns.Count; i++)
* {
* item.SubItems.Add(dr[i].ToString());
* }
* employeeListView.Items.Add(item);
* }*/
}
public BookInsert(Main main)
{
InitializeComponent();
initializeDateTimePicker();
db = new DBconnection();
db.DBConnection();
this.main = main;
}
public PlantList()
{
InitializeComponent();
db = new DBconnection();
db.DBConnection();
string Query = "select plant from TEST_SYSTEM_CODE where plant != 'admin' group by plant";
PlantListGrid.DataSource = db.QueryExeCute(Query);
}
public RentForm(string bookNum, string bookTitle, string bookPublisher, string bookWriter)
{
InitializeComponent();
db = new DBconnection();
db.DBConnection();
db.GetUsersList(userListView);
bookNumTB.Text = bookNum;
bookTilteTB.Text = bookTitle;
PublisherTB.Text = bookPublisher;
WriterTB.Text = bookWriter;
this.bookNum = bookNum;
}
public EmployeeInsert()
{
InitializeComponent();
db = new DBconnection();
db.DBConnection();
string Query = "select plant from TEST_SYSTEM_CODE where plant != 'admin' group by plant";
DataTable dt = db.QueryExeCute(Query);
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int j = 0; j < dt.Columns.Count; j++)
{
var cell = dt.Rows[i][j];
plantcombox.Items.Add(cell);
}
}
}
public UserInsert(Main main)
{
InitializeComponent();
db = new DBconnection();
db.DBConnection();
}
public PlantInsert_from()
{
InitializeComponent();
db = new DBconnection();
db.DBConnection();
}
