/// <summary> /// 获得长期未登录mq的用户信息 /// </summary> /// <param name="days">未登录的天数</param> /// <param name="cityList">要查找的城市ID列表,若为null,则表示查找全国城市</param> /// <returns></returns> public virtual IList <Model.CompanyStructure.CompanyUserBase> GetLongOffLineList(int days, params int[] cityList) { IList <Model.CompanyStructure.CompanyUserBase> list = new List <Model.CompanyStructure.CompanyUserBase>(); string SQL = SQL_SELECT_LongOffLine; StringBuilder strWhere = new StringBuilder(); if (cityList != null && cityList.Length > 0) { foreach (int cityId in cityList) { strWhere.AppendFormat("{0},", cityId); } } if (strWhere.Length > 0) { SQL = SQL.Replace("&#", string.Format(" AND CityId IN ({0})", strWhere.ToString().TrimEnd(",".ToCharArray()))); } else { SQL = SQL.Replace("&#", ""); } DbCommand dc = base.MQStore.GetSqlStringCommand(SQL); base.MQStore.AddInParameter(dc, "days", DbType.Int32, days); using (IDataReader rdr = DbHelper.ExecuteReader(dc, base.MQStore)) { while (rdr.Read()) { Model.CompanyStructure.CompanyUserBase model = new EyouSoft.Model.CompanyStructure.CompanyUserBase(); model.CompanyID = rdr.IsDBNull(rdr.GetOrdinal("CompanyID")) == true ? "" : rdr.GetString(rdr.GetOrdinal("CompanyID")); model.ContactInfo.Email = rdr.IsDBNull(rdr.GetOrdinal("ContactEmail")) == true ? "" : rdr.GetString(rdr.GetOrdinal("ContactEmail")); model.ContactInfo.Fax = rdr.IsDBNull(rdr.GetOrdinal("ContactFax")) == true ? "" : rdr.GetString(rdr.GetOrdinal("ContactFax")); model.ContactInfo.Mobile = rdr.IsDBNull(rdr.GetOrdinal("ContactMobile")) == true ? "" : rdr.GetString(rdr.GetOrdinal("ContactMobile")); model.ContactInfo.ContactName = rdr.IsDBNull(rdr.GetOrdinal("ContactName")) == true ? "" : rdr.GetString(rdr.GetOrdinal("ContactName")); if (rdr.IsDBNull(rdr.GetOrdinal("ContactSex"))) { model.ContactInfo.ContactSex = EyouSoft.Model.CompanyStructure.Sex.未知; } else { model.ContactInfo.ContactSex = (EyouSoft.Model.CompanyStructure.Sex)Enum.Parse(typeof(EyouSoft.Model.CompanyStructure.Sex), rdr.GetString(rdr.GetOrdinal("ContactSex"))); } model.ContactInfo.Tel = rdr.IsDBNull(rdr.GetOrdinal("ContactTel")) == true ? "" : rdr.GetString(rdr.GetOrdinal("ContactTel")); model.ID = rdr.IsDBNull(rdr.GetOrdinal("ID")) == true ? "" : rdr.GetString(rdr.GetOrdinal("ID")); model.IsAdmin = rdr.GetString(rdr.GetOrdinal("IsAdmin")) == "1" ? true : false; model.ContactInfo.MQ = rdr.IsDBNull(rdr.GetOrdinal("MQ")) == true ? "" : rdr.GetString(rdr.GetOrdinal("MQ")); model.ContactInfo.MSN = rdr.IsDBNull(rdr.GetOrdinal("MSN")) == true ? "" : rdr.GetString(rdr.GetOrdinal("MSN")); //model.PassWordInfo.SetEncryptPassWord(rdr.IsDBNull(rdr.GetOrdinal("Password")) == true ? "" : rdr.GetString(rdr.GetOrdinal("Password")), rdr.IsDBNull(rdr.GetOrdinal("EncryptPassword")) == true ? "" : rdr.GetString(rdr.GetOrdinal("EncryptPassword")), rdr.IsDBNull(rdr.GetOrdinal("MD5Password")) == true ? "" : rdr.GetString(rdr.GetOrdinal("MD5Password"))); model.ContactInfo.QQ = rdr.IsDBNull(rdr.GetOrdinal("QQ")) == true ? "" : rdr.GetString(rdr.GetOrdinal("QQ")); model.UserName = rdr.IsDBNull(rdr.GetOrdinal("UserName")) == true ? "" : rdr.GetString(rdr.GetOrdinal("UserName")); list.Add(model); } } return(list); }
/// <summary> /// 修改个人设置信息(不修改密码,角色,部门) /// </summary> /// <param name="model">帐号信息实体</param> /// <returns></returns> public bool UpdatePersonal(EyouSoft.Model.CompanyStructure.CompanyUserBase model) { bool isTrue = false; //if (model == null || string.IsNullOrEmpty(model.ContactInfo.Email)) if (model == null) //不验证email是否为空(企业名片中老数据中是无email的) { return(isTrue); } model.ContactInfo.Email = model.ContactInfo.Email.Trim(); //去除email空格 isTrue = idal.UpdatePersonal(model); #region 步修改其他平台用户信息 zwc 2011-04-07 if (isTrue) { this.SyncUpdateUserInfo(model.ID); } #endregion return(isTrue); }