protected new void Page_Load(object sender, EventArgs e)
    {
        base.AllowHttpMethod("POST");
        base.DisableTop(false);

        string DocTitle = GetString("i");

        PublishStateEnum publishState;

        Enum.TryParse(GetString("p"), out publishState);

        int pgNow  = GetNumber <int>("pgNow");
        int pgSize = GetNumber <int>("pgSize");


        PageCL CL     = new PageCL();
        string tbData = CL.GetList(new List <DocumentInfoVM>(), "ConnDB", "dbo.usp_DocumentM_xGetDocViewList",
                                   new Dictionary <string, object>()
        {
            { "@pgNow", pgNow == 0 ? 1 : pgNow },
            { "@pgSize", pgSize == 0 ? 10 : pgSize }
        });

        Response.ContentType = "application/json; charset=utf-8";
        Response.Write(tbData);
        Response.End();
    }
Exemplo n.º 2
0
    protected new void Page_Load(object sender, EventArgs e)
    {
        base.AllowHttpMethod("POST");
        base.DisableTop(true);

        int pgNow              = GetNumber <int>("pgNow");
        int pgSize             = GetNumber <int>("pgSize");
        int OrgID              = GetNumber <int>("lid");
        int AdmissionYearStart = GetNumber <int>("s");
        int AdmissionYearEnd   = GetNumber <int>("e");
        int ElementarySchoolID = GetNumber <int>("ei");
        int StudentYear        = GetNumber <int>("sy");

        PageCL CL     = new PageCL();
        string tbData = CL.GetList(new List <ElementaryRecordVM>(), "ConnDB", "dbo.usp_RecordM_xGetElementRecordListByMany",
                                   new Dictionary <string, object>()
        {
            { "@OrgID", OrgID },
            { "@AdmissionYearStart", AdmissionYearStart },
            { "@AdmissionYearEnd", AdmissionYearEnd == 0 ? 200 : AdmissionYearEnd },
            { "@InoculationType", 2 },
            { "@ElementarySchoolID", ElementarySchoolID },
            { "@pgNow", pgNow == 0 ? 1 : pgNow },
            { "@pgSize", pgSize == 0 ? 10 : pgSize }
        });

        Response.ContentType = "application/json; charset=utf-8";
        Response.Write(tbData);
        Response.End();
    }
Exemplo n.º 3
0
    protected new void Page_Load(object sender, EventArgs e)
    {
        base.AllowHttpMethod("POST");

        string AccountOrName = GetString("on");
        int    CheckState    = GetNumber <int>("cs");
        int    CheckYear     = GetNumber <int>("cy");
        int    YearSeason    = GetNumber <int>("ys");
        int    CheckProgress = GetNumber <int>("cp");
        int    pgNow         = GetNumber <int>("pgNow");
        int    pgSize        = GetNumber <int>("pgSize");

        PageCL CL     = new PageCL();
        string tbData = CL.GetList(new List <AccountCheckVM>(), "ConnUser", "dbo.usp_AccountM_xGetAccountCheckListByMany",
                                   new Dictionary <string, object>()
        {
            { "@OrgName", AccountOrName },
            { "@CheckYear", CheckYear },
            { "@YearSeason", YearSeason },
            { "@CheckProgress", CheckProgress },
            { "@pgNow", pgNow == 0 ? 1 : pgNow },
            { "@pgSize", pgSize == 0 ? 10 : pgSize },
        });

        Response.ContentType = "application/json; charset=utf-8";
        Response.Write(tbData);
        Response.End();
    }
    protected new void Page_Load(object sender, EventArgs e)
    {
        base.AllowHttpMethod("POST");

        int    AgencyCounty  = GetNumber <int>("ac");
        int    AgencyTown    = GetNumber <int>("at");
        int    AgencyVillage = GetNumber <int>("av");
        int    AgencyState   = GetNumber <int>("as");
        string AgencyName    = GetString("an");
        int    pgNow         = GetNumber <int>("pgNow");
        int    pgSize        = GetNumber <int>("pgSize");

        PageCL CL     = new PageCL();
        string tbData = CL.GetList(new List <AgencyInfoVM>(), "ConnDB", "dbo.usp_ParameterM_xGetAgencyListByMany",
                                   new Dictionary <string, object>()
        {
            { "@AgencyCounty", AgencyCounty },
            { "@AgencyTown", AgencyTown },
            { "@AgencyVillage", AgencyVillage },
            { "@AgencyState", AgencyState },
            { "@AgencyName", AgencyName },
            { "@pgNow", pgNow == 0 ? 1 : pgNow },
            { "@pgSize", pgSize == 0 ? 10 : pgSize }
        });

        Response.ContentType = "application/json; charset=utf-8";
        Response.Write(tbData);
        Response.End();
    }
