Example #1
0
 /// <summary>
 /// 表:BLCategory (添加一条数据
 /// </summary>
 /// <param name="bLCategory">添加的数据</param>
 /// <returns>执行成功的行数</returns>
 public static int Insert(BLCategory bLCategory)
 {
     return(DBHelp.ExecuteNonQuery(
                "insert into BLCategory values(@BLName)",
                new SqlParameter[] {
         new SqlParameter("@BLName", bLCategory.BLName)
     }));
 }
Example #2
0
 /// <summary>
 /// 表:BLCategory (根据BLID删除数据
 /// </summary>
 /// <param name="BLID">所需BLID</param>
 /// <returns>执行成功行数</returns>
 public static int Delete_BLID(int BLID)
 {
     return(DBHelp.ExecuteNonQuery(
                "delete from BLCategory where BLID=@BLID",
                new SqlParameter[] {
         new SqlParameter("@BLID", BLID)
     }));
 }
Example #3
0
 /// <summary>
 /// 表:Trade (根据MID删除数据
 /// </summary>
 /// <param name="MID">所需MID</param>
 /// <returns>执行成功的行数</returns>
 public static int Delelte_MID(int MID)
 {
     return(DBHelp.ExecuteNonQuery(
                "delete from trade where MID=@MID",
                new SqlParameter[] {
         new SqlParameter("@MID", MID)
     }));
 }
Example #4
0
 /// <summary>
 /// 表:Book (根据BID删除
 /// </summary>
 /// <param name="BID">所需BID</param>
 /// <returns>执行成功行数</returns>
 public static int Delete_BID(int BID)
 {
     return(DBHelp.ExecuteNonQuery(
                "delete from Book where BID=@BID",
                new SqlParameter[] {
         new SqlParameter("@BID", BID)
     }));
 }
Example #5
0
 /// <summary>
 /// 表:Trade (根据TID删除数据
 /// </summary>
 /// <param name="TID">所需TID</param>
 /// <returns>执行成功行数</returns>
 public static int Delete_TID(int TID)
 {
     return(DBHelp.ExecuteNonQuery(
                "Delete from Trade where TID=@TID",
                new SqlParameter[] {
         new SqlParameter("@TID", TID)
     }));
 }
Example #6
0
 /// <summary>
 /// 表:BLCategory (修改数据
 /// </summary>
 /// <param name="bLCategory">修改的数据</param>
 /// <returns>执行成功的行数</returns>
 public static int Update(BLCategory bLCategory)
 {
     return(DBHelp.ExecuteNonQuery(
                "update BLCategory set BLName=@BLName where BLID=@BLID",
                new SqlParameter[] {
         new SqlParameter("@BLName", bLCategory.BLName),
         new SqlParameter("@BLID", bLCategory.BLID),
     }));
 }
Example #7
0
 /// <summary>
 /// 表:Trade (根据TID修改BCount
 /// </summary>
 /// <param name="trade">修改的数据</param>
 /// <returns>执行成功的行数</returns>
 public static int Update_BCount(int BCount, int TID)
 {
     return(DBHelp.ExecuteNonQuery(
                "update Trade set BCount=@BCount where TID=@TID",
                new SqlParameter[] {
         new SqlParameter("@BCount", BCount),
         new SqlParameter("@TID", TID),
     }));
 }
Example #8
0
 /// <summary>
 /// 表:Order (根据OID修改OState
 /// </summary>
 /// <param name="OID">所需OID</param>
 /// <param name="OState">所需OState</param>
 /// <returns></returns>
 public static int UpdateOState_OID(string OID, int OState)
 {
     return(DBHelp.ExecuteNonQuery(
                "update  [Order] set OState=@OState where OID=@OID",
                new SqlParameter[] {
         new SqlParameter("@OState", OState),
         new SqlParameter("@OID", OID),
     }));
 }
Example #9
0
 /// <summary>
 /// 表:Trade (根据MID与BID修改
 /// </summary>
 /// <param name="trade">修改的数据</param>
 /// <returns>执行成功的行数</returns>
 public static int Update_BCount(Trade trade)
 {
     return(DBHelp.ExecuteNonQuery(
                "update Trade set BCount=BCount+@BCount where MID=@MID and BID=@BID",
                new SqlParameter[] {
         new SqlParameter("@BCount", trade.BCount),
         new SqlParameter("@MID", trade.MID),
         new SqlParameter("@BID", trade.BID),
     }));
 }
Example #10
0
 /// <summary>
 /// 表:Trade (添加数据
 /// </summary>
 /// <param name="trade">添加的数据</param>
 /// <returns>执行成功的行数</returns>
 public static int Insert(Trade trade)
 {
     return(DBHelp.ExecuteNonQuery(
                "insert into Trade values(@BID,@MID,@BCount)",
                new SqlParameter[] {
         new SqlParameter("@BID", trade.BID),
         new SqlParameter("@MID", trade.MID),
         new SqlParameter("@BCount", trade.BCount),
     }));
 }
