/// <summary>
/// 查询头列表
/// </summary>
/// <returns></returns>
public string GetList()
{
try
{
//根据条件查询
DataTable dt = GetListD();
//构造返回的Json
JsonArrStockInfo ResultJson = CreateStockinfo(dt);
string strRet = JsonHelper.SerializeObject(ResultJson);
Last = "4";
return(strRet);
}
catch (Exception ex)
{
return("{\"Err\":\"" + ex.Message + "LastStep:" + Last + "\"}");
}
}
/// <summary>
/// 构造Json
/// </summary>
/// <returns></returns>
private JsonArrStockInfo CreateStockinfo(DataTable dt)
{
int Perpage;
if (SearchPar.numPerPage == "")
{
Perpage = 5;
}
else
{
Perpage = int.Parse(SearchPar.numPerPage);
}
int pageno;
if (SearchPar.pageNum == "")
{
pageno = 1;
}
else
{
pageno = int.Parse(SearchPar.pageNum) <= 0 ? 1 : int.Parse(SearchPar.pageNum);
}
Last = "2";
JsonArrStockInfo JsInfo = new JsonArrStockInfo();
JsonInfoIndHead StockHeader = new JsonInfoIndHead();
List <JsonInfoIndRows> body = new List <JsonInfoIndRows>();
StockHeader.listcount = dt.Rows.Count.ToString();
StockHeader.maxPage = (dt.Rows.Count / Perpage + 1).ToString();
StockHeader.numPerPage = Perpage.ToString();
StockHeader.pageNum = pageno.ToString();
JsInfo.header = StockHeader;
int endno = pageno * Perpage < dt.Rows.Count?pageno * Perpage:dt.Rows.Count;
for (int i = (pageno * Perpage - Perpage); i < endno; i++)
{
JsonInfoIndRows StockBodyRow = new JsonInfoIndRows();
StockBodyRow.OUTSTOCKINDICATIONID = dt.Rows[i]["OUTSTOCKINDICATIONID"].ToString();
StockBodyRow.LOADINGDOCID = dt.Rows[i]["LOADINGDOCID"].ToString();
StockBodyRow.SHIPPEDNUM = double.Parse(dt.Rows[i]["SHIPPEDNUM"].ToString());
StockBodyRow.ARRIVENUM = double.Parse(dt.Rows[i]["ARRIVENUM"].ToString());
StockBodyRow.OUTSTOCKTYPE = dt.Rows[i]["OUTSTOCKTYPE"].ToString();
StockBodyRow.CUSTTYPE = dt.Rows[i]["CUSTTYPE"].ToString();
StockBodyRow.DELIVERAREAID = dt.Rows[i]["DELIVERAREAID"].ToString();
StockBodyRow.DELIVERROUTEID = dt.Rows[i]["DELIVERROUTEID"].ToString();
StockBodyRow.DELIVERID = dt.Rows[i]["DELIVERID"].ToString();
StockBodyRow.FACTARRIVALDATE = dt.Rows[i]["FACTARRIVALDATE"].ToString();
StockBodyRow.ARRIVALDATE = dt.Rows[i]["ARRIVALDATE"].ToString();
StockBodyRow.CUSTID = dt.Rows[i]["CUSTID"].ToString();
StockBodyRow.OWNERID = dt.Rows[i]["OWNERID"].ToString();
StockBodyRow.SHIPPERID = dt.Rows[i]["SHIPPERID"].ToString();
StockBodyRow.TRANSFERTYPE = dt.Rows[i]["TRANSFERTYPE"].ToString();
StockBodyRow.ISURGENCY = dt.Rows[i]["ISURGENCY"].ToString();
StockBodyRow.MFLAG = dt.Rows[i]["MFLAG"].ToString();
StockBodyRow.REMARK = dt.Rows[i]["REMARK"].ToString();
body.Add(StockBodyRow);
}
JsInfo.body = body;
Last = "3";
return(JsInfo);
}
