public PostSearch SearchRPO(string BoxID)
{
PostSearch ps = new PostSearch();
string url = string.Format("{0}{1}", Properties.Resources.SearchURL, BoxID);
var client = new RestClient(url);
var r = new RestRequest();
//r.Resource = "1.0/clean/address";
r.Method = Method.GET;
r.Timeout = 3000;
r.AddHeader("Authorization", Properties.Resources.Authorization);
r.AddHeader("X-User-Authorization", Properties.Resources.XUserAuthorization);
r.AddHeader("Content-Type", Properties.Resources.ContentType);
//r.AddJsonBody(SimpleJson.DeserializeObject(output));
IRestResponse response = client.Execute(r);
try
{
ps = JsonConvert.DeserializeObject <PostSearch>(response.Content);
}
catch (Exception ex)
{
ThisAddIn.formProgress.SetLog("Error: " + ex.Message);
}
return(ps);
}
private static bool PostImport_02(Excel.Worksheet ws, DataTable dt)
{
int row = 2;
bool res = true;
RuPostQueryAPI api = new RuPostQueryAPI();
try
{
Excel.Range rng = ws.Rows[row].EntireRow;
foreach (DataRow drow in dt.Rows)
{
rng = ws.Rows[row].EntireRow;
rng.Copy(ws.Rows[row + 1]);
ws.Cells[row, 1].Value2 = drow["InputDate"];
ws.Cells[row, 2].Value2 = drow["ExecuteDate"];
ws.Cells[row, 3].Value2 = drow["OrderCode"];
ws.Cells[row, 5].Value2 = drow["Post_index"];
ws.Cells[row, 6].Value2 = drow["Post_region"];
ws.Cells[row, 7].Value2 = drow["Post_place"];
int boxid = 0;
bool rr = int.TryParse(drow["boxPostID"].ToString(), out boxid);
if (boxid != 0)
{
PostSearch ps = api.SearchRPO(drow["boxPostID"].ToString());
if (ps != null)
{
ws.Cells[row, 4].Value2 = ps.Barcode;
ws.Cells[row, 12].Value2 = ps.HumanOperationName;
ws.Cells[row, 11].Value2 = ps.LastOperDate;
ws.Cells[row, 9].Value2 = ps.TotalRateWoVat / 100;
}
}
row++;
formProgress.SetProgress(row - 2, 0, dt.Rows.Count);
}
rng = ws.Rows[row].EntireRow;
rng.Delete();
}
catch (Exception ex)
{
formProgress.SetLog("Error: " + ex.Message);
res = false;
}
return(res);
}