public void GetGEPContractDetailDataForExcel(int dateSerchType, DateTime sDate, DateTime eDate, int numSerchType, string serchNum)
{
//정제
TransportOverseaGEPDetailBiz Target = new TransportOverseaGEPDetailBiz();
//동작
string Result = Target.GetGEPContractDetailDataForExcel(dateSerchType, sDate, eDate, numSerchType, serchNum);
//검증
Trace.WriteLine(Result);
}
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);
}
}
}
