//筛选条件 private void textEdit3_TextChanged(object sender, EventArgs e) { DataView dv1 = GetDgvToTable(dataGridView1).DefaultView; dv1.RowFilter = "入库单号=" + textEdit3.Text + ""; DataGridViewAutoFilter.DataGridViewFunction Get1 = new DataGridViewFunction(); Get1.GridViewDataLoad(dv1.ToTable(), dataGridView1);//填充DataGridView Get1.GridViewHeaderFilter(dataGridView1); DataView dv2 = GetDgvToTable(dataGridView2).DefaultView; dv2.RowFilter = "入库单号=" + textEdit3.Text + " or 产品编号=" + textEdit3.Text; DataGridViewAutoFilter.DataGridViewFunction Get2 = new DataGridViewFunction(); Get2.GridViewDataLoad(dv2.ToTable(), dataGridView2);//填充DataGridView Get2.GridViewHeaderFilter(dataGridView2); }
//查询未审核的入库单 private void simpleButton1_Click(object sender, EventArgs e) { //跳转TabControl页面 tabControl1.SelectedTab = tabControl1.TabPages[0]; tabControl2.SelectedTab = tabControl2.TabPages[0]; this.Cursor = Cursors.WaitCursor; //判断数据完整性 if (dateEdit1.Text.Equals("")) { MessageBox.Show("开始时间不允许为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); this.Cursor = Cursors.Default; return; } if (dateEdit2.Text.Equals("")) { MessageBox.Show("结束时间不允许为空", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); this.Cursor = Cursors.Default; return; } try { if (comboBoxEdit1.Text.Equals("未审核")) { DataTable dt1 = new DataTable(); SqlParameter[] para = { new SqlParameter("@STARTTIME", SqlDbType.DateTime) , new SqlParameter("@ENDTIME", SqlDbType.DateTime) , new SqlParameter("@FLAG", SqlDbType.VarChar) }; para[0].Value = Convert.ToDateTime(this.dateEdit1.EditValue.ToString()); para[1].Value = Convert.ToDateTime(this.dateEdit2.EditValue.ToString()); para[2].Value = Getmodevalue(comboBoxEdit1.EditValue.ToString()); dt1 = SqlHelper.ExecStoredProcedureDataTable("WMS_RKDQuery", para); DataGridViewAutoFilter.DataGridViewFunction Get = new DataGridViewFunction(); //Get.GridViewDataLoad(dt1, dataGridView1);//填充DataGridView //Get.GridViewHeaderFilter(dataGridView1); dataGridView1.DataSource = dt1; dataGridView1.RowsDefaultCellStyle.BackColor = Color.White; dataGridView1.AlternatingRowsDefaultCellStyle.BackColor = Color.Gainsboro; dataGridView1.RowsDefaultCellStyle.Font = new Font("微软雅黑", 8, FontStyle.Regular); //dataGridView1.Refresh(); #region 统计数据 double index = 0; for (int i = 0; i < dt1.Rows.Count; i++) { index = index + Convert.ToDouble(dt1.Rows[i]["入库数量"].ToString()); } toolStripStatusLabel2.Text = Convert.ToString(index); #endregion this.Cursor = Cursors.Default; } else { DataTable dt1 = new DataTable(); SqlParameter[] para = { new SqlParameter("@STARTTIME", SqlDbType.DateTime) , new SqlParameter("@ENDTIME", SqlDbType.DateTime) , new SqlParameter("@FLAG", SqlDbType.VarChar) }; para[0].Value = Convert.ToDateTime(this.dateEdit1.EditValue.ToString()); para[1].Value = Convert.ToDateTime(this.dateEdit2.EditValue.ToString()); para[2].Value = Getmodevalue(comboBoxEdit1.EditValue.ToString()); dt1 = SqlHelper.ExecStoredProcedureDataTable("WMS_RKDQuery", para); //dataGridView2.DataSource = dt1; //DataGridViewAutoFilter.DataGridViewFunction Get = new DataGridViewFunction(); //Get.GridViewDataLoad(dt1, dataGridView2);//填充DataGridView dataGridView2.DataSource = dt1; dataGridView2.RowsDefaultCellStyle.BackColor = Color.White; dataGridView2.AlternatingRowsDefaultCellStyle.BackColor = Color.Gainsboro; dataGridView2.RowsDefaultCellStyle.Font = new Font("微软雅黑", 8, FontStyle.Regular); dataGridView2.Refresh(); #region 统计数据 double index = 0; for (int i = 0; i < dt1.Rows.Count; i++) { index = index + Convert.ToDouble(dt1.Rows[i]["入库数量"].ToString()); } toolStripStatusLabel4.Text = Convert.ToString(index); #endregion this.Cursor = Cursors.Default; } } catch (Exception ex) { MessageBox.Show(ex.Message); this.Cursor = Cursors.Default; return; } }