public bool Add(WorkExperienceInfo model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("insert into WorkExperience("); stringBuilder.Append("WorkExperienceNo,WorkExperienceSDate,WorkExperienceEDate,WorkExperienceOrg,WorkExperienceContent,WorkExperienceOrder)"); stringBuilder.Append(" values ("); stringBuilder.Append("@WorkExperienceNo,@WorkExperienceSDate,@WorkExperienceEDate,@WorkExperienceOrg,@WorkExperienceContent,@WorkExperienceOrder)"); SQLiteParameter[] array = new SQLiteParameter[] { new SQLiteParameter("@WorkExperienceNo", DbType.String), new SQLiteParameter("@WorkExperienceSDate", DbType.String), new SQLiteParameter("@WorkExperienceEDate", DbType.String), new SQLiteParameter("@WorkExperienceOrg", DbType.String), new SQLiteParameter("@WorkExperienceContent", DbType.String), new SQLiteParameter("@WorkExperienceOrder", DbType.Int32, 4) }; array[0].Value = model.WorkExperienceNo; array[1].Value = model.WorkExperienceSDate; array[2].Value = model.WorkExperienceEDate; array[3].Value = model.WorkExperienceOrg; array[4].Value = model.WorkExperienceContent; array[5].Value = model.WorkExperienceOrder; string text = ""; base.ExecuteNonQuery(stringBuilder.ToString(), array, out text); return(true); }
public bool Update(WorkExperienceInfo model) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update WorkExperience set "); stringBuilder.Append("WorkExperienceNo=@WorkExperienceNo,"); stringBuilder.Append("WorkExperienceSDate=@WorkExperienceSDate,"); stringBuilder.Append("WorkExperienceEDate=@WorkExperienceEDate,"); stringBuilder.Append("WorkExperienceOrg=@WorkExperienceOrg,"); stringBuilder.Append("WorkExperienceContent=@WorkExperienceContent,"); stringBuilder.Append("WorkExperienceOrder=@WorkExperienceOrder"); stringBuilder.Append(" where WorkExperienceNo=@WorkExperienceNo"); SQLiteParameter[] array = new SQLiteParameter[] { new SQLiteParameter("@WorkExperienceNo", DbType.String), new SQLiteParameter("@WorkExperienceSDate", DbType.String), new SQLiteParameter("@WorkExperienceEDate", DbType.String), new SQLiteParameter("@WorkExperienceOrg", DbType.String), new SQLiteParameter("@WorkExperienceContent", DbType.String), new SQLiteParameter("@WorkExperienceOrder", DbType.Int32, 4) }; array[0].Value = model.WorkExperienceNo; array[1].Value = model.WorkExperienceSDate; array[2].Value = model.WorkExperienceEDate; array[3].Value = model.WorkExperienceOrg; array[4].Value = model.WorkExperienceContent; array[5].Value = model.WorkExperienceOrder; string text = ""; base.ExecuteNonQuery(stringBuilder.ToString(), array, out text); return(true); }
private bool SaveProgress() { this.OnSaveCheckDenyEvent(EventArgs.Empty); IList <WorkExperienceInfo> list = new List <WorkExperienceInfo>(); for (int i = 0; i < this.dwork.RowCount - 1; i++) { DataGridViewRow dataGridViewRow = this.dwork.Rows[i]; WorkExperienceInfo workExperienceInfo = new WorkExperienceInfo(); workExperienceInfo.WorkExperienceNo = ((dataGridViewRow.Cells["workid"].Value == null) ? "" : dataGridViewRow.Cells["workid"].Value.ToString()); workExperienceInfo.WorkExperienceSDate = ((dataGridViewRow.Cells["workstartdate"].Value == null || dataGridViewRow.Cells["workstartdate"].Value == DBNull.Value || dataGridViewRow.Cells["workstartdate"].Value.ToString() == "") ? "" : ((DateTime)dataGridViewRow.Cells["workstartdate"].Value).ToString("yyyy-MM-dd")); workExperienceInfo.WorkExperienceEDate = ((dataGridViewRow.Cells["workenddate"].Value == null || dataGridViewRow.Cells["workenddate"].Value == DBNull.Value || dataGridViewRow.Cells["workenddate"].Value.ToString() == "") ? "" : ((DateTime)dataGridViewRow.Cells["workenddate"].Value).ToString("yyyy-MM-dd")); workExperienceInfo.WorkExperienceOrg = ((dataGridViewRow.Cells["workcompany"].Value == null || dataGridViewRow.Cells["workcompany"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["workcompany"].Value.ToString()); workExperienceInfo.WorkExperienceContent = ((dataGridViewRow.Cells["workduty"].Value == null || dataGridViewRow.Cells["workduty"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["workduty"].Value.ToString()); workExperienceInfo.WorkExperienceOrder = this.dwork.RowCount - i; if (workExperienceInfo.WorkExperienceSDate == "" || workExperienceInfo.WorkExperienceOrg == "" || workExperienceInfo.WorkExperienceContent == "") { MessageBox.Show("开始年月、工作单位、职务/职称为必填字段,检测到部分字段未填写完整", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return(false); } list.Add(workExperienceInfo); } this.OnSaveCheckPassedEvent(EventArgs.Empty); this._workExperienceService.UpdateWorkExperiences(list); list = this._workExperienceService.GetWorkExperience(); this.LoadData(list); return(true); }