protected void save() { var model = new Eyousoft_yhq.Model.User(); Eyousoft_yhq.BLL.Member bll = new Eyousoft_yhq.BLL.Member(); model.ContactSex = (sexType)Utils.GetInt(Utils.GetFormValue(ddl_sex.UniqueID)); model.UserName = Utils.GetFormValue("userName"); model.UserPwd = Utils.GetFormValue("userPwd"); model.ContactName = Utils.GetFormValue("contactName"); model.PollCode = Utils.GetFormValue("PollCode"); model.YuE = 0M; model.IssueTime = DateTime.Now; string retUrl = Utils.GetFormValue("rurl"); bool result = bll.Add(model); if (result) { if (!string.IsNullOrEmpty(retUrl)) { Response.Redirect(retUrl); } EyouSoft.Common.Page.HuiyuanPage.Logout(); Response.Redirect("/AppPage/weixin/Login.aspx"); } }
protected void pageSave(string doType) { string id = Utils.GetQueryStringValue("id"); var model = new Eyousoft_yhq.Model.User(); model.UserName = Utils.GetFormValue(userName.UniqueID); model.ContactSex = (sexType)Utils.GetInt(Utils.GetFormValue(ddl_sex.UniqueID)); model.UserPwd = Utils.GetFormValue(userPwd.UniqueID); model.ContactName = Utils.GetFormValue(ContactName.UniqueID); model.Remark = Utils.GetFormValue(remark.UniqueID); model.IssueTime = DateTime.Now; model.CommissonScale = Utils.GetDecimal(Utils.GetFormValue(fydecimal.UniqueID)); model.PromotionCode = Utils.GetFormValue(userPromotionCode.UniqueID); model.YuE = Utils.GetDecimal(Utils.GetFormValue(zhYuE.UniqueID)); model.IsZZ = Utils.GetFormValue(chk_zf.UniqueID) == "1" ? true : false; model.MemberOption = (MemberOption)Utils.GetInt(Utils.GetFormValue("MemberOption")); model.ProviceId = Utils.GetInt(Utils.GetFormValue("MyProvice")); model.CityId = Utils.GetInt(Utils.GetFormValue("MyCity")); model.AreaId = Utils.GetInt(Utils.GetFormValue("MyArea")); model.StreetId = Utils.GetInt(Utils.GetFormValue("MyStreet")); if (model.CommissonScale == 0 && string.IsNullOrEmpty(model.PromotionCode)) { model.IsAgent = false; } else { model.IsAgent = true; } #region 提交保存 bool result = false; string msg = ""; Response.Clear(); Eyousoft_yhq.BLL.Member BLL = new Eyousoft_yhq.BLL.Member(); //if (doType == "add") //{ // result = BLL.Add(model); // msg = result ? "添加成功!" : "添加失败!"; // Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg)); //} //else //{ model.UserID = id; result = BLL.Update(model); msg = result ? "修改成功!" : "修改失败!"; Response.Write(UtilsCommons.AjaxReturnJson(result ? "1" : "0", msg)); //} Response.End(); #endregion }
protected void save() { var model = new Eyousoft_yhq.Model.User(); Eyousoft_yhq.BLL.Member bll = new Eyousoft_yhq.BLL.Member(); model.ContactSex = (sexType)Utils.GetInt(Utils.GetFormValue(ddl_sex.UniqueID)); model.UserName = Utils.GetFormValue("userName"); model.UserPwd = Utils.GetFormValue("userPwd"); model.ContactName = Utils.GetFormValue("contactName"); model.PollCode = Utils.GetFormValue("PollCode"); model.YuE = 0M; model.IssueTime = DateTime.Now; bool result = bll.Add(model); if (result) { EyouSoft.Model.SSOStructure.MUserInfo userInfo = new Eyousoft_yhq.BLL.MemberLogin().isLogin(model.UserName, model.UserPwd); Response.Redirect("/AppPage/Default.aspx"); } }
protected void save() { Eyousoft_yhq.Model.User model = new Eyousoft_yhq.Model.User(); model.ContactName = Utils.GetFormValue(contactName.UniqueID); model.ContactSex = (sexType)Utils.GetInt(Utils.GetFormValue(ddl_sex.UniqueID)); ; model.UserPwd = Utils.GetFormValue(userPwd.UniqueID); model.UserID = userinfo.UserID; model.Remark = userinfo.Remark; bool result = new Eyousoft_yhq.BLL.Member().Update(model); if (result) { Utils.ShowMsg("修改成功!"); } else { Utils.ShowMsg("修改失败!"); } }
protected void save() { Eyousoft_yhq.Model.User model = new Eyousoft_yhq.Model.User(); model.ContactName = Utils.GetFormValue(contactName.UniqueID); model.ContactSex = (sexType)Utils.GetInt(Utils.GetFormValue(ddl_sex.UniqueID));; model.UserPwd = Utils.GetFormValue(userPwd.UniqueID); model.UserID = userinfo.UserID; model.Remark = userinfo.Remark; bool result = new Eyousoft_yhq.BLL.Member().Update(model); if (result) { Utils.ShowMsg("修改成功!"); } else { Utils.ShowMsg("修改失败!"); } }
/// <summary> /// 添加用户 /// </summary> protected string save() { var model = new Eyousoft_yhq.Model.User(); Eyousoft_yhq.BLL.Member bll = new Eyousoft_yhq.BLL.Member(); model.ContactSex = (sexType)Utils.GetInt(Utils.GetFormValue("userSex")); model.UserName = Utils.GetFormValue("userName"); model.UserPwd = Utils.GetFormValue("userPwd"); model.ContactName = Utils.GetFormValue("contactName"); model.PollCode = Utils.GetFormValue("userPollCode"); model.IsAgent = false; model.IssueTime = DateTime.Now; //string ViaCode = Utils.GetFormValue("userViaCode"); model.YuE = 0M; string msg = string.Empty; List <string[]> list = new List <string[]>(); //list = Session[model.UserName] as List<string[]>; //if (list != null) //{ // for (int i = 0; i < list.Count; i++) // { // if (ViaCode == list[i][1] && DateTime.Compare(Convert.ToDateTime(list[i][2]).AddMinutes(5), DateTime.Now) > 0) // { // msg = list[i][1]; // } // } //} //if (string.IsNullOrEmpty(msg)) //{ // return UtilsCommons.AjaxReturnJson("0", "请填写正确的验证码!"); //} bool result = bll.Add(model); Session.Remove(model.UserName); if (result) { Session.Remove(model.UserName); EyouSoft.Model.SSOStructure.MUserInfo userInfo = new Eyousoft_yhq.BLL.MemberLogin().isLogin(model.UserName, model.UserPwd); } return(UtilsCommons.AjaxReturnJson("1", string.Format("注册{0}", result ? "成功,正在跳转页面,请稍后 !" : "失败!请稍后再试"))); }
/// <summary> /// 添加用户 /// </summary> protected string save() { var model = new Eyousoft_yhq.Model.User(); Eyousoft_yhq.BLL.Member bll = new Eyousoft_yhq.BLL.Member(); model.ContactSex = (sexType)Utils.GetInt(Utils.GetFormValue("userSex")); model.UserName = Utils.GetFormValue("userName"); model.UserPwd = Utils.GetFormValue("userPwd"); model.ContactName = Utils.GetFormValue("contactName"); model.PollCode = Utils.GetFormValue("userPollCode"); model.IsAgent = false; model.IssueTime = DateTime.Now; //string ViaCode = Utils.GetFormValue("userViaCode"); model.YuE = 0M; string msg = string.Empty; List<string[]> list = new List<string[]>(); //list = Session[model.UserName] as List<string[]>; //if (list != null) //{ // for (int i = 0; i < list.Count; i++) // { // if (ViaCode == list[i][1] && DateTime.Compare(Convert.ToDateTime(list[i][2]).AddMinutes(5), DateTime.Now) > 0) // { // msg = list[i][1]; // } // } //} //if (string.IsNullOrEmpty(msg)) //{ // return UtilsCommons.AjaxReturnJson("0", "请填写正确的验证码!"); //} bool result = bll.Add(model); Session.Remove(model.UserName); if (result) { Session.Remove(model.UserName); EyouSoft.Model.SSOStructure.MUserInfo userInfo = new Eyousoft_yhq.BLL.MemberLogin().isLogin(model.UserName, model.UserPwd); } return UtilsCommons.AjaxReturnJson("1", string.Format("注册{0}", result ? "成功,正在跳转页面,请稍后 !" : "失败!请稍后再试")); }
protected void save() { var model = new Eyousoft_yhq.Model.User(); Eyousoft_yhq.BLL.Member bll = new Eyousoft_yhq.BLL.Member(); model.ContactSex = (sexType)Utils.GetInt(Utils.GetFormValue(ddl_sex.UniqueID)); model.UserName = Utils.GetFormValue("userName"); model.UserPwd = Utils.GetFormValue("userPwd"); model.ContactName = Utils.GetFormValue("contactName"); model.PollCode = Utils.GetFormValue("PollCode"); model.YuE = 0M; model.IssueTime = DateTime.Now; string retUrl = Utils.GetFormValue("rurl"); bool result = bll.Add(model); if (result) { if (!string.IsNullOrEmpty(retUrl)) Response.Redirect(retUrl); EyouSoft.Common.Page.HuiyuanPage.Logout(); Response.Redirect("/AppPage/weixin/Login.aspx"); } }
protected string UpdateUserInfo() { string Phone = Utils.GetFormValue(txtPhone.UniqueID); string Name = Utils.GetFormValue(txtName.UniqueID); string Pwd = Utils.GetFormValue(txtPassOld.UniqueID); string NewPwd = Utils.GetFormValue(txtPassNew.UniqueID); string SurePwd = Utils.GetFormValue(txtPassSure.UniqueID); string sex = Utils.GetFormValue(dl_sex.UniqueID); Eyousoft_yhq.Model.User UserInfo = new Eyousoft_yhq.Model.User(); UserInfo = Mem.GetModel(HuiYuanInfo.UserID); UserInfo.ProviceId = Utils.GetInt(Utils.GetFormValue("MyProvice")); UserInfo.CityId = Utils.GetInt(Utils.GetFormValue("MyCity")); UserInfo.AreaId = Utils.GetInt(Utils.GetFormValue("MyArea")); UserInfo.StreetId = Utils.GetInt(Utils.GetFormValue("MyStreet")); UserInfo.MemberOption = (MemberOption)Utils.GetInt(Utils.GetFormValue("MemberOption")); #region 验证码 string ViaCode = Utils.GetFormValue("userViaCode"); List <string[]> list = new List <string[]>(); list = Session[Phone] as List <string[]>; string msg = string.Empty; if (list != null) { for (int i = 0; i < list.Count; i++) { if (!string.IsNullOrEmpty(ViaCode) && ViaCode == list[i][1] && DateTime.Compare(Convert.ToDateTime(list[i][2]).AddMinutes(5), DateTime.Now) > 0) { msg = list[i][1]; UserInfo.valiUser = true; } } } if (!string.IsNullOrEmpty(ViaCode) && !UserInfo.valiUser) { return(UtilsCommons.AjaxReturnJson("0", "请填写正确的验证码!")); } #endregion if (!string.IsNullOrEmpty(Pwd)) { if (Pwd != UserInfo.UserPwd) { return(EyouSoft.Common.UtilsCommons.AjaxReturnJson("0", "原始密码不正确")); } else if (NewPwd != SurePwd) { return(EyouSoft.Common.UtilsCommons.AjaxReturnJson("0", "两次密码输入不一致")); } } if (!string.IsNullOrEmpty(SurePwd) && !string.IsNullOrEmpty(Pwd)) { UserInfo.UserPwd = SurePwd; } if (!string.IsNullOrEmpty(sex)) { UserInfo.ContactSex = (sexType)Utils.GetInt(sex); } if (!string.IsNullOrEmpty(Name)) { UserInfo.ContactName = Name; } if (Mem.Update(UserInfo)) { return(EyouSoft.Common.UtilsCommons.AjaxReturnJson("1", "修改成功")); } else { return(EyouSoft.Common.UtilsCommons.AjaxReturnJson("0", "修改失败,查看原始密码是否正确")); } }
/// <summary> /// 获取实体 /// </summary> /// <param name="UserID">用户编号</param> /// <returns></returns> public Eyousoft_yhq.Model.User GetModelByName(string UserName) { Eyousoft_yhq.Model.User model = null; StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT [UserID],[UserName],[UserPwd],[ContactName],[ContactSex],[Remark],[IssueTime],[CommissonScale],[PollCode],[PromotionCode],[IsAgent],[valiUser],[YuE],[IsZZ],MemberOption,ProviceId,CityId,AreaId,StreetId "); strSql.Append(" FROM tbl_Member "); strSql.Append(" where UserName=@UserName "); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "UserName", System.Data.DbType.AnsiStringFixedLength, UserName); using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db)) { while (dr.Read()) { model = new Eyousoft_yhq.Model.User(); model.UserID = dr.IsDBNull(dr.GetOrdinal("UserID")) ? "" : dr.GetString(dr.GetOrdinal("UserID")); model.UserName = dr.IsDBNull(dr.GetOrdinal("UserName")) ? "" : dr.GetString(dr.GetOrdinal("UserName")); model.UserPwd = dr.IsDBNull(dr.GetOrdinal("UserPwd")) ? "" : dr.GetString(dr.GetOrdinal("UserPwd")); model.ContactName = dr.IsDBNull(dr.GetOrdinal("ContactName")) ? "" : dr.GetString(dr.GetOrdinal("ContactName")); model.ContactSex = (sexType)dr.GetByte(dr.GetOrdinal("ContactSex")); model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")); model.CommissonScale = dr.IsDBNull(dr.GetOrdinal("CommissonScale")) ? 0 : dr.GetDecimal(dr.GetOrdinal("CommissonScale")); model.PollCode = dr.IsDBNull(dr.GetOrdinal("PollCode")) ? "" : dr.GetString(dr.GetOrdinal("PollCode")); model.PromotionCode = dr.IsDBNull(dr.GetOrdinal("PromotionCode")) ? "" : dr.GetString(dr.GetOrdinal("PromotionCode")); model.IsAgent = dr.IsDBNull(dr.GetOrdinal("IsAgent")) ? false : GetBoolean(dr.GetString(dr.GetOrdinal("IsAgent"))); model.valiUser = GetBoolean(dr.GetString(dr.GetOrdinal("valiUser"))); model.YuE = dr.GetDecimal(dr.GetOrdinal("YuE")); model.IsZZ = GetBoolean(dr.GetString(dr.GetOrdinal("IsZZ"))); if (!dr.IsDBNull(dr.GetOrdinal("IssueTime"))) { model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); } model.MemberOption = (MemberOption)dr.GetInt32(dr.GetOrdinal("MemberOption")); model.ProviceId = dr.GetInt32(dr.GetOrdinal("ProviceId")); model.CityId = dr.GetInt32(dr.GetOrdinal("CityId")); model.AreaId = dr.GetInt32(dr.GetOrdinal("AreaId")); model.StreetId = dr.GetInt32(dr.GetOrdinal("StreetId")); } } return model; }
/// <summary> /// 获取实体 /// </summary> /// <param name="UserID">用户编号</param> /// <returns></returns> public Eyousoft_yhq.Model.User GetModel(string UserID) { Eyousoft_yhq.Model.User model = null; StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * "); strSql.Append(" FROM tbl_Member "); strSql.Append(" where UserID=@UserID "); DbCommand cmd = this._db.GetSqlStringCommand(strSql.ToString()); this._db.AddInParameter(cmd, "UserID", System.Data.DbType.AnsiStringFixedLength, UserID); using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db)) { while (dr.Read()) { model = new Eyousoft_yhq.Model.User(); model.UserID = dr.IsDBNull(dr.GetOrdinal("UserID")) ? "" : dr.GetString(dr.GetOrdinal("UserID")); model.UserName = dr.IsDBNull(dr.GetOrdinal("UserName")) ? "" : dr.GetString(dr.GetOrdinal("UserName")); model.UserPwd = dr.IsDBNull(dr.GetOrdinal("UserPwd")) ? "" : dr.GetString(dr.GetOrdinal("UserPwd")); model.ContactName = dr.IsDBNull(dr.GetOrdinal("ContactName")) ? "" : dr.GetString(dr.GetOrdinal("ContactName")); model.ContactSex = (sexType)dr.GetByte(dr.GetOrdinal("ContactSex")); model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")); model.CommissonScale = dr.IsDBNull(dr.GetOrdinal("CommissonScale")) ? 0 : dr.GetDecimal(dr.GetOrdinal("CommissonScale")); model.PollCode = dr.IsDBNull(dr.GetOrdinal("PollCode")) ? "" : dr.GetString(dr.GetOrdinal("PollCode")); model.PromotionCode = dr.IsDBNull(dr.GetOrdinal("PromotionCode")) ? "" : dr.GetString(dr.GetOrdinal("PromotionCode")); model.IsAgent = dr.IsDBNull(dr.GetOrdinal("IsAgent")) ? false : GetBoolean(dr.GetString(dr.GetOrdinal("IsAgent"))); model.valiUser = GetBoolean(dr.GetString(dr.GetOrdinal("valiUser"))); model.YuE = dr.GetDecimal(dr.GetOrdinal("YuE")); model.IsZZ = GetBoolean(dr.GetString(dr.GetOrdinal("IsZZ"))); if (!dr.IsDBNull(dr.GetOrdinal("IssueTime"))) { model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); } model.WeiXinHao = dr["WeiXinHao"].ToString(); model.GongSiName = dr["GongSiName"].ToString(); model.ZhiWei = dr["ZhiWei"].ToString(); model.ShouJi = dr["ShouJi"].ToString(); model.TuXiangFilepath = dr["TuXiangFilepath"].ToString(); model.QQ = dr["QQ"].ToString(); model.YouXiang = dr["YouXiang"].ToString(); model.DiZhi = dr["DiZhi"].ToString(); model.IsLvYouGuWen = dr["IsLvYouGuWen"].ToString() == "1"; model.LvYouGuWenRenZhengTime = dr.GetDateTime(dr.GetOrdinal("LvYouGuWenRenZhengTime")); model.ZanJiShu = dr.GetInt32(dr.GetOrdinal("ZanJiShu")); model.GuanZhuJiShu = dr.GetInt32(dr.GetOrdinal("GuanZhuJiShu")); model.LiuYanJiShu = dr.GetInt32(dr.GetOrdinal("LiuYanJiShu")); model.MingPianId = dr["MingPianId"].ToString(); model.MemberOption = (MemberOption)dr.GetInt32(dr.GetOrdinal("MemberOption")); model.ProviceId = dr.GetInt32(dr.GetOrdinal("ProviceId")); model.CityId = dr.GetInt32(dr.GetOrdinal("CityId")); model.AreaId = dr.GetInt32(dr.GetOrdinal("AreaId")); model.StreetId = dr.GetInt32(dr.GetOrdinal("StreetId")); } } return model; }
public IList<Eyousoft_yhq.Model.User> GetList(Eyousoft_yhq.Model.MSearchUser serModel) { IList<Eyousoft_yhq.Model.User> list = new List<Eyousoft_yhq.Model.User>(); StringBuilder query = new StringBuilder(); query.Append("select UserID,UserName,UserPwd,ContactName,ContactSex,Remark,IssueTime,CommissonScale,PollCode,PromotionCode,IsAgent,valiUser,YuE,MemberOption,ProviceId,CityId,AreaId,StreetId from tbl_Member where 1=1"); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.UserName)) { query.AppendFormat(" and UserName like '%{0}%' ", serModel.UserName); } if (!string.IsNullOrEmpty(serModel.ContactName)) { query.AppendFormat(" and ContactName like '%{0}%' ", serModel.ContactName); } } query.Append(" order by UserID DESC "); DbCommand cmd = this._db.GetSqlStringCommand(query.ToString()); using (IDataReader dr = DbHelper.ExecuteReader(cmd, this._db)) { while (dr.Read()) { Eyousoft_yhq.Model.User model = new Eyousoft_yhq.Model.User(); model.UserID = dr.IsDBNull(dr.GetOrdinal("UserID")) ? "" : dr.GetString(dr.GetOrdinal("UserID")); model.UserName = dr.IsDBNull(dr.GetOrdinal("UserName")) ? "" : dr.GetString(dr.GetOrdinal("UserName")); model.UserPwd = dr.IsDBNull(dr.GetOrdinal("UserPwd")) ? "" : dr.GetString(dr.GetOrdinal("UserPwd")); model.ContactName = dr.IsDBNull(dr.GetOrdinal("ContactName")) ? "" : dr.GetString(dr.GetOrdinal("ContactName")); model.ContactSex = (sexType)dr.GetByte(dr.GetOrdinal("ContactSex")); model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")); model.CommissonScale = dr.IsDBNull(dr.GetOrdinal("CommissonScale")) ? 0 : dr.GetDecimal(dr.GetOrdinal("CommissonScale")); model.PollCode = dr.IsDBNull(dr.GetOrdinal("PollCode")) ? "" : dr.GetString(dr.GetOrdinal("PollCode")); model.PromotionCode = dr.IsDBNull(dr.GetOrdinal("PromotionCode")) ? "" : dr.GetString(dr.GetOrdinal("PromotionCode")); model.IsAgent = dr.IsDBNull(dr.GetOrdinal("IsAgent")) ? false : GetBoolean(dr.GetString(dr.GetOrdinal("IsAgent"))); model.valiUser = GetBoolean(dr.GetString(dr.GetOrdinal("valiUser"))); model.YuE = dr.GetDecimal(dr.GetOrdinal("YuE")); if (!dr.IsDBNull(dr.GetOrdinal("IssueTime"))) { model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); } model.MemberOption = (MemberOption)dr.GetInt32(dr.GetOrdinal("MemberOption")); model.ProviceId = dr.GetInt32(dr.GetOrdinal("ProviceId")); model.CityId = dr.GetInt32(dr.GetOrdinal("CityId")); model.AreaId = dr.GetInt32(dr.GetOrdinal("AreaId")); model.StreetId = dr.GetInt32(dr.GetOrdinal("StreetId")); list.Add(model); } } return list; }
public IList<Eyousoft_yhq.Model.User> GetList(int PageSize, int PageIndex, ref int RecordCount, Eyousoft_yhq.Model.MSearchUser serModel, int isadmin) { IList<Eyousoft_yhq.Model.User> list = new List<Eyousoft_yhq.Model.User>(); string tableName = "tbl_Member"; string fileds = " *,(SELECT COUNT(1) FROM tbl_Order WHERE MemberID=tbl_Member.UserID and PayState='2' ) AS OrderCount "; string orderByString = "IssueTime desc"; StringBuilder query = new StringBuilder(); query.AppendFormat(" 1=1 ", isadmin); if (serModel != null) { if (!string.IsNullOrEmpty(serModel.UserName)) { query.AppendFormat(" and UserName like '%{0}%' ", serModel.UserName); } if (!string.IsNullOrEmpty(serModel.ContactName)) { query.AppendFormat(" and ContactName like '%{0}%' ", serModel.ContactName); } if (!string.IsNullOrEmpty(serModel.PromotionCode)) { query.AppendFormat(" and PollCode = '{0}' ", serModel.PromotionCode); } if (serModel.IsLvYouGuWen.HasValue) { query.AppendFormat(" AND IsLvYouGuWen='{0}' ", serModel.IsLvYouGuWen.Value ? "1" : "0"); if (serModel.IsLvYouGuWen.Value) { orderByString = "LvYouGuWenRenZhengTime DESC"; } } if (serModel.MemberOption.HasValue) { query.AppendFormat(" AND MemberOption='{0}' ", (int)serModel.MemberOption); } if (serModel.ProviceId != 0) { query.AppendFormat(" AND ProviceId='{0}' ", serModel.ProviceId); } if (serModel.CityId != 0) { query.AppendFormat(" AND CityId='{0}' ", serModel.CityId); } if (serModel.AreaId != 0) { query.AppendFormat(" AND AreaId='{0}' ", serModel.AreaId); } if (serModel.StreetId != 0) { query.AppendFormat(" AND StreetId='{0}' ", serModel.StreetId); } } using (IDataReader dr = DbHelper.ExecuteReader1(this._db, PageSize, PageIndex, ref RecordCount, tableName, fileds, query.ToString(), orderByString, null)) { while (dr.Read()) { Eyousoft_yhq.Model.User model = new Eyousoft_yhq.Model.User(); model.UserID = dr.IsDBNull(dr.GetOrdinal("UserID")) ? "" : dr.GetString(dr.GetOrdinal("UserID")); model.UserName = dr.IsDBNull(dr.GetOrdinal("UserName")) ? "" : dr.GetString(dr.GetOrdinal("UserName")); model.UserPwd = dr.IsDBNull(dr.GetOrdinal("UserPwd")) ? "" : dr.GetString(dr.GetOrdinal("UserPwd")); model.ContactName = dr.IsDBNull(dr.GetOrdinal("ContactName")) ? "" : dr.GetString(dr.GetOrdinal("ContactName")); model.ContactSex = (sexType)dr.GetByte(dr.GetOrdinal("ContactSex")); model.Remark = dr.IsDBNull(dr.GetOrdinal("Remark")) ? "" : dr.GetString(dr.GetOrdinal("Remark")); model.CommissonScale = dr.IsDBNull(dr.GetOrdinal("CommissonScale")) ? 0 : dr.GetDecimal(dr.GetOrdinal("CommissonScale")); model.OrderCount = dr.GetInt32(dr.GetOrdinal("OrderCount")); model.PollCode = dr.IsDBNull(dr.GetOrdinal("PollCode")) ? "" : dr.GetString(dr.GetOrdinal("PollCode")); model.PromotionCode = dr.IsDBNull(dr.GetOrdinal("PromotionCode")) ? "" : dr.GetString(dr.GetOrdinal("PromotionCode")); model.IsAgent = dr.IsDBNull(dr.GetOrdinal("IsAgent")) ? false : GetBoolean(dr.GetString(dr.GetOrdinal("IsAgent"))); model.valiUser = GetBoolean(dr.GetString(dr.GetOrdinal("valiUser"))); model.YuE = dr.GetDecimal(dr.GetOrdinal("YuE")); model.IsZZ = GetBoolean(dr.GetString(dr.GetOrdinal("IsZZ"))); if (!dr.IsDBNull(dr.GetOrdinal("IssueTime"))) { model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime")); } model.WeiXinHao = dr["WeiXinHao"].ToString(); model.GongSiName = dr["GongSiName"].ToString(); model.ZhiWei = dr["ZhiWei"].ToString(); model.ShouJi = dr["ShouJi"].ToString(); model.TuXiangFilepath = dr["TuXiangFilepath"].ToString(); model.QQ = dr["QQ"].ToString(); model.YouXiang = dr["YouXiang"].ToString(); model.DiZhi = dr["DiZhi"].ToString(); model.IsLvYouGuWen = dr["IsLvYouGuWen"].ToString() == "1"; model.LvYouGuWenRenZhengTime = dr.GetDateTime(dr.GetOrdinal("LvYouGuWenRenZhengTime")); model.ZanJiShu = dr.GetInt32(dr.GetOrdinal("ZanJiShu")); model.GuanZhuJiShu = dr.GetInt32(dr.GetOrdinal("GuanZhuJiShu")); model.LiuYanJiShu = dr.GetInt32(dr.GetOrdinal("LiuYanJiShu")); model.MingPianId = dr["MingPianId"].ToString(); model.MemberOption = (MemberOption)dr.GetInt32(dr.GetOrdinal("MemberOption")); model.ProviceId = dr.GetInt32(dr.GetOrdinal("ProviceId")); model.CityId = dr.GetInt32(dr.GetOrdinal("CityId")); model.AreaId = dr.GetInt32(dr.GetOrdinal("AreaId")); model.StreetId = dr.GetInt32(dr.GetOrdinal("StreetId")); list.Add(model); } } return list; }
protected string UpdateUserInfo() { string Phone = Utils.GetFormValue(txtPhone.UniqueID); string Name = Utils.GetFormValue(txtName.UniqueID); string Pwd = Utils.GetFormValue(txtPassOld.UniqueID); string NewPwd = Utils.GetFormValue(txtPassNew.UniqueID); string SurePwd = Utils.GetFormValue(txtPassSure.UniqueID); string sex = Utils.GetFormValue(dl_sex.UniqueID); Eyousoft_yhq.Model.User UserInfo = new Eyousoft_yhq.Model.User(); UserInfo = Mem.GetModel(HuiYuanInfo.UserID); UserInfo.ProviceId = Utils.GetInt(Utils.GetFormValue("MyProvice")); UserInfo.CityId = Utils.GetInt(Utils.GetFormValue("MyCity")); UserInfo.AreaId = Utils.GetInt(Utils.GetFormValue("MyArea")); UserInfo.StreetId = Utils.GetInt(Utils.GetFormValue("MyStreet")); UserInfo.MemberOption = (MemberOption)Utils.GetInt(Utils.GetFormValue("MemberOption")); #region 验证码 string ViaCode = Utils.GetFormValue("userViaCode"); List<string[]> list = new List<string[]>(); list = Session[Phone] as List<string[]>; string msg = string.Empty; if (list != null) { for (int i = 0; i < list.Count; i++) { if (!string.IsNullOrEmpty(ViaCode) && ViaCode == list[i][1] && DateTime.Compare(Convert.ToDateTime(list[i][2]).AddMinutes(5), DateTime.Now) > 0) { msg = list[i][1]; UserInfo.valiUser = true; } } } if (!string.IsNullOrEmpty(ViaCode) && !UserInfo.valiUser) { return UtilsCommons.AjaxReturnJson("0", "请填写正确的验证码!"); } #endregion if (!string.IsNullOrEmpty(Pwd)) { if (Pwd != UserInfo.UserPwd) { return EyouSoft.Common.UtilsCommons.AjaxReturnJson("0", "原始密码不正确"); } else if (NewPwd != SurePwd) return EyouSoft.Common.UtilsCommons.AjaxReturnJson("0", "两次密码输入不一致"); } if (!string.IsNullOrEmpty(SurePwd) && !string.IsNullOrEmpty(Pwd)) { UserInfo.UserPwd = SurePwd; } if (!string.IsNullOrEmpty(sex)) { UserInfo.ContactSex = (sexType)Utils.GetInt(sex); } if (!string.IsNullOrEmpty(Name)) { UserInfo.ContactName = Name; } if (Mem.Update(UserInfo)) { return EyouSoft.Common.UtilsCommons.AjaxReturnJson("1", "修改成功"); } else { return EyouSoft.Common.UtilsCommons.AjaxReturnJson("0", "修改失败,查看原始密码是否正确"); } }