Esempio n. 1
0
 static void Main(string[] args)
 {
     Console.WriteLine("Press any key to drop Database");
     Console.Read();
     System.Data.Entity.Database.SetInitializer<Context>(new ContextDropDBInitializer());
     //System.Data.Entity.Database.SetInitializer<Context>(null);
     Context db = new Context();
     var query = (from o in db.SystemUsers select o).ToList();
     db.Dispose();
     ImportData import = new ImportData();
     string filename = "历史客户.xlsx";
     //import.Fun1(filename);
     Console.WriteLine("Press any key to Exit");
     Console.Read();
 }
Esempio n. 2
0
        public void Fun()
        {
            string filename = "人员名单.xlsx";
            FileInfo fi = new FileInfo(filename);
            StringBuilder errorinfo = new StringBuilder();
            using (ExcelPackage package = new ExcelPackage(fi))
            {
                ExcelWorksheet worksheet = package.Workbook.Worksheets["Sheet1"];
                int i = 1;
                using (Context db = new Context())
                {
                    //db.Configuration.AutoDetectChangesEnabled = false;
                    //using (TransactionScope tran = new TransactionScope())
                    //{
                        while (i < 100)
                        {
                            i++;
                            string name = ExcelHelper.ReadString(worksheet.Cells[i, 4]);
                            if (string.IsNullOrEmpty(name)) continue;
                            if ((from o in db.SystemUsers where o.Name == name select o).FirstOrDefault() != null)
                            {
                                Console.WriteLine(name + " 已存在");
                                continue;
                            }
                            string rolename = ExcelHelper.ReadString(worksheet.Cells[i, 2]);
                            int roleid = (from o in db.Roles where o.Name == rolename select o.Id).FirstOrDefault();
                            if (roleid == 0)
                            {
                               roleid= (from o in db.Roles where o.Name == "销售员" select o.Id).First();
                            }
                            SystemUser user = new SystemUser
                                              {
                                                  Name = name,
                                                  Password = "******",
                                                  LoginName = name,
                                                  Email = ExcelHelper.ReadString(worksheet.Cells[i, 5])
                                              };
                            SystemUser u = new SystemUser();
                            db.SystemUsers.Add(u);
                            u.Save(db, user);
                            RoleUser ru = new RoleUser {UserId = u.Id, RoleId = (int) roleid};
                            db.RoleUsers.Add(ru);
                            string projname = ExcelHelper.ReadString(worksheet.Cells[i, 1]);
                            int project =
                                (from o in db.Departments
                                    where o.Name == projname
                                    select o.Id).First();
                            DepartmentUser du = new DepartmentUser {UserId = u.Id};
                            string d3 = ExcelHelper.ReadString(worksheet.Cells[i, 3]);
                            if (string.IsNullOrEmpty(d3))
                            {
                                d3 = "公共客户";
                            }
                            else
                            {
                                d3 = rolename;
                            }
                            Department dept =
                                (from o in db.Departments where o.PId == project && o.Name == d3 select o).First();
                            du.DepartmentId = dept.Id;
                            db.DepartmentUsers.Add(du);
                            db.SaveChanges();

                           // tran.Complete();
                      //  }

                    }
                }
            }
        }
Esempio n. 3
0
        public void Fun1(string filename)
        {
            FileInfo fi = new FileInfo(filename);
            StringBuilder errorinfo = new StringBuilder();
            using (ExcelPackage package = new ExcelPackage(fi))
            {
                ExcelWorksheet worksheet = package.Workbook.Worksheets["Sheet1"];
                int i = 1;
                using (Context db = new Context())
                {
                    //db.Configuration.AutoDetectChangesEnabled = false;
                    //using (TransactionScope tran = new TransactionScope())
                    //{
                    while (i < 6000)
                    {
                        i++;
                        string name = ExcelHelper.ReadString(worksheet.Cells[i, 3]);
                        if (string.IsNullOrEmpty(name)) continue;
                        int projectid = int.Parse(ExcelHelper.ReadString(worksheet.Cells[i, 9]));
                        DateTime? d = ExcelHelper.ReadDateEmpty(worksheet.Cells[i, 2]);
                        if (d == null)
                        {
                            Console.WriteLine("ErrorDate" + i.ToString());
                            continue;
                        }
                        string phone = ExcelHelper.ReadString(worksheet.Cells[i, 4]);
                        string way = ExcelHelper.ReadString(worksheet.Cells[i, 5]);
                        if (string.IsNullOrEmpty(way))
                        {
                            way = "-";
                        }
                        string roomtype = ExcelHelper.ReadString(worksheet.Cells[i, 6]);
                        //string u1 = ExcelHelper.ReadString(worksheet.Cells[i, 7]);
                        string u2 = ExcelHelper.ReadString(worksheet.Cells[i, 8]);
                        if (phone != "-")
                        {
                            if (
                            (from o in db.Clients where o.ProjectId == projectid && o.Phone1 == phone select o)
                                .FirstOrDefault() !=null)
                        {
                            Console.WriteLine("客户已存在" + i.ToString());
                            continue;
                        }
                        }

                        int sales1 = (from o in db.SystemUsers where o.Name == u2 select o.Id).FirstOrDefault();
                        int sales;
                        if (sales1 == 0)
                        {
                            Console.WriteLine("销售员不存在" + u2+i.ToString());
                            continue;
                        }
                        sales = (int) sales1;

                        int team1 =
                            (from o in db.SystemUsers
                                join p in db.DepartmentUsers on o.Id equals p.UserId
                                where o.Name == u2
                                select p.DepartmentId).FirstOrDefault();
                        if (team1 == 0)
                        {
                            Console.WriteLine("销售组不存在" + u2);
                            continue;
                        }
                        int team=(int)team1;
                        Client client = new Client {ProjectId = projectid};
                        client.Name = name;
                        client.Phone1 = phone;
                        client.Way = way;
                        client.RoomType = roomtype;
                        client.AllPhone = phone;
                        client.Code = "导入数据";
                        client.CreateTime = (DateTime)d;
                        client.GroupId = team;
                        client.State = ClientStateEnum.来电客户;
                        client.StateDate = new DateTime(2013, 11, 30);
                        db.Clients.Add(client);
                        db.SaveChanges();
                        ClientActivity ca = new ClientActivity {ClientId = client.Id};
                        db.ClientActivities.Add(ca);
                        ca.ActualTime = client.CreateTime;
                        ca.FirstType = 1;
                        ca.Person = sales;
                        ca.Type = "来电";
                        db.SaveChanges();

                          }
            //tran.Complete();
            //                    }
                }
            }
        }
