/// <summary>
///
/// </summary>
/// <param name="pathScript"></param>
private void CreateEmbeddedDb(string pathScript)
{
FbConnectionStringBuilder csb = new FbConnectionStringBuilder();
csb.Charset = "UTF8";
csb.ServerType = FbServerType.Embedded;
csb.Database = databaseName;
csb.UserID = "SYSDBA";
csb.Password = "******";
try {
if (!File.Exists(databaseName)) {
OpenFileDialog filedialog = new OpenFileDialog();
DialogResult res = filedialog.ShowDialog();
filedialog.Title = "Wybierz skrypt sql do utworzenia bazy";
FbConnection.CreateDatabase(csb.ToString());
// parse the SQL script
FbScript script = new FbScript(filedialog.FileName);
script.Parse();
// execute the SQL script
using (FbConnection c = new FbConnection(csb.ToString())) {
FbBatchExecution fbe = new FbBatchExecution(c);
foreach (string cmd in script.Results) {
fbe.SqlStatements.Add(cmd);
}
fbe.Execute();
}
}
}
catch (Exception ex) {
MessageBox.Show(ex.Message, "Błąd", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private static void RecreateDatabaseAndInstallObjects()
{
FbConnection.ClearAllPools();
var connectionStringBuilder = new FbConnectionStringBuilder(ConnectionUtils.GetConnectionString());
if (File.Exists(connectionStringBuilder.Database))
FbConnection.DropDatabase(connectionStringBuilder.ConnectionString);
FbConnection.CreateDatabase(connectionStringBuilder.ToString(), 16384, true, false);
using (var connection = new FbConnection(connectionStringBuilder.ToString()))
{
FirebirdObjectsInstaller.Install(connection);
}
}
private void btnCheck_Click(object sender, EventArgs e)
{
try
{
if (txtPath.Text.Split('@').Length == 2)
{
FbConnectionStringBuilder cnString = new FbConnectionStringBuilder();
cnString.DataSource = txtPath.Text.Split('@')[0];
cnString.Database = txtPath.Text.Split('@')[1];
cnString.UserID = "SYSDBA";
cnString.Password = "******";
cnString.Charset = "win1251";
cnString.Dialect = 3;
using (FbConnection cn = new FbConnection(cnString.ToString()))
{
cn.Open();
FbCommand cmd = new FbCommand("SELECT PRICE.* FROM PRICE", cn);
cmd.ExecuteNonQuery();
}
MessageBox.Show("ok");
}
else
{
MessageBox.Show("Не верный формат строки!");
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message + "\n" + ex.Source);
}
}
public override async Task ChangeDatabaseAsync(string db, CancellationToken cancellationToken = default)
#endif
{
CheckClosed();
if (string.IsNullOrEmpty(db))
{
throw new InvalidOperationException("Database name is not valid.");
}
var oldConnectionString = _connectionString;
try
{
var csb = new FbConnectionStringBuilder(_connectionString);
/* Close current connection */
await CloseAsync().ConfigureAwait(false);
/* Set up the new Database */
csb.Database = db;
ConnectionString = csb.ToString();
/* Open new connection */
await OpenAsync(cancellationToken).ConfigureAwait(false);
}
catch (IscException ex)
{
ConnectionString = oldConnectionString;
throw FbException.Create(ex);
}
}
private bool DataBaseOpenConnection()
{
var fb_con = new FbConnectionStringBuilder
{
Charset = charset,
UserID = userID,
Password = password,
Database = database,
ServerType = 0
};
fb = new FbConnection(fb_con.ToString());
try
{
if (fb.State != ConnectionState.Open)
{
fb.Open();
}
}
catch (Exception ex)
{
Log.Add(ex.Message + "\r\n" + ex.Source + "\r\n" + ex.TargetSite);
return false;
}
return true;
}
private async Task ChangeDatabaseImpl(string db, AsyncWrappingCommonArgs async)
{
CheckClosed();
if (string.IsNullOrEmpty(db))
{
throw new InvalidOperationException("Database name is not valid.");
}
var oldConnectionString = _connectionString;
try
{
var csb = new FbConnectionStringBuilder(_connectionString);
/* Close current connection */
await CloseImpl(async).ConfigureAwait(false);
/* Set up the new Database */
csb.Database = db;
ConnectionString = csb.ToString();
/* Open new connection */
await OpenImpl(async).ConfigureAwait(false);
}
catch (IscException ex)
{
ConnectionString = oldConnectionString;
throw FbException.Create(ex);
}
}
public override void ChangeDatabase(string db)
{
lock (this)
{
CheckClosed();
if (string.IsNullOrEmpty(db))
{
throw new InvalidOperationException("Database name is not valid.");
}
string cs = _connectionString;
try
{
FbConnectionStringBuilder csb = new FbConnectionStringBuilder(_connectionString);
/* Close current connection */
Close();
/* Set up the new Database */
csb.Database = db;
ConnectionString = csb.ToString();
/* Open new connection */
Open();
}
catch (IscException ex)
{
ConnectionString = cs;
throw new FbException(ex.Message, ex);
}
}
}
public override void execute(Options options, INIManager iniManager)
{
string AppKey = iniManager.IniReadValue("APP", "AppKey");
string AppSecret = iniManager.IniReadValue("APP", "AppSecret");
string TaobaoAsistantPath = iniManager.IniReadValue("淘宝助理", "安装目录");
string nick = options.Nick;
string SessionKey = iniManager.IniReadValue(nick, "SessionKey");
string userId = iniManager.IniReadValue(nick, "UserId");
if (userId == null || userId.Trim().Equals(""))
{
userId = "1696293148";
}
StreamWriter MovePicLogWriter;
FileStream MovePicLog = new FileStream(Environment.CurrentDirectory + "\\" + "MovePic.log", FileMode.Append);
MovePicLogWriter = new StreamWriter(MovePicLog, Encoding.Default);
FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
cs.Database = Path.Combine(TaobaoAsistantPath, "users\\" + nick + "\\APPITEM.DAT");
cs.Charset = "UTF8";
cs.UserID = "SYSDBA";
cs.Password = "******";
cs.ServerType = FbServerType.Embedded;
FbConnection fbCon = new FbConnection(cs.ToString());
fbCon.Open();
FbCommand ItemsCommand = null;
ItemsCommand = new FbCommand("SELECT * FROM ITEM WHERE OUTER_ID = @SearchString OR TITLE = @SearchString", fbCon);
FbParameter SearchString = new FbParameter("@SearchString", FbDbType.VarChar);
SearchString.Value = options.Item;
ItemsCommand.Parameters.Add(SearchString);
FbDataReader ItemsReader = ItemsCommand.ExecuteReader();
while (ItemsReader.Read())
{
MovePicLogWriter.WriteLine("--------------------------------------------------------------------------------");
Console.WriteLine("--------------------------------------------------------------------------------");
string ClientID = ItemsReader["CLIENT_ID"].ToString();
string Title = ItemsReader["TITLE"].ToString();
Console.WriteLine("ClientID=" + ClientID);
MovePicLogWriter.WriteLine("ClientID=" + ClientID);
Console.WriteLine("TITLE=" + Title);
MovePicLogWriter.WriteLine("TITLE=" + Title);
FbTransaction myTransaction = fbCon.BeginTransaction();
FbCommand DeleteCommand = new FbCommand("UPDATE ITEM SET CLIENT_IS_DELETE = 1 WHERE CLIENT_ID = @ClientID", fbCon);
FbParameter ParamID = new FbParameter("@ClientID", FbDbType.VarChar);
ParamID.Value = ClientID;
DeleteCommand.Parameters.Add(ParamID);
DeleteCommand.Transaction = myTransaction;
DeleteCommand.ExecuteNonQuery();
myTransaction.Commit();
}
fbCon.Close();
MovePicLogWriter.Close();
MovePicLog.Close();
}
public static string CreateConectionString(string databaseFile,
string userName, string userPass, string _charset)
{
FbConnectionStringBuilder ConnectionSB = new FbConnectionStringBuilder();
ConnectionSB.Database = databaseFile;
ConnectionSB.UserID = userName;
ConnectionSB.Password = userPass;
ConnectionSB.Charset = _charset;
ConnectionSB.Pooling = false;
return ConnectionSB.ToString();
}
public static String GetConnectionString(Database databaseSettings)
{
var connectionString = new FbConnectionStringBuilder();
connectionString.Database = databaseSettings.DatabaseFile;
connectionString.DataSource = "localhost";
connectionString.Dialect = 3;
connectionString.UserID = databaseSettings.User;
connectionString.Password = databaseSettings.Password;
connectionString.Charset = "WIN1251";
connectionString.ConnectionTimeout = 15;
return connectionString.ToString();
}
/// <summary>
/// Возвращает строку для подключения к Firebird
/// </summary>
/// <param name="databaseParams">Параметры для подключения к Firebird</param>
public String GetConnectionString(Database databaseParams)
{
// формируем строку для подключения
FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
cs.DataSource = "localhost";
cs.Database = databaseParams.DatabaseFile;
cs.UserID = databaseParams.User;
cs.Password = databaseParams.Password;
cs.Charset = "WIN1251";
cs.Dialect = 3;
cs.ConnectionTimeout = 15;
return cs.ToString();
}
/// <summary>
/// Создает подключение к Firebird
/// </summary>
/// <returns>Подключение к Firebird</returns>
public static FbConnection GetConnection()
{
var csb = new FbConnectionStringBuilder();
csb.DataSource = "localhost";
csb.Database = RemoteControl.Settings.Database.DatabaseFile;
csb.UserID = RemoteControl.Settings.Database.User;
csb.Password = RemoteControl.Settings.Database.Password;
csb.Charset = "WIN1251";
csb.Dialect = 3;
csb.ConnectionTimeout = 15;
return new FbConnection(csb.ToString());
}
private static string GetConnectionString()
{
var cs = new FbConnectionStringBuilder
{
Database = "Data/database.fdb",
UserID = "SYSDBA",
Password = "******",
Charset = "UTF8",
ServerType = FbServerType.Embedded
};
return cs.ToString();
}
private string GetFb2ConnectionString()
{
var builder = new FbConnectionStringBuilder();
builder.DataSource = "localhost";
builder.Database = @"TestFb2.fdb";
builder.Charset = "UTF8";
builder.UserID = "SYSDBA";
builder.Password = "******";
builder.ServerType = FbServerType.Embedded;
builder.ClientLibrary = @"fb25\fbembed";
builder.Pooling = false;
return builder.ToString();
}
public override FbConnection getConnection()
{
FbConnectionStringBuilder fbSb = new FbConnectionStringBuilder();
//fbSb.Charset = "WIN1251";
fbSb.UserID = Properties.Settings.Default.login;
fbSb.Password = Properties.Settings.Default.password;
fbSb.Port = 3050;
fbSb.DataSource = Properties.Settings.Default.host;
fbSb.Database = Properties.Settings.Default.dbname;
fbSb.ServerType = 0;
//fbSb.ConnectionTimeout = 30;
//MessageBox.Show(fbSb.ToString());
FbConnection fb = new FbConnection(fbSb.ToString());
return fb;
}
static Backup()
{
FBDC.FbConnectionStringBuilder connectionInfo =
new FBDC.FbConnectionStringBuilder();
SCLP.LogProxy.Log(SCLP.LogLevel.Info,
"Backup Manager is now initializing...");
SCLP.LogProxy.Log(SCLP.LogLevel.Info,
"Creating cache directories if necessary...");
cacheDirectory = new DirectoryInfo(
SC.Configuration.SafemateRootPath +
@"\Cache");
creationCacheDirectory = new DirectoryInfo(
cacheDirectory.FullName + @"\Build");
backupOperations =
new List <QueuedBackupOperation>();
backupService = new FBDS.FbBackup();
restorationService = new FBDS.FbRestore();
restorationPath = String.Format(
"{0}\\{1}", creationCacheDirectory.FullName,
"RestorationTesting.fdb");
restorationService.Options =
FBDS.FbRestoreFlags.Replace;
connectionInfo.Charset = "NONE";
connectionInfo.Database = restorationPath;
connectionInfo.DataSource = "localhost";
connectionInfo.Password = "******";
connectionInfo.UserID = "sysdba";
restorationService.ConnectionString =
connectionInfo.ToString();
backupService.Verbose = restorationService.Verbose = true;
backupService.ServiceOutput += ServiceOutputHandler;
restorationService.ServiceOutput += ServiceOutputHandler;
#if __Safemate_Core_Backup_Debug
fragmentThreshold = 1 << 30;
#endif
CreateCreationCache();
}
public DrugstoreData()
{
FbConnectionStringBuilder csb = new FbConnectionStringBuilder();
// Путь до файла с базой данных
csb.Database = "D:\\data\\DS.FDB";
// Настройка параметров "общения" клиента с сервером
csb.Charset = "WIN1251";
csb.Dialect = 3;
// Настройки аутентификации
csb.UserID = "SYSDBA";
csb.Password = "******";
Connection = new FbConnection(csb.ToString());
}
public SQL()
{
FbConnectionStringBuilder fb_con = new FbConnectionStringBuilder();
fb_con.Charset = "WIN1251"; //используемая кодировка
fb_con.UserID = Program.DATALogin; //логин
fb_con.Password = Program.DATAPass; //пароль
if(Program.DATASource!="0")
fb_con.DataSource = Program.DATASource;
if (Program.DATAPort != "0")
fb_con.Port = int.Parse(Program.DATAPort);
fb_con.Database = Program.DATAserver; //путь к файлу базы данных
fb_con.ServerType = 0; //указываем тип сервера (0 - "полноценный Firebird" (classic или super server), 1 - встроенный (embedded))
//создаем подключение
fb = new FbConnection(fb_con.ToString()); //передаем нашу строку подключения объекту класса FbConnection
}
public DbTestFireBird()
{
FbConnectionStringBuilder builder = new FbConnectionStringBuilder
{
ServerType = FbServerType.Embedded,
UserID = Login,
Password = Password,
Dialect = Dialect,
Charset = Charset,
ClientLibrary = PathToDll,
Database = PathToDb
};
pConnectionString = builder.ToString();
Random r = new Random();
pRandomString = r.NextDouble().ToString();
}
private void ParseOld()
{
FbConnectionStringBuilder csb = new FbConnectionStringBuilder();
csb.UserID = "SYSDBA";
csb.Password = "******";
csb.Database = txtDatabaseFile.Text;
csb.ServerType = FbServerType.Default; // embedded Firebird
List<tabelldef> tabelldefs = new List<tabelldef>();
tabelldefs.Add(new tabelldef() { tableName = "BREVDB", idNum = 0, kliNum = 1, dokNum = 14 });
tabelldefs.Add(new tabelldef() { tableName = "JOURNALER", idNum = 0, kliNum = 4, dokNum = 10 });
tabelldefs.Add(new tabelldef() { tableName = "TEKSTBH", idNum = 0, dokNum = 5 });
FbConnection c = new FbConnection(csb.ToString());
c.Open();
foreach (tabelldef t in tabelldefs)
{
Application.DoEvents();
logg1.Refresh();
try
{
FbCommand cmd = new FbCommand("SELECT * FROM " + t.tableName, c);
using (FbDataReader r = cmd.ExecuteReader())
{
if (!Directory.Exists(Path.Combine(txtSavePath.Text, t.tableName)))
Directory.CreateDirectory(Path.Combine(txtSavePath.Text, t.tableName));
while (r.Read())
{
StreamWriter sw = File.CreateText(txtSavePath.Text + @"\" + t.tableName + @"\" + r.GetString(t.idNum) + (t.kliNum == -1 ? "" : "_" + r.GetString(t.kliNum)) + ".rtf");
sw.Write(r.GetString(t.dokNum));
sw.Close();
logg1.Log("Hentet ut " + t.tableName + " med id " + r.GetString(t.idNum) + Environment.NewLine, Logg.LogType.Info);
Application.DoEvents();
logg1.Refresh();
}
}
}
catch (Exception ex) {
logg1.Log("Feil ved uthenting av " + t.tableName + ". Feilen var : " + ex.Message + Environment.NewLine, Logg.LogType.Info);
}
}
//Console.ReadKey();
}
public FirebirdDatabase()
{
DbType = DatabaseType.Firebird;
ProviderName = DatabaseType.Firebird.GetProviderName();
DBPath = Environment.CurrentDirectory;
#if RUN_ALL_TESTS
// Create one database for each test. Remember to delete after.
DBPath = Path.Combine(Path.GetTempPath(), "NPoco", "Fb");
if (!Directory.Exists(DBPath))
Directory.CreateDirectory(DBPath);
DBName = Guid.NewGuid().ToString();
#endif
DBFileName = DBName + ".fdb";
FQDBFile = DBPath + "\\" + DBFileName;
// ConnectionString Builder
FbConnectionStringBuilder csb = new FbConnectionStringBuilder();
csb.Database = FQDBFile;
csb.DataSource = "localhost";
csb.Dialect = 3;
csb.Charset = "UTF8";
csb.Pooling = false;
csb.Role = FbRole;
csb.UserID = FbUserName;
csb.Password = FbUserPass;
ConnectionString = csb.ToString();
RecreateDataBase();
EnsureSharedConnectionConfigured();
Console.WriteLine("Tables (Constructor): " + Environment.NewLine);
var dt = ((FbConnection)Connection).GetSchema("Tables", new[] { null, null, null, "TABLE" });
foreach (DataRow row in dt.Rows)
{
Console.WriteLine((string)row[2]);
}
}
public string BuildConnectionString()
{
FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
cs.UserID = ConfigurationManager.AppSettings["User"];
cs.Password = ConfigurationManager.AppSettings["Password"];
cs.Database = ConfigurationManager.AppSettings["Database"];
cs.DataSource = ConfigurationManager.AppSettings["DataSource"];
cs.Port = Int32.Parse(ConfigurationManager.AppSettings["Port"]);
cs.Charset = ConfigurationManager.AppSettings["Charset"];
cs.Pooling = false;
cs.ServerType = (FbServerType)Int32.Parse(ConfigurationManager.AppSettings["ServerType"]);
return cs.ToString();
}
public string BuildServicesConnectionString(bool includeDatabase)
{
FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
cs.DataSource = ConfigurationManager.AppSettings["DataSource"];
cs.UserID = ConfigurationManager.AppSettings["User"];
cs.Password = ConfigurationManager.AppSettings["Password"];
if (includeDatabase)
{
cs.Database = ConfigurationManager.AppSettings["Database"];
}
cs.ServerType = (FbServerType)Convert.ToInt32(ConfigurationManager.AppSettings["ServerType"]);
return cs.ToString();
}
public override void RecreateDataBase()
{
// ConnectionString Builder
FbConnectionStringBuilder csb = new FbConnectionStringBuilder();
csb.DataSource = "localhost";
csb.Dialect = 3;
csb.Charset = "UTF8";
csb.Pooling = false;
csb.UserID = "SYSDBA"; // default user
csb.Password = "******"; // default password
string serverConnectionString = csb.ToString();
csb.Database = csb.Database = FQDBFile;
string databaseConnectionString = csb.ToString();
Console.WriteLine("-------------------------");
Console.WriteLine("Using Firebird Database ");
Console.WriteLine("-------------------------");
base.RecreateDataBase();
// Create simple user
FbSecurity security = new FbSecurity();
security.ConnectionString = serverConnectionString;
var userData = security.DisplayUser(FbUserName);
if (userData == null)
{
userData = new FbUserData();
userData.UserName = FbUserName;
userData.UserPassword = FbUserPass;
security.AddUser(userData);
}
// Try to shutdown & delete database
if (File.Exists(FQDBFile))
{
FbConfiguration configuration = new FbConfiguration();
configuration.ConnectionString = databaseConnectionString;
try
{
configuration.DatabaseShutdown(FbShutdownMode.Forced, 0);
Thread.Sleep(1000);
}
finally
{
File.Delete(FQDBFile);
}
}
// Create the new DB
FbConnection.CreateDatabase(databaseConnectionString, 4096, true, true);
if (!File.Exists(FQDBFile)) throw new Exception("Database failed to create");
// Create the Schema
string script = @"
CREATE TABLE Users(
UserId integer PRIMARY KEY NOT NULL,
Name varchar(200),
Age integer,
DateOfBirth timestamp,
Savings decimal(10,5),
Is_Male smallint,
UniqueId char(38),
TimeSpan time,
TestEnum varchar(10),
HouseId integer,
SupervisorId integer
);
CREATE TABLE ExtraUserInfos(
ExtraUserInfoId integer PRIMARY KEY NOT NULL,
UserId integer NOT NULL,
Email varchar(200),
Children integer
);
CREATE TABLE Houses(
HouseId integer PRIMARY KEY NOT NULL,
Address varchar(200)
);
CREATE TABLE CompositeObjects(
Key1ID integer PRIMARY KEY NOT NULL,
Key2ID integer NOT NULL,
Key3ID integer NOT NULL,
TextData varchar(512),
DateEntered timestamp NOT NULL,
DateUpdated timestamp
);
CREATE GENERATOR USERS_USERID_GEN;
CREATE GENERATOR EXTRAUSERINFOS_ID_GEN;
CREATE GENERATOR HOUSES_HOUSEID_GEN;
SET TERM ^ ;
CREATE TRIGGER BI_USERS_USERID FOR USERS
ACTIVE BEFORE INSERT
POSITION 0
AS
BEGIN
IF (NEW.USERID IS NULL) THEN
NEW.USERID = GEN_ID(USERS_USERID_GEN, 1);
END^
CREATE TRIGGER BI_EXTRAUSERINFOS_ID1 FOR EXTRAUSERINFOS
ACTIVE BEFORE INSERT
POSITION 0
AS
BEGIN
IF (NEW.EXTRAUSERINFOID IS NULL) THEN
NEW.EXTRAUSERINFOID = GEN_ID(EXTRAUSERINFOS_ID_GEN, 1);
END^
CREATE TRIGGER BI_HOUSES_HOUSEID FOR HOUSES
ACTIVE BEFORE INSERT
POSITION 0
AS
BEGIN
IF (NEW.HOUSEID IS NULL) THEN
NEW.HOUSEID = GEN_ID(HOUSES_HOUSEID_GEN, 1);
END^
SET TERM ; ^
CREATE ROLE %role%;
GRANT SELECT, UPDATE, INSERT, DELETE ON Users TO ROLE %role%;
GRANT SELECT, UPDATE, INSERT, DELETE ON ExtraUserInfos TO ROLE %role%;
GRANT SELECT, UPDATE, INSERT, DELETE ON Houses TO ROLE %role%;
GRANT SELECT, UPDATE, INSERT, DELETE ON CompositeObjects TO ROLE %role%;
GRANT %role% TO %user%;
".Replace("%role%", FbRole).Replace("%user%", FbUserName);
/*
* Using new connection so that when a transaction is bound to Connection if it rolls back
* it doesn't blow away the tables
*/
using (var conn = new FbConnection(databaseConnectionString))
{
FbScript fbScript = new FbScript(script);
fbScript.Parse();
FbBatchExecution fbBatch = new FbBatchExecution(conn, fbScript);
fbBatch.Execute(true);
conn.Open();
Console.WriteLine("Tables (CreateDB): " + Environment.NewLine);
var dt = conn.GetSchema("Tables", new[] {null, null, null, "TABLE"});
foreach (DataRow row in dt.Rows)
{
Console.WriteLine(row[2]);
}
conn.Close();
}
}
public override void execute(Options options, INIManager iniManager)
{
string AppKey = iniManager.IniReadValue("APP", "AppKey");
string AppSecret = iniManager.IniReadValue("APP", "AppSecret");
string TaobaoAsistantPath = iniManager.IniReadValue("淘宝助理", "安装目录");
string nick = options.Nick;
string SessionKey = iniManager.IniReadValue(nick, "SessionKey");
string userId = iniManager.IniReadValue(nick, "UserId");
if (userId == null || userId.Trim().Equals(""))
{
userId = "1696293148";
}
StreamWriter MovePicLogWriter;
FileStream MovePicLog = new FileStream(Environment.CurrentDirectory + "\\" + "MovePic.log", FileMode.Append);
MovePicLogWriter = new StreamWriter(MovePicLog, Encoding.Default);
FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
cs.Database = Path.Combine(TaobaoAsistantPath, "users\\" + nick + "\\APPITEM.DAT");
cs.Charset = "UTF8";
cs.UserID = "SYSDBA";
cs.Password = "******";
cs.ServerType = FbServerType.Embedded;
FbConnection fbCon = new FbConnection(cs.ToString());
fbCon.Open();
FbCommand ItemsCommand = null;
if ("all".Equals(options.Item))
{
ItemsCommand = new FbCommand("SELECT * FROM ITEM WHERE NUM_IID IS NULL AND CLIENT_NAVIGATION_TYPE = 1 OR SYNC_STATUS <> 1", fbCon);
}
else
{
ItemsCommand = new FbCommand("SELECT * FROM ITEM WHERE OUTER_ID = @SearchString OR TITLE = @SearchString", fbCon);
FbParameter SearchString = new FbParameter("@SearchString", FbDbType.VarChar);
SearchString.Value = options.Item;
ItemsCommand.Parameters.Add(SearchString);
}
FbDataReader ItemsReader = ItemsCommand.ExecuteReader();
while (ItemsReader.Read())
{
Boolean mainallpass = true;
Boolean descallpass = true;
MovePicLogWriter.WriteLine("--------------------------------------------------------------------------------");
Console.WriteLine("--------------------------------------------------------------------------------");
string ClientID = ItemsReader["CLIENT_ID"].ToString();
string Title = ItemsReader["TITLE"].ToString();
Console.WriteLine("ClientID=" + ClientID);
MovePicLogWriter.WriteLine("ClientID=" + ClientID);
Console.WriteLine("TITLE=" + Title);
MovePicLogWriter.WriteLine("TITLE=" + Title);
if ("main".Equals(options.Scope) || "all".Equals(options.Scope))
{
FbCommand PicturesCommand = new FbCommand("SELECT * FROM PICTURE WHERE CLIENT_ITEMID = @ClientItemID", fbCon);
FbParameter ParamClientID = new FbParameter("@ClientItemID", FbDbType.VarChar);
ParamClientID.Value = ClientID;
PicturesCommand.Parameters.Add(ParamClientID);
FbDataReader PicturesReader = PicturesCommand.ExecuteReader();
while (PicturesReader.Read())
{
MovePicLogWriter.WriteLine("----------");
Console.WriteLine("----------");
string PicClientID = PicturesReader["CLIENT_ID"].ToString();
string Url = PicturesReader["URL"].ToString();
string ClientName = PicturesReader["CLIENT_NAME"].ToString();
Console.WriteLine("URL=" + Url);
MovePicLogWriter.WriteLine("URL=" + Url);
Console.WriteLine("图片本地ID=" + PicClientID);
MovePicLogWriter.WriteLine("图片本地ID=" + PicClientID);
Console.WriteLine("CLIENT_NAME=" + ClientName);
MovePicLogWriter.WriteLine("CLIENT_NAME=" + ClientName);
if ("reupload".Equals(options.Action))
{
if (Url != null && !Url.Equals(""))
{
List<Picture> pictures = ImagesUtil.getPictures(Url, AppKey, AppSecret, SessionKey, MovePicLogWriter);
if (pictures != null && pictures.Count > 0)
{
foreach (Picture picture in pictures)
{
Console.WriteLine(picture.PicturePath);
MovePicLogWriter.WriteLine(picture.PicturePath);
if (!picture.Status.Equals("pass"))
{
mainallpass = false;
Console.WriteLine("审核中");
MovePicLogWriter.WriteLine("审核中");
DateTime dt = Convert.ToDateTime(picture.Modified);
if (dt < DateTime.Now.AddDays(-3))
{
Console.WriteLine("过了3天重新上传");
MovePicLogWriter.WriteLine("过了3天重新上传");
ImagesUtil.reUploadImage(picture, AppKey, AppSecret, SessionKey, MovePicLogWriter);
}
else
{
Console.WriteLine("没有到3天再等一等");
MovePicLogWriter.WriteLine("没有到3天再等一等");
}
}
else
{
Console.WriteLine("排查通过");
MovePicLogWriter.WriteLine("排查通过");
}
}
}
else
{
mainallpass = false;
Console.WriteLine("图片不在图片空间 " + Url);
MovePicLogWriter.WriteLine("图片不在图片空间 " + Url);
string PicPath = ImagesUtil.uploadImage(Url, AppKey, AppSecret, SessionKey, MovePicLogWriter);
if (!PicPath.Equals(""))
{
FbTransaction myTransaction = fbCon.BeginTransaction();
Console.WriteLine("PicPath=" + PicPath);
MovePicLogWriter.WriteLine("PicPath=" + PicPath);
FbCommand UpdateUrlCommand = new FbCommand("UPDATE PICTURE SET URL = @Url WHERE CLIENT_ID = @ClientID", fbCon);
FbParameter ParamUrl = new FbParameter("@Url", FbDbType.VarChar);
ParamUrl.Value = PicPath;
FbParameter ParamID = new FbParameter("@ClientID", FbDbType.VarChar);
ParamID.Value = PicClientID;
UpdateUrlCommand.Parameters.Add(ParamUrl);
UpdateUrlCommand.Parameters.Add(ParamID);
UpdateUrlCommand.Transaction = myTransaction;
UpdateUrlCommand.ExecuteNonQuery();
myTransaction.Commit();
MovePicLogWriter.WriteLine(Url + " 被替换为\n" + PicPath);
Console.WriteLine(Url + " 被替换为\n" + PicPath);
Console.WriteLine("上传完成");
MovePicLogWriter.WriteLine("上传完成");
}
}
}
}
}
}
if ("desc".Equals(options.Scope) || "all".Equals(options.Scope))
{
ArrayList images = new ArrayList();
string Desc = ItemsReader["DESCRIPTION"].ToString();
string imgpattern = "http://[^\\s]*?((\\.jpg)|(\\.png)|(\\.gif)|(\\.bmp))";
Regex r = new Regex(imgpattern, RegexOptions.Compiled | RegexOptions.IgnoreCase);
Match m = r.Match(Desc);
while (m.Success)
{
System.Text.RegularExpressions.Group imageGroup = m.Groups[0];
images.Add(imageGroup.Value);
m = m.NextMatch();
}
foreach (string image in images)
{
MovePicLogWriter.WriteLine("----------");
Console.WriteLine("----------");
Console.WriteLine(image);
MovePicLogWriter.WriteLine(image);
if ("reupload".Equals(options.Action))
{
Console.WriteLine("检查图片状态");
MovePicLogWriter.WriteLine("检查图片状态");
List<Picture> pictures = ImagesUtil.getPictures(image, AppKey, AppSecret, SessionKey, MovePicLogWriter);
if (pictures != null && pictures.Count > 0)
{
foreach (Picture picture in pictures)
{
Console.WriteLine(picture.PicturePath);
MovePicLogWriter.WriteLine(picture.PicturePath);
if (!picture.Status.Equals("pass"))
{
descallpass = false;
Console.WriteLine("审核中");
MovePicLogWriter.WriteLine("审核中");
DateTime dt = Convert.ToDateTime(picture.Modified);
if (dt < DateTime.Now.AddDays(-3))
{
Console.WriteLine("过了3天重新上传");
MovePicLogWriter.WriteLine("过了3天重新上传");
bool done = ImagesUtil.reUploadImage(picture, AppKey, AppSecret, SessionKey, MovePicLogWriter);
if (!done)
{
if (options.Prune)
{
Desc = Desc.Replace(picture.PicturePath, "");
}
}
}
else
{
Console.WriteLine("没有到3天再等一等");
MovePicLogWriter.WriteLine("没有到3天再等一等");
}
}
else
{
Console.WriteLine("排查通过");
MovePicLogWriter.WriteLine("排查通过");
}
}
}
else
{
descallpass = false;
Console.WriteLine("图片不在图片空间");
MovePicLogWriter.WriteLine("图片不在图片空间");
string PicPath = ImagesUtil.uploadImage(image, AppKey, AppSecret, SessionKey, MovePicLogWriter);
if (PicPath.Equals(""))
{
if (options.Prune)
{
Desc = Desc.Replace(image, PicPath);
}
}
else
{
Desc = Desc.Replace(image, PicPath);
}
}
}
}
ArrayList localImages = new ArrayList();
string localImgPattern = @"[a-zA-Z]{1}\:[\\/][^\s]*?（(\.jpg)|(\.png)|(\.gif)|(\.bmp)）";
Regex r2 = new Regex(localImgPattern, RegexOptions.Compiled | RegexOptions.IgnoreCase);
Match m2 = r2.Match(Desc);
while (m2.Success)
{
System.Text.RegularExpressions.Group imageGroup = m2.Groups[0];
localImages.Add(imageGroup.Value);
m2 = m2.NextMatch();
}
foreach (string localImage in localImages)
{
MovePicLogWriter.WriteLine("----------");
Console.WriteLine("----------");
string PicPath = "";
if (System.IO.File.Exists(localImage))
{
PicPath = ImagesUtil.uploadLocalImage(localImage, AppKey, AppSecret, SessionKey, MovePicLogWriter);
}
else
{
MovePicLogWriter.WriteLine(localImage + " 不存在。");
Console.WriteLine(localImage + " 不存在。");
}
if (PicPath.Equals(""))
{
if (options.Prune)
{
Desc = Desc.Replace(localImage, PicPath);
}
}
else
{
Desc = Desc.Replace(localImage, PicPath);
}
}
FbTransaction myTransaction = fbCon.BeginTransaction();
FbCommand UpdateDescCommand = new FbCommand("UPDATE ITEM SET DESCRIPTION = @Desc WHERE CLIENT_ID = @ClientID", fbCon);
FbParameter ParamID = new FbParameter("@ClientID", FbDbType.VarChar);
ParamID.Value = ClientID;
FbParameter ParamDesc = new FbParameter("@Desc", FbDbType.Text);
ParamDesc.Value = Desc;
UpdateDescCommand.Parameters.Add(ParamID);
UpdateDescCommand.Parameters.Add(ParamDesc);
UpdateDescCommand.Transaction = myTransaction;
UpdateDescCommand.ExecuteNonQuery();
myTransaction.Commit();
}
if (mainallpass && descallpass)
{
FbTransaction myTransaction = fbCon.BeginTransaction();
FbCommand UpdateSyncStatusCommand = new FbCommand("UPDATE ITEM SET SYNC_STATUS = 2, UPLOAD_FAIL_MSG ='所有图片审核通过,可以上传了。' WHERE CLIENT_ID = @ClientID", fbCon);
FbParameter ParamID = new FbParameter("@ClientID", FbDbType.VarChar);
ParamID.Value = ClientID;
UpdateSyncStatusCommand.Parameters.Add(ParamID);
UpdateSyncStatusCommand.Transaction = myTransaction;
UpdateSyncStatusCommand.ExecuteNonQuery();
myTransaction.Commit();
Console.WriteLine("所有图片审核通过");
MovePicLogWriter.WriteLine("所有图片审核通过");
}
else
{
FbTransaction myTransaction = fbCon.BeginTransaction();
FbCommand UpdateSyncStatusCommand = new FbCommand("UPDATE ITEM SET SYNC_STATUS = 4, UPLOAD_FAIL_MSG ='有图片等待审核。' WHERE CLIENT_ID = @ClientID", fbCon);
FbParameter ParamID = new FbParameter("@ClientID", FbDbType.VarChar);
ParamID.Value = ClientID;
UpdateSyncStatusCommand.Parameters.Add(ParamID);
UpdateSyncStatusCommand.Transaction = myTransaction;
UpdateSyncStatusCommand.ExecuteNonQuery();
myTransaction.Commit();
Console.WriteLine("==========>图片审核中");
MovePicLogWriter.WriteLine("==========>图片审核中");
}
Console.WriteLine("");
MovePicLogWriter.WriteLine("");
}
fbCon.Close();
MovePicLogWriter.Close();
MovePicLog.Close();
}
/// <summary>
/// Constructor for talking to an embedded firebird database.
/// </summary>
/// <param name="databasePath">Path to the db file.</param>
public FirebirdDescriptor(string databasePath)
{
if (!StringHelper.IsNonBlank(databasePath))
{
throw new ArgumentNullException("databasePath", "Database file path cannot be null/blank.");
}
FbConnectionStringBuilder builder = new FbConnectionStringBuilder();
builder.Database = Database = databasePath;
builder.ServerType = FbServerType.Embedded;
// For the embedded server, we want to disable pooling so we don't wind up locking
// the file indefinitely.
builder.Pooling = false;
_usePooling = false;
// There is no password, so the strings are the same.
_cleanConnStr = builder.ToString();
_connectionStr = builder.ToString();
}
/// <summary>
/// Constructor for talking to a server-based firebird database.
/// </summary>
/// <param name="server">Server name or IP. May not be null.</param>
/// <param name="database">Database name on that server. May not be null.</param>
/// <param name="user">Database user name, may be null.</param>
/// <param name="password">Plain text password for the user.
/// May be null.</param>
public FirebirdDescriptor(string server, string database,
string user, string password)
{
if (!StringHelper.IsNonBlank(server))
{
throw new ArgumentNullException("server", "Server parameter cannot be null/blank.");
}
if (!StringHelper.IsNonBlank(database))
{
throw new ArgumentNullException("database", "Database name parameter cannot be null/blank.");
}
FbConnectionStringBuilder builder = new FbConnectionStringBuilder();
builder.DataSource = Server = server;
builder.Database = Database = database;
builder.UserID = User = user;
// First make it without a password.
_cleanConnStr = builder.ToString();
// Now with the password for the real one.
Password = password;
builder.Password = Password;
_connectionStr = builder.ToString();
}
public override void ChangeDatabase(string db)
{
#if (!NET_CF)
lock (this)
{
this.CheckClosed();
if (string.IsNullOrEmpty(db))
{
throw new InvalidOperationException("Database name is not valid.");
}
string cs = this.connectionString;
try
{
FbConnectionStringBuilder csb = new FbConnectionStringBuilder(this.connectionString);
/* Close current connection */
this.Close();
/* Set up the new Database */
csb.Database = db;
this.ConnectionString = csb.ToString();
/* Open new connection */
this.Open();
}
catch (IscException ex)
{
this.ConnectionString = cs;
throw new FbException(ex.Message, ex);
}
}
#endif
}
private void btnSync_Click(object sender, EventArgs e)
{
try
{
if (txtPath.Text.Split('@').Length == 2)
{
FbConnectionStringBuilder cnString = new FbConnectionStringBuilder();
cnString.DataSource = txtPath.Text.Split('@')[0];
cnString.Database = txtPath.Text.Split('@')[1];
cnString.UserID = "SYSDBA";
cnString.Password = "******";
cnString.Charset = "win1251";
cnString.Dialect = 3;
using (FbConnection cn = new FbConnection(cnString.ToString()))
{
cn.Open();
FbCommand cmd = new FbCommand("SELECT SESSIONS.ID FROM SESSIONS", cn);
FbDataAdapter da = new FbDataAdapter(cmd);
DataTable tbl = new DataTable();
da.Fill(tbl);
string query = "";
using (FbCommand cmd_o = new FbCommand())
{
cmd_o.Connection = cn;
cmd_o.CommandTimeout = 9000;
query = "CREATE TABLE SESSIONS_OK (ID INTEGER);";
cmd_o.CommandText = query;
try
{
cmd_o.ExecuteNonQuery();
}
catch { }
query = "DELETE FROM SESSIONS_OK;\n";
cmd_o.CommandText = query;
cmd_o.ExecuteNonQuery();
for (int i = 0; i < tbl.Rows.Count; i++)
{
query = "INSERT INTO SESSIONS_OK\n" +
"\t(SESSIONS_OK.ID)\n" +
"\tVALUES \n" +
"\t(" + tbl.Rows[i]["ID"].ToString() + ");\n";
cmd_o.CommandText = query;
cmd_o.ExecuteNonQuery();
}
}
MessageBox.Show("ok");
}
}
else
{
MessageBox.Show("Не верный формат строки!");
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message + "\n" + ex.Source);
}
}
static void Main(string[] args)
{
if (args.Length < 1)
{
return;
}
string SELLER_NICK = args[0];
INIManager IniManager = new INIManager(Environment.CurrentDirectory + "\\" + "TradeAsist.ini");
string TaobaoAsistantPath = IniManager.IniReadValue("淘宝助理", "路径");
if (!TaobaoAsistantPath.Substring(TaobaoAsistantPath.Length - 1).Equals("\\"))
{
TaobaoAsistantPath = TaobaoAsistantPath + "\\";
}
Console.WriteLine(TaobaoAsistantPath);
string WDGJ_IP = IniManager.IniReadValue("管家数据库", "IP");
string WDGJ_USER = IniManager.IniReadValue("管家数据库", "USER");
string WDGJ_PASSWORD = IniManager.IniReadValue("管家数据库", "PASSWORD");
string WDGJ_DATABASE = IniManager.IniReadValue("管家数据库", "DATABASE");
FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
cs.Database = TaobaoAsistantPath + "users\\" + SELLER_NICK + "\\APPTRADE.DAT";
cs.UserID = "SYSDBA";
cs.Password = "******";
cs.ServerType = FbServerType.Embedded;
FbConnection fbCon = new FbConnection(cs.ToString());
fbCon.Open();
SqlConnectionStringBuilder builder = new SqlConnectionStringBuilder();
builder["server"] = WDGJ_IP;
builder["uid"] = WDGJ_USER;
builder["pwd"] = WDGJ_PASSWORD;
builder["database"] = WDGJ_DATABASE;
string sqlConnectionString = builder.ToString();
SqlConnection sqlCon1 = new SqlConnection(sqlConnectionString);
sqlCon1.Open();
SqlConnection sqlCon2 = new SqlConnection(sqlConnectionString);
sqlCon2.Open();
SqlCommand cmd = new SqlCommand("SELECT * FROM G_TRADE_TRADELIST WHERE TRADESTATUS = 2", sqlCon1);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
string TradeID = reader["TradeID"].ToString();
string TradeNO2 = reader["TradeNO2"].ToString();
if (TradeNO2 == null || TradeNO2.Equals(""))
{
continue;
}
string[] tradeNO = TradeNO2.Split(',');
TradeNO2 = tradeNO[0];
string TradeNick = reader["TradeNick"].ToString();
string SndTo = reader["SndTo"].ToString();
string Adr = reader["Adr"].ToString();
string Tel = reader["Tel"].ToString();
string sqlTrade = "SELECT * FROM TRADE WHERE TID = " + TradeNO2;
FbCommand cmdTrade = new FbCommand(sqlTrade, fbCon);
FbDataReader fbReader = cmdTrade.ExecuteReader();
if (fbReader.Read())
{
string TID = fbReader["TID"].ToString();
string BUYER_NICK = fbReader["BUYER_NICK"].ToString();
string RECEIVER_NAME = fbReader["RECEIVER_NAME"].ToString();
string RECEIVER_STATE = fbReader["RECEIVER_STATE"].ToString();
string RECEIVER_CITY = fbReader["RECEIVER_CITY"].ToString();
string RECEIVER_DISTRICT = fbReader["RECEIVER_DISTRICT"].ToString();
string RECEIVER_ADDRESS = fbReader["RECEIVER_ADDRESS"].ToString();
string RECEIVER_MOBILE = fbReader["RECEIVER_MOBILE"].ToString();
string RECEIVER_PHONE = fbReader["RECEIVER_PHONE"].ToString();
Console.WriteLine(TID + " " + BUYER_NICK + " " + RECEIVER_NAME + " " + RECEIVER_STATE + " " + RECEIVER_CITY + " " + RECEIVER_DISTRICT + " " + RECEIVER_ADDRESS + " " + RECEIVER_MOBILE + " " + RECEIVER_PHONE);
Console.WriteLine();
string updateAdrSql = "UPDATE G_TRADE_TRADELIST SET SndTo = @SndTo, Adr = @Adr, Tel = @Tel WHERE TradeID = " + TradeID;
SqlParameter paraSndTo = new SqlParameter("@SndTo", SqlDbType.NVarChar);
paraSndTo.Value = RECEIVER_NAME;
SqlParameter paraAdr = new SqlParameter("@Adr", SqlDbType.NVarChar);
paraAdr.Value = RECEIVER_STATE + " " + RECEIVER_CITY + " " + RECEIVER_DISTRICT + " " + RECEIVER_ADDRESS;
SqlParameter paraTel = new SqlParameter("@Tel", SqlDbType.NVarChar);
paraTel.Value = RECEIVER_MOBILE + " " + RECEIVER_PHONE;
SqlTransaction transaction = sqlCon2.BeginTransaction();
SqlCommand updateAdr = new SqlCommand(updateAdrSql, sqlCon2);
updateAdr.Parameters.Add(paraSndTo);
updateAdr.Parameters.Add(paraAdr);
updateAdr.Parameters.Add(paraTel);
updateAdr.Transaction = transaction;
updateAdr.ExecuteNonQuery();
transaction.Commit();
}
}
sqlCon1.Close();
sqlCon2.Close();
fbCon.Close();
}
public void FbConnectionStringBuilderTest()
{
FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
cs.DataSource = ConfigurationManager.AppSettings["DataSource"];
cs.Database = ConfigurationManager.AppSettings["Database"];
cs.Port = Convert.ToInt32(ConfigurationManager.AppSettings["Port"]);
cs.UserID = ConfigurationManager.AppSettings["User"];
cs.Password = ConfigurationManager.AppSettings["Password"];
cs.ServerType = (FbServerType)Convert.ToInt32(ConfigurationManager.AppSettings["ServerType"]);
cs.Charset = ConfigurationManager.AppSettings["Charset"];
cs.Pooling = Convert.ToBoolean(ConfigurationManager.AppSettings["Pooling"]);
using (FbConnection c = new FbConnection(cs.ToString()))
{
c.Open();
}
}
public void FbConnectionStringBuilderTest()
{
FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
cs.DataSource = TestsSetup.DataSource;
cs.Database = TestsSetup.Database;
cs.Port = TestsSetup.Port;
cs.UserID = TestsSetup.UserID;
cs.Password = TestsSetup.Password;
cs.ServerType = this.FbServerType;
cs.Charset = TestsSetup.Charset;
cs.Pooling = TestsSetup.Pooling;
Assert.DoesNotThrow(() =>
{
using (FbConnection c = new FbConnection(cs.ToString()))
{
c.Open();
}
});
}
public static string BuildServicesConnectionString(FbServerType serverType, bool includeDatabase)
{
FbConnectionStringBuilder cs = new FbConnectionStringBuilder();
cs.UserID = TestsSetup.UserID;
cs.Password = TestsSetup.Password;
cs.DataSource = TestsSetup.DataSource;
if (includeDatabase)
{
cs.Database = TestsSetup.Database;
}
cs.ServerType = serverType;
return cs.ToString();
}
/// <summary>
/// This constructor reads all the appropriate values from our standard config file
/// in the normal format.
/// </summary>
/// <param name="config">Config to get params from.</param>
/// <param name="component">Section of the config XML to look in for db params.</param>
/// <param name="decryptionDelegate">Delegate to call to decrypt password fields.
/// May be null if passwords are in plain text.</param>
public FirebirdDescriptor(Config config, string component,
ConnectionInfoDecryptionDelegate decryptionDelegate)
{
FbConnectionStringBuilder builder = new FbConnectionStringBuilder();
Server = config.GetParameter(component, "Server", null);
if (StringHelper.IsNonBlank(Server))
{
builder.DataSource = Server;
}
else
{
builder.ServerType = FbServerType.Embedded;
// For the embedded server, we want to disable pooling so we don't wind up locking
// the file indefinitely.
builder.Pooling = false;
_usePooling = false;
}
builder.Database = Database = config.GetParameterWithSubstitution(component, "Database", true);
builder.UserID = User = config.GetParameter(component, "User", null);
// First make it without a password.
_cleanConnStr = builder.ToString();
// Now with the password for the real one.
Password = GetDecryptedConfigParameter(config, component, "Password", decryptionDelegate);
builder.Password = Password;
_connectionStr = builder.ToString();
}
