/**  
* IEC_OrderBasicDAL.cs
*
* 功 能： 订单主表数据访问接口
* 类 名： IEC_OrderBasicDAL
*
* Ver    变更日期             负责人  变更内容
* ───────────────────────────────────
* V0.01  2013-4-23 10:55:24    吴崎均  初版
* V0.02  2013-5-6  9:08        吴崎均  增加分页方法(调用订单专用分页存储)
* V0.03  2013-5-10 16:33       吴崎均  增加方法:发起订单属性改变请求、执行订单属性改变请求
* V0.04  2013-5-11 13:21       吴崎均  增加方法:根据接手人查询属性变更请求集合
* V0.05  2013-5-11 14:13       吴崎均  增加方法:答复订单属性改变请求
* V0.06  2013-5-14 11:38       吴崎均  增加方法:根据卖家编号加载下一订单编号方法
* V0.07  2013-5-15 15:19       吴崎均  增加方法:根据编号获取订单信息
* V0.08  2013-5-17 11:07       吴崎均  增加方法:送货(含送货订单操作)
* V0.09  2013-5-17 14:21       吴崎均  增加方法:根据编号获取货运信息，根据订单编号获取订单操作信息集合 
* V0.10  2013-5-20 9:47        吴崎均  增加方法:根据订单编号获取收货地址信息
* V0.11  2013-5-28 13:43       吴崎均  修改批量删除方法定义及实现
* V0.12  2013-5-30 10:28       吴崎均  增加方法:预付款收/付款
* V0.13  2013-5-31 19:01       吴崎均  增加方法:根据订单编号确认收货
*
*/
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY.IBaseDAL;
using CY.Infrastructure.Query;
using CY.Model;

namespace CY.IDAL
{
    /// <summary>
    /// 订单主表-数据库操作接口
    /// </summary>
    public interface IEC_OrderBasicDAL : ICommonDAL, IPaging<EC_OrderBasic>, IGetAllModel<EC_OrderBasic>
    {
        /// <summary>
        /// 分页查询(根据联系人和结束状态)
        /// </summary>
        /// <param name="pagination">分页对象</param>
        /// <param name="searchParam">查询参数</param>
        /// <returns>查询结果 传入参数错误时结果为空</returns>
        IEnumerable<EC_OrderBasic> SelectModelPage(Infrastructure.Query.Pagination pagination, Dictionary<int, object> searchParam);


        /// <summary>
        /// 分页查询(未完工订单)
        /// </summary>
        /// <param name="pagination">分页对象</param>
        /// <param name="searchParam">查询参数</param>
        /// <returns>查询结果 传入参数错误时结果为空</returns>
        IEnumerable<EC_OrderBasic> SelectModelPage_weiwangong(Query query, Pagination pagination);

        /// <summary>
        /// 分页查询(根据联系人和结束状态)厂商订单，根据区域以及客户、业务经理查询
        /// </summary>
        /// <param name="pagination">分页对象</param>
        /// <param name="searchParam">查询参数</param>
        /// <returns>查询结果 传入参数错误时结果为空</returns>
        IEnumerable<EC_OrderBasic> SelectModelPage_Seller(Infrastructure.Query.Pagination pagination, Dictionary<int, object> searchParam);

        /// <summary>
        /// 生产安排分页查询
        /// </summary>
        /// <param name="pagination">分页对象</param>
        /// <param name="searchParam">查询参数</param>
        /// <returns>查询结果 传入参数错误时结果为空</returns>
        IEnumerable<EC_OrderBasic> SelectModelPageAg(Infrastructure.Query.Pagination pagination, Dictionary<int, object> searchParam);

        IEnumerable<EC_OrderBasic> SelectModelPageSeal(Infrastructure.Query.Pagination pagination, Dictionary<int, object> searchParam);


        /// <summary>
        /// 作业本送货分页查询
        /// </summary>
        /// <param name="pagination"></param>
        /// <returns></returns>
        IEnumerable<EC_OrderBasic> SelectModelPageWorkBook(Infrastructure.Query.Pagination pagination, Guid _MemberID, string txtBeginDate, string txtEndDate, string txtOrderId, string txtSearchyjname, string selCustormerManager, string selBusinessManager, string selOrderStates);


        /// <summary>
        /// 受理订单
        /// </summary>
        /// <param name="orderId">订单编号</param>
        /// <param name="commission">受理佣金(受理订单时站方收取的服务费)</param>
        /// <returns></returns>
        bool AcceptOrder(int orderId, double commission);

