private void btnEdit_Click(object sender, EventArgs e)
{
int id = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID));
BaoGiaModel model = (BaoGiaModel)BaoGiaBO.Instance.FindByPK(id);
frmBaoGia frm = new frmBaoGia();
frm.BaoGia = model;
frm.LoadDataChange += main_LoadDataChange;
frm.Show();
}
private void btnTongHopChiPhi_Click(object sender, EventArgs e)
{
int id = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID));
BaoGiaModel model = (BaoGiaModel)BaoGiaBO.Instance.FindByPK(id);
//frmBaoGiaCost frm = new frmBaoGiaCost();
//frm.BaoGia = model;
//frm.LoadDataChange += main_LoadDataChange;
//TextUtils.OpenForm(frm);
frmBaoGiaCostModule frm = new frmBaoGiaCostModule();
frm.BaoGia = model;
TextUtils.OpenForm(frm);
}
protected BaoGiaFacade(BaoGiaModel model) : base(model)
{
}
private void btnCreateBaoGia_Click(object sender, EventArgs e)
{
int id = TextUtils.ToInt(grvData.GetFocusedRowCellValue(colID));
if (id == 0)
{
return;
}
BaoGiaModel BaoGia = (BaoGiaModel)BaoGiaBO.Instance.FindByPK(id);
string localPath = "";
FolderBrowserDialog fbd = new FolderBrowserDialog();
if (fbd.ShowDialog() == DialogResult.OK)
{
localPath = fbd.SelectedPath + "\\" + BaoGia.Code + ".xlsx";
}
else
{
return;
}
string filePath = Application.StartupPath + "\\Templates\\FORM BAO GIA.xlsx";
try
{
File.Copy(filePath, localPath, true);
}
catch (Exception ex)
{
MessageBox.Show("Lỗi: File excel đang được mở." + Environment.NewLine + ex.Message);
return;
}
UsersModel userModel = (UsersModel)UsersBO.Instance.FindByPK(Global.UserID);
DataTable dtProduct = TextUtils.Select("select distinct productcode, productname from baogiaitem with(nolock) where productcode <> '' and baogiaid= " + BaoGia.ID);
//DataTable dtProductAo = TextUtils.Select("select distinct productcode, productname from baogiaitem with(nolock) where productcode = '' and baogiaid= " + BaoGia.ID);
if (grvData.RowCount == 0)
{
MessageBox.Show("Lỗi: Không có thiết bị nào để báo giá");
return;
}
using (WaitDialogForm fWait = new WaitDialogForm("Vui lòng chờ trong giây lát...", "Đang tạo báo giá..."))
{
System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US");
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(localPath);
workBoook = app.Workbooks[1];
workSheet = (Excel.Worksheet)workBoook.Worksheets[1];
workSheet.Cells[5, 4] = "Số báo giá: " + BaoGia.Code;
workSheet.Cells[6, 2] = "Đơn vị: " + BaoGia.CustomerCodeF + " - " + BaoGia.CustomerNameF;
workSheet.Cells[6, 4] = "Ngày báo giá: " + DateTime.Now.ToString("dd/MM/yyyy");
workSheet.Cells[7, 4] = "Người báo giá: " + userModel.FullName;
workSheet.Cells[8, 4] = "Số điện thoại: " + userModel.HandPhone;
workSheet.Cells[9, 4] = "Email: " + userModel.Email;
workSheet.Cells[25, 6] = "Hà nội, ngày " + DateTime.Now.Day + " tháng " + DateTime.Now.Month + " năm " + DateTime.Now.Year;
int rowCountProduct = dtProduct.Rows.Count;
DataTable dtModuleAo = TextUtils.Select("select * from baogiaitem where ProductCode = '' and Baogiaid = " + BaoGia.ID);
if (dtModuleAo.Rows.Count > 0)
{
int indexAo = dtModuleAo.Rows.Count - 1;
for (int i = indexAo; i >= 0; i--)
{
string moduleCode = TextUtils.ToString(dtModuleAo.Rows[i]["ModuleCode"]);
string moduleName = TextUtils.ToString(dtModuleAo.Rows[i]["ModuleName"]);
string qty = TextUtils.ToDecimal(dtModuleAo.Rows[i]["Qty"]).ToString("n0");
string price = TextUtils.ToDecimal(dtModuleAo.Rows[i]["PriceTPA"]).ToString("n0");
string total = TextUtils.ToDecimal(dtModuleAo.Rows[i]["TotalTPA"]).ToString("n0");
ModulesModel module = new ModulesModel();
try
{
module = (ModulesModel)ModulesBO.Instance.FindByCode(moduleCode);
}
catch (Exception)
{
}
if (module.ID > 0)
{
if (module.Specifications.Length > 0)
{
string[] thongSo = module.Specifications.Split('\n');
for (int k = thongSo.Length - 1; k >= 0; k--)
{
workSheet.Cells[15, 2] = thongSo[k];
((Excel.Range)workSheet.Rows[15]).Insert();
}
}
}
workSheet.Cells[15, 1] = rowCountProduct + i + 1;
workSheet.Cells[15, 2] = moduleName.ToUpper();
workSheet.Cells[15, 3] = moduleCode.ToUpper();
workSheet.Cells[15, 6] = qty;
workSheet.Cells[15, 7] = price;
workSheet.Cells[15, 8] = total;
((Excel.Range)workSheet.Rows[15]).Font.Bold = true;
((Excel.Range)workSheet.Rows[15]).Insert();
}
}
for (int i = rowCountProduct - 1; i >= 0; i--)
{
try
{
DataTable dtModule = TextUtils.Select("select * from baogiaitem where ProductCode = '"
+ dtProduct.Rows[i][0].ToString() + "' and Baogiaid = " + BaoGia.ID);
for (int j = dtModule.Rows.Count - 1; j >= 0; j--)
{
string moduleCode = TextUtils.ToString(dtModule.Rows[j]["ModuleCode"]);
string moduleName = TextUtils.ToString(dtModule.Rows[j]["ModuleName"]);
string qty = TextUtils.ToDecimal(dtModule.Rows[j]["Qty"]).ToString("n0");
string price = TextUtils.ToDecimal(dtModule.Rows[j]["PriceTPA"]).ToString("n0");
string total = TextUtils.ToDecimal(dtModule.Rows[j]["TotalTPA"]).ToString("n0");
ModulesModel module = new ModulesModel();
try
{
module = (ModulesModel)ModulesBO.Instance.FindByCode(moduleCode);
}
catch (Exception)
{
}
if (module.ID > 0)
{
if (module.Specifications.Length > 0)
{
string[] thongSo = module.Specifications.Split('\n');
for (int k = thongSo.Length - 1; k >= 0; k--)
{
workSheet.Cells[15, 2] = thongSo[k];
((Excel.Range)workSheet.Rows[15]).Insert();
}
}
}
workSheet.Cells[15, 2] = moduleName.ToUpper();
workSheet.Cells[15, 3] = moduleCode.ToUpper();
workSheet.Cells[15, 6] = qty;
workSheet.Cells[15, 7] = price;
workSheet.Cells[15, 8] = total;
((Excel.Range)workSheet.Rows[15]).Font.Bold = true;
((Excel.Range)workSheet.Rows[15]).Insert();
}
decimal productPrice = TextUtils.ToDecimal(dtModule.Compute("Sum(TotalTPA)", ""));
workSheet.Cells[15, 1] = i + 1;
workSheet.Cells[15, 2] = dtProduct.Rows[i][1].ToString().ToUpper();
workSheet.Cells[15, 3] = dtProduct.Rows[i][0].ToString().ToUpper();
workSheet.Cells[15, 4] = "Tân Phát";
workSheet.Cells[15, 5] = "Bộ";
workSheet.Cells[15, 6] = 1;
workSheet.Cells[15, 7] = productPrice.ToString("n0");
workSheet.Cells[15, 8] = productPrice.ToString("n0");
((Excel.Range)workSheet.Rows[15]).Font.Bold = true;
((Excel.Range)workSheet.Rows[15]).Insert();
}
catch (Exception)
{
}
}
((Excel.Range)workSheet.Rows[15]).Delete();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
if (app != null)
{
app.ActiveWorkbook.Save();
app.Workbooks.Close();
app.Quit();
}
}
Process.Start(localPath);
}
}
