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