using Dapper;
using dccdc.Models;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace dccdc.DAL
{
    public class InfectionQuestionAnswerDal
    {
        public List<InfectionOpenUserInfoModel> GetAllDataList()
        {
            string sql = "SELECT i.user_id,i.name,i.ident,i.phone,i.birth FROM(SELECT user_id " +
                "FROM dbo.infection_question_answer GROUP BY user_id) a " +
                "LEFT JOIN dbo.infection_open_user_info i ON a.user_id = i.user_id";
            using (IDbConnection conn = CommHelper.GetSqlConnection())
            {
                return conn.Query<InfectionOpenUserInfoModel>(sql).ToList();
            }
        }
        public string SaveData(InfectionQuestionAnswerModel model)
        {
            string sql = @"insert into infection_question_answer(question_id,info_id,question_sign,answer,create_time, create_by)Values(@question_id,@info_id,@question_sign,@answer,@create_time,@create_by)";
            string returnValue = string.Empty;
            try
            {
                using (IDbConnection conn = CommHelper.GetSqlConnection())
                {
                    int result = conn.Execute(sql, model);
                    if (result > 0)
                        returnValue = "True";
                    else
                        returnValue = "False";
                }
            }
            catch(Exception e)
            {
                returnValue = "False";
            }
            return returnValue;
        }

        public string delete(string id)
        {
            string sql = string.Format("DELETE FROM infection_question_answer WHERE info_id = '{0}'",id); 
            string returnValue = string.Empty;
            try
            {
                using (IDbConnection conn = CommHelper.GetSqlConnection())
                {
                    int result = conn.Execute(sql, id);
                    if (result > 0)
                        returnValue = "True";
                    else
                        returnValue = "False";
                }
            }
            catch (Exception e)
            {
                returnValue = "False";
            }
            return returnValue;
        }

        public bool deleteData(int id)
        {
            string sql = string.Format("DELETE FROM dbo.infection_question_answer WHERE info_id = '{0}'", id);
            string returnValue = string.Empty;
            try
            {
                using (IDbConnection conn = CommHelper.GetSqlConnection())
                {
                    int result = conn.Execute(sql);
                    return true;
                }
            }
            catch (Exception e)
            {
                return false;
            }
        }

        public object saveData(InfectionQuestionAnswerModel model)
        {
            string sql = @"insert into infection_question_answer(question_id,user_id,question_sign,answer,create_time)Values(@question_id,@user_id,@question_sign,@answer,@create_time)";
            string returnValue = string.Empty;
            using (IDbConnection conn = CommHelper.GetSqlConnection())
            {
                try
                {
                    int result = conn.Execute(sql, model);
                    if (result > 0)
                        return new { State = 1, Message = "操作成功！" };
                    else
                        return new { State = 0, Message = "操作失败！" };
                }
                catch (Exception ex)
                {
                    return new { State = 0, Message = ex.Message };
                }
            }
        }

        public List<InfectionQuestionAnswerModel> getDataListByUserID(string info_id)
        {
           
            string sql = string.Format("SELECT id,info_id,question_id,question_sign,answer FROM infection_question_answer WHERE info_id = '{0}' order by question_id asc", info_id);
            try
            {
                using (IDbConnection conn = CommHelper.GetSqlConnection())
                {
                    return conn.Query<InfectionQuestionAnswerModel>(sql).ToList();
                }
            }
            catch (Exception e)
            {
                return null;
            }
           
        }

        //导出
        public List<InfectionQuestionAnswerModel> export(string name, string ident)
        {
            string sql = " select* from dbo.infection_open_user_info A left join    "+							
                "	(select a1.info_id,a1.answer as A01,a2.answer as A02	" +
                "	,	a3.answer as	A03	" +
                "	,	a4.answer as	B01	" +
                "	,	a5.answer as	B01_Q	" +
                "	,	a6	.answer as	B02	" +
                "	,	a7	.answer as	B03	" +
                "	,	a8	.answer as	B04	" +
                "	,	a9	.answer as	B05	" +
                "	,	a10	.answer as	B06	" +
                "	,	a11	.answer as	C01	" +
                "	,	a12.answer as	C01_Q	" +
                "	,	a13	.answer as	C02	" +
                "	,	a14	.answer as	C02_Q	" +
                "	,	a15	.answer as	C03	" +
                "	,	a16	.answer as	C04	" +
                "	,	a17	.answer as	C05	" +
                "	,	a18	.answer as	C06	" +
                "	,	a19	.answer as	C07	" +
                "	,	a20	.answer as	D01	" +
                "	,	a21	.answer as	D02	" +
                "	,	a22	.answer as	D02_Q	" +
                "	,	a23	.answer as	D03	" +
                "	,	a24	.answer as	D04	" +
                "	,	a25	.answer as	D05	" +
                "	,	a26	.answer as	E01	" +
                "	,	a27	.answer as	E02	" +
                "	,	a28	.answer as	E03	" +
                "	,	a29	.answer as	E04	" +
                "	,	a30	.answer as	F01	" +
                "	,	a31	.answer as	F01_Q	" +
                "	,	a32	.answer as	F02	" +
                "	,	a33	.answer as	F03	" +
                "	,	a34	.answer as	F04	" +
                "	,	a35	.answer as	F05	" +
                "	,	a36	.answer as	F06	" +
                "	,	a37	.answer as	F06_Q	" +
                "	,	a38	.answer as	F07	" +
                "	,	a39	.answer as	F08	" +
                "	,	a40	.answer as	F09	" +
                "	,	a41	.answer as	G01	" +
                "	,	a42	.answer as	G02	" +
                "	,	a43	.answer as	G03	" +
                "	,	a44	.answer as	G04	" +
                "	,	a45	.answer as	G05	" +
                "	,	a46	.answer as	G06	" +
                "	,	a47	.answer as	G06_Q	" +
                "	,	a48	.answer as	G07	" +
                "	,	a49	.answer as	G08	" +
                "	,	a50	.answer as	G08_Q	" +
                "	,	a51	.answer as	G09	" +
                "	,	a52	.answer as	G10	" +
                "	,	a53	.answer as	G11	" +
                "	,	a54	.answer as	G11_Q	" +
                "	,	a55	.answer as	G12	" +
                "	,	a56	.answer as	G13	" +
                "	,	a57	.answer as	G13_Q	" +
                "	,	a58	.answer as	G14	" +
                "	,	a59	.answer as	G15	" +
                "	,	a60	.answer as	H01	" +
                "	,	a61	.answer as	H02	" +
                "	,	a62	.answer as	H02_Q	" +
                "	,	a63	.answer as	H03	" +
                "	,	a64	.answer as	H03_Q	" +
                "	,	a65	.answer as	H04	" +
                "	,	a66	.answer as	H04_Q	" +
                "	,	a67	.answer as	H05	" +
                "	,	a68	.answer as	H05_Q	" +
                "	,	a69	.answer as	H06	" +
                "	,	a70	.answer as	H07	" +
                "	,	a71	.answer as	H08	" +
                "	,	a72	.answer as	H08_Q	" +
                "	,	a73	.answer as	H09	" +
                "	,	a74	.answer as	H10	" +
                "	,	a75	.answer as	H11	" +
                "	,	a76	.answer as	H11_Q	" +
                "	,	a77	.answer as	H12	" +
                "	,	a78	.answer as	H13	" +
                "	,	a79	.answer as	H13_Q	" +
                "	,	a80	.answer as	H14	" +
                "	,	a81	.answer as	H15	" +
                "	,	a82	.answer as	I01	" +
                "	,	a83	.answer as	I02	" +
                "	,	a84	.answer as	I02_Q	" +
                "	,	a85	.answer as	I03	" +
                "	,	a86	.answer as	I03_Q	" +
                "	,	a87	.answer as	J01	" +
                "	,	a88	.answer as	J02	" +
                "	,	a89	.answer as	J03	" +
                "	,	a90	.answer as	J04	" +
                "	,	a91	.answer as	J05	" +
                "	,	a92	.answer as	J06	" +
                "	,	a93	.answer as	J07	" +
                "	,	a94	.answer as	J08	" +
                "	,	a95	.answer as	K01	" +
                "	,	a96	.answer as	K02	" +
                "	,	a97	.answer as	K03	" +
                "	,	a98	.answer as	K04	" +
                "	,	a99	.answer as	K05	" +
                "	,	a100	.answer as	K06	" +
                "	,	a101	.answer as	K07	" +
                "	,	a102	.answer as	K08	" +
                "	,	a103	.answer as	K09	" +
                "	,	a104	.answer as	K10	" +
                "	,	a105	.answer as	T01	" +
                "	,	a106	.answer as	T02a	" +
                "	,	a107	.answer as	T02b	" +
                "	,	a108	.answer as	T03	" +
                "	,	a109	.answer as	T03_Q	" +
                "	,	a110	.answer as	T03_Q2	" +
                "	 from dbo.infection_question_answer a1 	" +
                "	left join dbo.infection_question_answer a2 on a1.info_id=a2.info_id and a1.question_id=1 and a2.question_id=2 	" +
                "	left join dbo.infection_question_answer 	a3 	on a2.info_id=	a3 	.info_id and a1.question_id=1 and 	a3	.question_id=	3	" +
                "	left join dbo.infection_question_answer 	a4 	on a3.info_id=	a4 	.info_id and a1.question_id=1 and 	a4	.question_id=	4	" +
                "	left join dbo.infection_question_answer 	a5 	on a4.info_id=	a5 	.info_id and a1.question_id=1 and 	a5	.question_id=	5	" +
                "	left join dbo.infection_question_answer 	a6 	on a5.info_id=	a6 	.info_id and a1.question_id=1 and 	a6	.question_id=	6	" +
                "	left join dbo.infection_question_answer 	a7 	on a6.info_id=	a7 	.info_id and a1.question_id=1 and 	a7	.question_id=	7	" +
                "	left join dbo.infection_question_answer 	a8 	on a7.info_id=	a8 	.info_id and a1.question_id=1 and 	a8	.question_id=	8	" +
                "	left join dbo.infection_question_answer 	a9 	on a8.info_id=	a9 	.info_id and a1.question_id=1 and 	a9	.question_id=	9	" +
                "	left join dbo.infection_question_answer 	a10 	on a9.info_id=	a10 	.info_id and a1.question_id=1 and 	a10	.question_id=	10	" +
                "	left join dbo.infection_question_answer 	a11 	on a10.info_id=	a11 	.info_id and a1.question_id=1 and 	a11	.question_id=	11	" +
                "	left join dbo.infection_question_answer 	a12 	on a11.info_id=	a12 	.info_id and a1.question_id=1 and 	a12	.question_id=	12	" +
                "	left join dbo.infection_question_answer 	a13 	on a12.info_id=	a13 	.info_id and a1.question_id=1 and 	a13	.question_id=	13	" +
                "	left join dbo.infection_question_answer 	a14 	on a13.info_id=	a14 	.info_id and a1.question_id=1 and 	a14	.question_id=	14	" +
                "	left join dbo.infection_question_answer 	a15 	on a14.info_id=	a15 	.info_id and a1.question_id=1 and 	a15	.question_id=	15	" +
                "	left join dbo.infection_question_answer 	a16 	on a15.info_id=	a16 	.info_id and a1.question_id=1 and 	a16	.question_id=	16	" +
                "	left join dbo.infection_question_answer 	a17 	on a16.info_id=	a17 	.info_id and a1.question_id=1 and 	a17	.question_id=	17	" +
                "	left join dbo.infection_question_answer 	a18 	on a17.info_id=	a18 	.info_id and a1.question_id=1 and 	a18	.question_id=	18	" +
                "	left join dbo.infection_question_answer 	a19 	on a18.info_id=	a19 	.info_id and a1.question_id=1 and 	a19	.question_id=	19	" +
                "	left join dbo.infection_question_answer 	a20 	on a19.info_id=	a20 	.info_id and a1.question_id=1 and 	a20	.question_id=	20	" +
                "	left join dbo.infection_question_answer 	a21 	on a20.info_id=	a21 	.info_id and a1.question_id=1 and 	a21	.question_id=	21	" +
                "	left join dbo.infection_question_answer 	a22 	on a21.info_id=	a22 	.info_id and a1.question_id=1 and 	a22	.question_id=	22	" +
                "	left join dbo.infection_question_answer 	a23 	on a22.info_id=	a23 	.info_id and a1.question_id=1 and 	a23	.question_id=	23	" +
                "	left join dbo.infection_question_answer 	a24 	on a23.info_id=	a24 	.info_id and a1.question_id=1 and 	a24	.question_id=	24	" +
                "	left join dbo.infection_question_answer 	a25 	on a24.info_id=	a25 	.info_id and a1.question_id=1 and 	a25	.question_id=	25	" +
                "	left join dbo.infection_question_answer 	a26 	on a25.info_id=	a26 	.info_id and a1.question_id=1 and 	a26	.question_id=	26	" +
                "	left join dbo.infection_question_answer 	a27 	on a26.info_id=	a27 	.info_id and a1.question_id=1 and 	a27	.question_id=	27	" +
                "	left join dbo.infection_question_answer 	a28 	on a27.info_id=	a28 	.info_id and a1.question_id=1 and 	a28	.question_id=	28	" +
                "	left join dbo.infection_question_answer 	a29 	on a28.info_id=	a29 	.info_id and a1.question_id=1 and 	a29	.question_id=	29	" +
                "	left join dbo.infection_question_answer 	a30 	on a29.info_id=	a30 	.info_id and a1.question_id=1 and 	a30	.question_id=	30	" +
                "	left join dbo.infection_question_answer 	a31 	on a30.info_id=	a31 	.info_id and a1.question_id=1 and 	a31	.question_id=	31	" +
                "	left join dbo.infection_question_answer 	a32 	on a31.info_id=	a32 	.info_id and a1.question_id=1 and 	a32	.question_id=	32	" +
                "	left join dbo.infection_question_answer 	a33 	on a32.info_id=	a33 	.info_id and a1.question_id=1 and 	a33	.question_id=	33	" +
                "	left join dbo.infection_question_answer 	a34 	on a33.info_id=	a34 	.info_id and a1.question_id=1 and 	a34	.question_id=	34	" +
                "	left join dbo.infection_question_answer 	a35 	on a34.info_id=	a35 	.info_id and a1.question_id=1 and 	a35	.question_id=	35	" +
                "	left join dbo.infection_question_answer 	a36 	on a35.info_id=	a36 	.info_id and a1.question_id=1 and 	a36	.question_id=	36	" +
                "	left join dbo.infection_question_answer 	a37 	on a36.info_id=	a37 	.info_id and a1.question_id=1 and 	a37	.question_id=	37	" +
                "	left join dbo.infection_question_answer 	a38 	on a37.info_id=	a38 	.info_id and a1.question_id=1 and 	a38	.question_id=	38	" +
                "	left join dbo.infection_question_answer 	a39 	on a38.info_id=	a39 	.info_id and a1.question_id=1 and 	a39	.question_id=	39	" +
                "	left join dbo.infection_question_answer 	a40 	on a39.info_id=	a40 	.info_id and a1.question_id=1 and 	a40	.question_id=	40	" +
                "	left join dbo.infection_question_answer 	a41 	on a40.info_id=	a41 	.info_id and a1.question_id=1 and 	a41	.question_id=	41	" +
                "	left join dbo.infection_question_answer 	a42 	on a41.info_id=	a42 	.info_id and a1.question_id=1 and 	a42	.question_id=	42	" +
                "	left join dbo.infection_question_answer 	a43 	on a42.info_id=	a43 	.info_id and a1.question_id=1 and 	a43	.question_id=	43	" +
                "	left join dbo.infection_question_answer 	a44 	on a43.info_id=	a44 	.info_id and a1.question_id=1 and 	a44	.question_id=	44	" +
                "	left join dbo.infection_question_answer 	a45 	on a44.info_id=	a45 	.info_id and a1.question_id=1 and 	a45	.question_id=	45	" +
                "	left join dbo.infection_question_answer 	a46 	on a45.info_id=	a46 	.info_id and a1.question_id=1 and 	a46	.question_id=	46	" +
                "	left join dbo.infection_question_answer 	a47 	on a46.info_id=	a47 	.info_id and a1.question_id=1 and 	a47	.question_id=	47	" +
                "	left join dbo.infection_question_answer 	a48 	on a47.info_id=	a48 	.info_id and a1.question_id=1 and 	a48	.question_id=	48	" +
                "	left join dbo.infection_question_answer 	a49 	on a48.info_id=	a49 	.info_id and a1.question_id=1 and 	a49	.question_id=	49	" +
                "	left join dbo.infection_question_answer 	a50 	on a49.info_id=	a50 	.info_id and a1.question_id=1 and 	a50	.question_id=	50	" +
                "	left join dbo.infection_question_answer 	a51 	on a50.info_id=	a51 	.info_id and a1.question_id=1 and 	a51	.question_id=	51	" +
                "	left join dbo.infection_question_answer 	a52 	on a51.info_id=	a52 	.info_id and a1.question_id=1 and 	a52	.question_id=	52	" +
                "	left join dbo.infection_question_answer 	a53 	on a52.info_id=	a53 	.info_id and a1.question_id=1 and 	a53	.question_id=	53	" +
                "	left join dbo.infection_question_answer 	a54 	on a53.info_id=	a54 	.info_id and a1.question_id=1 and 	a54	.question_id=	54	" +
                "	left join dbo.infection_question_answer 	a55 	on a54.info_id=	a55 	.info_id and a1.question_id=1 and 	a55	.question_id=	55	" +
                "	left join dbo.infection_question_answer 	a56 	on a55.info_id=	a56 	.info_id and a1.question_id=1 and 	a56	.question_id=	56	" +
                "	left join dbo.infection_question_answer 	a57 	on a56.info_id=	a57 	.info_id and a1.question_id=1 and 	a57	.question_id=	57	" +
                "	left join dbo.infection_question_answer 	a58 	on a57.info_id=	a58 	.info_id and a1.question_id=1 and 	a58	.question_id=	58	" +
                "	left join dbo.infection_question_answer 	a59 	on a58.info_id=	a59 	.info_id and a1.question_id=1 and 	a59	.question_id=	59	" +
                "	left join dbo.infection_question_answer 	a60 	on a59.info_id=	a60 	.info_id and a1.question_id=1 and 	a60	.question_id=	60	" +
                "	left join dbo.infection_question_answer 	a61 	on a60.info_id=	a61 	.info_id and a1.question_id=1 and 	a61	.question_id=	61	" +
                "	left join dbo.infection_question_answer 	a62 	on a61.info_id=	a62 	.info_id and a1.question_id=1 and 	a62	.question_id=	62	" +
                "	left join dbo.infection_question_answer 	a63 	on a62.info_id=	a63 	.info_id and a1.question_id=1 and 	a63	.question_id=	63	" +
                "	left join dbo.infection_question_answer 	a64 	on a63.info_id=	a64 	.info_id and a1.question_id=1 and 	a64	.question_id=	64	" +
                "	left join dbo.infection_question_answer 	a65 	on a64.info_id=	a65 	.info_id and a1.question_id=1 and 	a65	.question_id=	65	" +
                "	left join dbo.infection_question_answer 	a66 	on a65.info_id=	a66 	.info_id and a1.question_id=1 and 	a66	.question_id=	66	" +
                "	left join dbo.infection_question_answer 	a67 	on a66.info_id=	a67 	.info_id and a1.question_id=1 and 	a67	.question_id=	67	" +
                "	left join dbo.infection_question_answer 	a68 	on a67.info_id=	a68 	.info_id and a1.question_id=1 and 	a68	.question_id=	68	" +
                "	left join dbo.infection_question_answer 	a69 	on a68.info_id=	a69 	.info_id and a1.question_id=1 and 	a69	.question_id=	69	" +
                "	left join dbo.infection_question_answer 	a70 	on a69.info_id=	a70 	.info_id and a1.question_id=1 and 	a70	.question_id=	70	" +
                "	left join dbo.infection_question_answer 	a71 	on a70.info_id=	a71 	.info_id and a1.question_id=1 and 	a71	.question_id=	71	" +
                "	left join dbo.infection_question_answer 	a72 	on a71.info_id=	a72 	.info_id and a1.question_id=1 and 	a72	.question_id=	72	" +
                "	left join dbo.infection_question_answer 	a73 	on a72.info_id=	a73 	.info_id and a1.question_id=1 and 	a73	.question_id=	73	" +
                "	left join dbo.infection_question_answer 	a74 	on a73.info_id=	a74 	.info_id and a1.question_id=1 and 	a74	.question_id=	74	" +
                "	left join dbo.infection_question_answer 	a75 	on a74.info_id=	a75 	.info_id and a1.question_id=1 and 	a75	.question_id=	75	" +
                "	left join dbo.infection_question_answer 	a76 	on a75.info_id=	a76 	.info_id and a1.question_id=1 and 	a76	.question_id=	76	" +
                "	left join dbo.infection_question_answer 	a77 	on a76.info_id=	a77 	.info_id and a1.question_id=1 and 	a77	.question_id=	77	" +
                "	left join dbo.infection_question_answer 	a78 	on a77.info_id=	a78 	.info_id and a1.question_id=1 and 	a78	.question_id=	78	" +
                "	left join dbo.infection_question_answer 	a79 	on a78.info_id=	a79 	.info_id and a1.question_id=1 and 	a79	.question_id=	79	" +
                "	left join dbo.infection_question_answer 	a80 	on a79.info_id=	a80 	.info_id and a1.question_id=1 and 	a80	.question_id=	80	" +
                "	left join dbo.infection_question_answer 	a81 	on a80.info_id=	a81 	.info_id and a1.question_id=1 and 	a81	.question_id=	81	" +
                "	left join dbo.infection_question_answer 	a82 	on a81.info_id=	a82 	.info_id and a1.question_id=1 and 	a82	.question_id=	82	" +
                "	left join dbo.infection_question_answer 	a83 	on a82.info_id=	a83 	.info_id and a1.question_id=1 and 	a83	.question_id=	83	" +
                "	left join dbo.infection_question_answer 	a84 	on a83.info_id=	a84 	.info_id and a1.question_id=1 and 	a84	.question_id=	84	" +
                "	left join dbo.infection_question_answer 	a85 	on a84.info_id=	a85 	.info_id and a1.question_id=1 and 	a85	.question_id=	85	" +
                "	left join dbo.infection_question_answer 	a86 	on a85.info_id=	a86 	.info_id and a1.question_id=1 and 	a86	.question_id=	86	" +
                "	left join dbo.infection_question_answer 	a87 	on a86.info_id=	a87 	.info_id and a1.question_id=1 and 	a87	.question_id=	87	" +
                "	left join dbo.infection_question_answer 	a88 	on a87.info_id=	a88 	.info_id and a1.question_id=1 and 	a88	.question_id=	88	" +
                "	left join dbo.infection_question_answer 	a89 	on a88.info_id=	a89 	.info_id and a1.question_id=1 and 	a89	.question_id=	89	" +
                "	left join dbo.infection_question_answer 	a90 	on a89.info_id=	a90 	.info_id and a1.question_id=1 and 	a90	.question_id=	90	" +
                "	left join dbo.infection_question_answer 	a91 	on a90.info_id=	a91 	.info_id and a1.question_id=1 and 	a91	.question_id=	91	" +
                "	left join dbo.infection_question_answer 	a92 	on a91.info_id=	a92 	.info_id and a1.question_id=1 and 	a92	.question_id=	92	" +
                "	left join dbo.infection_question_answer 	a93 	on a92.info_id=	a93 	.info_id and a1.question_id=1 and 	a93	.question_id=	93	" +
                "	left join dbo.infection_question_answer 	a94 	on a93.info_id=	a94 	.info_id and a1.question_id=1 and 	a94	.question_id=	94	" +
                "	left join dbo.infection_question_answer 	a95 	on a94.info_id=	a95 	.info_id and a1.question_id=1 and 	a95	.question_id=	95	" +
                "	left join dbo.infection_question_answer 	a96 	on a95.info_id=	a96 	.info_id and a1.question_id=1 and 	a96	.question_id=	96	" +
                "	left join dbo.infection_question_answer 	a97 	on a96.info_id=	a97 	.info_id and a1.question_id=1 and 	a97	.question_id=	97	" +
                "	left join dbo.infection_question_answer 	a98 	on a97.info_id=	a98 	.info_id and a1.question_id=1 and 	a98	.question_id=	98	" +
                "	left join dbo.infection_question_answer 	a99 	on a98.info_id=	a99 	.info_id and a1.question_id=1 and 	a99	.question_id=	99	" +
                "	left join dbo.infection_question_answer 	a100 	on a99.info_id=	a100 	.info_id and a1.question_id=1 and 	a100	.question_id=	100	" +
                "	left join dbo.infection_question_answer 	a101 	on a100.info_id=	a101 	.info_id and a1.question_id=1 and 	a101	.question_id=	101	" +
                "	left join dbo.infection_question_answer 	a102 	on a101.info_id=	a102 	.info_id and a1.question_id=1 and 	a102	.question_id=	102	" +
                "	left join dbo.infection_question_answer 	a103 	on a102.info_id=	a103 	.info_id and a1.question_id=1 and 	a103	.question_id=	103	" +
                "	left join dbo.infection_question_answer 	a104 	on a103.info_id=	a104 	.info_id and a1.question_id=1 and 	a104	.question_id=	104	" +
                "	left join dbo.infection_question_answer 	a105 	on a104.info_id=	a105 	.info_id and a1.question_id=1 and 	a105	.question_id=	105	" +
                "	left join dbo.infection_question_answer 	a106 	on a105.info_id=	a106 	.info_id and a1.question_id=1 and 	a106	.question_id=	106	" +
                "	left join dbo.infection_question_answer 	a107 	on a106.info_id=	a107 	.info_id and a1.question_id=1 and 	a107	.question_id=	107	" +
                "	left join dbo.infection_question_answer 	a108 	on a107.info_id=	a108 	.info_id and a1.question_id=1 and 	a108	.question_id=	108	" +
                "	left join dbo.infection_question_answer 	a109 	on a108.info_id=	a109 	.info_id and a1.question_id=1 and 	a109	.question_id=	109	" +
                "	left join dbo.infection_question_answer 	a110 	on a109.info_id=	a110 	.info_id and a1.question_id=1 and 	a110	.question_id=	110	" +
                "	where a2.answer is not null) B on A.id=B.info_id	" +
                " where B.info_id is not null" ;

            if (!string.IsNullOrEmpty(name))
            {
                sql += " and A.name like '%" + name + "%' ";
            }
            if (!string.IsNullOrEmpty(ident))
            {
                sql += "' and A.ident = '" + ident + "' ";
            }
            using (IDbConnection conn = CommHelper.GetSqlConnection())
            {
                try
                {

                    return conn.Query<InfectionQuestionAnswerModel>(sql).ToList();
                }
                catch (Exception e)
                {
                    string err = e.Message;
                    return null;
                }
            }
        }
    }
}