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

namespace WX.CRM.DAL.Res
{
    public class RES_SCENE_DAL
    {
        public DataSet List(ref Pager pager, QueryUserComboDto usercomboDto, string nickName, decimal? sceneType, DateTime? sTime, DateTime? eTime)
        {
            try
            {
                var p = new List<OracleParameter>
                {
                    usercomboDto.userId.HasValue ? new OracleParameter() { ParameterName = "p_inneruserId", OracleType = OracleType.Number, Value = usercomboDto.userId.Value } : new OracleParameter() { ParameterName = "p_inneruserId", OracleType = OracleType.Number, Value = DBNull.Value },
                    string.IsNullOrEmpty(usercomboDto.groupIds) ? new OracleParameter() { ParameterName = "p_groupId", OracleType = OracleType.VarChar, Value = DBNull.Value }: new OracleParameter() { ParameterName = "p_groupId", OracleType = OracleType.VarChar, Value = usercomboDto.groupIds },
                    string.IsNullOrEmpty(usercomboDto.deptId) ? new OracleParameter() { ParameterName = "p_deptId", OracleType = OracleType.VarChar, Value = DBNull.Value }: new OracleParameter() { ParameterName = "p_deptId", OracleType = OracleType.VarChar, Value = usercomboDto.deptId },
                    usercomboDto.companyId.HasValue ? new OracleParameter() { ParameterName = "p_companyId", OracleType = OracleType.Number, Value = usercomboDto.companyId.Value } : new OracleParameter() { ParameterName = "p_companyId", OracleType = OracleType.Number, Value = DBNull.Value },
                    string.IsNullOrEmpty(nickName) ? new OracleParameter() { ParameterName = "p_nickName", OracleType = OracleType.VarChar, Value = DBNull.Value }: new OracleParameter() { ParameterName = "p_nickName", OracleType = OracleType.VarChar, Value = nickName },
                    sceneType.HasValue ? new OracleParameter() { ParameterName = "p_sceneType", OracleType = OracleType.Number, Value = sceneType.Value } : new OracleParameter() { ParameterName = "p_sceneType", OracleType = OracleType.Number, Value = DBNull.Value },
                    sTime.HasValue ? new OracleParameter() { ParameterName = "p_sTime", OracleType = OracleType.DateTime, Value = sTime.Value } : new OracleParameter() { ParameterName = "p_sTime", OracleType = OracleType.DateTime, Value = DBNull.Value },
                    eTime.HasValue ? new OracleParameter() { ParameterName = "p_eTime", OracleType = OracleType.DateTime, Value = eTime.Value } : new OracleParameter() { ParameterName = "p_eTime", OracleType = OracleType.DateTime, Value = DBNull.Value },
                    new OracleParameter {ParameterName = "p_pageIndex", OracleType = OracleType.Number, Value = pager.page},
                    new OracleParameter {ParameterName = "p_pageSize", OracleType = OracleType.Number, Value = pager.rows},
                    new OracleParameter {ParameterName = "p_list", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output},
                };

                return OracleHelper.DataQueray(CommandType.StoredProcedure, "pack_wx_res.GetSceneRes", p.ToArray());
            }
            catch (Exception ex)
            {

                throw;
            }
        }
    }
}