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));
}