Exemplo n.º 5
0
    protected new void Page_Load(object sender, EventArgs e)
    {
        base.AllowHttpMethod("POST");
        base.DisableTop(true);

        int pgNow  = GetNumber <int>("pgNow");
        int pgSize = GetNumber <int>("pgSize");

        //int OrgID = GetNumber<int>("oid");
        int    SchoolCounty  = GetNumber <int>("sc");
        int    SchoolTown    = GetNumber <int>("st");
        int    SchoolVillage = GetNumber <int>("sv");
        int    EnableState   = GetNumber <int>("es");
        string SchoolName    = GetString("sn");

        PageCL CL     = new PageCL();
        string tbData = CL.GetList(new List <SchoolCodeVM>(), "ConnDB", "dbo.usp_CodeM_xGetSchoolListByMany",
                                   new Dictionary <string, object>()
        {
            //{ "@OrgID", OrgID },
            { "@SchoolCounty", SchoolCounty },
            { "@SchoolTown", SchoolTown },
            { "@SchoolVillage", SchoolVillage },
            { "@EnableState", EnableState },
            { "@SchoolName", SchoolName },
            { "@pgNow", pgNow == 0 ? 1 : pgNow },
            { "@pgSize", pgSize == 0 ? 10 : pgSize }
        });

        Response.ContentType = "application/json; charset=utf-8";
        Response.Write(tbData);
        Response.End();
    }
Exemplo n.º 6
0
    protected new void Page_Load(object sender, EventArgs e)
    {
        base.AllowHttpMethod("GET", "POST");
        base.DisableTop(false);
        //Response.Write(Request.HttpMethod);
        if (Request.HttpMethod.Equals("POST"))
        {
            PageUrl        = QueryStringEncryptToolS.Decrypt(base.GetString("p"));
            EncryptPageUrl = QueryStringEncryptToolS.Encrypt(PageUrl);

            bool.TryParse(GetString("hf"), out hasFilter);

            //AddOrgLevel4 = GetString("addlv4");

            if (hasFilter)
            {
                loginOrgID = AuthServer.GetLoginUser().OrgID.ToString();
            }

            agencyState = GetNumber <int>("as");

            HasViewPower = CheckPower(PageUrl, MyPowerEnum.瀏覽);
            if (HasViewPower == false)
            {
                throw new HttpException(404, "Not found");
            }
            HasSearchPower = CheckPower(PageUrl, MyPowerEnum.查詢);

            PageCL CL = new PageCL();
            tbData = CL.GetList(new List <AgencyInfoVM>(), "ConnDB", "dbo.usp_ParameterM_xGetAgencyListByMany",
                                new Dictionary <string, object>()
            {
                { "@AgencyCounty", 0 },
                { "@AgencyTown", 0 },
                { "@AgencyVillage", 0 },
                { "@AgencyState", 0 },
                { "@AgencyName", "" },
                { "@pgNow", 1 },
                { "@pgSize", 10 }
            });
        }
        else
        {
            Response.Write("");
            Response.End();
        }
    }
Exemplo n.º 7
0
    protected new void Page_Load(object sender, EventArgs e)
    {
        base.AllowHttpMethod("POST");


        int pgNow  = GetNumber <int>("pgNow");
        int pgSize = GetNumber <int>("pgSize");

        PageCL CL     = new PageCL();
        string tbData = CL.GetList(new List <SystemCodeCateVM>(), "ConnDB", "dbo.usp_CodeM_xGetEnabledSystemCodeCateList",
                                   new Dictionary <string, object>()
        {
            { "@pgNow", pgNow == 0 ? 1 : pgNow },
            { "@pgSize", pgSize == 0 ? 10 : pgSize }
        });

        Response.ContentType = "application/json; charset=utf-8";
        Response.Write(tbData);
        Response.End();
    }
