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[] 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[] setHearingAssessmentDataBase(CreateHearingAssessment StructData) { Audiometry aDB = new Audiometry(); if (int.Parse(aDB._StaffhaveRoles[1]) == 1) { return aDB.setHearingAssessmentData(StructData); } else { return new string[2] { _noRole, _errorMsg }; } }
public CreateHearingAssessment getHearingAssessmentData(string sID) { CreateHearingAssessment returnValue = new CreateHearingAssessment(); DataBase Base = new DataBase(); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { Sqlconn.Open(); string sql = "SELECT HearingAssessment.*, StudentDatabase.StudentName, StudentDatabase.StudentBirthday " + "FROM HearingAssessment INNER JOIN StudentDatabase ON HearingAssessment.StudentID=StudentDatabase.StudentID " + "WHERE HearingAssessment.isDeleted=0 and StudentDatabase.isDeleted=0 AND HearingAssessment.ID=@ID"; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@ID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(sID); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { returnValue.caseUnit = dr["Unit"].ToString(); returnValue.checkDate = DateTime.Parse(dr["CheckDate"].ToString()).ToString("yyyy-MM-dd"); returnValue.studentID = dr["StudentID"].ToString(); returnValue.studentName = dr["StudentName"].ToString(); returnValue.studentbirthday = DateTime.Parse(dr["StudentBirthday"].ToString()).ToString("yyyy-MM-dd"); returnValue.studentAge = dr["Age"].ToString(); returnValue.studentMonth = dr["AgeMonth"].ToString(); returnValue.studentUseAids = dr["UseAids"].ToString(); returnValue.assistmanageR = dr["HearingAids_R"].ToString(); returnValue.brandR = dr["AidsBrand_R"].ToString(); returnValue.modelR = dr["AidsModel_R"].ToString(); returnValue.buyingPlaceR = dr["AidsOptionalLocation_R"].ToString(); returnValue.buyingtimeR = DateTime.Parse(dr["AidsOptionalTime_R"].ToString()).ToString("yyyy-MM-dd"); returnValue.insertHospitalR = dr["EEarHospital_R"].ToString(); returnValue.openHzDateR = DateTime.Parse(dr["EEarOpen_R"].ToString()).ToString("yyyy-MM-dd"); returnValue.assistmanageL = dr["HearingAids_L"].ToString(); returnValue.brandL = dr["AidsBrand_L"].ToString(); returnValue.modelL = dr["AidsModel_L"].ToString(); returnValue.buyingtimeL = DateTime.Parse(dr["AidsOptionalTime_L"].ToString()).ToString("yyyy-MM-dd"); returnValue.buyingPlaceL = dr["AidsOptionalLocation_L"].ToString(); returnValue.insertHospitalL = dr["EEarHospital_L"].ToString(); returnValue.openHzDateL = DateTime.Parse(dr["EEarOpen_L"].ToString()).ToString("yyyy-MM-dd"); returnValue.detectionPurposes = dr["Purpose"].ToString(); returnValue.detectionPurposesText = dr["PurposeText"].ToString(); returnValue.explain = dr["PurposeExplain"].ToString(); returnValue.observation = dr["Observation"].ToString(); returnValue.observationExplain = dr["ObservationExplain"].ToString(); returnValue.checkR = dr["RightEar"].ToString(); returnValue.checkL = dr["LeftEar"].ToString(); returnValue.checkRecibelR = dr["RightDecibel"].ToString(); returnValue.checkLossR = dr["RightDegree"].ToString(); returnValue.checkCategoryR = dr["RightExplain"].ToString(); returnValue.checkRecibelL = dr["LeftDecibel"].ToString(); returnValue.checkLossL = dr["LeftDegree"].ToString(); returnValue.checkCategoryL = dr["LeftExplain"].ToString(); returnValue.checkResult = dr["TestResult"].ToString(); returnValue.checkAidsResultR = dr["AssessRAids"].ToString(); returnValue.checkAidsResultRText = dr["AssessRExplain"].ToString(); returnValue.checkAidsResultL = dr["AssessLAids"].ToString(); returnValue.checkAidsResultLText = dr["AssessLExplain"].ToString(); returnValue.effectR = dr["VerificationRAids"].ToString(); returnValue.effectRText = dr["VerificationRExplain"].ToString(); returnValue.effectL = dr["VerificationLAids"].ToString(); returnValue.effectLText = dr["VerificationLExplain"].ToString(); returnValue.effectOther = dr["OtherAssess"].ToString(); returnValue.effectOtherText = dr["OtherAssessExplain"].ToString(); returnValue.suggestion = dr["ManageSuggestion"].ToString(); returnValue.suggestionHour = dr["ManageSuggestionHour"].ToString(); returnValue.suggestion2 = dr["OperateSuggestion"].ToString(); returnValue.suggestion3 = dr["suggestion"].ToString(); returnValue.suggestion3Text = dr["suggestionExplain"].ToString(); returnValue.checkNextDate = DateTime.Parse(dr["NextDate"].ToString()).ToString("yyyy-MM-dd"); returnValue.audiologist = dr["CreateFileBy"].ToString(); StaffDataBase sDB = new StaffDataBase(); List<string> CreateFileName = sDB.getStaffDataName(returnValue.audiologist); returnValue.audiologistName = CreateFileName[1].ToString(); } Sqlconn.Close(); } catch (Exception e) { returnValue.checkNo = "-1"; returnValue.errorMsg = e.Message.ToString(); } } return returnValue; }
public CreateHearingAssessment getHearingAssessmentDataBase(string sID) { Audiometry aDB = new Audiometry(); CreateHearingAssessment returnValue = new CreateHearingAssessment(); if (int.Parse(aDB._StaffhaveRoles[3]) == 1) { returnValue = aDB.getHearingAssessmentData(sID); } else { returnValue.checkNo = _getcheckNo; returnValue.errorMsg = _errorMsg; } StaffDataBase sDB = new StaffDataBase(); List<string> UserFile = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name); if (returnValue.caseUnit != UserFile[2] && int.Parse(aDB._StaffhaveRoles[4]) == 0 && UserFile[1].Length > 0) { returnValue.checkNo = _getcheckNo; returnValue.errorMsg = _errorMsg; } return returnValue; }