public string[] createFmAssessmentData(CreateFMAidsAssess 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 FMAidsAssess (Unit, StudentID, Audiologist, AssessDate, AidsSource, AidsSourceExplain, " +
"TransmitterType, Channel, FMAidsModelR, FMAidsDPAIR, FMAidsProgramR, FMAudioProportionR, FMAidsUIR, FMAidsUITextR, " +
"FMAidsReceptorR, FMAidsReceptorVolumeR, FMAidsModelL, FMAidsDPAIL, FMAidsProgramL, FMAudioProportionL, " +
"FMAidsUIL, FMAidsUITextL, FMAidsReceptorL, FMAidsReceptorVolumeL, FML1_750hz, FML1_1khz, FML1_2khz, FML1_Average, " +
"FMR1_750hz, FMR1_1khz, FMR1_2khz, FMR1_Average, FML2_750hz, FML2_1khz, FML2_2khz, FML2_Average, FMR2_750hz, FMR2_1khz, " +
"FMR2_2khz, FMR2_Average, FML3_750hz, FML3_1khz, FML3_2khz, FML3_Average, FMR3_750hz, FMR3_1khz, FMR3_2khz, FMR3_Average, " +
"FML4_750hz, FML4_1khz, FML4_2khz, FML4_Average, FMR4_750hz, FMR4_1khz, FMR4_2khz, FMR4_Average, FML5_750hz, FML5_1khz, " +
"FML5_2khz, FML5_Average, FMR5_750hz, FMR5_1khz, FMR5_2khz, FMR5_Average, FML6_750hz, FMR6_750hz, FML6_1khz, FMR6_1khz, " +
"FML6_2khz, FMR6_2khz, FML6_Average, FMR6_Average, FMExplain, VoiceValue1, VoiceItem1TrueL1, VoiceItem1TrueL2, " +
"VoiceItem1TrueL3, VoiceItem1TrueR1, VoiceItem1TrueR2, VoiceItem1TrueR3, VoiceItem1TrueD1, VoiceItem1TrueD2, " +
"VoiceItem1TrueD3, VoiceValue2, VoiceItem2TrueL1, VoiceItem2TrueL2, VoiceItem2TrueL3, VoiceItem2TrueR1, VoiceItem2TrueR2, " +
"VoiceItem2TrueR3, VoiceItem2TrueD1, VoiceItem2TrueD2, VoiceItem2TrueD3, VoiceExplain, CreateFileBy, UpFileBy, UpFileDate) " +
"VALUES(@Unit, @StudentID, @Audiologist, @AssessDate, @AidsSource, @AidsSourceExplain, @TransmitterType, @Channel, " +
"@FMAidsModelR, @FMAidsDPAIR, @FMAidsProgramR, @FMAudioProportionR, @FMAidsUIR, @FMAidsUITextR, @FMAidsReceptorR, " +
"@FMAidsReceptorVolumeR, @FMAidsModelL, @FMAidsDPAIL, @FMAidsProgramL, @FMAudioProportionL, @FMAidsUIL, @FMAidsUITextL, " +
"@FMAidsReceptorL, @FMAidsReceptorVolumeL, @FML1_750hz, @FML1_1khz, @FML1_2khz, @FML1_Average, @FMR1_750hz, " +
"@FMR1_1khz, @FMR1_2khz, @FMR1_Average, @FML2_750hz, @FML2_1khz, @FML2_2khz, @FML2_Average, @FMR2_750hz, @FMR2_1khz, " +
"@FMR2_2khz, @FMR2_Average, @FML3_750hz, @FML3_1khz, @FML3_2khz, @FML3_Average, @FMR3_750hz, @FMR3_1khz, @FMR3_2khz, " +
"@FMR3_Average, @FML4_750hz, @FML4_1khz, @FML4_2khz, @FML4_Average, @FMR4_750hz, @FMR4_1khz, @FMR4_2khz, @FMR4_Average, " +
"@FML5_750hz, @FML5_1khz, @FML5_2khz, @FML5_Average, @FMR5_750hz, @FMR5_1khz, @FMR5_2khz, @FMR5_Average, @FML6_750hz, " +
"@FMR6_750hz, @FML6_1khz, @FMR6_1khz, @FML6_2khz, @FMR6_2khz, @FML6_Average, @FMR6_Average, @FMExplain, @VoiceValue1, " +
"@VoiceItem1TrueL1, @VoiceItem1TrueL2, @VoiceItem1TrueL3, @VoiceItem1TrueR1, @VoiceItem1TrueR2, @VoiceItem1TrueR3, " +
"@VoiceItem1TrueD1, @VoiceItem1TrueD2, @VoiceItem1TrueD3, @VoiceValue2, @VoiceItem2TrueL1, @VoiceItem2TrueL2, " +
"@VoiceItem2TrueL3, @VoiceItem2TrueR1, @VoiceItem2TrueR2, @VoiceItem2TrueR3, @VoiceItem2TrueD1, @VoiceItem2TrueD2, " +
"@VoiceItem2TrueD3, @VoiceExplain, @CreateFileBy, @UpFileBy, (getDate()))";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@Unit", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[2].ToString());
cmd.Parameters.Add("@StudentID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.studentID);
cmd.Parameters.Add("@Audiologist", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]);
cmd.Parameters.Add("@AssessDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StructData.assessDate);
cmd.Parameters.Add("@AidsSource", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.aSource);
cmd.Parameters.Add("@AidsSourceExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.aSourceText);
cmd.Parameters.Add("@TransmitterType", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmModel);
cmd.Parameters.Add("@Channel", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmChannel);
cmd.Parameters.Add("@FMAidsModelR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmAidstypeR);
cmd.Parameters.Add("@FMAidsDPAIR", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.DPAIsettingR);
cmd.Parameters.Add("@FMAidsProgramR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmProgramR);
cmd.Parameters.Add("@FMAudioProportionR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmAudioR);
cmd.Parameters.Add("@FMAidsUIR", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.fmUIR);
cmd.Parameters.Add("@FMAidsUITextR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmUITextR);
cmd.Parameters.Add("@FMAidsReceptorR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmReceptorR);
cmd.Parameters.Add("@FMAidsReceptorVolumeR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmVolumeR);
cmd.Parameters.Add("@FMAidsModelL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmAidstypeL);
cmd.Parameters.Add("@FMAidsDPAIL", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.DPAIsettingL);
cmd.Parameters.Add("@FMAidsProgramL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmProgramL);
cmd.Parameters.Add("@FMAudioProportionL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmAudioL);
cmd.Parameters.Add("@FMAidsUIL", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.fmUIL);
cmd.Parameters.Add("@FMAidsUITextL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmUITextL);
cmd.Parameters.Add("@FMAidsReceptorL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmReceptorL);
cmd.Parameters.Add("@FMAidsReceptorVolumeL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmVolumeL);
cmd.Parameters.Add("@FML1_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm1L_1);
cmd.Parameters.Add("@FML1_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm1L_2);
cmd.Parameters.Add("@FML1_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm1L_3);
cmd.Parameters.Add("@FML1_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm1L_4);
cmd.Parameters.Add("@FMR1_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm1R_1);
cmd.Parameters.Add("@FMR1_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm1R_2);
cmd.Parameters.Add("@FMR1_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm1R_3);
cmd.Parameters.Add("@FMR1_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm1R_4);
cmd.Parameters.Add("@FML2_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm2L_1);
cmd.Parameters.Add("@FML2_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm2L_2);
cmd.Parameters.Add("@FML2_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm2L_3);
cmd.Parameters.Add("@FML2_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm2L_4);
cmd.Parameters.Add("@FMR2_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm2R_1);
cmd.Parameters.Add("@FMR2_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm2R_2);
cmd.Parameters.Add("@FMR2_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm2R_3);
cmd.Parameters.Add("@FMR2_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm2R_4);
cmd.Parameters.Add("@FML3_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm3L_1);
cmd.Parameters.Add("@FML3_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm3L_2);
cmd.Parameters.Add("@FML3_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm3L_3);
cmd.Parameters.Add("@FML3_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm3L_4);
cmd.Parameters.Add("@FMR3_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm3R_1);
cmd.Parameters.Add("@FMR3_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm3R_2);
cmd.Parameters.Add("@FMR3_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm3R_3);
cmd.Parameters.Add("@FMR3_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm3R_4);
cmd.Parameters.Add("@FML4_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm4L_1);
cmd.Parameters.Add("@FML4_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm4L_2);
cmd.Parameters.Add("@FML4_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm4L_3);
cmd.Parameters.Add("@FML4_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm4L_4);
cmd.Parameters.Add("@FMR4_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm4R_1);
cmd.Parameters.Add("@FMR4_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm4R_2);
cmd.Parameters.Add("@FMR4_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm4R_3);
cmd.Parameters.Add("@FMR4_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm4R_4);
cmd.Parameters.Add("@FML5_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm5L_1);
cmd.Parameters.Add("@FML5_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm5L_2);
cmd.Parameters.Add("@FML5_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm5L_3);
cmd.Parameters.Add("@FML5_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm5L_4);
cmd.Parameters.Add("@FMR5_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm5R_1);
cmd.Parameters.Add("@FMR5_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm5R_2);
cmd.Parameters.Add("@FMR5_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm5R_3);
cmd.Parameters.Add("@FMR5_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm5R_4);
cmd.Parameters.Add("@FML6_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm6L_1);
cmd.Parameters.Add("@FMR6_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm6L_2);
cmd.Parameters.Add("@FML6_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm6L_3);
cmd.Parameters.Add("@FMR6_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm6L_4);
cmd.Parameters.Add("@FML6_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm6R_1);
cmd.Parameters.Add("@FMR6_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm6R_2);
cmd.Parameters.Add("@FML6_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm6R_3);
cmd.Parameters.Add("@FMR6_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm6R_4);
cmd.Parameters.Add("@FMExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result);
cmd.Parameters.Add("@VoiceValue1", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.testmaterial);
cmd.Parameters.Add("@VoiceItem1TrueL1", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true1L_1);
cmd.Parameters.Add("@VoiceItem1TrueL2", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true1L_2);
cmd.Parameters.Add("@VoiceItem1TrueL3", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true1L_3);
cmd.Parameters.Add("@VoiceItem1TrueR1", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true1R_1);
cmd.Parameters.Add("@VoiceItem1TrueR2", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true1R_2);
cmd.Parameters.Add("@VoiceItem1TrueR3", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true1R_3);
cmd.Parameters.Add("@VoiceItem1TrueD1", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true1D_1);
cmd.Parameters.Add("@VoiceItem1TrueD2", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true1D_2);
cmd.Parameters.Add("@VoiceItem1TrueD3", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true1D_3);
cmd.Parameters.Add("@VoiceValue2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.testmaterial2);
cmd.Parameters.Add("@VoiceItem2TrueL1", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true2L_1);
cmd.Parameters.Add("@VoiceItem2TrueL2", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true2L_2);
cmd.Parameters.Add("@VoiceItem2TrueL3", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true2L_3);
cmd.Parameters.Add("@VoiceItem2TrueR1", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true2R_1);
cmd.Parameters.Add("@VoiceItem2TrueR2", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true2R_2);
cmd.Parameters.Add("@VoiceItem2TrueR3", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true2R_3);
cmd.Parameters.Add("@VoiceItem2TrueD1", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true2D_1);
cmd.Parameters.Add("@VoiceItem2TrueD2", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true2D_2);
cmd.Parameters.Add("@VoiceItem2TrueD3", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true2D_3);
cmd.Parameters.Add("@VoiceExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result2);
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('FMAidsAssess') AS cID";
cmd = new SqlCommand(sql, Sqlconn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
returnValue[1] = dr["cID"].ToString();
}
dr.Close();
this.ComparisonFMAidsData(StructData);
}
Sqlconn.Close();
}
catch (Exception e)
{
returnValue[0] = "-1";
returnValue[1] = e.Message.ToString();
}
}
return returnValue;
}
public string[] setFmAssessmentData(CreateFMAidsAssess 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 FMAidsAssess SET AidsSource = @AidsSource, AidsSourceExplain = @AidsSourceExplain, "+
"TransmitterType = @TransmitterType, Channel = @Channel, FMAidsModelR = @FMAidsModelR, FMAidsDPAIR = @FMAidsDPAIR, " +
"FMAidsProgramR = @FMAidsProgramR, FMAudioProportionR = @FMAudioProportionR, FMAidsUIR = @FMAidsUIR, " +
"FMAidsUITextR = @FMAidsUITextR, FMAidsReceptorR = @FMAidsReceptorR, FMAidsReceptorVolumeR = @FMAidsReceptorVolumeR, " +
"FMAidsModelL = @FMAidsModelL, FMAidsDPAIL = @FMAidsDPAIL, FMAidsProgramL = @FMAidsProgramL, " +
"FMAudioProportionL = @FMAudioProportionL, FMAidsUIL = @FMAidsUIL, FMAidsUITextL = @FMAidsUITextL, " +
"FMAidsReceptorL = @FMAidsReceptorL, FMAidsReceptorVolumeL = @FMAidsReceptorVolumeL, FML1_750hz = @FML1_750hz, " +
"FML1_1khz = @FML1_1khz, FML1_2khz = @FML1_2khz, FML1_Average = @FML1_Average, FMR1_750hz = @FMR1_750hz, " +
"FMR1_1khz = @FMR1_1khz, FMR1_2khz = @FMR1_2khz, FMR1_Average = @FMR1_Average, FML2_750hz = @FML2_750hz, " +
"FML2_1khz = @FML2_1khz, FML2_2khz = @FML2_2khz, FML2_Average = @FML2_Average, FMR2_750hz = @FMR2_750hz, " +
"FMR2_1khz = @FMR2_1khz, FMR2_2khz = @FMR2_2khz, FMR2_Average = @FMR2_Average, FML3_750hz = @FML3_750hz, " +
"FML3_1khz = @FML3_1khz, FML3_2khz = @FML3_2khz, FML3_Average = @FML3_Average, FMR3_750hz = @FMR3_750hz, " +
"FMR3_1khz = @FMR3_1khz, FMR3_2khz = @FMR3_2khz, FMR3_Average = @FMR3_Average, FML4_750hz = @FML4_750hz, " +
"FML4_1khz = @FML4_1khz, FML4_2khz = @FML4_2khz, FML4_Average = @FML4_Average, FMR4_750hz = @FMR4_750hz, " +
"FMR4_1khz = @FMR4_1khz, FMR4_2khz = @FMR4_2khz, FMR4_Average = @FMR4_Average, FML5_750hz = @FML5_750hz, " +
"FML5_1khz = @FML5_1khz, FML5_2khz = @FML5_2khz, FML5_Average = @FML5_Average, FMR5_750hz = @FMR5_750hz, " +
"FMR5_1khz = @FMR5_1khz, FMR5_2khz = @FMR5_2khz, FMR5_Average = @FMR5_Average, FML6_750hz = @FML6_750hz, " +
"FMR6_750hz = @FMR6_750hz, FML6_1khz = @FML6_1khz, FMR6_1khz = @FMR6_1khz, FML6_2khz = @FML6_2khz, FMR6_2khz = @FMR6_2khz, " +
"FML6_Average = @FML6_Average, FMR6_Average = @FMR6_Average, FMExplain = @FMExplain, VoiceValue1 = @VoiceValue1, " +
"VoiceItem1TrueL1 = @VoiceItem1TrueL1, VoiceItem1TrueL2 = @VoiceItem1TrueL2, VoiceItem1TrueL3 = @VoiceItem1TrueL3, " +
"VoiceItem1TrueR1 = @VoiceItem1TrueR1, VoiceItem1TrueR2 = @VoiceItem1TrueR2, VoiceItem1TrueR3 = @VoiceItem1TrueR3, " +
"VoiceItem1TrueD1 = @VoiceItem1TrueD1, VoiceItem1TrueD2 = @VoiceItem1TrueD2, VoiceItem1TrueD3 = @VoiceItem1TrueD3, " +
"VoiceValue2 = @VoiceValue2, VoiceItem2TrueL1 = @VoiceItem2TrueL1, VoiceItem2TrueL2 = @VoiceItem2TrueL2, " +
"VoiceItem2TrueL3 = @VoiceItem2TrueL3, VoiceItem2TrueR1 = @VoiceItem2TrueR1, VoiceItem2TrueR2 = @VoiceItem2TrueR2, " +
"VoiceItem2TrueR3 = @VoiceItem2TrueR3, VoiceItem2TrueD1 = @VoiceItem2TrueD1, VoiceItem2TrueD2 = @VoiceItem2TrueD2, " +
"VoiceItem2TrueD3 = @VoiceItem2TrueD3, VoiceExplain = @VoiceExplain, 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("@AidsSource", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.aSource);
cmd.Parameters.Add("@AidsSourceExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.aSourceText);
cmd.Parameters.Add("@TransmitterType", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmModel);
cmd.Parameters.Add("@Channel", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmChannel);
cmd.Parameters.Add("@FMAidsModelR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmAidstypeR);
cmd.Parameters.Add("@FMAidsDPAIR", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.DPAIsettingR);
cmd.Parameters.Add("@FMAidsProgramR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmProgramR);
cmd.Parameters.Add("@FMAudioProportionR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmAudioR);
cmd.Parameters.Add("@FMAidsUIR", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.fmUIR);
cmd.Parameters.Add("@FMAidsUITextR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmUITextR);
cmd.Parameters.Add("@FMAidsReceptorR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmReceptorR);
cmd.Parameters.Add("@FMAidsReceptorVolumeR", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmVolumeR);
cmd.Parameters.Add("@FMAidsModelL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmAidstypeL);
cmd.Parameters.Add("@FMAidsDPAIL", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.DPAIsettingL);
cmd.Parameters.Add("@FMAidsProgramL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmProgramL);
cmd.Parameters.Add("@FMAudioProportionL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmAudioL);
cmd.Parameters.Add("@FMAidsUIL", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.fmUIL);
cmd.Parameters.Add("@FMAidsUITextL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmUITextL);
cmd.Parameters.Add("@FMAidsReceptorL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmReceptorL);
cmd.Parameters.Add("@FMAidsReceptorVolumeL", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.fmVolumeL);
cmd.Parameters.Add("@FML1_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm1L_1);
cmd.Parameters.Add("@FML1_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm1L_2);
cmd.Parameters.Add("@FML1_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm1L_3);
cmd.Parameters.Add("@FML1_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm1L_4);
cmd.Parameters.Add("@FMR1_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm1R_1);
cmd.Parameters.Add("@FMR1_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm1R_2);
cmd.Parameters.Add("@FMR1_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm1R_3);
cmd.Parameters.Add("@FMR1_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm1R_4);
cmd.Parameters.Add("@FML2_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm2L_1);
cmd.Parameters.Add("@FML2_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm2L_2);
cmd.Parameters.Add("@FML2_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm2L_3);
cmd.Parameters.Add("@FML2_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm2L_4);
cmd.Parameters.Add("@FMR2_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm2R_1);
cmd.Parameters.Add("@FMR2_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm2R_2);
cmd.Parameters.Add("@FMR2_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm2R_3);
cmd.Parameters.Add("@FMR2_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm2R_4);
cmd.Parameters.Add("@FML3_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm3L_1);
cmd.Parameters.Add("@FML3_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm3L_2);
cmd.Parameters.Add("@FML3_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm3L_3);
cmd.Parameters.Add("@FML3_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm3L_4);
cmd.Parameters.Add("@FMR3_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm3R_1);
cmd.Parameters.Add("@FMR3_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm3R_2);
cmd.Parameters.Add("@FMR3_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm3R_3);
cmd.Parameters.Add("@FMR3_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm3R_4);
cmd.Parameters.Add("@FML4_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm4L_1);
cmd.Parameters.Add("@FML4_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm4L_2);
cmd.Parameters.Add("@FML4_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm4L_3);
cmd.Parameters.Add("@FML4_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm4L_4);
cmd.Parameters.Add("@FMR4_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm4R_1);
cmd.Parameters.Add("@FMR4_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm4R_2);
cmd.Parameters.Add("@FMR4_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm4R_3);
cmd.Parameters.Add("@FMR4_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm4R_4);
cmd.Parameters.Add("@FML5_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm5L_1);
cmd.Parameters.Add("@FML5_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm5L_2);
cmd.Parameters.Add("@FML5_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm5L_3);
cmd.Parameters.Add("@FML5_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm5L_4);
cmd.Parameters.Add("@FMR5_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm5R_1);
cmd.Parameters.Add("@FMR5_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm5R_2);
cmd.Parameters.Add("@FMR5_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm5R_3);
cmd.Parameters.Add("@FMR5_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm5R_4);
cmd.Parameters.Add("@FML6_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm6L_1);
cmd.Parameters.Add("@FMR6_750hz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm6L_2);
cmd.Parameters.Add("@FML6_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm6L_3);
cmd.Parameters.Add("@FMR6_1khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm6L_4);
cmd.Parameters.Add("@FML6_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm6R_1);
cmd.Parameters.Add("@FMR6_2khz", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm6R_2);
cmd.Parameters.Add("@FML6_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm6R_3);
cmd.Parameters.Add("@FMR6_Average", SqlDbType.Decimal).Value = Chk.CheckStringtoDecimalFunction(StructData.fm6R_4);
cmd.Parameters.Add("@FMExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result);
cmd.Parameters.Add("@VoiceValue1", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.testmaterial);
cmd.Parameters.Add("@VoiceItem1TrueL1", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true1L_1);
cmd.Parameters.Add("@VoiceItem1TrueL2", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true1L_2);
cmd.Parameters.Add("@VoiceItem1TrueL3", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true1L_3);
cmd.Parameters.Add("@VoiceItem1TrueR1", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true1R_1);
cmd.Parameters.Add("@VoiceItem1TrueR2", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true1R_2);
cmd.Parameters.Add("@VoiceItem1TrueR3", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true1R_3);
cmd.Parameters.Add("@VoiceItem1TrueD1", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true1D_1);
cmd.Parameters.Add("@VoiceItem1TrueD2", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true1D_2);
cmd.Parameters.Add("@VoiceItem1TrueD3", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true1D_3);
cmd.Parameters.Add("@VoiceValue2", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.testmaterial2);
cmd.Parameters.Add("@VoiceItem2TrueL1", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true2L_1);
cmd.Parameters.Add("@VoiceItem2TrueL2", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true2L_2);
cmd.Parameters.Add("@VoiceItem2TrueL3", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true2L_3);
cmd.Parameters.Add("@VoiceItem2TrueR1", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true2R_1);
cmd.Parameters.Add("@VoiceItem2TrueR2", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true2R_2);
cmd.Parameters.Add("@VoiceItem2TrueR3", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true2R_3);
cmd.Parameters.Add("@VoiceItem2TrueD1", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true2D_1);
cmd.Parameters.Add("@VoiceItem2TrueD2", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true2D_2);
cmd.Parameters.Add("@VoiceItem2TrueD3", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.true2D_3);
cmd.Parameters.Add("@VoiceExplain", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result2);
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]=="1")
{
this.ComparisonFMAidsData(StructData);
}
Sqlconn.Close();
}
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 CreateFMAidsAssess getFmAssessmentData(string SID)
{
CreateFMAidsAssess returnValue = new CreateFMAidsAssess();
DataBase Base = new DataBase();
using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
{
try
{
StaffDataBase sDB = new StaffDataBase();
Sqlconn.Open();
string sql = "SELECT FMAidsAssess.*,StudentDatabase.StudentName,StudentDatabase.StudentBirthday FROM FMAidsAssess " +
"INNER JOIN StudentDatabase ON FMAidsAssess.StudentID=StudentDatabase.StudentID " +
"WHERE FMAidsAssess.ID=@ID AND FMAidsAssess.isDeleted=0";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(SID);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
returnValue.ID = dr["ID"].ToString();
returnValue.Unit = 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.audiologistID = dr["Audiologist"].ToString();
List<string> CreateFileName = sDB.getStaffDataName(returnValue.audiologistID);
returnValue.audiologist = CreateFileName[1];
returnValue.assessDate = DateTime.Parse(dr["AssessDate"].ToString()).ToString("yyyy-MM-dd");
returnValue.aSource = dr["AidsSource"].ToString();
returnValue.aSourceText = dr["AidsSourceExplain"].ToString();
returnValue.fmModel = dr["TransmitterType"].ToString();
returnValue.fmChannel = dr["Channel"].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.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.fm1L_1 = dr["FML1_750hz"].ToString();
returnValue.fm1L_2 = dr["FML1_1khz"].ToString();
returnValue.fm1L_3 = dr["FML1_2khz"].ToString();
returnValue.fm1L_4 = dr["FML1_Average"].ToString();
returnValue.fm1R_1 = dr["FMR1_750hz"].ToString();
returnValue.fm1R_2 = dr["FMR1_1khz"].ToString();
returnValue.fm1R_3 = dr["FMR1_2khz"].ToString();
returnValue.fm1R_4 = dr["FMR1_Average"].ToString();
returnValue.fm2L_1 = dr["FML2_750hz"].ToString();
returnValue.fm2L_2 = dr["FML2_1khz"].ToString();
returnValue.fm2L_3 = dr["FML2_2khz"].ToString();
returnValue.fm2L_4 = dr["FML2_Average"].ToString();
returnValue.fm2R_1 = dr["FMR2_750hz"].ToString();
returnValue.fm2R_2 = dr["FMR2_1khz"].ToString();
returnValue.fm2R_3 = dr["FMR2_2khz"].ToString();
returnValue.fm2R_4 = dr["FMR2_Average"].ToString();
returnValue.fm3L_1 = dr["FML3_750hz"].ToString();
returnValue.fm3L_2 = dr["FML3_1khz"].ToString();
returnValue.fm3L_3 = dr["FML3_2khz"].ToString();
returnValue.fm3L_4 = dr["FML3_Average"].ToString();
returnValue.fm3R_1 = dr["FMR3_750hz"].ToString();
returnValue.fm3R_2 = dr["FMR3_1khz"].ToString();
returnValue.fm3R_3 = dr["FMR3_2khz"].ToString();
returnValue.fm3R_4 = dr["FMR3_Average"].ToString();
returnValue.fm4L_1 = dr["FML4_750hz"].ToString();
returnValue.fm4L_2 = dr["FML4_1khz"].ToString();
returnValue.fm4L_3 = dr["FML4_2khz"].ToString();
returnValue.fm4L_4 = dr["FML4_Average"].ToString();
returnValue.fm4R_1 = dr["FMR4_750hz"].ToString();
returnValue.fm4R_2 = dr["FMR4_1khz"].ToString();
returnValue.fm4R_3 = dr["FMR4_2khz"].ToString();
returnValue.fm4R_4 = dr["FMR4_Average"].ToString();
returnValue.fm5L_1 = dr["FML5_750hz"].ToString();
returnValue.fm5L_2 = dr["FML5_1khz"].ToString();
returnValue.fm5L_3 = dr["FML5_2khz"].ToString();
returnValue.fm5L_4 = dr["FML5_Average"].ToString();
returnValue.fm5R_1 = dr["FMR5_750hz"].ToString();
returnValue.fm5R_2 = dr["FMR5_1khz"].ToString();
returnValue.fm5R_3 = dr["FMR5_2khz"].ToString();
returnValue.fm5R_4 = dr["FMR5_Average"].ToString();
returnValue.fm6L_1 = dr["FML6_750hz"].ToString();
returnValue.fm6L_2 = dr["FMR6_750hz"].ToString();
returnValue.fm6L_3 = dr["FML6_1khz"].ToString();
returnValue.fm6L_4 = dr["FMR6_1khz"].ToString();
returnValue.fm6R_1 = dr["FML6_2khz"].ToString();
returnValue.fm6R_2 = dr["FMR6_2khz"].ToString();
returnValue.fm6R_3 = dr["FML6_Average"].ToString();
returnValue.fm6R_4 = dr["FMR6_Average"].ToString();
returnValue.result = dr["FMExplain"].ToString();
returnValue.testmaterial = dr["VoiceValue1"].ToString();
returnValue.true1L_1 = dr["VoiceItem1TrueL1"].ToString();
returnValue.true1L_2 = dr["VoiceItem1TrueL2"].ToString();
returnValue.true1L_3 = dr["VoiceItem1TrueL3"].ToString();
returnValue.true1R_1 = dr["VoiceItem1TrueR1"].ToString();
returnValue.true1R_2 = dr["VoiceItem1TrueR2"].ToString();
returnValue.true1R_3 = dr["VoiceItem1TrueR3"].ToString();
returnValue.true1D_1 = dr["VoiceItem1TrueD1"].ToString();
returnValue.true1D_2 = dr["VoiceItem1TrueD2"].ToString();
returnValue.true1D_3 = dr["VoiceItem1TrueD3"].ToString();
returnValue.testmaterial2 = dr["VoiceValue2"].ToString();
returnValue.true2L_1 = dr["VoiceItem2TrueL1"].ToString();
returnValue.true2L_2 = dr["VoiceItem2TrueL2"].ToString();
returnValue.true2L_3 = dr["VoiceItem2TrueL3"].ToString();
returnValue.true2R_1 = dr["VoiceItem2TrueR1"].ToString();
returnValue.true2R_2 = dr["VoiceItem2TrueR2"].ToString();
returnValue.true2R_3 = dr["VoiceItem2TrueR3"].ToString();
returnValue.true2D_1 = dr["VoiceItem2TrueD1"].ToString();
returnValue.true2D_2 = dr["VoiceItem2TrueD2"].ToString();
returnValue.true2D_3 = dr["VoiceItem2TrueD3"].ToString();
returnValue.result2 = dr["VoiceExplain"].ToString();
}
dr.Close();
Sqlconn.Close();
}
catch (Exception e)
{
returnValue.checkNo = "-1";
returnValue.errorMsg = e.Message.ToString();
}
}
return returnValue;
}
public string[] setFmAssessmentDataBase(CreateFMAidsAssess StructData)
{
Audiometry aDB = new Audiometry();
if (int.Parse(aDB._StaffhaveRoles[1]) == 1)
{
return aDB.setFmAssessmentData(StructData);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public CreateFMAidsAssess getFmAssessmentDataBase(string SID)
{
Audiometry aDB = new Audiometry();
CreateFMAidsAssess returnValue = new CreateFMAidsAssess();
if (int.Parse(aDB._StaffhaveRoles[3]) == 1)
{
returnValue=aDB.getFmAssessmentData(SID);
}
else
{
returnValue.checkNo = _noRole;
returnValue.errorMsg = _errorMsg;
}
return returnValue;
}
