using DClient;using System;using System.Collections.Generic;using System.Configuration;using System.Linq;using System.Text;using System.Threading.Tasks;namespace CouchBaseDAL{    public class CsCouchBaseHelper    {        static Repository myRepository = DClientHelper.GetRepository(ConfigurationManager.AppSettings["CouchBaseBucketName"], ConfigurationManager.AppSettings["db_adminName"], ConfigurationManager.AppSettings["db_adminPassWord"]);        static string id;        static string msg;        /// <summary>        /// 增加        /// </summary>        /// <typeparam name="T">實體類</typeparam>        /// <param name="doc">實體</param>        /// <returns></returns>        public static bool Add<T>(T doc) where T : class        {            return myRepository.Add(doc, out id, out msg);        }        /// <summary>        /// 修改        /// </summary>        /// <typeparam name="T">實體類</typeparam>        /// <param name="id">主鍵ID</param>        /// <param name="doc">實體</param>        /// <returns></returns>        public static bool Update<T>(string id, T doc) where T : class        {            return myRepository.Update(id, doc, out msg);        }        /// <summary>        /// 刪除        /// </summary>        /// <param name="id">主鍵ID</param>        /// <returns></returns>        public static bool Delete(string id)        {            return myRepository.Delete(id, out msg);        }        /// <summary>        /// 取到一個唯一的實體        /// </summary>        /// <typeparam name="T">實體類</typeparam>        /// <param name="id">主鍵ID</param>        /// <returns></returns>        public static T Get<T>(string id) where T : class        {            return myRepository.Get<T>(id, out msg);        }        /// <summary>        /// 查詢1參數        /// </summary>        /// <typeparam name="T">實體類</typeparam>        /// <param name="fieldName">參數名</param>        /// <param name="fieldValueFrom">參數數值范圍</param>        /// <param name="fieldValueTo">參數數值范圍</param>        /// <param name="limitNum">取出數據的條數</param>        /// <param name="skipNum">跳過多少條</param>        /// <returns></returns>        public static List<T> Query<T>(string fieldName, object fieldValueFrom, object fieldValueTo, int limitNum = 0, int skipNum = 0) where T : class        {            return myRepository.Query<T>(fieldName, fieldValueFrom, fieldValueTo, out msg, StaleSetting.State.False, limitNum, skipNum).Select<QueryResult<T>, T>(d => d.value).ToList();        }        /// <summary>        /// 查詢記錄數1參數        /// </summary>        /// <typeparam name="T">實體類</typeparam>        /// <param name="fieldName">參數</param>        /// <param name="fieldValueFrom">數值范圍</param>        /// <param name="fieldValueTo">數值范圍</param>        /// <param name="limitNum">取出數據的條數</param>        /// <param name="skipNum">跳過多少條</param>        /// <returns></returns>        public static int QueryCount1<T>(string fieldName, object fieldValueFrom, object fieldValueTo, int limitNum = 0, int skipNum = 0) where T : class        {            int iCount = 0;            IList<QueryResult<object>> myCount = myRepository.Query<T, object>(fieldName, fieldValueFrom, fieldValueTo, out msg, StaleSetting.State.False, limitNum, skipNum, false, true);            if (myCount.Count > 0)            {                iCount = Convert.ToInt32(myCount[0].value);            }            return iCount;        }        /// <summary>        /// 查詢記錄數2參數        /// </summary>        /// <typeparam name="T">實體類</typeparam>        /// <param name="field1Name">參數1</param>        /// <param name="field1Value">參數1數據</param>        /// <param name="field2Name">參數2</param>        /// <param name="field2ValueFrom">參數2數值范圍</param>        /// <param name="field2ValueTo">參數2數值范圍</param>        /// <param name="limitNum">取出數據的條數</param>        /// <param name="skipNum">跳過多少條</param>        /// <returns></returns>        public static int QueryCount2<T>(string field1Name, object field1Value, string field2Name, object field2ValueFrom, object field2ValueTo, int limitNum = 0, int skipNum = 0) where T : class        {            int iCount = 0;            IList<QueryResult<object>> myCount = myRepository.Query<T, object>(field1Name, field1Value, field2Name, field2ValueFrom, field2ValueTo, out msg, StaleSetting.State.False, limitNum, skipNum, false, true);            if (myCount.Count>0)            {                iCount = Convert.ToInt32(myCount[0].value);            }            return iCount;        }        /// <summary>        /// 查詢2參數        /// </summary>        /// <typeparam name="T">實體類</typeparam>        /// <param name="field1Name">參數1</param>        /// <param name="field1Value">參數1數據</param>        /// <param name="field2Name">參數2</param>        /// <param name="field2ValueFrom">參數2數值范圍</param>        /// <param name="field2ValueTo">參數2數值范圍</param>        /// <param name="limitNum">取出數據的條數</param>        /// <param name="skipNum">跳過多少條</param>        /// <returns></returns>        public static List<T> Query<T>(string field1Name, object field1Value, string field2Name, object field2ValueFrom, object field2ValueTo, int limitNum = 0, int skipNum = 0) where T : class        {            return myRepository.Query<T>(field1Name, field1Value, field2Name, field2ValueFrom, field2ValueTo, out msg, StaleSetting.State.False, limitNum, skipNum).Select<QueryResult<T>, T>(d => d.value).ToList();        }        /// <summary>        /// 查詢所有數據        /// </summary>        /// <typeparam name="T">實體類</typeparam>        /// <param name="limitNum">取出數據的條數</param>        /// <param name="skipNum">跳過多少條</param>        /// <returns></returns>        public static List<T> GetAll<T>(int limitNum = 0, int skipNum = 0) where T : class        {            return myRepository.GetAll<T>(out msg, StaleSetting.State.False, limitNum, skipNum).Select<QueryResult<T>, T>(d => d.value).ToList();        }        /// <summary>        /// 查詢所有數據條數        /// </summary>        /// <typeparam name="T">實體類</typeparam>        /// <param name="limitNum">取出數據的條數</param>        /// <param name="skipNum">跳過多少條</param>        /// <returns></returns>        public static int GetAllCount<T>(int limitNum = 0, int skipNum = 0) where T : class        {            int iCount = 0;            IList<QueryResult<object>> myCount = myRepository.GetAll<T, object>(out msg, StaleSetting.State.False, limitNum, skipNum, false, true);            if (myCount.Count > 0)            {                iCount = Convert.ToInt32(myCount[0].value);            }            return iCount;        }        /// <summary>        /// N1ql查詢        /// </summary>        /// <typeparam name="T">實體類</typeparam>        /// <param name="sN1ql">N1ql語句</param>        /// <returns></returns>        public static List<T> RunQuery<T>(string sN1ql) where T : class        {            return myRepository.RunQuery<T>(out msg, sN1ql);        }    }}