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