public List <DateTime> DBSelectSlot(bool isArchive)
{
string cond = "dt='" + mDt.ToString(DT._) + "' AND stt";
if (isArchive)
{
cond = cond + "=" + (int)ExamStt.Archive;
}
else
{
cond = cond + "!=" + (int)ExamStt.Archive;
}
MySqlDataReader reader = DBConnect.exeQrySelect("sqz_slot", "t", cond);
List <DateTime> r = new List <DateTime>();
while (reader.Read())
{
string s = reader.GetString(0);
DateTime dt;
DT.To_(mDt.ToString(DT._) + ' ' +
s, DT.HS, out dt);
r.Add(dt);
}
reader.Close();
return(r);
}
public static List <int> DBSelectRoomIDs()
{
MySqlDataReader reader = DBConnect.exeQrySelect("sqz_room", null, null);
List <int> r = new List <int>();
while (reader.Read())
{
r.Add(reader.GetInt32(0));
}
reader.Close();
return(r);
}
public static List <DateTime> DBSel()
{
MySqlDataReader reader = DBConnect.exeQrySelect("sqz_board", null, null);
List <DateTime> dt = new List <DateTime>();
while (reader.Read())
{
dt.Add(reader.GetDateTime(0));
}
reader.Close();
return(dt);
}
public string DBGetT()
{
MySqlDataReader reader = DBConnect.exeQrySelect("sqz_examinee", "t",
"dt='" + mDt.ToString(DT._) + "' AND lv='" + Lv.ToString() +
"' AND id=" + uId);
if (reader.Read())
{
reader.Close();
return(reader.GetString(0));
}
return(DT.INV_H.ToString(DT.hh));
}
public List <string> DBSelectExaminee()
{
string cond = "dt='" + mDt.ToString(DT._) + "'";
MySqlDataReader reader = DBConnect.exeQrySelect("sqz_examinee", "lv,id", cond);
List <string> r = new List <string>();
while (reader.Read())
{
r.Add(reader.GetChar(0).ToString() + reader.GetUInt16(1).ToString("d4"));
}
reader.Close();
return(r);
}
public void LoadExaminees(DateTime dt)
{
vExaminee.Clear();
N_ExamineeGroupByLv[Level.A] = N_ExamineeGroupByLv[Level.B] = 0;
MySqlDataReader reader = DBConnect.exeQrySelect("sqz_slot_room AS a,sqz_examinee AS b",
"lv,id,name,birdate,birthplace", "a.rid=" + ID +
" AND a.dt='" + dt.ToString(DT._) + "' AND a.t='" + dt.ToString(DT.hh) +
"' AND a.dt=b.dt AND a.t=b.t AND a.rid=b.rid");
while (reader.Read())
{
ExamineeS0 e = new ExamineeS0();
e.mDt = dt;
if (!Enum.TryParse(reader.GetString(0), out e.Lv))
{
continue;
}
e.uId = reader.GetUInt16(1);
e.tName = reader.GetString(2);
e.tBirdate = reader.GetDateTime(3).ToString(DT.RR);
e.tBirthplace = reader.GetString(4);
vExaminee.Add(e.LvId, e);
++N_ExamineeGroupByLv[e.Lv];
}
reader.Close();
foreach (ExamineeA e in vExaminee.Values)
{
reader = DBConnect.exeQrySelect("sqz_nee_qsheet",
"t1,t2,grade,comp", "dt='" + e.mDt.ToString(DT._) + "' AND lv='" +
e.Lv + "' AND neeid=" + e.uId);
if (reader != null)
{
if (reader.Read())
{
if (DT.Toh(reader.GetString(0), DT.hs, out e.dtTim1))
{
break;
}
if (DT.Toh(reader.GetString(1), DT.hs, out e.dtTim2))
{
break;
}
e.uGrade = reader.GetInt16(2);
e.tComp = reader.GetString(3);
e.mPhase = ExamineePhase.Finished;
}
reader.Close();
}
}
}
public bool DBSelGrade()
{
MySqlDataReader reader = DBConnect.exeQrySelect("sqz_nee_qsheet", "grade",
"dt='" + mDt.ToString(DT._) + "' AND lv='" + Lv.ToString() +
"' AND neeid=" + uId);
if (reader.Read())
{
reader.Close();
uGrade = reader.GetInt16(0);
return(true);
}
return(false);
}
public int DBGetQSId()
{
MySqlDataReader reader = DBConnect.exeQrySelect("sqz_nee_qsheet", "qsid",
"dt='" + mDt.ToString(DT._) +
"' AND lv='" + Lv.ToString() +
"' AND neeid=" + uId);
if (reader.Read())
{
reader.Close();
return(reader.GetInt32(0));
}
return(-1);
}
public char[] DBGetAns()
{
MySqlDataReader reader = DBConnect.exeQrySelect("sqz_nee_qsheet", "ans",
"dt='" + mDt.ToString(DT._) + "' AND lv='" + Lv.ToString() +
"' AND neeid=" + uId);
if (reader.Read())
{
reader.Close();
return(reader.GetString(0).ToCharArray());
}
char[] noans = new char[AnsSheet.LEN];
for (int i = 0; i < AnsSheet.LEN; ++i)
{
noans[i] = MultiChoiceItem.C0;
}
return(noans);
}
public bool DBSelTimeAndPw(DateTime dt)
{
MySqlDataReader reader = DBConnect.exeQrySelect("sqz_slot_room", "pw,t1,t2",
"dt='" + dt.ToString(DT._) + "' AND t='" + dt.ToString(DT.hh) +
"' AND rid=" + ID + " LIMIT 1");
if (reader.Read())
{
tPw = reader.IsDBNull(0) ? null : reader.GetString(0);
if (reader.IsDBNull(1) || DT.Toh(reader.GetString(1), DT.hs, out t1))
{
t1 = DT.INV_;
}
if (reader.IsDBNull(2) || DT.Toh(reader.GetString(2), DT.hs, out t2))
{
t2 = DT.INV_;
}
}
reader.Close();
return(false);
}
public bool DBSelectQS(DateTime dt)//todo void
{
MySqlDataReader reader = DBConnect.exeQrySelect("sqz_qsheet", "id",
"dt='" + dt.ToString(DT._) + "' AND t='" + dt.ToString(DT.hh) +
"' AND lv='" + Lv.ToString() + "' AND alt=" +
(IsAlternative ? '1' : '0'));
List <int> qsids = new List <int>();
while (reader.Read())
{
qsids.Add(reader.GetUInt16(0));
}
reader.Close();
foreach (int qsid in qsids)
{
QuestSheet qs = new QuestSheet();
if (qs.DBSelect(dt, Lv, qsid))
{
return(true);
}
Sheets.Add(qs.uId, qs);
}
return(false);
}
