public void ExtractionSurExcel(GunaDataGridView dataGrid)
{
if (dataGrid.Rows.Count > 0)
{
Microsoft.Office.Interop.Excel.Application applicationClass = new Microsoft.Office.Interop.Excel.Application();
applicationClass.Application.Workbooks.Add(Type.Missing);
for (int i = 1; i < dataGrid.Columns.Count + 1; i++)
{
applicationClass.Cells[1, i] = dataGrid.Columns[i - 1].HeaderText;
}
for (int i = 0; i < dataGrid.Rows.Count; i++)
{
for (int j = 0; j < dataGrid.Columns.Count; j++)
{
if (dataGrid.Rows[i].Cells[j].Value != null)
{
applicationClass.Cells[i + 2, j + 1] = dataGrid.Rows[i].Cells[j].Value.ToString();
}
}
}
applicationClass.Columns.AutoFit();
applicationClass.Visible = true;
}
}
// el metodo retorna un tabla para el documento pdf
private PdfPTable PdfTable(GunaDataGridView table)
{
PdfPTable pdfTable = new PdfPTable(table.Columns.Count);
pdfTable.DefaultCell.Padding = 3;
pdfTable.WidthPercentage = 100;
pdfTable.HorizontalAlignment = Element.ALIGN_LEFT;
pdfTable.SpacingBefore = 20;
foreach (DataGridViewColumn column in table.Columns)
{
PdfPHeaderCell pdfCell = new PdfPHeaderCell()
{
Phrase = new Phrase(column.HeaderText)
};
pdfTable.AddCell(pdfCell);
}
foreach (DataGridViewRow row in table.Rows)
{
foreach (DataGridViewCell cell in row.Cells)
{
pdfTable.AddCell(cell.Value.ToString());
}
}
return(pdfTable);
}
public int thongKe_DAO(GunaComboBox cb, GunaDataGridView dgv, int kieu)
{
if (kieu == 1)
{
var query = from NHANVIEN_CHUCVU6s in db.NHANVIEN_CHUCVU6s
where
NHANVIEN_CHUCVU6s.HOSO6.PHONGBAN6.MAPB == cb.SelectedValue.ToString() &&
NHANVIEN_CHUCVU6s.DENNGAY == "Nay"
select new
{
NHANVIEN_CHUCVU6s.HOSO6.MANV,
NHANVIEN_CHUCVU6s.HOSO6.HOTEN,
NGAYSINH = (DateTime?)NHANVIEN_CHUCVU6s.HOSO6.NGAYSINH,
NHANVIEN_CHUCVU6s.HOSO6.GIOITINH,
NHANVIEN_CHUCVU6s.HOSO6.SODT,
NHANVIEN_CHUCVU6s.HOSO6.EMAIL,
NGAYTD = (DateTime?)NHANVIEN_CHUCVU6s.HOSO6.NGAYTD,
NHANVIEN_CHUCVU6s.HOSO6.PHONGBAN6.TENPB,
NHANVIEN_CHUCVU6s.CHUCVU6.TENCV
};
if (query.Count() > 0)
{
dgv.DataSource = query;
return(1);
}
}
else
{
var query2 = from NHANVIEN_CHUCVU6s in db.NHANVIEN_CHUCVU6s
where
NHANVIEN_CHUCVU6s.CHUCVU6.MACV == cb.SelectedValue.ToString() &&
NHANVIEN_CHUCVU6s.DENNGAY == "Nay"
select new
{
NHANVIEN_CHUCVU6s.HOSO6.MANV,
NHANVIEN_CHUCVU6s.HOSO6.HOTEN,
NGAYSINH = (DateTime?)NHANVIEN_CHUCVU6s.HOSO6.NGAYSINH,
NHANVIEN_CHUCVU6s.HOSO6.GIOITINH,
NHANVIEN_CHUCVU6s.HOSO6.SODT,
NHANVIEN_CHUCVU6s.HOSO6.EMAIL,
NGAYTD = (DateTime?)NHANVIEN_CHUCVU6s.HOSO6.NGAYTD,
NHANVIEN_CHUCVU6s.HOSO6.PHONGBAN6.TENPB,
NHANVIEN_CHUCVU6s.CHUCVU6.TENCV
};
if (query2.Count() > 0)
{
dgv.DataSource = query2;
return(1);
}
}
return(0);
}
public void DesignDataGrid(GunaDataGridView dataGrid)
{
dataGrid.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(13, 72, 114);
dataGrid.ColumnHeadersHeight = 50;
dataGrid.RowHeadersVisible = true;
foreach (DataGridViewRow row in dataGrid.Rows)
{
row.Selected = false;
row.Height = 50;
row.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
}
}
public int thongKe_DAO(GunaComboBox cb, GunaDataGridView dgv, int kieu)
{
if (kieu == 1)
{
var query = from TRINHDONGOAINGU6s in db.TRINHDONGOAINGU6s
where
TRINHDONGOAINGU6s.TRINHDO == cb.SelectedValue.ToString()
select new
{
TRINHDONGOAINGU6s.HOSO6.MANV,
TRINHDONGOAINGU6s.HOSO6.HOTEN,
NGAYSINH = (DateTime?)TRINHDONGOAINGU6s.HOSO6.NGAYSINH,
TRINHDONGOAINGU6s.HOSO6.GIOITINH,
TRINHDONGOAINGU6s.HOSO6.EMAIL,
TRINHDONGOAINGU6s.HOSO6.SODT,
NGAYTD = (DateTime?)TRINHDONGOAINGU6s.HOSO6.NGAYTD,
TRINHDONGOAINGU6s.NGOAINGU,
TRINHDONGOAINGU6s.TRINHDO
};
if (query.Count() > 0)
{
dgv.DataSource = query;
return(1);
}
}
else
{
var query2 = from TRINHDONGOAINGU6s in db.TRINHDONGOAINGU6s
where
TRINHDONGOAINGU6s.NGOAINGU == cb.SelectedValue.ToString()
select new
{
TRINHDONGOAINGU6s.HOSO6.MANV,
TRINHDONGOAINGU6s.HOSO6.HOTEN,
NGAYSINH = (DateTime?)TRINHDONGOAINGU6s.HOSO6.NGAYSINH,
TRINHDONGOAINGU6s.HOSO6.GIOITINH,
TRINHDONGOAINGU6s.HOSO6.EMAIL,
TRINHDONGOAINGU6s.HOSO6.SODT,
NGAYTD = (DateTime?)TRINHDONGOAINGU6s.HOSO6.NGAYTD,
TRINHDONGOAINGU6s.NGOAINGU,
TRINHDONGOAINGU6s.TRINHDO
};
if (query2.Count() > 0)
{
dgv.DataSource = query2;
return(1);
}
}
return(0);
}
private void loadData(string query, GunaDataGridView dataView)
{
DataSet data = new DataSet();
ConnectString b = new ConnectString();
string con = b.getConnectionString(fromdangnhap.checkConnectionString);
using (SqlConnection connect = new SqlConnection(con))
{
connect.Open();
SqlDataAdapter apter = new SqlDataAdapter(query, con);
apter.Fill(data);
connect.Close();
}
dataView.DataSource = data.Tables[0];
}
private void initData(string query, GunaDataGridView showData)
{
DataSet data = new DataSet();
ConnectionString b = new ConnectionString();
string con = b.getConnectionString(frmLogin.checkConnectionString);
using (SqlConnection connect = new SqlConnection(con))
{
connect.Open();
SqlDataAdapter apter = new SqlDataAdapter(query, con);
apter.Fill(data);
connect.Close();
}
showData.DataSource = data.Tables[0];
}
public void imprimirTicket(GunaDataGridView grid, string folio, string empleado, string comentarios, double total, double cambio, double efectivo)
{
Ticket tickets = new Ticket();
//Image img = Resources.bakery_logo_cake_confectionery_frosting_icing_cake_png_clip_art;
//tickets.HeaderImage = img;
tickets.AddHeaderLine("Reposteria");
tickets.AddHeaderLine("EXPEDIDO POR:");
tickets.AddHeaderLine(empleado);
tickets.AddHeaderLine("RFC: MARL-730815-A83");
tickets.AddHeaderLine("Av Ceylan #1133 Col. Industrial VallejoSDAJSKDSLKKDSHKDHSASAJDSJHADKJSDSKJADHDSJSKJDSHADHAKJD CP 02300 Azcapotzalco Mexico DF");
tickets.AddSubHeaderLine("folio # 1");
tickets.AddSubHeaderLine(DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString());
//NECESITAMOS CONFIGURARLO AQUI PARA Q SOLO IMPRIMA LA FECHA DE LA FACTURA
//tickets.AddItem("1", "Nombre producto que vamos a vender esta largo", "Total");
double tots = 0;
foreach (DataGridViewRow fila in grid.Rows)
{
tickets.AddItem(fila.Cells[2].Value.ToString(), fila.Cells[1].Value.ToString(), fila.Cells[4].Value.ToString());
//ticket.lineasIgual();
//ticket.AgregaArticulo(fila.Cells[0].Value.ToString(), int.Parse(fila.Cells[3].Value.ToString()),double.Parse(fila) );
//ticket.lineasIgual();
tots = tots + double.Parse(fila.Cells[4].Value.ToString());
}
tickets.AddTotal("SUBTOTAL", tots.ToString());
tickets.AddTotal("TOTAL", total.ToString());
tickets.AddTotal("", "");
tickets.AddTotal("RECIBIDO", efectivo.ToString());
tickets.AddTotal("CAMBIO", cambio.ToString());
tickets.AddTotal("", "");
tickets.AddFooterLine(comentarios);
tickets.AddFooterLine("");
//tickets.AddFooterLine("No nos hacemnos responsables por los valores u onjetos olvidados, en las prendas, CONSERVE ESTA NOTA, ES NECESARIA PARA RECOJER LA ROPA");
tickets.AddFooterLine("");
tickets.AddFooterLine("¡¡¡GRACIAS POR SU PREFERENCIA!!!");
tickets.PrintTicket("HP53D614"); //Nombre de la impresora de tickets
}
private void reloadDataGridViewShowCart(DataTable data, GunaDataGridView dtgv)
{
dtgv.DataSource = data;
}
public void layDLTable_BUS(GunaDataGridView gr, GunaLabel lb)
{
QuanLyTrinhDoNgoaiNgu_DAO.Instance.layDLTable_DAO(gr, lb.Text);
}
public int thongKeTrinhDoChuyenMon(string strTK, GunaDataGridView dg, int kieu)
{
return(ThongKeTrinhDoChuyenMon_Dao.createInstance.thongKeTrinhDo(strTK, dg, kieu));
}
public int thongKe_BUS(GunaComboBox cb, GunaDataGridView dgv, int kieu)
{
return(ThongKePhongBanChucVu_DAO.Instance.thongKe_DAO(cb, dgv, kieu));
}
public bool SiActiveButtonPourPlusieursSelections(GunaDataGridView dataGrid) => (dataGrid.SelectedRows.Count > 0);
public bool SiActiveButtonPourUneSelection(GunaDataGridView dataGrid) => (dataGrid.SelectedRows.Count == 1);
private void exportExel(GunaDataGridView dgvCTHoaDon)
{
bool fileError = false;
try
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "XLSX(*.xlsx)|*.xlsx";
saveFileDialog.FileName = "ThongKeHoaDonBanHang.xlsx";
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
if (File.Exists(saveFileDialog.FileName))
{
try
{
File.Delete(saveFileDialog.FileName);
}
catch
{
fileError = true;
}
}
}
if (!fileError)
{
app obj = new app();
obj.Application.Workbooks.Add(Type.Missing);
obj.Columns.ColumnWidth = 35;
obj.StandardFontSize = 13;
obj.Cells[1].Font.Bold = true;
obj.Rows[2].Font.Bold = true;
obj.Rows[1].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
obj.Rows[2].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
obj.Rows[3].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
obj.Rows[4].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
obj.Rows[5].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
obj.Rows[3].Font.Bold = true;
obj.Rows[4].Font.Bold = true;
// obj.Rows[5].Font.Bold = true;
int dem1 = 3;
obj.Cells[1, 1] = " Thống Kê Hóa Đơn Bán Hàng ";
obj.Cells[2, 1] = "Ngày Lập: " + DateTime.Now;
if (dgvCTHoaDon.RowCount > 0)
{
for (int i = 1; i < dgvCTHoaDon.Columns.Count + 1; i++)
{
obj.Cells[4, i] = dgvCTHoaDon.Columns[i - 1].HeaderText;
}
for (int i = 0; i < dgvCTHoaDon.Rows.Count; i++)
{
dem1 += 1;
obj.Rows[dem1].HorizontalAlignment = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignCenter;
for (int j = 0; j < dgvCTHoaDon.Columns.Count; j++)
{
if (dgvCTHoaDon.Rows[i].Cells[j].Value != null)
{
obj.Cells[i + 5, j + 1] = dgvCTHoaDon.Rows[i].Cells[j].Value.ToString();
}
else
{
obj.Cells[i + 5, j + 1] = "";
}
}
}
}
obj.ActiveWorkbook.SaveCopyAs(saveFileDialog.FileName);
obj.ActiveWorkbook.Saved = true;
MessageBox.Show("Xuất thành công", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
//try
//{
// string dcmail = "";
// string querry = "select email from khachhang where tenkh = N'" + cbTenKh.Text + "'";
// DataTable DL = KetNoi.Istance.ExcuteQuerry(querry);
// foreach (DataRow row in DL.Rows)
// {
// dcmail = row["email"].ToString();
// }
// SmtpClient mailclient = new SmtpClient("smtp.gmail.com", 587);
// mailclient.EnableSsl = true;
// mailclient.Credentials = new NetworkCredential("*****@*****.**", "dinhhoang0603");
// MailMessage message = new MailMessage("*****@*****.**", dcmail);
// message.Subject = "THƯ CẢM ƠN KHÁCH HÀNG CỦA BENRI FARM";
// message.Body = "Cảm ơn quý khách hàng " + cbTenKh.Text + " đã tin tưởng Benri Farm! " + "\n" + "Kính mong quý khách sẽ tiếp tục ủng hộ!" + "\n" +
// "Thân ái!";
// mailclient.Send(message);
// message = null;
// Alert b = new Alert("Mail đã được gửi đi!", AlertType.success);
// b.ShowDialog();
//}
//catch
//{
// Alert b = new Alert("Báo cáo chưa được gửi do lỗi mạng!", AlertType.info);
// b.ShowDialog();
//}
}
}
catch
{
MessageBox.Show("Dữ liệu không hợp lệ hoặc lỗi kết nối", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public void hienThi(GunaDataGridView gr, GunaLabel txtMaNV)
{
TrinhDoChuyenMon_DAO.createInstance.hienThi(gr, txtMaNV.Text);
}
public void layDLTable_BUS(GunaDataGridView gr, GunaLabel lb)
{
QuanLyQuaTrinhCongTac_DAO.Instance.layDLTable_DAO(gr, lb.Text);
}
public int thongKe_BUS(GunaComboBox cb, GunaDataGridView dgv, int kieu)
{
return(ThongKeTrinhDoNgoaiNgu_DAO.Instance.thongKe_DAO(cb, dgv, kieu));
}
public void hienThiDuLieu(GunaDataGridView gr)
{
ChucVu_DAO.createInstance.hienThiDuLieu(gr);
}
public void xuatBaoCao(GunaDataGridView dgv)
{
if (dgv.Rows.Count > 0)
{
SaveFileDialog sfd = new SaveFileDialog
{
Filter = "PDF (*.pdf)|*.pdf",
FileName = "Output.pdf"
};
bool fileError = false;
if (sfd.ShowDialog() == DialogResult.OK)
{
if (File.Exists(sfd.FileName))
{
try
{
File.Delete(sfd.FileName);
}
catch (IOException ex)
{
fileError = true;
frm.capNhatLoiNhan("Đang có chương trình mở file này!!!");
frm.ShowDialog();
}
}
if (!fileError)
{
try
{
PdfPTable pdfTable = new PdfPTable(dgv.Columns.Count);
pdfTable.DefaultCell.Padding = 3;
pdfTable.WidthPercentage = 100;
pdfTable.HorizontalAlignment = Element.ALIGN_LEFT;
BaseFont bf = BaseFont.CreateFont(@"C:\WINDOWS\Fonts\TIMES.TTF", BaseFont.IDENTITY_H, true);
iTextSharp.text.Font fonttitle = new iTextSharp.text.Font(bf, 15);
iTextSharp.text.Font font = new iTextSharp.text.Font(bf, 10);
iTextSharp.text.Font fonttext = new iTextSharp.text.Font(bf, 12);
Paragraph header = new Paragraph
{
Alignment = Element.ALIGN_CENTER
};
Paragraph text = new Paragraph();
Chunk c1 = new Chunk("BÁO CÁO THỐNG KÊ TRÌNH ĐỘ CHUYÊN MÔN \n", fonttitle);
Chunk c2 = new Chunk(DateTime.Now.ToShortDateString() + "\n\n", font);
header.Add(c1);
header.Add(c2);
foreach (DataGridViewColumn column in dgv.Columns)
{
PdfPCell cell = new PdfPCell(new Phrase(column.HeaderText, fonttext));
pdfTable.AddCell(cell);
}
foreach (DataGridViewRow row in dgv.Rows)
{
foreach (DataGridViewCell cell in row.Cells)
{
PdfPCell cell1 = new PdfPCell(new Phrase(cell.Value.ToString(), fonttext));
pdfTable.AddCell(cell1);
}
}
using (FileStream stream = new FileStream(sfd.FileName, FileMode.Create))
{
Document pdfDoc = new Document(PageSize.A4, 10f, 20f, 20f, 10f);
PdfWriter.GetInstance(pdfDoc, stream);
pdfDoc.Open();
pdfDoc.Add(header);
pdfDoc.Add(pdfTable);
pdfDoc.Close();
stream.Close();
}
frm.capNhatLoiNhan("Xuất dữ liệu thành công!!!");
frm.ShowDialog();
}
catch (Exception ex)
{
frm.capNhatLoiNhan("Có lỗi xảy ra!!!");
frm.ShowDialog();
}
}
}
}
else
{
frm.capNhatLoiNhan("Không có bản ghi nào được xuất!!!");
frm.ShowDialog();
}
}
public void layDLTable_BUS(GunaDataGridView gr, GunaLabel lb)
{
QuanLyNhanVienChucVu_DAO.Instance.layDLTable_DAO(gr, lb.Text);
}
public bool timKiemTrinhDoChuyenMon_BUS(GunaTextBox maNV, GunaLabel txtTenNV, GunaDataGridView gr)
{
HoSoNV_DTO nv = new HoSoNV_DTO
{
MaNV = maNV.Text
};
TrinhDoChuyenMon_DAO.createInstance.timKiemTrinhDoChuyenMon_DAO(nv);
txtTenNV.Text = nv.HoTen;
if (nv.HoTen == null)
{
return(false);
}
TrinhDoChuyenMon_DAO.createInstance.hienThi(gr, nv.MaNV);
return(true);
}