        /// <summary>
        /// 受理订单
        /// </summary>
        /// <param name="orderId">订单编号</param>
        /// <param name="operator">操作人</param>
        /// <returns></returns>
        bool SuodingOrder(int orderId, string operater);

        /// <summary>
        /// 批量受理订单
        /// </summary>
        /// <param name="orderIds"></param>
        /// <param name="commission"></param>
        /// <returns></returns>
        bool AcceptOrderAll(string orderIds, double commission);

        /// <summary>
        /// 修改订单状态(非支付状态且不可修改为未受理和已受理)
        /// </summary>
        /// <param name="orderOperate">订单操作</param>
        /// <returns></returns>
        bool UpdateOrderState(params  EC_OrderOperate[] orderOperates);

        ///// <summary>
        ///// 修改订单状态(非支付状态且不可修改为未受理和已受理)
        ///// </summary>
        ///// <param name="orderOperate">订单操作</param>
        ///// <param name="stateId">状态编号</param>
        ///// <returns></returns>
        //bool UpdateOrderState(EC_OrderOperate orderOperate, int stateId);

        /// <summary>
        /// 根据编号批量删除数据
        /// </summary>
        /// <param name="currentOperator">当前操作人</param>
        /// <param name="ids">编号集合</param>
        /// <returns></returns>
        bool DeleteDataByIds(string currentOperator, params int[] ids);

        /// <summary>
        /// 根据卖家编号加载下一订单编号方法
        /// </summary>
        /// <param name="memberId">卖家编号</param>
        /// <returns></returns>
        string LoadOrderIdBySellerId(Guid memberId);

        /// <summary>
        /// 根据编号获取订单信息
        /// </summary>
        /// <param name="orderId">订单唯一编号</param>
        /// <returns></returns>
        EC_OrderBasic SelectModelById(int orderId);

        /// <summary>
        /// 根据订单编号获取订单 
        /// </summary>
        /// <param name="orderIds">订单编号</param>
        /// <returns></returns>
        IEnumerable<EC_OrderBasic> GetOrderByIds(string orderIds);

        /// <summary>
        /// 发起订单属性改变请求
        /// </summary>
        /// <param name="dialogue">请求</param>
        /// <returns></returns>
        int OrderPropertyChangeRequest(EC_OrderDialogue dialogue);

        /// <summary>
        /// 执行订单属性改变请求
        /// </summary>
        /// <param name="requestId">要执行的目标数据</param>
        /// <param name="memberId">执行者</param>
        /// <returns></returns>
        int OrderPropertyChangeExecute(Guid requestId, Guid memberId);

        /// <summary>
        /// 根据接手人查询属性变更请求集合
        /// </summary>
        /// <param name="memberId">接手用户</param>
        /// <returns></returns>
        IEnumerable<EC_OrderDialogue> SelectPropertyChangeRequest(Guid memberId);

        /// <summary>
        /// 答复订单属性改变请求
        /// </summary>
        /// <param name="requestId">要答复的目标数据</param>
        /// <param name="memberId">答复人</param>
        /// <param name="isAllow">是否同意</param>
        /// <returns></returns>
        int OrderPropertyChangeReply(Guid requestId, Guid memberId, bool isAllow);

        /// <summary>
        /// 送货
        /// </summary>
        /// <param name="awbInfo">货运信息</param>
        /// <returns></returns>
        bool DeliverPresswork(EC_AwbInfo awbInfo);

        /// <summary>
        /// 根据编号获取货运信息
        /// </summary>
        /// <param name="orderId">订单编号</param>
        /// <returns></returns>
        EC_AwbInfo SelectAwbInfoById(int orderId);

        /// <summary>
        /// 根据订单编号获取订单操作信息
        /// </summary>
        /// <param name="orderId">订单编号</param>
        /// <returns></returns>
        IEnumerable<EC_OrderOperate> SelectOrderOperates(int orderId);

        /// <summary>
        /// 根据订单编号获取收货地址信息
        /// </summary>
        /// <param name="orderIds">订单编号集合</param>
        /// <returns></returns>
        IEnumerable<EC_AcceptWayByOrder> SelectOrderAddress(string orderIds);

        /// <summary>
        /// 收款(线下转账、现金)
        /// </summary>
        /// <param name="orderId">订单编号</param>
        /// <param name="firmAccountRecord">操作记录</param>
        /// <returns></returns>
        bool ReceiveMoneyToAccount(int orderId, OA_FirmAccountRecord firmAccountRecord);


