Example #1
0
        internal bool Add(TechnologyAwards model)
        {
            StringBuilder stringBuilder = new StringBuilder();

            stringBuilder.Append("insert into TechnologyAwards(");
            stringBuilder.Append("TechnologyAwardsNo,TechnologyAwardsee,TechnologyAwardsPName,TechnologyAwardsYear,TechnologyAwardsTypeLevel,TechnologyAwardsContent,TechnologyAwardsPDF,TechnologyAwardsPDFOName,TechnologyAwardsOrder)");
            stringBuilder.Append(" values (");
            stringBuilder.Append("@TechnologyAwardsNo,@TechnologyAwardsee,@TechnologyAwardsPName,@TechnologyAwardsYear,@TechnologyAwardsTypeLevel,@TechnologyAwardsContent,@TechnologyAwardsPDF,@TechnologyAwardsPDFOName,@TechnologyAwardsOrder)");
            SQLiteParameter[] array = new SQLiteParameter[]
            {
                new SQLiteParameter("@TechnologyAwardsNo", DbType.String),
                new SQLiteParameter("@TechnologyAwardsee", DbType.String),
                new SQLiteParameter("@TechnologyAwardsPName", DbType.String),
                new SQLiteParameter("@TechnologyAwardsYear", DbType.String),
                new SQLiteParameter("@TechnologyAwardsTypeLevel", DbType.String),
                new SQLiteParameter("@TechnologyAwardsContent", DbType.String),
                new SQLiteParameter("@TechnologyAwardsPDF", DbType.String),
                new SQLiteParameter("@TechnologyAwardsPDFOName", DbType.String),
                new SQLiteParameter("@TechnologyAwardsOrder", DbType.Int32, 4)
            };
            array[0].Value = model.TechnologyAwardsNo;
            array[1].Value = model.TechnologyAwardsee;
            array[2].Value = model.TechnologyAwardsPName;
            array[3].Value = model.TechnologyAwardsYear;
            array[4].Value = model.TechnologyAwardsTypeLevel;
            array[5].Value = model.TechnologyAwardsContent;
            array[6].Value = model.TechnologyAwardsPDF;
            array[7].Value = model.TechnologyAwardsPDFOName;
            array[8].Value = model.TechnologyAwardsOrder;
            string text = "";

            base.ExecuteNonQuery(stringBuilder.ToString(), array, out text);
            return(true);
        }
