using System;
using System.Collections.Generic;
using System.Data;
using System.Data.OracleClient;
using System.Linq;
using WX.CRM.Common;
using WX.CRM.Model.DTO;

namespace WX.CRM.DAL.Res
{
    public class RES_ALLOCATE_DAL
    {
        /// <summary>
        /// 获取当天的日历信息
        /// </summary>
        /// <returns></returns>
        public DataTable GetTradeCalender()
        {
            OracleParameter[] p = new[] { new OracleParameter { ParameterName = "v_data", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output } };
            DataTable tab = OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_RES_ALLOCATE.GetTradeCalender", p).Tables[0];
            return tab;
        }

        /// <summary>
        /// 资源分配定时分配主过程
        /// </summary>
        public void TimingExecuteAllocateProc()
        {
            OracleConnection conn = new OracleConnection(OracleHelper.AYCRMConn);
            if (conn.State == ConnectionState.Closed)
                conn.Open();
            try
            {
                using (OracleTransaction trans = conn.BeginTransaction())
                {
                    var p2 = new List<OracleParameter>();

                    int restult = OracleHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure, "PACK_RES_ALLOCATE.TimingExecuteAllocateProc", p2.ToArray());
                    trans.Commit();
                }
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                if (conn.State == ConnectionState.Open)
                    conn.Close();
            }
        }
        /// <summary>
        /// 资源分配定时回收主过程
        /// </summary>
        public void TimingExecuteRecycleProc()
        {
            OracleConnection conn = new OracleConnection(OracleHelper.AYCRMConn);
            if (conn.State == ConnectionState.Closed)
                conn.Open();
            try
            {
                using (OracleTransaction trans = conn.BeginTransaction())
                {
                    var p2 = new List<OracleParameter>();

                    int restult = OracleHelper.ExecuteNonQuery(trans, CommandType.StoredProcedure, "PACK_RES_RECYCLE.TimingExecuteRecycleProc", p2.ToArray());
                    trans.Commit();
                }
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                if (conn.State == ConnectionState.Open)
                    conn.Close();
            }
        }
        #region
        public void ViewMyRes(string customerid, decimal inneruserid)
        {
            OracleConnection conn = new OracleConnection(OracleHelper.AYCRMConn);
            if (conn.State == ConnectionState.Closed)
                conn.Open();
            try
            {
                using (OracleTransaction trans = conn.BeginTransaction())
                {
                    OracleParameter[] p = new[]
                    {
                        new OracleParameter
                        {
                            ParameterName = "p_customerid",
                            OracleType = OracleType.VarChar,
                            Value = customerid
                        },
                        new OracleParameter
                        {
                            ParameterName = "p_inneruserId",
                            OracleType = OracleType.Number,
                            Value = inneruserid
                        },
                    };
                    OracleHelper.DataQueray(trans, CommandType.StoredProcedure, "PACK_RES_VIEW.DefaultView",
                        p);
                    trans.Commit();
                }
            }
            catch (Exception)
            {
                throw;
            }
            finally
            {
                if (conn.State == ConnectionState.Open)
                    conn.Close();
            }
        }
        #endregion

        #region 我的分配资源查询
        public DataSet GetMyAllocateResList(ref Pager pg, string resid, decimal inneruserid, string resourcetag, decimal resourcetypeid, decimal isview, decimal isnew, DateTime? stime, DateTime? etime, string groupId, string pkids)
        {
            //OracleConnection conn = new OracleConnection(OracleHelper.AYCRMConn);
            //if (conn.State == ConnectionState.Closed)
            //    conn.Open();
            try
            {
                //    using (OracleTransaction trans = conn.BeginTransaction())
                //{
                List<OracleParameter> p = new List<OracleParameter>()
                {
                    new OracleParameter {ParameterName = "p_ResId", OracleType = OracleType.VarChar, Value = resid},
                    new OracleParameter {ParameterName = "p_pkids", OracleType = OracleType.VarChar, Value = pkids},
                    new OracleParameter {ParameterName = "p_GroupId", OracleType = OracleType.VarChar, Value = groupId},
                    new OracleParameter {ParameterName = "p_UserId", OracleType = OracleType.Number, Value = inneruserid},
                    new OracleParameter {ParameterName = "p_ResourceTypeId", OracleType = OracleType.Number, Value = resourcetypeid},
                    new OracleParameter {ParameterName = "p_ResourceTag", OracleType = OracleType.VarChar, Value = resourcetag},
                    new OracleParameter {ParameterName = "p_IsView", OracleType = OracleType.Number, Value = isview},
                    new OracleParameter {ParameterName = "p_IsNew", OracleType = OracleType.Number, Value = isnew},
                    new OracleParameter {ParameterName = "p_stime", OracleType = OracleType.DateTime, Value = stime},
                    new OracleParameter {ParameterName = "p_etime", OracleType = OracleType.DateTime, Value = etime},
                    new OracleParameter {ParameterName = "p_pageIndex", OracleType = OracleType.Number, Value = pg.page},
                    new OracleParameter {ParameterName = "p_pageSize", OracleType = OracleType.Number, Value = pg.rows},
                    new OracleParameter {ParameterName = "p_data", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output}
                };
                //LogHelper.Info(string.Format("p_ResId:{0},p_GroupId:{1},p_UserId:{2},p_ResourceTypeId:{3},p_ResourceTag:{4},p_IsView:{5},p_IsNew:{6},p_stime:{7},p_etime:{8},p_pageIndex:{9},p_pageSize:{10}",  resid, groupId, inneruserid, resourcetypeid, resourcetag, isview, isnew, stime, etime,pg.page,pg.rows));
                var ds = OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_RES_ALLOCATE.GetMyAllocatedRes", p.ToArray());
                //trans.Commit();
                return ds;
                //    }
            }
            catch (Exception)
            {
                throw;
            }
            //finally
            //{
            //    if (conn.State == ConnectionState.Open)
            //        conn.Close();
            //}
        }

