using Dapper;
using Estsh.Core.Dapper;
using Estsh.Core.IRepositories;
using Estsh.Core.Model.Result;
using Estsh.Core.Models;
using Estsh.Core.Repository.IRepositories;
using System.Collections;
using System.Data;
using System.Text;

/***************************************************************************************************
 *
 * 更新人：sitong.dong
 * 描述：
 * 修改时间：2022.06.22
 * 修改日志：系统迭代升级
 *
 **************************************************************************************************/
namespace Estsh.Core.Repositories
{
    public class GridColumnRepository : BaseRepository<SysWebGridColumn>, IGridColumnRepository
    {
        public GridColumnRepository(DapperDbContext _dapperDbContext) : base(_dapperDbContext)
        {
        }
        string TABLE_NAME = "sys_web_grid_column";
        string PK_NAME = "column_id";
        public List<SysWebGridColumn> GetColumnByMenuId(int menu_id)
        {
            using (IDbConnection dbConn = dapperDbContext.GetDbConnection())
            {
                dbConn.Open();
                string sqlStr = string.Format("SELECT t1.column_id,t1.menu_id,t1.grid_name,t1.name,t1.display,t1.isAllowHide,t1.isSort,t1.type,t1.width,t1.minWidth,t1.align,t2.create_userid,t2.create_time,t2.update_userid,t2.update_time FROM {0} WHERE menu_id = {1} order by [index]", this.TABLE_NAME, menu_id);
                List<SysWebGridColumn> result = dbConn.Query<SysWebGridColumn>(sqlStr).ToList();
                return result;
            }
        }

        public List<SysWebGridColumn> GetColumnByMenuIdAndGridId(int menu_id, string grid_name)
        {
            using (IDbConnection dbConn = dapperDbContext.GetDbConnection())
            {
                dbConn.Open();
                string sqlStr = string.Format("SELECT t1.column_id,t1.menu_id,t1.grid_name,t1.name,t1.display,t1.isAllowHide,t1.isSort,t1.type,t1.width,t1.minWidth,t1.align,t2.create_userid,t2.create_time,t2.update_userid,t2.update_time FROM {0} WHERE menu_id = {1} and grid_name = '{2}' order by [index]", this.TABLE_NAME, menu_id, grid_name);
                List<SysWebGridColumn> result = dbConn.Query<SysWebGridColumn>(sqlStr).ToList();
                return result;
            }
        }

        public List<SysWebGridColumn>  GetColumnByUrl(string url)
        {
            using (IDbConnection dbConn = dapperDbContext.GetDbConnection())
            {
                dbConn.Open();
                string sqlStr = string.Format("SELECT t1.column_id,t1.menu_id,t1.grid_name,t1.name,t1.display,t1.isAllowHide,t1.isSort,t1.type,t1.width,t1.minWidth,t1.align,t2.create_userid,t2.create_time,t2.update_userid,t2.update_time FROM {0} as t1 left join sys_web_menu t2 on t1.menu_id = t2.menu_id  WHERE t2.url = '{1}' order by [index]", this.TABLE_NAME, url);
                List<SysWebGridColumn> result = dbConn.Query<SysWebGridColumn>(sqlStr).ToList();
                return result;
            }
        }
        public List<SysWebGridColumn> GetColumnByUrlAndGridId(string url, string gridName)
        {
            using (IDbConnection dbConn = dapperDbContext.GetDbConnection())
            {
                dbConn.Open();
                string sqlStr = string.Format("SELECT t1.column_id,t1.menu_id,t1.grid_name,t1.name,t1.display,t1.isAllowHide,t1.isSort,t1.type,t1.width,t1.minWidth,t1.align,t2.create_userid,t2.create_time,t2.update_userid,t2.update_time FROM {0} as t1 left join sys_web_menu t2 on t1.menu_id = t2.menu_id  WHERE t2.url = '{1}' and grid_name = '{2}' order by [index]", this.TABLE_NAME, url, gridName);
                List<SysWebGridColumn> result = dbConn.Query<SysWebGridColumn>(sqlStr).ToList();
                return result;
            }
        }
    }
}