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); }