public override void DataBind()
{
string StrSql = @" Select a.ActivityDetailCode, a.ActivityDetail, a.TDay, a.ActivityCode, a.Sort, b.TotalAmount As OTotalAmount, IsNull(a.Confirm, 0) Confirm,
IsNull(Sum(d.TotalMoney), 0) NAmount, IsNull(b.ActivityStatus, 0) As ActivityStatus, IsNull(a.ActivityStatus, 0) As ActivityDetailStatus
From ActivityDetail a Left Join Activity b On a.ActivityCode = b.ActivityCode
Left Join Projects c On b.ProjectsCode = c.ProjectsCode
Left Join ActivityCostsDetail d On a.ActivityDetailCode = d.ActivityDetailCode
Where a.DelFlag = 0 And b.DelFlag = 0 And c.DelFlag = 0 And a.ActivityCode = '" + Request["acid"] + "'";
if (txtSearch.Text != "")
{
StrSql = StrSql + " And a.ActivityDetail Like '%" + txtSearch.Text + "%' ";
}
DataView dv = Conn.Select(string.Format(StrSql + " Group By a.ActivityDetailCode, a.ActivityDetail, a.TDay, a.ActivityCode, a.Sort, b.TotalAmount, a.ActivityStatus, b.ActivityStatus, a.Confirm Order By a.Sort Desc"));
decimal NTotalAmount = 0;
if (dv.Count != 0)
{
for (int i = 0; i < dv.Count; i++)
{
NTotalAmount += Convert.ToDecimal(dv[i]["NAMount"]);
}
lblNBudget.Text = NTotalAmount.ToString("#,##0.00");
lblActivityStatus.Text = btc.getSpanColorStatus(Convert.ToBoolean(Cookie.GetValue2("ckActivityStatus")), dv[0]["ActivityStatus"].ToString());
SumBalance();
}
GridView1.DataSource = dv;
lblSearchTotal.InnerText = dv.Count.ToString();
GridView1.DataBind();
}
protected string getActivityStatus(string ActivityStatus)
{
return(btc.getSpanColorStatus(Convert.ToBoolean(Cookie.GetValue2("ckActivityStatus")), ActivityStatus));
}