Exemplo n.º 8
0
    protected void Page_Load(object sender, EventArgs e)
    {
        base.AllowHttpMethod("POST");

        int pgNow      = GetNumber <int>("pgNow");
        int pgSize     = GetNumber <int>("pgSize");
        int RoleCateID = GetNumber <int>("rc");

        PageCL CL     = new PageCL();
        string tbData = CL.GetList(new List <RolePowerSettingVM>(), "ConnUser", "dbo.usp_PowerM_xGetRoleListByRoleCateID",
                                   new Dictionary <string, object>()
        {
            { "@RoleCateID", RoleCateID },
            { "@pgNow", pgNow == 0 ? 1 : pgNow },
            { "@pgSize", pgSize == 0 ? 10 : pgSize }
        });

        Response.ContentType = "application/json; charset=utf-8";
        Response.Write(tbData);
        Response.End();
    }
Exemplo n.º 9
0
    protected new void Page_Load(object sender, EventArgs e)
    {
        base.AllowHttpMethod("POST");
        base.DisableTop(true);

        int pgNow  = GetNumber <int>("pgNow");
        int pgSize = GetNumber <int>("pgSize");

        int OrgID = GetNumber <int>("i");


        PageCL CL     = new PageCL();
        string tbData = CL.GetList(new List <MedicalCodeVM>(), "ConnUser", "dbo.usp_CodeM_xGetOrgChangeLogListByID",
                                   new Dictionary <string, object>()
        {
            { "@OrgID", OrgID }
        });

        Response.ContentType = "application/json; charset=utf-8";
        Response.Write(tbData);
        Response.End();
    }
Exemplo n.º 10
0
    protected new void Page_Load(object sender, EventArgs e)
    {
        base.AllowHttpMethod("POST");

        var PageUrl = QueryStringEncryptToolS.Decrypt(base.GetString("p"));

        bool hasFilter = false;

        bool.TryParse(base.GetString("hf"), out hasFilter);

        var HasViewPower = CheckPower(PageUrl, MyPowerEnum.瀏覽);

        if (HasViewPower == false)
        {
            throw new HttpException(404, "Not found");
        }

        string AgencyName = GetString("an");
        //string AddOrgLevel4 = GetString("addlv4");
        int AgencyCounty  = GetNumber <int>("ac");
        int AgencyTown    = GetNumber <int>("at");
        int AgencyVillage = GetNumber <int>("av");
        int AgencyState   = GetNumber <int>("as");
        int pgNow         = GetNumber <int>("pgNow");
        int pgSize        = GetNumber <int>("pgSize");

        PageCL CL = new PageCL();
        string tbData;

        if (hasFilter)
        {
            tbData = CL.GetList(new List <AgencyInfoVM>(), "ConnDB", "dbo.usp_ParameterM_xGetAgencyListByOrgID",
                                new Dictionary <string, object>()
            {
                { "@AgencyCounty", AgencyCounty },
                { "@AgencyTown", AgencyTown },
                { "@AgencyVillage", AgencyVillage },
                { "@AgencyState", AgencyState },
                { "@AgencyName", AgencyName },
                //{ "@AddOrgLevel4", AddOrgLevel4 },
                { "@OrgID", AuthServer.GetLoginUser().OrgID.ToString() },
                { "@pgNow", pgNow == 0 ? 1 : pgNow },
                { "@pgSize", pgSize == 0 ? 10 : pgSize }
            });
        }
        else
        {
            tbData = CL.GetList(new List <AgencyInfoVM>(), "ConnDB", "dbo.usp_ParameterM_xGetAgencyListByMany",
                                new Dictionary <string, object>()
            {
                { "@AgencyCounty", AgencyCounty },
                { "@AgencyTown", AgencyTown },
                { "@AgencyVillage", AgencyVillage },
                { "@AgencyState", AgencyState },
                { "@AgencyName", AgencyName },
                { "@pgNow", pgNow == 0 ? 1 : pgNow },
                { "@pgSize", pgSize == 0 ? 10 : pgSize }
            });
        }

        Response.ContentType = "application/json; charset=utf-8";
        Response.Write(tbData);
        Response.End();
    }