Esempio n. 4
0
		static void Main (string[] args)
		{
			Platform[] platforms = Platform.GetPlatforms ();
			for (int i = 0; i < platforms.Length; i++) {
				Console.WriteLine ("Platform={0}", i);
				Console.WriteLine ("  Name       = {0}", platforms[i].Name);
				Console.WriteLine ("  Vendor     = {0}", platforms[i].Vendor);
				Console.WriteLine ("  Version    = {0}", platforms[i].Version);
				Console.WriteLine ("  Profile    = {0}", platforms[i].Profile);
				Console.WriteLine ("  Extensions = {0}", platforms[i].Extensions);
				Device[] devices = platforms[0].GetDevices (DeviceType.All);
				for (int j = 0; j < devices.Length; j++) {
					Console.WriteLine ("  Device={0}", j);
					Console.WriteLine ("    Name   = {0}", devices[j].Name);
					Console.WriteLine ("    Vendor = {0}", devices[j].Vendor);
					Console.WriteLine ("    MaxComputeUnits = {0}", devices[j].MaxComputeUnits);
				}
			}
			
			int blockSize = 16;
			int matrixSize = 1024;
			int matrixBytes = matrixSize * matrixSize * 4;
			float[] matrixA = new float[matrixSize * matrixSize];
			float[] matrixB = new float[matrixSize * matrixSize];
			float[] matrixR = new float[matrixSize * matrixSize];
			float[] matrixCPU = new float[matrixSize * matrixSize];

			int[] global_threads = new int[] {matrixSize, matrixSize};
			int[] local_threads = new int[] {blockSize, blockSize};
			int blockCacheBytes = blockSize * blockSize * 4;

			Random rnd = new Random ();
			for (int i = 0; i < matrixA.Length; i ++) {
				matrixA[i] = (float)rnd.NextDouble ();
				matrixB[i] = (float)rnd.NextDouble ();
			}

			Stopwatch sw;
			Device device;
			using (Context context = new Context (DeviceType.GPU))
			using (CommandQueue queue = context.CreateCommandQueue (device = context.Devices[0], CommandQueueProperties.Default))
			using (Memory memA = context.CreateBuffer (MemoryFlags.ReadOnly, matrixBytes))
			using (Memory memB = context.CreateBuffer (MemoryFlags.ReadOnly, matrixBytes))
			using (Memory memC = context.CreateBuffer (MemoryFlags.WriteOnly, matrixBytes))
			using (Program prog = context.CreateProgram (OpenCL_TestProgram, device, null))
			using (Kernel kernel = prog.CreateKernel ("multMatrix")) {
				kernel.SetArgument (0, memA);
				kernel.SetArgument (1, memB);
				kernel.SetArgument (2, memC);
				kernel.SetLocalDataShare (3, blockCacheBytes);
				kernel.SetLocalDataShare (4, blockCacheBytes);
				kernel.SetArgument (5, matrixSize, 4);
				kernel.SetArgument (6, blockSize, 4);

				queue.WriteBuffer (memA, 0, matrixA, 0, matrixBytes);
				queue.WriteBuffer (memB, 0, matrixB, 0, matrixBytes);
				
				sw = Stopwatch.StartNew ();
				queue.Execute (kernel, null, global_threads, local_threads);
				sw.Stop ();
				Console.WriteLine ("GPU: {0:f4}ms", sw.Elapsed.TotalMilliseconds);

				queue.ReadBuffer (memC, 0,  matrixR, 0, matrixBytes);
			}

			sw = Stopwatch.StartNew ();
			for (int i = 0; i < matrixSize; i ++) {
				for (int j = 0; j < matrixSize; j ++) {
					for (int k = 0; k < matrixSize; k ++)
						matrixCPU[i * matrixSize + j] += matrixA[i * matrixSize + k] * matrixB[k * matrixSize + j];
				}
			}
			sw.Stop ();
			Console.WriteLine ("CPU: {0:f4}ms", sw.Elapsed.TotalMilliseconds);

			for (int i = 0; i < matrixR.Length; i ++) {
				if (matrixR[i] != matrixCPU[i]) {
					Console.WriteLine ("Error");
					return;
				}
			}
			Console.WriteLine ("OK");
		}