public ADeeWu.HuoBi3J.Model.IM_Users GetEntity(string where)
{
DataTable dt = this.Select(where,"");
if(dt.Rows.Count==0) return null;
DataRow dr = dt.Rows[0];
ADeeWu.HuoBi3J.Model.IM_Users Entity = new ADeeWu.HuoBi3J.Model.IM_Users();
Entity.ID = long.Parse(dr["ID"].ToString());
Entity.UIN = (string)(dr["UIN"]);
Entity.UserID = long.Parse(dr["UserID"].ToString());
Entity.NickName = (string)(dr["NickName"]);
Entity.HeadPic = (string)(dr["HeadPic"]);
Entity.Sex = (string)(dr["Sex"]);
Entity.SignText = (string)(dr["SignText"]);
Entity.Birthday = dr["Birthday"] as DateTime?;
Entity.Tel = (string)(dr["Tel"]);
Entity.Email = (string)(dr["Email"]);
Entity.ProvinceID = long.Parse(dr["ProvinceID"].ToString());
Entity.CityID = long.Parse(dr["CityID"].ToString());
Entity.AreaID = long.Parse(dr["AreaID"].ToString());
Entity.Province = (string)(dr["Province"]);
Entity.City = (string)(dr["City"]);
Entity.Area = (string)(dr["Area"]);
Entity.Profession = (string)(dr["Profession"]);
Entity.School = (string)(dr["School"]);
Entity.HomePage = (string)(dr["HomePage"]);
Entity.Introduce = (string)(dr["Introduce"]);
Entity.CheckState = int.Parse(dr["CheckState"].ToString());
Entity.LastLoginTime = DateTime.Parse(dr["LastLoginTime"].ToString());
Entity.LastLoginIP = (string)(dr["LastLoginIP"]);
Entity.LoginTimes = int.Parse(dr["LoginTimes"].ToString());
Entity.LoginState = int.Parse(dr["LoginState"].ToString());
Entity.CreateTime = DateTime.Parse(dr["CreateTime"].ToString());
Entity.ModifyTime = DateTime.Parse(dr["ModifyTime"].ToString());
return Entity;
}
public ADeeWu.HuoBi3J.Model.IM_Users[] GetEntityList(string orderBy,string[] columns,params object[] values)
{
StringBuilder builder = new StringBuilder();
builder.Append("select * from [IM_Users] where 1=1");
db.Parameters.Clear();
for(int i=0;i<columns.Length;i++)
{
builder.AppendFormat(" and [{0}]=@{0}", columns[i]);
db.Parameters.Append("@"+columns[i],values[i]);
}
if (!string.IsNullOrEmpty(orderBy))
{
builder.AppendFormat(" order by {0}", orderBy);
}
DataTable dt = db.Select(builder.ToString());
ADeeWu.HuoBi3J.Model.IM_Users[] EntityList = new ADeeWu.HuoBi3J.Model.IM_Users[dt.Rows.Count];
if (dt.Rows.Count == 0) return EntityList;
for (int i = 0; i < dt.Rows.Count; i++)
{
DataRow dr = dt.Rows[i];
ADeeWu.HuoBi3J.Model.IM_Users Entity = new ADeeWu.HuoBi3J.Model.IM_Users();
Entity.ID = long.Parse(dr["ID"].ToString());
Entity.UIN = (string)(dr["UIN"]);
Entity.UserID = long.Parse(dr["UserID"].ToString());
Entity.NickName = (string)(dr["NickName"]);
Entity.HeadPic = (string)(dr["HeadPic"]);
Entity.Sex = (string)(dr["Sex"]);
Entity.SignText = (string)(dr["SignText"]);
Entity.Birthday = dr["Birthday"] as DateTime?;
Entity.Tel = (string)(dr["Tel"]);
Entity.Email = (string)(dr["Email"]);
Entity.ProvinceID = long.Parse(dr["ProvinceID"].ToString());
Entity.CityID = long.Parse(dr["CityID"].ToString());
Entity.AreaID = long.Parse(dr["AreaID"].ToString());
Entity.Province = (string)(dr["Province"]);
Entity.City = (string)(dr["City"]);
Entity.Area = (string)(dr["Area"]);
Entity.Profession = (string)(dr["Profession"]);
Entity.School = (string)(dr["School"]);
Entity.HomePage = (string)(dr["HomePage"]);
Entity.Introduce = (string)(dr["Introduce"]);
Entity.CheckState = int.Parse(dr["CheckState"].ToString());
Entity.LastLoginTime = DateTime.Parse(dr["LastLoginTime"].ToString());
Entity.LastLoginIP = (string)(dr["LastLoginIP"]);
Entity.LoginTimes = int.Parse(dr["LoginTimes"].ToString());
Entity.LoginState = int.Parse(dr["LoginState"].ToString());
Entity.CreateTime = DateTime.Parse(dr["CreateTime"].ToString());
Entity.ModifyTime = DateTime.Parse(dr["ModifyTime"].ToString());
EntityList[i] = Entity;
}
return EntityList;
}
public ADeeWu.HuoBi3J.Model.IM_Users GetEntity(long ID,string UIN)
{
db.Parameters.Clear();
db.Parameters.Append("@ID",ID);
db.Parameters.Append("@UIN",UIN);
DataTable dt = db.Select("select * from [IM_Users] where 1=1 and [ID]=@ID and [UIN]=@UIN");
if(dt.Rows.Count==0) return null;
DataRow dr = dt.Rows[0];
ADeeWu.HuoBi3J.Model.IM_Users Entity = new ADeeWu.HuoBi3J.Model.IM_Users();
Entity.ID = long.Parse(dr["ID"].ToString());
Entity.UIN = (string)(dr["UIN"]);
Entity.UserID = long.Parse(dr["UserID"].ToString());
Entity.NickName = (string)(dr["NickName"]);
Entity.HeadPic = (string)(dr["HeadPic"]);
Entity.Sex = (string)(dr["Sex"]);
Entity.SignText = (string)(dr["SignText"]);
Entity.Birthday = dr["Birthday"] as DateTime?;
Entity.Tel = (string)(dr["Tel"]);
Entity.Email = (string)(dr["Email"]);
Entity.ProvinceID = long.Parse(dr["ProvinceID"].ToString());
Entity.CityID = long.Parse(dr["CityID"].ToString());
Entity.AreaID = long.Parse(dr["AreaID"].ToString());
Entity.Province = (string)(dr["Province"]);
Entity.City = (string)(dr["City"]);
Entity.Area = (string)(dr["Area"]);
Entity.Profession = (string)(dr["Profession"]);
Entity.School = (string)(dr["School"]);
Entity.HomePage = (string)(dr["HomePage"]);
Entity.Introduce = (string)(dr["Introduce"]);
Entity.CheckState = int.Parse(dr["CheckState"].ToString());
Entity.LastLoginTime = DateTime.Parse(dr["LastLoginTime"].ToString());
Entity.LastLoginIP = (string)(dr["LastLoginIP"]);
Entity.LoginTimes = int.Parse(dr["LoginTimes"].ToString());
Entity.LoginState = int.Parse(dr["LoginState"].ToString());
Entity.CreateTime = DateTime.Parse(dr["CreateTime"].ToString());
Entity.ModifyTime = DateTime.Parse(dr["ModifyTime"].ToString());
return Entity;
}
