/// <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); }