/// <summary>
/// Returns an SQL statement to update this object in the DB
/// </summary>
/// <returns></returns>
protected override string GetUpdateSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("update `order` set");
sb.Append(" o_internal_id = '" + Preparer.Escape(this.InternalId) + "'");
sb.Append(" ,o_internal_ats_id = '" + Preparer.Escape(this.InternalATSId) + "'");
sb.Append(" ,o_customer_id = '" + Preparer.Escape(this.CustomerId) + "'");
sb.Append(" ,o_pin = '" + Preparer.Escape(this.Pin) + "'");
sb.Append(" ,o_additional_pins = '" + Preparer.Escape(this.AdditionalPins) + "'");
sb.Append(" ,o_property_address = '" + Preparer.Escape(this.PropertyAddress) + "'");
sb.Append(" ,o_property_address_2 = '" + Preparer.Escape(this.PropertyAddress2) + "'");
sb.Append(" ,o_property_city = '" + Preparer.Escape(this.PropertyCity) + "'");
sb.Append(" ,o_property_state = '" + Preparer.Escape(this.PropertyState) + "'");
sb.Append(" ,o_property_zip = '" + Preparer.Escape(this.PropertyZip) + "'");
sb.Append(" ,o_property_county = '" + Preparer.Escape(this.PropertyCounty) + "'");
sb.Append(" ,o_property_use = '" + Preparer.Escape(this.PropertyUse) + "'");
sb.Append(" ,o_internal_status_code = '" + Preparer.Escape(this.InternalStatusCode) + "'");
sb.Append(" ,o_customer_status_code = '" + Preparer.Escape(this.CustomerStatusCode) + "'");
sb.Append(" ,o_originator_id = '" + Preparer.Escape(this.OriginatorId) + "'");
sb.Append(" ,o_created = '" + Preparer.Escape(this.Created) + "'");
sb.Append(" ,o_modified = '" + Preparer.Escape(this.Modified) + "'");
sb.Append(" ,o_closing_date = '" + Preparer.Escape(this.ClosingDate) + "'");
sb.Append(" ,o_client_name = '" + Preparer.Escape(this.ClientName) + "'");
sb.Append(" ,o_oul_id = '" + Preparer.Escape(this.OrderUploadLogId) + "'");
sb.Append(" where o_id = '" + Preparer.Escape(this.Id) + "'");
return(sb.ToString());
}
protected override string GetWhereSql()
{
StringBuilder sb = new StringBuilder();
string delim = " where ";
if (null != Code)
{
sb.Append(delim + "ap.ap_code = '" + Preparer.Escape(Code) + "'");
delim = " and ";
}
if (null != Description)
{
sb.Append(delim + "ap.ap_description = '" + Preparer.Escape(Description) + "'");
delim = " and ";
}
if (-1 != SendNotification)
{
sb.Append(delim + "ap.ap_send_notification = '" + Preparer.Escape(SendNotification) + "'");
delim = " and ";
}
if (null != ChangeStatusTo)
{
sb.Append(delim + "ap.ap_change_status_to = '" + Preparer.Escape(ChangeStatusTo) + "'");
delim = " and ";
}
return(sb.ToString());
}
protected override string GetWhereSql()
{
StringBuilder sb = new StringBuilder();
string delim = " where ";
if (null != Code)
{
sb.Append(delim + "ss.ss_code = '" + Preparer.Escape(Code) + "'");
delim = " and ";
}
if (null != Description)
{
sb.Append(delim + "ss.ss_description = '" + Preparer.Escape(Description) + "'");
delim = " and ";
}
if (null != Data)
{
sb.Append(delim + "ss.ss_data = '" + Preparer.Escape(Data) + "'");
delim = " and ";
}
return(sb.ToString());
}
/// <summary>
/// Returns an SQL statement to insert this object into the DB
/// </summary>
/// <returns></returns>
protected override string GetInsertSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into `request` (");
sb.Append(" r_request_type_code");
sb.Append(" ,r_order_id");
sb.Append(" ,r_originator_id");
sb.Append(" ,r_created");
sb.Append(" ,r_status_code");
sb.Append(" ,r_xml");
sb.Append(" ,r_is_current");
sb.Append(" ,r_note");
sb.Append(" ) values (");
sb.Append(" '" + Preparer.Escape(this.RequestTypeCode) + "'");
sb.Append(" ,'" + Preparer.Escape(this.OrderId) + "'");
sb.Append(" ,'" + Preparer.Escape(this.OriginatorId) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Created) + "'");
sb.Append(" ,'" + Preparer.Escape(this.StatusCode) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Xml) + "'");
sb.Append(" ,'" + Preparer.Escape(this.IsCurrent) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Note) + "'");
sb.Append(" )");
return(sb.ToString());
}
/// <summary>
/// Persists updates to the DB. Note that the password field is not updated.
/// SetPassword() must be called to set the password
/// </summary>
/// <returns></returns>
protected override string GetUpdateSql()
{
StringBuilder sb = new StringBuilder();
// note password and created are not updated here
sb.Append("update `account` set");
sb.Append(" a_username = '******'");
//sb.Append(" ,a_password = '******'");
sb.Append(" ,a_first_name = '" + Preparer.Escape(this.FirstName) + "'");
sb.Append(" ,a_last_name = '" + Preparer.Escape(this.LastName) + "'");
sb.Append(" ,a_status_code = '" + Preparer.Escape(this.StatusCode) + "'");
//sb.Append(" ,a_created = '" + Preparer.Escape(this.Created) + "'");
sb.Append(" ,a_modified = sysdate()");
sb.Append(" ,a_password_hint = '" + Preparer.Escape(this.PasswordHint) + "'");
sb.Append(" ,a_preferences_xml = '" + Preparer.Escape(this.PreferencesXml) + "'");
sb.Append(" ,a_role_code = '" + Preparer.Escape(this.RoleCode) + "'");
sb.Append(" ,a_company_id = '" + Preparer.Escape(this.CompanyId) + "'");
sb.Append(" ,a_internal_id = '" + Preparer.Escape(this.InternalId) + "'");
sb.Append(" ,a_email = '" + Preparer.Escape(this.Email) + "'");
sb.Append(" ,a_underwriter_codes = '" + Preparer.Escape(this.UnderwriterCodes) + "'");
sb.Append(" ,a_underwriter_endorsements = '" + Preparer.Escape(this.UnderwriterEndorsements) + "'");
sb.Append(" ,a_business_license_id = '" + Preparer.Escape(this.BusinessLicenseID) + "'");
sb.Append(" ,a_individual_license_id = '" + Preparer.Escape(this.IndividualLicenseID) + "'");
sb.Append(" ,a_signature = '" + Preparer.Escape(this.Signature) + "'");
sb.Append(" where a_id = '" + Preparer.Escape(this.Id) + "'");
return(sb.ToString());
}
protected override string GetWhereSql()
{
StringBuilder sb = new StringBuilder();
string delim = " where ";
if (AccountID > 0)
{
sb.Append(delim + "h.a_id = '" + Preparer.Escape(AccountID) + "'");
delim = " and ";
}
if (!SubmissionXML.Equals(""))
{
sb.Append(delim + "h.h_submission_xml = '" + Preparer.Escape(SubmissionXML) + "'");
delim = " and ";
}
if ("1-1-1 0:0:0" != Preparer.Escape(Created))
{
sb.Append(delim + "h.h_created = '" + Preparer.Escape(Created) + "'");
delim = " and ";
}
if ("1-1-1 0:0:0" != Preparer.Escape(Modified))
{
sb.Append(delim + "h.h_modified = '" + Preparer.Escape(Modified) + "'");
delim = " and ";
}
return(sb.ToString());
}
protected override string GetWhereSql()
{
StringBuilder sb = new StringBuilder();
string delim = " where ";
if (null != Code)
{
sb.Append(delim + "rs.rs_code = '" + Preparer.Escape(Code) + "'");
delim = " and ";
}
if (null != Description)
{
sb.Append(delim + "rs.rs_description = '" + Preparer.Escape(Description) + "'");
delim = " and ";
}
if (-1 != PermissionBit)
{
sb.Append(delim + "rs.rs_permission_bit = '" + Preparer.Escape(PermissionBit) + "'");
delim = " and ";
}
return(sb.ToString());
}
protected override string GetWhereSql()
{
StringBuilder sb = new StringBuilder();
string delim = " where ";
if (null != Codes)
{
// we accept a comma-separated list like so: code1,code2,code3
// so we'll convert this to sql " in ('code1','code2','code3')"
string[] carr = Codes.Split(",".ToCharArray());
string ccode = "''";
foreach (string c in carr)
{
ccode += ",'" + Preparer.Escape(c.Trim()) + "'";
}
sb.Append(delim + "u.u_code in (" + ccode + ")");
delim = " and ";
}
if (null != Code)
{
sb.Append(delim + "u.u_code = '" + Preparer.Escape(Code) + "'");
delim = " and ";
}
if (null != Description)
{
sb.Append(delim + "u.u_description = '" + Preparer.Escape(Description) + "'");
delim = " and ";
}
return(sb.ToString());
}
protected override string GetWhereSql()
{
StringBuilder sb = new StringBuilder();
string delim = " where ";
if (-1 != AccountId)
{
sb.Append(delim + "oa.oa_account_id = '" + Preparer.Escape(AccountId) + "'");
delim = " and ";
}
if (-1 != OrderId)
{
sb.Append(delim + "oa.oa_order_id = '" + Preparer.Escape(OrderId) + "'");
delim = " and ";
}
if (null != PermissionBit)
{
sb.Append(delim + "oa.oa_permission_bit = '" + Preparer.Escape(PermissionBit) + "'");
delim = " and ";
}
return(sb.ToString());
}
protected override string GetWhereSql()
{
StringBuilder sb = new StringBuilder();
string delim = " where ";
if (null != Code)
{
sb.Append(delim + "rt.rt_code = '" + Preparer.Escape(Code) + "'");
delim = " and ";
}
if (null != Description)
{
sb.Append(delim + "rt.rt_description = '" + Preparer.Escape(Description) + "'");
delim = " and ";
}
if (null != Definition)
{
sb.Append(delim + "rt.rt_definition = '" + Preparer.Escape(Definition) + "'");
delim = " and ";
}
if (-1 != IsActive)
{
sb.Append(delim + "rt.rt_is_active = '" + Preparer.Escape(IsActive) + "'");
delim = " and ";
}
return(sb.ToString());
}
protected override string GetWhereSql()
{
StringBuilder sb = new StringBuilder();
string delim = " where ";
if (-1 != Id)
{
sb.Append(delim + "c.c_id = '" + Preparer.Escape(Id) + "'");
delim = " and ";
}
if (null != Name)
{
sb.Append(delim + "c.c_name = '" + Preparer.Escape(Name) + "'");
delim = " and ";
}
if (null != NameBeginsWith)
{
sb.Append(delim + "c.c_name like '" + Preparer.Escape(NameBeginsWith) + "%'");
delim = " and ";
}
if ("1-1-1 0:0:0" != Preparer.Escape(Created))
{
sb.Append(delim + "c.c_created = '" + Preparer.Escape(Created) + "'");
delim = " and ";
}
return(sb.ToString());
}
/// <summary>
/// Returns an SQL statement to insert this object into the DB
/// </summary>
/// <returns></returns>
protected override string GetInsertSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into `schedule` (");
sb.Append(" a_id");
sb.Append(" ,o_id");
sb.Append(" ,r_id");
sb.Append(" ,att_id");
sb.Append(" ,ua_id");
sb.Append(" ,s_search_package_date");
sb.Append(" ,s_modified");
sb.Append(" ,s_created");
sb.Append(" ) values (");
sb.Append(" '" + Preparer.Escape(this.AccountID) + "'");
sb.Append(" ,'" + Preparer.Escape(this.OrderID) + "'");
sb.Append(" ,'" + Preparer.Escape(this.RequestID) + "'");
sb.Append(" ,'" + Preparer.Escape(this.AttachmentID) + "'");
sb.Append(" ,'" + Preparer.Escape(this.UploadAccountID) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Search_package_date) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Modified) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Created) + "'");
sb.Append(" )");
return(sb.ToString());
}
/// <summary>
/// Returns an SQL statement to update this object in the DB
/// </summary>
/// <returns></returns>
protected override string GetUpdateSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("update `order_assignment` set");
sb.Append(" oa_permission_bit = '" + Preparer.Escape(this.PermissionBit) + "'");
sb.Append(" where oa_account_id = '" + Preparer.Escape(this.AccountId) + "'");
return(sb.ToString());
}
/// <summary>
/// Returns an SQL statement to update this object in the DB
/// </summary>
/// <returns></returns>
protected override string GetUpdateSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("update `attachment_roles` set");
sb.Append(" r_code= '" + Preparer.Escape(this.RoleCode) + "'");
sb.Append(" where ap_code = '" + Preparer.Escape(this.AttachmentPurposeCode) + "'");
return(sb.ToString());
}
/// <summary>
/// Returns an SQL statement to update this object in the DB
/// </summary>
/// <returns></returns>
protected override string GetUpdateSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("update `location` set");
sb.Append(" l_description = '" + Preparer.Escape(this.Description) + "'");
sb.Append(" where l_code = '" + Preparer.Escape(this.Code) + "'");
return(sb.ToString());
}
/// <summary>
/// Returns an SQL statement to insert this object into the DB
/// </summary>
/// <returns></returns>
protected override string GetInsertSql()
{
string state = this.PropertyState.Trim();
if (state.Length > 2)
{
state = state.Substring(0, 2);
}
StringBuilder sb = new StringBuilder();
sb.Append("insert into `order` (");
sb.Append(" o_internal_id");
sb.Append(" ,o_internal_ats_id");
sb.Append(" ,o_customer_id");
sb.Append(" ,o_pin");
sb.Append(" ,o_additional_pins");
sb.Append(" ,o_property_address");
sb.Append(" ,o_property_address_2");
sb.Append(" ,o_property_city");
sb.Append(" ,o_property_state");
sb.Append(" ,o_property_zip");
sb.Append(" ,o_property_county");
sb.Append(" ,o_property_use");
sb.Append(" ,o_internal_status_code");
sb.Append(" ,o_customer_status_code");
sb.Append(" ,o_originator_id");
sb.Append(" ,o_created");
sb.Append(" ,o_modified");
sb.Append(" ,o_closing_date");
sb.Append(" ,o_client_name");
sb.Append(" ,o_oul_id");
sb.Append(" ) values (");
sb.Append(" '" + Preparer.Escape(this.InternalId) + "'");
sb.Append(" ,'" + Preparer.Escape(this.InternalATSId) + "'");
sb.Append(" ,'" + Preparer.Escape(this.CustomerId) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Pin) + "'");
sb.Append(" ,'" + Preparer.Escape(this.AdditionalPins) + "'");
sb.Append(" ,'" + Preparer.Escape(this.PropertyAddress) + "'");
sb.Append(" ,'" + Preparer.Escape(this.PropertyAddress2) + "'");
sb.Append(" ,'" + Preparer.Escape(this.PropertyCity) + "'");
sb.Append(" ,'" + Preparer.Escape(state) + "'");
sb.Append(" ,'" + Preparer.Escape(this.PropertyZip) + "'");
sb.Append(" ,'" + Preparer.Escape(this.PropertyCounty) + "'");
sb.Append(" ,'" + Preparer.Escape(this.PropertyUse) + "'");
sb.Append(" ,'" + Preparer.Escape(this.InternalStatusCode) + "'");
sb.Append(" ,'" + Preparer.Escape(this.CustomerStatusCode) + "'");
sb.Append(" ,'" + Preparer.Escape(this.OriginatorId) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Created) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Modified) + "'");
sb.Append(" ,'" + Preparer.Escape(this.ClosingDate) + "'");
sb.Append(" ,'" + Preparer.Escape(this.ClientName) + "'");
sb.Append(" ,'" + Preparer.Escape(this.OrderUploadLogId) + "'");
sb.Append(" )");
return(sb.ToString());
}
/// <summary>
/// Returns an SQL statement to update this object in the DB
/// </summary>
/// <returns></returns>
protected override string GetUpdateSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("update `request_status` set");
sb.Append(" rs_description = '" + Preparer.Escape(this.Description) + "'");
sb.Append(" ,rs_permission_bit = '" + Preparer.Escape(this.PermissionBit) + "'");
sb.Append(" where rs_code = '" + Preparer.Escape(this.Code) + "'");
return(sb.ToString());
}
/// <summary>
/// Returns an SQL statement to update this object in the DB
/// </summary>
/// <returns></returns>
protected override string GetUpdateSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("update `system_setting` set");
sb.Append(" ss_description = '" + Preparer.Escape(this.Description) + "'");
sb.Append(" ,ss_data = '" + Preparer.Escape(this.Data) + "'");
sb.Append(" where ss_code = '" + Preparer.Escape(this.Code) + "'");
return(sb.ToString());
}
/// <summary>
/// Returns an SQL statement to update this object in the DB
/// </summary>
/// <returns></returns>
protected override string GetUpdateSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("update `company` set");
sb.Append(" c_name = '" + Preparer.Escape(this.Name) + "'");
sb.Append(" ,c_created = '" + Preparer.Escape(this.Created) + "'");
sb.Append(" where c_id = '" + Preparer.Escape(this.Id) + "'");
return(sb.ToString());
}
protected override string GetWhereSql()
{
StringBuilder sb = new StringBuilder();
string delim = " where ";
if (null != Zip)
{
sb.Append(delim + "z.Zip = '" + Preparer.Escape(Zip) + "'");
delim = " and ";
}
if (null != ZipBeginsWith)
{
sb.Append(delim + "z.Zip like '" + Preparer.Escape(ZipBeginsWith) + "%'");
delim = " and ";
}
if (null != City)
{
sb.Append(delim + "z.City = '" + Preparer.Escape(City) + "'");
delim = " and ";
}
if (null != CityBeginsWith)
{
sb.Append(delim + "z.City like '" + Preparer.Escape(CityBeginsWith) + "%'");
delim = " and ";
}
if (null != State)
{
sb.Append(delim + "z.State = '" + Preparer.Escape(State) + "'");
delim = " and ";
}
if (null != County)
{
sb.Append(delim + "z.County = '" + Preparer.Escape(County) + "'");
delim = " and ";
}
if (null != FipsCode)
{
sb.Append(delim + "z.FipsCode = '" + Preparer.Escape(FipsCode) + "'");
delim = " and ";
}
if (null != CountyBeginsWith)
{
sb.Append(delim + "z.County like '" + Preparer.Escape(CountyBeginsWith) + "%'");
delim = " and ";
}
return(sb.ToString());
}
/// <summary>
/// Returns an SQL statement to update this object in the DB
/// </summary>
/// <returns></returns>
protected override string GetUpdateSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("update `attachment_purpose` set");
sb.Append(" ap_description = '" + Preparer.Escape(this.Description) + "'");
sb.Append(" ,ap_send_notification = '" + Preparer.Escape(this.SendNotification) + "'");
sb.Append(" ,ap_change_status_to = '" + Preparer.Escape(this.ChangeStatusTo) + "'");
sb.Append(" ,ap_permission_required = '" + Preparer.Escape(this.PermissionRequired) + "'");
sb.Append(" where ap_code = '" + Preparer.Escape(this.Code) + "'");
return(sb.ToString());
}
/// <summary>
/// Returns an SQL statement to update this object in the DB
/// </summary>
/// <returns></returns>
protected override string GetUpdateSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("update `zipcode` set");
sb.Append(" City = '" + Preparer.Escape(this.City) + "'");
sb.Append(" ,State = '" + Preparer.Escape(this.State) + "'");
sb.Append(" ,County = '" + Preparer.Escape(this.County) + "'");
sb.Append(" ,FipsCode = '" + Preparer.Escape(this.FipsCode) + "'");
sb.Append(" where Zip = '" + Preparer.Escape(this.Zip) + "'");
return(sb.ToString());
}
/// <summary>
/// Returns an SQL statement to update this object in the DB
/// </summary>
/// <returns></returns>
protected override string GetUpdateSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("update `title_fees` set");
sb.Append(" tf_type = '" + Preparer.Escape(this.FeeType) + "',");
sb.Append(" tf_name = '" + Preparer.Escape(this.Name) + "',");
sb.Append(" tf_fee = '" + Preparer.Escape(this.Fee) + "',");
sb.Append(" tf_modified = '" + Preparer.Escape(this.Modified) + "'");
sb.Append(" where tf_id = '" + Preparer.Escape(this.Id) + "'");
return(sb.ToString());
}
/// <summary>
/// Returns an SQL statement to update this object in the DB
/// </summary>
/// <returns></returns>
protected override string GetUpdateSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("update `request_type` set");
sb.Append(" rt_description = '" + Preparer.Escape(this.Description) + "'");
sb.Append(" ,rt_export_formats = '" + Preparer.Escape(this.ExportFormats) + "'");
sb.Append(" ,rt_definition = '" + Preparer.Escape(this.Definition) + "'");
sb.Append(" ,rt_is_active = '" + Preparer.Escape(this.IsActive) + "'");
sb.Append(" where rt_code = '" + Preparer.Escape(this.Code) + "'");
return(sb.ToString());
}
/// <summary>
/// Persists updates to the DB.
/// </summary>
/// <returns></returns>
protected override string GetUpdateSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("update `hud_log` set");
sb.Append(" a_id = '" + Preparer.Escape(this.AccountID) + "'");
sb.Append(" ,h_submission_xml = '" + Preparer.Escape(this.SubmissionXML) + "'");
sb.Append(" ,h_modified = sysdate()");
sb.Append(" where h_id = '" + Preparer.Escape(this.Id) + "'");
return(sb.ToString());
}
/// <summary>
/// Returns an SQL statement to update this object in the DB
/// </summary>
/// <returns></returns>
protected override string GetUpdateSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("update `order_status` set");
sb.Append(" os_description = '" + Preparer.Escape(this.Description) + "'");
sb.Append(" ,os_permission_bit = '" + Preparer.Escape(this.PermissionBit) + "'");
sb.Append(" ,os_internal_external = '" + Preparer.Escape(this.InternalExternal) + "'");
sb.Append(" ,os_is_closed = '" + Preparer.Escape(this.IsClosed) + "'");
sb.Append(" where os_code = '" + Preparer.Escape(this.Code) + "'");
return(sb.ToString());
}
/// <summary>
/// persists the password for the a
/// </summary>
public void SetPassword()
{
StringBuilder sb = new StringBuilder();
sb.Append(" update account set");
sb.Append(" a_password = aes_encrypt('" + Preparer.Escape(this.Password) + "','" + Preparer.Escape(this.Username) + "')");
sb.Append(" where a_id = '" + Preparer.Escape(this.Id) + "'");
// set password fields back to blank
this.Password = "";
this.phreezer.ExecuteNonQuery(sb.ToString());
}
/// <summary>
/// Returns an SQL statement to insert this object into the DB
/// </summary>
/// <returns></returns>
protected override string GetInsertSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into `location` (");
sb.Append(" l_code");
sb.Append(" ,l_description");
sb.Append(" ) values (");
sb.Append(" '" + Preparer.Escape(this.Code) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Description) + "'");
sb.Append(" )");
return(sb.ToString());
}
/// <summary>
/// Returns an SQL statement to update this object in the DB
/// </summary>
/// <returns></returns>
protected override string GetUpdateSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("update `content` set");
sb.Append(" ct_meta_title = '" + Preparer.Escape(this.MetaTitle) + "'");
sb.Append(" ,ct_meta_keywords = '" + Preparer.Escape(this.MetaKeywords) + "'");
sb.Append(" ,ct_meta_description = '" + Preparer.Escape(this.MetaDescription) + "'");
sb.Append(" ,ct_header = '" + Preparer.Escape(this.Header) + "'");
sb.Append(" ,ct_body = '" + Preparer.Escape(this.Body) + "'");
sb.Append(" ,ct_modified = '" + Preparer.Escape(this.Modified) + "'");
sb.Append(" where ct_code = '" + Preparer.Escape(this.Code) + "'");
return(sb.ToString());
}
/// <summary>
/// Returns an SQL statement to insert this object into the DB
/// </summary>
/// <returns></returns>
protected override string GetInsertSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into `attachment_roles` (");
sb.Append(" ap_code");
sb.Append(" ,r_code");
sb.Append(" ) values (");
sb.Append(" '" + Preparer.Escape(this.AttachmentPurposeCode) + "'");
sb.Append(" ,'" + Preparer.Escape(this.RoleCode) + "'");
sb.Append(" )");
return(sb.ToString());
}
