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