/// <summary> /// 更新用户 /// </summary> /// <returns></returns> public string updateUsers() { string s = string.Empty; int roleId = helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId); int menuId = helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"]); #region 密码加密 string pwd = helpcommon.PasswordHelp.encrypt(Request.Form["userPwd"]); pwd = helpcommon.PasswordHelp.encrypt(pwd); #endregion var Id = helpcommon.ParmPerportys.GetNumParms(Request.Form["Id"]); var personaId = helpcommon.ParmPerportys.GetNumParms(Request.Form["personaId"]); var userName = Request.Form["userName"]; //var userPwd = Request.Form["userPwd"];//密码 var userPwd = pwd;//密码 var userRealName = Request.Form["userRealName"]; var userSex = helpcommon.ParmPerportys.GetNumParms(Request.Form["userSex"]); var UserPhone = Request.Form["UserPhone"]; var UserAddress = Request.Form["UserAddress"]; var UserEmail = Request.Form["UserEmail"]; var userIndex = helpcommon.ParmPerportys.GetNumParms(Request.Form["userIndex"]); var UserManage = helpcommon.ParmPerportys.GetNumParms(Request.Form["UserManage"]); //var UserId = helpcommon.ParmPerportys.GetNumParms(Request.Form["UserId"]); var Def1 = Request.Form["Def1"]; var Def2 = Request.Form["Def2"]; var Def3 = Request.Form["Def3"]; var Def4 = Request.Form["Def4"]; var Def5 = Request.Form["Def5"]; int UserId = userInfo.User.Id; PublicHelpController ph = new PublicHelpController(); bll.usersbll usersBll = new bll.usersbll(); DataTable mytable = usersBll.getDataEdit(Id); string[] ssName = usersBll.getDataName("users"); string[] ss = ph.getFiledPermisson(roleId, menuId, funName.updateName); IDataParameter[] ipara = new IDataParameter[] { new SqlParameter("id", SqlDbType.Int, 4), new SqlParameter("personaId", SqlDbType.Int, 4), new SqlParameter("usersName", SqlDbType.NVarChar, 20), new SqlParameter("usersPwd", SqlDbType.NVarChar, 100), new SqlParameter("usersRealName", SqlDbType.NVarChar, 20), new SqlParameter("usersSex", SqlDbType.Int, 4), new SqlParameter("usersPhone", SqlDbType.NVarChar, 20), new SqlParameter("usersAddress", SqlDbType.NVarChar, 200), new SqlParameter("usersEmail", SqlDbType.NVarChar, 20), new SqlParameter("usersIndex", SqlDbType.Int, 4), new SqlParameter("usersManage", SqlDbType.Int, 4), new SqlParameter("userId", SqlDbType.Int, 4), new SqlParameter("Def1", SqlDbType.NVarChar, 50), new SqlParameter("Def2", SqlDbType.NVarChar, 50), new SqlParameter("Def3", SqlDbType.NVarChar, 50), new SqlParameter("Def4", SqlDbType.NVarChar, 50), new SqlParameter("Def5", SqlDbType.NVarChar, 50) }; for (int i = 0; i < ssName.Length; i++) { if (ss.Contains(ssName[i])) { if (ssName[i] == "Id") { ipara[i].Value = Id; } if (ssName[i] == "personaId") { ipara[i].Value = personaId; } if (ssName[i] == "userName") { ipara[i].Value = userName; } if (ssName[i] == "userPwd") { ipara[i].Value = userPwd; } if (ssName[i] == "userRealName") { ipara[i].Value = userRealName; } if (ssName[i] == "userSex") { ipara[i].Value = userSex; } if (ssName[i] == "UserPhone") { ipara[i].Value = UserPhone; } if (ssName[i] == "UserAddress") { ipara[i].Value = UserAddress; } if (ssName[i] == "UserEmail") { ipara[i].Value = UserEmail; } if (ssName[i] == "userIndex") { ipara[i].Value = userIndex; } if (ssName[i] == "UserManage") { ipara[i].Value = UserManage; } if (ssName[i] == "UserId") { ipara[i].Value = UserId; } if (ssName[i] == "Def1") { ipara[i].Value = Def1; } if (ssName[i] == "Def2") { ipara[i].Value = Def2; } if (ssName[i] == "Def3") { ipara[i].Value = Def3; } if (ssName[i] == "Def4") { ipara[i].Value = Def4; } if (ssName[i] == "Def5") { ipara[i].Value = Def5; } } else { ipara[i].Value = mytable.Rows[0][mytable.Columns[i].ColumnName].ToString(); } } s = usersBll.Update(ipara, "updateUsers"); usersBll = null; return(s); }
/// <summary> /// 编辑用户 /// </summary> /// <returns></returns> public string editUsers() { StringBuilder s = new StringBuilder(); List <model.users> list = new List <model.users>(); int roleId = helpcommon.ParmPerportys.GetNumParms(userInfo.User.personaId); int id = helpcommon.ParmPerportys.GetNumParms(Request.Form["id"]); int menuId = helpcommon.ParmPerportys.GetNumParms(Request.Form["menuId"]); bll.usersbll usersBll = new bll.usersbll(); DataTable dt = usersBll.getDataEdit(id); string[] ssName = usersBll.getDataName("users"); PublicHelpController ph = new PublicHelpController(); string[] ss = ph.getFiledPermisson(roleId, menuId, funName.updateName); s.Append("<div style='float:left'>"); for (int i = 0; i < dt.Rows.Count; i++) { for (int j = 0; j < ssName.Length; j++) { if (ss.Contains(ssName[j])) { s.Append("<div style='width:250px;float:left;'>"); if (ssName[j] == "Id") { s.Append("<span style='float:left;text-align:right;width: 80px;'>编号:</span>"); } if (ssName[j] == "personaId") { s.Append("<span style='float:left;text-align:right;width: 80px;'>角色:</span>"); } if (ssName[j] == "userName") { s.Append("<span style='float:left;text-align:right;width: 80px;'>用户名:</span>"); } if (ssName[j] == "userPwd") { s.Append("<span style='float:left;text-align:right;width: 80px;'>密码:</span>"); } if (ssName[j] == "userRealName") { s.Append("<span style='float:left;text-align:right;width: 80px;'>姓名:</span>"); } if (ssName[j] == "userSex") { s.Append("<span style='float:left;text-align:right;width: 80px;'>性别:</span>"); } if (ssName[j] == "UserPhone") { s.Append("<span style='float:left;text-align:right;width: 80px;'>电话:</span>"); } if (ssName[j] == "UserAddress") { s.Append("<span style='float:left;text-align:right;width: 80px;'>地址:</span>"); } if (ssName[j] == "UserEmail") { s.Append("<span style='float:left;text-align:right;width: 80px;'>邮箱:</span>"); } if (ssName[j] == "userIndex") { s.Append("<span style='float:left;text-align:right;width: 80px;'>排序:</span>"); } if (ssName[j] == "UserManage") { s.Append("<span style='float:left;text-align:right;width: 80px;'>管理:</span>"); } if (ssName[j] == "UserId") { s.Append("<span style='float:left;text-align:right;width: 80px;'>操作人:</span>"); } if (ssName[j] == "Def1") { s.Append("<span style='float:left;text-align:right;width: 80px;'>默认1:</span>"); } if (ssName[j] == "Def2") { s.Append("<span style='float:left;text-align:right;width: 80px;'>默认2:</span>"); } if (ssName[j] == "Def3") { s.Append("<span style='float:left;text-align:right;width: 80px;'>默认3:</span>"); } if (ssName[j] == "Def4") { s.Append("<span style='float:left;text-align:right;width: 80px;'>默认4:</span>"); } if (ssName[j] == "Def5") { s.Append("<span style='float:left;text-align:right;width: 80px;'>默认5:</span>"); } if (ssName[j] == "userSex") { #region 性别 s.Append("<span style='width:135px;display:-moz-inline-box; display:inline-block;'>"); if (dt.Rows[i][ss[j]].ToString() == "0") { s.Append("<input style='width:18px;' id='usersSex' name='radio1' type='radio' value='0' checked='checked' />男"); s.Append("<input style='width:18px;' id='usersSex1' name='radio1' type='radio' value='1' />女"); } else { s.Append("<input style='width:18px;' id='usersSex' name='radio1' type='radio' value='0' />男"); s.Append("<input style='width:18px;' id='usersSex1' name='radio1' type='radio' value='1' checked='checked' />女"); } s.Append("</span>"); #endregion } else if (ssName[j] == "personaId") { #region 角色 RoleHelperController RH = new RoleHelperController(); s.Append("<select id='usersRoleEdit' title='" + dt.Rows[i][ss[j]].ToString() + "'>" + RH.getRoleData() + "</select>"); #endregion } else if (ssName[j] == "userPwd") { #region 密码 s.Append("<input type='password' value='" + dt.Rows[i][ss[j]] + "' id='" + ssName[j] + "' />"); #endregion } else { s.Append("<input type='text' value='" + dt.Rows[i][ss[j]] + "' id='" + ssName[j] + "' />"); } s.Append("</div>"); } } } shopbll sbl = new shopbll(); DataTable dtShop = sbl.GetAllShop(); string[] dtPerssionshop = usersBll.GetShopAllocation(id.ToString()); s.Append("<div style='width:450px;margin:auto'>"); for (int i = 0; i < dtShop.Rows.Count; i++) { if (dtPerssionshop.Contains(dtShop.Rows[i]["Id"].ToString())) { s.Append("<label style='width: 150px;float:left;text-align:left'><input class='Check' style='width:20px;' type='checkbox' checked='checked' shopid='" + dtShop.Rows[i]["Id"] + "' />" + dtShop.Rows[i]["ShopName"] + "</label>"); } else { s.Append("<label style='width: 150px;float:left;text-align:left'><input class='Check' style='width:20px;' type='checkbox' shopid='" + dtShop.Rows[i]["Id"] + "' />" + dtShop.Rows[i]["ShopName"] + "</label>"); } } s.Append("</div>"); s.Append("</div>"); s.Append("<div><button id='btnSave' value='保存' onclick='userSave()'>保存</button></div>"); usersBll = null; return(s.ToString()); }