internal bool Update(RTreatises model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update RTreatises set ");
stringBuilder.Append("RTreatisesNo=@RTreatisesNo,");
stringBuilder.Append("RTreatisesType=@RTreatisesType,");
stringBuilder.Append("RTreatisesAuthor=@RTreatisesAuthor,");
stringBuilder.Append("RTreatisesName=@RTreatisesName,");
stringBuilder.Append("RTreatisesJournalTitle=@RTreatisesJournalTitle,");
stringBuilder.Append("RTreatisesRell=@RTreatisesRell,");
stringBuilder.Append("RTreatisesPage=@RTreatisesPage,");
stringBuilder.Append("RTreatisesCollection=@RTreatisesCollection,");
stringBuilder.Append("RTreatisesContent=@RTreatisesContent,");
stringBuilder.Append("RTreatisesPDF=@RTreatisesPDF,");
stringBuilder.Append("RTreatisesPDFOName=@RTreatisesPDFOName,");
stringBuilder.Append("RTreatisesOrder=@RTreatisesOrder");
stringBuilder.Append(" where RTreatisesNo=@RTreatisesNo");
SQLiteParameter[] array = new SQLiteParameter[]
{
new SQLiteParameter("@RTreatisesNo", DbType.String),
new SQLiteParameter("@RTreatisesType", DbType.String),
new SQLiteParameter("@RTreatisesAuthor", DbType.String),
new SQLiteParameter("@RTreatisesName", DbType.String),
new SQLiteParameter("@RTreatisesJournalTitle", DbType.String),
new SQLiteParameter("@RTreatisesRell", DbType.String),
new SQLiteParameter("@RTreatisesPage", DbType.String),
new SQLiteParameter("@RTreatisesCollection", DbType.String),
new SQLiteParameter("@RTreatisesContent", DbType.String),
new SQLiteParameter("@RTreatisesPDF", DbType.String),
new SQLiteParameter("@RTreatisesPDFOName", DbType.String),
new SQLiteParameter("@RTreatisesOrder", DbType.Int32, 4)
};
array[0].Value = model.RTreatisesNo;
array[1].Value = model.RTreatisesType;
array[2].Value = model.RTreatisesAuthor;
array[3].Value = model.RTreatisesName;
array[4].Value = model.RTreatisesJournalTitle;
array[5].Value = model.RTreatisesRell;
array[6].Value = model.RTreatisesPage;
array[7].Value = model.RTreatisesCollection;
array[8].Value = model.RTreatisesContent;
array[9].Value = model.RTreatisesPDF;
array[10].Value = model.RTreatisesPDFOName;
array[11].Value = model.RTreatisesOrder;
string text = "";
base.ExecuteNonQuery(stringBuilder.ToString(), array, out text);
return(true);
}
internal bool Add(RTreatises model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into RTreatises(");
stringBuilder.Append("RTreatisesNo,RTreatisesType,RTreatisesAuthor,RTreatisesName,RTreatisesJournalTitle,RTreatisesRell,RTreatisesPage,RTreatisesCollection,RTreatisesContent,RTreatisesPDF,RTreatisesPDFOName,RTreatisesOrder)");
stringBuilder.Append(" values (");
stringBuilder.Append("@RTreatisesNo,@RTreatisesType,@RTreatisesAuthor,@RTreatisesName,@RTreatisesJournalTitle,@RTreatisesRell,@RTreatisesPage,@RTreatisesCollection,@RTreatisesContent,@RTreatisesPDF,@RTreatisesPDFOName,@RTreatisesOrder)");
SQLiteParameter[] array = new SQLiteParameter[]
{
new SQLiteParameter("@RTreatisesNo", DbType.String),
new SQLiteParameter("@RTreatisesType", DbType.String),
new SQLiteParameter("@RTreatisesAuthor", DbType.String),
new SQLiteParameter("@RTreatisesName", DbType.String),
new SQLiteParameter("@RTreatisesJournalTitle", DbType.String),
new SQLiteParameter("@RTreatisesRell", DbType.String),
new SQLiteParameter("@RTreatisesPage", DbType.String),
new SQLiteParameter("@RTreatisesCollection", DbType.String),
new SQLiteParameter("@RTreatisesContent", DbType.String),
new SQLiteParameter("@RTreatisesPDF", DbType.String),
new SQLiteParameter("@RTreatisesPDFOName", DbType.String),
new SQLiteParameter("@RTreatisesOrder", DbType.Int32, 4)
};
array[0].Value = model.RTreatisesNo;
array[1].Value = model.RTreatisesType;
array[2].Value = model.RTreatisesAuthor;
array[3].Value = model.RTreatisesName;
array[4].Value = model.RTreatisesJournalTitle;
array[5].Value = model.RTreatisesRell;
array[6].Value = model.RTreatisesPage;
array[7].Value = model.RTreatisesCollection;
array[8].Value = model.RTreatisesContent;
array[9].Value = model.RTreatisesPDF;
array[10].Value = model.RTreatisesPDFOName;
array[11].Value = model.RTreatisesOrder;
string text = "";
base.ExecuteNonQuery(stringBuilder.ToString(), array, out text);
return(true);
}
private bool SaveProgress()
{
this.OnSaveCheckDenyEvent(EventArgs.Empty);
IList <RTreatises> list = new List <RTreatises>();
for (int i = 0; i < this.dRTreatises.RowCount - 1; i++)
{
DataGridViewRow dataGridViewRow = this.dRTreatises.Rows[i];
RTreatises rTreatises = new RTreatises();
rTreatises.RTreatisesNo = ((dataGridViewRow.Cells["paperid"].Value == null) ? "" : dataGridViewRow.Cells["paperid"].Value.ToString());
rTreatises.RTreatisesName = ((dataGridViewRow.Cells["papername"].Value == null || dataGridViewRow.Cells["papername"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["papername"].Value.ToString());
rTreatises.RTreatisesRell = ((dataGridViewRow.Cells["paperyear"].Value == null || dataGridViewRow.Cells["paperyear"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["paperyear"].Value.ToString());
string a;
if (dataGridViewRow.Cells["papertype"].Value != null && dataGridViewRow.Cells["papertype"].Value != DBNull.Value && (a = dataGridViewRow.Cells["papertype"].Value.ToString()) != null)
{
if (!(a == "论文"))
{
if (!(a == "著作"))
{
if (!(a == "研究技术报告"))
{
if (a == "重要学术会议邀请报告")
{
rTreatises.RTreatisesType = "4";
}
}
else
{
rTreatises.RTreatisesType = "3";
}
}
else
{
rTreatises.RTreatisesType = "2";
}
}
else
{
rTreatises.RTreatisesType = "1";
}
}
rTreatises.RTreatisesJournalTitle = ((dataGridViewRow.Cells["paperpublish"].Value == null || dataGridViewRow.Cells["paperpublish"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["paperpublish"].Value.ToString());
rTreatises.RTreatisesCollection = ((dataGridViewRow.Cells["paperref"].Value == null || dataGridViewRow.Cells["paperref"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["paperref"].Value.ToString());
rTreatises.RTreatisesAuthor = ((dataGridViewRow.Cells["paperorder"].Value == null || dataGridViewRow.Cells["paperorder"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["paperorder"].Value.ToString());
rTreatises.RTreatisesPDF = ((dataGridViewRow.Cells["hiddenRTreatisesPDFOName"].Value == null || dataGridViewRow.Cells["hiddenRTreatisesPDFOName"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["hiddenRTreatisesPDFOName"].Value.ToString());
rTreatises.RTreatisesPDFOName = ((dataGridViewRow.Cells["paperattachmentinfo"].Value == null || dataGridViewRow.Cells["paperattachmentinfo"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["paperattachmentinfo"].Value.ToString());
rTreatises.UpLoadFullPath = ((dataGridViewRow.Cells["uploadfullpath"].Value == null || dataGridViewRow.Cells["uploadfullpath"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["uploadfullpath"].Value.ToString());
rTreatises.RTreatisesOrder = this.dRTreatises.RowCount - i;
if (rTreatises.RTreatisesName == "" || rTreatises.RTreatisesType == "" || rTreatises.RTreatisesRell == "" || rTreatises.RTreatisesJournalTitle == "" || rTreatises.RTreatisesPDFOName == "")
{
MessageBox.Show("所有字段均为必填字段，代表性著作需要上传对应的PDF支撑文件", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(false);
}
int num;
if (!int.TryParse(rTreatises.RTreatisesAuthor, out num))
{
MessageBox.Show("录入的排名有非整数数据", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(false);
}
list.Add(rTreatises);
}
if (list.Count > 10)
{
MessageBox.Show("录入的代表性著作记录条数超过10条", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(false);
}
this.OnSaveCheckPassedEvent(EventArgs.Empty);
this._rTreatisesService.UpdateRTreatisess(list);
list = this._rTreatisesService.GetRTreatises();
this.LoadData(list);
return(true);
}
