/// <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 `system_setting` (");
sb.Append(" ss_code");
sb.Append(" ,ss_description");
sb.Append(" ,ss_data");
sb.Append(" ) values (");
sb.Append(" '" + Preparer.Escape(this.Code) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Description) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Data) + "'");
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` set");
sb.Append(" r_request_type_code = '" + Preparer.Escape(this.RequestTypeCode) + "'");
sb.Append(" ,r_order_id = '" + Preparer.Escape(this.OrderId) + "'");
sb.Append(" ,r_originator_id = '" + Preparer.Escape(this.OriginatorId) + "'");
sb.Append(" ,r_created = '" + Preparer.Escape(this.Created) + "'");
sb.Append(" ,r_status_code = '" + Preparer.Escape(this.StatusCode) + "'");
sb.Append(" ,r_xml = '" + Preparer.Escape(this.Xml) + "'");
sb.Append(" ,r_is_current = '" + Preparer.Escape(this.IsCurrent) + "'");
sb.Append(" ,r_note = '" + Preparer.Escape(this.Note) + "'");
sb.Append(" where r_id = '" + Preparer.Escape(this.Id) + "'");
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_status` (");
sb.Append(" rs_code");
sb.Append(" ,rs_description");
sb.Append(" ,rs_permission_bit");
sb.Append(" ) values (");
sb.Append(" '" + Preparer.Escape(this.Code) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Description) + "'");
sb.Append(" ,'" + Preparer.Escape(this.PermissionBit) + "'");
sb.Append(" )");
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 `order_assignment` (");
sb.Append(" oa_account_id");
sb.Append(" ,oa_order_id");
sb.Append(" ,oa_permission_bit");
sb.Append(" ) values (");
sb.Append(" '" + Preparer.Escape(this.AccountId) + "'");
sb.Append(" ,'" + Preparer.Escape(this.OrderId) + "'");
sb.Append(" ,'" + Preparer.Escape(this.PermissionBit) + "'");
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 `schedule` set");
sb.Append(" a_id = '" + Preparer.Escape(this.AccountID) + "'");
sb.Append(" ,o_id = '" + Preparer.Escape(this.OrderID) + "'");
sb.Append(" ,r_id = '" + Preparer.Escape(this.RequestID) + "'");
sb.Append(" ,att_id = '" + Preparer.Escape(this.AttachmentID) + "'");
sb.Append(" ,ua_id = '" + Preparer.Escape(this.UploadAccountID) + "'");
sb.Append(" ,s_search_package_date = '" + Preparer.Escape(this.Search_package_date) + "'");
sb.Append(" ,s_first_notification = '" + Preparer.Escape(this.First_notification) + "'");
sb.Append(" ,s_second_notification = '" + Preparer.Escape(this.Second_notification) + "'");
sb.Append(" ,s_modified = '" + Preparer.Escape(this.Modified) + "'");
sb.Append(" where s_id = '" + Preparer.Escape(this.Id) + "'");
return(sb.ToString());
}
/// <summary>
/// Inserts into the DB. Note that password field is not inserted
/// SetPassword() must be called to set the password
/// </summary>
/// <returns></returns>
protected override string GetInsertSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into `account` (");
sb.Append(" a_username");
sb.Append(" ,a_password");
sb.Append(" ,a_first_name");
sb.Append(" ,a_last_name");
sb.Append(" ,a_status_code");
sb.Append(" ,a_created");
sb.Append(" ,a_modified");
sb.Append(" ,a_password_hint");
sb.Append(" ,a_preferences_xml");
sb.Append(" ,a_role_code");
sb.Append(" ,a_company_id");
sb.Append(" ,a_internal_id");
sb.Append(" ,a_email");
sb.Append(" ,a_underwriter_codes");
sb.Append(" ,a_underwriter_endorsements");
sb.Append(" ,a_business_license_id");
sb.Append(" ,a_individual_license_id");
sb.Append(" ,a_signature");
sb.Append(" ) values (");
sb.Append(" '" + Preparer.Escape(this.Username) + "'");
sb.Append(" ,''");
sb.Append(" ,'" + Preparer.Escape(this.FirstName) + "'");
sb.Append(" ,'" + Preparer.Escape(this.LastName) + "'");
sb.Append(" ,'" + Preparer.Escape(this.StatusCode) + "'");
sb.Append(" ,sysdate()");
sb.Append(" ,sysdate()");
sb.Append(" ,'" + Preparer.Escape(this.PasswordHint) + "'");
sb.Append(" ,'" + Preparer.Escape(this.PreferencesXml) + "'");
sb.Append(" ,'" + Preparer.Escape(this.RoleCode) + "'");
sb.Append(" ,'" + Preparer.Escape(this.CompanyId) + "'");
sb.Append(" ,'" + Preparer.Escape(this.InternalId) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Email) + "'");
sb.Append(" ,'" + Preparer.Escape(this.UnderwriterCodes) + "'");
sb.Append(" ,'" + Preparer.Escape(this.UnderwriterEndorsements) + "'");
sb.Append(" ,'" + Preparer.Escape(this.BusinessLicenseID) + "'");
sb.Append(" ,'" + Preparer.Escape(this.IndividualLicenseID) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Signature) + "'");
sb.Append(" )");
return(sb.ToString());
}
/// <summary>
/// Inserts into the DB.
/// </summary>
/// <returns></returns>
protected override string GetInsertSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into `hud_log` (");
sb.Append(" a_id");
sb.Append(" ,h_submission_xml");
sb.Append(" ,h_modified");
sb.Append(" ,h_created");
sb.Append(" ) values (");
sb.Append(" '" + Preparer.Escape(this.AccountID) + "'");
sb.Append(" ,'" + Preparer.Escape(this.SubmissionXML) + "'");
sb.Append(" ,sysdate()");
sb.Append(" ,sysdate()");
sb.Append(" )");
return(sb.ToString());
}
protected override string GetWhereSql()
{
StringBuilder sb = new StringBuilder();
string delim = " where ";
if (null != Id)
{
sb.Append(delim + "tf.tf_id = '" + Preparer.Escape(Id) + "'");
delim = " and ";
}
if (null != FeeType)
{
sb.Append(delim + "tf.tf_type = '" + Preparer.Escape(FeeType) + "'");
delim = " and ";
}
if (null != Name)
{
sb.Append(delim + "tf.tf_name = '" + Preparer.Escape(Name) + "'");
delim = " and ";
}
if (0 != Fee)
{
sb.Append(delim + "tf.tf_fee = '" + Preparer.Escape(Fee) + "'");
delim = " and ";
}
/*
* if (null != Modified)
* {
* sb.Append(delim + "tf.tf_modified = '" + Preparer.Escape(Modified) + "'");
* delim = " and ";
* }
*
* if (null != Created)
* {
* sb.Append(delim + "tf.tf_created = '" + Preparer.Escape(Created) + "'");
* delim = " and ";
* }
*/
return(sb.ToString());
}
/// <summary>
/// reads the column values from a datareader and populates the object properties
/// </summary>
/// <param name="reader"></param>
public override void Load(MySqlDataReader reader)
{
if (reader.HasRows)
{
this.Id = Preparer.SafeInt(reader["s_id"]);
this.AccountID = Preparer.SafeInt(reader["a_id"]);
this.OrderID = Preparer.SafeInt(reader["o_id"]);
this.RequestID = Preparer.SafeInt(reader["r_id"]);
this.AttachmentID = Preparer.SafeInt(reader["att_id"]);
this.UploadAccountID = Preparer.SafeInt(reader["ua_id"]);
this.Search_package_date = Preparer.SafeDateTime(reader["s_search_package_date"]);
this.First_notification = Preparer.SafeDateTime(reader["s_first_notification"]);
this.Second_notification = Preparer.SafeDateTime(reader["s_second_notification"]);
this.Modified = Preparer.SafeDateTime(reader["s_modified"]);
this.Created = Preparer.SafeDateTime(reader["s_created"]);
this.OnLoad(reader);
}
}
protected override string GetWhereSql()
{
StringBuilder sb = new StringBuilder();
string delim = " where ";
if (null != Code)
{
sb.Append(delim + "l.l_code = '" + Preparer.Escape(Code) + "'");
delim = " and ";
}
if (null != Description)
{
sb.Append(delim + "l.l_description = '" + Preparer.Escape(Description) + "'");
delim = " and ";
}
return(sb.ToString());
}
protected override string GetWhereSql()
{
StringBuilder sb = new StringBuilder();
string delim = " where ";
if (AccountID > 0)
{
sb.Append(delim + "el.a_id = '" + Preparer.Escape(AccountID) + "'");
delim = " and ";
}
if (OrderID > 0)
{
sb.Append(delim + "el.o_id = '" + Preparer.Escape(OrderID) + "'");
delim = " and ";
}
if (RequestID > 0)
{
sb.Append(delim + "el.r_id = '" + Preparer.Escape(RequestID) + "'");
delim = " and ";
}
if (null != ExportFormat)
{
sb.Append(delim + "el.export_format = '" + Preparer.Escape(ExportFormat) + "'");
delim = " and ";
}
if ("1-1-1 0:0:0" != Preparer.Escape(Created))
{
sb.Append(delim + "el.el_created = '" + Preparer.Escape(Created) + "'");
delim = " and ";
}
if ("1-1-1 0:0:0" != Preparer.Escape(Modified))
{
sb.Append(delim + "el.el_modified = '" + Preparer.Escape(Modified) + "'");
delim = " and ";
}
return(sb.ToString());
}
protected override string GetWhereSql()
{
StringBuilder sb = new StringBuilder();
string delim = " where ";
if (null != RoleCode)
{
sb.Append(delim + "r_code = '" + Preparer.Escape(RoleCode) + "'");
delim = " and ";
}
if (null != AttachmentPurposeCode)
{
sb.Append(delim + "ap_code = '" + Preparer.Escape(AttachmentPurposeCode) + "'");
delim = " and ";
}
return(sb.ToString());
}
protected override string GetWhereSql()
{
StringBuilder sb = new StringBuilder();
string delim = " where ";
if (null != Username)
{
sb.Append(delim + "a.a_username like '%" + Preparer.Escape(Username) + "%'");
delim = " or ";
}
if (null != FirstName)
{
sb.Append(delim + "a.a_first_name like '%" + Preparer.Escape(FirstName) + "%'");
delim = " or ";
}
if (null != LastName)
{
sb.Append(delim + "a.a_last_name like '%" + Preparer.Escape(LastName) + "%'");
delim = " or ";
}
if (null != Company)
{
sb.Append(delim + "c.c_name like '%" + Preparer.Escape(Company) + "%'");
delim = " or ";
}
if (null != RoleCode)
{
sb.Append(delim + "a.a_role_code like '%" + Preparer.Escape(RoleCode) + "%'");
delim = " or ";
}
{
sb.Append(delim + "a.a_email like '%" + Preparer.Escape(Email) + "%'");
delim = " or ";
}
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 `order_status` (");
sb.Append(" os_code");
sb.Append(" ,os_description");
sb.Append(" ,os_permission_bit");
sb.Append(" ,os_internal_external");
sb.Append(" ,os_is_closed");
sb.Append(" ) values (");
sb.Append(" '" + Preparer.Escape(this.Code) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Description) + "'");
sb.Append(" ,'" + Preparer.Escape(this.PermissionBit) + "'");
sb.Append(" ,'" + Preparer.Escape(this.InternalExternal) + "'");
sb.Append(" ,'" + Preparer.Escape(this.IsClosed) + "'");
sb.Append(" )");
return(sb.ToString());
}
public async Task <ActionResult <Response <Preparer> > > GetPreparer(int id)
{
logger.LogInformation("GET preparadores/{id} invocado con id " + id);
return(await RequestsHandler.HandleAsyncRequest(
logger,
async() =>
{
var preparer = await potigianContext.Preparers.FirstOrDefaultAsync(p => p.Id == id);
if (preparer == null)
{
preparer = new Preparer
{
Code = "-1"
};
}
return preparer;
}));
}
/// <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 `taxing_district` set");
sb.Append(" type = '" + Preparer.Escape(this.Type) + "'");
sb.Append(" ,county = '" + Preparer.Escape(this.County) + "'");
sb.Append(" ,liable_party = '" + Preparer.Escape(this.Liable_party) + "'");
sb.Append(" ,amount = '" + Preparer.Escape(this.Amount) + "'");
sb.Append(" ,where = '" + Preparer.Escape(this.Where) + "'");
sb.Append(" ,address = '" + Preparer.Escape(this.Address) + "'");
sb.Append(" ,csz = '" + Preparer.Escape(this.CSZ) + "'");
sb.Append(" ,phone = '" + Preparer.Escape(this.Phone) + "'");
sb.Append(" ,website = '" + Preparer.Escape(this.Website) + "'");
sb.Append(" ,stamp_exempt = '" + Preparer.Escape(this.Stamp_exempt) + "'");
sb.Append(" ,notes = '" + Preparer.Escape(this.Notes) + "'");
sb.Append(" ,stamp_required = '" + Preparer.Escape(this.Stamp_required) + "'");
sb.Append(" where taxing_district = '" + Preparer.Escape(this.Taxing_district) + "'");
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_type` (");
sb.Append(" rt_code");
sb.Append(" ,rt_description");
sb.Append(" ,rt_export_formats");
sb.Append(" ,rt_definition");
sb.Append(" ,rt_is_active");
sb.Append(" ) values (");
sb.Append(" '" + Preparer.Escape(this.Code) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Description) + "'");
sb.Append(" ,'" + Preparer.Escape(this.ExportFormats) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Definition) + "'");
sb.Append(" ,'" + Preparer.Escape(this.IsActive) + "'");
sb.Append(" )");
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_purpose` (");
sb.Append(" ap_code");
sb.Append(" ,ap_description");
sb.Append(" ,ap_send_notification");
sb.Append(" ,ap_change_status_to");
sb.Append(" ,ap_permission_required");
sb.Append(" ) values (");
sb.Append(" '" + Preparer.Escape(this.Code) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Description) + "'");
sb.Append(" ,'" + Preparer.Escape(this.SendNotification) + "'");
sb.Append(" ,'" + Preparer.Escape(this.ChangeStatusTo) + "'");
sb.Append(" ,'" + Preparer.Escape(this.PermissionRequired) + "'");
sb.Append(" )");
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 `title_fees` (");
sb.Append(" tf_type");
sb.Append(" ,tf_name");
sb.Append(" ,tf_fee");
sb.Append(" ,tf_modified");
sb.Append(" ,tf_created");
sb.Append(" ) values (");
sb.Append(" '" + Preparer.Escape(this.FeeType) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Name) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Fee) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Modified) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Created) + "'");
sb.Append(" )");
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 `zipcode` (");
sb.Append(" Zip");
sb.Append(" ,City");
sb.Append(" ,State");
sb.Append(" ,County");
sb.Append(" ,FipsCode");
sb.Append(" ) values (");
sb.Append(" '" + Preparer.Escape(this.Zip) + "'");
sb.Append(" ,'" + Preparer.Escape(this.City) + "'");
sb.Append(" ,'" + Preparer.Escape(this.State) + "'");
sb.Append(" ,'" + Preparer.Escape(this.County) + "'");
sb.Append(" ,'" + Preparer.Escape(this.FipsCode) + "'");
sb.Append(" )");
return(sb.ToString());
}
public void Demo1()
{
var textPath = Path.Combine(Directory.GetCurrentDirectory(), "..", "..", "..", "text.txt");
var text = Reader.ReadFile(textPath);
var preparer = new Preparer(new[] { "что", "если", "это", "как" }, word => word.Length > 3);
var prepared = preparer.CreateWordFreqList(text, 200);
var algorithm = AlgorithmFabric.Create(AlgorithmType.Exponential);
var graphicalWords = algorithm(prepared);
var painter = new Painter(FontFamily.GenericSansSerif,
new RandomChoicePalette(new[]
{ Color.Peru, Color.Pink, Color.Green, Color.Red, Color.Blue, Color.Black }, Color.White),
size => new CircularLayouter(size));
var img = painter.Paint(graphicalWords);
var path = Path.Combine(Directory.GetCurrentDirectory(), "demo1.jpg");
Saver.SaveImage(img, path);
Console.WriteLine($"Изображение сохранено в {path}");
}
/// <summary>
/// reads the column values from a datareader and populates the object properties
/// </summary>
/// <param name="reader"></param>
public override void Load(MySqlDataReader reader)
{
if (reader.HasRows)
{
this.Taxing_district = Preparer.SafeString(reader["taxing_district"]);
this.Type = Preparer.SafeString(reader["type"]);
this.County = Preparer.SafeString(reader["county"]);
this.Liable_party = Preparer.SafeString(reader["liable_party"]);
this.Amount = Preparer.SafeString(reader["amount"]);
this.Where = Preparer.SafeString(reader["where"]);
this.Address = Preparer.SafeString(reader["address"]);
this.CSZ = Preparer.SafeString(reader["csz"]);
this.Phone = Preparer.SafeString(reader["phone"]);
this.Website = Preparer.SafeString(reader["website"]);
this.Stamp_exempt = Preparer.SafeString(reader["stamp_exempt"]);
this.Notes = Preparer.SafeString(reader["notes"]);
this.Stamp_required = Preparer.SafeInt(reader["stamp_required"]);
this.OnLoad(reader);
}
}
/// <summary>
/// Inserts into the DB.
/// </summary>
/// <returns></returns>
protected override string GetInsertSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into `export_log` (");
sb.Append(" a_id");
sb.Append(" ,o_id");
sb.Append(" ,r_id");
sb.Append(" ,export_format");
sb.Append(" ,el_modified");
sb.Append(" ,el_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.ExportFormat) + "'");
sb.Append(" ,sysdate()");
sb.Append(" ,sysdate()");
sb.Append(" )");
return(sb.ToString());
}
/// <summary>
/// Attempts to login using the given username/password. if success, the a
/// is loaded and true is returned. otherwise returns false
/// </summary>
/// <param name="reader"></param>
public bool Login(string username, string password)
{
string sql = "select * from account a "
+ " inner join role r on a.a_role_code = r.r_code "
+ " where a_username = '******'"
+ " and a.a_password = aes_encrypt('" + Preparer.Escape(password) + "','" + Preparer.Escape(username) + "')";
MySqlDataReader reader = this.phreezer.ExecuteReader(sql, System.Data.CommandBehavior.SingleRow);
bool loginOk = false;
if (reader.HasRows)
{
reader.Read();
this.Load(reader);
loginOk = true;
}
reader.Close();
return(loginOk);
}
protected override string GetWhereSql()
{
StringBuilder sb = new StringBuilder();
string delim = " where ";
if (null != Code)
{
sb.Append(delim + "os.os_code = '" + Preparer.Escape(Code) + "'");
delim = " and ";
}
if (null != Description)
{
sb.Append(delim + "os.os_description = '" + Preparer.Escape(Description) + "'");
delim = " and ";
}
if (-1 != PermissionBit)
{
sb.Append(delim + "os.os_permission_bit = '" + Preparer.Escape(PermissionBit) + "'");
delim = " and ";
}
if (-1 != InternalExternal)
{
sb.Append(delim + "os.os_internal_external = '" + Preparer.Escape(InternalExternal) + "'");
delim = " and ";
}
if (-1 != IsClosed)
{
sb.Append(delim + "os.os_is_closed = '" + Preparer.Escape(IsClosed) + "'");
delim = " and ";
}
return(sb.ToString());
}
/// <summary>
/// reads the column values from a datareader and populates the object properties
/// </summary>
/// <param name="reader"></param>
public override void Load(MySqlDataReader reader)
{
this.Id = Preparer.SafeInt(reader["a_id"]);
this.Username = Preparer.SafeString(reader["a_username"]);
this.Password = Preparer.SafeString(reader["a_password"]);
this.FirstName = Preparer.SafeString(reader["a_first_name"]);
this.LastName = Preparer.SafeString(reader["a_last_name"]);
this.StatusCode = Preparer.SafeString(reader["a_status_code"]);
this.Created = Preparer.SafeDateTime(reader["a_created"]);
this.Modified = Preparer.SafeDateTime(reader["a_modified"]);
this.PasswordHint = Preparer.SafeString(reader["a_password_hint"]);
this.PreferencesXml = Preparer.SafeString(reader["a_preferences_xml"]);
this.RoleCode = Preparer.SafeString(reader["a_role_code"]);
this.CompanyId = Preparer.SafeInt(reader["a_company_id"]);
this.InternalId = Preparer.SafeString(reader["a_internal_id"]);
this.Email = Preparer.SafeString(reader["a_email"]);
this.UnderwriterCodes = Preparer.SafeString(reader["a_underwriter_codes"]);
this.UnderwriterEndorsements = Preparer.SafeString(reader["a_underwriter_endorsements"]);
this.BusinessLicenseID = Preparer.SafeString(reader["a_business_license_id"]);
this.IndividualLicenseID = Preparer.SafeString(reader["a_individual_license_id"]);
this.Signature = Preparer.SafeString(reader["a_signature"]);
this.OnLoad(reader);
}
/// <summary>
/// Inserts into the DB.
/// </summary>
/// <returns></returns>
protected override string GetInsertSql()
{
StringBuilder sb = new StringBuilder();
sb.Append("insert into `upload_log` (");
sb.Append(" a_id");
sb.Append(" ,ua_id");
sb.Append(" ,o_id");
sb.Append(" ,r_id");
sb.Append(" ,att_id");
sb.Append(" ,ul_modified");
sb.Append(" ,ul_created");
sb.Append(" ) values (");
sb.Append(" '" + Preparer.Escape(this.AccountID) + "'");
sb.Append(" ,'" + Preparer.Escape(this.UploadAccountID) + "'");
sb.Append(" ,'" + Preparer.Escape(this.OrderID) + "'");
sb.Append(" ,'" + Preparer.Escape(this.RequestID) + "'");
sb.Append(" ,'" + Preparer.Escape(this.AttachmentID) + "'");
sb.Append(" ,sysdate()");
sb.Append(" ,sysdate()");
sb.Append(" )");
return(sb.ToString());
}
protected override string GetWhereSql()
{
StringBuilder sb = new StringBuilder();
string delim = " where ";
if ("1/1/0001 12:00:00 AM" != First_notification.ToString())
{
sb.Append(delim + "s.s_first_notification like '%" + Preparer.Escape(First_notification) + "%'");
delim = " or ";
}
if ("1/1/0001 12:00:00 AM" != Second_notification.ToString())
{
sb.Append(delim + "s.s_second_notification like '%" + Preparer.Escape(Second_notification) + "%'");
delim = " or ";
}
if ("1/1/0001 12:00:00 AM" != Search_package_date.ToString())
{
sb.Append(delim + "s.s_search_package_date like '%" + Preparer.Escape(Search_package_date) + "%'");
delim = " or ";
}
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 `content` (");
sb.Append(" ct_code");
sb.Append(" ,ct_meta_title");
sb.Append(" ,ct_meta_keywords");
sb.Append(" ,ct_meta_description");
sb.Append(" ,ct_header");
sb.Append(" ,ct_body");
sb.Append(" ,ct_modified");
sb.Append(" ) values (");
sb.Append(" '" + Preparer.Escape(this.Code) + "'");
sb.Append(" ,'" + Preparer.Escape(this.MetaTitle) + "'");
sb.Append(" ,'" + Preparer.Escape(this.MetaKeywords) + "'");
sb.Append(" ,'" + Preparer.Escape(this.MetaDescription) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Header) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Body) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Modified) + "'");
sb.Append(" )");
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 `taxing_district` (");
sb.Append(" taxing_district");
sb.Append(" ,type");
sb.Append(" ,county");
sb.Append(" ,liable_party");
sb.Append(" ,amount");
sb.Append(" ,where");
sb.Append(" ,address");
sb.Append(" ,csz");
sb.Append(" ,phone");
sb.Append(" ,website");
sb.Append(" ,stamp_exempt");
sb.Append(" ,notes");
sb.Append(" ,stamp_required");
sb.Append(" ) values (");
sb.Append(" '" + Preparer.Escape(this.Taxing_district) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Type) + "'");
sb.Append(" ,'" + Preparer.Escape(this.County) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Liable_party) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Amount) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Where) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Address) + "'");
sb.Append(" ,'" + Preparer.Escape(this.CSZ) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Phone) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Website) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Stamp_exempt) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Notes) + "'");
sb.Append(" ,'" + Preparer.Escape(this.Stamp_required) + "'");
sb.Append(" )");
return(sb.ToString());
}
private void StartProcessing()
{
FinaChanLogger.Info("Process Start");
if (_readerThread != null)
{
_readerThread.Abort();
_readerThread = null;
}
this.Dispatcher.Invoke(new Action(() =>
{
stage1.Status = UserControls.Stage.statusEnum.NotStarted;
stage2.Status = UserControls.Stage.statusEnum.NotStarted;
stage3.Status = UserControls.Stage.statusEnum.NotStarted;
stage4.Status = UserControls.Stage.statusEnum.NotStarted;
}));
LockUI(true);
_preparer = kernel.Get<Preparer>();
_preparer.OnFinished += new BaseWorker.FinishHandler(_preparer_OnFinished);
_prepareThread = new Thread(new ThreadStart(_preparer.Work));
_prepareThread.IsBackground = true;
_prepareThread.Start();
this.Dispatcher.Invoke(new Action(() =>
{
stage1.Status = UserControls.Stage.statusEnum.InProgress;
}));
}
