//帳號申請ＵＲＬ驗證專用SMTP
public void RegistAccountURL(ArrayList UserSmtp)
{
MailAddress mailFromUser = new MailAddress(UserSmtp[0].ToString(), UserSmtp[1].ToString(), Encoding.UTF8);
MailMessage mailUser = new MailMessage();
mailUser.From = mailFromUser;
mailUser.To.Add(UserSmtp[10].ToString());
mailUser.IsBodyHtml = true;
mailUser.Body = "<table><tr><td>申請人姓名：" + AddMethodSystem.NoHTML(UserSmtp[6].ToString()) + "</td></tr>";
if (smtp[3].ToString() != string.Empty)
{
mailUser.Body += "<tr><td>您申請的7000GO帳號名稱：" + AddMethodSystem.NoHTML(smtp[3].ToString()) + "</td></tr>";
}
if (smtp[4].ToString() != string.Empty)
{
mailUser.Body += "<tr><td>您註冊的7000GO網站名稱：" + AddMethodSystem.NoHTML(smtp[4].ToString()) + "</td></tr>";
}
mailUser.Body += "<tr><td>請點擊下面網址通過帳戶驗證</td></tr>";
mailUser.Body += "<tr><td>" + UserSmtp[16].ToString() + "</td></tr>";
mailUser.Body += "</table><br/>";
//在此加入信件Footer設定
mailUser.Body += FooterSet();
mailUser.Subject = AddMethodSystem.NoHTML(smtp[17].ToString());
mailUser.SubjectEncoding = Encoding.UTF8;
mailUser.Priority = MailPriority.Normal;
SmtpClient SMTP = new SmtpClient(smtp[15].ToString(), int.Parse(smtp[14].ToString())); //主機位置與port
SMTP.Credentials = new NetworkCredential(smtp[0].ToString(), smtp[2].ToString()); //server@domainname
SMTP.Send(mailUser);
}
/// <summary>
/// 此方法為Radio擁有2種屬性String,Int 且擁有一個下拉選單
/// </summary>
/// <param name="RadioColumn">選擇的欄位名</param>
/// <param name="RadioColumnSet1">string欄位名</param>
/// <param name="RadioColumnSet2">Int欄位名</param>
/// <param name="Txtbox1">TextBox輸入字串</param>
/// <param name="DropdownValue">下拉值</param>
/// <param name="DropdownSet1">下拉欄位</param>
/// <returns></returns>
public static string SearchWHEREStringObject(string RadioColumn, string RadioColumnSet1, string RadioColumnSet2, string Txtbox1, int DropdownValue, string DropdownSet1, string ORDER)
{
StringBuilder sb = new StringBuilder();
sb.Append("1=1");
if (Txtbox1.ToLower() != "all" && Txtbox1 != string.Empty)
{
if (RadioColumn == RadioColumnSet1)
{
sb.Append(" AND " + RadioColumnSet1 + " LIKE '%" + AddMethodSystem.NoHTML(Txtbox1) + "%'");
}
else
{
if (Tools.TryParseMethod(Txtbox1.ToString()) != 0)
{
sb.Append(" AND " + RadioColumnSet2 + "<=" + int.Parse(Txtbox1));
}
else
{
sb.Append(" AND " + RadioColumnSet1 + " LIKE '%" + AddMethodSystem.NoHTML(Txtbox1) + "%'");
}
}
}
if (DropdownValue != 0)
{
sb.Append(" AND " + DropdownSet1 + "=" + DropdownValue);
}
// sb.Append(ORDER);
return(sb.ToString());
}
//支援多型
/// <summary>
/// 此方法為Radio擁有2欄位且擁有欄位為:Price
/// </summary>
/// <param name="SELECT">SELECT欄位</param>
/// <param name="Tablename">資料表名稱</param>
/// <param name="RadioColumn">RadioButton選擇值</param>
/// <param name="RadioColumnSet1">RadioButton欄位1</param>
/// <param name="RadioColumnSet2">RadioButton欄位2</param>
/// <param name="Txtbox1">TextBox輸入字串</param>
/// <param name="DropdownValue">DropdownList下拉類別</param>
/// <param name="DropdownSet1">DropdownList下拉欄位</param>
/// <param name="ORDER">排序字串</param>
/// <returns></returns>
public static string SearchWHEREString(string SELECT, string Tablename, string RadioColumn, string RadioColumnSet1, string RadioColumnSet2, string Txtbox1, int DropdownValue, string DropdownSet1, string ORDER)
{
int i = 0;
StringBuilder sb = new StringBuilder();
sb.Append("SELECT " + SELECT + " FROM " + Tablename + " WHERE 1=1");
if (RadioColumn == RadioColumnSet1)
{
if (Txtbox1.ToLower() != "all" && Txtbox1 != string.Empty)
{
sb.Append(" AND " + RadioColumnSet1 + " LIKE '%" + AddMethodSystem.NoHTML(Txtbox1) + "%'");
}
}
else
{
if (Txtbox1.ToLower() != "all" && Txtbox1 != string.Empty)
{
if (int.TryParse(Txtbox1, out i))
{
sb.Append(" AND " + RadioColumnSet2 + "<=" + int.Parse(Txtbox1));
}
else
{
sb.Append(" AND " + RadioColumnSet1 + " LIKE '%" + AddMethodSystem.NoHTML(Txtbox1) + "%'");
}
}
}
if (DropdownValue != 0)
{
sb.Append(" AND " + DropdownSet1 + "=" + DropdownValue);
}
sb.Append(ORDER);
return(sb.ToString());
}
//支援多型
/// <summary>
/// 此方法為:單一TextBox搜尋-控制項:1
/// </summary>
/// <param name="SELECT"></param>
/// <param name="Tablename"></param>
/// <param name="RadioColumn">欄位名</param>
/// <param name="Txtbox1">欄位值</param>
/// <returns></returns>
public static string SearchWHEREStringObject(string RadioColumn, string Txtbox1, string ORDER)
{
StringBuilder sb3 = new StringBuilder();
sb3.Append("1=1");
if (Txtbox1.ToLower() != "all" && Txtbox1 != string.Empty)
{
sb3.Append(" AND " + RadioColumn + " LIKE '%" + AddMethodSystem.NoHTML(Txtbox1) + "%'");
}
// sb3.Append(ORDER);
return(sb3.ToString());
}
/// <summary>
/// 此方法為無Dropdown與Radio分別欄位
/// </summary>
/// <param name="SELECT"></param>
/// <param name="Tablename"></param>
/// <param name="RadioColumn"></param>
/// <param name="Txtbox1"></param>
/// <param name="ORDER"></param>
/// <returns></returns>
public static string SearchWHEREString(string SELECT, string Tablename, string RadioColumn, string Txtbox1, string ORDER)
{
StringBuilder sb3 = new StringBuilder();
sb3.Append("SELECT " + SELECT + " FROM " + Tablename + " WHERE 1=1");
if (Txtbox1.ToLower() != "all" && Txtbox1 != string.Empty)
{
sb3.Append(" AND " + RadioColumn + " LIKE '%" + AddMethodSystem.NoHTML(Txtbox1) + "%'");
}
sb3.Append(ORDER);
return(sb3.ToString());
}
/// <summary>
/// 此種方法用在Radio有N欄位且搭配一個Int值Dropdown-控制項:2
/// </summary>
/// <param name="RadioColumn">欄位名</param>
/// <param name="Txtbox1">欄位值</param>
/// <param name="DropdownValue">Int下拉值</param>
/// <param name="DropdownSet1">欄位名</param>
/// <returns></returns>
public static string SearchWHEREStringObject(string RadioColumn, string Txtbox1, int DropdownValue, string DropdownSet1, string ORDER)
{
StringBuilder sb2 = new StringBuilder();
sb2.Append("1=1");
if (Txtbox1.ToLower() != "all" && Txtbox1 != string.Empty)
{
sb2.Append(" AND " + RadioColumn + " LIKE '%" + AddMethodSystem.NoHTML(Txtbox1) + "%'");
}
if (DropdownValue != 0)
{
sb2.Append(" AND " + DropdownSet1 + "=" + DropdownValue);
}
// sb2.Append(ORDER);
return(sb2.ToString());
}
public void SendMail(ArrayList SmtpList)
{
//發件者信箱,名稱,編碼
MailAddress mailFrom = new MailAddress(smtp[0].ToString(), smtp[1].ToString(), Encoding.UTF8);
MailMessage mail = new MailMessage();
mail.From = mailFrom; //發件者
try
{
for (int i = 0; i < AL.Count; i++)
{
if (AL[i].ToString().Trim() != string.Empty)
{
mail.To.Add(AL[i].ToString()); //收件者
}
}
}
catch
{
mail.To.Add("*****@*****.**");
}
mail.IsBodyHtml = true;
//異動變數區
mail.Body = "<table><tr><td>訪客姓名：" + AddMethodSystem.NoHTML(SmtpList[6].ToString()) + "</td></tr>";
if (smtp[11].ToString() != string.Empty)
{
mail.Body += "<tr><td>主 旨：" + AddMethodSystem.NoHTML(smtp[11].ToString()) + "</td></tr>";
}
if (smtp[9].ToString() != string.Empty)
{
mail.Body += "<tr><td>地 址：" + AddMethodSystem.NoHTML(smtp[9].ToString()) + "</td></tr>";
}
if (smtp[7].ToString() != string.Empty)
{
mail.Body += "<tr><td>聯絡電話：" + AddMethodSystem.NoHTML(smtp[7].ToString()) + "</td></tr>";
}
if (smtp[8].ToString() != string.Empty)
{
mail.Body += "<tr><td>手 機：" + AddMethodSystem.NoHTML(smtp[8].ToString()) + "</td></tr>";
}
if (smtp[10].ToString() != string.Empty)
{
mail.Body += "<tr><td>電子信箱：" + AddMethodSystem.NoHTML(smtp[10].ToString()) + "</td></tr>";
}
if (smtp[12].ToString() != string.Empty)
{
mail.Body += "<br/>內容:<br/><div style='width:600px;height:300px'><textarea id='Contents' name='Contents' style='width:600px;height:300px'>" + AddMethodSystem.NoHTML(smtp[12].ToString()) + "</textarea></div>";
}
if (smtp[3].ToString() != string.Empty)
{
mail.Body += "<tr><td>申請帳號：" + AddMethodSystem.NoHTML(smtp[3].ToString()) + "</td></tr>";
}
if (smtp[4].ToString() != string.Empty)
{
mail.Body += "<tr><td>網站名稱：" + AddMethodSystem.NoHTML(smtp[4].ToString()) + "</td></tr>";
}
//異動變數區
mail.Body += "</table>";
if (smtp[18].ToString() != string.Empty)
{
mail.Subject = AddMethodSystem.NoHTML(smtp[18].ToString());
}
else
{
mail.Subject = AddMethodSystem.NoHTML(smtp[13].ToString());
}
mail.SubjectEncoding = Encoding.UTF8;
mail.Priority = MailPriority.Normal;
SmtpClient SMTP = new SmtpClient(smtp[15].ToString(), int.Parse(smtp[14].ToString())); //主機位置與port
//發送者驗證
SMTP.Credentials = new NetworkCredential(smtp[0].ToString(), smtp[2].ToString()); //server@domainname
SMTP.Send(mail);
if (smtp[16].ToString() != string.Empty)
{
RegistAccountURL(smtp);
}
}
