/// <summary>
/// Thủ tục đọc các cấu trúc mẫu từ file mau vào các biến kiểu chuỗi
/// </summary>
/// <Modifield>
/// Người tạo ngày tạo chú thích
/// Nguyễn Trung Tuyến 9/04/2009 Tạo mới
/// </Modifield>
protected void ReadCacBanMau()
{
ClsFileFunction f = new ClsFileFunction();
strBanMau1 = f.ReadFileToString(clsGlobalVariable.STRServerMapPath + "\\Ban mau\\Ban mau thiet ke chi tiet CSDL 1.xml");
strBanMau2 = f.ReadFileToString(clsGlobalVariable.STRServerMapPath + "\\Ban mau\\Ban mau thiet ke chi tiet CSDL 2.xml");
strBanMauDanhSachBang = f.ReadFileToString(clsGlobalVariable.STRServerMapPath + "\\Cau truc\\cautrucdanhsachbang.txt");
strBanMauHangTrongDanhSachBang = f.ReadFileToString(clsGlobalVariable.STRServerMapPath + "\\Cau truc\\cautruchangtrongdanhsachbang.txt");
strBanMauChiTietBang = f.ReadFileToString(clsGlobalVariable.STRServerMapPath + "\\Cau truc\\cautrucchitietbang.txt");
strBanMauHangTrongChiTietBang = f.ReadFileToString(clsGlobalVariable.STRServerMapPath + "\\Cau truc\\cautruchangtrongchititetbang.txt");
strBanMauDanhSachIndex = f.ReadFileToString(clsGlobalVariable.STRServerMapPath + "\\Cau truc\\cautrucdanhsachindex.txt");
strBanMauHangTrongDanhSachIndex = f.ReadFileToString(clsGlobalVariable.STRServerMapPath + "\\Cau truc\\cautruchangtrongdanhsachindex.txt");
strBanMauDanhSachTrigger = f.ReadFileToString(clsGlobalVariable.STRServerMapPath + "\\Cau truc\\cautrucdanhsachtrigger.txt");
strBanMauHangTrongDanhSachTrigger = f.ReadFileToString(clsGlobalVariable.STRServerMapPath + "\\Cau truc\\cautruchangtrongdanhsachtrigger.txt");
strBanMauDanhSachStoreProcedure1 = f.ReadFileToString(clsGlobalVariable.STRServerMapPath + "\\Cau truc\\cautrucdanhsachstoreprocedure.txt");
strBanMauHangTrongDanhSachStoreProcedure1 = f.ReadFileToString(clsGlobalVariable.STRServerMapPath + "\\Cau truc\\cautruchangtrongdanhsachstoreprocedure.txt");
strBanMauDanhSachFunctions1 = f.ReadFileToString(clsGlobalVariable.STRServerMapPath + "\\Cau truc\\cautrucdanhsachstoreprocedure.txt");
strBanMauHangTrongDanhSachFunctions1 = f.ReadFileToString(clsGlobalVariable.STRServerMapPath + "\\Cau truc\\cautruchangtrongdanhsachstoreprocedure.txt");
strBanMauDanhSachStoreFunction2 = f.ReadFileToString(clsGlobalVariable.STRServerMapPath + "\\Cau truc\\cautrucstoreprocedure.txt");
strBanMauHangDauVaoStoreFunction2 = f.ReadFileToString(clsGlobalVariable.STRServerMapPath + "\\Cau truc\\cautruchangdauvaostoreprocedure.txt");
strBanMauDanhSachView = f.ReadFileToString(clsGlobalVariable.STRServerMapPath + "\\Cau truc\\cautrucdanhsachview.txt");
strBanMauHangTrongDanhSachView = f.ReadFileToString(clsGlobalVariable.STRServerMapPath + "\\Cau truc\\cautruchangtrongdanhsachview.txt");
}
/// <summary>
///
/// </summary>
/// <param name="orclconn"></param>
/// <param name="strFilePath"></param>
/// <returns></returns>
/// <Modifield>
/// Người tạo ngày tạo chú thích
/// Nguyễn Trung Tuyến 9/04/2009 Tạo mới
/// </Modifield>
public bool WriteDatabaseStructureToWordFile(OracleConnection orclconn, String strFilePath, String strOptionPrint)
{
ClsFileFunction f = new ClsFileFunction();
String strContent = string.Empty;
ReadCacBanMau();
strContent = FillCoustomInformToXML(orclconn, strOptionPrint);
if (f.WriteContentToFile(strFilePath, strContent))
{
return(true);
}
return(false);
}
private void btnPrint_Click(object sender, EventArgs e)
{
ClsSQLDatabaseToDoc SQLdbtoword = new ClsSQLDatabaseToDoc();
ClsOracleDatabaseToDoc ORACLEdbtoword = new ClsOracleDatabaseToDoc();
ClsFileFunction ffunc = new ClsFileFunction();
String strOption = GetOptionString();
if (strOption.Contains("0"))
{
if (ffunc.CopyFile(clsGlobalVariable.STRServerMapPath + "\\temp.doc", filepath))
{
if (MessageBox.Show("In File Thành Công!\nBạn có muốn mở File để xem? ", "Kết quả",
MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
System.Diagnostics.Process proc = new System.Diagnostics.Process();
proc.EnableRaisingEvents = false;
proc.StartInfo.FileName = filepath;
proc.Start();
//proc.WaitForExit();
}
}
else
{
MessageBox.Show("In File Thất Bại!", "Kết quả", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
if (sqlConn != null)
{
if (SQLdbtoword.WriteDatabaseStructureToWordFile(sqlConn, filepath, strOption))
{
if (MessageBox.Show("In File Thành Công!\nBạn có muốn mở File để xem? ", "Kết quả",
MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
System.Diagnostics.Process proc = new System.Diagnostics.Process();
try
{
proc.EnableRaisingEvents = false;
proc.StartInfo.FileName = filepath;
proc.Start();
}
catch (Exception ex)
{
}
finally { proc.Dispose(); }
}
}
else
{
MessageBox.Show("In File Thất Bại!", "Kết quả", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else if (oracleConn != null)
{
if (ORACLEdbtoword.WriteDatabaseStructureToWordFile(oracleConn, filepath, strOption))
{
if (MessageBox.Show("In File Thành Công!\nBạn có muốn mở File để xem? ", "Kết quả",
MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
System.Diagnostics.Process proc = new System.Diagnostics.Process();
try
{
proc.EnableRaisingEvents = false;
proc.StartInfo.FileName = filepath;
proc.Start();
}
catch (Exception ex)
{
}
finally { proc.Dispose(); }
}
}
else
{
MessageBox.Show("In File Thất Bại!", "Kết quả", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
this.Dispose();
}