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(); }
private void Frm_AddPC_Load(object sender, EventArgs e) { //表头设置 dgv_CDlist.ColumnHeadersDefaultCellStyle = DataGridViewStyleHelper.GetHeaderStyle(); //列设置 if (string.IsNullOrEmpty(txt_BatchCode.Text) && !"PC".Equals(unitCode)) { CreateBatchCode(unitCode); } //隐藏光盘列表主键 dgv_CDlist.Columns[0].Visible = false; Text = (isAdd ? "新增" : "修改") + "批次信息"; txt_BatchName.Focus(); }
private void Frm_ToR_Load(object sender, EventArgs e) { //默认加载批次列表 LoadPCDataScoure(null); //加载来源单位列表 LoadCompanySource(); btn_Back.Enabled = false; //默认查看状态为全部 cbo_Status.SelectedIndex = 0; dgv_SWDJ.ColumnHeadersDefaultCellStyle = DataGridViewStyleHelper.GetHeaderStyle(); dgv_GPDJ.ColumnHeadersDefaultCellStyle = DataGridViewStyleHelper.GetHeaderStyle(); dgv_SWDJ.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize; dgv_GPDJ.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.AutoSize; }
public BatchRecInfo(object trpID) { TRP_ID = trpID; InitializeComponent(); view.RowHeadersDefaultCellStyle = DataGridViewStyleHelper.GetHeaderStyle(); }