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