//筛选条件
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;
}
}
