/// <summary>
/// 从省一体化平台按uuid获取数据安监申报数据到无锡数据中心
/// </summary>
public string YourTask_PullAJSBDataFromSythptByUUID(string deptCode, string password, string uuid)
{
string apiMessage = string.Empty;
DataTable dtapizb = dataService.Get_API_zb_apiFlowDetail("0");
if (dtapizb.Rows[0][0].ToString() == "1")
{
try
{
ReceiveDataServiceSpace.ReceiveDataServicePortTypeClient client = new ReceiveDataServiceSpace.ReceiveDataServicePortTypeClient();
//根据uuid获取安监申报详细数据
string getDetailDataXml = String.Empty;
Public.WriteLog("YourTask_PullAJSBDataFromSythptByUUID：" + uuid);
getDetailDataXml = client.getAJSBBByUuid(deptCode, password, uuid);
//Public.WriteLog("结果：" + getDetailDataXml);
if (getDetailDataXml.Contains("<?xml version=\"1.0\" encoding=\"gb2312\"?>"))
{
apiMessage = "success";
getDetailDataXml = getDetailDataXml.Replace("<?xml version=\"1.0\" encoding=\"gb2312\"?>", "").Replace("<body>", "").Replace("</body>", "");
saveAJSBXmlDataToDb(uuid, deptCode, getDetailDataXml, DateTime.Now);
}
}
catch (Exception ex)
{
Public.WriteLog("执行YourTask_PullAJSBDataFromSythptByUUID方法出现异常:" + ex.Message);
apiMessage += ex.Message;
}
}
return(apiMessage);
}
/// <summary>
/// 从省一体化平台获取数据安监申报数据到无锡数据中心
/// </summary>
public string YourTask_PullAJSBDataFromSythpt(DateTime pullDate)
{
string apiMessage = string.Empty;
//ShenBaoDataService sbDataService = new ShenBaoDataService();
DataTable dtapizb = dataService.Get_API_zb_apiFlowDetail("0");
if (dtapizb.Rows[0][0].ToString() == "1")
{
try
{
DateTime beginTime = DateTime.Now;
Public.WriteLog("开始执行YourTask_PullAJSBDataFromSythpt任务:" + beginTime.ToString("yyyy-MM-dd HH:mm:ss"));
//往数据监控日志表添加一条记录
DataTable dt_DataJkLog = dataService.GetSchema_DataJkLog();
DataRow row_DataJkLog = dt_DataJkLog.NewRow();
dt_DataJkLog.Rows.Add(row_DataJkLog);
string dataJkLogID = dataService.Get_DataJkLogNewID();
row_DataJkLog["ID"] = dataJkLogID;
row_DataJkLog["DataFlow"] = dtapizb.Rows[0]["apiFlow"];
row_DataJkLog["DataFlowName"] = dtapizb.Rows[0]["apiName"];
row_DataJkLog["ServiceUrl"] = dtapizb.Rows[0]["apiUrl"];
row_DataJkLog["csTime"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
dataService.Submit_DataJkLog(dt_DataJkLog);
ReceiveDataServiceSpace.ReceiveDataServicePortTypeClient client = new ReceiveDataServiceSpace.ReceiveDataServicePortTypeClient();
#region 从省一体化平台获取安监申报数据
DataTable dtApApiUsers = dataService.GetApApiUsers("AJ");//AJ-获取安监帐号列表
string pullDateStr = pullDate.ToString("yyyy-MM-dd");
//string pullDateStr = "2017-09-04";//测试时间
//DateTime pullDate = DateTime.Now;
//DateTime.TryParse(pullDateStr, out pullDate);
string getUUIDXml = String.Empty;
string getDetailDataXml = String.Empty;
string message_lxxm = String.Empty;
DataTable dt_DataJkDataDetail = dataService.GetSchema_DataJkDataDetail();
foreach (DataRow rowUser in dtApApiUsers.Rows)
{
try
{
Public.WriteLog("获取安监申报数据,机构：" + rowUser["deptCode"].ToString2() + ",日期：" + pullDateStr);
getUUIDXml = client.getAJSBBByDate(rowUser["deptCode"].ToString2(), rowUser["password"].ToString2(), pullDateStr);
Public.WriteLog("获取安监申报数据结果-getAJSBBByDate：" + getUUIDXml);
if (getUUIDXml.Contains("<?xml version=\"1.0\" encoding=\"GB2312\"?>"))
{
apiMessage = "sucess";
getUUIDXml = getUUIDXml.Replace("<?xml version=\"1.0\" encoding=\"GB2312\"?>", "").Replace("<body>", "").Replace("</body>", "");
}
else
{
//错误处理, 往数据监控详细日志表项添加一条记录
createMonitorLog(dataService, dt_DataJkDataDetail, dataJkLogID, "Ap_ajsbb", "getAJSBBByDate");
/**
* DataRow row_DataJkDataDetail = dt_DataJkDataDetail.NewRow();
* dt_DataJkDataDetail.Rows.Add(row_DataJkDataDetail);
* Int64 id = dataService.Get_DataJkDataDetailNewID().ToInt64();
* row_DataJkDataDetail["ID"] = id;
* row_DataJkDataDetail["DataJkLogID"] = row_DataJkLog["ID"];
* row_DataJkDataDetail["tableName"] = "Ap_ajsbb";
* row_DataJkDataDetail["MethodName"] = "getAJSBBByDate";
*/
}
if (!string.IsNullOrEmpty(getUUIDXml.Trim()))
{
DataTable dt = xmlHelper.ConvertXMLToDataTableWithBase64Decoding(getUUIDXml, out message_lxxm);
//string parseBase64Xml = xmlHelper.ConvertDataTableToXML(dt, "dataTable", "row");
//Public.WriteLog("获取安监申报数据结果：" + parseBase64Xml);
foreach (DataRow row in dt.Rows)
{
try
{
//根据uuid获取安监申报详细数据
Public.WriteLog("根据uuid获取安监申报详细数据：" + row[0].ToString());
getDetailDataXml = client.getAJSBBByUuid(rowUser["deptCode"].ToString2(), rowUser["password"].ToString2(), row[0].ToString());
//Public.WriteLog("结果：" + getDetailDataXml);
if (getDetailDataXml.Contains("<?xml version=\"1.0\" encoding=\"gb2312\"?>"))
{
getDetailDataXml = getDetailDataXml.Replace("<?xml version=\"1.0\" encoding=\"gb2312\"?>", "").Replace("<body>", "").Replace("</body>", "");
saveAJSBXmlDataToDb(row[0].ToString(), rowUser["deptCode"].ToString2(), getDetailDataXml, pullDate);
}
else
{
//错误处理, 往数据监控详细日志表项添加一条记录
createMonitorLog(dataService, dt_DataJkDataDetail, dataJkLogID, "Ap_ajsbb", "getAJSBBByUuid");
}
}
catch (Exception ex)
{
Public.WriteLog("根据uuid获取安监申报详细数据方法出现异常:" + ex.Message);
apiMessage += ex.Message;
}
}
}
}
catch (Exception ex)
{
Public.WriteLog("执行YourTask_PullAJSBDataFromSythpt方法出现异常1:" + ex.Message);
apiMessage += ex.Message;
}
}
dataService.Submit_DataJkDataDetail(dt_DataJkDataDetail);
#endregion
}
catch (Exception ex)
{
Public.WriteLog("执行YourTask_PullAJSBDataFromSythpt方法出现异常2:" + ex.Message);
apiMessage += ex.Message;
}
finally
{
DataTable dtapicb = dataService.GetSchema_API_cb();
DataRow row_apicb = dtapicb.NewRow();
dtapicb.Rows.Add(row_apicb);
row_apicb["apiCbID"] = dataService.Get_apiCbNewID();
row_apicb["apiFlow"] = "0";
row_apicb["apiMethod"] = "getAJSBBByDate";
row_apicb["apiDyResult"] = string.IsNullOrEmpty(apiMessage) == true ? "成功" : "失败";
row_apicb["apiDyMessage"] = apiMessage;
row_apicb["apiDyTime"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
dataService.Submit_API_cb(dtapicb);
dataService.UpdateZbJkzt("0", string.IsNullOrEmpty(apiMessage) == true ? "1" : "0", apiMessage);
}
}
return(apiMessage);
}