protected void btnSave_Click(object sender, EventArgs e) { Ctrl_Sys_User dcUserInfo = new Ctrl_Sys_User(); if (dcUserInfo.Exists(int.Parse(hdUserId.Value), txtUserName.Text)) { MessageBox.Show(this, "用户名称,不允许重复!"); return; } int iUserInfoId = int.Parse(hdUserId.Value.ToString());//取得区\县标识 UserInfoEntity userInfo = new UserInfoEntity(); userInfo.UserId = iUserInfoId; userInfo.UserName = txtUserName.Text; userInfo.UserNickName = txtUserNickName.Text; userInfo.UserLevel = int.Parse(drpUserLevel.SelectedValue); userInfo.StreetId = drpStreet.Enabled == true ? int.Parse(drpStreet.SelectedValue) : 0; userInfo.CommunityId = drpCommunity.Enabled == true ? int.Parse(drpCommunity.SelectedValue) : 0; if (iUserInfoId == 0)//代表添加 { userInfo.UserPwd = FormsAuthentication.HashPasswordForStoringInConfigFile(txtUserPwd.Text, "md5"); iUserInfoId = dcUserInfo.Add(userInfo); if (iUserInfoId > 0) { dcUserInfo.AddUserRole(iUserInfoId, int.Parse(drpUserRole.SelectedValue)); MessageBox.ShowAndRedirect(this, "成功添加一条信息!", "OperManage.aspx"); } else { MessageBox.Show(this, "添加信息失败,请与管理员联系!"); } } else { if (chkIsModPwd.Checked) { userInfo.UserPwd = FormsAuthentication.HashPasswordForStoringInConfigFile(txtUserPwd.Text, "md5"); } else { userInfo.UserPwd = hdUserPwd.Value; } if (dcUserInfo.UpdateUserRole(iUserInfoId, int.Parse(drpUserRole.SelectedValue)) && dcUserInfo.Update(userInfo)) { MessageBox.ShowAndRedirect(this, "成功修改一条信息!", "OperManage.aspx"); } else { MessageBox.Show(this, "修改信息失败,请与管理员联系!"); } } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(UserInfoEntity model) { int iExecute = 0; try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into Sys_User("); strSql.Append("UserName,UserPwd,UserNickName,UserLevel,StreetId,CommunityId)"); strSql.Append(" values ("); strSql.Append("@UserName,@UserPwd,@UserNickName,@UserLevel,@StreetId,@CommunityId)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar,30), new SqlParameter("@UserPwd", SqlDbType.NVarChar,100), new SqlParameter("@UserNickName", SqlDbType.NVarChar,30), new SqlParameter("@UserLevel", SqlDbType.Int), new SqlParameter("@StreetId", SqlDbType.Int), new SqlParameter("@CommunityId", SqlDbType.Int)}; parameters[0].Value = model.UserName; parameters[1].Value = model.UserPwd; parameters[2].Value = model.UserNickName; parameters[3].Value = model.UserLevel; parameters[4].Value = model.StreetId; parameters[5].Value = model.CommunityId; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj != null) { iExecute = Convert.ToInt32(obj); } } catch (Exception e) { Log4Net.LogWrite("err", "SysAccessData.SysManage.UserManage\\DacUserInfo\\Add" + e.Message); } return iExecute; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(UserInfoEntity model) { bool iExecute = false; try { StringBuilder strSql = new StringBuilder(); strSql.Append("update Sys_User set "); strSql.Append("UserName=@UserName,"); strSql.Append("UserPwd=@UserPwd,"); strSql.Append("UserNickName=@UserNickName,"); strSql.Append("UserLevel=@UserLevel,"); strSql.Append("StreetId=@StreetId,"); strSql.Append("CommunityId=@CommunityId"); strSql.Append(" where Id=@UserId"); SqlParameter[] parameters = { new SqlParameter("@UserName", SqlDbType.NVarChar,30), new SqlParameter("@UserPwd", SqlDbType.NVarChar,100), new SqlParameter("@UserNickName", SqlDbType.NVarChar,30), new SqlParameter("@UserLevel", SqlDbType.Int), new SqlParameter("@StreetId", SqlDbType.Int), new SqlParameter("@CommunityId", SqlDbType.Int), new SqlParameter("@UserId", SqlDbType.Int)}; parameters[0].Value = model.UserName; parameters[1].Value = model.UserPwd; parameters[2].Value = model.UserNickName; parameters[3].Value = model.UserLevel; parameters[4].Value = model.StreetId; parameters[5].Value = model.CommunityId; parameters[6].Value = model.UserId; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { iExecute = true; } } catch (Exception e) { Log4Net.LogWrite("err", "SysAccessData.SysManage.UserManage\\DacUserInfo\\Update" + e.Message); } return iExecute; }
/// <summary> /// 得到一个对象实体 /// </summary> public UserInfoEntity GetModel(int UserId) { UserInfoEntity model = null; try { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 A.Id as UserId,UserName,UserPwd,UserNickName,UserLevel,StreetId,CommunityId,RoleId from Sys_User as A inner join Sys_UserRole B"); strSql.Append(" on A.Id=B.UserId"); strSql.Append(" where A.Id=@UserId"); SqlParameter[] parameters = { new SqlParameter("@UserId", SqlDbType.Int,4) }; parameters[0].Value = UserId; model = new UserInfoEntity(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["UserId"] != null && ds.Tables[0].Rows[0]["UserId"].ToString() != "") { model.UserId = int.Parse(ds.Tables[0].Rows[0]["UserId"].ToString()); } if (ds.Tables[0].Rows[0]["UserName"] != null && ds.Tables[0].Rows[0]["UserName"].ToString() != "") { model.UserName = ds.Tables[0].Rows[0]["UserName"].ToString(); } if (ds.Tables[0].Rows[0]["UserPwd"] != null && ds.Tables[0].Rows[0]["UserPwd"].ToString() != "") { model.UserPwd = ds.Tables[0].Rows[0]["UserPwd"].ToString(); } if (ds.Tables[0].Rows[0]["UserNickName"] != null && ds.Tables[0].Rows[0]["UserNickName"].ToString() != "") { model.UserNickName = ds.Tables[0].Rows[0]["UserNickName"].ToString(); } if (ds.Tables[0].Rows[0]["UserLevel"] != null && ds.Tables[0].Rows[0]["UserLevel"].ToString() != "") { model.UserLevel = int.Parse(ds.Tables[0].Rows[0]["UserLevel"].ToString()); } if (ds.Tables[0].Rows[0]["StreetId"] != null && ds.Tables[0].Rows[0]["StreetId"].ToString() != "") { model.StreetId = int.Parse(ds.Tables[0].Rows[0]["StreetId"].ToString()); } if (ds.Tables[0].Rows[0]["CommunityId"] != null && ds.Tables[0].Rows[0]["CommunityId"].ToString() != "") { model.CommunityId = int.Parse(ds.Tables[0].Rows[0]["CommunityId"].ToString()); } if (ds.Tables[0].Rows[0]["RoleId"] != null && ds.Tables[0].Rows[0]["RoleId"].ToString() != "") { model.UserRole = int.Parse(ds.Tables[0].Rows[0]["RoleId"].ToString()); } } } catch (Exception e) { Log4Net.LogWrite("err", "SysAccessData.SysManage.UserManage\\DacUserInfo\\GetModel" + e.Message); } return model; }