private void btnXuatFile_Click(object sender, EventArgs e)
{
List <ReplacementGroup> rg = new List <ReplacementGroup>();
DateTime today = DateTime.Today;
rg.Add(new ReplacementGroup("<hoTen>", textBox_hoten.Text));
rg.Add(new ReplacementGroup("<ngaySinh>", tbNgaySinh.Text));
rg.Add(new ReplacementGroup("<gioiTinh>", rdNam.Checked?"Nam":"Nữ"));
rg.Add(new ReplacementGroup("<quocTich>", tbquoctich.Text));
rg.Add(new ReplacementGroup("<cmnd>", textBox_madinhdanh.Text));
rg.Add(new ReplacementGroup("<hoChieu>", tbhochieu.Text));
rg.Add(new ReplacementGroup("<noiThuongTruTamTru>", tbDCThuongTru.Text));
rg.Add(new ReplacementGroup("<tuNgay>", dtpNgayBatDau.Value.ToShortDateString()));
rg.Add(new ReplacementGroup("<denNgay>", dtpNgayKetThuc.Value.ToShortDateString()));
rg.Add(new ReplacementGroup("<lyDo>", tbLyDo.Text));
rg.Add(new ReplacementGroup("<noiDen>", textBox_noiden.Text));
rg.Add(new ReplacementGroup("<d3>", today.Day.ToString()));
rg.Add(new ReplacementGroup("<m3>", today.Month.ToString()));
rg.Add(new ReplacementGroup("<y3>", today.Year.ToString()));
string srcPath = System.Windows.Forms.Application.StartupPath + "\\MauIn\\Mau HK05.doc";
string dstPath = System.Windows.Forms.Application.StartupPath + "\\MauIn\\KetQua\\Mau HK05_" + textBox_madinhdanh.Text + "_" + DateTime.Now.ToString("dd-MM-yyyy") + ".doc";
CreateWordHelper.CreateWordDocument(srcPath, dstPath, rg);
MessageBox.Show(this, "Đã tạo thành công file thông tin với tên: " + dstPath, "Thành công",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void xuatFile()
{
List <ReplacementGroup> rg = new List <ReplacementGroup>();
DateTime today = DateTime.Today;
rg.Add(new ReplacementGroup("<hoTen>", tbhoten.Text));
rg.Add(new ReplacementGroup("<tenKhac>", tbTenKhac.Text));
rg.Add(new ReplacementGroup("<ngaySinh>", dtpNgaySinh.Value.ToShortDateString()));
rg.Add(new ReplacementGroup("<gioiTinh>", rdNam.Checked ? "Nam" : "Nữ"));
rg.Add(new ReplacementGroup("<noiSinh>", cbbNoiSinh.Text));
rg.Add(new ReplacementGroup("<nguyenQuan>", tbnguyenquan.Text));
rg.Add(new ReplacementGroup("<danToc>", tbdantoc.Text));
rg.Add(new ReplacementGroup("<tonGiao>", tbtongiao.Text));
rg.Add(new ReplacementGroup("<quocTich>", tbquoctich.Text));
rg.Add(new ReplacementGroup("<noiThuongTru>", tbDCThuongTru.Text));
rg.Add(new ReplacementGroup("<tenChuHo>", tenChuHo));
rg.Add(new ReplacementGroup("<qhVoiChuHo>", tbQHVoiCH.Text));
rg.Add(new ReplacementGroup("<lyDo>", lyDo));
rg.Add(new ReplacementGroup("<noiDen>", noiDen));
rg.Add(new ReplacementGroup("<ngay>", today.Day.ToString()));
rg.Add(new ReplacementGroup("<thang>", today.Month.ToString()));
rg.Add(new ReplacementGroup("<nam>", today.Year.ToString()));
string srcPath = System.Windows.Forms.Application.StartupPath + "\\MauIn\\Mau HK07.doc";
string dstPath = System.Windows.Forms.Application.StartupPath + "\\MauIn\\KetQua\\Mau HK07_" + tbmadinhdanh.Text + "_" + DateTime.Now.ToString("dd-MM-yyyy") + ".doc";
CreateWordHelper.CreateWordDocument(srcPath, dstPath, rg);
MessageBox.Show(this, "Đã tạo thành công file thông tin với tên: " + dstPath, "Thành công",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void btnXuat_Click(object sender, EventArgs e)
{
List <ReplacementGroup> rg = new List <ReplacementGroup>();
DateTime today = DateTime.Today;
DateTime tuNgay = today.AddMonths(-int.Parse(cbbThoiGian.SelectedValue.ToString()));
rg.Add(new ReplacementGroup("<tuNgay>", tuNgay.ToShortDateString()));
rg.Add(new ReplacementGroup("<denNgay>", today.ToShortDateString()));
rg.Add(new ReplacementGroup("<tongSoHo>", (int.Parse(tbHoTH.Text) + int.Parse(tbHoTH.Text)).ToString()));
rg.Add(new ReplacementGroup("<tongSo>", (int.Parse(tbNhanKhauTH.Text) + int.Parse(tbNhanKhauTT.Text)).ToString()));
rg.Add(new ReplacementGroup("<nkThanhThi>", (int.Parse(tbNKThanhThiTH.Text) + int.Parse(tbNKThanhThiTT.Text)).ToString()));
rg.Add(new ReplacementGroup("<nkNu>", (int.Parse(tbNKNuTH.Text) + int.Parse(tbNKNuTT.Text)).ToString()));
rg.Add(new ReplacementGroup("<nk14>", (int.Parse(tbNK14TH.Text) + int.Parse(tbNK14TT.Text)).ToString()));
rg.Add(new ReplacementGroup("<hoTH>", tbHoTH.Text));
rg.Add(new ReplacementGroup("<NhanKhauTH>", tbNhanKhauTH.Text));
rg.Add(new ReplacementGroup("<NKThanhThiTH>", tbNKThanhThiTH.Text));
rg.Add(new ReplacementGroup("<NKNuTH>", tbNKNuTH.Text));
rg.Add(new ReplacementGroup("<NK14TH>", tbNK14TH.Text));
rg.Add(new ReplacementGroup("<hoKoTH>", tbHoKoTH.Text));
rg.Add(new ReplacementGroup("<NhanKhauKoTH>", tbNhanKhauKoTH.Text));
rg.Add(new ReplacementGroup("<NKThanhThiKoTH>", tbNKThanhThiKoTH.Text));
rg.Add(new ReplacementGroup("<NKNuKoTH>", tbNKNuKoTH.Text));
rg.Add(new ReplacementGroup("<NK14KoTH>", tbNK14KoTH.Text));
rg.Add(new ReplacementGroup("<hoTT>", tbHoTT.Text));
rg.Add(new ReplacementGroup("<NhanKhauTT>", tbNhanKhauTT.Text));
rg.Add(new ReplacementGroup("<NKThanhThiTT>", tbNKThanhThiTT.Text));
rg.Add(new ReplacementGroup("<NKNuTT>", tbNKNuTT.Text));
rg.Add(new ReplacementGroup("<NK14TT>", tbNK14TT.Text));
rg.Add(new ReplacementGroup("<hoKoTT>", tbHoKoTT.Text));
rg.Add(new ReplacementGroup("<NhanKhauKoTT>", tbNhanKhauKoTT.Text));
rg.Add(new ReplacementGroup("<NKThanhThiKoTT>", tbNKThanhThiKoTT.Text));
rg.Add(new ReplacementGroup("<NKNuKoTT>", tbNKNuKoTT.Text));
rg.Add(new ReplacementGroup("<NK14KoTT>", tbNK14KoTT.Text));
rg.Add(new ReplacementGroup("<ngay>", today.Day.ToString()));
rg.Add(new ReplacementGroup("<thang>", today.Month.ToString()));
rg.Add(new ReplacementGroup("<nam>", today.Year.ToString()));
string srcPath = System.Windows.Forms.Application.StartupPath + "\\MauIn\\Mau HK15.doc";
string dstPath = System.Windows.Forms.Application.StartupPath + "\\MauIn\\KetQua\\Mau HK15_" + DateTime.Now.ToString("dd-MM-yyyy") + "_" + cbbThoiGian.SelectedValue.ToString() + ".doc";
CreateWordHelper.CreateWordDocument(srcPath, dstPath, rg);
MessageBox.Show(this, "Đã tạo thành công file thông tin với tên: " + dstPath, "Thành công",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
private void btnXuatFile_Click(object sender, EventArgs e)
{
List <ReplacementGroup> rg = new List <ReplacementGroup>();
//DataTable source = hssvbus.TimKiemJoinNhanKhau("AND mssv='" + textBox_mssv.Text + "'").Tables[0];
DataTable source = hssvbus.TimKiemtheoCuTru(textBox_madinhdanh.Text);
DataRow data = source.Rows[0];
List <string> listViPham = new List <string>();
foreach (DataGridViewRow item in dataGridView1.Rows)
{
if (item.Cells["toidanh"].Value != null)
{
listViPham.Add(item.Cells["toidanh"].Value.ToString());
}
}
string vipham = string.Join(", ", listViPham.ToArray());
vipham = string.IsNullOrEmpty(textBox_vipham.Text) ? vipham : textBox_vipham.Text + ", " + vipham;
if (data.ItemArray.Length > 0)
{
rg.Add(new ReplacementGroup("<ten>", data["hoten"].ToString()));
rg.Add(new ReplacementGroup("<ngaySinh>", data["ngaysinh"].ToString().Split(' ')[0]));
rg.Add(new ReplacementGroup("<mssv>", data["mahssv"].ToString()));
rg.Add(new ReplacementGroup("<truong>", data["truong"].ToString()));
rg.Add(new ReplacementGroup("<maDinhDanh>", data["madinhdanh"].ToString()));
//rg.Add(new ReplacementGroup("<ngayCap>", data["ngaycap"].ToString().Split(' ')[0]));
//rg.Add(new ReplacementGroup("<diaChiThuongTru>", data["diachithuongtru"].ToString()));
rg.Add(new ReplacementGroup("<diaChiThuongTru>", data["diachithuongtru"].ToString()));
rg.Add(new ReplacementGroup("<diaChiTamTru>", ""));
int vtkhupho = data["noithuongtru"].ToString().IndexOf(",");
int thlen = data["noithuongtru"].ToString().Length;
rg.Add(new ReplacementGroup("<khupho>", data["noithuongtru"].ToString().Substring(vtkhupho, thlen - vtkhupho)));
rg.Add(new ReplacementGroup("<tuNgay>", data["thoigianbatdautamtruthuongtru"].ToString().Split(' ')[0]));
rg.Add(new ReplacementGroup("<denNgay>", data["thoigianketthuctamtruthuongtru"].ToString().Split(' ')[0]));
rg.Add(new ReplacementGroup("<viPham>", vipham));
rg.Add(new ReplacementGroup("<checkKhong>", vipham == "" ? "" : ""));
rg.Add(new ReplacementGroup("<checkCo>", vipham == "" ? "" : ""));
DateTime today = DateTime.Now;
rg.Add(new ReplacementGroup("<ngay>", today.Day.ToString()));
rg.Add(new ReplacementGroup("<thang>", today.Month.ToString()));
rg.Add(new ReplacementGroup("<nam>", today.Year.ToString()));
string srcPath = System.Windows.Forms.Application.StartupPath + "\\MauIn\\Mau HSSV01.doc";
string dstPath = System.Windows.Forms.Application.StartupPath + "\\MauIn\\KetQua\\Mau HSSV01_" + textBox_mssv.Text + ".doc";
CreateWordHelper.CreateWordDocument(srcPath, dstPath, rg);
MessageBox.Show(this, "Đã tạo thành công file thông tin với tên: " + dstPath, "Thành công",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
MessageBox.Show(this, "lỗi", "Không thành công", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
