internal bool Update(NDProject model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update NDProject set "); stringBuilder.Append("NDProjectNo=@NDProjectNo,"); stringBuilder.Append("NDProjectSYear=@NDProjectSYear,"); stringBuilder.Append("NDProjectEYear=@NDProjectEYear,"); stringBuilder.Append("NDProjectName=@NDProjectName,"); stringBuilder.Append("NDProjectType=@NDProjectType,"); stringBuilder.Append("NDProjectSource=@NDProjectSource,"); stringBuilder.Append("NDProjectOutlay=@NDProjectOutlay,"); stringBuilder.Append("NDProjectTaskBySelf=@NDProjectTaskBySelf,"); stringBuilder.Append("NDProjectUserOrder=@NDProjectUserOrder,"); stringBuilder.Append("NDProjectOrder=@NDProjectOrder"); stringBuilder.Append(" where NDProjectNo=@NDProjectNo"); SQLiteParameter[] array = new SQLiteParameter[] { new SQLiteParameter("@NDProjectNo", DbType.String), new SQLiteParameter("@NDProjectSYear", DbType.String), new SQLiteParameter("@NDProjectEYear", DbType.String), new SQLiteParameter("@NDProjectName", DbType.String), new SQLiteParameter("@NDProjectType", DbType.String), new SQLiteParameter("@NDProjectSource", DbType.String), new SQLiteParameter("@NDProjectOutlay", DbType.String), new SQLiteParameter("@NDProjectTaskBySelf", DbType.String), new SQLiteParameter("@NDProjectUserOrder", DbType.String), new SQLiteParameter("@NDProjectOrder", DbType.Int32, 4) }; array[0].Value = model.NDProjectNo; array[1].Value = model.NDProjectSYear; array[2].Value = model.NDProjectEYear; array[3].Value = model.NDProjectName; array[4].Value = model.NDProjectType; array[5].Value = model.NDProjectSource; array[6].Value = model.NDProjectOutlay; array[7].Value = model.NDProjectTaskBySelf; array[8].Value = model.NDProjectUserOrder; array[9].Value = model.NDProjectOrder; string text = ""; base.ExecuteNonQuery(stringBuilder.ToString(), array, out text); return(true); }
private bool SaveProgress() { this.OnSaveCheckDenyEvent(EventArgs.Empty); IList<NDProject> list = new List<NDProject>(); for (int i = 0; i < this.dproject.RowCount - 1; i++) { DataGridViewRow dataGridViewRow = this.dproject.Rows[i]; NDProject nDProject = new NDProject(); nDProject.NDProjectNo = ((dataGridViewRow.Cells["defenceid"].Value == null) ? "" : dataGridViewRow.Cells["defenceid"].Value.ToString()); nDProject.NDProjectSYear = ((dataGridViewRow.Cells["defencestartdate"].Value == null || dataGridViewRow.Cells["defencestartdate"].Value == DBNull.Value || dataGridViewRow.Cells["defencestartdate"].Value.ToString() == "") ? "" : ((DateTime)dataGridViewRow.Cells["defencestartdate"].Value).ToString("yyyy-MM-dd")); nDProject.NDProjectEYear = ((dataGridViewRow.Cells["defenceenddate"].Value == null || dataGridViewRow.Cells["defenceenddate"].Value == DBNull.Value || dataGridViewRow.Cells["defenceenddate"].Value.ToString() == "") ? "" : ((DateTime)dataGridViewRow.Cells["defenceenddate"].Value).ToString("yyyy-MM-dd")); nDProject.NDProjectName = ((dataGridViewRow.Cells["defencename"].Value == null || dataGridViewRow.Cells["defencename"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["defencename"].Value.ToString()); nDProject.NDProjectSource = ((dataGridViewRow.Cells["defencesource"].Value == null || dataGridViewRow.Cells["defencesource"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["defencesource"].Value.ToString()); nDProject.NDProjectOutlay = ((dataGridViewRow.Cells["defencefee"].Value == null || dataGridViewRow.Cells["defencefee"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["defencefee"].Value.ToString()); nDProject.NDProjectTaskBySelf = ((dataGridViewRow.Cells["defencemaintask"].Value == null || dataGridViewRow.Cells["defencemaintask"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["defencemaintask"].Value.ToString()); nDProject.NDProjectUserOrder = ((dataGridViewRow.Cells["defenceorder"].Value == null || dataGridViewRow.Cells["defenceorder"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["defenceorder"].Value.ToString()); nDProject.NDProjectSource = ((dataGridViewRow.Cells["defencesource"].Value == null || dataGridViewRow.Cells["defencesource"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["defencesource"].Value.ToString()); nDProject.NDProjectOrder = this.dproject.RowCount - i; if (nDProject.NDProjectName == "" || nDProject.NDProjectSYear == "" || nDProject.NDProjectOutlay == "" || nDProject.NDProjectUserOrder == "" || nDProject.NDProjectTaskBySelf == "") { MessageBox.Show("项目名称、开始年月,经费、主要承担任务、排名为必填字段,检测到部分字段未填写完整", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return false; } decimal num; if (!decimal.TryParse(nDProject.NDProjectOutlay, out num)) { MessageBox.Show("录入的经费有非数值数据", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return false; } DateTime.Parse(nDProject.NDProjectSYear); list.Add(nDProject); } if (list.Count > 10) { MessageBox.Show("录入的国防相关代表性项目记录条数超过10条", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return false; } this.OnSaveCheckPassedEvent(EventArgs.Empty); this._nDProjectService.UpdateNDProjects(list); list = this._nDProjectService.GetNDProject(); this.LoadData(list); return true; }
internal bool Add(NDProject model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("insert into NDProject("); stringBuilder.Append("NDProjectNo,NDProjectSYear,NDProjectEYear,NDProjectName,NDProjectType,NDProjectSource,NDProjectOutlay,NDProjectTaskBySelf,NDProjectUserOrder,NDProjectOrder)"); stringBuilder.Append(" values ("); stringBuilder.Append("@NDProjectNo,@NDProjectSYear,@NDProjectEYear,@NDProjectName,@NDProjectType,@NDProjectSource,@NDProjectOutlay,@NDProjectTaskBySelf,@NDProjectUserOrder,@NDProjectOrder)"); SQLiteParameter[] array = new SQLiteParameter[] { new SQLiteParameter("@NDProjectNo", DbType.String), new SQLiteParameter("@NDProjectSYear", DbType.String), new SQLiteParameter("@NDProjectEYear", DbType.String), new SQLiteParameter("@NDProjectName", DbType.String), new SQLiteParameter("@NDProjectType", DbType.String), new SQLiteParameter("@NDProjectSource", DbType.String), new SQLiteParameter("@NDProjectOutlay", DbType.String), new SQLiteParameter("@NDProjectTaskBySelf", DbType.String), new SQLiteParameter("@NDProjectUserOrder", DbType.String), new SQLiteParameter("@NDProjectOrder", DbType.Int32, 4) }; array[0].Value = model.NDProjectNo; array[1].Value = model.NDProjectSYear; array[2].Value = model.NDProjectEYear; array[3].Value = model.NDProjectName; array[4].Value = model.NDProjectType; array[5].Value = model.NDProjectSource; array[6].Value = model.NDProjectOutlay; array[7].Value = model.NDProjectTaskBySelf; array[8].Value = model.NDProjectUserOrder; array[9].Value = model.NDProjectOrder; string text = ""; base.ExecuteNonQuery(stringBuilder.ToString(), array, out text); return(true); }