public override void DataBind()
{
string StrSql = "Select a.ProjectsCode, a.ProjectsName, b.ActivityCode, b.ActivityName, b.SDate , b.EDate, '' As DeptName, b.Status, b.Df, IsNull(b.ApproveFlag, 0) ApproveFlag, "
+ " b.CostsType, IsNull(b.TotalAmount, 0) TotalAmount, IsNull((Cast(b.Term As nVarChar) + '/' + Cast(b.YearB As nVarChar)), '') Term, 0 As ConnectInd, 0 As ConnectEva "
+ " From Projects a, Activity b "
+ " Where a.ProjectsCode = b.ProjectsCode And b.DelFlag = 0 "
+ " And a.StudyYear = '" + ddlYearB.SelectedValue + "' And b.SchoolID = '" + CurrentUser.SchoolID + "' ";
DataView dv = Conn.Select(string.Format(StrSql + " Order By b.CreateDate Desc "));
for (int j = 0; j < dv.Count; j++)
{
dv[j]["DeptName"] = btc.getAcDeptName(dv[j]["ActivityCode"].ToString());
dv[j]["ConnectInd"] = btc.getAcIndicators2(dv[j]["ActivityCode"].ToString());
dv[j]["ConnectEva"] = btc.getAcEvaluation(dv[j]["ActivityCode"].ToString());
}
GridView1.DataSource = dv;
lblSearchTotal.InnerText = dv.Count.ToString();
GridView1.DataBind();
}
