public List <string> DownloadOutToDB(string StrserviceUrl, string Strdbhost, string Strappkey, string Strappscret, string Strtoken)
{
List <string> returnList = new List <string>();
for (int i = -100; i < 0; i++)
{
bool isSuccess = false;
string strJson = string.Empty;
while (isSuccess != true)
{
EdbLib edb = new EdbLib(StrserviceUrl, Strdbhost, Strappkey, Strappscret, Strtoken);
Dictionary <String, String> @params = edb.edbGetCommonParams("edbInStoreGet");
@params["type"] = "1";
@params["date_type"] = "制单日期create_time";
@params["begin_time"] = DateTime.Now.AddDays(i).ToShortDateString();
@params["end_time"] = DateTime.Now.AddDays(i + 1).ToShortDateString();
@params["page_no"] = "1";
@params["page_size"] = "1000";
strJson = edb.edbRequstPost(@params, out isSuccess);
edb = null;
}
if (strJson != string.Empty)
{
returnList = JsonToStockObject(strJson, returnList);
}
}
return(returnList);
}
private List <Item> LoadInfo(string date_type, string begin_time, string end_time, string order_status, string StrserviceUrl, string Strdbhost, string Strappkey, string Strappscret, string Strtoken)
{
List <Item> lItems = new List <Item>();
bool isSuccess = false;
string strJson = string.Empty;
while (isSuccess != true)
{
EdbLib edb = new EdbLib(StrserviceUrl, Strdbhost, Strappkey, Strappscret, Strtoken);
Dictionary <String, String> @params = edb.edbGetCommonParams("edbTradeGet");
if (date_type != "")
{
@params["date_type"] = date_type;
}
@params["begin_time"] = begin_time;
@params["end_time"] = end_time;
@params["order_status"] = order_status;
@params["page_no"] = "1";
@params["page_size"] = page_size;
strJson = edb.edbRequstPost(@params, out isSuccess);
edb = null;
}
if (strJson != string.Empty)
{
JObject jo = (JObject)JsonConvert.DeserializeObject(strJson);
JArray arr = (JArray)jo["Success"]["items"]["item"];
foreach (JObject j in arr)
{
lItems.Add(GetItem(j));
}
}
return(lItems);
}
/// <summary>
/// 下载当天退货单信息
/// </summary>
public void DownloadReturnToDB(string StrserviceUrl, string Strdbhost, string Strappkey, string Strappscret, string Strtoken)
{
ConfigHelper config = new ConfigHelper();
string strdt1 = config.ReadValueByKey(ConfigurationFile.AppConfig, "退货到货日期");
if (strdt1 != null)
{
DateTime dt1 = Convert.ToDateTime(strdt1);
if (dt1 < DateTime.Now)
{
for (int i = 1; i <= 24; i++)
{
DateTime dt2 = dt1.AddHours(1);
if (dt2 > DateTime.Now)
{
break;
}
bool isSuccess = false;
string strJson = string.Empty;
while (isSuccess != true)
{
EdbLib edb = new EdbLib(StrserviceUrl, Strdbhost, Strappkey, Strappscret, Strtoken);
Dictionary <String, String> @params = edb.edbGetCommonParams("edbTradReturnGet");
@params["date_type"] = "退货到货日期";
@params["start_time"] = dt1.ToString();
@params["end_time"] = dt2.ToString();
@params["page_no"] = "1";
@params["page_size"] = "1000";
strJson = edb.edbRequstPost(@params, out isSuccess);
edb = null;
}
if (strJson != string.Empty)
{
List <Edb_RETURNSTOCK> lco = JsonToObject(strJson);
ObjectToData(lco);
}
dt1 = dt2;
}
if (dt1 > DateTime.Now)
{
dt1 = DateTime.Now;
}
config.UpdateOrCreateAppSetting(ConfigurationFile.AppConfig, "退货到货日期", dt1.ToString());
}
}
}
/// <summary>
/// 导入分布式调拨出库单到E店宝出库单
/// </summary>
/// <returns></returns>
public string AddStockOut(string StrserviceUrl, string Strdbhost, string Strappkey, string Strappscret, string Strtoken)
{
string strJson = string.Empty;
if (isExists() == true)
{
bool isSuccess = false;
while (isSuccess != true)
{
EdbLib edb = new EdbLib(StrserviceUrl, Strdbhost, Strappkey, Strappscret, Strtoken);
Dictionary <String, String> @params = edb.edbGetCommonParams("edbOutStoreAdd");
StringBuilder builder = new StringBuilder();
builder.Append("<info>");
List <string> BillNos = new List <string>();
builder = GetCentaur_OutStorageList(builder, out BillNos);
builder.Append("<product_info>");
foreach (string BillNo in BillNos)
{
builder = GetOutStorage_ItemList(builder, BillNo);
}
builder.Append("</product_info>");
builder.Append("</info>");
@params["xmlValues"] = builder.ToString();
strJson = edb.edbRequstPost(@params, out isSuccess);
edb = null;
}
if (strJson != string.Empty)
{
UpdateSTKTRANSFEROUT(strJson);
}
}
LogHelper.WriteLog(strcon, "Edb_STKTRANSFEROUT_DAL", "ResultJsonData", "", strJson);
return(strJson);
}
private void LoadInfo(string date_type, string begin_time, string end_time, string order_status, string StrserviceUrl, string Strdbhost, string Strappkey, string Strappscret, string Strtoken)
{
bool isSuccess = false;
string strJson = string.Empty;
while (isSuccess != true)
{
EdbLib edb = new EdbLib(StrserviceUrl, Strdbhost, Strappkey, Strappscret, Strtoken);
Dictionary <String, String> @params = edb.edbGetCommonParams("edbTradeGet");
if (date_type != "")
{
@params["date_type"] = date_type;
}
@params["begin_time"] = begin_time;
@params["end_time"] = end_time;
@params["order_status"] = order_status;
@params["page_no"] = "1";
@params["page_size"] = page_size;
LogHelper.WriteFileLog(typeof(Edb_OUTSTOCK_DAL), begin_time + "|" + end_time);
strJson = edb.edbRequstPost(@params, out isSuccess);
edb = null;
}
if (strJson != string.Empty)
{
try
{
JObject jo = (JObject)JsonConvert.DeserializeObject(strJson);
JArray arr = (JArray)jo["Success"]["items"]["item"];
int total_results = int.Parse(jo["Success"]["total_results"].ToString());
if (total_results > 0)
{
DateTime dt = DateTime.Parse(begin_time);
JArray narr = arr;
JArray j = null;
for (int x = arr.Count - 1; x >= 0; x--)
{
JObject obj = (JObject)arr[x];
if (total_results == int.Parse(page_size))
{
string delivery_time = obj["delivery_time"].ToString();
if (dt < DateTime.Parse(delivery_time))
{
dt = DateTime.Parse(delivery_time);
}
}
if (IsExists(obj["tid"].ToString()) == false)
{
if (j != null)
{
//j.Merge((JArray)obj["tid_item"]);
foreach (JObject job in (JArray)obj["tid_item"])
{
j.Add(job);
}
}
else
{
j = (JArray)obj["tid_item"];
}
obj.Remove("tid_item");
}
else
{
arr.Remove(obj);
}
}
if (arr != null && j != null)
{
DataTable d1 = GetDataTable(JsonToDataTable(arr.ToString()), dtTrade);
SqlBulkCopyInsert("tb_Trade", d1);
DataTable d2 = GetDataTable(JsonToDataTable(j.ToString()), dtTradeEntry);
SqlBulkCopyInsert("tb_TradeEntry", d2);
}
StringToDB(begin_time, end_time, true);
if (total_results == int.Parse(page_size) && dt < DateTime.Parse(end_time) && dt > DateTime.Parse(begin_time))
{
LoadInfo(date_type, dt.ToString("yyyy-MM-dd HH:mm:ss"), end_time, order_status, StrserviceUrl, Strdbhost, Strappkey, Strappscret, Strtoken);
}
}
else
{
StringToDB(begin_time, end_time, true);
}
}
catch (Exception ex)
{
LogHelper.WriteFileLog(typeof(Edb_OUTSTOCK_DAL), ex);
LogHelper.WriteFileLog(typeof(Edb_OUTSTOCK_DAL), strJson);
}
}
else
{
StringToDB(begin_time, end_time, false);
}
}