Exemplo n.º 11
0
    protected new void Page_Load(object sender, EventArgs e)
    {
        base.AllowHttpMethod("POST");

        int pgNow  = GetNumber <int>("pgNow");
        int pgSize = GetNumber <int>("pgSize");

        int    OrgID         = GetNumber <int>("oid");
        int    AgencyCounty  = GetNumber <int>("ac");
        int    AgencyTown    = GetNumber <int>("at");
        int    AgencyVillage = GetNumber <int>("av");
        int    AgencyState   = GetNumber <int>("as");
        string AgencyName    = GetString("an");

        PageCL CL     = new PageCL();
        string tbData = CL.GetList(new List <AgencyInfoVM>(), "ConnDB", "dbo.usp_ParameterM_xGetAgencyListByMany",
                                   new Dictionary <string, object>()
        {
            { "@OrgID", OrgID },
            { "@AgencyCounty", AgencyCounty },
            { "@AgencyTown", AgencyTown },
            { "@AgencyVillage", AgencyVillage },
            { "@AgencyState", AgencyState },
            { "@AgencyName", AgencyName },
            { "@OrgLevel", 0 },
            { "@pgNow", pgNow == 0 ? 1 : pgNow },
            { "@pgSize", pgSize == 0 ? 10 : pgSize }
        });

        Response.ContentType = "application/json; charset=utf-8";
        Response.Write(tbData);
        Response.End();

        //DataSet ds = GetDataSet("ConnDB", "dbo.usp_ParameterM_xGetAgencyListByMany"
        //                                 , new Dictionary<string, object>()
        //                                 {
        //                                      { "@OrgID", OrgID },
        //                                      { "@AgencyCounty", AgencyCounty  },
        //                                      { "@AgencyTown", AgencyTown },
        //                                      { "@AgencyVillage", AgencyVillage },
        //                                      { "@AgencyState", AgencyState },
        //                                      { "@AgencyName", AgencyName },
        //                                      { "@pgNow", pgNow == 0 ? 1 : pgNow },
        //                                      { "@pgSize", pgSize == 0 ? 10 : pgSize }
        //                                });

        //List<AgencyInfoVM> list = new List<AgencyInfoVM>();
        //PageVM rtn = new PageVM();

        //EntityS.FillModel(list, ds.Tables[0]);
        //EntityS.FillModel(rtn, ds.Tables[1]);
        //rtn.message = list;

        //Response.ContentType = "application/json; charset=utf-8";
        //Response.Write(JsonConvert.SerializeObject(rtn));
        //Response.End();

        //Response.AppendHeader("Content-Encoding", "gzip");
        //GZippedJsonT gzip = new GZippedJsonT();
        //var data = gzip.Compress(JsonConvert.SerializeObject(rtn, Formatting.Indented));
        ////Response.AppendHeader("Content-Length", data.Length.ToString());
        ////Response.ContentType = "application/json; charset=utf-8";
        ////Response.ContentEncoding = Encoding.UTF8;
        //Response.OutputStream.Write(data, 0, data.Length);
        //Response.End();

        //int pgNow;
        //int pgSize;


        //int.TryParse(Request.Form["pgNow"], out pgNow);
        //int.TryParse(Request.Form["pgSize"], out pgSize);

        //DataSet ds = new DataSet();

        //using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString()))
        //{
        //    using (SqlCommand cmd = new SqlCommand("dbo.usp_ParameterM_xGetAgencyList", sc))
        //    {
        //        cmd.CommandType = CommandType.StoredProcedure;
        //        cmd.Parameters.AddWithValue("@pgNow", pgNow == 0 ? 1 : pgNow);
        //        cmd.Parameters.AddWithValue("@pgSize", pgSize == 0 ? 10 : pgSize);
        //        using (SqlDataAdapter da = new SqlDataAdapter(cmd))
        //        {
        //            sc.Open();
        //            da.Fill(ds);
        //        }

        //    }
        //}

        //List<AgencyInfoVM> list = new List<AgencyInfoVM>();
        //PageVM rtn = new PageVM();



        //EntityS.FillModel(list, ds.Tables[0]);
        //EntityS.FillModel(rtn, ds.Tables[1]);
        //rtn.message = list;

        //Response.ContentType = "application/json; charset=utf-8";
        //Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rtn));
        //Response.End();
    }