public IList<Core.Business.User> GetAllUser()
{
IList<Core.Business.User> userlist = new List<Core.Business.User>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectUsersAll");
if (reader != null)
{
while (reader.Read() && !reader.IsClosed)
{
Core.Business.User user = new Core.Business.User();
if (!reader.IsDBNull(0)) user.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) user.UserID = reader.GetString(1);
if (!reader.IsDBNull(2)) user.PostRankID = reader.GetGuid(2);
if (!reader.IsDBNull(3)) user.EducationID = reader.GetGuid(3);
if (!reader.IsDBNull(4)) user.PicURL = reader.GetString(4);
if (!reader.IsDBNull(5)) user.Name = reader.GetString(5);
if (!reader.IsDBNull(6)) user.Password = reader.GetString(6);
if (!reader.IsDBNull(7)) user.Gender = reader.GetString(7);
if (!reader.IsDBNull(8)) user.BirthDate = reader.GetDateTime(8);
if (!reader.IsDBNull(9)) user.Address = reader.GetString(9);
if (!reader.IsDBNull(10)) user.Mailcode = reader.GetString(10);
if (!reader.IsDBNull(11)) user.Fax = reader.GetString(11);
if (!reader.IsDBNull(12)) user.Phone = reader.GetString(12);
if (!reader.IsDBNull(13)) user.MobilePhone = reader.GetString(13);
if (!reader.IsDBNull(14)) user.Email = reader.GetString(14);
if (!reader.IsDBNull(15)) user.Specialty = reader.GetString(15);
if (!reader.IsDBNull(16)) user.Resume = reader.GetString(16);
if (!reader.IsDBNull(17)) user.Remark = reader.GetString(17);
if (!reader.IsDBNull(18)) user.UnitID = reader.GetGuid(18);
if (!reader.IsDBNull(19)) user.UserType = reader.GetInt32(19);
if (!reader.IsDBNull(20)) user.Discourse = reader.GetString(20);
if (!reader.IsDBNull(21)) user.Acquire = reader.GetString(21);
if (!reader.IsDBNull(22)) user.RegDate = reader.GetDateTime(22);
if (!reader.IsDBNull(23)) user.LastActiveTime = reader.GetDateTime(23);
if (!reader.IsDBNull(24)) user.Status = reader.GetInt32(24);
if (!reader.IsDBNull(25)) user.Unit = reader.GetString(25);
if (!reader.IsDBNull(26)) user.Duty = reader.GetString(26);
if (!reader.IsDBNull(27)) user.FeildID = reader.GetGuid(27);
user.MarkOld();
userlist.Add(user);
}
reader.Close();
}
return userlist;
}
public IList<Core.Business.User> GetAllUser()
{
IList<Core.Business.User> userlist = new List<Core.Business.User>();
SqlServerUtility sql = new SqlServerUtility();
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectUsersAll");
if(reader != null)
{
while(reader.Read())
{
Core.Business.User user = new Core.Business.User();
if (!reader.IsDBNull(0)) user.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) user.UserId = reader.GetString(1);
if (!reader.IsDBNull(2)) user.Name = reader.GetString(2);
if (!reader.IsDBNull(3)) user.Password = reader.GetString(3);
if (!reader.IsDBNull(4)) user.Gender = reader.GetInt32(4);
if (!reader.IsDBNull(5)) user.Birthday = reader.GetDateTime(5);
if (!reader.IsDBNull(6)) user.UnitCode = reader.GetGuid(6);
if (!reader.IsDBNull(7)) user.Icon = reader.GetString(7);
if (!reader.IsDBNull(8)) user.Email = reader.GetString(8);
if (!reader.IsDBNull(9)) user.Phone = reader.GetString(9);
if (!reader.IsDBNull(10)) user.CellPhone = reader.GetString(10);
if (!reader.IsDBNull(11)) user.CredentialCardType = reader.GetInt32(11);
if (!reader.IsDBNull(12)) user.CardNo = reader.GetString(12);
if (!reader.IsDBNull(13)) user.Position = reader.GetString(13);
if (!reader.IsDBNull(14)) user.JXTLevel = reader.GetInt32(14);
if (!reader.IsDBNull(15)) user.DeveloperId = reader.GetGuid(15);
if (!reader.IsDBNull(16)) user.RegisterDate = reader.GetDateTime(16);
if (!reader.IsDBNull(17)) user.Status = reader.GetInt32(17);
if (!reader.IsDBNull(18)) user.Remark = reader.GetString(18);
user.MarkOld();
userlist.Add(user);
}
reader.Close();
}
return userlist;
}
public Core.Business.User Select(Guid id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Code", SqlDbType.UniqueIdentifier, id);
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectUser");
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.User user = new Core.Business.User();
if (!reader.IsDBNull(0)) user.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) user.UserId = reader.GetString(1);
if (!reader.IsDBNull(2)) user.Name = reader.GetString(2);
if (!reader.IsDBNull(3)) user.Password = reader.GetString(3);
if (!reader.IsDBNull(4)) user.Gender = reader.GetInt32(4);
if (!reader.IsDBNull(5)) user.Birthday = reader.GetDateTime(5);
if (!reader.IsDBNull(6)) user.UnitCode = reader.GetGuid(6);
if (!reader.IsDBNull(7)) user.Icon = reader.GetString(7);
if (!reader.IsDBNull(8)) user.Email = reader.GetString(8);
if (!reader.IsDBNull(9)) user.Phone = reader.GetString(9);
if (!reader.IsDBNull(10)) user.CellPhone = reader.GetString(10);
if (!reader.IsDBNull(11)) user.CredentialCardType = reader.GetInt32(11);
if (!reader.IsDBNull(12)) user.CardNo = reader.GetString(12);
if (!reader.IsDBNull(13)) user.Position = reader.GetString(13);
if (!reader.IsDBNull(14)) user.JXTLevel = reader.GetInt32(14);
if (!reader.IsDBNull(15)) user.DeveloperId = reader.GetGuid(15);
if (!reader.IsDBNull(16)) user.RegisterDate = reader.GetDateTime(16);
if (!reader.IsDBNull(17)) user.Status = reader.GetInt32(17);
if (!reader.IsDBNull(18)) user.Remark = reader.GetString(18);
reader.Close();
return user;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public Core.Business.User Select(Guid id)
{
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, id);
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectUser");
if (reader != null && !reader.IsClosed && reader.Read())
{
Core.Business.User user = new Core.Business.User();
if (!reader.IsDBNull(0)) user.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) user.UserID = reader.GetString(1);
if (!reader.IsDBNull(2)) user.PostRankID = reader.GetGuid(2);
if (!reader.IsDBNull(3)) user.EducationID = reader.GetGuid(3);
if (!reader.IsDBNull(4)) user.PicURL = reader.GetString(4);
if (!reader.IsDBNull(5)) user.Name = reader.GetString(5);
if (!reader.IsDBNull(6)) user.Password = reader.GetString(6);
if (!reader.IsDBNull(7)) user.Gender = reader.GetString(7);
if (!reader.IsDBNull(8)) user.BirthDate = reader.GetDateTime(8);
if (!reader.IsDBNull(9)) user.Address = reader.GetString(9);
if (!reader.IsDBNull(10)) user.Mailcode = reader.GetString(10);
if (!reader.IsDBNull(11)) user.Fax = reader.GetString(11);
if (!reader.IsDBNull(12)) user.Phone = reader.GetString(12);
if (!reader.IsDBNull(13)) user.MobilePhone = reader.GetString(13);
if (!reader.IsDBNull(14)) user.Email = reader.GetString(14);
if (!reader.IsDBNull(15)) user.Specialty = reader.GetString(15);
if (!reader.IsDBNull(16)) user.Resume = reader.GetString(16);
if (!reader.IsDBNull(17)) user.Remark = reader.GetString(17);
if (!reader.IsDBNull(18)) user.UnitID = reader.GetGuid(18);
if (!reader.IsDBNull(19)) user.UserType = reader.GetInt32(19);
if (!reader.IsDBNull(20)) user.Discourse = reader.GetString(20);
if (!reader.IsDBNull(21)) user.Acquire = reader.GetString(21);
if (!reader.IsDBNull(22)) user.RegDate = reader.GetDateTime(22);
if (!reader.IsDBNull(23)) user.LastActiveTime = reader.GetDateTime(23);
if (!reader.IsDBNull(24)) user.Status = reader.GetInt32(24);
if (!reader.IsDBNull(25)) user.Unit = reader.GetString(25);
if (!reader.IsDBNull(26)) user.Duty = reader.GetString(26);
if (!reader.IsDBNull(27)) user.FeildID = reader.GetGuid(27);
reader.Close();
return user;
}
else
{
if (reader != null && !reader.IsClosed)
reader.Close();
return null;
}
}
public IEnumerable<User> SearchUserUnPaged(UserSearchJsonPatch json)
{
if (json == null)
throw new ArgumentNullException(" json is null ");
IList<Core.Business.User> userlist = new List<Core.Business.User>();
SqlServerUtility sql = new SqlServerUtility();
if (!string.IsNullOrEmpty(json.RealName))
{
sql.AddParameter("@realname", SqlDbType.NVarChar, json.RealName);
}
if (!string.IsNullOrEmpty(json.Name))
{
sql.AddParameter("@name", SqlDbType.NVarChar, json.Name);
}
if (json.Gender != null)
{
if (json.Gender.Value == 1)
{
sql.AddParameter("@gender", SqlDbType.NVarChar, "��");
}
else
{
sql.AddParameter("@gender", SqlDbType.NVarChar, "Ů");
}
}
if (json.PostRank != null && json.PostRank.Value != Guid.Empty)
{
sql.AddParameter("@postrank", SqlDbType.UniqueIdentifier, json.PostRank.Value);
}
if (json.Education != null && json.Education.Value != Guid.Empty)
{
sql.AddParameter("@educaion", SqlDbType.UniqueIdentifier, json.Education);
}
if (json.StartAge != null)
{
sql.AddParameter("@startage", SqlDbType.Int, json.StartAge.Value);
}
if (json.EndAge != null)
{
sql.AddParameter("@endage", SqlDbType.Int, json.EndAge.Value);
}
if (json.IsPhone != null)
{
sql.AddParameter("@isphone", SqlDbType.Bit, json.IsPhone);
}
if (!string.IsNullOrEmpty(json.Phone))
{
sql.AddParameter("@phone", SqlDbType.NVarChar, json.Phone);
}
if (json.IsMobile != null)
{
sql.AddParameter("@ismobile", SqlDbType.Bit, json.IsMobile.Value);
}
if (!string.IsNullOrEmpty(json.Mobile))
{
sql.AddParameter("@name", SqlDbType.NVarChar, json.Mobile);
}
if (json.IsEmail != null)
{
sql.AddParameter("@isemail", SqlDbType.Bit, json.IsEmail.Value);
}
if (!string.IsNullOrEmpty(json.Email))
{
sql.AddParameter("@email", SqlDbType.NVarChar, json.Email);
}
if (json.UserType != null)
{
sql.AddParameter("@name", SqlDbType.Int, json.UserType.Value);
}
if (json.Unit != null)
{
sql.AddParameter("@unit", SqlDbType.UniqueIdentifier, json.Unit.Value);
}
if (json.StartRegisterTime != null && json.StartRegisterTime.Value > DateTime.MinValue)
{
sql.AddParameter("@startregistertime", SqlDbType.DateTime, json.StartRegisterTime.Value);
}
if (json.EndRegisterTime != null && json.EndRegisterTime.Value > DateTime.MinValue && json.EndRegisterTime.Value >= json.StartRegisterTime.Value)
{
sql.AddParameter("@endregistertime", SqlDbType.DateTime, json.EndRegisterTime.Value);
}
if (!string.IsNullOrEmpty(json.Department))
{
sql.AddParameter("@department", SqlDbType.NVarChar, json.Department);
}
if (json.Status != null)
{
sql.AddParameter("@status", SqlDbType.Int, json.Status.Value);
}
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectUserUnPaged");
if (reader != null)
{
while (reader.Read() && !reader.IsClosed)
{
Core.Business.User user = new Core.Business.User();
if (!reader.IsDBNull(0)) user.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) user.UserID = reader.GetString(1);
if (!reader.IsDBNull(2)) user.PostRankID = reader.GetGuid(2);
if (!reader.IsDBNull(3)) user.EducationID = reader.GetGuid(3);
if (!reader.IsDBNull(4)) user.PicURL = reader.GetString(4);
if (!reader.IsDBNull(5)) user.Name = reader.GetString(5);
if (!reader.IsDBNull(6)) user.Password = reader.GetString(6);
if (!reader.IsDBNull(7)) user.Gender = reader.GetString(7);
if (!reader.IsDBNull(8)) user.BirthDate = reader.GetDateTime(8);
if (!reader.IsDBNull(9)) user.Address = reader.GetString(9);
if (!reader.IsDBNull(10)) user.Mailcode = reader.GetString(10);
if (!reader.IsDBNull(11)) user.Fax = reader.GetString(11);
if (!reader.IsDBNull(12)) user.Phone = reader.GetString(12);
if (!reader.IsDBNull(13)) user.MobilePhone = reader.GetString(13);
if (!reader.IsDBNull(14)) user.Email = reader.GetString(14);
if (!reader.IsDBNull(15)) user.Specialty = reader.GetString(15);
if (!reader.IsDBNull(16)) user.Resume = reader.GetString(16);
if (!reader.IsDBNull(17)) user.Remark = reader.GetString(17);
if (!reader.IsDBNull(18)) user.UnitID = reader.GetGuid(18);
if (!reader.IsDBNull(19)) user.UserType = reader.GetInt32(19);
if (!reader.IsDBNull(20)) user.Discourse = reader.GetString(20);
if (!reader.IsDBNull(21)) user.Acquire = reader.GetString(21);
if (!reader.IsDBNull(22)) user.RegDate = reader.GetDateTime(22);
if (!reader.IsDBNull(23)) user.LastActiveTime = reader.GetDateTime(23);
if (!reader.IsDBNull(24)) user.Status = reader.GetInt32(24);
if (!reader.IsDBNull(25)) user.Unit = reader.GetString(25);
if (!reader.IsDBNull(26)) user.Duty = reader.GetString(26);
if (!reader.IsDBNull(27)) user.FeildID = reader.GetGuid(27);
user.MarkOld();
userlist.Add(user);
}
reader.Close();
}
return userlist;
}
public IList<CY.CSTS.Core.Business.User> GetExpertsByWhere(string strWhere, string strOrder, CY.CSTS.Core.Business.PagingInfo pageInfo)
{
List<User> userlist = new List<User>();
SqlServerUtility sql = new SqlServerUtility();
if (strOrder.Trim().Length == 0)
{
strOrder = "Id desc";
}
if (strWhere.Trim().Length == 0)
{
strWhere = "1=1";
}
StringBuilder sqlwhere = new StringBuilder();
sqlwhere.Append(" declare @LowerBand int ");
sqlwhere.Append(" declare @UpperBand int");
sqlwhere.Append(" declare @CurrentPage int");
sqlwhere.Append(" declare @PageSize int");
sqlwhere.Append(" Set @CurrentPage=" + pageInfo.CurrentPage + "");
sqlwhere.Append(" Set @PageSize=" + pageInfo.PageSize + "");
sqlwhere.Append(" SET @LowerBand = (@CurrentPage - 1) * @PageSize");
sqlwhere.Append(" SET @UpperBand = (@CurrentPage * @PageSize) + 1");
sqlwhere.Append(";WITH tempPagedUsers AS ");
sqlwhere.Append(" ( SELECT [Id],[UserID],[PostRankID],[EducationID],[PicURL],[Name]");
sqlwhere.Append(" ,[Password],[Gender],[BirthDate],[Address],[Mailcode],[Fax],[Phone],[MobilePhone]");
sqlwhere.Append(" ,[Email],[Specialty],[Resume],[Remark],[UnitID],[UserType],[Discourse],[Acquire],[RegDate]");
sqlwhere.Append(" ,[LastActiveTime],[Status],[Unit],[Duty],[FeildID],ROW_NUMBER() OVER (order by Id) as RowNumber FROM [dbo].[User]");
sqlwhere.Append(" where UserType=4 and " + strWhere + ")");
sqlwhere.Append(" SELECT * FROM tempPagedUsers WHERE UserType=4 and RowNumber > @LowerBand AND RowNumber < @UpperBand Order by " + strOrder);
SqlDataReader reader = sql.ExecuteSqlReader(sqlwhere.ToString());
if (reader != null && !reader.IsClosed)
{
Core.Business.User user = null;
while (reader.Read())
{
user = new Core.Business.User();
if (!reader.IsDBNull(0))
{
user = CY.CSTS.Core.Business.User.Load(reader.GetGuid(0));
}
userlist.Add(user);
}
reader.Close();
}
return userlist;
}
/// <summary>
/// ��ҳ��������
/// </summary>
/// <param name="pagenumber"></param>
/// <param name="pagesize"></param>
/// <param name="unitId"></param>
/// <returns></returns>
public IList<User> GetUserInUnitByPage(int pagenumber, int pagesize, string sqlwherecondintion)
{
List<User> userlist = new List<User>();
SqlServerUtility sql = new SqlServerUtility();
//sql.AddParameter("@LowerBand",SqlDbType.Int,pagenumber);
//sql.AddParameter("@UpperBand",SqlDbType.Int,pagesize);
StringBuilder sqlwhere = new StringBuilder();
sqlwhere.Append(" declare @LowerBand int ");
sqlwhere.Append(" declare @UpperBand int");
sqlwhere.Append(" declare @CurrentPage int");
sqlwhere.Append(" declare @PageSize int");
sqlwhere.Append(" Set @CurrentPage=" + pagenumber + "");
sqlwhere.Append(" Set @PageSize=" + pagesize + "");
sqlwhere.Append(" SET @LowerBand = (@CurrentPage - 1) * @PageSize");
sqlwhere.Append(" SET @UpperBand = (@CurrentPage * @PageSize) + 1");
sqlwhere.Append(";WITH tempPagedUsers AS ");
sqlwhere.Append(" ( SELECT [Id],[UserID],[PostRankID],[EducationID],[PicURL],[Name]");
sqlwhere.Append(" ,[Password],[Gender],[BirthDate],[Address],[Mailcode],[Fax],[Phone],[MobilePhone]");
sqlwhere.Append(" ,[Email],[Specialty],[Resume],[Remark],[UnitID],[UserType],[Discourse],[Acquire],[RegDate]");
sqlwhere.Append(" ,[LastActiveTime],[Status],[Unit],[Duty],[FeildID],ROW_NUMBER() OVER (order by UserID asc) as RowNumber FROM [dbo].[User]");
sqlwhere.Append(" where " + sqlwherecondintion + ")");
sqlwhere.Append(" SELECT * FROM tempPagedUsers WHERE RowNumber > @LowerBand AND RowNumber < @UpperBand");
SqlDataReader reader = sql.ExecuteSqlReader(sqlwhere.ToString());
if (reader != null && !reader.IsClosed)
{
Core.Business.User user = null;
while (reader.Read())
{
user = new Core.Business.User();
if (!reader.IsDBNull(0))
{
user = CY.CSTS.Core.Business.User.Load(reader.GetGuid(0));
}
userlist.Add(user);
}
reader.Close();
}
return userlist;
}
public List<User> GetUserByUserSearchJsonNPagingInfo(string code, string name, string gender, int usertype, int userstate, int pagesize, int pagenum)
{
List<User> userlist = new List<User>();
System.Text.StringBuilder sbFilter = new System.Text.StringBuilder();
#region Builder Filter
sbFilter.Append(" 1=1 ");
if (!string.IsNullOrEmpty(code))
{
sbFilter.Append(" AND [UserId] like '%");
sbFilter.Append(code.Replace("'", "").Replace("\"", ""));
sbFilter.Append("%'");
}
if (!string.IsNullOrEmpty(name))
{
sbFilter.Append(" AND [Name] like '%");
sbFilter.Append(name.Replace("'", "").Replace("\"", ""));
sbFilter.Append("%'");
}
if (!string.IsNullOrEmpty(gender))
{
sbFilter.Append(" and [gender]='");
sbFilter.Append(gender);
sbFilter.Append("'");
}
sbFilter.Append(" and UserType=");
sbFilter.Append(usertype);
sbFilter.Append(" and Status =");
sbFilter.Append(userstate);
#endregion
string filter = sbFilter.ToString();
SqlServerUtility sql = new SqlServerUtility();
StringBuilder sqlwhere = new StringBuilder();
sqlwhere.Append(" declare @LowerBand int ");
sqlwhere.Append(" declare @UpperBand int");
sqlwhere.Append(" declare @CurrentPage int");
sqlwhere.Append(" declare @PageSize int");
sqlwhere.Append(" Set @CurrentPage=" + pagenum + "");
sqlwhere.Append(" Set @PageSize=" + pagesize + "");
sqlwhere.Append(" SET @LowerBand = (@CurrentPage - 1) * @PageSize");
sqlwhere.Append(" SET @UpperBand = (@CurrentPage * @PageSize) + 1");
sqlwhere.Append(";WITH tempPagedUsers AS ");
sqlwhere.Append(" ( SELECT [Id],[UserID],[PostRankID],[EducationID],[PicURL],[Name]");
sqlwhere.Append(" ,[Password],[Gender],[BirthDate],[Address],[Mailcode],[Fax],[Phone],[MobilePhone]");
sqlwhere.Append(" ,[Email],[Specialty],[Resume],[Remark],[UnitID],[UserType],[Discourse],[Acquire],[RegDate]");
sqlwhere.Append(" ,[LastActiveTime],[Status],[Unit],[Duty],[FeildID],ROW_NUMBER() OVER (order by Id) as RowNumber FROM [dbo].[User]");
sqlwhere.Append(" where " + filter + ")");
sqlwhere.Append(" SELECT * FROM tempPagedUsers WHERE RowNumber > @LowerBand AND RowNumber < @UpperBand");
SqlDataReader reader = sql.ExecuteSqlReader(sqlwhere.ToString());
if (reader != null && !reader.IsClosed)
{
Core.Business.User user = null;
while (reader.Read())
{
user = new Core.Business.User();
if (!reader.IsDBNull(0))
{
user = CY.CSTS.Core.Business.User.Load(reader.GetGuid(0));
}
userlist.Add(user);
}
reader.Close();
}
return userlist;
}
public IList<CY.CSTS.Core.Business.User> SelectUsersDynamic(string whereCondition, string orderByExpression)
{
if (string.IsNullOrEmpty(whereCondition))
{
return this.GetAllUser();
}
IList<Core.Business.User> userlist = new List<Core.Business.User>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@WhereCondition", SqlDbType.NVarChar, whereCondition);
sql.AddParameter("@OrderByExpression", SqlDbType.NVarChar, orderByExpression);
SqlDataReader reader = sql.ExecuteSPReader("usp_SelectUsersDynamic");
if (reader != null)
{
while (reader.Read() && !reader.IsClosed)
{
Core.Business.User user = new Core.Business.User();
if (!reader.IsDBNull(0)) user.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) user.UserID = reader.GetString(1);
if (!reader.IsDBNull(2)) user.PostRankID = reader.GetGuid(2);
if (!reader.IsDBNull(3)) user.EducationID = reader.GetGuid(3);
if (!reader.IsDBNull(4)) user.PicURL = reader.GetString(4);
if (!reader.IsDBNull(5)) user.Name = reader.GetString(5);
if (!reader.IsDBNull(6)) user.Password = reader.GetString(6);
if (!reader.IsDBNull(7)) user.Gender = reader.GetString(7);
if (!reader.IsDBNull(8)) user.BirthDate = reader.GetDateTime(8);
if (!reader.IsDBNull(9)) user.Address = reader.GetString(9);
if (!reader.IsDBNull(10)) user.Mailcode = reader.GetString(10);
if (!reader.IsDBNull(11)) user.Fax = reader.GetString(11);
if (!reader.IsDBNull(12)) user.Phone = reader.GetString(12);
if (!reader.IsDBNull(13)) user.MobilePhone = reader.GetString(13);
if (!reader.IsDBNull(14)) user.Email = reader.GetString(14);
if (!reader.IsDBNull(15)) user.Specialty = reader.GetString(15);
if (!reader.IsDBNull(16)) user.Resume = reader.GetString(16);
if (!reader.IsDBNull(17)) user.Remark = reader.GetString(17);
if (!reader.IsDBNull(18)) user.UnitID = reader.GetGuid(18);
if (!reader.IsDBNull(19)) user.UserType = reader.GetInt32(19);
if (!reader.IsDBNull(20)) user.Discourse = reader.GetString(20);
if (!reader.IsDBNull(21)) user.Acquire = reader.GetString(21);
if (!reader.IsDBNull(22)) user.RegDate = reader.GetDateTime(22);
if (!reader.IsDBNull(23)) user.LastActiveTime = reader.GetDateTime(23);
if (!reader.IsDBNull(24)) user.Status = reader.GetInt32(24);
if (!reader.IsDBNull(25)) user.Unit = reader.GetString(25);
if (!reader.IsDBNull(26)) user.Duty = reader.GetString(26);
if (!reader.IsDBNull(27)) user.FeildID = reader.GetGuid(27);
user.MarkOld();
userlist.Add(user);
}
reader.Close();
}
return userlist;
}
public IEnumerable<User> GetUser(Guid instrument)
{
if (instrument == System.Guid.Empty)
return null;
IList<Core.Business.User> userlist = new List<Core.Business.User>();
SqlServerUtility sql = new SqlServerUtility();
sql.AddParameter("@Id", SqlDbType.UniqueIdentifier, instrument);
SqlDataReader reader = sql.ExecuteSqlReader(Sql_GetUsers);
if (reader != null)
{
while (reader.Read() && !reader.IsClosed)
{
Core.Business.User user = new Core.Business.User();
if (!reader.IsDBNull(0)) user.Id = reader.GetGuid(0);
if (!reader.IsDBNull(1)) user.UserID = reader.GetString(1);
if (!reader.IsDBNull(2)) user.PostRankID = reader.GetGuid(2);
if (!reader.IsDBNull(3)) user.EducationID = reader.GetGuid(3);
if (!reader.IsDBNull(4)) user.PicURL = reader.GetString(4);
if (!reader.IsDBNull(5)) user.Name = reader.GetString(5);
if (!reader.IsDBNull(6)) user.Password = reader.GetString(6);
if (!reader.IsDBNull(7)) user.Gender = reader.GetString(7);
if (!reader.IsDBNull(8)) user.BirthDate = reader.GetDateTime(8);
if (!reader.IsDBNull(9)) user.Address = reader.GetString(9);
if (!reader.IsDBNull(10)) user.Mailcode = reader.GetString(10);
if (!reader.IsDBNull(11)) user.Fax = reader.GetString(11);
if (!reader.IsDBNull(12)) user.Phone = reader.GetString(12);
if (!reader.IsDBNull(13)) user.MobilePhone = reader.GetString(13);
if (!reader.IsDBNull(14)) user.Email = reader.GetString(14);
if (!reader.IsDBNull(15)) user.Specialty = reader.GetString(15);
if (!reader.IsDBNull(16)) user.Resume = reader.GetString(16);
if (!reader.IsDBNull(17)) user.Remark = reader.GetString(17);
if (!reader.IsDBNull(18)) user.UnitID = reader.GetGuid(18);
if (!reader.IsDBNull(19)) user.UserType = reader.GetInt32(19);
if (!reader.IsDBNull(20)) user.Discourse = reader.GetString(20);
if (!reader.IsDBNull(21)) user.Acquire = reader.GetString(21);
if (!reader.IsDBNull(22)) user.RegDate = reader.GetDateTime(22);
if (!reader.IsDBNull(23)) user.LastActiveTime = reader.GetDateTime(23);
if (!reader.IsDBNull(24)) user.Status = reader.GetInt32(24);
if (!reader.IsDBNull(25)) user.Unit = reader.GetString(25);
if (!reader.IsDBNull(26)) user.Duty = reader.GetString(26);
if (!reader.IsDBNull(27)) user.FeildID = reader.GetGuid(27);
user.MarkOld();
userlist.Add(user);
}
reader.Close();
}
return userlist;
}
