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 string[] setStudentDataBase5(StudentHearingInformation 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 StudentDevelop=@StudentDevelop, StudentDevelopText21=@StudentDevelopText21, StudentDevelopText22=@StudentDevelopText22, " + "StudentDevelopText31=@StudentDevelopText31, StudentDevelopText61=@StudentDevelopText61, StudentDevelopText62=@StudentDevelopText62, " + "StudentDevelopText81=@StudentDevelopText81, StudentDevelopText10=@StudentDevelopText10, StudentDevelopText11=@StudentDevelopText11, " + "StudentDevelopText12=@StudentDevelopText12 " + "WHERE ID=@ID"; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value = StudentHearing.ID; cmd.Parameters.Add("@StudentDevelop", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.history); cmd.Parameters.Add("@StudentDevelopText21", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.history02t01); cmd.Parameters.Add("@StudentDevelopText22", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.history02t02); cmd.Parameters.Add("@StudentDevelopText31", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.history03t01); cmd.Parameters.Add("@StudentDevelopText61", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.history06t01); cmd.Parameters.Add("@StudentDevelopText62", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.history06t02); cmd.Parameters.Add("@StudentDevelopText81", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.history08t01); cmd.Parameters.Add("@StudentDevelopText10", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.history10t01); cmd.Parameters.Add("@StudentDevelopText11", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.history11t01); cmd.Parameters.Add("@StudentDevelopText12", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentHearing.history12t01); returnValue[0] = cmd.ExecuteNonQuery().ToString(); Sqlconn.Close(); } catch (Exception e) { returnValue[0] = "-1"; returnValue[1] = e.Message; } } return returnValue; }
public StudentHearingInformation getStudentHearingInfo(string ID) { StudentHearingInformation returnValue = new StudentHearingInformation(); DataBase Base = new DataBase(); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { Sqlconn.Open(); string sql = "SELECT * FROM StudentDatabase WHERE isDeleted=0 AND ID=(@ID)"; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value = Chk.CheckStringtoInt64Function(ID); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { returnValue.history = dr["StudentDevelop"].ToString(); returnValue.history02t01 = dr["StudentDevelopText21"].ToString(); returnValue.history02t02 = dr["StudentDevelopText22"].ToString(); returnValue.history03t01 = dr["StudentDevelopText31"].ToString(); returnValue.history06t01 = dr["StudentDevelopText61"].ToString(); returnValue.history06t02 = dr["StudentDevelopText62"].ToString(); returnValue.history08t01 = dr["StudentDevelopText81"].ToString(); returnValue.history10t01 = dr["StudentDevelopText10"].ToString(); returnValue.history11t01 = dr["StudentDevelopText11"].ToString(); returnValue.history12t01 = dr["StudentDevelopText12"].ToString(); returnValue.problems01t01 = dr["HearingProblemAge"].ToString(); returnValue.problems01t02 = dr["HearingProblemMonth"].ToString(); returnValue.hearingQ = dr["HearingProblem"].ToString(); returnValue.hearingQText = dr["HearingProblemText"].ToString(); returnValue.problems02t01 = dr["DiagnoseAge"].ToString(); returnValue.problems02t02 = dr["DiagnoseMonth"].ToString(); returnValue.problems02t03 = dr["DiagnoseAgency"].ToString(); returnValue.problems02t04 = dr["DiagnoseR"].ToString(); returnValue.problems02t05 = dr["DiagnoseL"].ToString(); returnValue.hearingcheck = dr["NewbornHearing"].ToString(); returnValue.hearingYescheck = dr["NewbornHearingInspection"].ToString(); returnValue.hearingYesPlace = dr["NewbornHearingInspectionAgency"].ToString(); returnValue.hearingYesResultR = dr["NewbornHearingInspectionDiagnoseR"].ToString(); returnValue.hearingYesResultL = dr["NewbornHearingInspectionDiagnoseL"].ToString(); returnValue.sleepcheck = dr["AuditoryElectrophysiology1"].ToString(); returnValue.sleepcheckTime1 = DateTime.Parse(dr["AuditoryElectrophysiology_Date1"].ToString()).ToString("yyyy-MM-dd");//dr["AuditoryElectrophysiology_Date1"].ToString(); returnValue.sleepcheckPlace1 = dr["AuditoryElectrophysiology_Agency1"].ToString(); returnValue.sleepcheckCheckItem1 = dr["AuditoryElectrophysiology_Item1"].ToString(); returnValue.sleepcheckResultL1 = dr["AuditoryElectrophysiology_Diagnose1R"].ToString(); returnValue.sleepcheckResultR1 = dr["AuditoryElectrophysiology_Diagnose1L"].ToString(); returnValue.sleepcheckTime2 = DateTime.Parse(dr["AuditoryElectrophysiology_Date2"].ToString()).ToString("yyyy-MM-dd"); returnValue.sleepcheckPlace2 = dr["AuditoryElectrophysiology_Agency2"].ToString(); returnValue.sleepcheckCheckItem2 = dr["AuditoryElectrophysiology_Item2"].ToString(); returnValue.sleepcheckResultL2 = dr["AuditoryElectrophysiology_Diagnose2R"].ToString(); returnValue.sleepcheckResultR2 = dr["AuditoryElectrophysiology_Diagnose2L"].ToString(); returnValue.sleepcheckTime3 = DateTime.Parse(dr["AuditoryElectrophysiology_Date3"].ToString()).ToString("yyyy-MM-dd"); returnValue.sleepcheckPlace3 = dr["AuditoryElectrophysiology_Agency3"].ToString(); returnValue.sleepcheckCheckItem3 = dr["AuditoryElectrophysiology_Item3"].ToString(); returnValue.sleepcheckResultL3 = dr["AuditoryElectrophysiology_Diagnose3R"].ToString(); returnValue.sleepcheckResultR3 = dr["AuditoryElectrophysiology_Diagnose3L"].ToString(); returnValue.sleepcheckTime4 = DateTime.Parse(dr["AuditoryElectrophysiology_Date4"].ToString()).ToString("yyyy-MM-dd"); returnValue.sleepcheckPlace4 = dr["AuditoryElectrophysiology_Agency4"].ToString(); returnValue.sleepcheckCheckItem4 = dr["AuditoryElectrophysiology_Item4"].ToString(); returnValue.sleepcheckResultL4 = dr["AuditoryElectrophysiology_Diagnose4R"].ToString(); returnValue.sleepcheckResultR4 = dr["AuditoryElectrophysiology_Diagnose4L"].ToString(); returnValue.sleepcheckTime5 = DateTime.Parse(dr["AuditoryElectrophysiology_Date5"].ToString()).ToString("yyyy-MM-dd"); returnValue.sleepcheckPlace5 = dr["AuditoryElectrophysiology_Agency5"].ToString(); returnValue.sleepcheckCheckItem5 = dr["AuditoryElectrophysiology_Item5"].ToString(); returnValue.sleepcheckResultL5 = dr["AuditoryElectrophysiology_Diagnose5R"].ToString(); returnValue.sleepcheckResultR5 = dr["AuditoryElectrophysiology_Diagnose5L"].ToString(); returnValue.ctmri = dr["CTorMRI"].ToString(); returnValue.ctmriTime = DateTime.Parse(dr["CTorMRI_Date1"].ToString()).ToString("yyyy-MM-dd"); returnValue.ctmriPlace = dr["CTorMRI_Agency1"].ToString(); returnValue.ctmriResultL = dr["CTorMRI_DiagnoseR"].ToString(); returnValue.ctmriResultR = dr["CTorMRI_DiagnoseL"].ToString(); returnValue.gene = dr["GeneScreening"].ToString(); returnValue.geneTime = DateTime.Parse(dr["GeneScreening_Date"].ToString()).ToString("yyyy-MM-dd"); returnValue.genePlace = dr["GeneScreening_Agency"].ToString(); returnValue.geneResult = dr["GeneScreening_Item"].ToString(); returnValue.familyhistory = dr["FamilyHearingProblemHistory"].ToString(); returnValue.familyhistoryText = dr["FamilyHearingProblemHistoryText"].ToString(); returnValue.changehistory = dr["HearingChangeHistory"].ToString(); returnValue.changehistoryText = dr["HearingChangeHistoryText"].ToString(); returnValue.assistmanage = dr["AidsManagement"].ToString(); returnValue.accessory = dr["AidsManagementTextAge"].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.allassis = dr["AllDayAids"].ToString(); returnValue.allassisNoText = dr["AllDayAidsText"].ToString(); returnValue.assis1 = dr["ActiveReaction"].ToString(); returnValue.assis1NoText = dr["ActiveReactionText"].ToString(); returnValue.assis2 = dr["BasicCare"].ToString(); returnValue.assis2NoText = dr["BasicCareText"].ToString(); returnValue.assisFM = dr["UseFMsystem"].ToString(); returnValue.assisFMBrand = dr["UseFMsystemBrand"].ToString(); returnValue.assessnotes = dr["HearingAssessmentSummary"].ToString(); returnValue.assessnotes1 = dr["EarEndoscopy"].ToString(); returnValue.assessnotes102Text = dr["EarEndoscopyAbnormalText"].ToString(); returnValue.problems11t02 = dr["PureToneText"].ToString(); returnValue.assessnotes2 = dr["Tympanogram"].ToString(); returnValue.problems11t03 = dr["SATorSDT"].ToString(); returnValue.problems11t04 = dr["SpeechRecognition"].ToString(); returnValue.problems11t05 = dr["AidsSystem"].ToString(); returnValue.problems11t06 = dr["HearingInspection"].ToString(); returnValue.problems11t07 = dr["HearingOther"].ToString(); returnValue.accessory1 = dr["accessory1"].ToString(); returnValue.accessory2 = dr["accessory2"].ToString(); StaffDataBase sDB = new StaffDataBase(); List<string> StaffData = sDB.getStaffDataName(dr["Audiologist"].ToString()); returnValue.inspectorID = dr["Audiologist"].ToString(); returnValue.inspectorName = StaffData[1]; returnValue.inspectorDate = DateTime.Parse(dr["SurveyingDate"].ToString()).ToString("yyyy-MM-dd"); } Sqlconn.Close(); } catch (Exception e) { returnValue.checkNo = "-1"; returnValue.errorMsg = e.Message.ToString(); } return returnValue; } }
public StudentResult getStudentDataWho(string StudentID) { StudentResult returnValue = new StudentResult(); returnValue.StudentData = new CreateStudent(); DataBase Base = new DataBase(); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { Sqlconn.Open(); string sql = "SELECT * FROM StudentDatabase WHERE isDeleted=0 AND StudentID= @ID";////修正SQL式[ StudentID= (@ID) ] → [ ID = @ID ] by Awho SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@ID", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentID); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { returnValue.Column = Int64.Parse(dr["ID"].ToString()); CreateStudent addValue = new CreateStudent(); StaffDataBase sDB = new StaffDataBase(); List<string> StaffData = sDB.getStaffDataName(dr["WriteName"].ToString()); addValue.fillInName = StaffData[1]; addValue.ID = dr["ID"].ToString(); addValue.assessDate = dr["EvaluationDate"].ToString(); addValue.consultationDate = dr["ConsultDate"].ToString(); addValue.upDate = dr["Updated"].ToString(); addValue.caseStatu = dr["CaseStatu"].ToString(); addValue.Unit = dr["Unit"].ToString(); addValue.studentID = dr["StudentID"].ToString(); addValue.studentName = dr["StudentName"].ToString(); addValue.studentTWID = dr["StudentIdentity"].ToString(); addValue.censusAddressZip = dr["AddressZip1"].ToString(); addValue.censusAddressCity = dr["AddressCity1"].ToString(); addValue.censusAddress = dr["AddressOther1"].ToString(); addValue.addressZip = dr["AddressZip2"].ToString(); addValue.addressCity = dr["AddressCity2"].ToString(); addValue.address = dr["AddressOther2"].ToString(); addValue.studentbirthday = DateTime.Parse(dr["StudentBirthday"].ToString()).ToString("yyyy-MM-dd"); addValue.studentSex = dr["StudentSex"].ToString(); addValue.firstClassDate = DateTime.Parse(dr["ClassDate"].ToString()).ToString("yyyy-MM-dd"); addValue.guaranteeDate = DateTime.Parse(dr["GuaranteeDate"].ToString()).ToString("yyyy-MM-dd"); addValue.endReasonDate = DateTime.Parse(dr["CompletedDate"].ToString()).ToString("yyyy-MM-dd"); addValue.endReasonType = dr["CompletedType"].ToString(); addValue.endReason = dr["CompletedReason"].ToString(); addValue.sendDateSince = DateTime.Parse(dr["ShortEndDateSince"].ToString()).ToString("yyyy-MM-dd"); addValue.sendDateUntil = DateTime.Parse(dr["ShortEndDateUntil"].ToString()).ToString("yyyy-MM-dd"); addValue.nomembershipType = dr["NomembershipType"].ToString(); addValue.nomembershipReason = dr["NomembershipReason"].ToString(); addValue.studentPhoto = dr["StudentAvatar"].ToString(); addValue.wCare = dr["CaregiversDaytime"].ToString(); addValue.wCareName = dr["CaregiversDaytimeText"].ToString(); addValue.bCare = dr["CaregiversNight"].ToString(); addValue.bCareName = dr["CaregiversNightText"].ToString(); addValue.fPRelation1 = dr["ContactRelation1"].ToString(); addValue.fPName1 = dr["ContactName1"].ToString(); addValue.fPTel1 = dr["ContactTel_company1"].ToString(); addValue.fPPhone1 = dr["ContactPhone1"].ToString(); addValue.fPHPhone1 = dr["ContactTel_home1"].ToString(); addValue.fPFax1 = dr["ContactFax1"].ToString(); addValue.fPRelation2 = dr["ContactRelation2"].ToString(); addValue.fPName2 = dr["ContactName2"].ToString(); addValue.fPTel2 = dr["ContactTel_company2"].ToString(); addValue.fPPhone2 = dr["ContactPhone2"].ToString(); addValue.fPHPhone2 = dr["ContactTel_home2"].ToString(); addValue.fPFax2 = dr["ContactFax2"].ToString(); addValue.fPRelation3 = dr["ContactRelation3"].ToString(); addValue.fPName3 = dr["ContactName3"].ToString(); addValue.fPTel3 = dr["ContactTel_company3"].ToString(); addValue.fPPhone3 = dr["ContactPhone3"].ToString(); addValue.fPHPhone3 = dr["ContactTel_home3"].ToString(); addValue.fPFax3 = dr["ContactFax3"].ToString(); addValue.fPRelation4 = dr["ContactRelation4"].ToString(); addValue.fPName4 = dr["ContactName4"].ToString(); addValue.fPTel4 = dr["ContactTel_company4"].ToString(); addValue.fPPhone4 = dr["ContactPhone4"].ToString(); addValue.fPHPhone4 = dr["ContactTel_home4"].ToString(); addValue.fPFax4 = dr["ContactFax4"].ToString(); addValue.email = dr["StudentEmail"].ToString(); addValue.sourceType = dr["ReferralSourceType"].ToString(); addValue.sourceName = dr["ReferralSource"].ToString(); addValue.manualWhether = dr["PhysicalAndMentalDisabilityHandbook"].ToString(); addValue.manualCategory1 = dr["DisabilityCategory1"].ToString(); addValue.manualGrade1 = dr["DisabilityGrade1"].ToString(); addValue.manualCategory2 = dr["DisabilityCategory2"].ToString(); addValue.manualGrade2 = dr["DisabilityGrade2"].ToString(); addValue.manualCategory3 = dr["DisabilityCategory3"].ToString(); addValue.manualGrade3 = dr["DisabilityGrade3"].ToString(); addValue.manualNo = dr["NoDisabilityHandbook"].ToString(); addValue.manualUnit = dr["ApplyDisabilityHandbook"].ToString(); addValue.studentManualImg = dr["DisabilityProve"].ToString(); addValue.notificationWhether = dr["Notify"].ToString(); addValue.notificationUnit = dr["Notify_Unit"].ToString(); addValue.notificationManage = dr["Notify_Member"].ToString(); addValue.notificationTel = dr["Notify_Tel"].ToString(); addValue.notificationDate = DateTime.Parse(dr["Notify_Date"].ToString()).ToString("yyyy-MM-dd"); addValue.notificationCity = dr["Notify_City"].ToString(); addValue.economy = dr["EconomyState"].ToString(); addValue.economyLow = dr["EconomyLow"].ToString(); addValue.fAppellation1 = dr["FamilyAppellation1"].ToString(); addValue.fName1 = dr["FamilyName1"].ToString(); addValue.fBirthday1 = DateTime.Parse(dr["FamilyBirthday1"].ToString()).ToString("yyyy-MM-dd"); addValue.fEDU1 = dr["FamilyEducation1"].ToString(); addValue.fProfession1 = dr["FamilyProfession1"].ToString(); addValue.fLive1 = dr["FamilyLive1"].ToString(); addValue.fHearing1 = dr["FamilyHearing1"].ToString(); addValue.fHealthy1 = dr["FamilyHealth1"].ToString(); addValue.familyText01 = dr["FamilyHealthText1"].ToString(); addValue.fAppellation2 = dr["FamilyAppellation2"].ToString(); addValue.fName2 = dr["FamilyName2"].ToString(); addValue.fBirthday2 = DateTime.Parse(dr["FamilyBirthday2"].ToString()).ToString("yyyy-MM-dd"); addValue.fEDU2 = dr["FamilyEducation2"].ToString(); addValue.fProfession2 = dr["FamilyProfession2"].ToString(); addValue.fLive2 = dr["FamilyLive2"].ToString(); addValue.fHearing2 = dr["FamilyHearing2"].ToString(); addValue.fHealthy2 = dr["FamilyHealth2"].ToString(); addValue.familyText02 = dr["FamilyHealthText2"].ToString(); addValue.fAppellation3 = dr["FamilyAppellation3"].ToString(); addValue.fName3 = dr["FamilyName3"].ToString(); addValue.fBirthday3 = DateTime.Parse(dr["FamilyBirthday3"].ToString()).ToString("yyyy-MM-dd"); addValue.fEDU3 = dr["FamilyEducation3"].ToString(); addValue.fProfession3 = dr["FamilyProfession3"].ToString(); addValue.fLive3 = dr["FamilyLive3"].ToString(); addValue.fHearing3 = dr["FamilyHearing3"].ToString(); addValue.fHealthy3 = dr["FamilyHealth3"].ToString(); addValue.familyText03 = dr["FamilyHealthText3"].ToString(); addValue.fAppellation4 = dr["FamilyAppellation4"].ToString(); addValue.fName4 = dr["FamilyName4"].ToString(); addValue.fBirthday4 = DateTime.Parse(dr["FamilyBirthday4"].ToString()).ToString("yyyy-MM-dd"); addValue.fEDU4 = dr["FamilyEducation4"].ToString(); addValue.fProfession4 = dr["FamilyProfession4"].ToString(); addValue.fLive4 = dr["FamilyLive4"].ToString(); addValue.fHearing4 = dr["FamilyHearing4"].ToString(); addValue.fHealthy4 = dr["FamilyHealth4"].ToString(); addValue.familyText04 = dr["FamilyHealthText4"].ToString(); addValue.fAppellation5 = dr["FamilyAppellation5"].ToString(); addValue.fName5 = dr["FamilyName5"].ToString(); addValue.fBirthday5 = DateTime.Parse(dr["FamilyBirthday5"].ToString()).ToString("yyyy-MM-dd"); addValue.fEDU5 = dr["FamilyEducation5"].ToString(); addValue.fProfession5 = dr["FamilyProfession5"].ToString(); addValue.fLive5 = dr["FamilyLive5"].ToString(); addValue.fHearing5 = dr["FamilyHearing5"].ToString(); addValue.fHealthy5 = dr["FamilyHealth5"].ToString(); addValue.familyText05 = dr["FamilyHealthText5"].ToString(); addValue.fAppellation6 = dr["FamilyAppellation6"].ToString(); addValue.fName6 = dr["FamilyName6"].ToString(); addValue.fBirthday6 = DateTime.Parse(dr["FamilyBirthday6"].ToString()).ToString("yyyy-MM-dd"); addValue.fEDU6 = dr["FamilyEducation6"].ToString(); addValue.fProfession6 = dr["FamilyProfession6"].ToString(); addValue.fLive6 = dr["FamilyLive6"].ToString(); addValue.fHearing6 = dr["FamilyHearing6"].ToString(); addValue.fHealthy6 = dr["FamilyHealth6"].ToString(); addValue.familyText06 = dr["FamilyHealthText6"].ToString(); addValue.fAppellation7 = dr["FamilyAppellation7"].ToString(); addValue.fName7 = dr["FamilyName7"].ToString(); addValue.fBirthday7 = DateTime.Parse(dr["FamilyBirthday7"].ToString()).ToString("yyyy-MM-dd"); addValue.fEDU7 = dr["FamilyEducation7"].ToString(); addValue.fProfession7 = dr["FamilyProfession7"].ToString(); addValue.fLive7 = dr["FamilyLive7"].ToString(); addValue.fHearing7 = dr["FamilyHearing7"].ToString(); addValue.fHealthy7 = dr["FamilyHealth7"].ToString(); addValue.familyText07 = dr["FamilyHealthText7"].ToString(); addValue.fAppellation8 = dr["FamilyAppellation8"].ToString(); addValue.fName8 = dr["FamilyName8"].ToString(); addValue.fBirthday8 = DateTime.Parse(dr["FamilyBirthday8"].ToString()).ToString("yyyy-MM-dd"); addValue.fEDU8 = dr["FamilyEducation8"].ToString(); addValue.fProfession8 = dr["FamilyProfession8"].ToString(); addValue.fLive8 = dr["FamilyLive8"].ToString(); addValue.fHearing8 = dr["FamilyHearing8"].ToString(); addValue.fHealthy8 = dr["FamilyHealth8"].ToString(); addValue.familyText08 = dr["FamilyHealthText8"].ToString(); addValue.lang1 = dr["FamilyLanguage"].ToString(); addValue.lang1t01 = dr["FamilyLanguageText"].ToString(); addValue.lang2 = dr["FamilyConnectLanguage"].ToString(); addValue.lang2t01 = dr["FamilyConnectLanguageText"].ToString(); addValue.familyEcological = dr["FamilyProfile1"].ToString(); addValue.famailySituation = dr["FamilyProfile2"].ToString(); addValue.famailyMedical = dr["FamilyProfile3"].ToString(); addValue.famailyActionSituation = dr["FamilyProfile4"].ToString(); addValue.fswAssess = dr["FamilyProfile5"].ToString(); StaffData = sDB.getStaffDataName(dr["FamilyProfileWriteName"].ToString()); addValue.socialName = StaffData[1]; addValue.socialDate = DateTime.Parse(dr["FamilyProfileWriteDate"].ToString()).ToString("yyyy-MM-dd"); returnValue.StudentData = addValue; StudentHearingInformation addValue2 = new StudentHearingInformation(); addValue2.history = dr["StudentDevelop"].ToString(); addValue2.history02t01 = dr["StudentDevelopText21"].ToString(); addValue2.history02t02 = dr["StudentDevelopText22"].ToString(); addValue2.history03t01 = dr["StudentDevelopText31"].ToString(); addValue2.history06t01 = dr["StudentDevelopText61"].ToString(); addValue2.history06t02 = dr["StudentDevelopText62"].ToString(); addValue2.history08t01 = dr["StudentDevelopText81"].ToString(); addValue2.history10t01 = dr["StudentDevelopText10"].ToString(); addValue2.history11t01 = dr["StudentDevelopText11"].ToString(); addValue2.history12t01 = dr["StudentDevelopText12"].ToString(); addValue2.problems01t01 = dr["HearingProblemAge"].ToString(); addValue2.problems01t02 = dr["HearingProblemMonth"].ToString(); addValue2.hearingQ = dr["HearingProblem"].ToString(); addValue2.hearingQText = dr["HearingProblemText"].ToString(); addValue2.problems02t01 = dr["DiagnoseAge"].ToString(); addValue2.problems02t02 = dr["DiagnoseMonth"].ToString(); addValue2.problems02t03 = dr["DiagnoseAgency"].ToString(); addValue2.problems02t04 = dr["DiagnoseR"].ToString(); addValue2.problems02t05 = dr["DiagnoseL"].ToString(); addValue2.hearingcheck = dr["NewbornHearing"].ToString(); addValue2.hearingYescheck = dr["NewbornHearingInspection"].ToString(); addValue2.hearingYesPlace = dr["NewbornHearingInspectionAgency"].ToString(); addValue2.hearingYesResultR = dr["NewbornHearingInspectionDiagnoseR"].ToString(); addValue2.hearingYesResultL = dr["NewbornHearingInspectionDiagnoseL"].ToString(); addValue2.sleepcheck = dr["AuditoryElectrophysiology1"].ToString(); addValue2.sleepcheckTime1 = DateTime.Parse(dr["AuditoryElectrophysiology_Date1"].ToString()).ToString("yyyy-MM-dd");//dr["AuditoryElectrophysiology_Date1"].ToString(); addValue2.sleepcheckPlace1 = dr["AuditoryElectrophysiology_Agency1"].ToString(); addValue2.sleepcheckCheckItem1 = dr["AuditoryElectrophysiology_Item1"].ToString(); addValue2.sleepcheckResultL1 = dr["AuditoryElectrophysiology_Diagnose1R"].ToString(); addValue2.sleepcheckResultR1 = dr["AuditoryElectrophysiology_Diagnose1L"].ToString(); addValue2.sleepcheckTime2 = DateTime.Parse(dr["AuditoryElectrophysiology_Date2"].ToString()).ToString("yyyy-MM-dd"); addValue2.sleepcheckPlace2 = dr["AuditoryElectrophysiology_Agency2"].ToString(); addValue2.sleepcheckCheckItem2 = dr["AuditoryElectrophysiology_Item2"].ToString(); addValue2.sleepcheckResultL2 = dr["AuditoryElectrophysiology_Diagnose2R"].ToString(); addValue2.sleepcheckResultR2 = dr["AuditoryElectrophysiology_Diagnose2L"].ToString(); addValue2.sleepcheckTime3 = DateTime.Parse(dr["AuditoryElectrophysiology_Date3"].ToString()).ToString("yyyy-MM-dd"); addValue2.sleepcheckPlace3 = dr["AuditoryElectrophysiology_Agency3"].ToString(); addValue2.sleepcheckCheckItem3 = dr["AuditoryElectrophysiology_Item3"].ToString(); addValue2.sleepcheckResultL3 = dr["AuditoryElectrophysiology_Diagnose3R"].ToString(); addValue2.sleepcheckResultR3 = dr["AuditoryElectrophysiology_Diagnose3L"].ToString(); addValue2.sleepcheckTime4 = DateTime.Parse(dr["AuditoryElectrophysiology_Date4"].ToString()).ToString("yyyy-MM-dd"); addValue2.sleepcheckPlace4 = dr["AuditoryElectrophysiology_Agency4"].ToString(); addValue2.sleepcheckCheckItem4 = dr["AuditoryElectrophysiology_Item4"].ToString(); addValue2.sleepcheckResultL4 = dr["AuditoryElectrophysiology_Diagnose4R"].ToString(); addValue2.sleepcheckResultR4 = dr["AuditoryElectrophysiology_Diagnose4L"].ToString(); addValue2.sleepcheckTime5 = DateTime.Parse(dr["AuditoryElectrophysiology_Date5"].ToString()).ToString("yyyy-MM-dd"); addValue2.sleepcheckPlace5 = dr["AuditoryElectrophysiology_Agency5"].ToString(); addValue2.sleepcheckCheckItem5 = dr["AuditoryElectrophysiology_Item5"].ToString(); addValue2.sleepcheckResultL5 = dr["AuditoryElectrophysiology_Diagnose5R"].ToString(); addValue2.sleepcheckResultR5 = dr["AuditoryElectrophysiology_Diagnose5L"].ToString(); addValue2.ctmri = dr["CTorMRI"].ToString(); addValue2.ctmriTime = DateTime.Parse(dr["CTorMRI_Date1"].ToString()).ToString("yyyy-MM-dd"); addValue2.ctmriPlace = dr["CTorMRI_Agency1"].ToString(); addValue2.ctmriResultL = dr["CTorMRI_DiagnoseR"].ToString(); addValue2.ctmriResultR = dr["CTorMRI_DiagnoseL"].ToString(); addValue2.gene = dr["GeneScreening"].ToString(); addValue2.geneTime = DateTime.Parse(dr["GeneScreening_Date"].ToString()).ToString("yyyy-MM-dd"); addValue2.genePlace = dr["GeneScreening_Agency"].ToString(); addValue2.geneResult = dr["GeneScreening_Item"].ToString(); addValue2.familyhistory = dr["FamilyHearingProblemHistory"].ToString(); addValue2.familyhistoryText = dr["FamilyHearingProblemHistoryText"].ToString(); addValue2.changehistory = dr["HearingChangeHistory"].ToString(); addValue2.changehistoryText = dr["HearingChangeHistoryText"].ToString(); addValue2.assistmanage = dr["AidsManagement"].ToString(); addValue2.accessory = dr["AidsManagementTextAge"].ToString(); addValue2.assistmanageR = dr["HearingAids_R"].ToString(); addValue2.brandR = dr["AidsBrand_R"].ToString(); addValue2.modelR = dr["AidsModel_R"].ToString(); addValue2.buyingPlaceR = dr["AidsOptionalLocation_R"].ToString(); addValue2.buyingtimeR = DateTime.Parse(dr["AidsOptionalTime_R"].ToString()).ToString("yyyy-MM-dd"); addValue2.insertHospitalR = dr["EEarHospital_R"].ToString(); addValue2.openHzDateR = DateTime.Parse(dr["EEarOpen_R"].ToString()).ToString("yyyy-MM-dd"); addValue2.assistmanageL = dr["HearingAids_L"].ToString(); addValue2.brandL = dr["AidsBrand_L"].ToString(); addValue2.modelL = dr["AidsModel_L"].ToString(); addValue2.buyingtimeL = DateTime.Parse(dr["AidsOptionalTime_L"].ToString()).ToString("yyyy-MM-dd"); addValue2.buyingPlaceL = dr["AidsOptionalLocation_L"].ToString(); addValue2.insertHospitalL = dr["EEarHospital_L"].ToString(); addValue2.openHzDateL = DateTime.Parse(dr["EEarOpen_L"].ToString()).ToString("yyyy-MM-dd"); addValue2.allassis = dr["AllDayAids"].ToString(); addValue2.allassisNoText = dr["AllDayAidsText"].ToString(); addValue2.assis1 = dr["ActiveReaction"].ToString(); addValue2.assis1NoText = dr["ActiveReactionText"].ToString(); addValue2.assis2 = dr["BasicCare"].ToString(); addValue2.assis2NoText = dr["BasicCareText"].ToString(); addValue2.assisFM = dr["UseFMsystem"].ToString(); addValue2.assisFMBrand = dr["UseFMsystemBrand"].ToString(); addValue2.assessnotes = dr["HearingAssessmentSummary"].ToString(); addValue2.assessnotes1 = dr["EarEndoscopy"].ToString(); addValue2.assessnotes102Text = dr["EarEndoscopyAbnormalText"].ToString(); addValue2.problems11t02 = dr["PureToneText"].ToString(); addValue2.assessnotes2 = dr["Tympanogram"].ToString(); addValue2.problems11t03 = dr["SATorSDT"].ToString(); addValue2.problems11t04 = dr["SpeechRecognition"].ToString(); addValue2.problems11t05 = dr["AidsSystem"].ToString(); addValue2.problems11t06 = dr["HearingInspection"].ToString(); addValue2.problems11t07 = dr["HearingOther"].ToString(); addValue2.inspectorID = dr["Audiologist"].ToString(); addValue2.inspectorDate = DateTime.Parse(dr["SurveyingDate"].ToString()).ToString("yyyy-MM-dd"); returnValue.HearingData = addValue2; StudentTeachingInformation addValue4 = new StudentTeachingInformation(); addValue4.case1 = dr["CaseFamilyCooperative"].ToString(); addValue4.case1t04 = dr["EntrustOthers"].ToString(); addValue4.case1t05 = dr["CooperativeDifficulty"].ToString(); addValue4.case2 = dr["RearingAttitude"].ToString(); addValue4.case21 = dr["RearingAttitude1"].ToString(); addValue4.case21t01 = dr["RearingAttitude1Text"].ToString(); addValue4.case22 = dr["RearingAttitude2"].ToString(); addValue4.case22t01 = dr["RearingAttitude2Text"].ToString(); addValue4.case23 = dr["RearingAttitude3"].ToString(); addValue4.case23t01 = dr["RearingAttitude3Text"].ToString(); addValue4.case24 = dr["RearingAttitude4"].ToString(); addValue4.case24t01 = dr["RearingAttitude4Text"].ToString(); addValue4.case25 = dr["RearingAttitude5"].ToString(); addValue4.case25t01 = dr["RearingAttitude5Text"].ToString(); addValue4.case26 = dr["RearingAttitude6"].ToString(); addValue4.case26t01 = dr["RearingAttitude6Text"].ToString(); addValue4.case3 = dr["Dispositional"].ToString(); addValue4.case31 = dr["Dispositional1"].ToString(); addValue4.case31t01 = dr["Dispositional1Text"].ToString(); addValue4.case32 = dr["Dispositional2"].ToString(); addValue4.case32t01 = dr["Dispositional2Text"].ToString(); addValue4.case33 = dr["Dispositional3"].ToString(); addValue4.case33t01 = dr["Dispositional3Text"].ToString(); addValue4.case34 = dr["Dispositional4"].ToString(); addValue4.case34t01 = dr["Dispositional4Text"].ToString(); addValue4.attend = dr["Attendance"].ToString(); addValue4.attend01t01 = dr["AttendanceText"].ToString(); addValue4.accompany = dr["TeachEscorts"].ToString(); addValue4.accompany01t01 = dr["TeachEscortsText"].ToString(); addValue4.teach = dr["AfterTeach"].ToString(); addValue4.teach01t01 = dr["AfterTeachText"].ToString(); addValue4.caseQ = dr["MajorProblem"].ToString(); addValue4.caseQ01t01 = dr["MajorProblemText"].ToString(); addValue4.OtherRemark1 = dr["RemarkOther"].ToString(); addValue4.case4 = dr["LearningAttitude"].ToString(); addValue4.case5 = dr["Temperament"].ToString(); addValue4.case6 = dr["Activity"].ToString(); addValue4.case7 = dr["Focus"].ToString(); addValue4.case8 = dr["Persistence"].ToString(); addValue4.case9 = dr["CommunicationBehavior"].ToString(); addValue4.case10 = dr["AuditorySkill"].ToString(); addValue4.case11 = dr["Acknowledge"].ToString(); addValue4.case12 = dr["Language"].ToString(); addValue4.case12t01 = dr["LanguageText"].ToString(); addValue4.case13 = dr["Action"].ToString(); addValue4.wear = dr["WearAids"].ToString(); addValue4.mind = dr["SpiritAndCoordinate"].ToString(); addValue4.mind01t01 = dr["SpiritAndCoordinateOther"].ToString(); addValue4.connectwish = dr["Communication"].ToString(); addValue4.studywish = dr["LearningDesire"].ToString(); addValue4.related = dr["AttachmentData"].ToString(); addValue4.related01t01 = dr["AttachmentDataText"].ToString(); addValue4.OtherRemark2 = dr["RemarkOther2"].ToString(); addValue4.case14 = dr["ExistingResources"].ToString(); addValue4.trusteeship = dr["InterventionAgencies"].ToString(); addValue4.case14t01 = dr["HospitalIntervention"].ToString(); addValue4.proceed = dr["RelatedIntervention"].ToString(); addValue4.proceedt01 = dr["RelatedInterventionText"].ToString(); addValue4.preschools = dr["InNurserySchool"].ToString(); addValue4.case15 = dr["HearingRehabilitation"].ToString(); addValue4.Rehabilitation1 = dr["CaseNeed"].ToString(); addValue4.Rehabilitation2 = dr["CaseFamilyEnthusiasm"].ToString(); addValue4.Rehabilitation3 = dr["Rehousing"].ToString(); addValue4.Rehabilitation3Text = dr["RehousingText"].ToString(); addValue4.case16 = dr["CaseFamilyCourseProposal"].ToString(); addValue4.OtherRemark3 = dr["CaseFamilyCourseProposalText"].ToString(); addValue4.case17 = dr["CaseCourseProposal"].ToString(); addValue4.OtherRemark4 = dr["CaseCourseProposalText"].ToString(); addValue4.teacherID = dr["Teacher"].ToString(); addValue4.teacherDate = DateTime.Parse(dr["TeacherDate"].ToString()).ToString("yyyy-MM-dd"); returnValue.TeachData = addValue4; } dr.Close(); List<StudentBodyInformation> addValue3 = new List<StudentBodyInformation>(); sql = "SELECT * FROM StudentHeightWeightRecord WHERE isDeleted=0 AND StudentID=(@ID)"; cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@ID", SqlDbType.NVarChar).Value = returnValue.StudentData.studentID; dr = cmd.ExecuteReader(); while (dr.Read()) { StudentBodyInformation addValue3item = new StudentBodyInformation(); addValue3item.RecordID = dr["hwID"].ToString(); addValue3item.RecordDate = DateTime.Parse(dr["hwDate"].ToString()).ToString("yyyy-MM-dd"); addValue3item.studentID = dr["StudentID"].ToString(); addValue3item.RecordHeight = dr["StudentHeight"].ToString(); addValue3item.RecordWeight = dr["StudentWeight"].ToString(); addValue3item.RecordRemark = dr["hwRemark"].ToString(); addValue3.Add(addValue3item); } dr.Close(); returnValue.BodyData = addValue3; Sqlconn.Close(); } catch (Exception e) { returnValue.checkNo = "-1"; returnValue.errorMsg = e.Message; } } return returnValue; }
public string[] setStudentDataBase6(StudentHearingInformation StudentHearingData) { Audiometry aDB = new Audiometry(); CaseDataBase SDB = new CaseDataBase(); //if (int.Parse(aDB._StaffhaveRoles[1]) == 1) //{ return SDB.setStudentDataBase6(StudentHearingData); //} //else //{ // return new string[2] { _noRole, _errorMsg }; //} }
public StudentHearingInformation getstudentdhearInfo(string ID) { CaseDataBase SDB = new CaseDataBase(); StudentHearingInformation returnValue = new StudentHearingInformation(); if (int.Parse(SDB._StaffhaveRoles[3]) == 1) { returnValue = SDB.getStudentHearingInfo(ID); } else { returnValue.checkNo = _noRole; returnValue.errorMsg = _errorMsg; } return returnValue; }