/// <summary>
        /// 获得数据列表
        /// </summary>
        public List <ZQUSR.Model.sr_Calculate2> DataTableToList(DataTable dt)
        {
            List <ZQUSR.Model.sr_Calculate2> modelList = new List <ZQUSR.Model.sr_Calculate2>();
            int rowsCount = dt.Rows.Count;

            if (rowsCount > 0)
            {
                ZQUSR.Model.sr_Calculate2 model;
                for (int n = 0; n < rowsCount; n++)
                {
                    model = new ZQUSR.Model.sr_Calculate2();
                    if (dt.Rows[n]["PK_CID"].ToString() != "")
                    {
                        model.PK_CID = int.Parse(dt.Rows[n]["PK_CID"].ToString());
                    }
                    if (dt.Rows[n]["Population"].ToString() != "")
                    {
                        model.Population = int.Parse(dt.Rows[n]["Population"].ToString());
                    }
                    if (dt.Rows[n]["Rank"].ToString() != "")
                    {
                        model.Rank = int.Parse(dt.Rows[n]["Rank"].ToString());
                    }
                    model.ScoreScale = dt.Rows[n]["ScoreScale"].ToString();
                    modelList.Add(model);
                }
            }
            return(modelList);
        }
 /// <summary>
 /// ��������б�
 /// </summary>
 public List<ZQUSR.Model.sr_Calculate2> DataTableToList(DataTable dt)
 {
     List<ZQUSR.Model.sr_Calculate2> modelList = new List<ZQUSR.Model.sr_Calculate2>();
     int rowsCount = dt.Rows.Count;
     if (rowsCount > 0)
     {
         ZQUSR.Model.sr_Calculate2 model;
         for (int n = 0; n < rowsCount; n++)
         {
             model = new ZQUSR.Model.sr_Calculate2();
             if(dt.Rows[n]["PK_CID"].ToString()!="")
             {
                 model.PK_CID=int.Parse(dt.Rows[n]["PK_CID"].ToString());
             }
             if(dt.Rows[n]["Population"].ToString()!="")
             {
                 model.Population=int.Parse(dt.Rows[n]["Population"].ToString());
             }
             if(dt.Rows[n]["Rank"].ToString()!="")
             {
                 model.Rank=int.Parse(dt.Rows[n]["Rank"].ToString());
             }
             model.ScoreScale=dt.Rows[n]["ScoreScale"].ToString();
             modelList.Add(model);
         }
     }
     return modelList;
 }
        private void Save(string strAuditState)
        {
            if (Session["UserID"] != null)
            {
                string cmd = Request.QueryString["cmd"].ToString();
                try
                {
                    if (txtTime.Text == "")
                    {
                        MessageBox.Show(this, "发表日期不能为空!");
                        txtTime.Focus();
                    }
                    else if (!PageValidateBll.IsDateTime(txtTime.Text))
                    {
                        MessageBox.Show(this, "发表日期格式不正确!");
                        txtTime.Focus();
                    }
                    else if (txtTitle.Text == "")
                    {
                        MessageBox.Show(this, "成果名称不能为空!");
                        txtTitle.Focus();
                    }
                    else if (ddlType.SelectedValue == "-1")
                    {
                        MessageBox.Show(this, "请选择学科!");
                        ddlType.Focus();
                    }
                    else if (ddlUnit.SelectedValue == "-1")
                    {
                        MessageBox.Show(this, "请选择发表刊物名称/来源!");
                        ddlUnit.Focus();
                    }
                    else if (ddlSchoolSign.SelectedValue == "-1")
                    {
                        MessageBox.Show(this, "请选择学校署名排名!");
                        ddlSchoolSign.Focus();
                    }
                    else if (ddlRank.SelectedValue == "-1")
                    {
                        MessageBox.Show(this, "请选择完成成果排名!");
                        ddlRank.Focus();
                    }
                    else
                    {
                        string   strAID        = txtAID.Text;                            //成果编号
                        string   strUserID     = Session["UserID"].ToString();           //用户编号
                        string   strBigSort    = "科研成果";                                 //大类别
                        string   strSmallSort  = "创作类成果";                                //小类别
                        string   strType       = ddlType.SelectedItem.Text;              //创作类学科(美术/音乐/体育/文学)
                        string   strTitle      = txtTitle.Text;                          //成果名称
                        DateTime dtAddTime     = DateTime.Now;                           //提交时间
                        string   strUnit       = ddlUnit.SelectedItem.Text;              //发表刊物来源
                        DateTime dtPublishTime = Convert.ToDateTime(txtTime.Text);       //发表日期
                        int      intRank       = Convert.ToInt32(ddlRank.SelectedValue); //完成成果排名
                        string   strSchoolSign = ddlSchoolSign.SelectedItem.Text;        //学校署名排名
                        string   strRemark     = txtRemark.Text;                         //备注

                        AchievementModel.PK_AID      = strAID;                           //成果编号
                        AchievementModel.FK_UserID   = strUserID;                        //用户编号
                        AchievementModel.BigSort     = strBigSort;                       //大类别
                        AchievementModel.SmallSort   = strSmallSort;                     //小类别
                        AchievementModel.Type        = strType;                          //创作类学科(美术/音乐/体育/文学)
                        AchievementModel.Title       = strTitle;                         //成果名称
                        AchievementModel.AddTime     = dtAddTime;                        //提交时间
                        AchievementModel.Unit        = strUnit;                          //发表刊物来源
                        AchievementModel.PublishTime = dtPublishTime;                    //发表日期
                        AchievementModel.Rank        = intRank;                          //完成成果排名
                        AchievementModel.SchoolSign  = strSchoolSign;                    //学校署名排名
                        AchievementModel.Remark      = strRemark;                        //备注
                        AchievementModel.AuditState  = strAuditState;                    //审核状态

                        //计算成果总得分
                        ProduceModel = ProduceBll.GetJiBieBySource(strUnit);
                        string  strJiBie       = ""; //级别
                        decimal decLevelFactor = 0;  //级别分系数
                        decimal decScore       = 0;  //成果总得分
                        if (ProduceModel != null)
                        {
                            strJiBie                     = ProduceModel.JiBie;
                            decLevelFactor               = Convert.ToDecimal(ProduceModel.LevelFactor);
                            AchievementModel.JiBie       = strJiBie;                 //级别
                            AchievementModel.LevelFactor = decLevelFactor;           //级别分系数

                            int intScore = LevelScoresBll.GetScoreByJiBie(strJiBie); //根据级别得到对应的级别分数
                            decScore = intScore * decLevelFactor;
                        }


                        //计算成果个人得分
                        int     intPopulation = 1;  //完成人数
                        string  strAllAuthor  = ""; //参与作者
                        decimal decPerScore   = 0;  //个人得分
                        //根据完成成果排名判断是否为多人合作,若是则按多人合作个人所占比例规则计算得分
                        //若否则成果总得分即为个人得分
                        if (!(intRank == -1 || intRank == 0))
                        {
                            if (txtPopulation.Text == "")
                            {
                                MessageBox.Show(this, "完成人数不能为空!");
                                txtPopulation.Focus();
                            }
                            else if (!PageValidateBll.IsNumber(txtPopulation.Text))
                            {
                                MessageBox.Show(this, "完成人数只能填写数字!");
                                txtPopulation.Focus();
                            }
                            else if (txtAllAuthor.Text == "")
                            {
                                MessageBox.Show(this, "参与作者不能为空!");
                                txtAllAuthor.Focus();
                            }
                            else
                            {
                                intPopulation = Convert.ToInt32(txtPopulation.Text);
                                strAllAuthor  = txtAllAuthor.Text;
                                //根据完成人数和完成成果排名返回对应的得分比例
                                Cal2Model = Cal2Bll.GetScoreScale(intPopulation, intRank);
                                if (Cal2Model != null)
                                {
                                    string   strScale = Cal2Model.ScoreScale;
                                    string[] str      = strScale.Split('/');
                                    int      int1     = int.Parse(str[0]);
                                    int      int2     = int.Parse(str[1]);
                                    decPerScore = decScore * int1 / int2;
                                    AchievementModel.Population = intPopulation; //完成人数
                                    AchievementModel.AllAuthor  = strAllAuthor;  //参与作者
                                    AchievementModel.PerScore   = decPerScore;   //个人得分

                                    if (cmd == "add")                            //新增
                                    {
                                        if (!AchievementBll.Exists(strAID))
                                        {
                                            AchievementBll.Add(AchievementModel);
                                        }
                                        else
                                        {
                                            MessageBox.Show(this, "已经存在该记录");
                                        }
                                    }
                                    if (cmd == "modify")  //修改
                                    {
                                        AchievementBll.Update(AchievementModel);
                                    }
                                    Response.Redirect("ChuangZuo_List.aspx");
                                }
                            }
                        }
                        else
                        {
                            decPerScore = decScore;
                            AchievementModel.Population = intPopulation; //完成人数
                            AchievementModel.AllAuthor  = strAllAuthor;  //参与作者
                            AchievementModel.PerScore   = decPerScore;   //个人得分
                            if (cmd == "add")                            //新增
                            {
                                if (!AchievementBll.Exists(strAID))
                                {
                                    AchievementBll.Add(AchievementModel);
                                }
                                else
                                {
                                    MessageBox.Show(this, "已经存在该记录");
                                }
                            }
                            if (cmd == "modify")  //修改
                            {
                                AchievementBll.Update(AchievementModel);
                            }
                            Response.Redirect("ChuangZuo_List.aspx");
                        }
                    }
                }
                catch (Exception ex)
                {
                    throw ex;
                }
            }
            else
            {
                Response.Write("<script language=javascript>alert('您已经与服务器断开连接,请重新登录!');window.location.href='~/../../login.aspx';</script>");
            }
        }
        private void Save(string strAuditState)
        {
            if (Session["UserID"] != null)
            {
                string cmd = Request.QueryString["cmd"].ToString();
                try
                {
                    if (txtTime.Text == "")
                    {
                        MessageBox.Show(this, "发表日期不能为空!");
                        txtTime.Focus();
                    }
                    else if (!PageValidateBll.IsDateTime(txtTime.Text))
                    {
                        MessageBox.Show(this, "发表日期格式不正确!");
                        txtTime.Focus();
                    }
                    else if (txtTitle.Text == "")
                    {
                        MessageBox.Show(this, "成果名称不能为空!");
                        txtTitle.Focus();
                    }
                    else if (ddlType.SelectedValue == "-1")
                    {
                        MessageBox.Show(this, "请选择学科!");
                        ddlType.Focus();
                    }
                    else if (ddlUnit.SelectedValue == "-1")
                    {
                        MessageBox.Show(this, "请选择发表刊物名称/来源!");
                        ddlUnit.Focus();
                    }
                    else if (ddlSchoolSign.SelectedValue == "-1")
                    {
                        MessageBox.Show(this, "请选择学校署名排名!");
                        ddlSchoolSign.Focus();
                    }
                    else if (ddlRank.SelectedValue == "-1")
                    {
                        MessageBox.Show(this, "请选择完成成果排名!");
                        ddlRank.Focus();
                    }
                    else
                    {
                        string strAID = txtAID.Text;    //成果编号
                        string strUserID = Session["UserID"].ToString();     //用户编号
                        string strBigSort = "科研成果";    //大类别
                        string strSmallSort = "创作类成果";    //小类别
                        string strType = ddlType.SelectedItem.Text;     //创作类学科(美术/音乐/体育/文学)
                        string strTitle = txtTitle.Text;    //成果名称
                        DateTime dtAddTime = DateTime.Now;  //提交时间
                        string strUnit = ddlUnit.SelectedItem.Text;  //发表刊物来源
                        DateTime dtPublishTime = Convert.ToDateTime(txtTime.Text);  //发表日期
                        int intRank = Convert.ToInt32(ddlRank.SelectedValue);   //完成成果排名
                        string strSchoolSign = ddlSchoolSign.SelectedItem.Text;     //学校署名排名
                        string strRemark = txtRemark.Text;  //备注

                        AchievementModel.PK_AID = strAID;   //成果编号
                        AchievementModel.FK_UserID = strUserID;   //用户编号
                        AchievementModel.BigSort = strBigSort;    //大类别
                        AchievementModel.SmallSort = strSmallSort;  //小类别
                        AchievementModel.Type = strType;    //创作类学科(美术/音乐/体育/文学)
                        AchievementModel.Title = strTitle;  //成果名称
                        AchievementModel.AddTime = dtAddTime;   //提交时间
                        AchievementModel.Unit = strUnit;    //发表刊物来源
                        AchievementModel.PublishTime = dtPublishTime;   //发表日期
                        AchievementModel.Rank = intRank;    //完成成果排名
                        AchievementModel.SchoolSign = strSchoolSign;    //学校署名排名
                        AchievementModel.Remark = strRemark;    //备注
                        AchievementModel.AuditState = strAuditState;  //审核状态

                        //计算成果总得分
                        ProduceModel = ProduceBll.GetJiBieBySource(strUnit);
                        string strJiBie = "";   //级别
                        decimal decLevelFactor = 0;     //级别分系数
                        decimal decScore = 0;   //成果总得分
                        if (ProduceModel != null)
                        {
                            strJiBie = ProduceModel.JiBie;
                            decLevelFactor = Convert.ToDecimal(ProduceModel.LevelFactor);
                            AchievementModel.JiBie = strJiBie;  //级别
                            AchievementModel.LevelFactor = decLevelFactor;  //级别分系数

                            int intScore = LevelScoresBll.GetScoreByJiBie(strJiBie);    //根据级别得到对应的级别分数
                            decScore = intScore * decLevelFactor;
                        }

                        //计算成果个人得分
                        int intPopulation = 1;      //完成人数
                        string strAllAuthor = "";   //参与作者
                        decimal decPerScore = 0;    //个人得分
                        //根据完成成果排名判断是否为多人合作,若是则按多人合作个人所占比例规则计算得分
                        //若否则成果总得分即为个人得分
                        if (!(intRank == -1 || intRank == 0))
                        {
                            if (txtPopulation.Text == "")
                            {
                                MessageBox.Show(this, "完成人数不能为空!");
                                txtPopulation.Focus();
                            }
                            else if (!PageValidateBll.IsNumber(txtPopulation.Text))
                            {
                                MessageBox.Show(this, "完成人数只能填写数字!");
                                txtPopulation.Focus();
                            }
                            else if (txtAllAuthor.Text == "")
                            {
                                MessageBox.Show(this, "参与作者不能为空!");
                                txtAllAuthor.Focus();
                            }
                            else
                            {
                                intPopulation = Convert.ToInt32(txtPopulation.Text);
                                strAllAuthor = txtAllAuthor.Text;
                                //根据完成人数和完成成果排名返回对应的得分比例
                                Cal2Model = Cal2Bll.GetScoreScale(intPopulation, intRank);
                                if (Cal2Model != null)
                                {
                                    string strScale = Cal2Model.ScoreScale;
                                    string[] str = strScale.Split('/');
                                    int int1 = int.Parse(str[0]);
                                    int int2 = int.Parse(str[1]);
                                    decPerScore = decScore * int1 / int2;
                                    AchievementModel.Population = intPopulation;    //完成人数
                                    AchievementModel.AllAuthor = strAllAuthor;  //参与作者
                                    AchievementModel.PerScore = decPerScore;    //个人得分

                                    if (cmd == "add")   //新增
                                    {
                                        if (!AchievementBll.Exists(strAID))
                                        {
                                            AchievementBll.Add(AchievementModel);
                                        }
                                        else
                                        {
                                            MessageBox.Show(this, "已经存在该记录");
                                        }
                                    }
                                    if (cmd == "modify")  //修改
                                    {
                                        AchievementBll.Update(AchievementModel);
                                    }
                                    Response.Redirect("ChuangZuo_List.aspx");
                                }
                            }
                        }
                        else
                        {
                            decPerScore = decScore;
                            AchievementModel.Population = intPopulation;    //完成人数
                            AchievementModel.AllAuthor = strAllAuthor;  //参与作者
                            AchievementModel.PerScore = decPerScore;    //个人得分
                            if (cmd == "add")   //新增
                            {
                                if (!AchievementBll.Exists(strAID))
                                {
                                    AchievementBll.Add(AchievementModel);
                                }
                                else
                                {
                                    MessageBox.Show(this,"已经存在该记录");
                                }
                            }
                            if (cmd == "modify")  //修改
                            {
                                AchievementBll.Update(AchievementModel);
                            }
                            Response.Redirect("ChuangZuo_List.aspx");
                        }
                    }
                }
                catch (Exception ex)
                {

                    throw ex;
                }
            }
            else
            {
                Response.Write("<script language=javascript>alert('您已经与服务器断开连接,请重新登录!');window.location.href='~/../../login.aspx';</script>");
            }
        }
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public void Update(ZQUSR.Model.sr_Calculate2 model)
 {
     dal.Update(model);
 }
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int  Add(ZQUSR.Model.sr_Calculate2 model)
 {
     return(dal.Add(model));
 }