/// <summary> /// 获取我的已发起工单 /// </summary> /// <returns></returns> public DataTable GetMyStartedOrders(int pageIndex, int pageSize, out int count) { WhereStatement where = new WhereStatement(); //string sStatus = JSRequest.GetRequestUrlParm(OrderEntity.FieldStatus, false); //int? status = JSValidator.ValidateInt(OrderEntity.FieldStatus, sStatus, false); //if (status != null) { where.Add(OrderEntity.FieldStatus, Comparison.Equals, status); } PermissionService permissionService = new PermissionService(); ViewManager manager = new ViewManager("VO_Order"); //1.0 获取当前员工数据 StaffEntity staff = permissionService.GetCurrentStaff(); //2.0 构建where从句 where.Add(OrderEntity.FieldStarterID, Comparison.Equals, staff.ID); where.Add(OrderEntity.FieldStatus, Comparison.NotEquals, (int)OrderStatus.Canceled); OrderByStatement orderby = new OrderByStatement(); orderby.Add(OrderEntity.FieldPriority, Sorting.Descending); orderby.Add(OrderEntity.FieldBookingTime, Sorting.Ascending); //3.0 获取已发起的数据 DataTable dt = manager.GetDataTableByPage(where, out count, pageIndex, pageSize, orderby); return(dt); }
/// <summary> /// 获取我处理中的工单 /// </summary> /// <returns></returns> public DataTable GetMyHandlingOrders(int pageIndex, int pageSize, out int count) { PermissionService permissionService = new PermissionService(); ViewManager manager = new ViewManager("VO_Order"); //1.0 获取当前员工数据 StaffEntity staff = permissionService.GetCurrentStaff(); //2.0 构建where从句 WhereStatement where = new WhereStatement(); WhereClause clause = new WhereClause(OrderEntity.FieldStatus, Comparison.Equals, (int)OrderStatus.Handling); clause.AddClause(LogicOperator.Or, Comparison.Equals, (int)OrderStatus.Rejected); where.Add(clause); where.Add(OrderEntity.FieldHandlerID, Comparison.Equals, staff.ID); //2.1 构建orderby 从句 OrderByStatement orderby = new OrderByStatement(); orderby.Add(OrderEntity.FieldPriority, Sorting.Descending); orderby.Add(OrderEntity.FieldBookingTime, Sorting.Ascending); //3.0 获取已发起的数据 DataTable dt = manager.GetDataTableByPage(where, out count, pageIndex, pageSize, orderby); return(dt); }
/// <inheritdoc /> public ISelectStringBuilder OrderBy(string columnName, SortingOperator @operator) { var clause = new OrderByClause(columnName, @operator); OrderByStatement.Add(clause); return(this); }
/// <inheritdoc /> public ISelectStringBuilder OrderBy(string columnName) { var clause = new OrderByClause(columnName); OrderByStatement.Add(clause); return(this); }
public void Test_GetIdsManager() { IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.CenterDbConnectionString, BaseSystemInfo.CenterDbType); UserManager manager = new UserManager(dbHelper); UserEntity entity = new UserEntity(); WhereStatement where = new WhereStatement(dbHelper); //where.Add(new WhereClause(entity.FieldF3, Comparison.Equals, "333"));//Test Return Data where.Add(new WhereClause(entity.FieldF3, Comparison.Equals, "3334"));//Test Return String[0] OrderByStatement orderby = new OrderByStatement(); orderby.Add(entity.PrimaryKey, Sorting.Ascending); orderby.Add(entity.FieldDateTimeType, Sorting.Descending); string[] ids = manager.GetIds(where, orderby); Console.WriteLine(ids); }
public DataTable GetOrderHandlers(Guid orderID) { //只能查视图 ViewManager manager = new ViewManager("VO_OrderHandlers"); WhereStatement where = new WhereStatement(); where.Add(OrderHandlerEntity.FieldOrderID, Comparison.Equals, orderID.ToString()); OrderByStatement orderby = new OrderByStatement(); orderby.Add(OrderHandlerEntity.FieldIsLeader, Sorting.Descending); int count = 0; DataTable dt = manager.GetDataTable(where, out count, orderby); return(dt); }
public void Test_GetDataTableManager() { IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.CenterDbConnectionString, BaseSystemInfo.CenterDbType); UserManager manager = new UserManager(dbHelper); UserEntity entity = new UserEntity(); WhereStatement where = new WhereStatement(dbHelper); where.Add(new WhereClause(entity.FieldF3, Comparison.Equals, "333")); OrderByStatement orderby = new OrderByStatement(); orderby.Add(entity.PrimaryKey, Sorting.Ascending); int count = 0; DataTable dt1 = manager.GetDataTable(where, out count, orderby); DataTable dt2 = manager.GetDataTableByPage(where, out count, 2, 2, orderby); }
public void Test_GetListManager() { IDbHelper dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.CenterDbConnectionString, BaseSystemInfo.CenterDbType); UserManager manager = new UserManager(dbHelper); UserEntity entity = new UserEntity(); WhereStatement where = new WhereStatement(dbHelper); where.Add(new WhereClause(entity.FieldF3, Comparison.In, new string[] { "333", "3333" })); where.Add(new WhereClause(entity.FieldF2, Comparison.Like, "aa%")); OrderByStatement orderby = new OrderByStatement(); orderby.Add(entity.PrimaryKey, Sorting.Ascending); int count = 0; List <UserEntity> list = manager.GetList(where, out count, orderby); List <UserEntity> listByPage = manager.GetListByPage(where, out count, 2, 2, orderby); }
/// <summary> /// Adds the order by. /// </summary> /// <param name="field">The field.</param> /// <param name="order">The order.</param> public void AddOrderBy(string field, Sorting order) { var newOrderByClause = new OrderByClause(field, order); OrderByStatement.Add(newOrderByClause); }
/// <summary> /// Adds the order by. /// </summary> /// <param name="clause">The clause.</param> public void AddOrderBy(OrderByClause clause) { OrderByStatement.Add(clause); }