/** 修改广告来源信息 */
public void modifyADSouce() {
LEDAdSourceDB tLEDAdSourceDB = new LEDAdSourceDB();
tLEDAdSourceDB.setProductCode(this.getProductCode());
tLEDAdSourceDB.setSiteCode(this.getSiteCode());
if (!tLEDAdSourceDB.getInfo()) {
operateResult = "Fail|修改失败，数据库中没有此广告来源信息";
return;
}
LEDAdSourceSchema tLEDAdSourceSchema = new LEDAdSourceSchema();
tLEDAdSourceSchema.setSchema(tLEDAdSourceDB.getSchema());
tLEDAdSourceSchema.setPayMode(this.getPayMode());
tLEDAdSourceSchema.setContent(this.getContent());
MMap map = new MMap();
map.put(tLEDAdSourceSchema, "UPDATE");
PubSubmit tPubSubmit = new PubSubmit();
VData cVData = new VData();
cVData.add(map);
if (!tPubSubmit.submitData(cVData, "")) {
operateResult = "Fail|修改操作失败";
return;
} else {
operateResult = "Succ|修改成功";
initData();
return;
}
}
/**
* 获取定量数据
*
* @return LEDAdSourceSet
*/
public LEDAdSourceSet getData() {
int tCount = 0;
LEDAdSourceSet tLEDAdSourceSet = new LEDAdSourceSet();
LEDAdSourceSchema tLEDAdSourceSchema = null;
if (null == mResultSet) {
CError tError = new CError();
tError.moduleName = "LEDAdSourceDB";
tError.functionName = "getData";
tError.errorMessage = "数据集为空，请先准备数据集！";
this.mErrors.addOneError(tError);
return null;
}
try {
tCount = 1;
tLEDAdSourceSchema = new LEDAdSourceSchema();
tLEDAdSourceSchema.setSchema(mResultSet, 1);
tLEDAdSourceSet.add(tLEDAdSourceSchema);
// 注意mResultSet.next()的作用
while (tCount++ < SysConst.FETCHCOUNT) {
if (mResultSet.next()) {
tLEDAdSourceSchema = new LEDAdSourceSchema();
tLEDAdSourceSchema.setSchema(mResultSet, 1);
tLEDAdSourceSet.add(tLEDAdSourceSchema);
}
}
} catch (Exception ex) {
CError tError = new CError();
tError.moduleName = "LEDAdSourceDB";
tError.functionName = "getData";
tError.errorMessage = ex.toString();
this.mErrors.addOneError(tError);
try {
mResultSet.close();
mResultSet = null;
} catch (Exception ex2) {
}
try {
mStatement.close();
mStatement = null;
} catch (Exception ex3) {
}
if (!mflag) {
try {
con.close();
} catch (Exception et) {
}
}
return null;
}
return tLEDAdSourceSet;
}
/** 保存数据 */
public void save() {
if (this.getSiteName() == null || "".equals(this.getSiteName())) {
operateResult = "Fail|" + "网站名称不能为空！";
return;
}
if (this.getSiteCode() == null || "".equals(this.getSiteCode())) {
operateResult = "Fail|" + "网站缩写不能为空！";
return;
}
if (this.getProductCode() == null || "".equals(this.getProductCode())) {
operateResult = "Fail|" + "产品不能为空！";
return;
}
if (this.getSiteType() == null || "".equals(this.getSiteType())) {
operateResult = "Fail|" + "网站类型不能为空！";
return;
}
if (this.payModelList == null || this.payModelList.length < 1) {
operateResult = "Fail|" + "支付方式不能为空！";
return;
}
String type = "";
String sql =
"select siteCode,siteType from ledadsource where siteCode='" + this.getSiteCode() + "'";
ExeSQL tExeSQL = new ExeSQL();
SSRS tSSRS = new SSRS();
tSSRS = tExeSQL.execSQL(sql);
int row = tSSRS.getMaxRow();
if (row > 0) {
type = tSSRS.GetText(1, 2);
if (!this.getSiteType().equals(type)) {
operateResult = "Fail|网站编码在数据库中已存在，输入的网站类型与存在的不一致！";
return;
}
}
sql =
"select siteCode from ledadsource where "
+ "siteCode='"
+ this.getSiteCode()
+ "' "
+ "and productcode='"
+ this.getProductCode()
+ "'";
tExeSQL = new ExeSQL();
tSSRS = new SSRS();
tSSRS = tExeSQL.execSQL(sql);
row = tSSRS.getMaxRow();
if (row > 0) {
operateResult = "Fail|" + "添加失败！该数据在数据库中已存在!";
return;
}
if ("all".equals(this.getProductCode())) {
this.setVisitedPage("首页面");
} else if ("register".equals(this.getProductCode())) {
this.setVisitedPage("注册页面");
} else if ("actIndex".equals(this.getProductCode())) {
this.setVisitedPage("宣传页面");
} else if ("readIndex".equals(this.getProductCode())) {
this.setVisitedPage("阅读投保须知页面");
} else {
sql =
"select contplanname from lepplan where contplancode='"
+ this.getProductCode()
+ "' and plantype='00'";
this.setVisitedPage(tExeSQL.getOneValue(sql));
}
String siteUrl = "http://icare.metlife.com.cn/visit.jsf?source=";
LisIDEA tLisIDEA = new LisIDEA();
siteUrl = siteUrl + tLisIDEA.encryptString(this.getSiteCode());
siteUrl = siteUrl + "&product=" + tLisIDEA.encryptString(this.getProductCode());
LEDAdSourceSchema tLEDAdSourceSchema = new LEDAdSourceSchema();
tLEDAdSourceSchema.setContent(this.getContent());
tLEDAdSourceSchema.setProductCode(this.getProductCode());
tLEDAdSourceSchema.setSiteCode(this.getSiteCode());
tLEDAdSourceSchema.setSiteName(this.getSiteName());
tLEDAdSourceSchema.setSiteType(this.getSiteType());
tLEDAdSourceSchema.setUrl(siteUrl);
tLEDAdSourceSchema.setPayMode(this.getPayMode());
tLEDAdSourceSchema.setVisitedPage(this.getVisitedPage());
MMap map = new MMap();
map.put(tLEDAdSourceSchema, "INSERT");
PubSubmit tPubSubmit = new PubSubmit();
VData cVData = new VData();
cVData.add(map);
if (!tPubSubmit.submitData(cVData, "")) {
operateResult = "Fail|添加失败";
return;
} else {
operateResult = "Succ|添加成功";
initData();
find();
return;
}
}
public LEDAdSourceSet executeQuery(String sql, int nStart, int nCount) {
Statement stmt = null;
ResultSet rs = null;
LEDAdSourceSet aLEDAdSourceSet = new LEDAdSourceSet();
if (!mflag) {
con = DBConnPool.getConnection();
}
try {
stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
rs = stmt.executeQuery(StrTool.GBKToUnicode(sql));
int i = 0;
while (rs.next()) {
i++;
if (i < nStart) {
continue;
}
if (i >= nStart + nCount) {
break;
}
LEDAdSourceSchema s1 = new LEDAdSourceSchema();
if (!s1.setSchema(rs, i)) {
// @@错误处理
CError tError = new CError();
tError.moduleName = "LEDAdSourceDB";
tError.functionName = "executeQuery";
tError.errorMessage = "sql语句有误，请查看表名及字段名信息!";
this.mErrors.addOneError(tError);
}
aLEDAdSourceSet.add(s1);
}
try {
rs.close();
} catch (Exception ex) {
}
try {
stmt.close();
} catch (Exception ex1) {
}
} catch (Exception e) {
// @@错误处理
CError tError = new CError();
tError.moduleName = "LEDAdSourceDB";
tError.functionName = "executeQuery";
tError.errorMessage = e.toString();
this.mErrors.addOneError(tError);
try {
rs.close();
} catch (Exception ex2) {
}
try {
stmt.close();
} catch (Exception ex3) {
}
if (!mflag) {
try {
con.close();
} catch (Exception et) {
}
}
}
if (!mflag) {
try {
con.close();
} catch (Exception e) {
}
}
return aLEDAdSourceSet;
}
public LEDAdSourceSet query(int nStart, int nCount) {
Statement stmt = null;
ResultSet rs = null;
LEDAdSourceSet aLEDAdSourceSet = new LEDAdSourceSet();
if (!mflag) {
con = DBConnPool.getConnection();
}
try {
stmt = con.createStatement(ResultSet.TYPE_FORWARD_ONLY, ResultSet.CONCUR_READ_ONLY);
SQLString sqlObj = new SQLString("LEDAdSource");
LEDAdSourceSchema aSchema = this.getSchema();
sqlObj.setSQL(5, aSchema);
String sql = sqlObj.getSQL();
rs = stmt.executeQuery(sql);
int i = 0;
while (rs.next()) {
i++;
if (i < nStart) {
continue;
}
if (i >= nStart + nCount) {
break;
}
LEDAdSourceSchema s1 = new LEDAdSourceSchema();
s1.setSchema(rs, i);
aLEDAdSourceSet.add(s1);
}
try {
rs.close();
} catch (Exception ex) {
}
try {
stmt.close();
} catch (Exception ex1) {
}
} catch (Exception e) {
// @@错误处理
CError tError = new CError();
tError.moduleName = "LEDAdSourceDB";
tError.functionName = "query";
tError.errorMessage = e.toString();
this.mErrors.addOneError(tError);
try {
rs.close();
} catch (Exception ex2) {
}
try {
stmt.close();
} catch (Exception ex3) {
}
if (!mflag) {
try {
con.close();
} catch (Exception et) {
}
}
}
if (!mflag) {
try {
con.close();
} catch (Exception e) {
}
}
return aLEDAdSourceSet;
}