/// <summary> /// 按索引编码更新索引目录信息。 /// 索引编码为主键。 /// </summary> /// <param name="syml"></param> /// <returns></returns> public bool updateZwqkSYMLBySYBM(ZWQKJG_SYML syml) { bool result; try { sqlMapper.BeginTransaction(); sqlMapper.Update("UpdateZWQKJG_SYML", syml); sqlMapper.CommitTransaction(); result = true; } catch { sqlMapper.RollBackTransaction(); result = false; } return result; }
/// <summary> /// 获取页面中的信息 /// </summary> /// <returns>一个索引目录对象</returns> private ZWQKJG_SYML GetZWQKJG_SYML() { ZWQKJG_SYML zwqkSYML = new ZWQKJG_SYML(); //分类编码 zwqkSYML.flbm = this.flbmTextBox.Text.Trim(); //索引编码 zwqkSYML.sybm = this.sybmTextBox.Text.Trim(); //中文名称 zwqkSYML.zwmc = this.zwmcTextBox.Text.Trim(); //外文名称 zwqkSYML.wwmc = this.wwmcTextBox.Text.Trim(); //开放 if (this.kfCheckBox.Checked) { zwqkSYML.kf = true; } else { zwqkSYML.kf = false; } //收录年份 zwqkSYML.slnf = this.slnfTextBox.Text.Trim(); //最新年份 try { zwqkSYML.zxnf = Int32.Parse(this.zxnfTextBox.Text.Trim()); } catch (Exception) { } //年份区间 try { zwqkSYML.nfqj = Int32.Parse(this.nfqjTextBox.Text.Trim()); } catch (Exception) { } //主办单位 zwqkSYML.zbdw=this.zbdwTextBox.Text.Trim(); //编辑单位 zwqkSYML.bjdw = this.bjdwTextBox.Text.Trim(); //通讯地址 zwqkSYML.txdz = this.txdzTextBox.Text.Trim(); //办公电话 zwqkSYML.bgdh = this.bgdhTextBox.Text.Trim(); //传真电话 zwqkSYML.czdh = this.czdhTextBox.Text.Trim(); //电子邮件 zwqkSYML.dzyj = this.dzyjTextBox.Text.Trim(); //创刊年份 zwqkSYML.cknf = this.cknfTextBox.Text.Trim(); //负责人 zwqkSYML.fzr = this.fzrTextBox.Text.Trim(); //邮政编码 zwqkSYML.yzbm = this.yzbmTextBox.Text.Trim(); //发行周期 zwqkSYML.fxzq = this.fxzqDropDownList.SelectedValue; //国际刊号 zwqkSYML.gjkh = this.gjkhTextBox.Text.Trim(); //国内刊号 zwqkSYML.gnkh = this.gnkhTextBox.Text.Trim(); //邮发代号 zwqkSYML.yfdh = this.yfdhTextBox.Text.Trim(); //资料来源 zwqkSYML.zlly = this.zllyTextBox.Text.Trim(); //简介 zwqkSYML.jj = this.jjTextBox.Text; return zwqkSYML; }
/// <summary> /// 插入中文期刊索引目录信息。 /// </summary> /// <param name="syml"></param> public void insertZwqkSYML(ZWQKJG_SYML syml) { sqlMapper.Insert("InsertZWQKJG_SYML", syml); }