private void Btn_Sure_Click(object sender, System.EventArgs e) { int index = cbo_AdviceType.SelectedIndex; if (index != -1) { object advice = txt_Advice.Text; string primaryKey = Guid.NewGuid().ToString(); string insertSql = $"INSERT INTO quality_advices VALUES('{primaryKey}','{UserHelper.GetUser().UserKey}','{DateTime.Now}','{objId}','{advice}',{index})"; SqlHelper.ExecuteNonQuery(insertSql); lbl_ObjName.Tag = primaryKey; btn_Delete.Enabled = true; XtraMessageBox.Show("保存成功。"); Close(); } }
/// <summary> /// 根据指定的对象ID和类型获取意见 /// </summary> /// <param name="id">主键</param> /// <param name="type">类型</param> /// <returns> /// 对象数组:[0]主键[1]名称 /// </returns> private object[] GetAdvice(object id, int type) { object[] _obj = SqlHelper.ExecuteRowsQuery($"SELECT qa_id, qa_advice FROM quality_advices WHERE qa_obj_id='{id}' AND qa_user='******' AND qa_type={type} ORDER BY qa_time DESC"); return(_obj ?? null); }