Beispiel #1
0
        IList GetBusinessVolumeTargActSum(BVType businessVolumeType, DateTime begin, DateTime end, long storeID, long worldID)
        {
            List <BusinessVolumeTargActSum> result;
            string procName;
            string query;

            switch (businessVolumeType)
            {
            case BVType.Targeted:
                procName = "spBV_TargetedSumGet";
                break;

            case BVType.Actual:
                procName = "spBV_ActualSumGet";
                break;

            default:
                goto case BVType.Targeted;
            }

            if (worldID < 0)
            {
                query = string.Format("exec {0} '{1}', '{2}', {3}", procName, begin.ToString("yyyMMdd"), end.ToString("yyyMMdd"), storeID);
            }
            else
            {
                query = string.Format("exec {0} '{1}', '{2}', {3}, {4}", procName, begin.ToString("yyyMMdd"), end.ToString("yyyMMdd"), storeID, worldID);
            }
            using (IDataReader reader = getDataReader(query))
            {
                result = Map.ToList <BusinessVolumeTargActSum>(reader);
            }
            return(result);
        }
Beispiel #2
0
 IList GetBusinessVolumeTargActSum(BVType businessVolumeType, DateTime begin, DateTime end, long storeID)
 {
     return(GetBusinessVolumeTargActSum(businessVolumeType, begin, end, storeID, SharedConsts.CalculateAll));
 }