public string DBDeleleUnfinishedExaminee() { StringBuilder sb = new StringBuilder(); int n = DBConnect.Count("sqz_nee_qsheet AS a,sqz_examinee AS b", "a.dt", "a.dt='" + mDt.ToString(DT._) + "' AND t='" + mDt.ToString(DT.hh) + "' AND a.dt=b.dt AND a.neeid=b.id"); sb.AppendFormat(Txt.s._[(int)TxI.SLOT],mDt.ToString(DT.hh)); if (0 < n) { sb.Append(Txt.s._[(int)TxI.SLOT_DEL_GRD] + '\n'); return(sb.ToString()); } else if (n < 0) { sb.Append(Txt.s._[(int)TxI.SLOT_DEL_ECPT]); return(sb.ToString()); } n = DBConnect.Delete("sqz_examinee", "dt='" + mDt.ToString(DT._) + "' AND t='" + mDt.ToString(DT.hh) + "'"); if (n < 0) { sb.Append(Txt.s._[(int)TxI.SLOT_DEL_ECPT]); } else { sb.AppendFormat(Txt.s._[(int)TxI.SLOT_DEL_N],n.ToString()); } return(sb.ToString()); }
public static List <int[]> DBCountItemGroupByModule(Level lv) { IUx[] IUs_by_Lv = MultiChoiceItem.GetIUs(lv); int[] n_difficultItems = new int[IUs_by_Lv.Length]; int[] n_allItems = new int[IUs_by_Lv.Length]; int j = -1; foreach (IUx i in IUs_by_Lv) { n_allItems[++j] = DBConnect.Count("sqz_question", "id", "moid=" + (int)i + " AND del=0"); if (n_allItems[j] < 0) { n_allItems[++j] = 0; } n_difficultItems[j] = DBConnect.Count("sqz_question", "id", "moid=" + (int)i + " AND diff=1 AND del=0"); if (n_difficultItems[j] < 0) { n_difficultItems[j] = 0; } } List <int[]> n = new List <int[]>(); n.Add(n_allItems); n.Add(n_difficultItems); return(n); }
public static int DBGetND(IUx iu) { int n = DBConnect.Count("sqz_question", "id", "moid=" + (int)iu + " AND diff=1 AND del=0"); if (n < 0) { n = 0; } return(n); }