Пример #1
0
        public ActionResult List(CrmCustomerSearchViewModel model)
        {
            int    pageindex = model.Page ?? 1;
            string sql       = "Select msg_S_0088 as Id,msg_S_0200 as CariKod,msg_S_0390 as CariUnvan,msg_S_0602 as YetkiliAdSoyad,msg_S_0501 as PersonelKod,msg_S_0502 as PersonelAdSoyad,msg_S_0264 as BasTarih,msg_S_0476 as BasSaat,msg_S_0265 as BitTarih,msg_S_0477 as BitSaat,msg_S_0598 as Sure,msg_S_0595 as Tip,msg_S_0596 as Yer,msg_S_0597 as Konu,msg_S_1156 as Oncelik FROM dbo.fn_Cariiliskicarifoyu (N'" + model.CariKod + "','" + model.startDate + "','" + model.endDate + "',0)";
            var    data      = _iliskilerViewORM.GetList(sql);
            List <CrmCustomerMovListViewModel> list = new List <CrmCustomerMovListViewModel>();

            foreach (var item in data)
            {
                CrmCustomerMovListViewModel cus = new CrmCustomerMovListViewModel();
                cus.BasSaat         = item.BasSaat;
                cus.BasTarih        = item.BasTarih;
                cus.BitSaat         = item.BitSaat;
                cus.BitTarih        = item.BitTarih;
                cus.CariKod         = item.CariKod;
                cus.CariUnvan       = item.CariUnvan;
                cus.Id              = item.Id;
                cus.Konu            = item.Konu;
                cus.Oncelik         = item.Oncelik;
                cus.PersonelAdSoyad = item.PersonelAdSoyad;
                cus.PersonelKod     = item.PersonelKod;
                cus.Sure            = item.Sure;
                cus.Tip             = item.Tip;
                cus.Yer             = item.Yer;
                cus.YetkiliAdSoyad  = item.YetkiliAdSoyad;
                list.Add(cus);
            }
            model.CustomerMovList = list.ToPagedList(pageindex, 5);
            if (Request.IsAjaxRequest())
            {
                return(PartialView("_customermovlist", model));
            }
            return(View(model));
        }
Пример #2
0
        public ActionResult List()
        {
            var model = new CrmCustomerSearchViewModel();

            return(View(model));
        }