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);
}
