using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using ApServerProvider;
using System.Collections;
using System.Text;
using System.Data;
using DbCommon;
using Estsh.Web.Util;

/***************************************************************************************************
 * 
 * 作者：王勇
 * 
 * *************************************************************************************************/
namespace Estsh.Core.Repositories
{
    /// <summary>
    /// 目视单打印模块的业务数据
    /// </summary>
    public class ProdOrderReleaseDal : BaseApp
    {
        public ProdOrderReleaseDal(RemotingProxy remotingProxy)
            : base(remotingProxy)
        {
        }

        #region 目视单打印

        public Hashtable getStockOrderListByPage(int PageSize, int PageIndex, string cbCustPDLine, string str)
        {
            lock (_remotingProxy)
            {
                Hashtable result = new Hashtable();

                DynamicParameters parameters = new DynamicParameters();

                parameters.Add(new StoreProcedureParameter(DbType.Int32, ParameterDirection.Output, "@TotalCount", 100));
                parameters.Add(new StoreProcedureParameter(DbType.Int32, ParameterDirection.Output, "@TotalPage", 100));
                parameters.Add(new StoreProcedureParameter(DbType.String, ParameterDirection.Input, "@Table", " dbo.g_order AS a LEFT JOIN dbo.sys_part AS b ON a.model_part_id=b.part_id LEFT JOIN dbo.sys_model AS c ON b.model_id =c.model_id LEFT JOIN dbo.sys_model_type AS d ON c.model_type_id=d.type_id "));
                parameters.Add(new StoreProcedureParameter(DbType.String, ParameterDirection.Input, "@Column", " order_id,order_seq,b.part_no,b.part_spec2,car_no,vin,release_status,a.create_ymd,a.create_hms,b.part_class,d.type_name  "));
                parameters.Add(new StoreProcedureParameter(DbType.String, ParameterDirection.Input, "@OrderColumn", " a.order_seq   "));
                parameters.Add(new StoreProcedureParameter(DbType.String, ParameterDirection.Input, "@GroupColumn", ""));
                parameters.Add(new StoreProcedureParameter(DbType.Int32, ParameterDirection.Input, "@PageSize", PageSize));
                parameters.Add(new StoreProcedureParameter(DbType.Int32, ParameterDirection.Input, "@CurrentPage", PageIndex));
                parameters.Add(new StoreProcedureParameter(DbType.Int32, ParameterDirection.Input, "@Group", 0));
                parameters.Add(new StoreProcedureParameter(DbType.String, ParameterDirection.Input, "@Condition", " cust_pdline=" + cbCustPDLine + " AND release_status=0  "));

                Hashtable values = new Hashtable(2);

                DataTable dt = new DataTable();
                dt = _remotingProxy.ExecuteSotreProcedure("Com_Pagination", parameters, ref values);
                ArrayList dataList = DataTypeConvert.NewObject.DataTableToArrayList(dt);
                result.Add("dataList", dataList);
                result.Add("totalCount", values["@TotalCount"].ToString());

                return result;
            }
        }

