public string[] ComparisonAidsData(StudentDataBasic DateItem) { string[] returnValue = new string[2]; AspAjax asp = new AspAjax(); try { StudentDataBasic BasicData = asp.getStudentAidsDataBaseBasic(DateItem.studentID); if (DateItem.assistmanageR != BasicData.assistmanageR || DateItem.brandR != BasicData.brandR || DateItem.modelR != BasicData.modelR || DateItem.buyingPlaceR != BasicData.buyingPlaceR || DateItem.buyingtimeR != BasicData.buyingtimeR || DateItem.insertHospitalR != BasicData.insertHospitalR || DateItem.openHzDateR != BasicData.openHzDateR || DateItem.assistmanageL != BasicData.assistmanageL || DateItem.brandL != BasicData.brandL || DateItem.modelL != BasicData.modelL || DateItem.buyingtimeL != BasicData.buyingtimeL || DateItem.buyingPlaceL != BasicData.buyingPlaceL || DateItem.insertHospitalL != BasicData.insertHospitalL || DateItem.openHzDateL != BasicData.openHzDateL) { CreateStudentAidsUse AidsUseData = new CreateStudentAidsUse(); AidsUseData.studentID = DateItem.studentID; AidsUseData.assistmanageR = DateItem.assistmanageR; AidsUseData.brandR = DateItem.brandR; AidsUseData.modelR = DateItem.modelR; AidsUseData.buyingPlaceR = DateItem.buyingPlaceR; AidsUseData.buyingtimeR = DateItem.buyingtimeR; AidsUseData.insertHospitalR = DateItem.insertHospitalR; AidsUseData.openHzDateR = DateItem.openHzDateR; AidsUseData.assistmanageL = DateItem.assistmanageL; AidsUseData.brandL = DateItem.brandL; AidsUseData.modelL = DateItem.modelL; AidsUseData.buyingtimeL = DateItem.buyingtimeL; AidsUseData.buyingPlaceL = DateItem.buyingPlaceL; AidsUseData.insertHospitalL = DateItem.insertHospitalL; AidsUseData.openHzDateL = DateItem.openHzDateL; // string[] item=this.createStudentAidsUse(AidsUseData); DateItem.ID = BasicData.ID; returnValue = this.setStudentDataHearingInformation(DateItem); } } catch (Exception e) { returnValue[0] = "-1"; returnValue[1] = e.Message.ToString(); } return returnValue; }
public string[] createHearingAssessmentData(CreateHearingAssessment StructData) { string[] returnValue = new string[2]; returnValue[0] = "0"; returnValue[1] = ""; DataBase Base = new DataBase(); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { StaffDataBase sDB = new StaffDataBase(); List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name); Sqlconn.Open(); string sql = "INSERT INTO HearingAssessment (Unit, CheckDate, StudentID, Age, AgeMonth, UseAids, HearingAids_R, AidsBrand_R, AidsModel_R, AidsOptionalTime_R, "+ "AidsOptionalLocation_R, EEarHospital_R, EEarOpen_R, HearingAids_L, AidsBrand_L, AidsModel_L, AidsOptionalTime_L, AidsOptionalLocation_L, EEarHospital_L, "+ "EEarOpen_L, Purpose, PurposeText, PurposeExplain, Observation, ObservationExplain, RightEar, LeftEar, RightDecibel, RightDegree, " + "RightExplain, LeftDecibel, LeftDegree, LeftExplain, TestResult, AssessRAids, AssessRExplain, AssessLAids, AssessLExplain, VerificationRAids, " + "VerificationRExplain, VerificationLAids, VerificationLExplain, OtherAssess, OtherAssessExplain, ManageSuggestion, ManageSuggestionHour, OperateSuggestion, " + "suggestion, suggestionExplain, NextDate, CreateFileBy, UpFileBy, UpFileDate) " + "VALUES(@Unit, @CheckDate, @StudentID, @Age, @AgeMonth, @UseAids, @HearingAids_R, @AidsBrand_R, @AidsModel_R, @AidsOptionalTime_R, @AidsOptionalLocation_R, "+ "@EEarHospital_R, @EEarOpen_R, @HearingAids_L, @AidsBrand_L, @AidsModel_L, @AidsOptionalTime_L, @AidsOptionalLocation_L, @EEarHospital_L, @EEarOpen_L, "+ "@Purpose, @PurposeText, @PurposeExplain, @Observation, @ObservationExplain, @RightEar, @LeftEar, @RightDecibel, @RightDegree, @RightExplain, " + "@LeftDecibel, @LeftDegree, @LeftExplain, @TestResult, @AssessRAids, @AssessRExplain, @AssessLAids, @AssessLExplain, @VerificationRAids, " + "@VerificationRExplain, @VerificationLAids, @VerificationLExplain, @OtherAssess, @OtherAssessExplain, @ManageSuggestion, @ManageSuggestionHour, " + "@OperateSuggestion, @suggestion, @suggestionExplain, @NextDate, @CreateFileBy, @UpFileBy, (getDate()))"; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@Unit", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[2].ToString()); cmd.Parameters.Add("@CheckDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.checkDate); cmd.Parameters.Add("@StudentID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.studentID); cmd.Parameters.Add("@Age", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.studentAge); cmd.Parameters.Add("@AgeMonth", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.studentMonth); cmd.Parameters.Add("@UseAids", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.studentUseAids); cmd.Parameters.Add("@HearingAids_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.assistmanageR); cmd.Parameters.Add("@AidsBrand_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.brandR); cmd.Parameters.Add("@AidsModel_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.modelR); cmd.Parameters.Add("@AidsOptionalTime_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.buyingtimeR); cmd.Parameters.Add("@AidsOptionalLocation_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.buyingPlaceR); cmd.Parameters.Add("@EEarHospital_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.insertHospitalR); cmd.Parameters.Add("@EEarOpen_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.openHzDateR); cmd.Parameters.Add("@HearingAids_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.assistmanageL); cmd.Parameters.Add("@AidsBrand_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.brandL); cmd.Parameters.Add("@AidsModel_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.modelL); cmd.Parameters.Add("@AidsOptionalTime_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.buyingtimeL); cmd.Parameters.Add("@AidsOptionalLocation_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.buyingPlaceL); cmd.Parameters.Add("@EEarHospital_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.insertHospitalL); cmd.Parameters.Add("@EEarOpen_L", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.openHzDateL); cmd.Parameters.Add("@Purpose", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.detectionPurposes); cmd.Parameters.Add("@PurposeText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.detectionPurposesText); cmd.Parameters.Add("@PurposeExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.explain); cmd.Parameters.Add("@Observation", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.observation); cmd.Parameters.Add("@ObservationExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.observationExplain); cmd.Parameters.Add("@RightEar", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.checkR); cmd.Parameters.Add("@LeftEar", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.checkL); cmd.Parameters.Add("@RightDecibel", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.checkRecibelR); cmd.Parameters.Add("@RightDegree", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.checkLossR); cmd.Parameters.Add("@RightExplain", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.checkCategoryR); cmd.Parameters.Add("@LeftDecibel", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.checkRecibelL); cmd.Parameters.Add("@LeftDegree", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.checkLossL); cmd.Parameters.Add("@LeftExplain", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.checkCategoryL); cmd.Parameters.Add("@TestResult", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkResult); cmd.Parameters.Add("@AssessRAids", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.checkAidsResultR); cmd.Parameters.Add("@AssessRExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkAidsResultRText); cmd.Parameters.Add("@AssessLAids", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.checkAidsResultL); cmd.Parameters.Add("@AssessLExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkAidsResultLText); cmd.Parameters.Add("@VerificationRAids", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.effectR); cmd.Parameters.Add("@VerificationRExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.effectRText); cmd.Parameters.Add("@VerificationLAids", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.effectL); cmd.Parameters.Add("@VerificationLExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.effectLText); cmd.Parameters.Add("@OtherAssess", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.effectOther); cmd.Parameters.Add("@OtherAssessExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.effectOtherText); cmd.Parameters.Add("@ManageSuggestion", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.suggestion); cmd.Parameters.Add("@ManageSuggestionHour", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.suggestionHour); cmd.Parameters.Add("@OperateSuggestion", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.suggestion2); cmd.Parameters.Add("@suggestion", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.suggestion3); cmd.Parameters.Add("@suggestionExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.suggestion3Text); cmd.Parameters.Add("@NextDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.checkNextDate); cmd.Parameters.Add("@CreateFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]); cmd.Parameters.Add("@UpFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]); returnValue[0] = cmd.ExecuteNonQuery().ToString(); if (returnValue[0] != "0") { sql = "select IDENT_CURRENT('HearingAssessment') AS cID"; cmd = new SqlCommand(sql, Sqlconn); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { returnValue[1] = dr["cID"].ToString(); } dr.Close(); StudentDataBasic DateItem = new StudentDataBasic(); DateItem.studentID = StructData.studentID; DateItem.assistmanageR = StructData.assistmanageR; DateItem.brandR = StructData.brandR; DateItem.modelR = StructData.modelR; DateItem.buyingPlaceR = StructData.buyingPlaceR; DateItem.buyingtimeR = StructData.buyingtimeR; DateItem.insertHospitalR = StructData.insertHospitalR; DateItem.openHzDateR = StructData.openHzDateR; DateItem.assistmanageL = StructData.assistmanageL; DateItem.brandL = StructData.brandL; DateItem.modelL = StructData.modelL; DateItem.buyingtimeL = StructData.buyingtimeL; DateItem.buyingPlaceL = StructData.buyingPlaceL; DateItem.insertHospitalL = StructData.insertHospitalL; DateItem.openHzDateL = StructData.openHzDateL; this.ComparisonAidsData(DateItem); } Sqlconn.Close(); } catch (Exception e) { returnValue[0] = "-1"; returnValue[1] = e.Message.ToString(); } } return returnValue; }
public string[] createHearingInspectionData(CreateHearingInspection StructData) { string[] returnValue = new string[2]; returnValue[0] = "0"; returnValue[1] = ""; DataBase Base = new DataBase(); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { StaffDataBase sDB = new StaffDataBase(); List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name); Sqlconn.Open(); string sql = "INSERT INTO HearingInspection (Unit, CheckDate, StudentID, CheckType, Credibility,HearingAids_R, "+ "AidsBrand_R, AidsModel_R, AidsOptionalTime_R, "+ "AidsOptionalLocation_R, EEarHospital_R, EEarOpen_R, HearingAids_L, AidsBrand_L, AidsModel_L, AidsOptionalTime_L, "+ "AidsOptionalLocation_L, EEarHospital_L,"+ "EEarOpen_L, ListenCheck, Earphones, NakedEar, HearingAfter, PureToneImg, PrueRDecibel, PrueLDecibel, EarEndoscopyRight, " + "EarEndoscopyRExplain, EarEndoscopyLeft, EarEndoscopyLExplain, TympanicCavity, PatternRight, PatternLeft, CanalRight, CanalLeft, "+ "EardrumRight, " + "EardrumLeft, PressureRight, PressureLeft, AidsDetectRight1, AidsDetectRight2, AidsDetectLeft1, AidsDetectLeft2, AidsDetect, "+ "VoiceMaterial1, VoiceWear1, " + "VoiceState1, VoiceVolume1, VoiceResult1, VoiceRemark1, VoiceMaterial2, VoiceWear2, VoiceState2, VoiceVolume2, VoiceResult2, "+ "VoiceRemark2, VoiceItem3, " + "VoiceMaterial3, VoiceWear3, VoiceState3, VoiceVolume3, VoiceResult3, VoiceRemark3, VoiceItem4, VoiceMaterial4, VoiceWear4, "+ "VoiceState4, VoiceVolume4, " + "VoiceResult4, VoiceRemark4, VoicePurpose, VoicePurposeExplain, VoiceExplain, CreateFileBy, UpFileBy, UpFileDate,"+ "material1,SATVolumeBefore,SATREarBefore,SATLEarBefore,SATEarBefore,SATVolumeAfter,SATREarAfter,SATLEarAfter,SATEarAfter,"+ "WRSVolumeBefore,WRSREarBefore,WRSLEarBefore,WRSEarBefore,WRSVolumeAfter,WRSREarAfter,WRSLEarAfter,WRSEarAfter," + "material2,material3,project3,project3VolumeBefore,project3REarBefore,project3LEarBefore,project3EarBefore,"+ "project3VolumeAfter,project3REarAfter,project3LEarAfter,project3EarAfter," + "material4,project4,project4VolumeBefore,project4REarBefore,project4LEarBefore,project4EarBefore," + "project4VolumeAfter,project4REarAfter,project4LEarAfter,project4EarAfter," + "checkPurposeText,checkPurpose,explain" + ") " + "VALUES(@Unit, @CheckDate, @StudentID, @CheckType, @Credibility, @HearingAids_R, @AidsBrand_R, @AidsModel_R, @AidsOptionalTime_R, "+ "@AidsOptionalLocation_R, "+ "@EEarHospital_R, @EEarOpen_R, @HearingAids_L, @AidsBrand_L, @AidsModel_L, @AidsOptionalTime_L, @AidsOptionalLocation_L, "+ "@EEarHospital_L, @EEarOpen_L, "+ "@ListenCheck, @Earphones, @NakedEar, @HearingAfter, @PureToneImg, @PrueRDecibel, @PrueLDecibel, @EarEndoscopyRight, "+ "@EarEndoscopyRExplain, " + "@EarEndoscopyLeft, @EarEndoscopyLExplain, @TympanicCavity, @PatternRight, @PatternLeft, @CanalRight, @CanalLeft, "+ "@EardrumRight, @EardrumLeft, " + "@PressureRight, @PressureLeft, @AidsDetectRight1, @AidsDetectRight2, @AidsDetectLeft1, @AidsDetectLeft2, @AidsDetect, "+ "@VoiceMaterial1, @VoiceWear1, " + "@VoiceState1, @VoiceVolume1, @VoiceResult1, @VoiceRemark1, @VoiceMaterial2, @VoiceWear2, @VoiceState2, @VoiceVolume2, "+ "@VoiceResult2, @VoiceRemark2, " + "@VoiceItem3, @VoiceMaterial3, @VoiceWear3, @VoiceState3, @VoiceVolume3, @VoiceResult3, @VoiceRemark3, @VoiceItem4, "+ "@VoiceMaterial4, @VoiceWear4, " + "@VoiceState4, @VoiceVolume4, @VoiceResult4, @VoiceRemark4, @VoicePurpose, @VoicePurposeExplain, @VoiceExplain, "+ "@CreateFileBy, @UpFileBy, (getDate()),"+ "@material1,@SATVolumeBefore,@SATREarBefore,@SATLEarBefore,@SATEarBefore,@SATVolumeAfter,@SATREarAfter,@SATLEarAfter,@SATEarAfter,"+ "@WRSVolumeBefore,@WRSREarBefore,@WRSLEarBefore,@WRSEarBefore,@WRSVolumeAfter,@WRSREarAfter,@WRSLEarAfter,@WRSEarAfter," + "@material2,@material3,@project3,@project3VolumeBefore,@project3REarBefore,@project3LEarBefore,@project3EarBefore," + "@project3VolumeAfter,@project3REarAfter,@project3LEarAfter,@project3EarAfter," + "@material4,@project4,@project4VolumeBefore,@project4REarBefore,@project4LEarBefore,@project4EarBefore," + "@project4VolumeAfter,@project4REarAfter,@project4LEarAfter,@project4EarAfter," + "@checkPurposeText,@checkPurpose,@explain" + ")"; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@material1 ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material1); cmd.Parameters.Add("@SATVolumeBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATVolumeBefore); cmd.Parameters.Add("@SATREarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATREarBefore); cmd.Parameters.Add("@SATLEarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATLEarBefore); cmd.Parameters.Add("@SATEarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATEarBefore); cmd.Parameters.Add("@SATVolumeAfter ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATVolumeAfter); cmd.Parameters.Add("@SATREarAfter ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATREarAfter); cmd.Parameters.Add("@SATLEarAfter ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATLEarAfter); cmd.Parameters.Add("@SATEarAfter ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATEarAfter); cmd.Parameters.Add("@WRSVolumeBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSVolumeBefore); cmd.Parameters.Add("@WRSREarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSREarBefore); cmd.Parameters.Add("@WRSLEarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSLEarBefore); cmd.Parameters.Add("@WRSEarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSEarBefore); cmd.Parameters.Add("@WRSVolumeAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSVolumeAfter); cmd.Parameters.Add("@WRSREarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSREarAfter); cmd.Parameters.Add("@WRSLEarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSLEarAfter); cmd.Parameters.Add("@WRSEarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSEarAfter); cmd.Parameters.Add("@material3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material3); cmd.Parameters.Add("@project3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3); cmd.Parameters.Add("@material2", SqlDbType.TinyInt).Value = StructData.material2; cmd.Parameters.Add("@project3VolumeBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3VolumeBefore); cmd.Parameters.Add("@project3REarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3REarBefore); cmd.Parameters.Add("@project3LEarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3LEarBefore); cmd.Parameters.Add("@project3EarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3EarBefore); cmd.Parameters.Add("@project3VolumeAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3VolumeAfter); cmd.Parameters.Add("@project3REarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3REarAfter); cmd.Parameters.Add("@project3LEarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3LEarAfter); cmd.Parameters.Add("@project3EarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3EarAfter); cmd.Parameters.Add("@project4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4); cmd.Parameters.Add("@material4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material4); cmd.Parameters.Add("@project4VolumeBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4VolumeBefore); cmd.Parameters.Add("@project4REarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4REarBefore); cmd.Parameters.Add("@project4LEarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4LEarBefore); cmd.Parameters.Add("@project4EarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4EarBefore); cmd.Parameters.Add("@project4VolumeAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4VolumeAfter); cmd.Parameters.Add("@project4REarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4REarAfter); cmd.Parameters.Add("@project4LEarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4LEarAfter); cmd.Parameters.Add("@project4EarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4EarAfter); cmd.Parameters.Add("@checkPurposeText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkPurposeText); cmd.Parameters.Add("@checkPurpose", SqlDbType.TinyInt).Value = StructData.checkPurpose; cmd.Parameters.Add("@explain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.explain); cmd.Parameters.Add("@Unit", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[2].ToString()); cmd.Parameters.Add("@CheckDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.checkDate); cmd.Parameters.Add("@StudentID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.studentID); cmd.Parameters.Add("@CheckType", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkMode); cmd.Parameters.Add("@Credibility", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.credibility); cmd.Parameters.Add("@HearingAids_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.assistmanageR); cmd.Parameters.Add("@AidsBrand_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.brandR); cmd.Parameters.Add("@AidsModel_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.modelR); cmd.Parameters.Add("@AidsOptionalTime_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.buyingtimeR); cmd.Parameters.Add("@AidsOptionalLocation_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.buyingPlaceR); cmd.Parameters.Add("@EEarHospital_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.insertHospitalR); cmd.Parameters.Add("@EEarOpen_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.openHzDateR); cmd.Parameters.Add("@HearingAids_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.assistmanageL); cmd.Parameters.Add("@AidsBrand_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.brandL); cmd.Parameters.Add("@AidsModel_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.modelL); cmd.Parameters.Add("@AidsOptionalTime_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.buyingtimeL); cmd.Parameters.Add("@AidsOptionalLocation_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.buyingPlaceL); cmd.Parameters.Add("@EEarHospital_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.insertHospitalL); cmd.Parameters.Add("@EEarOpen_L", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.openHzDateL); cmd.Parameters.Add("@ListenCheck", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkInstrument); cmd.Parameters.Add("@Earphones", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.headphone); cmd.Parameters.Add("@NakedEar", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.nudetonety); cmd.Parameters.Add("@HearingAfter", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.hearingtone); cmd.Parameters.Add("@PureToneImg", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingtoneImg); cmd.Parameters.Add("@PrueRDecibel", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.toneR); cmd.Parameters.Add("@PrueLDecibel", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.toneL); cmd.Parameters.Add("@EarEndoscopyRight", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.hearingtoneR); cmd.Parameters.Add("@EarEndoscopyRExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingtoneRText); cmd.Parameters.Add("@EarEndoscopyLeft", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.hearingtoneL); cmd.Parameters.Add("@EarEndoscopyLExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingtoneLText); cmd.Parameters.Add("@TympanicCavity", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingInstrument); cmd.Parameters.Add("@PatternRight", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingImgR); cmd.Parameters.Add("@PatternLeft", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingImgL); cmd.Parameters.Add("@CanalRight", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingVolumeR); cmd.Parameters.Add("@CanalLeft", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingVolumeL); cmd.Parameters.Add("@EardrumRight", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.conformR); cmd.Parameters.Add("@EardrumLeft", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.conformL); cmd.Parameters.Add("@PressureRight", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.pressureR); cmd.Parameters.Add("@PressureLeft", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.pressureL); cmd.Parameters.Add("@AidsDetectRight1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.aidsR); cmd.Parameters.Add("@AidsDetectRight2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.aidsdetectR); cmd.Parameters.Add("@AidsDetectLeft1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.aidsL); cmd.Parameters.Add("@AidsDetectLeft2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.aidsdetectL); cmd.Parameters.Add("@AidsDetect", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.aidsOther); cmd.Parameters.Add("@VoiceMaterial1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material1); cmd.Parameters.Add("@VoiceWear1", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.voice1); cmd.Parameters.Add("@VoiceState1", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.state1); cmd.Parameters.Add("@VoiceVolume1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.volume1); cmd.Parameters.Add("@VoiceResult1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result1); cmd.Parameters.Add("@VoiceRemark1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.remark1); cmd.Parameters.Add("@VoiceMaterial2", SqlDbType.NVarChar).Value = StructData.material2.ToString(); cmd.Parameters.Add("@VoiceWear2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.voice2); cmd.Parameters.Add("@VoiceState2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.state2); cmd.Parameters.Add("@VoiceVolume2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.volume2); cmd.Parameters.Add("@VoiceResult2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result2); cmd.Parameters.Add("@VoiceRemark2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.remark2); cmd.Parameters.Add("@VoiceItem3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3); cmd.Parameters.Add("@VoiceMaterial3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material3); cmd.Parameters.Add("@VoiceWear3", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.voice3); cmd.Parameters.Add("@VoiceState3", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.state3); cmd.Parameters.Add("@VoiceVolume3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.volume3); cmd.Parameters.Add("@VoiceResult3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result3); cmd.Parameters.Add("@VoiceRemark3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.remark3); cmd.Parameters.Add("@VoiceItem4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4); cmd.Parameters.Add("@VoiceMaterial4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material4); cmd.Parameters.Add("@VoiceWear4", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.voice4); cmd.Parameters.Add("@VoiceState4", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.state4); cmd.Parameters.Add("@VoiceVolume4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.volume4); cmd.Parameters.Add("@VoiceResult4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result4); cmd.Parameters.Add("@VoiceRemark4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.remark4); cmd.Parameters.Add("@VoicePurpose", SqlDbType.TinyInt).Value = StructData.checkPurpose; cmd.Parameters.Add("@VoicePurposeExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkPurposeText); cmd.Parameters.Add("@VoiceExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.explain); cmd.Parameters.Add("@CreateFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]); cmd.Parameters.Add("@UpFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]); returnValue[0] = cmd.ExecuteNonQuery().ToString(); if (returnValue[0] != "0") { sql = "select IDENT_CURRENT('HearingInspection') AS cID"; cmd = new SqlCommand(sql, Sqlconn); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { returnValue[1] = dr["cID"].ToString(); } dr.Close(); StudentDataBasic DateItem = new StudentDataBasic(); DateItem.studentID = StructData.studentID; DateItem.assistmanageR = StructData.assistmanageR; DateItem.brandR = StructData.brandR; DateItem.modelR = StructData.modelR; DateItem.buyingPlaceR = StructData.buyingPlaceR; DateItem.buyingtimeR = StructData.buyingtimeR; DateItem.insertHospitalR = StructData.insertHospitalR; DateItem.openHzDateR = StructData.openHzDateR; DateItem.assistmanageL = StructData.assistmanageL; DateItem.brandL = StructData.brandL; DateItem.modelL = StructData.modelL; DateItem.buyingtimeL = StructData.buyingtimeL; DateItem.buyingPlaceL = StructData.buyingPlaceL; DateItem.insertHospitalL = StructData.insertHospitalL; DateItem.openHzDateL = StructData.openHzDateL; this.ComparisonAidsData(DateItem); CreateStudentAidsUse AidsUse = new CreateStudentAidsUse(); AidsUse.assessDate = StructData.checkDate; AidsUse.studentID = StructData.studentID; AidsUse.assistmanageR = StructData.assistmanageR; AidsUse.brandR = StructData.brandR; AidsUse.modelR = StructData.modelR; AidsUse.buyingPlaceR = StructData.buyingPlaceR; AidsUse.buyingtimeR = StructData.buyingtimeR; AidsUse.insertHospitalR = StructData.insertHospitalR; AidsUse.openHzDateR = StructData.openHzDateR; AidsUse.assistmanageL = StructData.assistmanageL; AidsUse.brandL = StructData.brandL; AidsUse.modelL = StructData.modelL; AidsUse.buyingtimeL = StructData.buyingtimeL; AidsUse.buyingPlaceL = StructData.buyingPlaceL; AidsUse.insertHospitalL = StructData.insertHospitalL; AidsUse.openHzDateL = StructData.openHzDateL; createStudentAidsUse(AidsUse); } Sqlconn.Close(); } catch (Exception e) { returnValue[0] = "-1"; returnValue[1] = e.Message.ToString(); } } return returnValue; }
private string[] setStudentDataHearingInformation(StudentDataBasic StudentHearing) { string[] returnValue = new string[2]; returnValue[0] = "0"; returnValue[1] = ""; DataBase Base = new DataBase(); SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()); using (Sqlconn) { try { Sqlconn.Open(); string sql = "UPDATE StudentDatabase SET HearingAids_R=@HearingAids_R, AidsBrand_R=@AidsBrand_R, AidsModel_R=@AidsModel_R, AidsOptionalTime_R=@AidsOptionalTime_R, " + "AidsOptionalLocation_R=@AidsOptionalLocation_R, EEarHospital_R=@EEarHospital_R,EEarOpen_R=@EEarOpen_R, " + "HearingAids_L=@HearingAids_L, AidsBrand_L=@AidsBrand_L, AidsModel_L=@AidsModel_L, AidsOptionalTime_L=@AidsOptionalTime_L, AidsOptionalLocation_L=@AidsOptionalLocation_L, " + "EEarHospital_L=@EEarHospital_L, EEarOpen_L=@EEarOpen_L " + "WHERE ID=@ID "; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.ID); cmd.Parameters.Add("@HearingAids_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.assistmanageR); cmd.Parameters.Add("@AidsBrand_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.brandR); cmd.Parameters.Add("@AidsModel_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.modelR); cmd.Parameters.Add("@AidsOptionalTime_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.buyingtimeR); cmd.Parameters.Add("@AidsOptionalLocation_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.buyingPlaceR); cmd.Parameters.Add("@EEarHospital_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.insertHospitalR); cmd.Parameters.Add("@EEarOpen_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.openHzDateR); cmd.Parameters.Add("@HearingAids_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.assistmanageL); cmd.Parameters.Add("@AidsBrand_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.brandL); cmd.Parameters.Add("@AidsModel_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.modelL); cmd.Parameters.Add("@AidsOptionalTime_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.buyingtimeL); cmd.Parameters.Add("@AidsOptionalLocation_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.buyingPlaceL); cmd.Parameters.Add("@EEarHospital_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.insertHospitalL); cmd.Parameters.Add("@EEarOpen_L", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.openHzDateL); returnValue[0] = cmd.ExecuteNonQuery().ToString(); Sqlconn.Close(); } catch (Exception e) { returnValue[0] = "-1"; returnValue[1] = e.Message; } } return returnValue; }
public string[] setHearingInspectionData(CreateHearingInspection StructData) { string[] returnValue = new string[2]; returnValue[0] = "0"; returnValue[1] = ""; string PicUpdatestring = ""; if (StructData.hearingtoneImg != null) { PicUpdatestring = "PureToneImg=@PureToneImg, "; } DataBase Base = new DataBase(); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { StaffDataBase sDB = new StaffDataBase(); List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name); Sqlconn.Open(); string sql = "UPDATE HearingInspection SET CheckDate=@CheckDate, StudentID=@StudentID, CheckType=@CheckType, Credibility=@Credibility, "+PicUpdatestring+ "HearingAids_R=@HearingAids_R, AidsBrand_R=@AidsBrand_R, AidsModel_R=@AidsModel_R, AidsOptionalTime_R=@AidsOptionalTime_R, " + "AidsOptionalLocation_R=@AidsOptionalLocation_R, EEarHospital_R=@EEarHospital_R,EEarOpen_R=@EEarOpen_R, " + "HearingAids_L=@HearingAids_L, AidsBrand_L=@AidsBrand_L, AidsModel_L=@AidsModel_L, AidsOptionalTime_L=@AidsOptionalTime_L, "+ "AidsOptionalLocation_L=@AidsOptionalLocation_L, EEarHospital_L=@EEarHospital_L, EEarOpen_L=@EEarOpen_L, ListenCheck=@ListenCheck, "+ "Earphones=@Earphones, NakedEar=@NakedEar, HearingAfter=@HearingAfter, PrueRDecibel=@PrueRDecibel, PrueLDecibel=@PrueLDecibel, "+ "EarEndoscopyRight=@EarEndoscopyRight, EarEndoscopyRExplain=@EarEndoscopyRExplain, EarEndoscopyLeft=@EarEndoscopyLeft, "+ "EarEndoscopyLExplain=@EarEndoscopyLExplain, TympanicCavity=@TympanicCavity, PatternRight=@PatternRight, PatternLeft=@PatternLeft, "+ "CanalRight=@CanalRight, CanalLeft=@CanalLeft, EardrumRight=@EardrumRight, EardrumLeft=@EardrumLeft, PressureRight=@PressureRight, "+ "PressureLeft=@PressureLeft, AidsDetectRight1=@AidsDetectRight1, AidsDetectRight2=@AidsDetectRight2, AidsDetectLeft1=@AidsDetectLeft1, "+ "AidsDetectLeft2=@AidsDetectLeft2, AidsDetect=@AidsDetect, VoiceMaterial1=@VoiceMaterial1, VoiceWear1=@VoiceWear1, VoiceState1=@VoiceState1, "+ "VoiceVolume1=@VoiceVolume1, VoiceResult1=@VoiceResult1, VoiceRemark1=@VoiceRemark1, VoiceMaterial2=@VoiceMaterial2, VoiceWear2=@VoiceWear2, "+ "VoiceState2=@VoiceState2, VoiceVolume2=@VoiceVolume2, VoiceResult2=@VoiceResult2, VoiceRemark2=@VoiceRemark2, VoiceItem3=@VoiceItem3, "+ "VoiceMaterial3=@VoiceMaterial3, VoiceWear3=@VoiceWear3, VoiceState3=@VoiceState3, VoiceVolume3=@VoiceVolume3, VoiceResult3=@VoiceResult3, "+ "VoiceRemark3=@VoiceRemark3, VoiceItem4=@VoiceItem4, VoiceMaterial4=@VoiceMaterial4, VoiceWear4=@VoiceWear4, VoiceState4=@VoiceState4, "+ "VoiceVolume4=@VoiceVolume4, VoiceResult4=@VoiceResult4, VoiceRemark4=@VoiceRemark4, VoicePurpose=@VoicePurpose, VoicePurposeExplain=@VoicePurposeExplain, "+ "VoiceExplain=@VoiceExplain, UpFileBy= @UpFileBy,SATVolumeBefore=@SATVolumeBefore,material1=@material1,SATVolumeAfter=@SATVolumeAfter , "+ "SATREarAfter=@SATREarAfter, SATLEarAfter=@SATLEarAfter, SATEarAfter=@SATEarAfter,"+ "SATREarBefore=@SATREarBefore, SATLEarBefore=@SATLEarBefore, SATEarBefore=@SATEarBefore, WRSVolumeBefore=@WRSVolumeBefore, "+ "WRSREarBefore=@WRSREarBefore, WRSLEarBefore=@WRSLEarBefore, WRSEarBefore=@WRSEarBefore, WRSVolumeAfter=@WRSVolumeAfter, "+ "WRSREarAfter=@WRSREarAfter, WRSLEarAfter=@WRSLEarAfter, WRSEarAfter=@WRSEarAfter, project3=@project3,material3=@material3 , "+ "material2=@material2, project3VolumeBefore=@project3VolumeBefore, project3REarBefore=@project3REarBefore, "+ "project3LEarBefore=@project3LEarBefore, project3EarBefore=@project3EarBefore,project3VolumeAfter=@project3VolumeAfter, "+ "project3REarAfter=@project3REarAfter, project3LEarAfter=@project3LEarAfter, project3EarAfter=@project3EarAfter, "+ "project4=@project4, material4=@material4, project4VolumeBefore=@project4VolumeBefore, "+ "project4REarBefore=@project4REarBefore, project4LEarBefore=@project4LEarBefore, project4EarBefore=@project4EarBefore, "+ "project4VolumeAfter=@project4VolumeAfter, project4REarAfter=@project4REarAfter, "+ "project4EarAfter=@project4EarAfter, project4LEarAfter=@project4LEarAfter, "+ "checkPurpose=@checkPurpose, explain=@explain, UpFileDate=(getDate()) WHERE ID=@ID"; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@ID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.ID); cmd.Parameters.Add("@CheckDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.checkDate); cmd.Parameters.Add("@StudentID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.studentID); cmd.Parameters.Add("@CheckType", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkMode); cmd.Parameters.Add("@Credibility", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.credibility); cmd.Parameters.Add("@HearingAids_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.assistmanageR); cmd.Parameters.Add("@AidsBrand_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.brandR); cmd.Parameters.Add("@AidsModel_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.modelR); cmd.Parameters.Add("@AidsOptionalTime_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.buyingtimeR); cmd.Parameters.Add("@AidsOptionalLocation_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.buyingPlaceR); cmd.Parameters.Add("@EEarHospital_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.insertHospitalR); cmd.Parameters.Add("@EEarOpen_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.openHzDateR); cmd.Parameters.Add("@HearingAids_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.assistmanageL); cmd.Parameters.Add("@AidsBrand_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.brandL); cmd.Parameters.Add("@AidsModel_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.modelL); cmd.Parameters.Add("@AidsOptionalTime_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.buyingtimeL); cmd.Parameters.Add("@AidsOptionalLocation_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.buyingPlaceL); cmd.Parameters.Add("@EEarHospital_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.insertHospitalL); cmd.Parameters.Add("@EEarOpen_L", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.openHzDateL); cmd.Parameters.Add("@ListenCheck", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkInstrument); cmd.Parameters.Add("@Earphones", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.headphone); cmd.Parameters.Add("@NakedEar", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.nudetonety); cmd.Parameters.Add("@HearingAfter", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.hearingtone); cmd.Parameters.Add("@PureToneImg", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingtoneImg); cmd.Parameters.Add("@PrueRDecibel", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.toneR); cmd.Parameters.Add("@PrueLDecibel", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.toneL); cmd.Parameters.Add("@EarEndoscopyRight", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.hearingtoneR); cmd.Parameters.Add("@EarEndoscopyRExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingtoneRText); cmd.Parameters.Add("@EarEndoscopyLeft", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.hearingtoneL); cmd.Parameters.Add("@EarEndoscopyLExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingtoneLText); cmd.Parameters.Add("@TympanicCavity", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingInstrument); cmd.Parameters.Add("@PatternRight", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingImgR); cmd.Parameters.Add("@PatternLeft", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingImgL); cmd.Parameters.Add("@CanalRight", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingVolumeR); cmd.Parameters.Add("@CanalLeft", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingVolumeL); cmd.Parameters.Add("@EardrumRight", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.conformR); cmd.Parameters.Add("@EardrumLeft", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.conformL); cmd.Parameters.Add("@PressureRight", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.pressureR); cmd.Parameters.Add("@PressureLeft", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.pressureL); cmd.Parameters.Add("@AidsDetectRight1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.aidsR); cmd.Parameters.Add("@AidsDetectRight2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.aidsdetectR); cmd.Parameters.Add("@AidsDetectLeft1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.aidsL); cmd.Parameters.Add("@AidsDetectLeft2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.aidsdetectL); cmd.Parameters.Add("@AidsDetect", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.aidsOther); cmd.Parameters.Add("@VoiceMaterial1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material1); cmd.Parameters.Add("@VoiceWear1", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.voice1); cmd.Parameters.Add("@VoiceState1", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.state1); cmd.Parameters.Add("@VoiceVolume1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.volume1); cmd.Parameters.Add("@VoiceResult1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result1); cmd.Parameters.Add("@VoiceRemark1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.remark1); cmd.Parameters.Add("@VoiceMaterial2", SqlDbType.NVarChar).Value = StructData.material2; cmd.Parameters.Add("@VoiceWear2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.voice2); cmd.Parameters.Add("@VoiceState2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.state2); cmd.Parameters.Add("@VoiceVolume2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.volume2); cmd.Parameters.Add("@VoiceResult2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result2); cmd.Parameters.Add("@VoiceRemark2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.remark2); cmd.Parameters.Add("@project3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3); cmd.Parameters.Add("@VoiceMaterial3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material3); cmd.Parameters.Add("@VoiceWear3", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.voice3); cmd.Parameters.Add("@VoiceState3", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.state3); cmd.Parameters.Add("@VoiceVolume3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.volume3); cmd.Parameters.Add("@VoiceResult3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result3); cmd.Parameters.Add("@VoiceRemark3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.remark3); cmd.Parameters.Add("@VoiceItem3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.VoiceItem3); cmd.Parameters.Add("@VoiceItem4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.VoiceItem4); cmd.Parameters.Add("@VoiceMaterial4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material4); cmd.Parameters.Add("@VoiceWear4", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.voice4); cmd.Parameters.Add("@VoiceState4", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.state4); cmd.Parameters.Add("@VoiceVolume4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.volume4); cmd.Parameters.Add("@VoiceResult4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result4); cmd.Parameters.Add("@VoiceRemark4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.remark4); cmd.Parameters.Add("@VoicePurpose", SqlDbType.TinyInt).Value = StructData.checkPurpose; cmd.Parameters.Add("@VoicePurposeExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkPurposeText); cmd.Parameters.Add("@VoiceExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.explain); cmd.Parameters.Add("@CreateFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]); cmd.Parameters.Add("@UpFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]); cmd.Parameters.Add("@material1 ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material1); cmd.Parameters.Add("@SATVolumeBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATVolumeBefore); cmd.Parameters.Add("@SATREarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATREarBefore); cmd.Parameters.Add("@SATLEarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATLEarBefore); cmd.Parameters.Add("@SATEarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATEarBefore); cmd.Parameters.Add("@SATVolumeAfter ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATVolumeAfter); cmd.Parameters.Add("@SATREarAfter ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATREarAfter); cmd.Parameters.Add("@SATLEarAfter ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATLEarAfter); cmd.Parameters.Add("@SATEarAfter ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATEarAfter); cmd.Parameters.Add("@WRSVolumeBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSVolumeBefore); cmd.Parameters.Add("@WRSREarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSREarBefore); cmd.Parameters.Add("@WRSLEarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSLEarBefore); cmd.Parameters.Add("@WRSEarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSEarBefore); cmd.Parameters.Add("@WRSVolumeAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSVolumeAfter); cmd.Parameters.Add("@WRSREarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSREarAfter); cmd.Parameters.Add("@WRSLEarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSLEarAfter); cmd.Parameters.Add("@WRSEarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSEarAfter); cmd.Parameters.Add("@material3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material3); cmd.Parameters.Add("@material2", SqlDbType.TinyInt).Value = StructData.material2; cmd.Parameters.Add("@project3VolumeBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3VolumeBefore); cmd.Parameters.Add("@project3REarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3REarBefore); cmd.Parameters.Add("@project3LEarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3LEarBefore); cmd.Parameters.Add("@project3EarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3EarBefore); cmd.Parameters.Add("@project3VolumeAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3VolumeAfter); cmd.Parameters.Add("@project3REarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3REarAfter); cmd.Parameters.Add("@project3LEarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3LEarAfter); cmd.Parameters.Add("@project3EarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3EarAfter); cmd.Parameters.Add("@project4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4); cmd.Parameters.Add("@material4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material4); cmd.Parameters.Add("@project4VolumeBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4VolumeBefore); cmd.Parameters.Add("@project4REarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4REarBefore); cmd.Parameters.Add("@project4LEarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4LEarBefore); cmd.Parameters.Add("@project4EarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4EarBefore); cmd.Parameters.Add("@project4VolumeAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4VolumeAfter); cmd.Parameters.Add("@project4REarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4REarAfter); cmd.Parameters.Add("@project4LEarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4LEarAfter); cmd.Parameters.Add("@project4EarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4EarAfter); cmd.Parameters.Add("@checkPurposeText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkPurposeText); cmd.Parameters.Add("@checkPurpose", SqlDbType.TinyInt).Value = StructData.checkPurpose; cmd.Parameters.Add("@explain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.explain); returnValue[0] = cmd.ExecuteNonQuery().ToString(); if (returnValue[0] == "1") { StudentDataBasic DateItem = new StudentDataBasic(); //DateItem.ID = StructData.ID; DateItem.studentID = StructData.studentID; DateItem.assistmanageR = StructData.assistmanageR; DateItem.brandR = StructData.brandR; DateItem.modelR = StructData.modelR; DateItem.buyingPlaceR = StructData.buyingPlaceR; DateItem.buyingtimeR = StructData.buyingtimeR; DateItem.insertHospitalR = StructData.insertHospitalR; DateItem.openHzDateR = StructData.openHzDateR; DateItem.assistmanageL = StructData.assistmanageL; DateItem.brandL = StructData.brandL; DateItem.modelL = StructData.modelL; DateItem.buyingtimeL = StructData.buyingtimeL; DateItem.buyingPlaceL = StructData.buyingPlaceL; DateItem.insertHospitalL = StructData.insertHospitalL; DateItem.openHzDateL = StructData.openHzDateL; this.ComparisonAidsData(DateItem); CreateStudentAidsUse AidsUse = new CreateStudentAidsUse(); AidsUse.assessDate = StructData.checkDate; AidsUse.studentID = StructData.studentID; AidsUse.assistmanageR = StructData.assistmanageR; AidsUse.brandR = StructData.brandR; AidsUse.modelR = StructData.modelR; AidsUse.buyingPlaceR = StructData.buyingPlaceR; AidsUse.buyingtimeR = StructData.buyingtimeR; AidsUse.insertHospitalR = StructData.insertHospitalR; AidsUse.openHzDateR = StructData.openHzDateR; AidsUse.assistmanageL = StructData.assistmanageL; AidsUse.brandL = StructData.brandL; AidsUse.modelL = StructData.modelL; AidsUse.buyingtimeL = StructData.buyingtimeL; AidsUse.buyingPlaceL = StructData.buyingPlaceL; AidsUse.insertHospitalL = StructData.insertHospitalL; AidsUse.openHzDateL = StructData.openHzDateL; createStudentAidsUse(AidsUse); } } catch (Exception e) { returnValue[0] = "-1"; returnValue[1] = e.Message.ToString(); } } return returnValue; }
public string[] setHearingAssessmentData(CreateHearingAssessment StructData) { string[] returnValue = new string[2]; returnValue[0] = "0"; returnValue[1] = ""; DataBase Base = new DataBase(); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { StaffDataBase sDB = new StaffDataBase(); List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name); Sqlconn.Open(); string sql = "UPDATE HearingAssessment SET CheckDate=@CheckDate, Age=@Age, AgeMonth=@AgeMonth, UseAids=@UseAids, HearingAids_R=@HearingAids_R, "+ "AidsBrand_R=@AidsBrand_R, AidsModel_R=@AidsModel_R, AidsOptionalTime_R=@AidsOptionalTime_R, AidsOptionalLocation_R=@AidsOptionalLocation_R, "+ "EEarHospital_R=@EEarHospital_R,EEarOpen_R=@EEarOpen_R, HearingAids_L=@HearingAids_L, AidsBrand_L=@AidsBrand_L, AidsModel_L=@AidsModel_L, "+ "AidsOptionalTime_L=@AidsOptionalTime_L, AidsOptionalLocation_L=@AidsOptionalLocation_L, " + "EEarHospital_L=@EEarHospital_L, EEarOpen_L=@EEarOpen_L, Purpose=@Purpose, PurposeText=@PurposeText, "+ "PurposeExplain=@PurposeExplain, Observation=@Observation, ObservationExplain=@ObservationExplain, RightEar=@RightEar, LeftEar=@LeftEar, "+ "RightDecibel=@RightDecibel, RightDegree=@RightDegree, RightExplain=@RightExplain, LeftDecibel=@LeftDecibel, LeftDegree=@LeftDegree, "+ "LeftExplain=@LeftExplain, TestResult=@TestResult, AssessRAids=@AssessRAids, AssessRExplain=@AssessRExplain, AssessLAids=@AssessLAids, "+ "AssessLExplain=@AssessLExplain, VerificationRAids=@VerificationRAids, VerificationRExplain=@VerificationRExplain, VerificationLAids=@VerificationLAids, "+ "VerificationLExplain=@VerificationLExplain, OtherAssess=@OtherAssess, OtherAssessExplain=@OtherAssessExplain, ManageSuggestion=@ManageSuggestion, "+ "ManageSuggestionHour=@ManageSuggestionHour, OperateSuggestion=@OperateSuggestion, suggestion=@suggestion, suggestionExplain=@suggestionExplain, "+ "NextDate=@NextDate, UpFileBy=@UpFileBy, UpFileDate=(getDate()) WHERE ID=@ID"; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@ID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.ID); cmd.Parameters.Add("@CheckDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.checkDate); cmd.Parameters.Add("@Age", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.studentAge); cmd.Parameters.Add("@AgeMonth", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.studentMonth); cmd.Parameters.Add("@UseAids", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.studentUseAids); cmd.Parameters.Add("@HearingAids_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.assistmanageR); cmd.Parameters.Add("@AidsBrand_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.brandR); cmd.Parameters.Add("@AidsModel_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.modelR); cmd.Parameters.Add("@AidsOptionalTime_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.buyingtimeR); cmd.Parameters.Add("@AidsOptionalLocation_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.buyingPlaceR); cmd.Parameters.Add("@EEarHospital_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.insertHospitalR); cmd.Parameters.Add("@EEarOpen_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.openHzDateR); cmd.Parameters.Add("@HearingAids_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.assistmanageL); cmd.Parameters.Add("@AidsBrand_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.brandL); cmd.Parameters.Add("@AidsModel_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.modelL); cmd.Parameters.Add("@AidsOptionalTime_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.buyingtimeL); cmd.Parameters.Add("@AidsOptionalLocation_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.buyingPlaceL); cmd.Parameters.Add("@EEarHospital_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.insertHospitalL); cmd.Parameters.Add("@EEarOpen_L", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.openHzDateL); cmd.Parameters.Add("@Purpose", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.detectionPurposes); cmd.Parameters.Add("@PurposeText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.detectionPurposesText); cmd.Parameters.Add("@PurposeExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.explain); cmd.Parameters.Add("@Observation", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.observation); cmd.Parameters.Add("@ObservationExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.observationExplain); cmd.Parameters.Add("@RightEar", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.checkR); cmd.Parameters.Add("@LeftEar", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.checkL); cmd.Parameters.Add("@RightDecibel", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.checkRecibelR); cmd.Parameters.Add("@RightDegree", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.checkLossR); cmd.Parameters.Add("@RightExplain", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.checkCategoryR); cmd.Parameters.Add("@LeftDecibel", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.checkRecibelL); cmd.Parameters.Add("@LeftDegree", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.checkLossL); cmd.Parameters.Add("@LeftExplain", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.checkCategoryL); cmd.Parameters.Add("@TestResult", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkResult); cmd.Parameters.Add("@AssessRAids", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.checkAidsResultR); cmd.Parameters.Add("@AssessRExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkAidsResultRText); cmd.Parameters.Add("@AssessLAids", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.checkAidsResultL); cmd.Parameters.Add("@AssessLExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkAidsResultLText); cmd.Parameters.Add("@VerificationRAids", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.effectR); cmd.Parameters.Add("@VerificationRExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.effectRText); cmd.Parameters.Add("@VerificationLAids", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.effectL); cmd.Parameters.Add("@VerificationLExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.effectLText); cmd.Parameters.Add("@OtherAssess", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.effectOther); cmd.Parameters.Add("@OtherAssessExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.effectOtherText); cmd.Parameters.Add("@ManageSuggestion", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.suggestion); cmd.Parameters.Add("@ManageSuggestionHour", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.suggestionHour); cmd.Parameters.Add("@OperateSuggestion", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.suggestion2); cmd.Parameters.Add("@suggestion", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.suggestion3); cmd.Parameters.Add("@suggestionExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.suggestion3Text); cmd.Parameters.Add("@NextDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.checkNextDate); cmd.Parameters.Add("@UpFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]); returnValue[0] = cmd.ExecuteNonQuery().ToString(); if (returnValue[0] == "1") { StudentDataBasic DateItem = new StudentDataBasic(); DateItem.studentID = StructData.studentID; DateItem.assistmanageR = StructData.assistmanageR; DateItem.brandR = StructData.brandR; DateItem.modelR = StructData.modelR; DateItem.buyingPlaceR = StructData.buyingPlaceR; DateItem.buyingtimeR = StructData.buyingtimeR; DateItem.insertHospitalR = StructData.insertHospitalR; DateItem.openHzDateR = StructData.openHzDateR; DateItem.assistmanageL = StructData.assistmanageL; DateItem.brandL = StructData.brandL; DateItem.modelL = StructData.modelL; DateItem.buyingtimeL = StructData.buyingtimeL; DateItem.buyingPlaceL = StructData.buyingPlaceL; DateItem.insertHospitalL = StructData.insertHospitalL; DateItem.openHzDateL = StructData.openHzDateL; this.ComparisonAidsData(DateItem); } Sqlconn.Close(); } catch (Exception e) { returnValue[0] = "-1"; returnValue[1] = e.Message.ToString(); } } return returnValue; }
public string[] setStudentDataBase6(StudentHearingInformation StudentHearing) { string[] returnValue = new string[2]; returnValue[0] = "0"; returnValue[1] = ""; StudentHearingInformation oldData = this.getStudentHearingInfo(StudentHearing.ID.ToString()); if ((oldData.accessory == "0" || oldData.accessory != StudentHearing.accessory) && StudentHearing.assistmanage == "3" && StudentHearing.accessory != "0") { StudentDataBasic DateItem = new StudentDataBasic(); DateItem.studentID = StudentHearing.studentID; DateItem.assistmanageR = StudentHearing.assistmanageR; DateItem.brandR = StudentHearing.brandR; DateItem.modelR = StudentHearing.modelR; DateItem.buyingPlaceR = StudentHearing.buyingPlaceR; DateItem.buyingtimeR = StudentHearing.buyingtimeR; DateItem.insertHospitalR = StudentHearing.insertHospitalR; DateItem.openHzDateR = StudentHearing.openHzDateR; DateItem.assistmanageL = StudentHearing.assistmanageL; DateItem.brandL = StudentHearing.brandL; DateItem.modelL = StudentHearing.modelL; DateItem.buyingtimeL = StudentHearing.buyingtimeL; DateItem.buyingPlaceL = StudentHearing.buyingPlaceL; DateItem.insertHospitalL = StudentHearing.insertHospitalL; DateItem.openHzDateL = StudentHearing.openHzDateL; Audiometry aDB = new Audiometry(); aDB.ComparisonAidsData(DateItem); } DataBase Base = new DataBase(); SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()); using (Sqlconn) { try { Sqlconn.Open(); string sql = "UPDATE StudentDatabase SET HearingProblemAge=@HearingProblemAge, HearingProblemMonth=@HearingProblemMonth, " + "HearingProblem=@HearingProblem, HearingProblemText=@HearingProblemText, DiagnoseAge=@DiagnoseAge, DiagnoseMonth=@DiagnoseMonth, " + "DiagnoseAgency=@DiagnoseAgency, DiagnoseR=@DiagnoseR, DiagnoseL=@DiagnoseL, NewbornHearing=@NewbornHearing, " + "NewbornHearingInspection=@NewbornHearingInspection, NewbornHearingInspectionAgency=@NewbornHearingInspectionAgency, " + "NewbornHearingInspectionDiagnoseR=@NewbornHearingInspectionDiagnoseR, NewbornHearingInspectionDiagnoseL=@NewbornHearingInspectionDiagnoseL, " + "AuditoryElectrophysiology1=@AuditoryElectrophysiology1, AuditoryElectrophysiology_Date1=@AuditoryElectrophysiology_Date1, " + "AuditoryElectrophysiology_Agency1=@AuditoryElectrophysiology_Agency1, AuditoryElectrophysiology_Item1=@AuditoryElectrophysiology_Item1, " + "AuditoryElectrophysiology_Diagnose1R=@AuditoryElectrophysiology_Diagnose1R, AuditoryElectrophysiology_Diagnose1L=@AuditoryElectrophysiology_Diagnose1L, " + "AuditoryElectrophysiology_Date2=@AuditoryElectrophysiology_Date2, AuditoryElectrophysiology_Agency2=@AuditoryElectrophysiology_Agency2, " + "AuditoryElectrophysiology_Item2=@AuditoryElectrophysiology_Item2, AuditoryElectrophysiology_Diagnose2R=@AuditoryElectrophysiology_Diagnose2R, " + "AuditoryElectrophysiology_Diagnose2L=@AuditoryElectrophysiology_Diagnose2L, AuditoryElectrophysiology_Date3=@AuditoryElectrophysiology_Date3, " + "AuditoryElectrophysiology_Agency3=@AuditoryElectrophysiology_Agency3, AuditoryElectrophysiology_Item3=@AuditoryElectrophysiology_Item3, " + "AuditoryElectrophysiology_Diagnose3R=@AuditoryElectrophysiology_Diagnose3R, AuditoryElectrophysiology_Diagnose3L=@AuditoryElectrophysiology_Diagnose3L, " + "AuditoryElectrophysiology_Date4=@AuditoryElectrophysiology_Date4, AuditoryElectrophysiology_Agency4=@AuditoryElectrophysiology_Agency4, " + "AuditoryElectrophysiology_Item4=@AuditoryElectrophysiology_Item4, AuditoryElectrophysiology_Diagnose4R=@AuditoryElectrophysiology_Diagnose4R, " + "AuditoryElectrophysiology_Diagnose4L=@AuditoryElectrophysiology_Diagnose4L, AuditoryElectrophysiology_Date5=@AuditoryElectrophysiology_Date5, " + "AuditoryElectrophysiology_Agency5=@AuditoryElectrophysiology_Agency5, AuditoryElectrophysiology_Item5=@AuditoryElectrophysiology_Item5, " + "AuditoryElectrophysiology_Diagnose5R=@AuditoryElectrophysiology_Diagnose5R, AuditoryElectrophysiology_Diagnose5L=@AuditoryElectrophysiology_Diagnose5L, " + "CTorMRI=@CTorMRI, CTorMRI_Date1=@CTorMRI_Date1, " + "CTorMRI_Agency1=@CTorMRI_Agency1, CTorMRI_DiagnoseR=@CTorMRI_DiagnoseR, CTorMRI_DiagnoseL=@CTorMRI_DiagnoseL, " + "GeneScreening=@GeneScreening, GeneScreening_Date=@GeneScreening_Date, GeneScreening_Agency=@GeneScreening_Agency, " + "GeneScreening_Item=@GeneScreening_Item, " + "FamilyHearingProblemHistory=@FamilyHearingProblemHistory, FamilyHearingProblemHistoryText=@FamilyHearingProblemHistoryText, " + "HearingChangeHistory=@HearingChangeHistory, HearingChangeHistoryText=@HearingChangeHistoryText, AidsManagement=@AidsManagement, " + "AidsManagementTextAge=@AidsManagementTextAge, HearingAids_R=@HearingAids_R, AidsBrand_R=@AidsBrand_R, AidsModel_R=@AidsModel_R, AidsOptionalTime_R=@AidsOptionalTime_R, " + "AidsOptionalLocation_R=@AidsOptionalLocation_R, EEarHospital_R=@EEarHospital_R,EEarOpen_R=@EEarOpen_R, " + "HearingAids_L=@HearingAids_L, AidsBrand_L=@AidsBrand_L, AidsModel_L=@AidsModel_L, AidsOptionalTime_L=@AidsOptionalTime_L, AidsOptionalLocation_L=@AidsOptionalLocation_L, " + "EEarHospital_L=@EEarHospital_L, EEarOpen_L=@EEarOpen_L, AllDayAids=@AllDayAids, AllDayAidsText=@AllDayAidsText, " + "ActiveReaction=@ActiveReaction, ActiveReactionText=@ActiveReactionText, BasicCare=@BasicCare, BasicCareText=@BasicCareText, UseFMsystem=@UseFMsystem, " + "UseFMsystemBrand=@UseFMsystemBrand, HearingAssessmentSummary=@HearingAssessmentSummary, EarEndoscopy=@EarEndoscopy, " + "EarEndoscopyAbnormalText=@EarEndoscopyAbnormalText, PureToneText=@PureToneText, Tympanogram=@Tympanogram, SATorSDT=@SATorSDT, " + "SpeechRecognition=@SpeechRecognition, AidsSystem=@AidsSystem, HearingInspection=@HearingInspection, HearingOther=@HearingOther, " + "Audiologist=@Audiologist, SurveyingDate=@SurveyingDate,accessory1=@accessory1,accessory2=@accessory2 " + "WHERE ID=@ID "; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value = StudentHearing.ID; cmd.Parameters.Add("@HearingProblemAge", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.problems01t01); cmd.Parameters.Add("@HearingProblemMonth", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.problems01t02); cmd.Parameters.Add("@HearingProblem", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.hearingQ); cmd.Parameters.Add("@HearingProblemText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.hearingQText); cmd.Parameters.Add("@DiagnoseAge", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.problems02t01); cmd.Parameters.Add("@DiagnoseMonth", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.problems02t02); cmd.Parameters.Add("@DiagnoseAgency", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.problems02t03); cmd.Parameters.Add("@DiagnoseR", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.problems02t04); cmd.Parameters.Add("@DiagnoseL", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.problems02t05); cmd.Parameters.Add("@NewbornHearing", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.hearingcheck); cmd.Parameters.Add("@NewbornHearingInspection", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.hearingYescheck); cmd.Parameters.Add("@NewbornHearingInspectionAgency", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.hearingYesPlace); cmd.Parameters.Add("@NewbornHearingInspectionDiagnoseR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.hearingYesResultR); cmd.Parameters.Add("@NewbornHearingInspectionDiagnoseL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.hearingYesResultL); cmd.Parameters.Add("@AuditoryElectrophysiology1", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.sleepcheck); cmd.Parameters.Add("@AuditoryElectrophysiology_Date1", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.sleepcheckTime1); cmd.Parameters.Add("@AuditoryElectrophysiology_Agency1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckPlace1); cmd.Parameters.Add("@AuditoryElectrophysiology_Item1", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.sleepcheckCheckItem1); cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose1R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultL1); cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose1L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultR1); cmd.Parameters.Add("@AuditoryElectrophysiology_Date2", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.sleepcheckTime2); cmd.Parameters.Add("@AuditoryElectrophysiology_Agency2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckPlace2); cmd.Parameters.Add("@AuditoryElectrophysiology_Item2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.sleepcheckCheckItem2); cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose2R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultL2); cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose2L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultR2); cmd.Parameters.Add("@AuditoryElectrophysiology_Date3", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.sleepcheckTime3); cmd.Parameters.Add("@AuditoryElectrophysiology_Agency3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckPlace3); cmd.Parameters.Add("@AuditoryElectrophysiology_Item3", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.sleepcheckCheckItem3); cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose3R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultL3); cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose3L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultR3); cmd.Parameters.Add("@AuditoryElectrophysiology_Date4", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.sleepcheckTime4); cmd.Parameters.Add("@AuditoryElectrophysiology_Agency4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckPlace4); cmd.Parameters.Add("@AuditoryElectrophysiology_Item4", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.sleepcheckCheckItem4); cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose4R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultL4); cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose4L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultR4); cmd.Parameters.Add("@AuditoryElectrophysiology_Date5", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.sleepcheckTime5); cmd.Parameters.Add("@AuditoryElectrophysiology_Agency5", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckPlace5); cmd.Parameters.Add("@AuditoryElectrophysiology_Item5", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.sleepcheckCheckItem5); cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose5R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultL5); cmd.Parameters.Add("@AuditoryElectrophysiology_Diagnose5L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.sleepcheckResultR5); cmd.Parameters.Add("@CTorMRI", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.ctmri); cmd.Parameters.Add("@CTorMRI_Date1", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.ctmriTime); cmd.Parameters.Add("@CTorMRI_Agency1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.ctmriPlace); cmd.Parameters.Add("@CTorMRI_DiagnoseR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.ctmriResultL); cmd.Parameters.Add("@CTorMRI_DiagnoseL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.ctmriResultR); cmd.Parameters.Add("@GeneScreening", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.gene); cmd.Parameters.Add("@GeneScreening_Date", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.geneTime); cmd.Parameters.Add("@GeneScreening_Agency", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.genePlace); cmd.Parameters.Add("@GeneScreening_Item", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.geneResult); cmd.Parameters.Add("@FamilyHearingProblemHistory", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.familyhistory); cmd.Parameters.Add("@FamilyHearingProblemHistoryText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.familyhistoryText); cmd.Parameters.Add("@HearingChangeHistory", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.changehistory); cmd.Parameters.Add("@HearingChangeHistoryText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.changehistoryText); cmd.Parameters.Add("@AidsManagement", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.assistmanage); cmd.Parameters.Add("@AidsManagementTextAge", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.accessory); cmd.Parameters.Add("@HearingAids_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.assistmanageR); cmd.Parameters.Add("@AidsBrand_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.brandR); cmd.Parameters.Add("@AidsModel_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.modelR); cmd.Parameters.Add("@AidsOptionalTime_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.buyingtimeR); cmd.Parameters.Add("@AidsOptionalLocation_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.buyingPlaceR); cmd.Parameters.Add("@EEarHospital_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.insertHospitalR); cmd.Parameters.Add("@EEarOpen_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.openHzDateR); cmd.Parameters.Add("@HearingAids_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.assistmanageL); cmd.Parameters.Add("@AidsBrand_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.brandL); cmd.Parameters.Add("@AidsModel_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.modelL); cmd.Parameters.Add("@AidsOptionalTime_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.buyingtimeL); cmd.Parameters.Add("@AidsOptionalLocation_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.buyingPlaceL); cmd.Parameters.Add("@EEarHospital_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.insertHospitalL); cmd.Parameters.Add("@EEarOpen_L", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.openHzDateL); cmd.Parameters.Add("@AllDayAids", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.allassis); cmd.Parameters.Add("@AllDayAidsText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.allassisNoText); cmd.Parameters.Add("@ActiveReaction", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.assis1); cmd.Parameters.Add("@ActiveReactionText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.assis1NoText); cmd.Parameters.Add("@BasicCare", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.assis2); cmd.Parameters.Add("@BasicCareText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.assis2NoText); cmd.Parameters.Add("@UseFMsystem", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.assisFM); cmd.Parameters.Add("@UseFMsystemBrand", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.assisFMBrand); cmd.Parameters.Add("@HearingAssessmentSummary", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.assessnotes); cmd.Parameters.Add("@EarEndoscopy", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentHearing.assessnotes1); cmd.Parameters.Add("@EarEndoscopyAbnormalText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.assessnotes102Text); cmd.Parameters.Add("@PureToneText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.problems11t02); cmd.Parameters.Add("@Tympanogram", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.assessnotes2); cmd.Parameters.Add("@SATorSDT", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.problems11t03); cmd.Parameters.Add("@SpeechRecognition", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.problems11t04); cmd.Parameters.Add("@AidsSystem", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.problems11t05); cmd.Parameters.Add("@HearingInspection", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.problems11t06); cmd.Parameters.Add("@HearingOther", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.problems11t07); cmd.Parameters.Add("@Audiologist", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StudentHearing.inspectorID); cmd.Parameters.Add("@SurveyingDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentHearing.inspectorDate); cmd.Parameters.Add("@accessory1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.accessory1); cmd.Parameters.Add("@accessory2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.accessory2); returnValue[0] = cmd.ExecuteNonQuery().ToString(); Sqlconn.Close(); } catch (Exception e) { returnValue[0] = "-1"; returnValue[1] = e.Message; } } return returnValue; }
public StudentDataBasic getStudentAidsDataBaseBasic(string cID) { CaseDataBase SDB = new CaseDataBase(); StudentResult stuData = SDB.getStudentDataWho(cID); StudentDataBasic returnValue = new StudentDataBasic(); returnValue.ID = stuData.Column.ToString(); returnValue.studentID = stuData.StudentData.studentID; returnValue.studentName = stuData.StudentData.studentName; returnValue.studentSex = stuData.StudentData.studentSex; returnValue.studentbirthday = stuData.StudentData.studentbirthday; returnValue.assistmanageL = stuData.HearingData.assistmanageL; returnValue.assistmanageR = stuData.HearingData.assistmanageR; returnValue.brandL = stuData.HearingData.brandL; returnValue.brandR = stuData.HearingData.brandR; returnValue.modelL = stuData.HearingData.modelL; returnValue.modelR = stuData.HearingData.modelR; returnValue.buyingtimeR = stuData.HearingData.buyingtimeR; returnValue.buyingtimeL = stuData.HearingData.buyingtimeL; returnValue.buyingPlaceR = stuData.HearingData.buyingPlaceR; returnValue.buyingPlaceL = stuData.HearingData.buyingPlaceL; returnValue.openHzDateR = stuData.HearingData.openHzDateR; returnValue.openHzDateL = stuData.HearingData.openHzDateL; returnValue.insertHospitalR = stuData.HearingData.insertHospitalR; returnValue.insertHospitalL = stuData.HearingData.insertHospitalL; returnValue.checkNo = stuData.checkNo; returnValue.errorMsg = stuData.errorMsg; return returnValue; }