GetSql gs = new GetSql(); DataSet ds = new DataSet(); ds = gs.SelectTable_Queue(DateTime.Now.ToString("yyyy-MM-dd")); DataGridView_Queue.DataSource = ds.Tables[0].DefaultView; this.DataGridView_Queue.Columns.Clear(); this.DisplayCol(DataGridView_Queue, "queueid", "队列号"); this.DisplayCol(DataGridView_Queue, "nvoiceid", "发票号"); this.DisplayCol(DataGridView_Queue, "patientname", "患者姓名"); this.DisplayCol(DataGridView_Queue, "patienttype", "患者类型"); this.DisplayCol(DataGridView_Queue, "patientpk", "队列优先级"); this.DisplayCol(DataGridView_Queue, "patientdetail", "备注"); this.DisplayCol(DataGridView_Queue, "queuetime", "排队时间"); //RedoSerialNo(); //取消标题行的排序功能 for (int i = 0; i < this.DataGridView_Queue.Columns.Count; i++) { this.DataGridView_Queue.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable; } DataGridView_Queue.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; this.DataGridView_Queue.Columns[0].FillWeight = 80; this.DataGridView_Queue.Columns[6].FillWeight = 150; DataGridView_Queue.Columns[6].DefaultCellStyle.Format = "yyyy-MM-dd H:mm:ss"; //患者优先级从表Table_Queue读取后patientpk字段值转换为”优先和普通“ foreach (DataRow dr in ds.Tables[0].Rows) { if (dr["patientpk"].ToString() == "1") { dr["patientpk"] = "优先"; } else { dr["patientpk"] = "普通"; } } } //展示列 void DisplayCol(DataGridView dgv, String dataPropertyName, String headerText) { dgv.AutoGenerateColumns = false; DataGridViewTextBoxColumn obj = new DataGridViewTextBoxColumn(); obj.DataPropertyName = dataPropertyName; obj.HeaderText = headerText; obj.Name = dataPropertyName; obj.Resizable = DataGridViewTriState.True; dgv.Columns.AddRange(new DataGridViewColumn[] { obj }); //dgv.Columns.Add(obj); }