private void BindGrid()
{
List <Res> cls = Res.Ress.FindAll(
delegate(Res c)
{
return(c.Description != "Update by Excellent" &&
c.Description != "Profile" &&
c.IsPublished == true);
});
// sort in descending order
cls.Sort(delegate(Res c1, Res c2)
{ return(DateTime.Compare(c2.DateCreated, c1.DateCreated)); });
List <Res> Ress = new List <Res>(10);
int limit = 0;
for (int i = 0; i < cls.Count; i++)//only top 10 display
{
if (limit <= 10)
{
Ress.Add(cls[i]);
limit++;
}
}
GridList.DataSource = Ress;
GridList.DataBind();
}
protected void btnSearch()
{
string strSQL = " select seqno,isprivate,(select username from sys_operuser where userid = lrr) as lrName,lrrq,title,Memo,waringRQ,lookper,(select username from sys_operuser where userid = closeper) as closename, closerq ,case when flag = 'N' then '新备忘' when flag='C' then '已取消' else '已完成' end as status from sys_mymemo where (lrr='" + UserAction.UserID + "' or LookPer||',' like '%" + UserAction.UserID + ",%') ";
if (!string.IsNullOrEmpty(tbSearchTitle.Text.Trim()))
{
strSQL += " AND TITLE LIKE '%" + tbSearchTitle.Text.Trim() + "'";
}
if (dpSearchStart.SelectedDate != null)
{
strSQL += " AND lrrq >=to_date('" + Convert.ToDateTime(dpSearchStart.SelectedDate).ToString("yyyy-MM-dd") + "','YYYY-MM-DD')";
}
if (dpSearchEnd.SelectedDate != null)
{
strSQL += " AND lrrq <to_date('" + Convert.ToDateTime(dpSearchEnd.SelectedDate).ToString("yyyy-MM-dd") + "','YYYY-MM-DD')+1";
}
strSQL += " order by lrrq desc";
int total = 0;
DataTable dt = PubFunc.DbGetPage(GridList.PageIndex, GridList.PageSize, strSQL, ref total);
GridList.DataSource = dt;
GridList.RecordCount = total;
GridList.DataBind();
}
void BindGrid()
{
List <RzViewContent> rz = RZSource.Init.GetRzSourceByType(RzType, pType);
GridList.DataSource = rz;
GridList.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (lstLRRQ1.SelectedDate == null || lstLRRQ2.SelectedDate == null)
{
Alert.Show("请输入条件【申领日期】！", "提示信息", MessageBoxIcon.Warning);
return;
}
else if (lstLRRQ1.SelectedDate > lstLRRQ2.SelectedDate)
{
Alert.Show("【开始日期】大于【结束日期】，请重新输入！", "提示信息", MessageBoxIcon.Warning);
return;
}
int total = 0;
DataTable dt = PubFunc.DbGetPage(GridList.PageIndex, GridList.PageSize, GetSearchSQL(), ref total);
GridList.DataSource = dt;
GridList.RecordCount = total;
GridList.DataBind();
decimal Total1 = 0, Total2 = 0;
foreach (DataRow row in dt.Rows)
{
Total1 += Convert.ToDecimal(row["SUBSUM"] ?? "0");
Total2 += Convert.ToDecimal(row["SUBNUM"] ?? "0");
}
JObject summary = new JObject();
summary.Add("DEPTOUTNAME", "本页合计");
summary.Add("SUBSUM", Total1);
summary.Add("SUBNUM", Total2);
GridList.SummaryData = summary;
}
protected override void billSearch()
{
if (lstLRRQ1.SelectedDate == null || lstLRRQ2.SelectedDate == null)
{
Alert.Show("请输入条件【盘点日期】！");
return;
}
string strSql = @"select a.*,F_GETUSERNAME(LRY) LRYNAME,F_GETUSERNAME(SPR) SPRNAME,F_GETDEPTNAME(DEPTID) DEPTIDNAME,decode(FLAG,'N','新单','Y','已审核','已完结') FLAGNAME,DECODE(SYTYPE,'4','盘点','0','益余','1','损耗','未定义') SYTYPENAME from dat_sy_doc a ";
string strSearch = " where ";
strSearch += string.Format(" deptid in( select code FROM SYS_DEPT where F_CHK_DATARANGE(CODE, '{0}') = 'Y' )", UserAction.UserID);
strSearch += string.Format(" AND (LRRQ between TO_DATE('{0}','YYYY-MM-DD') and (TO_DATE('{1}','YYYY-MM-DD')) + 1)", lstLRRQ1.Text, lstLRRQ2.Text);
if (lstBILLNO.Text.Length > 0)
{
strSearch += string.Format(" AND SEQNO like '%{0}%'", lstBILLNO.Text);
}
if (!string.IsNullOrWhiteSpace(lstDEPTOUT.SelectedValue))
{
strSearch += string.Format(" AND deptid ='{0}'", lstDEPTOUT.SelectedValue);
}
if (!string.IsNullOrWhiteSpace(strSearch))
{
strSql += strSearch;
}
strSql += " ORDER BY LRRQ DESC";
DataTable dtBill = new DataTable();
dtBill = DbHelperOra.Query(strSql).Tables[0];
GridList.DataSource = dtBill;
GridList.DataBind();
}
private void DataSearch()
{
if (lstLRRQ1.SelectedDate == null || lstLRRQ2.SelectedDate == null)
{
Alert.Show("请输入条件【查询期间】！", MessageBoxIcon.Warning);
return;
}
else if (lstLRRQ1.SelectedDate > lstLRRQ2.SelectedDate)
{
Alert.Show("【开始日期】大于【结束日期】，请重新输入！", MessageBoxIcon.Warning);
return;
}
if (ddlDEPTID.SelectedValue.Length < 1)
{
Alert.Show("请输入条件【库房】！", MessageBoxIcon.Warning);
return;
}
int total = 0;
DataTable dtData = PubFunc.DbGetPage(GridList.PageIndex, GridList.PageSize, GetSearchSql(), ref total);
GridList.RecordCount = total;
GridList.DataSource = dtData;
GridList.DataBind();
}
private void fillIndList()
{
string connectionString = ConfigurationManager.ConnectionStrings["CN"].ConnectionString;
string sql = "Select *,IDT_MST.DPCD,ITMMST.NAME AS ITEMNAME,DEPT_MST.NAME AS DEPARTMENT From IDT_TRN INNER JOIN IDT_MST ON IDT_MST.COMP=IDT_TRN.COMP AND IDT_MST.INDNO=IDT_TRN.INDNO INNER JOIN ITMMST ON IDT_TRN.ICOD =ITMMST.CODE LEFT JOIN DEPT_MST ON IDT_MST.COMP =DEPT_MST.COMP AND IDT_MST.UNIT =DEPT_MST.UNIT AND IDT_MST.DPCD =DEPT_MST.CODE WHERE (ITEMSTATUS='N' OR ITEMSTATUS='H') AND IDT_TRN.COMP='0001' AND IDT_TRN.UNIT ='000001' AND IDT_TRN.RECSTAT <> 'D'";
using (SqlConnection sqlConnection = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand(sql))
{
using (SqlDataAdapter sda = new SqlDataAdapter())
{
cmd.Connection = sqlConnection;
sda.SelectCommand = cmd;
using (DataTable dt = new DataTable())
{
sda.Fill(dt);
GridList.DataSource = dt;
GridList.DataBind();
GridList.HeaderRow.TableSection = TableRowSection.TableHeader;
}
}
}
}
}
protected override void billSearch()
{
if (lstLRRQ1.SelectedDate == null || lstLRRQ2.SelectedDate == null)
{
Alert.Show("请输入条件【损益日期】！");
return;
}
string strSql = @"SELECT A.*,F_GETUSERNAME(LRY) LRYNAME,F_GETUSERNAME(SHR) SHRNAME,F_GETDEPTNAME(DEPTID) DEPTIDNAME,F_GETSYTYPENAME(SYTYPE) SYTYPENAME,DECODE(FLAG,'N','已提交','Y','已审核','R','已驳回','已执行') FLAGNAME,F_GETSYTYPENAME(SYTYPE) SYTYPENAME
FROM DAT_SY_DOC A WHERE A.FLAG <>'M' ";
string strSearch = "";
if (lstBILLNO.Text.Length > 0)
{
strSearch += string.Format(" AND SEQNO like '%{0}%'", lstBILLNO.Text);
}
if (lisFLAG.SelectedValue.Length > 0)
{
strSearch += string.Format(" AND FLAG = '{0}'", lisFLAG.SelectedValue);
}
strSearch += string.Format(" AND (LRRQ between TO_DATE('{0}','YYYY-MM-DD') and (TO_DATE('{1}','YYYY-MM-DD')) + 1)", lstLRRQ1.Text, lstLRRQ2.Text);
if (!string.IsNullOrWhiteSpace(strSearch))
{
strSql += strSearch;
}
strSql += " ORDER BY LRRQ DESC";
highlightRows.Text = ",";
DataTable dtBill = new DataTable();
dtBill = DbHelperOra.Query(strSql).Tables[0];
GridList.DataSource = dtBill;
GridList.DataBind();
}
private void DataSearch()
{
if (PubFunc.StrIsEmpty(dpkKSRQ.SelectedDate.ToString()) || PubFunc.StrIsEmpty(dpkJSRQ.SelectedDate.ToString()))
{
Alert.Show("输入日期不正确,请检查！");
return;
}
if (dpkKSRQ.SelectedDate > dpkJSRQ.SelectedDate)
{
Alert.Show("开始日期不能大于结束日期！");
return;
}
string strMonitor = " ";
strMonitor += " AND execrq BETWEEN TO_DATE('" + dpkKSRQ.Text + "','YYYY/MM/DD') and TO_DATE('" + dpkJSRQ.Text + "','YYYY/MM/DD') + 1";
if (chkCHULI.Checked)
{
strMonitor += " AND FLAG = 'N' ";
}
strSql = strSql + strMonitor;
int total = 0;
DataTable dtData = PubFunc.DbGetPage(GridList.PageIndex, GridList.PageSize, strSql, ref total);
GridList.RecordCount = total;
GridList.DataSource = dtData;
GridList.DataBind();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (lstLRRQ1.SelectedDate == null)
{
Alert.Show("请输入条件【录入日期】！");
return;
}
string strSearch = "";
if (lstBILLNO.Text.Length > 0)
{
strSearch += string.Format(" AND A.BILLNO LIKE '%{0}%'", lstBILLNO.Text);
}
strSearch += string.Format(" AND A.FLAG='S'");
if (lstLRY.SelectedItem != null && lstLRY.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.LRY='{0}'", UserAction.UserID);
}
strSearch += string.Format(" AND A.LRRQ>=TO_DATE('{0}','YYYY-MM-DD')", lstLRRQ1.Text);
if (!string.IsNullOrWhiteSpace(strSearch))
{
strSql += strSearch;
}
GridList.DataSource = DbHelperOra.Query(strSql).Tables[0];
GridList.DataBind();
}
protected override void billSearch()
{
if (lstLRRQ1.SelectedDate == null || lstLRRQ2.SelectedDate == null)
{
Alert.Show("请输入条件【结算日期】！");
return;
}
DataTable dtBill = DbHelperOra.Query(GetQuerySql()).Tables[0];
GridList.DataSource = dtBill;
GridList.DataBind();
//计算合计数量
decimal bzslTotal = 0, feTotal = 0, feeTotal = 0;
foreach (DataRow row in dtBill.Rows)
{
bzslTotal += Convert.ToDecimal(string.IsNullOrWhiteSpace(row["XSJE"].ToString()) ? "0" : row["XSJE"]);
feeTotal += Convert.ToDecimal(string.IsNullOrWhiteSpace(row["THJE"].ToString()) ? "0" : row["THJE"]);
feTotal += Convert.ToDecimal(string.IsNullOrWhiteSpace(row["YJJJ"].ToString()) ? "0" : row["YJJJ"]);
}
JObject summary = new JObject();
summary.Add("FLAGNAME", "本页合计");
summary.Add("XSJE", bzslTotal.ToString("F2"));
summary.Add("THJE", feeTotal.ToString("F2"));
summary.Add("YJJJ", feTotal.ToString("F2"));
GridList.SummaryData = summary;
}
protected override void billSearch()
{
if (lstLRRQ1.SelectedDate == null || lstLRRQ2.SelectedDate == null)
{
Alert.Show("请输入条件【盘点日期】！", MessageBoxIcon.Warning);
return;
}
string strSql = @"select a.*,F_GETUSERNAME(LRY) LRYNAME,F_GETUSERNAME(SPR) SPRNAME,decode(FLAG,'N','新单','Y','已审核','S','已完结','R','已驳回','已提交') FLAGNAME,DECODE(PDTYPE,'1','普通盘点','2','动销盘点','3','月末盘点','4','APP盘点','未定义') PDTYPENAME from dat_pdplan_doc a where 1=1 ";
string strSearch = "";
if (lstBILLNO.Text.Length > 0)
{
strSearch += string.Format(" AND SEQNO like '%{0}%'", lstBILLNO.Text);
}
if (lstFLAG.SelectedValue.Length > 0)
{
strSearch += string.Format(" AND FLAG='{0}'", lstFLAG.SelectedValue);
}
strSearch += string.Format(" AND (PDRQ between TO_DATE('{0}','YYYY-MM-DD') and (TO_DATE('{1}','YYYY-MM-DD')) + 1)", lstLRRQ1.Text, lstLRRQ2.Text);
if (!string.IsNullOrWhiteSpace(strSearch))
{
strSql += strSearch;
}
strSql += " ORDER BY PDRQ DESC";
DataTable dtBill = new DataTable();
dtBill = DbHelperOra.Query(strSql).Tables[0];
GridList.DataSource = dtBill;
GridList.DataBind();
}
protected override void billSearch()
{
if (lstLRRQ1.SelectedDate == null || lstLRRQ2.SelectedDate == null)
{
Alert.Show("请输入条件【使用日期】！");
return;
}
else if (lstLRRQ1.SelectedDate > lstLRRQ2.SelectedDate)
{
Alert.Show("开始日期大于结束日期，请重新输入！");
return;
}
string strSql = @"SELECT A.SEQNO,A.BILLNO,
a.flag,
decode(a.flag,'M','新单','N','提交','Q','启用','S','已审核','Y','已审批','R','已驳回','F','已废弃') flagname,
decode(a.XGTYPE,'N','新增','M','修改','D','作废') xgtypename,
A.SUBNUM,
F_GETUSERNAME(A.LRY) LRY,
A.LRRQ,
F_GETUSERNAME(A.SPR) SPR,
A.SPRQ,
F_GETUSERNAME(A.SHR) SHR,
A.SHRQ,
A.MEMO
from DAT_TZSUP_DOC A WHERE 1=1 ";
string strSearch = "";
if (lstBILLNO.Text.Length > 0)
{
strSearch += string.Format(" AND TRIM(UPPER(A.BILLNO)) LIKE '%{0}%'", lstBILLNO.Text.Trim().ToUpper());
}
if (!string.IsNullOrWhiteSpace(lstFLAG.SelectedValue))
{
strSearch += string.Format(" AND A.FLAG='{0}'", lstFLAG.SelectedValue);
}
if (Request.QueryString["oper"] != null)
{
string oper = Request.QueryString["oper"].ToString();
if (oper == "zj")
{
strSearch += string.Format(" AND A.FLAG<>'M'", lstFLAG.SelectedValue);
}
}
strSearch += string.Format(" AND A.LRRQ>=TO_DATE('{0}','YYYY-MM-DD')", lstLRRQ1.Text);
strSearch += string.Format(" AND A.LRRQ <TO_DATE('{0}','YYYY-MM-DD') + 1", lstLRRQ2.Text);
if (!string.IsNullOrWhiteSpace(strSearch))
{
strSql += strSearch;
}
strSql += " ORDER BY DECODE(A.FLAG,'M','1','R','2','N','3','Q','4','S','5','6'),A.BILLNO DESC";
highlightRowYellow.Text = "";
highlightRowRed.Text = "";
highlightRowGreen.Text = "";
GridList.DataSource = DbHelperOra.Query(strSql).Tables[0];
GridList.DataBind();
}
protected void billSearch()
{
string strSql = @"select A.GDSEQ,
A.GDNAME,
A.GDSPEC,
f_getunitname(A.UNIT) UNIT,
f_getdeptname(B.DEPTID) DEPTIDname,
B.DEPTID,
B.ZDKC,
B.ZGKC,
B.DSNUM,
B.NUM1,
B.NUM2,
B.NUM3,
F_GETISCOLLECT(B.DEPTID, A.GDSEQ) COLLECT,
F_GETPRODUCERNAME(A.PRODUCER) PRODUCERNAME,
PIZNO,
(B.DSNUM * B.NUM1) DSKUCUN,
NVL(B.DSPOOL, 0) DSPOOL,
--DECODE((NVL(B.DSNUM, 0) - NVL(B.NUM3, 0)), 0, '已配送', NVL(B.DSNUM, 0) - NVL(B.NUM3, 0)) NOTDS
--应出定数 = 定数数量-代收定数-定数预占
CASE
WHEN (NVL(B.DSNUM, 0) - NVL(B.NUM3, 0) - NVL(B.DSPOOL, 0)) >0 THEN (NVL(B.DSNUM, 0) - NVL(B.NUM3, 0) - NVL(B.DSPOOL, 0))
--WHEN (NVL(B.DSNUM, 0) - NVL(B.NUM3, 0) - NVL(B.DSPOOL, 0)) <= 0 THEN 0
ELSE 0 END YCDS
from doc_goods A, DOC_GOODSCFG B
where a.gdseq(+) = b.gdseq";
string strSearch = "";
string strSearchOrder = " order by A.GDSEQ";
if (tbxGDSEQ.Text.Trim().Length > 0)
{
strSearch += string.Format(" AND (B.GDSEQ LIKE '%{0}%' OR A.GDNAME LIKE '%{0}%')", tbxGDSEQ.Text.Trim());
}
if (lstDEPTID.SelectedItem != null && lstDEPTID.SelectedIndex > 0)
{
strSearch += string.Format(" AND B.DEPTID = '{0}'", lstDEPTID.SelectedValue);
}
if (ShowMode.Checked == false)
{
strSearch += " AND ((B.DSNUM >0 AND B.NUM1 > 0) or nvl(B.NUM3,0) >0 )";
}
if (DbHelperOra.GetSingle(string.Format("select distinct deptid from SYS_USERRANGE t where userid='{0}'", UserAction.UserID)) != null)
{
strSearch += string.Format(" and b.deptid in (select distinct deptid from SYS_USERRANGE t where userid='{0}')", UserAction.UserID);
}
strSql += strSearch;
strSql += strSearchOrder;
int total = 0;
DataTable dt = PubFunc.DbGetPage(GridList.PageIndex, GridList.PageSize, strSql, ref total);
GridList.DataSource = dt;
GridList.RecordCount = total;
GridList.DataBind();
OutputSummaryData(dt);
}
protected override void billSearch()
{
if (lstLRRQ1.SelectedDate == null || lstLRRQ2.SelectedDate == null)
{
Alert.Show("请输入条件【申领日期】！", "提示信息", MessageBoxIcon.Warning);
return;
}
else if (lstLRRQ1.SelectedDate > lstLRRQ2.SelectedDate)
{
Alert.Show("【开始日期】大于【结束日期】，请重新输入！", "提示信息", MessageBoxIcon.Warning);
return;
}
string strSql = @"SELECT A.SEQNO,A.BILLNO,A.FLAG,F_GETDEPTNAME(A.DEPTID) DEPTID,A.XSRQ,F_GETDEPTNAME(A.DEPTOUT) DEPTOUT,
DECODE(A.FLAG,'M','新单','N','已提交','S' ,'已分配','R' ,'已驳回','Y' ,'已出库','G' ,'已结算') FLAG_CN,
A.SUBNUM,F_GETUSERNAME(A.SLR) SLR,F_GETUSERNAME(A.LRY) LRY,A.LRRQ,F_GETUSERNAME(A.SHR) SHR,A.SHRQ,A.MEMO,A.STR2,DECODE(OPER,'P','已打印','未打印') PRINT, FUNCTIME,OPERUSER,OPERTIME
FROM DAT_CK_DOC A, SYS_FUNCPRNNUM B
WHERE A.XSTYPE='1' AND A.BILLTYPE='LCD' AND A.SEQNO = B.FUNCNO(+) ";
string strSearch = "";
if (lstBILLNO.Text.Length > 0)
{
strSearch += string.Format(" AND A.BILLNO LIKE '%{0}%'", lstBILLNO.Text);
}
if (lstFLAG.SelectedItem != null && lstFLAG.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.FLAG='{0}'", lstFLAG.SelectedItem.Value);
}
if (tbxSTR2.Text.Trim().Length > 0)
{
strSearch += string.Format(" AND A.STR2 LIKE '%{0}%'", tbxSTR2.Text.Trim());
}
if (lstDEPTID.SelectedItem != null && lstDEPTID.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.DEPTID='{0}'", lstDEPTID.SelectedItem.Value);
}
if (lstDEPTOUT.SelectedItem != null && lstDEPTOUT.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND DEPTOUT='{0}'", lstDEPTOUT.SelectedItem.Value);
}
if (lstLRY.SelectedItem != null && lstLRY.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND LRY = '{0}'", lstLRY.SelectedItem.Value);
}
strSearch += string.Format(" AND deptid in( select code FROM SYS_DEPT where type <>'1' and F_CHK_DATARANGE(CODE, '{0}') = 'Y' )", UserAction.UserID);
strSearch += string.Format(" AND A.LRRQ>=TO_DATE('{0}','YYYY-MM-DD')", lstLRRQ1.Text);
strSearch += string.Format(" AND A.LRRQ <TO_DATE('{0}','YYYY-MM-DD') + 1", lstLRRQ2.Text);
if (!string.IsNullOrWhiteSpace(strSearch))
{
strSql += strSearch;
}
strSql += " ORDER BY DECODE(A.FLAG,'M','1','N','2','S' ,'3','R' ,'4','Y' ,'5','G' ,'6','7'),A.BILLNO DESC";
int total = 0;
GridList.DataSource = PubFunc.DbGetPage(GridList.PageIndex, GridList.PageSize, strSql, ref total);
GridList.RecordCount = total;
GridList.DataBind();
}
protected override void billSearch()
{
if (lstLRRQ1.SelectedDate == null || lstLRRQ2.SelectedDate == null)
{
Alert.Show("请输入条件【申领日期】！");
return;
}
else if (lstLRRQ1.SelectedDate > lstLRRQ2.SelectedDate)
{
Alert.Show("开始日期大于结束日期，请重新输入！");
return;
}
string strSql = @"SELECT A.SEQNO,A.BILLNO,B.NAME FLAG_CN,A.FLAG,F_GETDEPTNAME(A.DEPTID) DEPTID,A.XSRQ,F_GETDEPTNAME(A.DEPTOUT) DEPTOUT,
A.SUBNUM,F_GETUSERNAME(A.SLR) SLR,F_GETUSERNAME(A.LRY) LRY,A.LRRQ,F_GETUSERNAME(A.SHR) SHR,A.SHRQ,A.MEMO
from DAT_SL_DOC A, SYS_CODEVALUE B
WHERE A.FLAG = B.CODE AND B.TYPE ='DIC_BILLSTATUS' AND BILLTYPE='LYD' AND XSTYPE='1' AND A.FLAG IN('N','S','B','F') ";
string strSearch = "";
if (lstBILLNO.Text.Length > 0)
{
strSearch += string.Format(" AND A.BILLNO LIKE '%{0}%'", lstBILLNO.Text);
}
if (lstFLAG.SelectedItem != null && lstFLAG.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.FLAG='{0}'", lstFLAG.SelectedItem.Value);
}
if (lstDEPTID.SelectedValue != null && lstDEPTID.SelectedValue.Length > 0)
{
strSearch += string.Format(" AND A.DEPTID='{0}'", lstDEPTID.SelectedValue);
}
if (lstDEPTOUT.SelectedItem != null && lstDEPTOUT.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND DEPTOUT='{0}'", lstDEPTOUT.SelectedItem.Value);
}
if (lstSLR.SelectedItem != null && lstSLR.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND SLR='{0}'", lstSLR.SelectedItem.Value);
}
strSearch += string.Format(" AND deptid in( select code FROM SYS_DEPT where type <>'1' and F_CHK_DATARANGE(CODE, '{0}') = 'Y' )", UserAction.UserID);
strSearch += string.Format(" AND A.XSRQ>=TO_DATE('{0}','YYYY-MM-DD')", lstLRRQ1.Text);
strSearch += string.Format(" AND A.XSRQ <TO_DATE('{0}','YYYY-MM-DD') + 1", lstLRRQ2.Text);
if (!string.IsNullOrWhiteSpace(strSearch))
{
strSql += strSearch;
}
strSql += " ORDER BY A.BILLNO DESC";
highlightRows.Text = "";
highlightRowYellow.Text = "";
highRedlightRows.Text = "";
DataTable table = DbHelperOra.Query(strSql).Tables[0];
DataView view1 = table.DefaultView;
view1.Sort = String.Format("{0} {1}", GridList.SortField, GridList.SortDirection);
GridList.DataSource = view1;
GridList.DataBind();
}
protected override void billSearch()
{
if (lstLRRQ1.SelectedDate == null || lstLRRQ2.SelectedDate == null)
{
Alert.Show("请输入条件【使用日期】！");
return;
}
else if (lstLRRQ1.SelectedDate > lstLRRQ2.SelectedDate)
{
Alert.Show("【开始日期】大于【结束日期】，请重新输入！", MessageBoxIcon.Warning);
return;
}
string strSql = @"SELECT A.SEQNO,A.BILLNO,decode(A.FLAG,'N','新单','A','已提交','W','已出库','R','已驳回','Y','已收货','未定义') FLAGNAME,A.FLAG,F_GETDEPTNAME(A.DEPTID) DEPTID,A.XSRQ,F_GETDEPTNAME(A.DEPTOUT) DEPTOUT,A.SUBSUM,
A.SUBNUM,F_GETUSERNAME(A.LRY) LRY,A.LRRQ,A.SHRQ,A.MEMO,F_GETUSERNAME(A.SHR) SHR
from DAT_DB_DOC A
WHERE BILLTYPE='DBD' AND XSTYPE='1' ";
string strSearch = "";
if (tgbBILLNO.Text.Length > 0)
{
strSearch += string.Format(" AND UPPER(TRIM(A.BILLNO)) LIKE '%{0}%'", tgbBILLNO.Text.Trim().ToUpper());
}
if (lstDEPTID.SelectedItem != null && lstDEPTID.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.DEPTID='{0}'", lstDEPTID.SelectedItem.Value);
}
if (ddlDEPTOUT.SelectedValue.Length > 0)
{
strSearch += string.Format(" AND A.DEPTOUT='{0}'", ddlDEPTOUT.SelectedItem.Value);
}
if (!PubFunc.StrIsEmpty(lstFLAG.SelectedValue))
{
strSearch += string.Format(" AND A.FLAG='{0}'", lstFLAG.SelectedValue);
}
strSearch += string.Format(" AND deptid in( select code FROM SYS_DEPT where F_CHK_DATARANGE(CODE, '{0}') = 'Y' )", UserAction.UserID);
strSearch += string.Format(" AND A.XSRQ>=TO_DATE('{0}','YYYY-MM-DD')", lstLRRQ1.Text);
strSearch += string.Format(" AND A.XSRQ <TO_DATE('{0}','YYYY-MM-DD') + 1", lstLRRQ2.Text);
if (!string.IsNullOrWhiteSpace(strSearch))
{
strSql += strSearch;
}
if (hdfOper.Text == "audit")
{
strSql += " AND A.FLAG IN('A','W') ";
}
else
{
strSql += " AND A.FLAG IN('N','A') ";
}
strSql += " ORDER BY A.BILLNO DESC";
highlightRows.Text = "";
highlightRowYellow.Text = "";
highlightRowRed.Text = "";
GridList.DataSource = DbHelperOra.Query(strSql).Tables[0];
GridList.DataBind();
}
protected void bntSearch_Click(object sender, EventArgs e)
{
DataTable dt = DbHelperOra.Query(GetSql()).Tables[0];
GridList.DataSource = dt;
GridList.DataBind();
btnAutoOrder.Enabled = true;
}
protected override void billSearch()
{
int total = 0;
DataTable dt = PubFunc.DbGetPage(GridList.PageIndex, GridList.PageSize, GetQuerySql(), ref total);
GridList.DataSource = dt;
GridList.RecordCount = total;
GridList.DataBind();
}
protected override void billSearch()
{
if (lstLRRQ1.SelectedDate == null || lstLRRQ2.SelectedDate == null)
{
Alert.Show("输入条件录入日期不正确！");
return;
}
else if (lstLRRQ1.SelectedDate > lstLRRQ2.SelectedDate)
{
Alert.Show("开始日期大于结束日期，请重新输入！");
return;
}
string strSql = @"SELECT A.SEQNO,A.BILLNO,DECODE(A.FLAG,'Y','已审核','R','已驳回','新单') FLAG,F_GETDEPTNAME(A.DEPTID) DEPTID,A.XSRQ,F_GETDEPTNAME(A.DEPTOUT) DEPTOUT,
A.SUBNUM,F_GETUSERNAME(A.LRY) SLR,F_GETUSERNAME(A.LRY) LRY,A.LRRQ,A.SHR,F_GETUSERNAME(A.SHR) SHRNAME,A.SHRQ,A.MEMO
from DAT_CK_DOC A
WHERE BILLTYPE='DST' AND XSTYPE='2' ";
string strSearch = "";
if (lstBILLNO.Text.Length > 0)
{
strSearch += string.Format(" AND A.BILLNO LIKE '%{0}%'", lstBILLNO.Text);
}
if (lstFLAG.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.FLAG='{0}'", lstFLAG.SelectedItem.Value);
}
if (lstSLR.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.SLR='{0}'", lstSLR.SelectedItem.Value);
}
if (lstDEPTID.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.DEPTID='{0}'", lstDEPTID.SelectedItem.Value);
}
if (lstDEPTOUT.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND DEPTOUT='{0}'", lstDEPTOUT.SelectedItem.Value);
}
if (tbxGDSEQ.Text.Trim().Length > 0)
{
strSearch += string.Format(" AND EXISTS (SELECT 1 FROM DAT_CK_COM C,DOC_GOODS B WHERE A.SEQNO = C.SEQNO AND C.GDSEQ = B.GDSEQ AND (B.GDSEQ LIKE '%{0}%' OR B.GDNAME LIKE '%{0}%' OR B.ZJM LIKE '%{0}%' OR B.BAR3 LIKE '%{0}%'))", tbxGDSEQ.Text.Trim().ToUpper());
}
strSearch += string.Format(" AND deptid in( select code FROM SYS_DEPT where type <>'1' and F_CHK_DATARANGE(CODE, '{0}') = 'Y' )", UserAction.UserID);
strSearch += string.Format(" AND A.LRRQ>=TO_DATE('{0}','YYYY-MM-DD')", lstLRRQ1.Text);
strSearch += string.Format(" AND A.LRRQ <TO_DATE('{0}','YYYY-MM-DD') + 1", lstLRRQ2.Text);
if (!string.IsNullOrWhiteSpace(strSearch))
{
strSql += strSearch;
}
strSql += " ORDER BY A.BILLNO DESC";
highlightRows.Text = "";
GridList.DataSource = DbHelperOra.Query(strSql).Tables[0];
GridList.DataBind();
}
protected void btnSearch()
{
string strSQL = "SELECT SYSNAME,VERSION,UPTDATE,TO_CHAR(UPTMEMO) UPTMEMO,f_getusername(UPTPER) UPTPER, f_getusername(TESTPER) TESTPER,f_getusername(checkper) checkper FROM SYS_VERSION WHERE FLAG = 'Y' ORDER BY uptdate DESC";
int total = 0;
DataTable dt = PubFunc.DbGetPage(GridList.PageIndex, GridList.PageSize, strSQL, ref total);
GridList.DataSource = dt;
GridList.RecordCount = total;
GridList.DataBind();
}
protected void GridList_Sort(object sender, GridSortEventArgs e)
{
GridList.SortDirection = e.SortDirection;
GridList.SortField = e.SortField;
DataView view1 = PubFunc.GridDataGet(GridList).DefaultView;
view1.Sort = String.Format("{0} {1}", GridList.SortField, GridList.SortDirection);
GridList.DataSource = view1;
GridList.DataBind();
}
private void DataQuery()
{
if (lstSCRQ1.SelectedDate == null || lstSCRQ2.SelectedDate == null)
{
Alert.Show("请输入条件【查询日期】！");
return;
}
else if (lstSCRQ1.SelectedDate > lstSCRQ2.SelectedDate)
{
Alert.Show("开始日期大于结束日期，请重新输入！");
return;
}
//string sql = "select A.*,B.DONAME from DAT_DO_LIST A,DAT_DO_TYPE B WHERE A.DOTYPE=B.DOTYPE ";
string sql = @"select A.*,
f_getroleid(a.rolelist) ROLELISTNAME,
B.DONAME,
(case A.Flag
when 'Y' then
'信息已处理，不显示'
when 'N' then
'信息未处理，显示'
else
'维护信息'
end) FLAGNAME,
f_getusername(A.USERID) USERNAME,
f_getusername(A.DOUSER) DOUSERNAME,
C.FUNCNAME
from DAT_DO_LIST A, DAT_DO_TYPE B, SYS_FUNCTION C
WHERE A.DOTYPE = B.DOTYPE
AND A.FUNCID = C.FUNCID(+) ";
int total = 0;
if (lstDOTYPE.SelectedItem != null && lstDOTYPE.SelectedItem.Value.Length > 0)
{
sql += string.Format(" AND A.DOTYPE='{0}'", lstDOTYPE.SelectedItem.Value);
}
if (lstFLAG.SelectedItem != null && lstFLAG.SelectedItem.Value.Length > 0)
{
sql += string.Format(" AND A.FLAG='{0}'", lstFLAG.SelectedItem.Value);
}
sql += string.Format(" AND a.scrq>=TO_DATE('{0}','yyyy-mm-dd hh24:mi:ss')", lstSCRQ1.SelectedDate);
sql += string.Format(" AND a.scrq <=TO_DATE('{0}','yyyy-mm-dd hh24:mi:ss')+1 ", lstSCRQ2.SelectedDate);
// sql += string.Format(" AND F_CHK_ROLELIST(B.ROLELIST, '{0}') = 'Y'" , UserAction.UserRole);
sql += " ORDER BY A.SCRQ DESC";
GridList.DataSource = PubFunc.DbGetPage(GridList.PageIndex, GridList.PageSize, sql, ref total);
GridList.RecordCount = total;
GridList.DataBind();
}
private void DataSearch()
{
highlightRows.Text = "";
highlightRowsGreen.Text = "";
int count = 0;
GridList.DataSource = GetDataTable(GridList.PageIndex, GridList.PageSize, GetSearchSql(), ref count);
GridList.RecordCount = count;
GridList.DataBind();
}
protected override void billSearch()
{
if (lstLRRQ1.SelectedDate == null || lstLRRQ2.SelectedDate == null)
{
Alert.Show("请输入条件【使用日期】！");
return;
}
else if (lstLRRQ1.SelectedDate > lstLRRQ2.SelectedDate)
{
Alert.Show("开始日期大于结束日期，请重新输入！");
return;
}
string strSql = @"SELECT A.SEQNO,A.BILLNO, F_GETBILLFLAG(FLAG) FLAG_CN, FLAG,F_GETDEPTNAME(A.DEPTID) DEPTID,A.THRQ,F_GETSUPNAME(A.PSSID) SUPNAME,A.SUBSUM,
A.SUBNUM,F_GETUSERNAME(A.CGY) CGY,F_GETUSERNAME(A.LRY) LRY,A.LRRQ,F_GETUSERNAME(A.SHR) SHR,A.SHRQ,A.MEMO
from DAT_TH_DOC A
WHERE NVL(A.NUM1,0) = 2 AND A.DEPTID in( select code FROM SYS_DEPT where F_CHK_DATARANGE(CODE, '" + UserAction.UserID + "') = 'Y' ) ";
string strSearch = "";
if (lstBILLNO.Text.Length > 0)
{
strSearch += string.Format(" AND UPPER(TRIM(A.BILLNO)) LIKE '%{0}%'", lstBILLNO.Text.Trim().ToUpper());
}
if (lstDEPTID.SelectedItem != null && lstDEPTID.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.DEPTID='{0}'", lstDEPTID.SelectedItem.Value);
}
if (lstCGY.SelectedItem != null && lstCGY.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.CGY='{0}'", lstCGY.SelectedItem.Value);
}
if (lstPSSID.SelectedItem != null && lstPSSID.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.PSSID='{0}'", lstPSSID.SelectedItem.Value);
}
//过滤新单的单据，不能审核，提交后的才能审核
if (Request.QueryString["oper"].ToString() == "audit")
{
strSearch += " AND A.FLAG<>'M'";
}
// strSearch += string.Format(" AND deptid in( select code FROM SYS_DEPT where F_CHK_DATARANGE(CODE, '{0}') = 'Y' )", UserAction.UserID);
strSearch += string.Format(" AND A.THRQ>=TO_DATE('{0}','YYYY-MM-DD')", lstLRRQ1.Text);
strSearch += string.Format(" AND A.THRQ <TO_DATE('{0}','YYYY-MM-DD') + 1", lstLRRQ2.Text);
if (!string.IsNullOrWhiteSpace(strSearch))
{
strSql += strSearch;
}
strSql += " ORDER BY A.BILLNO DESC";
GridList.DataSource = DbHelperOra.Query(strSql).Tables[0];
GridList.DataBind();
}
protected override void billSearch()
{
if (lstLRRQ1.SelectedDate == null || lstLRRQ2.SelectedDate == null)
{
Alert.Show("请输入条件【结算日期】！");
return;
}
string strSql = @"select
CUSTID,SEQNO,DEPTID,F_GETDEPTNAME(DEPTID) DEPTIDNAME,SUPID,SUPNAME,FLAG,decode(FLAG,'Y','已结算','G','已付款','R','驳回','未结算') FLAGNAME,GATFUNDCORP,GATFUNDBANK,GATACCNTNO,LINKMAN,LINKTEL,
CWLINKMAN,CWLINKTEL,BEGRQ,ENDRQ,SYJE,XSJE,THJE,JSJE,FPJE,FPHM,LRY,LRRQ,SPR,SPRQ,SHR,WJJE,YJJJ,JSJE,WJJE,
SHRQ,MEMO,STR1,STR2,STR3,NUM1,NUM2,NUM3,UPTTIME
from dat_jsd_doc where 1=1 ";
string strSearch = "";
if (lstBILLNO.Text.Length > 0)
{
strSearch += string.Format(" AND SEQNO LIKE '%{0}%'", lstBILLNO.Text);
}
if (lstFLAG.SelectedValue.Length > 0)
{
strSearch += string.Format(" AND FLAG = '{0}'", lstFLAG.SelectedValue);
}
strSearch += string.Format(" AND ((BEGRQ between TO_DATE('{0}','YYYY-MM-DD') and (TO_DATE('{1}','YYYY-MM-DD')) + 1) or (ENDRQ between TO_DATE('{0}','YYYY-MM-DD') and (TO_DATE('{1}','YYYY-MM-DD') + 1)))", lstLRRQ1.Text, lstLRRQ2.Text);
if (!string.IsNullOrWhiteSpace(strSearch))
{
strSql += strSearch;
}
strSql += " ORDER BY DEPTID,ENDRQ DESC";
highlightRows.Text = "";
DataTable dtBill = new DataTable();
dtBill = DbHelperOra.Query(strSql).Tables[0];
GridList.DataSource = dtBill;
GridList.DataBind();
//计算合计数量
decimal ddslTotal = 0, bzslTotal = 0, feTotal = 0, feeTotal = 0;
foreach (DataRow row in dtBill.Rows)
{
ddslTotal += Convert.ToDecimal(row["SYJE"]);
bzslTotal += Convert.ToDecimal(row["XSJE"]);
feeTotal += Convert.ToDecimal(row["THJE"]);
feTotal += Convert.ToDecimal(row["YJJJ"]);
}
JObject summary = new JObject();
summary.Add("FLAGNAME", "本页合计");
summary.Add("SYJE", ddslTotal.ToString("F2"));
summary.Add("XSJE", bzslTotal.ToString("F2"));
summary.Add("THJE", feeTotal.ToString("F2"));
summary.Add("YJJJ", feTotal.ToString("F2"));
GridList.SummaryData = summary;
}
void BindGrid()
{
List <Excellent> exs = Excellent.Excellents.FindAll(
delegate(Excellent e)
{
return(e.IsPublished == true);
});
GridList.DataSource = exs;
GridList.DataBind();
}
protected override void billSearch()
{
if (lstLRRQ1.SelectedDate == null || lstLRRQ2.SelectedDate == null)
{
Alert.Show("输入条件录入日期不正确！");
return;
}
else if (lstLRRQ1.SelectedDate > lstLRRQ2.SelectedDate)
{
Alert.Show("开始日期大于结束日期，请重新输入！");
return;
}
string strSql = @"SELECT A.SEQNO,A.BILLNO,B.NAME FLAG,F_GETDEPTNAME(A.DEPTID) DEPTID,A.XSRQ,F_GETDEPTNAME(A.DEPTOUT) DEPTOUT,A.SUBSUM,
A.SUBNUM,F_GETUSERNAME(A.SLR) SLR,F_GETUSERNAME(A.LRY) LRY,A.LRRQ,A.SHR,A.SHRQ,A.MEMO
from DAT_CK_DOC A, SYS_CODEVALUE B
WHERE A.FLAG = B.CODE AND B.TYPE ='DIC_BILLSTATUS' AND BILLTYPE='DSC' AND XSTYPE='1' ";
string strSearch = "";
if (lstBILLNO.Text.Length > 0)
{
strSearch += string.Format(" AND A.BILLNO LIKE '%{0}%'", lstBILLNO.Text);
}
if (lstFLAG.SelectedValue.Length > 0)
{
strSearch += string.Format(" AND A.FLAG='{0}'", lstFLAG.SelectedItem.Value);
}
if (lstSLR.SelectedValue.Length > 0)
{
strSearch += string.Format(" AND A.SLR='{0}'", lstSLR.SelectedItem.Value);
}
if (lstDEPTID.SelectedValue.Length > 0)
{
strSearch += string.Format(" AND A.DEPTID='{0}'", lstDEPTID.SelectedItem.Value);
}
if (lstDEPTOUT.SelectedValue.Length > 0)
{
strSearch += string.Format(" AND DEPTOUT='{0}'", lstDEPTOUT.SelectedItem.Value);
}
strSearch += string.Format(" AND deptid in( select code FROM SYS_DEPT where type <>'1' and F_CHK_DATARANGE(CODE, '{0}') = 'Y' )", UserAction.UserID);
strSearch += string.Format(" AND A.LRRQ>=TO_DATE('{0}','YYYY-MM-DD')", lstLRRQ1.Text);
strSearch += string.Format(" AND A.LRRQ <TO_DATE('{0}','YYYY-MM-DD') + 1", lstLRRQ2.Text);
if (!string.IsNullOrWhiteSpace(strSearch))
{
strSql += strSearch;
}
strSql += " ORDER BY B.NAME,A.BILLNO DESC";
highlightRows.Text = "";
GridList.DataSource = DbHelperOra.Query(strSql).Tables[0];
GridList.DataBind();
}
protected override void billSearch()
{
if (lstLRRQ1.SelectedDate == null || lstLRRQ2.SelectedDate == null)
{
Alert.Show("请输入条件【结算日期】！");
return;
}
string strSql = @"SELECT
CUSTID,SEQNO,DEPTID,F_GETDEPTNAME(DEPTID) DEPTIDNAME,SUPID,SUPNAME,FLAG,DECODE(FLAG,'Y','已审核','G','已付款','R','驳回','未结算') FLAGNAME,GATFUNDCORP,GATFUNDBANK,GATACCNTNO,LINKMAN,LINKTEL,
CWLINKMAN,CWLINKTEL,BEGRQ,ENDRQ,NVL(SYJE,0) SYJE,NVL(XSJE,0) XSJE,NVL(THJE,0) THJE,NVL(JSJE,0) JSJE,FPJE,FPHM,LRY,LRRQ,SPR,SPRQ,SHR,NVL(YJJJ,0) YJJJ,JSJE,WJJE,
SHRQ,MEMO,STR1,STR2,STR3,NUM1,NUM2,NUM3,UPTTIME
FROM DAT_JSD_DOC WHERE SEQNO IN (SELECT DISTINCT SEQNO FROM DAT_JSD_COM) ";
string strSearch = "";
if (lstBILLNO.Text.Length > 0)
{
strSearch += string.Format(" AND SEQNO = '{0}'", lstBILLNO.Text);
}
if (lstSUPID.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND SUPID='{0}'", lstSUPID.SelectedItem.Value);
}
strSearch += string.Format(" AND ((BEGRQ BETWEEN TO_DATE('{0}','YYYY-MM-DD') AND (TO_DATE('{1}','YYYY-MM-DD')) + 1) OR (ENDRQ BETWEEN TO_DATE('{0}','YYYY-MM-DD') AND (TO_DATE('{1}','YYYY-MM-DD') + 1)))", lstLRRQ1.Text, lstLRRQ2.Text);
if (!string.IsNullOrWhiteSpace(strSearch))
{
strSql += strSearch;
}
strSql += " ORDER BY DEPTID,ENDRQ DESC";
DataTable dtBill = new DataTable();
dtBill = DbHelperOra.Query(strSql).Tables[0];
GridList.DataSource = dtBill;
GridList.DataBind();
//计算合计数量
decimal ddslTotal = 0, bzslTotal = 0, feTotal = 0, feeTotal = 0;
foreach (DataRow row in dtBill.Rows)
{
ddslTotal += Convert.ToDecimal(row["SYJE"]);
bzslTotal += Convert.ToDecimal(row["XSJE"]);
feeTotal += Convert.ToDecimal(row["THJE"]);
feTotal += Convert.ToDecimal(row["YJJJ"]);
}
JObject summary = new JObject();
summary.Add("FLAGNAME", "本页合计");
summary.Add("SYJE", ddslTotal.ToString("F2"));
summary.Add("XSJE", bzslTotal.ToString("F2"));
summary.Add("THJE", feeTotal.ToString("F2"));
summary.Add("YJJJ", feTotal.ToString("F2"));
GridList.SummaryData = summary;
}
private void bntSearch_Click()
{
if (lstLRRQ1.SelectedDate == null || lstLRRQ2.SelectedDate == null)
{
Alert.Show("请输入条件【录入日期】！");
return;
}
else if (lstLRRQ1.SelectedDate > lstLRRQ2.SelectedDate)
{
Alert.Show("开始日期大于结束日期，请重新输入！");
return;
}
string strSql = @"SELECT A.SEQNO,A.BILLNO,B.NAME FLAG,A.DDBH,F_GETDEPTNAME(A.DEPTID) DEPTID,A.SUPNAME,A.DHRQ,
A.SUBSUM,F_GETUSERNAME(A.CGY) CGY,F_GETUSERNAME(A.LRY) LRY,A.LRRQ,A.SHR,A.SHRQ,A.MEMO
from DAT_RK_DOC A,
SYS_CODEVALUE B
WHERE A.FLAG = B.CODE AND B.TYPE ='DIC_BILLSTATUS' ";
string strSearch = "";
if (lstBILLNO.Text.Length > 0)
{
strSearch += string.Format(" AND A.BILLNO LIKE '%{0}%'", lstBILLNO.Text);
}
if (lstFLAG.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.FLAG='{0}'", lstFLAG.SelectedItem.Value);
}
if (lstSLR.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.SLR='{0}'", lstSLR.SelectedItem.Value);
}
if (lstDEPTID.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND A.DEPTID='{0}'", lstDEPTID.SelectedItem.Value);
}
if (lstDEPTOUT.SelectedItem.Value.Length > 0)
{
strSearch += string.Format(" AND DEPTOUT='{0}'", lstDEPTOUT.SelectedItem.Value);
}
strSearch += string.Format(" AND A.LRRQ>=TO_DATE('{0}','YYYY-MM-DD')", lstLRRQ1.Text);
strSearch += string.Format(" AND A.LRRQ <TO_DATE('{0}','YYYY-MM-DD') + 1", lstLRRQ2.Text);
if (!string.IsNullOrWhiteSpace(strSearch))
{
strSql += strSearch;
}
GridList.DataSource = DbHelperOra.Query(strSql).Tables[0];
GridList.DataBind();
}
