当前文件路径：ClothesShop/IDAL/Iorder.cs

		            
 1using System;
 2using System.Collections.Generic;
 3using System.Text;
 4using System.Data;
 5using System.Data.OleDb;
 6namespace ClothesShop.IDAL
 7...{
 8    public interface Iorder
 9    ...{
10        /**//// <summary>
11        /// 添加一条订单纪录
12        /// </summary>
13        /// <param name="orderid">订单号</param>
14        /// <param name="productid">商品号</param>
15        /// <param name="userid">用户编号</param>
16        /// <param name="acceptname">收货人</param>
17        /// <param name="address">收货地址</param>
18        /// <param name="postalcode">邮政编码</param>
19        /// <param name="phone">联系电话</param>
20        /// <param name="delivery">送货方式</param>
21        /// <param name="payment">付款方式</param>
22        /// <param name="state">订单状态</param>
23        /// <param name="ordertime">下单时间</param>
24        /// <param name="orderprice">订单总额</param>
25        /// <returns></returns>
26        int createorder(string orderid, string productid, int userid, string acceptname,
27            string address, string postalcode, string phone, string delivery, string payment, int state, DateTime ordertime, double orderprice);
28
29        /**//// <summary>
30        /// 更新订单状态
31        /// </summary>
32        /// <param name="orderid">订单号</param>
33        /// <param name="state">订单状态</param>
34        /// <returns></returns>
35        int updatestate(string orderid,int state);
36
37        /**//// <summary>
38        /// 根据条件查询订单纪录
39        /// </summary>
40        /// <param name="username">用户名</param>
41        /// <param name="ordertime">下单时间</param>
42        /// <param name="state">订单状态</param>
43        /// <returns></returns>
44        DataTable selectorderlist(string username,string ordertime,int state);
45
46        /**//// <summary>
47        /// 根据条件查询订单纪录
48        /// </summary>
49        /// <param name="state">订单状态</param>
50        /// <returns></returns>
51        DataTable selectorderlist(int state);
52
53        DataTable selectorderlist(string username,int state);
54
55        /**//// <summary>
56        /// 根据用户ID获得订单列表
57        /// </summary>
58        /// <param name="userid"></param>
59        /// <returns></returns>
60        DataTable getordersbyuserid(int userid);
61
62        /**//// <summary>
63        /// 获得一条订单信息
64        /// </summary>
65        /// <param name="orderid"></param>
66        /// <returns></returns>
67        DataRow getoneorder(string orderid);
68    }
69}
70