//查询
private void button1_Click(object sender, EventArgs e)
{
SqlStr sqls = SqlStr.newSql();//进行过滤的条件
if (this.selTextInpt1.Value == null || this.selTextInpt1.Value.Trim() == "")
{
WJs.alert("请选择一个科室！");
selTextInpt1.Focus();
return;
}
DataRow dr1 = EQKind_ytTreeView.getSelectRow();
DataRow dr2 = UseStatus_ytTreeView.getSelectRow();
if (EQKind_ytTreeView.SelectedNode != EQKind_ytTreeView.Nodes[0])
{
sqls.Add(" AND EQID IN (SELECT EQID FROM LKEQ.DICTEQ WHERE KINDCODE= " + dr1["KINDCODE"].ToString() + ")");
}
if (UseStatus_ytTreeView.SelectedNode != UseStatus_ytTreeView.Nodes[0])
{
sqls.Add(" AND STATUSCODE=" + dr2["STATUSCODE"].ToString());
}
if (this.ytComboBox1.SelectedIndex == 0)
{
sqls.Add(" AND STATUS=0 ");
}
if (this.ytComboBox1.SelectedIndex == 1)
{
sqls.Add(" AND STATUS=1 ");
}
if (this.ytComboBox1.SelectedIndex == 2)
{
sqls.Add(" AND STATUS=2 ");
}
if (this.ytComboBox1.SelectedIndex == 3)
{
sqls.Add(" AND STATUS=6 ");
}
if (this.ytComboBox1.SelectedIndex == 4)
{
sqls.Add(" AND STATUS=7 ");
}
else
{
sqls.Add(" AND 1=1 ");
}
this.dataGView1.reLoad(new object[] { this.selTextInpt1.Value, His.his.Choscode.ToString() }, sqls);
this.TiaoSu.Text = this.dataGView1.RowCount.ToString() + "笔";
this.JinEHeJi.Text = this.dataGView1.Sum("价格").ToString() + "元";
this.label6.Text = this.dataGView1.Sum("原值").ToString() + "元";
}
void ReLoad()
{
EQKind_ytTreeView.reLoad(new object[] { His.his.Choscode.ToString() });
UseStatus_ytTreeView.reLoad(new object[] { His.his.Choscode.ToString() });
}
