public LogItem[] GetItems( NpgsqlConnection connection, CriteriaType criteriaType, DateTime criteria, int maxCount, bool includeBytes) { IWhereOp whereOp; bool asc; switch (criteriaType) { case CriteriaType.DownFromInfinity: whereOp = null; asc = false; break; case CriteriaType.DownFrom: whereOp = new Lt(DbStr.Time, criteria.Ticks); asc = false; break; case CriteriaType.DownFromOrEqual: whereOp = new Le(DbStr.Time, criteria.Ticks); asc = false; break; case CriteriaType.UpFromInfinity: whereOp = null; asc = true; break; case CriteriaType.UpFrom: whereOp = new Gt(DbStr.Time, criteria.Ticks); asc = true; break; case CriteriaType.UpFromOrEqual: whereOp = new Ge(DbStr.Time, criteria.Ticks); asc = true; break; default: throw new NotSupportedException("CriteriaType " + criteriaType); } var columns = includeBytes ? _columns : _columnsWithoutBytes; var query = _npgQueryHelper.Select( _tableName, columns, whereOp, new[] { DbStr.Time }, asc, Math.Min(maxCount, MaxItemsToRetrieve)); var alarms = _npgHelper.ExecuteReader(connection, query, reader => { var i = new LogItem { Time = reader.GetDateTimeFormTicks(0), Text = reader.GetNullableString(1) }; if (includeBytes) { i.Bytes = reader.GetByteArray(2); } return(i); }); return(asc ? alarms.Reverse().ToArray() : alarms); }
/// <summary> /// Add a <Gt>-Tag /// </summary> /// <returns><see cref="BaseCoreComparingGroupElement{T}"/></returns> public static T Gt <T>(this T parent, Action <Gt> action) where T : BaseCoreComparingGroupElement <T> { var gt = new Gt(); action(gt); parent.Childs.Add(gt); return(parent); }
public void learn(ISpiderElement element) { spiderLink link = element as spiderLink; if (link != null) { Gt.Add(link.url, link); } }
static IValidator Gt(object pValue, object pMin, string pFieldName, string pErrorMsg) { IValidator validator = new Gt() { Value = pValue, Min = pMin, ErrorMsg = pErrorMsg, FieldName = pFieldName }; return(validator); }
// Operator Comp public string Visit(Gt node) { var st = ""; var labelOne = GenerateLabel(); var labelTwo = GenerateLabel(); st += VisitChildren(node); st += tab(2) + "ble.un " + labelOne + "\n"; st += tab(2) + "ldc.i4.0\n"; st += tab(2) + "br " + labelTwo + "\n"; st += tab(1) + labelOne + ":\n"; st += tab(2) + "ldc.i4 42\n"; st += tab(1) + labelTwo + ":\n"; return(st); }
public User[] Get(NpgsqlConnection connection, CriteriaType criteriaType, string name, int count) { IWhereOp whereOp; bool asc; switch (criteriaType) { case CriteriaType.DownFromInfinity: whereOp = null; asc = true; break; case CriteriaType.DownFrom: whereOp = new Gt(DbStr.Name, name); asc = true; break; case CriteriaType.DownFromOrEqual: whereOp = new Ge(DbStr.Name, name); asc = true; break; case CriteriaType.UpFromInfinity: whereOp = null; asc = false; break; case CriteriaType.UpFrom: whereOp = new Lt(DbStr.Name, name); asc = false; break; case CriteriaType.UpFromOrEqual: whereOp = new Le(DbStr.Name, name); asc = false; break; default: throw new NotSupportedException("CriteriaType " + criteriaType); } int limit = Math.Min(count, MaxUsersToRetrieve); NpgQuery query = _npgQueryHelper.Select( DbStr.Users, _userColumns, whereOp, new[] { DbStr.Name }, asc, limit); var users = _npgHelper.ExecuteReader(connection, query, GetUser); return(asc ? users : users.Reverse().ToArray()); }
public void Test_b_gt_5() { var fsa = new FieldSpec <int>("a"); var fsb = new FieldSpec <int>("b"); var store1 = TableStore.Create(fsa, fsb); var fa = store1.GetField(fsa); var fb = store1.GetField(fsb); var expr = new Gt <int>(fsb, 5); var(_, snapshot, test) = Table.Filter(Table.Create(store1), expr); var r1 = store1.Insert(); r1.SetValue(fa, 0); r1.SetValue(fb, 5); var r2 = store1.Insert(); r2.SetValue(fa, 1); r2.SetValue(fb, 6); var r3 = store1.Insert(); r3.SetValue(fa, 2); r3.SetValue(fb, 7); Assert.Equal(new Array8[] { new Array8(1) { [0] = 1 }, new Array8(1) { [0] = 2 } }, snapshot()); Assert.Empty(test(store1[0])); Assert.Equal(new Array8[] { new Array8(1) { [0] = 1 } }, test(store1[1])); Assert.Equal(new Array8[] { new Array8(1) { [0] = 2 } }, test(store1[2])); }
protected override bool ExecuteParent(ArraySegment <string> arguments, ICommandSender sender, out string response) { EventHandlers.LogCommandUsed((CommandSender)sender, EventHandlers.FormatArguments(arguments, 0)); StringBuilder ListBuilder = new StringBuilder(); ListBuilder.Append("Here are the following enums you can use in commands:\n\nBreakType: "); foreach (BreakType Bt in Enum.GetValues(typeof(BreakType))) { ListBuilder.Append(Bt.ToString()); ListBuilder.Append(" "); } ListBuilder.AppendLine(); ListBuilder.Append("MoveType: "); foreach (MoveType Mt in Enum.GetValues(typeof(MoveType))) { ListBuilder.Append(Mt.ToString()); ListBuilder.Append(" "); } ListBuilder.AppendLine(); ListBuilder.Append("GrenadeType: "); foreach (GrenadeType Gt in Enum.GetValues(typeof(GrenadeType))) { ListBuilder.Append(Gt.ToString()); ListBuilder.Append(" "); } ListBuilder.AppendLine(); ListBuilder.Append("VectorAxis: "); foreach (VectorAxis Va in Enum.GetValues(typeof(VectorAxis))) { ListBuilder.Append(Va.ToString()); ListBuilder.Append(" "); } ListBuilder.AppendLine(); ListBuilder.Append("PositionModifier: "); foreach (PositionModifier Pm in Enum.GetValues(typeof(PositionModifier))) { ListBuilder.Append(Pm.ToString()); ListBuilder.Append(" "); } string message = ListBuilder.ToString(); ListBuilder.Clear(); response = message; return(true); }
public bool checkData() { if (!checkNull(mnv.Text, " MaNV")) { mnv.Focus(); return(false); } if (!checkNull(tnv.Text, " TenNV")) { tnv.Focus(); return(false); } if (!checkNull(ns.Text, " Ngày Sinh")) { ns.Focus(); return(false); } if (!checkNull(noisinh.Text, " Nơi Sinh")) { noisinh.Focus(); return(false); } if (!checkNull(tamt.Text, " Tạm trú")) { tamt.Focus(); return(false); } if (!checkNull(qq.Text, " Quê Quán")) { qq.Focus(); return(false); } if (!checkNull(qt.Text, " Quốc Tịch")) { qt.Focus(); return(false); } if (!checkNull(dto.Text, " Dân tộc")) { dto.Focus(); return(false); } if (!checkNull(cmnd.Text, " CMND")) { cmnd.Focus(); return(false); } if (!checkNull(ngc.Text, " Ngày Cấp Cmnd")) { ngc.Focus(); return(false); } if (!checkNull(noic.Text, " Nơi cấp")) { noic.Focus(); return(false); } if (!checkNull(email.Text, " Email")) { email.Focus(); return(false); } if (!checkNull(sdt.Text, " SDT")) { sdt.Focus(); return(false); } if (!checkNull(phg.Text, " Phòng")) { phg.Focus(); return(false); } if (!checkNull(cv.Text, " Chúc vụ")) { cv.Focus(); return(false); } if (!checkNull(Gt.Text, " Giới Tính")) { Gt.Focus(); return(false); } DataConnection dc = new DataConnection(); SqlConnection connect = dc.getConnect(); connect.Open(); string sql = "select MaNV from NhanVien Where MaNV='" + mnv.Text + "'"; string sql1 = "select MaPhong from PhongBan Where MaPhong='" + phg.Text + "'"; string sql2 = "select MaChucVu from ChucVu Where MaChucVu='" + cv.Text + "'"; SqlDataAdapter da = new SqlDataAdapter(sql, connect); DataTable dt = new DataTable(); da.Fill(dt); if (dt.Rows.Count > 0) { MessageBox.Show("MaNV đã tồn tại ", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } SqlDataAdapter da1 = new SqlDataAdapter(sql1, connect); DataTable dt1 = new DataTable(); da1.Fill(dt1); if (dt1.Rows.Count == 0) { MessageBox.Show("MaPhong chưa tồn tại ", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } SqlDataAdapter da2 = new SqlDataAdapter(sql2, connect); DataTable dt2 = new DataTable(); da2.Fill(dt2); if (dt2.Rows.Count == 0) { MessageBox.Show("MaChucVu chưa tồn tại ", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } if (Regex.IsMatch(tnv.Text, "[0-9]")) { MessageBox.Show(" Tên Nhân viên không hợp lệ", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); tnv.Focus(); return(false); } if (Regex.IsMatch(cmnd.Text, "[A-Za-z]") || cmnd.Text.Length != 9) { MessageBox.Show("CMND không hợp lệ", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); cmnd.Focus(); return(false); } if (Regex.IsMatch(sdt.Text, "[A-Za-z]") || sdt.Text.Length != 10) { MessageBox.Show("SDT không hợp lệ", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); sdt.Focus(); return(false); } if (Gt.Text.ToUpper() == "NAM" || Gt.Text.ToUpper() == "NU") { return(true); } else { MessageBox.Show("Gioi tinh phải là Nam / nu", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); return(false); } return(true); }
public Tuple <DateTime, double?[]>[] GetPage(int[] trendTagIds, CriteriaType criteriaType, DateTime criteria, int maxCount) { IWhereOp whereOp; bool asc; switch (criteriaType) { case CriteriaType.DownFromInfinity: whereOp = null; asc = false; break; case CriteriaType.DownFrom: whereOp = new Lt(DbStr.Time, criteria.Ticks); asc = false; break; case CriteriaType.DownFromOrEqual: whereOp = new Le(DbStr.Time, criteria.Ticks); asc = false; break; case CriteriaType.UpFromInfinity: whereOp = null; asc = true; break; case CriteriaType.UpFrom: whereOp = new Gt(DbStr.Time, criteria.Ticks); asc = true; break; case CriteriaType.UpFromOrEqual: whereOp = new Ge(DbStr.Time, criteria.Ticks); asc = true; break; default: throw new NotSupportedException("CriteriaType " + criteriaType); } var columns = new List <string>(trendTagIds.Length + 1) { DbStr.Time }; columns.AddRange(trendTagIds.Select(GetColumnName)); var columnsArr = columns.ToArray(); int limit = Math.Min(maxCount, MaxSamplesToRetrieve); var parameters = new List <NpgsqlParameter>(); var queryTexts = new List <string>(); for (var i = 0; i < TrendTableSelector.TablesCount; i++) { string queryText = _npgQueryHelper.Select( parameters, _tableName + "_" + i, columnsArr, whereOp, ColumnsOfTime, asc, limit); queryTexts.Add(queryText); } NpgQuery query = _npgQueryHelper.Union(parameters, queryTexts, ColumnsOfTime, asc, limit); var result = _npgHelper.ExecuteReader(_connection, query, reader => { DateTime time = reader.GetDateTimeFormTicks(0); var values = new double?[columns.Count - 1]; for (var j = 1; j < columns.Count; j++) { values[j - 1] = reader.GetNullableDouble(j); } return(new Tuple <DateTime, double?[]>(time, values)); }); return(asc ? result.Reverse().ToArray() : result); }
public void Visit(Gt node) { VisitChildren(node); }