private void buttonIMPORT_Click(object sender, EventArgs e)
{
MyApp = new Excel.Application();
MyApp.Visible = false;
MyBook = MyApp.Workbooks.Open(textBox1.Text);
hhSheet = (Excel.Worksheet)MyBook.Sheets[1];
tonSheet = (Excel.Worksheet)MyBook.Sheets[2];
long hhCount = hhSheet.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell).Row;
long khoCount = tonSheet.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell).Column;
DataInstance.Instance().DBContext();
// HANG HOA
for (int index = 2; index <= hhCount; index++)
{
System.Array MyValues = (System.Array)hhSheet.get_Range("A" +
index.ToString(), "B" + index.ToString()).Cells.Value;
DataInstance.Instance().DBContext().AddToHANG_HOA(new HANG_HOA
{
NAME = MyValues.GetValue(1, 1).ToString(),
UNIT = MyValues.GetValue(1, 2).ToString(),
});
}
// KHO
for (int index = 2; index <= khoCount; index++)
{
string MyValues = tonSheet.Cells[1, index].Value;
DataInstance.Instance().DBContext().AddToKHOes(new KHO
{
NAME = MyValues,
TYPE = MKho.KHO_HANG
});
DataInstance.Instance().DBContext().SaveChanges();
for (int i = 2; i <= hhCount; i++)
{
long sl = long.Parse(tonSheet.Cells[i, index].Value.ToString());
long dongia = long.Parse(hhSheet.Cells[i, 3].Value.ToString());
DataInstance.Instance().DBContext().AddToNHAP_HANG(new NHAP_HANG
{
MAKHO = MKho.GetIDbyName(tonSheet.Cells[1, index].Value.ToString()),
MANCC = -1,
MAHH = MHangHoa.GetIDbyName(hhSheet.Cells[i, 1].Value.ToString()),
SO_LUONG = sl,
SL_CON_LAI = sl,
DON_GIA_MUA = dongia,
NGAY_NHAP = DateTime.Now.Date,
CREATED_AT = DateTime.Now
});
}
}
DataInstance.Instance().DBContext().SaveChanges();
MessageBox.Show("Cập nhật dữ liệu thành công\nVui lòng khởi động lại chương trình");
MyBook.Close();
MyApp.Quit();
MHeTHong.Set(MHeTHong.DATE, DateTime.Now.ToLongDateString());
Application.Exit();
}
