Пример #1
0
        private static List <Item> GetItems(string format)
        {
            List <Item>  items        = new List <Item>();
            DbDataReader dbDataReader = GetDbReader(CommandType.StoredProcedure, "ПрайсЭкспортБезДублей");

            while (dbDataReader.Read())
            {
                Item item = new Item();

                //item.Category = new Category(categories[(int)dbDataReader["Min-КодТипа"]]);
                if (format != "csv")
                {
                    item.Category = categoryDao.FindByNumber((int)dbDataReader["Min-КодТипа"]);
                }
                item.Date = dbDataReader["Min-СрокГодн"] != DBNull.Value
                                ? (DateTime?)dbDataReader["Min-СрокГодн"]
                                : null;
                item.ProductId  = (int)dbDataReader["Min-КодТовара"];
                item.Manufacter = (string)dbDataReader["Min-КраткоЗаводИ"];
                item.Name       = (string)dbDataReader["НаимПрайс"];
                item.Pack       = dbDataReader["Min-Упаковка"] != DBNull.Value
                                ? (string)dbDataReader["Min-Упаковка"]
                                : string.Empty;
                item.Price1 = (decimal)dbDataReader["Min-Цена1"];
                item.Price2 = (decimal)dbDataReader["Min-Цена2"];
                item.Price3 = (decimal)dbDataReader["Min-Цена3"];

                //item.ReceiptId = dbDataReader["Min-КодСтрокПрих"] != DBNull.Value
                //    ? (int?)dbDataReader["Min-КодСтрокПрих"]
                //    : null;

                object o = null;
                try
                {
                    o = dbDataReader["Sum-Sum_Расход"];
                    if (dbDataReader["Sum-Sum_Расход"] != DBNull.Value)
                    {
                        item.Rest = (int?)(double)dbDataReader["Sum-Sum_Расход"];
                    }
                    else
                    {
                        item.Rest = null;
                    }
                    //item.Rest = dbDataReader["Sum-Sum_Расход"] != DBNull.Value
                    //                    ? (int?)dbDataReader["Sum-Sum_Расход"]
                    //                    : null;
                }
                catch (Exception)
                {
                    Debug.Write(o.GetType());

                    if (dbDataReader["Sum-Sum_Расход"] != DBNull.Value)
                    {
                        double d = (double)dbDataReader["Sum-Sum_Расход"];
                        item.Rest = (int?)d;
                    }
                    else
                    {
                        item.Rest = null;
                    }
                    throw;
                }

                items.Add(item);
            }
            return(items);
        }