public static MotionClass.DIALOG_DETAIL.ASK Get_DIALOG_DETAIL(string DD_DMID, string DD_Type, string DD_Sentence, string DD_CreateTime, string DD_UpdateTime) { MotionClass.DIALOG_DETAIL.ASK data = new MotionClass.DIALOG_DETAIL.ASK(); data.DD_DMID = DD_DMID; data.DD_Type = DD_Type; data.DD_Sentence = DD_Sentence; data.DD_CreateTime = DD_CreateTime; data.DD_UpdateTime = DD_UpdateTime; return(data); }
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 void Get_Dialog_Detail(string DM_ID, string sentence, string now_date) { MotionClass.DIALOG_DETAIL.ASK data_ask = SQLFunc.Get_DIALOG_DETAIL(DM_ID, "0", sentence, now_date, now_date); SQLFunc.Add_DIALOG_DETAIL(data_ask); }