public ListPage()
{
InitializeComponent();
books = new List <Book>();
sQLiteManager = new SQLiteManager();
RefreshData();
}
/// <summary>
/// Init a database. </summary>
/// <param name="context"> application context. </param>
/// <param name="dbName"> database (file) name. </param>
/// <param name="version"> schema version. </param>
/// <param name="tableName"> table name. </param>
/// <param name="schema"> specimen value. </param>
/// <param name="errorListener"> optional error listener. </param>
public EngagementStorage(Context context, string dbName, int version, string tableName, ContentValues schema, ErrorListener errorListener)
{
/* Prepare SQLite manager */
mContext = context;
mManager = new SQLiteManager(context, dbName, version, tableName, schema);
mErrorListener = errorListener;
}
private void Guardar_Click(object sender, EventArgs e)
{
if (Convert.ToInt32(PesoText.Text) > 0)
{
try
{
OracleManager.VerificarIntegridadBaseDeDatos(_MarcasUsuario.ID_Planta);
_MarcasUsuario.Peso = Convert.ToInt32(PesoText.Text);
InsertarEnBasesDeDatos(_MarcasUsuario);
Limpiar_UI();
MessageBox.Show("Datos Guardados con éxito.Serás redireccionado " +
"a la página web.", "Confirmación", MessageBoxButtons.OK, MessageBoxIcon.Information);
SQLiteManager.CambiarEstado_App(3);
_MarcasUsuario.Clear_Session();
}
catch (Exception _error)
{
EscribirEnLog("Error al Ingresar Datos. Error: " + _error.Message);
MessageBox.Show("Intermitencia de enlace detectada, pruebe nuevamente.", "Información",
MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1,
MessageBoxOptions.DefaultDesktopOnly);
}
}
else
{
MessageBox.Show("El peso ingresado no puede ser 0.", "Alerta",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1,
MessageBoxOptions.DefaultDesktopOnly);
}
}
/// <summary>
/// Type=1003 应用被启用<para/>
/// 处理 酷Q 的插件启动事件回调
/// </summary>
/// <param name="sender">事件的触发对象</param>
/// <param name="e">事件的附加参数</param>
public void AppEnable(object sender, CQAppEnableEventArgs e)
{
// 当应用被启用后，将收到此事件。
// 如果酷Q载入时应用已被启用，则在_eventStartup(Type=1001,酷Q启动)被调用后，本函数也将被调用一次。
// 如非必要，不建议在这里加载窗口。（可以添加菜单，让用户手动打开窗口）
try
{
ApiModel.setModel(e.CQApi, e.CQLog);
SQLiteManager.GetInstance();
FileOptions.GetInstance();
GuildBattle.InitFile();
DirectoryInfo root = new DirectoryInfo(e.CQApi.AppDirectory);
FileInfo[] files = root.GetFiles();
string pattern = @"Data\-(\d+)\.ini";
foreach (FileInfo info in files)
{
if (Regex.IsMatch(info.Name, pattern))
{
Match temp = Regex.Match(info.Name, pattern);
GuildBattle.GetInstance(long.Parse(temp.Groups[1].Value));
}
}
} catch (Exception exception)
{
e.CQLog.Warning("AppEnable", exception);
}
}
private void GetInfOfDataBase(out string firstName, out string lastName)
{
firstName = string.Empty;
lastName = string.Empty;
string connectionString = SQLiteManager.GetConnectionString(this.PathToDataBase);
using (SQLiteConnection connection = new SQLiteConnection(connectionString))
{
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(
$"SELECT * FROM person WHERE {DbFieldId} = {DbRowId}",
connection))
{
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
firstName = reader[$"{DbFieldFirstName}"].ToString();
lastName = reader[$"{DbFieldLastName}"].ToString();
}
}
}
connection.Close();
}
}
private void Closing_Event(object sender, FormClosingEventArgs e)
{
if (_userSession.Grado == 0 && _userSession.Intento == 1)
{
DialogResult result = MessageBox.Show("Esta aplicación es necesaria para los procesos de Toma de " +
"Grado. ¿Está seguro que realmente desea cerrarla?", "Confirmación",
MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (result == DialogResult.OK)
{
WindowState = FormWindowState.Minimized;
_userSession.Clear_Session();
Limpiar_UI();
SQLiteManager.CambiarEstado_App(4);
//if (PuertoSerial.IsOpen)
// PuertoSerial.Close();
//SQLiteManager.CambiarEstado_App(4);
}
else
{
e.Cancel = true;
}
}
else
{
MessageBox.Show("NO PUEDES CANCELAR LUEGO DE HABER LEIDO EL GRADO.", "ALERTA",
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
e.Cancel = true;
}
}
public string GetHelpTroopNum()
{
List <SQLiteManager.HelpTroopData> helpTroopData = SQLiteManager.GetInstance().GetHelpTroopNum(group, 10);
string output = "【代刀数统计(含补刀)】";
int totalTroop = 0, totalReimburseTroop = 0;
long allTotalDamage = 0; // 所有人代刀总伤害
foreach (SQLiteManager.HelpTroopData data in helpTroopData)
{
totalTroop += data.count;
totalReimburseTroop += data.reimburseCount;
allTotalDamage += data.totalDamage;
output += "\n" + GetUserName(group, data.qq) + "\t\t" + (data.count - data.reimburseCount).ToString();
if (data.reimburseCount > 0)
{
output += "(+" + data.reimburseCount.ToString() + ")";
}
output += "刀\t伤害: " + data.totalDamage.ToString();
}
output += "\n【总代刀数(含补刀)】 " + (totalTroop - totalReimburseTroop).ToString();
if (totalReimburseTroop > 0)
{
output += "(+" + totalReimburseTroop.ToString() + ")";
}
output += " 刀";
output += "\n【代刀总伤害】 " + allTotalDamage.ToString();
return(output);
}
private void getItemsData()
{
DataTable itemsTable = new DataTable();
SQLiteManager mngr = new SQLiteManager();
itemsTable = mngr.getListItems("WINDOWS");
mngr.ConnectionClose();
foreach (DataRow row in itemsTable.Rows)
{
if (row[0].ToString().Equals(tableBD))
{
itemsInWidth = Convert.ToInt32(row[1]);
itemsInHeight = Convert.ToInt32(row[2]);
itemSpace = Convert.ToDouble(row[3]);
itemWidth = Convert.ToDouble(row[5]);
itemHeight = Convert.ToDouble(row[4]);
try
{
fontSize = Convert.ToDouble(row[6]);
}
catch
{
fontSize = 14.0;
}
break;
}
}
itemsCount = itemsInWidth * itemsInHeight;
}
private void TickEvent(object sender, EventArgs e)
{
HoraInfo.Text = DateTime.Now.ToString("HH:mm:ss");
if (SQLiteManager.DebeEjecutarse())
{
BringToFront();
Show();
TopMost = true;
RefractoIcon.Visible = false;
WindowState = FormWindowState.Maximized;
SetearUI_Session(_userSession);
SQLiteManager.EliminarRegistro(_userSession.Id_Recepcion);
OracleManager.VerificarIntegridadBaseDeDatos(_userSession.Id_Planta);
SQLiteManager.CambiarEstado_App(2);
}
if (SQLiteManager.DebeMinimizarse())
{
Limpiar_UI();
//SQLiteManager.CambiarEstado_App(0);
WindowState = FormWindowState.Minimized;
_userSession.Clear_Session();
Hide();
RefractoIcon.Visible = true;
RefractoIcon.ShowBalloonTip(1000);
}
else
{
_cooperado.BringToFront();
}
}
public Romanero_Vista()
{
InitializeComponent();
SQLiteManager.CheckFolders();
_cooperado = new Cooperado_Vista();
SetearSegundaPantalla();
SetearFechaHora();
SetearNombrePlanta();
_cooperado.PlantaInfo.Text = Nombre_Planta;
PlantaInfo.Text = Nombre_Planta;
WindowState = FormWindowState.Minimized;
//SetStartUp();
OracleManager.SetConfiguracionDePuerto(PuertoSerial, _MarcasUsuario.ID_Planta, 2);
TopMost = true;
_cooperado.TopMost = true;
try
{
PuertoSerial.Open();
}
catch (Exception _error)
{
MessageBox.Show("Configuración del Serial Incorrecta. Error: " + _error.Message, "ERROR FATAL",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//EscribirEnLog(GetExecutingDirectoryName());
//PowerModeChangedEventHandler += new SystemEvents_PowerModeChanged();
}
private List <string[]> GetInfOfDataBase()
{
var result = new List <string[]>();
string connectionString = SQLiteManager.GetConnectionString(this.PathToDataBase);
using (SQLiteConnection connection = new SQLiteConnection(connectionString))
{
connection.Open();
using (SQLiteCommand command = new SQLiteCommand(
$"SELECT * FROM person",
connection))
{
using (SQLiteDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
var firstName = reader[$"{DbFieldFirstName}"].ToString();
var lastName = reader[$"{DbFieldLastName}"].ToString();
result.Add(new string[] { firstName, lastName });
}
}
}
connection.Close();
return(result);
}
}
private void InsertarEnBaseDeDatos(Session _userSession)
{
ScreenManager.TomarPantallazo(_userSession);
SQLiteManager.InsertarDatos(_userSession);
OracleManager.InsertarDatosEnPasarela(_userSession);
OracleManager.InsertarFotoRecepcion(_userSession);
}
public InsertPage()
{
InitializeComponent();
Title = "Kişi Ekle";
_btnInsert.Clicked += _btnInsert_Clicked;
manager = new SQLiteManager <Person>();
}
// Token: 0x060000E8 RID: 232 RVA: 0x00007314 File Offset: 0x00005514
private static byte[] ExtractPrivateKey4(string file)
{
byte[] array = new byte[24];
try
{
Console.WriteLine("Key source file: " + file);
if (!File.Exists(file))
{
Console.WriteLine("Source file UNKNOWN");
return(array);
}
SQLiteManager sqliteManager = new SQLiteManager(file);
sqliteManager.ReadTable("metaData");
string value = sqliteManager.GetValue(0, "item1");
string value2 = sqliteManager.GetValue(0, "item2)");
Asn1DerObject asn1DerObject = new Asn1Der().Parse(Encoding.Default.GetBytes(value2));
byte[] data = asn1DerObject.objects[0].objects[0].objects[1].objects[0].Data;
byte[] data2 = asn1DerObject.objects[0].objects[1].Data;
MozillaPBE mozillaPBE = new MozillaPBE(Encoding.Default.GetBytes(value), Encoding.Default.GetBytes(string.Empty), data);
mozillaPBE.Compute();
string input = TripleDESHelper.DESCBCDecryptor(mozillaPBE.Key, mozillaPBE.IV, data2, PaddingMode.None);
Console.WriteLine(new string('=', 20));
Console.WriteLine("Global salt found for encrypt: [" + FirefoxBase.CalcHex(value) + "]");
Console.WriteLine("Entry salt found for encrypt: [" + FirefoxBase.CalcHex(data) + "]");
Console.WriteLine("СheckPwd key for encrypt : [" + FirefoxBase.CalcHex(mozillaPBE.Key) + "]");
Console.WriteLine("СheckPwd IV for encrypt: [" + FirefoxBase.CalcHex(mozillaPBE.IV) + "]");
Console.WriteLine("Decrypted chiper: [" + FirefoxBase.CalcHex(input) + "]");
Console.WriteLine(new string('=', 20));
sqliteManager.ReadTable("nssPrivate");
int rowCount = sqliteManager.GetRowCount();
string s = string.Empty;
for (int i = 0; i < rowCount; i++)
{
if (sqliteManager.GetValue(i, "a102") == Encoding.Default.GetString(FirefoxBase.MagicNumber1))
{
s = sqliteManager.GetValue(i, "a11");
break;
}
}
Asn1DerObject asn1DerObject2 = new Asn1Der().Parse(Encoding.Default.GetBytes(s));
data = asn1DerObject2.objects[0].objects[0].objects[1].objects[0].Data;
data2 = asn1DerObject2.objects[0].objects[1].Data;
mozillaPBE = new MozillaPBE(Encoding.Default.GetBytes(value), Encoding.Default.GetBytes(string.Empty), data);
mozillaPBE.Compute();
Console.WriteLine(new string('=', 20));
Console.WriteLine("ChiperT found after encrypt: [" + FirefoxBase.CalcHex(data2) + "]");
Console.WriteLine("Global salt found after encrypt: [" + FirefoxBase.CalcHex(value) + "]");
Console.WriteLine("Entry salt found after encrypt: [" + FirefoxBase.CalcHex(data) + "]");
Console.WriteLine("СheckPwd key after encrypt : [" + FirefoxBase.CalcHex(mozillaPBE.Key) + "]");
Console.WriteLine("СheckPwd IV after encrypt: [" + FirefoxBase.CalcHex(mozillaPBE.IV) + "]");
array = Encoding.Default.GetBytes(TripleDESHelper.DESCBCDecryptor(mozillaPBE.Key, mozillaPBE.IV, data2, PaddingMode.PKCS7));
Console.WriteLine("Decrypted private key: [" + FirefoxBase.CalcHex(array) + "]");
Console.WriteLine(new string('=', 20));
}
catch (Exception value3)
{
Console.WriteLine(value3);
}
return(array);
}
public string GetTodayDamage(long group, long qq)
{
List <string> temp = new List <string>();
List <SQLiteManager.Damage> damages = SQLiteManager.GetInstance().GetTodayDamages(group, qq);
string output = "[" + GuildBattle.GetUserName(group, qq) + "] 今日对BOSS造成的伤害：";
if (damages.Count == 0)
{
output += "\n无记录";
return(output);
}
long allDamage = 0;
for (int i = 0; i < damages.Count; ++i)
{
temp.Add(damages[i].troop.ToString() + "队伤害: " + damages[i].damage.ToString());
allDamage += damages[i].damage;
}
temp.Sort();
for (int i = 0; i < temp.Count; ++i)
{
output += "\n" + temp[i];
}
output += "\n[今日伤害总计] " + allDamage.ToString();
return(output);
}
public bool CreateExcelReport()
{
bool result;
try
{
var mySQLManager = new MySQLManager();
var reports = mySQLManager.GetAllReports();
var sqliteManager = new SQLiteManager();
var discountInformations = sqliteManager.GetDiscountPercentagesPerCompany();
var reportsWithDiscounts = from r in reports
join di in discountInformations on r.CompanyID equals di.CompanyID
select new DiscountedReport
{
CompanyName = r.CompanyName,
ProductName = r.ProductName,
Price = r.Price * (decimal)(1 - (di.DiscountPercent / 100.00)),
Quantity = r.Quantity,
TotalRevenue = r.TotalRevenue * (decimal)(1 - (di.DiscountPercent / 100.00)),
TotalDiscount = r.TotalRevenue * (decimal)(di.DiscountPercent / 100.00)
};
var file = CreateDirAndFile();
WriteReportDataToFile(file, reportsWithDiscounts);
result = true;
}
catch (Exception)
{
result = false;
}
return result;
}
public static SQLiteManager getInstance()
{
if (ins == null)
{
ins = new SQLiteManager();
}
return(ins);
}
public SQLiteHandler()
{
m_manager = new SQLiteManager("envelope");
if (m_manager.isNewDatabase())
{
Initialize();
}
}
public void BindData()
{
this.IsRefreshing = true;
SQLiteManager manager = new SQLiteManager();
Person = new ObservableCollection <PersonModel>(manager.GetAll().ToList());
this.IsRefreshing = false;
}
public static SQLiteRowData getDefaultView()
{
SQLite.SQLiteRowData dafaultView = new SQLite.SQLiteRowData();
dafaultView = SQLiteManager.SharedInstance().GetItemForKey("SelectedSettingDefaultView").Result;
return(dafaultView);
}
/// <summary>
/// Obtiene datos del pais.
/// </summary>
public void GetDataPais()
{
// Pais
Pais p;
// Obtengo pais
p = SQLiteManager.Connection().GetProvincia(ID_Pais);
// Compruebo datos
if (p == null)
{
// Obtengo pais del servidor
RestManager.Connection().GetData((int)URIS.GetPais, new string[] { ID_Pais.ToString() }, null, (arg) =>
{
// Compruebo datos
if (!string.IsNullOrWhiteSpace(arg))
{
// Deserializo JSON
NSDictionary data = (NSDictionary)NSJsonSerialization.Deserialize(arg, 0, out NSError e);
// Leo datos
foreach (NSString key in data.Keys)
{
switch (key.ToString().ToLower())
{
case "id_pais":
ID_Pais = (int)(NSNumber)data.ValueForKey(key);
break;
case "nombre":
Nombre_Pais = data.ValueForKey(key).ToString();
break;
}
}
// Guardo en SQLite
SQLiteManager.Connection().SetPais(this);
}
// Continuo
lock (l)
{
Monitor.Pulse(l);
}
});
// Espero
lock (l)
{
Monitor.Wait(l);
}
}
else
{
// Cargo nombre
Nombre_Pais = p.Nombre_Pais;
}
}
public void SetDamage(long lessBlood)
{
data.damage = bossdata[data.bossNumber - 1] - lessBlood;
CaculateAllDamage();
SaveData();
SQLiteManager.GetInstance().AddLog(group, "已将BOSS剩余血量重置为 " + GetBossLessDamage().ToString());
ApiModel.CQApi.SendGroupMessage(group, "已将BOSS血量数据重置！" +
"\n" + "该BOSS剩余HP: " + GetBossLessDamage().ToString());
}
public bool SetSL(long qq)
{
if (GetSLStatus(qq) > 0)
{
return(false);
}
SQLiteManager.GetInstance().SetSL(group, qq);
return(true);
}
public bool RemoveSL(long qq)
{
if (GetSLStatus(qq) == -1)
{
return(false);
}
SQLiteManager.GetInstance().RemoveSL(group, qq);
return(true);
}
public PersonDetailPage(Person _person)
{
InitializeComponent();
Title = "Kişi Düzenle";
manager = new SQLiteManager <Person>();
this._person = _person;
GetInfo();
_btnUpdate.Clicked += _btnUpdate_Clicked;
}
public static void saveDefaultView(string selectedDefaultView)
{
if (selectedDefaultView != null)
{
SQLite.SQLiteRowData data = new SQLite.SQLiteRowData();
data = new SQLiteRowData("SelectedSettingDefaultView", selectedDefaultView);
SQLiteManager.SharedInstance().SaveItem(data);
}
}
public static void saveTimePeriod(string selectedTimePeriod)
{
if (selectedTimePeriod != null)
{
SQLite.SQLiteRowData data = new SQLite.SQLiteRowData();
data = new SQLiteRowData("SelectedSettingTimePeriod", selectedTimePeriod);
SQLiteManager.SharedInstance().SaveItem(data);
}
}
public static SQLiteRowData getTimePeriod()
{
SQLiteRowData dataValueTime = new SQLite.SQLiteRowData();
dataValueTime = SQLiteManager.SharedInstance().GetItemForKey("SelectedSettingTimePeriod").Result;
return(dataValueTime);
}
public App()
{
InitializeComponent();
MainPage = new NavigationPage(new MainPage());
var path = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "MyData.db");
dbManager = new SQLiteManager(path);
}
/// <Docs>If the fragment is being re-created from
/// a previous saved state, this is the state.</Docs>
/// <summary>
/// Raises the create event.
/// </summary>
/// <param name="savedInstanceState">Saved instance state.</param>
public override void OnCreate(Bundle savedInstanceState)
{
base.OnCreate(savedInstanceState);
if (Arguments.ContainsKey(ArgActivityId))
{
mActivityId = Arguments.GetInt(ArgActivityId);
}
mSqlite = SQLiteManager.Instance;
}
public void SetProjectBoxItems()
{
projectsBox.Items.Clear();
string[] projects = new SQLiteManager().PathsRepository.GetAllTitles().ToArray();
projectsBox.Items.AddRange(projects);
if (projectsBox.Items.Count > 0)
{
projectsBox.SelectedIndex = 0;
}
}
public SQLiteHelper(String localfilePath, SQLiteManager sqLiteManager)
{
this.manager = sqLiteManager;
this.localFilePath = localfilePath;
}
static void Init()
{
_instance = (SQLiteManager)EditorWindow.GetWindow (typeof(SQLiteManager));
}
/// <summary>
/// <list type="bullet">
/// <item>Initialises Inventory interface</item>
/// <item>Loads and initialises a new SQLite connection and maintains it.</item>
/// <item>use default URI if connect string is empty.</item>
/// </list>
/// </summary>
/// <param name="dbconnect">connect string</param>
override public void Initialise(string connect)
{
database = new SQLiteManager(connect);
}
private void ToMySQLButton_Click(object sender, RoutedEventArgs e)
{
bool result = false;
var mySqlManager = new MySQLManager();
mySqlManager.ClearMySqlDb();
result = mySqlManager.LoadAllReportsDataFromSQLServer();
var sqLiteManager = new SQLiteManager();
sqLiteManager.DeleteAllEntities("Discounts");
var reportsEngine = new ReportsEngine();
var discounts = reportsEngine.GetDiscountsInfo();
foreach (var discount in discounts)
{
result = sqLiteManager.CreateDiscountForCompany(discount.CompanyId, discount.TypeID);
}
if (result)
{
Result.Text = "Import to MySQL has been successfully completed!";
Result.Foreground = Brushes.Green;
}
else
{
Result.Text = "Import to MySQL failed!";
Result.Foreground = Brushes.Red;
}
}
public void Prepare(SQLiteManager data)
{
this.data = data;
Display ();
}
