private void getBudgetEdit(string ActivityDetailCode) { TotalOldAmount = 0; ttlMoney = 0; //string strSQL = @" Select ItemID From ActivityCostsDetail Where ActivityDetailCode = '{0}' "; //DataView ckDv = Conn.Select(string.Format(strSQL, ActivityDetailCode)); //if (ckDv.Count != 0) //{ // if (string.IsNullOrEmpty(ckDv[0]["ItemID"].ToString())) // { // hdfckItemID.Value = " And a.ListName = e.EntryCostsCode "; // } // else // { // hdfckItemID.Value = " And a.ItemID = e.ItemID "; // } //} string strSQL = @" Select a.ActivityCode, a.ListName, a.ListName As EntryCostsCode, a.BudgetTypeCode, IsNull(d.Sort, 0) As AcDSort, a.TotalP, a.TotalD, IsNull(e.Cost, 0) AS TotalG, a.TotalMoney, a.TotalMoney2, BudgetTypeName = Case a.BudgetTypeCode When '88f2efd0-b802-4528-8ca8-aae8d8352649' Then a.BudgetTypeOtherName Else b.BudgetTypeName End, a.ListName As EntryCostsName, IsNull(e.TotalMoney,0) ValueT, IsNull(e.TotalDD, 0) TotalDD, '' TotalMoney2Ag, 0.0 As OldTotalAmount, a.ItemID From CostsDetail a, BudgetType b, ActivityDetail d, ActivityCostsDetail e Where a.BudgetTypeCode = b.BudgetTypeCode And a.ActivityCode = d.ActivityCode And d.ActivityDetailCode = e.ActivityDetailCode And a.ItemID = e.ItemID And e.ActivityDetailCode = '{0}' "; DataView dv1 = Conn.Select(string.Format(strSQL + " Order By a.ListNo, b.Sort ", ActivityDetailCode)); if (dv1.Count != 0) { for (int j = 0; j < dv1.Count; j++) { dv1[j]["TotalMoney2Ag"] = Convert.ToDecimal(dv1[j]["ValueT"]).ToString("#,##0"); strSQL = @" Select a.ActivityCode, a.ListName As EntryCostsCode, a.BudgetTypeCode, a.BudgetTypeOtherName, a.TotalP, a.TotalD, IsNull(e.Cost, 0) AS TotalG, a.TotalMoney, a.TotalMoney2, BudgetTypeName = Case a.BudgetTypeCode When '88f2efd0-b802-4528-8ca8-aae8d8352649' Then a.BudgetTypeOtherName Else b.BudgetTypeName End, a.ListName As EntryCostsName, IsNull(Sum(e.TotalMoney),0) ValueT, '' As TotalMoney2Ag, b.Sort From CostsDetail a, BudgetType b, ActivityDetail d, ActivityCostsDetail e Where a.BudgetTypeCode = b.BudgetTypeCode And a.ActivityCode = d.ActivityCode And d.ActivityDetailCode = e.ActivityDetailCode And a.ItemID = e.ItemID And a.ActivityCode = '{0}' And a.ItemID = '{1}' And d.Sort < {2} Group By a.ActivityCode, a.EntryCostsCode, a.BudgetTypeCode, a.BudgetTypeOtherName, a.TotalP, a.TotalD, e.Cost, a.TotalMoney, a.TotalMoney2, a.BudgetTypeCode, BudgetTypeName, a.ListName, b.Sort "; DataView dv9 = Conn.Select(string.Format(strSQL + " Order By b.Sort ", dv1[0]["ActivityCode"].ToString(), dv1[j]["ItemID"].ToString(), Convert.ToInt32(dv1[j]["AcDSort"]))); if (dv9.Count != 0) { dv1[j]["OldTotalAmount"] = Convert.ToDecimal(dv9[0]["ValueT"]); } } } GridViewBudget.DataSource = dv1; GridViewBudget.DataBind(); if (dv1.Count != 0) { Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "SumTotal();", true); } }
public override void DataBind() { ServiceReference1.SESserviceSoapClient SesSevice = new ServiceReference1.SESserviceSoapClient(); DataSet ds = SesSevice.getDvActivityCostsDetail(ddlActivityDetail.SelectedValue); DataView dv = ds.Tables[0].DefaultView; GridViewBudget.DataSource = dv; GridViewBudget.DataBind(); }
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 = ""; } }
private void GetData(string id) { if (String.IsNullOrEmpty(id)) { return; } string strSQL = " Select StrategiesCode, ProjectsCode, ActivityCode, DeptCode, CostsType, TotalAmount, StudyYear, BudgetYear, Term, YearB, SDate, EDate, CostsType2, SDate2, EDate2, IsNull(ckTime, 0) ckTime, FactorRateID, Results " + " From Activity " + " Where ActivityCode = '" + id + "' "; DataView dv = Conn.Select(string.Format(strSQL)); if (dv.Table.Rows.Count != 0) { getlblTarget(); ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString(); getddlFactorRate(ddlYearB.SelectedValue); getcblFactor(ddlYearB.SelectedValue); getddlStrategies(1, ddlYearB.SelectedValue); ddlStrategies.SelectedValue = dv[0]["StrategiesCode"].ToString(); getddlProjects(1, ddlYearB.SelectedValue, ddlStrategies.SelectedValue); ddlProjects.SelectedValue = dv[0]["ProjectsCode"].ToString(); getddlActivity(1, ddlProjects.SelectedValue); ddlActivity.SelectedValue = dv[0]["ActivityCode"].ToString(); getActivityDetail(ddlActivity.SelectedValue); txtSDay.Text = Convert.ToDateTime(dv[0]["SDate"]).ToString("dd/MM/yyyy"); txtEDay.Text = Convert.ToDateTime(dv[0]["EDate"]).ToString("dd/MM/yyyy"); txtSDay2.Text = (string.IsNullOrEmpty(dv[0]["SDate2"].ToString())) ? Convert.ToDateTime(dv[0]["SDate"]).ToString("dd/MM/yyyy") : Convert.ToDateTime(dv[0]["SDate2"]).ToString("dd/MM/yyyy"); txtEDay2.Text = (string.IsNullOrEmpty(dv[0]["EDate2"].ToString())) ? Convert.ToDateTime(dv[0]["EDate"]).ToString("dd/MM/yyyy") : Convert.ToDateTime(dv[0]["EDate2"]).ToString("dd/MM/yyyy"); ddlSDay.SelectedValue = (string.IsNullOrEmpty(dv[0]["SDate2"].ToString())) ? Convert.ToDateTime(dv[0]["SDate"]).Day.ToString("00") : Convert.ToDateTime(dv[0]["SDate2"]).Day.ToString("00"); ddlSMonth.SelectedValue = (string.IsNullOrEmpty(dv[0]["SDate2"].ToString())) ? Convert.ToDateTime(dv[0]["SDate"]).Month.ToString("00") : Convert.ToDateTime(dv[0]["SDate2"]).Month.ToString("00"); ddlSYear.SelectedValue = (string.IsNullOrEmpty(dv[0]["SDate2"].ToString())) ? (Convert.ToDateTime(dv[0]["SDate"]).Year + 543).ToString() : (Convert.ToDateTime(dv[0]["SDate2"]).Year + 543).ToString(); ddlEDay.SelectedValue = (string.IsNullOrEmpty(dv[0]["EDate2"].ToString())) ? Convert.ToDateTime(dv[0]["EDate"]).Day.ToString("00") : Convert.ToDateTime(dv[0]["EDate2"]).Day.ToString("00"); ddlEMonth.SelectedValue = (string.IsNullOrEmpty(dv[0]["EDate2"].ToString())) ? Convert.ToDateTime(dv[0]["EDate"]).Month.ToString("00") : Convert.ToDateTime(dv[0]["EDate2"]).Month.ToString("00"); ddlEYear.SelectedValue = (string.IsNullOrEmpty(dv[0]["EDate2"].ToString())) ? (Convert.ToDateTime(dv[0]["EDate"]).Year + 543).ToString() : (Convert.ToDateTime(dv[0]["EDate2"]).Year + 543).ToString(); ddlStrategies.Enabled = false; ddlProjects.Enabled = false; ddlActivity.Enabled = false; strSQL = "Select * From ActivityDetail Where ActivityCode = '" + id + "' And DelFlag = 0"; DataView dvCkDt = Conn.Select(strSQL); strSQL = "Select IsNull(TotalAmount2,0) TotalAmount2 From Activity Where ActivityCode = '" + id + "'"; DataView dvckTl = Conn.Select(strSQL); DataView dv1; if ((dvCkDt.Count == 0) || (Convert.ToDecimal(dvckTl[0]["TotalAmount2"]) != 0)) { strSQL = " Select a.ActivityCode, a.ListName, a.ListName As EntryCostsCode, a.BudgetTypeCode, " + " a.TotalP, a.TotalD, a.TotalG, a.TotalMoney, a.TotalMoney2, a.ItemID, " + " BudgetTypeName = Case a.BudgetTypeCode When '88f2efd0-b802-4528-8ca8-aae8d8352649' Then a.BudgetTypeOtherName Else b.BudgetTypeName End, " + " a.ListName As EntryCostsName, ValueT = Case IsNull(a.TotalMoney2,0) When 0 Then 0 Else a.TotalMoney2 End, '' As TotalMoney2Ag " + " From CostsDetail a, BudgetType b " + " Where a.BudgetTypeCode = b.BudgetTypeCode And a.ActivityCode = '{0}' "; dv1 = Conn.Select(string.Format(strSQL + " Order By a.ListNo, b.Sort ", id)); } else { strSQL = " Select a.ActivityCode, a.ListName, a.ListName As EntryCostsCode, a.BudgetTypeCode, a.BudgetTypeOtherName, a.TotalP, a.TotalD, a.TotalG, " + " a.TotalMoney, a.TotalMoney2, BudgetTypeName = Case a.BudgetTypeCode When '88f2efd0-b802-4528-8ca8-aae8d8352649' Then a.BudgetTypeOtherName Else b.BudgetTypeName End, " + " a.ListName As EntryCostsName, IsNull(Sum(e.TotalMoney),0) ValueT, '' As TotalMoney2Ag, b.Sort, a.ListNo, a.ItemID, e.ItemID As ItemID2 " + " From CostsDetail a, BudgetType b, ActivityDetail d, ActivityCostsDetail e " + " Where a.BudgetTypeCode = b.BudgetTypeCode And a.ActivityCode = d.ActivityCode " + " And d.ActivityDetailCode = e.ActivityDetailCode And a.ItemID = e.ItemID " + " And a.ActivityCode = '{0}' " + " Group By a.ActivityCode, a.BudgetTypeCode, a.BudgetTypeOtherName, " + " a.TotalP, a.TotalD, a.TotalG, a.TotalMoney, a.TotalMoney2, BudgetTypeName, a.ListName, b.Sort, a.ListNo, a.ItemID, e.ItemID "; dv1 = Conn.Select(string.Format(strSQL + " Order By a.ListNo, b.Sort ", id)); } if (dv1.Count != 0) { for (int j = 0; j < dv1.Count; j++) { dv1[j]["TotalMoney2Ag"] = Convert.ToDecimal(dv1[j]["ValueT"]).ToString("#,##0.00"); //dv1[j]["TotalMoney2Ag"] = 0; } } GridViewBudget.DataSource = dv1; GridViewBudget.DataBind(); //¤ÇÒÁÊÓàÃ稢ͧ¡Ô¨¡ÃÃÁ ddlFactorRate.SelectedValue = dv[0]["FactorRateID"].ToString(); DataView dv2 = Conn.Select(string.Format("Select FactorCode From dtFactor Where ActivityCode = '" + id + "' ")); if (dv2.Count != 0) { for (int i = 0; i <= cblFactor.Items.Count - 1; i++) { for (int j = 0; j <= dv2.Count - 1; j++) { if (cblFactor.Items[i].Value == dv2[j]["FactorCode"].ToString()) { cblFactor.Items[i].Selected = true; break; } } } } txtResults.Text = dv[0]["Results"].ToString(); //txtOldTotal.Text = Convert.ToDouble(dv[0]["TotalAmount"]).ToString("#,##0"); Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "SumTotal(); ckddlDate(1); ckddlDate(2);", true); } }