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