protected void btnSrchBill_Click(object sender, EventArgs e)
{
if (docSTR1.Text.Length > 0)
{
String Sql = @"SELECT DISTINCT A.SEQNO,f_getdeptname(A.DEPTID) DEPTNAME,f_getsupname(A.PSSID) PSSNAME,A.SHRQ
FROM DAT_YRK_DOC A,DAT_YRK_COM B,DOC_GOODSCFG C
WHERE A.SEQNO = B.SEQNO AND B.GDSEQ = C.GDSEQ AND A.FLAG = 'Y'AND A.SEQNO='{3}'
AND C.DEPTID = '{0}' AND A.SHRQ BETWEEN TO_DATE('{1}','YYYY-MM-DD') AND TO_DATE('{2}','YYYY-MM-DD') + 1";
if (ddlDEPTIN.SelectedValue.Length > 0)
{
Sql += "AND A.DEPTID = '" + ddlDEPTIN.SelectedValue + "'";
}
int total = 0;
DataTable dtData = PubFunc.DbGetPage(GridBill.PageIndex, GridBill.PageSize, String.Format(Sql, docDEPTID.SelectedValue, dbkTime1.Text, dbkTime2.Text, docSTR1.Text), ref total);
GridBill.RecordCount = total;
GridBill.DataSource = dtData;
GridBill.DataBind();
}
else
{
String Sql = @"SELECT DISTINCT A.SEQNO,f_getdeptname(A.DEPTID) DEPTNAME,f_getsupname(A.PSSID) PSSNAME,A.SHRQ
FROM DAT_YRK_DOC A,DAT_YRK_COM B,DOC_GOODSCFG C
WHERE A.SEQNO = B.SEQNO AND B.GDSEQ = C.GDSEQ AND A.FLAG = 'Y'
AND C.DEPTID = '{0}' AND A.SHRQ BETWEEN TO_DATE('{1}','YYYY-MM-DD') AND TO_DATE('{2}','YYYY-MM-DD') + 1";
if (ddlDEPTIN.SelectedValue.Length > 0)
{
Sql += " AND A.DEPTID = '" + ddlDEPTIN.SelectedValue + "'";
}
int total = 0;
DataTable dtData = PubFunc.DbGetPage(GridBill.PageIndex, GridBill.PageSize, String.Format(Sql, docDEPTID.SelectedValue, dbkTime1.Text, dbkTime2.Text), ref total);
GridBill.RecordCount = total;
GridBill.DataSource = dtData;
GridBill.DataBind();
}
}
private void DataSearch()
{
int total = 0;
string strSql = @"SELECT A.SEQNO,A.BILLNO,B.NAME FLAG_CN,A.FLAG,A.XSRQ,F_GETDEPTNAME(A.DEPTOUT) DEPTOUT,A.SUBNUM,F_GETUSERNAME(A.SLR) SLR
FROM DAT_CK_DOC A, SYS_CODEVALUE B
WHERE A.FLAG = B.CODE AND A.FLAG = 'Y' AND B.TYPE ='DIC_BILLSTATUS' AND A.BILLTYPE='LCD' AND A.XSTYPE='1' AND A.DEPTID='{0}'
ORDER BY A.XSRQ DESC";
//获取显示名称标记
DataTable dtData = PubFunc.DbGetPage(GridBill.PageIndex, GridBill.PageSize, string.Format(strSql, docDEPTID.SelectedValue), ref total);
GridBill.RecordCount = total;
GridBill.DataSource = dtData;
GridBill.DataBind();
}
