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("未知错误!")); } } }