static void Main(string[] args)
{
PayStatusNotifyTask paynotify = new PayStatusNotifyTask {
SourceID = "1005", PaymentNo = "445443443", Amount = 1000, BandCODFlag = 0
};
try
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into PayStatusNotifyTask(SourceID,PaymentNo,Amount,BandCODFlag)values(@SourceID,@PaymentNo,@Amount,@BandCODFlag)");
System.Data.SqlClient.SqlParameter[] parm =
{
new System.Data.SqlClient.SqlParameter("@SourceID", paynotify.SourceID),
new System.Data.SqlClient.SqlParameter("@PaymentNo", paynotify.PaymentNo),
new System.Data.SqlClient.SqlParameter("@Amount", paynotify.Amount),
new System.Data.SqlClient.SqlParameter("@BandCODFlag", paynotify.BandCODFlag)
};
//int res= QueryService.Platform.ExecuteSqlCommand(sb.ToString(), parm);
int res = QueryService.Platform.ExecuteSqlCommand(sb.ToString(), parm);
Console.WriteLine("执行完成," + res);
Console.ReadKey();
}
catch (Exception ex)
{
//TxtLoger.SavaLogToTXT("更新任务表异常,id为：" + paynotify.TaskID + "更新出错,错误详情为:" + ex.Message, "a");
throw ex;
}
}
private int UpdateTaskModel(PayStatusNotifyTask paynotify)
{
try
{
StringBuilder sb = new StringBuilder();
sb.Append("update PayStatusNotifyTask set ");
if (paynotify.TaskStatus != null)
{
sb.Append(" TaskStatus=@TaskStatus ");
}
sb.Append(",TaskNum=@TaskNum");
sb.Append(" where TaskID=@TaskID");
if (paynotify.TaskNum < 8)
{
paynotify.TaskNum = paynotify.TaskNum + 1;
}
System.Data.SqlClient.SqlParameter[] parm = { new System.Data.SqlClient.SqlParameter("@TaskStatus", paynotify.TaskStatus),
new System.Data.SqlClient.SqlParameter("@TaskNum", paynotify.TaskNum),
new System.Data.SqlClient.SqlParameter("@TaskID", paynotify.TaskID) };
return(QueryService.Platform.ExecuteSqlCommand(sb.ToString(), parm));
}
catch (Exception ex)
{
//TxtLoger.SavaLogToTXT("更新任务表异常,id为：" + paynotify.TaskID + "更新出错,错误详情为:" + ex.Message, "a");
}
return(0);
}
private int UpdateTaskModel(PayStatusNotifyTask paynotify)
{
var res = new ServiceResult("更新支付通知任务表失败！");
try
{
StringBuilder sb = new StringBuilder();
sb.Append("update PayStatusNotifyTask set ");
if (paynotify.TaskStatus != null)
{
sb.Append(" TaskStatus=@TaskStatus ");
}
sb.Append(",TaskNum=@TaskNum");
sb.Append(" where TaskID=@TaskID");
System.Data.SqlClient.SqlParameter[] parm = { new System.Data.SqlClient.SqlParameter("@TaskStatus", paynotify.TaskStatus),
new System.Data.SqlClient.SqlParameter("@TaskNum", paynotify.TaskNum),
new System.Data.SqlClient.SqlParameter("@TaskID", paynotify.TaskID) };
return(QueryService.Platform.ExecuteSqlCommand(sb.ToString(), parm));
}
catch (Exception ex)
{
TxtLoger.SavaLogToTXT("更新支付通知任务表失败：机构号为：" + paynotify.SourceID + ",update异常详情：" + ex.Message, "a");
res.IsError(ex);
}
return(0);
}