Example #2
0
        private bool SaveProgress()
        {
            this.OnSaveCheckDenyEvent(EventArgs.Empty);
            IList <TechnologyAwards> list = new List <TechnologyAwards>();

            for (int i = 0; i < this.dTechnologyAwards.RowCount - 1; i++)
            {
                DataGridViewRow  dataGridViewRow  = this.dTechnologyAwards.Rows[i];
                TechnologyAwards technologyAwards = new TechnologyAwards();
                technologyAwards.TechnologyAwardsNo        = ((dataGridViewRow.Cells["scienceid"].Value == null) ? "" : dataGridViewRow.Cells["scienceid"].Value.ToString());
                technologyAwards.TechnologyAwardsPName     = ((dataGridViewRow.Cells["sciencename"].Value == null || dataGridViewRow.Cells["sciencename"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["sciencename"].Value.ToString());
                technologyAwards.TechnologyAwardsTypeLevel = ((dataGridViewRow.Cells["sciencelevel"].Value == null || dataGridViewRow.Cells["sciencelevel"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["sciencelevel"].Value.ToString());
                technologyAwards.TechnologyAwardsYear      = ((dataGridViewRow.Cells["sciencedate"].Value == null || dataGridViewRow.Cells["sciencedate"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["sciencedate"].Value.ToString());
                technologyAwards.TechnologyAwardsee        = ((dataGridViewRow.Cells["scienceorder"].Value == null || dataGridViewRow.Cells["scienceorder"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["scienceorder"].Value.ToString());
                technologyAwards.TechnologyAwardsPDFOName  = ((dataGridViewRow.Cells["scienceattainfo"].Value == null || dataGridViewRow.Cells["scienceattainfo"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["scienceattainfo"].Value.ToString());
                technologyAwards.TechnologyAwardsPDF       = ((dataGridViewRow.Cells["hiddenStoreName"].Value == null || dataGridViewRow.Cells["hiddenStoreName"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["hiddenStoreName"].Value.ToString());
                technologyAwards.UpLoadFullPath            = ((dataGridViewRow.Cells["UpLoadFullyName"].Value == null || dataGridViewRow.Cells["UpLoadFullyName"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["UpLoadFullyName"].Value.ToString());
                technologyAwards.TechnologyAwardsOrder     = this.dTechnologyAwards.RowCount - i;
                if (technologyAwards.TechnologyAwardsPName == "" || technologyAwards.TechnologyAwardsTypeLevel == "" || technologyAwards.TechnologyAwardsYear == "" || technologyAwards.TechnologyAwardsee == "" || technologyAwards.TechnologyAwardsPDFOName == "")
                {
                    MessageBox.Show("所有字段均为必填字段,重要科技奖项需要上传对应的PDF支撑文件", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    return(false);
                }
                int num;
                if (!int.TryParse(technologyAwards.TechnologyAwardsee, out num))
                {
                    MessageBox.Show("录入的排名有非整数数据", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                    return(false);
                }
                list.Add(technologyAwards);
            }
            if (list.Count > 10)
            {
                MessageBox.Show("录入的重要科技奖项记录条数超过10条", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
                return(false);
            }
            this.OnSaveCheckPassedEvent(EventArgs.Empty);
            this._technologyAwardsService.UpdateTechnologyAwards(list);
            list = this._technologyAwardsService.GetTechnologyAwards();
            this.LoadData(list);
            return(true);
        }
Example #3
0
        internal bool Update(TechnologyAwards model)
        {
            StringBuilder stringBuilder = new StringBuilder();

            stringBuilder.Append("update TechnologyAwards set ");
            stringBuilder.Append("TechnologyAwardsNo=@TechnologyAwardsNo,");
            stringBuilder.Append("TechnologyAwardsee=@TechnologyAwardsee,");
            stringBuilder.Append("TechnologyAwardsPName=@TechnologyAwardsPName,");
            stringBuilder.Append("TechnologyAwardsYear=@TechnologyAwardsYear,");
            stringBuilder.Append("TechnologyAwardsTypeLevel=@TechnologyAwardsTypeLevel,");
            stringBuilder.Append("TechnologyAwardsContent=@TechnologyAwardsContent,");
            stringBuilder.Append("TechnologyAwardsPDF=@TechnologyAwardsPDF,");
            stringBuilder.Append("TechnologyAwardsPDFOName=@TechnologyAwardsPDFOName,");
            stringBuilder.Append("TechnologyAwardsOrder=@TechnologyAwardsOrder");
            stringBuilder.Append(" where TechnologyAwardsNo=@TechnologyAwardsNo");
            SQLiteParameter[] array = new SQLiteParameter[]
            {
                new SQLiteParameter("@TechnologyAwardsNo", DbType.String),
                new SQLiteParameter("@TechnologyAwardsee", DbType.String),
                new SQLiteParameter("@TechnologyAwardsPName", DbType.String),
                new SQLiteParameter("@TechnologyAwardsYear", DbType.String),
                new SQLiteParameter("@TechnologyAwardsTypeLevel", DbType.String),
                new SQLiteParameter("@TechnologyAwardsContent", DbType.String),
                new SQLiteParameter("@TechnologyAwardsPDF", DbType.String),
                new SQLiteParameter("@TechnologyAwardsPDFOName", DbType.String),
                new SQLiteParameter("@TechnologyAwardsOrder", DbType.Int32, 4)
            };
            array[0].Value = model.TechnologyAwardsNo;
            array[1].Value = model.TechnologyAwardsee;
            array[2].Value = model.TechnologyAwardsPName;
            array[3].Value = model.TechnologyAwardsYear;
            array[4].Value = model.TechnologyAwardsTypeLevel;
            array[5].Value = model.TechnologyAwardsContent;
            array[6].Value = model.TechnologyAwardsPDF;
            array[7].Value = model.TechnologyAwardsPDFOName;
            array[8].Value = model.TechnologyAwardsOrder;
            string text = "";

            base.ExecuteNonQuery(stringBuilder.ToString(), array, out text);
            return(true);
        }