private void getActivityDetail(string ActivityCode)
{
DataView dv = btc.getActivityDetailFinished(ActivityCode);
if (dv.Count != 0)
{
txtActivityDetail.Text = dv[0]["ActivityDetail"].ToString();
lblPlace.Text = dv[0]["Place"].ToString();
lblType.Text = dv[0]["CostsType"].ToString();
lblTerm.Text = dv[0]["Term"].ToString() + "/" + dv[0]["YearB"].ToString();
lblBudgetYear.Text = dv[0]["BudgetYear"].ToString();
txtTotalAmount.Text = Convert.ToDecimal(dv[0]["TotalAmount"]).ToString("#,##0.00");
lblDepartment.Text = dv[0]["DeptName"].ToString();
lblEmpName.Text = dv[0]["EmpName"].ToString();
txtSDay.Text = Convert.ToDateTime(dv[0]["SDate"]).ToShortDateString();
txtEDay.Text = Convert.ToDateTime(dv[0]["EDate"]).ToShortDateString();
}
}
private void getActivityDetail(string ActivityCode)
{
DataView dv = btc.getActivityDetailFinished(ActivityCode);
if (dv.Count != 0)
{
txtActivityDetail.Text = dv[0]["ActivityDetail"].ToString();
lblPlace.Text = dv[0]["Place"].ToString();
lblType.Text = dv[0]["CostsType"].ToString();
lblTerm.Text = dv[0]["Term"].ToString() + "/" + dv[0]["YearB"].ToString();
lblBudgetYear.Text = dv[0]["BudgetYear"].ToString();
//txtTotalAmount.Text = Convert.ToDecimal(dv[0]["TotalAmount"]).ToString("#,##0.00");
string strSQL = " Select a.*, BudgetTypeName = Case a.BudgetTypeCode When '88f2efd0-b802-4528-8ca8-aae8d8352649' Then a.BudgetTypeOtherName Else b.BudgetTypeName End, a.ListName, IsNull(a.TotalMoney2,0) ValueT "
+ " From CostsDetail a, BudgetType b "
+ " Where a.BudgetTypeCode = b.BudgetTypeCode And a.ActivityCode = '{0}' ";
DataView dv1 = Conn.Select(string.Format(strSQL + " Order By a.ListNo, b.Sort ", ActivityCode));
GridViewBudget.DataSource = dv1;
GridViewBudget.DataBind();
//§º»ÃÐÁÒ³
DataTable dt2, dt3;
dt2 = new DataTable();
dt2 = dv1.ToTable(true, "BudgetTypeCode", "BudgetTypeName");
//dt2.Columns.Add("BudgetTypeName");
dt2.Columns.Add("TotalMoney");
foreach (DataRow dr in dt2.Rows)
{
dr["TotalMoney"] = dv1.ToTable().Compute("SUM(TotalMoney)", "BudgetTypeCode='" + dr["BudgetTypeCode"] + "'");
}
if (dt2.Rows.Count != 0)
{
for (int i = 0; i < dt2.Rows.Count; i++)
{
if (dt2.Rows[i]["BudgetTypeCode"].ToString() == "88f2efd0-b802-4528-8ca8-aae8d8352649")
{
dt2.Rows[i]["BudgetTypeName"] = "Í×è¹ æ";
}
}
}
dt3 = dt2.DefaultView.ToTable(true, "BudgetTypeCode", "BudgetTypeName", "TotalMoney");
dt3.Columns["BudgetTypeName"].ColumnName = "name";
dt3.Columns["TotalMoney"].ColumnName = "data";
dt3.AcceptChanges();
ReportGraph(dt3.DefaultView, 1);
DataTable dt1 = new DataTable();
dt1.Columns.Add("name");
dt1.Columns.Add("data");
DataRow dr1;
dr1 = dt1.NewRow();
dr1["name"] = "§º»ÃÐÁÒ³µÑé§äÇé";
dr1["data"] = Convert.ToDecimal(dv1.ToTable().Compute("Sum(TotalMoney)", ""));
dt1.Rows.Add(dr1);
dr1 = dt1.NewRow();
dr1["name"] = "§º»ÃÐÁÒ³·Õèãªé";
dr1["data"] = Convert.ToDecimal(dv1.ToTable().Compute("Sum(ValueT)", ""));
dt1.Rows.Add(dr1);
ReportGraph(dt1.DefaultView, 0);
cktxtBudget();
//txtOldTotal.Text = Convert.ToDouble(dv[0]["TotalAmount"]).ToString("#,##0");
Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "ckddlDate();", true);
lblDepartment.Text = dv[0]["DeptName"].ToString();
lblEmpName.Text = dv[0]["EmpName"].ToString();
txtSDay.Text = Convert.ToDateTime(dv[0]["SDate"]).ToString("dd/MM/yyyy");
txtEDay.Text = Convert.ToDateTime(dv[0]["EDate"]).ToString("dd/MM/yyyy");
txtSDay2.Text = Convert.ToDateTime(dv[0]["SDate2"]).ToString("dd/MM/yyyy");
txtEDay2.Text = Convert.ToDateTime(dv[0]["EDate2"]).ToString("dd/MM/yyyy");
}
else
{
txtActivityDetail.Text = "";
lblPlace.Text = "";
lblType.Text = "";
lblTerm.Text = "";
lblBudgetYear.Text = "";
//txtTotalAmount.Text = "0.00";
lblDepartment.Text = "";
lblEmpName.Text = "";
txtSDay.Text = "";
txtEDay.Text = "";
}
}
