예제 #1
0
        /// <summary>
        /// 参数选择按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void btnPreParaSelect_Click(object sender, EventArgs e)
        {
            List <SelectedPramas> SelectedPramasInfoList = new List <SelectedPramas>();

            foreach (DataGridViewRow row in dgvPreParamSelection.Rows)
            {
                DataGridViewCheckBoxCell checkbox = (DataGridViewCheckBoxCell)row.Cells[0];
                if (checkbox.Value == null)
                {
                    checkbox.Value = 0;
                }
                if ((int)checkbox.Value == 1)
                {
                    SelectedPramas SelectedPramasInfo = new SelectedPramas();
                    SelectedPramasInfo.PramasId   = Convert.ToInt32(row.Cells["PramasID"].Value);
                    SelectedPramasInfo.PramasText = row.Cells["ParamNameSelection"].Value.ToString();
                    SelectedPramasInfo.ProName    = HAZOP分析系统.ProName;
                    SelectedPramasInfoList.Add(SelectedPramasInfo);
                }
            }
            if (SelectedPramasInfoList.Count > 0)
            {
                if (spbll.Add_SelectedPramasinfo(SelectedPramasInfoList))
                {
                    PreParamSledDataBind();
                    PreParamSelectionDataBind();
                }
            }
            else
            {
                MessageBox.Show("请选择参数!");
            }
        }
        /// <summary>
        /// 根据项目名获取已选择项目参数列表
        /// </summary>
        /// <param name="ProName">项目名</param>
        /// <param name="SelectedPramas">HOZAPModel命名空间中的SelectedPramas类,已选择参数类</param>
        /// <returns>已选择项目参数列表</returns>
        public List <SelectedPramas> Get_SelectedPramasList(string ProName)
        {
            string sql = "select * from tb_SelectedPramas where ProName=@ProName";
            List <SelectedPramas> SelectedPramasList = null;

            using (SqlDataReader sdr = SqlHelper.ExecuteReader(sql, new SqlParameter("@ProName", ProName)))
            {
                if (sdr.HasRows)
                {
                    SelectedPramasList = new List <SelectedPramas>();
                    while (sdr.Read()) //追条读取已选参数数据表中的数据
                    {
                        SelectedPramas selectedpramas = new SelectedPramas();
                        selectedpramas.PramasId   = sdr.GetInt32(0);
                        selectedpramas.PramasText = sdr.GetString(1);
                        selectedpramas.ProName    = sdr.GetString(2);
                        SelectedPramasList.Add(selectedpramas);
                    }
                }
            }
            return(SelectedPramasList);
        }