private void GetData(string id)
{
if (String.IsNullOrEmpty(id))
{
return;
}
string strSql = @" Select a.ProjectsCode, a.StudyYear, S.StrategiesCode, b.ActivityCode, c.IndicatorsName2,
c.Weight, c.WeightType, c.RateType, c.OffAll, c.OffThat, c.APercent, c.CkCriterion, c.Sort, c.EvaAssessment, c.EvaTool
From Projects a Left Join dtStrategies S On a.ProjectsCode = S.ProjectsCode
Inner Join Activity b On a.ProjectsCode = b.ProjectsCode
Inner Join Indicators2 c On b.ActivityCode = c.ActivityCode
Where c.Indicators2Code = '{0}' ";
DataView dv = Conn.Select(string.Format(strSql, id));
if (dv.Count != 0)
{
ddlYearB.SelectedValue = dv[0]["StudyYear"].ToString();
//getddlStrategies(1, ddlYearB.SelectedValue);
//ddlStrategies.SelectedValue = dv[0]["StrategiesCode"].ToString();
getddlProjects(1, ddlYearB.SelectedValue, "");
ddlProjects.SelectedValue = dv[0]["ProjectsCode"].ToString();
getddlActivity(1, ddlProjects.SelectedValue);
ddlActivity.SelectedValue = dv[0]["ActivityCode"].ToString();
getActivityDetail(ddlActivity.SelectedValue);
if (btc.CkUseData(id, "Indicators2Code", "Evaluation", " And DelFlag = 0 "))
{
ddlYearB.Enabled = false;
//ddlStrategies.Enabled = false;
ddlProjects.Enabled = false;
ddlActivity.Enabled = false;
}
txtIndicators2.Text = dv[0]["IndicatorsName2"].ToString();
txtEvaAssessment.Text = dv[0]["EvaAssessment"].ToString();
txtEvaTool.Text = dv[0]["EvaTool"].ToString();
if (Convert.ToInt32(dv[0]["WeightType"].ToString()) == 0)
{
txtWeight.Text = ((Convert.ToDecimal(dv[0]["OffAll"].ToString()) * 50) / 100).ToString("#,##0");
}
else
{
txtWeight.Text = string.IsNullOrEmpty(dv[0]["Weight"].ToString()) ? "0" : Convert.ToInt32(dv[0]["Weight"]).ToString("#,##0");
}
ddlRateType.SelectedValue = dv[0]["RateType"].ToString();
txtAll.Text = string.IsNullOrEmpty(dv[0]["OffAll"].ToString()) ? "0" : Convert.ToInt32(dv[0]["OffAll"]).ToString("#,##0");
txtSort.Text = dv[0]["Sort"].ToString();
btc.getCreateUpdateUser(lblCreate, lblUpdate, "Indicators2", "Indicators2Code", id);
Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "ckRateType(1); Calculate(0);", true);
}
}
private void Delete(string id)
{
if (String.IsNullOrEmpty(id))
{
return;
}
if (btc.CkUseData(id, "ScoreGroupID", "Indicators", "") || btc.CkUseData(id, "ScoreGroupID", "Standard", "") || btc.CkUseData(id, "ScoreGroupID", "Side", ""))
{
Response.Redirect("ScoreGroup.aspx?ckmode=3&Cr=0");
}
else
{
Int32 i = Conn.Update("ScoreGroup", "Where ScoreGroupID = '" + id + "' ", "DelFlag, UpdateUser, UpdateDate", 1, CurrentUser.ID, DateTime.Now);
Response.Redirect("ScoreGroup.aspx?ckmode=3&Cr=" + i);
}
}
private void Delete(string id)
{
if (String.IsNullOrEmpty(id))
{
return;
}
if (btc.CkUseData(id, "IndicatorsCode", "Evaluation", "And DelFlag = 0"))
{
Response.Redirect("Indicators.aspx?ckmode=3&Cr=0");
}
else
{
Int32 i = Conn.Update("Indicators", "Where IndicatorsCode = '" + id + "' ", "DelFlag, UpdateUser, UpdateDate", 1, CurrentUser.ID, DateTime.Now);
Response.Redirect("Indicators.aspx?ckmode=3&Cr=" + i);
}
}
private void Delete(string id)
{
if (String.IsNullOrEmpty(id))
{
return;
}
if (btc.CkUseData(id, "StandardCode", "dtNewStandard", ""))
{
Response.Redirect("NewStandard.aspx?ckmode=3&Cr=0");
}
else
{
Int32 i = Conn.Update("NewStandard", "Where StandardCode = '" + id + "' ", "DelFlag, UpdateUser, UpdateDate", 1, CurrentUser.ID, DateTime.Now);
Response.Redirect("NewStandard.aspx?ckmode=3&Cr=" + i);
}
}
private void Delete(string id)
{
if (String.IsNullOrEmpty(id))
{
return;
}
if (btc.CkUseData(id, "MainActivityID", "Activity", ""))
{
Response.Redirect("MainActivity.aspx?ckmode=3&Cr=0");
}
else
{
Int32 i = Conn.Update("MainActivity", "Where MainActivityID = '" + id + "' ", "DelFlag, UpdateUser, UpdateDate", 1, CurrentUser.ID, DateTime.Now);
Response.Redirect("MainActivity.aspx?ckmode=3&Cr=" + i);
}
}
private void Delete(string id)
{
if (String.IsNullOrEmpty(id))
{
return;
}
if (btc.CkUseData(id, "SubProjectTypeID", "Projects", "And DelFlag = 0"))
{
Response.Redirect("SubProjectType.aspx?ckmode=3&Cr=0");
}
else
{
Int32 i = Conn.Update("SubProjectType", "Where SubProjectTypeID = '" + id + "' ", "DelFlag, UpdateUser, UpdateDate", 1, CurrentUser.ID, DateTime.Now);
Response.Redirect("SubProjectType.aspx?ckmode=3&Cr=" + i);
}
}
private void Delete(string id)
{
if (String.IsNullOrEmpty(id))
{
return;
}
if (btc.CkUseData(id, "FourthAssessmentIndicatorID", "dtFourthAssessment", ""))
{
Response.Redirect("FourthAssessmentIndicator.aspx?ckmode=3&Cr=0");
}
else
{
Int32 i = Conn.Update("FourthAssessmentIndicator", "Where FourthAssessmentIndicatorID = '" + id + "' ", "DelFlag, UpdateUser, UpdateDate", 1, CurrentUser.ID, DateTime.Now);
Response.Redirect("FourthAssessmentIndicator.aspx?ckmode=3&Cr=" + i);
}
}
private void Delete(string id)
{
Int32 i = 0;
if (String.IsNullOrEmpty(id))
{
return;
}
if (btc.CkUseData(id, "StudyYear", "Strategies", "And DelFlag = 0"))
{
Response.Redirect("StudyYear.aspx?ckmode=3&Cr=0");
}
else
{
i = Conn.Delete("StudyYear", "Where StudyYear = '" + id + "'");
Response.Redirect("StudyYear.aspx?ckmode=3&Cr=" + i);
}
}
protected void btSave_Click(object sender, EventArgs e)
{
StringBuilder strbSql = new StringBuilder();
Int32 i = 0;
if ((btc.CkUseData(ddlYearB.SelectedValue, "StudyYear", "Income", "And DelFlag = 0 And DeptCode = '" + CurrentUser.DeptID + "'")) && Request.QueryString["mode"] != "2")
{
btc.Msg_Head(Img1, MsgHead, true, "7", 0);
Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "SumTotal();", true);
return;
}
if (String.IsNullOrEmpty(Request.QueryString["mode"]) || Request.QueryString["mode"] == "1")
{
string NewID = Guid.NewGuid().ToString();
strbSql.AppendFormat("INSERT INTO Income (IncomeCode, StudyYear, Ma, Subsidies, MaRevenue, Revenue, MaFree, Free, MaReserve, Reserve, MaOther, Other, DelFlag, CreateUser, CreateDate, UpdateUser, UpdateDate, DeptCode) VALUES ('{0}',{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},'{13}','{14}','{15}','{16}','{17}');",
NewID, ddlYearB.SelectedValue, Convert.ToDecimal(txtMa.Text), Convert.ToDecimal(txtMa.Text) + Convert.ToDecimal(txtSubsidies.Text), Convert.ToDecimal(txtMaRevenue.Text), Convert.ToDecimal(txtMaRevenue.Text) + Convert.ToDecimal(txtRevenue.Text), Convert.ToDecimal(txtMaFree.Text), Convert.ToDecimal(txtMaFree.Text) + Convert.ToDecimal(txtFree.Text), Convert.ToDecimal(txtMaReserve.Text), Convert.ToDecimal(txtMaReserve.Text) + Convert.ToDecimal(txtReserve.Text), Convert.ToDecimal(txtMaOther.Text), Convert.ToDecimal(txtMaOther.Text) + Convert.ToDecimal(txtOther.Text), 0, CurrentUser.ID, DateTime.Now.ToString("yyyy-MM-dd", new CultureInfo("en-gb")) + " 00:00:00.000", CurrentUser.ID, DateTime.Now.ToString("yyyy-MM-dd", new CultureInfo("en-gb")) + " 00:00:00.000", CurrentUser.DeptID);
strbSql.AppendFormat("INSERT INTO IncomeDetail (IncomeCode, StudyYear, P1No, P1Value, P2No, P2Value, P3No, P3Value, M1No, M1Value, M2No, M2Value, M3No, M3Value, ClassP1, ClassP2, ClassP3, ClassM1, ClassM2, ClassM3) VALUES ('{0}',{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16},{17},{18},{19});",
NewID, ddlYearB.SelectedValue, Convert.ToDecimal(txtP1.Value), Convert.ToDecimal(txtPb1.Value), Convert.ToDecimal(txtP2.Value), Convert.ToDecimal(txtPb2.Value), Convert.ToDecimal(txtP3.Value), Convert.ToDecimal(txtPb3.Value), Convert.ToDecimal(txtM1.Value), Convert.ToDecimal(txtMb1.Value), Convert.ToDecimal(txtM2.Value), Convert.ToDecimal(txtMb2.Value), Convert.ToDecimal(txtM3.Value), Convert.ToDecimal(txtMb3.Value), Convert.ToDecimal(txtClassP1.Value), Convert.ToDecimal(txtClassP2.Value), Convert.ToDecimal(txtClassP3.Value), Convert.ToDecimal(txtClassM1.Value), Convert.ToDecimal(txtClassM2.Value), Convert.ToDecimal(txtClassM3.Value));
//i = Conn.AddNew("Income", "IncomeCode, StudyYear, Ma, Subsidies, MaRevenue, Revenue, MaFree, Free, MaReserve, Reserve, MaOther, Other, DelFlag, CreateUser, CreateDate, UpdateUser, UpdateDate, DeptCode",
// NewID, ddlYearB.SelectedValue, Convert.ToDecimal(txtMa.Text), Convert.ToDecimal(txtMa.Text) + Convert.ToDecimal(txtSubsidies.Text), Convert.ToDecimal(txtMaRevenue.Text), Convert.ToDecimal(txtMaRevenue.Text) + Convert.ToDecimal(txtRevenue.Text), Convert.ToDecimal(txtMaFree.Text), Convert.ToDecimal(txtMaFree.Text) + Convert.ToDecimal(txtFree.Text), Convert.ToDecimal(txtMaReserve.Text), Convert.ToDecimal(txtMaReserve.Text) + Convert.ToDecimal(txtReserve.Text), Convert.ToDecimal(txtMaOther.Text), Convert.ToDecimal(txtMaOther.Text) + Convert.ToDecimal(txtOther.Text), 0, CurrentUser.ID, DateTime.Now, CurrentUser.ID, DateTime.Now, CurrentUser.DeptID);
//Conn.AddNew("IncomeDetail", "IncomeCode, StudyYear, P1No, P1Value, P2No, P2Value, P3No, P3Value, M1No, M1Value, M2No, M2Value, M3No, M3Value, ClassP1, ClassP2, ClassP3, ClassM1, ClassM2, ClassM3",
// NewID, ddlYearB.SelectedValue, Convert.ToDecimal(txtP1.Value), Convert.ToDecimal(txtPb1.Value), Convert.ToDecimal(txtP2.Value), Convert.ToDecimal(txtPb2.Value), Convert.ToDecimal(txtP3.Value), Convert.ToDecimal(txtPb3.Value), Convert.ToDecimal(txtM1.Value), Convert.ToDecimal(txtMb1.Value), Convert.ToDecimal(txtM2.Value), Convert.ToDecimal(txtMb2.Value), Convert.ToDecimal(txtM3.Value), Convert.ToDecimal(txtMb3.Value), Convert.ToDecimal(txtClassP1.Value), Convert.ToDecimal(txtClassP2.Value), Convert.ToDecimal(txtClassP3.Value), Convert.ToDecimal(txtClassM1.Value), Convert.ToDecimal(txtClassM2.Value), Convert.ToDecimal(txtClassM3.Value));
i = Conn.Execute(strbSql.ToString());
Response.Redirect("Income.aspx?ckmode=1&Cr=" + i);
}
if (Request.QueryString["mode"] == "2")
{
strbSql.AppendFormat("UPDATE Income Set Ma = {1}, Subsidies = {2}, MaRevenue = {3}, Revenue = {4}, MaFree = {5}, Free = {6}, MaReserve = {7}, Reserve = {8}, MaOther = {9}, Other = {10}, UpdateUser = '******', UpdateDate = '{12}' Where IncomeCode = '{0}';",
Request.QueryString["id"], Convert.ToDecimal(txtMa.Text), Convert.ToDecimal(txtMa.Text) + Convert.ToDecimal(txtSubsidies.Text), Convert.ToDecimal(txtMaRevenue.Text), Convert.ToDecimal(txtMaRevenue.Text) + Convert.ToDecimal(txtRevenue.Text), Convert.ToDecimal(txtMaFree.Text), Convert.ToDecimal(txtMaFree.Text) + Convert.ToDecimal(txtFree.Text), Convert.ToDecimal(txtMaReserve.Text), Convert.ToDecimal(txtMaReserve.Text) + Convert.ToDecimal(txtReserve.Text), Convert.ToDecimal(txtMaOther.Text), Convert.ToDecimal(txtMaOther.Text) + Convert.ToDecimal(txtOther.Text), CurrentUser.ID, DateTime.Now.ToString("yyyy-MM-dd", new CultureInfo("en-gb")) + " 00:00:00.000");
strbSql.AppendFormat("UPDATE IncomeDetail Set P1No = {1}, P1Value = {2}, P2No = {3}, P2Value = {4}, P3No = {5}, P3Value = {6}, M1No = {7}, M1Value = {8}, M2No = {9}, M2Value = {10}, M3No = {11}, M3Value = {12}, ClassP1 = {13}, ClassP2 = {14}, ClassP3 = {15}, ClassM1 = {16}, ClassM2 = {17}, ClassM3 = {18} Where IncomeCode = '{0}';",
Request.QueryString["id"], Convert.ToDecimal(txtP1.Value), Convert.ToDecimal(txtPb1.Value), Convert.ToDecimal(txtP2.Value), Convert.ToDecimal(txtPb2.Value), Convert.ToDecimal(txtP3.Value), Convert.ToDecimal(txtPb3.Value), Convert.ToDecimal(txtM1.Value), Convert.ToDecimal(txtMb1.Value), Convert.ToDecimal(txtM2.Value), Convert.ToDecimal(txtMb2.Value), Convert.ToDecimal(txtM3.Value), Convert.ToDecimal(txtMb3.Value), Convert.ToDecimal(txtClassP1.Value), Convert.ToDecimal(txtClassP2.Value), Convert.ToDecimal(txtClassP3.Value), Convert.ToDecimal(txtClassM1.Value), Convert.ToDecimal(txtClassM2.Value), Convert.ToDecimal(txtClassM3.Value));
//i = Conn.Update("Income", "Where IncomeCode = '" + Request.QueryString["id"] + "' ", "Ma, Subsidies, MaRevenue, Revenue, MaFree, Free, MaReserve, Reserve, MaOther, Other, UpdateUser, UpdateDate",
// Convert.ToDecimal(txtMa.Text), Convert.ToDecimal(txtMa.Text) + Convert.ToDecimal(txtSubsidies.Text), Convert.ToDecimal(txtMaRevenue.Text), Convert.ToDecimal(txtMaRevenue.Text) + Convert.ToDecimal(txtRevenue.Text), Convert.ToDecimal(txtMaFree.Text), Convert.ToDecimal(txtMaFree.Text) + Convert.ToDecimal(txtFree.Text), Convert.ToDecimal(txtMaReserve.Text), Convert.ToDecimal(txtMaReserve.Text) + Convert.ToDecimal(txtReserve.Text), Convert.ToDecimal(txtMaOther.Text), Convert.ToDecimal(txtMaOther.Text) + Convert.ToDecimal(txtOther.Text), CurrentUser.ID, DateTime.Now);
//Conn.Update("IncomeDetail", "Where IncomeCode = '" + Request.QueryString["id"] + "' ", "P1No, P1Value, P2No, P2Value, P3No, P3Value, M1No, M1Value, M2No, M2Value, M3No, M3Value, ClassP1, ClassP2, ClassP3, ClassM1, ClassM2, ClassM3",
// Convert.ToDecimal(txtP1.Value), Convert.ToDecimal(txtPb1.Value), Convert.ToDecimal(txtP2.Value), Convert.ToDecimal(txtPb2.Value), Convert.ToDecimal(txtP3.Value), Convert.ToDecimal(txtPb3.Value), Convert.ToDecimal(txtM1.Value), Convert.ToDecimal(txtMb1.Value), Convert.ToDecimal(txtM2.Value), Convert.ToDecimal(txtMb2.Value), Convert.ToDecimal(txtM3.Value), Convert.ToDecimal(txtMb3.Value), Convert.ToDecimal(txtClassP1.Value), Convert.ToDecimal(txtClassP2.Value), Convert.ToDecimal(txtClassP3.Value), Convert.ToDecimal(txtClassM1.Value), Convert.ToDecimal(txtClassM2.Value), Convert.ToDecimal(txtClassM3.Value));
i = Conn.Execute(strbSql.ToString());
Response.Redirect("Income.aspx?ckmode=2&Cr=" + i);
}
}
private void Delete(string id)
{
Int32 i = 0;
if (String.IsNullOrEmpty(id))
{
return;
}
if (btc.CkUseData(id, "StrategiesCode", "Projects", "And DelFlag = 0"))
{
Response.Redirect("Strategies.aspx?ckmode=3&Cr=0");
}
else
{
i = Conn.Update("Strategies", "Where StrategiesCode = '" + id + "' ", "DelFlag, UpdateUser, UpdateDate", 1, CurrentUser.ID, DateTime.Now);
Conn.Delete("StrategiesIndicators", "Where StrategiesCode = '" + Request.QueryString["id"] + "'");
Response.Redirect("Strategies.aspx?ckmode=3&Cr=" + i);
}
}
protected void btSave_Click(object sender, EventArgs e)
{
Int32 i = 0;
if ((btc.CkUseData(ddlYearB.SelectedValue, "StudyYear", "Expenses", "And DelFlag = 0")) && Request["mode"] != "2")
{
btc.Msg_Head(Img1, MsgHead, true, "7", 0);
Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "SumTotal();", true);
return;
}
if (String.IsNullOrEmpty(Request["mode"]) || Request["mode"] == "1")
{
string NewID = Guid.NewGuid().ToString();
i = Conn.AddNew("Expenses", "ExpensesCode, StudyYear, Subsidies, Revenue, Free, Other, DelFlag, CreateUser, CreateDate, UpdateUser, UpdateDate", NewID, ddlYearB.SelectedValue, Convert.ToDecimal(txtSubsidies.Text), Convert.ToDecimal(txtRevenue.Text), Convert.ToDecimal(txtFree.Text), Convert.ToDecimal(txtOther.Text), 0, CurrentUser.ID, DateTime.Now, CurrentUser.ID, DateTime.Now);
Response.Redirect("Expenses.aspx?ckmode=1&Cr=" + i);
}
if (Request["mode"] == "2")
{
i = Conn.Update("Expenses", "Where ExpensesCode = '" + Request["id"] + "' ", "Subsidies, Revenue, Free, Other, UpdateUser, UpdateDate", Convert.ToDecimal(txtSubsidies.Text), Convert.ToDecimal(txtRevenue.Text), Convert.ToDecimal(txtFree.Text), Convert.ToDecimal(txtOther.Text), CurrentUser.ID, DateTime.Now);
Response.Redirect("Expenses.aspx?ckmode=2&Cr=" + i);
}
}
protected void btSave_Click(object sender, EventArgs e)
{
Int32 i = 0;
if ((btc.CkUseData(ddlYearB.SelectedValue, "StudyYear", "Income", "And DelFlag = 0")) && Request["mode"] != "2")
{
btc.Msg_Head(Img1, MsgHead, true, "7", 0);
Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "SumTotal();", true);
return;
}
if (String.IsNullOrEmpty(Request["mode"]) || Request["mode"] == "1")
{
string NewID = Guid.NewGuid().ToString();
i = Conn.AddNew("Income", "IncomeCode, StudyYear, Ma, Subsidies, MaRevenue, Revenue, MaFree, Free, MaReserve, Reserve, MaOther, Other, DelFlag, CreateUser, CreateDate, UpdateUser, UpdateDate", NewID, ddlYearB.SelectedValue, Convert.ToDecimal(txtMa.Text), Convert.ToDecimal(txtMa.Text) + Convert.ToDecimal(txtSubsidies.Text), Convert.ToDecimal(txtMaRevenue.Text), Convert.ToDecimal(txtMaRevenue.Text) + Convert.ToDecimal(txtRevenue.Text), Convert.ToDecimal(txtMaFree.Text), Convert.ToDecimal(txtMaFree.Text) + Convert.ToDecimal(txtFree.Text), Convert.ToDecimal(txtMaReserve.Text), Convert.ToDecimal(txtMaReserve.Text) + Convert.ToDecimal(txtReserve.Text), Convert.ToDecimal(txtMaOther.Text), Convert.ToDecimal(txtMaOther.Text) + Convert.ToDecimal(txtOther.Text), 0, CurrentUser.ID, DateTime.Now, CurrentUser.ID, DateTime.Now);
Conn.AddNew("IncomeDetail", "IncomeCode, StudyYear, A1No, A1Value, A2No, A2Value, A3No, A3Value, P1No, P1Value, P2No, P2Value, P3No, P3Value, P4No, P4Value, P5No, P5Value, P6No, P6Value, M1No, M1Value, M2No, M2Value, M3No, M3Value, M4No, M4Value, M5No, M5Value, M6No, M6Value, ClassA1, ClassA2, ClassA3, ClassP1, ClassP2, ClassP3, ClassP4, ClassP5, ClassP6, ClassM1, ClassM2, ClassM3, ClassM4, ClassM5, ClassM6", NewID, ddlYearB.SelectedValue, Convert.ToDecimal(txtA1.Value), Convert.ToDecimal(txtAb1.Value), Convert.ToDecimal(txtA2.Value), Convert.ToDecimal(txtAb2.Value), Convert.ToDecimal(txtA3.Value), Convert.ToDecimal(txtAb3.Value), Convert.ToDecimal(txtP1.Value), Convert.ToDecimal(txtPb1.Value), Convert.ToDecimal(txtP2.Value), Convert.ToDecimal(txtPb2.Value), Convert.ToDecimal(txtP3.Value), Convert.ToDecimal(txtPb3.Value), Convert.ToDecimal(txtP4.Value), Convert.ToDecimal(txtPb4.Value), Convert.ToDecimal(txtP5.Value), Convert.ToDecimal(txtPb5.Value), Convert.ToDecimal(txtP6.Value), Convert.ToDecimal(txtPb6.Value), Convert.ToDecimal(txtM1.Value), Convert.ToDecimal(txtMb1.Value), Convert.ToDecimal(txtM2.Value), Convert.ToDecimal(txtMb2.Value), Convert.ToDecimal(txtM3.Value), Convert.ToDecimal(txtMb3.Value), Convert.ToDecimal(txtM4.Value), Convert.ToDecimal(txtMb4.Value), Convert.ToDecimal(txtM5.Value), Convert.ToDecimal(txtMb5.Value), Convert.ToDecimal(txtM6.Value), Convert.ToDecimal(txtMb6.Value), Convert.ToDecimal(txtClassA1.Value), Convert.ToDecimal(txtClassA2.Value), Convert.ToDecimal(txtClassA3.Value), Convert.ToDecimal(txtClassP1.Value), Convert.ToDecimal(txtClassP2.Value), Convert.ToDecimal(txtClassP3.Value), Convert.ToDecimal(txtClassP4.Value), Convert.ToDecimal(txtClassP5.Value), Convert.ToDecimal(txtClassP6.Value), Convert.ToDecimal(txtClassM1.Value), Convert.ToDecimal(txtClassM2.Value), Convert.ToDecimal(txtClassM3.Value), Convert.ToDecimal(txtClassM4.Value), Convert.ToDecimal(txtClassM5.Value), Convert.ToDecimal(txtClassM6.Value));
Response.Redirect("Income.aspx?ckmode=1&Cr=" + i);
}
if (Request["mode"] == "2")
{
i = Conn.Update("Income", "Where IncomeCode = '" + Request["id"] + "' ", "Ma, Subsidies, MaRevenue, Revenue, MaFree, Free, MaReserve, Reserve, MaOther, Other, UpdateUser, UpdateDate", Convert.ToDecimal(txtMa.Text), Convert.ToDecimal(txtMa.Text) + Convert.ToDecimal(txtSubsidies.Text), Convert.ToDecimal(txtMaRevenue.Text), Convert.ToDecimal(txtMaRevenue.Text) + Convert.ToDecimal(txtRevenue.Text), Convert.ToDecimal(txtMaFree.Text), Convert.ToDecimal(txtMaFree.Text) + Convert.ToDecimal(txtFree.Text), Convert.ToDecimal(txtMaReserve.Text), Convert.ToDecimal(txtMaReserve.Text) + Convert.ToDecimal(txtReserve.Text), Convert.ToDecimal(txtMaOther.Text), Convert.ToDecimal(txtMaOther.Text) + Convert.ToDecimal(txtOther.Text), CurrentUser.ID, DateTime.Now);
Conn.Update("IncomeDetail", "Where IncomeCode = '" + Request["id"] + "' ", "A1No, A1Value, A2No, A2Value, A3No, A3Value, P1No, P1Value, P2No, P2Value, P3No, P3Value, P4No, P4Value, P5No, P5Value, P6No, P6Value, M1No, M1Value, M2No, M2Value, M3No, M3Value, M4No, M4Value, M5No, M5Value, M6No, M6Value, ClassA1, ClassA2, ClassA3, ClassP1, ClassP2, ClassP3, ClassP4, ClassP5, ClassP6, ClassM1, ClassM2, ClassM3, ClassM4, ClassM5, ClassM6", Convert.ToDecimal(txtA1.Value), Convert.ToDecimal(txtAb1.Value), Convert.ToDecimal(txtA2.Value), Convert.ToDecimal(txtAb2.Value), Convert.ToDecimal(txtA3.Value), Convert.ToDecimal(txtAb3.Value), Convert.ToDecimal(txtP1.Value), Convert.ToDecimal(txtPb1.Value), Convert.ToDecimal(txtP2.Value), Convert.ToDecimal(txtPb2.Value), Convert.ToDecimal(txtP3.Value), Convert.ToDecimal(txtPb3.Value), Convert.ToDecimal(txtP4.Value), Convert.ToDecimal(txtPb4.Value), Convert.ToDecimal(txtP5.Value), Convert.ToDecimal(txtPb5.Value), Convert.ToDecimal(txtP6.Value), Convert.ToDecimal(txtPb6.Value), Convert.ToDecimal(txtM1.Value), Convert.ToDecimal(txtMb1.Value), Convert.ToDecimal(txtM2.Value), Convert.ToDecimal(txtMb2.Value), Convert.ToDecimal(txtM3.Value), Convert.ToDecimal(txtMb3.Value), Convert.ToDecimal(txtM4.Value), Convert.ToDecimal(txtMb4.Value), Convert.ToDecimal(txtM5.Value), Convert.ToDecimal(txtMb5.Value), Convert.ToDecimal(txtM6.Value), Convert.ToDecimal(txtMb6.Value), Convert.ToDecimal(txtClassA1.Value), Convert.ToDecimal(txtClassA2.Value), Convert.ToDecimal(txtClassA3.Value), Convert.ToDecimal(txtClassP1.Value), Convert.ToDecimal(txtClassP2.Value), Convert.ToDecimal(txtClassP3.Value), Convert.ToDecimal(txtClassP4.Value), Convert.ToDecimal(txtClassP5.Value), Convert.ToDecimal(txtClassP6.Value), Convert.ToDecimal(txtClassM1.Value), Convert.ToDecimal(txtClassM2.Value), Convert.ToDecimal(txtClassM3.Value), Convert.ToDecimal(txtClassM4.Value), Convert.ToDecimal(txtClassM5.Value), Convert.ToDecimal(txtClassM6.Value));
Response.Redirect("Income.aspx?ckmode=2&Cr=" + i);
}
}
private void GetData(string id)
{
if (string.IsNullOrEmpty(id))
{
return;
}
string strSql = @"Select P.*, IsNull(P.SetBudget, 0) Set_Budget, D.MainSubDeptCode
From Projects P Inner Join Department D On P.DeptCode = D.DeptCode
Where ProjectsCode = '{0}' ";
DataView dv = Conn.Select(string.Format(strSql, id));
DataView dv1 = Conn.Select(string.Format("Select StandardNationCode From dtStandardNation Where ProjectsCode = '" + id + "' "));
DataView dv2 = Conn.Select(string.Format("Select StandardMinistryCode From dtStandardMinistry Where ProjectsCode = '" + id + "' "));
DataView dv333 = Conn.Select(string.Format("Select StrategicObjectivesCode From dtStrategicObjectives Where ProjectsCode = '" + id + "' "));
DataView dv9 = Conn.Select(string.Format("Select StrategicCode From dtStrategic Where ProjectsCode = '" + id + "' "));
DataView dv18 = Conn.Select(string.Format("Select StrategicPlanID From dtStrategicPlan Where ProjectsCode = '" + id + "' "));
DataView dv19 = Conn.Select(string.Format("Select CorporateStrategyID From dtCorporateStrategy Where ProjectsCode = '" + id + "' "));
if (dv.Count != 0)
{
ddlYearS.SelectedValue = dv[0]["StudyYear"].ToString();
lblYearS.Text = ddlYearS.SelectedItem.Text;
SetItem();
if (btc.CkUseData(id, "ProjectsCode", "Activity", " And DelFlag = 0 "))
{
ddlYearS.Enabled = false;
}
ddlStrategicPlan.SelectedValue = dv[0]["StrategicPlanID"].ToString();
txtStrategicPlan.Text = dv[0]["StrategicPlan"].ToString();
txtProjects.Text = dv[0]["ProjectsName"].ToString();
hdfMainSubDeptCode.Value = dv[0]["MainSubDeptCode"].ToString();
txtIdentityName.Text = dv[0]["IdentityName"].ToString();
txtIdentityName2.Text = dv[0]["IdentityName2"].ToString();
txtPurpose.Text = dv[0]["Purpose"].ToString();
txtPurpose2.Text = dv[0]["Purpose2"].ToString();
txtTarget.Text = dv[0]["Target"].ToString();
txtTarget2.Text = dv[0]["Target2"].ToString();
txtPeriod1.Text = dv[0]["Period1"].ToString();
hdfCreateUser.Value = dv[0]["CreateUser"].ToString();
txtProjectsDetail.Text = dv[0]["ProjectsDetail"].ToString();
txtResponsibleName.Text = dv[0]["ResponsibleName"].ToString();
txtResponsiblePosition.Text = dv[0]["ResponsiblePosition"].ToString();
txtSort.Text = dv[0]["Sort"].ToString();
txtProjectRegistration.Text = dv[0]["ProjectRegistration"].ToString();
txtIOCode.Text = dv[0]["IOCode"].ToString();
rbtlProjectType.SelectedValue = dv[0]["ProjectTypeID"].ToString();
rbtlProjectType.Enabled = false;
getrbtlSubProjectType();
rbtlSubProjectType.SelectedValue = dv[0]["SubProjectTypeID"].ToString();
rbtlSubProjectType.Enabled = false;
txtPlace.Text = dv[0]["Place1"].ToString();
txtEvaTool.Text = dv[0]["EvaTool"].ToString();
btc.getddlDepartment(1, ddlDept, "", CurrentUser.DeptID, null);
ddlDept.SelectedValue = dv[0]["DeptCode"].ToString();
lblDept.Text = ddlDept.SelectedItem.Text;
btc.getddlDepartmentJoin(1, ddlDeptJoin, "", ddlDept.SelectedValue);
ddlDeptJoin.SelectedValue = dv[0]["DeptJoinCode"].ToString();
if (!string.IsNullOrEmpty(dv[0]["DeptJoinCode"].ToString()))
{
lblDeptJoin.Text = ddlDeptJoin.SelectedItem.Text;
}
else
{
lblDeptJoin.Text = "-";
}
ddlDeptJoin.Visible = false;
ddlDept.Visible = false;
txtConclusion.Text = dv[0]["Conclusion"].ToString();
txtPerformance.Text = dv[0]["Performance"].ToString();
txtProblem.Text = dv[0]["Problem"].ToString();
txtSolutions.Text = dv[0]["Solutions"].ToString();
if (!string.IsNullOrEmpty(dv[0]["SDate"].ToString()))
{
txtSDay.Text = Convert.ToDateTime(dv[0]["SDate"]).ToShortDateString();
}
if (!string.IsNullOrEmpty(dv[0]["EDate"].ToString()))
{
txtEDay.Text = Convert.ToDateTime(dv[0]["EDate"]).ToShortDateString();
}
}
btc.getCreateUpdateUser(lblCreate, lblUpdate, "Projects", "ProjectsCode", id);
if (!string.IsNullOrEmpty(dv[0]["IsApprove"].ToString()))
{
if (Convert.ToInt32(dv[0]["IsApprove"]) == 1)
{
lblApprove.Text = "<span style=\"font-weight:bold;\"> ͹ØÁѵÔâ¤Ã§¡ÒÃâ´Â : </span>" + btc.getEmpName(dv[0]["UserApprove"].ToString()) + "<br /><span style=\"font-weight:bold;\"> Çѹ·Õè : </span>" + Convert.ToDateTime(dv[0]["DateApprove"]).ToString("dd/MM/yyyy");
lblComment.Text = "<span style=\"font-weight:bold;\">¤ÇÒÁ¤Ô´àËç¹ : </span>" + dv[0]["Comment"].ToString();
lblApprove.ForeColor = System.Drawing.Color.Green;
lblComment.ForeColor = System.Drawing.Color.Green;
}
else
{
lblApprove.Text = "<span style=\"font-weight:bold;\">äÁè͹ØÁѵÔâ¤Ã§¡ÒÃâ´Â : </span>" + btc.getEmpName(dv[0]["UserApprove"].ToString()) + "<br /><span style=\"font-weight:bold;\"> Çѹ·Õè : </span>" + Convert.ToDateTime(dv[0]["DateApprove"]).ToString("dd/MM/yyyy");
lblComment.Text = "<span style=\"font-weight:bold;\">¤ÇÒÁ¤Ô´àËç¹ : </span>" + dv[0]["Comment"].ToString();
lblApprove.ForeColor = System.Drawing.Color.Red;
lblComment.ForeColor = System.Drawing.Color.Red;
}
}
if (hdfCreateUser.Value != CurrentUser.ID)
{
if (CurrentUser.RoleLevel < 98)
{
btSave.Visible = false;
}
}
else
{
//if (btc.ckApproveFlow(id)) //àªç¤ÇèÒÁÕ¡Òà Approve ä»áÅéÇËÃ×ÍÂѧ
//{
// btSave.Visible = false;
//}
}
//if (dv18.Count != 0)
//{
// for (int i = 0; i <= cblStrategicPlan.Items.Count - 1; i++)
// {
// for (int j = 0; j <= dv18.Count - 1; j++)
// {
// if (cblStrategicPlan.Items[i].Value == dv18[j]["StrategicPlanID"].ToString())
// {
// cblStrategicPlan.Items[i].Selected = true;
// break;
// }
// }
// }
//}
if (btc.ckIdentityName("ckStrategies"))
{
DataView dv100 = Conn.Select(string.Format("Select StrategiesCode From dtStrategies Where ProjectsCode = '" + id + "'"));
if (dv100.Count != 0)
{
for (int i = 0; i <= cblStrategies.Items.Count - 1; i++)
{
for (int j = 0; j <= dv100.Count - 1; j++)
{
if (cblStrategies.Items[i].Value == dv100[j]["StrategiesCode"].ToString())
{
cblStrategies.Items[i].Selected = true;
break;
}
}
}
}
}
cblStrategies.Enabled = false;
btc.getcblCorporateStrategy(divCorporateStrategy, cblCorporateStrategy, ddlYearS.SelectedValue, cblStrategies); //KPI
if (dv19.Count != 0)
{
for (int i = 0; i <= cblCorporateStrategy.Items.Count - 1; i++)
{
for (int j = 0; j <= dv19.Count - 1; j++)
{
if (cblCorporateStrategy.Items[i].Value == dv19[j]["CorporateStrategyID"].ToString())
{
cblCorporateStrategy.Items[i].Selected = true;
break;
}
}
}
}
cblCorporateStrategy.Enabled = false;
if (dv1.Count != 0)
{
for (int i = 0; i <= cblStandardNation.Items.Count - 1; i++)
{
for (int j = 0; j <= dv1.Count - 1; j++)
{
if (cblStandardNation.Items[i].Value == dv1[j]["StandardNationCode"].ToString())
{
cblStandardNation.Items[i].Selected = true;
break;
}
}
}
}
if (dv2.Count != 0)
{
for (int i = 0; i <= cblStandardMinistry.Items.Count - 1; i++)
{
for (int j = 0; j <= dv2.Count - 1; j++)
{
if (cblStandardMinistry.Items[i].Value == dv2[j]["StandardMinistryCode"].ToString())
{
cblStandardMinistry.Items[i].Selected = true;
break;
}
}
}
}
if (dv333.Count != 0)
{
for (int i = 0; i <= cblStrategicObjectives.Items.Count - 1; i++)
{
for (int j = 0; j <= dv333.Count - 1; j++)
{
if (cblStrategicObjectives.Items[i].Value == dv333[j]["StrategicObjectivesCode"].ToString())
{
cblStrategicObjectives.Items[i].Selected = true;
break;
}
}
}
}
if (dv9.Count != 0)
{
for (int i = 0; i <= cblStrategic.Items.Count - 1; i++)
{
for (int j = 0; j <= dv9.Count - 1; j++)
{
if (cblStrategic.Items[i].Value == dv9[j]["StrategicCode"].ToString())
{
cblStrategic.Items[i].Selected = true;
break;
}
}
}
}
if (btc.ckIdentityName("iNameShow2"))
{
DataView dv101 = Conn.Select(string.Format("Select IdentityNameCode From dtIdentityName Where ProjectsCode = '" + id + "'"));
if (dv101.Count != 0)
{
for (int i = 0; i <= cblIdentityName2.Items.Count - 1; i++)
{
for (int j = 0; j <= dv101.Count - 1; j++)
{
if (cblIdentityName2.Items[i].Value == dv101[j]["IdentityNameCode"].ToString())
{
cblIdentityName2.Items[i].Selected = true;
break;
}
}
}
}
}
cblIdentityName2.Enabled = false;
}
