public decimal Get_OutInOfStorage(string strWhere)
{
string strSql = @"select sum(DecQty) as DecQty from ZL_OutInOfStorage " + strWhere;
DecAmount value = _con.Query <DecAmount>(strSql).AsList().FirstOrDefault();
return(Convert.ToDecimal(value.DecQty));
}
public decimal Get_CirculationStock(string strWhere)
{
string strSql = @"select (sum(DecQtyNal)+sum(DecQtySeparPass)) as DecQty from ZL_CirculationStock " + strWhere;
DecAmount value = _con.Query <DecAmount>(strSql).AsList().FirstOrDefault();
return(Convert.ToDecimal(value.DecQty));
}