public int DBInsRoom_and_Examinee()
{
Random rand = new Random();
int v = 1;
StringBuilder sb = new StringBuilder();
foreach (ExamRoom r in Rooms.Values)
{
int n = 0;
bool isExist = DBConnect.IsExist("sqz_slot_room",
"dt='" + mDt.ToString(DT._) + "' AND t='" + mDt.ToString(DT.hh) +
"' AND rid=" + r.ID);
if (!isExist)
{
DBConnect.Ins("sqz_slot_room",
"dt,t,rid,pw,qpkalt", "('" + mDt.ToString(DT._) + "','" + mDt.ToString(DT.hh) +
"'," + r.ID + ",'" + ExamRoom.GeneratePw(rand) + "',0)");
}
n = r.SaveExaminees();
if (n < 0)
{
sb.AppendFormat(Txt.s._[(int)TxI.ROOM_DB_NOK] + '\n', r.ID + 1,
Txt.s._[(int)TxI.NEE_EXIST]);
v = 0;
}
}
return(v);
}
public bool DBInsResult(int rid)
{
StringBuilder vals = new StringBuilder();
foreach (ExamSlot sl in Slots.Values)
{
sl.DBUpdateRs(rid, vals);
}
bool rval;
if (0 < vals.Length)
{
vals.Remove(vals.Length - 1, 1);//remove the last comma
int rs;
rval = (rs = DBConnect.Ins("sqz_nee_qsheet",
"dt,lv,neeid,qsid,t1,t2,grade,comp,ans", vals.ToString())) < 0;
}
else
{
rval = true;
}
if (!rval)
{
foreach (ExamSlot sl in Slots.Values)
{
sl.SaveCommitTime(rid);
}
}
return(rval);
}
public int DBInsSlot(DateTime t)
{
string v = "('" + mDt.ToString(DT._) + "','"
+ t.ToString(DT.h) + "'," + (int)ExamStt.Prep + ")";
return(DBConnect.Ins("sqz_slot", "dt,t,stt", v));
}
public int SaveExaminees()
{
if (vExaminee.Count == 0)
{
return(0);
}
string attbs = "dt,lv,id,t,rid,name,birdate,birthplace";
StringBuilder vals = new StringBuilder();
foreach (ExamineeA e in vExaminee.Values)
{
vals.Append("('" + e.mDt.ToString(DT._) + "','");
vals.Append(e.Lv.ToString() + "',");
vals.Append(e.uId + ",");
vals.Append("'" + e.mDt.ToString(DT.hh) + "',");
vals.Append(ID + ",");
vals.Append("'" + e.tName + "',");
vals.Append("'" + DT.ToS(e.tBirdate, DT.RR) + "',");
vals.Append("'" + e.tBirthplace + "'),");
}
vals.Remove(vals.Length - 1, 1);//remove the last comma
return(DBConnect.Ins("sqz_examinee", attbs, vals.ToString()));
}
public int DBIns()
{
return(DBConnect.Ins("sqz_board", "dt", "('" + mDt.ToString(DT._) + "')"));
}
