private string GetMenu() { List <ModuleMenuVM> list = new List <ModuleMenuVM>(); DataTable dt = GetDataTable("ConnUser", "dbo.usp_SystemM_xGetModuleMenu" , new Dictionary <string, object>() { { "@UserID", 1 }, { "@ModuleCateID", RoleCateID } }); EntityS.FillModel(list, dt); return(JsonConvert.SerializeObject(list)); }
protected void Page_Load(object sender, EventArgs e) { //base.AllowHttpMethod("POST"); int pgNow; int pgSize; int.TryParse(Request.Form["ac"], out AgencyCounty); int.TryParse(Request.Form["at"], out AgencyTown); int.TryParse(Request.Form["av"], out AgencyVillage); int.TryParse(Request.Form["as"], out AgencyState); int.TryParse(Request.Form["pgNow"], out pgNow); int.TryParse(Request.Form["pgSize"], out pgSize); AgencyName = Request.Form["an"] ?? ""; DataSet ds = new DataSet(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_ParameterM_xGetAgencyListByMany", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@AgencyCounty", AgencyCounty); cmd.Parameters.AddWithValue("@AgencyTown", AgencyTown); cmd.Parameters.AddWithValue("@AgencyVillage", AgencyVillage); cmd.Parameters.AddWithValue("@AgencyState", AgencyState); cmd.Parameters.AddWithValue("@AgencyName", AgencyName); 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(); }
private string GetMenu(UserVM user) { //ModuleMenuVM lastNode = null; List <ModuleMenuVM> list = new List <ModuleMenuVM>(); //List<ModuleMenuVM> Rtn = new List<ModuleMenuVM>(); int ModuleCateID = 1; if (WebConfigurationManager.AppSettings["ModuleCateID"] != null) { ModuleCateID = Convert.ToInt32(WebConfigurationManager.AppSettings["ModuleCateID"]); } DataTable dt = MSDB.GetDataTable("ConnUser", "dbo.usp_SystemM_xGetModuleMenu" , new Dictionary <string, object>() { { "@UserID", user.ID }, { "@ModuleCateID", ModuleCateID } }); EntityS.FillModel(list, dt); //foreach (ModuleMenuVM item in list) //{ // if (item.PID == 0) // { // Rtn.Add(item); // lastNode = item; // } // else // { // if (lastNode != null) // { // if (lastNode.ID == item.PID) // { // lastNode.children.Add(item); // } // else // { // GenMenuRecursive(item, lastNode); // } // } // } //} //return JsonConvert.SerializeObject(Rtn); return(JsonConvert.SerializeObject(list)); }
protected void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("POST"); base.DisableTop(true); base.BodyClass = "class='bodybg'"; int pgNow = 0; int pgSize = 0; int OrgID = 0; int StatisticalYearStart = 0; int StatisticalYearEnd = 0; int.TryParse(Request.Form["lid"], out OrgID); int.TryParse(Request.Form["s"], out StatisticalYearStart); int.TryParse(Request.Form["e"], out StatisticalYearEnd); 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_RecordM_xGetBCGRecordListByMany", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@OrgID", OrgID); cmd.Parameters.AddWithValue("@StatisticalYearStart", StatisticalYearStart); cmd.Parameters.AddWithValue("@StatisticalYearEnd", StatisticalYearEnd); 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 <BCGRecordVM> list = new List <BCGRecordVM>(); 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 void Page_Load(object sender, EventArgs e) { int pgNow; int pgSize = 5; string BirthDateS; string BirthDateE; int SearchKind; int OrgID = 0; BirthDateS = Request.Form["BirthDateS"] ?? ""; BirthDateE = Request.Form["BirthDateE"] ?? ""; if (BirthDateS != "") { BirthDateS = (Convert.ToInt32(BirthDateS.Substring(0, 3)) + 1911).ToString() + "/" + BirthDateS.Substring(3, 2) + "/" + BirthDateS.Substring(5, 2); } if (BirthDateE != "") { BirthDateE = (Convert.ToInt32(BirthDateE.Substring(0, 3)) + 1911).ToString() + "/" + BirthDateE.Substring(3, 2) + "/" + BirthDateE.Substring(5, 2); } int.TryParse(Request.Form["pgNow"], out pgNow); int.TryParse(Request.Form["SearchKind"], out SearchKind); int.TryParse(Request.Form["OrgID"], out OrgID); DataTableCollection dtc = (DataTableCollection)DBUtil.DBOp("ConnDB" , "exec dbo.usp_CaseUser_xGetMergeUserList {0},{1},{2},{3},{4},{5} " , new string[] { pgNow.ToString() , pgSize.ToString() , BirthDateS , BirthDateE , OrgID.ToString() , SearchKind.ToString() }, NSDBUtil.CmdOpType.ExecuteReaderReturnDataTableCollection); List <MergeCheckListVM> list = new List <MergeCheckListVM>(); PageVM rtn = new PageVM(); EntityS.FillModel(list, dtc[0]); EntityS.FillModel(rtn, dtc[1]); rtn.message = list; Response.ContentType = "application/json; charset=utf-8"; Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rtn)); Response.End(); }
protected void Page_Load(object sender, EventArgs e) { SearchPower = base.AddPower(SearchPower); int pgNow; int pgSize; int QuestionType = 0; string Question = ""; int QAViewDateStatus = 0; int.TryParse(Request.Form["pgNow"], out pgNow); int.TryParse(Request.Form["pgSize"], out pgSize); if (SearchPower.HasPower == true) { int.TryParse(Request.Form["QuestionType"], out QuestionType); Question = Request.Form["Question"]; int.TryParse(Request.Form["QAViewDateStatus"], out QAViewDateStatus); } DataSet ds = new DataSet(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("usp_QAView_xSearchTable", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@pgNow", pgNow); cmd.Parameters.AddWithValue("@pgSize", pgSize); cmd.Parameters.AddWithValue("@QaType", QuestionType); cmd.Parameters.AddWithValue("@Question", Question); cmd.Parameters.AddWithValue("@QAViewDateStatus", QAViewDateStatus); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(ds); } } } List <QnADataVM> list = new List <QnADataVM>(); 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(); }
private string GetMenu(UserVM user) { ModuleMenuVM lastNode = null; List <ModuleMenuVM> list = new List <ModuleMenuVM>(); List <ModuleMenuVM> Rtn = new List <ModuleMenuVM>(); DataTable dt = new DataTable(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnUser"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_SystemM_xGetModuleMenu", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserID", user.ID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(dt); } } } EntityS.FillModel(list, dt); foreach (ModuleMenuVM item in list) { if (item.PID == 0) { Rtn.Add(item); lastNode = item; } else { if (lastNode != null) { if (lastNode.ID == item.PID) { lastNode.Children.Add(item); } else { GenMenuRecursive(item, lastNode); } } } } return(JsonConvert.SerializeObject(Rtn)); }
protected new void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("GET", "POST"); base.DisableTop(false); user = AuthServer.GetLoginUser(); if (Request.HttpMethod.Equals("POST")) { ID = GetNumber <int>("c"); FluNotesID = GetNumber <int>("i"); if (ID == 0 && FluNotesID == 0) { IsValid = false; string script = "<style>body{display:none;}</style><script>alert('資料取得失敗');window.close();</script>"; Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); return; } if (this.IsPostBack == false) { if (FluNotesID == 0) { tbDate.Text = DateTime.Now.ToShortTaiwanDate(); } else { DataTable dt = MSDB.GetDataTable("ConnDB", "dbo.usp_RecordM_xGetFluNotesByID" , new Dictionary <string, object>() { { "@FluNotesID", FluNotesID } }); RegisterFluNotesVM VM = new RegisterFluNotesVM(); EntityS.FillModel(VM, dt); tbDate.Text = VM.InoculationDate.ToShortTaiwanDate(); } } } else { Response.Write(""); Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { //base.AllowHttpMethod("POST"); int pgNow; int pgSize; string NameOrIdNo; NameOrIdNo = Request.Form["NameOrIdNo"] ?? ""; 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_CaseUser_xGetConcactList", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@pgNow", pgNow == 0 ? 1 : pgNow); cmd.Parameters.AddWithValue("@pgSize", pgSize == 0 ? 10 : pgSize); cmd.Parameters.AddWithValue("@NameOrIdNo", NameOrIdNo); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(ds); } } } List <UserProfileListVM> list = new List <UserProfileListVM>(); 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(); }
public static void Update() { List <SystemAreaCodeVM> list = new List <SystemAreaCodeVM>(); DataTable dt = new DataTable(); SqlCommand cmd = new SqlCommand("dbo.usp_CodeM_xGetSystemAreaCode"); cmd.CommandType = CommandType.StoredProcedure; dt = DB.GetDataTable(cmd, "ConnDB"); EntityS.FillModel(list, dt); SystemAreaCode.dict = list.OrderBy(item => item.OrderNumber) .GroupBy(item => item.CodeKey) .ToDictionary(IGrouping => IGrouping.Key, IGrouping => IGrouping.ToList()); dt.Dispose(); }
protected void Page_Load(object sender, EventArgs e) { int pgNow = 1; int pgSize = 10; string NameOrIdNo = Request.Form["NameOrIdNo"] ?? ""; int.TryParse(Request.Form["pgNow"], out pgNow); int.TryParse(Request.Form["pgSize"], out pgSize); pgNow = (pgNow == 0 ? 1 : pgNow); pgSize = (pgSize == 0 ? 10 : pgSize); string SearchName = ""; string SearchIdNo = ""; string SearchResNo = ""; if (NumberValidate.IsIdNo(NameOrIdNo) || (NameOrIdNo.StartsWith("99") && NameOrIdNo.Length == 10)) { SearchIdNo = NameOrIdNo; } else if (NumberValidate.IsResNo(NameOrIdNo)) { SearchResNo = NameOrIdNo; } else { SearchName = NameOrIdNo; } DataTableCollection dtc = (DataTableCollection)DBUtil.DBOp("ConnDB" , " exec dbo.usp_CaseUser_xGetContactList {0},{1},{2},{3},{4} " , new string[] { pgNow.ToString(), pgSize.ToString(), SearchName, SearchIdNo, SearchResNo } , NSDBUtil.CmdOpType.ExecuteReaderReturnDataTableCollection); List <UserProfileListVM> list = new List <UserProfileListVM>(); PageVM rtn = new PageVM(); EntityS.FillModel(list, dtc[0]); EntityS.FillModel(rtn, dtc[1]); rtn.message = list; Response.ContentType = "application/json; charset=utf-8"; Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rtn)); Response.End(); }
protected void Page_Load(object sender, EventArgs e) { SearchPower = base.AddPower(SearchPower); UserVM user = AuthServer.GetLoginUser(); int pgNow; int pgSize; int VaccineID = 0; int.TryParse(Request.Form["pgNow"], out pgNow); int.TryParse(Request.Form["pgSize"], out pgSize); if (SearchPower.HasPower == true) { int.TryParse(Request.Form["VaccineID"], out VaccineID); } DataSet ds = new DataSet(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("usp_StockQuery_xSearchTable", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@pgNow", pgNow); cmd.Parameters.AddWithValue("@pgSize", pgSize); cmd.Parameters.AddWithValue("@OrgID", user.OrgID); cmd.Parameters.AddWithValue("@VaccineID", VaccineID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(ds); } } } List <StockQueryVM> list = new List <StockQueryVM>(); 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 void Page_Load(object sender, EventArgs e) { int pgNow = GetNumber <int>("pgNow"); int pgSize = GetNumber <int>("pgSize"); string StartDate = ""; string EndDate = ""; string Status = ""; StartDate = GetString("StartDate"); EndDate = GetString("EndDate"); Status = GetString("Status"); Status = Status.Equals("2") ? "" : Status; DataSet ds = new DataSet(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("usp_ImportMaster_xImmiSearchTable", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@pgNow", pgNow); cmd.Parameters.AddWithValue("@pgSize", pgSize); cmd.Parameters.AddWithValue("@StartDate", StartDate); cmd.Parameters.AddWithValue("@EndDate", EndDate); cmd.Parameters.AddWithValue("@CatID", 9); cmd.Parameters.AddWithValue("@IsSuccess", Status); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(ds); } } } List <ImportMasterVM> list = new List <ImportMasterVM>(); 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 void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("GET", "POST"); base.DisableTop(false); base.BodyClass = "class='bodybg'"; if (Request.HttpMethod.Equals("POST")) { int.TryParse(Request.Form["c"], out CaseUserID); DataTable dt = new DataTable(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_RecordM_xGetVaccineList", sc)) { cmd.CommandType = CommandType.StoredProcedure; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(dt); } } } List <string> VaccineList = (Request.Form["a"] ?? "").Split(',').ToList(); List <AddVaccineVM> list = new List <AddVaccineVM>(); EntityS.FillModel(list, dt); //var listLookup = list.ToLookup(item => item.VaccineID); var listDiff = list.Where(item => (VaccineList.Contains(item.VaccineID) == false)); if (list.Count > 0) { tbAry = JsonConvert.SerializeObject(listDiff); } } else { Response.Write(""); Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("POST"); base.DisableTop(true); base.BodyClass = "class='bodybg'"; int.TryParse(Request.Form["i"], out VaccineID); if (VaccineID == 0) { string script = "<script>alert('資料取得失敗');history.go(-1);</script>"; Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); return; } DataTable dt = new DataTable(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_ParameterM_xGetDefaultBatchByVaccineDataID", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@VaccineDataID", VaccineID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(dt); } } } List <BatchSettingVM> list = new List <BatchSettingVM>(); EntityS.FillModel(list, dt); Response.ContentType = "application/json; charset=utf-8"; Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(list)); Response.End(); }
public string GetList <T>(List <T> list, string Conn, string SQL, Dictionary <string, object> dict) { DataSet ds = MSDB.GetDataSet(Conn, SQL , dict); PageVM rtn = new PageVM(); EntityS.FillModel(list, ds.Tables[0]); EntityS.FillModel(rtn, ds.Tables[1]); if (list.Count > 0) { rtn.message = list; } else { rtn.message = new List <string>(); } return(JsonConvert.SerializeObject(rtn)); }
protected void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("GET", "POST"); base.DisableTop(true); base.BodyClass = "class='bodybg'"; user = AuthServer.GetLoginUser(); if (this.IsPostBack == false) { DataTable dt = new DataTable(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_RecordM_xGetCertificateSignByOrgID", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@OrgID", user.OrgID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(dt); } } } if (dt.Rows.Count > 0) { CertificateSignVM VM = new CertificateSignVM(); EntityS.FillModel(VM, dt); tbP.Text = VM.PhysicianSignature; tbE.Text = VM.EnglishFullTitle; tbC.Text = VM.ChineseFullTitle; tbD.Text = VM.UnitDirector; tbS.Text = VM.UnitStamp; tbLocation.Text = VM.OrgName; hfLocationID.Value = VM.OrgID.ToString(); } } }
protected void Page_Load(object sender, EventArgs e) { int CheckID; int.TryParse(Request.Form["CheckID"], out CheckID); DataSet ds = new DataSet(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("usp_QnAData_xGetQnAData", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", CheckID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(ds); } } } List <QnADataVM> list = new List <QnADataVM>(); List <CreateInfoVM> list1 = new List <CreateInfoVM>(); List <ModifyInfoVM> list2 = new List <ModifyInfoVM>(); List <DocumentFileVM> list3 = new List <DocumentFileVM>(); HasFileDataVM rtn = new HasFileDataVM(); EntityS.FillModel(list, ds.Tables[0]); EntityS.FillModel(list1, ds.Tables[1]); EntityS.FillModel(list2, ds.Tables[2]); EntityS.FillModel(list3, ds.Tables[3]); rtn.Datalist = list; rtn.CreateInfo = list1; rtn.ModifyInfo = list2; rtn.Filelist = list3; Response.ContentType = "application/json; charset=utf-8"; Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rtn)); Response.End(); }
protected void Page_Load(object sender, EventArgs e) { NewPower = base.AddPower(list[0]); UploadPower = base.AddPower(list[1]); base.AllowHttpMethod("GET", "POST"); base.DisableTop(true); if (this.IsPostBack == false) { ReleaseDate.Text = DateTime.Now.ToShortTaiwanDate(); ReleaseDate.Enabled = false; QnAType.PostBackUrl = "/System/FrequentlyAskedQuestionM/QnAData/New_QnAType.aspx?PageView=add1"; QnAType.Text = "新增類別"; 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); } } } List <SystemCodeVM> TableList = new List <SystemCodeVM>(); EntityS.FillModel(TableList, ds.Tables[0]); if (ds.Tables.Count > 0) { List <SystemCodeVM> SystemCodeList = TableList; foreach (SystemCodeVM sc in SystemCodeList) { QuestionType.Items.Add(new ListItem(sc.EnumName, sc.EnumValue.ToString())); } } PublishedStatus1.Checked = true; } }
protected void Page_Load(object sender, EventArgs e) { UserVM user = AuthServer.GetLoginUser(); MyLevel = SystemOrg.GetVM(user.OrgID).OrgLevel; DataTable dt = new DataTable(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnUser"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_PowerM_xGetOrgByOrgID", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@OrgID", user.OrgID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(dt); } } } List <SystemOrgVM> list = new List <SystemOrgVM>(); EntityS.FillModel(list, dt); if (Convert.ToInt32(WebConfigurationManager.AppSettings["OrgAreaSet"]) == 0) { OrgArea = false; list.RemoveAll(item => item.OrgLevel == 2); for (var i = 0; i < list.Count; i++) { if (list[i].OrgLevel == 3) { list[i].PID = 1; } } } MyTreeData = JsonConvert.SerializeObject(list.Where(item => item.OrgCateID == Convert.ToInt32(WebConfigurationManager.AppSettings["OrgCateID"]))); }
protected new void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("POST"); base.DisableTop(true); UpdatePower = base.GetPower(list[1]); CateID = GetNumber <int>("ci"); ID = GetNumber <int>("i"); if (ID == 0 || CateID == 0) { IsValid = false; string script = "<style>body{display:none;}</style><script>alert('資料取得失敗');history.go(-1);</script>"; Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); return; } if (this.IsPostBack == false) { DataTable dt = MSDB.GetDataTable("ConnDB", "dbo.usp_CodeM_xGetSystemCodeByID" , new Dictionary <string, object>() { { "@SystemCodeID", ID } }); EntityS.FillModel(VM, dt); lblCate.Text = VM.CodeDescription; lblValue.Text = VM.EnumValue.ToString(); tbName.Text = VM.EnumName; if (VM.IsEnabled) { rb1.Checked = true; } else { rb2.Checked = true; } } }
protected new void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("POST"); base.DisableTop(true); OrgID = GetNumber <int>("o"); DataTable dt = MSDB.GetDataTable("ConnDB", "dbo.usp_CertificateM_xGetCertificateSignByOrgID" , new Dictionary <string, object>() { { "@OrgID", OrgID } }); CertificateSignVM VM = new CertificateSignVM(); EntityS.FillModel(VM, dt); VM.OrgID = OrgID; Response.ContentType = "application/json; charset=utf-8"; Response.Write(JsonConvert.SerializeObject(VM)); Response.End(); }
public static void Update() { DataTable dt = new DataTable(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnUser"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_PowerM_xGetAllRole", sc)) { cmd.CommandType = CommandType.StoredProcedure; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(dt); } } } AllList = new List <SystemRoleVM>(); EntityS.FillModel(AllList, dt); SystemRole.list = AllList.Where(item => item.RoleCateID == Convert.ToInt32(WebConfigurationManager.AppSettings["RoleCateID"])).ToList(); }
protected void Page_Load(object sender, EventArgs e) { //base.AllowHttpMethod("POST"); int pgNow; int pgSize; int CapacityID = 1; int CaseID = 0; int.TryParse(Request.Form["pgNow"], out pgNow); int.TryParse(Request.Form["pgSize"], out pgSize); int.TryParse(Request.Form["CapacityID"], out CapacityID); int.TryParse(Request.Form["CaseID"], out CaseID); pgNow = (pgNow == 0 ? 1 : pgNow); pgSize = (pgSize == 0 ? 10 : pgSize); //Response.Write(pgNow.ToString()); //Response.Write(pgSize.ToString()); //Response.Write(CaseID.ToString()); //Response.Write(CapacityID.ToString()); DataTableCollection dtc = (DataTableCollection)DBUtil.DBOp("ConnDB" , " exec dbo.usp_CaseUser_xGetCapacityModifyLog {0},{1},{2},{3}" , new string[] { pgNow.ToString(), pgSize.ToString(), CaseID.ToString(), CapacityID.ToString() } , NSDBUtil.CmdOpType.ExecuteReaderReturnDataTableCollection); List <CapacityModifyLogVM> list = new List <CapacityModifyLogVM>(); PageVM rtn = new PageVM(); EntityS.FillModel(list, dtc[0]); EntityS.FillModel(rtn, dtc[1]); rtn.message = list; Response.ContentType = "application/json; charset=utf-8"; Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rtn)); Response.End(); }
public static void Update(int OrgID) { DataTable dt = new DataTable(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnUser"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_PowerM_xGetOrgByOrgID", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@OrgID", OrgID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(dt); } } } List <SystemOrgVM> list = new List <SystemOrgVM>(); EntityS.FillModel(list, dt); if (Convert.ToInt32(WebConfigurationManager.AppSettings["OrgAreaSet"]) == 0) { list.RemoveAll(item => item.OrgLevel == 2); for (var i = 0; i < list.Count; i++) { if (list[i].OrgLevel == 3) { list[i].PID = 1; } } } SystemOrgByOrgID.list = list; if (list.Count > 0) { SystemOrgByOrgID.JsonList = JsonConvert.SerializeObject(list.Where(item => item.OrgCateID == Convert.ToInt32(WebConfigurationManager.AppSettings["OrgCateID"]))); } }
public static void Update() { DataTable dt = new DataTable(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnUser"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_PowerM_xGetAllOrg", sc)) { cmd.CommandType = CommandType.StoredProcedure; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(dt); } } } AllList = new List <SystemOrgVM>(); EntityS.FillModel(AllList, dt); SystemOrg.list = AllList.Where(item => item.OrgCateID == Convert.ToInt32(WebConfigurationManager.AppSettings["OrgCateID"])).ToList(); if (Convert.ToInt32(WebConfigurationManager.AppSettings["OrgAreaSet"]) == 0) { SystemOrg.list.RemoveAll(item => item.OrgLevel == 2); for (var i = 0; i < SystemOrg.list.Count; i++) { if (SystemOrg.list[i].OrgLevel == 3) { SystemOrg.list[i].PID = 1; } } } ZoneList = list.Where(item => item.OrgLevel < 5).ToList(); if (SystemOrg.list.Count > 0) { SystemOrg.JsonList = JsonConvert.SerializeObject(ZoneList); } }
protected void Page_Load(object sender, EventArgs e) { UserVM user = AuthServer.GetLoginUser(); string PageType; int ID; int SelectID; PageType = Request.Form["Page"]; int.TryParse(Request.Form["ID"], out ID); int.TryParse(Request.Form["SelectID"], out SelectID); DataSet ds = new DataSet(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("usp_StockManagementM_xGetVaccineBatch", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PageType", PageType); cmd.Parameters.AddWithValue("@DataID", ID); cmd.Parameters.AddWithValue("@VaccID", SelectID); cmd.Parameters.AddWithValue("@OrgID", user.OrgID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(ds); } } } List <ChooseVaccineBatchVM> list = new List <ChooseVaccineBatchVM>(); 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 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"); DataSet ds = MSDB.GetDataSet("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 } }); List <SchoolCodeVM> list = new List <SchoolCodeVM>(); 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(); }
protected void Page_Load(object sender, EventArgs e) { //base.AllowHttpMethod("POST"); //base.DisableTop(true); int pgNow = 0; int pgSize = 0; int CheckStatus = 0; int.TryParse(Request.Form["pgNow"], out pgNow); int.TryParse(Request.Form["pgSize"], out pgSize); int.TryParse(Request.Form["CheckStatus"], out CheckStatus); pgNow = (pgNow == 0 ? 1 : pgNow); pgSize = (pgSize == 0 ? 10 : pgSize); string FileDateS = Request.Form["FileDateS"] ?? ""; string FileDateE = Request.Form["FileDateE"] ?? ""; DataTableCollection dtc = (DataTableCollection)DBUtil.DBOp("ConnDB" , "exec dbo.usp_Log_xCheckFileList {0},{1},{2},{3},{4} " , new string[] { pgNow.ToString() , pgSize.ToString() , FileDateS , FileDateE , CheckStatus.ToString() }, NSDBUtil.CmdOpType.ExecuteReaderReturnDataTableCollection); List <CheckFileLogListVM> list = new List <CheckFileLogListVM>(); PageVM rtn = new PageVM(); EntityS.FillModel(list, dtc[0]); EntityS.FillModel(rtn, dtc[1]); rtn.message = list; Response.ContentType = "application/json; charset=utf-8"; Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(rtn)); Response.End(); }
protected void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("GET", "POST"); base.DisableTop(false); base.BodyClass = "class='bodybg'"; user = AuthServer.GetLoginUser(); user2 = new UserVM(); if (this.IsPostBack == false) { DataTable dt = new DataTable(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnUser"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_AccountM_xGetUserInfoByID", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserID", user.ID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(dt); } } } EntityS.FillModel(user2, dt); lblAccount.Text = user.LoginName; tbDept.Text = user.RoleName; tbIDF.Text = user2.RocID; tbName.Text = user2.UserName; tbEmail.Text = user2.Email; tbTitle.Text = user2.Title; tbTel.Text = user2.PhoneNumber; } }