private static int UpdateBookNum(OrderDetails deta)
{
string sql = string.Format(@"update Book set BCount=BCount-{0},BSaleCount=BSaleCount+{0}
where BID={1}", deta.BCount, deta.BID);
int count = DBHelp.MyExecuteNonQuery(sql, null);
return(count);
}
/// <summary>
/// 插入订单详细表
/// </summary>
/// <param name="listDeta"></param>
/// <returns></returns>
private static int AddOrderDetails(OrderDetails deta)
{
string sql = string.Format(@"insert into OrderDetails(OID,BID,BPrice,BCount)
values('{0}',{1},{2},{3})", deta.OID, deta.BID, deta.BPrice, deta.BCount);
int count = DBHelp.MyExecuteNonQuery(sql, null);
return(count);
}
private static int DeleteTrade(Order order, OrderDetails deta)
{
string sql = string.Format(@"delete Trade where BID={0} and MID={1}",
deta.BID, order.MID);
int count = DBHelp.MyExecuteNonQuery(sql, null);
return(count);
}
/// <summary>
/// 根据id删除购物车
/// </summary>
/// <param name="TID"></param>
/// <returns></returns>
public static int DeleteByTID(int TID)
{
SqlParameter[] pare = new SqlParameter[]
{
new SqlParameter("@TID", TID)
};
return(DBHelp.MyExecuteNonQuery("delete from Trade where TID=@TID", pare));
}
/// <summary>
/// 插入订单表
/// </summary>
/// <returns></returns>
private static int AddOrders(Order order)
{
//--1>.插入订单表
string sql = string.Format(@"insert into Orders(OID,MID,ODate,OConsignee,OAddress,OTelephone,OSumPrice,OState)
values('{0}',{1},'{2}','{3}','{4}','{5}',{6},{7})", order.OID, order.MID, order.ODate, order.OConsignee, order.OAddress, order.OTelephone, order.OSumPrice, order.OState);
int count = DBHelp.MyExecuteNonQuery(sql, null);
return(count);
}
/// <summary>
/// 修改库存
/// </summary>
/// <param name="number"></param>
/// <param name="bid"></param>
/// <returns>影响行数</returns>
public static int updateBcountByid(int number, int bid)
{
String sql = string.Format("update Book set BCount-=@number where BID=@bid");
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("@number", number),
new SqlParameter("@bid", bid)
};
return(DBHelp.MyExecuteNonQuery(sql, sp));
}
/// <summary>
/// 修改Bcount
/// </summary>
/// <param name="t"></param>
/// <returns></returns>
public static int update_Bcount(Trade t)
{
String sql = string.Format("update Trade set BCount+=@BCount where MID=@MID and BID=@BID");
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("@BCount", t.BCount),
new SqlParameter("@MID", t.MID),
new SqlParameter("@BID", t.BID),
};
return(DBHelp.MyExecuteNonQuery(sql, sp));
}
/// <summary>
/// 修改数量
/// </summary>
/// <returns></returns>
public static int UpdateByTID(int TID, int BCount)
{
SqlParameter[] pare = new SqlParameter[]
{
new SqlParameter("@TID", TID),
new SqlParameter("@BCount", BCount)
};
string sql = "update Trade set BCount=@BCount where BID=@TID";
return(DBHelp.MyExecuteNonQuery(sql, pare));
}
/// <summary>
/// 添加到购物车
/// </summary>
/// <returns></returns>
public static int addTrade(int BID, int MID, int number)
{
SqlParameter[] sp = new SqlParameter[] {
new SqlParameter("@BID", BID),
new SqlParameter("@MID", MID),
new SqlParameter("@number", number)
};
string sql = string.Format("insert into Trade values(@BID,@MID,@number)");
return(DBHelp.MyExecuteNonQuery(sql, sp));
}
/// <summary>
/// 注册新用户
/// </summary>
/// <returns></returns>
public static int add(Member m)
{
string sql = string.Format("insert into Member values(@name,@email,@pwd)");
SqlParameter[] pare = new SqlParameter[]
{
new SqlParameter("@name", m.MName),
new SqlParameter("@email", m.MEmail),
new SqlParameter("@pwd", m.MPassword)
};
int count = DBHelp.MyExecuteNonQuery(sql, pare);
return(count);
}
/// <summary>
/// 添加订单
/// </summary>
/// <param name="o"></param>
/// <returns></returns>
public static int addOrderDetails(OrderDetails o)
{
string sql = string.Format("insert into OrderDetails values('{0}',{1},{2},{3})", o.OID, o.BID, o.BPrice, o.BCount);
return(DBHelp.MyExecuteNonQuery(sql, null));
}
/// <summary>
/// 根据订单号修改订单状态
/// </summary>
/// <returns></returns>
public static int updateStateByOID(string OID)
{
string sql = string.Format("update Orders set OState=OState+1 where OID='{0}'", OID);
return(DBHelp.MyExecuteNonQuery(sql, null));
}
/// <summary>
/// 添加入订单表
/// </summary>
/// <param name="o"></param>
/// <returns></returns>
public static int addOrders(Order o)
{
string sql = string.Format("insert into Orders values('{0}',{1},getdate(),'{2}','{3}','{4}',{5},{6})", o.OID, o.MID, o.OConsignee, o.OAddress, o.OTelephone, o.OSumPrice, o.OState);
return(DBHelp.MyExecuteNonQuery(sql, null));
}
/// <summary>
/// 根据书籍id修改书籍信息
/// </summary>
/// <param name="b"></param>
/// <returns></returns>
public static int update(Book b)
{
string sql = string.Format("update Book set BSID={0},BName='{1}',BAuthor='{2}',BISBN='{3}',BPic='{4}',BPrice={5},BCount={6} where BID={7}", b.BSID, b.BName, b.BAuthor, b.BISBN, b.BPic, b.BPrice, b.BCount, b.BID);
return(DBHelp.MyExecuteNonQuery(sql, null));
}
/// <summary>
/// 添加图书
/// </summary>
/// <param name="b"></param>
/// <returns></returns>
public static int addBook(Book b)
{
string sql = string.Format("insert into Book values({0},'{1}','{2}','{3}','','','{4}',{5},{6},getdate(),{7})", b.BSID, b.BName, b.BAuthor, b.BISBN, b.BPic, b.BPrice, b.BCount, b.BSaleCount);
return(DBHelp.MyExecuteNonQuery(sql, null));
}
/// <summary>
/// 根据书籍id删除书籍
/// </summary>
/// <param name="BID"></param>
/// <returns></returns>
public static int delete(int BID)
{
return(DBHelp.MyExecuteNonQuery(string.Format("delete from Book where BID={0}", BID), null));
}
