public static async Task <bool> ApiPTLListDetail(string url)
{
bool result = false;
var request = System.Net.WebRequest.Create(url) as HttpWebRequest;
if (request != null)
{
request.Method = "GET";
request.ServicePoint.Expect100Continue = false;
request.Timeout = 20000;
request.ContentType = "application/json";
using (WebResponse response = await request.GetResponseAsync())
{
using (Stream stream = response.GetResponseStream())
{
string x = JsonObject.Load(stream).ToString();
JsonObject jObj = (JsonObject)JsonObject.Parse(x);
JsonArray jArr = (JsonArray)jObj["result"];
foreach (var item in jArr)
{
using (var database = WMSDatabase.NewConnection())
{
database.Insert
(new tblPickingListDetail
{
move_doc = Convert.ToString((int)item["move_doc_number"]),
picking_id = Convert.ToString((int)item["id"]),
upc = item["upc"],
sku = item["sku"],
dept = item["dept"],
style = item["short_description"],
descr = item["short_description"],
oqty = Convert.ToString((int)item["quantity_to_pick"]),
rqty = Convert.ToString((int)item["moved_qty"]),
status = "Open"
}
);
}
}
}
}
}
return(result);
}
/// <summary>
/// 获取事务管理对象
/// </summary>
/// <param name="system">事务运行系统</param>
/// <param name="warehouseId">事务运行仓库Id</param>
/// <returns></returns>
private static IUnitOfWork GetUnitOfWork(WMSDatabase system, string warehouseId)
{
AssertUtils.ArgumentNotNull(system, "system");
if (system == WMSDatabase.WarehouseIdSpecified && string.IsNullOrEmpty(warehouseId))
{
throw new Exception("请指定运行事务的仓库Id");
}
IWMSUnitOfWorkDefinition unitOfWorkDefinition = WMSUnitOfWorkDefinition.DefaultDefintion;
unitOfWorkDefinition.Database = system;
unitOfWorkDefinition.WarehouseId = warehouseId;
string connString = ConnectionStringsUtil.GetConnStringByDefinition(unitOfWorkDefinition);
if (string.IsNullOrEmpty(connString))
{
throw new Exception("根据事务定义配置没有找到相应的连接字符串。");
}
return(UnitOfWorkFactory.GetAdoNetUnitOfWork(connString, unitOfWorkDefinition));
}
public static async Task <bool> ApiPTLList(string url)
{
bool result = false;
var request = System.Net.WebRequest.Create(url) as HttpWebRequest;
if (request != null)
{
request.Method = "GET";
request.ServicePoint.Expect100Continue = false;
request.Timeout = 20000;
request.ContentType = "application/json";
using (WebResponse response = await request.GetResponseAsync())
{
using (Stream stream = response.GetResponseStream())
{
string x = JsonObject.Load(stream).ToString();
JsonObject jObj = (JsonObject)JsonObject.Parse(x);
JsonArray jArr = (JsonArray)jObj["result"];
foreach (var item in jArr)
{
using (var database = WMSDatabase.NewConnection())
{
database.Insert
(new tblPickingList
{
move_doc = Convert.ToString((int)item["move_doc_number"]),
store_id = item["store_code"],
store_name = item["store_name"],
status = "Open"
}
);
}
await ApiPTLListDetail(GlobalVariables.GlobalUrl + "/PTLListDetail/" + Convert.ToString((int)item["move_doc_number"]));
}
}
}
}
return(result);
}