        /// <summary>
        /// 收款(线下转账、现金)
        /// </summary>
        /// <param name="orderId">订单编号</param>
        /// <param name="firmAccountRecord">操作记录</param>
        /// <returns></returns>
        bool ReceiveMoneyToQueren(int orderId, OA_FirmAccountRecord firmAccountRecord);


        /// <summary>
        /// 收款(外协预付款、客户预付款)
        /// </summary>
        /// <param name="sellerId">卖家</param>
        /// <param name="buyerId">买家</param>
        /// <param name="orderId">订单编号</param>
        /// <param name="money">金额</param>
        /// <param name="operatTypeId">操作类型编号(2:预付款,3普通付款)</param>
        /// <param name="subjectName">支付科目(订单付款,外协付款)</param>
        /// <param name="currentOperator">操作人</param>
        /// <returns></returns>
        bool ReceiveMoney(Guid sellerId, Guid buyerId, int orderId, decimal money, int operatTypeId, string subjectName, string currentOperator);

        /// <summary>
        /// 根据订单编号确认收货
        /// </summary>
        /// <param name="orderId">订单编号</param>
        /// <param name="memberId">买家编号</param>
        /// <returns></returns>
        bool ConfirmAcceptById(int orderId, Guid memberId);

        /// <summary>
        /// 根据编号获取订单列表
        /// </summary>
        /// <param name="Keyids"></param>
        /// <param name="FirmId"></param>
        /// <returns></returns>
        IEnumerable<Model.EC_OrderBasic> GetEC_OrderBasicListByKeyid(string Keyids, Guid FirmId);

        /// <summary>
        /// 订单完工
        /// </summary>
        /// <param name="m_EC_OrderOperateList"></param>
        /// <param name="m_EC_OrderBasicList"></param>
        /// <returns></returns>
        bool CompletedOrderList(List<EC_OrderOperate> m_EC_OrderOperateList, List<EC_OrderBasic> m_EC_OrderBasicList);

        /// <summary>
        /// 卖家退单操作
        /// </summary>
        /// <param name="orderId"></param>
        /// <param name="retireMony"></param>
        /// <param name="operatorName"></param>
        /// <returns></returns>
        int RetireOrderBySeller(int orderId, decimal retireMony, string operatorName);

        /// <summary>
        /// 判断是否已经操作
        /// </summary>
        /// <param name="keyid"></param>
        /// <param name="orderState"></param>
        /// <param name="opType"></param>
        /// <returns></returns>
        bool IsOpearted(int keyid, int orderState, string opType);

        /// <summary>
        /// 修改打印状态
        /// </summary>
        /// <param name="orderId"></param>
        void UpdatePrintState(int orderId);


        /// <summary>
        /// 修改金额和单价
        /// </summary>
        /// <param name="orderId"></param>
        /// <param name="SumPrice"></param>
        /// <param name="UnitPrice"></param>
        bool Updatejinedanjia(int orderId,decimal SumPrice, decimal UnitPrice,int num);

        /// <summary>
        /// 修改打印状态
        /// </summary>
        /// <param name="orderId"></param>
        void UpdatePrintfengqianState(int orderId);

        void UpdatePrintBiaoqianState(int orderId);

        /// <summary>
        /// 查询后道(3)整单(4)
        /// </summary>
        /// <param name="pagination"></param>
        /// <param name="MemberId"></param>
        /// <param name="StartCreatTime"></param>
        /// <param name="EndCreatTime"></param>
        /// <param name="StartReturnTime"></param>
        /// <param name="EndReturnTime"></param>
        /// <param name="Creater"></param>
        /// <param name="OutFirm"></param>
        /// <param name="WorkStates"></param>
        /// <param name="OutOrderId"></param>
        /// <param name="RelationType"></param>
        /// <param name="PayState"></param>
        /// <returns></returns>
        IEnumerable<EC_OrderBasic> SelectAferOfOutOrder(Infrastructure.Query.Pagination pagination, Guid MemberId, DateTime? StartCreatTime, DateTime? EndCreatTime, DateTime? StartReturnTime, DateTime? EndReturnTime, string Creater, string OutFirm, string WorkStates, string OutOrderId, int? RelationType, string PayState = null);

