public GJBZ_PM(GJBZ_PM gp)
{
this.wjm = gp.wjm;
this.wwmc = gp.wwmc;
this.wwztc = gp.wwztc;
this.ys = gp.ys;
this.zf = gp.zf;
this.zf1 = gp.zf1;
this.zfnf = gp.zfnf;
this.zwmc = gp.zwmc;
this.zwztc = gp.zwztc;
this.bbxz = gp.bbxz;
this.bdtbz = gp.bdtbz;
this.bz = gp.bz;
this.bzdhhy = gp.bzdhhy;
this.bzwh = gp.bzwh;
this.ybzwh = gp.ybzwh;
this.bzwjm = gp.bzwjm;
this.cygx = gp.cygx;
this.dlr = gp.dlr;
this.dtbz = gp.dtbz;
this.fbdw = gp.fbdw;
this.fbrq = gp.fbrq;
this.flbm = gp.flbm;
this.gbfl = gp.gbfl;
this.gxrq = gp.gxrq;
this.gxx = gp.gxx;
this.icsfl = gp.icsfl;
this.pzdw = gp.pzdw;
this.qcdw = gp.qcdw;
this.ssrq = gp.ssrq;
}
/// <summary>
/// 在读取数据前,插入一个"原标准文号列"
/// </summary>
/// <param name="reader"></param>
/// <param name="err"></param>
/// <returns></returns>
protected override PM getPM(OleDbDataReader reader, out String err)
{
err = String.Empty;
GJBZ_PM pm = new GJBZ_PM();
if (hasFormatTable)
{
pm.flbm = reader["分类编码"].ToString().Trim();
pm.bzwh = reader["标准文号"].ToString();
pm.ybzwh = pm.bzwh; //记住原有的“标准文号”
pm.wjm = reader["文件名"].ToString().Trim();
pm.ywjm = pm.wjm;
pm.icsfl = reader["ICS分类"].ToString().Trim();
pm.gbfl = reader["GB分类"].ToString().Trim();
pm.bbxz = reader["版本性质"].ToString().Trim();
pm.zwmc = reader["中文名称"].ToString().Trim();
pm.wwmc = reader["外文名称"].ToString().Trim();
try
{
pm.isOK = Boolean.Parse(reader["强制入库"].ToString());
}
catch
{
pm.isOK = false;
}
string dateStr = "";
dateStr = reader["发布日期"].ToString().Trim();
try
{
if (!String.Empty.Equals(dateStr))
{
pm.fbrq = DateTime.Parse(dateStr);
}
} catch
{
err += "发布日期\"" + reader["发布日期"] + "\"出错 ";
}
dateStr = reader["实施日期"].ToString().Trim();
try
{
if (!String.Empty.Equals(dateStr))
{
pm.ssrq = DateTime.Parse(dateStr);
}
}
catch
{
err += "实施日期\"" + reader["实施日期"] + "\"出错 ";
}
pm.cygx = reader["采用关系"].ToString().Trim();
string yeshu = "";
yeshu = reader["页数"].ToString().Trim();
try
{
if (!String.Empty.Equals(yeshu))
{
pm.ys = Int32.Parse(yeshu);
}
else pm.ys = 0;
} catch
{
err += "页数\"" + reader["页数"] + "\"出错 ";
}
try
{
pm.zf = Boolean.Parse(reader["作废"].ToString().Trim());
}
catch (Exception)
{
pm.zf = false;
}
if (true == pm.zf) pm.zf1 = "T";
else pm.zf1 = "F";
pm.dtbz = reader["代替标准"].ToString().Trim();
pm.bdtbz = reader["被代替标准"].ToString().Trim();
pm.zfnf = reader["作废年份"].ToString().Trim();
pm.zwztc = reader["中文主题词"].ToString().Trim();
pm.wwztc = reader["外文主题词"].ToString().Trim();
pm.qcdw = reader["起草单位"].ToString().Trim();
pm.fbdw = reader["发布单位"].ToString().Trim();
pm.pzdw = reader["批准单位"].ToString().Trim();
pm.bzdhhy = reader["标准代号含义"].ToString().Trim();
pm.bz = reader["备注"].ToString().Trim();
pm.gxx = reader["更新项"].ToString().Trim();
}
if (!"".Equals(err)) err += pmKeyInfo(pm);
pm.gxrq = DateTime.Now;
pm.dlr = user.name;
pm.fillEmptyStringAsNull();
return pm;
}
/// <summary>
/// 进行题录页数更新
/// </summary>
/// <param name="wjm"></param>
/// <param name="flbm"></param>
/// <param name="gjbz"></param>
public void UpdatePageNumber(string wjm, string flbm, GJBZ_PM gjbz)
{
string path = destFolder + ConstructWjmPath(flbm);
if (File.Exists(path + wjm))
{
try
{
PdfReader pdf = new PdfReader(path + wjm);
if (null != pdf)
{
gjbz.ys = pdf.NumberOfPages;
pdf.Close();
}
}
catch { }
}
}
/// <summary>
/// 进行潜在的标准代替关系更新
/// </summary>
/// <param name="gp"></param>
/// <returns></returns>
public String UpdateDTBZ(GJBZ_PM gp)
{
String err = String.Empty;
if (gp.bzwh.LastIndexOf('-') < 0)
{
err = "标准文号缺少年份 ";
return err;
}
//进行标准替代关系的更新, 确保标准文号格式正确
string pre_wh = gp.bzwh.Substring(0, gp.bzwh.LastIndexOf('-') + 1);
//找到代替的标准,只代替最近的标准
GJBZ_PM gpm = gjbzDAO.GetAlikeGJBZ_PM(pre_wh, gp.bzwh, "desc");
if (gpm != null && gpm.bzwh.CompareTo(gp.bzwh) < 0)
{
gpm.zf = false;
gpm.zf1 = "F";
gpm.zfnf = gp.bzwh.Substring(gp.bzwh.Length - 4);
if (GlobalMethod.IsBzInvalid(gp.ssrq))
{
gpm.zf = true;
gpm.zf1 = "T";
}
string bzwh_full = ComposeFullBZWH(gp);
if (gpm.bdtbz == null)
{
gpm.bdtbz = bzwh_full;
}
else if (gpm.bdtbz.IndexOf(gp.bzwh) < 0 && gpm.bdtbz.IndexOf(bzwh_full) < 0)
{
if (!"".Equals(gpm.bdtbz)) gpm.bdtbz += ";";
gpm.bdtbz += bzwh_full;
}
bzwh_full = ComposeFullBZWH(gpm);
if (gp.dtbz == null)
{
gp.dtbz = bzwh_full;
}
else if (gp.dtbz.IndexOf(gpm.bzwh) < 0 && gp.dtbz.IndexOf(bzwh_full) < 0)
{
if (!"".Equals(gp.dtbz)) gp.dtbz += ";";
gp.dtbz += bzwh_full;
}
try
{
gjbzDAO.UpdateGJBZ_PM(gpm, user.name);
/* 更新access表中记录 */
if (gp.bzwjm.Equals("NULL")) {
gp.fillEmptyStringAsNull();
deletePM((PM)gp, out err);
insertPM((PM)gp);
gp.eraseNullInEmptyString();
}
}
catch(Exception e)
{
err += "更新替代关系异常(" + e.Message + ") " + pmKeyInfo(gp);
}
}
return err;
}
public override string formatData(PM pm)
{
//反馈信息
String result = String.Empty;
String Empty = "NULL";
GJBZ_PM gjbz = (GJBZ_PM)pm;
//规范“标准文号”
gjbz.bzwh = GlobalMethod.CharConvert(gjbz.bzwh);
string bbxz = gjbz.bbxz;
gjbz.bzwh = FormatBZWH(gjbz.bzwh, ref bbxz, out result);
gjbz.bbxz = bbxz;
gjbz.wjm = BZMethod.BzwhToWjm(gjbz.bzwh, gjbz.bbxz);
gjbz.dtbz = GlobalMethod.CharConvert(gjbz.dtbz);
gjbz.bdtbz = GlobalMethod.CharConvert(gjbz.bdtbz);
string r = "", notnull = "notnull";
if (!gjbz.dtbz.Equals("NULL"))
{
string[] dtbz = gjbz.dtbz.Split(';');
gjbz.dtbz = FormatBZWH(dtbz[0], ref notnull, out r);
for (int i = 1; i < dtbz.Length; i++)
{
gjbz.dtbz += ";" + FormatBZWH(dtbz[i], ref notnull, out r);
}
gjbz.dtbz = BZMethod.dtBzwhSort(gjbz.dtbz);
}
if (!gjbz.bdtbz.Equals("NULL"))
{
string[] bdtbz = gjbz.bdtbz.Split(';');
gjbz.bdtbz = FormatBZWH(bdtbz[0], ref notnull, out r);
for (int i = 1; i < bdtbz.Length; i++)
{
gjbz.bdtbz += ";" + FormatBZWH(bdtbz[i], ref notnull, out r);
}
gjbz.bdtbz = BZMethod.dtBzwhSort(gjbz.bdtbz);
}
result += r;
gjbz.zwmc = GlobalMethod.RemoveQues(gjbz.zwmc);
gjbz.flbm = GlobalMethod.Semicolon(gjbz.flbm);
gjbz.icsfl = GlobalMethod.Semicolon(gjbz.icsfl);
gjbz.gbfl = GlobalMethod.Semicolon(gjbz.gbfl);
gjbz.zwztc = GlobalMethod.Semicolon(gjbz.zwztc);
gjbz.wwztc = GlobalMethod.Semicolon(gjbz.wwztc);
gjbz.dlr = user.name;
gjbz.gxrq = DateTime.Now;
gjbz.bzwjm = Empty;
/* 找出flbm */
/* 通过GB分类查找flbm */
if (gjbz.flbm.Equals(Empty))
{
if (!gjbz.gbfl.Equals(Empty))
{
string[] fl_arr = gjbz.gbfl.Split(';');
for (int i = fl_arr.Length - 1; i >= 0; i--)
{
GJBZ_FL gjbzFL = gjbzDAO.GetGJBZ_FLByZyfl(fl_arr[i]);
if (gjbzFL != null)
{
gjbz.flbm = gjbzFL.flbm;
break;
}
}
}
}
/* 通过相似标准文号查找flbm */
if (gjbz.flbm.Equals(Empty))
{
gjbz.flbm = GetFlbmByHistBZWH(gjbz.bzwh);
}
/* 根据代替标准查找相似标准的分类编码 */
if (gjbz.flbm.Equals(Empty))
{
if (!gjbz.dtbz.Equals(Empty))
{
string[] dtbz_wh = gjbz.dtbz.Split(';');
foreach (string wh in dtbz_wh)
{
gjbz.flbm = GetFlbmByHistBZWH(gjbz.bzwh, wh);
if (!gjbz.flbm.Equals(Empty)) break;
}
}
}
/* 默认的分类编码 */
if (gjbz.flbm.Equals(Empty))
{
gjbz.flbm = "B2A0";
//result += "未找到合适的分类编码 ";
}
//分类编码可能有多个,以分类隔开
String[] flbms = gjbz.flbm.Split(';');
foreach (string flbm in flbms)
{
if (gjbzDAO.GetGJBZ_FLByFlbm(flbm) == null)
{
result += "分类编码" + flbm + "不存在 ";
}
else
{
string bzwjm = fileFolder + ConstructWjmPath(flbm);
if (Directory.Exists(bzwjm))
{
bzwjm += gjbz.wjm;
if (File.Exists(bzwjm))
gjbz.bzwjm = bzwjm;
}
}
}
/* 补全同类标准的空缺字段 */
string prefix = gjbz.bzwh.Substring(0, gjbz.bzwh.LastIndexOf('-') + 1);
if (null != prev_gjbz.bzwh && prev_gjbz.bzwh.IndexOf(prefix) >= 0)
{
if (gjbz.icsfl.Equals("NULL")) gjbz.icsfl = prev_gjbz.icsfl;
if (gjbz.gbfl.Equals("NULL")) gjbz.gbfl = prev_gjbz.gbfl;
}
prev_gjbz = gjbz;
if (Empty.Equals(gjbz.zwmc))
{
result += "中文名称为空 ";
}
if (result.Equals(String.Empty))
{
//拆分连续标准文号
String toSplitBzwh = gjbz.bzwh;
seqBzwh = BZMethod.SplitSeqBZWH(gjbz.bzwh);
foreach (String newBzwh in seqBzwh)
{
gjbz.bzwh = newBzwh;
gjbz.wjm = BZMethod.BzwhToWjm(newBzwh, gjbz.bbxz);
gjbz.fillEmptyStringAsNull();
GJBZ_PM gpm = new GJBZ_PM(gjbz);
gpm.bzwh = newBzwh;
gpm.wjm = gjbz.wjm;
gpm.ybzwh = gpm.bzwh;
seqList.Add((PM)gpm);
}
if (seqBzwh.Count > 0)
{
/* 拆分成功,删除原记录 */
gjbz.bzwh = toSplitBzwh;
gjbz.isValid = false;
string err;
deletePM((PM)gjbz, out err);
}
}
/* 标准文号 不能处理得进行保留 */
if (String.Empty.Equals(result) && !gjbz.isOK && !isBZWHQualified(gjbz.bzwh))
{
gjbz.isValid = false;
goto bzwh_err;
}
if (!result.Equals(String.Empty))
result += pmKeyInfo(pm);
return result;
bzwh_err:
result += "标准文号不能够正确识别 ";
result += pmKeyInfo(pm);
return result;
}
/// <summary>
/// 进行标准的代替关系更新
/// </summary>
/// <param name="bzPM"></param>
public void DTGX_CheckUpdate(GJBZ_PM bzPM)
{
string dtbz = bzPM.dtbz;
string[] dtbz_arr = dtbz.Split(';');
/**
* 更新代替关系
*/
string bzwh;
for (int i = 0; i < dtbz_arr.Length; i++) {
bzwh = dtbz_arr[i];
bzwh = bzwh.Replace("/T", "");
bzwh = bzwh.Replace("/Z", "");
GJBZ_PM oldBZ = gjbzDAO.GetGJBZ_PMByBzwh(bzwh);
if (null != oldBZ)
{
DTGX_Update(oldBZ, bzPM);
}
}
string bdtbz = bzPM.bdtbz;
string[] bdtbz_arr = bdtbz.Split(';');
/**
* 更新被代替关系
*/
for (int i = 0; i < bdtbz_arr.Length ; i++)
{
bzwh = bdtbz_arr[i];
bzwh = bzwh.Replace("/T", "");
bzwh = bzwh.Replace("/Z", "");
GJBZ_PM newBZ = gjbzDAO.GetGJBZ_PMByBzwh(bzwh);
if (null != newBZ)
{
DTGX_Update(bzPM, newBZ);
}
}
}
/// <summary>
/// 找到标准文件并进行上传,同时删除该条记录
/// </summary>
/// <param name="gjbz"></param>
private string UploadBZfile(GJBZ_PM gjbz)
{
string ret = "";
string path = ConstructWjmPath(gjbz.flbm);
if (gjbz.bzwjm.Equals("NULL"))
{
ret = gjbz.wjm;
gjbz.wjm = gjbz.ywjm;
return "对应的文件\"" + ret + "\"不存在.\n";
}
String bzwjm = fileFolder + path;
/* 存在该标准的文件,则进行上传 */
if (File.Exists(bzwjm + gjbz.wjm))
{
gjbz.bzwjm = bzwjm + gjbz.wjm;
try
{
PdfReader pdf = new PdfReader(gjbz.bzwjm);
if (null != pdf)
{
gjbz.ys = pdf.NumberOfPages;
pdf.Close();
}
else
gjbz.ys = 0;
}
catch
{
gjbz.ys = 0;
return gjbz.wjm + " PDF文件存在问题";
}
FileMove.MoveFile(gjbz.bzwjm, gjbz.wjm, destFolder + path);
File.Delete(gjbz.bzwjm);
}
else
{
gjbz.wjm = gjbz.ywjm;
}
return ret;
}
/// <summary>
/// 根据“代替关系“进行代替项的更新，包括”代替标准“与”被代替标准“
/// </summary>
/// <param name="oldGjbz"></param>
/// <param name="newGjbz"></param>
private void DTGX_Update(GJBZ_PM oldBZ, GJBZ_PM newBZ)
{
string bdtbzOfOldBZ = oldBZ.bdtbz;
string dtbzOfNewBZ = newBZ.dtbz;
if (null == bdtbzOfOldBZ) bdtbzOfOldBZ = oldBZ.bdtbz = "";
if (null == dtbzOfNewBZ) dtbzOfNewBZ = newBZ.dtbz = "";
/**
* 更新“被代替标准”的“被代替”字段
*/
string bzwhOfNewBZ = ComposeFullBZWH(newBZ);
if (bdtbzOfOldBZ.IndexOf(bzwhOfNewBZ) < 0)
{
if (!"".Equals(bdtbzOfOldBZ)) oldBZ.bdtbz += ";";
oldBZ.bdtbz += bzwhOfNewBZ;
oldBZ.bdtbz = BZMethod.dtBzwhSort(oldBZ.bdtbz);
if (GlobalMethod.IsBzInvalid(newBZ.ssrq))
{
oldBZ.zf = true;
oldBZ.zf1 = "T";
}
gjbzDAO.UpdateGJBZ_PM(oldBZ, user.name);
}
/**
* 更新“代替标准”的“代替”字段
*/
string bzwhOfOldBZ = ComposeFullBZWH(oldBZ);
if (dtbzOfNewBZ.IndexOf(bzwhOfOldBZ) < 0)
{
if (!"".Equals(dtbzOfNewBZ)) newBZ.dtbz += ";";
newBZ.dtbz += bzwhOfOldBZ;
newBZ.dtbz = BZMethod.dtBzwhSort(newBZ.dtbz);
gjbzDAO.UpdateGJBZ_PM(newBZ, user.name);
}
}
/// <summary>
/// 根据版本性质恢复原有的标准文号
/// </summary>
/// <param name="gp"></param>
/// <returns></returns>
string ComposeFullBZWH(GJBZ_PM gp)
{
string ret = gp.bzwh.Substring(0, gp.bzwh.IndexOf(' '));
if (gp.bbxz != null && (gp.bbxz.Equals("T") || gp.bbxz.Equals("Z")))
{
ret += "/" + gp.bbxz;
}
ret += gp.bzwh.Substring(gp.bzwh.IndexOf(' '));
return ret;
}
/// <summary>
/// 进行追加更新
/// </summary>
/// <param name="dest"></param>
/// <param name="src"></param>
private void AppendUpdate(GJBZ_PM dest, GJBZ_PM src)
{
if (IsEmpty(dest.wjm) && !IsEmpty(src.wjm)) dest.wjm = src.wjm;
if (IsEmpty(dest.bbxz) && !IsEmpty(src.bbxz)) dest.bbxz = src.bbxz;
//if (IsEmpty(dest.flbm) && !IsEmpty(src.flbm)) dest.flbm = src.flbm;
if (IsEmpty(dest.icsfl) && !IsEmpty(src.icsfl)) dest.icsfl = src.icsfl;
if (IsEmpty(dest.gbfl) && !IsEmpty(src.gbfl)) dest.gbfl = src.gbfl;
if (IsEmpty(dest.zwmc) && !IsEmpty(src.zwmc)) dest.zwmc = src.zwmc;
if (IsEmpty(dest.wwmc) && !IsEmpty(src.wwmc)) dest.wwmc = src.wwmc;
if (IsEmpty(dest.cygx) && !IsEmpty(src.cygx)) dest.cygx = src.cygx;
if (IsEmpty(dest.zfnf) && !IsEmpty(src.zfnf)) dest.zfnf = src.zfnf;
if (IsEmpty(dest.zwztc) && !IsEmpty(src.zwztc)) dest.zwztc = src.zwztc;
if (IsEmpty(dest.wwztc) && !IsEmpty(src.wwztc)) dest.wwztc = src.wwztc;
if (IsEmpty(dest.fbdw) && !IsEmpty(src.fbdw)) dest.fbdw = src.fbdw;
if (IsEmpty(dest.qcdw) && !IsEmpty(src.qcdw)) dest.qcdw = src.qcdw;
if (IsEmpty(dest.pzdw) && !IsEmpty(src.pzdw)) dest.pzdw = src.pzdw;
if (IsEmpty(dest.ssrq) && !IsEmpty(src.ssrq)) dest.ssrq = src.ssrq;
if (IsEmpty(dest.fbrq) && !IsEmpty(src.fbrq)) dest.fbrq = src.fbrq;
if (IsEmpty(dest.bzdhhy) && !IsEmpty(src.bzdhhy)) dest.bzdhhy = src.bzdhhy;
if (IsEmpty(dest.gxx) && !IsEmpty(src.gxx)) dest.gxx = src.gxx;
if (IsEmpty(dest.bz) && !IsEmpty(src.bz)) dest.bz = src.bz;
//if (IsEmpty(dest.ys) && !IsEmpty(src.ys)) dest.ys = src.ys;
//if (IsEmpty(dest.zf) && !IsEmpty(src.zf)) dest.zf = src.zf;
if (0 != src.ys) dest.ys = src.ys;
dest.zf |= src.zf;
if (true == dest.zf) dest.zf1 = "T";
else dest.zf1 = "F";
//if (IsEmpty(dest.dtbz) && !IsEmpty(src.dtbz)) dest.dtbz = src.dtbz;
//if (IsEmpty(dest.bdtbz) && !IsEmpty(src.bdtbz)) dest.bdtbz = src.bdtbz;
dest.dtbz = BZMethod.MergeDTGX(src.dtbz, dest.dtbz);
dest.bdtbz = BZMethod.MergeDTGX(src.bdtbz, dest.bdtbz);
}
/// <summary>
/// 获取用户填写的国家标准篇名信息
/// </summary>
/// <returns></returns>
private GJBZ_PM GetGJBZPM()
{
GJBZ_PM gjbzPM = new GJBZ_PM();
//标准文号
gjbzPM.bzwh = this.bzwhTextBox.Text.Trim();
//分类编码
gjbzPM.flbm = this.flbmTextBox.Text;
//文件名
gjbzPM.wjm = this.pdfTextBox.Text;
//中文名称
gjbzPM.zwmc = this.zwmcTextBox.Text.Trim();
//版本性质
gjbzPM.bbxz = this.bbxzTextBox.Text.Trim();
//ICS分类
gjbzPM.icsfl = this.icsflTextBox.Text.Trim();
//GB分类
gjbzPM.gbfl = this.gbflTextBox.Text.Trim();
//外文名称
gjbzPM.wwmc = this.wwmcTextBox.Text.Trim();
//发布日期
if (!"".Equals(this.fbrqTextBox.Text))
{
gjbzPM.fbrq = DateTime.Parse(this.fbrqTextBox.Text);
}
//实施日期
if (!"".Equals(this.ssrqTextBox.Text))
{
gjbzPM.ssrq = DateTime.Parse(this.ssrqTextBox.Text);
}
//采用关系
gjbzPM.cygx = this.cygxTextBox.Text.Trim();
//代替标准
gjbzPM.dtbz = this.dtbzTextBox.Text.Trim();
//被代替标准
gjbzPM.bdtbz = this.bdtbzTextBox.Text.Trim();
//页数
if (!"".Equals(this.ysTextBox.Text))
gjbzPM.ys = Int32.Parse(this.ysTextBox.Text);
//作废
gjbzPM.zf = this.zfCheckBox.Checked;
//作废年份
gjbzPM.zfnf = this.zfnfTextBox.Text.Trim();
//中文主题词
gjbzPM.zwztc = this.zwztcTextBox.Text.Trim();
//外文主题词
gjbzPM.wwztc = this.wwztcTextBox.Text.Trim();
//起草单位
gjbzPM.qcdw = this.qcdwTextBox.Text.Trim();
//发布单位
gjbzPM.fbdw = this.fbdwTextBox.Text.Trim();
//批准单位
gjbzPM.pzdw = this.pzdwTextBox.Text.Trim();
//备注
gjbzPM.bz = this.bzTextBox.Text.Trim();
//标准代号含义
gjbzPM.bzdhhy = this.bzdhhyTextBox.Text.Trim();
//更新项
gjbzPM.gxx = this.gxxTextBox.Text.Trim();
//更新日期
try
{
gjbzPM.gxrq = DateTime.Parse(this.gxrqTextBox.Text.Trim());
}
catch
{
gjbzPM.gxrq = DateTime.Now;
}
//登录人
gjbzPM.dlr = this.dlrTextBox.Text;
return gjbzPM;
}
/// <summary>
/// 生成日志信息
/// </summary>
/// <param name="zwqkPM">中文篇名信息</param>
/// <param name="opType">操作类型</param>
/// <param name="uname">用户名</param>
/// <returns></returns>
private OperationLogItem GetOperationLogItem(GJBZ_PM gjbzPM, String opType, String uname)
{
if (null == gjbzPM)
{
return null;
}
OperationLogItem operationLogItem = new OperationLogItem();
//操作类型
operationLogItem.opType = opType;
//数据库表
operationLogItem.opTable = "GJBZ_PM";
//全文页数
operationLogItem.opPageCount = gjbzPM.ys;
operationLogItem.opObjectID = "国家标准";
// 操作涉及的书刊
operationLogItem.opBookIn = "国家标准";
// 时间
operationLogItem.opDate = DateTime.Now;
// 操作员
operationLogItem.opPerson = uname;
//记录操作模式，判断是否属于批量操作。取值范围SINGLE/BATCH。
operationLogItem.opMode = "SINGLE";
//操作的内容
String content = "('" +
gjbzPM.flbm + "','" + gjbzPM.bzwh + "','" +
gjbzPM.wjm + "','" + gjbzPM.bbxz + "','" +
gjbzPM.zwmc + "','" + gjbzPM.icsfl + "','" +
gjbzPM.gbfl + "','" + gjbzPM.wwmc + "','" +
gjbzPM.fbrq + "','" + gjbzPM.ssrq + "','" +
gjbzPM.cygx + "','" + gjbzPM.dtbz + "','" +
gjbzPM.bdtbz + "','" + gjbzPM.ys + "','" +
gjbzPM.zf + "','" + gjbzPM.zfnf + "','" +
gjbzPM.zwztc + "','" + gjbzPM.wwztc + "','" +
gjbzPM.qcdw + "','" + gjbzPM.fbdw + "','" +
gjbzPM.pzdw + "','" + gjbzPM.bz + "','" +
gjbzPM.bzdhhy + "','" + gjbzPM.gxrq + "','" +
gjbzPM.dlr +
"')";
operationLogItem.opContent = content;
return operationLogItem;
}
/// <summary>
/// 更新一条篇名信息
/// </summary>
/// <param name="gjbz_pm">要更新的篇名信息</param>
/// <param name="uname">操作用户名</param>
/// <returns></returns>
public Boolean UpdateGJBZ_PM(GJBZ_PM gjbz_pm, String uname)
{
Boolean flag = true;
int back = sqlMapper.Update("UpdateGJBZ_PM", gjbz_pm);
if (back <= 0)
{
flag = false;
}
if (flag)
{
OperationLogItem operationLog = this.GetOperationLogItem(gjbz_pm, "UPDATE", uname);
this.operationLogDAO.insertLogItem(operationLog);
}
return flag;
}
/// <summary>
/// 插入一条篇名信息
/// </summary>
/// <param name="gjbz_pm">篇名信息</param>
/// <returns></returns>
public Boolean InsertGJBZ_PM(GJBZ_PM gjbz_pm)
{
Boolean flag = true;
OperationLogItem operationLog = this.GetOperationLogItem(gjbz_pm, "INSERT", null);
try
{
sqlMapper.Insert("InsertGJBZ_PM", gjbz_pm);
this.operationLogDAO.insertLogItem(operationLog);
}
catch (Exception)
{
flag = false;
}
return flag;
}
/// <summary>
/// 插入一条篇名信息
/// </summary>
/// <param name="gjbz_pm">篇名信息</param>
/// <returns></returns>
public String InsertGJBZ_PM(GJBZ_PM gjbz_pm)
{
try
{
sqlMapper.Insert("InsertGJBZ_PM", gjbz_pm);
}
catch (Exception e)
{
return "插入记录异常(" + e.Message + ")";
}
return String.Empty;
}