        public Hashtable getStockOrderDetailByPage(int PageSize, int PageIndex, int order_id)
        {
            lock (_remotingProxy)
            {
                Hashtable result = new Hashtable();

                DynamicParameters parameters = new DynamicParameters();

                parameters.Add(new StoreProcedureParameter(DbType.Int32, ParameterDirection.Output, "@TotalCount", 100));
                parameters.Add(new StoreProcedureParameter(DbType.Int32, ParameterDirection.Output, "@TotalPage", 100));
                parameters.Add(new StoreProcedureParameter(DbType.String, ParameterDirection.Input, "@Table", " dbo.g_vw_order_detail AS a LEFT JOIN dbo.g_vw_order AS v ON a.order_id=v.order_id LEFT JOIN dbo.sys_part AS b ON b.part_id=v.model_part_id LEFT JOIN dbo.g_order_items AS e ON e.order_detail_id=a.ruid LEFT JOIN dbo.sys_part AS p ON e.part_no=p.part_no LEFT JOIN dbo.sys_model AS c ON c.model_id=b.model_id LEFT JOIN dbo.sys_model_type AS d ON c.model_type_id=d.type_id  "));
                parameters.Add(new StoreProcedureParameter(DbType.String, ParameterDirection.Input, "@Column", " p.part_no,p.part_spec,p.part_location ,d.type_name,RIGHT(p.cust_part_no,2) AS color "));
                parameters.Add(new StoreProcedureParameter(DbType.String, ParameterDirection.Input, "@OrderColumn", " p.part_location "));
                parameters.Add(new StoreProcedureParameter(DbType.String, ParameterDirection.Input, "@GroupColumn", ""));
                parameters.Add(new StoreProcedureParameter(DbType.Int32, ParameterDirection.Input, "@PageSize", PageSize));
                parameters.Add(new StoreProcedureParameter(DbType.Int32, ParameterDirection.Input, "@CurrentPage", PageIndex));
                parameters.Add(new StoreProcedureParameter(DbType.Int32, ParameterDirection.Input, "@Group", 0));
                parameters.Add(new StoreProcedureParameter(DbType.String, ParameterDirection.Input, "@Condition", " a.order_id=" + order_id));

                Hashtable values = new Hashtable(2);

                DataTable dt = new DataTable();
                dt = _remotingProxy.ExecuteSotreProcedure("Com_Pagination", parameters, ref values);
                ArrayList dataList = DataTypeConvert.NewObject.DataTableToArrayList(dt);
                result.Add("dataList", dataList);
                result.Add("totalCount", values["@TotalCount"].ToString());

                return result;
            }
        }



        public Hashtable updatePrintData(string order_id)
        {
            lock (_remotingProxy)
            {
                Hashtable result = new Hashtable();

                string SqlStrings = "";
                Hashtable Parameters = new Hashtable();

                Hashtable Params = new Hashtable(1);

                SqlStrings = ("   SELECT v.order_seq,v.car_no,v.vin, b.part_no,b.part_spec,p.part_location,o.enum_desc ,d.type_name,RIGHT(p.cust_part_no,2) AS color,dbo.get_ymd() AS date_ymd,"
                        + " (SUBSTRING(( SELECT CONVERT(VARCHAR(12), GETDATE(), 111)), 1, 4)+SUBSTRING(( SELECT CONVERT(VARCHAR(12), GETDATE(), 111)), 6, 2)+SUBSTRING(( SELECT CONVERT(VARCHAR(12), GETDATE(), 111)), 9, 2))"
                         + " AS order_number_1,CASE p.part_location WHEN '01' THEN 'A' WHEN '02' THEN 'B' WHEN '03' THEN 'C' WHEN '04' THEN '' END AS order_number_2 ,'车' AS car_name"
                        + " FROM dbo.g_vw_order_detail AS a LEFT JOIN dbo.g_vw_order AS v ON a.order_id=v.order_id LEFT JOIN dbo.sys_part AS b ON b.part_id=v.model_part_id "
                        + " LEFT JOIN dbo.sys_part AS p ON a.list_elno=p.part_no LEFT JOIN dbo.sys_enum AS o ON o.enum_value=p.part_location LEFT JOIN dbo.sys_model AS c ON c.model_id=b.model_id "
                         + " LEFT JOIN dbo.sys_model_type AS d ON c.model_type_id=d.type_id"
                + " WHERE a.order_id in (" + order_id + ") AND  enum_type='sys_part_location' ORDER BY part_location,a.order_id");
                Hashtable values = new Hashtable(2);

                DataTable dt = new DataTable();
                dt = _remotingProxy.GetDataTable(SqlStrings, Parameters);
                ArrayList dataList = DataTypeConvert.NewObject.DataTableToArrayList(dt);
                result.Add("dataList", dataList);

                return result;
            }
        }

