📄 domainclient.cs
字号:
using System;
using System.Text;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Web.Mail;
namespace Haokoo.domain
{
/// <summary>
/// DomainClient 的摘要说明。
/// </summary>
///
public class DomainDetails
{
public int myID;
public string DomainName;
public string Password;
public string email;
public string Url;
public string siteName;
public string ShowStr;
public int typeName;
public string DataFrom;
public string isLocked;
public string PopAd;
public DateTime RegDate;
}
public class DomainClient
{
public DataView GetDomainType()
{
SqlConnection myconn=new SqlConnection(ConfigurationSettings.AppSettings["sql_connstr"]);
SqlDataAdapter mycmd=new SqlDataAdapter("select * from Domain_Type",myconn);
DataSet ds=new DataSet();
mycmd.Fill(ds,"Domain_type");
return ds.Tables["Domain_type"].DefaultView;
}
public string RegisterDomain(string DomainName,string pwd,string email,string url,string ShowStr,string siteName,string typeName,string DataFrom)
{
int ReturnState;
string ReturnText;
string SqlStr;
SqlConnection myconn=new SqlConnection(ConfigurationSettings.AppSettings["sql_connstr"]);
myconn.Open();
SqlCommand mycmd=new SqlCommand("sp_Domain_Check",myconn);
mycmd.CommandType=CommandType.StoredProcedure;
SqlParameter myDomainName=mycmd.Parameters.Add("@myDomain",SqlDbType.NVarChar,30);
myDomainName.Value=DomainName;
ReturnState=(int)mycmd.ExecuteScalar();
switch (ReturnState)
{
case 100:
ReturnText="对不起，" + DomainName + ".haokoo.net 已经被别人注册了,请换名再试！";
break;
case 200:
ReturnText="对不起，" + DomainName+ ".haokoo.net 已经被保护起来了,请换名再试！";
break;
default:
try
{
SqlStr="Insert into Domain_Main(myDomain,password,email,url,isShow,siteName,typeName,DataFrom) Values('";
SqlStr+=DomainName+"','"+pwd+"','"+email+"','"+url+"','"+ShowStr+"','"+siteName.Replace("'","’");
SqlStr+="','"+typeName+"','"+DataFrom+"')";
mycmd=new SqlCommand(SqlStr,myconn);
mycmd.CommandType=CommandType.Text;
mycmd.ExecuteNonQuery();
//**************************************************************发送邮件开始
MailMessage myMail=new MailMessage();
StringBuilder MailBody=new StringBuilder();
myMail.From="<zhuho@haokoo.com>Haokoo.net";
myMail.To=email;
myMail.Subject="您的免费域名" +DomainName+ ".haokoo.net 的注册信息！";
myMail.BodyFormat=MailFormat.Html;
MailBody.Append("<style>A:visited { TEXT-DECORATION: none }");
MailBody.Append("A:active { TEXT-DECORATION: none }");
MailBody.Append("A:hover { TEXT-DECORATION: underline }");
MailBody.Append("A:link { text-decoration: none;}");
MailBody.Append("A:visited { text-decoration: none;}");
MailBody.Append("BODY { FONT-FAMILY: Verdana,宋体; FONT-SIZE: 9pt;}");
MailBody.Append("TD { FONT-FAMILY: Verdana,宋体; FONT-SIZE: 9pt }</style>");
MailBody.Append("<TABLE border=0 width='95%' align=center><TBODY><TR>");
MailBody.Append("<TD valign=middle align=top>");
MailBody.Append( DomainName + "，您好：<br><br>");
MailBody.Append("欢迎您使用HAOKOO.NET免费域名系统，我们将提供给您最好的域名转向服务！<br><br>");
MailBody.Append("下面是您的注册信息如下：<br>");
MailBody.Append("域名：<b>"+DomainName+".haokoo.net</b><br>");
MailBody.Append("您的密码："+pwd+"<br>");
MailBody.Append("注册邮箱："+email+"<br>");
MailBody.Append("转向地址："+url+"<br>");
MailBody.Append("网站名称："+siteName+"<br>");
MailBody.Append("<br>现在您可以通过<a href='http://" +DomainName+ ".haokoo.net' target='_blank'>http://" +DomainName+ ".haokoo.net</a>或");
MailBody.Append("<a href='http://www." +DomainName+ ".haokoo.net' target='_blank'>http://www." +DomainName+ ".haokoo.net</a>来访问您的网站，赶快试试吧！");
MailBody.Append("<br><br>");
MailBody.Append("<center><font color=red>全方位的.NET技术资源，尽在Haokoo.net！欢迎您下次光临！</font></TD></TR>");
MailBody.Append( "<TR><TD align=right><a href='http://www.haokoo.net' target='_blank'><img src='http://www.haokoo.net/images/logo.gif' ");
MailBody.Append( "border=0 alt='www.haokoo.net'></a></TD></TR>");
MailBody.Append("</TBODY></TABLE><br>");
myMail.Body=MailBody.ToString();
SmtpMail.Send(myMail);
//************************************************************************发送邮件结束
ReturnText="OK";
}
catch
{
ReturnText="对不起，程序出现致命错误，请检查提交的数据是否正确!";
}
finally
{
myconn.Close();
}
break;
}
return ReturnText;
}
public string EditLogin(string DomainName,string pwd)
{
SqlConnection myconn=new SqlConnection(ConfigurationSettings.AppSettings["sql_connstr"]);
SqlCommand mycmd=new SqlCommand("select id,myDomain,password from Domain_Main where myDomain='"+DomainName+"'" ,myconn);
myconn.Open();
SqlDataReader myDataReader=mycmd.ExecuteReader(CommandBehavior.CloseConnection);
if(myDataReader.Read())
{
if(pwd==myDataReader.GetString(2))
return "OK";
else
return "对不起，登录失败！可能是域名或密码错误！";
}
else
return "对不起，登录失败！该域名不存在！";
}
public string EditDomain(string DomainName,string pwd,string email,string url,string ShowStr,string siteName,string typeName,string isLocked,string PopAd,bool ChangePwd,bool EditFlag)
{
string SqlStr;
SqlStr="Update Domain_Main set email='" + email + "',url='" + url + "',siteName='" + siteName +"',isShow='" + ShowStr + "',typeName=" + typeName;
if(ChangePwd) SqlStr+=",password='"+pwd+"'";
if(EditFlag) SqlStr+=",isLocked='"+isLocked+"',PopAd='"+PopAd+"'";
SqlStr+=" Where myDomain='"+DomainName+"'";
try
{
SqlConnection myconn=new SqlConnection(ConfigurationSettings.AppSettings["sql_connstr"]);
SqlCommand mycmd=new SqlCommand(SqlStr,myconn);
myconn.Open();
mycmd.ExecuteNonQuery();
myconn.Close();
return "OK";
}
catch
{
return "对不起，程序出现致命错误，请检查提交的数据是否正确!";
}
}
public DomainDetails GetDomainDetail(string DomainName)
{
SqlConnection myconn=new SqlConnection(ConfigurationSettings.AppSettings["sql_connstr"]);
SqlCommand mycmd=new SqlCommand("select id,myDomain,password,email,url,isShow,siteName,typeName,DataFrom,isLocked,PopAd,RegDate from Domain_Main where myDomain='"+DomainName+"'" ,myconn);
myconn.Open();
SqlDataReader myDataReader=mycmd.ExecuteReader(CommandBehavior.CloseConnection);
DomainDetails myDomainDetail=new DomainDetails();
if(myDataReader.Read())
{
myDomainDetail.myID=myDataReader.GetInt32(0);
myDomainDetail.DomainName=DomainName;
myDomainDetail.Password=myDataReader.GetString(2);
myDomainDetail.email=myDataReader.GetString(3);
myDomainDetail.Url=myDataReader.GetString(4);
myDomainDetail.ShowStr=myDataReader.GetString(5);
myDomainDetail.siteName=myDataReader.GetString(6);
myDomainDetail.typeName=myDataReader.GetInt16(7);
myDomainDetail.DataFrom=myDataReader.GetString(8);
myDomainDetail.isLocked=myDataReader.GetString(9);
myDomainDetail.PopAd=myDataReader.GetString(10);
myDomainDetail.RegDate=myDataReader.GetDateTime(11);
}
return myDomainDetail;
}
public string PwdSendMail(string DomainName,string Emailbox)
{
SqlConnection myconn=new SqlConnection(ConfigurationSettings.AppSettings["sql_connstr"]);
SqlCommand mycmd=new SqlCommand("select mydomain,password,email from Domain_Main where myDomain='" +DomainName+ "'",myconn);
myconn.Open();
SqlDataReader myDataReader=mycmd.ExecuteReader(CommandBehavior.CloseConnection);
if(myDataReader.Read())
{
if(Emailbox==myDataReader.GetString(2))
{
MailMessage myMail=new MailMessage();
StringBuilder MailBody=new StringBuilder();
myMail.From="<zhuho@haokoo.com>Haokoo.net";
myMail.To=Emailbox;
myMail.Subject="您的免费域名" +DomainName+".haokoo.net的密码！";
myMail.BodyFormat=MailFormat.Html;
MailBody.Append("<style>A:visited { TEXT-DECORATION: none }");
MailBody.Append("A:active { TEXT-DECORATION: none }");
MailBody.Append("A:hover { TEXT-DECORATION: underline }");
MailBody.Append("A:link { text-decoration: none;}");
MailBody.Append("A:visited { text-decoration: none;}");
MailBody.Append("BODY { FONT-FAMILY: Verdana,宋体; FONT-SIZE: 9pt;}");
MailBody.Append("TD { FONT-FAMILY: Verdana,宋体; FONT-SIZE: 9pt }</style>");
MailBody.Append("<TABLE border=0 width='95%' align=center><TBODY><TR>");
MailBody.Append("<TD valign=middle align=top>");
MailBody.Append(DomainName + "，您好：<br><br>");
MailBody.Append("欢迎您使用HAOKOO.NET免费域名系统，我们将提供给您最好的域名转向服务！<br><br>");
MailBody.Append("下面是您的注册信息如下：<br>");
MailBody.Append("域名：<b>"+DomainName+ ".haokoo.net</b><br>");
MailBody.Append("您的密码："+ myDataReader.GetString(1) + "<br>");
MailBody.Append("注册邮箱："+ Emailbox + "<br>");
MailBody.Append("<br><br>");
MailBody.Append("<center><font color=red>全方位的.NET技术资源，尽在Haokoo.net！欢迎您下次光临！</font></TD></TR>");
MailBody.Append("<TR><TD align=right><a href='http://www.haokoo.net' target='_blank'><img src='http://www.haokoo.net/images/logo.gif' ");
MailBody.Append("border=0 alt='www.haokoo.net'></a></TD></TR>");
MailBody.Append("</TBODY></TABLE><br>");
myMail.Body=MailBody.ToString();
SmtpMail.Send(myMail);
return "OK";
}
else
return "密码发送失败，因为域名与您提供的Email不匹配！";
}
else
return "密码发送失败，该域名不存在！";
}
public SqlDataReader DomainTypeList()
{
string Sqlstr="SELECT Domain_Type.ID, Domain_Type.TypeName, COUNT(Domain_Main.typeName) AS TotalNum FROM Domain_Type LEFT JOIN Domain_Main ON Domain_Type.ID = ";
Sqlstr+="Domain_Main.typeName GROUP BY Domain_Type.ID, Domain_Type.TypeName, Domain_Main.typeName";
SqlConnection myconn=new SqlConnection(ConfigurationSettings.AppSettings["sql_connstr"]);
SqlCommand mycmd=new SqlCommand(Sqlstr,myconn);
myconn.Open();
return mycmd.ExecuteReader(CommandBehavior.CloseConnection);
}
public DataView DomainDetailList(string ClassID)
{
SqlConnection myconn=new SqlConnection(ConfigurationSettings.AppSettings["sql_connstr"]);
SqlDataAdapter mycmd=new SqlDataAdapter("select d.*,t.typeName as siteType from Domain_main d,Domain_type t where d.typename=t.id and d.typename=" + ClassID,myconn);
DataSet ds=new DataSet();
mycmd.Fill(ds,"domain_main");
return ds.Tables["domain_main"].DefaultView;
}
public SqlDataReader DomainTop100()
{
SqlConnection myconn=new SqlConnection(ConfigurationSettings.AppSettings["sql_connstr"]);
SqlCommand mycmd=new SqlCommand("select top 50 d.*,t.typeName as siteType from Domain_main d,Domain_type t where d.typename=t.id order by hitcount desc",myconn);
myconn.Open();
return mycmd.ExecuteReader(CommandBehavior.CloseConnection);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -