/// <summary> /// 得到一个对象实体 /// </summary> public ShowShop.Model.Member.MailInfo GetModelByID(int id) { ShowShop.Model.Member.MailInfo model = new ShowShop.Model.Member.MailInfo(); StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 [id],[sender],[sendtime],[sendip],[title],[body],[stat] from yxs_mailinfo "); strSql.Append(" where [id]=@id "); SqlParameter[] parameters = (SqlParameter[])this.ValueIDPara(id); using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString(), parameters)) { if (reader.Read()) { model.ID = reader.GetInt32(0); model.Sender = reader.GetString(1); model.SendTime = reader.GetDateTime(2); model.SendIp = reader.GetString(3); model.Title = reader.GetString(4); model.Body = reader.GetString(5); model.Stat = reader.GetInt32(6); } } return model; }
/// <summary> /// 得到指定条件的所有短消息 /// </summary> /// <param name="uid"></param> /// <returns></returns> public List<ShowShop.Model.Member.MailInfo> GetAll(string strWhere) { List<ShowShop.Model.Member.MailInfo> list = new List<ShowShop.Model.Member.MailInfo>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select [id],[sender],[sendtime],[sendip],[title],[body],[stat] from yxs_mailinfo "); if (strWhere != null && strWhere != "") { strSql.Append("where " + strWhere + " "); } using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString())) { while (reader.Read()) { ShowShop.Model.Member.MailInfo model = new ShowShop.Model.Member.MailInfo(); model.ID = reader.GetInt32(0); model.Sender = reader.GetString(1); model.SendTime = reader.GetDateTime(2); model.SendIp = reader.GetString(3); model.Title = reader.GetString(4); model.Body = reader.GetString(5); model.Stat = reader.GetInt32(6); list.Add(model); } } return list; }