public virtual int _GetUniqueIdentifier()
{
var hashCode = 399326290;
hashCode = hashCode * -1521134295 + (Id?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (TotalUnits?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (Description?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (Result?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (LeadTime?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (WeekDay?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (StockOnHandDate?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (StockOnHand?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (OrderQuantity?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (SalesQuantity?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (QuantitySalesForecast?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (StockOnHandDateFormatted?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (SupplierStock?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (QuantitySum?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (SalesForecastDate?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (SalesForecastDateFormatted?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (Threshold?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (OrderDate?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (OrderDateFormatted?.GetHashCode() ?? 0);
hashCode = hashCode * -1521134295 + (RealOrderQuantity?.GetHashCode() ?? 0);
return(hashCode);
}
// 查询
public static List <SupplierStock> QuerySupplierStock(int id)
{
List <SupplierStock> supplierStocks = new List <SupplierStock>();
using (var statement = SqlUtil.conn.Prepare("SELECT S.s_id, S.s_name, B.b_id, B.b_name, B.b_author, SS.number, SS.price " +
"FROM supplier_stock SS, book B, supplier S " +
"WHERE SS.b_id = ? and SS.b_id = B.b_id and SS.s_id = S.s_id"))
{
statement.Bind(1, id);
while (SQLiteResult.ROW == statement.Step())
{
Supplier supplier = new Supplier {
SId = int.Parse(statement[0].ToString()), SName = (string)statement[1]
};
Book book = new Book {
BId = int.Parse(statement[2].ToString()), BName = (string)statement[3], BAuthor = (string)statement[4]
};
SupplierStock supplierStock = new SupplierStock {
Supplier = supplier, Book = book, Number = int.Parse(statement[5].ToString()), Price = float.Parse(statement[6].ToString())
};
supplierStocks.Add(supplierStock);
}
}
return(supplierStocks);
}
private void SearchId_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(BookIDBox.Text))
{
return;
}
BookDetail.Visibility = Visibility.Visible;
supplierStocks.Clear();
SupplierStockUtil.QuerySupplierStock(int.Parse(BookIDBox.Text)).ForEach(p => supplierStocks.Add(p));
if (supplierStocks.Count() > 0)
{
select = supplierStocks[0];
}
else
{
BookDetail.Visibility = Visibility.Collapsed;
}
}
private void SupplierList_ItemClick(object sender, ItemClickEventArgs e)
{
select = (SupplierStock)e.ClickedItem;
}
