protected void Page_Load(object sender, EventArgs e) { Cookie.SetValue2("ckActivityStatus", btc.ckIdentityName("ckActivityStatus")); //àªç¤âËÁ´µÔ´µÒÁ§Ò¹ if (!IsPostBack) { ckAlertRenew(); //Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "AlertActivity();", true); getSchoolDetail(); CkAdmin(); LoadComment(); LoadImageSlider(); btc.getddlMainDepartment(0, ddlSearchMainDept, Cookie.GetValue2("ckMainDeptID")); btc.getddlMainSubDepartment(0, ddlSearchMainSubDept, ddlSearchMainDept.SelectedValue, Cookie.GetValue2("ckMainSubDeptID")); btc.getddlDepartment(0, ddlSearchDept, ddlSearchMainSubDept.SelectedValue, Cookie.GetValue2("ckDeptID"), null); btc.getddlEmpByDept(0, ddlSearchEmp, ddlSearchDept.SelectedValue, Cookie.GetValue2("ckEmpID")); //btc.CkGroup(ddlSearchDept, ddlSearchEmp, Cookie.GetValue2("DfDept").ToString(), Cookie.GetValue2("DfEmp").ToString()); getrbtlStatus(); getddlYear(0); //getddlStrategies(0, ddlSearchYear.SelectedValue); btc.getddlMainDepartment(0, ddlSearchMainDept2, Cookie.GetValue2("ckMainDeptID")); btc.getddlMainSubDepartment(0, ddlSearchMainSubDept2, ddlSearchMainDept2.SelectedValue, Cookie.GetValue2("ckMainSubDeptID")); btc.getddlDepartment(0, ddlSearchDept2, ddlSearchMainSubDept2.SelectedValue, Cookie.GetValue2("ckDeptID"), null); btc.getddlEmpByDept(0, ddlSearchEmp2, ddlSearchDept2.SelectedValue, Cookie.GetValue2("ckEmpID")); DataBind(); } }
private void GetData() { string strSideName = "'´éÒ¹·Õè '"; string strStandardName = "'Áҵðҹ·Õè '"; string strIndicatorName = "'µÑǺ觪Õé·Õè '"; if (btc.ckIdentityName("ckStandardNew")) { strSideName = "'Áҵðҹ·Õè '"; strStandardName = "'»ÃÐà´ç¹Ï·Õè '"; strIndicatorName = "'»ÃÐà´ç¹ÏÂèÍ·Õè'"; } string strSql = " Select c.SideCode, {0} + Cast(c.Sort As nVarChar) + '. ' + c.SideName FullSideName, c.SideName, c.Sort, " + " a.StandardCode, {1} + Cast(a.Sort As nVarChar) + '. ' + a.StandardName FullStandardName, a.StandardName, a.Sort, " + " b.IndicatorsCode, {2} + Cast(a.Sort As nVarChar) + '.' + Cast(b.Sort As nVarChar) + ' ' + b.IndicatorsName FullIndicatorsName, b.IndicatorsName, b.Sort, " + " 0 As CountAc, 0 As CountSt " + " From Side c Left Join Standard a On c.SideCode = a.SideCode " + " Left Join Indicators b On a.StandardCode = b.StandardCode " + " Where c.DelFlag = 0 And a.DelFlag = 0 And b.DelFlag = 0 And a.StudyYear = '" + ddlYearB.SelectedValue + "' " + " Group By c.SideCode, c.SideName, c.Sort, a.StandardCode, a.StandardName, a.Sort, b.IndicatorsCode, b.IndicatorsName, b.Sort " + " Order By c.Sort, a.Sort, b.Sort "; dv1 = Conn.Select(string.Format(strSql, strSideName, strStandardName, strIndicatorName)); if (dv1.Count != 0) { Int32 CountAct = 0; for (int i = 0; i < dv1.Count; i++) { dv1[i]["FullStandardName"] = (dv1[i]["FullStandardName"].ToString().Length > 100 ? dv1[i]["FullStandardName"].ToString().Substring(0, 100) + "..." : dv1[i]["FullStandardName"]); dv1[i]["FullIndicatorsName"] = (dv1[i]["FullIndicatorsName"].ToString().Length > 100 ? dv1[i]["FullIndicatorsName"].ToString().Substring(0, 100) + "..." : dv1[i]["FullIndicatorsName"]); strSql = " Select IsNull(Count(Distinct(ActivityCode)), 0) ActCount From Evaluation " + " Where StandardCode = '" + dv1[i]["StandardCode"].ToString() + "' " + " And IndicatorsCode = '" + dv1[i]["IndicatorsCode"].ToString() + "' " + " And DelFlag = 0 And StudyYear = '" + ddlYearB.SelectedValue + "' And SchoolID = '" + CurrentUser.SchoolID + "' "; DataView ckDv = Conn.Select(strSql); if (ckDv.Count != 0) { dv1[i]["CountAc"] = Convert.ToInt32(ckDv[0]["ActCount"]); } else { dv1[i]["CountAc"] = 0; } } DataView dv2 = dv1.ToTable(true, "SideCode", "SideName", "FullSideName", "StandardCode", "FullStandardName", "StandardName").DefaultView; rptStandard.DataSource = dv2; rptStandard.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //àªç¤»Õ§º»ÃÐÁÒ³ btc.ckBudgetYear(null, lblYear); if (btc.ckIdentityName("ckBudgetYear")) { lblYear2.InnerText = "»Õ¡ÒÃÈÖ¡ÉÒ : "; } getddlYear(1); btc.getddlDay(ddlSDay); btc.getddlMonth2(ddlSMonth); btc.getddlYear(ddlSYear, 4); btc.getddlDay(ddlEDay); btc.getddlMonth2(ddlEMonth); btc.getddlYear(ddlEYear, 4); string mode = Request["mode"]; if (!String.IsNullOrEmpty(mode)) { switch (mode.ToLower()) { case "1": break; case "2": MultiView1.ActiveViewIndex = 0; GetData(Request["id"]); GetDataAttach(Request["id"]); if (btc.CkActivitySuccess(Request["id"])) { btSave.Visible = false; if (btc.ckGetAdmission(CurrentUser.UserRoleID) == 1) { btUndo.Visible = true; } } break; case "3": break; } } } ddlSDay.Attributes.Add("onchange", "ckddlDate(1);"); ddlSMonth.Attributes.Add("onchange", "ckddlDate(1);"); ddlSYear.Attributes.Add("onchange", "ckddlDate(1);"); ddlEDay.Attributes.Add("onchange", "ckddlDate(2);"); ddlEMonth.Attributes.Add("onchange", "ckddlDate(2);"); ddlEYear.Attributes.Add("onchange", "ckddlDate(2);"); }
protected void Page_Load(object sender, EventArgs e) { Cookie.SetValue2("ckActivityStatus", btc.ckIdentityName("ckActivityStatus")); //เช็คโหมดติดตามงาน if (!IsPostBack) { getddlDepartment(); btc.getddlEmpByDept(0, ddlSearchEmp, ddlSearchDept.SelectedValue, Cookie.GetValue2("ckEmpID")); //btc.CkGroup(ddlSearchDept, ddlSearchEmp, Cookie.GetValue2("AcDept").ToString(), Cookie.GetValue2("AcEmp").ToString()); getrbtlStatus(); DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MultiView1.ActiveViewIndex = 0; if (!string.IsNullOrEmpty(Request["Cr"])) { btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"])); } if (btc.ckIdentityName("ckStandardNew")) { lblTitle1.Text = "¤Ñ´ÅÍ¡Áҵðҹ/»ÃÐà´ç¹¡ÒþԨÒóÒ/»ÃÐà´ç¹¡ÒþԨÒóÒÂèÍÂ"; GridView1.Columns[1].HeaderText = "Áҵðҹ"; GridView1.Columns[2].HeaderText = "»ÃÐà´ç¹¡ÒþԨÒóÒ"; GridView1.Columns[3].HeaderText = "»ÃÐà´ç¹¡ÒþԨÒóÒÂèÍÂ"; } else { lblTitle1.Text = "¤Ñ´ÅÍ¡´éÒ¹/Áҵðҹ/µÑǺ觪Õé"; GridView1.Columns[1].HeaderText = "´éÒ¹"; GridView1.Columns[2].HeaderText = "Áҵðҹ"; GridView1.Columns[3].HeaderText = "µÑǺ觪Õé"; } //àªç¤»Õ§º»ÃÐÁÒ³ btc.ckBudgetYear(lblSearchYear, lblYear); getddlYear(); ckNewStandard(); string mode = Request["mode"]; if (!string.IsNullOrEmpty(mode)) { switch (mode.ToLower()) { case "1": break; case "2": break; case "3": break; } } else { DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "setupRefresh();", true); if (!IsPostBack) { MultiView1.ActiveViewIndex = 0; if (btc.ckIdentityName("ckBudgetYear")) { rbtStudyYear.Text = " »Õ§º»ÃÐÁÒ³"; rbtBudgetYear.Text = " »Õ¡ÒÃÈÖ¡ÉÒ"; } setYearType(); getddlYear(0); getddlProjectsNotStrategies(ddlSearchYear.SelectedValue); getddlDepartment(); string mode = Request["mode"]; if (!string.IsNullOrEmpty(mode)) { switch (mode.ToLower()) { case "1": break; case "2": break; case "3": break; } } else { DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MultiView1.ActiveViewIndex = 0; if (!string.IsNullOrEmpty(Request["Cr"])) { btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"])); } //àªç¤»Õ§º»ÃÐÁÒ³ btc.ckBudgetYear(lblSearchYear, null); Cookie.SetValue2("ckActivityStatus", btc.ckIdentityName("ckActivityStatus")); //àªç¤âËÁ´µÔ´µÒÁ§Ò¹ getddlYear(0); getddlStrategies(0, ddlSearchYear.SelectedValue); getddlProjects(0, ddlSearchYear.SelectedValue, ddlSearch2.SelectedValue); getddlDepartment(); getddlEmpByDept(0, ddlSearchDept.SelectedValue); btc.CkGroup(ddlSearchDept, ddlSearchEmp, Cookie.GetValue2("CtDept").ToString(), Cookie.GetValue2("CtEmp").ToString()); string mode = Request.QueryString["mode"]; if (!String.IsNullOrEmpty(mode)) { switch (mode.ToLower()) { case "1": break; case "2": break; case "3": break; } } else { DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MultiView1.ActiveViewIndex = 0; btc.LinkReport(linkReport); //àªç¤»Õ§º»ÃÐÁÒ³ btc.ckBudgetYear(lblSearchYear, null); Cookie.SetValue2("ckActivityStatus", btc.ckIdentityName("ckActivityStatus")); //àªç¤âËÁ´µÔ´µÒÁ§Ò¹ string mode = Request.QueryString["mode"]; if (!string.IsNullOrEmpty(mode)) { switch (mode.ToLower()) { case "1": break; case "2": break; case "3": break; } } else { getddlYear(0); //getddlStrategies(0, ddlSearchYear.SelectedValue); getddlProjects(0, ddlSearchYear.SelectedValue, ""); btc.getddlMainDepartment(0, ddlSearchMainDept, Cookie.GetValue2("ckMainDeptID")); btc.getddlMainSubDepartment(0, ddlSearchMainSubDept, ddlSearchMainDept.SelectedValue, Cookie.GetValue2("ckMainSubDeptID")); btc.getddlDepartment(0, ddlSearchDept, ddlSearchMainSubDept.SelectedValue, Cookie.GetValue2("ckDeptID"), null); btc.getddlEmpByDept(0, ddlSearchEmp, ddlSearchDept.SelectedValue, Cookie.GetValue2("ckEmpID")); DataBind(); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (btc.ckIdentityName("ckAnuban")) { lblStrategySPM.InnerHtml = "¡ÅÂØ·¸ì ʾ». : "; lblStrategySPMP.Text = "Êӹѡ§Ò¹à¢µ¾×é¹·Õè¡ÒÃÈÖ¡ÉÒ»ÃжÁÈÖ¡ÉÒ"; } getcblReportProject(); getcblReportActivity(); GetRate(); getddlYear(); GetData(CurrentUser.SchoolID); ckFullText(); } txtUpdateLink.Attributes.Add("onkeyup", "Cktxt(0);"); txtLogSarLink.Attributes.Add("onkeyup", "Cktxt(0);"); txtForwardMail.Attributes.Add("onkeyup", "Cktxt(0);"); //txtIdentity.Attributes.Add("onkeyup", "CkIdentity();"); //txtIdentity2.Attributes.Add("onkeyup", "CkIdentity2();"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { //àªç¤»Õ§º»ÃÐÁÒ³ btc.ckBudgetYear(lblSearchYear, null); Cookie.SetValue2("ckActivityStatus", btc.ckIdentityName("ckActivityStatus")); //àªç¤âËÁ´µÔ´µÒÁ§Ò¹ getddlYear(0); getddlMonth(); getddlStrategies(0, ddlSearchYear.SelectedValue); getddlProjects(0, ddlSearchYear.SelectedValue, ddlSearch2.SelectedValue); getddlDepartment(); getddlEmpByDept(0, ddlSearchDept.SelectedValue); btc.CkGroup(ddlSearchDept, ddlSearchEmp, Cookie.GetValue2("AcDept").ToString(), Cookie.GetValue2("AcEmp").ToString()); getrbtlStatus(); string mode = Request["mode"]; if (!string.IsNullOrEmpty(mode)) { switch (mode.ToLower()) { case "1": break; case "2": break; case "3": break; } } else { DataBind(); } } }
private void getActivityDetail(string ActivityCode) { DataView dv = btc.getActivityDetail(ActivityCode); if (dv.Count != 0) { txtActivityDetail.Text = dv[0]["ActivityDetail"].ToString(); lblType.Text = dv[0]["CostsType"].ToString(); lblTerm.Text = dv[0]["Term"].ToString() + "/" + dv[0]["YearB"].ToString(); if (btc.ckIdentityName("ckBudgetYear")) { lblBudgetYear.Text = dv[0]["StudyYear"].ToString(); } else { lblBudgetYear.Text = dv[0]["BudgetYear"].ToString(); } txtTotalAmount.Text = Convert.ToDouble(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(); } else { txtActivityDetail.Text = ""; lblType.Text = ""; lblTerm.Text = ""; lblBudgetYear.Text = ""; txtTotalAmount.Text = "0.00"; lblDepartment.Text = ""; lblEmpName.Text = ""; txtSDay.Text = ""; txtEDay.Text = ""; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MultiView1.ActiveViewIndex = 0; if (!string.IsNullOrEmpty(Request["Cr"])) { btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"])); } if (btc.ckIdentityName("ckStandardNew")) { lblTitle1.Text = "»ÃÐà´ç¹¡ÒþԨÒóÒÂèÍÂ"; lblTitle2.Text = "»ÃÐà´ç¹¡ÒþԨÒóÒÂèÍÂ"; lblStandardSearch.Text = "»ÃÐà´ç¹¡ÒþԨÒóÒ"; lblIndicatorNo.Text = "»ÃÐà´ç¹¡ÒþԨÒóÒÂèÍ·Õè"; lblStandard.Text = "»ÃÐà´ç¹¡ÒþԨÒóÒ"; lblIndicator.Text = "»ÃÐà´ç¹¡ÒþԨÒóÒÂèÍÂ"; GridView1.Columns[0].HeaderText = "»ÃÐà´ç¹¡ÒþԨÒóÒÂèÍÂ"; GridView2.Columns[0].HeaderText = "»ÃÐà´ç¹¡ÒþԨÒóÒÂèÍÂ"; btAdd.Text = " ÊÃéÒ§»ÃÐà´ç¹¡ÒþԨÒóÒÂèÍÂãËÁè"; btAdd.ToolTip = "ÊÃéÒ§»ÃÐà´ç¹¡ÒþԨÒóÒÂèÍÂãËÁè"; btSave.ToolTip = "ºÑ¹·Ö¡»ÃÐà´ç¹¡ÒþԨÒóÒÂè͹Õé"; btSaveAgain.Text = " ºÑ¹·Ö¡áÅÐÊÃéÒ§»ÃÐà´ç¹¡ÒþԨÒóÒÂèÍÂãËÁè"; btSaveAgain.ToolTip = "ºÑ¹·Ö¡»ÃÐà´ç¹¡ÒþԨÒóÒÂè͹ÕéáÅÐÊÃéÒ§»ÃÐà´ç¹¡ÒþԨÒóÒÂèÍÂãËÁè"; } else { lblTitle1.Text = "µÑǺ觪Õé"; lblTitle2.Text = "µÑǺ觪Õé"; lblStandardSearch.Text = "Áҵðҹ"; lblIndicatorNo.Text = "µÑǺ觪Õé·Õè"; lblStandard.Text = "Áҵðҹ"; lblIndicator.Text = "µÑǺ觪Õé"; GridView1.Columns[0].HeaderText = "µÑǺ觪Õé"; GridView2.Columns[0].HeaderText = "µÑǺ觪Õé"; btAdd.Text = " ÊÃéÒ§µÑǺ觪ÕéãËÁè"; btAdd.ToolTip = "ÊÃéÒ§µÑǺ觪ÕéãËÁè"; btSave.ToolTip = "ºÑ¹·Ö¡µÑǺ觪Õé¹Õé"; btSaveAgain.Text = " ºÑ¹·Ö¡áÅÐÊÃéÒ§µÑǺ觪ÕéãËÁè"; btSaveAgain.ToolTip = "ºÑ¹·Ö¡µÑǺ觪Õé¹ÕéáÅÐÊÃéÒ§µÑǺ觪ÕéãËÁè"; } btc.LinkReport(linkReport); //àªç¤»Õ§º»ÃÐÁÒ³ btc.ckBudgetYear(lblSearchYear, lblYear); getddlYear(0); getddlStandard(0, ddlSearchYear.SelectedValue); btc.CkAdmission(GridView1, btAdd, null); string mode = Request["mode"]; if (!String.IsNullOrEmpty(mode)) { switch (mode.ToLower()) { case "1": MultiView1.ActiveViewIndex = 1; getddlYear(1); getddlStandard(1, ddlYearB.SelectedValue); getddlScoreGroup(); btc.GenSort(txtSort, "Indicators", " And StandardCode = '" + ddlStandard.SelectedValue + "'"); Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "Cktxt(0);", true); break; case "2": MultiView1.ActiveViewIndex = 1; getddlYear(1); getddlScoreGroup(); btc.btEnable(btSaveAgain, false); GetData(Request["id"]); break; case "3": MultiView1.ActiveViewIndex = 0; Delete(Request["id"]); break; } } else { DataBind(); } } ddlStandard.Attributes.Add("onchange", "Cktxt(0);"); txtIndicators.Attributes.Add("onkeyup", "Cktxt(0);"); txtWeightScore.Attributes.Add("onkeyup", "Cktxt(0);"); ddlScoreGroup.Attributes.Add("onchange", "Cktxt(0);"); txtSort.Attributes.Add("onkeyup", "Cktxt(0);"); }
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; }
public override void DataBind() { string StrSql = ""; if (ddlSearch.SelectedIndex == 0) { if (ddlSearchDept.SelectedIndex == 0) { StrSql = " Select a.ProjectsCode, a.StrategiesCode, a.StudyYear,'â¤Ã§¡ÒÃ' + a.ProjectsName As FullName, a.Df, " + " a.Sort, b.Sort Sort1, b.StrategiesName, IsNull(Sum(c.TotalAmount), 0) TotalAmount1, " + " IsNull(Sum(c.TotalAmount2), 0) TotalAmount2, '' As AcCode, " + " (IsNull(Sum(c.TotalAmount), 0) - IsNull(Sum(c.TotalAmount2), 0)) TotalBalance, '-' As DeptName " + " From Projects a Left Join Strategies b On a.StrategiesCode = b.StrategiesCode " + " Left Join Activity c On a.ProjectsCode = c.ProjectsCode And c.DelFlag = 0 "; if (btc.ckIdentityName("ckBudgetYear")) { StrSql += " And c.StudyYear = '" + ddlSearchYear.SelectedValue + "' "; } else { StrSql += " And c.BudgetYear = '" + ddlSearchYear.SelectedValue + "' "; } StrSql += " Where a.DelFlag = 0 And a.StudyYear = '" + ddlSearchYear.SelectedValue + "' And a.SchoolID = '" + CurrentUser.SchoolID + "' "; } else { StrSql = " Select a.ProjectsCode, a.StrategiesCode, a.StudyYear,'â¤Ã§¡ÒÃ' + a.ProjectsName As FullName, a.Df, " + " a.Sort, b.Sort Sort1, b.StrategiesName, IsNull(Sum(c.TotalAmount), 0) TotalAmount1, " + " IsNull(Sum(c.TotalAmount2), 0) TotalAmount2, '' As AcCode, " + " (IsNull(Sum(c.TotalAmount), 0) - IsNull(Sum(c.TotalAmount2), 0)) TotalBalance, '-' As DeptName " + " From Projects a Left Join Strategies b On a.StrategiesCode = b.StrategiesCode " + " Left Join Activity c On a.ProjectsCode = c.ProjectsCode And c.DelFlag = 0 "; if (btc.ckIdentityName("ckBudgetYear")) { StrSql += " And c.StudyYear = '" + ddlSearchYear.SelectedValue + "' "; } else { StrSql += " And c.BudgetYear = '" + ddlSearchYear.SelectedValue + "' "; } //+ " Left Join dtAcDept d On c.ActivityCode = d.ActivityCode " StrSql += " Where a.DelFlag = 0 And a.StudyYear = '" + ddlSearchYear.SelectedValue + "' " + " And c.DeptCode = '" + ddlSearchDept.SelectedValue + "' " + " And a.SchoolID = '" + CurrentUser.SchoolID + "' "; } } else { if (ddlSearchDept.SelectedIndex == 0) { StrSql = " Select a.ProjectsCode, a.StrategiesCode, a.StudyYear, a.ProjectsName, a.Df, " + " a.Sort, b.Sort Sort1, b.StrategiesName, c.ActivityCode AcCode,'¡Ô¨¡ÃÃÁ' + c.ActivityName As FullName, " + " IsNull(c.TotalAmount, 0) TotalAmount1, " + " IsNull(c.TotalAmount2, 0) TotalAmount2, " + " (IsNull(c.TotalAmount, 0) - IsNull(c.TotalAmount2, 0)) TotalBalance, '' As DeptName " + " From Projects a Left Join Strategies b On a.StrategiesCode = b.StrategiesCode " + " Left Join Activity c On a.ProjectsCode = c.ProjectsCode And c.DelFlag = 0 "; if (btc.ckIdentityName("ckBudgetYear")) { StrSql += " And c.StudyYear = '" + ddlSearchYear.SelectedValue + "' "; } else { StrSql += " And c.BudgetYear = '" + ddlSearchYear.SelectedValue + "' "; } StrSql += " Left Join dtAcDept d On c.ActivityCode = d.ActivityCode " + " Where a.DelFlag = 0 And a.StudyYear = '" + ddlSearchYear.SelectedValue + "' " + " And a.SchoolID = '" + CurrentUser.SchoolID + "' " + " And a.ProjectsCode = '" + ddlSearch.SelectedValue + "'"; } else { StrSql = " Select a.ProjectsCode, a.StrategiesCode, a.StudyYear, a.ProjectsName, a.Df, " + " a.Sort, b.Sort Sort1, b.StrategiesName, c.ActivityCode AcCode,'¡Ô¨¡ÃÃÁ' + c.ActivityName As FullName, " + " IsNull(c.TotalAmount, 0) TotalAmount1, " + " IsNull(c.TotalAmount2, 0) TotalAmount2, " + " (IsNull(c.TotalAmount, 0) - IsNull(c.TotalAmount2, 0)) TotalBalance, '' As DeptName " + " From Projects a Left Join Strategies b On a.StrategiesCode = b.StrategiesCode " + " Left Join Activity c On a.ProjectsCode = c.ProjectsCode And c.DelFlag = 0 "; if (btc.ckIdentityName("ckBudgetYear")) { StrSql += " And c.StudyYear = '" + ddlSearchYear.SelectedValue + "' "; } else { StrSql += " And c.BudgetYear = '" + ddlSearchYear.SelectedValue + "' "; } //+ " Left Join dtAcDept d On c.ActivityCode = d.ActivityCode " StrSql += " Where a.DelFlag = 0 And a.StudyYear = '" + ddlSearchYear.SelectedValue + "' " + " And a.SchoolID = '" + CurrentUser.SchoolID + "' " + " And c.DeptCode = '" + ddlSearchDept.SelectedValue + "' " + " And a.ProjectsCode = '" + ddlSearch.SelectedValue + "'"; } } if (txtSearch.Text != "") { StrSql += " And ( a.ProjectsName Like '%" + txtSearch.Text + "%' Or c.ActivityName Like '%" + txtSearch.Text + "%' ) "; } DataView dv; if (ddlSearch.SelectedIndex == 0) { StrSql += " Group By a.ProjectsCode, a.StrategiesCode, a.StudyYear, a.ProjectsName, a.Df, a.Sort, b.Sort, b.StrategiesName "; } else { StrSql += " Group By a.ProjectsCode, a.StrategiesCode, a.StudyYear, a.ProjectsName, a.Df, a.Sort, b.Sort, b.StrategiesName, c.ActivityCode, c.ActivityName, c.TotalAmount, c.TotalAmount2 "; } dv = Conn.Select(string.Format(StrSql + " Order By b.Sort, a.Sort ")); for (int j = 0; j < dv.Count; j++) { if (dv[j]["DeptName"].ToString() != "-") { dv[j]["DeptName"] = btc.getAcDeptName(dv[j]["AcCode"].ToString()); } } GridView1.DataSource = dv; lblSearchTotal.InnerText = dv.Count.ToString(); GridView1.DataBind(); //----GrandTotal----------- if (ddlSearchDept.SelectedIndex == 0) { StrSql = " Select IsNull(Sum(c.TotalAmount), 0) TotalAmount1, " + " IsNull(Sum(c.TotalAmount2), 0) TotalAmount2, " + " (IsNull(Sum(c.TotalAmount), 0) - IsNull(Sum(c.TotalAmount2), 0)) TotalBalance " + " From Projects a Left Join Strategies b On a.StrategiesCode = b.StrategiesCode " + " Left Join Activity c On a.ProjectsCode = c.ProjectsCode " + " Where a.DelFlag = 0 And c.DelFlag = 0 " + " And a.SchoolID = '" + CurrentUser.SchoolID + "' "; if (btc.ckIdentityName("ckBudgetYear")) { StrSql += " And c.StudyYear = '" + ddlSearchYear.SelectedValue + "' "; } else { StrSql += " And c.BudgetYear = '" + ddlSearchYear.SelectedValue + "' "; } } else { StrSql = " Select IsNull(Sum(c.TotalAmount), 0) TotalAmount1, " + " IsNull(Sum(c.TotalAmount2), 0) TotalAmount2, " + " (IsNull(Sum(c.TotalAmount), 0) - IsNull(Sum(c.TotalAmount2), 0)) TotalBalance " + " From Projects a Left Join Strategies b On a.StrategiesCode = b.StrategiesCode " + " Left Join Activity c On a.ProjectsCode = c.ProjectsCode " + " Left Join dtAcDept d On c.ActivityCode = d.ActivityCode " + " Where a.DelFlag = 0 And c.DelFlag = 0 " + " And d.DeptCode = '" + ddlSearchDept.SelectedValue + "' " + " And a.SchoolID = '" + CurrentUser.SchoolID + "' "; if (btc.ckIdentityName("ckBudgetYear")) { StrSql += " And c.StudyYear = '" + ddlSearchYear.SelectedValue + "' "; } else { StrSql += " And c.BudgetYear = '" + ddlSearchYear.SelectedValue + "' "; } } DataView dvTotal = Conn.Select(StrSql); ToltalBudget.InnerHtml = (dvTotal.Count != 0) ? Convert.ToDecimal(dvTotal[0]["TotalAmount1"]).ToString("#,##0.00") : "0.00"; ToltalBudget2.InnerHtml = (dvTotal.Count != 0) ? Convert.ToDecimal(dvTotal[0]["TotalAmount2"]).ToString("#,##0.00") : "0.00"; TotalBalance.InnerHtml = (dvTotal.Count != 0) ? Convert.ToDecimal(dvTotal[0]["TotalBalance"]).ToString("#,##0.00") : "0.00"; //----EndGrandTotal----------- }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MultiView1.ActiveViewIndex = 0; if (!string.IsNullOrEmpty(Request["Cr"])) { btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"])); } getActivityName(Request.QueryString["acid"]); btc.getddlDay(ddlSDay); btc.getddlMonth2(ddlSMonth); btc.getddlYear(ddlSYear, 5); btc.getddlDay(ddlSDay2); btc.getddlMonth2(ddlSMonth2); btc.getddlYear(ddlSYear2, 5); txtSDay.Text = DateTime.Now.ToShortDateString(); txtSDay2.Text = DateTime.Now.ToShortDateString(); Cookie.SetValue2("ckActivityStatus", btc.ckIdentityName("ckActivityStatus")); //àªç¤âËÁ´µÔ´µÒÁ§Ò¹ if (btc.CkStatusActivitySuccess(Request["acid"])) { btSave.Visible = false; GridView1.Columns[GridView1.Columns.Count - 1].Visible = false; } if (btc.ckGetAdmission(CurrentUser.UserRoleID) != 1) { GridView1.Columns[GridView1.Columns.Count - 1].Visible = false; } string mode = Request["mode"]; int ij = string.IsNullOrEmpty(Request.QueryString["i"]) ? 0 : Convert.ToInt32(Request.QueryString["i"]); btc.getddlActivityStatus(ddlActivityStatus); if (!string.IsNullOrEmpty(mode)) { switch (mode.ToLower()) { case "1": MultiView1.ActiveViewIndex = 1; getDataActivity(Request.QueryString["acid"]); getSort(Request.QueryString["acid"]); hdfID.Value = Guid.NewGuid().ToString(); getlblKeyWord(); getddlDeputyDirectorName(); //txtResponsibleName.Text = lblEmp.Text; txtPositionResponsible.Text = "¼ÙéÃѺ¼Ô´ªÍº¡Ô¨¡ÃÃÁ"; txtPositionHeadGroup.Text = "ËÑÇ˹éÒ¡ÅØèÁ§Ò¹"; txtPositionHeadGroupSara.Text = "ËÑÇ˹éÒ§Ò¹/¡ÅØèÁÊÒÃÐÏ"; txtPositionUnderManagerName.Text = "Ãͧ¼ÙéÍӹǡÒáÅØèÁ"; if (Convert.ToBoolean(Cookie.GetValue2("ckActivityStatus"))) { DivActivityStatus.Visible = true; } Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "Cktxt(0);", true); break; case "2": MultiView1.ActiveViewIndex = 1; getDataActivity(Request.QueryString["acid"]); hdfID.Value = Request.QueryString["id"]; txtWithdrow.ReadOnly = true; getlblKeyWord(); getddlDeputyDirectorName(); GetData(hdfID.Value); GetDataAttach(hdfID.Value); break; case "3": MultiView1.ActiveViewIndex = 0; Delete(Request["id"]); break; case "4": btc.Msg_Head(Img1, MsgHead, true, "2", ij); break; } } else { DataBind(); } } txtActivityDetail.Attributes.Add("onkeyup", "Cktxt(0);"); txtWithdrow.Attributes.Add("onkeyup", "Cktxt(0);"); ddlSDay.Attributes.Add("onchange", "ckddlDate();"); ddlSMonth.Attributes.Add("onchange", "ckddlDate();"); ddlSYear.Attributes.Add("onchange", "ckddlDate();"); ddlSDay2.Attributes.Add("onchange", "ckddlDate2();"); ddlSMonth2.Attributes.Add("onchange", "ckddlDate2();"); ddlSYear2.Attributes.Add("onchange", "ckddlDate2();"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MultiView1.ActiveViewIndex = 0; if (!string.IsNullOrEmpty(Request["Cr"])) { btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"])); } //àªç¤»Õ§º»ÃÐÁÒ³ btc.ckBudgetYear(lblSearchYear, lblYear); if (btc.ckIdentityName("ckBudgetYear")) { lblYear2.InnerText = "»Õ¡ÒÃÈÖ¡ÉÒ : "; } getddlYear(0); getddlStrategies(0, ddlSearchYear.SelectedValue); getddlProjects(0, ddlSearchYear.SelectedValue, ddlSearch2.SelectedValue); getddlActivity(0, ddlSearch.SelectedValue); getddlDepartment(); getddlEmpByDept(0, ddlSearchDept.SelectedValue); btc.CkGroup(ddlSearchDept, ddlSearchEmp, Cookie.GetValue2("IndDept").ToString(), Cookie.GetValue2("IndEmp").ToString()); string mode = Request["mode"]; string delmode = Request.QueryString["delmode"]; int ij = string.IsNullOrEmpty(Request.QueryString["i"])? 0 : Convert.ToInt32(Request.QueryString["i"]); if (!String.IsNullOrEmpty(mode)) { switch (mode.ToLower()) { case "1": break; case "2": MultiView1.ActiveViewIndex = 1; getddlYear(1); GetData(Request["id"]); GetDataAttach(Request["id"]); EnableTxt(false); Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "CkPercent(0);", true); break; case "3": break; case "4": btc.Msg_Head(Img1, MsgHead, true, "2", ij); break; } } else { DataBind(); } if (!String.IsNullOrEmpty(delmode)) { //DeleteItems(); //DataBind2(); } } ddlStrategies.Attributes.Add("onchange", "Cktxt(0);"); ddlProjects.Attributes.Add("onchange", "Cktxt(0);"); ddlActivity.Attributes.Add("onchange", "Cktxt(0);"); txtSort.Attributes.Add("onkeyup", "Cktxt(0);"); txtWeight.Attributes.Add("onchange", "CkWeight();"); txtCan.Attributes.Add("onchange", "CkNum(); CkPercent(0);"); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { MultiView1.ActiveViewIndex = 0; if (!string.IsNullOrEmpty(Request["Cr"])) { btc.Msg_Head(Img1, MsgHead, true, Request["ckmode"], Convert.ToInt32(Request["Cr"])); } if (btc.ckIdentityName("ckStandardNew")) { lblTitle1.Text = "Áҵðҹ"; lblTitle2.Text = "Áҵðҹ"; lblSideNo.Text = "Áҵðҹ·Õè"; lblSide.Text = "Áҵðҹ"; GridView1.Columns[0].HeaderText = "Áҵðҹ·Õè"; GridView1.Columns[1].HeaderText = "ª×èÍÁҵðҹ"; GridView2.Columns[0].HeaderText = "Áҵðҹ·Õè"; GridView2.Columns[1].HeaderText = "ª×èÍÁҵðҹ"; btAdd.Text = " ÊÃéÒ§ÁҵðҹãËÁè"; btAdd.ToolTip = "ÊÃéÒ§ÁҵðҹãËÁè"; btSave.ToolTip = "ºÑ¹·Ö¡Áҵðҹ¹Õé"; btSaveAgain.Text = " ºÑ¹·Ö¡áÅÐÊÃéÒ§ÁҵðҹãËÁè"; btSaveAgain.ToolTip = "ºÑ¹·Ö¡Áҵðҹ¹ÕéáÅÐÊÃéÒ§ÁҵðҹãËÁè"; } else { lblTitle1.Text = "´éÒ¹"; lblTitle2.Text = "´éÒ¹"; lblSideNo.Text = "´éÒ¹·Õè"; lblSide.Text = "´éÒ¹"; GridView1.Columns[0].HeaderText = "´éÒ¹·Õè"; GridView1.Columns[1].HeaderText = "ª×èÍ´éÒ¹"; GridView2.Columns[0].HeaderText = "´éÒ¹·Õè"; GridView2.Columns[1].HeaderText = "ª×èÍ´éÒ¹"; btAdd.Text = " ÊÃéÒ§´éÒ¹ãËÁè"; btAdd.ToolTip = "ÊÃéÒ§´éÒ¹ãËÁè"; btSave.ToolTip = "ºÑ¹·Ö¡´éÒ¹¹Õé"; btSaveAgain.Text = " ºÑ¹·Ö¡áÅÐÊÃéÒ§´éÒ¹ãËÁè"; btSaveAgain.ToolTip = "ºÑ¹·Ö¡´éÒ¹¹ÕéáÅÐÊÃéÒ§´éÒ¹ãËÁè"; } //àªç¤»Õ§º»ÃÐÁÒ³ btc.ckBudgetYear(lblSearchYear, lblYear); getddlYear(0); btc.CkAdmission(GridView1, btAdd, null); string mode = Request["mode"]; if (!string.IsNullOrEmpty(mode)) { switch (mode.ToLower()) { case "1": MultiView1.ActiveViewIndex = 1; getddlYear(1); getddlScoreGroup(); btc.GenSort(txtSort, "Side", " And StudyYear = '" + ddlYearB.SelectedValue + "' "); Page.ClientScript.RegisterStartupScript(Page.GetType(), Guid.NewGuid().ToString(), "Cktxt(0);", true); break; case "2": MultiView1.ActiveViewIndex = 1; getddlYear(1); getddlScoreGroup(); btc.btEnable(btSaveAgain, false); GetData(Request["id"]); break; case "3": MultiView1.ActiveViewIndex = 0; Delete(Request["id"]); break; } } else { DataBind(); } } txtSide.Attributes.Add("onkeyup", "Cktxt(0);"); ddlScoreGroup.Attributes.Add("onchange", "Cktxt(0);"); txtSort.Attributes.Add("onkeyup", "Cktxt(0);"); }