public List <LuisList> SelectLuisSecond(string orgment, string intent, String entities)
{
SqlDataReader rdr = null;
List <LuisList> luisList = new List <LuisList>();
if (orgment.StartsWith("서울특별시"))
{
orgment = "서울특별시";
}
if (entities.StartsWith("010-"))
{
entities = "010-";
}
if (entities.StartsWith("2017-"))
{
entities = "2017-";
}
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = " SELECT RELATION_ID, LUIS_ID, LUIS_INTENT, LUIS_ENTITIES, BEFORE_1_LUIS, BEFORE_1_INTENT, BEFORE_1_ENTITIES," +
" BEFORE_2_LUIS, BEFORE_2_INTENT, BEFORE_2_ENTITIES, BEFORE_3_LUIS, BEFORE_3_INTENT, BEFORE_3_ENTITIES, DLG_ID, DLG_ORDER_NO " +
" FROM TBL_SECCS_DLG_RELATION_LUIS WHERE LUIS_ENTITIES LIKE '%" + orgment + "%'" +
" AND BEFORE_1_INTENT = @intent" +
" AND BEFORE_1_ENTITIES LIKE '%" + entities + "%'" +
" AND USE_YN = 'Y' ORDER BY DLG_ORDER_NO";
Debug.WriteLine("* cmd.CommandText : " + cmd.CommandText);
cmd.Parameters.AddWithValue("@intent", intent);
rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (rdr.Read())
{
int dlgId = Convert.ToInt32(rdr["DLG_ID"]);
string dlgOrderNo = rdr["DLG_ORDER_NO"] as string;
string dlgIntent = rdr["LUIS_INTENT"] as string; //
string dlgEntities = rdr["LUIS_ENTITIES"] as string; //
LuisList luis = new LuisList();
luis.dlgId = dlgId;
luis.dlgOrderNo = dlgOrderNo;
luis.dlgIntent = dlgIntent;
luis.dlgEntities = dlgEntities;
Debug.WriteLine("* dlgId : " + dlgId + " || dlgOrderNo : " + dlgOrderNo + " || dlgIntent : " + dlgIntent + " || dlgEntities : " + dlgEntities);
luisList.Add(luis);
}
}
return(luisList);
}
public List <LuisList> SelectLuis(string intent, String[] entities)
{
SqlDataReader rdr = null;
List <LuisList> luisList = new List <LuisList>();
for (int i = 0; i < entities.Length; i++)
{
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = " SELECT RELATION_ID, LUIS_ID, LUIS_INTENT, LUIS_ENTITIES, BEFORE_1_LUIS, BEFORE_1_INTENT, BEFORE_1_ENTITIES," +
" BEFORE_2_LUIS, BEFORE_2_INTENT, BEFORE_2_ENTITIES, BEFORE_3_LUIS, BEFORE_3_INTENT, BEFORE_3_ENTITIES, DLG_ID, DLG_ORDER_NO " +
" FROM TBL_DLG_RELATION_LUIS WHERE LUIS_INTENT = @intent" +
" AND LUIS_ENTITIES LIKE '%" + entities[i] + "%'" +
" AND USE_YN = 'Y' ORDER BY DLG_ORDER_NO";
cmd.Parameters.AddWithValue("@intent", intent);
rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (rdr.Read())
{
int dlgId = Convert.ToInt32(rdr["DLG_ID"]);
string dlgOrderNo = rdr["DLG_ORDER_NO"] as string;
LuisList luis = new LuisList();
luis.dlgId = dlgId;
luis.dlgOrderNo = dlgOrderNo;
luisList.Add(luis);
}
cmd.CommandText = "";
}
}
return(luisList);
}
