void LoadOrderDetails() { Class.clsListOrder cls = new Class.clsListOrder(); cls.OrderCode = ""; dtOrderDetail = cls.tbOrderDetails_GetByCode(); gridItem.DataSource = dtOrderDetail; dtOrderDetail.Clear(); }
void LoadOrderDetails(string Ordercode) { Class.clsListOrder cls = new Class.clsListOrder(); cls.OrderCode = Ordercode; dtOrderDetail = cls.tbOrderDetails_GetByCode(); gridItem.DataSource = dtOrderDetail; cls.OrderCode = ""; dtOrderDetailTemp = cls.tbOrderDetails_GetByCode(); }
//xuat du lieu tu grid ra table file excel private void btnExportFile_Click(object sender, EventArgs e) { try { if (gridItemDetail.SelectedRowsCount > 0) { int[] selectedRows = gridItemDetail.GetSelectedRows(); object[] result = new object[selectedRows.Length]; DataTable dt = new DataTable(); dt.Columns.Add("SoHD"); dt.Columns.Add("NgayDN"); dt.Columns.Add("NhaCC"); dt.Columns.Add("MoTa"); dt.Columns.Add("SoLuong"); dt.Columns.Add("DonVi"); dt.Columns.Add("Gia"); dt.Columns.Add("ThanhTien"); dt.Columns.Add("VAT"); for (int i = 0; i < selectedRows.Length; i++) { int rowHandle = selectedRows[i]; if (!gridItemDetail.IsGroupRow(rowHandle)) { result[i] = gridItemDetail.GetRowCellValue(rowHandle, colOrderCode); DataRow dr = dt.NewRow(); dr["SoHD"] = gridItemDetail.GetRowCellValue(rowHandle, colOrderCode); dr["NgayDN"] = "'" + ((DateTime)gridItemDetail.GetRowCellValue(rowHandle, colDateSuggest)).ToString("dd/MM/yyyy"); dr["NhaCC"] = gridItemDetail.GetRowCellValue(rowHandle, colSupplierName); Class.clsListOrder cls = new Class.clsListOrder(); //xu ly in cac chi tiet hoa don tu vi tri tren luoi dua vao ordercode string code = gridItemDetail.GetRowCellValue(rowHandle, colOrderCode).ToString(); cls.OrderCode = code; DataTable dtct = cls.tbOrderDetails_GetByCode(); if (dtct.Rows.Count > 0) { dr["MoTa"] = dtct.Rows[0]["Describe"].ToString(); dr["SoLuong"] = dtct.Rows[0]["Number"].ToString(); dr["DonVi"] = dtct.Rows[0]["Unit"].ToString(); dr["Gia"] = dtct.Rows[0]["Price"].ToString(); dr["ThanhTien"] = dtct.Rows[0]["Monetize"].ToString(); } dr["VAT"] = gridItemDetail.GetRowCellValue(rowHandle, colVAT); dt.Rows.Add(dr); int soct = dtct.Rows.Count; if (soct > 1) { for (int ii = 1; ii < soct; ii++) { DataRow dr1 = dt.NewRow(); dr1["MoTa"] = dtct.Rows[ii]["Describe"].ToString(); dr1["SoLuong"] = dtct.Rows[ii]["Number"].ToString(); dr1["DonVi"] = dtct.Rows[ii]["Unit"].ToString(); dr1["Gia"] = dtct.Rows[ii]["Price"].ToString(); dr1["ThanhTien"] = dtct.Rows[ii]["Monetize"].ToString(); dt.Rows.Add(dr1); } } } } // xuat excel SaveFileDialog saveFile = new SaveFileDialog(); saveFile.Filter = "Excel File|*.xls"; saveFile.Title = "Exprot to Excel File"; saveFile.ShowDialog(); if (saveFile.FileName != "") { Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; object misValue = System.Reflection.Missing.Value; xlApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Add(misValue); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); xlWorkSheet.Cells[1, 1] = "Số HĐ"; xlWorkSheet.Cells[1, 2] = "Ngày đề nghị"; xlWorkSheet.Cells[1, 3] = "Nhà Cung cấp"; xlWorkSheet.Cells[1, 4] = "Mô tả"; xlWorkSheet.Cells[1, 5] = "Số lượng"; xlWorkSheet.Cells[1, 6] = "Đơn vị tính"; xlWorkSheet.Cells[1, 7] = "Đơn Giá"; xlWorkSheet.Cells[1, 8] = "Thành tiền"; xlWorkSheet.Cells[1, 9] = "VAT"; object[,] Array_Record; Array_Record = new object[dt.Rows.Count, dt.Columns.Count]; for (int i = 0; i < dt.Rows.Count; i++) { for (int j = 0; j < dt.Columns.Count; j++) { Array_Record[i, j] = dt.Rows[i][j].ToString(); } } xlWorkSheet.get_Range("A2", "I" + (dt.Rows.Count + 1)).Value = Array_Record; xlWorkBook.SaveAs(saveFile.FileName, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); xlWorkBook.Close(true, misValue, misValue); xlApp.Quit(); releaseObject(xlWorkSheet); releaseObject(xlWorkBook); releaseObject(xlApp); MessageBox.Show("Xuất file thành công !.."); } } } catch (Exception ex) { MessageBox.Show("Loi " + ex.ToString()); } }