/// <summary>
/// 从页面中读取片名的信息
/// </summary>
/// <returns>返回片名对象</returns>
private WWHY_PM GetWWHY_PM()
{
User user = (User)Session["login"];
//登陆超时则退到登录页
if (null == user)
{
GlobalMethod.RedirectLogin(Response);
return null;
}
WWHY_PM wwhyPM = new WWHY_PM();
//登录人
wwhyPM.dlr = user.name;
//索引编码
wwhyPM.sybm = this.sybmTextBox.Text.Trim();
//页数
try
{
wwhyPM.ys = Int32.Parse(this.ysTextBox.Text.Trim());
}
catch (Exception)
{
}
//文件名
wwhyPM.wjm = this.wjmHyperLink.Text.Trim();
//原文件名
wwhyPM.ywjm = this.ywjmHiddenField.Value.Trim();
//中文篇名
wwhyPM.zwpm = this.zwpmTextBox.Text.Trim();
//外文篇名
wwhyPM.wwpm = this.wwpmTextBox.Text.Trim();
//作者
wwhyPM.zz = this.zzTextBox.Text.Trim();
//作者单位
wwhyPM.zzdw = this.zzdwTextBox.Text.Trim();
//中文文摘
wwhyPM.zwwz = this.zwwzTextBox.Text.Trim();
//外文文摘
wwhyPM.wwwz = this.wwwzTextBox.Text.Trim();
//中文主题词
wwhyPM.zwztc = this.zwztcTextBox.Text.Trim();
//外文主题词
wwhyPM.wwztc = this.wwztcTextBox.Text.Trim();
//国图分类
wwhyPM.gtfl = this.gtflTextBox.Text.Trim();
//馆藏号
wwhyPM.gch = this.gchTextBox.Text.Trim();
//更新日期
try
{
wwhyPM.gxrq = DateTime.Parse(this.gxrqTextBox.Text);
}
catch (Exception)
{
wwhyPM.gxrq = DateTime.Now;
}
return wwhyPM;
}
/// <summary>
/// 从页面中读取篇名的信息
/// </summary>
/// <returns>返回片名对象</returns>
private WWHY_PM GetWWHY_PM()
{
User user = (User)Session["login"];
//登陆超时则退到登录页
if (null == user)
{
Response.Write(" <script> top.location = '" + GlobalResource.LOGIN_PAGE + "' </script> ");
return null;
}
WWHY_PM wwhyPM = new WWHY_PM();
//登录人
wwhyPM.dlr = user.name;
//索引编码
wwhyPM.sybm = this.sybmTextBox.Text.Trim();
//页数
try
{
wwhyPM.ys = Int32.Parse(this.ysTextBox.Text.Trim());
}
catch (Exception)
{
}
//文件名
wwhyPM.wjm = this.wjmTextBox.Text.Trim();
//原文件名
wwhyPM.ywjm = this.ywjmHiddenField.Value.Trim();
//中文篇名
wwhyPM.zwpm = this.zwpmTextBox.Text.Trim();
//外文篇名
wwhyPM.wwpm = this.wwpmTextBox.Text.Trim();
//作者
wwhyPM.zz = this.zzTextBox.Text.Trim();
//作者单位
wwhyPM.zzdw = this.zzdwTextBox.Text.Trim();
//中文文摘
wwhyPM.zwwz = this.zwwzTextBox.Text.Trim();
//外文文摘
wwhyPM.wwwz = this.wwwzTextBox.Text.Trim();
//中文主题词
wwhyPM.zwztc = this.zwztcTextBox.Text.Trim();
//外文主题词
wwhyPM.wwztc = this.wwztcTextBox.Text.Trim();
//国图分类
wwhyPM.gtfl = this.gtflTextBox.Text.Trim();
//馆藏号
wwhyPM.gch = this.gchTextBox.Text.Trim();
//更新日期
try
{
wwhyPM.gxrq = DateTime.Parse(this.gxrqTextBox.Text.Trim());
}
catch
{
wwhyPM.gxrq = DateTime.Today;
}
return wwhyPM;
}
/// <summary>
/// 生成日志信息
/// </summary>
/// <param name="wwqkPM">外文会议信息</param>
/// <param name="opType">操作类型</param>
/// <param name="uname">用户名</param>
/// <returns></returns>
private OperationLogItem GetOperationLogItem(WWHY_PM wwhyPM, String opType, String uname)
{
if (null == wwhyPM)
{
return null;
}
OperationLogItem operationLogItem = new OperationLogItem();
//操作类型
operationLogItem.opType = opType;
//数据库表
operationLogItem.opTable = "WWHY_PM";
//全文页数
operationLogItem.opPageCount = wwhyPM.ys;
operationLogItem.opObjectID = "外文会议";
// 操作涉及的书刊
operationLogItem.opBookIn = "外文会议";
// 时间
operationLogItem.opDate = DateTime.Now;
// 操作员
operationLogItem.opPerson = uname;
//记录操作模式，判断是否属于批量操作。取值范围SINGLE/BATCH。
operationLogItem.opMode = "SINGLE";
//操作的内容
String content = "('" + wwhyPM.sybm + "','" + wwhyPM.wjm + "','" + wwhyPM.ywjm + "','" + wwhyPM.zwpm + "','" + wwhyPM.wwpm + "','" + wwhyPM.zz + "','" + wwhyPM.zzdw + "','" + wwhyPM.zz + "','" + wwhyPM.zzdw + "','" + wwhyPM.zwwz + "','" + wwhyPM.wwwz + "','" + wwhyPM.zwztc + "','" + wwhyPM.wwztc + "','" + wwhyPM.ys + "','" + wwhyPM.gtfl + "','" + wwhyPM.gtfl + "','" + wwhyPM.gch + "','" + wwhyPM.gxrq + "','" + wwhyPM.dlr + "','" + wwhyPM.gxx+"')";
operationLogItem.opContent = content;
return operationLogItem;
}
/// <summary>
/// 按文件名更新篇名信息。
/// 文件名为主键。
/// </summary>
/// <param name="pm"></param>
/// <returns></returns>
public bool updateWwhyPMByWJM(WWHY_PM pm, String uname)
{
OperationLogItem operationLog = null;
operationLog = this.GetOperationLogItem(pm, "UPDATE", uname);
bool result;
try
{
sqlMapper.BeginTransaction();
sqlMapper.Update("UpdateWWHY_PM", pm);
sqlMapper.CommitTransaction();
this.operationLogDAO.insertLogItem(operationLog);
result = true;
}
catch
{
sqlMapper.RollBackTransaction();
result = false;
}
return result;
}
/// <summary>
/// 插入外文会议篇名信息。
/// </summary>
/// <param name="pm"></param>
public void insertWwhyPM(WWHY_PM pm)
{
OperationLogItem operationLog = null;
operationLog = this.GetOperationLogItem(pm, "INSERT", pm.dlr);
if (null != operationLog)
{
this.operationLogDAO.insertLogItem(operationLog);
}
sqlMapper.Insert("InsertWWHY_PM", pm);
}
protected override PM getPM(OleDbDataReader reader, out String err)
{
err = String.Empty;
WWHY_PM pm = new WWHY_PM();
if (hasFormatTable)
{
pm.sybm = reader["索引编码"].ToString().Trim();
pm.wjm = reader["文件名"].ToString().Trim();
pm.zwpm = reader["中文篇名"].ToString().Trim();
pm.wwpm = reader["外文篇名"].ToString().Trim();
pm.zz = reader["作者"].ToString().Trim();
pm.zzdw = reader["作者单位"].ToString().Trim();
pm.zwwz = reader["中文文摘"].ToString().Trim();
pm.wwwz = reader["外文文摘"].ToString().Trim();
pm.zwztc = reader["中文主题词"].ToString().Trim();
pm.wwztc = reader["外文主题词"].ToString().Trim();
try
{
pm.ys = int.Parse(reader["页数"].ToString());
}
catch (Exception)
{
pm.ys = 0;
}
pm.gtfl = reader["国图分类"].ToString().Trim();
pm.gch = reader["馆藏号"].ToString().Trim();
pm.ywjm = reader["原文件名"].ToString().Trim();
pm.gxx = reader["更新项"].ToString().Trim();
}
else
{
//pm.sybm = reader["索引编码"].ToString();
//pm.wjm = reader["文件名"].ToString();
pm.zwpm = reader["论文题名"].ToString();
pm.wwpm = reader["英文论文题名"].ToString();
pm.zz = reader["论文作者"].ToString();
pm.zzdw = reader["作者机构"].ToString();
pm.zwwz = reader["论文摘要"].ToString();
pm.wwwz = reader["英文论文摘要"].ToString();
pm.zwztc = reader["论文关键词"].ToString();
pm.wwztc = reader["英文论文关键词"].ToString();
pm.gtfl = reader["分类号"].ToString();
pm.ywjm = reader["文件名"].ToString();
//TODO : 馆藏号
//根据分类编码中的关键词查找分类,并生成索引目录
string hymc = reader["会议录名称"].ToString();
WWHY_SYML wwhySYML = wwhyDAO.getWwhySYMLByZwmc(hymc);
if (wwhySYML == null)
{
//构造索引目录
wwhySYML = new WWHY_SYML();
wwhySYML.flbm = GetFlbmByKeywords(hymc);
if ("".Equals(wwhySYML.flbm))
{
wwhySYML.flbm = GetFlbmByFlmc(hymc);
}
try
{
wwhySYML.nf = int.Parse(reader["年"].ToString());
}
catch
{
wwhySYML.nf = 2012;
}
string sybm =
wwhyDAO.getMaxWwhySYML(wwhySYML.flbm, wwhySYML.nf.ToString());
if (null == sybm)
{
sybm = wwhySYML.flbm + "-" + wwhySYML.nf.ToString() + "-000";
}
else
{
string serial = "000";
int number = 0;
try
{
number =
int.Parse(sybm.Substring(sybm.Length - 3)) + 1;
}
catch
{
}
serial += number;
sybm = wwhySYML.flbm + "-" + wwhySYML.nf.ToString() + "-"
+ serial.Substring(serial.Length - 3);
}
wwhySYML.sybm = sybm;
//读取索引字段，并插入到数据表中
wwhySYML.hydd = reader["会议地点"].ToString();
wwhySYML.wz = reader["语种"].ToString();
wwhySYML.zwmc = reader["会议录名称"].ToString();
wwhySYML.gch = "";
wwhySYML.wwmc = reader["英文会议录名称"].ToString();
wwhySYML.zbdw = reader["主办单位"].ToString();
wwhySYML.cbdw = "";
wwhySYML.chbdw = reader["出版单位"].ToString();
try
{
wwhySYML.fbrq = DateTime.Parse(reader["发表时间"].ToString());
}
catch
{
wwhySYML.fbrq = DateTime.Now;
}
wwhySYML.gtfl = GetGTFLbyFL(reader["分类号"].ToString());
wwhySYML.jj = "";
wwhySYML.dlrq = DateTime.Now;
if (!"".Equals(wwhySYML.flbm))
{
try
{
wwhyDAO.insertWwhySYML(wwhySYML);
}
catch
{
//不应该失败
}
}
}
if (!"".Equals(wwhySYML.flbm))
{
pm.sybm = wwhySYML.sybm;
pm.gch = wwhySYML.gch;
if (null == pm.gch) pm.gch = "";
}
}
pm.dlr = user.name;
pm.fillEmptyStringAsNull();
return pm;
}
