Exemple #1
0
    /// <summary>
    /// 获取页面中的信息
    /// </summary>
    /// <returns>一个索引目录对象</returns>
    private WWHY_SYML GetWWHY_SYML()
    {
        WWHY_SYML wwhySYML = new WWHY_SYML();

        //分类编码
        wwhySYML.flbm = this.flbmTextBox.Text.Trim();
        //索引编码
        wwhySYML.sybm = this.sybmTextBox.Text.Trim();

        //文种
        wwhySYML.wz = this.wzTextBox.Text.Trim();
        //年份
        try
        {
            wwhySYML.nf = Int32.Parse(this.nfTextBox.Text.Trim());
        }
        catch (Exception)
        {
        }

        //中文名称
        wwhySYML.zwmc = this.zwmcTextBox.Text.Trim();
        //外文名称
        wwhySYML.wwmc = this.wwmcTextBox.Text.Trim();

        //主办单位
        wwhySYML.zbdw=this.zbdwTextBox.Text.Trim();
        //承办单位
        wwhySYML.cbdw= this.cbdwTextBox.Text.Trim();
        //出版单位
        wwhySYML.chbdw=this.chbdwTextBox.Text.Trim();
        try
        {
            //发布日期
            wwhySYML.fbrq = DateTime.Parse(this.fbrqTextBox.Text.Trim());
        }
        catch (Exception)
        {
        }
        //会议地点
        wwhySYML.hydd=this.hyddTextBox.Text.Trim();
        //简介
        wwhySYML.jj=this.jjTextBox.Text.Trim();
        //馆藏号
        wwhySYML.gch=this.gchTextBox.Text.Trim();
        //国图分类
        wwhySYML.gtfl = this.gtflTextBox.Text.Trim();
        try
        {
            //登录日期
            wwhySYML.dlrq = DateTime.Parse(this.dlrqTextBox.Text);
        }
        catch (Exception)
        {
        }

        return wwhySYML;
    }
Exemple #2
0
 /// <summary>
 /// 按索引编码更新索引目录信息。
 /// 索引编码为主键。
 /// </summary>
 /// <param name="syml"></param>
 /// <returns></returns>
 public bool updateWwhySYMLBySYBM(WWHY_SYML syml)
 {
     bool result;
     try
     {
         sqlMapper.BeginTransaction();
         sqlMapper.Update("UpdateWWHY_SYML", syml);
         sqlMapper.CommitTransaction();
         result = true;
     }
     catch
     {
         sqlMapper.RollBackTransaction();
         result = false;
     }
     return result;
 }
Exemple #3
0
 protected override SYML getSyml(OleDbDataReader reader, out string err)
 {
     err = String.Empty;
     WWHY_SYML syml = new WWHY_SYML();
     syml.flbm = reader["分类编码"].ToString().Trim();
     syml.sybm = reader["索引编码"].ToString().Trim();
     syml.wz = reader["文种"].ToString().Trim();
     try
     {
         syml.nf = int.Parse(reader["年份"].ToString());
     }
     catch (Exception)
     {
         syml.nf = 0;
         err += syml.flbm + ":" + syml.wwmc + ": 年份\"" + reader["年份"] + "\"出错,置为0\n";
     }
     syml.zwmc = reader["中文名称"].ToString().Trim();
     syml.wwmc = reader["外文名称"].ToString().Trim();
     syml.zbdw = reader["主办单位"].ToString().Trim();
     syml.cbdw = reader["承办单位"].ToString().Trim();
     syml.chbdw = reader["出版单位"].ToString().Trim();
     try
     {
         if (String.Empty.Equals(reader["发布日期"].ToString().Trim()))
         {
             err += syml.flbm + ":" + syml.wwmc + ":发布日期为空\n";
             syml.fbrq = DateTime.MinValue;
         }
         else
             syml.fbrq = DateTime.Parse(reader["发布日期"].ToString().Trim());
     }
     catch
     {
         err += syml.flbm + ":" + syml.wwmc + ": 发布日期\"" + reader["发布日期"] + "\"出错\n";
     }
     syml.gtfl = reader["国图分类"].ToString().Trim();
     syml.hydd = reader["会议地点"].ToString().Trim();
     syml.jj = reader["简介"].ToString().Trim();
     syml.gch = reader["馆藏号"].ToString().Trim();
     syml.dlrq = DateTime.Now;
     syml.fillEmptyStringAsNull();
     return syml;
 }
Exemple #4
0
 /// <summary>
 /// 插入外文会议索引目录信息。
 /// </summary>
 /// <param name="syml"></param>
 public void insertWwhySYML(WWHY_SYML syml)
 {
     sqlMapper.Insert("InsertWWHY_SYML", syml);
 }
