private void DataSearch() { int total = 0; string sql = @"SELECT A.GDSEQ, A.GDNAME, A.ZJM, F_GETUNITNAME(A.UNIT) UNITNAME, A.GDSPEC, NVL(T.HWID,G.HJCODE1) HWID, G.ZDKC, G.ZGKC, F_GETSUPNAME(A.SUPPLIER) SUPPLIERNAME, F_GETPRODUCERNAME(A.PRODUCER) PRODUCERNAME, T.KFBH FROM DOC_HWZD T, DOC_GOODSCFG G, DOC_GOODS A WHERE T.HWID(+) = G.HJCODE1 AND G.GDSEQ = A.GDSEQ"; string strSearch = ""; if (lstGDSEQ.Text.Trim().Length > 0) { strSearch += string.Format(" AND (A.GDSEQ LIKE '%{0}%' or UPPER(A.ZJM) LIKE '%{0}%' or A.GDNAME LIKE '%{0}%')", lstGDSEQ.Text.Trim().ToUpper()); } if (lstDEPTID.SelectedItem != null && lstDEPTID.SelectedItem.Value.Length > 0) { strSearch += " AND G.DEPTID='" + lstDEPTID.SelectedValue + "'"; } if (lstHW.Text.Trim().Length > 0) { strSearch += " AND T.HWID='" + lstHW.Text.Trim() + "'"; } if (lstGG.Text.Trim().Length > 0) { strSearch += " AND A.GDSPEC='" + lstGG.Text.Trim() + "'"; } if (docDHLX.SelectedItem != null && docDHLX.SelectedItem.Value.Length > 0) { strSearch += " AND A.CATID0='" + docDHLX.SelectedValue + "'"; } sql += strSearch; DataTable dtData = PubFunc.DbGetPage(GridShelf.PageIndex, GridShelf.PageSize, sql, ref total); GridShelf.RecordCount = total; GridShelf.DataSource = dtData; GridShelf.DataBind(); }
private void DataSearch() { int total = 0; string sql = "SELECT HWID,JWBH,KFBH,KB,f_getusername(MANAGER) MANAGER,HWZT,DZBQH,ABC,DECODE(HWZT,'Y','可用','1','可用','不可用') HWZTNAME,F_GETDEPTNAME(a.KFBH) KFBHNAME,(select NAME FROM SYS_CODEVALUE c WHERE c.TYPE='DEPOT_AREA' and c.code=a.KB) KBNAME,XD,QYBH,PAI,LIE,CENG FROM DOC_HWZD A WHERE HWID LIKE '%{0}%' "; string strSearch = ""; if (lstDEPTID.SelectedItem != null && lstDEPTID.SelectedItem.Value.Length > 0) { strSearch += " AND KFBH='" + lstDEPTID.SelectedValue + "'"; } sql += strSearch; DataTable dtData = PubFunc.DbGetPage(GridShelf.PageIndex, GridShelf.PageSize, string.Format(sql, trbSearch.Text), ref total); GridShelf.RecordCount = total; GridShelf.DataSource = dtData; //GridShelf.DataSource = DbHelperOra.Query(string.Format(sql, trbSearch.Text)).Tables[0]; GridShelf.DataBind(); }