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