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;
}
