/// <summary>
/// 查询所有的商品
/// </summary>
/// <param name="old"></param>
/// <returns></returns>
public static List <FlowerNew> GetFlowerNew(string str)
{
List <FlowerNew> flo = new List <FlowerNew>();
SqlDataReader dr = DbHelp.ExecuteDataReader(str);
FlowerNew flower = null;
while (dr.Read())
{
flower = new FlowerNew();
flower.FlowerColor = dr["FlowerColor"] as string;
flower.FlowerDesc = dr["FlowerDesc"] as string;
flower.FlowerID = (int)dr["FlowerID"];
flower.FlowerLang = dr["FlowerLang"] as string;
flower.FlowerMaterials = dr["FlowerMaterials"] as string;
flower.FlowerName = dr["FlowerName"] as string;
flower.FlowerNum = (int)dr["FlowerNum"];
flower.FlowerPicUrl = dr["FlowerPicUrl"] as string;
flower.FlowerPrice = (decimal)dr["FlowerPrice"];
flower.FlowerSize = dr["FlowerSize"] as string;
flower.FlowerState = dr["FlowerState"] as string;
flower.TypeID = (int)dr["TypeID"];
flo.Add(flower);
}
dr.Close();
return(flo);
}
/// <summary>
/// 添加新商品
/// </summary>
/// <param name="flo"></param>
/// <returns></returns>
public static int InsertFlowerNew(FlowerNew flo)
{
string str = "Insert into FlowerNew values(@FlowerName,@FlowerMaterials,@TypeID,@FlowerColor,@FlowerSize,@FlowerPicUrl,@FlowerPrice,@FlowerNum,@FlowerLang,@FlowerDesc,@FlowerState)";
SqlParameter[] p = { new SqlParameter("@FlowerName", flo.FlowerName), new SqlParameter("@FlowerMaterials", flo.FlowerMaterials), new SqlParameter("@TypeID", flo.TypeID),
new SqlParameter("@FlowerColor", flo.FlowerColor), new SqlParameter("@FlowerSize", flo.FlowerSize), new SqlParameter("@FlowerPicUrl", flo.FlowerPicUrl),
new SqlParameter("@FlowerPrice", flo.FlowerPrice), new SqlParameter("@FlowerNum", flo.FlowerNum), new SqlParameter("@FlowerLang", flo.FlowerLang),
new SqlParameter("@FlowerDesc", flo.FlowerDesc), new SqlParameter("@FlowerState", flo.FlowerState) };
return(DbHelp.ExecuteNonQuary(str, p));
}
public static string InsertFlowerNew(FlowerNew flo)
{
string str = "";
switch (FlowerNewDal.InsertFlowerNew(flo))
{
case -2:
str = "数据库连接异常!请检查您的数据库或联系管理员";
break;
case -1:
str = "数据操作异常！请检查输入的数据或联系管理员";
break;
case 0:
str = "操作失败，请检查数据是否错误";
break;
default:
str = "商品添加成功！";
break;
}
return(str);
}
