public JsonResult GetGEPContractDetailData(Nullable<int> page, Nullable<int> rows, Nullable<int> dateSerchType, string sDate, string eDate, Nullable<int> numSerchType, string serchNum) { if (page == null) { return Json("", JsonRequestBehavior.AllowGet); } long TotalPage = 0; TransportOverseaGEPDetailBiz Biz = new TransportOverseaGEPDetailBiz(); List<GEPContractDetail> Result = Biz.GetGEPContractDetailData(ref TotalPage, Convert.ToInt32(page), Convert.ToInt32(rows), Convert.ToInt32(dateSerchType), Convert.ToDateTime(sDate + " 00:00:00"), Convert.ToDateTime(eDate + " 23:59:59"), Convert.ToInt32(numSerchType), serchNum); var result = new { total = TotalPage, page = page, rows = (from t in Result select new { cell = new string[] { t.ObjectID ,t.State ,t.ForeingConutryTransc ,t.ForeingConutryInvoiceNum ,t.ContractDate ,t.OrderNum ,t.ProductNum ,t.ProductName ,t.ProductOption ,t.ProductAmt ,t.ReceiverName ,t.ReceiverContact ,t.DeliveryNation ,t.DeliveryAddress ,t.ArrivedDate ,t.LocalTransc ,t.InvoiceNum ,t.UserID ,t.ExpectedWeight ,t.RealWeight ,t.ExpectedWeightCost ,t.RealWeightCost ,t.ContractID ,t.EMSChagneDate ,t.SellerName ,t.SellerID } }).ToArray() }; return Json(result); }
public void GetGEPContractDetailData(int nowPage, int pageSize, int dateSerchType, DateTime sDate, DateTime eDate,int numSerchType, string serchNum) { //정제 TransportOverseaGEPDetailBiz Target = new TransportOverseaGEPDetailBiz(); long TotalPage = 0; //동작 List<GEPContractDetail> Result = Target.GetGEPContractDetailData(ref TotalPage, nowPage, pageSize, dateSerchType, sDate, eDate, numSerchType, serchNum); //검증 Trace.WriteLine("TotalPage=" + TotalPage.ToString()); if (Result == null) { Trace.WriteLine("데이터가 없습니다."); } else { foreach (var t in Result) { Trace.DumpBusinessEntity(t); } } }