//帳號申請URL驗證專用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); } }