/// <summary> /// 插入日志项。 /// </summary> /// <param name="logItem"></param> public void insertLogItem(OperationLogItem logItem) { try { sqlMapper.Insert("InsertOperationLogItem", logItem); } catch (Exception e) { Console.WriteLine("插入日志失败:" + e.Message); } }
/// <summary> /// 生成日志信息 /// </summary> /// <param name="zwqkPM">中文篇名信息</param> /// <param name="opType">操作类型</param> /// <param name="uname">用户名</param> /// <returns></returns> private OperationLogItem GetOperationLogItem(GYBG_PM gybgPM, String opType, String uname) { if (null == gybgPM) { return null; } OperationLogItem operationLogItem = new OperationLogItem(); //操作类型 operationLogItem.opType = opType; //数据库表 operationLogItem.opTable = "GYBG_PM"; //全文页数 try { operationLogItem.opPageCount = Int32.Parse(gybgPM.ys); } catch (Exception) { } operationLogItem.opObjectID = "国研报告"; // 操作涉及的书刊 operationLogItem.opBookIn = "国研报告"; // 时间 operationLogItem.opDate = DateTime.Now; // 操作员 operationLogItem.opPerson = uname; //记录操作模式,判断是否属于批量操作。取值范围SINGLE/BATCH。 operationLogItem.opMode = "SINGLE"; //操作的内容 String content = "('" + gybgPM.flbm + "','" + gybgPM.sybm + "','" + gybgPM.wjm + "','" + gybgPM.dwjm + "','" + gybgPM.lm + "','" + gybgPM.bt + "','" + gybgPM.zzdw + "','" + gybgPM.zz + "','" + gybgPM.nf + "','" + gybgPM.bgrq + "','" + gybgPM.ztc + "','" + gybgPM.ly + "','" + gybgPM.wz + "','" + gybgPM.gxrq + "','" + gybgPM.ys + "')"; operationLogItem.opContent = content; return operationLogItem; }
/// <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="zwqkPM">中文篇名信息</param> /// <param name="opType">操作类型</param> /// <param name="uname">用户名</param> /// <returns></returns> private OperationLogItem GetOperationLogItem(ZWQK_PM zwqkPM, String opType, String uname) { if (null == zwqkPM) { return null; } OperationLogItem operationLogItem = new OperationLogItem(); //操作类型 operationLogItem.opType = opType; //数据库表 operationLogItem.opTable = "ZWQK_PM"; //全文页数 operationLogItem.opPageCount = zwqkPM.ys; operationLogItem.opObjectID = "中文期刊"; // 操作涉及的书刊 operationLogItem.opBookIn = "中文期刊"; // 时间 operationLogItem.opDate = DateTime.Now; // 操作员 operationLogItem.opPerson = uname; //记录操作模式,判断是否属于批量操作。取值范围SINGLE/BATCH。 operationLogItem.opMode = "SINGLE"; //操作的内容 String content = "('" + zwqkPM.sybm + "','" + zwqkPM.wjm + "','" + zwqkPM.ywjm + "','" + zwqkPM.nf + "','" + zwqkPM.qh + "','" + zwqkPM.zwpm + "','" + zwqkPM.wwpm + "','" + zwqkPM.zz + "','" + zwqkPM.zzdw + "','" + zwqkPM.kb + "','" + zwqkPM.ys + "','" + zwqkPM.zwwz + "','" + zwqkPM.zwztc + "','" + zwqkPM.wwwz + "','" + zwqkPM.wwztc + "','" + zwqkPM.gtfl + "','" + zwqkPM.wxbs + "','" + zwqkPM.dlr + "','" + zwqkPM.gxrq + "')"; operationLogItem.opContent = content; return operationLogItem; }
/// <summary> /// 生成日志信息 /// </summary> /// <param name="zwqkPM">电力报刊刊信息</param> /// <param name="opType">操作类型</param> /// <param name="uname">用户名</param> /// <returns></returns> private OperationLogItem GetOperationLogItem(DLBK_PM dlbkPM, String opType, String uname) { if (null == dlbkPM) { return null; } OperationLogItem operationLogItem = new OperationLogItem(); //操作类型 operationLogItem.opType = opType; //数据库表 operationLogItem.opTable = "DLBK_PM"; //全文页数 try { operationLogItem.opPageCount = 0; } catch (Exception) { } operationLogItem.opObjectID = "电力报刊"; // 操作涉及的书刊 operationLogItem.opBookIn = "电力报刊"; // 时间 operationLogItem.opDate = DateTime.Now; // 操作员 operationLogItem.opPerson = uname; //记录操作模式,判断是否属于批量操作。取值范围SINGLE/BATCH。 operationLogItem.opMode = "SINGLE"; //操作的内容 String content = "('" + dlbkPM.flbm + "','" + dlbkPM.bt + "','" + dlbkPM.zz + "','" + dlbkPM.rq + "','" + dlbkPM.bh + "','" + dlbkPM.lm + "','" + dlbkPM.zw + "')"; operationLogItem.opContent = content; return operationLogItem; }
/// <summary> /// 生成日志信息 /// </summary> /// <param name="zwqkPM">经济报刊刊信息</param> /// <param name="opType">操作类型</param> /// <param name="uname">用户名</param> /// <returns></returns> private OperationLogItem GetOperationLogItem(BDBK_PM bdbkPM, String opType, String uname) { if (null == bdbkPM) { return null; } OperationLogItem operationLogItem = new OperationLogItem(); //操作类型 operationLogItem.opType = opType; //数据库表 operationLogItem.opTable = "BDBK_PM"; //全文页数 try { //operationLogItem.opPageCount = Int32.Parse(bdbkPM.ys); operationLogItem.opPageCount = 0; } catch (Exception) { } operationLogItem.opObjectID = "经济报刊"; // 操作涉及的书刊 operationLogItem.opBookIn = "经济报刊"; // 时间 operationLogItem.opDate = DateTime.Now; // 操作员 operationLogItem.opPerson = uname; //记录操作模式,判断是否属于批量操作。取值范围SINGLE/BATCH。 operationLogItem.opMode = "SINGLE"; //操作的内容 String content = "('" + bdbkPM.flbm + "','" + bdbkPM.sybm + "','" + bdbkPM.wjm + "','" + bdbkPM.bt + "','" + bdbkPM.zz + "','" + bdbkPM.rq + "','" + bdbkPM.bh + "','" + bdbkPM.lm + "','" + bdbkPM.ywjm + "','" + bdbkPM.nf + "','" + bdbkPM.yf + "','" + bdbkPM.qw + "','" + bdbkPM.dlr + "','" + bdbkPM.gxrq + "')"; operationLogItem.opContent = content; return operationLogItem; }
/// <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="nybgPM">中文篇名信息</param> /// <param name="opType">操作类型</param> /// <param name="uname">用户名</param> /// <returns></returns> private OperationLogItem GetOperationLogItem(NYBG_PM nybgPM, String opType, String uname) { if (null == nybgPM) { return null; } OperationLogItem operationLogItem = new OperationLogItem(); //操作类型 operationLogItem.opType = opType; //数据库表 operationLogItem.opTable = "NYBG_PM"; //全文页数 operationLogItem.opPageCount =nybgPM.ys; operationLogItem.opObjectID = "考察报告"; // 操作涉及的书刊 operationLogItem.opBookIn = "考察报告"; // 时间 operationLogItem.opDate = DateTime.Now; // 操作员 operationLogItem.opPerson = uname; //记录操作模式,判断是否属于批量操作。取值范围SINGLE/BATCH。 operationLogItem.opMode = "SINGLE"; //操作的内容 String content = "('" + nybgPM.flbm + "','" + nybgPM.sybm + "','" + nybgPM.wjm + "','" + nybgPM.ywjm + "','" + nybgPM.ys + "','" + nybgPM.bgmc + "','" + nybgPM.nf + "','" + nybgPM.cbrq + "','" + nybgPM.zz + "','" + nybgPM.zzdw + "','" + nybgPM.zbdw + "','" + nybgPM.ztc + "','" + nybgPM.wz + "','" + nybgPM.bgh + "','" + nybgPM.fltx +"','"+ nybgPM.zfl + "','" + nybgPM.wxbh + "','" + nybgPM.qw +"','"+ nybgPM.gxrq + "','" + nybgPM.dlr + "')"; operationLogItem.opContent = content; return operationLogItem; }
/// <summary> /// 生成日志信息 /// </summary> /// <param name="kjbgPM">中文篇名信息</param> /// <param name="opType">操作类型</param> /// <param name="uname">用户名</param> /// <returns></returns> private OperationLogItem GetOperationLogItem(KJBG_PM kjbgPM, String opType, String uname) { if (null == kjbgPM) { return null; } OperationLogItem operationLogItem = new OperationLogItem(); //操作类型 operationLogItem.opType = opType; //数据库表 operationLogItem.opTable = "KJBG_PM"; //全文页数 operationLogItem.opPageCount =kjbgPM.ys; operationLogItem.opObjectID = "科技报告"; // 操作涉及的书刊 operationLogItem.opBookIn = "科技报告"; // 时间 operationLogItem.opDate = DateTime.Now; // 操作员 operationLogItem.opPerson = uname; //记录操作模式,判断是否属于批量操作。取值范围SINGLE/BATCH。 operationLogItem.opMode = "SINGLE"; //操作的内容 String content = "('" + kjbgPM.flbm + "','" + kjbgPM.sybm + "','" + kjbgPM.wjm + "','" + kjbgPM.bgbh + "','" + kjbgPM.bgmc + "','" + kjbgPM.bgdw + "','" + kjbgPM.nf + "','" + kjbgPM.zz + "','" + kjbgPM.zwwz + "','" + kjbgPM.zwztc + "','" + kjbgPM.zlly + "','" + kjbgPM.ys + "','" + kjbgPM.dlr + "','" + kjbgPM.gxrq + "','" + kjbgPM.kf + "')"; operationLogItem.opContent = content; return operationLogItem; }
/// <summary> /// 生成日志信息 /// </summary> /// <param name="xwlwPM">中文篇名信息</param> /// <param name="opType">操作类型</param> /// <param name="uname">用户名</param> /// <returns></returns> private OperationLogItem GetOperationLogItem(XWLW_PM xwlwPM, String opType, String uname) { if (null == xwlwPM) { return null; } OperationLogItem operationLogItem = new OperationLogItem(); //操作类型 operationLogItem.opType = opType; //数据库表 operationLogItem.opTable = "XWLW_PM"; //全文页数 operationLogItem.opPageCount = xwlwPM.ys; operationLogItem.opObjectID = "学位论文"; // 操作涉及的书刊 operationLogItem.opBookIn = "学位论文"; // 时间 operationLogItem.opDate = DateTime.Now; // 操作员 operationLogItem.opPerson = uname; //记录操作模式,判断是否属于批量操作。取值范围SINGLE/BATCH。 operationLogItem.opMode = "SINGLE"; //操作的内容 String content = "('" + xwlwPM.flbm + "','" + xwlwPM.sybm + "','" + xwlwPM.wjm + "','" + xwlwPM.ywjm + "','" + xwlwPM.zwtm + "','" + xwlwPM.ywtm + "','" + xwlwPM.zz + "','" + xwlwPM.ds + "','" + xwlwPM.lwjb + "','" + xwlwPM.xkzymc + "','" + xwlwPM.flh + "','" + xwlwPM.xwsydw + "','" + xwlwPM.lwtjrq + "','" + xwlwPM.lwdbrq+ "','" +xwlwPM.xwsyrq + "','" + xwlwPM.zwztc + "','" + xwlwPM.zwzy + "','" + xwlwPM.ywztc + "','" + xwlwPM.ywzy + "','" + xwlwPM.fltx + "','" + xwlwPM.nf + "','" + xwlwPM.cbrq + "','" + xwlwPM.ys + "','" + xwlwPM.gxrq + "','" + xwlwPM.qw + "')"; operationLogItem.opContent = content; return operationLogItem; }
/// <summary> /// 生成日志信息 /// </summary> /// <param name="kjcgPM">科技成果信息</param> /// <param name="opType">操作类型</param> /// <param name="uname">用户名</param> /// <returns></returns> private OperationLogItem GetOperationLogItem(KJCG_PM kjcgPM, String opType, String uname) { if (null == kjcgPM) { return null; } OperationLogItem operationLogItem = new OperationLogItem(); //操作类型 operationLogItem.opType = opType; //数据库表 operationLogItem.opTable = "KJCG_PM"; operationLogItem.opObjectID = "科技成果"; // 操作涉及的书刊 operationLogItem.opBookIn = "科技成果"; // 时间 operationLogItem.opDate = DateTime.Now; // 操作员 operationLogItem.opPerson = uname; //记录操作模式,判断是否属于批量操作。取值范围SINGLE/BATCH。 operationLogItem.opMode = "SINGLE"; //操作的内容 String content = "('" + kjcgPM.flbm + "','" + kjcgPM.zydm + "','" + kjcgPM.cgdm + "','" + kjcgPM.sbbm + "','" + kjcgPM.zwmc + "','" + kjcgPM.cglb + "','" + kjcgPM.qsrq + "','" + kjcgPM.zzrq + "','" + kjcgPM.xkdm + "','" + kjcgPM.gtfl + "','" + kjcgPM.zwztc + "','" + kjcgPM.zwwz + "','" + kjcgPM.ktly + "','" + kjcgPM.pjfs + "','" + kjcgPM.pjdw + "','" + kjcgPM.pjrq + "','" + kjcgPM.pjyj + "','" + kjcgPM.jxmc + "','" + kjcgPM.jldw + "','" + kjcgPM.jlnd + "','" + kjcgPM.sjdj + "','" + kjcgPM.cqxs + "','" + kjcgPM.cqmc + "','" + kjcgPM.cqbs + "','" + kjcgPM.dydw + "','" + kjcgPM.dwsx + "','" + kjcgPM.lsgx + "','" + kjcgPM.txdz + "','" + kjcgPM.yzbm + "','" + kjcgPM.lxdh + "','" + kjcgPM.czdh + "','" + kjcgPM.lxr + "','" + kjcgPM.dzxx + "','" + kjcgPM.qtdw + "','" + kjcgPM.dywcr + "','" + kjcgPM.xb + "','" + kjcgPM.zwzc + "','" + kjcgPM.szdw + "','" + kjcgPM.dh + "','" + kjcgPM.qtwcr + "','" + kjcgPM.tjdwyj + "','" + kjcgPM.gxrq + "','" + kjcgPM.gx + "','" + "')"; operationLogItem.opContent = content; return operationLogItem; }
/// <summary> /// 生成日志信息 /// </summary> /// <param name="zwqkPM">中文篇名信息</param> /// <param name="opType">操作类型</param> /// <param name="uname">用户名</param> /// <returns></returns> private OperationLogItem GetOperationLogItem(GJIBZ_PM gjbzPM, String opType, String uname) { if (null == gjbzPM) { return null; } OperationLogItem operationLogItem = new OperationLogItem(); //操作类型 operationLogItem.opType = opType; //数据库表 operationLogItem.opTable = "GJIBZ_PM"; //全文页数 operationLogItem.opPageCount = gjbzPM.ys; operationLogItem.opObjectID = "国际标准"; // 操作涉及的书刊 operationLogItem.opBookIn = "国际标准"; // 时间 operationLogItem.opDate = DateTime.Now; // 操作员 operationLogItem.opPerson = uname; //记录操作模式,判断是否属于批量操作。取值范围SINGLE/BATCH。 operationLogItem.opMode = "SINGLE"; //操作的内容 String content = "('" + gjbzPM.flbm + "','" + gjbzPM.bzwh + "','" + gjbzPM.wjm + "','" + gjbzPM.bbxz + "','" + gjbzPM.zwmc + "','" + gjbzPM.icsfl + "','" + gjbzPM.gbfl + "','" + gjbzPM.wwmc + "','" + gjbzPM.fbrq + "','" + gjbzPM.ssrq + "','" + gjbzPM.cygx + "','" + gjbzPM.dtbz + "','" + gjbzPM.bdtbz + "','" + gjbzPM.ys + "','" + gjbzPM.zf + "','"+gjbzPM.zf1 + "','" + gjbzPM.zfnf + "','" + gjbzPM.zwztc + "','" + gjbzPM.wwztc + "','" + gjbzPM.bz + "','" + gjbzPM.gxrq + "','" + gjbzPM.dlr + "')"; operationLogItem.opContent = content; return operationLogItem; }
/// <summary> /// 生成日志信息 /// </summary> /// <param name="zwqkPM">中文篇名信息</param> /// <param name="opType">操作类型</param> /// <param name="uname">用户名</param> /// <returns></returns> private OperationLogItem GetOperationLogItem(ZCWX_PM zcwxPM, String opType, String uname) { if (null == zcwxPM) { return null; } OperationLogItem operationLogItem = new OperationLogItem(); //操作类型 operationLogItem.opType = opType; //数据库表 operationLogItem.opTable = "ZCWX_PM"; operationLogItem.opObjectID = "自产文献"; // 操作涉及的书刊 operationLogItem.opBookIn = "自产文献"; // 时间 operationLogItem.opDate = DateTime.Now; // 操作员 operationLogItem.opPerson = uname; //记录操作模式,判断是否属于批量操作。取值范围SINGLE/BATCH。 operationLogItem.opMode = "SINGLE"; //操作的内容 String content = "('" + zcwxPM.flbm + "','" + zcwxPM.sybm + "','" + zcwxPM.gch + "','" + zcwxPM.zwpm + "','" + zcwxPM.cbdw + "','" + zcwxPM.wxmj + "','" + zcwxPM.wxlx + "','" + zcwxPM.zrgr + "','" + zcwxPM.zrdw + "','" + zcwxPM.cbrq + "','" + zcwxPM.ztxt + "','" + zcwxPM.gtfl + "','" + zcwxPM.zwztc + "','" + zcwxPM.zwwz + "','" + zcwxPM.bz + "','" + zcwxPM.gxrq + "')"; operationLogItem.opContent = content; return operationLogItem; }
/// <summary> /// 生成日志信息 /// </summary> /// <param name="zwqkPM">中文篇名信息</param> /// <param name="opType">操作类型</param> /// <param name="uname">用户名</param> /// <returns></returns> private OperationLogItem GetOperationLogItem(GDFG_PM gdfgPM, String opType, String uname) { if (null == gdfgPM) { return null; } OperationLogItem operationLogItem = new OperationLogItem(); //操作类型 operationLogItem.opType = opType; //数据库表 operationLogItem.opTable = "GDFG_PM"; //全文页数 operationLogItem.opPageCount = gdfgPM.ys; operationLogItem.opObjectID = "国电法规"; // 操作涉及的法规 operationLogItem.opBookIn = "国电法规"; // 时间 operationLogItem.opDate = DateTime.Now; // 操作员 operationLogItem.opPerson = uname; //记录操作模式,判断是否属于批量操作。取值范围SINGLE/BATCH。 operationLogItem.opMode = "SINGLE"; //操作的内容 String content = "('" + gdfgPM.flbm + "','" + gdfgPM.sybm + "','" + gdfgPM.wjm + "','" + gdfgPM.fgwh + "','" + gdfgPM.fgmc + "','" + gdfgPM.fbdw + "','" + gdfgPM.fbrq + "','" + gdfgPM.ssrq + "','" + gdfgPM.sx + "','" + gdfgPM.sxrq + "','" + gdfgPM.kb + "','" + gdfgPM.ys + "','" + gdfgPM.bz + "','" + gdfgPM.zyfl + "','" + gdfgPM.qwjc + "','" + gdfgPM.kf + "','" + gdfgPM.gxrq + "','" + gdfgPM.gxx + "','" + gdfgPM.dlr + "')"; operationLogItem.opContent = content; return operationLogItem; }