using System;
using System.Collections.Generic;
using System.Data;
using System.Data.OracleClient;

namespace WX.CRM.DAL.Qc
{
    public class UserScore_DL
    {
        /// <summary>
        /// 员工评分明细 页底汇总
        /// </summary>
        /// <param name="groupId"></param>
        /// <param name="inneruserId"></param>
        /// <param name="status"></param>
        /// <param name="stime"></param>
        /// <param name="etime"></param>
        /// <returns></returns>
        public DataTable GetUserScoreDetialCount(string groupId, string inneruserId, decimal? status, DateTime? stime, DateTime? etime)
        {
            try
            {

                var para = new List<OracleParameter>();
                para.Add(new OracleParameter() { ParameterName = "v_groupId", OracleType = OracleType.NVarChar, Value = groupId });
                para.Add(new OracleParameter() { ParameterName = "v_userId", OracleType = OracleType.NVarChar, Value = inneruserId });
                para.Add(new OracleParameter() { ParameterName = "v_status", OracleType = OracleType.Number, Value = status });
                para.Add(new OracleParameter() { ParameterName = "v_stime", OracleType = OracleType.DateTime, Value = stime });
                para.Add(new OracleParameter() { ParameterName = "v_etime", OracleType = OracleType.DateTime, Value = etime });
                para.Add(new OracleParameter() { ParameterName = "v_data", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output });
                return OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_QC_SCORE.QC_UserScoreDetialCount", para.ToArray()).Tables[0];
            }
            catch
            {
                throw;
            }
        }
        /// <summary>
        ///员工评分汇总表查询
        /// </summary>
        /// <param name="groupId"></param>
        /// <param name="inneruserId"></param>
        /// <param name="status"></param>
        /// <param name="stime"></param>
        /// <param name="etime"></param>
        /// <returns></returns>
        public DataTable GetUserScoreCollect(string groupId, string inneruserId, decimal? status, DateTime? stime, DateTime? etime)
        {
            try
            {
                var para = new List<OracleParameter>();
                para.Add(new OracleParameter() { ParameterName = "v_groupId", OracleType = OracleType.NVarChar, Value = groupId });
                para.Add(new OracleParameter() { ParameterName = "v_userId", OracleType = OracleType.NVarChar, Value = inneruserId });
                para.Add(new OracleParameter() { ParameterName = "v_status", OracleType = OracleType.Number, Value = status });
                para.Add(new OracleParameter() { ParameterName = "v_stime", OracleType = OracleType.DateTime, Value = stime });
                para.Add(new OracleParameter() { ParameterName = "v_etime", OracleType = OracleType.DateTime, Value = etime });
                para.Add(new OracleParameter() { ParameterName = "v_data", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output });
                return OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_QC_SCORE.QC_UserScoreCollect", para.ToArray()).Tables[0];
            }
            catch
            {
                throw;
            }
        }
        /// <summary>
        /// 主管评分明细 页底汇总
        /// </summary>
        /// <param name="groupId"></param>
        /// <param name="grouperEid"></param>
        /// <param name="userEId"></param>
        /// <param name="scoreNo"></param>
        /// <param name="status"></param>
        /// <param name="stime"></param>
        /// <param name="etime"></param>
        /// <returns></returns>
        public DataTable GetGrouperScoreDetialCount(string groupId, decimal? grouperEid, decimal? userEId, decimal? scoreNo, decimal? status, DateTime? stime, DateTime? etime)
        {
            try
            {
                var para = new List<OracleParameter>();
                para.Add(new OracleParameter() { ParameterName = "v_groupId", OracleType = OracleType.NVarChar, Value = groupId });
                para.Add(new OracleParameter() { ParameterName = "v_grouperEid", OracleType = OracleType.Number, Value = grouperEid });
                para.Add(new OracleParameter() { ParameterName = "v_userEid", OracleType = OracleType.Number, Value = userEId });
                para.Add(new OracleParameter() { ParameterName = "v_scoreNo", OracleType = OracleType.Number, Value = scoreNo });
                para.Add(new OracleParameter() { ParameterName = "v_status", OracleType = OracleType.Number, Value = status });
                para.Add(new OracleParameter() { ParameterName = "v_stime", OracleType = OracleType.DateTime, Value = stime });
                para.Add(new OracleParameter() { ParameterName = "v_etime", OracleType = OracleType.DateTime, Value = etime });
                para.Add(new OracleParameter() { ParameterName = "v_data", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output });
                return OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_QC_SCORE.QC_GrouperScoreDetialCount", para.ToArray()).Tables[0];
            }
            catch
            {
                throw;
            }
        }

        /// <summary>
        /// 主管评分汇总
        /// </summary>
        /// <param name="groupId"></param>
        /// <param name="grouperEid"></param>
        /// <param name="userEId"></param>
        /// <param name="scoreNo"></param>
        /// <param name="status"></param>
        /// <param name="stime"></param>
        /// <param name="etime"></param>
        /// <returns></returns>
        public DataTable GetGrouperScoreCollect(string groupId, decimal? grouperEid, decimal? status, DateTime? stime, DateTime? etime)
        {
            try
            {
                var para = new List<OracleParameter>();
                para.Add(new OracleParameter() { ParameterName = "v_groupId", OracleType = OracleType.NVarChar, Value = groupId });
                para.Add(new OracleParameter() { ParameterName = "v_grouperEid", OracleType = OracleType.Number, Value = grouperEid });
                para.Add(new OracleParameter() { ParameterName = "v_status", OracleType = OracleType.Number, Value = status });
                para.Add(new OracleParameter() { ParameterName = "v_stime", OracleType = OracleType.DateTime, Value = stime });
                para.Add(new OracleParameter() { ParameterName = "v_etime", OracleType = OracleType.DateTime, Value = etime });
                para.Add(new OracleParameter() { ParameterName = "v_data", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output });
                return OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_QC_SCORE.QC_GrouperScoreCollect", para.ToArray()).Tables[0];
            }
            catch
            {
                throw;
            }
        }
        /// <summary>
        /// 删除数据
        /// </summary>
        /// <param name="type"></param>
        /// <param name="stime"></param>
        /// <param name="etime"></param>
        public void DeleteScoreData(string type, DateTime? stime, DateTime? etime)
        {
            try
            {
                var para = new List<OracleParameter>();
                para.Add(new OracleParameter() { ParameterName = "v_type", OracleType = OracleType.NVarChar, Value = type });
                para.Add(new OracleParameter() { ParameterName = "v_stime", OracleType = OracleType.DateTime, Value = stime });
                para.Add(new OracleParameter() { ParameterName = "v_etime", OracleType = OracleType.DateTime, Value = etime });
                OracleHelper.ExecuteNonQuery(CommandType.StoredProcedure, "PACK_QC_SCORE.QC_DeleteScoreData", para.ToArray());
            }
            catch
            {
                throw;
            }
        }
    }


}