public static void Del_DIALOG_FEEDBACK(string DF_DDID)
{
var cmd = new SqlCommand();
cmd.CommandText = @"Delete Dialog_Feedback Where DF_DDID=@DF_DDID";
cmd.Parameters.Add("DF_DDID", SqlDbType.Int).Value = DF_DDID;
Persister.ExecuteNonQuery(cmd);
}
public static void Del_DIALOG_DETAIL(string DD_ID)
{
var cmd = new SqlCommand();
cmd.CommandText = @"Delete Dialog_Detail Where DD_ID=@DD_ID";
cmd.Parameters.Add("DD_ID", SqlDbType.Int).Value = DD_ID;
Persister.ExecuteNonQuery(cmd);
}
public static void Upd_DIALOG_DETAIL_DD_Type(string DD_Type, string DD_ID)
{
var cmd = new SqlCommand();
cmd.CommandText = "Update Dialog_Detail set DD_Type=@DD_Type,DD_UpdateTime=GetDate() where DD_ID=@DD_ID";
cmd.Parameters.Add("DD_Type", SqlDbType.SmallInt).Value = DD_Type;
cmd.Parameters.Add("DD_ID", SqlDbType.Int).Value = DD_ID;
Persister.ExecuteNonQuery(cmd);
}
public static void Upd_DIALOG_MAIN(MotionClass.DIALOG_MAIN data)
{
var cmd = new SqlCommand();
cmd.CommandText = "Update Dialog_Main set DM_Motion_Total=DM_Motion_Total+@DM_Motion_Total, DM_EndTime=@DM_EndTime where DM_ID=@DM_ID";
cmd.Parameters.Add("DM_Motion_Total", SqlDbType.Float).Value = data.DM_Motion_Total;
cmd.Parameters.Add("DM_EndTime", SqlDbType.DateTime).Value = data.DM_EndTime;
cmd.Parameters.Add("DM_ID", SqlDbType.Int).Value = data.DM_ID;
Persister.ExecuteNonQuery(cmd);
}
public static void Add_DIALOG_FEEDBACK(MotionClass.DIALOG_FEEDBACK data)
{
var cmd = new SqlCommand();
cmd.CommandText = @"Insert into Dialog_Feedback (DF_DDID, DF_Type, DF_CreateTime)
values (@DF_DDID, @DF_Type, @DF_CreateTime)";
cmd.Parameters.Add("DF_DDID", SqlDbType.Int).Value = data.DF_DDID;
cmd.Parameters.Add("DF_Type", SqlDbType.SmallInt).Value = data.DF_Type;
cmd.Parameters.Add("DF_CreateTime", SqlDbType.DateTime).Value = data.DF_CreateTime;
Persister.ExecuteNonQuery(cmd);
}
public static void Add_DIALOG_DETAIL(MotionClass.DIALOG_DETAIL.ASK data)
{
var cmd = new SqlCommand();
cmd.CommandText = @"Insert into Dialog_Detail (DD_DMID, DD_Type, DD_Sentence, DD_CreateTime, DD_UpdateTime)
values (@DD_DMID, @DD_Type, @DD_Sentence, @DD_CreateTime, @DD_UpdateTime)";
cmd.Parameters.Add("DD_DMID", SqlDbType.Int).Value = data.DD_DMID;
cmd.Parameters.Add("DD_Type", SqlDbType.SmallInt).Value = data.DD_Type;
cmd.Parameters.Add("DD_Sentence", SqlDbType.NVarChar).Value = data.DD_Sentence;
cmd.Parameters.Add("DD_CreateTime", SqlDbType.DateTime).Value = data.DD_CreateTime;
cmd.Parameters.Add("DD_UpdateTime", SqlDbType.DateTime).Value = data.DD_UpdateTime;
Persister.ExecuteNonQuery(cmd);
}
public static void Upd_DIALOG_DETAIL(MotionClass.DIALOG_DETAIL.REPLY data)
{
var cmd = new SqlCommand();
cmd.CommandText = @"Update Dialog_Detail set DD_Type=@DD_Type, DD_Motion=@DD_Motion
, DD_Reply=@DD_Reply, DD_Bad=@DD_Bad, DD_Bad_Term=@DD_Bad_Term, DD_Good=@DD_Good
, DD_Good_Term=@DD_Good_Term, DD_Judgment=@DD_Judgment, DD_UpdateTime=@DD_UpdateTime
where DD_ID=@DD_ID
";
cmd.Parameters.Add("DD_Type", SqlDbType.SmallInt).Value = data.DD_Type;
cmd.Parameters.Add("DD_Motion", SqlDbType.Float).Value = data.DD_Motion;
cmd.Parameters.Add("DD_Reply", SqlDbType.NVarChar).Value = data.DD_Reply;
cmd.Parameters.Add("DD_Bad", SqlDbType.Int).Value = data.DD_Bad;
cmd.Parameters.Add("DD_Bad_Term", SqlDbType.NVarChar).Value = data.DD_Bad_Term;
cmd.Parameters.Add("DD_Good", SqlDbType.Int).Value = data.DD_Good;
cmd.Parameters.Add("DD_Good_Term", SqlDbType.NVarChar).Value = data.DD_Good_Term;
cmd.Parameters.Add("DD_Judgment", SqlDbType.NVarChar).Value = data.DD_Judgment;
cmd.Parameters.Add("DD_UpdateTime", SqlDbType.DateTime).Value = data.DD_UpdateTime;
cmd.Parameters.Add("DD_ID", SqlDbType.Int).Value = data.DD_ID;
Persister.ExecuteNonQuery(cmd);
}
