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