/// <summary>
/// 查找替换文本
/// </summary>
/// <param name="filePath">文件路径</param>
/// <param name="strOld">查找文本</param>
/// <param name="strNew">替换文本</param>
public void WordReplace(string[] strOld, string[] strNew)
{
string[] SampleFilePaths = { @".\Resources\外封面.docx", @".\Resources\报告书.docx", @".\Resources\委托书.docx", @".\Resources\管理表.docx", @".\Resources\流程单.docx" };
string ProjectName = NamedObjectDictionary.ReadFromNOD(lib.AppConfig.ProjectInfoName[1]);
string FolderPath = Interaction.GetFolderPath();
if (strOld.Length == strNew.Length)
{
using (Spire.Doc.Document doc = new Spire.Doc.Document())
{
foreach (string SampleFilePath in SampleFilePaths)
{
string filename = System.IO.Path.GetFileNameWithoutExtension(SampleFilePath) + "-" + ProjectName; //获取文件名
string extension = System.IO.Path.GetExtension(SampleFilePath); //获取扩展名
string saveFilePath = FolderPath + @"\" + filename + extension; //合并成完整路径
doc.LoadFromFile(SampleFilePath);
for (int i = 0; i < strOld.Length; i++)
{
doc.Replace("[<" + strOld[i] + ">]", strNew[i], false, false);
}
if (saveFilePath != null)
{
doc.SaveToFile(saveFilePath);
doc.Close();
}
}
}
}
else
{
Forms.MessageBox.Show("要替换的新旧字符串数量不同，取消操作");
}
}
/// <summary>
/// 替换Word
/// </summary>
/// <param name="path"></param>
/// <param name="dics"></param>
/// <param name="savePath"></param>
/// <returns></returns>
public bool WordReplace(string path, string savePath, Dictionary <string, string> dics)
{
using (var doc = new Spire.Doc.Document())
{
doc.LoadFromFile(path);
foreach (var item in dics)
{
doc.Replace(new Regex(item.Key), item.Value);
}
doc.SaveToFile(savePath);
doc.Close();
}
return(true);
}
public ActionResult CreateDocumentsFromTemplate(ContractDetails details)
{
//Get data from db for current user
DSGVOEntities1 db = new DSGVOEntities1();
kunden CurrentUser = db.kundens.Where(t => t.plz == details.UserZip.ToString().Trim() && t.seriennr.Substring(15).Trim() == details.SerialNo.ToString().Trim()).First();
////Update contractuser in db
//CurrentUser.contractuser = details.ContractUser.ToString().Trim();
////Change email if it is changed
//if (CurrentUser.email.ToString().Trim() != details.Email.ToString().Trim())
//{
// CurrentUser.email = details.Email.ToString().Trim();
//}
//db.SaveChanges();
//Check if changes in data exist and send it in email
StringBuilder dataChanges = new StringBuilder();
bool ChangesExist = false;
dataChanges.Append("<table>");
dataChanges.Append(" <tr><th>Previous data</th><th>Changed data from user</th></tr>");
if (CurrentUser.name1.ToString().Trim() != details.Name1.ToString().Trim())
{
ChangesExist = true;
dataChanges.Append(" <tr><td>" + CurrentUser.name1.ToString().Trim() + " </td><td>" + details.Name1.ToString().Trim() + "</td></tr>");
CurrentUser.name1 = details.Name1.ToString().Trim();
}
if (CurrentUser.name2.ToString().Trim() != details.Name2.ToString().Trim())
{
ChangesExist = true;
dataChanges.Append(" <tr><td>" + CurrentUser.name2.ToString().Trim() + " </td><td>" + details.Name2.ToString().Trim() + "</td></tr>");
CurrentUser.name2 = details.Name2.ToString().Trim();
}
if (CurrentUser.strasse.ToString().Trim() != details.Street.ToString().Trim())
{
ChangesExist = true;
dataChanges.Append(" <tr><td>" + CurrentUser.strasse.ToString().Trim() + " </td><td>" + details.Street.ToString().Trim() + "</td></tr>");
CurrentUser.strasse = details.Street.ToString().Trim();
}
if (CurrentUser.plz.ToString().Trim() != details.Zip.ToString().Trim())
{
ChangesExist = true;
dataChanges.Append(" <tr><td>" + CurrentUser.plz.ToString().Trim() + " </td><td>" + details.Zip.ToString().Trim() + "</td></tr>");
CurrentUser.plz = details.Zip.ToString().Trim();
}
if (CurrentUser.ort.ToString().Trim() != details.City.ToString().Trim())
{
ChangesExist = true;
dataChanges.Append(" <tr><td>" + CurrentUser.ort.ToString().Trim() + " </td><td>" + details.City.ToString().Trim() + "</td></tr>");
CurrentUser.ort = details.City.ToString().Trim();
}
//if (CurrentUser.land.ToString().Trim() != details.Country.ToString().Trim())
//{
// ChangesExist = true;
// dataChanges.Append(" <tr><td>" + CurrentUser.land.ToString().Trim() + " </td><td>" + details.Country.ToString().Trim() + "</td></tr>");
//}
if (CurrentUser.email.ToString().Trim() != details.Email.ToString().Trim())
{
ChangesExist = true;
dataChanges.Append(" <tr><td>" + CurrentUser.email.ToString().Trim() + " </td><td>" + details.Email.ToString().Trim() + "</td></tr>");
CurrentUser.email = details.Email.ToString().Trim();
}
//if (CurrentUser.contractuser == null)
//{
// ChangesExist = true;
// dataChanges.Append(" <tr><td>Empty</td><td>" + details.ContractUser.ToString().Trim() + "</td></tr>");
//}
////Adding user data to viewbag
//if (CurrentUser.name1 != null)
//{
// details.Name1 = CurrentUser.name1.ToString().Trim();
//}
//if (CurrentUser.name2 != null)
//{
// details.Name2 = CurrentUser.name2.ToString().Trim();
//}
//if (CurrentUser.strasse != null)
//{
// details.Street= CurrentUser.strasse.ToString().Trim() + " " ;
//}
//if (CurrentUser.ort != null)
//{
// details.City= CurrentUser.ort.ToString().Trim();
//}
//if (CurrentUser.land != null)
//{
// //Set country
// switch (CurrentUser.land.ToString().Trim())
// {
// case "D":
// CurrentUser.land = "Deutschland";
// break;
// case "A":
// CurrentUser.land = "Österreich";
// break;
// case "CH":
// CurrentUser.land = "Schweiz";
// break;
// default:
// break;
// }
// details.Country = CurrentUser.land.ToString().Trim();
//}
//if (CurrentUser.email != null)
//{
// details.Contact = CurrentUser.email.ToString().Trim();
//}
// Set country
switch (details.Country.ToString().Trim())
{
case "D":
details.Country = "Deutschland";
break;
case "A":
details.Country = "Österreich";
break;
case "CH":
details.Country = "Schweiz";
break;
default:
break;
}
string Result, Name;
//Generating strong name as word and pdf name
string HashName = UserInfo.CalculateMD5Hash(details.SerialNo + "-" + details.UserZip);
try
{
Spire.Doc.Document document = new Spire.Doc.Document();
document.LoadFromFile(Server.MapPath("~/Template/template.docx").ToString());
if (details.Name1 != null && details.Name1.ToString().Trim() != "")
{
document.Replace("##AGName1##", details.Name1, false, true);
}
else
{
document.Replace("##AGName1##", "", false, true);
}
if (details.Name2 != null && details.Name2.ToString().Trim() != "")
{
document.Replace("##AGName2##", details.Name2, false, true);
}
else
{
document.Replace("##AGName2##", "", false, true);
}
if (details.Street != null && details.Street.ToString().Trim() != "")
{
document.Replace("##AGStreet##", details.Street, false, true);
}
else
{
document.Replace("##AGStreet##", "", false, true);
}
if (details.Zip != null && details.Zip.ToString().Trim() != "")
{
document.Replace("##AGZIP##", details.Zip, false, true);
}
else
{
document.Replace("##AGZIP##", "", false, true);
}
if (details.City != null && details.City.ToString().Trim() != "")
{
document.Replace("##AGCITY##", details.City, false, true);
document.Replace("##City##", details.City, false, true);
}
else
{
document.Replace("##AGCITY##", "", false, true);
document.Replace("##City##", "", false, true);
}
if (details.Country != null && details.Country.ToString().Trim() != "")
{
document.Replace("##AGCountry##", details.Country, false, true);
}
else
{
document.Replace("##AGCountry##", "", false, true);
}
if (details.ContractUser != null && details.ContractUser.ToString().Trim() != "")
{
document.Replace("##ContractUser##", details.ContractUser, false, true);
}
if (details.Email != null && details.Email.ToString().Trim() != "")
{
document.Replace("##AGCONTACT##", details.Email, false, true);
}
else
{
document.Replace("##AGCONTACT##", "", false, true);
}
document.Replace("##DayDate##", DateTime.Now.ToString("dd.MM.yyyy"), false, true);
document.SaveToFile(Server.MapPath("~/Word/").ToString() + HashName + ".docx", Spire.Doc.FileFormat.Docx);
//Code for making connection with existing word template
Microsoft.Office.Interop.Word._Application wApp = new Microsoft.Office.Interop.Word.Application();
Microsoft.Office.Interop.Word.Documents wDocs = wApp.Documents;
Microsoft.Office.Interop.Word._Document wDoc = wDocs.Open(Server.MapPath("~/Word/").ToString() + HashName + ".docx", ReadOnly: false, Visible: false);
wDoc.Activate();
string pdfName = @Server.MapPath("~/Pdf/").ToString() + HashName + ".pdf";
//wDoc.ExportAsFixedFormat(OutputFileName: pdfName, ExportFormat: WdExportFormat.wdExportFormatPDF, UseISO19005_1: true);
wDoc.ExportAsFixedFormat(
pdfName,
WdExportFormat.wdExportFormatPDF,
OptimizeFor: WdExportOptimizeFor.wdExportOptimizeForPrint,
BitmapMissingFonts: true,
DocStructureTags: false,
UseISO19005_1: true);
wDoc.Close();
//Update fields into db
CurrentUser.contractuser = details.ContractUser;
CurrentUser.contactperson = details.ContractUser;
CurrentUser.contractsigned = true;
CurrentUser.signeddate = DateTime.Now;
CurrentUser.contractname = HashName + ".pdf";
//Send email with pdf as attachment to office
SmtpClient smtpClient = new SmtpClient();
NetworkCredential basicCredential =
new NetworkCredential("*****@*****.**", "hopeDSGVO");
System.Net.Mail.MailMessage message = new System.Net.Mail.MailMessage();
MailAddress fromAddress = new MailAddress("*****@*****.**");
smtpClient.Host = "smtp.1und1.de";
smtpClient.UseDefaultCredentials = false;
smtpClient.Credentials = basicCredential;
smtpClient.Port = 587;
smtpClient.EnableSsl = true;
message.From = fromAddress;
message.Subject = "hope-DSGVO - AV-Vertrag, Kunde: " + details.UserZip + " - hotel: " + details.Name1;
message.Attachments.Add(new System.Net.Mail.Attachment(Server.MapPath("~/Pdf/").ToString() + HashName + ".pdf"));
//[email protected]
message.To.Add(new MailAddress("*****@*****.**"));
smtpClient.Send(message);
//Send email to customer
SmtpClient smtpCustomer = new SmtpClient();
NetworkCredential basicCredentialCustomer =
new NetworkCredential("*****@*****.**", "hopeDSGVO");
System.Net.Mail.MailMessage messageCustomer = new System.Net.Mail.MailMessage();
MailAddress fromAddressCompany = new MailAddress("*****@*****.**");
smtpCustomer.Host = "smtp.1und1.de";
smtpCustomer.UseDefaultCredentials = false;
smtpCustomer.Credentials = basicCredential;
smtpCustomer.Port = 587;
smtpCustomer.EnableSsl = true;
messageCustomer.From = fromAddressCompany;
messageCustomer.Subject = "hope-DSGVO - AV-Vertrag, Kunde: " + details.UserZip + " - hotel: " + details.Name1;
messageCustomer.Attachments.Add(new System.Net.Mail.Attachment(Server.MapPath("~/Pdf/").ToString() + HashName + ".pdf"));
//[email protected]
messageCustomer.To.Add(new MailAddress(CurrentUser.email.ToString().Trim()));
smtpCustomer.Send(messageCustomer);
//Send email if user changed data on html form [email protected]
if (ChangesExist)
{
//Send email with pdf as attachemnt
SmtpClient smtpClientSecond = new SmtpClient();
NetworkCredential basicCredentialSecond =
new NetworkCredential("*****@*****.**", "hopeDSGVO");
System.Net.Mail.MailMessage messageSecond = new System.Net.Mail.MailMessage();
MailAddress fromAddressSecond = new MailAddress("*****@*****.**");
smtpClientSecond.Host = "smtp.1und1.de";
smtpClientSecond.UseDefaultCredentials = false;
smtpClientSecond.Credentials = basicCredential;
smtpClientSecond.Port = 587;
smtpClientSecond.EnableSsl = true;
messageSecond.From = fromAddress;
messageSecond.Subject = "hope-DSGVO - Kundendaten geändert: " + details.UserZip + " - hotel: " + details.Name1;
messageSecond.IsBodyHtml = true;
messageSecond.Body = dataChanges.ToString();
//[email protected]
messageSecond.To.Add(new MailAddress("*****@*****.**"));
smtpClientSecond.Send(message);
//Update field in database
CurrentUser.datachanged = true;
}
//Update field in database
db.SaveChanges();
return(Json(new { Result = "true", Name = HashName }));
}
catch (Exception ex)
{
Console.WriteLine("Error occured:", ex.ToString());
return(Json(Result = ex.ToString()));
}
finally
{
Dispose();
}
}