IDAL/Iorder.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
namespace ClothesShop.IDAL
{
    public interface Iorder
    {
        /// <summary>
        /// 添加一条订单纪录
        /// </summary>
        /// <param name="orderid">订单号</param>
        /// <param name="productid">商品号</param>
        /// <param name="userid">用户编号</param>
        /// <param name="acceptname">收货人</param>
        /// <param name="address">收货地址</param>
        /// <param name="postalcode">邮政编码</param>
        /// <param name="phone">联系电话</param>
        /// <param name="delivery">送货方式</param>
        /// <param name="payment">付款方式</param>
        /// <param name="state">订单状态</param>
        /// <param name="ordertime">下单时间</param>
        /// <param name="orderprice">订单总额</param>
        /// <returns></returns>
        int createorder(string orderid, string productid, int userid, string acceptname,
            string address, string postalcode, string phone, string delivery, string payment, int state, DateTime ordertime, double orderprice);

        /// <summary>
        /// 更新订单状态
        /// </summary>
        /// <param name="orderid">订单号</param>
        /// <param name="state">订单状态</param>
        /// <returns></returns>
        int updatestate(string orderid,int state);

        /// <summary>
        /// 根据条件查询订单纪录
        /// </summary>
        /// <param name="username">用户名</param>
        /// <param name="ordertime">下单时间</param>
        /// <param name="state">订单状态</param>
        /// <returns></returns>
        DataTable selectorderlist(string username,string ordertime,int state);

        /// <summary>
        /// 根据条件查询订单纪录
        /// </summary>
        /// <param name="state">订单状态</param>
        /// <returns></returns>
        DataTable selectorderlist(int state);

        DataTable selectorderlist(string username,int state);

        /// <summary>
        /// 根据用户ID获得订单列表
        /// </summary>
        /// <param name="userid"></param>
        /// <returns></returns>
        DataTable getordersbyuserid(int userid);