/// <summary> /// 获取门店总收益 /// </summary> /// <param name="storeId"></param> /// <returns></returns> public double GetEarnings(int storeId) { double sum = 0.00; if (storeId <= 0) { return(sum); } DishStoreEarnings earnings = DishStoreEarningsBLL.SingleModel.GetModelByStoreId(storeId); if (earnings == null) { return(sum); } sum = earnings.money; return(sum); }
public double GetEarningsByDate(int storeId, DateTime startDate, DateTime endDate) { double sum = 0.00; DishStoreEarnings earnings = DishStoreEarningsBLL.SingleModel.GetModelByStoreId(storeId); if (earnings == null) { return(sum); } string sql = $"select sum(changeMoney) from DishStoreEarningsDetails where seId={earnings.id} and addTime between @startDate and @endDate"; List <MySqlParameter> parames = new List <MySqlParameter>(); parames.Add(new MySqlParameter("@startDate", startDate)); parames.Add(new MySqlParameter("@endDate", endDate)); sum = SqlMySql.ExecuteScalar(connName, CommandType.Text, sql, parames.ToArray()) == DBNull.Value ? 0 : Convert.ToDouble(SqlMySql.ExecuteScalar(connName, CommandType.Text, sql, parames.ToArray())); return(sum); }