        public DataTable updatePrintData_2(string order_id, string cbCustPDLine)
        {
            lock (_remotingProxy)
            {
                Hashtable result = new Hashtable();

                StringBuilder SqlStrings = new StringBuilder();
                Hashtable Parameters = new Hashtable();

                Hashtable Params = new Hashtable(1);

                SqlStrings.Append(" SELECT a.order_id,a.order_seq,a.vin,d.type_name,b.part_class,b.part_spec2,'FALSE' AS FALSE ,");
                SqlStrings.Append(" ( SUBSTRING(( SELECT    CONVERT(VARCHAR(12), GETDATE(), 111)), 1, 4)");
                SqlStrings.Append(" + SUBSTRING(( SELECT  CONVERT(VARCHAR(12), GETDATE(), 111)), 6, 2)");
                SqlStrings.Append(" + SUBSTRING(( SELECT  CONVERT(VARCHAR(12), GETDATE(), 111) ), 9, 2) ) AS order_number_1,dbo.get_ymd() AS date_ymd  FROM dbo.g_order AS a ");
                SqlStrings.Append(" LEFT JOIN dbo.sys_part AS b ON a.model_part_id=b.part_id");
                SqlStrings.Append(" LEFT JOIN dbo.sys_model AS c ON b.model_id=c.model_id");
                SqlStrings.Append(" LEFT JOIN dbo.sys_model_type AS d ON d.type_id=c.model_type_id");
                SqlStrings.Append(" WHERE  a.count=0 AND a.order_id in ( " + order_id + ") AND  a.cust_pdline= " + cbCustPDLine + "  ");
                SqlStrings.Append(" ORDER BY a.order_seq");
                Hashtable values = new Hashtable(2);

                DataTable dt = new DataTable();
                dt = _remotingProxy.GetDataTable(SqlStrings.ToString(), Parameters);
                //ArrayList dataList = DataTypeConvert.NewObject.DataTableToArrayList(dt);
                //result.Add("dataList", dataList);

                return dt;
            }
        }

        public DataTable getForPintData(string order_id, string cbCustPDLine)
        {
            lock (_remotingProxy)
            {
                Hashtable result = new Hashtable();

                StringBuilder SqlStrings = new StringBuilder();
                Hashtable Parameters = new Hashtable();

                Hashtable Params = new Hashtable(1);

                SqlStrings.Append(" SELECT a.order_id,a.order_seq,a.vin,d.type_name,b.part_class,b.part_spec2,'FALSE' AS FALSE ,");
                SqlStrings.Append(" ( SUBSTRING(( SELECT    CONVERT(VARCHAR(12), GETDATE(), 111)), 1, 4)");
                SqlStrings.Append(" + SUBSTRING(( SELECT  CONVERT(VARCHAR(12), GETDATE(), 111)), 6, 2)");
                SqlStrings.Append(" + SUBSTRING(( SELECT  CONVERT(VARCHAR(12), GETDATE(), 111) ), 9, 2) ) AS order_number_1,dbo.get_ymd() AS date_ymd  FROM dbo.g_order AS a ");
                SqlStrings.Append(" LEFT JOIN dbo.sys_part AS b ON a.model_part_id=b.part_id");
                SqlStrings.Append(" LEFT JOIN dbo.sys_model AS c ON b.model_id=c.model_id");
                SqlStrings.Append(" LEFT JOIN dbo.sys_model_type AS d ON d.type_id=c.model_type_id");
                SqlStrings.Append(" WHERE  a.order_id in ( " + order_id + ") AND  a.cust_pdline= " + cbCustPDLine + "  ");
                SqlStrings.Append(" ORDER BY a.order_seq");
                Hashtable values = new Hashtable(2);

                DataTable dt = new DataTable();
                dt = _remotingProxy.GetDataTable(SqlStrings.ToString(), Parameters);
                //ArrayList dataList = DataTypeConvert.NewObject.DataTableToArrayList(dt);
                //result.Add("dataList", dataList);

                return dt;
            }
        }