        public DataSet GetMyAllocateResList2(ref Pager pg, string resid, decimal? inneruserid, string resourcetag, decimal resourcetypeid, decimal isview, decimal isnew, DateTime? stime, DateTime? etime, string groupId, decimal? productId, decimal? subproductId, DateTime? stimeTH, DateTime? etimeTH, string pkids, string category, DateTime? stimeGD, DateTime? etimeGD, DateTime? stimeKT, DateTime? etimeKT, DateTime? stimeFP, DateTime? etimeFP, decimal? hasTH = null, decimal? hasGD = null, decimal? isFP = null, string extxml = null, decimal? midproductid = null)
        {
            //OracleConnection conn = new OracleConnection(OracleHelper.AYCRMConn);
            //if (conn.State == ConnectionState.Closed)
            //    conn.Open();
            try
            {
                //    using (OracleTransaction trans = conn.BeginTransaction())
                //{
                List<OracleParameter> p = new List<OracleParameter>
                {
                    new OracleParameter {ParameterName = "p_ResId", OracleType = OracleType.VarChar, Value = resid},
                    new OracleParameter {ParameterName = "p_pkids", OracleType = OracleType.VarChar, Value = pkids},
                    string.IsNullOrEmpty(groupId) ? new OracleParameter {ParameterName = "p_GroupId", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_GroupId", OracleType = OracleType.VarChar, Value = groupId},
                    inneruserid.HasValue ? new OracleParameter {ParameterName = "p_UserId", OracleType = OracleType.Number, Value = inneruserid} : new OracleParameter {ParameterName = "p_UserId", OracleType = OracleType.Number, Value = DBNull.Value},
                    new OracleParameter {ParameterName = "p_ResourceTypeId", OracleType = OracleType.Number, Value = resourcetypeid},
                    new OracleParameter {ParameterName = "p_ResourceTag", OracleType = OracleType.VarChar, Value = resourcetag},
                    new OracleParameter {ParameterName = "p_IsView", OracleType = OracleType.Number, Value = isview},
                    new OracleParameter {ParameterName = "p_IsNew", OracleType = OracleType.Number, Value = isnew},
                    new OracleParameter {ParameterName = "p_stime", OracleType = OracleType.DateTime, Value = stime},
                    new OracleParameter {ParameterName = "p_etime", OracleType = OracleType.DateTime, Value = etime},
                    new OracleParameter {ParameterName = "p_pageIndex", OracleType = OracleType.Number, Value = pg.page},
                    new OracleParameter {ParameterName = "p_pageSize", OracleType = OracleType.Number, Value = pg.rows},
                    new OracleParameter {ParameterName = "p_data", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output},
                    string.IsNullOrEmpty(category) ? new OracleParameter {ParameterName = "p_category", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_category", OracleType = OracleType.VarChar, Value = category},
                    stimeTH.HasValue ? new OracleParameter {ParameterName = "p_stimeTH", OracleType = OracleType.DateTime, Value = stimeTH.Value} : new OracleParameter {ParameterName = "p_stimeTH", OracleType = OracleType.DateTime, Value = DBNull.Value },
                    etimeTH.HasValue ? new OracleParameter {ParameterName = "p_etimeTH", OracleType = OracleType.DateTime, Value = etimeTH.Value} : new OracleParameter {ParameterName = "p_etimeTH", OracleType = OracleType.DateTime, Value = DBNull.Value },
                    stimeGD.HasValue ? new OracleParameter {ParameterName = "p_stimeGD", OracleType = OracleType.DateTime, Value = stimeGD.Value} : new OracleParameter {ParameterName = "p_stimeGD", OracleType = OracleType.DateTime, Value = DBNull.Value },
                    etimeGD.HasValue ? new OracleParameter {ParameterName = "p_etimeGD", OracleType = OracleType.DateTime, Value = etimeGD.Value} : new OracleParameter {ParameterName = "p_etimeGD", OracleType = OracleType.DateTime, Value = DBNull.Value },
                    productId.HasValue ? new OracleParameter{ ParameterName = "p_productid",OracleType = OracleType.Number,Value = productId.Value} : new OracleParameter{ ParameterName = "p_productid", OracleType = OracleType.Number, Value = DBNull.Value },
                    subproductId.HasValue ? new OracleParameter{ ParameterName = "p_subproductid", OracleType = OracleType.Number, Value = subproductId.Value } : new OracleParameter{ ParameterName = "p_subproductid", OracleType = OracleType.Number, Value = DBNull.Value },
                    stimeKT.HasValue ? new OracleParameter {ParameterName = "p_stimeKT", OracleType = OracleType.DateTime, Value = stimeKT.Value} : new OracleParameter {ParameterName = "p_stimeKT", OracleType = OracleType.DateTime, Value = DBNull.Value },
                    etimeKT.HasValue ? new OracleParameter {ParameterName = "p_etimeKT", OracleType = OracleType.DateTime, Value = etimeKT.Value} : new OracleParameter {ParameterName = "p_etimeKT", OracleType = OracleType.DateTime, Value = DBNull.Value },
                    stimeFP.HasValue ? new OracleParameter {ParameterName = "p_stimeFP", OracleType = OracleType.DateTime, Value = stimeFP.Value} : new OracleParameter {ParameterName = "p_stimeFP", OracleType = OracleType.DateTime, Value = DBNull.Value },
                    etimeFP.HasValue ? new OracleParameter {ParameterName = "p_etimeFP", OracleType = OracleType.DateTime, Value = etimeFP.Value} : new OracleParameter {ParameterName = "p_etimeFP", OracleType = OracleType.DateTime, Value = DBNull.Value },
                    hasTH.HasValue ? new OracleParameter{ ParameterName = "p_hasTH", OracleType = OracleType.Number, Value = hasTH.Value } : new OracleParameter{ ParameterName = "p_hasTH", OracleType = OracleType.Number, Value = DBNull.Value },
                    hasGD.HasValue ? new OracleParameter{ ParameterName = "p_hasGD", OracleType = OracleType.Number, Value = hasGD.Value } : new OracleParameter{ ParameterName = "p_hasGD", OracleType = OracleType.Number, Value = DBNull.Value },
                    isFP.HasValue ? new OracleParameter{ ParameterName = "p_isFP", OracleType = OracleType.Number, Value = isFP.Value } : new OracleParameter{ ParameterName = "p_isFP", OracleType = OracleType.Number, Value = DBNull.Value },
                    string.IsNullOrEmpty(extxml) ? new OracleParameter { ParameterName = "p_extxml", OracleType = OracleType.VarChar, Value = DBNull.Value } : new OracleParameter{ ParameterName= "p_extxml", OracleType = OracleType.VarChar, Value = extxml },
                    midproductid.HasValue ? new OracleParameter{ ParameterName = "p_midproductid", OracleType = OracleType.Number, Value = midproductid.Value  } : new OracleParameter{ ParameterName = "p_midproductid", OracleType = OracleType.Number, Value = DBNull.Value }
                };
                //LogHelper.Info(string.Format("p_ResId:{0},p_GroupId:{1},p_UserId:{2},p_ResourceTypeId:{3},p_ResourceTag:{4},p_IsView:{5},p_IsNew:{6},p_stime:{7},p_etime:{8},p_pageIndex:{9},p_pageSize:{10}",  resid, groupId, inneruserid, resourcetypeid, resourcetag, isview, isnew, stime, etime,pg.page,pg.rows));
                var ds = OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_RES_ALLOCATE.GetMyAllocatedRes2", p.ToArray());
                //trans.Commit();
                return ds;
                //    }
            }
            catch (Exception)
            {
                throw;
            }
            //finally
            //{
            //    if (conn.State == ConnectionState.Open)
            //        conn.Close();
            //}
        }


        /// <summary>
        /// 获取诊股资源提醒
        /// </summary>
        /// <param name="pg"></param>
        /// <param name="resid"></param>
        /// <param name="inneruserid"></param>
        /// <param name="resourcetag"></param>
        /// <param name="resourcetypeid"></param>
        /// <param name="isview"></param>
        /// <param name="isnew"></param>
        /// <param name="stime"></param>
        /// <param name="etime"></param>
        /// <param name="groupId"></param>
        /// <param name="pkids"></param>
        /// <returns></returns>
        public DataSet GetMyZhenGuResList(ref Pager pg, string resid, decimal inneruserid, string resourcetag, decimal resourcetypeid, decimal isview, decimal isnew, DateTime? stime, DateTime? etime, string groupId, string pkids)
        {
            //OracleConnection conn = new OracleConnection(OracleHelper.AYCRMConn);
            //if (conn.State == ConnectionState.Closed)
            //    conn.Open();
            try
            {
                //    using (OracleTransaction trans = conn.BeginTransaction())
                //{
                List<OracleParameter> p = new List<OracleParameter>()
                {
                    new OracleParameter {ParameterName = "p_ResId", OracleType = OracleType.VarChar, Value = resid},
                    new OracleParameter {ParameterName = "p_pkids", OracleType = OracleType.VarChar, Value = pkids},
                    new OracleParameter {ParameterName = "p_GroupId", OracleType = OracleType.VarChar, Value = groupId},
                    new OracleParameter {ParameterName = "p_UserId", OracleType = OracleType.Number, Value = inneruserid},
                    new OracleParameter {ParameterName = "p_ResourceTypeId", OracleType = OracleType.Number, Value = resourcetypeid},
                    new OracleParameter {ParameterName = "p_ResourceTag", OracleType = OracleType.VarChar, Value = resourcetag},
                    new OracleParameter {ParameterName = "p_IsView", OracleType = OracleType.Number, Value = isview},
                    new OracleParameter {ParameterName = "p_IsNew", OracleType = OracleType.Number, Value = isnew},
                    new OracleParameter {ParameterName = "p_stime", OracleType = OracleType.DateTime, Value = stime},
                    new OracleParameter {ParameterName = "p_etime", OracleType = OracleType.DateTime, Value = etime},
                    new OracleParameter {ParameterName = "p_pageIndex", OracleType = OracleType.Number, Value = pg.page},
                    new OracleParameter {ParameterName = "p_pageSize", OracleType = OracleType.Number, Value = pg.rows},
                    new OracleParameter {ParameterName = "p_data", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output}
                };
                //LogHelper.Info(string.Format("p_ResId:{0},p_GroupId:{1},p_UserId:{2},p_ResourceTypeId:{3},p_ResourceTag:{4},p_IsView:{5},p_IsNew:{6},p_stime:{7},p_etime:{8},p_pageIndex:{9},p_pageSize:{10}",  resid, groupId, inneruserid, resourcetypeid, resourcetag, isview, isnew, stime, etime,pg.page,pg.rows));
                var ds = OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_RES_ALLOCATE.GetMyZhenGuRes", p.ToArray());
                //trans.Commit();
                return ds;
                //    }
            }
            catch (Exception)
            {
                throw;
            }
            //finally
            //{
            //    if (conn.State == ConnectionState.Open)
            //        conn.Close();
            //}
        }

        public DataSet GetDistributeZhenGu(DateTime? stime, DateTime? etime)
        {
            try
            {
                var p = new List<OracleParameter>()
                {
                    new OracleParameter {ParameterName = "p_stime", OracleType = OracleType.DateTime, Value = stime},
                    new OracleParameter {ParameterName = "p_etime", OracleType = OracleType.DateTime, Value = etime},
                    new OracleParameter {ParameterName = "p_data", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output},
                    new OracleParameter {ParameterName = "p_data2", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output},
                    new OracleParameter {ParameterName = "p_data3", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output}
                };
                var ds = OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_RES_ALLOCATE.GetDistributeZhenGu", p.ToArray());
                return ds;
            }
            catch (Exception)
            {
                throw;
            }
        }

        public DataSet GetZhenGuOrder(DateTime? stime, DateTime? etime)
        {
            try
            {
                var p = new List<OracleParameter>()
                {
                    new OracleParameter {ParameterName = "p_stime", OracleType = OracleType.DateTime, Value = stime},
                    new OracleParameter {ParameterName = "p_etime", OracleType = OracleType.DateTime, Value = etime},
                    new OracleParameter {ParameterName = "p_data", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output}
                };
                var ds = OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_RES_ALLOCATE.GetZhenGuOrder", p.ToArray());
                return ds;
            }
            catch (Exception)
            {
                throw;
            }
        }

        #endregion
        public DataTable GetAllocateLogList(DateTime time1, DateTime time2)
        {
            try
            {
                OracleParameter[] p = new[]
                    {
                        new OracleParameter{ParameterName = "v_startTime",  OracleType = OracleType.DateTime, Value = time1 },
                        new OracleParameter{ParameterName = "v_endTime", OracleType = OracleType.DateTime,Value = time2},
                        new OracleParameter{ParameterName = "v_tab",OracleType = OracleType.Cursor,Direction = ParameterDirection.Output}
                    };
                var ds = OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_RES_ALLOCATE.GetAllocateLogList", p).Tables[0];
                return ds;
            }
            catch (Exception)
            {
                throw;
            }

        }


        public bool CanShowResMobile(string resid, decimal inneruserid)
        {
            OracleConnection conn = new OracleConnection(OracleHelper.AYCRMConn);
            if (conn.State == ConnectionState.Closed)
                conn.Open();
            try
            {
                using (OracleTransaction trans = conn.BeginTransaction())
                {
                    OracleParameter[] p = new[]
                    {
                        new OracleParameter{ParameterName = "p_resId",  OracleType = OracleType.VarChar, Value = resid },
                        new OracleParameter{ParameterName = "p_innerUserId", OracleType = OracleType.Number,Value = inneruserid},
                        new OracleParameter{ParameterName = "p_flag",OracleType = OracleType.Number,Direction = ParameterDirection.Output}
                    };
                    OracleHelper.ExecuteNonQuery(CommandType.StoredProcedure, "PACK_RES.canShowMobile", p);
                    trans.Commit();
                    return p[2].Value.ToString() == "1";
                }
            }
            catch (Exception)
            {
                return false;
            }
            finally
            {
                if (conn.State == ConnectionState.Open)
                    conn.Close();
            }
        }

        public void HandlerMyAllocate(ref Pager pg, string resid, decimal? inneruserid, string resourcetag, decimal resourcetypeid, decimal isview, decimal isnew, DateTime? stime, DateTime? etime, string groupId, decimal? productId, decimal? subproductId, DateTime? stimeTH, DateTime? etimeTH, string pkids, string category, DateTime? stimeGD, DateTime? etimeGD, DateTime? stimeKT, DateTime? etimeKT, DateTime? stimeFP, DateTime? etimeFP, decimal? hasTH, decimal? hasGD, decimal fenpeiUser, decimal pici, string extxml, decimal? midproductid)
        {
            try
            {
                List<OracleParameter> p = new List<OracleParameter>
                {
                    new OracleParameter {ParameterName = "p_ResId", OracleType = OracleType.VarChar, Value = resid},
                    new OracleParameter {ParameterName = "p_pkids", OracleType = OracleType.VarChar, Value = pkids},
                    string.IsNullOrEmpty(groupId) ? new OracleParameter {ParameterName = "p_GroupId", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_GroupId", OracleType = OracleType.VarChar, Value = groupId},
                    inneruserid.HasValue ? new OracleParameter {ParameterName = "p_UserId", OracleType = OracleType.Number, Value = inneruserid} : new OracleParameter {ParameterName = "p_UserId", OracleType = OracleType.Number, Value = DBNull.Value},
                    new OracleParameter {ParameterName = "p_ResourceTypeId", OracleType = OracleType.Number, Value = resourcetypeid},
                    new OracleParameter {ParameterName = "p_ResourceTag", OracleType = OracleType.VarChar, Value = resourcetag},
                    new OracleParameter {ParameterName = "p_IsView", OracleType = OracleType.Number, Value = isview},
                    new OracleParameter {ParameterName = "p_IsNew", OracleType = OracleType.Number, Value = isnew},
                    new OracleParameter {ParameterName = "p_stime", OracleType = OracleType.DateTime, Value = stime},
                    new OracleParameter {ParameterName = "p_etime", OracleType = OracleType.DateTime, Value = etime},
                    new OracleParameter {ParameterName = "p_pageIndex", OracleType = OracleType.Number, Value = pg.page},
                    new OracleParameter {ParameterName = "p_pageSize", OracleType = OracleType.Number, Value = pg.rows},
                    string.IsNullOrEmpty(category) ? new OracleParameter {ParameterName = "p_category", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_category", OracleType = OracleType.VarChar, Value = category},
                    stimeTH.HasValue ? new OracleParameter {ParameterName = "p_stimeTH", OracleType = OracleType.DateTime, Value = stimeTH.Value} : new OracleParameter {ParameterName = "p_stimeTH", OracleType = OracleType.DateTime, Value = DBNull.Value },
                    etimeTH.HasValue ? new OracleParameter {ParameterName = "p_etimeTH", OracleType = OracleType.DateTime, Value = etimeTH.Value} : new OracleParameter {ParameterName = "p_etimeTH", OracleType = OracleType.DateTime, Value = DBNull.Value },
                    stimeGD.HasValue ? new OracleParameter {ParameterName = "p_stimeGD", OracleType = OracleType.DateTime, Value = stimeGD.Value} : new OracleParameter {ParameterName = "p_stimeGD", OracleType = OracleType.DateTime, Value = DBNull.Value },
                    etimeGD.HasValue ? new OracleParameter {ParameterName = "p_etimeGD", OracleType = OracleType.DateTime, Value = etimeGD.Value} : new OracleParameter {ParameterName = "p_etimeGD", OracleType = OracleType.DateTime, Value = DBNull.Value },
                    productId.HasValue ? new OracleParameter{ ParameterName = "p_productid",OracleType = OracleType.Number,Value = productId.Value} : new OracleParameter{ ParameterName = "p_productid", OracleType = OracleType.Number, Value = DBNull.Value },
                    subproductId.HasValue ? new OracleParameter{ ParameterName = "p_subproductid", OracleType = OracleType.Number, Value = subproductId.Value } : new OracleParameter{ ParameterName = "p_subproductid", OracleType = OracleType.Number, Value = DBNull.Value },
                    stimeKT.HasValue ? new OracleParameter {ParameterName = "p_stimeKT", OracleType = OracleType.DateTime, Value = stimeKT.Value} : new OracleParameter {ParameterName = "p_stimeKT", OracleType = OracleType.DateTime, Value = DBNull.Value },
                    etimeKT.HasValue ? new OracleParameter {ParameterName = "p_etimeKT", OracleType = OracleType.DateTime, Value = etimeKT.Value} : new OracleParameter {ParameterName = "p_etimeKT", OracleType = OracleType.DateTime, Value = DBNull.Value },
                    stimeFP.HasValue ? new OracleParameter {ParameterName = "p_stimeFP", OracleType = OracleType.DateTime, Value = stimeFP.Value} : new OracleParameter {ParameterName = "p_stimeFP", OracleType = OracleType.DateTime, Value = DBNull.Value },
                    etimeFP.HasValue ? new OracleParameter {ParameterName = "p_etimeFP", OracleType = OracleType.DateTime, Value = etimeFP.Value} : new OracleParameter {ParameterName = "p_etimeFP", OracleType = OracleType.DateTime, Value = DBNull.Value },
                    hasTH.HasValue ? new OracleParameter{ ParameterName = "p_hasTH", OracleType = OracleType.Number, Value = hasTH.Value } : new OracleParameter{ ParameterName = "p_hasTH", OracleType = OracleType.Number, Value = DBNull.Value },
                    hasGD.HasValue ? new OracleParameter{ ParameterName = "p_hasGD", OracleType = OracleType.Number, Value = hasGD.Value } : new OracleParameter{ ParameterName = "p_hasGD", OracleType = OracleType.Number, Value = DBNull.Value },
                    new OracleParameter {ParameterName = "p_fenpeiUser", OracleType = OracleType.Number, Value = fenpeiUser},
                    new OracleParameter {ParameterName = "p_pici", OracleType = OracleType.Number, Value = pici},
                    string.IsNullOrEmpty(extxml) ? new OracleParameter { ParameterName = "p_extxml", OracleType = OracleType.VarChar, Value = DBNull.Value } : new OracleParameter{ ParameterName= "p_extxml", OracleType = OracleType.VarChar, Value = extxml },
                    midproductid.HasValue ? new OracleParameter{ ParameterName = "p_midproductid", OracleType = OracleType.Number, Value = midproductid.Value  } : new OracleParameter{ ParameterName = "p_midProductId", OracleType = OracleType.Number, Value = DBNull.Value }
                };
                OracleHelper.ExecuteNonQuery(CommandType.StoredProcedure, "PACK_RES_ALLOCATE.UpdateAllocateAndFPR2", p.ToArray());

            }
            catch (Exception)
            {
                throw;
            }
        }

        #region 高级资源分配   高级资源分配列表
        public IList<SeniorDistributionDto> GetSeniorDistribution(ref Pager pg, SeniorDistributionQuery query)
        {
            var p = new List<OracleParameter>
            {
                string.IsNullOrEmpty(query.resId) ? new OracleParameter {ParameterName = "p_resId", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_resId", OracleType = OracleType.VarChar, Value = query.resId},
                string.IsNullOrEmpty(query.orderIds) ? new OracleParameter {ParameterName = "p_orderIds", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_orderIds", OracleType = OracleType.VarChar, Value = query.orderIds},
                query.orderType.HasValue ? new OracleParameter {ParameterName = "p_orderType", OracleType = OracleType.Number, Value = query.orderType.Value} : new OracleParameter {ParameterName = "p_orderType", OracleType = OracleType.Number, Value = DBNull.Value},
                query.midproductId.HasValue ? new OracleParameter{ ParameterName = "p_midProductId", OracleType = OracleType.Number, Value = query.midproductId.Value  } : new OracleParameter{ ParameterName = "p_midProductId", OracleType = OracleType.Number, Value = DBNull.Value },
                query.subProductId.HasValue ? new OracleParameter{ ParameterName = "p_subProductId", OracleType = OracleType.Number, Value = query.subProductId.Value } : new OracleParameter{ ParameterName = "p_subProductId", OracleType = OracleType.Number, Value = DBNull.Value },
                !string.IsNullOrEmpty(query.cname) ? new OracleParameter{ ParameterName = "p_cname", OracleType = OracleType.VarChar, Value = query.cname } : new OracleParameter{ ParameterName = "p_cname", OracleType = OracleType.VarChar, Value = DBNull.Value },


                string.IsNullOrEmpty(query.category) ? new OracleParameter {ParameterName = "p_category", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_category", OracleType = OracleType.VarChar, Value = query.category},
                query.openStartTime.HasValue ? new OracleParameter{ ParameterName = "p_openStartTime", OracleType = OracleType.DateTime, Value = query.openStartTime.Value } : new OracleParameter{ ParameterName = "p_openStartTime", OracleType = OracleType.DateTime, Value = DBNull.Value },
                query.openEndTime.HasValue ? new OracleParameter{ ParameterName = "p_openEndTime", OracleType = OracleType.DateTime, Value = query.openEndTime.Value } : new OracleParameter{ ParameterName = "p_openEndTime", OracleType = OracleType.DateTime, Value = DBNull.Value },
                query.fenpeiSTime.HasValue ? new OracleParameter{ ParameterName = "p_fenpeiSTime", OracleType = OracleType.DateTime, Value = query.fenpeiSTime.Value } : new OracleParameter{ ParameterName = "p_fenpeiSTime", OracleType = OracleType.DateTime, Value = DBNull.Value },
                query.fenpeiETime.HasValue ? new OracleParameter{ ParameterName = "p_fenpeiETime", OracleType = OracleType.DateTime, Value = query.fenpeiETime.Value } : new OracleParameter{ ParameterName = "p_fenpeiETime", OracleType = OracleType.DateTime, Value = DBNull.Value },
                query.isDistribute.HasValue ? new OracleParameter{ ParameterName = "p_isDistribute", OracleType = OracleType.Number, Value = query.isDistribute.Value } : new OracleParameter{ ParameterName = "p_isDistribute", OracleType = OracleType.Number, Value = DBNull.Value },
                query.isRefund.HasValue ? new OracleParameter{ ParameterName = "p_isRefund", OracleType = OracleType.Number, Value = query.isRefund.Value } : new OracleParameter{ ParameterName = "p_isRefund", OracleType = OracleType.Number, Value = DBNull.Value },
                new OracleParameter {ParameterName = "p_pageIndex", OracleType = OracleType.Number, Value = pg.page},
                new OracleParameter {ParameterName = "p_pageSize", OracleType = OracleType.Number, Value = pg.rows},
                new OracleParameter {ParameterName = "p_data", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output},
                query.eid.HasValue ? new OracleParameter {ParameterName = "p_UserId", OracleType = OracleType.Number, Value = query.eid.Value} : new OracleParameter {ParameterName = "p_UserId", OracleType = OracleType.Number, Value = DBNull.Value},
                !string.IsNullOrEmpty(query.groupId) ? new OracleParameter {ParameterName = "p_group", OracleType = OracleType.VarChar, Value = query.groupId} : new OracleParameter {ParameterName = "p_group", OracleType = OracleType.VarChar, Value = DBNull.Value},
                !string.IsNullOrEmpty(query.amounttypeid) ? new OracleParameter {ParameterName = "p_amounttypeid", OracleType = OracleType.VarChar, Value = query.amounttypeid} : new OracleParameter {ParameterName = "p_amounttypeid", OracleType = OracleType.VarChar, Value = DBNull.Value},
                //query.hasAfterSale.HasValue ? new OracleParameter {ParameterName = "p_hasAfterSale", OracleType = OracleType.Number, Value = query.hasAfterSale.Value } : new OracleParameter {ParameterName = "p_hasAfterSale", OracleType = OracleType.Number, Value = DBNull.Value }

            };

            var ds = OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_RES_ALLOCATE.GetSeniorDistribution_New", p.ToArray());

            return ds.Tables[0].ToList<SeniorDistributionDto>();
        }

        public IList<MySeniorDistributionDto> GetMySeniorDistribution(ref Pager pg, MySeniorDistributionQuery query)
        {
            var p = new List<OracleParameter>
            {
                string.IsNullOrEmpty(query.groupId) ? new OracleParameter {ParameterName = "p_GroupId", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_GroupId", OracleType = OracleType.VarChar, Value = query.groupId},
                query.userId.HasValue ? new OracleParameter {ParameterName = "p_UserId", OracleType = OracleType.Number, Value = query.userId.Value} : new OracleParameter {ParameterName = "p_UserId", OracleType = OracleType.Number, Value = DBNull.Value},
                string.IsNullOrEmpty(query.resId) ? new OracleParameter {ParameterName = "p_resId", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_resId", OracleType = OracleType.VarChar, Value = query.resId},
                query.orderId.HasValue ? new OracleParameter {ParameterName = "p_orderId", OracleType = OracleType.Number, Value = query.orderId.Value} : new OracleParameter {ParameterName = "p_orderId", OracleType = OracleType.Number, Value = DBNull.Value},
                query.orderType.HasValue ? new OracleParameter {ParameterName = "p_orderType", OracleType = OracleType.Number, Value = query.orderType.Value} : new OracleParameter {ParameterName = "p_orderType", OracleType = OracleType.Number, Value = DBNull.Value},
                query.midproductId.HasValue ? new OracleParameter{ ParameterName = "p_midProductId", OracleType = OracleType.Number, Value = query.midproductId.Value  } : new OracleParameter{ ParameterName = "p_midProductId", OracleType = OracleType.Number, Value = DBNull.Value },
                query.subProductId.HasValue ? new OracleParameter{ ParameterName = "p_subProductId", OracleType = OracleType.Number, Value = query.subProductId.Value } : new OracleParameter{ ParameterName = "p_subProductId", OracleType = OracleType.Number, Value = DBNull.Value },
                string.IsNullOrEmpty(query.category) ? new OracleParameter {ParameterName = "p_category", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_category", OracleType = OracleType.VarChar, Value = query.category},
                query.openStartTime.HasValue ? new OracleParameter{ ParameterName = "p_openStartTime", OracleType = OracleType.DateTime, Value = query.openStartTime.Value } : new OracleParameter{ ParameterName = "p_openStartTime", OracleType = OracleType.DateTime, Value = DBNull.Value },
                query.openEndTime.HasValue ? new OracleParameter{ ParameterName = "p_openEndTime", OracleType = OracleType.DateTime, Value = query.openEndTime.Value } : new OracleParameter{ ParameterName = "p_openEndTime", OracleType = OracleType.DateTime, Value = DBNull.Value },
                query.isRefund.HasValue ? new OracleParameter{ ParameterName = "p_isRefund", OracleType = OracleType.Number, Value = query.isRefund.Value } : new OracleParameter{ ParameterName = "p_isRefund", OracleType = OracleType.Number, Value = DBNull.Value },
                new OracleParameter {ParameterName = "p_pageIndex", OracleType = OracleType.Number, Value = pg.page},
                new OracleParameter {ParameterName = "p_pageSize", OracleType = OracleType.Number, Value = pg.rows},
                !string.IsNullOrEmpty(query.amounttypeid) ? new OracleParameter {ParameterName = "p_amounttypeid", OracleType = OracleType.VarChar, Value = query.amounttypeid} : new OracleParameter {ParameterName = "p_amounttypeid", OracleType = OracleType.VarChar, Value = DBNull.Value},
                new OracleParameter {ParameterName = "p_data", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output}
            };
            var ds = OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_RES_ALLOCATE.GetMySeniorRes", p.ToArray());
            return ds.Tables[0].ToList<MySeniorDistributionDto>();
        }

        #endregion

        #region 客服部资源分配   客服部资源分配列表
        public IList<SeniorKFBDistributionDto> GetKFBSeniorDistribution(ref Pager pg, SeniorDistributionQuery query)
        {
            var p = new List<OracleParameter>
            {
                string.IsNullOrEmpty(query.resId) ? new OracleParameter {ParameterName = "p_resId", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_resId", OracleType = OracleType.VarChar, Value = query.resId},
                string.IsNullOrEmpty(query.orderIds) ? new OracleParameter {ParameterName = "p_orderIds", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_orderIds", OracleType = OracleType.VarChar, Value = query.orderIds},
                query.orderType.HasValue ? new OracleParameter {ParameterName = "p_orderType", OracleType = OracleType.Number, Value = query.orderType.Value} : new OracleParameter {ParameterName = "p_orderType", OracleType = OracleType.Number, Value = DBNull.Value},
                query.midproductId.HasValue ? new OracleParameter{ ParameterName = "p_midProductId", OracleType = OracleType.Number, Value = query.midproductId.Value  } : new OracleParameter{ ParameterName = "p_midProductId", OracleType = OracleType.Number, Value = DBNull.Value },
                query.subProductId.HasValue ? new OracleParameter{ ParameterName = "p_subProductId", OracleType = OracleType.Number, Value = query.subProductId.Value } : new OracleParameter{ ParameterName = "p_subProductId", OracleType = OracleType.Number, Value = DBNull.Value },
                !string.IsNullOrEmpty(query.cname) ? new OracleParameter{ ParameterName = "p_cname", OracleType = OracleType.VarChar, Value = query.cname } : new OracleParameter{ ParameterName = "p_cname", OracleType = OracleType.VarChar, Value = DBNull.Value },


                string.IsNullOrEmpty(query.category) ? new OracleParameter {ParameterName = "p_category", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_category", OracleType = OracleType.VarChar, Value = query.category},
                query.openStartTime.HasValue ? new OracleParameter{ ParameterName = "p_openStartTime", OracleType = OracleType.DateTime, Value = query.openStartTime.Value } : new OracleParameter{ ParameterName = "p_openStartTime", OracleType = OracleType.DateTime, Value = DBNull.Value },
                query.openEndTime.HasValue ? new OracleParameter{ ParameterName = "p_openEndTime", OracleType = OracleType.DateTime, Value = query.openEndTime.Value } : new OracleParameter{ ParameterName = "p_openEndTime", OracleType = OracleType.DateTime, Value = DBNull.Value },
                query.fenpeiSTime.HasValue ? new OracleParameter{ ParameterName = "p_fenpeiSTime", OracleType = OracleType.DateTime, Value = query.fenpeiSTime.Value } : new OracleParameter{ ParameterName = "p_fenpeiSTime", OracleType = OracleType.DateTime, Value = DBNull.Value },
                query.fenpeiETime.HasValue ? new OracleParameter{ ParameterName = "p_fenpeiETime", OracleType = OracleType.DateTime, Value = query.fenpeiETime.Value } : new OracleParameter{ ParameterName = "p_fenpeiETime", OracleType = OracleType.DateTime, Value = DBNull.Value },
                query.isDistribute.HasValue ? new OracleParameter{ ParameterName = "p_isDistribute", OracleType = OracleType.Number, Value = query.isDistribute.Value } : new OracleParameter{ ParameterName = "p_isDistribute", OracleType = OracleType.Number, Value = DBNull.Value },
                query.isRefund.HasValue ? new OracleParameter{ ParameterName = "p_isRefund", OracleType = OracleType.Number, Value = query.isRefund.Value } : new OracleParameter{ ParameterName = "p_isRefund", OracleType = OracleType.Number, Value = DBNull.Value },
                new OracleParameter {ParameterName = "p_pageIndex", OracleType = OracleType.Number, Value = pg.page},
                new OracleParameter {ParameterName = "p_pageSize", OracleType = OracleType.Number, Value = pg.rows},
                new OracleParameter {ParameterName = "p_data", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output},
                query.eid.HasValue ? new OracleParameter {ParameterName = "p_UserId", OracleType = OracleType.Number, Value = query.eid.Value} : new OracleParameter {ParameterName = "p_UserId", OracleType = OracleType.Number, Value = DBNull.Value},
                !string.IsNullOrEmpty(query.groupId) ? new OracleParameter {ParameterName = "p_group", OracleType = OracleType.VarChar, Value = query.groupId} : new OracleParameter {ParameterName = "p_group", OracleType = OracleType.VarChar, Value = DBNull.Value},
                !string.IsNullOrEmpty(query.amounttypeid) ? new OracleParameter {ParameterName = "p_amounttypeid", OracleType = OracleType.VarChar, Value = query.amounttypeid} : new OracleParameter {ParameterName = "p_amounttypeid", OracleType = OracleType.VarChar, Value = DBNull.Value},
                //query.hasAfterSale.HasValue ? new OracleParameter {ParameterName = "p_hasAfterSale", OracleType = OracleType.Number, Value = query.hasAfterSale.Value } : new OracleParameter {ParameterName = "p_hasAfterSale", OracleType = OracleType.Number, Value = DBNull.Value }

            };

            var ds = OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_RES_ALLOCATE.GetKFBSeniorDistribution_New", p.ToArray());

            return ds.Tables[0].ToList<SeniorKFBDistributionDto>();
        }

        public IList<MySeniorKFBDistributionDto> GetKFBMySeniorDistribution(ref Pager pg, MySeniorDistributionQuery query)
        {
            var p = new List<OracleParameter>
            {
                string.IsNullOrEmpty(query.groupId) ? new OracleParameter {ParameterName = "p_GroupId", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_GroupId", OracleType = OracleType.VarChar, Value = query.groupId},
                query.userId.HasValue ? new OracleParameter {ParameterName = "p_UserId", OracleType = OracleType.Number, Value = query.userId.Value} : new OracleParameter {ParameterName = "p_UserId", OracleType = OracleType.Number, Value = DBNull.Value},
                string.IsNullOrEmpty(query.resId) ? new OracleParameter {ParameterName = "p_resId", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_resId", OracleType = OracleType.VarChar, Value = query.resId},
                query.orderId.HasValue ? new OracleParameter {ParameterName = "p_orderId", OracleType = OracleType.Number, Value = query.orderId.Value} : new OracleParameter {ParameterName = "p_orderId", OracleType = OracleType.Number, Value = DBNull.Value},
                query.orderType.HasValue ? new OracleParameter {ParameterName = "p_orderType", OracleType = OracleType.Number, Value = query.orderType.Value} : new OracleParameter {ParameterName = "p_orderType", OracleType = OracleType.Number, Value = DBNull.Value},
                query.midproductId.HasValue ? new OracleParameter{ ParameterName = "p_midProductId", OracleType = OracleType.Number, Value = query.midproductId.Value  } : new OracleParameter{ ParameterName = "p_midProductId", OracleType = OracleType.Number, Value = DBNull.Value },
                query.subProductId.HasValue ? new OracleParameter{ ParameterName = "p_subProductId", OracleType = OracleType.Number, Value = query.subProductId.Value } : new OracleParameter{ ParameterName = "p_subProductId", OracleType = OracleType.Number, Value = DBNull.Value },
                string.IsNullOrEmpty(query.category) ? new OracleParameter {ParameterName = "p_category", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_category", OracleType = OracleType.VarChar, Value = query.category},
                query.openStartTime.HasValue ? new OracleParameter{ ParameterName = "p_openStartTime", OracleType = OracleType.DateTime, Value = query.openStartTime.Value } : new OracleParameter{ ParameterName = "p_openStartTime", OracleType = OracleType.DateTime, Value = DBNull.Value },
                query.openEndTime.HasValue ? new OracleParameter{ ParameterName = "p_openEndTime", OracleType = OracleType.DateTime, Value = query.openEndTime.Value } : new OracleParameter{ ParameterName = "p_openEndTime", OracleType = OracleType.DateTime, Value = DBNull.Value },
                query.isRefund.HasValue ? new OracleParameter{ ParameterName = "p_isRefund", OracleType = OracleType.Number, Value = query.isRefund.Value } : new OracleParameter{ ParameterName = "p_isRefund", OracleType = OracleType.Number, Value = DBNull.Value },
                new OracleParameter {ParameterName = "p_pageIndex", OracleType = OracleType.Number, Value = pg.page},
                new OracleParameter {ParameterName = "p_pageSize", OracleType = OracleType.Number, Value = pg.rows},
                !string.IsNullOrEmpty(query.amounttypeid) ? new OracleParameter {ParameterName = "p_amounttypeid", OracleType = OracleType.VarChar, Value = query.amounttypeid} : new OracleParameter {ParameterName = "p_amounttypeid", OracleType = OracleType.VarChar, Value = DBNull.Value},
                new OracleParameter {ParameterName = "p_data", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output}
            };
            var ds = OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_RES_ALLOCATE.GetKFBMySeniorRes", p.ToArray());
            return ds.Tables[0].ToList<MySeniorKFBDistributionDto>();
        }

        #endregion


        public void ExeSeniorDistribute(SeniorDistributionQuery query)
        {
            var p = new List<OracleParameter>
            {
                string.IsNullOrEmpty(query.resId) ? new OracleParameter {ParameterName = "p_resId", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_resId", OracleType = OracleType.VarChar, Value = query.resId},
                string.IsNullOrEmpty(query.orderIds) ? new OracleParameter {ParameterName = "p_orderIds", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_orderIds", OracleType = OracleType.VarChar, Value = query.orderIds},
                query.orderType.HasValue ? new OracleParameter {ParameterName = "p_orderType", OracleType = OracleType.Number, Value = query.orderType.Value} : new OracleParameter {ParameterName = "p_orderType", OracleType = OracleType.Number, Value = DBNull.Value},
                query.midproductId.HasValue ? new OracleParameter{ ParameterName = "p_midProductId", OracleType = OracleType.Number, Value = query.midproductId.Value  } : new OracleParameter{ ParameterName = "p_midProductId", OracleType = OracleType.Number, Value = DBNull.Value },
                query.subProductId.HasValue ? new OracleParameter{ ParameterName = "p_subProductId", OracleType = OracleType.Number, Value = query.subProductId.Value } : new OracleParameter{ ParameterName = "p_subProductId", OracleType = OracleType.Number, Value = DBNull.Value },
                !string.IsNullOrEmpty(query.cname) ? new OracleParameter{ ParameterName = "p_cname", OracleType = OracleType.VarChar, Value = query.cname } : new OracleParameter{ ParameterName = "p_cname", OracleType = OracleType.VarChar, Value = DBNull.Value },

                string.IsNullOrEmpty(query.category) ? new OracleParameter {ParameterName = "p_category", OracleType = OracleType.VarChar, Value = DBNull.Value} : new OracleParameter {ParameterName = "p_category", OracleType = OracleType.VarChar, Value = query.category},
                query.openStartTime.HasValue ? new OracleParameter{ ParameterName = "p_openStartTime", OracleType = OracleType.DateTime, Value = query.openStartTime.Value } : new OracleParameter{ ParameterName = "p_openStartTime", OracleType = OracleType.DateTime, Value = DBNull.Value },
                query.openEndTime.HasValue ? new OracleParameter{ ParameterName = "p_openEndTime", OracleType = OracleType.DateTime, Value = query.openEndTime.Value } : new OracleParameter{ ParameterName = "p_openEndTime", OracleType = OracleType.DateTime, Value = DBNull.Value },
                query.fenpeiSTime.HasValue ? new OracleParameter{ ParameterName = "p_fenpeiSTime", OracleType = OracleType.DateTime, Value = query.fenpeiSTime.Value } : new OracleParameter{ ParameterName = "p_fenpeiSTime", OracleType = OracleType.DateTime, Value = DBNull.Value },
                query.fenpeiETime.HasValue ? new OracleParameter{ ParameterName = "p_fenpeiETime", OracleType = OracleType.DateTime, Value = query.fenpeiETime.Value } : new OracleParameter{ ParameterName = "p_fenpeiETime", OracleType = OracleType.DateTime, Value = DBNull.Value },
                query.isDistribute.HasValue ? new OracleParameter{ ParameterName = "p_isDistribute", OracleType = OracleType.Number, Value = query.isDistribute.Value } : new OracleParameter{ ParameterName = "p_isDistribute", OracleType = OracleType.Number, Value = DBNull.Value },
                query.isRefund.HasValue ? new OracleParameter{ ParameterName = "p_isRefund", OracleType = OracleType.Number, Value = query.isRefund.Value } : new OracleParameter{ ParameterName = "p_isRefund", OracleType = OracleType.Number, Value = DBNull.Value },
                new OracleParameter {ParameterName = "p_pageIndex", OracleType = OracleType.Number, Value = 1},
                new OracleParameter {ParameterName = "p_pageSize", OracleType = OracleType.Number, Value = int.MaxValue},
                new OracleParameter {ParameterName = "p_fenpeiUser", OracleType = OracleType.Number, Value = query.fenpeiUser},
                new OracleParameter {ParameterName = "p_pici", OracleType = OracleType.Number, Value = query.pici},
                query.eid.HasValue ? new OracleParameter {ParameterName = "p_UserId", OracleType = OracleType.Number, Value = query.eid.Value} : new OracleParameter {ParameterName = "p_UserId", OracleType = OracleType.Number, Value = DBNull.Value},
                !string.IsNullOrEmpty(query.groupId) ? new OracleParameter {ParameterName = "p_group", OracleType = OracleType.VarChar, Value = query.groupId} : new OracleParameter {ParameterName = "p_group", OracleType = OracleType.VarChar, Value = DBNull.Value}
            };
            OracleHelper.ExecuteNonQuery(CommandType.StoredProcedure, "PACK_RES_ALLOCATE.ExeSeniorDistribute", p.ToArray());
        }

        public void ExeSeniorDistributeByResId(decimal fenpeiUser, decimal pici, string remark, decimal isNew)
        {
            var p = new List<OracleParameter>
            {
                new OracleParameter {ParameterName = "p_fenpeiUser", OracleType = OracleType.Number, Value = fenpeiUser},
                new OracleParameter {ParameterName = "p_pici", OracleType = OracleType.Number, Value = pici},
                new OracleParameter {ParameterName = "p_isview", OracleType = OracleType.Number, Value = isNew},
                new OracleParameter {ParameterName = "p_remark", OracleType = OracleType.VarChar, Value = remark}
            };
            OracleHelper.ExecuteNonQuery(CommandType.StoredProcedure, "PACK_RES_ALLOCATE.ExeSeniorDistributeByResId", p.ToArray());
        }


    }

}