void Start()
{
try
{
MySqlDB mysql = new MySqlDB();
//mysql.CreateTableAutoID("momo",new string[]{"id","name","qq","email","blog"}, new string[]{"int","text","text","text","text"});
//mysql.InsertInto("momo",new string[]{"name","qq","email","blog"},new string[]{"xuanyusong","289187120","*****@*****.**","xuanyusong.com"});
//mysql.InsertInto("momo",new string[]{"name","qq","email","blog"},new string[]{"ruoruo","34546546","*****@*****.**","xuanyusong.com"});
//DataSet ds = mysql.SelectWhere("momo",new string[]{"name","qq"},new string []{"id"},new string []{"="},new string []{"1"});
DataTable dt = mysql.SelectLimitLines("momo",0,100);
if(dt != null)
{
foreach (DataRow row in dt.Rows)
{
foreach (DataColumn column in dt.Columns)
{
Debug.Log(row[column]);
}
}
}
//mysql.UpdateInto("momo",new string[]{"name","qq"},new string[]{"'ruoruo'","'11111111'"}, "email", "'*****@*****.**'" );
//mysql.Delete("momo",new string[]{"id","email"}, new string[]{"1","'*****@*****.**'"} );
mysql.Close();
}catch(Exception e)
{
Error = e.Message;
}
}
public AvitoLoadImageDeferentSize(IHttpWeb httpweb, string pathFolder, MySqlDB _mySqlDB, string _ftpUsername, string _ftpPassword, ImageParsedCountHelper imageParsed)
: base(httpweb, pathFolder, imageParsed)
{
mySqlDB = _mySqlDB;
ftpUsername = _ftpUsername;
ftpPassword = _ftpPassword;
imageLoader = new ImageLoader(PathToFolder, ftpUsername, ftpPassword);
}
public EbayLoadImage(IHttpWeb httpweb, string pathFolder, MySqlDB _mySqlDB, string _ftpUsername, string _ftpPassword)
{
PathToFolder = pathFolder;
web = httpweb;
mySqlDB = _mySqlDB;
ftpUsername = _ftpUsername;
ftpPassword = _ftpPassword;
imageLoader = new ImageLoader(PathToFolder, ftpUsername, ftpPassword);
}
void Start()
{
Application.runInBackground = true;
//Screen.SetResolution(804, 673, false);
mysqldb = new MySqlDB();
DataTable dt = mysqldb.SelectLimitLines(tableName, startLine, 1);
linesPerFrame = int.Parse(dt.Rows[0][1].ToString());
startLine++;
InvokeRepeating("ReadOneFrameFromMySql", 0f, interval);
}
public void AddRecruitedToProject(int projekt_index)
{
MySqlDB mySql = new MySqlDB();
string command = "SELECT * FROM projekt_jelolt_kapcs WHERE jelolt_id = " + data.id + " AND projekt_id = " + projekt_index + "";
if (!mySql.IsExists(command))
{
mySql.Close();
command = "INSERT INTO projekt_jelolt_kapcs_kulsos (id, projekt_id, jelolt_id, datum) VALUES (NULL, " + projekt_index + ", " + data.id + ", '" + DateTime.Now.ToString("yyyy.MM.dd") + "' );";
mySql.Execute(command);
}
mySql.Close();
}
public static void Insert(ModelInsertProject data) // javított newprojectpanel
{
MySqlDB mySql = new MySqlDB();
string command = "INSERT INTO projektek (`id`, `hr_id`, `megnevezes_projekt`, `pc`, `vegzettseg`, `tapasztalat_ev`, `statusz`, `fel_datum`, `le_datum`, `nyelvtudas`, `munkakor`, `szuldatum`, `ber`, `kepesseg1`, `kepesseg2`, `kepesseg3`, `kepesseg4`, `kepesseg5`, `feladatok`, `elvarasok`, `kinalunk`)" +
" VALUES (NULL, " + data.hr_id + ", '" + data.megnevezes_projekt + "'," + data.pc + "," + data.vegzettseg + "," + data.tapasztalat_ev + "," + data.statusz + ",'" + data.fel_datum + "','" + data.le_datum + "'," + data.nyelvtudas + "," + data.munkakor + "," + data.szuldatum + "," + data.ber + "," + data.kepesseg1 + "," + data.kepesseg2 + "," + data.kepesseg3 + "," + data.kepesseg4 + "," + data.kepesseg5 + ",'" + data.feladatok + "','" + data.elvarasok + "','" + data.kinalunk + "');";
mySql.Execute(command);
int proID = Convert.ToInt16(mySql.UniqueList("SELECT projektek.id FROM projektek WHERE projektek.megnevezes_projekt = '" + data.megnevezes_projekt + "' AND projektek.pc = " + data.pc + " AND projektek.munkakor = '" + data.munkakor + "'", "projektek", 1)[0]);
Session.ProjektID = proID;
command = "INSERT INTO`projekt_ertesitendok_kapcs` (projekt_id,ertesitendok_id) VALUES(" + proID + "," + Session.UserData.id + ")";
mySql.Execute(command);
mySql.Close();
}
static void Main(string[] args)
{
MySqlDB mySqlDB = new MySqlDB();
var table = mySqlDB.Select();
int id = 4;
string first = "leggo";
string last = "Naija";
string email = "*****@*****.**";
int phone = 08902445;
string passw = "jamess";
mySqlDB.Insert(first, last, email, phone, passw);
Console.ReadKey();
}
public static void AcceptRecruited(ModelFreelancerApplicant applicant) //javított használja: applicantlist
{
List <ModelProjektJeloltKapcs> kapcsolatok = ModelProjektJeloltKapcs.Get("SELECT * FROM projekt_jelolt_kapcs_kulsos WHERE jelolt_id = " + applicant.id + "");
MySqlDB mySql = new MySqlDB();
string command = "UPDATE jeloltek SET ervenyes = 1, friss = false WHERE id = " + applicant.id + ";";
mySql.Execute(command);
foreach (var item in kapcsolatok)
{
command = "INSERT INTO projekt_jelolt_kapcs (id, projekt_id, jelolt_id, hr_id,allapota, datum) VALUES (NULL, " + item.projekt_id + ", " + item.jelolt_id + ", " + Session.UserData.id + ",4, '" + DateTime.Now.ToString("yyyy.MM.dd") + "' );";
mySql.Execute(command);
}
command = "DELETE FROM projekt_jelolt_kapcs_kulsos WHERE projekt_jelolt_kapcs_kulsos.jelolt_id = " + applicant.id + ";";
mySql.Execute(command);
}
public static List <ModelFullApplicant> GetModelFullApplicant(string command)
{
List <ModelFullApplicant> list = new List <ModelFullApplicant>();
MySqlDB mySql = new MySqlDB();
if (mySql.Open() == true)
{
mySql.cmd = new MySqlCommand(command, mySql.conn);
mySql.sdr = mySql.cmd.ExecuteReader();
while (mySql.sdr.Read())
{
list.Add(new ModelFullApplicant
{
id = Convert.ToInt32(mySql.sdr["id"]),
nev = mySql.sdr["nev"].ToString(),
email = mySql.sdr["email"].ToString(),
telefon = mySql.sdr["telefon"].ToString(),
lakhely = mySql.sdr["lakhely"].ToString(),
ertesult = mySql.sdr["ertesules_megnevezes"].ToString(),
id_ertesult = Convert.ToInt32(mySql.sdr["id_ertesult"]),
szuldatum = Convert.ToInt32(mySql.sdr["szuldatum"]),
neme = mySql.sdr["neme"].ToString(),
id_neme = Convert.ToInt32(mySql.sdr["id_neme"]),
tapasztalat_ev = Convert.ToInt32(mySql.sdr["tapasztalat_ev"]),
munkakor = mySql.sdr["munkakor"].ToString(),
munkakor2 = mySql.sdr["munkakor2"].ToString(),
munkakor3 = mySql.sdr["munkakor3"].ToString(),
id_munkakor = Convert.ToInt32(mySql.sdr["id_munkakor"]),
id_munkakor2 = Convert.ToInt32(mySql.sdr["id_munkakor2"]),
id_munkakor3 = Convert.ToInt32(mySql.sdr["id_munkakor3"]),
vegz_terulet = mySql.sdr["vegz_terulet"].ToString(),
id_vegz_terulet = Convert.ToInt32(mySql.sdr["id_vegz_terulet"]),
nyelvtudas = mySql.sdr["nyelvtudas"].ToString(),
nyelvtudas2 = mySql.sdr["nyelvtudas2"].ToString(),
id_nyelvtudas = Convert.ToInt32(mySql.sdr["id_nyelvtudas"]),
id_nyelvtudas2 = Convert.ToInt32(mySql.sdr["id_nyelvtudas2"]),
kategoria = Convert.ToInt32(mySql.sdr["kategoria"]),
statusz = Convert.ToInt32(mySql.sdr["statusz"]),
reg_date = mySql.sdr["reg_date"].ToString(),
megjegyzes = mySql.sdr["megjegyzes"].ToString(),
folderUrl = mySql.sdr["folderUrl"].ToString(),
});
}
mySql.sdr.Close();
}
mySql.Close();
return(list);
}
public static List <ModelUserData> GetUserSession(string command)
{
MySqlDB mySql = new MySqlDB();
List <ModelUserData> list = new List <ModelUserData>();
if (mySql.Open() == true)
{
mySql.cmd = new MySqlCommand(command, mySql.conn);
mySql.sdr = mySql.cmd.ExecuteReader();
while (mySql.sdr.Read())
{
string kategoriaSeged;
switch (Convert.ToInt32(mySql.sdr["kategoria"]))
{
case 2:
kategoriaSeged = Kategoria.Admin.ToString();
break;
case 1:
kategoriaSeged = Kategoria.HR.ToString();
break;
case 0:
default:
kategoriaSeged = Kategoria.Szakmai.ToString();
break;
}
list.Add(new ModelUserData
{
id = Convert.ToInt32(mySql.sdr["id"]),
username = mySql.sdr["username"].ToString(),
name = mySql.sdr["name"].ToString(),
email = mySql.sdr["email"].ToString(),
kategoria = Convert.ToInt32(mySql.sdr["kategoria"]),
kategoriaMegnevezes = kategoriaSeged,
jogosultsag = Convert.ToInt32(mySql.sdr["jogosultsag"]),
validitas = Convert.ToInt32(mySql.sdr["validitas"]),
validitasBool = Convert.ToBoolean(mySql.sdr["validitas"]),
belepve = mySql.sdr["belepve"].ToString(),
reg_datum = mySql.sdr["reg_datum"].ToString(),
});
}
mySql.sdr.Close();
}
mySql.Close();
return(list);
}
public void projectArchiver(int id, int statusz) // javított
{
MySqlDB mySql = new MySqlDB();
if (statusz == 0)
{
statusz = 1;
}
else
{
statusz = 0;
}
string command = "UPDATE projektek SET statusz=" + statusz + " WHERE projektek.id = " + id + ";";
mySql.Execute(command);
mySql.Close();
}
public void ActionExcel(FileExcelDatas exceldatas, string cellgs, string useStr, bool inDB, Action <string> show)
{
try
{
StringBuilder builder = new StringBuilder();
if (inDB)
{
builder.AppendLine("USE " + useStr + ";");
}
CreateTableHeadInster(builder, exceldatas, cellgs, useStr, inDB, show);
CreateTableRowInster(builder, exceldatas, cellgs, useStr, inDB, show);
if (inDB)
{
try
{
MySqlDB.Instance().ReMySqlConnection();
int count = MySqlDB.Instance().ExecuteNonQuery(builder.ToString());
show("写入数据 影响行数 " + count);
}
catch (Exception ex)
{
show("数据库操作失败：" + ex.ToString());
return;
}
finally
{
try
{
MySqlDB.Instance().Close();
}
catch (Exception ex)
{
show("数据库关闭错误：" + ex.ToString());
}
}
}
else
{
CreateClassFile("mysql", builder.ToString());
}
}
catch (Exception ex)
{
show("请仔细检查配置表 错误信息：" + ex.ToString());
}
}
public static void FirstOpen(int applicantId)
{
MySqlDB mySql = new MySqlDB();
string command = "UPDATE jeloltek SET friss = false WHERE id = " + applicantId + ";";
mySql.Execute(command);
mySql.Close();
try
{
Applicant applicant = new Applicant(applicantId);
new Email().Send(applicant.data.email, new EmailTemplate().Udvozlo_Email(applicant.data.nev));
}
catch (Exception)
{
throw;
}
}
public static string GetSavedUser()
{
string user;
try
{
user = SqLite.Query("select username from app");
}
catch (Exception)
{
SqLite.Update("CREATE TABLE IF NOT EXISTS 'app' ('username' TEXT);");
user = SqLite.Query("SELECT 'username' FROM 'app';");
}
MySqlDB mySql = new MySqlDB();
mySql.Close();
return(user);
}
public static bool Authentication(string username)
{
MySqlDB mySql = new MySqlDB();
if (mySql.Bind("SELECT count(id) FROM users WHERE username='******' AND validitas = 1"))
{
Session.UserData = UserData.GetOwnDatas();
DateTime dateTime = DateTime.Now;
mySql.Execute("UPDATE users SET belepve = '" + dateTime.ToString("yyyy.MM.dd") + "' WHERE username = '******';");
mySql.Close();
return(true);
}
else
{
mySql.Close();
}
return(false);
}
async public static Task <bool> AddFile(string fileName, string fileType)
{
bool result = false;
try
{
MySqlParameter[] parameters = new MySqlParameter[]
{
new MySqlParameter(ParameterNames.NAME, fileName),
new MySqlParameter(ParameterNames.TYPE, fileType),
};
result = await MySqlDB.SetQueryAsync(conStr : _conStr, query : INSERT_FILE, parameters : parameters).ConfigureAwait(false);
}
catch (Exception)
{
throw;
}
return(result);
}
public static List <ModelStatusz> GetModelStatusz(string command)
{
MySqlDB mySql = new MySqlDB();
List <ModelStatusz> list = new List <ModelStatusz>();
if (mySql.Open() == true)
{
mySql.cmd = new MySqlCommand(command, mySql.conn);
mySql.sdr = mySql.cmd.ExecuteReader();
while (mySql.sdr.Read())
{
list.Add(new ModelStatusz
{
id = Convert.ToInt32(mySql.sdr["id"]),
allapot = mySql.sdr["allapot"].ToString(),
});
}
mySql.sdr.Close();
}
mySql.Close();
return(list);
}
public static List <ModelErtesulesek> GetModelErtesulesek(string command)
{
MySqlDB mySql = new MySqlDB();
List <ModelErtesulesek> list = new List <ModelErtesulesek>();
if (mySql.Open() == true)
{
mySql.cmd = new MySqlCommand(command, mySql.conn);
mySql.sdr = mySql.cmd.ExecuteReader();
while (mySql.sdr.Read())
{
list.Add(new ModelErtesulesek
{
id = Convert.ToInt32(mySql.sdr["id"]),
ertesules_megnevezes = mySql.sdr["ertesules_megnevezes"].ToString(),
});
}
mySql.sdr.Close();
}
mySql.Close();
return(list);
}
public static List <ModelNyelv> GetModelNyelv(string query)
{
MySqlDB mySql = new MySqlDB();
List <ModelNyelv> items = new List <ModelNyelv>();
if (mySql.Open() == true)
{
mySql.cmd = new MySqlCommand(query, mySql.conn);
mySql.sdr = mySql.cmd.ExecuteReader();
while (mySql.sdr.Read())
{
items.Add(new ModelNyelv
{
id = Convert.ToInt32(mySql.sdr["id"]),
nyelv = mySql.sdr["megnevezes_nyelv"].ToString(),
});
}
mySql.sdr.Close();
}
mySql.Close();
return(items);
}
public static List <ModelVegzettseg> GetModelVegzettseg(string command)
{
MySqlDB mySql = new MySqlDB();
List <ModelVegzettseg> list = new List <ModelVegzettseg>();
if (mySql.Open() == true)
{
mySql.cmd = new MySqlCommand(command, mySql.conn);
mySql.sdr = mySql.cmd.ExecuteReader();
while (mySql.sdr.Read())
{
list.Add(new ModelVegzettseg
{
id = Convert.ToInt32(mySql.sdr["id"]),
megnevezes_vegzettseg = mySql.sdr["megnevezes_vegzettseg"].ToString(),
});
}
mySql.sdr.Close();
}
mySql.Close();
return(list);
}
public static List <ModelApplicantListbox> GetModelApplicantListboxShort(string command)
{
List <ModelApplicantListbox> list = new List <ModelApplicantListbox>();
MySqlDB mySql = new MySqlDB();
if (mySql.Open() == true)
{
mySql.cmd = new MySqlCommand(command, mySql.conn);
mySql.sdr = mySql.cmd.ExecuteReader();
while (mySql.sdr.Read())
{
list.Add(new ModelApplicantListbox
{
id = Convert.ToInt32(mySql.sdr["id"]),
nev = mySql.sdr["nev"].ToString(),
});
}
mySql.sdr.Close();
}
mySql.Close();
return(list);
}
public static void Delete(int id) // javított
{
MySqlDB mySql = new MySqlDB();
string command;
command = "DELETE FROM projektek WHERE projektek.id = " + id + ";";
mySql.Execute(command);
command = "DELETE FROM projekt_jelolt_kapcs WHERE projekt_jelolt_kapcs.projekt_id = " + id + ";";
mySql.Execute(command);
command = "DELETE FROM projekt_hr_kapcs WHERE projekt_hr_kapcs.projekt_id = " + id + ";";
mySql.Execute(command);
command = "DELETE FROM projekt_ertesitendok_kapcs WHERE projekt_ertesitendok_kapcs.projekt_id = " + id + ";";
mySql.Execute(command);
command = "DELETE FROM megjegyzesek WHERE megjegyzesek.projekt_id = " + id + ";";
mySql.Execute(command);
command = "DELETE FROM interview WHERE interview.projekt_id = " + id + ";";
mySql.Execute(command);
command = "DELETE FROM projekt_koltsegek WHERE projekt_koltsegek.projekt_id = " + id + ";";
mySql.Execute(command);
command = "DELETE FROM interview WHERE interview.projekt_id=" + id + " AND hr_id=" + Session.UserData.id + "";
mySql.Execute(command);
mySql.Close();
}
public static List <ModelFreelancerList> getFreelancerList(string command)
{
MySqlDB mySql = new MySqlDB();
List <ModelFreelancerList> list = new List <ModelFreelancerList>();
if (mySql.Open() == true)
{
mySql.cmd = new MySqlCommand(command, mySql.conn);
mySql.sdr = mySql.cmd.ExecuteReader();
while (mySql.sdr.Read())
{
list.Add(new ModelFreelancerList
{
id = Convert.ToInt32(mySql.sdr["id"]),
name = mySql.sdr["name"].ToString(),
rid = mySql.sdr["rid"].ToString(),
email = mySql.sdr["email"].ToString()
});
}
mySql.sdr.Close();
}
return(list);
}
public static List <ModelProjectList> GetModelProjectList(string command)
{
MySqlDB mySql = new MySqlDB();
List <ModelProjectList> list = new List <ModelProjectList>();
if (mySql.Open() == true)
{
mySql.cmd = new MySqlCommand(command, mySql.conn);
mySql.sdr = mySql.cmd.ExecuteReader();
while (mySql.sdr.Read())
{
int jelolt;
try
{
jelolt = Convert.ToInt32(mySql.sdr["jeloltek_db"]);
}
catch (Exception)
{
jelolt = 0;
}
list.Add(new ModelProjectList
{
id = Convert.ToInt32(mySql.sdr["id"]),
megnevezes_projekt = mySql.sdr["megnevezes_projekt"].ToString(),
megnevezes_munka = mySql.sdr["megnevezes_munka"].ToString(),
interjuk_db = Convert.ToInt32(mySql.sdr["interjuk_db"]),
statusz = Convert.ToInt32(mySql.sdr["statusz"]),
jeloltek_db = jelolt,
fel_datum = mySql.sdr["fel_datum"].ToString(),
Completion = 100
});
}
mySql.sdr.Close();
}
mySql.Close();
return(list);
}
public List <ModelProjectSmallList> GetModelProjectSmallList(string command)
{
MySqlDB mySql = new MySqlDB();
List <ModelProjectSmallList> list = new List <ModelProjectSmallList>();
if (mySql.Open() == true)
{
mySql.cmd = new MySqlCommand(command, mySql.conn);
mySql.sdr = mySql.cmd.ExecuteReader();
int j = 0;
while (mySql.sdr.Read())
{
list.Add(new ModelProjectSmallList
{
id = Convert.ToInt32(mySql.sdr["id"]),
megnevezes_projekt = mySql.sdr["megnevezes_projekt"].ToString()
});
j++;
}
mySql.sdr.Close();
}
mySql.Close();
return(list);
}
public static List <ModelProjektJeloltKapcs> Get(string command)
{
MySqlDB mySql = new MySqlDB();
List <ModelProjektJeloltKapcs> list = new List <ModelProjektJeloltKapcs>();
if (mySql.Open() == true)
{
mySql.cmd = new MySqlCommand(command, mySql.conn);
mySql.sdr = mySql.cmd.ExecuteReader();
while (mySql.sdr.Read())
{
list.Add(new ModelProjektJeloltKapcs
{
id = Convert.ToInt32(mySql.sdr["id"]),
projekt_id = Convert.ToInt32(mySql.sdr["projekt_id"]),
jelolt_id = Convert.ToInt32(mySql.sdr["jelolt_id"]),
datum = mySql.sdr["datum"].ToString(),
});
}
mySql.sdr.Close();
}
mySql.Close();
return(list);
}
public CartController(MySqlDB mySqlDatabase)
{
this.MySqlDB = mySqlDatabase;
}
public static List <ModelApplicantList> GetModelApplicantList(string command)
{
List <ModelApplicantList> list = new List <ModelApplicantList>();
MySqlDB mySql = new MySqlDB();
if (mySql.Open() == true)
{
mySql.cmd = new MySqlCommand(command, mySql.conn);
mySql.sdr = mySql.cmd.ExecuteReader();
while (mySql.sdr.Read())
{
string allapot_megnev = "Beérkezett", frissSeged = "Transparent", allasbanSeged = "Hidden";
int allapot = 0;
try
{
allapot = Convert.ToInt32(mySql.sdr["allapota"]);
}
catch (Exception)
{
}
string imgsrc = "/Public/imgs/pm_logo_mini.png";
if (Convert.ToInt32(mySql.sdr["kategoria"]) == 1)
{
imgsrc = "/Public/imgs/profession-logo-mini.png";
}
switch (allapot)
{
case 1:
allapot_megnev = "Telefonon szűrt";
break;
case 2:
allapot_megnev = "Felvett";
break;
case 3:
allapot_megnev = "Elutasított";
break;
case 4:
allapot_megnev = "Projekthez kapcsolt";
break;
default:
allapot_megnev = "Beérkezett";
break;
}
if (Convert.ToBoolean(mySql.sdr["allasban"]))
{
allasbanSeged = "Visible";
}
if (Convert.ToBoolean(mySql.sdr["friss"]))
{
frissSeged = "#defee3";
}
list.Add(new ModelApplicantList
{
id = Convert.ToInt32(mySql.sdr["id"]),
nev = mySql.sdr["nev"].ToString(),
munkakor = mySql.sdr["munkakor"].ToString(),
munkakor2 = mySql.sdr["munkakor2"].ToString(),
munkakor3 = mySql.sdr["munkakor3"].ToString(),
email = mySql.sdr["email"].ToString(),
szuldatum = Convert.ToInt32(mySql.sdr["szuldatum"]),
statusz = Convert.ToInt32(mySql.sdr["statusz"]),
interjuk_db = Convert.ToInt32(mySql.sdr["interjuk_db"]),
project_db = Convert.ToInt32(mySql.sdr["project_db"]),
kategoria = Convert.ToInt32(mySql.sdr["kategoria"]),
friss = frissSeged,
frissValue = Convert.ToBoolean(mySql.sdr["friss"]),
allasban = allasbanSeged,
allasbanValue = Convert.ToBoolean(mySql.sdr["allasban"]),
allapota = allapot,
allapot_megnevezes = allapot_megnev,
reg_datum = mySql.sdr["reg_date"].ToString(),
profil_icon = imgsrc,
megjegyzes = mySql.sdr["megjegyzes"].ToString()
});
}
mySql.sdr.Close();
}
mySql.Close();
return(list);
}
public CategoriesViewComponent(MySqlDB mySqlDatabase)
{
this.MySqlDB = mySqlDatabase;
}
private void InitDatabases()
{
Console.WriteLine("Initialising Connections");
// the code that you want to measure comes here
if (this.Redis != null)
{
Eb_Solution s_obj = this.Redis.Get <Eb_Solution>(String.Format("solution_{0}", this.SolutionId));
if (s_obj != null)
{
this.SolutionType = s_obj.SolutionType;
this.RouterSolution = s_obj.PrimarySolution;
}
}
if (this.Connections != null)
{
string _userName = string.Empty;
string _passWord = string.Empty;
// DATA DB
if (Connections.DataDbConfig != null)
{
_userName = Connections.DataDbConfig.UserName;
_passWord = Connections.DataDbConfig.Password;
if (Connections.DataDbConfig.DatabaseVendor == DatabaseVendors.PGSQL)
{
DataDB = new PGSQLDatabase(Connections.DataDbConfig);
}
else if (Connections.DataDbConfig.DatabaseVendor == DatabaseVendors.ORACLE)
{
DataDB = new OracleDB(Connections.DataDbConfig);
}
else if (Connections.DataDbConfig.DatabaseVendor == DatabaseVendors.MYSQL)
{
DataDB = new MySqlDB(Connections.DataDbConfig);
}
DataDB.ConId = Connections.DataDbConfig.Id;
// DATA DB RO
if (!(string.IsNullOrEmpty(Connections.DataDbConfig.ReadOnlyUserName) || string.IsNullOrEmpty(Connections.DataDbConfig.ReadOnlyPassword)))
{
Connections.DataDbConfig.UserName = Connections.DataDbConfig.ReadOnlyUserName;
Connections.DataDbConfig.Password = Connections.DataDbConfig.ReadOnlyPassword;
if (Connections.DataDbConfig.DatabaseVendor == DatabaseVendors.PGSQL)
{
DataDBRO = new PGSQLDatabase(Connections.DataDbConfig);
}
else if (Connections.DataDbConfig.DatabaseVendor == DatabaseVendors.ORACLE)
{
DataDBRO = new OracleDB(Connections.DataDbConfig);
}
else if (Connections.DataDbConfig.DatabaseVendor == DatabaseVendors.MYSQL)
{
DataDBRO = new MySqlDB(Connections.DataDbConfig);
}
}
else if (DataDBRO == null)
{
DataDBRO = DataDB;
}
// DATA DB RW
if (!(string.IsNullOrEmpty(Connections.DataDbConfig.ReadWriteUserName) || string.IsNullOrEmpty(Connections.DataDbConfig.ReadWritePassword)))
{
Connections.DataDbConfig.UserName = Connections.DataDbConfig.ReadWriteUserName;
Connections.DataDbConfig.Password = Connections.DataDbConfig.ReadWritePassword;
if (Connections.DataDbConfig.DatabaseVendor == DatabaseVendors.PGSQL)
{
DataDBRW = new PGSQLDatabase(Connections.DataDbConfig);
}
else if (Connections.DataDbConfig.DatabaseVendor == DatabaseVendors.ORACLE)
{
DataDBRW = new OracleDB(Connections.DataDbConfig);
}
else if (Connections.DataDbConfig.DatabaseVendor == DatabaseVendors.MYSQL)
{
DataDBRW = new MySqlDB(Connections.DataDbConfig);
}
}
else if (DataDBRW == null)
{
DataDBRW = DataDB;
}
if (Connections.ObjectsDbConfig == null)
{
Connections.DataDbConfig.UserName = _userName;
Connections.DataDbConfig.Password = _passWord;
Connections.ObjectsDbConfig = Connections.DataDbConfig;
}
}
else
{
throw new Exception("No Data DB Integrated!");
}
//Supporting DataDB
if (Connections.SupportingDataDbConfig != null && Connections.SupportingDataDbConfig.Count > 0)
{
if (SupportingDataDB == null)
{
SupportingDataDB = new Dictionary <int, IDatabase>();
}
for (int i = 0; i < Connections.SupportingDataDbConfig.Count; i++)
{
if (Connections.SupportingDataDbConfig[i].DatabaseVendor == DatabaseVendors.PGSQL)
{
SupportingDataDB.Add(Connections.SupportingDataDbConfig[i].Id, new PGSQLDatabase(Connections.SupportingDataDbConfig[i]));
}
else if (Connections.SupportingDataDbConfig[i].DatabaseVendor == DatabaseVendors.ORACLE)
{
SupportingDataDB.Add(Connections.SupportingDataDbConfig[i].Id, new OracleDB(Connections.SupportingDataDbConfig[i]));
}
else if (Connections.SupportingDataDbConfig[i].DatabaseVendor == DatabaseVendors.MYSQL)
{
SupportingDataDB.Add(Connections.SupportingDataDbConfig[i].Id, new MySqlDB(Connections.SupportingDataDbConfig[i]));
}
else if (Connections.SupportingDataDbConfig[i].DatabaseVendor == DatabaseVendors.MSSQL)
{
SupportingDataDB.Add(Connections.SupportingDataDbConfig[i].Id, new MSSQLDatabase(Connections.SupportingDataDbConfig[i]));
}
}
}
//OBJECTS DB
if (Connections.ObjectsDbConfig.DatabaseVendor == DatabaseVendors.PGSQL)
{
ObjectsDB = new PGSQLDatabase(Connections.ObjectsDbConfig);
}
else if (Connections.ObjectsDbConfig.DatabaseVendor == DatabaseVendors.ORACLE)
{
ObjectsDB = new OracleDB(Connections.ObjectsDbConfig);
}
else if (Connections.ObjectsDbConfig.DatabaseVendor == DatabaseVendors.MYSQL)
{
ObjectsDB = new MySqlDB(Connections.ObjectsDbConfig);
}
// OBJECTS DB RO
if (!(string.IsNullOrEmpty(Connections.ObjectsDbConfig.ReadOnlyUserName) || string.IsNullOrEmpty(Connections.ObjectsDbConfig.ReadOnlyPassword)))
{
Connections.ObjectsDbConfig.UserName = Connections.ObjectsDbConfig.ReadOnlyUserName;
Connections.ObjectsDbConfig.Password = Connections.ObjectsDbConfig.ReadOnlyPassword;
if (Connections.ObjectsDbConfig.DatabaseVendor == DatabaseVendors.PGSQL)
{
ObjectsDBRO = new PGSQLDatabase(Connections.ObjectsDbConfig);
}
else if (Connections.ObjectsDbConfig.DatabaseVendor == DatabaseVendors.ORACLE)
{
ObjectsDBRO = new OracleDB(Connections.ObjectsDbConfig);
}
else if (Connections.ObjectsDbConfig.DatabaseVendor == DatabaseVendors.MYSQL)
{
ObjectsDBRO = new MySqlDB(Connections.ObjectsDbConfig);
}
}
else if (ObjectsDBRO == null)
{
ObjectsDBRO = ObjectsDB;
}
// OBJECTS DB RW
if (!(string.IsNullOrEmpty(Connections.ObjectsDbConfig.ReadWriteUserName) || string.IsNullOrEmpty(Connections.ObjectsDbConfig.ReadWritePassword)))
{
Connections.ObjectsDbConfig.UserName = Connections.ObjectsDbConfig.ReadWriteUserName;
Connections.ObjectsDbConfig.Password = Connections.ObjectsDbConfig.ReadWritePassword;
if (Connections.ObjectsDbConfig.DatabaseVendor == DatabaseVendors.PGSQL)
{
ObjectsDBRW = new PGSQLDatabase(Connections.ObjectsDbConfig);
}
else if (Connections.ObjectsDbConfig.DatabaseVendor == DatabaseVendors.ORACLE)
{
ObjectsDBRW = new OracleDB(Connections.ObjectsDbConfig);
}
else if (Connections.ObjectsDbConfig.DatabaseVendor == DatabaseVendors.MYSQL)
{
ObjectsDBRW = new MySqlDB(Connections.ObjectsDbConfig);
}
}
else if (ObjectsDBRW == null)
{
ObjectsDBRW = ObjectsDB;
}
// LOGS DB
LogsDB = new PGSQLDatabase(EbConnectionsConfigProvider.InfraConnections.LogsDbConfig);
//Files DB
FilesDB = new FilesCollection();
bool IsDefaultConIdCorrect = false;
if (Connections.FilesDbConfig == null)
{
Connections.FilesDbConfig = new FilesConfigCollection();
}
if (Connections.FilesDbConfig.Integrations.Count == 0)
{
Connections.DataDbConfig.UserName = _userName;
Connections.DataDbConfig.Password = _passWord;
if (Connections.DataDbConfig.DatabaseVendor == DatabaseVendors.PGSQL)
{
FilesDB.Add(new PGSQLFileDatabase(Connections.DataDbConfig));
}
else if (Connections.DataDbConfig.DatabaseVendor == DatabaseVendors.ORACLE)
{
FilesDB.Add(new OracleFilesDB(Connections.DataDbConfig));
}
else if (Connections.DataDbConfig.DatabaseVendor == DatabaseVendors.MYSQL)
{
FilesDB.Add(new MySQLFilesDB(Connections.DataDbConfig));
}
FilesDB.DefaultConId = Connections.DataDbConfig.Id;
Console.WriteLine("No files Db. set :" + Connections.DataDbConfig.DatabaseName);
}
else
{
for (int i = 0; i < Connections.FilesDbConfig.Integrations.Count; i++)
{
if (Connections.FilesDbConfig.Integrations[i].Type == EbIntegrations.MongoDB)
{
FilesDB.Add(new MongoDBDatabase(this.SolutionId, Connections.FilesDbConfig.Integrations[i] as EbMongoConfig));
}
else if (Connections.FilesDbConfig.Integrations[i].Type == EbIntegrations.DropBox)
{
FilesDB.Add(new DropBox.DropBoxDatabase(Connections.FilesDbConfig.Integrations[i] as EbDropBoxConfig));
}
else if (Connections.FilesDbConfig.Integrations[i].Type == EbIntegrations.AWSS3)
{
FilesDB.Add(new AWSS3.AWSS3(Connections.FilesDbConfig.Integrations[i] as EbAWSS3Config));
}
else if (Connections.FilesDbConfig.Integrations[i].Type == EbIntegrations.GoogleDrive)
{
FilesDB.Add(new GoogleDrive.GoogleDriveDatabase(Connections.FilesDbConfig.Integrations[i] as EbGoogleDriveConfig));
}
else if (Connections.FilesDbConfig.Integrations[i].Type == EbIntegrations.PGSQL)
{
FilesDB.Add(new PGSQLFileDatabase(Connections.FilesDbConfig.Integrations[i] as PostgresConfig));
Console.WriteLine("Postgres Files Db found:" + (Connections.FilesDbConfig.Integrations[i] as PostgresConfig).DatabaseName);
}
else if (Connections.FilesDbConfig.Integrations[i].Type == EbIntegrations.ORACLE)
{
FilesDB.Add(new OracleFilesDB(Connections.FilesDbConfig.Integrations[i] as OracleConfig));
}
else if (Connections.FilesDbConfig.Integrations[i].Type == EbIntegrations.MYSQL)
{
FilesDB.Add(new MySQLFilesDB(Connections.FilesDbConfig.Integrations[i] as MySqlConfig));
}
if (Connections.FilesDbConfig.DefaultConId == Connections.FilesDbConfig.Integrations[i].Id)
{
IsDefaultConIdCorrect = true;
}
Console.WriteLine("Files Db. set :" + Connections.FilesDbConfig.Integrations[i].Type + Connections.FilesDbConfig.Integrations[i].NickName);
}
if (IsDefaultConIdCorrect)
{
FilesDB.DefaultConId = Connections.FilesDbConfig.DefaultConId;
}
else
{
throw new Exception("DefaultConId doesn't found in the files-config list..!!");
}
}
Console.WriteLine("Files DB Collection Count(Init DB) : " + FilesDB.Count);
ChatConnection = new ChatConCollection();
//if (Connections.ChatConfigs == null)
// Connections.ChatConfigs = new ChatConfigCollection();
if (Connections.ChatConfigs != null)
{
ChatConnection.Default = new EbSlack(Connections.ChatConfigs.Default as EbSlackConfig);
for (int i = 0; i < Connections.ChatConfigs.Fallback.Count; i++)
{
if (Connections.ChatConfigs.Fallback[i].Type == EbIntegrations.Slack)
{
ChatConnection.Add(new EbSlack(Connections.ChatConfigs.Fallback[i] as EbSlackConfig));
}
if (Connections.ChatConfigs.Default.Id == Connections.ChatConfigs.Fallback[i].Id)
{
IsDefaultConIdCorrect = true;
}
}
if (IsDefaultConIdCorrect)
{
ChatConnection.Default = new EbSlack(Connections.ChatConfigs.Default as EbSlackConfig);
}
else
{
throw new Exception("DefaultConId doesn't found in the files-config list..!!");
}
}
Console.WriteLine("Chat connection Collection Count(Init DB) : " + ChatConnection.Count);
//EmailConfigs
if (Connections.EmailConfigs != null)
{
EmailConnection = new EbMailConCollection(Connections.EmailConfigs);
EmailRetrieveConnection = new EBMailRetrieveConCollection(Connections.EmailConfigs);
}
else if (this.SolutionType == SolutionType.REPLICA && MasterConnections != null && MasterConnections.EmailConfigs != null)
{
EmailConnection = new EbMailConCollection(MasterConnections.EmailConfigs);
}
//SmsConfigs
if (Connections.SMSConfigs != null)
{
SMSConnection = new EbSmsConCollection(Connections.SMSConfigs);
}
else if (this.SolutionType == SolutionType.REPLICA && MasterConnections != null && MasterConnections.SMSConfigs != null)
{
SMSConnection = new EbSmsConCollection(MasterConnections.SMSConfigs);
}
//if (Connections.ChatConfigs != null)
//{
// ChatConnection = new ChatCollection(Connections.ChatConfigs);
//}
if (Connections.CloudinaryConfigs != null && Connections.CloudinaryConfigs.Count > 0)
{
if (ImageManipulate == null)
{
ImageManipulate = new List <IImageManipulate>();
}
for (int i = 0; i < Connections.CloudinaryConfigs.Count; i++)
{
ImageManipulate.Add(new EbCloudinary(Connections.CloudinaryConfigs[i]));
}
}
if (Connections.MapConfigs != null && Connections.MapConfigs.Integrations.Count > 0)
{
MapConnection = new EbMapConCollection();
for (int i = 0; i < Connections.MapConfigs.Integrations.Count; i++)
{
if (Connections.MapConfigs.Integrations[i].Type == EbIntegrations.GoogleMap)
{
MapConnection.Add(new EbGoogleMap(Connections.MapConfigs.Integrations[i]));
}
}
MapConnection.DefaultConId = Connections.MapConfigs.DefaultConId;
}
if (Connections.MobileConfig != null)
{
MobileAppConnection = new MobileAppConnection(Connections.MobileConfig);
}
else if (this.SolutionType == SolutionType.REPLICA && MasterConnections != null && MasterConnections.MobileConfig != null)
{
MobileAppConnection = new MobileAppConnection(MasterConnections.MobileConfig);
}
//if (Connections.FTPConnection != null)
// FTP = new EbFTP(Connections.FTPConnection);
}
else
{
throw new Exception("Fatal Error :: Connection is null or Empty! . Solnname = " + SolutionId);
}
Console.WriteLine("Connections Initialised Successfully");
}
public ProductsViewComponent(MySqlDB mySqlDatabase)
{
this.MySqlDB = mySqlDatabase;
}
void FormMain_Load(object sender, EventArgs e)
{
try
{
this.lbFiles.Tag = new List <ItemFileInfo>();
this.labtips.Text = "Excel 生成实体类以及数据源 \r\n\r\nXml 分析生成程序代码，\r\n\r\nPS: Excel“.xls” 建议使用 Wps！";
this.tbmsgshow.Text = string.Empty;
if (!File.Exists("dbconfig.xml"))
{
System.Xml.Serialization.XmlSerializer xml = new System.Xml.Serialization.XmlSerializer(typeof(DBConfigs));
using (FileStream fs = new FileStream("dbconfig.xml", FileMode.CreateNew, FileAccess.Write))
{
var dbcs = new DBConfigs();
dbcs.NamespaceStr = "net.sz.game.po";
dbcs.SavePath = CreateBase.BasePath;
dbcs.SaveJPAPath = CreateBase.JavaJpaCodePathData;
dbcs.SaveJavaMessagePath = CreateBase.protobufjavaMessage;
dbcs.SaveCsharpMessagePath = CreateBase.protobufnetMessage;
dbcs.IsNullEmpty = false;
dbcs.Configs.Add(new DBConfig()
{
DBBase = "test",
DBPath = "192.168.0.188",
DBPart = 3306,
DBUser = "******",
DBPwd = "fuckdaohaode1314"
});
dbcs.Configs.Add(new DBConfig()
{
DBBase = "local_gamesr_data",
DBPath = "192.168.0.188",
DBPart = 3306,
DBUser = "******",
DBPwd = "fuckdaohaode1314"
});
xml.Serialize(fs, dbcs);
}
}
{
System.Xml.Serialization.XmlSerializer xml = new System.Xml.Serialization.XmlSerializer(typeof(DBConfigs));
DBConfigs dbcs = null;
using (FileStream fs = new FileStream("dbconfig.xml", FileMode.Open, FileAccess.ReadWrite))
{
dbcs = (DBConfigs)xml.Deserialize(fs);
if (!string.IsNullOrWhiteSpace(dbcs.SavePath))
{
CreateBase.SetPath(dbcs.SavePath.Trim());
}
else
{
dbcs.SavePath = CreateBase.BasePath;
}
if (!string.IsNullOrWhiteSpace(dbcs.SaveCsharpMessagePath))
{
CreateBase.protobufnetMessage = (dbcs.SaveCsharpMessagePath.Trim());
}
else
{
dbcs.SaveCsharpMessagePath = CreateBase.protobufnetMessage;
}
if (!string.IsNullOrWhiteSpace(dbcs.SaveJavaMessagePath))
{
CreateBase.protobufjavaMessage = (dbcs.SaveJavaMessagePath.Trim());
}
else
{
dbcs.SaveJavaMessagePath = CreateBase.protobufjavaMessage;
}
if (!string.IsNullOrWhiteSpace(dbcs.SaveJPAPath))
{
CreateBase.JavaJpaCodePathData = (dbcs.SaveJPAPath.Trim());
}
else
{
dbcs.SaveJPAPath = CreateBase.JavaJpaCodePathData;
}
this.cb_isnull.Checked = dbcs.IsNullEmpty;
this.combdbcons.DataSource = dbcs.Configs;
this.combdbcons.SelectedIndex = 0;
DBConfig dbc = dbcs.Configs[0];
this.tbdbpack.Text = dbc.DBBase.Trim();
this.tbcodepack.Text = dbcs.NamespaceStr.Trim();
}
using (FileStream fs1 = new FileStream("dbconfig.xml", FileMode.Create, FileAccess.Write))
{
xml.Serialize(fs1, dbcs);
}
}
MySqlDB.Instance();
}
catch (Exception ex)
{
MessageBox.Show("数据库连接字符串错误" + ex);
Application.Exit();
}
}
public StockistsViewComponent(MySqlDB mySqlDatabase)
{
this.MySqlDB = mySqlDatabase;
}
public static void Init(string databaseIP, string databaseName, string uid, string password)
{
_conStr = MySqlDB.GetDbConStr(serverIP: databaseIP, databaseName: databaseName, uid: uid, password: password);
}
