62,046
社区成员
发帖
与我相关
我的任务
分享
User类:
public int UserId { get; set; }//用户编号
public string UserName { get; set; } //用户名,登录用。
public string UserPassword { get; set; } // 密码
public string UserSex { get; set; }//性别
public string UserPhone { get; set; }// 联系电话
public int Charm { get; set; } // 魅力值,通过好友印象投票所得
public Groggery Groggery { get; set; }// 外键对象
/// <summary>
/// 用户注册
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public bool AddUser(User user)
{
string sql = "insert into Users values (@UserName,@UserPassword,@UserSex,@UserPhone,@Charm,@GroggeryId,@UserState,@UserImage,@Number)";
return DBHelper.GetExcuteNonQuery(sql,
DBHelper.CreateParameter("@UserName", SqlDbType.NVarChar, user.UserName),
DBHelper.CreateParameter("@UserPassword", SqlDbType.NVarChar, user.UserPassword),
DBHelper.CreateParameter("@UserSex", SqlDbType.NVarChar, user.UserSex),
DBHelper.CreateParameter("@UserPhone", SqlDbType.NVarChar, user.UserPhone),
DBHelper.CreateParameter("@Charm", SqlDbType.Int, user.Charm),
DBHelper.CreateParameter("@GroggeryId", SqlDbType.Int, user.Groggery.GroggeryId),
DBHelper.CreateParameter("@UserState", SqlDbType.Int, user.UserState),
DBHelper.CreateParameter("@UserImage", SqlDbType.NVarChar, user.UserImage),
DBHelper.CreateParameter("@Number", SqlDbType.Int, user.Number)
) > 0;
}
/// <summary>
/// 修改用户信息
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public bool UpdateUserStateById(User user)
{
StringBuilder sql = new StringBuilder();
sql.Append("UPDATE USERS SET ");
sql.Append("UserName=@UserName, ");
sql.Append("UserPassword=@UserPassword, ");
sql.Append("UserSex=@UserSex, ");
sql.Append("UserPhone=@UserPhone, ");
sql.Append("Charm=@Charm, ");
sql.Append("GroggeryId=@GroggeryId, ");
sql.Append("UserState=@UserState, ");
sql.Append("UserImage=@UserImage, ");
sql.Append("number=@Number ");
sql.Append("where UserId=@UserId");
SqlParameter[] param ={
new SqlParameter("@UserName",SqlDbType.NVarChar),
new SqlParameter("@UserPassword",SqlDbType.NVarChar),
new SqlParameter("@UserSex",SqlDbType.NVarChar),
new SqlParameter("@UserPhone",SqlDbType.NVarChar),
new SqlParameter("@Charm",SqlDbType.Int),
new SqlParameter("@GroggeryId",SqlDbType.Int),
new SqlParameter("@UserState",SqlDbType.Int),
new SqlParameter("@UserImage",SqlDbType.NVarChar),
new SqlParameter("@Number",SqlDbType.Int),
new SqlParameter("@UserId",SqlDbType.Int)
};
param[0].Value = user.UserId;
param[1].Value = user.UserName;
param[2].Value = user.UserPassword;
param[3].Value = user.UserSex;
param[4].Value = user.UserPhone;
param[5].Value = user.Charm;
param[6].Value = user.Groggery.GroggeryId;
param[7].Value = user.UserState;
param[8].Value = user.UserImage;
param[9].Value = user.Number;
return DBHelper.GetExcuteNonQuery(sql.ToString(), param) > 0;
}
protected void Button1_Click(object sender, EventArgs e)
{
user.UserName = this.txtUserName.Text;
user.UserPassword = this.txtUserPassword.Text;
user.UserSex = this.txtUserSex.Text;
user.UserPhone = this.txtUserPhone.Text;
user.Charm = 0;
//user.Groggery.GroggeryId = this.DropDownList1.SelectedItem.Value;
user.Groggery.GroggeryId = 100;
user.UserState = 0;
user.UserImage = "null.jpg";
user.Number = 0;
if (um.AddUser(user))
{
Response.Write("1," + user.UserId);
}
else
{
Response.Write("0");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
user.UserName = this.txtUserName.Text;
user.UserPassword = this.txtUserPassword.Text;
//你这里的user实体类,只给9个属性赋值,插入操作里面有10个字段,不报错才怪!!!!!