public static int?GetLPNQuantity(Session session, int LPNNumber, int customerID, DateTime inventoryDate, Inventory currentRecord)
{
CriteriaOperatorCollection filter = new CriteriaOperatorCollection();
filter.Add(new BinaryOperator("InventoryDate", inventoryDate, BinaryOperatorType.Equal));
filter.Add(new BinaryOperator(Inventory.Fields.InventoryItemID.ItemCustomerID.CustomerID.PropertyName, customerID, BinaryOperatorType.Equal));
filter.Add(new BinaryOperator("LPNNumber", LPNNumber, BinaryOperatorType.Equal));
filter.Add(new BinaryOperator(Inventory.Fields.InventoryID.PropertyName, currentRecord.InventoryID, BinaryOperatorType.NotEqual));
int?LPNQuantity = (int?)session.Evaluate <Inventory>(new AggregateOperand("", "InventoryQuantity", Aggregate.Sum), new GroupOperator(GroupOperatorType.And, filter));
if (LPNQuantity.HasValue)
{
LPNQuantity += currentRecord.InventoryQuantity;
}
else
{
LPNQuantity = currentRecord.InventoryQuantity;
}
if (LPNQuantity.HasValue)
{
return(LPNQuantity.Value);
}
else
{
return(0);
}
}
public static int GetNewPalletNumber(Session session, DateTime inventoryDate, int itemID, int?shift)
{
int?value = null;
CriteriaOperatorCollection filter = new CriteriaOperatorCollection();
filter.Add(new BinaryOperator("InventoryDate", inventoryDate.Date, BinaryOperatorType.GreaterOrEqual));
filter.Add(new BinaryOperator("InventoryDate", inventoryDate.Date.AddDays(1), BinaryOperatorType.Less));
filter.Add(new BinaryOperator("InventoryItemID", itemID, BinaryOperatorType.Equal));
if (shift.HasValue)
{
filter.Add(new BinaryOperator("Shift", (object)shift, BinaryOperatorType.Equal));
}
else
{
return(1);
}
value = (int?)session.Evaluate <Inventory>(new AggregateOperand("", "Pallet", Aggregate.Max), new GroupOperator(GroupOperatorType.And, filter));
if (value.HasValue)
{
return(value.Value + 1);
}
else
{
return(1);
}
}
private static void AddRMItems(Session ReportSession, bool OnlyAssignedCustomers)
{
XPCollection <LocationInventory> itemCollection = null;
CriteriaOperatorCollection theCriteria = new CriteriaOperatorCollection();
VRMItemKey VRMKey = new VRMItemKey();
theCriteria.Add(new BinaryOperator(LocationInventory.Fields.LocationInventoryItem.ItemType.PropertyName, "RM", BinaryOperatorType.Equal));
if (OnlyAssignedCustomers)
{
theCriteria.Add(new InOperator(LocationInventory.Fields.LocationInventoryItem.ItemCustomerID.PropertyName, UsersCustomerBLL.GetAssignedCustomerIDs(ReportSession)));
}
itemCollection = new XPCollection <LocationInventory>(ReportSession, new GroupOperator(GroupOperatorType.And, theCriteria));
foreach (LocationInventory item in itemCollection)
{
VRMKey.ItemCode = item.LocationInventoryItem.ItemCode;
VRMKey.Location = item.Location.LocationCode;
if (CurrentRMInventoryDictionary.ContainsKey(VRMKey))
{
CurrentRMInventoryDictionary[VRMKey].QuantityOnHand += item.QuantityOnHand;
}
else
{
CurrentRMInventoryDictionary.Add(VRMKey, new VRMItem()
{
Item = item
});
}
}
}
public void FillAdjustmentView()
{
CriteriaOperatorCollection inventoryViewCriteria = new CriteriaOperatorCollection();
if (((DateTime?)fromFilterDateEdit.EditValue).HasValue)
{
inventoryViewCriteria.Add(new BinaryOperator(InventoryAdjustment.Fields.AdjustmentDate.PropertyName, Convert.ToDateTime(fromFilterDateEdit.EditValue), BinaryOperatorType.GreaterOrEqual));
}
if (((DateTime?)toFilterDateEdit.EditValue).HasValue)
{
inventoryViewCriteria.Add(new BinaryOperator(InventoryAdjustment.Fields.AdjustmentDate.PropertyName, Convert.ToDateTime(toFilterDateEdit.EditValue), BinaryOperatorType.LessOrEqual));
}
if (((int?)customerFilterLookUpEdit.EditValue).HasValue)
{
inventoryViewCriteria.Add(new BinaryOperator(InventoryAdjustment.Fields.AdjustmentItem.ItemCustomerID.CustomerID.PropertyName, Convert.ToInt32(customerFilterLookUpEdit.EditValue), BinaryOperatorType.Equal));
}
if (((int?)itemFilterLookUpEdit.EditValue).HasValue)
{
inventoryViewCriteria.Add(new BinaryOperator(InventoryAdjustment.Fields.AdjustmentItem.ItemID.PropertyName, Convert.ToInt32(itemFilterLookUpEdit.EditValue), BinaryOperatorType.Equal));
}
inventoryXPView.Criteria = CriteriaOperator.And(inventoryViewCriteria);
//Me.adjustmentGridControl.DataSource = m_Adjustment.GetAdjustmentView(CType(Me.fromFilterDateEdit.EditValue, Date?), CType(Me.toFilterDateEdit.EditValue, Date?), _
// CType(Me.customerFilterLookUpEdit.EditValue, Integer?), CType(Me.itemFilterLookUpEdit.EditValue, Integer?))
}
private void FilterLpns()
{
CriteriaOperatorCollection lpnViewCriteria = new CriteriaOperatorCollection();
if (((int?)itemLookUpEdit.EditValue).HasValue && ((int?)locationLookUpEdit.EditValue).HasValue)
{
lpnViewCriteria.Add(new BinaryOperator(LocationInventoryByLot.Fields.LocationInventoryItem.ItemID.PropertyName, Convert.ToInt32(itemLookUpEdit.EditValue), BinaryOperatorType.Equal));
lpnViewCriteria.Add(new BinaryOperator(LocationInventoryByLot.Fields.Location.Oid.PropertyName, Convert.ToInt32(locationLookUpEdit.EditValue), BinaryOperatorType.Equal));
lpnXpView.Criteria = CriteriaOperator.And(lpnViewCriteria);
}
}
private void AddUsedInProductiontoSummary(DateTime?fromDate, DateTime?toDate, int currentItem)
{
CriteriaOperatorCollection theCriteria = new CriteriaOperatorCollection();
if (fromDate.HasValue)
{
theCriteria.Add(new BinaryOperator("InventoryBOMInventoryID.InventoryDate", fromDate.Value, BinaryOperatorType.GreaterOrEqual));
}
if (toDate.HasValue)
{
theCriteria.Add(new BinaryOperator("InventoryBOMInventoryID.InventoryDate", toDate.Value, BinaryOperatorType.LessOrEqual));
}
theCriteria.Add(new BinaryOperator("InventoryBOMRawMatID", currentItem, BinaryOperatorType.Equal));
transactionSummary.UsedInProduction = Convert.ToDouble(Session.DefaultSession.Evaluate(typeof(InventoryBOMs), CriteriaOperator.Parse("Sum((InventoryBOMQuantity + InventoryBOMQuantity * (ScrapFactor)) * InventoryBOMInventoryID.InventoryQuantity * -1)"), CriteriaOperator.And(theCriteria)));
}
private void AddProductionToSummary(DateTime?fromDate, DateTime?toDate, int currentItem)
{
CriteriaOperatorCollection theCriteria = new CriteriaOperatorCollection();
if (fromDate.HasValue)
{
theCriteria.Add(new BinaryOperator("InventoryDate", fromDate.Value, BinaryOperatorType.GreaterOrEqual));
}
if (toDate.HasValue)
{
theCriteria.Add(new BinaryOperator("InventoryDate", toDate.Value, BinaryOperatorType.LessOrEqual));
}
theCriteria.Add(new BinaryOperator("InventoryItemID", currentItem, BinaryOperatorType.Equal));
transactionSummary.Produced = Convert.ToDouble(Session.DefaultSession.Evaluate(typeof(Inventory), CriteriaOperator.Parse("Sum(InventoryQuantity)"), CriteriaOperator.And(theCriteria)));
}
private void AddAdjustmentsToSummary(DateTime?fromDate, DateTime?toDate, int currentItem)
{
CriteriaOperatorCollection theCriteria = new CriteriaOperatorCollection();
if (fromDate.HasValue)
{
theCriteria.Add(new BinaryOperator("AdjustmentDate", fromDate.Value, BinaryOperatorType.GreaterOrEqual));
}
if (toDate.HasValue)
{
theCriteria.Add(new BinaryOperator("AdjustmentDate", toDate.Value, BinaryOperatorType.LessOrEqual));
}
theCriteria.Add(new BinaryOperator("AdjustmentItem", currentItem, BinaryOperatorType.Equal));
transactionSummary.Adjusted = Convert.ToDouble(Session.DefaultSession.Evaluate(typeof(InventoryAdjustment), CriteriaOperator.Parse("Sum(NewCount) - Sum(OriginalQuantity)"), CriteriaOperator.And(theCriteria)));
}
public static void Esit(this CriteriaOperatorCollection list, string alan, TextBox textBox)
{
if (!string.IsNullOrWhiteSpace(textBox.Text))
{
list.Add(new BinaryOperator(alan, textBox.Text));
}
}
public static void IleBaslayan(this CriteriaOperatorCollection list, string alan, TextBox textBox)
{
if (!string.IsNullOrWhiteSpace(textBox.Text))
{
list.Add(new BinaryOperator(alan, textBox.Text + "%", BinaryOperatorType.Like));
}
}
private CriteriaOperatorCollection GetOperatorCollection(string fields, DataTable dataTable)
{
var operatorCollection = new CriteriaOperatorCollection();
foreach (string property in fields.Split(';'))
{
if (property != "" && property.IndexOf("!") == -1 && property != "This")
{
XPMemberInfo xpMemberInfo = ReflectorHelper.GetXpMemberInfo(Session, ObjectType, property);
if (xpMemberInfo.IsPersistent)
{
operatorCollection.Add(CriteriaOperator.Parse(property, new object[0]));
var dataColumn = new DataColumn(property)
{
DataType = xpMemberInfo.MemberType
};
if (typeof(XPBaseObject).IsAssignableFrom(dataColumn.DataType))
{
dataColumn.DataType = Session.GetClassInfo(dataColumn.DataType).KeyProperty.MemberType;
}
dataTable.Columns.Add(dataColumn);
if (property == ObjectClassInfo.KeyProperty.Name)
{
dataTable.PrimaryKey = new[] { dataColumn }
}
;
}
}
}
return(operatorCollection);
}
private static FunctionOperator createOperandValue(object requiredValue, FunctionOperatorType operatorType)
{
CriteriaOperatorCollection operands = new CriteriaOperatorCollection();
OperandValue operandValue = new OperandValue(requiredValue);
operands.Add(operandValue);
return(new FunctionOperator(operatorType, operands));
}
private IEnumerable <Classroom> GetByCriteria(
Guid addressOid,
IEnumerable <string> equipmentElements,
SeatingType?seating = default(SeatingType?),
int?capacity = default(int?))
{
var criteria = new CriteriaOperatorCollection();
if (addressOid != Guid.Empty)
{
criteria.Add(
new BinaryOperator("Address", addressOid, BinaryOperatorType.Equal)
);
}
if (equipmentElements?.Any() ?? false)
{
criteria.Add(CriteriaOperator.Or(
equipmentElements.Select(e => new BinaryOperator(
"AdditionalInfo",
$"%{e}%",
BinaryOperatorType.Like
))
));
}
if (capacity.HasValue)
{
criteria.Add(
new BinaryOperator(
"Capacity",
capacity.Value,
BinaryOperatorType.GreaterOrEqual
)
);
}
if (seating.HasValue)
{
criteria.Add(new BinaryOperator("SeatingType", seating.Value));
}
return(criteria.Any() ?
new XPCollection <Classroom>(session, CriteriaOperator.And(criteria)) :
new XPCollection <Classroom>(session));
}
private static FunctionOperator createOperandProperty(string property, FunctionOperatorType operatorType)
{
CriteriaOperatorCollection operands = new CriteriaOperatorCollection();
OperandProperty propertyOperand = new OperandProperty(property);
operands.Add(propertyOperand);
return(new FunctionOperator(operatorType, operands));
}
public static void BuyukOlanlarByte(this CriteriaOperatorCollection list, string alan, TextBox textBox)
{
byte deger;
if (byte.TryParse(textBox.Text, out deger))
{
list.Add(new BinaryOperator(alan, deger, BinaryOperatorType.GreaterOrEqual));
}
}
public static void TarihAra(this CriteriaOperatorCollection list, string alan, DateTimePicker date)
{
DateTime deger;
if (DateTime.TryParse(Convert.ToString(date.Value.Date), out deger))
{
return;
}
list.Add(new BinaryOperator(alan, deger, BinaryOperatorType.Equal));
}
public static bool IsMultiLPN(Session session, int LPNNumber, int customerID, DateTime inventoryDate)
{
CriteriaOperatorCollection filter = new CriteriaOperatorCollection();
filter.Add(new BinaryOperator("InventoryDate", inventoryDate, BinaryOperatorType.Equal));
filter.Add(new BinaryOperator(Inventory.Fields.InventoryItemID.ItemCustomerID.CustomerID.PropertyName, customerID, BinaryOperatorType.Equal));
filter.Add(new BinaryOperator("LPNNumber", LPNNumber, BinaryOperatorType.Equal));
int?LPNCount = (int?)session.Evaluate <Inventory>(new AggregateOperand("", "InventoryQuantity", Aggregate.Count), new GroupOperator(GroupOperatorType.And, filter));
if (LPNCount.HasValue && LPNCount.Value > 1)
{
return(true);
}
else
{
return(false);
}
}
private void FilterLpns()
{
CriteriaOperatorCollection lpnViewCriteria = new CriteriaOperatorCollection();
if (fromLocationLookUpEdit.EditValue != null)
{
lpnViewCriteria.Add(new BinaryOperator(LocationInventoryByLot.Fields.Location.Oid.PropertyName, Convert.ToInt32(fromLocationLookUpEdit.EditValue), BinaryOperatorType.Equal));
}
autochange = true;
lpnViewCriteria.Add(new BinaryOperator(LocationInventoryByLot.Fields.LocationInventoryItem.ItemID.PropertyName, transferDetailsGridView.GetFocusedRowCellValue(transferItemGridColumn), BinaryOperatorType.Equal));
LPNxpView.Criteria = CriteriaOperator.And(lpnViewCriteria);
if (LPNxpView.Count == 1)
{
transferDetailsGridView.SetFocusedRowCellValue(fullLpnNumberGridColumn, LPNxpView[0]["LPN"]);
}
autochange = false;
}
public static bool IsUniqueConstrauntViolated <T>(this T prmValue, params string[] prmUniqueFields) where T : XPObject
{
var operands = new CriteriaOperatorCollection();
Array.ForEach(prmUniqueFields, property => operands.Add(new BinaryOperator(new OperandProperty(property),
new OperandValue(prmValue.ClassInfo.GetMember(property).GetValue(prmValue)), BinaryOperatorType.Equal)));
CriteriaOperator keyCondition = new NotOperator(new BinaryOperator(prmValue.ClassInfo.KeyProperty.Name,
prmValue.ClassInfo.KeyProperty.GetValue(prmValue)));
return(prmValue.Session.FindObject <T>(PersistentCriteriaEvaluationBehavior.InTransaction,
new GroupOperator(new GroupOperator(GroupOperatorType.And, operands), keyCondition)) != null);
}
private void FilterLots()
{
CriteriaOperatorCollection lotViewCriteria = new CriteriaOperatorCollection();
if (((int?)lpnLookUpEdit.EditValue).HasValue)
{
lotViewCriteria.Add(new BinaryOperator(LocationInventoryByLot.Fields.LPNNumber.PropertyName, Convert.ToInt32(lpnLookUpEdit.EditValue), BinaryOperatorType.Equal));
LotXpView.Criteria = CriteriaOperator.And(lotViewCriteria);
LotXpView.Reload();
}
}
private void AddReceivingsToSumary(DateTime?fromDate, DateTime?toDate, int currentItem)
{
double total = 0;
CriteriaOperatorCollection theCriteria = new CriteriaOperatorCollection();
if (fromDate.HasValue)
{
theCriteria.Add(new BinaryOperator("ReceivMainID.ReceivDate", fromDate.Value, BinaryOperatorType.GreaterOrEqual));
}
if (toDate.HasValue)
{
theCriteria.Add(new BinaryOperator("ReceivMainID.ReceivDate", toDate.Value, BinaryOperatorType.LessOrEqual));
}
theCriteria.Add(new BinaryOperator("ReceivDetItemID", currentItem, BinaryOperatorType.Equal));
total = Convert.ToDouble(Session.DefaultSession.Evaluate(typeof(ReceivingDetail), CriteriaOperator.Parse("Sum(intUnits)"), CriteriaOperator.And(theCriteria)));
theCriteria.Clear();
if (fromDate.HasValue)
{
theCriteria.Add(new BinaryOperator("ReceiveMainID.ReceivDate", fromDate.Value, BinaryOperatorType.GreaterOrEqual));
}
if (toDate.HasValue)
{
theCriteria.Add(new BinaryOperator("ReceiveMainID.ReceivDate", toDate.Value, BinaryOperatorType.LessOrEqual));
}
theCriteria.Add(new BinaryOperator("ReturnDetItemID", currentItem, BinaryOperatorType.Equal));
total += Convert.ToDouble(Session.DefaultSession.Evaluate(typeof(ReceivedReturns), CriteriaOperator.Parse("Sum(ReturnDetQty)"), CriteriaOperator.And(theCriteria)));
transactionSummary.Received = total;
}
public void FillProductionView()
{
CriteriaOperatorCollection productionViewCriteria = new CriteriaOperatorCollection();
if (((DateTime?)fromFilterDateEdit.EditValue).HasValue)
{
productionViewCriteria.Add(new BinaryOperator(Production.Fields.ProdMainDate.PropertyName, Convert.ToDateTime(fromFilterDateEdit.EditValue), BinaryOperatorType.GreaterOrEqual));
}
if (((DateTime?)toFilterDateEdit.EditValue).HasValue)
{
productionViewCriteria.Add(new BinaryOperator(Production.Fields.ProdMainDate.PropertyName, Convert.ToDateTime(toFilterDateEdit.EditValue), BinaryOperatorType.LessOrEqual));
}
if (((int?)customerFilterLookUpEdit.EditValue).HasValue)
{
productionViewCriteria.Add(new BinaryOperator(Production.Fields.ProdMainItemID.ItemCustomerID.CustomerID.PropertyName, Convert.ToInt32(customerFilterLookUpEdit.EditValue), BinaryOperatorType.Equal));
}
if (((int?)shiftFilterLookUpEdit.EditValue).HasValue)
{
productionViewCriteria.Add(new BinaryOperator(Production.Fields.ProdMainShift.ShiftID.PropertyName, Convert.ToInt32(shiftFilterLookUpEdit.EditValue), BinaryOperatorType.Equal));
}
if (((int?)machineFilterLookUpEdit.EditValue).HasValue)
{
productionViewCriteria.Add(new BinaryOperator(Production.Fields.ProdMainMachineLine.MachineLineID.PropertyName, Convert.ToInt32(machineFilterLookUpEdit.EditValue), BinaryOperatorType.Equal));
}
if (((int?)itemFilterLookUpEdit.EditValue).HasValue)
{
productionViewCriteria.Add(new BinaryOperator(Production.Fields.ProdMainItemID.ItemID.PropertyName, Convert.ToInt32(itemFilterLookUpEdit.EditValue), BinaryOperatorType.Equal));
}
productionXPView.Criteria = CriteriaOperator.And(productionViewCriteria);
}
private static CriteriaOperatorCollection RemoveEmptyOperands(CriteriaOperatorCollection source)
{
CriteriaOperatorCollection result = new CriteriaOperatorCollection();
foreach (CriteriaOperator operand in source)
{
if (!IsNull(operand))
{
result.Add(operand);
}
}
return(result);
}
public static bool IsLPNShipped(string fullLPNNumber, int customerID, Session DXSession)
{
if (!fullLPNNumber.StartsWith(CustomersBLL.GetLPNPrefix(customerID)))
{
fullLPNNumber = CustomersBLL.GetLPNPrefix(customerID) + ("0000000000" + fullLPNNumber).Substring(("0000000000" + fullLPNNumber).Length - CustomersBLL.GetCustomer(customerID, DXSession).LastLPNNumber.ToString().Length);
}
CriteriaOperatorCollection filter = new CriteriaOperatorCollection();
filter.Add(new BinaryOperator(ShipDet.Fields.ShipDetMainID.ShipMainCustID.CustomerID.PropertyName, customerID, BinaryOperatorType.Equal));
filter.Add(new BinaryOperator(ShipDet.Fields.FullLPNNumber.PropertyName, fullLPNNumber, BinaryOperatorType.Equal));
int?LPNCount = (int?)XpoDefault.Session.Evaluate <ShipDet>(new AggregateOperand("", "FullLPNNumber", Aggregate.Count), new GroupOperator(GroupOperatorType.And, filter));
if (LPNCount.HasValue && LPNCount.Value >= 1)
{
return(true);
}
else
{
return(false);
}
}
protected CriteriaOperatorCollection VisitOperands(CriteriaOperatorCollection operands)
{
bool isModified = false;
CriteriaOperatorCollection result = new CriteriaOperatorCollection(operands.Count);
foreach (CriteriaOperator operand in operands)
{
CriteriaOperator acceptedOperand = this.AcceptOperator(operand);
result.Add(acceptedOperand);
if (!object.ReferenceEquals(operand, acceptedOperand))
{
isModified = true;
}
}
return(isModified ? result : operands);
}
public static CriteriaOperator GetAndCriteria(params CriteriaOperator[] operators)
{
CriteriaOperatorCollection operatorCollection = new CriteriaOperatorCollection();
foreach (CriteriaOperator op in operators)
{
if (!Equals(op, null))
{
operatorCollection.Add(op);
}
}
if (operatorCollection.Count == 0)
{
return(null);
}
if (operatorCollection.Count == 1)
{
return(operatorCollection[0]);
}
return(GetANDCriteria(operatorCollection));
}
// Простая выборка полей по указанному запросу
private SelectStatementResult SelectSimple(string sql, string parameterName, object parameterValue, params string[] columnNames)
{
StringCollection parametersNames = new StringCollection();
parametersNames.Add(parameterName);
CriteriaOperatorCollection selectFields = new CriteriaOperatorCollection(columnNames.Length);
foreach (string columnName in columnNames)
selectFields.Add(new QueryOperand(columnName, null));
Query query = new Query(sql, new QueryParameterCollection(new OperandValue(parameterValue)), parametersNames);
return SelectData(query, selectFields);
}
private SelectStatementResult SelectData(Query query, CriteriaOperatorCollection targets)
{
if (query.ConstantValues != null && query.OperandIndexes != null && query.ConstantValues.Count > 0)
{
CriteriaOperatorCollection customTargets = new CriteriaOperatorCollection();
if (query.OperandIndexes.Count == 0)
{
customTargets.Add(new OperandValue(1));
}
else
{
CriteriaOperator[] trgts = new CriteriaOperator[query.OperandIndexes.Count];
for (int i = 0; i < targets.Count; i++)
{
if (query.OperandIndexes.ContainsKey(i))
{
trgts[query.OperandIndexes[i]] = targets[i];
}
}
customTargets.AddRange(trgts);
}
SelectStatementResult queryResult = SelectDataSimple(query, customTargets, false)[0];
SelectStatementResultRow[] rows = new SelectStatementResultRow[queryResult.Rows.Length];
for (int ri = 0; ri < rows.Length; ri++)
{
object[] values = new object[targets.Count];
for (int i = 0; i < targets.Count; i++)
{
if (query.OperandIndexes.ContainsKey(i))
{
values[i] = queryResult.Rows[ri].Values[query.OperandIndexes[i]];
}
else
{
values[i] = query.ConstantValues[i].Value;
}
}
rows[ri] = new SelectStatementResultRow(values);
}
return new SelectStatementResult(rows);
}
return SelectDataSimple(query, targets, false)[0];
}
private void PrintLpnSimpleButton_Click(object sender, EventArgs e)
{
int digits = CustomersBLL.GetCustomer(7, m_LocationSession).LastLPNNumber.ToString().Length;
XPView lpnXPview = null;
CriteriaOperatorCollection critaria = new CriteriaOperatorCollection();
lpnXPview = new XPView(m_LocationSession, typeof(LocationInventoryByLot));
if (inventoryByLotGridView.GroupCount > 0)
{
int i = -1;
while (inventoryByLotGridView.IsValidRowHandle(i))
{
if (inventoryByLotGridView.GetChildRowHandle(i, 0) > -1)
{
//INSTANT C# NOTE: The ending condition of VB 'For' loops is tested only on entry to the loop. Instant C# has created a temporary variable in order to use the initial value of inventoryByLotGridView.GetChildRowCount(i) + inventoryByLotGridView.GetChildRowHandle(i, 0) for every iteration:
int tempVar = inventoryByLotGridView.GetChildRowCount(i) + inventoryByLotGridView.GetChildRowHandle(i, 0);
for (int ci = inventoryByLotGridView.GetChildRowHandle(i, 0); ci < tempVar; ci++)
{
if (inventoryByLotGridView.IsRowVisible(ci) == RowVisibleState.Visible)
{
int? lpn = Utilities.ChangeType <int?>(inventoryByLotGridView.GetRowCellValue(ci, colLPNNumber));
string lot = inventoryByLotGridView.GetRowCellValue(ci, colLot).ToString();
if (lpn.HasValue && lot.Length > 0)
{
critaria.Add(new GroupOperator(GroupOperatorType.And, new BinaryOperator("LPNNumber", lpn.Value, BinaryOperatorType.Equal), new BinaryOperator("LocationInventoryLot", lot, BinaryOperatorType.Equal)));
}
}
}
}
i -= 1;
}
}
else
{
for (int ci = 0; ci < inventoryByLotGridView.RowCount; ci++)
{
if (inventoryByLotGridView.IsRowVisible(ci) == RowVisibleState.Visible)
{
int? lpn = Utilities.ChangeType <int?>(inventoryByLotGridView.GetRowCellValue(ci, colLPNNumber));
string lot = inventoryByLotGridView.GetRowCellValue(ci, colLot).ToString();
if (lpn.HasValue && lot.Length > 0)
{
critaria.Add(new GroupOperator(GroupOperatorType.And, new BinaryOperator("LPNNumber", lpn.Value, BinaryOperatorType.Equal), new BinaryOperator("LocationInventoryLot", lot, BinaryOperatorType.Equal)));
}
}
}
}
lpnXPview.Criteria = CriteriaOperator.Or(critaria);
lpnXPview.Properties.AddRange(new ViewProperty[]
{
new ViewProperty("Item", SortDirection.None, "[LocationInventoryItem.ItemCode]", false, true),
new ViewProperty("ItemDesc", SortDirection.None, "[LocationInventoryItem.ItemDescription]", false, true),
new ViewProperty("Allergens", SortDirection.None, "[LocationInventoryItem.Allergens]", false, true),
new ViewProperty("Qty", SortDirection.None, "[QuantityOnHand]", false, true),
new ViewProperty("Expr", SortDirection.None, "[ExpirationDate]", false, true),
new ViewProperty("Lot", SortDirection.None, "[LocationInventoryLot]", false, true),
new ViewProperty("LPN", SortDirection.Ascending, "[LPNNumber]", false, true)
});
LPNLabelsXtraReport labels = new LPNLabelsXtraReport();
labels.DataSource = lpnXPview;
labels.lpnGroupHeader.GroupFields.Add(new GroupField("LPN", XRColumnSortOrder.Ascending));
labels.itemCodeXrLabel.DataBindings.Add("Text", lpnXPview, "Item");
labels.itemDescXrLabel.DataBindings.Add("Text", lpnXPview, "ItemDesc");
labels.AllergensXrLabel.ExpressionBindings.Add(new ExpressionBinding("BeforePrint", "Text", "Iif(Len(Trim([Allergens]))>0,'Allergens: ' + [Allergens],'Allergens: None')"));
labels.exprXrLabel.DataBindings.Add("Text", lpnXPview, "Expr", "{0:MM/dd/yyyy}");
labels.qtyXrLabel.DataBindings.Add("Text", lpnXPview, "Qty");
labels.lotXrLabel.DataBindings.Add("Text", lpnXPview, "Lot");
labels.LPNXrBarCode.DataBindings.Add("Text", lpnXPview, "LPN", "SPG{0:D" + digits + "}");
labels.SumQtyXrLabel.ExpressionBindings.Add(new ExpressionBinding("BeforePrint", "Text", "sumSum([Qty])"));
labels.ReprintXrLabel.Visible = true;
labels.CreateDocument();
labels.ShowPreviewDialog();
}
public static XPView GetCurrentInventoryReport(int?customerID, string itemType, string items, bool?inactiveItems, bool?inactiveCustomers, bool?outOfStockItems, bool onlyAssignedCustomers, int?locationID)
{
XPView CurrentInventoryReportXPView = new XPView(Session.DefaultSession, typeof(LocationInventory));
CriteriaOperatorCollection theCriteria = new CriteriaOperatorCollection();
if (customerID.HasValue)
{
theCriteria.Add(new BinaryOperator(LocationInventory.Fields.LocationInventoryItem.ItemCustomerID.CustomerID.PropertyName, customerID.Value, BinaryOperatorType.Equal));
}
if (string.IsNullOrEmpty(itemType) == false)
{
theCriteria.Add(new BinaryOperator(LocationInventory.Fields.LocationInventoryItem.ItemType.PropertyName, itemType, BinaryOperatorType.Equal));
}
if (inactiveCustomers.Value == false)
{
theCriteria.Add(new BinaryOperator(LocationInventory.Fields.LocationInventoryItem.ItemCustomerID.Inactive.PropertyName, false));
}
if (inactiveItems.Value == false)
{
theCriteria.Add(new BinaryOperator(LocationInventory.Fields.LocationInventoryItem.Inactive.PropertyName, false));
}
if (string.IsNullOrEmpty(items) == false)
{
theCriteria.Add(new InOperator(LocationInventory.Fields.LocationInventoryItem.ItemID.PropertyName, items.Split('|')));
}
if (outOfStockItems.HasValue == false || outOfStockItems == false)
{
theCriteria.Add(new BinaryOperator(LocationInventory.Fields.QuantityOnHand.PropertyName, 1, BinaryOperatorType.GreaterOrEqual));
}
if (onlyAssignedCustomers == true)
{
theCriteria.Add(new InOperator(LocationInventory.Fields.LocationInventoryItem.ItemCustomerID.CustomerID.PropertyName, UsersCustomerBLL.GetAssignedCustomerIDs(XpoDefault.Session)));
}
if (locationID.HasValue)
{
theCriteria.Add(new BinaryOperator(LocationInventory.Fields.Location.Oid.PropertyName, locationID.Value, BinaryOperatorType.Equal));
}
try
{
CurrentInventoryReportXPView.Criteria = CriteriaOperator.And(theCriteria);
CurrentInventoryReportXPView.Properties.AddRange(new ViewProperty[]
{
new ViewProperty("CustomerName", SortDirection.Ascending, LocationInventory.Fields.LocationInventoryItem.ItemCustomerID.CustomerName.PropertyName, false, true),
new ViewProperty("ItemCode", SortDirection.Ascending, LocationInventory.Fields.LocationInventoryItem.ItemCode.PropertyName, false, true),
new ViewProperty("ItemDescription", SortDirection.None, LocationInventory.Fields.LocationInventoryItem.ItemDescription.PropertyName, false, true),
new ViewProperty("ItemType", SortDirection.None, CriteriaOperator.Parse(string.Format("IIF({0} = 'RM', 'Raw Material', IIF({0} = 'IG', 'Intermediate Goods', 'Finished Goods'))", LocationInventory.Fields.LocationInventoryItem.ItemType.PropertyName)), false, true),
new ViewProperty("QuantityOnHand", SortDirection.None, LocationInventory.Fields.QuantityOnHand.PropertyName, false, true),
new ViewProperty("InventoryByPallets", SortDirection.None, CriteriaOperator.Parse(string.Format("IIF({1} = 0, 0, {0} / {1})", LocationInventory.Fields.QuantityOnHand.PropertyName, LocationInventory.Fields.LocationInventoryItem.intUnitsPerPallet.PropertyName)), false, true),
new ViewProperty("UOM", SortDirection.None, LocationInventory.Fields.LocationInventoryItem.strUnitOfMeasure.PropertyName, false, true),
new ViewProperty("Location", SortDirection.None, LocationInventory.Fields.Location.LocationCode.PropertyName, false, true),
new ViewProperty("InactiveCustomer", SortDirection.None, LocationInventory.Fields.LocationInventoryItem.ItemCustomerID.Inactive.PropertyName, false, true),
new ViewProperty("InactiveItem", SortDirection.None, LocationInventory.Fields.LocationInventoryItem.Inactive.PropertyName, false, true)
});
return(CurrentInventoryReportXPView);
}
catch (ArgumentException ex)
{
MessageBox.Show(string.Format("There was an error while trying to retrieve the data for the report.{0}{1}", Environment.NewLine, ex.Message));
}
return(null);
}
private CriteriaOperatorCollection GetOperatorCollection(string fields, DataTable dataTable)
{
var operatorCollection = new CriteriaOperatorCollection();
foreach (string property in fields.Split(';'))
if (property != "" && property.IndexOf("!") == -1 && property != "This")
{
XPMemberInfo xpMemberInfo = ReflectorHelper.GetXpMemberInfo(Session, ObjectType, property);
if (xpMemberInfo.IsPersistent)
{
operatorCollection.Add(CriteriaOperator.Parse(property, new object[0]));
var dataColumn = new DataColumn(property) {DataType = xpMemberInfo.MemberType};
if (typeof (XPBaseObject).IsAssignableFrom(dataColumn.DataType))
dataColumn.DataType = Session.GetClassInfo(dataColumn.DataType).KeyProperty.MemberType;
dataTable.Columns.Add(dataColumn);
if (property == ObjectClassInfo.KeyProperty.Name)
dataTable.PrimaryKey = new[] {dataColumn};
}
}
return operatorCollection;
}
public static XPView GetShippingReturnsReport(DateTime?fromDate, DateTime?toDate, int?shiftID, int?customerID, string lot, string BOL, int?destinationID, int?carrierID, string items, bool?inactiveItems, bool?inactiveCustomers, bool onlyAssignedCustomers)
{
XPView ShippingReturnsReportXPView = new XPView(Session.DefaultSession, typeof(ShippedReturns));
CriteriaOperatorCollection theCriteria = new CriteriaOperatorCollection();
if (fromDate.HasValue)
{
theCriteria.Add(new BinaryOperator("ShipMainID.ShipMainDate", fromDate.Value, BinaryOperatorType.GreaterOrEqual));
}
if (toDate.HasValue)
{
theCriteria.Add(new BinaryOperator("ShipMainID.ShipMainDate", toDate.Value, BinaryOperatorType.LessOrEqual));
}
if (string.IsNullOrEmpty(BOL) == false)
{
theCriteria.Add(new BinaryOperator("ShipMainID.ShipMainBOL", BOL, BinaryOperatorType.Equal));
}
//If String.IsNullOrEmpty(po) = False Then
// theCriteria.Add(New BinaryOperator("ShipMainID.strPO", po, BinaryOperatorType.Equal))
//End If
//If String.IsNullOrEmpty(deliveryNoteNumber) = False Then
// theCriteria.Add(New BinaryOperator("ShipMainID.DeliveryNoteNumber", deliveryNoteNumber, BinaryOperatorType.Equal))
//End If
if (shiftID.HasValue)
{
theCriteria.Add(new BinaryOperator("ShipMainID.Shift", shiftID.Value, BinaryOperatorType.Equal));
}
if (customerID.HasValue)
{
theCriteria.Add(new BinaryOperator("ShipMainID.ShipMainCustID", customerID.Value, BinaryOperatorType.Equal));
}
if (carrierID.HasValue)
{
theCriteria.Add(new BinaryOperator("ShipMainID.ShipMainCarrierID", carrierID.Value, BinaryOperatorType.Equal));
}
if (destinationID.HasValue)
{
theCriteria.Add(new BinaryOperator("ShipMainID.intDestination", destinationID.Value, BinaryOperatorType.Equal));
}
if (string.IsNullOrEmpty(lot) == false)
{
theCriteria.Add(new BinaryOperator("ReturnDetLot", lot, BinaryOperatorType.Equal));
}
if (inactiveCustomers.Value == false)
{
theCriteria.Add(new BinaryOperator("ShipMainID.ShipMainCustID.Inactive", false));
}
if (inactiveItems.Value == false)
{
theCriteria.Add(new BinaryOperator("ReturnDetItemID.Inactive", false));
}
if (string.IsNullOrEmpty(items) == false)
{
theCriteria.Add(new InOperator("ReturnDetItemID", items.Split('|')));
}
if (onlyAssignedCustomers == true)
{
theCriteria.Add(new InOperator("ShipMainID.ShipMainCustID", UsersCustomerBLL.GetAssignedCustomerIDs(XpoDefault.Session)));
}
try
{
ShippingReturnsReportXPView.Criteria = CriteriaOperator.And(theCriteria);
ShippingReturnsReportXPView.Properties.AddRange(new ViewProperty[]
{
new ViewProperty("ShipMainDate", SortDirection.Ascending, "[ShipMainID].[ShipMainDate]", false, true),
new ViewProperty("ShiftName", SortDirection.None, "[ShipMainID].[Shift].[ShiftName]", false, true),
new ViewProperty("CustomerName", SortDirection.Ascending, "[ShipMainID].[ShipMainCustID].[CustomerName]", false, true),
new ViewProperty("ShipMainBOL", SortDirection.None, "[ShipMainID].[ShipMainBOL]", false, true),
new ViewProperty("strPO", SortDirection.None, "[ShipMainID].[strPO]", false, true),
new ViewProperty("DeliveryNoteNumber", SortDirection.None, "[ShipMainID].[DeliveryNoteNumber]", false, true),
new ViewProperty("ShippingName", SortDirection.None, "[ShipMainID].[intDestination].[ShippingName]", false, true),
new ViewProperty("ReturnDetLot", SortDirection.None, "[ReturnDetLot]", false, true),
new ViewProperty("ItemCode", SortDirection.Ascending, "[ReturnDetItemID].[ItemCode]", false, true),
new ViewProperty("ItemDescription", SortDirection.None, "[ReturnDetItemID].[ItemDescription]", false, true),
new ViewProperty("intUnits", SortDirection.None, "[intUnits]", false, true),
new ViewProperty("CarrierName", SortDirection.None, "[ShipMainID].[ShipMainCarrierID].[CarrierName]", false, true),
new ViewProperty("strTrailer", SortDirection.None, "[ShipMainID].[strTrailer]", false, true),
new ViewProperty("strSeal", SortDirection.None, "[ShipMainID].[strSeal]", false, true),
new ViewProperty("ExpirationDate", SortDirection.None, "[ExpirationDate]", false, true),
new ViewProperty("ExpirationDateFormat", SortDirection.None, "[ShipMainID].[ShipMainCustID].[ExpirationDateFormat]", false, true)
});
return(ShippingReturnsReportXPView);
}
catch (ArgumentException ex)
{
MessageBox.Show(string.Format("There was an error while trying to retrieve the data for the report.{0}{1}", Environment.NewLine, ex.Message));
}
return(null);
}
public ItemTransactionSummaryList GetItemTransactionSummaryReport(DateTime?fromDate, DateTime?toDate, int?itemCustomerID, string items, string itemType, bool onlyAssigned)
{
if (fromDate.HasValue == false && toDate.HasValue == false && itemCustomerID.HasValue == false && string.IsNullOrEmpty(items))
{
return(null);
}
ItemTransactionSummaryList transactionsSummaryList = new ItemTransactionSummaryList();
try
{
XPView itemsXPView = null;
CriteriaOperatorCollection theCriteria = new CriteriaOperatorCollection();
if (itemCustomerID.HasValue)
{
theCriteria.Add(new BinaryOperator("ItemCustomerID", itemCustomerID.Value, BinaryOperatorType.Equal));
}
if (onlyAssigned)
{
theCriteria.Add(new InOperator("ItemCustomerID", UsersCustomerBLL.GetAssignedCustomerIDs(XpoDefault.Session)));
}
if (string.IsNullOrEmpty(itemType) == false)
{
theCriteria.Add(new BinaryOperator("ItemType", itemType, BinaryOperatorType.Equal));
}
if (string.IsNullOrEmpty(items) == false)
{
theCriteria.Add(new InOperator("ItemID", items.Split('|')));
}
itemsXPView = new XPView(Session.DefaultSession, typeof(Items))
{
Criteria = CriteriaOperator.And(theCriteria)
};
itemsXPView.Properties.Add(new ViewProperty("ItemID", SortDirection.None, "ItemID", false, true));
foreach (ViewRecord item in itemsXPView)
{
transactionSummary = new ItemTransactionSummary();
Items currentItem = Session.DefaultSession.GetObjectByKey <Items>(item["ItemID"]);
transactionSummary.CustomerName = currentItem.ItemCustomerID.CustomerName;
transactionSummary.ItemCode = currentItem.ItemCode;
transactionSummary.ItemDescription = currentItem.ItemDescription;
transactionSummary.ItemType = ((currentItem.ItemType == "RM") ? "Raw Material" : ((currentItem.ItemType == "IG") ? "Intermediate Goods" : "Finished Goods")).ToString();
AddReceivingsToSumary(fromDate, toDate, currentItem.ItemID);
AddShippingsToSummary(fromDate, toDate, currentItem.ItemID);
AddAdjustmentsToSummary(fromDate, toDate, currentItem.ItemID);
AddProductionToSummary(fromDate, toDate, currentItem.ItemID);
AddUsedInProductiontoSummary(fromDate, toDate, currentItem.ItemID);
if (transactionSummary.Received != 0 || transactionSummary.Produced != 0 || transactionSummary.Adjusted != 0 || transactionSummary.Shipped != 0 || transactionSummary.UsedInProduction != 0)
{
transactionsSummaryList.Add(transactionSummary);
}
}
}
catch (Exception ex)
{
MessageBox.Show(string.Format("There was an error while trying to retrieve the data for the report.{0}{1}", Environment.NewLine, ex.Message));
return(null);
}
return(transactionsSummaryList);
}
private static CriteriaOperatorCollection GetCriteria(this GridView gv)
{
var go = gv.ActiveFilterCriteria as GroupOperator;
if (ReferenceEquals(go, null))
{
if (!ReferenceEquals(gv.ActiveFilterCriteria, null))
{
var OpC = new CriteriaOperatorCollection();
OpC.Add(gv.ActiveFilterCriteria);
return OpC;
}
return null;
}
return go.Operands;
}