public string[] ComparisonAidsData(StudentDataBasic DateItem)
{
string[] returnValue = new string[2];
AspAjax asp = new AspAjax();
try
{
StudentDataBasic BasicData = asp.getStudentAidsDataBaseBasic(DateItem.studentID);
if (DateItem.assistmanageR != BasicData.assistmanageR || DateItem.brandR != BasicData.brandR || DateItem.modelR != BasicData.modelR || DateItem.buyingPlaceR != BasicData.buyingPlaceR || DateItem.buyingtimeR != BasicData.buyingtimeR || DateItem.insertHospitalR != BasicData.insertHospitalR || DateItem.openHzDateR != BasicData.openHzDateR || DateItem.assistmanageL != BasicData.assistmanageL || DateItem.brandL != BasicData.brandL || DateItem.modelL != BasicData.modelL || DateItem.buyingtimeL != BasicData.buyingtimeL || DateItem.buyingPlaceL != BasicData.buyingPlaceL || DateItem.insertHospitalL != BasicData.insertHospitalL || DateItem.openHzDateL != BasicData.openHzDateL)
{
CreateStudentAidsUse AidsUseData = new CreateStudentAidsUse();
AidsUseData.studentID = DateItem.studentID;
AidsUseData.assistmanageR = DateItem.assistmanageR;
AidsUseData.brandR = DateItem.brandR;
AidsUseData.modelR = DateItem.modelR;
AidsUseData.buyingPlaceR = DateItem.buyingPlaceR;
AidsUseData.buyingtimeR = DateItem.buyingtimeR;
AidsUseData.insertHospitalR = DateItem.insertHospitalR;
AidsUseData.openHzDateR = DateItem.openHzDateR;
AidsUseData.assistmanageL = DateItem.assistmanageL;
AidsUseData.brandL = DateItem.brandL;
AidsUseData.modelL = DateItem.modelL;
AidsUseData.buyingtimeL = DateItem.buyingtimeL;
AidsUseData.buyingPlaceL = DateItem.buyingPlaceL;
AidsUseData.insertHospitalL = DateItem.insertHospitalL;
AidsUseData.openHzDateL = DateItem.openHzDateL;
// string[] item=this.createStudentAidsUse(AidsUseData);
DateItem.ID = BasicData.ID;
returnValue = this.setStudentDataHearingInformation(DateItem);
}
}
catch (Exception e)
{
returnValue[0] = "-1";
returnValue[1] = e.Message.ToString();
}
return returnValue;
}
public string[] createStudentAidsUse(CreateStudentAidsUse StudentData)
{
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 HearingCaseAidsUseRecord (Unit, StudentID, StudentAge, StudentMonth, HearingAids_R, AidsBrand_R, AidsModel_R, AidsOptionalTime_R, " +
"AidsOptionalLocation_R, EEarHospital_R, EEarOpen_R, AidsSource_R, AidsSourceText_R, HearingAids_L, AidsBrand_L, AidsModel_L, AidsOptionalTime_L, " +
"AidsOptionalLocation_L, EEarHospital_L, EEarOpen_L, AidsSource_L, AidsSourceText_L, " +
"AcquisitionDate, FMSourceAids, FMTypeAids, FMAidsBrand, FMAidsModel, FMAidsChannel, FMAidsModelR, FMAidsDPAIR, FMAidsProgramR, FMAudioProportionR, " +
"FMAidsUIR, FMAidsUITextR, FMAidsReceptorR, FMAidsReceptorVolumeR, FMAidsGainR, FMAidsModelL, FMAidsDPAIL, FMAidsProgramL, FMAudioProportionL, FMAidsUIL, " +
"FMAidsUITextL, FMAidsReceptorL, FMAidsReceptorVolumeL, FMAidsGainL, CreateFileBy, UpFileBy, UpFileDate,assessDate) " +
"VALUES(@Unit, @StudentID, @StudentAge, @StudentMonth, @HearingAids_R, @AidsBrand_R, @AidsModel_R, @AidsOptionalTime_R, @AidsOptionalLocation_R, " +
"@EEarHospital_R, @EEarOpen_R, @AidsSource_R, @AidsSourceText_R, @HearingAids_L, @AidsBrand_L, @AidsModel_L, @AidsOptionalTime_L, " +
"@AidsOptionalLocation_L, @EEarHospital_L, @EEarOpen_L, @AidsSource_L, @AidsSourceText_L, " +
"@AcquisitionDate, @FMSourceAids, @FMTypeAids, @FMAidsBrand, @FMAidsModel, @FMAidsChannel, @FMAidsModelR, @FMAidsDPAIR, @FMAidsProgramR, " +
"@FMAudioProportionR, @FMAidsUIR, @FMAidsUITextR, @FMAidsReceptorR, @FMAidsReceptorVolumeR, @FMAidsGainR, @FMAidsModelL, @FMAidsDPAIL, " +
"@FMAidsProgramL, @FMAudioProportionL, @FMAidsUIL, @FMAidsUITextL, @FMAidsReceptorL, @FMAidsReceptorVolumeL, @FMAidsGainL, @CreateFileBy, " +
"@UpFileBy, (getDate()),@assessDate)";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@AssessDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentData.assessDate);
cmd.Parameters.Add("@Unit", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[2].ToString());
cmd.Parameters.Add("@StudentID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StudentData.studentID);
cmd.Parameters.Add("@StudentAge", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.studentAge);
cmd.Parameters.Add("@StudentMonth", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.studentMonth);
cmd.Parameters.Add("@HearingAids_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.assistmanageR);
cmd.Parameters.Add("@AidsBrand_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.brandR);
cmd.Parameters.Add("@AidsModel_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.modelR);
cmd.Parameters.Add("@AidsOptionalTime_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentData.buyingtimeR);
cmd.Parameters.Add("@AidsOptionalLocation_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.buyingPlaceR);
cmd.Parameters.Add("@EEarHospital_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.insertHospitalR);
cmd.Parameters.Add("@EEarOpen_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentData.openHzDateR);
cmd.Parameters.Add("@AidsSource_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.sourceR);
cmd.Parameters.Add("@AidsSourceText_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.sourceTextR);
cmd.Parameters.Add("@HearingAids_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.assistmanageL);
cmd.Parameters.Add("@AidsBrand_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.brandL);
cmd.Parameters.Add("@AidsModel_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.modelL);
cmd.Parameters.Add("@AidsOptionalTime_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.buyingtimeL);
cmd.Parameters.Add("@AidsOptionalLocation_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.buyingPlaceL);
cmd.Parameters.Add("@EEarHospital_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.insertHospitalL);
cmd.Parameters.Add("@EEarOpen_L", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentData.openHzDateL);
cmd.Parameters.Add("@AidsSource_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.sourceL);
cmd.Parameters.Add("@AidsSourceText_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.sourceTextL);
cmd.Parameters.Add("@AcquisitionDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentData.gainDate);
cmd.Parameters.Add("@FMSourceAids", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fmAidssource);
cmd.Parameters.Add("@FMTypeAids", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fmAidstype);
cmd.Parameters.Add("@FMAidsBrand", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmBrand);
cmd.Parameters.Add("@FMAidsModel", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmModel);
cmd.Parameters.Add("@FMAidsChannel", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmChannel);
cmd.Parameters.Add("@FMAidsModelR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmAidstypeR);
cmd.Parameters.Add("@FMAidsDPAIR", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.DPAIsettingR);
cmd.Parameters.Add("@FMAidsProgramR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmProgramR);
cmd.Parameters.Add("@FMAudioProportionR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmAudioR);
cmd.Parameters.Add("@FMAidsUIR", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fmUIR);
cmd.Parameters.Add("@FMAidsUITextR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmUITextR);
cmd.Parameters.Add("@FMAidsReceptorR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmReceptorR);
cmd.Parameters.Add("@FMAidsReceptorVolumeR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmVolumeR);
cmd.Parameters.Add("@FMAidsGainR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmGainR);
cmd.Parameters.Add("@FMAidsModelL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmAidstypeL);
cmd.Parameters.Add("@FMAidsDPAIL", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.DPAIsettingL);
cmd.Parameters.Add("@FMAidsProgramL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmProgramL);
cmd.Parameters.Add("@FMAudioProportionL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmAudioL);
cmd.Parameters.Add("@FMAidsUIL", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fmUIL);
cmd.Parameters.Add("@FMAidsUITextL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmUITextL);
cmd.Parameters.Add("@FMAidsReceptorL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmReceptorL);
cmd.Parameters.Add("@FMAidsReceptorVolumeL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmVolumeL);
cmd.Parameters.Add("@FMAidsGainL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmGainL);
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('HearingCaseAidsUseRecord') AS cID";
cmd = new SqlCommand(sql, Sqlconn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
returnValue[1] = dr["cID"].ToString();
}
dr.Close();
}
Sqlconn.Close();
}
catch (Exception e)
{
returnValue[0] = "-1";
returnValue[1] = e.Message.ToString();
}
}
return returnValue;
}
private CreateStudentAidsUse getStudentFMUseNew(string StudentID)
{
CreateStudentAidsUse returnValue = new CreateStudentAidsUse();
DataBase Base = new DataBase();
using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
{
try
{
Sqlconn.Open();
string sql = "SELECT TOP 1 * FROM HearingCaseAidsUseRecord " +
"WHERE isDeleted=0 AND StudentID=@StudentID ORDER BY ID DESC";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@StudentID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StudentID);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
returnValue.ID = dr["ID"].ToString();
returnValue.caseUnit = dr["Unit"].ToString();
returnValue.studentID = dr["StudentID"].ToString();
/*returnValue.studentName = dr["StudentName"].ToString();
returnValue.studentbirthday = DateTime.Parse(dr["StudentBirthday"].ToString()).ToString("yyyy-MM-dd");
returnValue.studentAge = dr["StudentAge"].ToString();
returnValue.studentMonth = dr["StudentMonth"].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.sourceR = dr["AidsSource_R"].ToString();
returnValue.sourceTextR = dr["AidsSourceText_R"].ToString();
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.sourceL = dr["AidsSource_L"].ToString();
returnValue.sourceTextL = dr["AidsSourceText_L"].ToString();
returnValue.gainDate = DateTime.Parse(dr["AcquisitionDate"].ToString()).ToString("yyyy-MM-dd");*/
returnValue.fmAidssource = dr["FMSourceAids"].ToString();
returnValue.fmAidstype = dr["FMTypeAids"].ToString();
returnValue.fmBrand = dr["FMAidsBrand"].ToString();
returnValue.fmModel = dr["FMAidsModel"].ToString();
returnValue.fmChannel = dr["FMAidsChannel"].ToString();
returnValue.fmAidstypeR = dr["FMAidsModelR"].ToString();
returnValue.DPAIsettingR = dr["FMAidsDPAIR"].ToString();
returnValue.fmProgramR = dr["FMAidsProgramR"].ToString();
returnValue.fmAudioR = dr["FMAudioProportionR"].ToString();
returnValue.fmUIR = dr["FMAidsUIR"].ToString();
returnValue.fmUITextR = dr["FMAidsUITextR"].ToString();
returnValue.fmReceptorR = dr["FMAidsReceptorR"].ToString();
returnValue.fmVolumeR = dr["FMAidsReceptorVolumeR"].ToString();
returnValue.fmGainR = dr["FMAidsGainR"].ToString();
returnValue.fmAidstypeL = dr["FMAidsModelL"].ToString();
returnValue.DPAIsettingL = dr["FMAidsDPAIL"].ToString();
returnValue.fmProgramL = dr["FMAidsProgramL"].ToString();
returnValue.fmAudioL = dr["FMAudioProportionL"].ToString();
returnValue.fmUIL = dr["FMAidsUIL"].ToString();
returnValue.fmUITextL = dr["FMAidsUITextL"].ToString();
returnValue.fmReceptorL = dr["FMAidsReceptorL"].ToString();
returnValue.fmVolumeL = dr["FMAidsReceptorVolumeL"].ToString();
returnValue.fmGainL = dr["FMAidsGainL"].ToString();
}
dr.Close();
Sqlconn.Close();
}
catch (Exception e)
{
returnValue.checkNo = "-1";
returnValue.errorMsg = e.Message.ToString();
}
}
return returnValue;
}
public string[] createHearingInspectionData(CreateHearingInspection StructData)
{
string[] returnValue = new string[2];
returnValue[0] = "0";
returnValue[1] = "";
DataBase Base = new DataBase();
using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
{
try
{
StaffDataBase sDB = new StaffDataBase();
List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name);
Sqlconn.Open();
string sql = "INSERT INTO HearingInspection (Unit, CheckDate, StudentID, CheckType, Credibility,HearingAids_R, "+
"AidsBrand_R, AidsModel_R, AidsOptionalTime_R, "+
"AidsOptionalLocation_R, EEarHospital_R, EEarOpen_R, HearingAids_L, AidsBrand_L, AidsModel_L, AidsOptionalTime_L, "+
"AidsOptionalLocation_L, EEarHospital_L,"+
"EEarOpen_L, ListenCheck, Earphones, NakedEar, HearingAfter, PureToneImg, PrueRDecibel, PrueLDecibel, EarEndoscopyRight, " +
"EarEndoscopyRExplain, EarEndoscopyLeft, EarEndoscopyLExplain, TympanicCavity, PatternRight, PatternLeft, CanalRight, CanalLeft, "+
"EardrumRight, " +
"EardrumLeft, PressureRight, PressureLeft, AidsDetectRight1, AidsDetectRight2, AidsDetectLeft1, AidsDetectLeft2, AidsDetect, "+
"VoiceMaterial1, VoiceWear1, " +
"VoiceState1, VoiceVolume1, VoiceResult1, VoiceRemark1, VoiceMaterial2, VoiceWear2, VoiceState2, VoiceVolume2, VoiceResult2, "+
"VoiceRemark2, VoiceItem3, " +
"VoiceMaterial3, VoiceWear3, VoiceState3, VoiceVolume3, VoiceResult3, VoiceRemark3, VoiceItem4, VoiceMaterial4, VoiceWear4, "+
"VoiceState4, VoiceVolume4, " +
"VoiceResult4, VoiceRemark4, VoicePurpose, VoicePurposeExplain, VoiceExplain, CreateFileBy, UpFileBy, UpFileDate,"+
"material1,SATVolumeBefore,SATREarBefore,SATLEarBefore,SATEarBefore,SATVolumeAfter,SATREarAfter,SATLEarAfter,SATEarAfter,"+
"WRSVolumeBefore,WRSREarBefore,WRSLEarBefore,WRSEarBefore,WRSVolumeAfter,WRSREarAfter,WRSLEarAfter,WRSEarAfter," +
"material2,material3,project3,project3VolumeBefore,project3REarBefore,project3LEarBefore,project3EarBefore,"+
"project3VolumeAfter,project3REarAfter,project3LEarAfter,project3EarAfter," +
"material4,project4,project4VolumeBefore,project4REarBefore,project4LEarBefore,project4EarBefore," +
"project4VolumeAfter,project4REarAfter,project4LEarAfter,project4EarAfter," +
"checkPurposeText,checkPurpose,explain" +
") " +
"VALUES(@Unit, @CheckDate, @StudentID, @CheckType, @Credibility, @HearingAids_R, @AidsBrand_R, @AidsModel_R, @AidsOptionalTime_R, "+
"@AidsOptionalLocation_R, "+
"@EEarHospital_R, @EEarOpen_R, @HearingAids_L, @AidsBrand_L, @AidsModel_L, @AidsOptionalTime_L, @AidsOptionalLocation_L, "+
"@EEarHospital_L, @EEarOpen_L, "+
"@ListenCheck, @Earphones, @NakedEar, @HearingAfter, @PureToneImg, @PrueRDecibel, @PrueLDecibel, @EarEndoscopyRight, "+
"@EarEndoscopyRExplain, " +
"@EarEndoscopyLeft, @EarEndoscopyLExplain, @TympanicCavity, @PatternRight, @PatternLeft, @CanalRight, @CanalLeft, "+
"@EardrumRight, @EardrumLeft, " +
"@PressureRight, @PressureLeft, @AidsDetectRight1, @AidsDetectRight2, @AidsDetectLeft1, @AidsDetectLeft2, @AidsDetect, "+
"@VoiceMaterial1, @VoiceWear1, " +
"@VoiceState1, @VoiceVolume1, @VoiceResult1, @VoiceRemark1, @VoiceMaterial2, @VoiceWear2, @VoiceState2, @VoiceVolume2, "+
"@VoiceResult2, @VoiceRemark2, " +
"@VoiceItem3, @VoiceMaterial3, @VoiceWear3, @VoiceState3, @VoiceVolume3, @VoiceResult3, @VoiceRemark3, @VoiceItem4, "+
"@VoiceMaterial4, @VoiceWear4, " +
"@VoiceState4, @VoiceVolume4, @VoiceResult4, @VoiceRemark4, @VoicePurpose, @VoicePurposeExplain, @VoiceExplain, "+
"@CreateFileBy, @UpFileBy, (getDate()),"+
"@material1,@SATVolumeBefore,@SATREarBefore,@SATLEarBefore,@SATEarBefore,@SATVolumeAfter,@SATREarAfter,@SATLEarAfter,@SATEarAfter,"+
"@WRSVolumeBefore,@WRSREarBefore,@WRSLEarBefore,@WRSEarBefore,@WRSVolumeAfter,@WRSREarAfter,@WRSLEarAfter,@WRSEarAfter," +
"@material2,@material3,@project3,@project3VolumeBefore,@project3REarBefore,@project3LEarBefore,@project3EarBefore," +
"@project3VolumeAfter,@project3REarAfter,@project3LEarAfter,@project3EarAfter," +
"@material4,@project4,@project4VolumeBefore,@project4REarBefore,@project4LEarBefore,@project4EarBefore," +
"@project4VolumeAfter,@project4REarAfter,@project4LEarAfter,@project4EarAfter," +
"@checkPurposeText,@checkPurpose,@explain" +
")";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@material1 ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material1);
cmd.Parameters.Add("@SATVolumeBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATVolumeBefore);
cmd.Parameters.Add("@SATREarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATREarBefore);
cmd.Parameters.Add("@SATLEarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATLEarBefore);
cmd.Parameters.Add("@SATEarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATEarBefore);
cmd.Parameters.Add("@SATVolumeAfter ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATVolumeAfter);
cmd.Parameters.Add("@SATREarAfter ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATREarAfter);
cmd.Parameters.Add("@SATLEarAfter ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATLEarAfter);
cmd.Parameters.Add("@SATEarAfter ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATEarAfter);
cmd.Parameters.Add("@WRSVolumeBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSVolumeBefore);
cmd.Parameters.Add("@WRSREarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSREarBefore);
cmd.Parameters.Add("@WRSLEarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSLEarBefore);
cmd.Parameters.Add("@WRSEarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSEarBefore);
cmd.Parameters.Add("@WRSVolumeAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSVolumeAfter);
cmd.Parameters.Add("@WRSREarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSREarAfter);
cmd.Parameters.Add("@WRSLEarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSLEarAfter);
cmd.Parameters.Add("@WRSEarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSEarAfter);
cmd.Parameters.Add("@material3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material3);
cmd.Parameters.Add("@project3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3);
cmd.Parameters.Add("@material2", SqlDbType.TinyInt).Value = StructData.material2;
cmd.Parameters.Add("@project3VolumeBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3VolumeBefore);
cmd.Parameters.Add("@project3REarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3REarBefore);
cmd.Parameters.Add("@project3LEarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3LEarBefore);
cmd.Parameters.Add("@project3EarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3EarBefore);
cmd.Parameters.Add("@project3VolumeAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3VolumeAfter);
cmd.Parameters.Add("@project3REarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3REarAfter);
cmd.Parameters.Add("@project3LEarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3LEarAfter);
cmd.Parameters.Add("@project3EarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3EarAfter);
cmd.Parameters.Add("@project4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4);
cmd.Parameters.Add("@material4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material4);
cmd.Parameters.Add("@project4VolumeBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4VolumeBefore);
cmd.Parameters.Add("@project4REarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4REarBefore);
cmd.Parameters.Add("@project4LEarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4LEarBefore);
cmd.Parameters.Add("@project4EarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4EarBefore);
cmd.Parameters.Add("@project4VolumeAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4VolumeAfter);
cmd.Parameters.Add("@project4REarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4REarAfter);
cmd.Parameters.Add("@project4LEarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4LEarAfter);
cmd.Parameters.Add("@project4EarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4EarAfter);
cmd.Parameters.Add("@checkPurposeText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkPurposeText);
cmd.Parameters.Add("@checkPurpose", SqlDbType.TinyInt).Value = StructData.checkPurpose;
cmd.Parameters.Add("@explain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.explain);
cmd.Parameters.Add("@Unit", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[2].ToString());
cmd.Parameters.Add("@CheckDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.checkDate);
cmd.Parameters.Add("@StudentID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.studentID);
cmd.Parameters.Add("@CheckType", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkMode);
cmd.Parameters.Add("@Credibility", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.credibility);
cmd.Parameters.Add("@HearingAids_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.assistmanageR);
cmd.Parameters.Add("@AidsBrand_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.brandR);
cmd.Parameters.Add("@AidsModel_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.modelR);
cmd.Parameters.Add("@AidsOptionalTime_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.buyingtimeR);
cmd.Parameters.Add("@AidsOptionalLocation_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.buyingPlaceR);
cmd.Parameters.Add("@EEarHospital_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.insertHospitalR);
cmd.Parameters.Add("@EEarOpen_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.openHzDateR);
cmd.Parameters.Add("@HearingAids_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.assistmanageL);
cmd.Parameters.Add("@AidsBrand_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.brandL);
cmd.Parameters.Add("@AidsModel_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.modelL);
cmd.Parameters.Add("@AidsOptionalTime_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.buyingtimeL);
cmd.Parameters.Add("@AidsOptionalLocation_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.buyingPlaceL);
cmd.Parameters.Add("@EEarHospital_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.insertHospitalL);
cmd.Parameters.Add("@EEarOpen_L", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.openHzDateL);
cmd.Parameters.Add("@ListenCheck", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkInstrument);
cmd.Parameters.Add("@Earphones", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.headphone);
cmd.Parameters.Add("@NakedEar", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.nudetonety);
cmd.Parameters.Add("@HearingAfter", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.hearingtone);
cmd.Parameters.Add("@PureToneImg", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingtoneImg);
cmd.Parameters.Add("@PrueRDecibel", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.toneR);
cmd.Parameters.Add("@PrueLDecibel", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.toneL);
cmd.Parameters.Add("@EarEndoscopyRight", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.hearingtoneR);
cmd.Parameters.Add("@EarEndoscopyRExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingtoneRText);
cmd.Parameters.Add("@EarEndoscopyLeft", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.hearingtoneL);
cmd.Parameters.Add("@EarEndoscopyLExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingtoneLText);
cmd.Parameters.Add("@TympanicCavity", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingInstrument);
cmd.Parameters.Add("@PatternRight", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingImgR);
cmd.Parameters.Add("@PatternLeft", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingImgL);
cmd.Parameters.Add("@CanalRight", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingVolumeR);
cmd.Parameters.Add("@CanalLeft", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingVolumeL);
cmd.Parameters.Add("@EardrumRight", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.conformR);
cmd.Parameters.Add("@EardrumLeft", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.conformL);
cmd.Parameters.Add("@PressureRight", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.pressureR);
cmd.Parameters.Add("@PressureLeft", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.pressureL);
cmd.Parameters.Add("@AidsDetectRight1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.aidsR);
cmd.Parameters.Add("@AidsDetectRight2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.aidsdetectR);
cmd.Parameters.Add("@AidsDetectLeft1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.aidsL);
cmd.Parameters.Add("@AidsDetectLeft2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.aidsdetectL);
cmd.Parameters.Add("@AidsDetect", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.aidsOther);
cmd.Parameters.Add("@VoiceMaterial1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material1);
cmd.Parameters.Add("@VoiceWear1", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.voice1);
cmd.Parameters.Add("@VoiceState1", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.state1);
cmd.Parameters.Add("@VoiceVolume1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.volume1);
cmd.Parameters.Add("@VoiceResult1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result1);
cmd.Parameters.Add("@VoiceRemark1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.remark1);
cmd.Parameters.Add("@VoiceMaterial2", SqlDbType.NVarChar).Value = StructData.material2.ToString();
cmd.Parameters.Add("@VoiceWear2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.voice2);
cmd.Parameters.Add("@VoiceState2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.state2);
cmd.Parameters.Add("@VoiceVolume2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.volume2);
cmd.Parameters.Add("@VoiceResult2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result2);
cmd.Parameters.Add("@VoiceRemark2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.remark2);
cmd.Parameters.Add("@VoiceItem3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3);
cmd.Parameters.Add("@VoiceMaterial3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material3);
cmd.Parameters.Add("@VoiceWear3", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.voice3);
cmd.Parameters.Add("@VoiceState3", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.state3);
cmd.Parameters.Add("@VoiceVolume3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.volume3);
cmd.Parameters.Add("@VoiceResult3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result3);
cmd.Parameters.Add("@VoiceRemark3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.remark3);
cmd.Parameters.Add("@VoiceItem4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4);
cmd.Parameters.Add("@VoiceMaterial4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material4);
cmd.Parameters.Add("@VoiceWear4", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.voice4);
cmd.Parameters.Add("@VoiceState4", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.state4);
cmd.Parameters.Add("@VoiceVolume4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.volume4);
cmd.Parameters.Add("@VoiceResult4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result4);
cmd.Parameters.Add("@VoiceRemark4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.remark4);
cmd.Parameters.Add("@VoicePurpose", SqlDbType.TinyInt).Value = StructData.checkPurpose;
cmd.Parameters.Add("@VoicePurposeExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkPurposeText);
cmd.Parameters.Add("@VoiceExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.explain);
cmd.Parameters.Add("@CreateFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]);
cmd.Parameters.Add("@UpFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]);
returnValue[0] = cmd.ExecuteNonQuery().ToString();
if (returnValue[0] != "0")
{
sql = "select IDENT_CURRENT('HearingInspection') AS cID";
cmd = new SqlCommand(sql, Sqlconn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
returnValue[1] = dr["cID"].ToString();
}
dr.Close();
StudentDataBasic DateItem = new StudentDataBasic();
DateItem.studentID = StructData.studentID;
DateItem.assistmanageR = StructData.assistmanageR;
DateItem.brandR = StructData.brandR;
DateItem.modelR = StructData.modelR;
DateItem.buyingPlaceR = StructData.buyingPlaceR;
DateItem.buyingtimeR = StructData.buyingtimeR;
DateItem.insertHospitalR = StructData.insertHospitalR;
DateItem.openHzDateR = StructData.openHzDateR;
DateItem.assistmanageL = StructData.assistmanageL;
DateItem.brandL = StructData.brandL;
DateItem.modelL = StructData.modelL;
DateItem.buyingtimeL = StructData.buyingtimeL;
DateItem.buyingPlaceL = StructData.buyingPlaceL;
DateItem.insertHospitalL = StructData.insertHospitalL;
DateItem.openHzDateL = StructData.openHzDateL;
this.ComparisonAidsData(DateItem);
CreateStudentAidsUse AidsUse = new CreateStudentAidsUse();
AidsUse.assessDate = StructData.checkDate;
AidsUse.studentID = StructData.studentID;
AidsUse.assistmanageR = StructData.assistmanageR;
AidsUse.brandR = StructData.brandR;
AidsUse.modelR = StructData.modelR;
AidsUse.buyingPlaceR = StructData.buyingPlaceR;
AidsUse.buyingtimeR = StructData.buyingtimeR;
AidsUse.insertHospitalR = StructData.insertHospitalR;
AidsUse.openHzDateR = StructData.openHzDateR;
AidsUse.assistmanageL = StructData.assistmanageL;
AidsUse.brandL = StructData.brandL;
AidsUse.modelL = StructData.modelL;
AidsUse.buyingtimeL = StructData.buyingtimeL;
AidsUse.buyingPlaceL = StructData.buyingPlaceL;
AidsUse.insertHospitalL = StructData.insertHospitalL;
AidsUse.openHzDateL = StructData.openHzDateL;
createStudentAidsUse(AidsUse);
}
Sqlconn.Close();
}
catch (Exception e)
{
returnValue[0] = "-1";
returnValue[1] = e.Message.ToString();
}
}
return returnValue;
}
public string[] setStudentAidsUse(CreateStudentAidsUse StudentData)
{
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 HearingCaseAidsUseRecord SET HearingAids_R=@HearingAids_R, AidsBrand_R=@AidsBrand_R, AidsModel_R=@AidsModel_R, " +
"AidsOptionalTime_R=@AidsOptionalTime_R, AidsOptionalLocation_R=@AidsOptionalLocation_R, EEarHospital_R=@EEarHospital_R, EEarOpen_R=@EEarOpen_R, " +
"AidsSource_R=@AidsSource_R, AidsSourceText_R=@AidsSourceText_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, " +
"AidsSource_L=@AidsSource_L, AidsSourceText_L=@AidsSourceText_L, AcquisitionDate=@AcquisitionDate, " +
"FMSourceAids=@FMSourceAids, FMTypeAids=@FMTypeAids, FMAidsBrand=@FMAidsBrand, FMAidsModel=@FMAidsModel, FMAidsChannel=@FMAidsChannel, " +
"FMAidsModelR=@FMAidsModelR, FMAidsDPAIR=@FMAidsDPAIR, FMAidsProgramR=@FMAidsProgramR, FMAudioProportionR=@FMAudioProportionR, FMAidsUIR=@FMAidsUIR, " +
"FMAidsUITextR=@FMAidsUITextR, FMAidsReceptorR=@FMAidsReceptorR, FMAidsReceptorVolumeR=@FMAidsReceptorVolumeR, FMAidsGainR=@FMAidsGainR, " +
"FMAidsModelL=@FMAidsModelL, FMAidsDPAIL=@FMAidsDPAIL, FMAidsProgramL=@FMAidsProgramL, FMAudioProportionL=@FMAudioProportionL, FMAidsUIL=@FMAidsUIL, " +
"FMAidsUITextL=@FMAidsUITextL, FMAidsReceptorL=@FMAidsReceptorL, FMAidsReceptorVolumeL=@FMAidsReceptorVolumeL, FMAidsGainL=@FMAidsGainL, " +
"UpFileBy=@UpFileBy, UpFileDate=(getDate()) ,assessDate=@assessDate " +
"WHERE ID=@ID";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@AssessDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentData.assessDate);
cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value = Chk.CheckStringtoInt64Function(StudentData.ID);
cmd.Parameters.Add("@HearingAids_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.assistmanageR);
cmd.Parameters.Add("@AidsBrand_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.brandR);
cmd.Parameters.Add("@AidsModel_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.modelR);
cmd.Parameters.Add("@AidsOptionalTime_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentData.buyingtimeR);
cmd.Parameters.Add("@AidsOptionalLocation_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.buyingPlaceR);
cmd.Parameters.Add("@EEarHospital_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.insertHospitalR);
cmd.Parameters.Add("@EEarOpen_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentData.openHzDateR);
cmd.Parameters.Add("@AidsSource_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.sourceR);
cmd.Parameters.Add("@AidsSourceText_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.sourceTextR);
cmd.Parameters.Add("@HearingAids_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.assistmanageL);
cmd.Parameters.Add("@AidsBrand_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.brandL);
cmd.Parameters.Add("@AidsModel_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.modelL);
cmd.Parameters.Add("@AidsOptionalTime_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.buyingtimeL);
cmd.Parameters.Add("@AidsOptionalLocation_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.buyingPlaceL);
cmd.Parameters.Add("@EEarHospital_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.insertHospitalL);
cmd.Parameters.Add("@EEarOpen_L", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentData.openHzDateL);
cmd.Parameters.Add("@AidsSource_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.sourceL);
cmd.Parameters.Add("@AidsSourceText_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.sourceTextL);
cmd.Parameters.Add("@AcquisitionDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentData.gainDate);
cmd.Parameters.Add("@FMSourceAids", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fmAidssource);
cmd.Parameters.Add("@FMTypeAids", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fmAidstype);
cmd.Parameters.Add("@FMAidsBrand", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmBrand);
cmd.Parameters.Add("@FMAidsModel", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmModel);
cmd.Parameters.Add("@FMAidsChannel", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmChannel);
cmd.Parameters.Add("@FMAidsModelR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmAidstypeR);
cmd.Parameters.Add("@FMAidsDPAIR", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.DPAIsettingR);
cmd.Parameters.Add("@FMAidsProgramR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmProgramR);
cmd.Parameters.Add("@FMAudioProportionR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmAudioR);
cmd.Parameters.Add("@FMAidsUIR", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fmUIR);
cmd.Parameters.Add("@FMAidsUITextR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmUITextR);
cmd.Parameters.Add("@FMAidsReceptorR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmReceptorR);
cmd.Parameters.Add("@FMAidsReceptorVolumeR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmVolumeR);
cmd.Parameters.Add("@FMAidsGainR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmGainR);
cmd.Parameters.Add("@FMAidsModelL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmAidstypeL);
cmd.Parameters.Add("@FMAidsDPAIL", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.DPAIsettingL);
cmd.Parameters.Add("@FMAidsProgramL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmProgramL);
cmd.Parameters.Add("@FMAudioProportionL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmAudioL);
cmd.Parameters.Add("@FMAidsUIL", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentData.fmUIL);
cmd.Parameters.Add("@FMAidsUITextL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmUITextL);
cmd.Parameters.Add("@FMAidsReceptorL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmReceptorL);
cmd.Parameters.Add("@FMAidsReceptorVolumeL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmVolumeL);
cmd.Parameters.Add("@FMAidsGainL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentData.fmGainL);
cmd.Parameters.Add("@UpFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]);
returnValue[0] = cmd.ExecuteNonQuery().ToString();
Sqlconn.Close();
}
catch (Exception e)
{
returnValue[0] = "-1";
returnValue[1] = e.Message.ToString();
}
}
return returnValue;
}
public string[] setHearingInspectionData(CreateHearingInspection StructData)
{
string[] returnValue = new string[2];
returnValue[0] = "0";
returnValue[1] = "";
string PicUpdatestring = "";
if (StructData.hearingtoneImg != null) {
PicUpdatestring = "PureToneImg=@PureToneImg, ";
}
DataBase Base = new DataBase();
using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
{
try
{
StaffDataBase sDB = new StaffDataBase();
List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name);
Sqlconn.Open();
string sql = "UPDATE HearingInspection SET CheckDate=@CheckDate, StudentID=@StudentID, CheckType=@CheckType, Credibility=@Credibility, "+PicUpdatestring+
"HearingAids_R=@HearingAids_R, AidsBrand_R=@AidsBrand_R, AidsModel_R=@AidsModel_R, AidsOptionalTime_R=@AidsOptionalTime_R, " +
"AidsOptionalLocation_R=@AidsOptionalLocation_R, EEarHospital_R=@EEarHospital_R,EEarOpen_R=@EEarOpen_R, " +
"HearingAids_L=@HearingAids_L, AidsBrand_L=@AidsBrand_L, AidsModel_L=@AidsModel_L, AidsOptionalTime_L=@AidsOptionalTime_L, "+
"AidsOptionalLocation_L=@AidsOptionalLocation_L, EEarHospital_L=@EEarHospital_L, EEarOpen_L=@EEarOpen_L, ListenCheck=@ListenCheck, "+
"Earphones=@Earphones, NakedEar=@NakedEar, HearingAfter=@HearingAfter, PrueRDecibel=@PrueRDecibel, PrueLDecibel=@PrueLDecibel, "+
"EarEndoscopyRight=@EarEndoscopyRight, EarEndoscopyRExplain=@EarEndoscopyRExplain, EarEndoscopyLeft=@EarEndoscopyLeft, "+
"EarEndoscopyLExplain=@EarEndoscopyLExplain, TympanicCavity=@TympanicCavity, PatternRight=@PatternRight, PatternLeft=@PatternLeft, "+
"CanalRight=@CanalRight, CanalLeft=@CanalLeft, EardrumRight=@EardrumRight, EardrumLeft=@EardrumLeft, PressureRight=@PressureRight, "+
"PressureLeft=@PressureLeft, AidsDetectRight1=@AidsDetectRight1, AidsDetectRight2=@AidsDetectRight2, AidsDetectLeft1=@AidsDetectLeft1, "+
"AidsDetectLeft2=@AidsDetectLeft2, AidsDetect=@AidsDetect, VoiceMaterial1=@VoiceMaterial1, VoiceWear1=@VoiceWear1, VoiceState1=@VoiceState1, "+
"VoiceVolume1=@VoiceVolume1, VoiceResult1=@VoiceResult1, VoiceRemark1=@VoiceRemark1, VoiceMaterial2=@VoiceMaterial2, VoiceWear2=@VoiceWear2, "+
"VoiceState2=@VoiceState2, VoiceVolume2=@VoiceVolume2, VoiceResult2=@VoiceResult2, VoiceRemark2=@VoiceRemark2, VoiceItem3=@VoiceItem3, "+
"VoiceMaterial3=@VoiceMaterial3, VoiceWear3=@VoiceWear3, VoiceState3=@VoiceState3, VoiceVolume3=@VoiceVolume3, VoiceResult3=@VoiceResult3, "+
"VoiceRemark3=@VoiceRemark3, VoiceItem4=@VoiceItem4, VoiceMaterial4=@VoiceMaterial4, VoiceWear4=@VoiceWear4, VoiceState4=@VoiceState4, "+
"VoiceVolume4=@VoiceVolume4, VoiceResult4=@VoiceResult4, VoiceRemark4=@VoiceRemark4, VoicePurpose=@VoicePurpose, VoicePurposeExplain=@VoicePurposeExplain, "+
"VoiceExplain=@VoiceExplain, UpFileBy= @UpFileBy,SATVolumeBefore=@SATVolumeBefore,material1=@material1,SATVolumeAfter=@SATVolumeAfter , "+
"SATREarAfter=@SATREarAfter, SATLEarAfter=@SATLEarAfter, SATEarAfter=@SATEarAfter,"+
"SATREarBefore=@SATREarBefore, SATLEarBefore=@SATLEarBefore, SATEarBefore=@SATEarBefore, WRSVolumeBefore=@WRSVolumeBefore, "+
"WRSREarBefore=@WRSREarBefore, WRSLEarBefore=@WRSLEarBefore, WRSEarBefore=@WRSEarBefore, WRSVolumeAfter=@WRSVolumeAfter, "+
"WRSREarAfter=@WRSREarAfter, WRSLEarAfter=@WRSLEarAfter, WRSEarAfter=@WRSEarAfter, project3=@project3,material3=@material3 , "+
"material2=@material2, project3VolumeBefore=@project3VolumeBefore, project3REarBefore=@project3REarBefore, "+
"project3LEarBefore=@project3LEarBefore, project3EarBefore=@project3EarBefore,project3VolumeAfter=@project3VolumeAfter, "+
"project3REarAfter=@project3REarAfter, project3LEarAfter=@project3LEarAfter, project3EarAfter=@project3EarAfter, "+
"project4=@project4, material4=@material4, project4VolumeBefore=@project4VolumeBefore, "+
"project4REarBefore=@project4REarBefore, project4LEarBefore=@project4LEarBefore, project4EarBefore=@project4EarBefore, "+
"project4VolumeAfter=@project4VolumeAfter, project4REarAfter=@project4REarAfter, "+
"project4EarAfter=@project4EarAfter, project4LEarAfter=@project4LEarAfter, "+
"checkPurpose=@checkPurpose, explain=@explain, UpFileDate=(getDate()) WHERE ID=@ID";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.ID);
cmd.Parameters.Add("@CheckDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.checkDate);
cmd.Parameters.Add("@StudentID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.studentID);
cmd.Parameters.Add("@CheckType", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkMode);
cmd.Parameters.Add("@Credibility", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.credibility);
cmd.Parameters.Add("@HearingAids_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.assistmanageR);
cmd.Parameters.Add("@AidsBrand_R", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.brandR);
cmd.Parameters.Add("@AidsModel_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.modelR);
cmd.Parameters.Add("@AidsOptionalTime_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.buyingtimeR);
cmd.Parameters.Add("@AidsOptionalLocation_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.buyingPlaceR);
cmd.Parameters.Add("@EEarHospital_R", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.insertHospitalR);
cmd.Parameters.Add("@EEarOpen_R", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.openHzDateR);
cmd.Parameters.Add("@HearingAids_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.assistmanageL);
cmd.Parameters.Add("@AidsBrand_L", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.brandL);
cmd.Parameters.Add("@AidsModel_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.modelL);
cmd.Parameters.Add("@AidsOptionalTime_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.buyingtimeL);
cmd.Parameters.Add("@AidsOptionalLocation_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.buyingPlaceL);
cmd.Parameters.Add("@EEarHospital_L", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.insertHospitalL);
cmd.Parameters.Add("@EEarOpen_L", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.openHzDateL);
cmd.Parameters.Add("@ListenCheck", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkInstrument);
cmd.Parameters.Add("@Earphones", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.headphone);
cmd.Parameters.Add("@NakedEar", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.nudetonety);
cmd.Parameters.Add("@HearingAfter", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.hearingtone);
cmd.Parameters.Add("@PureToneImg", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingtoneImg);
cmd.Parameters.Add("@PrueRDecibel", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.toneR);
cmd.Parameters.Add("@PrueLDecibel", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.toneL);
cmd.Parameters.Add("@EarEndoscopyRight", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.hearingtoneR);
cmd.Parameters.Add("@EarEndoscopyRExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingtoneRText);
cmd.Parameters.Add("@EarEndoscopyLeft", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.hearingtoneL);
cmd.Parameters.Add("@EarEndoscopyLExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingtoneLText);
cmd.Parameters.Add("@TympanicCavity", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingInstrument);
cmd.Parameters.Add("@PatternRight", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingImgR);
cmd.Parameters.Add("@PatternLeft", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingImgL);
cmd.Parameters.Add("@CanalRight", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingVolumeR);
cmd.Parameters.Add("@CanalLeft", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.hearingVolumeL);
cmd.Parameters.Add("@EardrumRight", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.conformR);
cmd.Parameters.Add("@EardrumLeft", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.conformL);
cmd.Parameters.Add("@PressureRight", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.pressureR);
cmd.Parameters.Add("@PressureLeft", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.pressureL);
cmd.Parameters.Add("@AidsDetectRight1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.aidsR);
cmd.Parameters.Add("@AidsDetectRight2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.aidsdetectR);
cmd.Parameters.Add("@AidsDetectLeft1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.aidsL);
cmd.Parameters.Add("@AidsDetectLeft2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.aidsdetectL);
cmd.Parameters.Add("@AidsDetect", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.aidsOther);
cmd.Parameters.Add("@VoiceMaterial1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material1);
cmd.Parameters.Add("@VoiceWear1", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.voice1);
cmd.Parameters.Add("@VoiceState1", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.state1);
cmd.Parameters.Add("@VoiceVolume1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.volume1);
cmd.Parameters.Add("@VoiceResult1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result1);
cmd.Parameters.Add("@VoiceRemark1", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.remark1);
cmd.Parameters.Add("@VoiceMaterial2", SqlDbType.NVarChar).Value = StructData.material2;
cmd.Parameters.Add("@VoiceWear2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.voice2);
cmd.Parameters.Add("@VoiceState2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.state2);
cmd.Parameters.Add("@VoiceVolume2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.volume2);
cmd.Parameters.Add("@VoiceResult2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result2);
cmd.Parameters.Add("@VoiceRemark2", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.remark2);
cmd.Parameters.Add("@project3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3);
cmd.Parameters.Add("@VoiceMaterial3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material3);
cmd.Parameters.Add("@VoiceWear3", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.voice3);
cmd.Parameters.Add("@VoiceState3", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.state3);
cmd.Parameters.Add("@VoiceVolume3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.volume3);
cmd.Parameters.Add("@VoiceResult3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result3);
cmd.Parameters.Add("@VoiceRemark3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.remark3);
cmd.Parameters.Add("@VoiceItem3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.VoiceItem3);
cmd.Parameters.Add("@VoiceItem4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.VoiceItem4);
cmd.Parameters.Add("@VoiceMaterial4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material4);
cmd.Parameters.Add("@VoiceWear4", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.voice4);
cmd.Parameters.Add("@VoiceState4", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.state4);
cmd.Parameters.Add("@VoiceVolume4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.volume4);
cmd.Parameters.Add("@VoiceResult4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result4);
cmd.Parameters.Add("@VoiceRemark4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.remark4);
cmd.Parameters.Add("@VoicePurpose", SqlDbType.TinyInt).Value = StructData.checkPurpose;
cmd.Parameters.Add("@VoicePurposeExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkPurposeText);
cmd.Parameters.Add("@VoiceExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.explain);
cmd.Parameters.Add("@CreateFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]);
cmd.Parameters.Add("@UpFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]);
cmd.Parameters.Add("@material1 ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material1);
cmd.Parameters.Add("@SATVolumeBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATVolumeBefore);
cmd.Parameters.Add("@SATREarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATREarBefore);
cmd.Parameters.Add("@SATLEarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATLEarBefore);
cmd.Parameters.Add("@SATEarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATEarBefore);
cmd.Parameters.Add("@SATVolumeAfter ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATVolumeAfter);
cmd.Parameters.Add("@SATREarAfter ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATREarAfter);
cmd.Parameters.Add("@SATLEarAfter ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATLEarAfter);
cmd.Parameters.Add("@SATEarAfter ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.SATEarAfter);
cmd.Parameters.Add("@WRSVolumeBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSVolumeBefore);
cmd.Parameters.Add("@WRSREarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSREarBefore);
cmd.Parameters.Add("@WRSLEarBefore ", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSLEarBefore);
cmd.Parameters.Add("@WRSEarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSEarBefore);
cmd.Parameters.Add("@WRSVolumeAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSVolumeAfter);
cmd.Parameters.Add("@WRSREarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSREarAfter);
cmd.Parameters.Add("@WRSLEarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSLEarAfter);
cmd.Parameters.Add("@WRSEarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.WRSEarAfter);
cmd.Parameters.Add("@material3", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material3);
cmd.Parameters.Add("@material2", SqlDbType.TinyInt).Value = StructData.material2;
cmd.Parameters.Add("@project3VolumeBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3VolumeBefore);
cmd.Parameters.Add("@project3REarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3REarBefore);
cmd.Parameters.Add("@project3LEarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3LEarBefore);
cmd.Parameters.Add("@project3EarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3EarBefore);
cmd.Parameters.Add("@project3VolumeAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3VolumeAfter);
cmd.Parameters.Add("@project3REarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3REarAfter);
cmd.Parameters.Add("@project3LEarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3LEarAfter);
cmd.Parameters.Add("@project3EarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project3EarAfter);
cmd.Parameters.Add("@project4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4);
cmd.Parameters.Add("@material4", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material4);
cmd.Parameters.Add("@project4VolumeBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4VolumeBefore);
cmd.Parameters.Add("@project4REarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4REarBefore);
cmd.Parameters.Add("@project4LEarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4LEarBefore);
cmd.Parameters.Add("@project4EarBefore", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4EarBefore);
cmd.Parameters.Add("@project4VolumeAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4VolumeAfter);
cmd.Parameters.Add("@project4REarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4REarAfter);
cmd.Parameters.Add("@project4LEarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4LEarAfter);
cmd.Parameters.Add("@project4EarAfter", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project4EarAfter);
cmd.Parameters.Add("@checkPurposeText", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.checkPurposeText);
cmd.Parameters.Add("@checkPurpose", SqlDbType.TinyInt).Value = StructData.checkPurpose;
cmd.Parameters.Add("@explain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.explain);
returnValue[0] = cmd.ExecuteNonQuery().ToString();
if (returnValue[0] == "1")
{
StudentDataBasic DateItem = new StudentDataBasic();
//DateItem.ID = StructData.ID;
DateItem.studentID = StructData.studentID;
DateItem.assistmanageR = StructData.assistmanageR;
DateItem.brandR = StructData.brandR;
DateItem.modelR = StructData.modelR;
DateItem.buyingPlaceR = StructData.buyingPlaceR;
DateItem.buyingtimeR = StructData.buyingtimeR;
DateItem.insertHospitalR = StructData.insertHospitalR;
DateItem.openHzDateR = StructData.openHzDateR;
DateItem.assistmanageL = StructData.assistmanageL;
DateItem.brandL = StructData.brandL;
DateItem.modelL = StructData.modelL;
DateItem.buyingtimeL = StructData.buyingtimeL;
DateItem.buyingPlaceL = StructData.buyingPlaceL;
DateItem.insertHospitalL = StructData.insertHospitalL;
DateItem.openHzDateL = StructData.openHzDateL;
this.ComparisonAidsData(DateItem);
CreateStudentAidsUse AidsUse = new CreateStudentAidsUse();
AidsUse.assessDate = StructData.checkDate;
AidsUse.studentID = StructData.studentID;
AidsUse.assistmanageR = StructData.assistmanageR;
AidsUse.brandR = StructData.brandR;
AidsUse.modelR = StructData.modelR;
AidsUse.buyingPlaceR = StructData.buyingPlaceR;
AidsUse.buyingtimeR = StructData.buyingtimeR;
AidsUse.insertHospitalR = StructData.insertHospitalR;
AidsUse.openHzDateR = StructData.openHzDateR;
AidsUse.assistmanageL = StructData.assistmanageL;
AidsUse.brandL = StructData.brandL;
AidsUse.modelL = StructData.modelL;
AidsUse.buyingtimeL = StructData.buyingtimeL;
AidsUse.buyingPlaceL = StructData.buyingPlaceL;
AidsUse.insertHospitalL = StructData.insertHospitalL;
AidsUse.openHzDateL = StructData.openHzDateL;
createStudentAidsUse(AidsUse);
}
}
catch (Exception e)
{
returnValue[0] = "-1";
returnValue[1] = e.Message.ToString();
}
}
return returnValue;
}
public string[] ComparisonFMAidsData(CreateFMAidsAssess DateItem)
{
string[] returnValue = new string[2];
try
{
CreateStudentAidsUse FMNewData = this.getStudentFMUseNew(DateItem.studentID);
if (DateItem.fmChannel != FMNewData.fmChannel || DateItem.fmAidstypeR != FMNewData.fmAidstypeR || DateItem.DPAIsettingR != FMNewData.DPAIsettingR || DateItem.fmProgramR != FMNewData.fmProgramR || DateItem.fmAudioR != FMNewData.fmAudioR || DateItem.fmUIR != FMNewData.fmUIR || DateItem.fmUITextR != FMNewData.fmUITextR || DateItem.fmReceptorR != FMNewData.fmReceptorR || DateItem.fmVolumeR != FMNewData.fmVolumeR || DateItem.fmAidstypeL != FMNewData.fmAidstypeL || DateItem.DPAIsettingL != FMNewData.DPAIsettingL || DateItem.fmProgramL != FMNewData.fmProgramL || DateItem.fmAudioL != FMNewData.fmAudioL || DateItem.fmUIL != FMNewData.fmUIL || DateItem.fmUITextL != FMNewData.fmUITextL || DateItem.fmReceptorL != FMNewData.fmReceptorL || DateItem.fmVolumeL != FMNewData.fmVolumeL)
{
CreateStudentAidsUse AidsUseData = new CreateStudentAidsUse();
AidsUseData.studentID = DateItem.studentID;
AidsUseData.fmChannel=DateItem.fmChannel;
AidsUseData.fmAidstypeR=DateItem.fmAidstypeR;
AidsUseData.DPAIsettingR=DateItem.DPAIsettingR;
AidsUseData.fmProgramR=DateItem.fmProgramR;
AidsUseData.fmAudioR=DateItem.fmAudioR;
AidsUseData.fmUIR=DateItem.fmUIR;
AidsUseData.fmUITextR=DateItem.fmUITextR;
AidsUseData.fmReceptorR=DateItem.fmReceptorR;
AidsUseData.fmVolumeR=DateItem.fmVolumeR;
AidsUseData.fmAidstypeL=DateItem.fmAidstypeL;
AidsUseData.DPAIsettingL=DateItem.DPAIsettingL;
AidsUseData.fmProgramL=DateItem.fmProgramL;
AidsUseData.fmAudioL=DateItem.fmAudioL;
AidsUseData.fmUIL=DateItem.fmUIL;
AidsUseData.fmUITextL=DateItem.fmUITextL;
AidsUseData.fmReceptorL=DateItem.fmReceptorL;
AidsUseData.fmVolumeL=DateItem.fmVolumeL;
AidsUseData.assessDate = DateItem.assessDate;
AidsUseData.fmAidssource = DateItem.aSource;
AidsUseData.fmModel = DateItem.fmModel;
string[] item = this.createStudentAidsUse(AidsUseData);
}
}
catch (Exception e)
{
returnValue[0] = "-1";
returnValue[1] = e.Message.ToString();
}
return returnValue;
}
public string[] setStudentAidsUseData(CreateStudentAidsUse StudentData)
{
Audiometry aDB = new Audiometry();
if (int.Parse(aDB._StaffhaveRoles[1]) == 1)
{
return aDB.setStudentAidsUse(StudentData);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public CreateStudentAidsUse getStudentAidsUseDataBase(string ID)
{
Audiometry aDB = new Audiometry();
CreateStudentAidsUse returnValue = new CreateStudentAidsUse();
if (int.Parse(aDB._StaffhaveRoles[3]) == 1)
{
returnValue= aDB.getStudentAidsUse(ID);
}
else
{
returnValue.checkNo = _noRole;
returnValue.errorMsg = _errorMsg;
}
return returnValue;
}
