public double GetAmount(DateTime startDate, DateTime endDate)
{
DataSynchronizationStanbyLib.DataSetStanbyTableAdapters.HomeQueriesTableAdapter ad = new DataSynchronizationStanbyLib.DataSetStanbyTableAdapters.HomeQueriesTableAdapter();
//return (int)ad.TotalAmountQuery(startDate,endDate);
Nullable <Decimal> qty = ad.TotalAmountQuery(startDate, endDate);
if (qty.HasValue)
{
return((double)qty.Value);
}
return(0);
}
public int GetCT(DateTime startDate, DateTime endDate, string salesNO)
{
DataSynchronizationStanbyLib.DataSetStanbyTableAdapters.HomeQueriesTableAdapter ad = new DataSynchronizationStanbyLib.DataSetStanbyTableAdapters.HomeQueriesTableAdapter();
// return (int)ad.CtQuery(startDate, endDate, salesNO);
Nullable <Decimal> qty = ad.CtQuery(startDate, endDate, salesNO);
if (qty.HasValue)
{
return((int)qty.Value);
}
return(0);
}
public int GetQty(DateTime startDate, DateTime endDate)
{
DataSynchronizationStanbyLib.DataSetStanbyTableAdapters.HomeQueriesTableAdapter ad = new DataSynchronizationStanbyLib.DataSetStanbyTableAdapters.HomeQueriesTableAdapter();
Nullable <Decimal> qty = ad.TotalQtyQuery(startDate, endDate);
if (qty.HasValue)
{
return((int)qty.Value);
}
return(0);
}
