public string[] setHearingTestData(setHearingTests StructData)
{
string[] returnValue = new string[2];
returnValue[0] = "0";
returnValue[1] = "";
DataBase Base = new DataBase();
string LimitValue = "";
int itemNumber = Chk.CheckStringtoIntFunction(StructData.itemNumber);
if (itemNumber > 0)
{
if (itemNumber > 2)
{
LimitValue = "VoiceItem" + itemNumber + "=@project,";
}
using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
{
try
{
Sqlconn.Open();
string sql = "UPDATE HearingInspection SET VoiceWear" + itemNumber + "=@voice, VoiceState" + itemNumber + "=@state, " + LimitValue +
"VoiceMaterial" + itemNumber + "=@material, VoiceVolume" + itemNumber + "=@volume, VoiceResult" + itemNumber + "=@result, VoiceRemark" + itemNumber + "=@remark " +
"WHERE ID=@ID";
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@ID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.ID);
cmd.Parameters.Add("@voice", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.voice);
cmd.Parameters.Add("@state", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StructData.state);
cmd.Parameters.Add("@project", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.project);
cmd.Parameters.Add("@material", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.material);
cmd.Parameters.Add("@volume", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.volume);
cmd.Parameters.Add("@result", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.result);
cmd.Parameters.Add("@remark", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StructData.remark);
cmd.Parameters.Add("@number", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(StructData.itemNumber);
returnValue[0] = cmd.ExecuteNonQuery().ToString();
Sqlconn.Close();
}
catch (Exception e)
{
returnValue[0] = "-1";
returnValue[1] = e.Message;
}
}
}
else
{
returnValue[0] = "-1";
returnValue[1] = "系統錯誤";
}
return returnValue;
}
public string[] setHearingTestDataBase(setHearingTests StructData)
{
Audiometry aDB = new Audiometry();
if (int.Parse(aDB._StaffhaveRoles[1]) == 1)
{
return aDB.setHearingTestData(StructData);
}
else
{
return new string[2] { _noRole, _errorMsg };
}
}
public List<setHearingTests> getHearingTestData(string studentID)
{
List<setHearingTests> returnValue = new List<setHearingTests>();
string item1 = "語音察覺閾 (SAT)";
string item2 = "字詞辨識率 (WRS)";
string ConditionReturn = "";
StaffDataBase sDB = new StaffDataBase();
List<string> UserFile = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name);
if (int.Parse(_StaffhaveRoles[4]) == 0 && UserFile[1].Length > 0)
{
ConditionReturn += " AND Unit =" + UserFile[2] + " ";
}
DataBase Base = new DataBase();
using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()))
{
try
{
Sqlconn.Open();
string sql = "SELECT * FROM HearingInspection WHERE isDeleted=0 AND StudentID=@StudentID " + ConditionReturn;
SqlCommand cmd = new SqlCommand(sql, Sqlconn);
cmd.Parameters.Add("@StudentID", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(studentID);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
setHearingTests addValue = new setHearingTests();
for (int i = 1; i <= 4; i++) {
string item = "";
if (i ==1) {
item = item1;
}
else if (i == 2) {
item = item2;
}
else {
item = dr["VoiceItem" + i].ToString();
}
if (dr["VoiceWear" + i].ToString() != "0" || dr["VoiceState" + i].ToString() != "0" || dr["VoiceMaterial" + i].ToString().Length >0)
{
addValue = new setHearingTests();
addValue.ID = dr["ID"].ToString();
addValue.checkDate = DateTime.Parse(dr["CheckDate"].ToString()).ToString("yyyy-MM-dd");
addValue.voice = dr["VoiceWear" + i].ToString();
addValue.state = dr["VoiceState" + i].ToString();
addValue.project = item;
addValue.material = dr["VoiceMaterial" + i].ToString();
addValue.volume = dr["VoiceVolume" + i].ToString();
addValue.result = dr["VoiceResult" + i].ToString();
addValue.remark = dr["VoiceRemark" + i].ToString();
addValue.itemNumber = i.ToString();
returnValue.Add(addValue);
}
}
}
}
catch (Exception e)
{
setHearingTests addValue = new setHearingTests();
addValue.checkNo = "-1";
addValue.errorMsg = e.Message.ToString();
returnValue.Add(addValue);
}
}
return returnValue;
}
public List<setHearingTests> getHearingTestDataBase(string stuID)
{
Audiometry aDB = new Audiometry();
List<setHearingTests> returnValue = new List<setHearingTests>();
if (int.Parse(aDB._StaffhaveRoles[0]) == 1)
{
returnValue= aDB.getHearingTestData(stuID);
}
else
{
setHearingTests addValue = new setHearingTests();
addValue.checkNo = _noRole;
addValue.errorMsg = _errorMsg;
returnValue.Add(addValue);
}
return returnValue;
}
