public NhaCungCap()
{
InitializeComponent();
int sever = 1;
database.pickSever(sever);
funcShare = new functionShare(sever);
}
public ThongKe()
{
InitializeComponent();
demoChartDoughnut();
demoChartColumn();
db.pickSever(1);
functionShare share = new functionShare(1);
}
private void NhanVien_Load(object sender, EventArgs e)
{
int sever = 1;
database.pickSever(sever);
funcShare = new functionShare(sever);
//dbAccess.connection.Open();
//database.createConn();
FillData();
}
public PhieuNhap()
{
InitializeComponent();
int sever = 1;
database.pickSever(sever);
funcShare = new functionShare(sever);
createDataTable(out dt);
goiY(textbox_nv, "select id from nhan_vien");
goiY(textbox_ncc, "select id from nha_cung_cap");
goiY(textbox_item, "select id from mat_hang");
goiY(textbox_donvi, "select distinct don_vi from chi_tiet_phieu_nhap");
}
public ChiTietPhieuNhap(string phieu_nhap_id, string item_id, string so_luong, string don_gia, string don_vi)
{
InitializeComponent();
this.Location = new Point(870, 350);
this.so_luong = so_luong;
this.don_gia = don_gia;
this.don_vi = don_vi;
this.phieu_nhap_id = phieu_nhap_id;
this.item_id = item_id;
textbox_soluong.Text = so_luong;
textbox_donvi.Text = don_vi;
textbox_cost.Text = don_gia;
funcShare = new functionShare(1);
database.pickSever(1);
string query = "SELECT ten FROM mat_hang WHERE id=" + item_id;
cmd = new SqlCommand(query);
DataTable dataTable = new DataTable();
database.pushDataTable(cmd, dataTable);
label_ten.Text = dataTable.Rows[0]["ten"].ToString();
}
public QuayHang()
{
InitializeComponent();
funcShare = new functionShare(2);
}
public LoaiHang()
{
InitializeComponent();
funcShare = new functionShare(0);
}
public MatHang()
{
InitializeComponent();
// db.pickSever(1);
funcShare = new functionShare();
}
public ThongBao()
{
InitializeComponent();
database.pickSever(1);
funcShare = new functionShare(1);
}
public QLXuat()
{
InitializeComponent();
funcShare = new functionShare(0);
}
