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