protected void BtnEdit_Click1(object sender, EventArgs e) { for (int i = 0; i <= GridViewUsers.Rows.Count - 1; i++) { CheckBox cbox = (CheckBox)GridViewUsers.Rows[i].FindControl("CheckBoxs"); if (cbox.Checked == true) { string userID = GridViewUsers.DataKeys[i].Value.ToString(); User user = new User(); CTUserInfo userinfo = new CTUserInfo(); userinfo = user.GetUserInfoByUserID(userID).First(); //tbUserId.Text = userID; //string userName = GridViewUsers.Rows[i].Cells[2].Text.ToString(); //tbUserName.Text = userName; //string UserRealName = GridViewUsers.Rows[i].Cells[3].Text.ToString(); //tbUserRealName.Text = UserRealName; //string userage = GridViewUsers.Rows[i].Cells[4].Text.ToString(); //tbUserAge.Text = userage; //string usersex = GridViewUsers.Rows[i].Cells[5].Text.ToString(); //tbUserSex.Text = usersex; //string userAddress = GridViewUsers.Rows[i].Cells[6].Text.ToString(); //tbUserAddress.Text = userAddress; //string userEmail = GridViewUsers.Rows[i].Cells[7].Text.ToString(); //tbUserEmail.Text = userEmail; tbUserId.Text = userID; tbUserName.Text = userinfo.UserName; tbUserRealName.Text = userinfo.UserRealName; tbUserAge.Text = userinfo.UserAge.ToString(); tbUserSex.Text = userinfo.UserSex; tbUserAddress.Text = userinfo.UserAddress; tbUserEmail.Text = userinfo.UserEmail; tbUserWeiBo.Text = userinfo.UserWeiBo; tbUserQQNumber.Text = userinfo.UserQQNum; tbUserLevel.Text = userinfo.UserLevel; tbUserUserInfo.Text = userinfo.UserInfo; tbUserComplaintNumber.Text = userinfo.ComplainNum.ToString(); tbPortrait.Text = userinfo.Portrait; tbRoldID.Text = userinfo.RoldID; tbLastLoginTime.Text = userinfo.LastLoginTime; tbLoginTimes.Text = userinfo.LoginTimes.ToString(); tbModifyTime.Text = userinfo.ModifyTime; tbCreateTime.Text = userinfo.CreateTime; tbIsUsed.Text = userinfo.IsUsed.ToString(); } } }
//根据用户的ID得到用户的信息 public List <CTUserInfo> GetUserInfoByUserID(string UserID) { List <CTUserInfo> userInfoList = new List <CTUserInfo>(); SqlParameter parm = new SqlParameter(PARM_USER_ID, SqlDbType.NVarChar); parm.Value = UserID; //execute the query using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringLocalTransaction, CommandType.Text, SQL_SELECT_USERS_BY_USERID, parm)) { while (rdr.Read()) { CTUserInfo user = new CTUserInfo(); user.UserID = rdr["UserID"].ToString(); user.UserName = rdr["UserName"].ToString(); user.UserPass = rdr["UserPass"].ToString(); user.UserEmail = rdr["UserEmail"].ToString(); user.UserPhoneNumber = rdr["UserPhoneNumber"].ToString(); user.UserQQNum = rdr["UserQQNum"].ToString(); user.UserRealName = rdr["UserRealName"].ToString(); int tempAge = 0; user.UserAge = int.TryParse(rdr["UserAge"].ToString(), out tempAge) ? tempAge : 0; user.UserInfo = rdr["UserInfo"].ToString(); user.UserSex = rdr["UserSex"].ToString(); int tempComplain = 0; user.ComplainNum = int.TryParse(rdr["ComplaintNum"].ToString(), out tempComplain) ? tempComplain : 0; bool tempIsUsed = false; user.IsUsed = bool.TryParse(rdr["IsUsed"].ToString(), out tempIsUsed) ? tempIsUsed : false; user.UserWeiBo = rdr["UserWeiBo"].ToString(); user.Portrait = rdr["Portrait"].ToString(); user.UserLevel = rdr["UserLevel"].ToString(); user.CreateTime = rdr["CreateTime"].ToString(); user.ModifyTime = rdr["ModifyTime"].ToString(); user.RoldID = rdr["RoleID"].ToString(); user.LastLoginTime = rdr["LastLoginTime"].ToString(); int tempLoginTemps = 0; user.LoginTimes = int.TryParse(rdr["LoginTimes"].ToString(), out tempLoginTemps) ? tempLoginTemps : 0; userInfoList.Add(user); } } return(userInfoList); }
//编辑用户信息 public int EditUserInfo(string UserID, CTUserInfo userInfo) { int EditStatus = 0; SqlParameter[] parms = null; parms = new SqlParameter[] { new SqlParameter("@UserName", SqlDbType.NVarChar, 50), new SqlParameter("@UserPass", SqlDbType.NVarChar, 50), new SqlParameter("@UserRealName", SqlDbType.NVarChar, 50), new SqlParameter("@UserAge", SqlDbType.Int), new SqlParameter("@UserSex", SqlDbType.Char, 2), new SqlParameter("@UserAddress", SqlDbType.NVarChar, 50), new SqlParameter("@UserEmail", SqlDbType.NVarChar, 50), new SqlParameter("@UserPhoneNumber", SqlDbType.NVarChar, 11), new SqlParameter("@UserQQNum", SqlDbType.NVarChar, 10), new SqlParameter("@UserInfo", SqlDbType.NVarChar, 100), new SqlParameter("@ComplaintNum", SqlDbType.Int), new SqlParameter("@UserID", SqlDbType.NVarChar, 20), }; parms[0].Value = userInfo.UserName; parms[1].Value = userInfo.UserPass; parms[2].Value = userInfo.UserRealName; parms[3].Value = userInfo.UserAge; parms[4].Value = userInfo.UserSex; parms[5].Value = userInfo.UserAddress; parms[6].Value = userInfo.UserEmail; parms[7].Value = userInfo.UserPhoneNumber; parms[8].Value = userInfo.UserQQNum; parms[9].Value = userInfo.UserInfo; parms[10].Value = userInfo.ComplainNum; parms[11].Value = UserID; using (SqlConnection conn = new SqlConnection(SqlHelper.ConnectionStringOrderDistributedTransaction)) { EditStatus = SqlHelper.ExecuteNonQuery(conn, CommandType.Text, SQL_EDIT_USER, parms); } return(EditStatus); }
protected void BtnRegister_Click(object sender, EventArgs e) { string username = tb_UserName.Text.Trim().ToString(); string pass = tb_Pass.Text.Trim().ToString(); string passConfirm = tb_PassConfirm.Text.Trim().ToString(); string email = tb_Email.Text.Trim().ToString(); int age = int.Parse(tb_Age.Text.Trim().ToString()); User user = new User(); CTUserInfo userInfo = new CTUserInfo(username, pass, "", "", age, "", email, "", "", "", "", 0); int insertStatus = user.InsertUserInfo(userInfo); if (insertStatus == 1) { //CUtilities.SendMail("petcareweb", "*****@*****.**", "aaa", "aaa"); Response.Write("<script>alert('注册成功!')</script>"); } else { Response.Write("<script>alert('注册失败!')</script>"); } }
protected void Btn_Click(object sender, EventArgs e) { string name = tbUserName.Text.Trim().ToString(); string address = tbUserAddress.Text.Trim().ToString(); string email = tbUserEmail.Text.Trim().ToString(); int age = int.Parse(tbUserAge.Text.Trim().ToString()); string realname = tbUserRealName.Text.Trim().ToString(); string sex = tbUserSex.Text.Trim().ToString(); int complaintNumb = int.Parse(tbUserComplaintNumber.Text.Trim().ToString()); string qqNumb = tbUserQQNumber.Text.Trim().ToString(); string phoneNumb = tbUserPhoneNumber.Text.Trim().ToString(); string userInfo = tbUserUserInfo.Text.Trim().ToString(); CTUserInfo userinfo = new CTUserInfo(); userinfo.UserName = name; userinfo.UserAddress = address; userinfo.UserEmail = email; userinfo.UserAge = age; userinfo.UserPass = ""; userinfo.UserRealName = realname; userinfo.UserSex = sex; userinfo.ComplainNum = complaintNumb; userinfo.UserQQNum = qqNumb; userinfo.UserInfo = userInfo; userinfo.UserPhoneNumber = phoneNumb; PetCare.BLL.User user = new User(); int insertStatus = user.InsertUserInfo(userinfo); if (insertStatus > 0) { } LoadUser(); }
//编辑用户信息 public int EditUserInfo(string UserID, CTUserInfo userInfo) { return(dal.EditUserInfo(UserID, userInfo)); }
//插入用户信息 public int InsertUserInfo(CTUserInfo userinfo) { return(dal.InsertUser(userinfo)); }