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