        public DataTable getTopOrderBy(string step, string cbCustPDLine)
        {
            lock (_remotingProxy)
            {
                Hashtable result = new Hashtable();

                StringBuilder SqlStrings = new StringBuilder();
                Hashtable Parameters = new Hashtable();

                Hashtable Params = new Hashtable(1);

                SqlStrings.Append(" SELECT top " + step + " a.order_id,a.order_seq,a.vin,d.type_name,b.part_class,'FALSE' AS FALSE ,");
                SqlStrings.Append(" ( SUBSTRING(( SELECT    CONVERT(VARCHAR(12), GETDATE(), 111)), 1, 4)");
                SqlStrings.Append(" + SUBSTRING(( SELECT  CONVERT(VARCHAR(12), GETDATE(), 111)), 6, 2)");
                SqlStrings.Append(" + SUBSTRING(( SELECT  CONVERT(VARCHAR(12), GETDATE(), 111) ), 9, 2) ) AS order_number_1,dbo.get_ymd() AS date_ymd  FROM dbo.g_order AS a ");
                SqlStrings.Append(" LEFT JOIN dbo.sys_part AS b ON a.model_part_id=b.part_id");
                SqlStrings.Append(" LEFT JOIN dbo.sys_model AS c ON b.model_id=c.model_id");
                SqlStrings.Append(" LEFT JOIN dbo.sys_model_type AS d ON d.type_id=c.model_type_id");
                SqlStrings.Append(" WHERE  a.count=0  AND  a.cust_pdline= " + cbCustPDLine + "  ");
                SqlStrings.Append(" ORDER BY a.order_seq");
                Hashtable values = new Hashtable(2);

                DataTable dt = new DataTable();
                dt = _remotingProxy.GetDataTable(SqlStrings.ToString(), Parameters);
                //ArrayList dataList = DataTypeConvert.NewObject.DataTableToArrayList(dt);
                //result.Add("dataList", dataList);

                return dt;
            }
        }

        public DataTable getOrderByTraySeq(string traySeq, string cbCustPDLine)
        {
            lock (_remotingProxy)
            {
                Hashtable result = new Hashtable();

                StringBuilder SqlStrings = new StringBuilder();
                Hashtable Parameters = new Hashtable();

                Hashtable Params = new Hashtable(1);

                SqlStrings.Append(" SELECT DISTINCT order_id FROM dbo.g_order_detail WHERE tray_no='" + traySeq + "' ORDER BY order_id");
                Hashtable values = new Hashtable(2);

                DataTable dt = new DataTable();
                dt = _remotingProxy.GetDataTable(SqlStrings.ToString(), Parameters);
                //ArrayList dataList = DataTypeConvert.NewObject.DataTableToArrayList(dt);
                //result.Add("dataList", dataList);

                return dt;
            }
        }

        public int GetPartID(string partNO)
        {
            lock (_remotingProxy)
            {
                string SqlString =
                    "SELECT  part_id FROM dbo.sys_part WHERE part_no=@part_no AND enabled='Y' ";

                Hashtable Params = new Hashtable(1);

                Params.Add("@part_no", partNO);

                object obj = _remotingProxy.GetScalar(SqlString, Params);

                return obj == null ? 0 : Convert.ToInt32(obj);
            }
        }

        public int CustPartID(string partNO)
        {
            lock (_remotingProxy)
            {
                string SqlString =
                    "  select top 1  c.part_id from g_part_relation as a left join sys_part as c on c.model_id=a.model_id where a.cust_part_no='" + partNO + "' ";

                Hashtable Params = new Hashtable(1);

                Params.Add("@part_no", partNO);

                object obj = _remotingProxy.GetScalar(SqlString, Params);

                return obj == null ? 0 : Convert.ToInt32(obj);
            }
        }

        public string getOCN(string ocn)
        {
            lock (_remotingProxy)
            {
                string SqlString =
                    "  SELECT b.part_no FROM sys_ocn AS a  LEFT JOIN dbo.sys_part AS b ON a.model_name=b.part_no WHERE ocn='" + ocn + "'";

                object obj = _remotingProxy.GetScalar(SqlString);

                return obj == null ? "" : Convert.ToString(obj);
            }
        }

