375 lines
25 KiB
C#
375 lines
25 KiB
C#
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;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
}
|