Winsoft.GOV/Winsoft.GOV.Framework/Provider/QLSXProvider.cs

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`, "
                                + "`Acp_institution`, "
                                + "`Dec_institution`, "
                                + "`Content_involve`, "
                                + "`Applicable_object`, "
                                + "`XINGZHENXDRXY`, "
                                + "`Count_limit`, "
                                + "`Count_note`, "
                                + "`Ban_requirement`, "
                                + "`SHIXIANGSCtype`, "
                                + "`SHIXIANGSCLX`, "
                                + "`Apply_type`, "
                                + "`Apply_type_tel`, "
                                + "`Apply_type_mail`, "
                                + "`Apply_type_fax`, "
                                + "`Handle_type`, "
                                + "`MbFarenAdd`, "
                                + "`MbGerenFlag`, "
                                + "`HangYeClassType`, "
                                + "`QL_Sub_Kind`, "
                                + "`IM_FLOW_url`, "
                                + "`OUT_FLOW_url`, "
                                + "`Service_mode`, "
                                + "`Service_day`, "
                                + "`DesTime`, "
                                + "`APPWEBAPPLYURL`, "
                                + "`APPAPPOINTMENTURL`, "
                                + "`APPOINTMENTURL`, "
                                + "`IS_WEBAPPOINTMENT`, "
                                + "`WEBAPPOINTMENTPERIOD`, "
                                + "`MAINCONTEXT`, "
                                + "`DO_DEPT`, "
                                + "`RELATEDGUID`, "
                                + "`RELATED`, "
                                + "`IS_EXPRESS`, "
                                + "`ISPYC`, "
                                + "`LBSX`, "
                                + "`Service_Sub_Kind` ";

        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 });
            }
        }

    }
}