public DtCms.Model.Member QueryOneRecord(string UserName)
{
DtCms.Model.Member member;
string cmdstr = "Select * From dt_Member Where UserName='******'";
SqlParameter[] SqlParam = new SqlParameter[1];
SqlParam[0] = new SqlParameter("@UserName", UserName);
//获取SqlDataReader对象
SqlDataReader dataReader = DbHelperSQL.ExecuteReader(cmdstr, SqlParam);
if (dataReader.Read())
{
member = new DtCms.Model.Member();
member.Id = Convert.ToInt32(dataReader["Id"]);
member.Username = dataReader["Username"].ToString();
member.Turename = dataReader["Turename"].ToString();
member.Team = dataReader["Team"].ToString();
member.Usertel = dataReader["Usertel"].ToString();;
member.IsATMember = dataReader["IsATMember"].ToString();
}
else
{
member = null;
}
dataReader.Close();
return(member);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string Code = txtCode.Text.Trim();
string UserName = txtUserName.Text.Trim();
string pwd = txtpwd.Text.Trim();
string TureName = txtTureName.Text.Trim();
string UserTel = txtUserTel.Text.Trim();
string UserQQ = txtUserQQ.Text.Trim();
if (Code.ToLower() != (Session["DtCode"].ToString()).ToLower())
{
Response.Write("<script>alert('您输入的验证码与系统的不一致！');</script>");
return;
}
if (string.IsNullOrEmpty(UserName))
{
Response.Write("<script>alert('请输入会员名！');</script>");
return;
}
if (string.IsNullOrEmpty(pwd))
{
Response.Write("<script>alert('请输入密码！');</script>");
return;
}
if (string.IsNullOrEmpty(TureName))
{
Response.Write("<script>alert('请输入姓名！');</script>");
return;
}
if (string.IsNullOrEmpty(UserTel))
{
Response.Write("<script>alert('请输入联系电话！');</script>");
return;
}
if (string.IsNullOrEmpty(UserQQ))
{
Response.Write("<script>alert('请输入在线QQ！');</script>");
return;
}
DtCms.Model.Member member = new DtCms.Model.Member();
member.Username = UserName;
member.Pwd = pwd;
member.Turename = TureName;
member.Usertel = UserTel;
member.Userqq = UserQQ;
DtCms.BLL.Member bll = new DtCms.BLL.Member();
bll.Add(member);
Session["Member"] = UserName;
Response.Write("<script>alert('注册成功！');window.location.href='index.aspx'</script>");
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DtCms.Model.Member model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update dt_Member set ");
strSql.Append("UserName=@UserName,");
strSql.Append("Pwd=@Pwd,");
strSql.Append("TureName=@TureName,");
strSql.Append("UserTel=@UserTel,");
strSql.Append("UserQQ=@UserQQ,");
strSql.Append("AddTime=@AddTime,");
strSql.Append("Team=@Team,");
strSql.Append("IsATMember=@IsATMember,");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@UserName", SqlDbType.NVarChar, 20),
new SqlParameter("@Pwd", SqlDbType.NVarChar, 20),
new SqlParameter("@TureName", SqlDbType.NVarChar, 20),
new SqlParameter("@UserTel", SqlDbType.NVarChar, 30),
new SqlParameter("@UserQQ", SqlDbType.NVarChar, 50),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@Team", SqlDbType.NVarChar, 50),
new SqlParameter("@IsATMember", SqlDbType.NVarChar, 10)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.Username;
parameters[2].Value = model.Pwd;
parameters[3].Value = model.Turename;
parameters[4].Value = model.Usertel;
parameters[5].Value = model.Userqq;
parameters[6].Value = model.AddTime;
parameters[7].Value = model.Team;
parameters[8].Value = model.IsATMember;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DtCms.Model.Member model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into dt_Member(");
strSql.Append("UserName,Pwd,TureName,UserTel,UserQQ,AddTime,Team,IsATMember)");
strSql.Append(" values (");
strSql.Append("@UserName,@Pwd,@TureName,@UserTel,@UserQQ,@AddTime,@Team,@IsATMember)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@UserName", SqlDbType.NVarChar, 20),
new SqlParameter("@Pwd", SqlDbType.NVarChar, 20),
new SqlParameter("@TureName", SqlDbType.NVarChar, 20),
new SqlParameter("@UserTel", SqlDbType.NVarChar, 30),
new SqlParameter("@UserQQ", SqlDbType.NVarChar, 50),
new SqlParameter("@AddTime", SqlDbType.DateTime),
new SqlParameter("@Team", SqlDbType.NVarChar, 50),
new SqlParameter("@IsATMember", SqlDbType.NVarChar, 10)
};
parameters[0].Value = model.Username;
parameters[1].Value = model.Pwd;
parameters[2].Value = model.Turename;
parameters[3].Value = model.Usertel;
parameters[4].Value = model.Userqq;
parameters[5].Value = model.AddTime;
parameters[6].Value = model.Team;
parameters[7].Value = model.IsATMember;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public DtCms.Model.Member GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 Id,UserName,Pwd,TureName,UserTel,UserQQ,AddTime,Team,IsATMember from dt_Member ");
strSql.Append(" where Id=@Id");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
DtCms.Model.Member model = new DtCms.Model.Member();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["Id"].ToString() != "")
{
model.Id = int.Parse(ds.Tables[0].Rows[0]["Id"].ToString());
}
model.Username = ds.Tables[0].Rows[0]["UserName"].ToString();
model.Pwd = ds.Tables[0].Rows[0]["Pwd"].ToString();
model.Turename = ds.Tables[0].Rows[0]["TureName"].ToString();
model.Usertel = ds.Tables[0].Rows[0]["UserTel"].ToString();
model.Userqq = ds.Tables[0].Rows[0]["UserQQ"].ToString();
model.Team = ds.Tables[0].Rows[0]["Team"].ToString();
model.IsATMember = ds.Tables[0].Rows[0]["IsATMember"].ToString();
if (ds.Tables[0].Rows[0]["AddTime"].ToString() != "")
{
model.AddTime = DateTime.Parse(ds.Tables[0].Rows[0]["AddTime"].ToString());
}
return(model);
}
else
{
return(null);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
string Code = txtCode.Text.Trim();
string UserName = txtUserName.Text.Trim();
string pwd = txtpwd.Text.Trim();
if (Code.ToLower() != (Session["DtCode"].ToString()).ToLower())
{
Response.Write("<script>alert('您输入的验证码与系统的不一致！');</script>");
return;
}
if (string.IsNullOrEmpty(UserName))
{
Response.Write("<script>alert('请输入会员名！');</script>");
return;
}
if (string.IsNullOrEmpty(pwd))
{
Response.Write("<script>alert('请输入密码！');</script>");
return;
}
DtCms.Model.Member member = new DtCms.Model.Member();
member.Username = UserName;
member.Pwd = pwd;
DtCms.BLL.Member bll = new DtCms.BLL.Member();
if (bll.GetCount(" Username='******' and Pwd='" + pwd + "' ") > 0)
{
Session["Member"] = UserName;
Response.Write("<script>alert('登录成功！');window.location.href='index.aspx'</script>");
}
else
{
Response.Write("<script>alert('登录失败,会员名或密码输入错误！');</script>");
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(DtCms.Model.Member model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(DtCms.Model.Member model)
{
return(dal.Add(model));
}
