private void GetEmailInfo() { Service24041Client client = null; try { WebRequest webRequest = new WebRequest(); webRequest.Code = (int)S2400RequestCode.GetEmailInfo; webRequest.Session = CurrentApp.Session; client = new Service24041Client(WebHelper.CreateBasicHttpBinding(CurrentApp.Session), WebHelper.CreateEndpointAddress(CurrentApp.Session.AppServerInfo, "Service24041")); WebReturn webReturn = client.DoOperation(webRequest); CurrentApp.MonitorHelper.AddWebReturn(webReturn); if (!webReturn.Result) { ShowException(string.Format("WSFail.\t{0}\t{1}", webReturn.Code, webReturn.Message)); return; } if (string.IsNullOrEmpty(webReturn.Data)) { email = null; } else { OperationReturn optReturn = XMLHelper.DeserializeObject <EncryptEmail>(webReturn.Data as string); if (!optReturn.Result) { email = null; } else { email = optReturn.Data as EncryptEmail; } } } catch (Exception ex) { } finally { if (client != null) { if (client.State == System.ServiceModel.CommunicationState.Opened) { client.Close(); } } } }
/// <summary> /// 获得邮件通知配置信息 /// </summary> /// <param name="session"></param> /// <param name="lstParams"></param> /// <returns></returns> private OperationReturn GetEmailInfo(SessionInfo session, List <string> lstParams) { OperationReturn optReturn = new OperationReturn(); try { string rentToken = session.RentInfo.Token; string strSql = string.Empty; switch (session.DBType) { case 2: strSql = string.Format("SELECT * FROM T_11_001_{0} WHERE C001 = '{1}' and C002 =24 and C004 = 24041 ORDER BY C005", rentToken, session.RentID); optReturn = MssqlOperation.GetDataSet(session.DBConnectionString, strSql); if (!optReturn.Result) { return(optReturn); } break; case 3: strSql = string.Format("SELECT * FROM T_11_001_{0} WHERE C001 = '{1}' AND C002 =24 AND C004 = 24041 ORDER BY C005", rentToken, session.RentID); optReturn = OracleOperation.GetDataSet(session.DBConnectionString, strSql); if (!optReturn.Result) { return(optReturn); } break; } DataSet ds = optReturn.Data as DataSet; if (ds.Tables.Count <= 0 || ds.Tables[0].Rows.Count <= 0 || ds.Tables[0].Rows.Count < 8) { return(optReturn); } List <string> lstData = new List <string>(); EncryptEmail emailInfo = new EncryptEmail(); emailInfo.IsEnableEmail = ds.Tables[0].Rows[0]["C006"].ToString(); emailInfo.SMTP = ds.Tables[0].Rows[1]["C006"].ToString(); emailInfo.SMTPPort = ds.Tables[0].Rows[2]["C006"].ToString(); emailInfo.NeedSSL = ds.Tables[0].Rows[3]["C006"].ToString(); emailInfo.Account = ds.Tables[0].Rows[4]["C006"].ToString(); emailInfo.Pwd = ds.Tables[0].Rows[5]["C006"].ToString(); emailInfo.NeedAuthentication = ds.Tables[0].Rows[6]["C006"].ToString(); emailInfo.EmailAddress = ds.Tables[0].Rows[7]["C006"].ToString(); optReturn = XMLHelper.SeriallizeObject <EncryptEmail>(emailInfo); if (!optReturn.Result) { return(optReturn); } optReturn.Result = true; optReturn.Code = Defines.RET_SUCCESS; } catch (Exception ex) { optReturn.Result = false; optReturn.Code = Defines.RET_FAIL; optReturn.Message = ex.Message; optReturn.Exception = ex; } return(optReturn); }