        public string getPartName(string custPartNo)
        {
            lock (_remotingProxy)
            {
                StringBuilder SqlStringBuilder = new StringBuilder(1024);
                SqlStringBuilder.Append("SELECT TOP 1 ");
                SqlStringBuilder.Append("        c.part_no ");
                SqlStringBuilder.Append("FROM    dbo.sys_bom a ");
                SqlStringBuilder.Append("        LEFT JOIN dbo.sys_bom_detail b ON a.bom_id = b.bom_id ");
                SqlStringBuilder.Append("        LEFT JOIN dbo.sys_part c ON b.part_id = c.part_id ");
                SqlStringBuilder.Append("        LEFT JOIN sys_part d ON b.item_part_id = d.part_id ");
                SqlStringBuilder.Append("WHERE   a.bom_type = '物料' ");
                SqlStringBuilder.Append("        AND d.cust_part_no = '" + custPartNo + "' OR d.part_no_3c= '" + custPartNo + "' ");

                object obj = _remotingProxy.GetScalar(SqlStringBuilder.ToString());

                return obj == null ? "" : Convert.ToString(obj);
            }
        }

        public int GetOrderId(int custPdlineId)
        {
            lock (_remotingProxy)
            {
                string SqlString =
                    "  select top 1 order_id from g_order where cust_pdline=" + custPdlineId + "  order by order_id desc   ";
                //"  SELECT   (CASE WHEN MAX(order_id) IS NULL THEN '0' ELSE '0' END) +1 as order_id FROM dbo.g_vw_order   ";

                Hashtable Params = new Hashtable(1);

                object obj = _remotingProxy.GetScalar(SqlString, Params);

                return obj == null ? 0 : Convert.ToInt32(obj);
            }
        }

        public int getOrderDetailId(int custPdlineId)
        {
            lock (_remotingProxy)
            {
                string SqlString =
                    "  select top 1 * from dbo.g_order_detail order by ruid desc   ";
                //"  SELECT   (CASE WHEN MAX(order_id) IS NULL THEN '0' ELSE '0' END) +1 as order_id FROM dbo.g_vw_order   ";

                Hashtable Params = new Hashtable(1);

                object obj = _remotingProxy.GetScalar(SqlString, Params);

                return obj == null ? 0 : Convert.ToInt32(obj);
            }
        }

        public int GetCustPdlineId(int partId)
        {
            lock (_remotingProxy)
            {
                string SqlString =
                    " SELECT top 1 d.cust_pdline_id FROM dbo.sys_part AS a "
    + " LEFT JOIN dbo.sys_model AS b ON a.model_id=b.model_id "
    + " LEFT JOIN dbo.sys_model_type AS c ON b.model_type_id=c.type_id"
    + " LEFT JOIN dbo.sys_cust_pdline AS d ON c.cust_pdline_id=d.cust_pdline_id"
    + " WHERE a.part_type=2 AND a.part_id=" + partId;
                //"  SELECT   (CASE WHEN MAX(order_id) IS NULL THEN '0' ELSE '0' END) +1 as order_id FROM dbo.g_vw_order   ";

                Hashtable Params = new Hashtable(1);

                object obj = _remotingProxy.GetScalar(SqlString, Params);

                return obj == null ? 0 : Convert.ToInt32(obj);
            }
        }

        public string getShipNo(string shipNo)
        {
            lock (_remotingProxy)
            {
                string SqlString =
                    " sys_get_sn_seed 'ShipNumber'   ";
                //"  SELECT   (CASE WHEN MAX(order_id) IS NULL THEN '0' ELSE '0' END) +1 as order_id FROM dbo.g_vw_order   ";

                Hashtable Params = new Hashtable(1);

                object obj = _remotingProxy.GetScalar(SqlString, Params);

                return obj == null ? "" : Convert.ToString(obj);
            }
        }