Exemple #5
0
        protected override PM getPM(OleDbDataReader reader, out String err)
        {
            err = String.Empty;
            WWHY_PM pm = new WWHY_PM();
            if (hasFormatTable)
            {
                pm.sybm = reader["索引编码"].ToString().Trim();
                pm.wjm = reader["文件名"].ToString().Trim();
                pm.zwpm = reader["中文篇名"].ToString().Trim();
                pm.wwpm = reader["外文篇名"].ToString().Trim();
                pm.zz = reader["作者"].ToString().Trim();
                pm.zzdw = reader["作者单位"].ToString().Trim();
                pm.zwwz = reader["中文文摘"].ToString().Trim();
                pm.wwwz = reader["外文文摘"].ToString().Trim();
                pm.zwztc = reader["中文主题词"].ToString().Trim();
                pm.wwztc = reader["外文主题词"].ToString().Trim();
                try
                {
                    pm.ys = int.Parse(reader["页数"].ToString());
                }
                catch (Exception)
                {
                    pm.ys = 0;
                }

                pm.gtfl = reader["国图分类"].ToString().Trim();
                pm.gch = reader["馆藏号"].ToString().Trim();
                pm.ywjm = reader["原文件名"].ToString().Trim();
                pm.gxx = reader["更新项"].ToString().Trim();
            }
            else
            {
                //pm.sybm = reader["索引编码"].ToString();
                //pm.wjm = reader["文件名"].ToString();
                pm.zwpm = reader["论文题名"].ToString();
                pm.wwpm = reader["英文论文题名"].ToString();
                pm.zz = reader["论文作者"].ToString();
                pm.zzdw = reader["作者机构"].ToString();
                pm.zwwz = reader["论文摘要"].ToString();
                pm.wwwz = reader["英文论文摘要"].ToString();
                pm.zwztc = reader["论文关键词"].ToString();
                pm.wwztc = reader["英文论文关键词"].ToString();
                pm.gtfl = reader["分类号"].ToString();
                pm.ywjm = reader["文件名"].ToString();
                //TODO : 馆藏号

                //根据分类编码中的关键词查找分类,并生成索引目录
                string hymc = reader["会议录名称"].ToString();
                WWHY_SYML wwhySYML = wwhyDAO.getWwhySYMLByZwmc(hymc);
                if (wwhySYML == null)
                {
                    //构造索引目录
                    wwhySYML = new WWHY_SYML();
                    wwhySYML.flbm = GetFlbmByKeywords(hymc);

                    if ("".Equals(wwhySYML.flbm))
                    {
                        wwhySYML.flbm = GetFlbmByFlmc(hymc);
                    }

                    try
                    {
                        wwhySYML.nf = int.Parse(reader["年"].ToString());
                    }
                    catch
                    {
                        wwhySYML.nf = 2012;
                    }

                    string sybm =
                        wwhyDAO.getMaxWwhySYML(wwhySYML.flbm, wwhySYML.nf.ToString());

                    if (null == sybm)
                    {
                        sybm = wwhySYML.flbm + "-" + wwhySYML.nf.ToString() + "-000";
                    }
                    else
                    {
                        string serial = "000";
                        int number = 0;
                        try
                        {
                            number =
                                int.Parse(sybm.Substring(sybm.Length - 3)) + 1;
                        }
                        catch
                        {
                        }
                        serial += number;

                        sybm = wwhySYML.flbm + "-" + wwhySYML.nf.ToString() + "-"
                            + serial.Substring(serial.Length - 3);
                    }

                    wwhySYML.sybm = sybm;

                    //读取索引字段,并插入到数据表中
                    wwhySYML.hydd = reader["会议地点"].ToString();

                    wwhySYML.wz = reader["语种"].ToString();
                    wwhySYML.zwmc = reader["会议录名称"].ToString();
                    wwhySYML.gch = "";
                    wwhySYML.wwmc = reader["英文会议录名称"].ToString();
                    wwhySYML.zbdw = reader["主办单位"].ToString();
                    wwhySYML.cbdw = "";
                    wwhySYML.chbdw = reader["出版单位"].ToString();
                    try
                    {
                        wwhySYML.fbrq = DateTime.Parse(reader["发表时间"].ToString());
                    }
                    catch
                    {
                        wwhySYML.fbrq = DateTime.Now;
                    }

                    wwhySYML.gtfl = GetGTFLbyFL(reader["分类号"].ToString());
                    wwhySYML.jj = "";

                    wwhySYML.dlrq = DateTime.Now;

                    if (!"".Equals(wwhySYML.flbm))
                    {
                        try
                        {
                            wwhyDAO.insertWwhySYML(wwhySYML);
                        }
                        catch
                        {
                            //不应该失败
                        }
                    }
                }

                if (!"".Equals(wwhySYML.flbm))
                {
                    pm.sybm = wwhySYML.sybm;
                    pm.gch = wwhySYML.gch;
                    if (null == pm.gch) pm.gch = "";
                }
            }

            pm.dlr = user.name;
            pm.fillEmptyStringAsNull();

            return pm;
        }