using System;
using System.Data;
using System.Collections;
using Core.Mes.ServerFrameWork;
using Core.Mes.IBaseInterface;
using Core.XgMes.Server.JGKC.RollManager;
namespace Core.XgMes.Server.JGKC.MaterialManager
{
    public class Metarial : Core.Mes.ServerFrameWork.IComponent
    {
        /// <summary>
        ///物料代码新增
        /// </summary>
        /// <param name=" "></param>
        /// <returns></returns>
        public ReturnObject MetarilAdd(ArrayList MetarilInfo)
        {
            try
            {
                string err = "";
               
                Oracle.DataAccess.Client.OracleParameter pMetarilInfo = new Oracle.DataAccess.Client.OracleParameter("vMetarilInfo", Oracle.DataAccess.Client.OracleDbType.Varchar2);

                Oracle.DataAccess.Client.OracleParameter pSuccessFlag = new Oracle.DataAccess.Client.OracleParameter("vSuccessFlag", Oracle.DataAccess.Client.OracleDbType.Varchar2);


                pMetarilInfo.Direction = ParameterDirection.Input;
               
                pSuccessFlag.Direction = ParameterDirection.Output;


                pMetarilInfo.CollectionType = Oracle.DataAccess.Client.OracleCollectionType.PLSQLAssociativeArray;


                pMetarilInfo.Value = MetarilInfo.ToArray(typeof(string));





                int[] HSizeInf = new int[MetarilInfo.Count];
                for (int i = 0; i < MetarilInfo.Count; i++)
                {
                    HSizeInf[i] = 200;
                }
                pMetarilInfo.Size = MetarilInfo.Count;
                pMetarilInfo.ArrayBindSize = HSizeInf;

                pSuccessFlag.Size = 400;

                ((STMes.DBManager)DBManagerList["ODPDBZW"]).ExecuteNonQuery_NoDBSever("KCJ_METARILZW.MetarilManager", CommandType.StoredProcedure,
                        new Oracle.DataAccess.Client.OracleParameter[] { pMetarilInfo, pSuccessFlag }, out err);

                if (Common.CheckNullStr(pSuccessFlag.Value).Length > 0 | Common.CheckNullStr(err).Length > 0)
                {
                    return new ReturnObject(null, 1, pSuccessFlag.Value.ToString() + err);
                }
                else
                {
                    return new ReturnObject('1');
                }
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return new ReturnObject(null, ex.ToString());
            }
        }




        /// <summary>
        ///供方代码新增
        /// </summary>
        /// <param name=" "></param>
        /// <returns></returns>
        public ReturnObject ProviderAdd(ArrayList MetarilInfo)
        {
            try
            {
                string err = "";

                Oracle.DataAccess.Client.OracleParameter pMetarilInfo = new Oracle.DataAccess.Client.OracleParameter("vMetarilInfo", Oracle.DataAccess.Client.OracleDbType.Varchar2);

                Oracle.DataAccess.Client.OracleParameter pSuccessFlag = new Oracle.DataAccess.Client.OracleParameter("vSuccessFlag", Oracle.DataAccess.Client.OracleDbType.Varchar2);


                pMetarilInfo.Direction = ParameterDirection.Input;

                pSuccessFlag.Direction = ParameterDirection.Output;


                pMetarilInfo.CollectionType = Oracle.DataAccess.Client.OracleCollectionType.PLSQLAssociativeArray;


                pMetarilInfo.Value = MetarilInfo.ToArray(typeof(string));





                int[] HSizeInf = new int[MetarilInfo.Count];
                for (int i = 0; i < MetarilInfo.Count; i++)
                {
                    HSizeInf[i] = 200;
                }
                pMetarilInfo.Size = MetarilInfo.Count;
                pMetarilInfo.ArrayBindSize = HSizeInf;

                pSuccessFlag.Size = 400;

                ((STMes.DBManager)DBManagerList["ODPDBZW"]).ExecuteNonQuery_NoDBSever("KCJ_METARILZW.ProviderManager", CommandType.StoredProcedure,
                        new Oracle.DataAccess.Client.OracleParameter[] { pMetarilInfo, pSuccessFlag }, out err);

                if (Common.CheckNullStr(pSuccessFlag.Value).Length > 0 | Common.CheckNullStr(err).Length > 0)
                {
                    return new ReturnObject(null, 1, pSuccessFlag.Value.ToString() + err);
                }
                else
                {
                    return new ReturnObject('1');
                }
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return new ReturnObject(null, ex.ToString());
            }
        }



