/// <summary>
/// 查看购物车
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static List <Details> GetDetails(UserLogin user)
{
string str = "select d.*from Details d join UserLogin u on d.UserAccount = u.UserAccount where u.UserAccount = @UserName,e and u.UserPassword=@UserPassword and PayState=0";
List <Details> details = new List <Details>();
SqlParameter[] p = { new SqlParameter("@UserName", user.UserAccount), new SqlParameter("@UserPassword", user.USerPassword) };
SqlDataReader dr = DbHelp.ExecuteDataReader(str, p);
Details da = null;
while (dr.Read())
{
da = new Details();
da.DetailsID = (int)dr["DetailsID"];
da.ID = (int)dr["ID"];
da.FlowerName = dr["FlowerName"] as string;
da.FlowerColor = dr["FlowerColor"] as string;
da.DetailsNumber = (int)dr["DetailsNumber"]; //数量
da.FlowerPrice = (float)dr["FlowerPrice"]; //单价li
da.UserAccount = dr["UserAccount"] as string; //账户
da.FlowerPicUrl = dr["FlowerPrice"] as string;
da.FlowerSize = dr["FlowerSize"] as string;
da.Discount = (decimal)dr["Discount"];
da.PayState = (int)dr["PayState"];
da.PayDesc = dr["DetailsPrice"] as string;
details.Add(da);
}
dr.Close();
return(details);
}
/// <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="ty"></param>
/// <returns></returns>
public static int InsertFlowerType(FlowerType ty)
{
string str = "insert into FlowerType values(@TypeName)";
SqlParameter[] p = { new SqlParameter("@TypeName", ty.TypeName) };
return(DbHelp.ExecuteNonQuary(str, p));
}
/// <summary>
/// 追加评论
/// </summary>
/// <param name="feed"></param>
/// <returns></returns>
public static int UpdateFeedback(Feedback feed)
{
string str = "update Feedback set FeedFollow=@FeedFollow ,FeedFollowTime=@FeedFollowTime ";
SqlParameter[] p = { new SqlParameter("@FeedFollow", feed.FeedFollow), new SqlParameter("@FeedFollowTime", feed.FeedFollowTime) };
return(DbHelp.ExecuteNonQuary(str, p));
}
/// <summary>
/// 存放商品，添加商品数量
/// </summary>
/// <param name="sto"></param>
/// <returns></returns>
public static int InsertStore(StoreF sto)
{
string str = "insert into StotreF values(@NewDate,@Repertory.@TypeID.@Guardian)";
SqlParameter[] p = { new SqlParameter("@NewDate", sto.NewDate), new SqlParameter("@Repertory", sto.Repertory),
new SqlParameter("@TypeID", sto.TypeID), new SqlParameter("@Guardian", sto.Guardian) };
return(DbHelp.ExecuteNonQuary(str, p));
}
/// <summary>
/// 修改状态，是否下架
/// </summary>
/// <param name="flower"></param>
/// <returns></returns>
public static int UnderFlowerNew()
{
string sr = "是";
string str = "update FlowerNew set FlowerState=@FlowerState";//默认状态否
SqlParameter[] p = { new SqlParameter("@FlowerState", sr) };
return(DbHelp.ExecuteNonQuary(str, p));
}
/// <summary>
/// 客户反馈，评价
/// </summary>
/// <param name="feed"></param>
/// <returns></returns>
public static int InsertFeedback(Feedback feed)
{
string str = "insert into Feedback(UserAccount,FeedDesc,FeedDay,FeedState) values(@UserAccount,@FeedDesc,@FeedDay,@FeedState)";
SqlParameter[] p = { new SqlParameter("@UserAccount", feed.UserAccount), new SqlParameter("@FeedDesc", feed.FeedDesc),
new SqlParameter("@FeedDay", feed.FeedDay), new SqlParameter("@FeedState", feed.FeedState) };
return(DbHelp.ExecuteNonQuary(str, p));
}
/// <summary>
/// 新用户注册
/// </summary>
/// <param name="user"></param>
/// <returns></returns>
public static int InsertUserLogin(UserLogin user)
{
string str = "insert into UserLogin values(@UserAccount,@USerPassword,@UserName,@UserSex)";
SqlParameter[] p = { new SqlParameter("@UserAccount", user.UserAccount), new SqlParameter("@USerPassword", user.USerPassword),
new SqlParameter("@UserName", user.UserName),
new SqlParameter("@UserSex", user.UserSex) };
return(DbHelp.ExecuteNonQuary(str, p));
}
/// <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));
}
/// <summary>
/// 颜色
/// </summary>
/// <returns></returns>
public static List <Colors> GetColors()
{
List <Colors> co = new List <Colors>();
string str = "select * from Colors";
SqlDataReader dr = DbHelp.ExecuteDataReader(str);
while (dr.Read())
{
co.Add(new Colors()
{
ID = (int)dr["ColorID"], ColorName = dr["ColorName"] as string
});
}
dr.Close();
return(co);
}
/// <summary>
/// 登录
/// </summary>
/// <param name="acc"></param>
/// <param name="where"></param>
/// <param name="password"></param>
/// <returns></returns>
public static List <UserLogin> GetLogin(string where = null)
{
string str = "select * from UserLogin" + where;
List <UserLogin> lo = new List <UserLogin>();
SqlDataReader dr = DbHelp.ExecuteDataReader(str);
if (dr != null)
{
while (dr.Read())
{
lo.Add(new UserLogin(dr["UserAccount"] as string, dr["UserName"] as string, dr["USerPassword"] as string, dr["UserSex"] as string));
}
dr.Close();
}
return(lo);
}
/// <summary>
/// 付款
/// </summary>
/// <param name="de"></param>
/// <returns></returns>
public static string UpdateDratils(Details de)
{
string str = "update Details set PayState=1 where UserAccount=@UserAccount";
SqlParameter[] p = { new SqlParameter("@UserAccount", de.PayState), };
switch (DbHelp.ExecuteNonQuary(str, p))
{
case 1:
str = "付款成功";
break;
default:
str = "付款失败";
break;
}
return(str);
}
public static List <FlowerType> GetFLowerType()
{
List <FlowerType> ty = new List <FlowerType>();
string str = "select * from FlowerType";
SqlDataReader dr = DbHelp.ExecuteDataReader(str);
FlowerType flo = null;
while (dr.Read())
{
flo = new FlowerType();
flo.TypeName = dr["TypeName"] as string;
flo.TypeID = (int)dr["TypeID"];
ty.Add(flo);
}
dr.Close();
return(ty);
}
/// <summary>
/// 添加购物车
/// </summary>
/// <param name="de"></param>
/// <returns></returns>
public static string InsertDrtails(Details de)
{
string str = "insert into Details values(@DetailsID,@ID,@FlowerName," +
"@FlowerColor,@FlowerSize,@FlowerPicUrl,@FlowerPrice,@DetailsNumber,@UserAccount,@Discount,@PayState,@PayDesc)";
SqlParameter[] p = { new SqlParameter("@DetailsID", de.DetailsID), new SqlParameter("@ID", de.ID), new SqlParameter("@FlowerName", de.FlowerName),
new SqlParameter("@FlowerColor", de.FlowerColor), new SqlParameter("@FlowerSize", de.FlowerSize), new SqlParameter("@FlowerPicUrl", de.FlowerPicUrl),
new SqlParameter("@FlowerPrice", de.FlowerPrice), new SqlParameter("@DetailsNumber", de.DetailsNumber), new SqlParameter("@UserAccount", de.UserAccount),
new SqlParameter("@Discount", de.Discount), new SqlParameter("@PayState", de.PayState),
new SqlParameter("@PayDesc", de.PayDesc) };
switch (DbHelp.ExecuteNonQuary(str, p))
{
case 1:
str = "加入购物车";
break;
default:
str = "加入购物车失败";
break;
}
return(str);
}
public static int GetPageCount()
{
string str = "select count(*) from [FlowerNew]";
return((int)DbHelp.ExecuteScalar(str));
}
