/// <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);
}
