internal bool Update(NDPatent model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("update NDPatent set ");
stringBuilder.Append("NDPatentNo=@NDPatentNo,");
stringBuilder.Append("NDPatentApplicants=@NDPatentApplicants,");
stringBuilder.Append("NDPatentName=@NDPatentName,");
stringBuilder.Append("NDPatentType=@NDPatentType,");
stringBuilder.Append("NDPatentApprovalYear=@NDPatentApprovalYear,");
stringBuilder.Append("NDPatentNumber=@NDPatentNumber,");
stringBuilder.Append("NDPatentContent=@NDPatentContent,");
stringBuilder.Append("NDPatentPDF=@NDPatentPDF,");
stringBuilder.Append("NDPatentPDFOName=@NDPatentPDFOName,");
stringBuilder.Append("NDPatentOrder=@NDPatentOrder");
stringBuilder.Append(" where NDPatentNo=@NDPatentNo");
SQLiteParameter[] array = new SQLiteParameter[]
{
new SQLiteParameter("@NDPatentNo", DbType.String),
new SQLiteParameter("@NDPatentApplicants", DbType.String),
new SQLiteParameter("@NDPatentName", DbType.String),
new SQLiteParameter("@NDPatentType", DbType.String),
new SQLiteParameter("@NDPatentApprovalYear", DbType.String),
new SQLiteParameter("@NDPatentNumber", DbType.String),
new SQLiteParameter("@NDPatentContent", DbType.String),
new SQLiteParameter("@NDPatentPDF", DbType.String),
new SQLiteParameter("@NDPatentPDFOName", DbType.String),
new SQLiteParameter("@NDPatentOrder", DbType.Int32, 4)
};
array[0].Value = model.NDPatentNo;
array[1].Value = model.NDPatentApplicants;
array[2].Value = model.NDPatentName;
array[3].Value = model.NDPatentType;
array[4].Value = model.NDPatentApprovalYear;
array[5].Value = model.NDPatentNumber;
array[6].Value = model.NDPatentContent;
array[7].Value = model.NDPatentPDF;
array[8].Value = model.NDPatentPDFOName;
array[9].Value = model.NDPatentOrder;
string text = "";
base.ExecuteNonQuery(stringBuilder.ToString(), array, out text);
return(true);
}
private bool SaveProgress()
{
this.OnSaveCheckDenyEvent(EventArgs.Empty);
IList <NDPatent> list = new List <NDPatent>();
for (int i = 0; i < this.dnp.RowCount - 1; i++)
{
DataGridViewRow dataGridViewRow = this.dnp.Rows[i];
NDPatent nDPatent = new NDPatent();
nDPatent.NDPatentNo = ((dataGridViewRow.Cells["patentid"].Value == null) ? "" : dataGridViewRow.Cells["patentid"].Value.ToString());
nDPatent.NDPatentName = ((dataGridViewRow.Cells["patentname"].Value == null || dataGridViewRow.Cells["patentname"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["patentname"].Value.ToString());
nDPatent.NDPatentType = ((dataGridViewRow.Cells["patenttype"].Value == null || dataGridViewRow.Cells["patenttype"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["patenttype"].Value.ToString());
nDPatent.NDPatentNumber = ((dataGridViewRow.Cells["patentno"].Value == null || dataGridViewRow.Cells["patentno"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["patentno"].Value.ToString());
nDPatent.NDPatentApprovalYear = ((dataGridViewRow.Cells["patentauthorizedate"].Value == null || dataGridViewRow.Cells["patentauthorizedate"].Value == DBNull.Value || dataGridViewRow.Cells["patentauthorizedate"].Value.ToString() == "") ? "" : ((DateTime)dataGridViewRow.Cells["patentauthorizedate"].Value).ToString("yyyy-MM-dd"));
nDPatent.NDPatentApplicants = ((dataGridViewRow.Cells["userpatentorder"].Value == null || dataGridViewRow.Cells["userpatentorder"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["userpatentorder"].Value.ToString());
nDPatent.NDPatentPDFOName = ((dataGridViewRow.Cells["patentattinfo"].Value == null || dataGridViewRow.Cells["patentattinfo"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["patentattinfo"].Value.ToString());
nDPatent.NDPatentPDF = ((dataGridViewRow.Cells["hiddenStorenName"].Value == null || dataGridViewRow.Cells["hiddenStorenName"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["hiddenStorenName"].Value.ToString());
nDPatent.UpLoadFullPath = ((dataGridViewRow.Cells["UpLoadPath"].Value == null || dataGridViewRow.Cells["UpLoadPath"].Value == DBNull.Value) ? "" : dataGridViewRow.Cells["UpLoadPath"].Value.ToString());
nDPatent.NDPatentOrder = this.dnp.RowCount - i;
if (nDPatent.NDPatentName == "" || nDPatent.NDPatentNumber == "" || nDPatent.NDPatentApprovalYear == "" || nDPatent.NDPatentApplicants == "" || nDPatent.NDPatentPDFOName == "")
{
MessageBox.Show("所有字段均为必填字段，发明专利、国防专利需要上传对应的PDF支撑文件", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(false);
}
int num;
if (!int.TryParse(nDPatent.NDPatentApplicants, out num))
{
MessageBox.Show("录入的排名有非整数数据", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(false);
}
DateTime.Parse(nDPatent.NDPatentApprovalYear);
list.Add(nDPatent);
}
if (list.Count > 10)
{
MessageBox.Show("录入的发明专利、国防专利情况记录条数超过10条", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return(false);
}
this.OnSaveCheckPassedEvent(EventArgs.Empty);
this._nDPatentService.UpdateNDPatents(list);
list = this._nDPatentService.GetNDPatent();
this.LoadData(list);
return(true);
}
internal bool Add(NDPatent model)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("insert into NDPatent(");
stringBuilder.Append("NDPatentNo,NDPatentApplicants,NDPatentName,NDPatentType,NDPatentApprovalYear,NDPatentNumber,NDPatentContent,NDPatentPDF,NDPatentPDFOName,NDPatentOrder)");
stringBuilder.Append(" values (");
stringBuilder.Append("@NDPatentNo,@NDPatentApplicants,@NDPatentName,@NDPatentType,@NDPatentApprovalYear,@NDPatentNumber,@NDPatentContent,@NDPatentPDF,@NDPatentPDFOName,@NDPatentOrder)");
SQLiteParameter[] array = new SQLiteParameter[]
{
new SQLiteParameter("@NDPatentNo", DbType.String),
new SQLiteParameter("@NDPatentApplicants", DbType.String),
new SQLiteParameter("@NDPatentName", DbType.String),
new SQLiteParameter("@NDPatentType", DbType.String),
new SQLiteParameter("@NDPatentApprovalYear", DbType.String),
new SQLiteParameter("@NDPatentNumber", DbType.String),
new SQLiteParameter("@NDPatentContent", DbType.String),
new SQLiteParameter("@NDPatentPDF", DbType.String),
new SQLiteParameter("@NDPatentPDFOName", DbType.String),
new SQLiteParameter("@NDPatentOrder", DbType.Int32, 4)
};
array[0].Value = model.NDPatentNo;
array[1].Value = model.NDPatentApplicants;
array[2].Value = model.NDPatentName;
array[3].Value = model.NDPatentType;
array[4].Value = model.NDPatentApprovalYear;
array[5].Value = model.NDPatentNumber;
array[6].Value = model.NDPatentContent;
array[7].Value = model.NDPatentPDF;
array[8].Value = model.NDPatentPDFOName;
array[9].Value = model.NDPatentOrder;
string text = "";
base.ExecuteNonQuery(stringBuilder.ToString(), array, out text);
return(true);
}
