private void 应付款查询ToolStripMenuItem_Click(object sender, EventArgs e)
{
string strSql;
WFilter wf = new WFilter(0, "", false);
wf.tableName = "T_YFSearch"; //表名
wf.strSql = "select InvoiceNo 发票编号,OccurTime 单据日期,CustName 客户名称,T_Receipt_Main_Det.MatId 商品编号," +
"MatName 商品名称,SourceStoreH 仓库,num 数量,Amount 含税金额,MoneyPayed 核销金额,Amount-MoneyPayed 余额, "+
"ReceiptId 单据号,ReceiptTypeID 单据类别 from T_Receipt_Main_Det " +
"left join T_MatInf on T_MatInf .Matid =T_Receipt_Main_Det .MatId " +
"where ((ReceiptTypeID ='01' and InvoiceNo<>'11111111' and InvoiceNo<>'22222222' " +
"and InvoiceNo<>'33333333' and InvoiceNo<>'55555555' and InvoiceNo<>'66666666' " +
"and InvoiceNo<>'77777777')or (ReceiptTypeID='03') or (ReceiptTypeID='20') or (ReceiptTypeID='YF')) ";
wf.s_items.Add("单据号,ReceiptId,C");
wf.s_items.Add("单据类别,ReceiptTypeID,C");
wf.s_items.Add("发票编号,InvoiceNo,C");
wf.s_items.Add("单据日期,OccurTime,N");
wf.s_items.Add("客户名称,CustName,C");
wf.s_items.Add("商品编号,MatId,C");
wf.s_items.Add("商品名称,MatName,C");
wf.s_items.Add("仓库,SourceStoreH,C");
wf.s_items.Add("数量,num,N");
wf.s_items.Add("含税金额,Amount,N");
wf.s_items.Add("核销金额,MoneyPayed,N");
wf.s_items.Add("余额,Amount-MoneyPayed,N");
//隐掉查询键
wf.btnOK.Enabled = false;
wf.ShowDialog();
if (wf.DialogResult == DialogResult.OK)
{
//返回条件框中的sql语句
strSql = wf.Return_Sql;
strSql += "order by InvoiceNo ,CustName ";
YSYFForm form = new YSYFForm();
//form.TypeName = "YFSearch";
form.Strsql = strSql;
form.MdiParent = this;
form.Show();
form.TypeName = "YFSearch";
form.BringToFront();
form.ShowReport();
}
}
void wf_clickOkChange应收款查询()
{
if (wf.IsClickOk == true)
{
//返回条件框中的sql语句
string strSql = wf.Return_Sql;
strSql += "order by InvoiceNo ,CustName ";
YSYFForm form = new YSYFForm();
//form.TypeName = "YFSearch";
form.Strsql = strSql;
form.MdiParent = this;
form.Show();
form.TypeName = "YSSearch";
form.BringToFront();
form.ShowReport();
}
}