        /// <summary>
        /// 获取客户产线列表
        /// </summary>
        /// <returns></returns>
        public DataTable GetCustPDLine()
        {
            lock (_remotingProxy)
            {
                StringBuilder SqlStringBuilder = new StringBuilder(1024);
                SqlStringBuilder.Append("SELECT  cust_pdline_id as [value], ");
                SqlStringBuilder.Append("cust_pdline_name as [key] ");
                SqlStringBuilder.Append("FROM    dbo.sys_cust_pdline ");
                SqlStringBuilder.Append("WHERE   enabled = 'Y' ");
                SqlStringBuilder.Append("ORDER BY cust_pdline_name ");

                return _remotingProxy.GetDataTable(SqlStringBuilder.ToString());
            }
        }

        /// <summary>
        /// 释放指令
        /// </summary>
        /// <returns></returns>
        public string releaseOrder(string cbCustPDLine, string cbShift, string qty)
        {
            lock (_remotingProxy)
            {
                DynamicParameters Parameters = new DynamicParameters();

                Parameters.Add(new StoreProcedureParameter(DbType.String, ParameterDirection.Input, "@start_car_no", "888"));

                Parameters.Add(new StoreProcedureParameter(DbType.String, ParameterDirection.Input, "@cust_pdline", cbCustPDLine));

                Parameters.Add(new StoreProcedureParameter(DbType.String, ParameterDirection.Input, "@@shift_code", cbShift));

                Parameters.Add(new StoreProcedureParameter(DbType.String, ParameterDirection.Input, "@qty", qty));

                Parameters.Add(new StoreProcedureParameter(DbType.String, ParameterDirection.Output, "@tres", 500));

                Hashtable ht = _remotingProxy.ExecuteSotreProcedure("dbo.sys_release_order", Parameters);

                if (!ht.ContainsKey("@tres"))
                    return string.Empty;

                return ht["@tres"].ToString();
            }
        }

        public bool ifOrderId(string order_seq, int part_id)
        {
            lock (_remotingProxy)
            {
                string SqlString =

                    "select * from g_vw_order where order_seq= @order_seq AND cust_pdline=(SELECT cust_pdline_id FROM sys_part AS A LEFT JOIN sys_model AS B ON A.model_id=B.model_id LEFT JOIN sys_model_type AS C ON B.model_type_id=C.type_id WHERE A.part_id=" + part_id + " ) ";

                Hashtable Params = new Hashtable(1);

                Params.Add("@order_seq", order_seq);

                return _remotingProxy.Exists(SqlString, Params);
            }
        }



        public bool ifOrderId(string order_seq, int part_id, string PackageUnitNumber)
        {
            lock (_remotingProxy)
            {
                string SqlString =

                    "select * from g_vw_order where package_unit_number+order_seq='" + PackageUnitNumber + order_seq + "' AND cust_pdline=(SELECT cust_pdline_id FROM sys_part AS A LEFT JOIN sys_model AS B ON A.model_id=B.model_id LEFT JOIN sys_model_type AS C ON B.model_type_id=C.type_id WHERE A.part_id=" + part_id + " ) ";

                Hashtable Params = new Hashtable(1);

                return _remotingProxy.Exists(SqlString, Params);
            }
        }

        public bool selectRelationData(int part_id)
        {
            lock (_remotingProxy)
            {
                string SqlString =

                    "select top 1 * from g_part_relation as a  left join sys_part as b on a.model_id=b.model_id where b.part_id= " + part_id + "";

                Hashtable Params = new Hashtable(1);

                return _remotingProxy.Exists(SqlString, Params);
            }
        }

        public bool DeleteData(string order_id)
        {
            lock (_remotingProxy)
            {
                string SqlString =

                    " delete g_ve_order where order_id=@order_id ";

                Hashtable Params = new Hashtable(1);

                Params.Add("@order_id", order_id);

                return _remotingProxy.Exists(SqlString, Params);
            }
        }

