private void Awake() { if (instance != null && instance != this) { Destroy(this.gameObject); } else { instance = this; } }
static void Main(string[] args) { try { //xml string //DatabaseConfigXml.SetStringEncrypt("abcdefgh"); //StringEncrypt.DataEncrypt(StringEncrypt.EncryptType.MD5, // "server=135.251.245.8;Data Source=Test;uid=HR;pwd=hr;"); DatabaseConfigXml.SetStringEncrypt(); DatabaseMaster data = new DatabaseMaster( new ConnectionConfig() { ConnectionString = "Data Source=127.0.0.1;database=LabelMaster2;uid=Test;pwd=ioedu#2345", //ConnectionString = // DatabaseConfigXml.GetDbConfigXml( // "DatabaseConfig.xml", // "SQLite", // "ConnectString", // StringEncrypt.EncryptType.None), DBType = DatabaseType.MSSQL.ToString(), IsAutoCloseConnection = true }); //FileInfo fi = new FileInfo("D:\\Downloads\\MU400_SGWM_E50_V4.0.dbc"); //byte[] buff = new byte[fi.Length]; //FileStream fs = fi.OpenRead(); //fs.Read(buff, 0, Convert.ToInt32(fs.Length)); //fs.Close(); //ParameterINClass[] para = new ParameterINClass[1]; //para[0].SqlDbType = SqlDbType.Binary; //para[0].ParameterName = "@File"; //para[0].Value = buff; //data.Insertable("Label_Table").Data(new String[] { "Label_Name", "Lable_TypeID", "Label_Desp", "Label_CreateTime", "Label_Creater", "Label_File" , "Label_Enable" } //, new Object[] {"AA",1,"a",DateTime.Now,"A","@File",1 }).ExecuteParameterCommand(para); //data.Updateable("Label_Table").Data(new String[] { "Label_File" }, new Object[] {"@File" }).Where("Label_ID", 1).ExecuteCommand(para); //DataTable dt = data.Queryable("Label_Table").Columns().Data().ToDataTable(); //byte[] buff = (Byte[])dt.Rows[0]["Label_File"]; //FileStream fs = new FileStream("D:\\Downloads\\aa.dbc", FileMode.CreateNew); //BinaryWriter bw = new BinaryWriter(fs); //bw.Write(buff, 0, buff.Length); //bw.Close(); //fs.Close(); //data.Queryable("TestCase_List_Table") // .Columns() // .Where("Product_ID", 1) // .Where("TestCase_List_SequenceNo", 4) // .Data().ToDataTable(); //data.Updateable("TestCase_List_Table") // .Where("Product_ID", 1) // .Where("TestCase_List_SequenceNo", 4) // .Data(new String[] { "TestCase_List_PassFail" }, new Object[] { 0 }) // .ExecuteCommand(); DatabaseMasterMongoDB mongodb = new DatabaseMasterMongoDB(new ConnectionConfig() { ConnectionString = DatabaseConfigXml.GetDbConfigXml("DatabaseConfig.xml", "MongoDBName", "ConnectString", StringEncrypt.EncryptType.MD5), IsAutoCloseConnection = true }); //List<Hashtable> hr = mongodb.Queryable("DurabilityTest").Data("Summary").ToListHashTable(); //mongodb.Queryable("DurabilityTest").TableLink("T1111", new string[] {"_id"}, // new CommandComparison[] {CommandComparison.Is}, new object[] {"5f929ac3023a36f332afd822"}, // new WhereRelation[] {WhereRelation.None}, new List<string> {"Serial样机编号", "Time时间"}, // new List<string> { }, "Summary", "Serial样机编号", "Serial样机编号", "Summary").ToDataTable(); //mongodb.Connect(); //DataTable dt1 = mongodb.Queryable("DurabilityTest", "T111111").Data().ToDataTable(); //DataTable dt2 = mongodb.Queryable("DurabilityTest", "T111111").Where( "VOLT电压", 38, CommandComparison.GreaterOrEquals).Data().ToDataTable(); //mongodb.Close(); //String id = mongodb.FileManage("DurabilityTest").UploadFile("D:\\Downloads\\011002000411-31504817.pdf", "EXCEL"); //mongodb.FileManage("DurabilityTest").ReNameFile(id, "dingchen.pdf", "EXCEL"); //mongodb.FileManage("DurabilityTest").DownloadFile(id, "D:\\Downloads\\dingchen.pdf", "EXCEL"); //mongodb.FileManage("DurabilityTest").DeleteFile(id, "EXCEL"); //mongodb.FileManage("DurabilityTest").DeleteGridFS("EXCEL"); // DatabaseMasterRedis redis = new DatabaseMasterRedis(new ConnectionConfig() // { // ConnectionString = DatabaseConfigXml.GetDbConfigXml("DatabaseConfig.xml", "Redis", //"ConnectString", StringEncrypt.EncryptType.None), // IsAutoCloseConnection = true // }); //redis.Writeable().Data("Test", "12345"); //redis.Readable().Data<Int32>("Test"); //redis.Writeable().Delete(new string[]{"Test"}); } catch (Exception e) { Console.WriteLine(e); } }