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); }