void sendData(string QRCode, string OrderCode)
{
try
{
string date = TextUtils.ToString(DateTime.Now.ToString("dd-MM-yyyy HH:mm:ss"));
DataTable dt = TextUtils.LoadDataFromSP("spGetHistoryCheckDataDetail", "A"
, new string[] { "QRCode" }
, new object[] { QRCode });
grdData.DataSource = dt;
string[] arr = QRCode.Split(' ');
string[] arrOrder = arr[0].Split('-');
//grdData.Print();
if (grvData.RowCount <= 0)
{
return;
}
string filePath = TextUtils.ExportExcelReturnFilePathLocal(grvData, QRCode);
if (string.IsNullOrEmpty(filePath))
{
return;
}
Excel.Application app = default(Excel.Application);
Excel.Workbook workBoook = default(Excel.Workbook);
Excel.Worksheet workSheet = default(Excel.Worksheet);
try
{
app = new Excel.Application();
app.Workbooks.Open(filePath);
workBoook = app.Workbooks[1];
workSheet = (Excel.Worksheet)workBoook.Worksheets[1];
app.DisplayAlerts = false;
for (int i = 0; i < 5; i++)
{
((Excel.Range)workSheet.Rows[1]).Insert();
}
workSheet.Cells[1, 1] = "Order No: ";
workSheet.Cells[1, 3] = arrOrder[0];
workSheet.Cells[2, 1] = "PID No: ";
workSheet.Cells[2, 3] = arr[1];
ProductModel p = (ProductModel)ProductBO.Instance.FindByAttribute("ProductCode", arr[1].Trim())[0];
workSheet.Cells[3, 1] = "Mô Tả: ";
workSheet.Cells[3, 3] = p.ProductName;
workSheet.Cells[4, 1] = "Ngày lắp: ";
workSheet.Cells[4, 3] = "'" + date;
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: " + ex.Message);
}
finally
{
app.ActiveWorkbook.Save();
app.ActiveWorkbook.PrintOutEx();
app.Workbooks.Close();
app.Quit();
//Process.Start(filePath);
}
}
catch
{
}
}