// 退款SQL操作
public string Refund(string QRCode)
{
//返回的字符串
string callBack = null;
DataTable dt = null;
//判读二维码，并执行相应的操作
int status = IfUsedOrOutTime(QRCode);
switch (status)
{
case 100:
callBack = "判读餐票状态错误";
break;
case 101:
callBack = "已消费,请勿重刷";
break;
case 102:
callBack = "已退款，请勿重刷";
break;
case 1:
callBack = "就餐时间已过，无法退款";
break;
case -1:
try
{
SqlDbOperHandler doh = new SqlDbOperHandler();
doh.Reset();
doh.SqlCmd = "update [m_t_application] set ticketStatus = '已退款',UsedTime = GETDATE() where identification = '" + QRCode + "'";
dt = doh.GetDataTable();
doh.Dispose();
}
catch (Exception e)
{
LogClass.CreateLog(e.Message.ToString());
}
finally
{
callBack = "退款成功";
}
break;
case 0:
//判读有效
try
{
SqlDbOperHandler doh = new SqlDbOperHandler();
doh.Reset();
doh.SqlCmd = "update [m_t_application] set ticketStatus = '已退款',UsedTime = GETDATE() where identification = '" + QRCode + "'";
dt = doh.GetDataTable();
doh.Dispose();
}
catch (Exception e)
{
LogClass.CreateLog(e.Message.ToString());
}
finally
{
callBack = "退款成功";
}
break;
case 404:
callBack = "找不到该二维码";
break;
default:
callBack = "退款查询错误,请联系行政管理员";
break;
}
return(callBack);
}
