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

namespace WX.CRM.DAL.Wx
{
    public class WX_GROUP_DAL
    {

        /// <summary>
        /// 群维护
        /// </summary>
        /// <param name="v_chatroomname"></param>
        /// <param name="v_name"></param>
        /// <param name="v_ROOMOWNER"></param>
        /// <param name="v_createtime"></param>
        public bool WxGroupMaintain(string v_chatroomname, string v_name, string v_ROOMOWNER, DateTime v_createtime, string v_ShortName)
        {
            // LogHelper.Error(string.Format("WxGroupMaintain=>v_chatroomname:{0},v_name:{1},v_ROOMOWNER:{2},v_createtime:{3},v_ShortName:{4}", v_chatroomname, v_name, v_ROOMOWNER, v_createtime.ToString("yyyy-MM-dd mm:hh:ss"), v_ShortName));
            bool isSucced = true;
            try
            {
                var p = new List<OracleParameter>()
                {
                      new OracleParameter() { ParameterName = "v_chatroomname",  OracleType = OracleType.VarChar, Value =v_chatroomname },
                      new OracleParameter() { ParameterName = "v_name",  OracleType = OracleType.NVarChar, Value =v_name },
                      new OracleParameter() { ParameterName = "v_ROOMOWNER",  OracleType = OracleType.VarChar, Value =v_ROOMOWNER },
                      new OracleParameter() { ParameterName = "v_createtime",  OracleType = OracleType.DateTime, Value =v_createtime },
                      new OracleParameter() { ParameterName = "v_ShortName",  OracleType = OracleType.NVarChar, Value =v_ShortName }
                };
                OracleHelper.ExecuteNonQuery(CommandType.StoredProcedure, "PACK_WX_GROUP.WxGroupMaintain", p.ToArray());
            }
            catch (Exception ex)
            {
                LogHelper.Error(string.Format("v_chatroomname:{0},v_name:{1},v_ROOMOWNER:{2},v_createtime:{3}", v_chatroomname, v_name, v_ROOMOWNER, v_createtime.ToString("yyyy-MM-dd mm:hh:ss")));
                LogHelper.Error("PACK_WX_GROUP.WxGroupMaintain:" + ex.ToString());
                isSucced = false;
            }
            return isSucced;
        }
        /// <summary>
        /// 群成员维护
        /// </summary>
        /// <param name="v_chatroomname"></param>
        /// <param name="v_name"></param>
        /// <param name="v_ROOMOWNER"></param>
        /// <param name="v_createtime"></param>
        public bool WxGroupMemberMaintain(string v_chatroomname, string v_username, string v_nickname, string v_placenickname, string v_loginUsername)
        {
            //LogHelper.Error(string.Format("WxGroupMemberMaintain=>v_chatroomname:{0},v_username:{1},v_nickname:{2},v_placenickname:{3},v_loginUsername:{4}", v_chatroomname, v_username, v_nickname, v_placenickname, v_loginUsername));
            bool isSucced = true;
            try
            {
                var p = new List<OracleParameter>()
                {
                      new OracleParameter() { ParameterName = "v_chatroomname",  OracleType = OracleType.VarChar, Value =v_chatroomname },
                      new OracleParameter() { ParameterName = "v_username",  OracleType = OracleType.VarChar, Value =v_username },
                      new OracleParameter() { ParameterName = "v_nickname",  OracleType = OracleType.NVarChar, Value =v_nickname },
                      string.IsNullOrEmpty(v_placenickname)? new OracleParameter() { ParameterName = "v_placenickname",  OracleType = OracleType.NVarChar, Value =DBNull.Value }: new OracleParameter() { ParameterName = "v_placenickname",  OracleType = OracleType.NVarChar, Value =v_placenickname },
                      new OracleParameter() { ParameterName = "v_loginUsername",  OracleType = OracleType.VarChar, Value =v_loginUsername }
                };
                OracleHelper.ExecuteNonQuery(CommandType.StoredProcedure, "PACK_WX_GROUP.WxGroupMemberMaintain", p.ToArray());
            }
            catch (Exception ex)
            {
                LogHelper.Error(string.Format("v_chatroomname:{0},v_username:{1},v_nickname:{2},v_placenickname:{3},v_loginUsername:{4}", v_chatroomname, v_username, v_nickname, v_placenickname, v_loginUsername));
                LogHelper.Error("PACK_WX_GROUP.WxGroupMemberMaintain:" + ex.ToString());

                isSucced = false;
            }
            return isSucced;
        }

        public DataTable GetGroupNumber(string v_roomname)
        {
            DataTable tab = null;
            try
            {
                var p = new List<OracleParameter>()
                {
                      new OracleParameter() { ParameterName = "v_roomname",  OracleType = OracleType.VarChar, Value =v_roomname },
                      new OracleParameter() { ParameterName = "v_data", OracleType = OracleType.Cursor, Direction = ParameterDirection.Output }

                };
                tab = OracleHelper.DataQueray(CommandType.StoredProcedure, "PACK_WX_GROUP.GetGroupNumberByWorkAccount", p.ToArray()).Tables[0];
            }
            catch (Exception ex)
            {
                LogHelper.Error("PACK_WX_GROUP.GetGroupNumberByWorkAccount:" + ex.ToString());
            }
            return tab;
        }
    }
}