/// <summary>
/// 生成日志信息
/// </summary>
/// <param name="zgcgPM">中国成果信息</param>
/// <param name="opType">操作类型</param>
/// <param name="uname">用户名</param>
/// <returns></returns>
private OperationLogItem GetOperationLogItem(ZGCG_PM zgcgPM, String opType, String uname)
{
if (null == zgcgPM)
{
return null;
}
OperationLogItem operationLogItem = new OperationLogItem();
//操作类型
operationLogItem.opType = opType;
//数据库表
operationLogItem.opTable = "ZGCG_PM";
operationLogItem.opObjectID = "中国成果";
// 操作涉及的书刊
operationLogItem.opBookIn = "中国成果";
// 时间
operationLogItem.opDate = DateTime.Now;
// 操作员
operationLogItem.opPerson = uname;
//记录操作模式，判断是否属于批量操作。取值范围SINGLE/BATCH。
operationLogItem.opMode = "SINGLE";
//操作的内容
String content = "('" + zgcgPM.flbm + "','" +
zgcgPM.cgbh + "','" + zgcgPM.cgmc + "','" +
zgcgPM.wcr + "','" + zgcgPM.wcdw + "','" +
zgcgPM.dwdz + "','" + zgcgPM.yzbm + "','" +
zgcgPM.dwdh + "','" + zgcgPM.cgjj + "','" +
zgcgPM.zwztc + "','" + zgcgPM.yjqzsj + "','" +
zgcgPM.gtfl + "','" + zgcgPM.cglb + "','" +
zgcgPM.cgsp + "','" + zgcgPM.jdbm + "','" +
zgcgPM.jdrq + "','" + zgcgPM.lxhhj + "','" +
zgcgPM.fbdw + "','" + zgcgPM.zlly + "','" +
zgcgPM.fbnf + "','" + zgcgPM.lybh + "','" +
zgcgPM.hydm + "','" + zgcgPM.hymc + "','" +
zgcgPM.zysq + "','" + zgcgPM.kf + "','" +
zgcgPM.gxrq + "','" +
"')";
operationLogItem.opContent = content;
return operationLogItem;
}
/// <summary>
/// 更新一条篇名信息
/// </summary>
/// <param name="zgcg_pm">要更新的篇名信息</param>
/// <param name="uname">操作用户名</param>
/// <returns></returns>
public Boolean UpdateZGCG_PM(ZGCG_PM zgcg_pm, String uname)
{
Boolean flag = true;
int back = sqlMapper.Update("UpdateZGCG_PM", zgcg_pm);
if (back <= 0)
{
flag = false;
}
if (flag)
{
OperationLogItem operationLog = this.GetOperationLogItem(zgcg_pm, "UPDATE", uname);
this.operationLogDAO.insertLogItem(operationLog);
}
return flag;
}
/// <summary>
/// 插入一条篇名信息
/// </summary>
/// <param name="zgcg_pm">篇名信息</param>
/// <returns></returns>
public Boolean InsertZGCG_PM(ZGCG_PM zgcg_pm)
{
Boolean flag = true;
OperationLogItem operationLog = this.GetOperationLogItem(zgcg_pm, "INSERT", null);
try
{
sqlMapper.Insert("InsertZGCG_PM", zgcg_pm);
this.operationLogDAO.insertLogItem(operationLog);
}
catch (Exception)
{
flag = false;
}
return flag;
}
protected override PM getPM(OleDbDataReader reader, out String err)
{
err = String.Empty;
ZGCG_PM pm = new ZGCG_PM();
if (hasFormatTable)
{
pm.flbm = reader["分类编码"].ToString().Trim();
pm.cgmc = reader["成果名称"].ToString().Trim();
pm.cgbh = reader["成果编号"].ToString().Trim();
pm.wcr = reader["完成人"].ToString().Trim();
pm.wcdw = reader["完成单位"].ToString().Trim();
pm.dwdz = reader["单位地址"].ToString().Trim();
pm.yzbm = reader["邮政编码"].ToString().Trim();
pm.dwdh = reader["单位电话"].ToString().Trim();
pm.cgjj = reader["成果简介"].ToString().Trim();
pm.zwztc = reader["中文主题词"].ToString().Trim();
pm.yjqzsj = reader["研究起止时间"].ToString().Trim();
pm.gtfl = reader["国图分类"].ToString().Trim();
pm.cglb = reader["成果类别"].ToString().Trim();
pm.cgsp = reader["成果水平"].ToString().Trim();
pm.jdbm = reader["鉴定部门"].ToString().Trim();
pm.jdrq = reader["鉴定日期"].ToString().Trim();
pm.lxhhj = reader["立项或获奖"].ToString().Trim();
pm.fbdw = reader["发布单位"].ToString().Trim();
pm.zlly = reader["资料来源"].ToString().Trim();
try
{
if (String.Empty.Equals(reader["发布年份"].ToString().Trim()))
{
pm.fbnf = 0;
}
else
pm.fbnf = int.Parse(reader["发布年份"].ToString().Trim());
}
catch
{
err += "发布年份\"" + reader["发布年份"] + "\"出错" + pmKeyInfo(pm);
}
pm.lybh = reader["来源编号"].ToString().Trim();
pm.hydm = reader["行业代码"].ToString().Trim();
pm.hymc = reader["行业名称"].ToString().Trim();
pm.zlsq = reader["专利授权"].ToString().Trim();
try
{
pm.kf = Boolean.Parse(reader["开放"].ToString().Trim());
}
catch (Exception)
{
pm.kf = false;
}
}
else
{
//pm.flbm = reader["分类编码"].ToString().Trim();
pm.gtfl = reader["国图分类"].ToString().Trim();
pm.gtfl = pm.gtfl.Replace('；', ';');
pm.gtfl = pm.gtfl.Replace('．', '.');
pm.flbm = GtflToFlbm(pm.gtfl);
//pm.cgbh = reader["成果编号"].ToString().Trim();
pm.cgbh = "";
pm.cgmc = reader["成果名称"].ToString().Trim();
pm.wcdw = reader["完成单位"].ToString().Trim();
pm.wcr = reader["完成人"].ToString().Trim();
pm.dwdz = reader["单位地址"].ToString().Trim();
pm.yzbm = reader["邮政编码"].ToString().Trim();
pm.dwdh = reader["单位电话"].ToString().Trim();
pm.cgjj = reader["成果简介"].ToString().Trim();
pm.zwztc = reader["中文主题词"].ToString().Trim();
pm.yjqzsj = reader["研究起止时间"].ToString().Trim();
pm.cglb = reader["成果类别"].ToString().Trim();
pm.cgsp = reader["成果水平"].ToString().Trim();
pm.jdbm = reader["鉴定部门"].ToString().Trim();
pm.jdrq = reader["鉴定日期"].ToString().Trim();
pm.lxhhj = reader["立项或获奖"].ToString().Trim();
pm.fbdw = reader["发布单位"].ToString().Trim();
pm.zlly = reader["资料来源"].ToString().Trim();
try
{
if (String.Empty.Equals(reader["发布年份"].ToString().Trim()))
{
pm.fbnf = 0;
}
else
pm.fbnf = int.Parse(reader["发布年份"].ToString().Trim());
}
catch
{
err +="发布年份\"" + reader["发布年份"] + "\"出错" + pmKeyInfo(pm);
}
pm.lybh = reader["来源编码"].ToString().Trim();
pm.hydm = reader["行业代码"].ToString().Trim();
pm.hymc = reader["行业名称"].ToString().Trim();
pm.zlsq = reader["专利授权"].ToString().Trim();
pm.kf = true;
}
pm.dlr = user.name;
pm.gxrq = DateTime.Now;
pm.cgmc = CutColumnString(pm.cgmc, 150);
pm.wcdw = CutColumnString(pm.wcdw, 255);
pm.wcr = CutColumnString(pm.wcr, 100);
pm.dwdz = CutColumnString(pm.dwdz, 255);
pm.yzbm = CutColumnString(pm.yzbm, 6);
pm.dwdh = CutColumnString(pm.dwdh, 255);
pm.zwztc = CutColumnString(pm.zwztc, 100);
pm.yjqzsj = CutColumnString(pm.yjqzsj, 50);
pm.gtfl = CutColumnString(pm.gtfl, 35);
pm.cglb = CutColumnString(pm.cglb, 15);
pm.cgsp = CutColumnString(pm.cgsp, 10);
pm.jdbm = CutColumnString(pm.jdbm, 50);
pm.jdrq = CutColumnString(pm.jdrq, 20);
pm.lxhhj = CutColumnString(pm.lxhhj, 150);
pm.fbdw = CutColumnString(pm.fbdw, 100);
pm.zlly = CutColumnString(pm.zlly, 60);
pm.lybh = CutColumnString(pm.lybh, 10);
pm.hydm = CutColumnString(pm.hydm, 7);
pm.hymc = CutColumnString(pm.hymc, 50);
pm.zlsq = CutColumnString(pm.zlsq, 100);
pm.fillEmptyStringAsNull();
return pm;
}
/// <summary>
/// 插入一条篇名信息
/// </summary>
/// <param name="zgcg_pm">篇名信息</param>
/// <returns></returns>
public Boolean InsertZGCG_PM(ZGCG_PM zgcg_pm)
{
OperationLogItem operationLog = this.GetOperationLogItem(zgcg_pm, "INSERT", null);
sqlMapper.Insert("InsertZGCG_PM", zgcg_pm);
this.operationLogDAO.insertLogItem(operationLog);
return true;
}
/// <summary>
/// 获取用户填写的中国成果篇名信息
/// </summary>
/// <returns></returns>
private ZGCG_PM GetZGCGPM()
{
ZGCG_PM zgcgPM = new ZGCG_PM();
//自动编号
zgcgPM.id = Int32.Parse(this.idHiddenField.Value);
//成果编号
zgcgPM.cgbh = this.cgbhTextBox.Text;
//分类编码
zgcgPM.flbm = this.flbmTextBox.Text;
//成果名称
zgcgPM.cgmc = this.cgmcTextBox.Text;
//完成单位
zgcgPM.wcdw = this.wcdwTextBox.Text.Trim();
//完成人
zgcgPM.wcr = this.wcrTextBox.Text.Trim();
//单位地址
zgcgPM.dwdz = this.dwdzTextBox.Text.Trim();
//邮政编码
zgcgPM.yzbm = this.yzbmTextBox.Text;
//单位电话
zgcgPM.dwdh = this.dwdhTextBox.Text;
//中文主题词
zgcgPM.zwztc = this.zwztcTextBox.Text;
//成果简介
zgcgPM.cgjj = this.cgjjTextBox.Text;
zgcgPM.yjqzsj = this.yjqzsjTextBox.Text;//研究起止时间
zgcgPM.gtfl = this.gtflTextBox.Text;//国图分类
zgcgPM.cglb = this.cglbTextBox.Text;//成果类别
zgcgPM.cgsp = this.cgspTextBox.Text;//成果水平
zgcgPM.jdbm = this.jdbmTextBox.Text;//鉴定部门
zgcgPM.jdrq = this.jdrqTextBox.Text;//鉴定日期
zgcgPM.lxhhj = this.lxhhjTextBox.Text;//立项或获奖
zgcgPM.fbdw = this.fbdwTextBox.Text;//发布单位
zgcgPM.zlly = this.zllyTextBox.Text;//资料来源
zgcgPM.fbnf = Int32.Parse(this.fbnfTextBox.Text);//发布年份
zgcgPM.lybh = this.lybhTextBox.Text;//来源编号
zgcgPM.hydm = this.hydmTextBox.Text;//行业代码
zgcgPM.hymc = this.hymcTextBox.Text;//行业名称
zgcgPM.zysq = this.zlsqTextBox.Text;//专利授权
zgcgPM.kf = this.kfCheckBox.Checked;//开放
try
{
zgcgPM.gxrq = DateTime.Parse(this.gxrqTextBox.Text.Trim());
}
catch
{
zgcgPM.gxrq = DateTime.Now;//更新日期
}
return zgcgPM;
}
