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 = ""; } }