        /// <summary>
        /// 校验车号
        /// </summary>
        /// <param name="car_no"></param>
        /// <param name="part_id"></param>
        /// <returns></returns>
        public bool ifCarNo(string car_no, int part_id)
        {
            lock (_remotingProxy)
            {
                string SqlString =

                    "select * from g_order where car_no= @car_no  AND cust_pdline=(SELECT cust_pdline_id FROM sys_part AS A LEFT JOIN sys_model AS B ON A.model_id=B.model_id LEFT JOIN sys_model_type AS C ON B.model_type_id=C.type_id WHERE A.part_id=" + part_id + " )";

                Hashtable Params = new Hashtable(1);

                Params.Add("@car_no", car_no);

                return _remotingProxy.Exists(SqlString, Params);
            }
        }

        /// <summary>
        /// 校验VIN号
        /// </summary>
        /// <param name="vin"></param>
        /// <returns></returns>
        public bool ifVin(string vin, string custPdline)
        {
            lock (_remotingProxy)
            {
                string SqlString =

                    "select * from g_order where vin= @vin and cust_pdline=@custPdline ";

                Hashtable Params = new Hashtable(1);

                Params.Add("@vin", vin);
                Params.Add("@custPdline", custPdline);

                return _remotingProxy.Exists(SqlString, Params);
            }
        }

        public bool IfOrderDetail(string trayNo, string partType)
        {
            lock (_remotingProxy)
            {
                string SqlString =

                    "SELECT * FROM dbo.g_order_detail WHERE tray_no='" + trayNo + "' AND part_type='" + partType + "' ";

                return _remotingProxy.Exists(SqlString);
            }
        }

        /// <summary>
        /// 根据流水号查询order_id
        /// </summary>
        /// <param name="vin"></param>
        /// <returns></returns>
        public string ifOrderSeq(string orderSeq, string cbCustPDLine)
        {
            lock (_remotingProxy)
            {
                string SqlString =

                    "select top 1 order_id from g_order where order_seq= @orderSeq and cust_pdline=@cbCustPDLine ";

                Hashtable Params = new Hashtable(2);

                Params.Add("@orderSeq", orderSeq);
                Params.Add("@cbCustPDLine", cbCustPDLine);

                object obj = _remotingProxy.GetScalar(SqlString, Params);

                return obj == null ? "" : Convert.ToString(obj);
            }
        }

        public DataTable GetDetail(int part_id)
        {
            lock (_remotingProxy)
            {
                string SqlString =

                    "SELECT a.part_id,item_part_id,b.part_no ,CASE b.part_location WHEN '01' THEN 'F' WHEN '02' THEN 'F' ELSE 'R' END AS arrange_flag,part_location  FROM dbo.sys_bom_detail AS a LEFT JOIN dbo.sys_part AS b ON a.item_part_id=b.part_id WHERE a.part_id= @part_id ";

                Hashtable Params = new Hashtable(1);

                Params.Add("@part_id", part_id);

                return _remotingProxy.GetDataTable(SqlString, Params);
            }
        }


