using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Winsoft.GOV.Framework.Model;
using Dapper;
using System.Data;

namespace Winsoft.GOV.Framework.Provider
{
    public class QLSXProvider : BaseProvider<PowerMattersDetail>
    {
        private string cols = "`ROWGUID`, "
                                + "`UPDATE_DATE`, "
                                + "`UPDATE_TYPE`, "
                                + "`QL_KIND`, "
                                + "`QL_MAINITEM_ID`, "
                                + "`QL_SUBITEM_ID`, "
                                + "`SHIQUANCJ`, "
                                + "`BELONGXIAQUCODE`, "
                                + "`QL_DEP_ORGCDOE`, "
                                + "`ITEMSOURCE`, "
                                + "`VERSION_NUMBER`, "
                                + "`VERSION_DATE`, "
                                + "`QL_EFFECT_TIME`, "
                                + "`QL_INNER_CODE`, "
                                + "`QL_NAME`, "
                                + "`QL_STATE`, "
                                + "`LAWBASIS`, "
                                + "`ANTICIPATE_DAY`, "
                                + "`ANTICIPATE_TYPE`, "
                                + "`PROMISE_DAY`, "
                                + "`APPLYERMIN_COUNT`, "
                                + "`IS_PILOT`, "
                                + "`QL_DEP`, "
                                + "`LEAD_DEPT`, "
                                + "`BJTYPE`, "
                                + "`BENJISPXZ`, "
                                + "`HANDLE_FREQUENCY`, "
                                + "`XINGZHENXDRXZ`, "
                                + "`APPLY_CONDITION`, "
                                + "`BANJIAN_FINISHFILES`, "
                                + "`LINK_TEL`, "
                                + "`SUPERVISE_TEL`, "
                                + "`WEBAPPLYURL`, "
                                + "`WEBCONSULTURL`, "
                                + "`CHARGE_FLAG`, "
                                + "`CHARGE_BASIS`, "
                                + "`RIGHTCLASS_QIYEZT`, "
                                + "`RIGHTCLASS_QIYEDX`, "
                                + "`RIGHTCLASS_GERENSX`, "
                                + "`RIGHTCLASS_GERENDX`, "
                                + "`IN_FLOW_INFO`, "
                                + "`MATERIAL_INFO`, "
                                + "`CHARGEITEM_INFO`, "
                                + "`QA_INFO`, "
                                + "`ACCEPT_ADDRESS_INFO`, "
                                + "`SYNC_SIGN`, "
                                + "`SYNC_DATE`, "
                                + "`SYNC_ERROR_DESC`, "
                                + "`OUORGCODE`, "
                                + "`ROWGUIDbak`, "
                                + "`OUGUID`, "
                                //+ "`sync_state`, "
                                + "`FaRenUrl`, "
                                + "`GeRenFlag`, "
                                + "`Is_TongJian`, "
                                + "`QL_Full_ID`, "
                                + "`ENTRUST`, "
                                + "`ENTRUSTDES`, "
                                + "`APPLYERMIN_COUNT_DESC`, "
                                + "`OUTypeCode`, "
                                + "`OUT_FLOW_DESC`, "
                                + "`BANJIAN_FINISHTYPE`, "
                                + "`IS_SpecialPro`, "
                                + "`State2`, "
                                + "`NoSuit_Apply`, "
                                + "`IS_UnifyDo`, "
                                + "`IS_UpUnify`, "
                                + "`QL_ATT`, "
                                + "`BakNote`, "
                                + "`WebApplyMode`, "
                                + "`ITEMSOURCETYPE`, "
                                + "`Is_SimplePunish`, "
                                + "`Is_LevyWaiver`, "
                                + "`FeeBasis`, "
                                + "`FACT_INFO`, "
                                + "`IS_CS`, "
                                + "`UnifyDoDes`, "
                                + "`IS_VLB`, "
                                + "`NoUnify_Do`, "
                                + "`QL_INNER_CODE_ITEM`, "
                                + "`IsHasOwnFlow`, "
                                + "`Is_TouZiP`, "
                                + "`bak1`, "
                                + "`bak2`, "
                                + "`bak3` ";

        public QLSXProvider(County county):base(county)
        {
            connectionString = "qlk_" + _county.ToString();
        }

        public IEnumerable<PowerMattersDetail> Select(DateTime updateDate)
        {
            string sql = "SELECT " + cols + " FROM `qlt_qlsx` where UPDATE_DATE>@updateDate order by UPDATE_DATE limit 0, 10;";
            //"select * from powerMettersDetail where UPDATE_DATE>@updateDate order by UPDATE_DATE limit 0, 10";
            using (IDbConnection connection = GetDbConnection())
            {
                return connection.Query<PowerMattersDetail>(sql, new { updateDate = updateDate });
            }
        }

        public PowerMattersDetail FindByID(string ql_inner_code)
        {
            string sql = "SELECT " + cols + " FROM `qlt_qlsx` where QL_INNER_CODE=@ql_inner_code order by UPDATE_DATE desc limit 0, 1;";
            //"select * from powerMettersDetail where UPDATE_DATE>@updateDate order by UPDATE_DATE limit 0, 10";
            using (IDbConnection connection = GetDbConnection())
            {
                return connection.QueryFirstOrDefault<PowerMattersDetail>(sql, new { ql_inner_code = ql_inner_code });
            }
        }

    }
}