        /// <summary>
        ///仓库代码新增
        /// </summary>
        /// <param name=" "></param>
        /// <returns></returns>
        public ReturnObject DepotAdd(ArrayList DepotInfo)
        {
            try
            {
                string err = "";

                Oracle.DataAccess.Client.OracleParameter pDepotInfo = new Oracle.DataAccess.Client.OracleParameter("vDepotInfo", Oracle.DataAccess.Client.OracleDbType.Varchar2);

                Oracle.DataAccess.Client.OracleParameter pSuccessFlag = new Oracle.DataAccess.Client.OracleParameter("vSuccessFlag", Oracle.DataAccess.Client.OracleDbType.Varchar2);


                pDepotInfo.Direction = ParameterDirection.Input;

                pSuccessFlag.Direction = ParameterDirection.Output;


                pDepotInfo.CollectionType = Oracle.DataAccess.Client.OracleCollectionType.PLSQLAssociativeArray;


                pDepotInfo.Value = DepotInfo.ToArray(typeof(string));





                int[] HSizeInf = new int[DepotInfo.Count];
                for (int i = 0; i < DepotInfo.Count; i++)
                {
                    HSizeInf[i] = 200;
                }
                pDepotInfo.Size = DepotInfo.Count;
                pDepotInfo.ArrayBindSize = HSizeInf;

                pSuccessFlag.Size = 400;

                ((STMes.DBManager)DBManagerList["ODPDBZW"]).ExecuteNonQuery_NoDBSever("KCJ_METARILZW.DepotManager", CommandType.StoredProcedure,
                        new Oracle.DataAccess.Client.OracleParameter[] { pDepotInfo, pSuccessFlag }, out err);

                if (Common.CheckNullStr(pSuccessFlag.Value).Length > 0 | Common.CheckNullStr(err).Length > 0)
                {
                    return new ReturnObject(null, 1, pSuccessFlag.Value.ToString() + err);
                }
                else
                {
                    return new ReturnObject('1');
                }
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return new ReturnObject(null, ex.ToString());
            }
        }



        /// <summary>
        ///验收单新增
        /// </summary>
        /// <param name=" "></param>
        /// <returns></returns>
        public ReturnObject AccpetSheetAdd(ArrayList SheetInfo)
        {
            try
            {
                string err = "";

                Oracle.DataAccess.Client.OracleParameter pSheetInfo = new Oracle.DataAccess.Client.OracleParameter("vSheetInfo", Oracle.DataAccess.Client.OracleDbType.Varchar2);

                Oracle.DataAccess.Client.OracleParameter pSuccessFlag = new Oracle.DataAccess.Client.OracleParameter("vSuccessFlag", Oracle.DataAccess.Client.OracleDbType.Varchar2);


                pSheetInfo.Direction = ParameterDirection.Input;

                pSuccessFlag.Direction = ParameterDirection.Output;


                pSheetInfo.CollectionType = Oracle.DataAccess.Client.OracleCollectionType.PLSQLAssociativeArray;


                pSheetInfo.Value = SheetInfo.ToArray(typeof(string));





                int[] HSizeInf = new int[SheetInfo.Count];
                for (int i = 0; i < SheetInfo.Count; i++)
                {
                    HSizeInf[i] = 200;
                }
                pSheetInfo.Size = SheetInfo.Count;
                pSheetInfo.ArrayBindSize = HSizeInf;

                pSuccessFlag.Size = 400;

                ((STMes.DBManager)DBManagerList["ODPDBZW"]).ExecuteNonQuery_NoDBSever("KCJ_METARILZW.SheetManager", CommandType.StoredProcedure,
                        new Oracle.DataAccess.Client.OracleParameter[] { pSheetInfo, pSuccessFlag }, out err);

                if (Common.CheckNullStr(pSuccessFlag.Value).Length > 0 | Common.CheckNullStr(err).Length > 0)
                {
                    return new ReturnObject(null, 1, pSuccessFlag.Value.ToString() + err);
                }
                else
                {
                    return new ReturnObject('1');
                }
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return new ReturnObject(null, ex.ToString());
            }
        }




