/// <summary>
/// 查所有集合 kevin创建
/// </summary>
/// <returns></returns>
public List <Model.MemberRank> GetAllMemberRank()
{
string strSql = "select * from MemberRank";
List <Model.MemberRank> ranklist = new List <Model.MemberRank>();
using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql))
{
while (reader.Read())
{
Model.MemberRank model = new Model.MemberRank();
model.Id = (int)reader["Id"];
model.Name = (string)reader["Name"];
model.LogoPic = (string)reader["LogoPic"];
model.Discount = Convert.ToDecimal(reader["Discount"]);
model.MinScore = Convert.ToDecimal(reader["MinScore"]);
model.MaxScore = Convert.ToDecimal(reader["MaxScore"]);
model.Priority = Convert.ToInt32(reader["Priority"]);
model.IsSpecial = Convert.ToInt32(reader["IsSpecial"]);
model.IsShowPrice = Convert.ToInt32(reader["IsShowPrice"]);
model.Article = Convert.ToInt32(reader["Article"]);
model.Product = Convert.ToInt32(reader["Product"]);
model.ArticleAuditing = Convert.ToInt32(reader["ArticleAuditing"]);
model.ProductAuditing = Convert.ToInt32(reader["ProductAuditing"]);
model.MaxMoney = Convert.ToDecimal(reader["MaxMoney"]);
model.UpgradeMoney = Convert.ToDecimal(reader["UpgradeMoney"]);
model.IsUpgrade = Convert.ToInt32(reader["IsUpgrade"]);
ranklist.Add(model);
}
}
return(ranklist);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(Model.MemberRank model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update MemberRank set ");
strSql.Append("Name=@Name,");
strSql.Append("LogoPic=@LogoPic,");
strSql.Append("Discount=@Discount,");
strSql.Append("MinScore=@MinScore,");
strSql.Append("MaxScore=@MaxScore,");
strSql.Append("Priority=@Priority,");
strSql.Append("IsSpecial=@IsSpecial,");
strSql.Append("IsShowPrice=@IsShowPrice,");
strSql.Append("Article=@Article,");
strSql.Append("Product=@Product,");
strSql.Append("ArticleAuditing=@ArticleAuditing,");
strSql.Append("ProductAuditing=@ProductAuditing,");
strSql.Append("MaxMoney=@MaxMoney,");
strSql.Append("UpgradeMoney=@UpgradeMoney,");
strSql.Append("IsUpgrade=@IsUpgrade");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@LogoPic", SqlDbType.NVarChar, 200),
new SqlParameter("@Discount", SqlDbType.Float, 8),
new SqlParameter("@MinScore", SqlDbType.Float, 8),
new SqlParameter("@MaxScore", SqlDbType.Float, 8),
new SqlParameter("@Priority", SqlDbType.Int, 4),
new SqlParameter("@IsSpecial", SqlDbType.Int, 4),
new SqlParameter("@IsShowPrice", SqlDbType.Int, 4),
new SqlParameter("@Article", SqlDbType.Int, 4),
new SqlParameter("@Product", SqlDbType.Int, 4),
new SqlParameter("@ArticleAuditing", SqlDbType.Int, 4),
new SqlParameter("@ProductAuditing", SqlDbType.Int, 4),
new SqlParameter("@MaxMoney", SqlDbType.Float, 8),
new SqlParameter("@UpgradeMoney", SqlDbType.Float, 8),
new SqlParameter("@IsUpgrade", SqlDbType.Int, 4)
};
parameters[0].Value = model.Id;
parameters[1].Value = model.Name;
parameters[2].Value = model.LogoPic;
parameters[3].Value = model.Discount;
parameters[4].Value = model.MinScore;
parameters[5].Value = model.MaxScore;
parameters[6].Value = model.Priority;
parameters[7].Value = model.IsSpecial;
parameters[8].Value = model.IsShowPrice;
parameters[9].Value = model.Article;
parameters[10].Value = model.Product;
parameters[11].Value = model.ArticleAuditing;
parameters[12].Value = model.ProductAuditing;
parameters[13].Value = model.MaxMoney;
parameters[14].Value = model.UpgradeMoney;
parameters[15].Value = model.IsUpgrade;
ChangeHope.DataBase.SQLServerHelper.ExecuteSql(strSql.ToString(), parameters);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Model.MemberRank model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into MemberRank(");
strSql.Append("Name,LogoPic,Discount,MinScore,MaxScore,Priority,IsSpecial,IsShowPrice,Article,Product,ArticleAuditing,ProductAuditing,MaxMoney,UpgradeMoney,IsUpgrade)");
strSql.Append(" values (");
strSql.Append("@Name,@LogoPic,@Discount,@MinScore,@MaxScore,@Priority,@IsSpecial,@IsShowPrice,@Article,@Product,@ArticleAuditing,@ProductAuditing,@MaxMoney,@UpgradeMoney,@IsUpgrade)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Name", SqlDbType.NVarChar, 50),
new SqlParameter("@LogoPic", SqlDbType.NVarChar, 200),
new SqlParameter("@Discount", SqlDbType.Float, 8),
new SqlParameter("@MinScore", SqlDbType.Float, 8),
new SqlParameter("@MaxScore", SqlDbType.Float, 8),
new SqlParameter("@Priority", SqlDbType.Int, 4),
new SqlParameter("@IsSpecial", SqlDbType.Int, 4),
new SqlParameter("@IsShowPrice", SqlDbType.Int, 4),
new SqlParameter("@Article", SqlDbType.Int, 4),
new SqlParameter("@Product", SqlDbType.Int, 4),
new SqlParameter("@ArticleAuditing", SqlDbType.Int, 4),
new SqlParameter("@ProductAuditing", SqlDbType.Int, 4),
new SqlParameter("@MaxMoney", SqlDbType.Float, 8),
new SqlParameter("@UpgradeMoney", SqlDbType.Float, 8),
new SqlParameter("@IsUpgrade", SqlDbType.Int, 4)
};
parameters[0].Value = model.Name;
parameters[1].Value = model.LogoPic;
parameters[2].Value = model.Discount;
parameters[3].Value = model.MinScore;
parameters[4].Value = model.MaxScore;
parameters[5].Value = model.Priority;
parameters[6].Value = model.IsSpecial;
parameters[7].Value = model.IsShowPrice;
parameters[8].Value = model.Article;
parameters[9].Value = model.Product;
parameters[10].Value = model.ArticleAuditing;
parameters[11].Value = model.ProductAuditing;
parameters[12].Value = model.MaxMoney;
parameters[13].Value = model.UpgradeMoney;
parameters[14].Value = model.IsUpgrade;
object obj = ChangeHope.DataBase.SQLServerHelper.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(1);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.MemberRank GetModel(int Id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from MemberRank ");
strSql.Append(" where Id=@Id ");
SqlParameter[] parameters =
{
new SqlParameter("@Id", SqlDbType.Int, 4)
};
parameters[0].Value = Id;
Model.MemberRank model = null;
using (SqlDataReader reader = ChangeHope.DataBase.SQLServerHelper.ExecuteReader(strSql.ToString(), parameters))
{
while (reader.Read())
{
model = new Model.MemberRank();
model.Id = (int)reader["Id"];
model.Name = (string)reader["Name"];
model.LogoPic = (string)reader["LogoPic"];
model.Discount = Convert.ToDecimal(reader["Discount"]);
model.MinScore = Convert.ToDecimal(reader["MinScore"]);
model.MaxScore = Convert.ToDecimal(reader["MaxScore"]);
model.Priority = Convert.ToInt32(reader["Priority"]);
model.IsSpecial = Convert.ToInt32(reader["IsSpecial"]);
model.IsShowPrice = Convert.ToInt32(reader["IsShowPrice"]);
model.Article = Convert.ToInt32(reader["Article"]);
model.Product = Convert.ToInt32(reader["Product"]);
model.ArticleAuditing = Convert.ToInt32(reader["ArticleAuditing"]);
model.ProductAuditing = Convert.ToInt32(reader["ProductAuditing"]);
model.MaxMoney = Convert.ToDecimal(reader["MaxMoney"]);
model.UpgradeMoney = Convert.ToDecimal(reader["UpgradeMoney"]);
model.IsUpgrade = Convert.ToInt32(reader["IsUpgrade"]);
}
}
return(model);
}
