/// <summary>
/// 加载数据
/// </summary>
/// <param name="context"></param>
private static void LoadData(HttpContext context)
{
DataAccess.HandleList runProc = new DataAccess.HandleList();
DataSet ds = runProc.GetList("");
context.Response.Write(JsonConvert.SerializeObject(ds.Tables[0]));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
string jobID = context.Request.Form["jobID"];
DataAccess.TranHelper.BeginTran();
Entity.FlowInfo flow = new Entity.FlowInfo();
flow.Guid = Guid.NewGuid().ToString();
flow.JobID = jobID;
flow.FlowID = 4;
flow.SubmitDate = DateTime.Now;
flow.SubmitUser = PageBase.CommonObject.LoginUserInfo.companyId;
flow.Content = PageBase.CommonObject.LoginCompanyInfo.FULL_NAME + "完成国税.质检.工商部门审批";
flow.IsDelete = false;
flow.Remark = "";
new DataAccess.FlowInfo().Add(flow);
Entity.HandleList handle = new DataAccess.HandleList().DataRowToModel(new DataAccess.HandleList().GetList("OpeartionID=5 and JobID='" + jobID + "'").Tables[0].Rows[0]);
handle.IsChecked = true;
handle.Status = "已处理";
handle.OpeartionUser = PageBase.CommonObject.LoginUserInfo.companyId;
handle.OpeartionTime = DateTime.Now;
handle.Remark = PageBase.CommonObject.LoginCompanyInfo.FULL_NAME + "完成国税.质检.工商部门审批";
new DataAccess.HandleList().Update(handle);
try
{
DataAccess.TranHelper.CommitTran();
context.Response.Write("");
}
catch (Exception ex)
{
context.Response.Write("数据提交出错!" + ex.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
try
{
Dictionary <string, string> dic = new Dictionary <string, string>();
foreach (string key in Request.Params)
{
dic.Add(key, Request.QueryString[key]);
}
if (!DataAccess.PayHelper.Verify(dic))
{
lblMessage.Text = "验签失败.";
}
else
{
string jobID = dic["OrderId"];
string status = dic["Status"];
DateTime date = new DateTime();
try
{
jobID = dic["OrderId"];
status = dic["Status"];
date = DateTime.ParseExact(dic["LastUpdated"], "yyyyMMddHHmmss", null).AddHours(8);
}
catch (Exception ex)
{
lblMessage.Text = "参数错误." + ex.ToString();
return;
}
switch (status)
{
case "Success":
Entity.JobInfo job = new DataAccess.JobInfo().GetModel(jobID);
Entity.HandleList handle = new DataAccess.HandleList().GetFeeData(jobID);
if (job == null || handle == null)
{
lblMessage.Text = "订单数据不存在.";
}
else
{
if (job.FeeFlat.Equals("已缴费"))
{
Response.Redirect("JobList.aspx", false);
}
else
{
job.FeeFlat = "已缴费";
handle.IsChecked = true;
handle.Status = "已处理";
handle.OpeartionUser = job.CustomsCode;
handle.OpeartionTime = date;
handle.Remark = "网上支付";
//提交事务至后台
DataAccess.TranHelper.BeginTran();
new DataAccess.JobInfo().Update(job);
new DataAccess.HandleList().Update(handle);
try
{
DataAccess.TranHelper.CommitTran();
switch (job.JobType)
{
case "NA":
new DataAccess.NADataAccess().ChangeFlow(job);
break;
case "MD":
new DataAccess.MDDataAccess().ChangeFlow(job);
break;
case "RI":
new DataAccess.RIDataAccess().ChangeFlow(job);
break;
case "RM":
new DataAccess.RMDataAccess().ChangeFlow(job);
break;
case "SL":
new DataAccess.SLDataAccess().ChangeFlow(job);
break;
case "UU":
new DataAccess.UUDataAccess().ChangeFlow(job);
break;
}
Response.Redirect("JobList.aspx", false);
}
catch (Exception ex)
{
lblMessage.Text = "更新支付数据失败." + ex.ToString();
return;
}
}
}
break;
default:
break;
}
}
}
catch (Exception ex)
{
lblMessage.Text = "系统错误." + ex.ToString();
return;
}
}
}
public void ProcessRequest(HttpContext context)
{
try
{
context.Response.ContentType = "text/plain";
Dictionary <string, string> dic = new Dictionary <string, string>();
foreach (string key in context.Request.Params)
{
dic.Add(key, context.Request.QueryString[key]);
}
if (!DataAccess.PayHelper.Verify(dic))
{
context.Response.Write(JsonConvert.SerializeObject(new Data("FAIL", "SignatureInvalid")));
}
else
{
string jobID = dic["OrderId"];
string status = dic["Status"];
DateTime date = new DateTime();
try
{
jobID = dic["OrderId"];
status = dic["Status"];
date = DateTime.ParseExact(dic["LastUpdated"], "yyyyMMddHHmmss", null).AddHours(8);
}
catch (Exception ex)
{
context.Response.Write(JsonConvert.SerializeObject(new Data("FAIL", "ArgumentsInvalid." + ex.ToString())));
return;
}
switch (status)
{
case "Success":
Entity.JobInfo job = new DataAccess.JobInfo().GetModel(jobID);
Entity.HandleList handle = new DataAccess.HandleList().GetFeeData(jobID);
if (job == null || handle == null)
{
context.Response.Write(JsonConvert.SerializeObject(new Data("FAIL", "OrderNotFound")));
}
else
{
if (job.FeeFlat.Equals("已缴费"))
{
context.Response.Write(JsonConvert.SerializeObject(new Data("SUCCESS", "OK")));
}
else
{
job.FeeFlat = "已缴费";
handle.IsChecked = true;
handle.Status = "已处理";
handle.OpeartionUser = job.CustomsCode;
handle.OpeartionTime = date;
handle.Remark = "网上支付";
//提交事务至后台
DataAccess.TranHelper.BeginTran();
new DataAccess.JobInfo().Update(job);
new DataAccess.HandleList().Update(handle);
try
{
DataAccess.TranHelper.CommitTran();
switch (job.JobType)
{
case "NA":
new CardCenter.DataAccess.NADataAccess().ChangeFlow(job);
break;
case "MD":
new CardCenter.DataAccess.MDDataAccess().ChangeFlow(job);
break;
case "RI":
new CardCenter.DataAccess.RIDataAccess().ChangeFlow(job);
break;
case "RM":
new CardCenter.DataAccess.RMDataAccess().ChangeFlow(job);
break;
case "SL":
new CardCenter.DataAccess.SLDataAccess().ChangeFlow(job);
break;
case "UU":
new CardCenter.DataAccess.UUDataAccess().ChangeFlow(job);
break;
}
context.Response.Write(JsonConvert.SerializeObject(new Data("SUCCESS", "OK")));
}
catch (Exception ex)
{
context.Response.Write(JsonConvert.SerializeObject(new Data("FAIL", "WriteDataError." + ex.ToString())));
return;
}
}
}
break;
default:
break;
}
}
}
catch (Exception ex)
{
context.Response.Write(JsonConvert.SerializeObject(new Data("FAIL", "SystemError." + ex.ToString())));
return;
}
}
/// <summary>
/// 保存提交
/// </summary>
/// <param name="context"></param>
private static void Save(HttpContext context)
{
context.Response.ContentType = "application/json";
var data = context.Request;
var sr = new StreamReader(data.InputStream);
var stream = sr.ReadToEnd();
var javaScriptSerializer = new JavaScriptSerializer();
RequestDataJSON[] PostedData = javaScriptSerializer.Deserialize <RequestDataJSON[]>(stream);
bool flag = true;
if (PostedData != null)
{
string jobID = null;
DateTime time = DateTime.Now;
DataAccess.TranHelper.BeginTran();
foreach (RequestDataJSON post in PostedData)
{
Entity.HandleList handle = new DataAccess.HandleList().GetModel(post.id);
handle.IsChecked = bool.Parse(post.operation == "" ? "false" : post.operation);
handle.Status = handle.IsChecked ? "已处理" : "待处理";
handle.Remark = post.remark;
handle.OpeartionUser = PageBase.CommonObject.ManagerUserInfo.guid;
handle.OpeartionTime = time;
jobID = handle.JobID;
if (handle.FunctionID.Equals("A06") && handle.JobID.IndexOf("SL") >= 0)
{
DataSet sl = new DataAccess.SaleList().GetList(string.Format("JobID='{0}' and IsDelete=0", handle.JobID));
if (sl.Tables[0].Select("ManagerFlag<>2").Length > 0)
{
flag = false;
}
else
{
new DataAccess.HandleList().Update(handle);
}
}
else
{
new DataAccess.HandleList().Update(handle);
}
if (handle.OpeartionID == 8)
{
Entity.JobInfo job = new DataAccess.JobInfo().GetModel(handle.JobID);
job.FeeFlat = handle.IsChecked ? "已缴费" : "待缴费";
new DataAccess.JobInfo().Update(job);
}
}
try
{
DataAccess.TranHelper.CommitTran();
if (jobID != null)
{
Entity.JobInfo job = new DataAccess.JobInfo().GetModel(jobID);
switch (job.JobType)
{
case "NA":
new DataAccess.NADataAccess().ChangeFlow(job);
break;
case "MD":
new DataAccess.MDDataAccess().ChangeFlow(job);
break;
case "RI":
new DataAccess.RIDataAccess().ChangeFlow(job);
break;
case "RM":
new DataAccess.RMDataAccess().ChangeFlow(job);
break;
case "SL":
new DataAccess.SLDataAccess().ChangeFlow(job);
break;
case "UU":
new DataAccess.UUDataAccess().ChangeFlow(job);
break;
}
}
}
catch (Exception ex)
{
context.Response.Write("提交失败" + ex.Message);
}
}
if (flag)
{
context.Response.Write("提交成功");
}
else
{
context.Response.Write("工单项发放状态标记为“已发放”后，才允许修改发放环节状态！");
}
}
static void Main(string[] args)
{
DataTable dt = new DataAccess.RunProcedure().CloseList();
foreach (DataRow dr in dt.Rows)
{
try
{
Dictionary <string, string> result = new Dictionary <string, string>();
try
{
result = DataAccess.PayHelper.IPaySearch(dr["JobID"].ToString());
}
catch (Exception ex)
{
new DataAccess.Sys_Log().AddLog(string.Format("Function:CloseJob.Main;Param:{0};ErrorMsg:查询接口失败.{1}", dr["JobID"].ToString(), ex.ToString()));
}
bool IsSuccess = false;
if (result["status"] != null)
{
if (result["status"].Equals("Success"))
{
IsSuccess = true;
}
}
if (!IsSuccess)
{
//关闭工单
Entity.FlowInfo flow = new Entity.FlowInfo();
flow.Guid = Guid.NewGuid().ToString();
flow.JobID = dr["JobID"].ToString();
flow.FlowID = 18;
flow.SubmitDate = DateTime.Now;
flow.SubmitUser = "******";
flow.Content = "超时未支付，系统自动关闭工单。";
flow.IsDelete = false;
try
{
if (!new DataAccess.FlowInfo().AddEx(flow))
{
new DataAccess.Sys_Log().AddLog(string.Format("Function:CloseJob.Main;Param:{0};ErrorMsg:关闭工单失败.入库失败", flow.JobID));
}
}
catch (Exception ex)
{
new DataAccess.Sys_Log().AddLog(string.Format("Function:CloseJob.Main;Param:{0};ErrorMsg:关闭工单失败.{1}", flow.JobID, ex.ToString()));
}
//恢复库存
DataTable dtSale = new DataAccess.SaleList().GetList(string.Format("JobID='{0}' and IsDelete=0", flow.JobID)).Tables[0];
foreach (DataRow drSale in dtSale.Rows)
{
Entity.SaleList mSale = new DataAccess.SaleList().DataRowToModel(drSale);
Entity.Stock_Commodity mCommodity = new DataAccess.Stock_Commodity().GetEntity(mSale.ProductType);
mCommodity.StockDesplay += mSale.Num;
try
{
if (!new DataAccess.Stock_Commodity().UpdateEx(mCommodity))
{
new DataAccess.Sys_Log().AddLog(string.Format("Function:CloseJob.Main;Param:{0};ErrorMsg:恢复库存失败.入库失败", flow.JobID));
}
}
catch (Exception ex)
{
new DataAccess.Sys_Log().AddLog(string.Format("Function:CloseJob.Main;Param:{0};ErrorMsg:恢复库存失败.{1}", flow.JobID, ex.ToString()));
}
}
}
else
{
Entity.JobInfo job = new DataAccess.JobInfo().GetModel(dr["JobID"].ToString());
Entity.HandleList handle = new DataAccess.HandleList().GetFeeData(dr["JobID"].ToString());
if (job != null && handle != null)
{
//更新工单缴费信息
job.FeeFlat = "已缴费";
handle.IsChecked = true;
handle.Status = "已处理";
handle.OpeartionUser = job.CustomsCode;
handle.OpeartionTime = DateTime.ParseExact(result["lastUpdated"], "yyyyMMddHHmmss", null).AddHours(8);
handle.Remark = "网上支付";
try
{
if (!new DataAccess.JobInfo().UpdateEx(job) && new DataAccess.HandleList().UpdateEx(handle))
{
new DataAccess.Sys_Log().AddLog(string.Format("Function:CloseJob.Main;Param:{0};ErrorMsg:更新工单失败.入库失败", job.JobID));
}
}
catch (Exception ex)
{
new DataAccess.Sys_Log().AddLog(string.Format("Function:CloseJob.Main;Param:{0};ErrorMsg:更新工单失败.{1}", job.JobID, ex.ToString()));
}
}
}
}
catch (Exception ex)
{
new DataAccess.Sys_Log().AddLog(string.Format("Function:CloseJob.Main;Param:{0};ErrorMsg:未知错误.{1}", dr["JobID"].ToString(), ex.ToString()));
}
}
}
