/// <summary>
/// 导出数据至配置文件
/// </summary>
/// <returns></returns>
public bool ExportEmailServer()
{
string strXmlFile = HttpContext.Current.Server.MapPath("~/_data/config/jcms(emailserver).config");
JumboECMS.DBUtility.XmlControl XmlTool = new JumboECMS.DBUtility.XmlControl(strXmlFile);
try
{
XmlTool.RemoveAll("Mails");
XmlTool.Save();
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.SqlCmd = "Select [Id],[FromAddress],[FromName],[FromPwd],[SmtpHost] FROM [jcms_normal_emailserver] WHERE [Enabled]=1 ORDER BY id asc";
DataTable dt = _doh.GetDataTable();
string _id = string.Empty;
for (int i = 0; i < dt.Rows.Count; i++)
{
_id = dt.Rows[i]["Id"].ToString();
XmlTool = new JumboECMS.DBUtility.XmlControl(strXmlFile);
XmlTool.InsertNode("Mails", "Mail", "ID", _id);
XmlTool.InsertElement("Mails/Mail[ID=\"" + _id + "\"]", "FromAddress", dt.Rows[i]["FromAddress"].ToString(), false);
XmlTool.InsertElement("Mails/Mail[ID=\"" + _id + "\"]", "FromName", dt.Rows[i]["FromName"].ToString(), false);
XmlTool.InsertElement("Mails/Mail[ID=\"" + _id + "\"]", "FromPwd", dt.Rows[i]["FromPwd"].ToString(), false);
XmlTool.InsertElement("Mails/Mail[ID=\"" + _id + "\"]", "SmtpHost", dt.Rows[i]["SmtpHost"].ToString(), false);
XmlTool.InsertElement("Mails/Mail[ID=\"" + _id + "\"]", "Used", DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd HH:mm:ss"), false);
XmlTool.Save();
}
}
return(true);
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// 更新客服列表
/// </summary>
public void RefreshServiceList()
{
string _serviceids = "";
string _servicenames = "";
string _servicemails = "";
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.SqlCmd = "SELECT [ServiceId],[ServiceName],[Email] FROM [jcms_normal_user] WHERE ServiceId>0";
DataTable dt = _doh.GetDataTable();
for (int j = 0; j < dt.Rows.Count; j++)
{
if (j == 0)
{
_serviceids = dt.Rows[j]["ServiceId"].ToString();
_servicenames = dt.Rows[j]["ServiceName"].ToString();
_servicemails = dt.Rows[j]["Email"].ToString();
}
else
{
_serviceids += "," + dt.Rows[j]["ServiceId"].ToString();
_servicenames += "," + dt.Rows[j]["ServiceName"].ToString();
_servicemails += "," + dt.Rows[j]["Email"].ToString();
}
}
string strXmlFile = HttpContext.Current.Server.MapPath("~/_data/config/message.config");
JumboECMS.DBUtility.XmlControl XmlTool = new JumboECMS.DBUtility.XmlControl(strXmlFile);
XmlTool.Update("Messages/Service/UserId", _serviceids);
XmlTool.Update("Messages/Service/UserName", _servicenames);
XmlTool.Update("Messages/Service/UserMail", _servicemails);
XmlTool.Save();
XmlTool.Dispose();
}
}
/// <summary>
/// 系统发邮件给客服
/// </summary>
/// <param name="_Title"></param>
/// <param name="_Body"></param>
/// <returns></returns>
public bool SendServiceMail(string _Title, string _Body)
{
string strXmlFile = HttpContext.Current.Server.MapPath("~/_data/config/message.config");
JumboECMS.DBUtility.XmlControl XmlTool = new JumboECMS.DBUtility.XmlControl(strXmlFile);
string _ServiceMail = XmlTool.GetText("Messages/Service/UserMail");
XmlTool.Dispose();
return(SendMail(_ServiceMail, _Title, _Body));
}
public bool SendMail(string _To, string _Title, string _Body)
{
string strXmlFile = HttpContext.Current.Server.MapPath("~/_data/config/mail.config");
JumboECMS.DBUtility.XmlControl XmlTool = new JumboECMS.DBUtility.XmlControl(strXmlFile);
string _MailFrom = XmlTool.GetText("Mails/System/Address");
string _MailFromName = XmlTool.GetText("Mails/System/NickName");
string _MailPwd = XmlTool.GetText("Mails/System/Password");
string _MailSmtpHost = XmlTool.GetText("Mails/System/SmtpHost");
XmlTool.Dispose();
_Body += "<br /><br />" + site.Name1 + " <a href='" + site.Url + "'>" + site.Url + "</a>";
return(JumboECMS.Common.MailHelp.SendOK(_To, _Title, _Body, true, _MailFrom, _MailFromName, _MailPwd, _MailSmtpHost));
}
/// <summary>
/// 导入配置文件至数据库
/// </summary>
/// <returns></returns>
public bool ImportEmailServer()
{
string strXmlFile = HttpContext.Current.Server.MapPath("~/_data/config/jcms(emailserver).config");
JumboECMS.DBUtility.XmlControl XmlTool = new JumboECMS.DBUtility.XmlControl(strXmlFile);
try
{
using (DbOperHandler _doh = new Common().Doh())
{
_doh.Reset();
_doh.Delete("jcms_normal_emailserver");
DataTable dt = XmlTool.GetTable("Mails");
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
_doh.Reset();
for (int j = 0; j < dt.Columns.Count; j++)
{
if (dt.Columns[j].ColumnName.ToLower() != "id" && dt.Columns[j].ColumnName.ToLower() != "used")
{
_doh.AddFieldItem(dt.Columns[j].ColumnName.ToLower(), dt.Rows[i][j].ToString());
}
}
_doh.Insert("jcms_normal_emailserver");
}
}
dt.Clear();
dt.Dispose();
}
return(true);
}
catch (Exception)
{
return(false);
}
}