/// <summary> /// 得到一个对象实体 /// </summary> public ShowShop.Model.SystemInfo.Deliver GetModelByID(int id) { ShowShop.Model.SystemInfo.Deliver model = new ShowShop.Model.SystemInfo.Deliver(); StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 Id,DistributionName,DistributionDescription,InsuredCosts,IsCOD,Author,Version,IsInstallation from " + Pre + "deliverymode "); 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.Distributionname = reader.GetString(1); model.Distributiondescription = reader["DistributionDescription"].ToString(); model.Insuredcosts = float.Parse(reader["InsuredCosts"].ToString()); model.IsCOD = reader.GetInt32(4); model.Author = reader["Author"].ToString(); model.Version = reader["Version"].ToString(); model.Isinstallation = Convert.ToInt32(reader["IsInstallation"]); } else { model = null; } } return model; }
/// <summary> /// 所有数据集合 /// </summary> /// <returns></returns> public List<ShowShop.Model.SystemInfo.Deliver> GetAll() { List<ShowShop.Model.SystemInfo.Deliver> list = new List<ShowShop.Model.SystemInfo.Deliver>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select Id,DistributionName,DistributionDescription,InsuredCosts,IsCOD,Author,Version,IsInstallation from " + Pre + "deliverymode "); strSql.Append(" where 1=1"); strSql.Append(" order by Id asc"); using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString())) { while (reader.Read()) { ShowShop.Model.SystemInfo.Deliver model = new ShowShop.Model.SystemInfo.Deliver(); model.Id = reader.GetInt32(0); model.Distributionname = reader.GetString(1); model.Distributiondescription = reader["DistributionDescription"].ToString(); model.Insuredcosts = float.Parse(reader["InsuredCosts"].ToString()); model.IsCOD = reader.GetInt32(4); model.Author = reader["Author"].ToString(); model.Version = reader["Version"].ToString(); model.Isinstallation = Convert.ToInt32(reader["IsInstallation"]); list.Add(model); } } return list; return null; }