protected override PM getPM(OleDbDataReader reader, out String err) { err = String.Empty; JJBK_PM pm = new JJBK_PM(); if (hasFormatTable) { pm.flbm = reader["分类编码"].ToString().Trim(); pm.sybm = reader["索引编码"].ToString().Trim(); pm.oldWjm = pm.wjm = reader["文件名"].ToString().Trim(); pm.bt = reader["标题"].ToString().Trim(); pm.zz = reader["作者"].ToString().Trim(); try { pm.nf = int.Parse(reader["年份"].ToString().Trim()); } catch (Exception) { pm.nf = 0; } try { pm.yf = int.Parse(reader["月份"].ToString().Trim()); } catch (Exception) { pm.yf = 1; } try { if (String.Empty.Equals(reader["日期"].ToString().Trim())) { pm.rq = DateTime.Parse(pm.nf.ToString() + "/" + pm.yf.ToString() + "/1"); } else pm.rq = DateTime.Parse(reader["日期"].ToString().Trim()); } catch { err += "日期\"" + reader["日期"] + "\"出错" + pmKeyInfo(pm); } pm.bh = reader["版号"].ToString().Trim(); pm.lm = reader["栏目"].ToString().Trim(); pm.ywjm = reader["原文件名"].ToString().Trim(); pm.qw = reader["全文"].ToString().Trim(); } else { pm.bt = reader["题名"].ToString().Trim(); pm.bh = reader["版号"].ToString().Trim(); pm.lm = reader["栏目"].ToString().Trim(); pm.ywjm = reader["文件名"].ToString().Trim(); pm.zz = reader["作者名称"].ToString().Trim(); try { pm.nf = int.Parse(reader["年"].ToString().Trim()); } catch { pm.nf = 0; } try { if (!String.Empty.Equals(reader["日期"].ToString().Trim())) { pm.rq = DateTime.Parse(reader["日期"].ToString().Trim()); pm.yf = pm.rq.Month; } } catch { err += "日期出错\"" + reader["日期"].ToString().Trim(); } String bzzwm = reader["报纸中文名"].ToString().Trim(); foreach (JJBK_FL fl in jjbkFL) { if (null != fl.flmc && fl.flmc.Equals(bzzwm)) { pm.flbm = fl.flbm; break; } } if (null == pm.flbm || "".Equals(pm.flbm)) { pm.flbm = ""; pm.sybm = ""; pm.isValid = false; //err += " 分类编码未能找到 \"" + bzzwm + "\""; } else { pm.sybm = pm.flbm + String.Format("{0:4D}", pm.nf) + String.Format("{0:2D}", pm.yf); } pm.qw = "-1"; if (!"".Equals(err)) err += pmKeyInfo(pm); } pm.dlr = user.name; pm.fillEmptyStringAsNull(); return pm; }
/// <summary> /// 获取用户填写的国研报告篇名信息 /// </summary> /// <returns></returns> private JJBK_PM GetJJBKPM() { JJBK_PM jjbkPM = new JJBK_PM(); //索引编码 jjbkPM.sybm = this.sybmTextBox.Text; //分类编码 jjbkPM.flbm = this.flbmTextBox.Text; //文件名 jjbkPM.wjm = this.wjmTextBox.Text; //原文件名 jjbkPM.ywjm = this.ywjmFileUpload.FileName; //标题 jjbkPM.bt = this.btTextBox.Text.Trim(); //作者 jjbkPM.zz = this.zzTextBox.Text.Trim(); //日期 jjbkPM.rq = DateTime.Parse(this.rqTextBox.Text); //版号 jjbkPM.bh = this.bhTextBox.Text.Trim(); //栏目 jjbkPM.lm = this.lmTextBox.Text.Trim(); //年份 jjbkPM.nf = Int32.Parse(this.nfTextBox.Text); //月份 jjbkPM.yf = Int32.Parse(this.qhTextBox.Text); //更新日期 try { jjbkPM.gxrq = DateTime.Parse(this.gxrqTextBox.Text.Trim()); } catch { jjbkPM.gxrq = DateTime.Now; } //登录人 jjbkPM.dlr = this.dlrTextBox.Text; //全文 jjbkPM.qw = "-1"; return jjbkPM; }
/// <summary> /// 生成日志信息 /// </summary> /// <param name="zwqkPM">经济报刊刊信息</param> /// <param name="opType">操作类型</param> /// <param name="uname">用户名</param> /// <returns></returns> private OperationLogItem GetOperationLogItem(JJBK_PM jjbkPM, String opType, String uname) { if (null == jjbkPM) { return null; } OperationLogItem operationLogItem = new OperationLogItem(); //操作类型 operationLogItem.opType = opType; //数据库表 operationLogItem.opTable = "JJBK_PM"; //全文页数 try { //operationLogItem.opPageCount = Int32.Parse(jjbkPM.ys); operationLogItem.opPageCount = 0; } catch (Exception) { } operationLogItem.opObjectID = "经济报刊"; // 操作涉及的书刊 operationLogItem.opBookIn = "经济报刊"; // 时间 operationLogItem.opDate = DateTime.Now; // 操作员 operationLogItem.opPerson = uname; //记录操作模式,判断是否属于批量操作。取值范围SINGLE/BATCH。 operationLogItem.opMode = "SINGLE"; //操作的内容 String content = "('" + jjbkPM.flbm + "','" + jjbkPM.sybm + "','" + jjbkPM.wjm + "','" + jjbkPM.bt + "','" + jjbkPM.zz + "','" + jjbkPM.rq + "','" + jjbkPM.bh + "','" + jjbkPM.lm + "','" + jjbkPM.ywjm + "','" + jjbkPM.nf + "','" + jjbkPM.yf + "','" + jjbkPM.qw + "','" + jjbkPM.dlr + "','" + jjbkPM.gxrq + "')"; operationLogItem.opContent = content; return operationLogItem; }
/// <summary> /// 更新一条篇名信息 /// </summary> /// <param name="jjbk_pm">要更新的篇名信息</param> /// <param name="uname">操作用户名</param> /// <returns></returns> public Boolean UpdateJJBK_PM(JJBK_PM jjbk_pm, String uname) { Boolean flag = true; int back=sqlMapper.Update("UpdateJJBK_PM", jjbk_pm); if (back <= 0) { flag = false; } if (flag) { OperationLogItem operationLog = this.GetOperationLogItem(jjbk_pm, "UPDATE", uname); this.operationLogDAO.insertLogItem(operationLog); } return flag; }
/// <summary> /// 插入一条篇名信息 /// </summary> /// <param name="jjbk_pm">篇名信息</param> /// <returns></returns> public Boolean InsertJJBK_PM(JJBK_PM jjbk_pm) { Boolean flag = true; OperationLogItem operationLog = this.GetOperationLogItem(jjbk_pm, "INSERT", null); sqlMapper.Insert("InsertJJBK_PM", jjbk_pm); this.operationLogDAO.insertLogItem(operationLog); return flag; }
/// <summary> /// 插入一条篇名信息 /// </summary> /// <param name="jjbk_pm">篇名信息</param> /// <returns></returns> public Boolean InsertJJBK_PM(JJBK_PM jjbk_pm) { Boolean flag = true; OperationLogItem operationLog = this.GetOperationLogItem(jjbk_pm, "INSERT", null); try { sqlMapper.Insert("InsertJJBK_PM", jjbk_pm); this.operationLogDAO.insertLogItem(operationLog); } catch (Exception) { flag = false; } return flag; }