/// <summary>
/// 专项资金
/// </summary>
public void Show_DDL_SpecialFundsID()
{
try
{
DataTable DT = new DataTable();
//modify by guanzhq on 2012-03-05 begin
// 添加判断 不显示不在预约中列出的数据
//string sql = " SELECT cast(ID as varchar(10))+'|'+cast(accountid as varchar(10))+'|'+cast(isnull(EveryDayNum,0) as varchar(20)) Code, NAMES FROM vCash_SpecialFunds WHERE (STATUS = 1) and AccountStatus=1";
string sql = " SELECT cast(ID as varchar(10))+'|'+cast(accountid as varchar(10))+'|'+cast(isnull(EveryDayNum,0) as varchar(20)) Code, NAMES FROM vCash_SpecialFunds WHERE (STATUS = 1) and AccountStatus=1 and IsListApply=1";
//modify by guanzhq on 2012-03-05 end
DT = pagecontrol.doSql(sql).Tables[0];
if (DT.Rows.Count > 0)
{
DDL_SpecialFundsID.DataSource = DT;
DDL_SpecialFundsID.DataTextField = "NAMES";
DDL_SpecialFundsID.DataValueField = "Code";
DDL_SpecialFundsID.DataBind();
}
else
{
ListItem li = new ListItem("-暂无可选专项资金-", "0");
DDL_SpecialFundsID.Items.Add(li);
}
}
catch { }
}
/// <summary>
/// 显示专项资金列表
/// </summary>
protected void ShowSpecialFunds()
{
try
{
DataTable DT = new DataTable();
string sql = " SELECT ID, NAMES FROM Cash_SpecialFunds WHERE (STATUS = 1) AND (Delflag = 0) ";
//string sql = " SELECT ID, NAMES + '[' + CONVERT(varchar(20), Balance) + ',' + CONVERT(varchar(20),TotalNum) + ']' AS NAMES FROM Cash_SpecialFunds WHERE (STATUS = 1) AND (Delflag = 0) ";
DT = pageControl.doSql(sql).Tables[0];
if (DT.Rows.Count > 0)
{
DDL_SpecialFundsID.DataSource = DT;
DDL_SpecialFundsID.DataTextField = "NAMES";
DDL_SpecialFundsID.DataValueField = "ID";
DDL_SpecialFundsID.DataBind();
}
else
{
ListItem li = new ListItem("-暂无可选专项资金-", "");
DDL_SpecialFundsID.Items.Add(li);
}
}
catch
{ }
}
