public static void Register() { var container = new Container(); container.Options.DefaultScopedLifestyle = new WebRequestLifestyle(); DefaultPackage.RegisterServices(container); container.RegisterMvcControllers(Assembly.GetExecutingAssembly()); container.Verify(); DependencyResolver.SetResolver(new SimpleInjectorDependencyResolver(container)); }
void Package() { var temp = EditorUserBuildSettings.activeBuildTarget; EditorUserBuildSettings.SwitchActiveBuildTarget(PackagePlatform.GetBuildTarget()); //切换贴图格式 SwitchTextureFormat(); //打包其他文件 DefaultPackage.BuildDefaultSpecify(PackagePlatform.platformCurrent); //打包Assetbundle AssetBundlePackage.BuildAssetbundlesSpecify(PackagePlatform.platformCurrent); //打包场景 if (needPackageScene) { PackagePlatform.sceneDirectoryPath = rawScenePath; SceneBundlePackage.BuildSceneSpecify(PackagePlatform.platformCurrent); } //生成版本号 var minor = int.Parse(minorVersion); minor++; minorVersion = minor.ToString(); PackageUtil.GeneratorVersion(mainVersion, minorVersion); //生成文件表 PackageUtil.GeneratorChecklist(); EditorUserBuildSettings.SwitchActiveBuildTarget(temp); SavePackageConfig(); }
static void Main(string[] args) { _Application app = new Application(); Workbook book = null; Worksheet sheet = null; Range range = null; try { app.Visible = false; app.ScreenUpdating = false; app.DisplayAlerts = false; string filePath = Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), @"MasterSheet.xlsx"); book = app.Workbooks.Open(filePath, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value); sheet = (Worksheet)book.Worksheets[1]; // get a range to work with range = sheet.get_Range("A2", Missing.Value); // get the end of values to the right (will stop at the first empty cell) range = range.get_End(XlDirection.xlToRight); // get the end of values toward the bottom, looking in the last column (will stop at first empty cell) range = range.get_End(XlDirection.xlDown); // get the address of the bottom, right cell string downAddress = range.get_Address( false, false, XlReferenceStyle.xlA1, Type.Missing, Type.Missing); // Get the range, then values from a1 range = sheet.get_Range("A2", downAddress); object[,] values = (object[, ])range.Value2; // Value2 is a two dimenial array dime one = row, dime two = column. Console.WriteLine("Col Count: " + values.GetLength(1).ToString()); Console.WriteLine("Row Count: " + values.GetLength(0).ToString()); using (DanceClassDbContext db = new DanceClassDbContext()) { var users = new List <ApplicationUser>(); var memberships = new List <Membership>(); var packages = new List <Package>(); var defaultPackages = db.DefaultPackages.ToList(); for (int i = 1; i <= values.GetLength(0); i++) { string fullName = values[i, 1].ToString().Trim(); if (!values[i, 2].ToString().Equals("0")) { fullName = values[i, 2].ToString().Trim() + " " + fullName; } DateTime?dob = !values[i, 3].Equals("undefined") ? (DateTime?)DateTime.FromOADate((double)values[i, 3]) : null; string phoneNumber = "0" + values[i, 4].ToString().Trim(); int numberOfSessions = int.Parse(values[i, 5].ToString()); int months = int.Parse(values[i, 6].ToString()); DateTime createdDate = DateTime.FromOADate((double)values[i, 7]); Console.WriteLine(createdDate); DateTime expiryDate = DateTime.FromOADate((double)values[i, 8]); int remainingSessions = int.Parse(values[i, 10].ToString()); double price = (double)values[i, 11]; ApplicationUser user = new ApplicationUser { FullName = fullName, UserName = GenerateUserName(users, fullName), PhoneNumber = phoneNumber, Birthdate = dob, CreatedBy = "Imported", UpdatedBy = "Imported", CreatedDate = createdDate, UpdatedDate = createdDate }; Membership membership = new Membership { User = user, RemainingSessions = remainingSessions, ExpiryDate = expiryDate, CreatedBy = "Imported", UpdatedBy = "Imported", CreatedDate = createdDate, UpdatedDate = createdDate }; DefaultPackage defaultPackage = defaultPackages.FirstOrDefault(p => p.NumberOfSessions == numberOfSessions); Package package = new Package { NumberOfSessions = numberOfSessions, RemainingSessions = remainingSessions, Months = months, Price = price, DefaultPackageId = defaultPackage != null ? (int?)defaultPackage.Id : null, User = user, CreatedBy = "Imported", UpdatedBy = "Imported", CreatedDate = createdDate, UpdatedDate = createdDate, ExpiryDate = expiryDate }; users.Add(user); memberships.Add(membership); packages.Add(package); } ApplicationUserManager userManager = new ApplicationUserManager(new ApplicationUserStore(db)); using (DbContextTransaction transaction = db.Database.BeginTransaction()) { try { Console.WriteLine("--------------------------------------"); Console.WriteLine("- ADDING USERS -------------------------"); Console.WriteLine("--------------------------------------"); foreach (var u in users) { Console.WriteLine("Adding user: "******"Mistake1234").GetAwaiter().GetResult(); if (result.Succeeded) { result = userManager.AddToRoleAsync(u.Id, "Member").GetAwaiter().GetResult(); } if (!result.Succeeded) { throw new Exception(string.Join(". ", result.Errors)); } } Console.WriteLine("--------------------------------------"); Console.WriteLine("- ADDING MEMBERSHIPS -------------------------"); Console.WriteLine("--------------------------------------"); db.Memberships.AddRange(memberships); Console.WriteLine("--------------------------------------"); Console.WriteLine("- ADDING PACKAGES -------------------------"); Console.WriteLine("--------------------------------------"); db.Packages.AddRange(packages); Console.WriteLine("--------------------------------------"); Console.WriteLine("- SAVING CHANGES -------------------------"); Console.WriteLine("--------------------------------------"); db.SaveChanges(); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); Console.WriteLine(ex); } } } } catch (Exception e) { Console.WriteLine(e); } finally { range = null; sheet = null; if (book != null) { try { book.Close(false, Missing.Value, Missing.Value); } catch (Exception ex) { Console.WriteLine(ex.Message); } } book = null; if (app != null) { try { app.Quit(); } catch (Exception ex) { Console.WriteLine(ex.Message); } } app = null; Console.ReadKey(); } }