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