Biegral Blog

using System;
using AutoMapper;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;

namespace ConsoleApplication1
{
    class Program
    {

        private const string ConnStr = "Data Source=192.168.1.88;User Id=sa;Password=1234567890;Database=dbtest;Pooling=true;Max Pool Size=600;Min Pool Size=0;";
        static void Main(string[] args)
        {
            //automapper
            productDto dto = new productDto();
            dto.proId = 1000;
            dto.proName = "2016款最新秋季男式外套";

            //AddressDto到Address的映射，AddressDto的字段CountryName要对应Address的字段Country：
            //Mapper.CreateMap<AddressDto, Address>().ForMember(d => d.Country, opt => opt.MapFrom(s => s.CountryName));

            Mapper.Initialize(x => x.CreateMap<productDto, product>());
            var model = Mapper.Map<product>(dto);
            Console.WriteLine(string.Format("{0}-{1}-{2}-{3}-{4}", model.proId, model.Price, model.shortInfo, model.info, model.addDate));
            Console.ReadKey();

            JObject obj = new JObject();
            obj.Add("proId", "20000");
            obj.Add("proName", "品牌电脑");
            obj.Add("Price", "3600.00");
            //转换成json字符串
            string json = JsonConvert.SerializeObject(obj);
            Console.WriteLine(json);
            Console.ReadKey();
            //json字符串转换成对象 方式1
            var jsonObj = JObject.Parse(json); //JsonConvert.DeserializeObject(json);
            Console.WriteLine(string.Format("{0}-{1}-{2}", jsonObj["proId"], jsonObj["proName"], jsonObj["Price"]));
            Console.ReadKey();
            //json字符串转换成对象 方式2
            var jsonModel = JsonConvert.DeserializeObject(json);
            Console.WriteLine(string.Format("{0}-{1}-{2}", jsonObj["proId"], jsonObj["proName"], jsonObj["Price"]));
            Console.ReadKey();
            //json字符串转换成对象 方式3
            var proDto = JsonConvert.DeserializeObject<productDto>(json);
            Console.WriteLine(string.Format("{0}-{1}-{2}", proDto.proId, proDto.proName, proDto.Price));
            Console.ReadKey();
            /*
            Maticsoft.DBUtility.DbHelperSQL.connectionString = ConnStr;

            GetAllData();
            Console.ReadKey();

            AddData();
            Console.ReadKey();
            GetAllData();
            Console.ReadKey();

            UpdateData();
            Console.ReadKey();
            GetAllData();
            Console.ReadKey();

            GetQueryData();
            Console.ReadKey();

            DeleteData();
            Console.ReadKey();

            GetQueryData();
            Console.ReadKey();

            DeleteData2();
            Console.ReadKey();

            GetQueryData();
            Console.ReadKey();

            //事务处理
            using (TransactionScope scope = new TransactionScope())
            {
                scope.Complete();
            }
            */
        }

        private static void GetAllData()
        {
            Console.WriteLine("===============全部数据=================");
            //获取全部数据
            foreach (var item in Dec.BLL.GatherData.GetAllGatherDatas())
            {
                Console.WriteLine(string.Format("{0}-{1}-{2}-{3}-{4}-{5}-{6}", item.Url, item.SkuCode, item.Domain,
                    item.Lang, item.Currency, item.ProName, item.ProGroup));
            }
        }

        private static void GetQueryData()
        {
            Console.WriteLine("===============查询数据=================");
            //获取全部数据(搜索条件)
            Dec.Models.GatherData queryModel = new Dec.Models.GatherData();
            queryModel.Url = "22";
            queryModel.Domain = "44";
            foreach (var item in Dec.BLL.GatherData.GetAllGatherDatasByQuery(queryModel))
            {
                Console.WriteLine(string.Format("{0}-{1}-{2}-{3}-{4}-{5}-{6}", item.Url, item.SkuCode, item.Domain,
                    item.Lang, item.Currency, item.ProName, item.ProGroup));
            }
        }

        private static void AddData()
        {
            Console.WriteLine("===============新增数据=================");
            //新增数据
            Dec.Models.GatherData addModel = new Dec.Models.GatherData();
            addModel.Url = "22";
            addModel.SkuCode = "33";
            addModel.Domain = "44";

            addModel.Lang = "55";
            addModel.Currency = "66";
            addModel.ProName = "77";
            addModel.ProGroup = "88";
            int i = Dec.BLL.GatherData.Add(addModel);
            if (i > 0)
            {
                Console.WriteLine("插入成功");
            }
            else
            {
                Console.WriteLine("插入失败");
            }
        }

        private static void UpdateData()
        {
            Console.WriteLine("===============更新数据=================");
            //更新数据
            Dec.Models.GatherData updateModel = new Dec.Models.GatherData();
            updateModel.Id = 10000;
            updateModel.Url = "2222";
            updateModel.SkuCode = "3333";
            updateModel.Domain = "4444";

            updateModel.Lang = "5555";
            updateModel.Currency = "6666";
            updateModel.ProName = "7777";
            updateModel.ProGroup = "8888";
            bool flag = Dec.BLL.GatherData.Update(updateModel);
            if (flag)
            {
                Console.WriteLine("更新成功");
            }
            else
            {
                Console.WriteLine("更新失败");
            }
        }

        private static void DeleteData()
        {
            Console.WriteLine("===============删除数据=================");
            bool flag = Dec.BLL.GatherData.Delete(10000);
            if (flag)
            {
                Console.WriteLine("删除成功");
            }
            else
            {
                Console.WriteLine("删除失败");
            }
        }

        private static void DeleteData2()
        {
            Console.WriteLine("===============删除数据=================");
            //更新数据
            Dec.Models.GatherData updateModel = new Dec.Models.GatherData();
            updateModel.Url = "22";
            updateModel.SkuCode = "33";
            bool flag = Dec.BLL.GatherData.Delete(updateModel);
            if (flag)
            {
                Console.WriteLine("删除成功");
            }
            else
            {
                Console.WriteLine("删除失败");
            }
        }
    }

    public class productDto
    {
        public int proId { set; get; }
        public string proName { set; get; }
        public double Price { set; get; }
    }

    public class product
    {
        public int proId { set; get; }
        public string proName { set; get; }
        public double Price { set; get; }
        public string shortInfo { set; get; }
        public string info { set; get; }
        public DateTime addDate { set; get; }
    }
}