/// <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; }