        /// <summary>
        ///领料单新增
        /// </summary>
        /// <param name=" "></param>
        /// <returns></returns>
        public ReturnObject PickingSheetAdd(ArrayList SheetInfo)
        {
            try
            {
                string err = "";

                Oracle.DataAccess.Client.OracleParameter pSheetInfo = new Oracle.DataAccess.Client.OracleParameter("vSheetInfo", Oracle.DataAccess.Client.OracleDbType.Varchar2);

                Oracle.DataAccess.Client.OracleParameter pSuccessFlag = new Oracle.DataAccess.Client.OracleParameter("vSuccessFlag", Oracle.DataAccess.Client.OracleDbType.Varchar2);


                pSheetInfo.Direction = ParameterDirection.Input;

                pSuccessFlag.Direction = ParameterDirection.Output;


                pSheetInfo.CollectionType = Oracle.DataAccess.Client.OracleCollectionType.PLSQLAssociativeArray;


                pSheetInfo.Value = SheetInfo.ToArray(typeof(string));





                int[] HSizeInf = new int[SheetInfo.Count];
                for (int i = 0; i < SheetInfo.Count; i++)
                {
                    HSizeInf[i] = 200;
                }
                pSheetInfo.Size = SheetInfo.Count;
                pSheetInfo.ArrayBindSize = HSizeInf;

                pSuccessFlag.Size = 400;

                ((STMes.DBManager)DBManagerList["ODPDBZW"]).ExecuteNonQuery_NoDBSever("KCJ_METARILZW.PickingSheetManager", CommandType.StoredProcedure,
                        new Oracle.DataAccess.Client.OracleParameter[] { pSheetInfo, pSuccessFlag }, out err);

                if (Common.CheckNullStr(pSuccessFlag.Value).Length > 0 | Common.CheckNullStr(err).Length > 0)
                {
                    return new ReturnObject(null, 1, pSuccessFlag.Value.ToString() + err);
                }
                else
                {
                    return new ReturnObject('1');
                }
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return new ReturnObject(null, ex.ToString());
            }
        }



        /// <summary>
        ///仓库初始值管理
        /// </summary>
        /// <param name=" "></param>
        /// <returns></returns>
        public ReturnObject StockAdd(ArrayList StockInfo)
        {
            try
            {
                string err = "";

                Oracle.DataAccess.Client.OracleParameter pStockInfo = new Oracle.DataAccess.Client.OracleParameter("vStockInfo", Oracle.DataAccess.Client.OracleDbType.Varchar2);

                Oracle.DataAccess.Client.OracleParameter pSuccessFlag = new Oracle.DataAccess.Client.OracleParameter("vSuccessFlag", Oracle.DataAccess.Client.OracleDbType.Varchar2);


                pStockInfo.Direction = ParameterDirection.Input;

                pSuccessFlag.Direction = ParameterDirection.Output;


                pStockInfo.CollectionType = Oracle.DataAccess.Client.OracleCollectionType.PLSQLAssociativeArray;


                pStockInfo.Value = StockInfo.ToArray(typeof(string));





                int[] HSizeInf = new int[StockInfo.Count];
                for (int i = 0; i < StockInfo.Count; i++)
                {
                    HSizeInf[i] = 200;
                }
                pStockInfo.Size = StockInfo.Count;
                pStockInfo.ArrayBindSize = HSizeInf;

                pSuccessFlag.Size = 400;

                ((STMes.DBManager)DBManagerList["ODPDBZW"]).ExecuteNonQuery_NoDBSever("KCJ_METARILZW.StockManager", CommandType.StoredProcedure,
                        new Oracle.DataAccess.Client.OracleParameter[] { pStockInfo, pSuccessFlag }, out err);

                if (Common.CheckNullStr(pSuccessFlag.Value).Length > 0 | Common.CheckNullStr(err).Length > 0)
                {
                    return new ReturnObject(null, 1, pSuccessFlag.Value.ToString() + err);
                }
                else
                {
                    return new ReturnObject('1');
                }
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return new ReturnObject(null, ex.ToString());
            }
        }




