public override bool checkPMValid(PM pm, out string errMsg)
{
errMsg = String.Empty;
ZGCG_PM zgcg = (ZGCG_PM)pm;
this.openOleDbConnection();
sqlcmd.CommandText = @"select * from " + formatPmTableName
+ " where 成果编号=@成果编号 and 成果名称=@成果名称";
sqlcmd.Connection = this.ObjConnection;
sqlcmd.Parameters.Add(new OleDbParameter("成果编号", zgcg.cgbh));
sqlcmd.Parameters.Add(new OleDbParameter("成果名称", zgcg.cgmc));
OleDbDataReader reader = sqlcmd.ExecuteReader();
if (reader.Read())
{
reader.Close();
sqlcmd.Parameters.Clear();
return true;
}
else
{
reader.Close();
sqlcmd.Parameters.Clear();
return false;
}
}
public override string addOneRecord(PM pm)
{
String err = String.Empty;
XWLW_PM xwlw = (XWLW_PM)pm;
xwlw.gxrq = DateTime.Now;
xwlw.eraseNullInEmptyString();
err += insertPMwithUpdateWJM(pm);
if (!String.Empty.Equals(err))
return err;
String path = "/";
path += xwlw.sybm.Substring(0, 2) + "/";
path += xwlw.sybm.Substring(2, 2) + "/";
path += xwlw.sybm.Substring(5, 4) + "/";
String srcFile;
srcFile = fileFolder + xwlw.wjm_old;
if (!File.Exists(srcFile))
{
srcFile = fileFolder + path + xwlw.wjm_old;
}
String destFile = path + xwlw.wjm;
err = FileMove.MoveFile(srcFile, xwlw.wjm, destFolder + "/" + path);
if (!String.Empty.Equals(err))
{
err = xwlw.wjm_old + " " + err + "\n";
xwlwDAO.DeleteXWLW_PM(xwlw.wjm);
}
else
{
try
{
System.IO.File.Delete(srcFile);
}
catch { }
}
xwlw.fillEmptyStringAsNull();
/* 进行正确记录备份 */
if (String.Empty.Equals(err))
{
pm.isBack = true;
string none = "DONE";
deletePM(pm, out none);
insertPM(pm);
pm.isBack = false;
}
if (!hasFormatTable && String.Empty.Equals(err))
{
err += DeleteWF(pm);
}
return err;
}
public override bool checkPMValid(PM pm, out string errMsg)
{
errMsg = String.Empty;
ZCWX_PM zcwx = (ZCWX_PM)pm;
this.openOleDbConnection();
sqlcmd.CommandText = @"select * from " + formatPmTableName + " where 中文篇名=@中文篇名 and 出版单位=@出版单位";
sqlcmd.Connection = this.ObjConnection;
sqlcmd.Parameters.Add(new OleDbParameter("中文篇名", zcwx.zwpm));
sqlcmd.Parameters.Add(new OleDbParameter("出版单位", zcwx.cbdw));
OleDbDataReader reader = sqlcmd.ExecuteReader();
if (reader.Read())
{
reader.Close();
sqlcmd.Parameters.Clear();
return true;
}
else
{
reader.Close();
sqlcmd.Parameters.Clear();
return false;
}
}
public override bool checkPMValid(PM pm, out string errMsg)
{
errMsg = String.Empty;
KCBG_PM kcbg = (KCBG_PM)pm;
this.openOleDbConnection();
sqlcmd.CommandText = @"select * from " + formatPmTableName
+ " where 索引编码=@索引编码 and 报告名称=@报告名称";
sqlcmd.Connection = this.ObjConnection;
sqlcmd.Parameters.Add(new OleDbParameter("索引编码", kcbg.sybm));
sqlcmd.Parameters.Add(new OleDbParameter("报告名称", kcbg.bgmc));
OleDbDataReader reader = sqlcmd.ExecuteReader();
if (reader.Read())
{
reader.Close();
sqlcmd.Parameters.Clear();
return true;
}
else
{
reader.Close();
sqlcmd.Parameters.Clear();
return false;
}
}
public override bool checkPMValid(PM pm, out string errMsg)
{
errMsg = String.Empty;
GYBG_PM gybg = (GYBG_PM)pm;
this.openOleDbConnection();
sqlcmd.CommandText = @"select * from " + formatPmTableName + " where 年份=@年份 and 标题=@标题";
sqlcmd.Connection = this.ObjConnection;
sqlcmd.Parameters.Add(new OleDbParameter("年份", gybg.nf));
sqlcmd.Parameters.Add(new OleDbParameter("报告名称", gybg.bt));
OleDbDataReader reader = sqlcmd.ExecuteReader();
if (reader.Read())
{
reader.Close();
sqlcmd.Parameters.Clear();
return true;
}
else
{
reader.Close();
sqlcmd.Parameters.Clear();
return false;
}
}
public override string addOneRecord(PM pm)
{
String err = String.Empty;
GYBG_PM gybg = (GYBG_PM)pm;
gybg.gxrq = DateTime.Now;
gybg.eraseNullInEmptyString();
err += insertPMwithUpdateWJM(pm);
if (!String.Empty.Equals(err))
return err;
String path = getGybgFilePath(gybg.sybm);
String srcFile;
srcFile = fileFolder + gybg.ywjm;
if (!File.Exists(srcFile))
srcFile = fileFolder + path + gybg.ywjm;
String destFile = path + gybg.wjm;
err += FileMove.MoveFile(srcFile, gybg.wjm, destFolder + "/" + path);
if (!String.Empty.Equals(err))
{
err += "\n";
gybgDAO.DeleteGYBG_PM(gybg.wjm, user.name);
}
gybg.fillEmptyStringAsNull();
return err;
}
public override bool checkPMValid(PM pm, out string errMsg)
{
errMsg = String.Empty;
DLBK_PM dlbk = (DLBK_PM)pm;
this.openOleDbConnection();
sqlcmd.CommandText = @"select * from " + formatPmTableName
+ " where 分类编码=@分类编码 and 标题=@标题 and 作者=@作者";
sqlcmd.Connection = this.ObjConnection;
sqlcmd.Parameters.Add(new OleDbParameter("分类编码", dlbk.flbm));
sqlcmd.Parameters.Add(new OleDbParameter("标题", dlbk.bt));
sqlcmd.Parameters.Add(new OleDbParameter("作者", dlbk.zz));
OleDbDataReader reader = sqlcmd.ExecuteReader();
if (reader.Read())
{
reader.Close();
sqlcmd.Parameters.Clear();
return true;
}
else
{
reader.Close();
sqlcmd.Parameters.Clear();
return false;
}
}
public override string addOneRecord(PM pm)
{
String err = String.Empty;
ZGCG_PM zgcg = (ZGCG_PM)pm;
zgcg.gxrq = DateTime.Now;
zgcg.eraseNullInEmptyString();
err += insertPMwithUpdateWJM(pm);
if (!String.Empty.Equals(err))
return err;
if (String.Empty.Equals(err))
{
pm.isBack = true;
String dummy = "DONE";
deletePM(pm, out dummy);
insertPM(pm);
pm.isBack = false;
}
if (!hasFormatTable && String.Empty.Equals(err))
{
//删除WF表记录
deleteWFPM(pm, pmTableName, out err);
}
zgcg.fillEmptyStringAsNull();
return err;
}
public override string addOneRecord(PM pm)
{
String err = String.Empty;
BDBK_PM bdbk = (BDBK_PM)pm;
bdbk.gxrq = DateTime.Now;
bdbk.eraseNullInEmptyString();
err += insertPMwithUpdateWJM(pm);
if (!String.Empty.Equals(err))
return err;
String path = "/";
path += bdbk.sybm.Substring(0, 2) + "/";
path += bdbk.sybm.Substring(2, 2) + "/";
path += bdbk.nf.ToString() + "/";
String srcFile;
if (hasFormatTable)
{
srcFile = fileFolder + bdbk.oldWjm;
if (!File.Exists(srcFile))
{
srcFile = fileFolder + path + bdbk.oldWjm;
}
}
else srcFile = fileFolder + bdbk.ywjm;
String destFile = path + bdbk.wjm;
err += FileMove.MoveFile(srcFile, bdbk.wjm, destFolder + "/" + path);
if (!String.Empty.Equals(err))
{
err += "\n";
bdbkDAO.DeleteBDBK_PM(bdbk.wjm);
}
if (String.Empty.Equals(err))
{
pm.isBack = true;
String dummy = "DONE";
deletePM(pm, out dummy);
insertPM(pm);
pm.isBack = false;
}
if (!hasFormatTable && String.Empty.Equals(err))
{
//删除WF表记录
DeletePmByWjm(bdbk.ywjm, pmTableName, out err);
}
bdbk.fillEmptyStringAsNull();
return err;
}
public override string addOneRecord(PM pm)
{
String err = String.Empty;
WWHY_PM wwhy = (WWHY_PM)pm;
wwhy.gxrq = DateTime.Now;
wwhy.eraseNullInEmptyString();
err += insertPMwithUpdateWJM(pm);
if (!String.Empty.Equals(err))
return err;
String path = "/";
path += wwhy.sybm.Substring(0, 2) + "/";
path += wwhy.sybm.Substring(2, 2) + "/";
path += wwhy.sybm.Substring(4, 2) + "/";
path += wwhy.sybm.Substring(6, 2) + "/";
path += wwhy.sybm.Substring(9, 4) + "/";
String srcFile;
srcFile = fileFolder + wwhy.wjm_old;
if (!File.Exists(srcFile))
{
srcFile = fileFolder + path + wwhy.wjm_old;
}
String destFile = path + wwhy.wjm;
err += FileMove.MoveFile(srcFile, wwhy.wjm, destFolder + "/" + path);
if (!String.Empty.Equals(err))
{
err += "\n";
wwhyDAO.deleteWwhyPMByWjm(wwhy.wjm, user.name);
}
//备份到done表记录
if (String.Empty.Equals(err))
{
pm.isBack = true;
String dummy = "DONE";
deletePM(pm, out dummy);
insertPM(pm);
pm.isBack = false;
}
if (!hasFormatTable && String.Empty.Equals(err))
{
//删除WF表记录
deleteWFPM(pm, pmTableName, out err);
}
wwhy.fillEmptyStringAsNull();
return err;
}
public override string addOneRecord(PM pm)
{
String err = String.Empty;
NYBG_PM nybg = (NYBG_PM)pm;
nybg.gxrq = DateTime.Now;
nybg.eraseNullInEmptyString();
err += insertPMwithUpdateWJM(pm);
if (!String.Empty.Equals(err))
return err;
String path = "/";
path += nybg.sybm.Substring(0, 2) + "/";
path += nybg.sybm.Substring(2, 2) + "/";
path += nybg.sybm.Substring(4, 2) + "/";
path += nybg.nf.ToString() + "/";
String srcFile;
if (hasFormatTable)
{
srcFile = fileFolder + nybg.oldWjm;
if (!File.Exists(srcFile))
srcFile = fileFolder + WjmPath(nybg.oldWjm) + nybg.oldWjm;
}
else srcFile = fileFolder + nybg.ywjm;
String destFile = path + nybg.wjm;
err += FileMove.MoveFile(srcFile, nybg.wjm, destFolder + "/" + path);
if (!String.Empty.Equals(err))
{
err += "\n";
nybgDAO.DeleteNYBG_PM(nybg.wjm, user.name);
}
//备份到done表记录
if (String.Empty.Equals(err))
{
pm.isBack = true;
String dummy = "DONE";
deletePM(pm, out dummy);
insertPM(pm);
pm.isBack = false;
}
if (!hasFormatTable && String.Empty.Equals(err))
{
//删除WF表记录
deleteWFPM(pm, pmTableName, out err);
}
nybg.fillEmptyStringAsNull();
return err;
}
public override string addOneRecord(PM pm)
{
String err = String.Empty;
ZWQK_PM zwqk = (ZWQK_PM)pm;
zwqk.eraseNullInEmptyString();
err += insertPMwithUpdateWJM(pm);
if (!String.Empty.Equals(err))
return err;
String path = "/";
path += zwqk.sybm.Substring(0, 2) + "/";
path += zwqk.sybm.Substring(2, 2) + "/";
path += zwqk.sybm.Substring(4, 2) + "/";
path += zwqk.sybm.Substring(6, 2) + "/";
path += zwqk.nf.ToString() + "/";
String srcFile;
srcFile = fileFolder + "/" + zwqk.wjm_old;
if (!File.Exists(srcFile))
{
srcFile = fileFolder + path + zwqk.wjm_old;
}
String destFile = path + zwqk.wjm;
err = FileMove.MoveFile(srcFile, zwqk.wjm, destFolder + "/" + path);
if (!String.Empty.Equals(err))
{
err += pmKeyInfo(zwqk);
try
{
zwqkDAO.deleteZwqkPMByWjm(zwqk.wjm, user.name);
}
catch { }
}
/* delete 正常记录 from 万方表 */
if (!hasFormatTable && err.Equals(String.Empty))
{
err = DeleteWF(zwqk);
}
/* 保存正常记录到ACCESS表中 */
if (err.Equals(String.Empty))
{
//BackupPM(zwqk);
zwqk.isBack = true;
err = insertPM((PM)zwqk);
}
return err;
}
public override string addOneRecord(PM pm)
{
String err = String.Empty;
ZCWX_PM zcwx = (ZCWX_PM)pm;
zcwx.gxrq = DateTime.Now;
zcwx.eraseNullInEmptyString();
err += insertPMwithUpdateSybm(pm);
return err;
}
public override int deletePM(PM pm, out String err)
{
int back = 0;
err = String.Empty;
ZCWX_PM ZCWX = (ZCWX_PM)pm;
//打开连接
this.openOleDbConnection();
OleDbCommand sqlcmd = new OleDbCommand();
if (!String.Empty.Equals(validateTableName(formatPmTableName)))
{
sqlcmd.CommandText = @"create Table " + formatPmTableName + @"(分类编码 char(10), 索引编码 char(20), 馆藏号 char(50), 中文篇名 char(255), 出版单位 char(255), 文献密级 char(4), 文献类型 char(4), 责任个人 char(255), 责任单位 char(255), 出版日期 datetime, 载体形态 char(20), 国图分类 char(50), 中文主题词 char(255), 中文文摘 text, 备注 text, 更新日期 datetime, 登录人 char(20))";
sqlcmd.Connection = this.ObjConnection;
try
{
back = sqlcmd.ExecuteNonQuery();
}
catch (Exception e)
{
err = e.Message + "\n";
return 0;
}
}
//sql语句
sqlcmd.CommandText = @"delete from " + formatPmTableName + " where 中文篇名=@中文篇名 and 出版单位=@出版单位 and 出版日期=@出版日期";
sqlcmd.Connection = this.ObjConnection;
sqlcmd.Parameters.Add(new OleDbParameter("中文篇名", ZCWX.zwpm));
sqlcmd.Parameters.Add(new OleDbParameter("出版单位", ZCWX.cbdw));
OleDbParameter parameter = new OleDbParameter("出版日期", OleDbType.DBDate);
if (ZCWX.cbrq == null) parameter.Value = DBNull.Value;
else parameter.Value = ZCWX.cbrq;
sqlcmd.Parameters.Add(parameter);
try
{
back = sqlcmd.ExecuteNonQuery();
}
catch (Exception e)
{
err = "Exception: " + e.Message + "\n";
}
sqlcmd.Parameters.Clear();
return back;
}
public override string addOneRecord(PM pm)
{
String err = String.Empty;
KCBG_PM kcbg = (KCBG_PM)pm;
kcbg.gxrq = DateTime.Now;
kcbg.eraseNullInEmptyString();
err += insertPMwithUpdateWJM(pm);
if (!String.Empty.Equals(err))
return err;
String path = getKjbgFilePath(kcbg.sybm);
String srcFile;
srcFile = fileFolder + kcbg.ywjm;
if (!File.Exists(srcFile))
srcFile = fileFolder + path + kcbg.ywjm;
String destFile = path + kcbg.wjm;
err += FileMove.MoveFile(srcFile, kcbg.wjm, destFolder + "/" + path);
if (!String.Empty.Equals(err))
{
err += "\n";
kcbgDAO.DeleteKCBG_PM(kcbg.wjm, user.name);
}
kcbg.fillEmptyStringAsNull();
/* 进行正确记录备份 */
if (String.Empty.Equals(err))
{
pm.isBack = true;
string none = "DONE";
deletePM(pm, out none);
insertPM(pm);
pm.isBack = false;
}
return err;
}
public override string addOneRecord(PM pm)
{
String err = String.Empty;
GJBZ_PM gjbz = (GJBZ_PM)pm;
gjbz.gxrq = DateTime.Now;
gjbz.eraseNullInEmptyString();
try
{
/**
* 更新代替关系1.自动查找代替2.补充代替
*/
err += UpdateDTBZ(gjbz);
DTGX_CheckUpdate(gjbz);
gjbz.dtbz = BZMethod.DTBZRemoveDup(gjbz.dtbz);
gjbz.bdtbz = BZMethod.DTBZRemoveDup(gjbz.bdtbz);
UploadBZfile(gjbz);
err += gjbzDAO.InsertGJBZ_PM(gjbz);
if (String.Empty.Equals(err))
{
/* 进行正确记录的备份 */
pm.isBack = true;
deletePM(pm, out err);
insertPM(pm);
pm.isBack = false;
}
}
catch (Exception e)
{
err += "插入记录异常(" + e.Message + ")" + pmKeyInfo(pm);
}
if (!err.Equals(String.Empty))
err += pmKeyInfo(pm);
return err;
}
public override string addOneRecord(PM pm)
{
String err = String.Empty;
WJGF_PM wjgf = (WJGF_PM)pm;
String path = getXwjmPath(wjgf.xwjm);
String srcFile;
srcFile = fileFolder + "/" + wjgf.ywjm;
String destFile = path + wjgf.xwjm;
err += FileMove.MoveFile(srcFile, wjgf.xwjm, destFolder + path);
if (!String.Empty.Equals(err))
{
err += "\n";
}
return err;
}
public override string addOneRecord(PM pm)
{
String err = String.Empty;
DLBK_PM dlbk = (DLBK_PM)pm;
dlbk.gxrq = DateTime.Now;
dlbk.eraseNullInEmptyString();
try
{
dlbkDAO.InsertDLBK_PM(dlbk);
}
catch (Exception e)
{
err += "主库插入异常(" + e.Message + ")" + pmKeyInfo(pm);
}
/* 关键词为空时 */
dlbk.fillEmptyStringAsNull();
return err;
}
public override string addOneRecord(PM pm)
{
String err = String.Empty;
KJCG_PM kjcg = (KJCG_PM)pm;
kjcg.gxrq = DateTime.Now;
kjcg.cgdm = getCgdm(kjcg);
kjcg.sbbm = getSbbm(kjcg);
kjcg.eraseNullInEmptyString();
try
{
kjcgDAO.InsertKJCG_PM(kjcg);
}
catch (Exception e)
{
err += e.Message + "\n";
}
return err;
}
public override string addOneRecord(PM pm)
{
String err = String.Empty;
HYBZ_PM hybz = (HYBZ_PM)pm;
hybz.eraseNullInEmptyString();
try
{
/**
* 更新代替关系1.自动查找代替2.补充代替
*/
err += UpdateDTBZ(hybz);
DTGX_CheckUpdate(hybz);
hybz.dtbz = BZMethod.DTBZRemoveDup(hybz.dtbz);
hybz.bdtbz = BZMethod.DTBZRemoveDup(hybz.bdtbz);
UploadBZfile(hybz);
err += hybzDAO.InsertHYBZ_PM(hybz);
if (String.Empty.Equals(err))
{
/* 进行正确记录的备份 */
pm.isBack = true;
deletePM(pm, out err);
insertPM(pm);
pm.isBack = false;
}
}
catch (Exception e)
{
err += "添加表记录异常(" + e.Message + ")" + pmKeyInfo(pm);
}
return err;
}
public override string addOneRecord(PM pm)
{
String err = String.Empty;
GDFG_PM gdfg = (GDFG_PM)pm;
gdfg.gxrq = DateTime.Now;
gdfg.eraseNullInEmptyString();
err += insertPMwithUpdateWJM(pm);
if (!String.Empty.Equals(err))
return err;
String path = "/";
path += gdfg.sybm.Substring(0, 2) + "/";
path += gdfg.sybm.Substring(2, 2) + "/";
path += gdfg.sybm.Substring(4, 2) + "/";
path += gdfg.sybm.Substring(6, 2) + "/";
path += gdfg.sybm.Substring(8, 2) + "/";
path += gdfg.sybm.Substring(10, 2) + "/";
path += ((DateTime)gdfg.fbrq).Year.ToString() + "/";
String destFile = path + gdfg.wjm;
String srcFile = fileFolder + gdfg.ywjm;
if (!File.Exists(srcFile))
srcFile = fileFolder + path + gdfg.ywjm;
err += FileMove.MoveFile(srcFile, gdfg.wjm, destFolder + path);
if (!String.Empty.Equals(err))
{
err += "\n";
gdfgDAO.DeleteGDFG_PM(gdfg.wjm);
}
return err;
}
public override string addOneRecord(PM pm)
{
String err = String.Empty;
GJIBZ_PM gjibz = (GJIBZ_PM)pm;
gjibz.gxrq = DateTime.Now;
gjibz.eraseNullInEmptyString();
try
{
err += UpdateDTBZ(gjibz);
/**
* 进行代替关系的更新
*/
DTGX_CheckUpdate(gjibz);
UploadBZfile(gjibz);
err += gjibzDAO.InsertGJIBZ_PM(gjibz);
if (String.Empty.Equals(err))
{
/* 进行正确记录的备份 */
pm.isBack = true;
deletePM(pm, out err);
insertPM(pm);
pm.isBack = false;
}
}
catch (Exception e)
{
err += "添加记录异常(" + e.Message + ")" + pmKeyInfo(pm);
}
return err;
}
public override String insertPMwithUpdateWJM(PM pm)
{
String err = String.Empty;
NYBG_PM nybg = (NYBG_PM)pm;
int index;
index = nybg.ywjm.LastIndexOf('/');
int serial;
if ("ml".Equals(nybg.ywjm.Substring(index + 1, 2)))
{
serial = 0;
}
else
{
NYBG_PM maxPm = nybgDAO.getMaxNYBG_PM(nybg.flbm, nybg.nf.ToString());
if (maxPm != null)
{
int pos = maxPm.wjm.LastIndexOf('-');
serial = int.Parse(maxPm.wjm.Substring(pos + 1, 4)) + 1;
}
else
{
serial = 1;
}
}
String suffixStr;
if (hasFormatTable) suffixStr = GlobalMethod.GetFileExtention(nybg.oldWjm);
else suffixStr = GlobalMethod.GetFileExtention(nybg.ywjm);
String serialStr = "0000" + serial.ToString();
nybg.wjm = nybg.sybm + "-" + serialStr.Substring(serialStr.Length - 4) + suffixStr;
try
{
nybgDAO.InsertNYBG_PM(nybg);
}
catch (Exception e)
{
err += "插入主库记录异常(" + e.Message + ")" + pmKeyInfo(pm);
}
return err;
}
public override String insertPM(PM pm)
{
NYBG_PM nybg = (NYBG_PM)pm;
int back;
String err = String.Empty;
//打开连接
this.openOleDbConnection();
String tableName = null;
if (!pm.isBack) tableName = formatPmTableName;
else tableName = doneTable;
sqlcmd.CommandText = @"insert into " + tableName + @"(分类编码,索引编码,文件名,页数,报告名称,年份,出版日期,作者,作者单位,主办单位,主题词,文摘,报告号,分类体系,子分类,文献编号,原文件名,全文,更新日期,登录人) values(@分类编码,@索引编码,@文件名,@页数,@报告名称,@年份,@出版日期,@作者,@作者单位,@主办单位,@主题词,@文摘,@报告号,@分类体系,@子分类,@文献编号,@原文件名,@全文,@更新日期,@登录人)";
sqlcmd.Connection = this.ObjConnection;
sqlcmd.Parameters.Add(new OleDbParameter("分类编码", nybg.flbm));
sqlcmd.Parameters.Add(new OleDbParameter("索引编码", nybg.sybm));
sqlcmd.Parameters.Add(new OleDbParameter("文件名", nybg.wjm));
sqlcmd.Parameters.Add(new OleDbParameter("页数", nybg.ys));
sqlcmd.Parameters.Add(new OleDbParameter("报告名称", nybg.bgmc));
sqlcmd.Parameters.Add(new OleDbParameter("年份", nybg.nf));
sqlcmd.Parameters.Add(new OleDbParameter("出版日期", nybg.cbrq));
sqlcmd.Parameters.Add(new OleDbParameter("作者", nybg.zz));
sqlcmd.Parameters.Add(new OleDbParameter("作者单位", nybg.zzdw));
sqlcmd.Parameters.Add(new OleDbParameter("主办单位", nybg.zbdw));
sqlcmd.Parameters.Add(new OleDbParameter("主题词", nybg.ztc));
sqlcmd.Parameters.Add(new OleDbParameter("文摘", nybg.wz));
sqlcmd.Parameters.Add(new OleDbParameter("报告号", nybg.bgh));
sqlcmd.Parameters.Add(new OleDbParameter("分类体系", nybg.fltx));
sqlcmd.Parameters.Add(new OleDbParameter("子分类", nybg.zfl));
sqlcmd.Parameters.Add(new OleDbParameter("文献编号", nybg.wxbh));
sqlcmd.Parameters.Add(new OleDbParameter("原文件名", nybg.ywjm));
sqlcmd.Parameters.Add(new OleDbParameter("全文", nybg.qw));
OleDbParameter parameter = new OleDbParameter("更新日期", OleDbType.DBDate);
parameter.Value = nybg.gxrq;
sqlcmd.Parameters.Add(parameter);
sqlcmd.Parameters.Add(new OleDbParameter("登录人", nybg.dlr));
try
{
back = sqlcmd.ExecuteNonQuery();
}
catch (Exception e)
{
err = "插入表\"" + tableName + "\"异常(" + e.Message + ")" + pmKeyInfo(pm);
}
sqlcmd.Parameters.Clear();
return err;
}
public override string formatData(PM pm)
{
//反馈信息
String result = String.Empty;
String Empty = "NULL";
NYBG_PM nybg = (NYBG_PM)pm;
nybg.zz = GlobalMethod.Semicolon(nybg.zz);
nybg.zzdw = GlobalMethod.Semicolon(nybg.zzdw);
nybg.zbdw = GlobalMethod.Semicolon(nybg.zbdw);
nybg.ztc = GlobalMethod.Semicolon(nybg.ztc);
nybg.zfl = GlobalMethod.Semicolon(nybg.zfl);
if (nybg.zzdw.Length > 200) nybg.zzdw = nybg.zzdw.Substring(0, 200);
if (nybg.ztc.Length > 200) nybg.ztc = nybg.ztc.Substring(0, 200);
nybg.oldWjm = nybg.wjm;
nybg.wjm = "自动生成";
nybg.dlr = user.name;
nybg.gxrq = DateTime.Now;
nybg.sybm = nybg.flbm + "-" + nybg.nf.ToString();
if (nybgDAO.GetNYBG_FLByFlbm(nybg.flbm) == null)
{
result += "分类编码" + nybg.flbm + "不存在 ";
}
if (!hasFormatTable)
{
if (Empty.Equals(nybg.ywjm))
{
result += "原文件名（PDF全文）为空 ";
nybg.qw = false;
}
else
{
#if nodef
try
{
if (!File.Exists(fileFolder + nybg.ywjm))
{
String filePDF = fileFolder + nybg.ywjm;
if (!Directory.Exists(Path.GetDirectoryName(filePDF)))
Directory.CreateDirectory(Path.GetDirectoryName(filePDF));
File.Copy(fileFolder + "exp.pdf", fileFolder + nybg.ywjm);
}
}
catch
{
}
#endif
if (!File.Exists(fileFolder + nybg.ywjm))
{
result += nybg.ywjm + " PDF文件不存在";
nybg.qw = false;
}
else
{
nybg.qw = true;
try
{
PdfReader pdf = new PdfReader(fileFolder + nybg.ywjm);
if (null != pdf)
{
nybg.ys = pdf.NumberOfPages;
}
else
{
nybg.ys = 0;
}
pdf.Close();
}
catch
{
result += nybg.ywjm + " PDF文件存在问题.";
}
}
}
}
else
{
#if nodef
try
{
if (!File.Exists(fileFolder + nybg.oldWjm))
{
String filePDF = fileFolder + nybg.oldWjm;
if (!Directory.Exists(Path.GetDirectoryName(filePDF)))
Directory.CreateDirectory(Path.GetDirectoryName(filePDF));
File.Copy(fileFolder + "exp.pdf", fileFolder + nybg.oldWjm);
}
}
catch
{
}
#endif
if (Empty.Equals(nybg.oldWjm)) result += " 全文为空";
else if (!File.Exists(fileFolder + nybg.oldWjm)
&& !File.Exists(fileFolder + WjmPath(nybg.oldWjm) + nybg.oldWjm))
result += nybg.oldWjm + " 全文不存在";
}
if (Empty.Equals(nybg.bgmc))
{
result += "报告名称为空 ";
}
if (nybg.nf == 0)
{
result += "年份为空 ";
}
if (null != lastPM)
{
if (sortPM(lastPM, pm) == 0)
{
result += " 篇名重复";
pm.isValid = false;
}
}
lastPM = pm;
if (!result.Equals(String.Empty))
{
result += pmKeyInfo(pm);
}
return result;
}
public override bool findServerDuplicate(PM pm)
{
NYBG_PM nybg = (NYBG_PM)pm;
int result = nybgDAO.QueryNybgPM(nybg.sybm, nybg.nf.ToString(), nybg.bgmc);
if (result != 0)
return true;
else
return false;
}
public int deleteWFPM(PM pm, String tableName, out String err)
{
int back = 0;
err = String.Empty;
NYBG_PM zgcg = (NYBG_PM)pm;
//打开连接
this.openOleDbConnection();
//sql语句
sqlcmd.CommandText = @"delete from " + tableName
+ " where Title=@报告名称 and PY=@年份";
sqlcmd.Connection = this.ObjConnection;
sqlcmd.Parameters.Add(new OleDbParameter("报告名称", zgcg.bgmc));
sqlcmd.Parameters.Add(new OleDbParameter("年份", zgcg.nf));
if (!"".Equals(zgcg.bgh))
{
sqlcmd.CommandText += " and ReportNum=@报告号";
sqlcmd.Parameters.Add(GlobalMethod.NewDbPara("报告号", zgcg.bgh));
}
try
{
back = sqlcmd.ExecuteNonQuery();
}
catch (Exception e)
{
err = "删除表\"" + tableName + "\"异常(" + e.Message + ")" + pmKeyInfo(pm);
}
sqlcmd.Parameters.Clear();
return back;
}
public override String pmKeyInfo(PM pm)
{
NYBG_PM nybgPM = (NYBG_PM)pm;
String retMsg = " : " + nybgPM.nf + " 年, 报告名称《" + nybgPM.bgmc + "》\n";
return retMsg;
}
private static int sortPM(PM a, PM b)
{
int ret = 0;
NYBG_PM za = (NYBG_PM)a;
NYBG_PM zb = (NYBG_PM)b;
if ((ret = za.bgmc.CompareTo(zb.bgmc)) == 0)
{
if ((ret = za.nf.CompareTo(zb.nf)) == 0)
{
return za.flbm.CompareTo(zb.flbm);
}
}
return ret;
}
public override int deletePM(PM pm, out String err)
{
int back = 0;
err = String.Empty;
NYBG_PM nybg = (NYBG_PM)pm;
//打开连接
this.openOleDbConnection();
String tableName = null;
if (!pm.isBack) tableName = formatPmTableName;
else tableName = doneTable;
//sql语句
sqlcmd.Connection = this.ObjConnection;
sqlcmd.CommandText = @"delete from " + tableName
+ " where 索引编码=@索引编码 and 年份=@年份 and 报告名称=@报告名称";
sqlcmd.Parameters.Add(new OleDbParameter("索引编码", nybg.sybm));
sqlcmd.Parameters.Add(new OleDbParameter("年份", nybg.nf));
sqlcmd.Parameters.Add(new OleDbParameter("报告名称", nybg.bgmc));
try
{
back = sqlcmd.ExecuteNonQuery();
}
catch (Exception e)
{
err = "删除表\"" + tableName + "\"异常(" + e.Message + ")" + pmKeyInfo(pm);
}
sqlcmd.Parameters.Clear();
return back;
}
