Esempio n. 1
0
    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();
        }
    }
Esempio n. 2
0
    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();
        }
    }
Esempio n. 3
0
    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);");
    }
Esempio n. 4
0
    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();
        }
    }
Esempio n. 5
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 = "¤Ñ´ÅÍ¡Áҵðҹ/»ÃÐà´ç¹¡ÒþԨÒóÒ/»ÃÐà´ç¹¡ÒþԨÒóÒÂèÍÂ";
                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();
            }
        }
    }
Esempio n. 6
0
    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();
            }
        }
    }
Esempio n. 7
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"]));
            }

            //àªç¤»Õ§º»ÃÐÁÒ³
            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();
            }
        }
    }
Esempio n. 8
0
    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();
            }
        }
    }
Esempio n. 9
0
 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();");
 }
Esempio n. 10
0
    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();
            }
        }
    }
Esempio n. 11
0
    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           = "";
        }
    }
Esempio n. 12
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                  = "»ÃÐà´ç¹¡ÒþԨÒóÒÂèÍÂ";
                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;
    }
Esempio n. 14
0
    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-----------
    }
Esempio n. 15
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"]));
            }
            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();");
    }
Esempio n. 16
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"]));
            }

            //àªç¤»Õ§º»ÃÐÁÒ³
            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);");
    }
Esempio n. 17
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);");
    }