        /// <summary>
        ///计划申报管理
        /// </summary>
        /// <param name=" "></param>
        /// <returns></returns>
        public ReturnObject PlanSBAdd(ArrayList PlansbInfo)
        {
            try
            {
                string err = "";

                Oracle.DataAccess.Client.OracleParameter pPlanInfo = new Oracle.DataAccess.Client.OracleParameter("vPlanInfo", Oracle.DataAccess.Client.OracleDbType.Varchar2);

                Oracle.DataAccess.Client.OracleParameter pSuccessFlag = new Oracle.DataAccess.Client.OracleParameter("vSuccessFlag", Oracle.DataAccess.Client.OracleDbType.Varchar2);


                pPlanInfo.Direction = ParameterDirection.Input;

                pSuccessFlag.Direction = ParameterDirection.Output;


                pPlanInfo.CollectionType = Oracle.DataAccess.Client.OracleCollectionType.PLSQLAssociativeArray;


                pPlanInfo.Value = PlansbInfo.ToArray(typeof(string));





                int[] HSizeInf = new int[PlansbInfo.Count];
                for (int i = 0; i < PlansbInfo.Count; i++)
                {
                    HSizeInf[i] = 200;
                }
                pPlanInfo.Size = PlansbInfo.Count;
                pPlanInfo.ArrayBindSize = HSizeInf;

                pSuccessFlag.Size = 400;

                ((STMes.DBManager)DBManagerList["ODPDBZW"]).ExecuteNonQuery_NoDBSever("KCJ_METARILZW.PlanSB", CommandType.StoredProcedure,
                        new Oracle.DataAccess.Client.OracleParameter[] { pPlanInfo, pSuccessFlag }, out err);

                if (Common.CheckNullStr(pSuccessFlag.Value).Length > 0 | Common.CheckNullStr(err).Length > 0)
                {
                    return new ReturnObject(null, 1, pSuccessFlag.Value.ToString() + err);
                }
                else
                {
                    return new ReturnObject('1');
                }
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return new ReturnObject(null, ex.ToString());
            }
        }






        /// <summary>
        ///计划申报管理审批
        /// </summary>
        /// <param name=" "></param>
        /// <returns></returns>
        public ReturnObject PlanSPAdd(ArrayList PlansbInfo)
        {
            try
            {
                string err = "";

                Oracle.DataAccess.Client.OracleParameter pPlanInfo = new Oracle.DataAccess.Client.OracleParameter("vPlanInfo", Oracle.DataAccess.Client.OracleDbType.Varchar2);

                Oracle.DataAccess.Client.OracleParameter pSuccessFlag = new Oracle.DataAccess.Client.OracleParameter("vSuccessFlag", Oracle.DataAccess.Client.OracleDbType.Varchar2);


                pPlanInfo.Direction = ParameterDirection.Input;

                pSuccessFlag.Direction = ParameterDirection.Output;


                pPlanInfo.CollectionType = Oracle.DataAccess.Client.OracleCollectionType.PLSQLAssociativeArray;


                pPlanInfo.Value = PlansbInfo.ToArray(typeof(string));





                int[] HSizeInf = new int[PlansbInfo.Count];
                for (int i = 0; i < PlansbInfo.Count; i++)
                {
                    HSizeInf[i] = 200;
                }
                pPlanInfo.Size = PlansbInfo.Count;
                pPlanInfo.ArrayBindSize = HSizeInf;

                pSuccessFlag.Size = 400;

                ((STMes.DBManager)DBManagerList["ODPDBZW"]).ExecuteNonQuery_NoDBSever("KCJ_METARILZW.PlanSP", CommandType.StoredProcedure,
                        new Oracle.DataAccess.Client.OracleParameter[] { pPlanInfo, pSuccessFlag }, out err);

                if (Common.CheckNullStr(pSuccessFlag.Value).Length > 0 | Common.CheckNullStr(err).Length > 0)
                {
                    return new ReturnObject(null, 1, pSuccessFlag.Value.ToString() + err);
                }
                else
                {
                    return new ReturnObject('1');
                }
            }
            catch (System.Exception ex)
            {
                System.Diagnostics.Debug.WriteLine(ex.ToString());
                return new ReturnObject(null, ex.ToString());
            }
        }

    }
}