protected void Page_Load(object sender, EventArgs e) { ViewPower = base.GetPower(PowerList[0]); UpdatePower = base.GetPower(PowerList[1]); base.AllowHttpMethod("GET", "POST"); base.DisableTop(true); base.BodyClass = "class='bodybg'"; int.TryParse(Request["i"], out ID); if (ID == 0) { string script = "<script>alert('資料取得失敗');history.go(-1);</script>"; Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); return; } if (UpdatePower.HasPower == false) { tbAddress.Enabled = false; tbTel.Enabled = false; tbVaccine.Enabled = false; ddAgState.Enabled = false; //tbDepartment.Enabled = false; } if (this.IsPostBack == false) { DataSet ds = new DataSet(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_ParameterM_xGetAgencyByID", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@AgencyInfoID", ID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(ds); } } } AgencyInfoVM VM = new AgencyInfoVM(); List <AddVaccineVM> list = new List <AddVaccineVM>(); EntityS.FillModel(VM, ds.Tables[0]); EntityS.FillModel(list, ds.Tables[1]); var dict = SystemCode.GetDict("LocationSettingM_Divisions"); StateListAry = JsonConvert.SerializeObject(dict); var codes = SystemCode.dict["ParameterM_LocationSetting_AgencyState"]; ddAgState.Items.Add(new ListItem("請選擇", "0")); foreach (var item in codes) { ddAgState.Items.Add(new ListItem(item.EnumName, item.EnumValue.ToString())); } ddAgState.SelectedValue = VM.AgencyState.ToString(); lblBsState.Text = VM.BusinessStateString; //tbDepartment.Text = VM.Department; County = VM.AgencyCounty; Town = VM.AgencyTown; Village = VM.AgencyVillage; tbAddress.Text = VM.AgencyAddress; tbTel.Text = VM.AgencyPhoneNumber; tbSchedule.Text = VM.InoculationSchedule; lblName.Text = VM.AgencyName; lblCode.Text = VM.AgencyCode; tbOrg.Text = VM.OrgName; hfOrgID.Value = VM.OrgID.ToString(); //tbDepartment.Text = VM.Department; tbVaccine.Text = string.Join(",", list.Select(item => item.VaccineCName)); tbOther = VM.DepartmentOther; switch (VM.ReportingType) { case 1: rb1.Checked = true; break; case 2: rb2.Checked = true; break; case 3: rb3.Checked = true; break; } if (VM.IsSimpleFlu == false) { rbB1.Checked = true; } else { rbB2.Checked = true; } tbOtherIDs = VM.DepartmentIDs; CountyJson = JsonConvert.SerializeObject(SystemAreaCode.GetCountyList()); TownJson = JsonConvert.SerializeObject(SystemAreaCode.GetTownList(County)); VillageJson = JsonConvert.SerializeObject(SystemAreaCode.GetVillageList(Town)); } }
protected new void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("POST"); base.DisableTop(true); ViewPower = base.GetPower(PowerList[0]); UpdatePower = base.GetPower(PowerList[1]); //if (UpdatePower.HasPower) //{ // form1.DefaultButton = "btnSave"; //} ID = GetNumber <int>("i"); ContractID = GetNumber <int>("i2"); if (ID == 0) { IsValid = false; string script = "<script>alert('資料取得失敗');history.go(-1);</script>"; Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); return; } if (UpdatePower.HasPower == false) { tbAddress.Enabled = false; tbTel.Enabled = false; tbVaccine.Enabled = false; ddlAgState.Enabled = false; //tbDepartment.Enabled = false; } if (this.IsPostBack == false) { uc1.TableName = "O_OrgLog"; uc1.WhereDict = new Dictionary <string, object>() { { "@OrgID", ID } }; DataSet ds = MSDB.GetDataSet("ConnDB", "dbo.usp_ParameterM_xGetAgencyByID" , new Dictionary <string, object>() { { "@AgencyInfoID", ID } }); AgencyInfoVM VM = new AgencyInfoVM(); List <AddVaccineVM> list = new List <AddVaccineVM>(); OrgContractVM VM2 = new OrgContractVM(); List <DayTimeVM> ddListIn = new List <DayTimeVM>(); List <DayTimeVM> ddListOut = new List <DayTimeVM>(); EntityS.FillModel(VM, ds.Tables[0]); EntityS.FillModel(list, ds.Tables[1]); EntityS.FillModel(VM2, ds.Tables[2]); EntityS.FillModel(ddListIn, ds.Tables[3]); foreach (var item in ddListIn) { DayTimeVM inVM = new DayTimeVM(); inVM.ID = item.ID; inVM.Monday = item.Monday; inVM.Tuesday = item.Tuesday; inVM.Wednesday = item.Wednesday; inVM.Thursday = item.Thursday; inVM.Friday = item.Friday; inVM.Saturday = item.Saturday; inVM.Sunday = item.Sunday; inVM.TimeAry = new List <Dictionary <string, string> >(); foreach (DataRow dr in ds.Tables[4].Rows) { if (item.ID == Convert.ToInt32(dr["BusinesssDayID"].ToString())) { Dictionary <string, string> ssee = new Dictionary <string, string>(); ssee.Add("ss", dr["StartTime"].ToString().Substring(0, 5)); ssee.Add("ee", dr["StartTime"].ToString().Substring(0, 5)); inVM.TimeAry.Add(ssee); } } ddListOut.Add(inVM); } if (ddListOut.Count > 0) { ddListOutAry = JsonConvert.SerializeObject(ddListOut); } if (VM2.ID > 0) { ContractID = VM2.ID; tbDateStart.Text = VM2.ContractStart.ToShortTaiwanDate(); tbDateEnd.Text = VM2.ContractEnd.ToShortTaiwanDate(); tbDateStop.Text = VM2.ContractStop.ToShortTaiwanDate(); if (tbDateStart.Text.Length == 0) { tbDateStart.Text = DateTime.Now.ToShortTaiwanDate(); } } var dict = SystemCode.GetDict("LocationSettingM_Divisions"); StateListAry = JsonConvert.SerializeObject(dict); var codes = SystemCode.dict["ParameterM_LocationSetting_AgencyState"]; ddlAgState.Items.Add(new ListItem("請選擇", "")); foreach (var item in codes) { ddlAgState.Items.Add(new ListItem(item.EnumName, item.EnumValue.ToString())); } ddlAgState.SelectedValue = VM.AgencyState.ToString(); AgencyState = VM.AgencyState.ToString(); lblBsState.Text = VM.BusinessStateString; //tbDepartment.Text = VM.Department; County = VM.AgencyCounty; Town = VM.AgencyTown; Village = VM.AgencyVillage; CountyName = SystemAreaCode.GetName(VM.AgencyCounty); TownName = SystemAreaCode.GetName(VM.AgencyTown); VillageName = SystemAreaCode.GetName(VM.AgencyVillage); tbAddress.Text = VM.AgencyAddress; tbTelZone.Text = VM.PhoneAreaCode; tbTel.Text = VM.AgencyPhoneNumber; tbSchedule.Text = VM.InoculationSchedule; ddlAgencyCate.SelectedValue = VM.AgencyCate.ToString(); lblName.Text = VM.AgencyName; lblCode.Text = VM.AgencyCode; tbOrg.Text = VM.OrgName; hfOrgID.Value = VM.OrgID.ToString(); //tbDepartment.Text = VM.Department; tbVaccine.Text = string.Join(",", list.Select(item => item.VaccineCName)); tbOther = VM.DepartmentOther; switch (VM.ReportingType) { case 1: rb1.Checked = true; break; case 2: rb2.Checked = true; break; case 3: rb3.Checked = true; break; case 4: rb4.Checked = true; break; } if (VM.IsSimpleFlu == false) { rbB1.Checked = true; } else { rbB2.Checked = true; } tbOtherIDs = VM.DepartmentIDs; CountyJson = JsonConvert.SerializeObject(SystemAreaCode.GetCountyList()); TownJson = JsonConvert.SerializeObject(SystemAreaCode.GetTownList(County)); VillageJson = JsonConvert.SerializeObject(SystemAreaCode.GetVillageList(Town)); } }