        /// <summary>
        /// 分页查询外协订单(根据联系人和结束状态)
        /// </summary>
        /// <param name="pagination">分页对象</param>
        /// <param name="searchParam">查询参数</param>
        /// <returns>查询结果 传入参数错误时结果为空</returns>
        IEnumerable<EC_OrderBasic> SelectModelPage_Outsource(Infrastructure.Query.Pagination pagination, Dictionary<int, object> searchParam);

        /// <summary>
        /// 判断某订单是否是另一订单的自动外协订单
        /// </summary>
        /// <param name="orderId"></param>
        /// <returns></returns>
        bool IsOutOrder(int orderId);

        /// <summary>
        /// 自动外协订单
        /// </summary>
        /// <param name="OLD_orderBasic"></param>
        /// <param name="orderBasic"></param>
        /// <param name="acceptWayByOrder"></param>
        /// <param name="orderPrintParameter"></param>
        /// <param name="m_EC_OrderOperate"></param>
        /// <param name="RelationTypeid"></param>
        /// <param name="commission"></param>
        /// <param name="payRequest"></param>
        /// <returns></returns>
        bool AutoOutOrder(EC_OrderBasic OLD_orderBasic, EC_OrderBasic orderBasic, EC_AcceptWayByOrder acceptWayByOrder, EC_OrderPrintParameter orderPrintParameter, EC_OrderOperate m_EC_OrderOperate, int? RelationTypeid, double commission, CY.Model.Pay.Pay_Request payRequest);

        /// <summary>
        /// 根据订单编号获取自动外协订单
        /// </summary>
        /// <param name="orderId">订单编号</param>
        /// <returns></returns>
        EC_OrderBasic SelectOutOrderById(int orderId);

        /// <summary>
        /// 根据自动外协订单编号获取来源订单
        /// </summary>
        /// <param name="orderId">订单编号</param>
        /// <returns></returns>
        EC_OrderBasic SelectFromOutOrderById(int orderId);

        /// <summary>
        /// WEB服务自动完成订单
        /// </summary>
        void AutoCompleteOrderByWebService();

        /// <summary>
        /// 删除外协订单
        /// </summary>
        /// <param name="OrderId"></param>
        /// <returns></returns>
        bool DeleteOutOrder(int OrderId);

        /// <summary>
        /// 修改原订单数量
        /// </summary>
        /// <param name="OrderId"></param>
        /// <returns></returns>
        bool UpdateOldOrderSurplusPrintNum(int outOrderId);

        /// <summary>
        /// 统计订单金额
        /// </summary>
        /// <param name="pagination">分页对象</param>
        /// <param name="searchParam">查询参数</param>
        /// <returns>查询结果 传入参数错误时结果为空</returns>
        EC_OrderBasic SumOrderMoney(Infrastructure.Query.Pagination pagination, Dictionary<int, object> searchParam);

        /// <summary>
        /// 统计订单金额
        /// </summary>
        /// <param name="pagination">分页对象</param>
        /// <param name="searchParam">查询参数</param>
        /// <returns>查询结果 传入参数错误时结果为空</returns>
        EC_OrderBasic SumOrderMoney_receive(Infrastructure.Query.Pagination pagination, Dictionary<int, object> searchParam);

        /// <summary>
        /// 根据新增订单操作，并修改订单状态
        /// </summary>
        /// <param name="orderOperate"></param>
        /// <returns></returns>
        bool UpdateOrderState(EC_OrderOperate orderOperate);

        /// <summary>
        /// 分页查询(根据联系人和结束状态)-订单收款去除已冻结订单
        /// </summary>
        /// <param name="pagination">分页对象</param>
        /// <param name="searchParam">查询参数</param>
        /// <returns>查询结果 传入参数错误时结果为空</returns>
        IEnumerable<EC_OrderBasic> SelectModelPage_Financial(Infrastructure.Query.Pagination pagination, Dictionary<int, object> searchParam);


        /// <summary>
        /// 修改打印状态
        /// </summary>
        /// <param name="orderId"></param>
        void UpdateDeliveryOrderId(int orderId, Guid DeliveryOrderId);



        /// <summary>
        /// 根据发货单id查询
        /// </summary>
        /// <param name="deliverorderId"></param>
        /// <param name="FirmId"></param>
        /// <returns></returns>
        IEnumerable<Model.EC_OrderBasic> GetEC_OrderBasicListBydeliverorderId(Guid deliverorderId, Guid FirmId);
    }
}