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); int.TryParse(Request.Form["i"], out RecordDataID); VaccineCode = Request.Form["r"] ?? ""; AppointmentDate = Request.Form["a"] ?? ""; DateTime date = default(DateTime); bool success = DateTime.TryParse(AppointmentDate, out date); //AppointmentDate = date.ToShortTaiwanDate(); if (success == false || CaseUserID == 0 || RecordDataID == 0) { string script = "<script>alert('資料取得失敗');window.close();</script>"; Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); return; } string SystemRecordVaccineCode = ""; SystemRecordVaccineCode = Request.Form["r"] ?? ""; bool HasInsertSystemRecordVaccine = false; int Chk = 0; if (CaseUserID > 0 || SystemRecordVaccineCode.Equals("") == false) { var user = AuthServer.GetLoginUser(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_RecordM_xAddRecordData", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CaseUserID", CaseUserID); cmd.Parameters.AddWithValue("@SystemRecordVaccineCode", SystemRecordVaccineCode); cmd.Parameters.AddWithValue("@OrgID", user.OrgID); cmd.Parameters.AddWithValue("@CreatedUserID", user.ID); SqlParameter sp1 = cmd.Parameters.AddWithValue("@RecordDataID", RecordDataID); sp1.Direction = ParameterDirection.Output; SqlParameter sp2 = cmd.Parameters.AddWithValue("@HasInsertSystemRecordVaccine", HasInsertSystemRecordVaccine); sp2.Direction = ParameterDirection.Output; SqlParameter sp3 = cmd.Parameters.AddWithValue("@Chk", Chk); sp3.Direction = ParameterDirection.Output; sc.Open(); cmd.ExecuteNonQuery(); RecordDataID = (int)sp1.Value; HasInsertSystemRecordVaccine = (bool)sp2.Value; Chk = (int)sp3.Value; } if (HasInsertSystemRecordVaccine == true) { SystemRecordVaccine.Update(); } if (Chk < 1 || RecordDataID == 0) { string script = "<script>alert('資料取得失敗');window.close();</script>"; Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); return; } } } } else { Response.Write(""); Response.End(); } }
protected void btnSave_Click(object sender, EventArgs e) { string script = ""; string message = CheckNeeded(); if (message.Length > 0) { script = "<script>alert('" + message + "');</script>"; Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); return; } string title = tbTitle.Text.Trim(); string description = tbDesp.Text.Trim(); int state = 0; RadioButton thisRb = null; thisRb = form1.Controls.OfType <RadioButton>().FirstOrDefault(rb => rb.Checked); if (thisRb != null) { switch (thisRb.ID) { case "rb1": state = 1; break; case "rb2": state = 2; break; } } UserVM user = AuthServer.GetLoginUser(); int OutFileInfoID = 0; bool UploadFileSuccess = true; int Chk = 0; List <int> OutFileInfoID_List = new List <int>(); if (tbFile.HasFile == true) { HttpFileCollection multipleFiles = Request.Files; for (int fileCount = 0; fileCount < multipleFiles.Count; fileCount++) { //string fileName = Path.GetFileName(uploadedFile.FileName); //if (uploadedFile.ContentLength > 0) //{ // uploadedFile.SaveAs(Server.MapPath("~/Files/") + fileName); // Label1.Text += fileName + "Saved <BR>"; //} HttpPostedFile uploadedFile = multipleFiles[fileCount]; string extension = ""; //string[] ary = tbFile.FileName.Split('.'); string[] ary = uploadedFile.FileName.Split('.'); if (ary.Length > 1) { extension = ary.Last(); } byte[] fileData = null; using (var binaryReader = new BinaryReader(uploadedFile.InputStream)) { fileData = binaryReader.ReadBytes(uploadedFile.ContentLength); } NIIS_WS.WebServiceSoapClient WS = new NIIS_WS.WebServiceSoapClient(); string contentType = tbFile.PostedFile.ContentType; OutFileInfoID = WS.UploadFile(1, contentType, extension, uploadedFile.FileName, user.ID, user.OrgID, fileData); if (OutFileInfoID < 1) { UploadFileSuccess = false; break; } else { OutFileInfoID_List.Add(OutFileInfoID); } } } string OutFileInfoIDs = string.Join(",", OutFileInfoID_List.Select(x => x.ToString()).ToArray()); if (UploadFileSuccess == true) { using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_DocumentM_xAddDocumentInfo", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DocTitle", title); cmd.Parameters.AddWithValue("@PublishState", state); cmd.Parameters.AddWithValue("@DocDescription", description); cmd.Parameters.AddWithValue("@CreatedUserID", user.ID); //cmd.Parameters.AddWithValue("@FileInfoID", OutFileInfoID); cmd.Parameters.AddWithValue("@FileInfoIDs", OutFileInfoIDs); SqlParameter sp = cmd.Parameters.AddWithValue("@Chk", Chk); sp.Direction = ParameterDirection.Output; sc.Open(); cmd.ExecuteNonQuery(); Chk = (int)sp.Value; } } } if (UploadFileSuccess && Chk > 0) { script = "<script>alert('儲存成功');location.href = '/System/DocumentM/DocumentMaintain.aspx';</script><style>body{display:none;}</style>"; } else { script = "<script>alert('儲存失敗');</script>"; } Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); }
protected void Save_Click(object sender, EventArgs e) { UserVM user = AuthServer.GetLoginUser(); string script = ""; string message = CheckNeeded(); if (message.Length > 0) { script = "<script>alert('" + message + "');</script>"; Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "alert", script, false); return; } int OutFileInfoID = 0; bool UploadFileSuccess = true; List <int> OutFileInfoID_List = new List <int>(); if (TempFile.HasFile == true) { HttpFileCollection multipleFiles = Request.Files; for (int fileCount = 0; fileCount < multipleFiles.Count; fileCount++) { HttpPostedFile uploadedFile = multipleFiles[fileCount]; string extension = ""; string[] ary = uploadedFile.FileName.Split('.'); if (ary.Length > 1) { extension = ary.Last(); } byte[] fileData = null; using (var binaryReader = new BinaryReader(uploadedFile.InputStream)) { fileData = binaryReader.ReadBytes(uploadedFile.ContentLength); } NIIS_WS.WebServiceSoapClient WS = new NIIS_WS.WebServiceSoapClient(); string contentType = TempFile.PostedFile.ContentType; OutFileInfoID = WS.UploadFile(5, contentType, extension, uploadedFile.FileName, user.ID, user.OrgID, fileData); if (OutFileInfoID < 1) { UploadFileSuccess = false; break; } else { OutFileInfoID_List.Add(OutFileInfoID); } } } string OutFileInfoIDs = string.Join(",", OutFileInfoID_List.Select(x => x.ToString()).ToArray()); string dealDate = (Convert.ToInt32(DealDate.Text.Substring(0, 3)) + 1911).ToString() + "/" + DealDate.Text.Substring(3, 2) + "/" + DealDate.Text.Substring(5, 2); int dealType = int.Parse(DealType.SelectedValue); int dealHospitalID = 0; if (dealType == 4) { int.TryParse(DealHospitalID.Value, out dealHospitalID); } string remark = Remark.Text.Trim(); string num = Num.Text.Trim(); string tempHigh = TempHigh.Text.Trim(); int froIdx = int.Parse(FroIdx.SelectedValue); string tempLow = TempLow.Text.Trim(); int oriFroIdx = int.Parse(OriFroIdx.SelectedValue); int monIdx = int.Parse(MonIdx.SelectedValue); int CheckStorage = 0; int Success = 0; int VaccInBatchDataID; HttpUtility.HtmlEncode(int.TryParse(Request.QueryString["BI"], out VaccInBatchDataID)); if (UploadFileSuccess == true) { DataSet ds = new DataSet(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("usp_VaccineIn_xUpdateSearchVaccineInBatchData", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", VaccInBatchDataID); cmd.Parameters.AddWithValue("@Num", num); cmd.Parameters.AddWithValue("@TempHigh", tempHigh); cmd.Parameters.AddWithValue("@FroIdx", froIdx); cmd.Parameters.AddWithValue("@TempLow", tempLow); cmd.Parameters.AddWithValue("@OriFroIdx", oriFroIdx); cmd.Parameters.AddWithValue("@MonIdx", monIdx); cmd.Parameters.AddWithValue("@TempFile", OutFileInfoIDs); cmd.Parameters.AddWithValue("@DealDate", dealDate); cmd.Parameters.AddWithValue("@DealType", dealType); cmd.Parameters.AddWithValue("@DealHospitalID", dealHospitalID); cmd.Parameters.AddWithValue("@Remark", remark); cmd.Parameters.AddWithValue("@ModifyAccount", user.ID); SqlParameter sp = cmd.Parameters.AddWithValue("@CheckStorage", CheckStorage); SqlParameter sp1 = cmd.Parameters.AddWithValue("@Success", Success); sp.Direction = ParameterDirection.Output; sp1.Direction = ParameterDirection.Output; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(ds); CheckStorage = (int)sp.Value; Success = (int)sp1.Value; } } } } if (UploadFileSuccess && Success > 0) { script = "<script>alert('儲存成功!');location.href = '/Vaccine/StockManagementM/VaccineIn/Search_VaccineIn.aspx';</script>"; } else { if (CheckStorage > 0) { script = "<script>alert('庫存量不足!');</script>"; } else { script = "<script>alert('儲存失敗!');</script>"; } } Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "alert", script, false); }
protected void btnSave_Click(object sender, EventArgs e) { if (IsValid == false) { return; } string script = ""; string CaseUserChName = PureString(tbName.Text); string CaseUserEnName = PureString(tbE.Text); string ApplyUserName = PureString(tbA.Text); string UserRelationship = PureString(tbR.Text); var user = AuthServer.GetLoginUser(); int OutFileInfoID = 0; bool UploadFileSuccess = true; List <int> OutFileInfoID_List = new List <int>(); StringBuilder errorSb = new StringBuilder(); string errMsg = ""; if (tbFile.HasFile == true) { List <string> list = new List <string>() { //"application/pdf", "application/msword", "application/vnd.openxmlformats-officedocument.wordprocessingml.document", "application/vnd.ms-excel", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" }; HttpFileCollection multipleFiles = Request.Files; for (int fileCount = 0; fileCount < multipleFiles.Count; fileCount++) { HttpPostedFile uploadedFile = multipleFiles[fileCount]; string extension = ""; string[] ary = uploadedFile.FileName.Split('.'); if (ary.Length > 1) { extension = ary.Last(); } if (list.Contains(uploadedFile.ContentType) == false) { errorSb.Append("alert('上傳格式限WORD、EXCEL');"); } if (uploadedFile.ContentLength > 3 * 1024 * 1024) { errorSb.Append("alert('大小限3M以內');"); } errMsg = errorSb.ToString(); if (errMsg.Length > 0) { break; } byte[] fileData = null; using (var binaryReader = new BinaryReader(uploadedFile.InputStream)) { fileData = binaryReader.ReadBytes(uploadedFile.ContentLength); } NIIS_WS.WebServiceSoapClient WS = new NIIS_WS.WebServiceSoapClient(); string contentType = tbFile.PostedFile.ContentType; OutFileInfoID = WS.UploadFile(1, contentType, extension, uploadedFile.FileName, user.ID, user.OrgID, fileData); if (OutFileInfoID < 1) { UploadFileSuccess = false; break; } else { OutFileInfoID_List.Add(OutFileInfoID); } } } if (errMsg.Length > 0) { Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", "<script>" + errMsg + "</script>", false); return; } string OutFileInfoIDs = string.Join(",", OutFileInfoID_List.Select(x => x.ToString()).ToArray()); int ApplyFormat = 0; RadioButton selected = MyForm.Controls.OfType <RadioButton>().FirstOrDefault(rb => rb.Checked); if (selected != null) { switch (selected.ID) { case "rb1": ApplyFormat = 1; break; case "rb2": ApplyFormat = 2; break; } } int Chk = 0; if (UploadFileSuccess == true) { Dictionary <string, object> OutDict = new Dictionary <string, object>() { { "@Chk", Chk } }; MSDB.ExecuteNonQuery("ConnDB", "dbo.usp_CertificateM_xAddApplyData" , ref OutDict , new Dictionary <string, object>() { { "@CaseUserID", CaseUserID }, { "@CaseUserChName", CaseUserChName }, { "@CaseUserEnName", CaseUserEnName }, { "@ApplyUserName", ApplyUserName }, { "@UserRelationship", UserRelationship }, { "@CreatedUserID", user.ID }, { "@OrgID", user.OrgID }, { "@FileInfoIDs", OutFileInfoIDs }, { "@ApplyFormat", ApplyFormat }, }); Chk = (int)OutDict["@Chk"]; } if (UploadFileSuccess && Chk > 0) { script = "<style>body{display:none;}</style><script>alert('儲存成功');window.close();</script>"; } else { script = "<script>alert('儲存失敗');</script>"; } Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); }
protected void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("GET", "POST"); base.DisableTop(false); base.BodyClass = "class='bodybg'"; int.TryParse(Request.Form["au"], out AssessmentUserID); //DateTime.TryParse(Request.Form["AD"], out AssessmentDate); DateTime.TryParseExact((Request.Form["ad"] ?? DateTime.Now.ToShortTaiwanDate()).RepublicToAD(), "yyyyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None, out AssessmentDate); bool.TryParse(Request.Form["AW"], out AllowWork); ApplyHealthCateIDs = Request.Form["AH"] ?? ""; bool IsValid = false; try { List <int> list = ApplyHealthCateIDs.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries) .ToList <string>() .ConvertAll <int>(item => int.Parse(item)); IsValid = true; } catch { } OtherState = Request.Form["os"] ?? ""; int.TryParse(Request.Form["rd"], out RecordDataID); if (IsValid == false || AssessmentUserID == 0 || AssessmentDate == default(DateTime) || RecordDataID == 0) { string script = "<script>alert('資料取得失敗');history.go(-1);</script>"; Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); return; } var user = AuthServer.GetLoginUser(); int Chk = 0; using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_RecordM_xAddOrUpdateApplyHealth", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ApplyHealthID", 0); cmd.Parameters.AddWithValue("@AssessmentUserID", AssessmentUserID); cmd.Parameters.AddWithValue("@AssessmentDate", AssessmentDate); cmd.Parameters.AddWithValue("@CreatedUserID", user.ID); cmd.Parameters.AddWithValue("@AllowWork", AllowWork); cmd.Parameters.AddWithValue("@ApplyHealthCateIDs", ApplyHealthCateIDs); cmd.Parameters.AddWithValue("@OtherState", OtherState); cmd.Parameters.AddWithValue("@RecordDataID", RecordDataID); cmd.Parameters.AddWithValue("@OrgID", user.OrgID); SqlParameter sp = cmd.Parameters.AddWithValue("@Chk", Chk); sp.Direction = ParameterDirection.Output; sc.Open(); cmd.ExecuteNonQuery(); Chk = (int)sp.Value; } } OPVM VM = new OPVM(); VM.chk = Chk; Response.ContentType = "application/json; charset=utf-8"; Response.Write(Newtonsoft.Json.JsonConvert.SerializeObject(VM)); Response.End(); }
protected void btnSave_Click(object sender, EventArgs e) { List <string> RequestKeys = Request.Form.AllKeys.Where(key => key.Contains("ddlVaccineCode_") || key.Contains("ddlNotNeedOrRejectReason_") || key.Contains("tbPrDate_")).ToList(); UserVM user = AuthServer.GetLoginUser(); string VacIDs = hdVac.Value ?? ""; string[] Vac = VacIDs.Split(','); string VisitResult = ddlVisitResult.SelectedValue; string spName = (VisitID != 0 ? "usp_CaseVisit_xEdit" : "usp_CaseVisit_xAdd"); DataTable dt = (DataTable)DBUtil.DBOp("ConnDB", "exec [dbo].[" + spName + "] {0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10} " , new string[] { TaiwanYear.ToDateString(tbVisitDate.Text) , (VisitID != 0 ? VisitID.ToString() : CaseID.ToString()) , ddlVisitMan.SelectedValue , ddlVisitType.SelectedValue , ddlVisitReason.SelectedValue , VisitResult , tbVisitComment.Text , user.ID.ToString() , user.OrgID.ToString() , TaiwanYear.ToDateString(tbPreBackDate.Text) , ddlCountry.SelectedValue }, NSDBUtil.CmdOpType.ExecuteReaderReturnDataTable); int NewVisitID = 0; if (dt.Rows.Count > 0) { NewVisitID = Convert.ToInt32(dt.Rows[0][0]); CaseID = Convert.ToInt32(dt.Rows[0][1]); handlefile(NewVisitID); } DBUtil.DBOp("ConnDB", " UPDATE [dbo].[C_CaseVisitDetail] SET [LogicDel] = 1 where VisitID={0} " , new string[] { NewVisitID.ToString() }, NSDBUtil.CmdOpType.ExecuteNonQuery); //Response.Write(VacIDs); //Response.End(); foreach (string v in Vac) { string VacIDSeq = "", VisitResultDetailID = "0", PrejectDate = "", VacID = "", Seq = ""; VacIDSeq = Request.Form [RequestKeys.Find(r => r.Contains("ddlVaccineCode_" + v))] ?? ""; VacID = (VacIDSeq == "" ?v: VacIDSeq.Split('-')[0]); Seq = (VacIDSeq.Split('-').Length > 1 ? VacIDSeq.Split('-')[1] :""); VisitResultDetailID = Request.Form [RequestKeys.Find(r => r.Contains("ddlNotNeedOrRejectReason_" + v))] ?? ""; PrejectDate = TaiwanYear.ToDateString(Request.Form[RequestKeys.Find(r => r.Contains("tbPrDate_" + v))] ?? ""); DBUtil.DBOp("ConnDB", " exec [dbo].[usp_CaseVisit_xAddDetail] {0},{1},{2} ,{3},{4} " , new string[] { NewVisitID.ToString(), VacID, Seq, VisitResultDetailID, PrejectDate }, NSDBUtil.CmdOpType.ExecuteNonQuery); } //更新個人紀錄 DBUtil.DBOp("ConnDB", " exec [dbo].[usp_CaseVisit_xUpdateRecordData] {0} " , new string[] { NewVisitID.ToString() }, NSDBUtil.CmdOpType.ExecuteNonQuery); Page.ClientScript.RegisterStartupScript(Page.GetType(), "", "alert('成功!');location.href='VisitCaseList.aspx?i=" + CaseID.ToString() + "';", true); }
protected new void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("POST"); base.DisableTop(false); CaseUserID = GetNumber <int>("i"); if (CaseUserID == 0) { string script = "<style>body{disply:none;}</style><script>alert('資料取得失敗');history.go(-1);</script>"; Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); return; } ucCaseRemark1.CaseID = CaseUserID; var user = AuthServer.GetLoginUser(); OrgName = user.OrgName; DataTable dt = new DataTable(); int YCardMainID = 0; int DeltaDays = 0; Dictionary <string, object> OutDict = new Dictionary <string, object>() { { "@YCardMainID", YCardMainID }, { "@DeltaDays", DeltaDays } }; DataSet ds = MSDB.GetDataSet("ConnDB", "dbo.usp_RecordM_xGetCaseUserByIDAndGetOrAddYCardMain" , ref OutDict , new Dictionary <string, object>() { { "@CaseUserID", CaseUserID } }); YCardMainID = (int)OutDict["@YCardMainID"]; DeltaDays = (int)OutDict["@DeltaDays"]; List <RegisterStoolCardVM> scList = new List <RegisterStoolCardVM>(); List <RegisterFluNotesVM> fnList = new List <RegisterFluNotesVM>(); string CapacityIDs = ""; EntityS.FillModel(VM, ds.Tables[0]); if (ds.Tables[2].Rows.Count > 0) { EntityS.FillModel(VM, ds.Tables[2]); VM.HasYellowCardMessage = true; } EntityS.FillModel(scList, ds.Tables[3]); EntityS.FillModel(fnList, ds.Tables[4]); if (ds.Tables[1].Rows.Count > 0) { CapacityIDs = ds.Tables[1].Rows[0][0].ToString(); } if (scList.Count > 0) { scAry = JsonConvert.SerializeObject(scList); } if (fnList.Count > 0) { fnAry = JsonConvert.SerializeObject(fnList); } List <string> CapacityList = new List <string>(); foreach (var item in CapacityIDs.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries)) { CapacityList.Add(SystemCode.GetName("CaseUser_Capacity", int.Parse(item))); } CapacityString = string.Join(",", CapacityList.ToArray()); //if(ds.Tables[1].Rows.Count>0) // YCardMainID = (int)ds.Tables[1].Rows[0][0]; uJson = JsonConvert.SerializeObject(VM); AgeCalculatorT AT = new AgeCalculatorT(); AgeString = AT.GetYearMonthAge(VM.BirthDate); DateTime birthDate = VM.BirthDate; dt = MSDB.GetDataTable("ConnDB", "dbo.usp_RecordM_xGetRecordDataByCaseUserID" , new Dictionary <string, object>() { { "@CaseUserID", CaseUserID } }); List <RecordDataVM> list = new List <RecordDataVM>(); //List<RecordYellowDataVM> yellowList = new List<RecordYellowDataVM>(); var yellowList = SystemYCard.GetDict(YCardMainID).Where(item => item.YCardDataType == 1); //var x = SystemYCard.dict; List <RecordUserDataVM> userList = new List <RecordUserDataVM>(); //List<RecordYellowDataVM> yellowRemoveList = new List<RecordYellowDataVM>(); List <RecordUserDataVM> userRemoveList = new List <RecordUserDataVM>(); EntityS.FillModel(userList, dt); //EntityS.FillModel(yellowList, ds.Tables[0]); //EntityS.FillModel(userList, ds.Tables[1]); //var userVaccineCodes =userList.Select(item => item.SystemRecordVaccineCode).ToList(); //var DoseIDs = yellowList.Select(item => item.DoseID).ToList(); foreach (var yellow in yellowList) { var queryList = userList.FindAll(item => item.SystemRecordVaccineCode.Equals(yellow.DoseID)); if (queryList.Count > 0) { foreach (var q in queryList) { //yellowRemoveList.Add(yellow); userRemoveList.Add(q); RecordDataVM rVM = new RecordDataVM(birthDate); rVM.InoculationDate = q.InoculationDate; rVM.IsRule = true; rVM.OrgID = q.OrgID; rVM.VaccineBatchID = q.VaccineBatchID; rVM.SystemRecordVaccineID = q.SystemRecordVaccineID; rVM.AgeEngilsh = yellow.AgeEngilsh; rVM.DoseID = yellow.DoseID; rVM.Period = yellow.Period; rVM.CreatedDate = q.CreatedDate; rVM.CreateType = q.CreateType; //rVM.ColorType = 1; rVM.RecordDataID = q.RecordDataID; //if (rVM.InoculationDate == null || DateTime.Equals(rVM.InoculationDate, new DateTime(2099, 1, 1, 1, 1, 1, 0))) //{ // rVM.OrgID = 0; // rVM.ColorType = 0; // rVM.CreatedDate = null; //} //else if(rVM.AppointmentDate!=null && DateTime.Equals(rVM.InoculationDate, new DateTime(2099, 1, 1, 1, 1, 1, 0))==false) //{ // if(DateTime.Compare(rVM.InoculationDate.Value, rVM.AppointmentDate.Value.AddDays(90))>0) // { // rVM.ColorType = 1; // } //} list.Add(rVM); } } else { RecordDataVM rVM = new RecordDataVM(birthDate); rVM.IsRule = true; rVM.AgeEngilsh = yellow.AgeEngilsh; rVM.DoseID = yellow.DoseID; //rVM.SystemRecordVaccineID = SystemRecordVaccine.GetID(yellow.DoseID); rVM.Period = yellow.Period; //rVM.ColorType = 0; list.Add(rVM); } } //yellowList.RemoveAll(item => yellowRemoveList.Contains(item)); userList.RemoveAll(item => userRemoveList.Contains(item)); list.OrderBy(item => item.AppointmentDate).ThenBy(item => item.Period).ThenBy(item => item.DoseID); foreach (var u in userList) { RecordDataVM rVM = new RecordDataVM(birthDate); rVM.InoculationDate = u.InoculationDate; rVM.IsRule = false; rVM.OrgID = u.OrgID; rVM.VaccineBatchID = u.VaccineBatchID; rVM.SystemRecordVaccineID = u.SystemRecordVaccineID; rVM.RecordDataID = u.RecordDataID; if (rVM.InoculationDate == null || DateTime.Equals(rVM.InoculationDate, new DateTime(2099, 1, 1, 1, 1, 1, 0))) { rVM.OrgID = 0; rVM.CreatedDate = null; } //list.Add(VM); //find last InoculationDate var index = list.FindLastIndex(item => item.InoculationDateOut != null); if (index >= 0) { if (index + 1 <= list.Count) { list.Insert(index + 1, rVM); } else { list.Add(rVM); } } else { list.Insert(0, rVM); } } var LastInoculationDateIndex = list.FindLastIndex(item => item.InoculationDateOut != null); for (int i = LastInoculationDateIndex + 1; i <= list.Count - 1; i++) { list[i].DeltaDays = DeltaDays; } if (list.Count > 0) { tbAry = JsonConvert.SerializeObject(list); } }
protected void Page_Load(object sender, EventArgs e) { UserVM user = AuthServer.GetLoginUser(); int PID = SystemOrg.GetVM(user.OrgID).PID; int OrgLevel = SystemOrg.GetVM(user.OrgID).OrgLevel; List <SystemOrgVM> list = new List <SystemOrgVM>(); list.AddRange(SystemOrg.list); if (Convert.ToInt32(WebConfigurationManager.AppSettings["OrgAreaSet"]) == 0) { if (OrgLevel == 1) { //移除:與登入者平層、下一層以外的單位 list.RemoveAll(item => !(item.OrgLevel == OrgLevel || item.OrgLevel == OrgLevel + 2)); } else if (OrgLevel == 3) { //移除:與登入者上一層、平層、下一層以外的單位 list.RemoveAll(item => !(item.OrgLevel == OrgLevel - 2 || item.OrgLevel == OrgLevel || item.OrgLevel == OrgLevel + 1)); //移除:與登入者上一層同,卻不是登入者的上層 list.RemoveAll(item => item.OrgLevel == OrgLevel - 2 && item.ID != PID); //移除:與登入者同一層,且直屬單位不同 list.RemoveAll(item => item.OrgLevel == OrgLevel && item.PID != PID); //移除:與登入者下一層,且不屬於登入者下層單位 list.RemoveAll(item => item.OrgLevel == OrgLevel + 1 && item.PID != user.OrgID); } else if (OrgLevel == 4) { //移除:與登入者上一層、平層、下一層以外的單位 list.RemoveAll(item => !(item.OrgLevel == OrgLevel - 1 || item.OrgLevel == OrgLevel || item.OrgLevel == OrgLevel + 1)); //移除:與登入者上一層同,卻不是登入者的上層 list.RemoveAll(item => item.OrgLevel == OrgLevel - 1 && item.ID != PID); //移除:與登入者同一層,且直屬單位不同 list.RemoveAll(item => item.OrgLevel == OrgLevel && item.PID != PID); //移除:與登入者下一層,且不屬於登入者下層單位 list.RemoveAll(item => item.OrgLevel == OrgLevel + 1 && item.PID != user.OrgID); } else if (OrgLevel == 5) { //移除:與登入者上一層、平層、下一層以外的單位 list.RemoveAll(item => !(item.OrgLevel == OrgLevel - 1 || item.OrgLevel == OrgLevel || item.OrgLevel == OrgLevel + 1)); //移除:與登入者上一層同,卻不是登入者的上層 list.RemoveAll(item => item.OrgLevel == OrgLevel - 1 && item.ID != PID); //移除:與登入者同一層,且直屬單位不同 list.RemoveAll(item => item.OrgLevel == OrgLevel && item.PID != PID); //移除:與登入者下一層,且不屬於登入者下層單位 list.RemoveAll(item => item.OrgLevel == OrgLevel + 1 && item.PID != user.OrgID); } } else if (Convert.ToInt32(WebConfigurationManager.AppSettings["OrgAreaSet"]) == 1) { if (OrgLevel == 1) { //移除:與登入者平層、下一層以外的單位 list.RemoveAll(item => !(item.OrgLevel == OrgLevel || item.OrgLevel == OrgLevel + 1)); } else if (OrgLevel == 2) { //移除:與登入者上一層、平層、下一層以外的單位 list.RemoveAll(item => !(item.OrgLevel == OrgLevel - 1 || item.OrgLevel == OrgLevel || item.OrgLevel == OrgLevel + 1)); //移除:與登入者上一層同,卻不是登入者的上層 list.RemoveAll(item => item.OrgLevel == OrgLevel - 1 && item.ID != PID); //移除:與登入者同一層,且直屬單位不同 list.RemoveAll(item => item.OrgLevel == OrgLevel && item.PID != PID); //移除:與登入者下一層,且不屬於登入者下層單位 list.RemoveAll(item => item.OrgLevel == OrgLevel + 1 && item.PID != user.OrgID); } else if (OrgLevel == 3) { //移除:與登入者上一層、平層、下一層以外的單位 list.RemoveAll(item => !(item.OrgLevel == OrgLevel - 1 || item.OrgLevel == OrgLevel || item.OrgLevel == OrgLevel + 1)); //移除:與登入者上一層同,卻不是登入者的上層 list.RemoveAll(item => item.OrgLevel == OrgLevel - 1 && item.ID != PID); //移除:與登入者同一層,且直屬單位不同 list.RemoveAll(item => item.OrgLevel == OrgLevel && item.PID != PID); //移除:與登入者下一層,且不屬於登入者下層單位 list.RemoveAll(item => item.OrgLevel == OrgLevel + 1 && item.PID != user.OrgID); } else if (OrgLevel == 4) { //移除:與登入者上一層、平層、下一層以外的單位 list.RemoveAll(item => !(item.OrgLevel == OrgLevel - 1 || item.OrgLevel == OrgLevel || item.OrgLevel == OrgLevel + 1)); //移除:與登入者上一層同,卻不是登入者的上層 list.RemoveAll(item => item.OrgLevel == OrgLevel - 1 && item.ID != PID); //移除:與登入者同一層,且直屬單位不同 list.RemoveAll(item => item.OrgLevel == OrgLevel && item.PID != PID); //移除:與登入者下一層,且不屬於登入者下層單位 list.RemoveAll(item => item.OrgLevel == OrgLevel + 1 && item.PID != user.OrgID); } else if (OrgLevel == 5) { //移除:與登入者上一層、平層、下一層以外的單位 list.RemoveAll(item => !(item.OrgLevel == OrgLevel - 1 || item.OrgLevel == OrgLevel || item.OrgLevel == OrgLevel + 1)); //移除:與登入者上一層同,卻不是登入者的上層 list.RemoveAll(item => item.OrgLevel == OrgLevel - 1 && item.ID != PID); //移除:與登入者同一層,且直屬單位不同 list.RemoveAll(item => item.OrgLevel == OrgLevel && item.PID != PID); //移除:與登入者下一層,且不屬於登入者下層單位 list.RemoveAll(item => item.OrgLevel == OrgLevel + 1 && item.PID != user.OrgID); } } 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); int pgNow = 1, pgSize = 10; int OrderCol = 0, OrderAsc = 1;//0出生日期1身份證號 //1ASC 0 DESC int OrgID = 0; int AddrKind = 0, CountyID = 0, TownID = 0; int SearchNumberType = 0; string BirthDateS = "", BirthDateE = ""; string CaseName = "", CaseIdNo = "", HouseNo = ""; string ContactName = "", ContactIdNo = "", ContactBirthDate = ""; #region QS() BirthDateS = Request.Form["BirthDateS"] ?? ""; BirthDateE = Request.Form["BirthDateE"] ?? ""; ContactBirthDate = Request.Form["ContactBirthDate"] ?? ""; 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); } if (ContactBirthDate != "") { ContactBirthDate = (Convert.ToInt32(ContactBirthDate.Substring(0, 3)) + 1911).ToString() + "/" + ContactBirthDate.Substring(3, 2) + "/" + ContactBirthDate.Substring(5, 2); } CaseName = Request.Form["CaseName"] ?? ""; CaseIdNo = Request.Form["CaseIdNo"] ?? ""; HouseNo = Request.Form["HouseNo"] ?? ""; ContactName = Request.Form["ContactName"] ?? ""; ContactIdNo = Request.Form["ContactIdNo"] ?? ""; int.TryParse(Request.Form["pgNow"], out pgNow); int.TryParse(Request.Form["pgSize"], out pgSize); int.TryParse(Request.Form["AddrKind"], out AddrKind); int.TryParse(Request.Form["OrgID"], out OrgID); int.TryParse(Request.Form["CountyID"], out CountyID); int.TryParse(Request.Form["TownID"], out TownID); int.TryParse(Request.Form["NumberType"], out SearchNumberType); int.TryParse(Request.Form["OrderCol"], out OrderCol); int.TryParse(Request.Form["OrderAsc"], out OrderAsc); #endregion OrgID = AuthServer.GetLoginUser().OrgID; DataTableCollection dtc = (DataTableCollection)DBUtil.DBOp("ConnDB" , "exec dbo.usp_CaseUser_xGetUserList {0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14},{15},{16}" , new string[] { pgNow.ToString() , pgSize.ToString() , OrderCol.ToString() , OrderAsc.ToString() , CaseName , CaseIdNo , BirthDateS , BirthDateE , HouseNo , AddrKind.ToString() , ContactName , ContactIdNo , ContactBirthDate , OrgID.ToString() //請帶入想查看的ORG //若沒得選 請帶入目前登入user.org , CountyID.ToString() , TownID.ToString() , SearchNumberType.ToString() }, 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) { base.AllowHttpMethod("GET", "POST"); base.DisableTop(false); base.BodyClass = "class='bodybg'"; if (Request.HttpMethod.Equals("POST")) { nowDate = DateTime.Now.ToShortTaiwanDate(); int.TryParse(Request.Form["c"], out CaseUserID); int.TryParse(Request.Form["i"], out RecordDataID); VaccineCode = Request.Form["r"] ?? ""; AppointmentDate = Request.Form["a"] ?? ""; DateTime date = default(DateTime); bool success = DateTime.TryParse(AppointmentDate, out date); //AppointmentDate = date.ToShortTaiwanDate(); if (success == false || CaseUserID == 0 || RecordDataID == 0) { string script = "<script>alert('資料取得失敗');window.close();</script>"; Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); return; } if (SystemCode.dict.ContainsKey("RecordM_ApplyHealthCate")) { StateListAry = JsonConvert.SerializeObject(SystemCode.dict["RecordM_ApplyHealthCate"].OrderBy(item => item.OrderNumber)); } var user = AuthServer.GetLoginUser(); UserName = user.UserName; DataTable dt = new DataTable(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnUser"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_AccountM_xGetUserListByOrgID", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@OrgID", user.OrgID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(dt); } } } List <UserNameIDVM> list = new List <UserNameIDVM>(); EntityS.FillModel(list, dt); UserAry = Newtonsoft.Json.JsonConvert.SerializeObject(list); } else { Response.Write(""); Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { SearchPower = base.AddPower(SearchPower); UserVM user = AuthServer.GetLoginUser(); int pgNow; int pgSize; string StartDeal = ""; string EndDeal = ""; int InOrgType = 0; string InOrgID = ""; int Staff = 0; int VaccineID = 0; int BatchType = 0; int BatchID = 0; int DealStatus = 0; int Sort = 0; int.TryParse(Request.Form["pgNow"], out pgNow); int.TryParse(Request.Form["pgSize"], out pgSize); if (SearchPower.HasPower == true) { StartDeal = Request.Form["StartDeal"]; EndDeal = Request.Form["EndDeal"]; int.TryParse(Request.Form["InOrgType"], out InOrgType); InOrgID = Request.Form["InOrgID"]; int.TryParse(Request.Form["Staff"], out Staff); int.TryParse(Request.Form["VaccineID"], out VaccineID); int.TryParse(Request.Form["BatchType"], out BatchType); int.TryParse(Request.Form["BatchID"], out BatchID); int.TryParse(Request.Form["DealStatus"], out DealStatus); int.TryParse(Request.Form["Sort"], out Sort); if (StartDeal == "NaN") { StartDeal = ""; } if (EndDeal == "NaN") { EndDeal = ""; } if (InOrgID == "") { InOrgType = 0; } } DataSet ds = new DataSet(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("usp_VaccineOut_xSearchTable", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@pgNow", pgNow); cmd.Parameters.AddWithValue("@pgSize", pgSize); cmd.Parameters.AddWithValue("@StartDeal", StartDeal); cmd.Parameters.AddWithValue("@EndDeal", EndDeal); cmd.Parameters.AddWithValue("@OutOrgType", 2); cmd.Parameters.AddWithValue("@OutOrgID", user.OrgID); cmd.Parameters.AddWithValue("@InOrgType", InOrgType); cmd.Parameters.AddWithValue("@InOrgID", InOrgID); cmd.Parameters.AddWithValue("@Staff", Staff); cmd.Parameters.AddWithValue("@VaccineID", VaccineID); cmd.Parameters.AddWithValue("@BatchType", BatchType); cmd.Parameters.AddWithValue("@BatchID", BatchID); cmd.Parameters.AddWithValue("@DealStatus", DealStatus); cmd.Parameters.AddWithValue("@Sort", Sort); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(ds); } } } List <VaccineOutDataBatchVM> list = new List <VaccineOutDataBatchVM>(); 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 btnSave_Click(object sender, EventArgs e) { string script = ""; string CaseUserChName = tbName.Text.Trim(); string CaseUserEnName = tbE.Text.Trim(); string ApplyUserName = tbA.Text.Trim(); string UserRelationship = tbR.Text.Trim(); var user = AuthServer.GetLoginUser(); int OutFileInfoID = 0; bool UploadFileSuccess = true; List <int> OutFileInfoID_List = new List <int>(); if (tbFile.HasFile == true) { HttpFileCollection multipleFiles = Request.Files; for (int fileCount = 0; fileCount < multipleFiles.Count; fileCount++) { HttpPostedFile uploadedFile = multipleFiles[fileCount]; string extension = ""; string[] ary = uploadedFile.FileName.Split('.'); if (ary.Length > 1) { extension = ary.Last(); } byte[] fileData = null; using (var binaryReader = new BinaryReader(uploadedFile.InputStream)) { fileData = binaryReader.ReadBytes(uploadedFile.ContentLength); } NIIS_WS.WebServiceSoapClient WS = new NIIS_WS.WebServiceSoapClient(); string contentType = tbFile.PostedFile.ContentType; OutFileInfoID = WS.UploadFile(1, contentType, extension, uploadedFile.FileName, user.ID, user.OrgID, fileData); if (OutFileInfoID < 1) { UploadFileSuccess = false; break; } else { OutFileInfoID_List.Add(OutFileInfoID); } } } string OutFileInfoIDs = string.Join(",", OutFileInfoID_List.Select(x => x.ToString()).ToArray()); int Chk = 0; if (UploadFileSuccess == true) { using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_CertificateM_xAddApplyData", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CaseUserID", CaseUserID); cmd.Parameters.AddWithValue("@CaseUserChName", CaseUserChName); cmd.Parameters.AddWithValue("@CaseUserEnName", CaseUserEnName); cmd.Parameters.AddWithValue("@ApplyUserName", ApplyUserName); cmd.Parameters.AddWithValue("@UserRelationship", UserRelationship); cmd.Parameters.AddWithValue("@CreatedUserID", user.ID); cmd.Parameters.AddWithValue("@OrgID", user.OrgID); cmd.Parameters.AddWithValue("@FileInfoIDs", OutFileInfoIDs); SqlParameter sp = cmd.Parameters.AddWithValue("@Chk", Chk); sp.Direction = ParameterDirection.Output; sc.Open(); cmd.ExecuteNonQuery(); Chk = (int)sp.Value; } } } if (UploadFileSuccess && Chk > 0) { script = "<script>alert('儲存成功');location.href = '/System/DocumentM/DocumentMaintain.aspx';</script><style>body{display:none;}</style>"; } else { script = "<script>alert('儲存失敗');</script>"; } Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); }
protected void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("GET", "POST"); base.DisableTop(false); base.BodyClass = "class='bodybg'"; if (Request.HttpMethod.Equals("POST")) { if (this.IsPostBack == false) { int.TryParse(Request.Form["c"], out CaseUserID); int.TryParse(Request.Form["i"], out RecordDataID); VaccineCode = Request.Form["r"] ?? ""; AppointmentDate = Request.Form["a"] ?? ""; AppointmentDate = AppointmentDate.Equals("") ? Request.Form["aa"] ?? "": AppointmentDate; DateTime date = default(DateTime); bool success = DateTime.TryParse(AppointmentDate, out date); AppointmentDate = date.ToShortTaiwanDate(); lblVC.Text = VaccineCode; lblAD.Text = AppointmentDate; hfc.Value = CaseUserID.ToString(); hfi.Value = RecordDataID.ToString(); hfr.Value = VaccineCode; hfa.Value = AppointmentDate; if (success == false || CaseUserID == 0 || RecordDataID == 0) { string script = "<script>alert('資料取得失敗');window.close();</script>"; Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); return; } tbDate.Text = DateTime.Now.ToShortTaiwanDate(); if (SystemCode.dict.ContainsKey("RecordM_ApplyRecord_ReRecordReason")) { var codes = SystemCode.dict["RecordM_ApplyRecord_ReRecordReason"]; foreach (var item in codes) { ddlReason1.Items.Add(new ListItem(item.EnumName, item.EnumValue.ToString())); } } if (SystemCode.dict.ContainsKey("RecordM_ApplyRecord_ReInoculationReason")) { var codes = SystemCode.dict["RecordM_ApplyRecord_ReInoculationReason"]; foreach (var item in codes) { ddlReason2.Items.Add(new ListItem(item.EnumName, item.EnumValue.ToString())); } } if (SystemCode.dict.ContainsKey("RecordM_ApplyRecord_EarlyLateReason")) { var codes = SystemCode.dict["RecordM_ApplyRecord_EarlyLateReason"]; foreach (var item in codes) { ddlReason3.Items.Add(new ListItem(item.EnumName, item.EnumValue.ToString())); } } } user = AuthServer.GetLoginUser(); DataTable dt = new DataTable(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_RecordM_xGetDefaultBatchVaccineByOrgID", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@OrgID", user.OrgID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(dt); } } } List <DefaultBatchVaccineVM> list = new List <DefaultBatchVaccineVM>(); EntityS.FillModel(list, dt); if (list.Count > 0) { tbAry = JsonConvert.SerializeObject(list); } Agency = SystemOrg.GetName(user.OrgID); AgencyID = user.OrgID; } else { Response.Write(""); Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("GET"); base.DisableTop(false); base.BodyClass = "class='bodybg'"; var user = AuthServer.GetLoginUser(); int AgencyInfoID = 0; int.TryParse(Request["i"], out AgencyInfoID); string IDs = Request["is"] ?? ""; bool IsValid = false; List <int> IDsList = new List <int>(); try { IDsList = IDs.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries) .ToList <string>() .ConvertAll <int>(item => int.Parse(item)); IsValid = true; } catch { } if (AgencyInfoID == 0 || IsValid == false) { 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_xGetVaccineByAgencyID", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@AgencyInfoID", AgencyInfoID); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(dt); } } } List <AddVaccineVM> list = new List <AddVaccineVM>(); EntityS.FillModel(list, dt); if (IDsList.Count > 0) { foreach (var item in list) { if (IDsList.Contains(item.ID)) { item.IsChecked = true; } } } ListJson = Newtonsoft.Json.JsonConvert.SerializeObject(list); }
protected void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("POST"); base.DisableTop(true); int pgNow; int pgSize; int CountyID = 0; int TownID = 0; string BirthDateS; string BirthDateE; string CaseName; string CaseIdNo; string SearchReason; string SearchConditions = ""; int SearchKind = 1; int IsSearch = 0; BirthDateS = Request.Form["BirthDateS"] ?? ""; BirthDateE = Request.Form["BirthDateE"] ?? ""; if (BirthDateS != "") { try { // BirthDateS = Convert.ToDateTime(BirthDateS).ToString("yyyyMMdd"); BirthDateS = TaiwanYear.ToDateTime(BirthDateS).ToString("yyyyMMdd"); } catch { BirthDateS = ""; } } if (BirthDateE != "") { try { //BirthDateE = Convert.ToDateTime(BirthDateE).ToString("yyyyMMdd"); BirthDateE = TaiwanYear.ToDateTime(BirthDateE).ToString("yyyyMMdd"); } catch { BirthDateE = ""; } } CaseName = Request.Form["CaseName"] ?? ""; CaseIdNo = Request.Form["CaseIdNo"] ?? ""; int.TryParse(Request.Form["pgNow"], out pgNow); int.TryParse(Request.Form["pgSize"], out pgSize); int.TryParse(Request.Form["CountyID"], out CountyID); int.TryParse(Request.Form["TownID"], out TownID); int.TryParse(Request.Form["IsSearch"], out IsSearch); SearchReason = Request.Form["SearchReason"] ?? ""; int.TryParse(Request.Form["SearchKind"], out SearchKind); List <UserProfileListVM> list = new List <UserProfileListVM>(); PageVM rtn = new PageVM(); DataSet ds = new DataSet(); int SearcResultCount = 0; try { using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_CaseUser_xGetUserList", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@pgNow", pgNow == 0 ? 1 : pgNow); cmd.Parameters.AddWithValue("@pgSize", pgSize == 0 ? 10 : pgSize); cmd.Parameters.AddWithValue("@BirthDateS", BirthDateS); cmd.Parameters.AddWithValue("@BirthDateE", BirthDateE); cmd.Parameters.AddWithValue("@CaseName", CaseName); cmd.Parameters.AddWithValue("@CaseIdNo", CaseIdNo); cmd.Parameters.AddWithValue("@CountyID", CountyID); cmd.Parameters.AddWithValue("@TownID", TownID); //cmd.Parameters.AddWithValue("@IsSearch", IsSearch); //cmd.Parameters.AddWithValue("@SearchReason", SearchReason); using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); da.Fill(ds); } } } SearcResultCount = Convert.ToInt32(ds.Tables[1].Rows[0][0]); // SearcResultCount = 0; EntityS.FillModel(list, ds.Tables[0]); EntityS.FillModel(rtn, ds.Tables[1]); } catch { } finally { //記下查詢紀錄 if (IsSearch == 1) { if (CaseName != "") { SearchConditions += "姓名:" + CaseName; } if (CaseIdNo != "") { SearchConditions += "身份證號:" + CaseIdNo; } if (BirthDateS != "") { SearchConditions += "生日起日:" + BirthDateS; } if (BirthDateE != "") { SearchConditions += "生日迄日:" + BirthDateE; } if (CountyID != 0) { SearchConditions += "戶籍縣市:" + SystemAreaCode.GetName(CountyID); } if (TownID != 0) { SearchConditions += "戶籍鄉鎮:" + SystemAreaCode.GetName(TownID); } Session["SearchID"] = Convert.ToInt32(DBUtil.DBOp("ConnDB", " exec [dbo].[usp_CaseUser_xAddSearchLog] {0}, {1}, {2} ,{3} ,{4} ", new string[] { AuthServer.GetLoginUser().ID.ToString(), SearchConditions, SearchReason, SearcResultCount.ToString(), SearchKind.ToString() }, NSDBUtil.CmdOpType.ExecuteScalar)); } } 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("POST"); DateTime AssessmentDate = DateTime.Now; int SelfOrFamily = GetNumber <int>("sf"); int CaseUserID = GetNumber <int>("cc"); int AssessmentUserID = GetNumber <int>("au"); int SystemRecordVaccineID = GetNumber <int>("ri"); string AssessmentUserName = GetString("aun"); int UpdateUID = GetNumber <int>("uu"); //DateTime.TryParse(Request.Form["AD"], out AssessmentDate); //.TryParseExact((GetString("ad") ?? DateTime.Now.ToShortTaiwanDate()).RepublicToAD(), DateTime.TryParseExact((GetString("ad") ?? new DateTime(2099, 1, 1, 1, 1, 1, 0).ToShortTaiwanDate()).RepublicToAD(), "yyyyMMdd", CultureInfo.InvariantCulture, DateTimeStyles.None, out AssessmentDate); bool AllowWork = GetNumber <int>("aw") == 1 ? true :false; string ApplyHealthCateIDs = GetString("ah"); bool IsValid = false; try { List <int> list = ApplyHealthCateIDs.Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries) .ToList <string>() .ConvertAll <int>(item => int.Parse(item)); IsValid = true; } catch { } string OtherState = GetString("os"); int RecordDataID = GetNumber <int>("rd"); if (UpdateUID == 0) { if (IsValid == false || AssessmentUserID == 0 || AssessmentDate == default(DateTime) || RecordDataID == 0) { OPVM VMerr = new OPVM(); VMerr.chk = 0; Response.ContentType = "application/json; charset=utf-8"; Response.Write(JsonConvert.SerializeObject(VMerr)); Response.End(); } } var user = AuthServer.GetLoginUser(); int Chk = 0; Dictionary <string, object> OutDict = new Dictionary <string, object>() { { "@Chk", Chk } }; MSDB.ExecuteNonQuery("ConnDB", "dbo.usp_RecordM_xAddOrUpdateApplyHealth" , ref OutDict , new Dictionary <string, object>() { { "@ApplyHealthID", UpdateUID }, { "@AssessmentUserID", AssessmentUserID }, { "@AssessmentDate", AssessmentDate }, { "@CreatedUserID", user.ID }, { "@AllowWork", AllowWork }, { "@ApplyHealthCateIDs", ApplyHealthCateIDs }, { "@OtherState", OtherState }, { "@RecordDataID", RecordDataID }, { "@OrgID", user.OrgID }, { "@CaseUserID", CaseUserID }, { "@SelfOrFamily", SelfOrFamily }, { "@SystemRecordVaccineID", SystemRecordVaccineID } }); Chk = (int)OutDict["@Chk"]; OPVM VM = new OPVM(); VM.chk = Chk; if (UpdateUID > 0) { Dictionary <string, object> dict = new Dictionary <string, object>(); dict["I"] = UpdateUID; dict["AD"] = AssessmentDate; dict["N"] = AssessmentUserName; dict["ON"] = user.OrgName; dict["AS"] = "," + ApplyHealthCateIDs.Trim(',') + ","; dict["OS"] = OtherState; dict["AW"] = AllowWork; VM.obj = dict; } Response.ContentType = "application/json; charset=utf-8"; Response.Write(JsonConvert.SerializeObject(VM)); Response.End(); }
protected override void OnInitComplete(EventArgs e) { bool HasPower = false; if (Request.UrlReferrer == null || Request.Url.Host.Equals(Request.UrlReferrer.Host) == false) { throw new HttpException(404, "Not found"); } var dictHasPowerCount = 0; //List<string> urls = new List<string>(); Dictionary <string, bool> urls = new Dictionary <string, bool>(); foreach (var item in dict) { if (urls.ContainsKey(item.Key.PageUrl) == false) { urls[item.Key.PageUrl] = false; } item.Value.HasPower = CheckPower(item.Key.PageUrl, item.Key.myPowerEnum); if (item.Value.HasPower == true) { dictHasPowerCount++; } if (item.Key.myPowerEnum == MyPowerEnum.瀏覽) { urls[item.Key.PageUrl] = true; } } if (Request.Path.ToLower().Equals("/home.aspx") == true || Request.Path.ToLower().Equals("/leftmenu.aspx") == true || Request.Path.ToLower().Equals("/topheader.aspx") == true) { HasPower = true; } else { if (dict.Count > 0) { if ((dictHasPowerCount == dict.Count) || (powerLogicType == PowerLogicType.OR && dictHasPowerCount >= 1)) { HasPower = true; } foreach (var item in urls) { if (item.Value == false) { HasPower = CheckPower(item.Key, MyPowerEnum.瀏覽); if (powerLogicType == PowerLogicType.OR && HasPower == true) { break; } } } } else { HasPower = CheckPower(Request.Path, MyPowerEnum.瀏覽); } } if (HasPower == false) { UserVM user = AuthServer.GetLoginUser(); if (user != null) { throw new HttpException(404, "Not found"); //Response.Redirect("~/Login.aspx"); } else { throw new HttpException(404, "Not found"); //Response.Redirect("~/html/ErrorPage/NoPower.html"); } //string myScript = "<script>alert('您無權操作此頁面');history.go(-1);</script>"; //Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "DisableTop", myScript, false); } }
protected void btnSave_Click(object sender, EventArgs e) { string script = ""; string message = CheckValid(); if (message.Length > 0) { script = "<script>alert('" + message + "');</script>"; Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); return; } int CheckState = PureNumber <int>(rbList.SelectedValue); bool IsBusiness = cbP.Checked; string UserName = PureString(tbName.Text); string RocID = PureString(tbRID.Text); string PhoneNumber = PureString(tbPhone.Text); string Email = PureString(tbEmail.Text); string Title = PureString(tbTitle.Text); string ApplyReason = PureString(tbReason.Text); string CheckDescription = PureString(tbDesp.Text); List <int> roleList = new List <int>(); foreach (ListItem listItem in cbList.Items) { if (listItem.Selected) { int value = 0; int.TryParse(listItem.Value, out value); if (value > 0) { roleList.Add(value); } } } UserVM user = AuthServer.GetLoginUser(); //int OutFileInfoID = 0; //bool UploadFileSuccess = true; int Chk = 0; //List<int> OutFileInfoID_List = new List<int>(); //if (tbFile.HasFile == true) //{ // HttpFileCollection multipleFiles = Request.Files; // for (int fileCount = 0; fileCount < multipleFiles.Count; fileCount++) // { // //string fileName = Path.GetFileName(uploadedFile.FileName); // //if (uploadedFile.ContentLength > 0) // //{ // // uploadedFile.SaveAs(Server.MapPath("~/Files/") + fileName); // // Label1.Text += fileName + "Saved <BR>"; // //} // HttpPostedFile uploadedFile = multipleFiles[fileCount]; // string extension = ""; // //string[] ary = tbFile.FileName.Split('.'); // string[] ary = uploadedFile.FileName.Split('.'); // if (ary.Length > 1) // { // extension = ary.Last(); // } // byte[] fileData = null; // using (var binaryReader = new BinaryReader(uploadedFile.InputStream)) // { // fileData = binaryReader.ReadBytes(uploadedFile.ContentLength); // } // NIIS_WS.WebServiceSoapClient WS = new NIIS_WS.WebServiceSoapClient(); // string contentType = tbFile.PostedFile.ContentType; // OutFileInfoID = WS.UploadFile(1, contentType, extension, uploadedFile.FileName, user.ID, user.RoleID, fileData); // if (OutFileInfoID < 1) // { // UploadFileSuccess = false; // break; // } // else // { // OutFileInfoID_List.Add(OutFileInfoID); // } // } //} //string OutFileInfoIDs = string.Join(",", OutFileInfoID_List.Select(x => x.ToString()).ToArray()); //if (UploadFileSuccess == true) //{ Dictionary <string, object> OutDict = new Dictionary <string, object>() { { "@Chk", Chk } }; MSDB.ExecuteNonQuery("ConnUser", "dbo.usp_AccountM_xUpdateAccountInfo" , ref OutDict , new Dictionary <string, object>() { { "@UserID", ID }, { "@UserName", UserName }, { "@RocID", RocID }, { "@PhoneNumber", PhoneNumber }, { "@Email", Email }, { "@Title", Title }, { "@RoleIDs", string.Join(",", roleList.ConvertAll((item) => { return(item.ToString()); })) }, { "@ApplyReason", ApplyReason }, { "@CheckState", CheckState }, { "@CheckDescription", CheckDescription }, { "@IsBusiness", IsBusiness }, //{ "@FileInfoIDs", OutFileInfoIDs } }); Chk = (int)OutDict["@Chk"]; //} if (Chk > 0) { script = "<style>body{display:none;}</style><script>alert('儲存成功');location.href = '/System/AccountM/AccountMaintain.aspx?i=" + ID + "';</script>"; } else { script = "<script>alert('儲存失敗');</script>"; } Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); }
protected void btnSave_Click(object sender, EventArgs e) { if (IsValid == false) { return; } string checkScript = ""; string message = CheckValid(); if (message.Length > 0) { checkScript = "<script>alert('" + message + "');</script>"; Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", checkScript, false); return; } string title = PureString(tbTitle.Text); string description = PureString(tbDesp.Text); int state = 0; RadioButton thisRb = null; thisRb = MyForm.Controls.OfType <RadioButton>().FirstOrDefault(rb => rb.Checked); if (thisRb != null) { switch (thisRb.ID) { case "rb1": state = 1; break; case "rb2": state = 2; break; } } UserVM user = AuthServer.GetLoginUser(); int OutFileInfoID = 0; bool UploadFileSuccess = true; int Chk = 0; List <int> OutFileInfoID_List = new List <int>(); StringBuilder errorSb = new StringBuilder(); string errMsg = ""; if (tbFile.HasFile == true) { List <string> list = new List <string>() { "application/pdf", "application/msword", "application/vnd.openxmlformats-officedocument.wordprocessingml.document", "application/vnd.ms-excel", "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" }; HttpFileCollection multipleFiles = Request.Files; for (int fileCount = 0; fileCount < multipleFiles.Count; fileCount++) { //string fileName = Path.GetFileName(uploadedFile.FileName); //if (uploadedFile.ContentLength > 0) //{ // uploadedFile.SaveAs(Server.MapPath("~/Files/") + fileName); // Label1.Text += fileName + "Saved <BR>"; //} HttpPostedFile uploadedFile = multipleFiles[fileCount]; string extension = ""; //string[] ary = tbFile.FileName.Split('.'); string[] ary = uploadedFile.FileName.Split('.'); if (ary.Length > 1) { extension = ary.Last(); } if (list.Contains(uploadedFile.ContentType) == false) { errorSb.Append("alert('上傳格式限PDF、WORD、EXCEL');"); } if (uploadedFile.ContentLength > 3 * 1024 * 1024) { errorSb.Append("alert('大小限3M以內');"); } errMsg = errorSb.ToString(); if (errMsg.Length > 0) { break; } byte[] fileData = null; using (var binaryReader = new BinaryReader(uploadedFile.InputStream)) { fileData = binaryReader.ReadBytes(uploadedFile.ContentLength); } NIIS_WS.WebServiceSoapClient WS = new NIIS_WS.WebServiceSoapClient(); string contentType = tbFile.PostedFile.ContentType; OutFileInfoID = WS.UploadFile(1, contentType, extension, uploadedFile.FileName, user.ID, user.RoleID, fileData); if (OutFileInfoID < 1) { UploadFileSuccess = false; break; } else { OutFileInfoID_List.Add(OutFileInfoID); } } } if (errMsg.Length > 0) { Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", "<script>" + errMsg + "</script>", false); return; } string OutFileInfoIDs = string.Join(",", OutFileInfoID_List.Select(x => x.ToString()).ToArray()); if (UploadFileSuccess == true) { Dictionary <string, object> OutDict = new Dictionary <string, object>() { { "@Chk", Chk } }; MSDB.ExecuteNonQuery("ConnDB", "dbo.usp_DocumentM_xUpdateDocumentInfo" , ref OutDict , new Dictionary <string, object>() { { "@DocTitle", title }, { "@PublishState", state }, { "@DocDescription", description }, { "@DocumentInfoID", ID }, { "@FileInfoIDs", OutFileInfoIDs } }); Chk = (int)OutDict["@Chk"]; } string script = ""; if (UploadFileSuccess && Chk > 0) { script = string.Format("{0}<script>alert('儲存成功');location.href='{1}#{2}';</script>", "<style>body{display:none;}</style>" , "/System/DocumentM/DocumentMaintain.aspx" , HttpUtility.HtmlDecode(GetString("hash") ?? "") ); } else { script = "<script>alert('儲存失敗');</script>"; } Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); }
protected override void OnInitComplete(EventArgs e) { if (BreakCheckPower == true) { return; } bool HasPower = false; if (Request.UrlReferrer == null || Request.Url.Host.Equals(Request.UrlReferrer.Host) == false) { //throw new HttpException(404, "Not found"); Response.Redirect("/Login.aspx"); Response.End(); } UserVM user = AuthServer.GetLoginUser(); if (user != null) { if (Request.Path.ToLower().Equals("/home.aspx") == true || Request.Path.ToLower().Equals("/leftmenu.aspx") == true || Request.Path.ToLower().Equals("/topheader.aspx") == true) { HasPower = true; } else { if (dict.Count > 0) { var dictHasPowerCount = 0; List <string> allUrlList = new List <string>(); List <string> notAddUrlList = new List <string>(); List <string> PageUrlList = new List <string>(); List <string> FunctionIndexList = new List <string>(); foreach (var item in dict) { PageUrlList.Add(item.Key.PageUrl); FunctionIndexList.Add(((int)item.Key.myPowerEnum).ToString()); if (allUrlList.Contains(item.Key.PageUrl) == false) { allUrlList.Add(item.Key.PageUrl); } if (item.Key.myPowerEnum == MyPowerEnum.瀏覽) { if (notAddUrlList.Contains(item.Key.PageUrl) == false) { notAddUrlList.Add(item.Key.PageUrl); } } } var needAddUrlList = allUrlList.Except(notAddUrlList); foreach (var item in needAddUrlList) { PageUrlList.Add(item); FunctionIndexList.Add(((int)MyPowerEnum.瀏覽).ToString()); } var dt = MSDB.GetDataTable("ConnUser", "dbo.usp_SystemM_xCheckPowerList" , new Dictionary <string, object>() { { "@UserID", user.ID }, { "@PageUrls", string.Join(",", PageUrlList) }, { "@FunctionIndexs", string.Join(",", FunctionIndexList) }, { "@ModuleCateID", Convert.ToInt32(WebConfigurationManager.AppSettings["ModuleCateID"]) } }); int i = 0; foreach (var item in dict) { bool itemPower = (bool)dt.Rows[i][0]; if (isSharedPage == false && item.Key.myPowerEnum == MyPowerEnum.瀏覽 && itemPower == false) { HasPower = false; break; } else if (isSharedPage == true) { if (SharedPageCheckUrl.Length > 0) { HasPower = CheckPower(SharedPageCheckUrl, MyPowerEnum.瀏覽); } else { HasPower = CheckPower(Request.Path, MyPowerEnum.瀏覽); } if (HasPower == false) { break; } } else { item.Value.HasPower = itemPower; HasPower = true; } if (itemPower == true) { dictHasPowerCount++; } i++; } if (HasPower == true) { if ((dictHasPowerCount == dict.Count) || (powerLogicType == PowerLogicType.OR && dictHasPowerCount >= 1)) { HasPower = true; } else { HasPower = false; } } } else { HasPower = CheckPower(Request.Path, MyPowerEnum.瀏覽); } } if (HasPower == false) { throw new HttpException(404, "Not found"); } } else { throw new HttpException(404, "Not found"); } }
protected new void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("GET", "POST"); if (Request.HttpMethod.Equals("POST")) { PageUrl = QueryStringEncryptToolS.Decrypt(GetString("p")); EncryptPageUrl = QueryStringEncryptToolS.Encrypt(PageUrl); HasViewPower = CheckPower(PageUrl, MyPowerEnum.瀏覽); if (HasViewPower == false) { throw new HttpException(404, "Not found"); } HasSearchPower = CheckPower(PageUrl, MyPowerEnum.查詢); var user = AuthServer.GetLoginUser(); 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); //var all = SystemOrg.list; //int minValue = 0; //int maxValue = 0; //if (all.Count > 0) //{ // minValue = all[0].PID; // maxValue = all[all.Count-1].PID; //} //IEnumerable<SystemOrgVM> conditionList = new List<SystemOrgVM>() { SystemOrg.GetVM(AuthServer.GetLoginUser().OrgID) }; //IEnumerable<SystemOrgVM> queryList = new List<SystemOrgVM>(); //List<SystemOrgVM> FinalList = new List<SystemOrgVM>() { SystemOrg.GetVM(AuthServer.GetLoginUser().OrgID) }; //int maxLevel = 10; //int i = 0; //do //{ // queryList = GetChild(all, conditionList, minValue, maxValue); // FinalList.AddRange(queryList); // conditionList = queryList; // i++; //} while (queryList.Count() > 0 && i < maxLevel); list = list.Where(item => item.OrgLevel < 5).ToList(); MyTreeData = JsonConvert.SerializeObject(list); } else { Response.Write(""); Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { DownloadPower = base.AddPower(DownloadPower); base.AllowHttpMethod("GET", "POST"); base.DisableTop(false); UserVM user = AuthServer.GetLoginUser(); DealHospitalName.Text = HttpUtility.HtmlEncode(Request.Form[DealHospitalName.UniqueID]); if (this.IsPostBack == false) { if (SystemCode.dict.ContainsKey("StockManagementM_FroIdx")) { List <SystemCodeVM> SystemCodeList = SystemCode.dict["StockManagementM_FroIdx"]; foreach (SystemCodeVM sc in SystemCodeList) { FroIdx.Items.Add(new ListItem(sc.EnumName, sc.EnumValue.ToString())); } } if (SystemCode.dict.ContainsKey("StockManagementM_MonIdx")) { List <SystemCodeVM> SystemCodeList = SystemCode.dict["StockManagementM_MonIdx"]; foreach (SystemCodeVM sc in SystemCodeList) { MonIdx.Items.Add(new ListItem(sc.EnumName, sc.EnumValue.ToString())); } } if (SystemCode.dict.ContainsKey("StockManagementM_OriFroIdx")) { List <SystemCodeVM> SystemCodeList = SystemCode.dict["StockManagementM_OriFroIdx"]; foreach (SystemCodeVM sc in SystemCodeList) { OriFroIdx.Items.Add(new ListItem(sc.EnumName, sc.EnumValue.ToString())); } } if (SystemCode.dict.ContainsKey("StockManagementM_DealType")) { List <SystemCodeVM> SystemCodeList = SystemCode.dict["StockManagementM_DealType"]; foreach (SystemCodeVM sc in SystemCodeList) { DealType.Items.Add(new ListItem(sc.EnumName, sc.EnumValue.ToString())); } } int VaccOutBatchDataID; HttpUtility.HtmlEncode(int.TryParse(Request.QueryString["VaccOutBatchDataID"], out VaccOutBatchDataID)); DataSet ds = new DataSet(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("usp_VaccineOut_xGetVaccineOutBatchData", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", VaccOutBatchDataID); 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) { DealDate.Text = dt1.Rows[0]["DealDate"].ToString(); DealType.SelectedValue = dt1.Rows[0]["DealType"].ToString(); if (DealType.SelectedValue == "4") { DealHospitalName.Visible = true; DealHospitalID.Value = dt1.Rows[0]["DealHospital"].ToString(); int dealHospitalID = 0; int.TryParse(DealHospitalID.Value, out dealHospitalID); DealHospitalName.Text = SystemOrg.GetName(dealHospitalID); } Remark.Text = dt1.Rows[0]["Remark"].ToString(); Num.Text = dt1.Rows[0]["Num"].ToString(); TempHigh.Text = Convert.ToDouble(dt1.Rows[0]["TempHigh"]).ToString(); FroIdx.SelectedValue = dt1.Rows[0]["FroIdx"].ToString(); TempLow.Text = Convert.ToDouble(dt1.Rows[0]["TempLow"]).ToString(); OriFroIdx.SelectedValue = dt1.Rows[0]["OriFroIdx"].ToString(); MonIdx.SelectedValue = dt1.Rows[0]["MonIdx"].ToString(); DownloadFile.PostBackUrl = "/Vaccine/StockManagementM/VaccineOut/DownloadFileOP.aspx?i=" + dt1.Rows[0]["FileInfoID"].ToString(); DownloadFile.Text = dt1.Rows[0]["DisplayFileName"].ToString(); } } DealType.Enabled = false; FroIdx.Enabled = false; OriFroIdx.Enabled = false; MonIdx.Enabled = false; }
protected void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("POST"); base.DisableTop(true); if (Page.PreviousPage != null) { if (PreviousPage.IsCrossPagePostBack == true) { System_PowerM_RolePowerSetting_Add page = (System_PowerM_RolePowerSetting_Add)PreviousPage; RoleName = PureString(page.RoleName); RoleDescription = PureString(page.RoleDescription); int RoleLevel = page.RoleLevel; RoleLevelName = PureString(page.RoleLevelName); int tmRoleCateID = GetNumber <int>("hfCateID"); if (tmRoleCateID == 0) { tmRoleCateID = 1; } RoleCateID = tmRoleCateID; RoleCateName = GetString("hfCateName"); if (RoleName.Length == 0) { Response.Redirect("~/System/PowerM/RolePowerSetting_Add.aspx"); } else { MyTreeData = GetMenu(); } var user = AuthServer.GetLoginUser(); Dictionary <string, object> OutDict = new Dictionary <string, object>() { { "@OutRoleID", OutRoleID } }; MSDB.ExecuteNonQuery("ConnUser", "dbo.usp_PowerM_xAddRole" , ref OutDict , new Dictionary <string, object>() { { "@RoleName", RoleName }, { "@RoleLevel", RoleLevel }, { "@RoleDescription", RoleDescription }, { "@RoleCateID", RoleCateID }, { "@CreatedUserID", user.ID } }); OutRoleID = (int)OutDict["@OutRoleID"]; string script = ""; if (OutRoleID <= 0) { script = "<script>alert('儲存失敗');location.href = '/System/PowerM/RolePowerSetting.aspx';</script>"; Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); } else { hfR.Value = OutRoleID.ToString(); } } } else if (this.IsPostBack == true) { MyTreeData = GetMenu(); DataTable dt = GetDataTable("ConnUser", "dbo.usp_PowerM_xGetRoleByID" , new Dictionary <string, object>() { { "@ID", int.Parse(hfR.Value) } }); RolePowerSettingVM VM = new RolePowerSettingVM(); EntityS.FillModel(VM, dt); RoleName = VM.RoleName; RoleDescription = VM.RoleDescription; int RoleLevel = VM.RoleLevel; switch (VM.RoleLevel) { case 1: RoleLevelName = "中央"; break; case 2: RoleLevelName = "區管中心"; break; case 3: RoleLevelName = "局"; break; case 4: RoleLevelName = "所"; break; } } else { Response.Redirect("~/System/PowerM/RolePowerSetting_Add.aspx"); } }
protected void Save_Click(object sender, EventArgs e) { UserVM user = AuthServer.GetLoginUser(); string script = ""; string message = CheckNeeded(); if (message.Length > 0) { script = "<script>alert('" + message + "');</script>"; Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "alert", script, false); return; } int OutFileInfoID = 0; bool UploadFileSuccess = true; int Success = 0; List <int> OutFileInfoID_List = new List <int>(); if (tbFile.HasFile == true) { HttpFileCollection multipleFiles = Request.Files; for (int fileCount = 0; fileCount < multipleFiles.Count; fileCount++) { HttpPostedFile uploadedFile = multipleFiles[fileCount]; string extension = ""; string[] ary = uploadedFile.FileName.Split('.'); if (ary.Length > 1) { extension = ary.Last(); } byte[] fileData = null; using (var binaryReader = new BinaryReader(uploadedFile.InputStream)) { fileData = binaryReader.ReadBytes(uploadedFile.ContentLength); } NIIS_WS.WebServiceSoapClient WS = new NIIS_WS.WebServiceSoapClient(); string contentType = tbFile.PostedFile.ContentType; OutFileInfoID = WS.UploadFile(3, contentType, extension, uploadedFile.FileName, user.ID, user.OrgID, fileData); if (OutFileInfoID < 1) { UploadFileSuccess = false; break; } else { OutFileInfoID_List.Add(OutFileInfoID); } } } string OutFileInfoIDs = string.Join(",", OutFileInfoID_List.Select(x => x.ToString()).ToArray()); int questionType = int.Parse(QuestionType.SelectedValue); string question = Question.Text.Trim(); string reply = Reply.Text.Trim(); int publishedStatus = 0; if (PublishedStatus1.Checked == true) { publishedStatus = 1; } if (PublishedStatus2.Checked == true) { publishedStatus = 2; } int ID = 0; int.TryParse(Request.QueryString["I"], out ID); if (UploadFileSuccess == true) { DataSet ds = new DataSet(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("usp_QnAData_xAddQnAData", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", ID); cmd.Parameters.AddWithValue("@QuestionType", questionType); cmd.Parameters.AddWithValue("@Question", question); cmd.Parameters.AddWithValue("@Answer", reply); cmd.Parameters.AddWithValue("@FileInfoIDs", OutFileInfoIDs); cmd.Parameters.AddWithValue("@QaStatus", publishedStatus); cmd.Parameters.AddWithValue("@ModifyAccount", user.ID); SqlParameter sp = cmd.Parameters.AddWithValue("@Success", Success); sp.Direction = ParameterDirection.Output; using (SqlDataAdapter da = new SqlDataAdapter(cmd)) { sc.Open(); cmd.ExecuteNonQuery(); Success = (int)sp.Value; } } } } if (UploadFileSuccess && Success > 0) { script = "<script>alert('儲存成功');location.href = '/System/FrequentlyAskedQuestionM/QnAData/QnAData.aspx';</script>"; } else { script = "<script>alert('儲存失敗');</script>"; } Page.ClientScript.RegisterStartupScript(this.Page.GetType(), "alert", script, false); }
protected void btnSave_Click(object sender, EventArgs e) { string script = ""; if (this.tbFile.HasFile == false) { script = "<script>alert('檔案無效');</style>"; Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); } HSSFWorkbook workbook = new HSSFWorkbook(this.tbFile.FileContent); var sheet = workbook.GetSheetAt(0); DataTable dt = new DataTable(); DataTable outDt = new DataTable(); outDt.Columns.Add("失敗原因"); outDt.Columns.Add("學校代碼"); outDt.Columns.Add("學校名稱"); outDt.Columns.Add("入學年度"); outDt.Columns.Add("級別\r\n(1 = 新生, 2 = 二年級)"); outDt.Columns.Add("BCG應補種人數"); outDt.Columns.Add("BCG實際補種人數"); outDt.Columns.Add("rHepB1應補種人數"); outDt.Columns.Add("rHepB1實際補種人數"); outDt.Columns.Add("rHepB2應補種人數"); outDt.Columns.Add("rHepB2實際補種人數"); outDt.Columns.Add("rHepB3應補種人數"); outDt.Columns.Add("rHepB3實際補種人數"); outDt.Columns.Add("5in1-1應補種人數"); outDt.Columns.Add("5in1-1實際補種人數"); outDt.Columns.Add("5in1-2應補種人數"); outDt.Columns.Add("5in1-2實際補種人數"); outDt.Columns.Add("5in1-3應補種人數"); outDt.Columns.Add("5in1-3實際補種人數"); outDt.Columns.Add("5in1-4應補種人數"); outDt.Columns.Add("5in1-4實際補種人數"); outDt.Columns.Add("Var應補種人數"); outDt.Columns.Add("Var實際補種人數"); outDt.Columns.Add("MMR1應補種人數"); outDt.Columns.Add("MMR1實際補種人數"); outDt.Columns.Add("MMR2應補種人數"); outDt.Columns.Add("MMR2實際補種人數"); outDt.Columns.Add("JE1應補種人數"); outDt.Columns.Add("JE1實際補種人數"); outDt.Columns.Add("JE2應補種人數"); outDt.Columns.Add("JE2實際補種人數"); outDt.Columns.Add("JE3應補種人數"); outDt.Columns.Add("JE3實際補種人數"); outDt.Columns.Add("JE4應補種人數"); outDt.Columns.Add("JE4實際補種人數"); outDt.Columns.Add("Tdap-IPV應補種人數"); outDt.Columns.Add("Tdap-IPV實際補種人數"); var headerRow = sheet.GetRow(1); int cellCount = headerRow.LastCellNum; for (int i = headerRow.FirstCellNum; i < cellCount; i++) { DataColumn dc = new DataColumn(headerRow.GetCell(i).ToString()); if (i >= 4) { if (i % 2 == 1) { dc.ColumnName = sheet.GetRow(0).GetCell(i - 1).ToString() + dc.ColumnName; } else { dc.ColumnName = sheet.GetRow(0).GetCell(i).ToString() + dc.ColumnName; } } else { dc.ColumnName = sheet.GetRow(0).GetCell(i).ToString(); } dt.Columns.Add(dc); } int rowCount = sheet.LastRowNum; for (int i2 = 2; i2 <= sheet.LastRowNum; i2++) { var row = sheet.GetRow(i2); DataRow dr = dt.NewRow(); for (int j = row.FirstCellNum; j < cellCount; j++) { if (row.GetCell(j) != null) { dr[j] = row.GetCell(j).ToString(); } } dt.Rows.Add(dr); } workbook = null; sheet = null; ElementaryRecordVM VM = new ElementaryRecordVM(); foreach (DataRow item in dt.Rows) { int Chk = 0; try { VM.SchoolCode = item[0].ToString(); VM.SchoolName = item[1].ToString(); VM.AdmissionYear = int.Parse(item[2].ToString()); VM.StudentYear = int.Parse(item[3].ToString()); List <ElementaryRecordDataVM> list = new List <ElementaryRecordDataVM>(); for (int i = 4; i <= dt.Columns.Count - 1; i++) { ElementaryRecordDataVM child = new ElementaryRecordDataVM(); switch (i) { case 4: case 5: child.VaccineDataID = 1; child.VaccineType = 1; break; case 6: case 7: child.VaccineDataID = 1; child.VaccineType = 2; break; case 8: case 9: child.VaccineDataID = 1; child.VaccineType = 3; break; case 10: case 11: child.VaccineDataID = 1; child.VaccineType = 4; break; case 12: case 13: child.VaccineDataID = 1; child.VaccineType = 9; break; case 14: case 15: child.VaccineDataID = 1; child.VaccineType = 10; break; case 16: case 17: child.VaccineDataID = 1; child.VaccineType = 11; break; case 18: case 19: child.VaccineDataID = 1; child.VaccineType = 12; break; case 20: case 21: child.VaccineDataID = 1; child.VaccineType = 13; break; case 22: case 23: child.VaccineDataID = 1; child.VaccineType = 14; break; case 24: case 25: child.VaccineDataID = 1; child.VaccineType = 15; break; case 26: case 27: child.VaccineDataID = 1; child.VaccineType = 16; break; case 28: case 29: child.VaccineDataID = 1; child.VaccineType = 17; break; case 30: case 31: child.VaccineDataID = 1; child.VaccineType = 18; break; case 32: case 33: child.VaccineDataID = 1; child.VaccineType = 19; break; case 34: case 35: child.VaccineDataID = 1; child.VaccineType = 20; break; case 36: case 37: child.VaccineDataID = 1; child.VaccineType = 21; break; case 38: case 39: child.VaccineDataID = 1; child.VaccineType = 22; break; case 40: case 41: child.VaccineDataID = 1; child.VaccineType = 23; break; case 42: case 43: child.VaccineDataID = 1; child.VaccineType = 24; break; } child.InoculationNumber = int.Parse(item[i].ToString()); child.ShouldInoculationNumber = child.InoculationNumber; list.Add(child); } var user = AuthServer.GetLoginUser(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("dbo.usp_RecordM_xAddElementaryRecord", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ElementarySchoolID", 1); cmd.Parameters.AddWithValue("@AdmissionYear", VM.AdmissionYear); cmd.Parameters.AddWithValue("@StudentNumber", VM.StudentNumber); cmd.Parameters.AddWithValue("@HasYellowCardNumber", VM.HasYellowCardNumber); cmd.Parameters.AddWithValue("@SignUserID", user.ID); cmd.Parameters.AddWithValue("@CreatedUserID", user.ID); cmd.Parameters.AddWithValue("@StudentYear", VM.StudentYear); cmd.Parameters.AddWithValue("@InoculationType", 2); cmd.Parameters.AddWithValue("@VaccineTypeString", string.Join(",", list.Select(x => x.VaccineType.ToString()))); cmd.Parameters.AddWithValue("@InoculationNumberString", string.Join(",", list.Select(x => x.InoculationNumber.ToString()))); cmd.Parameters.AddWithValue("@ShouldInoculationNumberString", string.Join(",", list.Select(x => x.ShouldInoculationNumber.ToString()))); cmd.Parameters.AddWithValue("@OrgID", user.OrgID); SqlParameter sp = cmd.Parameters.AddWithValue("@Chk", Chk); sp.Direction = ParameterDirection.Output; sc.Open(); cmd.ExecuteNonQuery(); Chk = (int)sp.Value; } } } catch { } if (Chk < 1) { List <object> list = new List <object>(); DataRow drNew = outDt.NewRow(); foreach (object obj in item.ItemArray) { list.Add(obj); } list.Insert(0, "失敗"); drNew.ItemArray = list.ToArray(); outDt.Rows.Add(drNew); } } script = ""; if (outDt.Rows.Count > 0) { //script = @"<script> // var popUpWindow = function (url, title, w, h) { // var left = (screen.width / 2) - (w / 2); // var top = (screen.height / 2) - (h / 2); // return window.open(url, title, 'toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,left=10000, top=10000, width=10, height=10, visible=none'); // }; // var openWindowWithPost = function(url, title, w, h, keys, values) { // var newWindow = popUpWindow(url, title, w, h); // if (!newWindow) return false; // var html = ''; // html += ""<html><head></head><body><form id='formid' method='post' target='_blank' action='"" + url + ""'>""; // keys = keys || []; // values = values || []; // if (keys && values && (keys.length == values.length)) // for (var i = 0; i < keys.length; i++) // html += ""<input type='hidden' name='"" + keys[i] + ""' value='"" + values[i] + ""'/>""; // html += ""</form></body></html>""; // newWindow.document.write(html); // newWindow.document.getElementById('formid').submit(); // setTimeout(function(){ // newWindow.close(); // },1000); // return newWindow; // };"; //script += @"alert('上傳失敗'); // var keys = []; // var values = []; // keys[0] = 'json'; // values[0] = encodeURI('" + JsonConvert.SerializeObject(outDt) + "');" + // " openWindowWithPost('/Ashx/JsonToExcel.ashx','_blank',100,100, keys, values);</script>"; script += @"<script>alert('上傳失敗'); document.getElementById('json').value='" + JsonConvert.SerializeObject(outDt) + "';document.getElementById('formid').submit();</script>"; } else { script = "<script>alert('上傳成功');location.href = '/Vaccination/RecordM/StudentRecord.aspx';</script><style>body{display:none;}</style>"; } Page.ClientScript.RegisterClientScriptBlock(this.Page.GetType(), "alert", script, false); }
protected override void OnInitComplete(EventArgs e) { if (BreakCheckPower == true) { return; } bool HasPower = false; //if (Request.UrlReferrer==null || Request.Url.Host.Equals(Request.UrlReferrer.Host)== false) //{ // throw new HttpException(404, "Not found"); //} var dictHasPowerCount = 0; Dictionary <string, bool> urls = new Dictionary <string, bool>(); foreach (var item in dict) { if (urls.ContainsKey(item.Key.PageUrl) == false) { urls[item.Key.PageUrl] = false; } item.Value.HasPower = CheckPower(item.Key.PageUrl, item.Key.myPowerEnum); if (item.Value.HasPower == true) { dictHasPowerCount++; } if (item.Key.myPowerEnum == MyPowerEnum.瀏覽) { urls[item.Key.PageUrl] = true; } } if (Request.Path.ToLower().Equals("/home.aspx") == true || Request.Path.ToLower().Equals("/leftmenu.aspx") == true || Request.Path.ToLower().Equals("/topheader.aspx") == true) { HasPower = true; } else { if (dict.Count > 0) { if ((dictHasPowerCount == dict.Count) || (powerLogicType == PowerLogicType.OR && dictHasPowerCount >= 1)) { HasPower = true; } foreach (var item in urls) { if (item.Value == false) { HasPower = CheckPower(item.Key, MyPowerEnum.瀏覽); if (powerLogicType == PowerLogicType.OR && HasPower == true) { break; } } } } else { HasPower = CheckPower(Request.Path, MyPowerEnum.瀏覽); } } if (HasPower == false) { UserVM user = AuthServer.GetLoginUser(); if (user != null) { throw new HttpException(404, "Not found"); } else { throw new HttpException(404, "Not found"); } } }
protected void BindData() {//<table> //<tbody><tr> //<th scope="col">疫苗別</th> //<th scope="col">訪查日期</th> //<th scope="col">訪查單位(人員)</th> //<th scope="col">訪查方式</th> //<th scope="col">訪查原因</th> //<th scope="col">訪查紀錄</th> //<th scope="col">附件</th> //<th scope="col">刪除</th> //</tr> //</tbody> //</table> int ViewOrgID = AuthServer.GetLoginUser().OrgID; CaseVisitTb.Controls.Clear(); Table tb = new Table(); TableRow thr = new TableRow(); TableHeaderCell th1 = new TableHeaderCell(); th1.Text = "疫苗別"; thr.Cells.Add(th1); TableHeaderCell th2 = new TableHeaderCell(); th2.Text = "訪查日期"; thr.Cells.Add(th2); TableHeaderCell th3 = new TableHeaderCell(); th3.Text = "訪查單位(人員)"; thr.Cells.Add(th3); TableHeaderCell th4 = new TableHeaderCell(); th4.Text = "訪查方式"; thr.Cells.Add(th4); TableHeaderCell th5 = new TableHeaderCell(); th5.Text = "訪查原因"; thr.Cells.Add(th5); TableHeaderCell th6 = new TableHeaderCell(); th6.Text = "訪查結果"; thr.Cells.Add(th6); TableHeaderCell th7 = new TableHeaderCell(); th7.Text = "附件"; thr.Cells.Add(th7); tb.Controls.Add(thr); DataTable dt = (DataTable) DBUtil.DBOp("ConnDB", @"exec [dbo].[usp_CaseVist_xCaseVisitListByDoseID] {0},{1} " , new string[] { CaseID.ToString() , DoseID }, NSDBUtil.CmdOpType.ExecuteReaderReturnDataTable); foreach (DataRow r in dt.Rows) { TableRow thd = new TableRow(); TableCell td1 = new TableCell(); td1.Text = r["疫苗別"].ToString(); thd.Cells.Add(td1); TableCell td2 = new TableCell(); td2.Text = r["訪查日期"].ToString(); thd.Cells.Add(td2); TableCell td3 = new TableCell(); td3.Text = r["訪查單位(人員)"].ToString(); thd.Cells.Add(td3); TableCell td4 = new TableCell(); td4.Text = SystemCode.GetName("CaseVisit_VisitType", Convert.ToInt32(r["訪查方式"])); thd.Cells.Add(td4); TableCell td5 = new TableCell(); td5.Text = SystemCode.GetName("CaseVisit_VisitReason", Convert.ToInt32(r["訪查原因"])); thd.Cells.Add(td5); TableCell td6 = new TableCell(); td6.Text = SystemCode.GetName("CaseVisit_VisitResult_Reason_" + r["訪查原因"], Convert.ToInt32(r["訪查結果"])); thd.Cells.Add(td6); TableCell td7 = new TableCell(); int VisitOrg; int.TryParse(r["VisitOrg"].ToString(), out VisitOrg); td7.Text = ShowFiles(Convert.ToInt32(r["VisitID"]), (VisitOrg == ViewOrgID)); thd.Cells.Add(td7); tb.Controls.Add(thd); } CaseVisitTb.Controls.Add(tb); }
protected new void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("GET", "POST"); base.DisableTop(false); if (Request.HttpMethod.Equals("POST")) { CaseUserID = GetNumber <int>("c"); RecordDataID = GetNumber <int>("i"); SystemRecordVaccineCode = GetString("r"); SystemRecordVaccineID = GetNumber <int>("ri"); AppointmentDate = GetString("a"); AppointmentDate = AppointmentDate.Length == 0 ? GetString("aa") ?? "" : AppointmentDate; DateTime date = default(DateTime); bool success = DateTime.TryParse(AppointmentDate, out date); AppointmentDate = date.ToShortTaiwanDate(); UpdateUID = GetNumber <int>("uu"); user = AuthServer.GetLoginUser(); DataTable dt = MSDB.GetDataTable("ConnDB", "dbo.usp_RecordM_xGetDefaultBatchVaccineByOrgIDVaccineID" , new Dictionary <string, object>() { { "@OrgID", user.OrgID }, { "@VaccineID", SystemRecordVaccineCode.Split('-')[0] } }); List <DefaultBatchVaccineVM> list = new List <DefaultBatchVaccineVM>(); EntityS.FillModel(list, dt); if (list.Count > 0) { tbAry = JsonConvert.SerializeObject(list); } Agency = user.OrgName; AgencyID = user.OrgID; if (this.IsPostBack == false) { lblVC.Text = SystemRecordVaccineCode; lblAD.Text = AppointmentDate; //hfc.Value = CaseUserID.ToString(); //hfi.Value = RecordDataID.ToString(); //hfr.Value = SystemRecordVaccineCode; //hfa.Value = AppointmentDate; if (UpdateUID == 0) { if (success == false || CaseUserID == 0 || RecordDataID == 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; } } tbDate.Text = DateTime.Now.ToShortTaiwanDate(); if (SystemCode.dict.ContainsKey("RecordM_ApplyRecord_ReSignReason")) { var codes = SystemCode.dict["RecordM_ApplyRecord_ReSignReason"]; ddlReason1.Items.Add(new ListItem("請選擇", "")); foreach (var item in codes) { ddlReason1.Items.Add(new ListItem(item.EnumName, item.EnumValue.ToString())); } } if (SystemCode.dict.ContainsKey("RecordM_ApplyRecord_ReInoculationReason")) { var codes = SystemCode.dict["RecordM_ApplyRecord_ReInoculationReason"]; ddlReason2.Items.Add(new ListItem("請選擇", "")); foreach (var item in codes) { ddlReason2.Items.Add(new ListItem(item.EnumName, item.EnumValue.ToString())); } } if (SystemCode.dict.ContainsKey("RecordM_ApplyRecord_EarlyLateReason")) { var codes = SystemCode.dict["RecordM_ApplyRecord_EarlyLateReason"]; ddlReason3.Items.Add(new ListItem("請選擇", "")); foreach (var item in codes) { ddlReason3.Items.Add(new ListItem(item.EnumName, item.EnumValue.ToString())); } } if (UpdateUID > 0) { dt = MSDB.GetDataTable("ConnDB", "dbo.usp_RecordM_xGetApplyRecordByID" , new Dictionary <string, object>() { { "@ID", UpdateUID } }); ApplyRecordVM VM = new ApplyRecordVM(); EntityS.FillModel(VM, dt); ddlReason1.SelectedValue = VM.ReSignReason.ToString(); ddlReason2.SelectedValue = VM.ReInoculationReason.ToString(); ddlReason3.SelectedValue = VM.EarlyLateReason.ToString(); var ary = VM.ReasonString.Split(','); if (ary.Length > 0) { tbReason1.Text = ary[0]; } if (ary.Length > 1) { tbReason2.Text = ary[1]; } if (ary.Length > 0) { tbReason3.Text = ary[2]; } cbSI.Checked = VM.SpecialInoculation; } } } else { Response.Write(""); Response.End(); } }
protected void Page_Load(object sender, EventArgs e) { ModifyPower = base.AddPower(list[0]); UploadPower = base.AddPower(list[1]); base.AllowHttpMethod("GET", "POST"); base.DisableTop(false); UserVM user = AuthServer.GetLoginUser(); DealHospitalName.Text = HttpUtility.HtmlEncode(Request.Form[DealHospitalName.UniqueID]); if (this.IsPostBack == false) { DealDate.Attributes.Add("onclick", "WdatePicker({ dateFmt: 'yyyMMdd',maxDate:'" + DateTime.Now.ToString("yyyy-MM-dd") + "', lang: 'zh-tw' })"); DealDateImg.Attributes.Add("onclick", "WdatePicker({ el:'" + DealDate.ClientID + "',dateFmt: 'yyyMMdd',maxDate:'" + DateTime.Now.ToString("yyyy-MM-dd") + "', lang: 'zh-tw' })"); if (SystemCode.dict.ContainsKey("StockManagementM_FroIdx")) { List <SystemCodeVM> SystemCodeList = SystemCode.dict["StockManagementM_FroIdx"]; foreach (SystemCodeVM sc in SystemCodeList) { FroIdx.Items.Add(new ListItem(sc.EnumName, sc.EnumValue.ToString())); } } if (SystemCode.dict.ContainsKey("StockManagementM_MonIdx")) { List <SystemCodeVM> SystemCodeList = SystemCode.dict["StockManagementM_MonIdx"]; foreach (SystemCodeVM sc in SystemCodeList) { MonIdx.Items.Add(new ListItem(sc.EnumName, sc.EnumValue.ToString())); } } if (SystemCode.dict.ContainsKey("StockManagementM_OriFroIdx")) { List <SystemCodeVM> SystemCodeList = SystemCode.dict["StockManagementM_OriFroIdx"]; foreach (SystemCodeVM sc in SystemCodeList) { OriFroIdx.Items.Add(new ListItem(sc.EnumName, sc.EnumValue.ToString())); } } if (SystemCode.dict.ContainsKey("StockManagementM_DealType")) { List <SystemCodeVM> SystemCodeList = SystemCode.dict["StockManagementM_DealType"]; foreach (SystemCodeVM sc in SystemCodeList) { DealType.Items.Add(new ListItem(sc.EnumName, sc.EnumValue.ToString())); } } int VaccInBatchDataID; HttpUtility.HtmlEncode(int.TryParse(Request.QueryString["BI"], out VaccInBatchDataID)); DataSet ds = new DataSet(); using (SqlConnection sc = new SqlConnection(WebConfigurationManager.ConnectionStrings["ConnDB"].ToString())) { using (SqlCommand cmd = new SqlCommand("usp_VaccineIn_xGetVaccineInBatchData", sc)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@ID", VaccInBatchDataID); 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) { DealDate.Text = dt1.Rows[0]["DealDate"].ToString(); DealType.SelectedValue = dt1.Rows[0]["DealType"].ToString(); if (DealType.SelectedValue == "4") { DealHospitalName.Visible = true; DealHospitalImg.Visible = true; DealHospitalID.Value = dt1.Rows[0]["DealHospital"].ToString(); int dealHospitalID = 0; int.TryParse(DealHospitalID.Value, out dealHospitalID); DealHospitalName.Text = SystemOrg.GetName(dealHospitalID); } Remark.Text = dt1.Rows[0]["Remark"].ToString(); Num.Text = dt1.Rows[0]["Num"].ToString(); TempHigh.Text = Convert.ToDouble(dt1.Rows[0]["TempHigh"]).ToString(); FroIdx.SelectedValue = dt1.Rows[0]["FroIdx"].ToString(); TempLow.Text = Convert.ToDouble(dt1.Rows[0]["TempLow"]).ToString(); OriFroIdx.SelectedValue = dt1.Rows[0]["OriFroIdx"].ToString(); MonIdx.SelectedValue = dt1.Rows[0]["MonIdx"].ToString(); } } OriFroIdx.Enabled = false; }
protected new void Page_Load(object sender, EventArgs e) { base.AllowHttpMethod("GET", "POST"); base.DisableTop(false); string VaccineID = GetString("v"); if (Request.HttpMethod.Equals("POST")) { if (this.IsPostBack == false) { var user = AuthServer.GetLoginUser(); DataTable dt = MSDB.GetDataTable("ConnDB", "dbo.usp_RecordM_xGetDefaultBatchVaccineByOrgIDWithoutVaccineID" , new Dictionary <string, object>() { { "@OrgID", user.OrgID }, { "@VaccineID", VaccineID } }); List <DefaultBatchVaccineVM> list = new List <DefaultBatchVaccineVM>(); EntityS.FillModel(list, dt); List <DefaultBatchVaccineVM> outList = new List <DefaultBatchVaccineVM>(); var indexList = new List <Tuple <int, int> >(); foreach (var item in list) { bool HasValue = false; int index = 0; indexList.ForEach((innerItem) => { if (HasValue == false) { if (innerItem.Item1 == item.VaccineBatchID) { HasValue = true; } else { index++; } } }); if (HasValue == false) { outList.Add(item); indexList.Add(Tuple.Create(item.VaccineBatchID, outList.Count - 1)); } else { outList[index].Storage += item.Storage; } } outList.RemoveAll((item) => item.Storage == 0); tbAry = JsonConvert.SerializeObject(outList); } } else { Response.Write(""); Response.End(); } }