public List<Maticsoft.Model.SysManage.VerifyMail> DataTableToList(DataTable dt)
{
List<Maticsoft.Model.SysManage.VerifyMail> list = new List<Maticsoft.Model.SysManage.VerifyMail>();
int count = dt.Rows.Count;
if (count > 0)
{
for (int i = 0; i < count; i++)
{
Maticsoft.Model.SysManage.VerifyMail item = new Maticsoft.Model.SysManage.VerifyMail();
if ((dt.Rows[i]["UserName"] != null) && (dt.Rows[i]["UserName"].ToString() != ""))
{
item.UserName = dt.Rows[i]["UserName"].ToString();
}
if ((dt.Rows[i]["KeyValue"] != null) && (dt.Rows[i]["KeyValue"].ToString() != ""))
{
item.KeyValue = dt.Rows[i]["KeyValue"].ToString();
}
if ((dt.Rows[i]["CreatedDate"] != null) && (dt.Rows[i]["CreatedDate"].ToString() != ""))
{
item.CreatedDate = DateTime.Parse(dt.Rows[i]["CreatedDate"].ToString());
}
if ((dt.Rows[i]["Status"] != null) && (dt.Rows[i]["Status"].ToString() != ""))
{
item.Status = int.Parse(dt.Rows[i]["Status"].ToString());
}
if ((dt.Rows[i]["ValidityType"] != null) && (dt.Rows[i]["ValidityType"].ToString() != ""))
{
item.ValidityType = new int?(int.Parse(dt.Rows[i]["ValidityType"].ToString()));
}
list.Add(item);
}
}
return list;
}
public Maticsoft.Model.SysManage.VerifyMail GetModel(string KeyValue)
{
StringBuilder builder = new StringBuilder();
builder.Append("select top 1 UserName,KeyValue,CreatedDate,Status,ValidityType from Accounts_VerifyMail ");
builder.Append(" where KeyValue=@KeyValue ");
SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@KeyValue", SqlDbType.NVarChar, 50) };
cmdParms[0].Value = KeyValue;
Maticsoft.Model.SysManage.VerifyMail mail = new Maticsoft.Model.SysManage.VerifyMail();
DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms);
if (set.Tables[0].Rows.Count <= 0)
{
return null;
}
if ((set.Tables[0].Rows[0]["UserName"] != null) && (set.Tables[0].Rows[0]["UserName"].ToString() != ""))
{
mail.UserName = set.Tables[0].Rows[0]["UserName"].ToString();
}
if ((set.Tables[0].Rows[0]["KeyValue"] != null) && (set.Tables[0].Rows[0]["KeyValue"].ToString() != ""))
{
mail.KeyValue = set.Tables[0].Rows[0]["KeyValue"].ToString();
}
if ((set.Tables[0].Rows[0]["CreatedDate"] != null) && (set.Tables[0].Rows[0]["CreatedDate"].ToString() != ""))
{
mail.CreatedDate = DateTime.Parse(set.Tables[0].Rows[0]["CreatedDate"].ToString());
}
if ((set.Tables[0].Rows[0]["Status"] != null) && (set.Tables[0].Rows[0]["Status"].ToString() != ""))
{
mail.Status = int.Parse(set.Tables[0].Rows[0]["Status"].ToString());
}
if ((set.Tables[0].Rows[0]["ValidityType"] != null) && (set.Tables[0].Rows[0]["ValidityType"].ToString() != ""))
{
mail.ValidityType = new int?(int.Parse(set.Tables[0].Rows[0]["ValidityType"].ToString()));
}
return mail;
}
public bool SendRegisterEmail(string username, string EmailUrl)
{
string str = Guid.NewGuid().ToString().Replace("-", "");
Maticsoft.BLL.SysManage.VerifyMail mail = new Maticsoft.BLL.SysManage.VerifyMail();
Maticsoft.Model.SysManage.VerifyMail model = new Maticsoft.Model.SysManage.VerifyMail {
UserName = username,
KeyValue = str,
CreatedDate = DateTime.Now,
Status = 0,
ValidityType = 0
};
mail.Add(model);
int templetId = Globals.SafeInt(ConfigSystem.GetValueByCache("EmailTemplet_Register"), 0);
Maticsoft.Model.Ms.EmailTemplet modelByCache = this.GetModelByCache(templetId);
if (modelByCache != null)
{
string body = this.ReplaceTag(modelByCache.EmailBody, new string[][] { new string[] { "{Domain}", HttpContext.Current.Request.Url.Authority }, new string[] { "{CreatedDate}", DateTime.Now.ToString("yyyy-MM-dd") }, new string[] { "{SecretKey}", str }, new string[] { "{UserName}", username } });
try
{
Maticsoft.Model.MailConfig config = this.config.GetModel();
if ((model != null) && !string.IsNullOrWhiteSpace(config.Mailaddress))
{
MailSender.Send(config.SMTPServer, config.Username, DESEncrypt.Decrypt(config.Password), config.Mailaddress, EmailUrl, "", "", modelByCache.EmailSubject, body, true, Encoding.UTF8, true, config.SMTPSSL, null);
return true;
}
return true;
}
catch (Exception exception)
{
Maticsoft.Model.SysManage.ErrorLog log = new Maticsoft.Model.SysManage.ErrorLog {
Loginfo = "邮件发送失败！错误信息为：" + exception.StackTrace,
OPTime = DateTime.Now,
Url = "",
StackTrace = exception.StackTrace
};
Maticsoft.BLL.SysManage.ErrorLog.Add(log);
return false;
}
}
return false;
}