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._) + "')")); }