public lgk.Model.tb_TicketBack GetModel(string where)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 * from tb_TicketBack ");
strSql.Append(" where " + where);
lgk.Model.tb_TicketBack model = new lgk.Model.tb_TicketBack();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), null);
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "")
{
model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString());
}
if (ds.Tables[0].Rows[0]["Type"] != null && ds.Tables[0].Rows[0]["Type"].ToString() != "")
{
model.Type = ds.Tables[0].Rows[0]["Type"].ToString();
}
if (ds.Tables[0].Rows[0]["OrderNo"] != null && ds.Tables[0].Rows[0]["OrderNo"].ToString() != "")
{
model.OrderNo = ds.Tables[0].Rows[0]["OrderNo"].ToString();
}
if (ds.Tables[0].Rows[0]["OrderStatus"] != null && ds.Tables[0].Rows[0]["OrderStatus"].ToString() != "")
{
model.OrderStatus = ds.Tables[0].Rows[0]["OrderStatus"].ToString();
}
if (ds.Tables[0].Rows[0]["Reason"] != null && ds.Tables[0].Rows[0]["Reason"].ToString() != "")
{
model.Reason = ds.Tables[0].Rows[0]["Reason"].ToString();
}
if (ds.Tables[0].Rows[0]["TicketNos"] != null && ds.Tables[0].Rows[0]["TicketNos"].ToString() != "")
{
model.TicketNos = ds.Tables[0].Rows[0]["TicketNos"].ToString();
}
if (ds.Tables[0].Rows[0]["Sign"] != null && ds.Tables[0].Rows[0]["Sign"].ToString() != "")
{
model.Sign = ds.Tables[0].Rows[0]["Sign"].ToString();
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lgk.Model.tb_TicketBack model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_TicketBack(");
strSql.Append("Type,OrderNo,OrderStatus,Reason,TicketNos,FefundMoney,PoundageFee,Sign)");
strSql.Append(" values (");
strSql.Append("@Type,@OrderNo,@OrderStatus,@Reason,@TicketNos,@FefundMoney,@PoundageFee,@Sign)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@Type", SqlDbType.Int),
new SqlParameter("@OrderNo", SqlDbType.VarChar, 100),
new SqlParameter("@OrderStatus", SqlDbType.VarChar),
new SqlParameter("@Reason", SqlDbType.VarChar, 100),
new SqlParameter("@TicketNos", SqlDbType.VarChar, 100),
new SqlParameter("@FefundMoney", SqlDbType.VarChar, 100),
new SqlParameter("@PoundageFee", SqlDbType.VarChar, 100),
new SqlParameter("@Sign", SqlDbType.VarChar, 100)
};
parameters[0].Value = model.Type;
parameters[1].Value = model.OrderNo;
parameters[2].Value = model.OrderStatus;
parameters[3].Value = model.Reason;
parameters[4].Value = model.TicketNos;
parameters[5].Value = model.FefundMoney;
parameters[6].Value = model.PoundageFee;
parameters[7].Value = model.Sign;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_TicketBack model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update tb_TicketBack set ");
strSql.Append("Type=@Type,");
strSql.Append("OrderStatus=@OrderStatus,");
strSql.Append("Reason=@Reason,");
strSql.Append("TicketNos=@TicketNos,");
strSql.Append("Sign=@Sign");
strSql.Append(" where OrderNo=@OrderNo");
SqlParameter[] parameters =
{
new SqlParameter("@Type", SqlDbType.Int),
new SqlParameter("@OrderStatus", SqlDbType.VarChar),
new SqlParameter("@Reason", SqlDbType.VarChar, 100),
new SqlParameter("@TicketNos", SqlDbType.VarChar, 100),
new SqlParameter("@Sign", SqlDbType.VarChar, 100),
new SqlParameter("@OrderNo", SqlDbType.VarChar, 100)
};
parameters[0].Value = model.Type;
parameters[1].Value = model.OrderStatus;
parameters[2].Value = model.Reason;
parameters[3].Value = model.TicketNos;
parameters[4].Value = model.Sign;
parameters[5].Value = model.OrderNo;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(lgk.Model.tb_TicketBack model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(lgk.Model.tb_TicketBack model)
{
return(dal.Add(model));
}
public void ProcessRequest(HttpContext context)
{
string s = "\r\n" + "\r\n" + "\r\n" + "\r\n" + "记录时间" + DateTime.Now.ToString() + "\r\n";
try
{
context.Response.ContentType = "text/plain";
lgk.Model.tb_TicketBack Model = new lgk.Model.tb_TicketBack();
if (context.Request["type"] == null)
{
s = s + "没有回调\r\n";
context.Response.Write("没有回调数据");
}
else
{
Model.Type = context.Request["type"];
if (Model.Type == "0")
{
Model.OrderNo = context.Request["orderno"];
Model.OrderStatus = context.Request["orderstatus"];
Model.Reason = context.Request["reason"];
}
else if (Model.Type == "1")
{
Model.OrderNo = context.Request["orderno"];
Model.OrderStatus = context.Request["orderstatus"];
Model.TicketNos = context.Request["ticketnos"];
}
else if (Model.Type == "3")
{
Model.FefundMoney = context.Request["fefundmoney"];
Model.PoundageFee = context.Request["poundagefee"];
Model.Reason = context.Request["fefunstatemsg"];
Model.OrderStatus = context.Request["fefundstate"];
Model.OrderNo = context.Request["fefundno"];
}
Model.Sign = context.Request["sign"];
s = s + "接受内容信息:通知类型：" + Model.Type + ",订单号：" + Model.OrderNo + "，订单状态：" + Model.OrderStatus + "，返回结果集：" + Model.Reason + "\r\n";
if (Model != null)
{
lgk.Model.tb_TicketBack Modelreback = orderCallbll.GetModel(" OrderNo='" + Model.OrderNo + "'");
if (Modelreback == null)
{
if (orderCallbll.Add(Model) > 0)
{
lgk.Model.tb_TicketOrder order = orderBLL.GetModel("OrdeID='" + Model.OrderNo + "'");
if (order != null)
{
if (orderBLL.UpdateStatus(Convert.ToInt32(Model.OrderStatus), 1, Model.OrderNo))
{
s = s + "更新订单状态成功，订单状态为：" + StateCode(Model.OrderStatus.ToString()) + "\r\n";
//退票退款通知 返还金额到账户
if (Model.Type == "3" || Model.Type == "0" || Model.OrderStatus != "3")
{
lgk.Model.tb_user model = userBLL.GetModel(order.UserID);
model.Emoney += Convert.ToDecimal(order.PayPrice);
userBLL.Update(model);
string bramk = "退票退款:" + order.PayPrice;
ac.AddJournal(Convert.ToInt32(order.UserID), bramk, Convert.ToDecimal(order.PayPrice), 0, model.Emoney, 1);
bllaccount.UpdateBanlcen("TicketAccount", Convert.ToDecimal(order.PayPrice), 2);
}
context.Response.Write("SUCCESS");
}
}
else
{
s = s + "订单不存在\r\n";
context.Response.Write("订单不存在");
}
}
}
else
{
if (orderCallbll.Update(Model))
{
lgk.Model.tb_TicketOrder order = orderBLL.GetModel("OrdeID='" + Model.OrderNo + "'");
if (order != null)
{
if (orderBLL.UpdateStatus(Convert.ToInt32(Model.OrderStatus), 1, Model.OrderNo))
{
s = s + "更新订单状态成功，订单状态为：" + StateCode(Model.OrderStatus.ToString()) + "\r\n";
//退票退款通知 返还金额到账户
if (Model.Type == "3" || Model.Type == "0" || Model.OrderStatus != "3")
{
lgk.Model.tb_user model = userBLL.GetModel(order.UserID);
model.Emoney += Convert.ToDecimal(Model.FefundMoney);
userBLL.Update(model);
string bramk = "退票退款";
ac.AddJournal(Convert.ToInt32(order.UserID), bramk, Convert.ToDecimal(Model.FefundMoney), 0, model.Emoney, 1);
bllaccount.UpdateBanlcen("TicketAccount", Convert.ToDecimal(Model.FefundMoney), 2);
}
}
}
else
{
s = s + "订单不存在\r\n";
context.Response.Write("订单不存在");
}
}
s = s + "重复推送\r\n";
context.Response.Write("SUCCESS");
}
}
else
{
s = s + "回调数据为空\r\n";
context.Response.Write("没有回调数据");
}
}
}
catch (Exception ex)
{
s = s + "回调异常，错误信息" + ex.Message + "\r\n";
context.Response.Write("回调异常，错误信息" + ex.Message);
}
System.IO.File.AppendAllText(context.Server.MapPath("~/log/RequesTicketBacklog/RequestBacklog" + DateTime.Now.Year + "-" + DateTime.Now.Month + "-" + DateTime.Now.Day + ".txt"), s);
}