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