/// <summary>
/// 生成日志信息
/// </summary>
/// <param name="zwqkPM">中文篇名信息</param>
/// <param name="opType">操作类型</param>
/// <param name="uname">用户名</param>
/// <returns></returns>
private OperationLogItem GetOperationLogItem(TSSC_PM tsscPM, String opType, String uname)
{
if (null == tsscPM)
{
return null;
}
OperationLogItem operationLogItem = new OperationLogItem();
//操作类型
operationLogItem.opType = opType;
//数据库表
operationLogItem.opTable = "TSSC_PM";
//全文页数
operationLogItem.opPageCount = tsscPM.ys;
operationLogItem.opObjectID = "图书手册";
// 操作涉及的书刊
operationLogItem.opBookIn = "图书手册";
// 时间
operationLogItem.opDate = DateTime.Now;
// 操作员
operationLogItem.opPerson = uname;
//记录操作模式，判断是否属于批量操作。取值范围SINGLE/BATCH。
operationLogItem.opMode = "SINGLE";
//操作的内容
String content = "('" + tsscPM.flbm + "','" + tsscPM.sybm + "','" + tsscPM.wjm + "','" + tsscPM.sm + "','" + tsscPM.zz + "','" + tsscPM.cbnf + "','" + tsscPM.cbdw + "','" + tsscPM.sh + "','" + tsscPM.ys + "','" + tsscPM.cc + "','" + tsscPM.fm + "','" + tsscPM.tsjj + "','" + tsscPM.tsml + "','" + tsscPM.tsly + "','" + tsscPM.gxrq + "','" + tsscPM.gxx + "','" + tsscPM.dlr + "')";
operationLogItem.opContent = content;
return operationLogItem;
}
/// <summary>
/// 插入一条篇名信息
/// </summary>
/// <param name="tssc_pm">篇名信息</param>
/// <returns></returns>
public Boolean InsertTSSC_PM(TSSC_PM tssc_pm)
{
Boolean flag = true;
try
{
sqlMapper.Insert("InsertTSSC_PM", tssc_pm);
}
catch (Exception)
{
flag = false;
}
return flag;
}
/// <summary>
/// 更新一条篇名信息
/// </summary>
/// <param name="tssc_pm">要更新的篇名信息</param>
/// <param name="uname">操作用户名</param>
/// <returns></returns>
public Boolean UpdateTSSC_PM(TSSC_PM tssc_pm, String uname)
{
Boolean flag = true;
int back = sqlMapper.Update("UpdateTSSC_PM", tssc_pm);
if (back <= 0)
{
flag = false;
}
if (flag)
{
OperationLogItem operationLog = this.GetOperationLogItem(tssc_pm, "UPDATE", uname);
this.operationLogDAO.insertLogItem(operationLog);
}
return flag;
}
/// <summary>
/// 获取用户填写的图书手册篇名信息
/// </summary>
/// <returns></returns>
private TSSC_PM GetTSSCPM()
{
TSSC_PM tsscPM = new TSSC_PM();
//索引编码
tsscPM.sybm = this.sybmTextBox.Text;
//分类编码
tsscPM.flbm = this.flbmTextBox.Text;
//文件名
tsscPM.wjm = this.pdfHyperLink.Text;
//书名
tsscPM.sm = this.smTextBox.Text.Trim();
//图书来源
tsscPM.tsly = this.tslyTextBox.Text.Trim();
//出版年份
tsscPM.cbnf = this.cbnfTextBox.Text;
//图书简介
tsscPM.tsjj = this.tsjjTextBox.Text;
//图书目录
tsscPM.tsml = this.tsmlTextBox.Text;
//更新日期
try
{
tsscPM.gxrq = DateTime.Parse(this.gxrqTextBox.Text.Trim());
}
catch
{
tsscPM.gxrq = DateTime.Now;
}
//作者
tsscPM.zz = this.zzTextBox.Text;
//出版单位
tsscPM.cbdw = this.cbdwTextBox.Text;
//页数
if (!"".Equals(this.ysTextBox.Text))
tsscPM.ys = Int32.Parse(this.ysTextBox.Text);
//尺寸
if (!"".Equals(this.ccTextBox.Text))
tsscPM.cc = (float)Double.Parse(this.ccTextBox.Text);
//书号
tsscPM.sh = this.shTextBox.Text;
//封面
tsscPM.fm = this.fmCheckBox.Checked;
return tsscPM;
}
/// <summary>
/// 插入一条篇名信息
/// </summary>
/// <param name="tssc_pm">篇名信息</param>
/// <returns></returns>
public Boolean InsertTSSC_PM(TSSC_PM tssc_pm)
{
Boolean flag = true;
OperationLogItem operationLog = this.GetOperationLogItem(tssc_pm, "INSERT", null);
try
{
sqlMapper.Insert("InsertTSSC_PM", tssc_pm);
this.operationLogDAO.insertLogItem(operationLog);
}
catch (Exception)
{
flag = false;
}
return flag;
}
/// <summary>
/// 更新一条篇名信息
/// </summary>
/// <param name="tssc_pm">要更新的篇名信息</param>
/// <param name="uname">操作用户名</param>
/// <returns></returns>
public Boolean UpdateTSSC_PM(TSSC_PM tssc_pm, String uname)
{
Boolean flag = true;
int back = sqlMapper.Update("UpdateTSSC_PM", tssc_pm);
if (back <= 0)
{
flag = false;
}
return flag;
}
/// <summary>
/// 插入一条篇名信息
/// </summary>
/// <param name="tssc_pm">篇名信息</param>
/// <returns></returns>
public Boolean InsertTSSC_PM(TSSC_PM tssc_pm)
{
Boolean flag = true;
sqlMapper.Insert("InsertTSSC_PM", tssc_pm);
return flag;
}
protected override PM getPM(OleDbDataReader reader, out String err)
{
err = String.Empty;
TSSC_PM pm = new TSSC_PM();
if (hasFormatTable)
{
pm.flbm = reader["分类编码"].ToString().Trim();
pm.sybm = reader["索引编码"].ToString().Trim();
pm.ywjm = pm.wjm = reader["文件名"].ToString().Trim();
pm.sm = reader["书名"].ToString().Trim();
pm.zz = reader["作者"].ToString().Trim();
pm.cbnf = reader["出版年份"].ToString().Trim();
pm.cbdw = reader["出版单位"].ToString().Trim();
pm.sh = reader["书号"].ToString().Trim();
try
{
if (!"".Equals(reader["页数"].ToString()))
pm.ys = int.Parse(reader["页数"].ToString());
}
catch (Exception)
{
pm.ys = 0;
err += "页数\"" + reader["页数"] + "\"出错，置为0; ";
}
try
{
if (!"".Equals(reader["尺寸"].ToString()))
pm.cc = float.Parse(reader["尺寸"].ToString());
}
catch (Exception)
{
pm.cc = 0;
err += "尺寸\"" + reader["尺寸"] + "\"出错，置为0; ";
}
try
{
pm.fm = Boolean.Parse(reader["封面"].ToString());
}
catch (Exception)
{
pm.fm = false;
}
pm.tsjj = reader["图书简介"].ToString().Trim();
pm.tsml = reader["图书目录"].ToString().Trim();
pm.tsly = reader["图书来源"].ToString().Trim();
pm.gxx = reader["更新项"].ToString().Trim();
pm.dlr = reader["登录人"].ToString().Trim();
pm.gxrq = DateTime.Now;
}
else
{
//不支持
}
if (!err.Equals(String.Empty)) err += pmKeyInfo(pm);
pm.dlr = user.name;
pm.fillEmptyStringAsNull();
return pm;
}
