/// <summary> /// 得到一个实体 /// </summary> /// <param name="id"></param> /// <returns></returns> public ShowShop.Model.Member.ReceAddress GetModelByID(int id) { ShowShop.Model.Member.ReceAddress model = new ShowShop.Model.Member.ReceAddress(); StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 id,uid,userid,username,mobile,phone,fax,province,city,borough,address,zip,email,stat,ConsignesTime,ConstructionSigns from yxs_receaddress "); strSql.Append(" where [uid]=@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.UID = reader.GetInt32(1); model.UserId = reader.GetString(2); model.UserName = reader.GetString(3); model.Mobile = reader.GetString(4); model.Phone = reader.GetString(5); model.Fax = reader.GetString(6); model.Province = reader.GetString(7); model.City = reader.GetString(8); model.Borough = reader.GetString(9); model.Address = reader.GetString(10); model.Zip = reader.GetString(11); model.Email = reader.GetString(12); model.Stat = reader.GetInt32(13); model.ConsignesTime = reader["ConsignesTime"].ToString(); model.ConstructionSigns = reader["ConstructionSigns"].ToString(); } } return model; }
/// <summary> /// 得到指定条件的所有短消息 不加 where /// </summary> /// <param name="uid"></param> /// <returns></returns> public List<ShowShop.Model.Member.ReceAddress> GetAll(string strWhere) { List<ShowShop.Model.Member.ReceAddress> list = new List<ShowShop.Model.Member.ReceAddress>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select id,uid,userid,username,mobile,phone,fax,province,city,borough,address,zip,email,stat,ConsignesTime,ConstructionSigns from yxs_receaddress "); if (strWhere != null && strWhere != "") { strSql.Append("where " + strWhere + " "); } using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString())) { while (reader.Read()) { ShowShop.Model.Member.ReceAddress model = new ShowShop.Model.Member.ReceAddress(); model.ID = reader.GetInt32(0); model.UID = reader.GetInt32(1); model.UserId = reader.GetString(2); model.UserName = reader.GetString(3); model.Mobile = reader.GetString(4); model.Phone = reader.GetString(5); model.Fax = reader.GetString(6); model.Province = reader.GetString(7); model.City = reader.GetString(8); model.Borough = reader.GetString(9); model.Address = reader.GetString(10); model.Zip = reader.GetString(11); model.Email = reader.GetString(12); model.Stat = reader.GetInt32(13); model.ConsignesTime = reader.GetString(14); model.ConstructionSigns = reader.GetString(15); list.Add(model); } } return list; }