/// <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();
}
}