Example #11
0
 /// <summary>
 /// 表:Member (添加注册用户信息
 /// </summary>
 /// <param name="member">注册用户</param>
 /// <returns>执行成功行数</returns>
 public static int Register(Member member)
 {
     return(DBHelp.ExecuteNonQuery(
                "insert into Member values(@MName,@MEmail,@MPassword)",
                new SqlParameter[] {
         new SqlParameter("@MName", member.MName),
         new SqlParameter("@Memail", member.MEmail),
         new SqlParameter("@MPassword", member.MPassword),
     }));
 }
Example #12
0
 /// <summary>
 /// 表:OrderDetails (添加一条数据
 /// </summary>
 /// <param name="orderDetail">添加的数据</param>
 /// <returns>执行成功的行数</returns>
 public static int Insert(OrderDetails orderDetail)
 {
     return(DBHelp.ExecuteNonQuery(
                "insert into OrderDetails values(@OID,@BID,@BPrice,@BCount)",
                new SqlParameter[] {
         new SqlParameter("@OID", orderDetail.OID),
         new SqlParameter("@BID", orderDetail.BID),
         new SqlParameter("@BPrice", orderDetail.BPrice),
         new SqlParameter("@BCount", orderDetail.BCount),
     }));
 }
Example #13
0
 /// <summary>
 /// 表:Book (根据BID修改BCount与BSaleCount
 /// </summary>
 /// <param name="book">修改的数据</param>
 /// <returns>执行成功的行数</returns>
 public static int Update_BCountAndBSaleCount(Book book)
 {
     if (Select_BCount(book.BID) > book.BCount)
     {
         return(DBHelp.ExecuteNonQuery(
                    "update Book set BCount=BCount-@BCount,BSaleCount=BSaleCount+@BCount where BID=@BID",
                    new SqlParameter[] {
             new SqlParameter("@BCount", book.BCount),
             new SqlParameter("@BID", book.BID)
         }));
     }
     return(0);
 }
Example #14
0
 /// <summary>
 /// 表:Order (添加一条数据
 /// </summary>
 /// <param name="order">添加的数据</param>
 /// <returns>执行成功的行数</returns>
 public static int Insert(Order order)
 {
     return(DBHelp.ExecuteNonQuery(
                "insert into [Order] values(@OID,@MID,@ODate,@OConsignee,@OAddress,@OTelephone,@OSumPrice,@OState)",
                new SqlParameter[] {
         new SqlParameter("@OID", order.OID),
         new SqlParameter("@MID", order.MID),
         new SqlParameter("@ODate", order.ODate),
         new SqlParameter("@OConsignee", order.OConsignee),
         new SqlParameter("@OAddress", order.OAddress),
         new SqlParameter("@OTelephone", order.OTelephone),
         new SqlParameter("@OSumPrice", order.OSumPrice),
         new SqlParameter("@OState", order.OState),
     }));
 }
Example #15
0
 /// <summary>
 /// 表:Book (根据BID修改数据
 /// </summary>
 /// <param name="book">修改的数据</param>
 /// <returns>执行成功的行数</returns>
 public static int Update_BID(Book book)
 {
     return(DBHelp.ExecuteNonQuery(
                "update Book set BSID=@BSID,BName=@BName,BAuthor=@BAuthor,BISBN=@BISBN,BTOC=@BTOC,BComment=@BComment,BPic=@BPic,BPrice=@BPrice,BCount=@BCount,BSaleCount=@BSaleCount where BID=@BID",
                new SqlParameter[] {
         new SqlParameter("@BSID", book.BSID),
         new SqlParameter("@BName", book.BName),
         new SqlParameter("@BAuthor", book.BAuthor),
         new SqlParameter("@BISBN", book.BISBN),
         new SqlParameter("@BTOC", book.BTOC),
         new SqlParameter("@BComment", book.BComment),
         new SqlParameter("@BPic", book.BPic),
         new SqlParameter("@BPrice", book.BPrice),
         new SqlParameter("@BCount", book.BCount),
         new SqlParameter("@BSaleCount", book.BSaleCount),
         new SqlParameter("@BID", book.BID)
     }));
 }
Example #16
0
 /// <summary>
 /// 表:Book (添加一条数据
 /// </summary>
 /// <param name="book">添加的数据</param>
 /// <returns>执行成功的行数</returns>
 public static int Insert(Book book)
 {
     return(DBHelp.ExecuteNonQuery(
                "insert into Book values(@BID,@BSID,@BName,@BAuthor,@BISBN,@BTOC,@BComment,@BPic,@BPrice,@BCount,@BDate,@BSaleCount)",
                new SqlParameter[] {
         new SqlParameter("@BID", book.BID),
         new SqlParameter("@BSID", book.BSID),
         new SqlParameter("@BName", book.BName),
         new SqlParameter("@BAuthor", book.BAuthor),
         new SqlParameter("@BISBN", book.BISBN),
         new SqlParameter("@BTOC", DBNull.Value),
         new SqlParameter("@BComment", DBNull.Value),
         new SqlParameter("@BPic", book.BPic),
         new SqlParameter("@BPrice", book.BPrice),
         new SqlParameter("@BCount", book.BCount),
         new SqlParameter("@BDate", book.BDate),
         new SqlParameter("@BSaleCount", book.BSaleCount),
     }));
 }