protected override void billSearch() { //string strSql = @"SELECT A.GDSEQ,A.GDNAME,A.GDSPEC, // F_GETUNITNAME(A.UNIT) UNITNAME, // F_GETDEPTNAME(B.DEPTID) DEPTIDNAME, // B.DEPTID,B.ZDKC,B.ZGKC,B.DSNUM, B.NUM1,B.NUM2,B.NUM3,C.OPERUSER, // TO_CHAR(C.OPERDATE,'YYYY-MM-DD') OPERDATE,C.DEFSL, // F_GETPRODUCERNAME(A.PRODUCER) PRODUCERNAME,PIZNO // FROM DOC_GOODS A, DOC_GOODSCFG B, DOC_MYGOODS C // WHERE A.GDSEQ = B.GDSEQ // AND A.GDSEQ = C.GDSEQ // AND B.GDSEQ=C.GDSEQ AND B.DEPTID=C.DEPTID"; string strSql = @"SELECT A.GDSEQ,A.GDNAME,A.GDSPEC, F_GETUNITNAME(A.UNIT) UNITNAME, F_GETDEPTNAME(B.DEPTID) DEPTIDNAME, B.DEPTID,B.ZDKC,B.ZGKC,B.DSNUM, B.NUM1,B.NUM2,B.NUM3,f_getusername(C.OPERUSER) OPERUSER, TO_CHAR(C.OPERDATE,'YYYY-MM-DD') OPERDATE,C.DEFSL,PIZNO,f_getproducername(A.PRODUCER) PRODUCERNAME FROM DOC_GOODS A, DOC_GOODSCFG B, DOC_MYGOODS C WHERE A.GDSEQ = B.GDSEQ AND A.GDSEQ = C.GDSEQ AND B.GDSEQ=C.GDSEQ AND B.DEPTID=C.DEPTID"; string strSearch = ""; if (lstDEPTID.SelectedItem != null && lstDEPTID.SelectedItem.Value.Length > 0) { strSearch += string.Format(" AND B.DEPTID='{0}'", lstDEPTID.SelectedItem.Value); } if (tgbGDSEQ.Text.Trim().Length > 0) { strSearch += string.Format(" AND (A.GDSEQ LIKE '%{0}%' OR A.GDNAME LIKE '%{0}%') ", tgbGDSEQ.Text.Trim()); } if (rblRange.SelectedValue == "1") { strSearch += string.Format(" AND C.OPERUSER='******'", UserAction.UserID); } strSql += strSearch; //int total = 0; //DataTable dt = PubFunc.DbGetPage(GridList.PageIndex, GridList.PageSize, strSql, ref total); //DataTable dt //GridList.DataSource = dt; //GridList.RecordCount = total; //GridList.DataBind(); PageContext.RegisterStartupScript(GridList.GetRejectChangesReference()); DataTable dtBill = DbHelperOra.Query(strSql).Tables[0]; PubFunc.GridRowAdd(GridList, dtBill); }