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)); }
public ActionResult List() { var model = new CrmCustomerSearchViewModel(); return(View(model)); }