/// <summary>
/// 数据库新增报价单记录
/// </summary>
/// <param name="offer_sheet">报价单对象</param>
/// <returns>是否添加成功</returns>
private bool addOfferSheet(OfferSheet offer_sheet)
{
string sql = "insert into OSM_OFFER_SHEET(OFFERSHEET_CODE,GMF_ID,BJF_ID,OFFERSHEET_TYPE,OFFERSHEET_DATE,OFFERSHEET_STATE,OFFERSHEET_REGION) ";
sql += "values('" + offer_sheet.getOFFERSHEET_CODE() + "'," + offer_sheet.getGMF_ID() + "," + offer_sheet.getBJF_ID();
sql += ",'" + offer_sheet.getOFFERSHEET_TYPE() + "','" + offer_sheet.getOFFERSHEET_DATE() + "','";
sql += offer_sheet.getOFFERSHEET_STATE() + "','" + offer_sheet.getOFFERSHEET_REGION() + "')";
AccessDB adb = new AccessDB();
bool isExecuteSucc = adb.SQLExecute(sql);
if (isExecuteSucc)
{
MessageBox.Show("添加成功！", "消息");
}
else
{
MessageBox.Show("添加失败！", "消息");
}
return(isExecuteSucc);
}
/// <summary>
/// 数据库更新报价单记录
/// </summary>
/// <param name="offer_sheet"></param>
/// <returns>是否更新成功</returns>
private bool updateOfferSheet(OfferSheet offer_sheet)
{
string sql = "update OSM_OFFER_SHEET set OFFERSHEET_CODE = '" + offer_sheet.getOFFERSHEET_CODE() + "',";
sql += "GMF_ID=" + offer_sheet.getGMF_ID().ToString() + ",BJF_ID=" + offer_sheet.getBJF_ID() + ",";
sql += "OFFERSHEET_TYPE='" + offer_sheet.getOFFERSHEET_TYPE() + "',OFFERSHEET_DATE = #" + offer_sheet.getOFFERSHEET_DATE() + "#,";
sql += "OFFERSHEET_STATE='" + offer_sheet.getOFFERSHEET_STATE() + "',";
sql += "OFFERSHEET_REGION = '" + offer_sheet.getOFFERSHEET_REGION() + "' ";
sql += "where ID = " + offer_sheet.getID().ToString();
AccessDB adb = new AccessDB();
bool isExecuteSucc = adb.SQLExecute(sql);
if (isExecuteSucc)
{
MessageBox.Show("更新成功！", "消息");
}
else
{
MessageBox.Show("更新失败！", "消息");
}
return(isExecuteSucc);
}