public void GenerateReprot()
{
{
try
{
string VIN = HttpUtility.UrlDecode(Context.Request["VIN"]);
string XXGKBH = HttpUtility.UrlDecode(Context.Request["XXGKBH"]);
string str = "SELECT * FROM NC_JDCCLXXB WHERE VIN='" + VIN + "'";
DataSet ds = OracleHelper.ExecuteDataSet(CommandType.Text, str);
string oldXXGKBH = "";
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
oldXXGKBH = ds.Tables[0].Rows[0]["XXGKBH"].ToString();
}
}
string code = string.IsNullOrEmpty(oldXXGKBH) ? XXGKBH : oldXXGKBH;
try
{
QRCode.CreateCode(code, Context.Server.MapPath("~"));
}
catch
{
}
if (string.IsNullOrEmpty(oldXXGKBH))
{
string sqlStr = "UPDATE NC_JDCCLXXB SET XXGKBH='" + XXGKBH + "' WHERE VIN='" + VIN + "'";
int result = 0;
int.TryParse(OracleHelper.ExecuteNonQuery(CommandType.Text, sqlStr).ToString(), out result);
if (result > 0)
{
Context.Response.Write(Success("生成成功"));
}
else
{
Context.Response.Write(Failure("生成失败"));
}
}
else
{
Context.Response.Write(SuccessHasOld(oldXXGKBH));
}
}
catch (Exception e)
{
Context.Response.Write(Failure("未知错误！"));
}
}
}