        public DataTable GetDetail(int part_id, string part_location)
        {
            lock (_remotingProxy)
            {
                string SqlString = "";
                if (part_location == "01" || part_location == "02")
                {
                    SqlString = "SELECT a.part_id,item_part_id,b.part_no ,CASE b.part_location WHEN '01' THEN 'F' WHEN '02' THEN 'F' ELSE 'R' END AS arrange_flag,part_location  FROM dbo.sys_bom_detail AS a LEFT JOIN dbo.sys_part AS b ON a.item_part_id=b.part_id WHERE a.part_id= @part_id AND part_location='" + part_location + "' ";

                }
                else
                {
                    SqlString = "SELECT a.part_id,item_part_id,b.part_no ,CASE b.part_location WHEN '01' THEN 'F' WHEN '02' THEN 'F' ELSE 'R' END AS arrange_flag,part_location  FROM dbo.sys_bom_detail AS a LEFT JOIN dbo.sys_part AS b ON a.item_part_id=b.part_id WHERE a.part_id= @part_id AND part_location NOT IN ('01','02') ";
                }
                Hashtable Params = new Hashtable(1);

                Params.Add("@part_id", part_id);

                return _remotingProxy.GetDataTable(SqlString, Params);
            }
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="part_id"></param>
        /// <returns></returns>
        public DataTable getLocationType(int part_id)
        {
            lock (_remotingProxy)
            {
                string SqlString =

                    "SELECT DISTINCT CASE b.part_location WHEN '01' THEN 'F' WHEN '02' THEN 'F' ELSE 'R' END AS location_type FROM dbo.sys_bom_detail AS a LEFT JOIN dbo.sys_part AS b ON a.item_part_id=b.part_id WHERE a.part_id=@part_id ";

                Hashtable Params = new Hashtable(1);

                Params.Add("@part_id", part_id);

                return _remotingProxy.GetDataTable(SqlString, Params);
            }
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="part_id"></param>
        /// <returns></returns>
        public DataTable getLocationType2(int part_id)
        {
            lock (_remotingProxy)
            {
                string SqlString =

                    "SELECT DISTINCT CASE b.part_location WHEN '01' THEN 'PT11' WHEN '02' THEN 'PT12' ELSE 'PT20' END AS location_type FROM dbo.sys_bom_detail AS a LEFT JOIN dbo.sys_part AS b ON a.item_part_id=b.part_id WHERE a.part_id=@part_id ";

                Hashtable Params = new Hashtable(1);

                Params.Add("@part_id", part_id);

                return _remotingProxy.GetDataTable(SqlString, Params);
            }
        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="SqlStrings"></param>
        /// <param name="Parameters"></param>
        /// <returns></returns>
        public bool InsertData(List<string> SqlStrings, List<Hashtable> Parameters)
        {
            lock (_remotingProxy)
            {
                return _remotingProxy.ExecuteSqlTransaction(SqlStrings, Parameters);
            }
        }

        public int UpdateCount(string order_id)
        {
            lock (_remotingProxy)
            {
                string SqlString =
                    " update g_order set [count]=[count]+1 where order_id in (" + order_id + ") ";

                Hashtable Params = new Hashtable(1);

                object obj = _remotingProxy.GetScalar(SqlString, Params);

                return obj == null ? 0 : Convert.ToInt32(obj);
            }
        }

        public int UpdatePrintNumber(string printNumber, string cbCustPDLine)
        {
            lock (_remotingProxy)
            {
                string SqlString =
                    " UPDATE dbo.sys_base SET param_value='" + printNumber + "' WHERE param_name='" + cbCustPDLine + "ShipNumber'";

                object obj = _remotingProxy.GetScalar(SqlString);

                return obj == null ? 0 : Convert.ToInt32(obj);
            }
        }

        public int updateTrayNo(string HouPaiZhengYiNo, string FuJiaShiNo, string ZhengJiaShiNo, string order_id, string sum)
        {
            lock (_remotingProxy)
            {
                List<string> SqlStrings = new List<string>();
                List<Hashtable> Parameters = new List<Hashtable>();
                Hashtable Params = new Hashtable();

                string strSql = " UPDATE dbo.g_order_detail SET tray_no='" + HouPaiZhengYiNo + "',tray_seq='" + sum + "' WHERE order_id=" + order_id + " AND part_type='PT20' ";
                SqlStrings.Add(strSql);
                Parameters.Add(Params);

                strSql = "";
                strSql = " UPDATE dbo.g_order_detail SET tray_no='" + FuJiaShiNo + "',tray_seq='" + sum + "'  WHERE order_id=" + order_id + " AND part_type='PT12' ";
                SqlStrings.Add(strSql);
                Parameters.Add(Params);

                strSql = "";
                strSql = " UPDATE dbo.g_order_detail SET tray_no='" + ZhengJiaShiNo + "',tray_seq='" + sum + "'  WHERE order_id=" + order_id + " AND part_type='PT11' ";
                SqlStrings.Add(strSql);
                Parameters.Add(Params);

                object obj = _remotingProxy.ExecuteSqlTransaction(SqlStrings, Parameters);

                return obj == null ? 0 : Convert.ToInt32(obj);
            }
        }

        #endregion
    }
}