MES_Client/TGMES/Core.StlMes.Client.Sale.BLL.SaleBusinessMgt/Plan/SlmOrderResourceSendBll.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Collections;
using System.ComponentModel;
using System.Drawing;
using System.Windows.Forms;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;

namespace Core.StlMes.Client.Sale.BLL.SaleBusinessMgt.Plan
{
    public class SlmOrderResourceSendBll : SaleBusinessMgt.BllBase.BaseBll
    {

        public SlmOrderResourceSendBll(OpeBase ob)
            : base(ob)
        {
           
        }

        /// <summary>
        /// 查询合同行入口
        /// </summary>
        /// <param name="sqlCondition"></param>
        /// <returns></returns>
        private DataSet GetSlmOrderLine(string sqlCondition)
        {
            string str = " and (b.order_ln_status = '5' or b.order_ln_status = '6' or b.order_ln_status = '7')";
            string sqlStr = string.Format(SqlCollection.Plan.QUERY_SEND_INFO, sqlCondition + str, base.DateTimeTocharFormat);
            return base.ExecuteQuery(sqlStr);
        }

        /// <summary>
        /// 查询正式生效和已下发订单
        /// </summary>
        /// <returns></returns>
        public DataSet GetPassSlmOrderInfo()
        {
            return GetSlmOrderLine("");
        }

        /// <summary>
        /// 根据合同号查询
        /// </summary>
        /// <param name="orderNo"></param>
        /// <returns></returns>
        public DataSet GetSlmOrderSendInfoByOrderNo(string orderNo)
        {
            string sqlCondition = string.Format(" and b.order_no = '{0}'",orderNo);
            return GetSlmOrderLine(sqlCondition);
        }

        /// <summary>
        /// 根据下发轮次查询
        /// </summary>
        /// <param name="sendRound"></param>
        /// <returns></returns>
        public DataSet GetSlmOrderSendInfoBySendRound(string sendRound)
        {
            string sqlCondition = string.Format(" and b.send_round = '{0}'", sendRound);
            return GetSlmOrderLine(sqlCondition);
        }

        /// <summary>
        /// 根据产线查询
        /// </summary>
        /// <param name="prodLine"></param>
        /// <returns></returns>
        public DataSet GetSlmOrderSendInfoByProdLine(string prodLine)
        {
            string sqlCondition = string.Format(" and b.prod_line = '{0}'", prodLine);
            return GetSlmOrderLine(sqlCondition);
        }

        /// <summary>
        /// 根据开始时间到结束时间查询合同
        /// </summary>
        /// <param name="orderBdate"></param>
        /// <param name="orderEdate"></param>
        /// <returns></returns>
        public DataSet GetSlmOrderSendByBigindateToEeddate(DateTime orderBdate, DateTime orderEdate)
        {
            string sqlCondition = Util.ConverObject.ConvertDateTimeValueToDbLanguage("order_bdate", orderBdate, orderEdate);
            return GetSlmOrderLine(sqlCondition);
        }

        /// <summary>
        /// 资源计划下发
        /// </summary>
        /// <param name="list"></param>
        /// <param name="errMsg"></param>
        public void OrderSend(string orderNo,string orderSeq, out string errMsg)
        {
            errMsg = "";
            CoreClientParam param = base.GetCoreClientParam(_ServerName, "orderSend", new object[] { orderNo,orderSeq });
            CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
            errMsg = base.GetReturnErrorInfo(result);
        }

        /// <summary>
        /// 资源计划取消下发
        /// </summary>
        /// <param name="list"></param>
        /// <param name="errMsg"></param>
        public void OrderUnSend(string orderNo, string orderSeq, out string errMsg)
        {
            errMsg = "";
            CoreClientParam param = base.GetCoreClientParam(_ServerName, "orderUnSend", new object[] { orderNo, orderSeq });
            CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
            errMsg = base.GetReturnErrorInfo(result);
        }

        /// <summary>
        /// 保存下发轮次
        /// </summary>
        /// <param name="list"></param>
        /// <param name="errMsg"></param>
        public void SendRoundSave(ArrayList list, out string errMsg)
        {
            errMsg = "";
            CoreClientParam param = base.GetCoreClientParam(_ServerName, "sendRoundSave", new object[] { list });
            CoreClientParam result = base.fr.ExecuteNonQuery(param, CoreInvokeType.Internal);
            errMsg = base.GetReturnErrorInfo(result);
        }

        private string _ServerName = "core.stlmes.server.sale.service.plan.SlmOrderResourceSend";
    }
}