internal bool Update(RTreatises model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update RTreatises set "); stringBuilder.Append("RTreatisesNo=@RTreatisesNo,"); stringBuilder.Append("RTreatisesType=@RTreatisesType,"); stringBuilder.Append("RTreatisesAuthor=@RTreatisesAuthor,"); stringBuilder.Append("RTreatisesName=@RTreatisesName,"); stringBuilder.Append("RTreatisesJournalTitle=@RTreatisesJournalTitle,"); stringBuilder.Append("RTreatisesRell=@RTreatisesRell,"); stringBuilder.Append("RTreatisesPage=@RTreatisesPage,"); stringBuilder.Append("RTreatisesCollection=@RTreatisesCollection,"); stringBuilder.Append("RTreatisesContent=@RTreatisesContent,"); stringBuilder.Append("RTreatisesPDF=@RTreatisesPDF,"); stringBuilder.Append("RTreatisesPDFOName=@RTreatisesPDFOName,"); stringBuilder.Append("RTreatisesOrder=@RTreatisesOrder"); stringBuilder.Append(" where RTreatisesNo=@RTreatisesNo"); SQLiteParameter[] array = new SQLiteParameter[] { new SQLiteParameter("@RTreatisesNo", DbType.String), new SQLiteParameter("@RTreatisesType", DbType.String), new SQLiteParameter("@RTreatisesAuthor", DbType.String), new SQLiteParameter("@RTreatisesName", DbType.String), new SQLiteParameter("@RTreatisesJournalTitle", DbType.String), new SQLiteParameter("@RTreatisesRell", DbType.String), new SQLiteParameter("@RTreatisesPage", DbType.String), new SQLiteParameter("@RTreatisesCollection", DbType.String), new SQLiteParameter("@RTreatisesContent", DbType.String), new SQLiteParameter("@RTreatisesPDF", DbType.String), new SQLiteParameter("@RTreatisesPDFOName", DbType.String), new SQLiteParameter("@RTreatisesOrder", DbType.Int32, 4) }; array[0].Value = model.RTreatisesNo; array[1].Value = model.RTreatisesType; array[2].Value = model.RTreatisesAuthor; array[3].Value = model.RTreatisesName; array[4].Value = model.RTreatisesJournalTitle; array[5].Value = model.RTreatisesRell; array[6].Value = model.RTreatisesPage; array[7].Value = model.RTreatisesCollection; array[8].Value = model.RTreatisesContent; array[9].Value = model.RTreatisesPDF; array[10].Value = model.RTreatisesPDFOName; array[11].Value = model.RTreatisesOrder; string text = ""; base.ExecuteNonQuery(stringBuilder.ToString(), array, out text); return(true); }
internal bool Add(RTreatises model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("insert into RTreatises("); stringBuilder.Append("RTreatisesNo,RTreatisesType,RTreatisesAuthor,RTreatisesName,RTreatisesJournalTitle,RTreatisesRell,RTreatisesPage,RTreatisesCollection,RTreatisesContent,RTreatisesPDF,RTreatisesPDFOName,RTreatisesOrder)"); stringBuilder.Append(" values ("); stringBuilder.Append("@RTreatisesNo,@RTreatisesType,@RTreatisesAuthor,@RTreatisesName,@RTreatisesJournalTitle,@RTreatisesRell,@RTreatisesPage,@RTreatisesCollection,@RTreatisesContent,@RTreatisesPDF,@RTreatisesPDFOName,@RTreatisesOrder)"); SQLiteParameter[] array = new SQLiteParameter[] { new SQLiteParameter("@RTreatisesNo", DbType.String), new SQLiteParameter("@RTreatisesType", DbType.String), new SQLiteParameter("@RTreatisesAuthor", DbType.String), new SQLiteParameter("@RTreatisesName", DbType.String), new SQLiteParameter("@RTreatisesJournalTitle", DbType.String), new SQLiteParameter("@RTreatisesRell", DbType.String), new SQLiteParameter("@RTreatisesPage", DbType.String), new SQLiteParameter("@RTreatisesCollection", DbType.String), new SQLiteParameter("@RTreatisesContent", DbType.String), new SQLiteParameter("@RTreatisesPDF", DbType.String), new SQLiteParameter("@RTreatisesPDFOName", DbType.String), new SQLiteParameter("@RTreatisesOrder", DbType.Int32, 4) }; array[0].Value = model.RTreatisesNo; array[1].Value = model.RTreatisesType; array[2].Value = model.RTreatisesAuthor; array[3].Value = model.RTreatisesName; array[4].Value = model.RTreatisesJournalTitle; array[5].Value = model.RTreatisesRell; array[6].Value = model.RTreatisesPage; array[7].Value = model.RTreatisesCollection; array[8].Value = model.RTreatisesContent; array[9].Value = model.RTreatisesPDF; array[10].Value = model.RTreatisesPDFOName; array[11].Value = model.RTreatisesOrder; string text = ""; base.ExecuteNonQuery(stringBuilder.ToString(), array, out text); return(true); }
private bool SaveProgress() { this.OnSaveCheckDenyEvent(EventArgs.Empty); IList <RTreatises> list = new List <RTreatises>(); for (int i = 0; i < this.dRTreatises.RowCount - 1; i++) { DataGridViewRow dataGridViewRow = this.dRTreatises.Rows[i]; RTreatises rTreatises = new RTreatises(); rTreatises.RTreatisesNo = ((dataGridViewRow.Cells["paperid"].Value == null) ? "" : dataGridViewRow.Cells["paperid"].Value.ToString()); rTreatises.RTreatisesName = ((dataGridViewRow.Cells["papername"].Value == null || dataGridViewRow.Cells["papername"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["papername"].Value.ToString()); rTreatises.RTreatisesRell = ((dataGridViewRow.Cells["paperyear"].Value == null || dataGridViewRow.Cells["paperyear"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["paperyear"].Value.ToString()); string a; if (dataGridViewRow.Cells["papertype"].Value != null && dataGridViewRow.Cells["papertype"].Value != DBNull.Value && (a = dataGridViewRow.Cells["papertype"].Value.ToString()) != null) { if (!(a == "论文")) { if (!(a == "著作")) { if (!(a == "研究技术报告")) { if (a == "重要学术会议邀请报告") { rTreatises.RTreatisesType = "4"; } } else { rTreatises.RTreatisesType = "3"; } } else { rTreatises.RTreatisesType = "2"; } } else { rTreatises.RTreatisesType = "1"; } } rTreatises.RTreatisesJournalTitle = ((dataGridViewRow.Cells["paperpublish"].Value == null || dataGridViewRow.Cells["paperpublish"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["paperpublish"].Value.ToString()); rTreatises.RTreatisesCollection = ((dataGridViewRow.Cells["paperref"].Value == null || dataGridViewRow.Cells["paperref"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["paperref"].Value.ToString()); rTreatises.RTreatisesAuthor = ((dataGridViewRow.Cells["paperorder"].Value == null || dataGridViewRow.Cells["paperorder"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["paperorder"].Value.ToString()); rTreatises.RTreatisesPDF = ((dataGridViewRow.Cells["hiddenRTreatisesPDFOName"].Value == null || dataGridViewRow.Cells["hiddenRTreatisesPDFOName"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["hiddenRTreatisesPDFOName"].Value.ToString()); rTreatises.RTreatisesPDFOName = ((dataGridViewRow.Cells["paperattachmentinfo"].Value == null || dataGridViewRow.Cells["paperattachmentinfo"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["paperattachmentinfo"].Value.ToString()); rTreatises.UpLoadFullPath = ((dataGridViewRow.Cells["uploadfullpath"].Value == null || dataGridViewRow.Cells["uploadfullpath"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["uploadfullpath"].Value.ToString()); rTreatises.RTreatisesOrder = this.dRTreatises.RowCount - i; if (rTreatises.RTreatisesName == "" || rTreatises.RTreatisesType == "" || rTreatises.RTreatisesRell == "" || rTreatises.RTreatisesJournalTitle == "" || rTreatises.RTreatisesPDFOName == "") { MessageBox.Show("所有字段均为必填字段,代表性著作需要上传对应的PDF支撑文件", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return(false); } int num; if (!int.TryParse(rTreatises.RTreatisesAuthor, out num)) { MessageBox.Show("录入的排名有非整数数据", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return(false); } list.Add(rTreatises); } if (list.Count > 10) { MessageBox.Show("录入的代表性著作记录条数超过10条", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return(false); } this.OnSaveCheckPassedEvent(EventArgs.Empty); this._rTreatisesService.UpdateRTreatisess(list); list = this._rTreatisesService.GetRTreatises(); this.LoadData(list); return(true); }