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