protected void Page_Load(object sender, EventArgs e) { SearchPower = base.AddPower(SearchPower); base.DisableTop(true); if (SystemCode.dict.ContainsKey("FrequentlyAskedQuestionM_QAViewDate")) { QAViewDateStatus = JsonConvert.SerializeObject(SystemCode.dict["FrequentlyAskedQuestionM_QAViewDate"].Where(item => item.EnumName != null)); } DataSet ds = new DataSet(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("usp_QnAType_xGetQnATypeAllData", sc)) { cmd.CommandType = CommandType.StoredProcedure; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(ds); } } } QnAType = JsonConvert.SerializeObject(ds.Tables[0]); }
protected void Page_Load(object sender, EventArgs e) { SearchPower = base.AddPower(SearchPower); base.AllowHttpMethod("GET", "POST"); base.DisableTop(true); int OrgID = 0; int.TryParse(Request.QueryString["OrgID"], out OrgID); OrgName = SystemOrg.GetName(OrgID); DataSet ds = new DataSet(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("usp_AccountSet_xGetSearchData", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@OrgID", OrgID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(ds); } } } Year = JsonConvert.SerializeObject(ds.Tables[0]); }
protected new void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("GET", "POST"); base.DisableTop(true); AddPower = base.GetPower(list[1]); if (Request.HttpMethod.Equals("POST")) { ID = GetNumber <int>("i"); } else { ID = GetNumber <int>("i", MyHttpMethod.GET); } if (ID == 0) { string script = "<style>body{display:none;}</style><script>alert('資料取得失敗');history.go(-1);</script>"; Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); return; } DataTable dt = MSDB.GetDataTable("ConnDB", "dbo.usp_CodeM_xGetSystemCodeListByCateID" , new Dictionary <string, object>() { { "@SystemCodeCateID", ID } }); EntityS.FillModel(VM, dt); }
protected void Page_Load(object sender, EventArgs e) { AddPower = base.GetPower(AddPower); base.AllowHttpMethod("GET"); base.DisableTop(true); }
protected void Page_Load(object sender, EventArgs e) { SearchPower = base.AddPower(SearchPower); string Para = ""; if (SearchPower.HasPower == true) { Para = Request.Form["Para"]; } DataSet ds = new DataSet(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("usp_SysParameter_xSearchTable", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Para", Para); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(ds); } } } List <SystemParametersVM> list = new List <SystemParametersVM>(); AnyDataVM rtn = new AnyDataVM(); EntityS.FillModel(list, ds.Tables[0]); rtn.message = list; Response.ContentType = "application/json; charset=utf-8"; Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rtn)); Response.End(); }
protected new void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("GET"); base.DisableTop(true); SearchPower = base.GetPower(PowerList[0]); AddPower = base.GetPower(PowerList[1]); UploadPower = base.GetPower(PowerList[2]); var user = AuthServer.GetLoginUser(); UC_OpenSelectSingleOrg.PageUrl = "/Vaccination/RecordM/StudentRecord.aspx"; UC_OpenSelectSingleOrg.DefaultID = user.OrgID; UC_OpenSelectSingleOrg.DefaultName = user.OrgName; DefaultOrgID = user.OrgID; DefaultOrgName = user.OrgName; if (SystemElementarySchool.list.Count > 0) { sAry = JsonConvert.SerializeObject(SystemElementarySchool.list.Where(item => item.OrgID == user.OrgID)); } //PageCL CL = new PageCL(); //tbData = CL.GetList(new List<ElementaryRecordVM>(), "ConnDB", "dbo.usp_RecordM_xGetElementRecordListByMany", // new Dictionary<string, object>() // { // { "@OrgID", 0 }, // { "@AdmissionYearStart", 0 }, // { "@AdmissionYearEnd", 0 }, // { "@InoculationType", 1 }, // { "@ElementarySchoolID", 0 }, // { "@pgNow", 1 }, // { "@pgSize", 10 } // }); }
protected new void Page_Load(object sender, EventArgs e) { SearchPower = list[0]; AddPower = list[1]; base.AllowHttpMethod("GET"); base.DisableTop(true); if (SystemCode.dict.ContainsKey("CodeM_SchoolCode_EnableState")) { var codes = SystemCode.dict["CodeM_SchoolCode_EnableState"]; if (codes.Count > 0) { EnStateJson = JsonConvert.SerializeObject(codes); } } //PageCL CL = new PageCL(); //tbData = CL.GetList(new List<SchoolCodeVM>(), "ConnDB", "dbo.usp_CodeM_xGetSchoolListByMany", // new Dictionary<string, object>() // { // { "@OrgID", 0 }, // { "@SchoolCounty", 0 }, // { "@SchoolTown", 0 }, // { "@SchoolVillage", 0 }, // { "@EnableState", 0 }, // { "@SchoolName", "" }, // { "@pgNow", 1 }, // { "@pgSize", 10 } // }); }
protected void Page_Load(object sender, EventArgs e) { ModifyPower = base.AddPower(list[0]); SearchPower = base.AddPower(list[1]); base.AllowHttpMethod("GET", "POST"); base.DisableTop(true); UserVM user = AuthServer.GetLoginUser(); OrgName = string.Format("{0}", user.OrgName); OrgID = string.Format("{0}", user.OrgID); int SelectOrgID = 0; int.TryParse(Request.QueryString["ID"], out SelectOrgID); if (SelectOrgID == 0) { SelectOrgID = user.OrgID; OrgName = SystemOrg.GetName(SelectOrgID); } else { OrgName = SystemOrg.GetName(SelectOrgID); } if (user.OrgID == SelectOrgID) { Check = true; } else { Check = false; } }
protected void Page_Load(object sender, EventArgs e) { ModifyPower = base.AddPower(list[0]); SearchPower = base.AddPower(list[1]); base.AllowHttpMethod("GET", "POST"); base.DisableTop(true); }
protected new void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("GET"); base.DisableTop(true); AddPower = base.GetPower(AddPower); if (SystemPowerCate.list.Count > 0) { RoleCateID = Convert.ToInt32(WebConfigurationManager.AppSettings["RoleCateID"]); var list = SystemPowerCate.list; if (RoleCateID == 1) { MyPowerData = JsonConvert.SerializeObject(list); } else { OtherAttr = "ng-init=\"VM.selectSpc='4'\" ng-disabled='true'"; MyPowerData = JsonConvert.SerializeObject(list.Where(item => item.ID == RoleCateID)); } } //PageCL CL = new PageCL(); //tbData = CL.GetList(new List<RolePowerSettingVM>(), "ConnUser", "dbo.usp_PowerM_xGetRoleListByRoleCateID", // new Dictionary<string, object>() // { // { "@RoleCateID", 0 }, // { "@pgNow", 1}, // { "@pgSize", 10 } // }); }
protected new void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("GET"); base.DisableTop(true); SearchPower = base.GetPower(PowerList[0]); AddPower = base.GetPower(PowerList[1]); UpdatePower = base.GetPower(PowerList[2]); MyRoleData = JsonConvert.SerializeObject(SystemRole.list.Where(item => item.RoleName != null)); if (SystemCode.dict.ContainsKey("AccountM_EnableState")) { MyEnableData = JsonConvert.SerializeObject(SystemCode.dict["AccountM_EnableState"].Where(item => item.EnumName != null)); } if (SystemCode.dict.ContainsKey("AccountM_CheckState")) { MyCheckData = JsonConvert.SerializeObject(SystemCode.dict["AccountM_CheckState"].Where(item => item.EnumName != null)); } if (SystemCode.dict.ContainsKey("AccountM_LogoutPeriod")) { MyLogoutData = JsonConvert.SerializeObject(SystemCode.dict["AccountM_LogoutPeriod"].Where(item => item.EnumName != null)); } }
protected new void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("GET"); base.DisableTop(true); SearchPower = base.GetPower(PowerList[0]); AddPower = base.GetPower(PowerList[1]); UpdatePower = base.GetPower(PowerList[2]); var user = AuthServer.GetLoginUser(); UC_OpenSelectSingleOrg.PageUrl = "/System/AccountM/AccountCheck.aspx"; UC_OpenSelectSingleOrg.DefaultID = user.OrgID; UC_OpenSelectSingleOrg.DefaultName = user.OrgName; DefaultOrgID = user.OrgID; DefaultOrgName = user.OrgName; MyRoleData = JsonConvert.SerializeObject(SystemRole.list.Where(item => item.RoleName != null)); if (SystemCode.dict.ContainsKey("AccountM_EnableState")) { MyEnableData = JsonConvert.SerializeObject(SystemCode.dict["AccountM_EnableState"].Where(item => item.EnumName != null)); } if (SystemCode.dict.ContainsKey("AccountM_CheckState")) { MyCheckData = JsonConvert.SerializeObject(SystemCode.dict["AccountM_CheckState"].Where(item => item.EnumName != null)); } if (SystemCode.dict.ContainsKey("AccountM_LogoutPeriod")) { MyLogoutData = JsonConvert.SerializeObject(SystemCode.dict["AccountM_LogoutPeriod"].Where(item => item.EnumName != null)); } }
protected void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("POST"); base.DisableTop(true); ViewPower = base.GetPower(PowerList[0]); UpdatePower = base.GetPower(PowerList[1]); if (this.IsPostBack == false) { var codes = SystemCode.dict["CodeM_SchoolCode_EnableState"]; ddEnState.Items.Add(new ListItem("請選擇", "0")); foreach (var item in codes) { ddEnState.Items.Add(new ListItem(item.EnumName, item.EnumValue.ToString())); } ddEnState.SelectedValue = "0"; CountyJson = JsonConvert.SerializeObject(SystemAreaCode.GetCountyList()); TownJson = JsonConvert.SerializeObject(SystemAreaCode.GetTownList(County)); VillageJson = JsonConvert.SerializeObject(SystemAreaCode.GetVillageList(Town)); } }
protected void Page_Load(object sender, EventArgs e) { SearchPower = base.AddPower(list[0]); PrintPower = base.AddPower(list[1]); base.AllowHttpMethod("GET", "POST"); base.DisableTop(true); UserVM user = AuthServer.GetLoginUser(); OrgName = string.Format("{0}", user.OrgName); DataSet ds = new DataSet(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("usp_KnotStockQuery_xGetSearchData", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@OrgID", user.OrgID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(ds); } } } Vaccine = JsonConvert.SerializeObject(ds.Tables[0]); }
protected void Page_Load(object sender, EventArgs e) { NewPower = base.AddPower(list[0]); UploadPower = base.AddPower(list[1]); base.AllowHttpMethod("GET", "POST"); base.DisableTop(false); }
protected new void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("POST"); base.DisableTop(true); AddPower = base.GetPower(list[1]); ID = GetNumber <int>("i"); if (ID == 0) { string script = "<style>body{display:none;}</style><script>alert('資料取得失敗');history.go(-1);</script>"; Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); return; } DataTable dt = MSDB.GetDataTable("ConnDB", "dbo.usp_CodeM_xGetSystemCodeListByCateID" , new Dictionary <string, object>() { { "@SystemCodeCateID", ID } }); EntityS.FillModel(VM, dt); //PageCL CL = new PageCL(); //tbData = CL.GetList(new List<SystemCodeVM>(), "ConnDB", "dbo.usp_CodeM_xGetEnabledSystemCodeList", // new Dictionary<string, object>() // { // { "@SystemCodeCateID", ID }, // { "@EnState", 0 }, // { "@pgNow",1}, // { "@pgSize", 10} // }); }
protected void Page_Load(object sender, EventArgs e) { NewPower = base.AddPower(list[0]); DeletePower = base.AddPower(list[1]); SearchPower = base.AddPower(list[2]); PrintPower = base.AddPower(list[3]); DownloadPower = base.AddPower(list[4]); base.AllowHttpMethod("GET", "POST"); base.DisableTop(true); UserVM user = AuthServer.GetLoginUser(); OrgName = string.Format("{0}", user.OrgName); OrgID = string.Format("{0}", user.OrgID); if (SystemCode.dict.ContainsKey("VaccineM_BatchType")) { BatchType = JsonConvert.SerializeObject(SystemCode.dict["VaccineM_BatchType"].Where(item => item.EnumName != null)); } if (SystemCode.dict.ContainsKey("StockManagementM_DealStatus")) { DealStatus = JsonConvert.SerializeObject(SystemCode.dict["StockManagementM_DealStatus"].Where(item => item.EnumName != null)); } }
protected void Page_Load(object sender, EventArgs e) { AddPower = base.GetPower(list[0]); SearchPower = base.GetPower(list[1]); base.AllowHttpMethod("GET"); base.DisableTop(false); }
protected MyPowerVM AddPower(MyPowerVM VM) { if (dict.ContainsKey(VM) == false) { dict.Add(VM, VM); } return(VM); }
protected void Page_Load(object sender, EventArgs e) { SearchPower = base.AddPower(SearchPower); UserVM user = AuthServer.GetLoginUser(); int pgNow; int pgSize; int OrgID = 0; string Subject = ""; int Status = 0; int.TryParse(Request.Form["pgNow"], out pgNow); int.TryParse(Request.Form["pgSize"], out pgSize); if (SearchPower.HasPower == true) { int.TryParse(Request.Form["OrgID"], out OrgID); Subject = Request.Form["Subject"]; int.TryParse(Request.Form["Status"], out Status); if (OrgID == -1) { OrgID = user.OrgID; } } DataSet ds = new DataSet(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("usp_NewsPublished_xSearchTable", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@pgNow", pgNow); cmd.Parameters.AddWithValue("@pgSize", pgSize); cmd.Parameters.AddWithValue("@OrgID", OrgID); cmd.Parameters.AddWithValue("@Subject", Subject); cmd.Parameters.AddWithValue("@Status", Status); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(ds); } } } List <NewsPublishedVM> list = new List <NewsPublishedVM>(); 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(); }
protected MyPowerVM AddPower(MyPowerVM VM) { //CheckPowerList.Add(myPowerVM); if (dict.ContainsKey(VM) == false) { dict.Add(VM, VM); } return(VM); }
protected void Page_Load(object sender, EventArgs e) { SearchPower = base.GetPower(PowerList[0]); AddPower = base.GetPower(PowerList[1]); UpdatePower = base.GetPower(PowerList[2]); base.AllowHttpMethod("GET"); base.DisableTop(true); base.BodyClass = "class='bodybg'"; }
protected void Page_Load(object sender, EventArgs e) { NewPower = base.AddPower(NewPower); base.AllowHttpMethod("GET", "POST"); base.DisableTop(true); UserVM user = AuthServer.GetLoginUser(); OrgName = string.Format("{0}", user.OrgName); }
protected void Page_Load(object sender, EventArgs e) { NewPower = base.AddPower(NewPower); base.AllowHttpMethod("GET", "POST"); base.DisableTop(false); UserVM user = AuthServer.GetLoginUser(); if (this.IsPostBack == false) { if (SystemCode.dict.ContainsKey("StockManagementM_UseType")) { List <SystemCodeVM> SystemCodeList = SystemCode.dict["StockManagementM_UseType"]; foreach (SystemCodeVM sc in SystemCodeList) { UseType.Items.Add(new ListItem(sc.EnumName, sc.EnumValue.ToString())); } } int VaccUseBatchDataID; HttpUtility.HtmlEncode(int.TryParse(Request.QueryString["VaccUseBatchDataID"], out VaccUseBatchDataID)); DataSet ds = new DataSet(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("usp_VaccineUse_xGetVaccineUseBatchData", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", VaccUseBatchDataID); cmd.Parameters.AddWithValue("@OrgID", user.OrgID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(ds); } } } DataTable dt = ds.Tables[0]; DataTable dt1 = ds.Tables[1]; if (dt.Rows.Count > 0) { VaccineID.Text = dt.Rows[0]["VaccineID"].ToString(); BatchType.Text = dt.Rows[0]["BatchType"].ToString(); BatchID.Text = dt.Rows[0]["BatchID"].ToString(); FormDrug.Text = dt.Rows[0]["FormDrug"].ToString(); Storage.Text = dt.Rows[0]["Storage"].ToString(); } if (dt1.Rows.Count > 0) { Num.Text = dt1.Rows[0]["Num"].ToString(); UseType.SelectedValue = dt1.Rows[0]["UseType"].ToString(); } } }
protected new void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("GET"); base.DisableTop(true); SearchPower = base.GetPower(PowerList[0]); PrintPower = base.GetPower(PowerList[1]); //Page.DataBind(); var user = AuthServer.GetLoginUser(); UC_OpenSelectSingleOrg.PageUrl = "/System/AccountM/AccountCheck.aspx"; UC_OpenSelectSingleOrg.DefaultID = user.OrgID; UC_OpenSelectSingleOrg.DefaultName = user.OrgName; DefaultOrgID = user.OrgID; DefaultOrgName = user.OrgName; UC_OpenSelectAgency.PageUrl = "/Vaccination/ParameterM/LocationSetting.aspx"; UC_OpenSelectAgency.hasFilter = true; UC_OpenSelectAgency.agencyState = 2; //UC_OpenSelectAgency.SetID(user.OrgID); //UC_OpenSelectAgency.SetName(user.OrgName); //UC_OpenSelectAgency1.PageUrl = "/Vaccination/ParameterM/LocationSetting.aspx"; //UC_OpenSelectAgency2.PageUrl = "/Vaccination/ParameterM/LocationSetting.aspx"; //UC_OpenSelectAgency2.Suffix = "2"; //UC_OpenSelectSingleOrg.PageUrl = "/Vaccination/ParameterM/LocationSetting.aspx"; //UC_OpenSelectSingleOrg1.PageUrl = "/Vaccination/ParameterM/LocationSetting.aspx"; //UC_OpenSelectSingleOrg1.Suffix = "2"; if (SystemCode.dict.ContainsKey("ParameterM_LocationSetting_AgencyState")) { var codes = SystemCode.dict["ParameterM_LocationSetting_AgencyState"]; codes.RemoveAll(item => item.EnumName.Length == 0); if (codes.Count() > 0) { AgStateJson = JsonConvert.SerializeObject(codes); } } //PageCL CL = new PageCL(); //tbData = CL.GetList(new List<AgencyInfoVM>(), "ConnDB", "dbo.usp_ParameterM_xGetAgencyListByMany", // new Dictionary<string, object>() // { // { "@OrgID", 0 }, // { "@AgencyCounty", 0 }, // { "@AgencyTown", 0 }, // { "@AgencyVillage", 0 }, // { "@AgencyState", 0 }, // { "@AgencyName", "" }, // { "@pgNow", 1 }, // { "@pgSize", 10 } // }); }
protected void Page_Load(object sender, EventArgs e) { NewPower = base.AddPower(NewPower); base.AllowHttpMethod("GET", "POST"); base.DisableTop(true); if (SystemCode.dict.ContainsKey("StockManagementM_DealStatus")) { DealStatus = JsonConvert.SerializeObject(SystemCode.dict["StockManagementM_DealStatus"].Where(item => item.EnumName != null)); } }
protected MyPowerVM AddPower(string pageUrl, MyPowerEnum myPowerEnum) { MyPowerVM VM = new MyPowerVM(pageUrl, myPowerEnum); if (dict.ContainsKey(VM) == false) { dict.Add(VM, VM); } return(VM); }
protected MyPowerVM GetPower(MyPowerVM VM) { if (dict.ContainsKey(VM) == false) { return(dict[VM]); } else { return(VM); } }
protected void Page_Load(object sender, EventArgs e) { ModeifyPower = base.AddPower(list[0]); SearchPower = base.AddPower(list[1]); base.AllowHttpMethod("GET", "POST"); base.DisableTop(true); if (SystemCode.dict.ContainsKey("VaccineM_VaccineStatus")) { VaccineStatus = JsonConvert.SerializeObject(SystemCode.dict["VaccineM_VaccineStatus"].Where(item => item.EnumName != null)); } }
protected void Page_Load(object sender, EventArgs e) { NewPower = base.AddPower(list[0]); SearchPower = base.AddPower(list[1]); base.AllowHttpMethod("GET", "POST"); base.DisableTop(true); if (SystemCode.dict.ContainsKey("FrequentlyAskedQuestionM_QAMaintenanceQATypeStatus")) { TypeStatus = JsonConvert.SerializeObject(SystemCode.dict["FrequentlyAskedQuestionM_QAMaintenanceQATypeStatus"].Where(item => item.EnumName != null)); } }