public static IEnumerable <Order> RequestOrders(DateTime dateTime, string operatorsIds, string clientsIds, string factoriesIds, string productsIds)
{
operatorsIds = string.IsNullOrWhiteSpace(operatorsIds) ? "0" : "0," + operatorsIds;
clientsIds = string.IsNullOrWhiteSpace(clientsIds) ? "0" : "0," + clientsIds;
factoriesIds = string.IsNullOrWhiteSpace(factoriesIds) ? "0" : "0," + factoriesIds;
productsIds = string.IsNullOrWhiteSpace(productsIds) ? "0" : "0," + productsIds;
string fecha = dateTime.ToString();
PlannerDataSet ds = new PlannerDataSet();
ds.EnforceConstraints = false;
PlannerDataSetTableAdapters.PlannerOrdersTableAdapter adapter = new PlannerDataSetTableAdapters.PlannerOrdersTableAdapter();
//adapter.FillByPending(ds.PlannerOrders, dateTime.ToString(), operatorsIds, clientsIds, factoriesIds, productsIds);
adapter.FillByPendingsp(ds.PlannerOrders, dateTime, operatorsIds, clientsIds, factoriesIds, productsIds);
//adapter.FillByPendingtestInner(ds.PlannerOrders, dateTime.ToString() ,operatorsIds, clientsIds, factoriesIds, productsIds);
var table = ds.PlannerOrders;
foreach (DataRow row in table.Rows)
{
yield return(ConvertToOrder(row, table));
}
}
public static IEnumerable <Order> RequestOrders(DateTime dateTime)
{
PlannerDataSet ds = new PlannerDataSet();
ds.EnforceConstraints = false;
PlannerDataSetTableAdapters.PlannerOrdersTableAdapter adapter = new PlannerDataSetTableAdapters.PlannerOrdersTableAdapter();
adapter.FillByPending(ds.PlannerOrders, dateTime.ToString(), "0", "0", "0", "0");
//adapter.FillByPendingsp(ds.PlannerOrders, dateTime, "0", "0", "0", "0");
var table = ds.PlannerOrders;
foreach (DataRow row in table.Rows)
{
yield return(ConvertToOrder(row, table));
}
}