/// <summary>
/// 加载dataGridView数据
/// </summary>
/// <param name="dt"></param>
private void LoadDataGridview(DataTable dt)
{
Sumary_dgv.Columns.Clear();
Sumary_dgv.DataSource = dt;
dt.DefaultView.Sort = "register_date desc";
this.Sumary_dgv.CellFormatting += new System.Windows.Forms.DataGridViewCellFormattingEventHandler(Sumary_dgv_cellFormating);
Sumary_dgv.Columns[0].DataPropertyName = "record_id";
Sumary_dgv.Columns[1].DataPropertyName = "site";
Sumary_dgv.Columns[2].DataPropertyName = "register_date";
Sumary_dgv.Columns[3].DataPropertyName = "holder_dept";
Sumary_dgv.Columns[4].DataPropertyName = "holder_name";
Sumary_dgv.Columns[5].DataPropertyName = "type";
Sumary_dgv.Columns[6].DataPropertyName = "qty";
addButtonsToDataGridView(Sumary_dgv);
Sumary_dgv.AutoResizeColumns();
Sumary_dgv.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
//this.Sumary_dgv.CellFormatting -= new System.Windows.Forms.DataGridViewCellFormattingEventHandler(Sumary_dgv_cellFormating);
}
private void search_btn_Click(object sender, EventArgs e)
{
//((DataTable)Sumary_dgv.DataSource).Clear();
Sumary_dgv.Columns.Clear();
//Setting dataGridViewButtonColumn
dgvBtnCol.HeaderText = "Event";
dgvBtnCol.Text = "Open";
dgvBtnCol.UseColumnTextForButtonValue = true;
dgvBtnCol.Width = 80;
#region This SQL of search
string sql = "SELECT record_id, site, register_date, type,(select count(serial_cd) from t_module where record_id=t_record.record_id) as qty,holder_dept,holder_name " +
" FROM public.t_record where 1=1 ";
if (dept_cbx.Checked == true && dept_combo.SelectedItem.ToString() != "")
{
sql = sql + "and holder_dept='" + dept_combo.SelectedItem.ToString() + "'";
}
if (module_cbx.Checked == true && module_txt.Text != "")
{
sql = sql + " and record_id in (select record_id from t_module where serial_cd='" + module_txt.Text + "'";
}
if (dateShift_cbx.Checked == true && (DateTime.Parse(dateTimePicker1.Text) <= DateTime.Parse(dateTimePicker2.Text)))
{
sql = sql + " and register_date>='" + DateTime.Parse(dateTimePicker1.Text).ToString("yyyy-MM-dd 00:00:00") + "' and register_date<='" + DateTime.Parse(dateTimePicker2.Text).ToString("yyyy-MM-dd 23:59:59") + "'";
}
if (carton_chb.Checked == true && carton_txt.Text != "")
{
sql = " and t_record in (select record_ id from t_carton where carton_id='" + carton_txt.Text + "'";
}
if (meno_cbx.Checked == true && Memo_txt.Text != "")
{
sql = sql + " and reason='" + Memo_txt.Text + "'";
}
if (RecordID_chb.Checked == true && RecordID_txt.Text != "")
{
sql = sql + " and record_id='" + RecordID_txt.Text + "'";
}
sql = sql + " order by register_date desc limit 200 ";
#endregion
DataTable dt = new DataTable();
DBHelper.ExecuteRefDT(sql, ref dt);
if (dt.Rows.Count < 0)
{
((DataTable)Sumary_dgv.DataSource).Clear();
}
//Delegate cellFormatting to Sumary_dgv_CellFormating method
Sumary_dgv.CellFormatting += new DataGridViewCellFormattingEventHandler(Sumary_dgv_CellFormating);
Sumary_dgv.DataSource = dt;
Sumary_dgv.Columns.Add(dgvBtnCol);
//Auto resize dataGridView columns
Sumary_dgv.AutoResizeColumns();
Sumary_dgv.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
}
