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