private static bool openUrlDownloadFile(Log4netUtil.LogAppendToForms logAppendToForms, string url, string filename, bool isDebug)
{
try
{
System.Net.HttpWebRequest Myrq = (System.Net.HttpWebRequest)System.Net.HttpWebRequest.Create(url);
System.Net.HttpWebResponse myrp = (System.Net.HttpWebResponse)Myrq.GetResponse();
System.IO.Stream st = myrp.GetResponseStream();
System.IO.Stream so = new System.IO.FileStream(filename, System.IO.FileMode.Create);
byte[] by = new byte[1024];
int osize = st.Read(by, 0, (int)by.Length);
while (osize > 0)
{
so.Write(by, 0, osize);
osize = st.Read(by, 0, (int)by.Length);
}
so.Close();
st.Close();
myrp.Close();
Myrq.Abort();
return(true);
}
catch (Exception ex)
{
string logMessage = string.Format("【随货同行下载任务】 Url {0} 下载失败！原因,{1}", url, ex.Message);
Log4netUtil.Log4NetHelper.LogMessage(logAppendToForms, isDebug, logMessage, @"Util\FileHelper");
return(false);
}
}
/// <summary>
/// ScheduleJob
/// </summary>
/// <param name="scheduler"></param>
/// <param name="jobInfo"></param>
public void ScheduleDelBackUpFiles(Log4netUtil.LogAppendToForms logAppendToForms, int LogRetentionDays) //IScheduler scheduler,
{
Type type = GetClassInfo(Util.DalConst.AssemblyPathBLL, "BLL.log4netDelBLL");
if (type != null)
{
//使用组别、名称创建一个工作明细，此处为所需要执行的任务
IJobDetail job = new JobDetailImpl("清除日志计划", string.Format("{0}_JobGroup", "清除日志计划"), type);
job.JobDataMap.Add("JobType", "log4net清除日志");
job.JobDataMap.Add("LogRetentionDays", LogRetentionDays);
job.JobDataMap.Put("ControlQueue", logAppendToForms);
//使用组别、名称创建一个触发器，其中触发器立即执行，且每隔1秒或3秒执行一个任务，重复执行
CronTriggerImpl trigger = new CronTriggerImpl();
trigger.CronExpressionString = "0 0 9 1/1 * ? "; //"0/30 * * ? * 1,2,3,4,5 "; // 任务执行的cron表达式
trigger.Name = "清除日志计划"; //触发器名称，同一个分组中的名称必须不同
trigger.Description = "每天9点执行一次"; //触发器描述
trigger.StartTimeUtc = DateTime.UtcNow;
trigger.Group = string.Format("{0}_TriggerGroup", "清除日志计划"); //触发器组
scheduler.ScheduleJob(job, trigger); //作业和触发器设置到调度器中
}
else
{
Log4netUtil.Log4NetHelper.LogError(logAppendToForms, true, string.Format("定时调度任务启动失败,加载log4netDelBLL类为空{0}", string.Empty), "QuartzManager");
}
}
//private static System.Windows.Forms.RichTextBox rtxLog = null;
#region Execute
/// <summary>
/// Execute
/// </summary>
/// <param name="context"></param>
public void Execute(IJobExecutionContext context)
{
Log4netUtil.LogAppendToForms logAppendToForms = (Log4netUtil.LogAppendToForms)context.JobDetail.JobDataMap.Get("ControlQueue");
Version Ver = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version;
string jobName = context.JobDetail.Key.Name;
string jobGroup = context.JobDetail.Key.Group;
string logMessage = string.Empty;
string jobLogType = "QuartzManager";
JobDataMap jobData = context.JobDetail.JobDataMap;
try
{
int logRetentionDays = jobData.GetInt("LogRetentionDays");
if (logRetentionDays > 0)
{
string path = System.Windows.Forms.Application.StartupPath.ToString() + "\\Logs";
Log4netUtil.FilesHelper.DeleteALLFiles(logAppendToForms, path, logRetentionDays);
logMessage = string.Format("【{0}】 Execute 执行成功！Ver.{1}", "清除日志计划", Ver.ToString());
LogMessage(logAppendToForms, true, logMessage, jobLogType);
}
else
{
logMessage = string.Format("【{0}】 Execute 无执行计划！Ver.{1}", "清除日志计划", Ver.ToString());
LogWarning(logAppendToForms, true, logMessage, jobLogType);
}
}
catch (Exception ex)
{
logMessage = string.Format("【{0}】 Execute 执行发生异常:{1}", "清除日志计划", ex.ToString());
LogError(logAppendToForms, true, logMessage, jobLogType);
}
}
/// <summary>
/// GetDgvDtAll
/// </summary>
/// <param name="dgv"></param>
/// <param name="searchParam"></param>
public void GetDgvDtAll(Log4netUtil.LogAppendToForms logAppendToForms, System.Windows.Forms.DataGridView dgv, Model.SearchParam searchParam)
{
DALFactory.FactoryDAL fact = new DALFactory.FactoryDAL();
IDAL.ICommonDAL idal = fact.CreateCommonDAL();
System.Data.DataTable dataTable = idal.GetDgvDtAll(logAppendToForms, searchParam);
dgv.DataSource = dataTable;
}
/// <summary>
/// 打开网址并下载文件
/// </summary>
/// <param name="URL">下载文件地址</param>
/// <param name="Filename">下载后另存为（全路径）</param>
private static bool OpenUrlDownloadFile(Log4netUtil.LogAppendToForms logAppendToForms,
Model.JobEntity jobInfo,
string url, string filename)
{
try
{
System.Net.HttpWebRequest Myrq = (System.Net.HttpWebRequest)System.Net.HttpWebRequest.Create(url);
System.Net.HttpWebResponse myrp = (System.Net.HttpWebResponse)Myrq.GetResponse();
System.IO.Stream st = myrp.GetResponseStream();
System.IO.Stream so = new System.IO.FileStream(filename, System.IO.FileMode.Create);
byte[] by = new byte[1024];
int osize = st.Read(by, 0, (int)by.Length);
while (osize > 0)
{
so.Write(by, 0, osize);
osize = st.Read(by, 0, (int)by.Length);
}
so.Close();
st.Close();
myrp.Close();
Myrq.Abort();
return(true);
}
catch (Exception ex)
{
string logMessage = string.Format("【{0}_{1}】 下载文件失败 ;原因:{2}", jobInfo.JobCode, jobInfo.JobName, ex.Message);
Log4netUtil.Log4NetHelper.LogError(logAppendToForms, true, logMessage, @"Ftp");
return(false);
}
}
/// <summary>
/// LogMessage
/// </summary>
/// <param name="logAppendToForms"></param>
/// <param name="isDebug"></param>
/// <param name="logMessage"></param>
/// <param name="jobType"></param>
public static void LogMessage(Log4netUtil.LogAppendToForms logAppendToForms, bool isDebug, string logMessage, string jobType)
{
Log4netUtil.Log4NetHelper.Info(logMessage, jobType);
if (isDebug)
{
Log4netUtil.LogDisplayHelper.LogMessage(logAppendToForms, logMessage);
}
}
/// <summary>
/// BulkInsertDatabase
/// </summary>
/// <param name="logAppendToForms"></param>
/// <param name="jobInfo"></param>
/// <param name="dt"></param>
/// <param name="insertTableName"></param>
/// <returns></returns>
public int BulkInsertDatabase(Log4netUtil.LogAppendToForms logAppendToForms,
Model.JobEntity jobInfo,
string insertTableName, string strSql)
{
DALFactory.FactoryDAL fact = new DALFactory.FactoryDAL();
IDAL.ICommonDAL idal = fact.CreateCommonDAL();
return(idal.BulkCopyInsert(logAppendToForms, jobInfo, insertTableName, strSql));
}
/// <summary>
/// LogMessage
/// </summary>
/// <param name="logAppendToForms"></param>
/// <param name="isDebug"></param>
/// <param name="logMessage"></param>
/// <param name="jobType"></param>
private void LogMessage(Log4netUtil.LogAppendToForms logAppendToForms, bool isDebug, string logMessage, string jobType)
{
Log4netUtil.Log4NetHelper.Info(logMessage, "QuartzManager");
if (isDebug)
{
Log4netUtil.LogDisplayHelper.LogMessage(logAppendToForms, logMessage);
}
}
/// <summary>
/// BulkCopyInsert 批量插入数据库
/// </summary>
/// <param name="logAppendToForms"></param>
/// <param name="jobInfo"></param>
/// <param name="tableName"></param>
/// <returns></returns>
public int BulkCopyInsert(Log4netUtil.LogAppendToForms logAppendToForms, Model.JobEntity jobInfo, string tableName, string strSql)
{
string logMessage = string.Empty;
//string strSql = Util.ConvertHelper.DataTableToStrInsert(dt, tableName) + "\r";
string targetDatabase = jobInfo.TargetDatabase;
IDAL.IDBHelper _idbHelper = DALFactory.DBHelperFactory.CreateInstance(targetDatabase);//创建接口/创建接口
System.Data.Common.DbParameter[] cmdParams = null;
string jsonSql = Util.DbSqlLog.SqlToJson("9999", strSql, cmdParams);
logMessage = string.Format("【{0}_{1}】 JsonSql：{2} ", jobInfo.JobCode, jobInfo.JobName, jsonSql);
Log4netUtil.Log4NetHelper.LogMessage(logAppendToForms, jobInfo.IsDebug, logMessage, @"Database");
try
{
if (_idbHelper.ExecuteNonQuery(System.Data.CommandType.Text, strSql, targetDatabase, cmdParams) > 0)
{
logMessage = string.Format("【{0}_{1}】 执行BulkCopyInsert成功!", jobInfo.JobCode, jobInfo.JobName);
Newtonsoft.Json.Linq.JObject resultJObject = new Newtonsoft.Json.Linq.JObject();
resultJObject.Add("code", new Newtonsoft.Json.Linq.JValue("0000"));
resultJObject.Add("msg", new Newtonsoft.Json.Linq.JValue(logMessage));
resultJObject.Add("sql", new Newtonsoft.Json.Linq.JObject(Newtonsoft.Json.Linq.JObject.Parse(jsonSql)));
logMessage = string.Format("【{0}_{1}】 {2}", jobInfo.JobCode, jobInfo.JobName, Util.NewtonsoftCommon.SerializeObjToJson(resultJObject));
Log4netUtil.Log4NetHelper.LogMessage(logAppendToForms, jobInfo.IsDebug, logMessage, @"Database");
return(1);
}
else
{
logMessage = string.Format("【{0}_{1}】 执行BulkCopyInsert失败!", jobInfo.JobCode, jobInfo.JobName);
Newtonsoft.Json.Linq.JObject resultJObject = new Newtonsoft.Json.Linq.JObject();
resultJObject.Add("code", new Newtonsoft.Json.Linq.JValue("9999"));
resultJObject.Add("msg", new Newtonsoft.Json.Linq.JValue(logMessage));
resultJObject.Add("sql", new Newtonsoft.Json.Linq.JObject(Newtonsoft.Json.Linq.JObject.Parse(jsonSql)));
logMessage = string.Format("【{0}_{1}】 {2}", jobInfo.JobCode, jobInfo.JobName, Util.NewtonsoftCommon.SerializeObjToJson(resultJObject));
Log4netUtil.Log4NetHelper.LogError(logAppendToForms, jobInfo.IsDebug, logMessage, @"Database");
return(-1);
}
}
catch (Exception ex)
{
//违反了 PRIMARY KEY 约束
logMessage = string.Format("【{0}_{1}】 执行BulkCopyInsert失败! 失败原因:{2}", jobInfo.JobCode, jobInfo.JobName, ex.Message);
Newtonsoft.Json.Linq.JObject resultJObject = new Newtonsoft.Json.Linq.JObject();
resultJObject.Add("code", new Newtonsoft.Json.Linq.JValue("9999"));
resultJObject.Add("msg", new Newtonsoft.Json.Linq.JValue(logMessage));
resultJObject.Add("sql", new Newtonsoft.Json.Linq.JObject(Newtonsoft.Json.Linq.JObject.Parse(jsonSql)));
logMessage = string.Format("【{0}_{1}】 {2}", jobInfo.JobCode, jobInfo.JobName, Util.NewtonsoftCommon.SerializeObjToJson(resultJObject));
Log4netUtil.Log4NetHelper.LogError(logAppendToForms, jobInfo.IsDebug, logMessage, @"Database");
if (ex.Message.Contains("违反了 PRIMARY KEY 约束"))
{
return(2);
}
else
{
return(-1);
}
}
}
/// <summary>
/// ScheduleJob
/// </summary>
/// <param name="scheduler"></param>
/// <param name="jobInfo"></param>
public void ScheduleJob(Model.JobEntity jobInfo, Log4netUtil.LogAppendToForms logAppendToForms) //IScheduler scheduler,
{
if (ValidExpression(jobInfo.CronExpression))
{
Type type = GetClassInfo(Util.DalConst.AssemblyPathBLL, "BLL.JobsItemsBLL"); //GetClassInfo("BLL", "BLL.JobsItemsBLL");
if (type != null)
{
//使用组别、名称创建一个工作明细，此处为所需要执行的任务
IJobDetail job = new JobDetailImpl(jobInfo.JobCode.ToString(), string.Format("{0}_{1}_JobGroup", jobInfo.JobCode.ToString(), jobInfo.JobName), type);
job.JobDataMap.Add("JobCode", jobInfo.JobCode);
job.JobDataMap.Add("JobName", jobInfo.JobName);
job.JobDataMap.Add("IsDebug", jobInfo.IsDebug); //调式模式
job.JobDataMap.Add("DomainName", jobInfo.DomainName);
job.JobDataMap.Add("ServiceName", jobInfo.ServiceName);
job.JobDataMap.Add("InterfacePrefix", jobInfo.InterfacePrefix);
job.JobDataMap.Add("ApiModuleType", jobInfo.ApiModuleType);
job.JobDataMap.Add("ApiRequestType", jobInfo.ApiRequestType);
job.JobDataMap.Add("TargetDatabase", jobInfo.TargetDatabase);
job.JobDataMap.Add("ProcedureName", jobInfo.ProcedureName);
job.JobDataMap.Add("ModuleID", jobInfo.ModuleID);
job.JobDataMap.Add("FilterBillType", jobInfo.FilterBillType);
job.JobDataMap.Add("PageSize", jobInfo.PageSize);
job.JobDataMap.Add("WritebackProcedureName", jobInfo.WritebackProcedureName);
job.JobDataMap.Add("WritebackType", jobInfo.WritebackType);
job.JobDataMap.Add("InsertTableName", jobInfo.InsertTableName); //InsertTableName
job.JobDataMap.Add("CronExpression", jobInfo.CronExpression); //调式模式
job.JobDataMap.Add("CronExpressionDescription", jobInfo.CronExpressionDescription); //调式模式
job.JobDataMap.Add("EnterpriseId", jobInfo.EnterpriseId); //调式模式
job.JobDataMap.Add("EnterpriseName", jobInfo.EnterpriseName); //调式模式
job.JobDataMap.Add("StrConfigInfo", jobInfo.StrConfigInfo); //调式模式
job.JobDataMap.Put("ControlQueue", logAppendToForms);
//使用组别、名称创建一个触发器，其中触发器立即执行，且每隔1秒或3秒执行一个任务，重复执行
CronTriggerImpl trigger = new CronTriggerImpl();
trigger.CronExpressionString = jobInfo.CronExpression; // 任务执行的cron表达式
trigger.Name = string.Format("{0}_{1}", jobInfo.JobCode.ToString(), jobInfo.JobName); //触发器名称，同一个分组中的名称必须不同
trigger.Description = jobInfo.CronExpressionDescription; //触发器描述
trigger.StartTimeUtc = DateTime.UtcNow;
trigger.Group = string.Format("{0}_{1}_TriggerGroup", jobInfo.JobCode.ToString(), jobInfo.JobName); //触发器组
scheduler.ScheduleJob(job, trigger); //作业和触发器设置到调度器中
}
else
{
Log4netUtil.Log4NetHelper.LogError(logAppendToForms, true, string.Format("{0} 定时调度任务启动失败,加载 JobsItemsBLL 类为空", jobInfo.JobName), "QuartzManager");
}
}
else
{
Log4netUtil.Log4NetHelper.LogError(logAppendToForms, true, string.Format("{0} 定时调度任务启动失败,CronExpression{1}不是有效的表达式", jobInfo.JobName, jobInfo.CronExpression), "QuartzManager");
}
}
/// <summary>
/// ErpWriteback
/// </summary>
/// <param name="logAppendToForms"></param>
/// <param name="writebackParam"></param>
/// <returns></returns>
public bool ErpWriteback(Log4netUtil.LogAppendToForms logAppendToForms, Model.WritebackParam writebackParam)
{
string logMessage = string.Empty;
string procedureName = writebackParam.ProcedureName;
string targetDatabase = writebackParam.TargetDatabase;
IDAL.IDBHelper _idbHelper = DALFactory.DBHelperFactory.CreateInstance(targetDatabase);//创建接口
System.Data.Common.DbParameter[] cmdParams = { _idbHelper.CreateInParam(targetDatabase, ":i_WritebackType", writebackParam.WritebackType),
_idbHelper.CreateInParam(targetDatabase, ":i_BillCodes", string.IsNullOrEmpty(writebackParam.BillCodes)?string.Empty:writebackParam.BillCodes),
_idbHelper.CreateInParam(targetDatabase, ":i_Type", string.IsNullOrEmpty(writebackParam.Type)?string.Empty:writebackParam.Type),
_idbHelper.CreateInParam(targetDatabase, ":i_Status", writebackParam.Status),
_idbHelper.CreateInParam(targetDatabase, ":i_WritebackInfo", string.IsNullOrEmpty(writebackParam.WritebackInfo)?string.Empty:writebackParam.WritebackInfo) };
try
{
writebackParam.IsDebug = true;
int r = _idbHelper.ExecuteNonQuery(System.Data.CommandType.StoredProcedure, procedureName, targetDatabase, cmdParams);
if (r > 0)
{
string jsonSql = Util.DbSqlLog.SqlToJson("0000", procedureName, cmdParams);
logMessage = string.Format("ErpWriteback回写成功!!!{0}", string.Empty);
Newtonsoft.Json.Linq.JObject resultJObject = new Newtonsoft.Json.Linq.JObject();
resultJObject.Add("code", new Newtonsoft.Json.Linq.JValue("0000"));
resultJObject.Add("msg", new Newtonsoft.Json.Linq.JValue(logMessage));
resultJObject.Add("sql", new Newtonsoft.Json.Linq.JObject(Newtonsoft.Json.Linq.JObject.Parse(jsonSql)));
logMessage = string.Format("【{0}_{1}】 {2}", writebackParam.jobInfo.JobCode, writebackParam.jobInfo.JobName.ToString(), Util.NewtonsoftCommon.SerializeObjToJson(resultJObject));
Log4netUtil.Log4NetHelper.LogMessage(logAppendToForms, writebackParam.IsDebug, logMessage, @"Database");
return(true);
}
else
{
string jsonSql = Util.DbSqlLog.SqlToJson("9999", procedureName, cmdParams);
logMessage = string.Format("ErpWriteback回写失败!!!!{0}", string.Empty);
Newtonsoft.Json.Linq.JObject resultJObject = new Newtonsoft.Json.Linq.JObject();
resultJObject.Add("code", new Newtonsoft.Json.Linq.JValue("9999"));
resultJObject.Add("msg", new Newtonsoft.Json.Linq.JValue(logMessage));
resultJObject.Add("sql", new Newtonsoft.Json.Linq.JObject(Newtonsoft.Json.Linq.JObject.Parse(jsonSql)));
logMessage = string.Format("【{0}_{1}】 {2}", writebackParam.jobInfo.JobCode, writebackParam.jobInfo.JobName.ToString(), Util.NewtonsoftCommon.SerializeObjToJson(resultJObject));
Log4netUtil.Log4NetHelper.LogError(logAppendToForms, writebackParam.IsDebug, logMessage, @"Database");
return(false);
}
}
catch (Exception ex)
{
string jsonSql = Util.DbSqlLog.SqlToJson("9999", procedureName, cmdParams);
logMessage = string.Format("ErpWriteback回写失败!!!原因：{0};", ex.Message);
Newtonsoft.Json.Linq.JObject resultJObject = new Newtonsoft.Json.Linq.JObject();
resultJObject.Add("code", new Newtonsoft.Json.Linq.JValue("9999"));
resultJObject.Add("msg", new Newtonsoft.Json.Linq.JValue(logMessage));
resultJObject.Add("sql", new Newtonsoft.Json.Linq.JObject(Newtonsoft.Json.Linq.JObject.Parse(jsonSql)));
logMessage = string.Format("【{0}_{1}】 {2}", writebackParam.jobInfo.JobCode, writebackParam.jobInfo.JobName.ToString(), Util.NewtonsoftCommon.SerializeObjToJson(resultJObject));
Log4netUtil.Log4NetHelper.LogError(logAppendToForms, writebackParam.IsDebug, logMessage, @"Database");
return(false);
}
}
/// <summary>
/// SyncApiByJson Json
/// </summary>
/// <returns></returns>
public string SyncApiByJson(Log4netUtil.LogAppendToForms logAppendToForms, Model.JobEntity jobInfo, string controllerType, string requestData)
{
string reqUrl = string.Format("{0}/{1}", ReqURL, controllerType);
Newtonsoft.Json.Linq.JObject resultJObject = new Newtonsoft.Json.Linq.JObject();
Newtonsoft.Json.Linq.JArray jlistRequestData = Newtonsoft.Json.Linq.JArray.Parse(requestData);
string logMessage = string.Empty;
string result = string.Empty;
string t = string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now); //时间戳(格式：yyyy-MM-ddHH:mm:ss)
string token = BuildToken(); //"nDWKKyRDMrS1M9zxIbTAQQ=="; //
if (string.IsNullOrEmpty(token))
{
logMessage = string.Format(" controllerType:{0} ;SendPost SyncApiByJson 接口调用 BuildToken token生成失败:token为空 ！", controllerType);
Newtonsoft.Json.Linq.JObject requestDataObj = Newtonsoft.Json.Linq.JObject.Parse(requestData);
resultJObject.Add("errMsg", new Newtonsoft.Json.Linq.JValue(logMessage));
resultJObject.Add("rstFlag", new Newtonsoft.Json.Linq.JValue(10));
resultJObject.Add("reqUrl", new Newtonsoft.Json.Linq.JValue(reqUrl));
resultJObject.Add("t", new Newtonsoft.Json.Linq.JValue(t));
resultJObject.Add("token", new Newtonsoft.Json.Linq.JValue(token));
resultJObject.Add("items", new Newtonsoft.Json.Linq.JArray(jlistRequestData));
result = NewtonsoftCommon.SerializeObjToJson(resultJObject);
logMessage = string.Format("【{0}_{1}】 {2}", jobInfo.JobCode, jobInfo.JobName.ToString(), result);
Log4netUtil.Log4NetHelper.Error(logMessage, @"PrepurchApi");
Log4netUtil.LogDisplayHelper.LogError(logAppendToForms, logMessage);
return(result);
}
resultJObject = new Newtonsoft.Json.Linq.JObject();
Dictionary <string, string> param = new Dictionary <string, string>();
param.Add("t", t);
param.Add("token", token);
param.Add("items", HttpUtility.UrlEncode(requestData, Encoding.UTF8));//请求内容为 JSON 格式
//param.Add("RequestData", HttpUtility.UrlEncode(requestJson, Encoding.UTF8));//请求内容为 JSON 格式
result = sendPost(reqUrl, param);
resultJObject = new Newtonsoft.Json.Linq.JObject();
//logMessage = string.Format("SendPost SyncApiByJson 接口调用! controllerType:{0} ", controllerType);
logMessage = string.Format(" controllerType:{0} ;SendPost SyncApiByJson 接口调用！", controllerType);
resultJObject.Add("msg", new Newtonsoft.Json.Linq.JValue(logMessage));
resultJObject.Add("reqUrl", new Newtonsoft.Json.Linq.JValue(reqUrl));
resultJObject.Add("t", new Newtonsoft.Json.Linq.JValue(t));
resultJObject.Add("token", new Newtonsoft.Json.Linq.JValue(token));
//resultJObject.Add("order_code", new Newtonsoft.Json.Linq.JValue(orderCode));
resultJObject.Add("items", new Newtonsoft.Json.Linq.JArray(jlistRequestData));
resultJObject.Add("result", new Newtonsoft.Json.Linq.JObject(Newtonsoft.Json.Linq.JObject.Parse(result)));
logMessage = string.Format("【{0}_{1}】 {2}", jobInfo.JobCode, jobInfo.JobName.ToString(), NewtonsoftCommon.SerializeObjToJson(resultJObject));
Log4netUtil.Log4NetHelper.Info(logMessage, @"PrepurchApi");
Log4netUtil.LogDisplayHelper.LogMessage(logAppendToForms, logMessage);
return(result);
}
private static bool convertPDFToImage(Log4netUtil.LogAppendToForms logAppendToForms, string pdfInputPath, string imageOutputPath,
string imageName, int startPageNum, int endPageNum, ImageFormat imageFormat, Definition definition, bool isDebug)
{
PDFFile pdfFile = PDFFile.Open(pdfInputPath);
try
{
if (!Directory.Exists(imageOutputPath))
{
Directory.CreateDirectory(imageOutputPath);
}
if (startPageNum <= 0)
{
startPageNum = 1;
}
if (endPageNum > pdfFile.PageCount)
{
endPageNum = pdfFile.PageCount;
}
if (startPageNum > endPageNum)
{
int tempPageNum = startPageNum;
startPageNum = endPageNum;
endPageNum = startPageNum;
}
for (int i = startPageNum; i <= endPageNum; i++)
{
Bitmap pageImage = pdfFile.GetPageImage(i - 1, 56 * (int)definition);
string extension = imageFormat.ToString();
if (string.Equals(extension.ToLower(), "jpeg"))
{
extension = "jpg";
}
pageImage.Save(imageOutputPath + imageName + "." + extension, imageFormat);
//pageImage.Save(imageOutputPath + imageName + i.ToString() + "." + extension, imageFormat);
pageImage.Dispose();
}
return(true);
}
catch (Exception ex)
{
string logMessage = string.Format("【随货同行下载任务】 PdfInputPath {0} 转换图片失败！原因,{1}", pdfInputPath, ex.Message);
Log4netUtil.Log4NetHelper.LogMessage(logAppendToForms, isDebug, logMessage, @"KJJ\DownloadDataBusiness");
return(false);
}
finally
{
pdfFile.Dispose();
}
}
/// <summary>
/// ConvertJsonToJArray
/// </summary>
/// <param name="logAppendToForms"></param>
/// <param name="jobInfo"></param>
/// <param name="strJson"></param>
/// <returns></returns>
public static JArray ConvertJsonToJArray(Log4netUtil.LogAppendToForms logAppendToForms,
Model.JobEntity jobInfo, string strJson)
{
JObject jObject = JObject.Parse(strJson);
IEnumerable <JProperty> property = jObject.Properties();
JArray jArray = new JArray();
foreach (JProperty item in property)
{
JObject child = JObject.Parse(item.Value.ToString());
jArray.Add(child);
}
return(jArray);
}
/// <summary>
/// 删除文件夹下所有文件
/// </summary>
/// <param name="srcPath"></param>
public static bool DelFileName(Log4netUtil.LogAppendToForms logAppendToForms, string fileFullPath, string info)
{
try
{
// 删除该文件
System.IO.File.Delete(fileFullPath);
return(true);
}
catch (Exception ex)
{
string logMessage = string.Format("{0} 删除文件失败！文件路径:{1} ; 原因,{2}", info, fileFullPath, ex.Message);
Log4netUtil.Log4NetHelper.LogMessage(logAppendToForms, true, logMessage, @"Util\FileHelper");
return(false);
}
}
/// <summary>
/// Post方式提交数据，返回网页的源代码
/// </summary>
/// <param name="url">发送请求的 URL</param>
/// <param name="param">请求的参数集合</param>
/// <returns>远程资源的响应结果</returns>
private string SendPost(Log4netUtil.LogAppendToForms logAppendToForms,
Model.JobEntity jobInfo,
string url, string postData)
{
string logMessage = string.Empty;
string result = string.Empty;
byte[] byteData = Encoding.GetEncoding("UTF-8").GetBytes(postData.ToString());
try
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
if (url.Substring(0, 8) == "https://")
{
ServicePointManager.ServerCertificateValidationCallback = new RemoteCertificateValidationCallback(CheckValidationResult);
}
request.ContentType = "application/json";// "application/x-www-form-urlencoded";
request.Referer = url;
request.Accept = "*/*";
request.Timeout = 30 * 1000;
request.UserAgent = "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)";
request.Method = "POST";
request.ContentLength = byteData.Length;
Stream stream = request.GetRequestStream();
stream.Write(byteData, 0, byteData.Length);
stream.Flush();
stream.Close();
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Stream backStream = response.GetResponseStream();
StreamReader sr = new StreamReader(backStream, Encoding.GetEncoding("UTF-8"));
result = sr.ReadToEnd();
sr.Close();
backStream.Close();
response.Close();
request.Abort();
}
catch (Exception ex)
{
logMessage = string.Format("【{0}_{1}】 SendPost b2bApi接口失败 失败原因:{2}", jobInfo.JobCode, jobInfo.JobName, ex.Message);
Log4netUtil.Log4NetHelper.LogError(logAppendToForms, jobInfo.IsDebug, logMessage, string.Format(@"Api\{0}", jobInfo.JobCode));
Newtonsoft.Json.Linq.JObject jObject = new Newtonsoft.Json.Linq.JObject();
jObject.Add("code", 999);
jObject.Add("msg", ex.Message);
jObject.Add("data", string.Empty);
result = Util.NewtonsoftCommon.SerializeObjToJson(jObject);
}
return(result);
}
/// <summary>
/// GetDgvDtAll
/// </summary>
/// <param name="logAppendToForms"></param>
/// <param name="searchParam"></param>
/// <returns></returns>
public System.Data.DataTable GetDgvDtAll(Log4netUtil.LogAppendToForms logAppendToForms, Model.SearchParam searchParam)
{
string storedProcedureName = searchParam.ProcedureName;
string targetDatabase = searchParam.TargetDatabase;
string logMessage = string.Empty;
IDAL.IDBHelper _idbHelper = DALFactory.DBHelperFactory.CreateInstance(targetDatabase);//创建接口
System.Data.Common.DbParameter[] cmdParams = { _idbHelper.CreateInParam(targetDatabase, ":i_ModuleID", searchParam.ModuleID),
_idbHelper.CreateInParam(targetDatabase, ":i_IsMaintain", searchParam.IsMaintain),
_idbHelper.CreateInParam(targetDatabase, ":i_FilterFlag", searchParam.FilterFlag),
_idbHelper.CreateInParam(targetDatabase, ":i_StartDate", searchParam.StartDate),
_idbHelper.CreateInParam(targetDatabase, ":i_EndDate", searchParam.EndDate),
_idbHelper.CreateInParam(targetDatabase, ":i_Logogram", searchParam.Logogram),
_idbHelper.CreateInParam(targetDatabase, ":i_BillCode", searchParam.BillCode),
_idbHelper.CreateOutParam(targetDatabase, ":o_return", System.Data.DbType.Object) };
System.Data.DataTable dt = null;
try
{
dt = _idbHelper.ExecuteNQuery(System.Data.CommandType.StoredProcedure, storedProcedureName, targetDatabase, cmdParams);//调用接口的方法
string jsonSql = Util.DbSqlLog.SqlToJson("0000", storedProcedureName, cmdParams);
logMessage = string.Format("GetDgvDtAll 获取数据 执行ExecuteNQuery成功!{0}", string.Empty);
Newtonsoft.Json.Linq.JObject resultJObject = new Newtonsoft.Json.Linq.JObject();
resultJObject.Add("code", new Newtonsoft.Json.Linq.JValue("0000"));
resultJObject.Add("msg", new Newtonsoft.Json.Linq.JValue(logMessage));
resultJObject.Add("sql", new Newtonsoft.Json.Linq.JObject(Newtonsoft.Json.Linq.JObject.Parse(jsonSql)));
logMessage = string.Format("【{0}_{1}】 {2}", searchParam.jobInfo.JobCode, searchParam.jobInfo.JobName.ToString(), Util.NewtonsoftCommon.SerializeObjToJson(resultJObject));
Log4netUtil.Log4NetHelper.LogMessage(logAppendToForms, searchParam.IsDebug, logMessage, @"Database");
}
catch (Exception ex)
{
string jsonSql = Util.DbSqlLog.SqlToJson("9999", storedProcedureName, cmdParams);
logMessage = string.Format("GetDgvDtAll 获取数据 执行ExecuteNQuery失败;失败原因：{0}", ex.Message);
Newtonsoft.Json.Linq.JObject resultJObject = new Newtonsoft.Json.Linq.JObject();
resultJObject.Add("code", new Newtonsoft.Json.Linq.JValue("9999"));
resultJObject.Add("msg", new Newtonsoft.Json.Linq.JValue(logMessage));
resultJObject.Add("sql", new Newtonsoft.Json.Linq.JObject(Newtonsoft.Json.Linq.JObject.Parse(jsonSql)));
logMessage = string.Format("【{0}_{1}】 {2}", searchParam.jobInfo.JobCode, searchParam.jobInfo.JobName.ToString(), Util.NewtonsoftCommon.SerializeObjToJson(resultJObject));
Log4netUtil.Log4NetHelper.LogError(logAppendToForms, searchParam.IsDebug, logMessage, @"Database");
dt = null;
}
return(dt);
}
/// <summary>
/// FtpDownloadToFile
/// </summary>
/// <param name="logAppendToForms"></param>
/// <param name="jobInfo"></param>
/// <param name="ftpfilepath"></param>
/// <param name="fileSavePath"></param>
/// <param name="fileSaveName"></param>
/// <returns></returns>
public string FtpDownloadToFile(Log4netUtil.LogAppendToForms logAppendToForms, Model.JobEntity jobInfo,
string ftpfilepath, string fileSavePath, string fileSaveName, out string extension)
{
Newtonsoft.Json.Linq.JObject jObject = new Newtonsoft.Json.Linq.JObject();
var ftp = new Util.FluentFtpHelper(jobInfo.ConfigInfo.FtpHostIP, jobInfo.ConfigInfo.FtpPort, jobInfo.ConfigInfo.FtpUserName, jobInfo.ConfigInfo.FtpPassword);
if (!ftp.Connect())
{
extension = string.Empty;
jObject.Add("code", "9998");
jObject.Add("msg", "Ftp连接异常!");
jObject.Add("data", string.Empty);
return(jObject.ToString());
}
if (!ftp.isConnected())
{
extension = string.Empty;
jObject.Add("code", "9998");
jObject.Add("msg", "连接Ftp失败!");
jObject.Add("data", string.Empty);
return(jObject.ToString());
}
string localDic = string.Format("{0}\\{1}", fileSavePath, fileSaveName);
string remotePath = ftpfilepath;
if (ftp.DownloadImageFile(fileSavePath, fileSaveName, remotePath, out extension))
{
jObject.Add("code", "0000");
jObject.Add("msg", "Ftp下载文件成功!");
jObject.Add("data", string.Empty);
}
else
{
jObject.Add("code", "9999");
jObject.Add("msg", string.Format("localDic：{0} ;remotePath:{1} ;Ftp下载文件失败!", localDic, remotePath));
jObject.Add("data", string.Empty);
}
Log4netUtil.Log4NetHelper.Error(String.Format(@"ftpDownloadToFile->下载文件 Result:{0}", jObject.ToString()), @"Ftp");
return(jObject.ToString());
}
/// <summary>
/// 复制文件到指写文件夹
/// </summary>
/// <param name="sourceFile">源文件</param>
/// <param name="destinationFile">目标文件</param>
/// <returns> 成功 true 失败 false </returns>
private static bool CopyToFile(Log4netUtil.LogAppendToForms logAppendToForms,
Model.JobEntity jobInfo,
string sourceFile, string destinationFile)
{
System.IO.FileInfo file = new System.IO.FileInfo(sourceFile);
try
{
if (file.Exists)
{
file.CopyTo(destinationFile, true);
return(true);
}
return(false);
}
catch (Exception ex)
{
string logMessage = string.Format("【{0}_{1}】 复制文件失败 ;原因:{2}", jobInfo.JobCode, jobInfo.JobName, ex.Message);
Log4netUtil.Log4NetHelper.LogError(logAppendToForms, true, logMessage, @"Ftp");
return(false);
}
}
/// <summary>
/// 创建FTP工具
/// </summary>
/// <param name="host">主机名称</param>
/// <param name="userId">用户名</param>
/// <param name="password">密码</param>
/// <param name="port">端口</param>
/// <param name="enableSsl">允许Ssl</param>
/// <param name="proxy">代理</param>
/// <param name="useBinary">允许二进制</param>
/// <param name="usePassive">允许被动模式</param>
/// <param name="buffLength">buffLength</param>
public FtpHelper(Log4netUtil.LogAppendToForms logAppendToForms,
string ftpHostIP, string ftpUserName, string ftpPassword, int ftpPort, IWebProxy ftpProxy, bool ftpEnableSsl, bool ftpUseBinary, bool ftpUsePassive, int ftpBuffLength)
{
this.logAppendToForms = logAppendToForms;
this.ftpHostIP = ftpHostIP;
this.ftpUserName = ftpUserName;
this.ftpPassword = ftpPassword;
this.ftpPort = ftpPort;
this.ftpProxy = ftpProxy;
this.ftpEnableSsl = ftpEnableSsl;
this.ftpUseBinary = ftpUseBinary;
this.ftpUsePassive = ftpUsePassive;
this.ftpBuffLength = ftpBuffLength;
if (ftpHostIP.ToLower().StartsWith("ftp://"))
{
this.ftpURI = String.Format("{0}:{1}/", ftpHostIP, ftpPort.ToString());
}
else
{
this.ftpURI = String.Format("ftp://{0}:{1}/", ftpHostIP, ftpPort.ToString());
}
}
/// <summary>
/// CallDtyApi
/// </summary>
/// <param name="logAppendToForms"></param>
/// <param name="dtyApi"></param>
/// <param name="jobInfo"></param>
/// <param name="apiName"></param>
/// <param name="requestData"></param>
/// <param name="result"></param>
/// <returns></returns>
private bool CallDtyApi(Log4netUtil.LogAppendToForms logAppendToForms,
Util.DtyApi dtyApi,
Model.JobEntity jobInfo, string apiName, string requestData, out string result)
{
string logMessage = string.Empty;
//string passKey = "9A7OTA7JTAAJOE3153J17TEEAAJOTJO9";
result = dtyApi.DtyEDIApiByJson(apiName, requestData);
Newtonsoft.Json.Linq.JObject resultJObject = Newtonsoft.Json.Linq.JObject.Parse(result);
if (string.Equals(resultJObject.Value <string>("ErrCode"), "000"))
{
logMessage = string.Format("【{0}_{1}】 result:{2} 成功！ ", jobInfo.JobCode, jobInfo.JobName.ToString(), result);
LogMessage(logAppendToForms, true, logMessage, apiName);
return(true);
}
else
{
logMessage = string.Format("【{0}_{1}】 result:{2} ;失败！原因：{3} ", jobInfo.JobCode, jobInfo.JobName.ToString(), result, resultJObject.Value <string>("ErrMsg"));
LogError(logAppendToForms, true, logMessage, apiName);
return(false);
}
}
/// <summary>
/// frmMain_Load
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void frmMain_Load(object sender, EventArgs e)
{
System.Windows.Forms.Timer timer1 = new System.Windows.Forms.Timer();
this.timer1.Tick += new System.EventHandler(this.timer1_Tick);
this.timer3.Interval = 30 * 1000;
this.timer3.Tick += new System.EventHandler(this.timer3_Tick);
this.timer3.Start();
string isClearFaceLogStr = string.IsNullOrEmpty(Util.INIOperationClass.INIGetStringValue(Util.DalConst._ConfigFile, "Login", "IsClearFaceLog", null)) ? "否" : Util.INIOperationClass.INIGetStringValue(Util.DalConst._ConfigFile, "Login", "IsClearFaceLog", null);
bool isClearFaceLog = string.Equals(isClearFaceLogStr, "是") ? true : false;
if (isClearFaceLog)
{
string clearFaceLogIntervalStr = string.IsNullOrEmpty(Util.INIOperationClass.INIGetStringValue(Util.DalConst._ConfigFile, "Login", "ClearFaceLogInterval", null)) ? "60" : Util.INIOperationClass.INIGetStringValue(Util.DalConst._ConfigFile, "Login", "ClearFaceLogInterval", null);
int clearFaceLogInterval = Util.Common.IsInt(clearFaceLogIntervalStr) ? Convert.ToInt32(clearFaceLogIntervalStr) : 60;
this.timer2.Interval = 60 * 1000;
this.timer2.Tick += new System.EventHandler(this.timer2_Tick);
this.timer2.Start();
}
_ConfigInfo = Util.ConfigInfoLoad.GetConfigInfo();
_LogAppendToForms = new Log4netUtil.LogAppendToForms(); //
_LogAppendToForms._LogAppendDelegate = DisplayJobtimes;
rtxLog.Visible = false;
_EnterpriseName = Util.INIOperationClass.INIGetStringValue(Util.DalConst._ConfigFile, "EnterpriseConfig", "EnterpriseName", null);
_EnterpriseId = Util.INIOperationClass.INIGetStringValue(Util.DalConst._ConfigFile, "EnterpriseConfig", "EnterpriseId", null);
_B2bPlatformName = Util.INIOperationClass.INIGetStringValue(Util.DalConst._ConfigFile, "EnterpriseConfig", "B2bPlatformName", null);
_AutReg = string.Format("{0}{1}", _B2bPlatformName, _AutReg);
this.Text = _AutReg;
HideLog();
this.tsbtnStop.Enabled = false;
if (!_ConfigInfo.IsShowServiceAndSupport)
{
//ToptsmServiceAndSupport.Enabled = false;
//ToptsmServiceAndSupport.Visible = false;
}
}
/// <summary>
/// DtyEDIApiByJson
/// </summary>
/// <param name="logAppendToForms"></param>
/// <param name="jobInfo"></param>
/// <param name="controllerType"></param>
/// <param name="requestData"></param>
/// <returns></returns>
public string DtyEDIApiByJson(Log4netUtil.LogAppendToForms logAppendToForms, Model.JobEntity jobInfo, string controllerType, string requestData)
{
string reqUrl = string.Format("{0}/{1}", ReqUrl, controllerType);
Newtonsoft.Json.Linq.JObject resultJObject = new Newtonsoft.Json.Linq.JObject();
Newtonsoft.Json.Linq.JArray jlistRequestData = Newtonsoft.Json.Linq.JArray.Parse(requestData);
string logMessage = string.Empty;
string result = string.Empty;
Dictionary <string, string> param = new Dictionary <string, string>();
param.Add("Sample", HttpUtility.UrlEncode(requestData, Encoding.UTF8));//请求内容为 JSON 格式
//param.Add("RequestData", HttpUtility.UrlEncode(requestJson, Encoding.UTF8));//请求内容为 JSON 格式
result = sendPost(reqUrl, requestData);
//resultJObject = new Newtonsoft.Json.Linq.JObject();
//logMessage = string.Format("SendPost SyncApiByJson 接口调用! controllerType:{0} ", controllerType);
logMessage = string.Format(" controllerType:{0} ;SendPost SyncApiByJson 接口调用！", controllerType);
logMessage = string.Format("【{0}_{1}】 {2}", jobInfo.JobCode, jobInfo.JobName.ToString(), result);
Log4netUtil.Log4NetHelper.Info(logMessage, @"PrepurchApi");
Log4netUtil.LogDisplayHelper.LogMessage(logAppendToForms, logMessage);
return(result);
}
/// <summary>
/// 填充对象列表：用DataTable填充实体类
/// </summary>
public List <T> FillModel(Log4netUtil.LogAppendToForms logAppendToForms, DataTable dt, string lineMessage = "")
{
if (dt == null || dt.Rows.Count == 0)
{
return(null);
}
List <T> modelList = new List <T>();
try
{
foreach (DataRow dr in dt.Rows)
{
//T model = (T)Activator.CreateInstance(typeof(T));
T model = new T();
for (int i = 0; i < dr.Table.Columns.Count; i++)
{
PropertyInfo propertyInfo = model.GetType().GetProperty(dr.Table.Columns[i].ColumnName, BindingFlags.IgnoreCase | BindingFlags.Public | BindingFlags.Instance);
if (propertyInfo != null && dr[i] != DBNull.Value)
{
string value = dr[i] == null ? "" : dr[i].ToString();
//string typestr = dr[i].GetType().Name;
//if(typestr.Equals("DateTime"))
//value = dr[i].ToString();
propertyInfo.SetValue(model, value, null);
}
}
modelList.Add(model);
}
return(modelList);
}
catch (Exception ex)
{
string logMessage = string.Format(" {0} FillModel DataTable 转换实体类List<T>失败，原因：{1}", lineMessage, ex.Message);
Log4netUtil.LogDisplayHelper.LogError(logAppendToForms, logMessage);
return(null);
}
}
/// <summary>
/// EleInvPrint 打印电子发票
/// </summary>
/// <param name="isAuto"></param>
/// <param name="eInvoicePrintCopies"></param>
/// <param name="paperSizeRawKind"></param>
/// <param name="url"></param>
/// <param name="DataExchangeId"></param>
/// <param name="printerName"></param>
/// <returns></returns>
public static bool ImagePrint(Log4netUtil.LogAppendToForms logAppendToForms,
Model.JobEntity jobInfo,
string url, string fileName)
{
string logMessage = string.Empty;
try
{
if (string.IsNullOrEmpty(url))
{
logMessage = string.Format("【{0}_{1}】 下载及打印文件失败 ;原因:文件路径为空", jobInfo.JobCode, jobInfo.JobName);
Log4netUtil.Log4NetHelper.LogError(logAppendToForms, true, logMessage, @"Ftp");
return(false);
}
return(OpenUrlDownloadFile(logAppendToForms, jobInfo, url, fileName));
}
catch (Exception ex)
{
logMessage = string.Format("【{0}_{1}】 下载及打印文件失败 ;原因:{2}", jobInfo.JobCode, jobInfo.JobName, ex.Message);
Log4netUtil.Log4NetHelper.LogError(logAppendToForms, true, logMessage, @"Ftp");
return(false);
}
}
/// <summary>
/// ConvertJArrayToDataTable
/// </summary>
/// <param name="logAppendToForms"></param>
/// <param name="jobInfo"></param>
/// <param name="dataArr"></param>
/// <returns></returns>
public static System.Data.DataTable ConvertJArrayToDataTable(Log4netUtil.LogAppendToForms logAppendToForms,
Model.JobEntity jobInfo, JArray dataArr)
{
if (dataArr == null || dataArr.Count <= 0)
{
string logMessage = string.Format("【{0}_{1}】 ConvertJArrayToDataTable转换失败!失败原因：JArray为空 ", jobInfo.JobCode, jobInfo.JobName);
Newtonsoft.Json.Linq.JObject resultJObject = new Newtonsoft.Json.Linq.JObject();
resultJObject.Add("code", 999);
resultJObject.Add("msg", logMessage);
resultJObject.Add("data", dataArr.ToString());
logMessage = string.Format("【{0}_{1}】 ConvertJArrayToDataTable转换失败! ", jobInfo.JobCode, jobInfo.JobName);
Log4netUtil.Log4NetHelper.LogError(logAppendToForms, jobInfo.IsDebug, logMessage, string.Format(@"Api\{0}", jobInfo.JobCode));
return(null);
}
System.Data.DataTable resultDt = new System.Data.DataTable();
try
{
var colnames = ((JObject)(dataArr.First)).Properties();
List <string> columnNames = new List <string>();
if (colnames == null || colnames.Count() <= 0)
{
string logMessage = string.Format("【{0}_{1}】 ConvertJArrayToDataTable转换失败!失败原因：JArray Colnames为空 ", jobInfo.JobCode, jobInfo.JobName);
Newtonsoft.Json.Linq.JObject resultJObject = new Newtonsoft.Json.Linq.JObject();
resultJObject.Add("code", 999);
resultJObject.Add("msg", logMessage);
resultJObject.Add("data", dataArr.ToString());
logMessage = string.Format("【{0}_{1}】 ConvertJArrayToDataTable转换失败! ", jobInfo.JobCode, jobInfo.JobName);
Log4netUtil.Log4NetHelper.LogError(logAppendToForms, jobInfo.IsDebug, logMessage, string.Format(@"Api\{0}", jobInfo.JobCode));
return(null);
}
foreach (var item in colnames)
{
if (!columnNames.Contains(item.Name))
{
columnNames.Add(item.Name);
}
resultDt.Columns.Add(item.Name, typeof(string));
}
foreach (JObject data in dataArr)
{
JObject jo = JObject.Parse(data.ToString());
System.Data.DataRow row = resultDt.NewRow();
foreach (var columnName in columnNames)
{
if (jo.Property(columnName) == null)
{
data.Add(columnName, "");
row[columnName] = data[columnName].ToString();
}
else
{
row[columnName] = data[columnName].ToString();
}
}
resultDt.Rows.Add(row);
}
return(resultDt);
}
catch (Exception ex)
{
string logMessage = string.Format("【{0}_{1}】 ConvertJArrayToDataTable转换失败!失败原因：{2} ", jobInfo.JobCode, jobInfo.JobName, ex.Message);
Newtonsoft.Json.Linq.JObject resultJObject = new Newtonsoft.Json.Linq.JObject();
resultJObject.Add("code", 999);
resultJObject.Add("msg", logMessage);
resultJObject.Add("data", dataArr.ToString());
logMessage = string.Format("【{0}_{1}】 ConvertJArrayToDataTable转换失败! ", jobInfo.JobCode, jobInfo.JobName);
Log4netUtil.Log4NetHelper.LogError(logAppendToForms, jobInfo.IsDebug, logMessage, string.Format(@"Api\{0}", jobInfo.JobCode));
return(null);
}
}
/// <summary>
/// ErpWriteback
/// </summary>
/// <param name="logAppendToForms"></param>
/// <param name="writebackParam"></param>
/// <returns></returns>
public bool ErpExecuteProcedure(Log4netUtil.LogAppendToForms logAppendToForms, Model.WritebackParam writebackParam)
{
DALFactory.FactoryDAL fact = new DALFactory.FactoryDAL();
IDAL.ICommonDAL idal = fact.CreateCommonDAL();
return(idal.ErpExecuteProcedure(logAppendToForms, writebackParam));
}
/// <summary>
/// ExecuteScalar
/// </summary>
/// <param name="logAppendToForms"></param>
/// <param name="searchParam"></param>
/// <returns></returns>
public string ExecuteScalar(Log4netUtil.LogAppendToForms logAppendToForms, Model.SearchParam searchParam)
{
DALFactory.FactoryDAL fact = new DALFactory.FactoryDAL();
IDAL.ICommonDAL idal = fact.CreateCommonDAL();
return(idal.ExecuteScalar(logAppendToForms, searchParam));
}
/// <summary>
/// GetDataTableAll
/// </summary>
/// <param name="logAppendToForms"></param>
/// <param name="searchParam"></param>
/// <returns></returns>
public System.Data.DataTable GetDataTableAll(Log4netUtil.LogAppendToForms logAppendToForms, Model.SearchParam searchParam)
{
DALFactory.FactoryDAL fact = new DALFactory.FactoryDAL();
IDAL.ICommonDAL idal = fact.CreateCommonDAL();
return(idal.GetDgvDtAll(logAppendToForms, searchParam));
}
/// <summary>
/// 打开网址并下载文件
/// </summary>
/// <param name="url">下载文件地址</param>
/// <param name="Filename">下载后另存为（全路径）</param>
public static bool OpenUrlDownloadFile(Log4netUtil.LogAppendToForms logAppendToForms, string url, string filename, bool isDebug)
{
return(openUrlDownloadFile(logAppendToForms, url, filename, isDebug));
}
