// Book Action begin bool Book_insert_Click(Object Src, EventArgs E) { string sSQL = ""; bool bResult = Book_Validate(); // Book Check Event begin // Book Check Event end string p2_name = CCUtility.ToSQL(Utility.GetParam("Book_name"), FieldTypes.Text); string p2_author = CCUtility.ToSQL(Utility.GetParam("Book_author"), FieldTypes.Text); string p2_category_id = CCUtility.ToSQL(Utility.GetParam("Book_category_id"), FieldTypes.Number); string p2_price = CCUtility.ToSQL(Utility.GetParam("Book_price"), FieldTypes.Number); string p2_product_url = CCUtility.ToSQL(Utility.GetParam("Book_product_url"), FieldTypes.Text); string p2_image_url = CCUtility.ToSQL(Utility.GetParam("Book_image_url"), FieldTypes.Text); string p2_notes = CCUtility.ToSQL(Utility.GetParam("Book_notes"), FieldTypes.Text); string c1_is_recommended = CCUtility.getCheckBoxValue(Utility.GetParam("Book_is_recommended"), "1", "0", FieldTypes.Number); // Book Insert Event begin // Book Insert Event end if (bResult) { if (sSQL.Length == 0) { sSQL = "insert into items (" + "name," + "author," + "category_id," + "price," + "product_url," + "image_url," + "notes," + "is_recommended)" + " values (" + p2_name + "," + p2_author + "," + p2_category_id + "," + p2_price + "," + p2_product_url + "," + p2_image_url + "," + p2_notes + "," + c1_is_recommended + ")"; } Book_BeforeSQLExecute(sSQL, "Insert"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Book_ValidationSummary.Text += e.Message; Book_ValidationSummary.Visible = true; return(false); } // Book AfterInsert Event begin // Book AfterInsert Event end } return(bResult); }
bool Book_update_Click(Object Src, EventArgs E) { string sWhere = ""; string sSQL = ""; bool bResult = Book_Validate(); if (bResult) { if (p_Book_item_id.Value.Length > 0) { sWhere = sWhere + "item_id=" + CCUtility.ToSQL(p_Book_item_id.Value, FieldTypes.Number); } // Book Check Event begin // Book Check Event end if (bResult) { sSQL = "update items set " + "[name]=" + CCUtility.ToSQL(Utility.GetParam("Book_name"), FieldTypes.Text) + ",[author]=" + CCUtility.ToSQL(Utility.GetParam("Book_author"), FieldTypes.Text) + ",[category_id]=" + CCUtility.ToSQL(Utility.GetParam("Book_category_id"), FieldTypes.Number) + ",[price]=" + CCUtility.ToSQL(Utility.GetParam("Book_price"), FieldTypes.Number) + ",[product_url]=" + CCUtility.ToSQL(Utility.GetParam("Book_product_url"), FieldTypes.Text) + ",[image_url]=" + CCUtility.ToSQL(Utility.GetParam("Book_image_url"), FieldTypes.Text) + ",[notes]=" + CCUtility.ToSQL(Utility.GetParam("Book_notes"), FieldTypes.Text) + ",[is_recommended]=" + CCUtility.getCheckBoxValue(Utility.GetParam("Book_is_recommended"), "1", "0", FieldTypes.Number); sSQL = sSQL + " where " + sWhere; // Book Update Event begin // Book Update Event end Book_BeforeSQLExecute(sSQL, "Update"); OleDbCommand cmd = new OleDbCommand(sSQL, Utility.Connection); try { cmd.ExecuteNonQuery(); } catch (Exception e) { Book_ValidationSummary.Text += e.Message; Book_ValidationSummary.Visible = true; return(false); } } if (bResult) { // Book AfterUpdate Event begin // Book AfterUpdate Event end } } return(bResult); }