protected override void BindGrid()
{
using (var cmd = new SqlCommand())
{
cmd.CommandText = SelectAllFromTableWhereStatus;
if (IsFiltered)
{
var where = new SqlWhereStatement(false);
where.AddWhere("OrderDate", cboxDate.Text, true, ConvertHelper.ToDateTime(dateDate1.EditValue), ConvertHelper.ToDateTime(dateDate2.EditValue), DateTimePrecision.Days);
where.AddWhere("ActNumber", cboxActNumber.Text, true, txtActNumber.Text.Trim());
where.AddWhere("IssuedPerson", cboxIssuedPerson.Text, true, txtIssuedPerson.Text.Trim());
cmd.CommandText += where;
}
cmd.CommandText += " ORDER BY OrderDate DESC, ID DESC";
ds.VW_CashboxOrder.Clear();
ds.VW_CashboxOrder.Merge(DictionaryManager.GetDataTable(cmd));
}
}
protected override void BindGrid()
{
using (var cmd = new SqlCommand())
{
cmd.CommandText = SelectAllFromTableWhereStatus + " WHERE 1=1 ";
if (IsFiltered)
{
var where = new SqlWhereStatement(false);
where.AddWhere("PurchaseOrderID", cboxPurchaseOrderID.Text, true, txtPurchaseOrderID.Text.ToNullableInt32());
where.AddWhere("PurchaseOrderBranchID", WhereOperator.Equals, true, bbPurchaseOrderBranch.PrimaryKey);
where.AddWhere("PurchaseOrderDate", cboxPurchaseOrderDate.Text, true, ConvertHelper.ToNullableDateTime(datePurchaseOrderDate1.EditValue), ConvertHelper.ToNullableDateTime(datePurchaseOrderDate2.EditValue), DateTimePrecision.Days);
where.AddWhere("VendorID", cboxVendorID.Text, true, bbVendorID.PrimaryKey);
where.AddWhere("VendorName", cboxVendorName.Text, true, txtVendorName.Text.Trim());
where.AddWhere("SalesOrderID", cboxSalesOrderID.Text, true, txtSalesOrderID.Text.ToNullableInt32());
where.AddWhere("SalesOrderBranchID", WhereOperator.Equals, true, bbSalesOrderBranch.PrimaryKey);
//todo filter = FilterHelper.GetWhereClause("SalesOrderDate", cboxSalesOrderDate.Text, ConvertHelper.ToDateTime(dateSalesOrderDate1.EditValue), ConvertHelper.ToDateTime(dateSalesOrderDate2.EditValue), RoundingFormat.None, cmd);
//if (filter.Length > 0) cmd.CommandText += " AND " + filter;
//filter = FilterHelper.GetWhereClause("CustomerID", cboxCustomerID.Text, bbCustomerID.RecordValue);
//if (filter.Length > 0) cmd.CommandText += " AND " + filter;
//filter = FilterHelper.GetWhereClause("CustomerName", cboxCustomerName.Text, txtCustomerName.Text.Trim());
//if (filter.Length > 0) cmd.CommandText += " AND " + filter;
//filter = FilterHelper.GetWhereClause("ProductName", cboxProduct.Text, true, txtProduct.Text.Trim());
//if (filter.Length > 0) cmd.CommandText += " AND " + filter;
//filter = FilterHelper.GetWhereClause("ProductNumber", cboxProductNumber.Text, txtProductNumber.Text.Trim());
//if (filter.Length > 0) cmd.CommandText += " AND " + filter;
//filter = FilterHelper.GetWhereClause("ProductCurrencyCode", "=", lookCurrency.EditValue, SqlDbType.NChar, cmd);
//if (filter.Length > 0) cmd.CommandText += " AND " + filter;
cmd.CommandText += where;
}
cmd.CommandText += " ORDER BY SalesOrderDate DESC, SalesOrderID DESC";
ds.VW_SalesOrderDetailPivot.Clear();
ds.VW_SalesOrderDetailPivot.Merge(DictionaryManager.GetDataTable(cmd));
}
}
