internal bool Update(AcademicPost model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update AcademicPost set ");
stringBuilder.Append("AcademicPostNo=@AcademicPostNo,");
stringBuilder.Append("AcademicPostSDate=@AcademicPostSDate,");
stringBuilder.Append("AcademicPostEDate=@AcademicPostEDate,");
stringBuilder.Append("AcademicPostOrg=@AcademicPostOrg,");
stringBuilder.Append("AcademicPostContent=@AcademicPostContent,");
stringBuilder.Append("AcademicPostOrder=@AcademicPostOrder");
stringBuilder.Append(" where AcademicPostNo=@AcademicPostNo");
SQLiteParameter[] array = new SQLiteParameter[]
{
new SQLiteParameter("@AcademicPostNo", DbType.String),
new SQLiteParameter("@AcademicPostSDate", DbType.String),
new SQLiteParameter("@AcademicPostEDate", DbType.String),
new SQLiteParameter("@AcademicPostOrg", DbType.String),
new SQLiteParameter("@AcademicPostContent", DbType.String),
new SQLiteParameter("@AcademicPostOrder", DbType.Int32, 4)
};
array[0].Value = model.AcademicPostNo;
array[1].Value = model.AcademicPostSDate;
array[2].Value = model.AcademicPostEDate;
array[3].Value = model.AcademicPostOrg;
array[4].Value = model.AcademicPostContent;
array[5].Value = model.AcademicPostOrder;
string text = "";
base.ExecuteNonQuery(stringBuilder.ToString(), array, out text);
return(true);
}
private bool SaveProgress()
{
this.OnSaveCheckDenyEvent(EventArgs.Empty);
IList <AcademicPost> list = new List <AcademicPost>();
for (int i = 0; i < this.daca.RowCount - 1; i++)
{
DataGridViewRow dataGridViewRow = this.daca.Rows[i];
AcademicPost academicPost = new AcademicPost();
academicPost.AcademicPostNo = ((dataGridViewRow.Cells["academicjobid"].Value == null) ? "" : dataGridViewRow.Cells["academicjobid"].Value.ToString());
academicPost.AcademicPostSDate = ((dataGridViewRow.Cells["academicjobstartdate"].Value == null || dataGridViewRow.Cells["academicjobstartdate"].Value == DBNull.Value || dataGridViewRow.Cells["academicjobstartdate"].Value.ToString() == "") ? "" : ((DateTime)dataGridViewRow.Cells["academicjobstartdate"].Value).ToString("yyyy-MM-dd"));
academicPost.AcademicPostEDate = ((dataGridViewRow.Cells["academicjobenddate"].Value == null || dataGridViewRow.Cells["academicjobenddate"].Value == DBNull.Value || dataGridViewRow.Cells["academicjobenddate"].Value.ToString() == "") ? "" : ((DateTime)dataGridViewRow.Cells["academicjobenddate"].Value).ToString("yyyy-MM-dd"));
academicPost.AcademicPostOrg = ((dataGridViewRow.Cells["academicjoborg"].Value == null || dataGridViewRow.Cells["academicjoborg"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["academicjoborg"].Value.ToString());
academicPost.AcademicPostContent = ((dataGridViewRow.Cells["academicjobposition"].Value == null || dataGridViewRow.Cells["academicjobposition"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["academicjobposition"].Value.ToString());
academicPost.AcademicPostOrder = this.daca.RowCount - i;
if (academicPost.AcademicPostSDate == "" || academicPost.AcademicPostOrg == "" || academicPost.AcademicPostContent == "")
{
MessageBox.Show("开始年月、组织/机构、任职情况为必填字段，检测到部分字段未填写完整", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(false);
}
list.Add(academicPost);
}
this.OnSaveCheckPassedEvent(EventArgs.Empty);
this._academicPostService.UpdateAcademicPosts(list);
list = this._academicPostService.GetAcademicPostList();
this.LoadData(list);
return(true);
}
internal bool Add(AcademicPost model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into AcademicPost(");
stringBuilder.Append("AcademicPostNo,AcademicPostSDate,AcademicPostEDate,AcademicPostOrg,AcademicPostContent,AcademicPostOrder)");
stringBuilder.Append(" values (");
stringBuilder.Append("@AcademicPostNo,@AcademicPostSDate,@AcademicPostEDate,@AcademicPostOrg,@AcademicPostContent,@AcademicPostOrder)");
SQLiteParameter[] array = new SQLiteParameter[]
{
new SQLiteParameter("@AcademicPostNo", DbType.String),
new SQLiteParameter("@AcademicPostSDate", DbType.String),
new SQLiteParameter("@AcademicPostEDate", DbType.String),
new SQLiteParameter("@AcademicPostOrg", DbType.String),
new SQLiteParameter("@AcademicPostContent", DbType.String),
new SQLiteParameter("@AcademicPostOrder", DbType.Int32, 4)
};
array[0].Value = model.AcademicPostNo;
array[1].Value = model.AcademicPostSDate;
array[2].Value = model.AcademicPostEDate;
array[3].Value = model.AcademicPostOrg;
array[4].Value = model.AcademicPostContent;
array[5].Value = model.AcademicPostOrder;
string text = "";
base.ExecuteNonQuery(stringBuilder.ToString(), array, out text);
return(true);
}
