12,162
社区成员
发帖
与我相关
我的任务
分享
[WebMethod(Description = "服务器端调用该方法向客户端发送邮件,传输登录网关配置信息,发送成功则返回true,否则返回错误信息")]
public string sendEMailForConfig(string emailServer, string sendAddress, string eUserName, string ePwd, string CompanyID)
{
string[] config = new string[6];//存储配置信息
string receiver = "";//收件人地址
string conStr = System.Configuration.ConfigurationManager.ConnectionStrings["conGZMServerDB"].ConnectionString;//连接字符串
SqlConnection conn = new SqlConnection(conStr);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Select CompanyID,ClientCode,LoginID,LoginPassword,GatewayIP,NotePort,EMail From Company Where CompanyID =" + CompanyID;
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
try
{
conn.Open();
SqlDataReader sdrConfig = cmd.ExecuteReader();
if (sdrConfig.Read())
{
int i=0;
for ( ; i < sdrConfig.FieldCount-1; i++)
{
config[i] = sdrConfig[i].ToString();//将配置信息存储在数组中
}
receiver = sdrConfig[i].ToString();//收件人邮箱地址
if (receiver.Replace(" ", "").Equals(""))
{
return "收件人邮箱地址不能为空。";
}
}
sdrConfig.Close();
createConfigIni(config);//写配置文件
sendEmail(emailServer, sendAddress, eUserName, ePwd, receiver, path);//发邮件
return "发送成功";
}
catch (Exception ex)
{
return ex.ToString();
}
finally
{
conn.Dispose();
cmd.Dispose();
}
}