private void Frm_DomAccept_Load(object sender, EventArgs e) { LoadCompanySource(); LoadDataGridView(string.Empty); dgv_DataShow.ColumnHeadersDefaultCellStyle = DataGridViewStyleHelper.GetHeaderStyle(); dgv_DataShow.DefaultCellStyle = DataGridViewStyleHelper.GetCellStyle(); }
/// <summary> /// 加载当前意见 /// </summary> private void Frm_Advice_Load(object sender, EventArgs e) { string querySql = $"SELECT a.qa_type, a.qa_advice FROM quality_advices a " + $"WHERE qa_time = (SELECT MAX(qa_time) FROM quality_advices WHERE qa_obj_id = a.qa_obj_id AND qa_type = a.qa_type) " + $"AND qa_obj_id='{objId}' ORDER BY a.qa_type"; List <object[]> list = SqlHelper.ExecuteColumnsQuery(querySql, 2); for (int i = 0; i < list.Count; i++) { int index = dgv_BW.Rows.Add(); dgv_BW.Rows[index].Cells[0].Value = GetTypeValue(list[i][0]); dgv_BW.Rows[index].Cells[1].Value = list[i][1]; } dgv_BW.ColumnHeadersDefaultCellStyle = DataGridViewStyleHelper.GetHeaderStyle(); dgv_BW.DefaultCellStyle = DataGridViewStyleHelper.GetCellStyle(); }
/// <summary> /// 加载历史意见 /// </summary> private void Frm_Advice_Load(object sender, EventArgs e) { dgv_BW.Rows.Clear(); string querySql = $"SELECT qa_id, qa_type, qa_advice, qa_time FROM quality_advices WHERE qa_obj_id='{objId}' ORDER BY qa_type, qa_time"; DataTable table = SqlHelper.ExecuteQuery(querySql); foreach (DataRow row in table.Rows) { int index = dgv_BW.Rows.Add(); dgv_BW.Rows[index].Tag = row["qa_id"]; dgv_BW.Rows[index].Cells[0].Value = GetTypeValue(row["qa_type"]); dgv_BW.Rows[index].Cells[1].Value = row["qa_advice"]; dgv_BW.Rows[index].Cells[2].Value = row["qa_time"]; } dgv_BW.ColumnHeadersDefaultCellStyle = DataGridViewStyleHelper.GetHeaderStyle(); dgv_BW.DefaultCellStyle = DataGridViewStyleHelper.GetCellStyle(); }