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