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(); }