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