/// <summary>
/// 更新一条篇名信息
/// </summary>
/// <param name="gybg_pm">要更新的篇名信息</param>
/// <param name="uname">操作用户名</param>
/// <returns></returns>
public Boolean UpdateGYBG_PM(GYBG_PM gybg_pm, String uname)
{
Boolean flag = true;
int back=sqlMapper.Update("UpdateGYBG_PM", gybg_pm);
if (back <= 0)
{
flag = false;
}
if (flag)
{
OperationLogItem operationLog = this.GetOperationLogItem(gybg_pm, "UPDATE", uname);
this.operationLogDAO.insertLogItem(operationLog);
}
return flag;
}
/// <summary>
/// 生成日志信息
/// </summary>
/// <param name="zwqkPM">中文篇名信息</param>
/// <param name="opType">操作类型</param>
/// <param name="uname">用户名</param>
/// <returns></returns>
private OperationLogItem GetOperationLogItem(GYBG_PM gybgPM, String opType, String uname)
{
if (null == gybgPM)
{
return null;
}
OperationLogItem operationLogItem = new OperationLogItem();
//操作类型
operationLogItem.opType = opType;
//数据库表
operationLogItem.opTable = "GYBG_PM";
//全文页数
try
{
operationLogItem.opPageCount = Int32.Parse(gybgPM.ys);
}
catch (Exception)
{
}
operationLogItem.opObjectID = "国研报告";
// 操作涉及的书刊
operationLogItem.opBookIn = "国研报告";
// 时间
operationLogItem.opDate = DateTime.Now;
// 操作员
operationLogItem.opPerson = uname;
//记录操作模式，判断是否属于批量操作。取值范围SINGLE/BATCH。
operationLogItem.opMode = "SINGLE";
//操作的内容
String content = "('" + gybgPM.flbm + "','" + gybgPM.sybm + "','" + gybgPM.wjm + "','" + gybgPM.dwjm + "','" + gybgPM.lm + "','" + gybgPM.bt + "','" + gybgPM.zzdw + "','" + gybgPM.zz + "','" + gybgPM.nf + "','" + gybgPM.bgrq + "','" + gybgPM.ztc + "','" + gybgPM.ly + "','" + gybgPM.wz + "','" + gybgPM.gxrq + "','" + gybgPM.ys + "')";
operationLogItem.opContent = content;
return operationLogItem;
}
/// <summary>
/// 插入一条篇名信息
/// </summary>
/// <param name="gybg_pm">篇名信息</param>
/// <returns></returns>
public Boolean InsertGYBG_PM(GYBG_PM gybg_pm)
{
Boolean flag = true;
OperationLogItem operationLog = this.GetOperationLogItem(gybg_pm, "INSERT", null);
try
{
sqlMapper.Insert("InsertGYBG_PM", gybg_pm);
this.operationLogDAO.insertLogItem(operationLog);
}
catch (Exception)
{
flag = false;
}
return flag;
}
/// <summary>
/// 更新一条篇名信息
/// </summary>
/// <param name="gybg_pm">要更新的篇名信息</param>
/// <param name="uname">操作用户名</param>
/// <returns></returns>
public Boolean UpdateGYBG_PM(GYBG_PM gybg_pm, String uname)
{
Boolean flag = true;
int back=sqlMapper.Update("UpdateGYBG_PM", gybg_pm);
if (back <= 0)
{
flag = false;
}
return flag;
}
/// <summary>
/// 插入一条篇名信息
/// </summary>
/// <param name="gybg_pm">篇名信息</param>
/// <returns></returns>
public Boolean InsertGYBG_PM(GYBG_PM gybg_pm)
{
Boolean flag = true;
try
{
sqlMapper.Insert("InsertGYBG_PM", gybg_pm);
}
catch (Exception)
{
flag = false;
}
return flag;
}
/// <summary>
/// 获取用户填写的国研报告篇名信息
/// </summary>
/// <returns></returns>
private GYBG_PM GetGYBGPM()
{
GYBG_PM gybgPM = new GYBG_PM();
//索引编码
gybgPM.sybm = this.sybmTextBox.Text;
//分类编码
gybgPM.flbm = this.flbmTextBox.Text;
//文件名
gybgPM.wjm = this.pdfHyperLink.Text;
//Doc文件名
gybgPM.dwjm = this.docHyperLink.Text;
//标题
gybgPM.bt = this.btTextBox.Text.Trim();
//报告日期
gybgPM.bgrq = DateTime.Parse(this.bgrqTextBox.Text);
//栏目
gybgPM.lm = this.lmDropDownList.SelectedItem.Text;
//来源
gybgPM.ly = this.lyTextBox.Text.Trim();
//年份
gybgPM.nf = Int32.Parse(this.nfTextBox.Text);
//文摘
gybgPM.wz = this.wzTextBox.Text;
//主题词
gybgPM.ztc = this.ztcTextBox.Text;
//更新日期
try
{
gybgPM.gxrq = DateTime.Parse(this.gxrqTextBox.Text.Trim());
}
catch
{
gybgPM.gxrq = DateTime.Now;
}
//作者
gybgPM.zz = this.zzTextBox.Text;
//作者单位
gybgPM.zzdw = this.zzdwTextBox.Text;
//页数
gybgPM.ys = this.ysTextBox.Text;
return gybgPM;
}
protected override PM getPM(OleDbDataReader reader, out String err)
{
err = String.Empty;
GYBG_PM pm = new GYBG_PM();
if (hasFormatTable)
{
pm.flbm = reader["分类编码"].ToString().Trim();
pm.sybm = reader["索引编码"].ToString().Trim();
pm.lm = reader["栏目"].ToString().Trim();
pm.dwjm = reader["DOC文件名"].ToString().Trim();
pm.ywjm = pm.wjm = reader["文件名"].ToString().Trim();
try
{
pm.ys = Int32.Parse(reader["页数"].ToString());
}
catch
{
pm.ys = 0;
}
try
{
pm.nf = int.Parse(reader["年份"].ToString());
}
catch (Exception)
{
pm.nf = 0;
err += pm.sybm + ":" + pm.bt + ": 年份\"" + reader["年份"] + "\"出错，置为0\n";
}
pm.bt = reader["标题"].ToString().Trim();
pm.zz = reader["作者"].ToString().Trim();
pm.zzdw = reader["作者单位"].ToString().Trim();
pm.ztc = reader["主题词"].ToString().Trim();
pm.ly = reader["来源"].ToString().Trim();
pm.wz = reader["文摘"].ToString().Trim();
pm.dlr = user.name;
pm.gxrq = DateTime.Now;
try
{
pm.bgrq = DateTime.Parse(reader["报告日期"].ToString());
}
catch
{
}
}
else
{
//不支持
}
pm.fillEmptyStringAsNull();
return pm;
}
