static void Main5(string[] args) { DataTable dt = ExcelHelper.GetDataTable("D:/培训导入.xlsx"); IEntryService entryService = new EntryService(); //dt.Rows.RemoveAt(0); foreach (DataRow row in dt.Rows) { EntryImportDTO dto = new EntryImportDTO(); dto.Address = row["地址"].ToString(); dto.BankAccount = row["银行账号"].ToString(); dto.Contact = row["联系方式"].ToString(); dto.Duty = row["职务"].ToString(); dto.Ein = row["税号"].ToString(); dto.Gender = row["性别"].ToString(); dto.InvoiceUp = row["发票抬头"].ToString(); dto.Mobile = row["手机号"].ToString(); dto.Name = row["姓名"].ToString(); dto.OpenBank = row["开户行"].ToString(); dto.PayName = row["支付方式"].ToString(); dto.StayName = row["住宿要求"].ToString(); dto.CityId = 22; //dto.Workplace = "南宁市"; dto.WorkUnits = row["工作单位"].ToString(); dto.TrainId = 1; dto.EntryChannelId = 38; bool b = row["地址"].ToString() == ""; //long id = entryService.ImportAdd(dto); Console.WriteLine(b); } //EntryDTO dto = new EntryDTO(); //dto.Gender = true; //dto.PayId = 1; //dto.StayId = 1; //long id = entryService.Add(dto); //Console.WriteLine(id); Console.ReadKey(); }
public long ImportAdd(EntryImportDTO dto) { using (MyDbContext dbc = new MyDbContext()) { CommonService <TrainEntity> cs = new CommonService <TrainEntity>(dbc); CommonService <IdNameEntity> ics = new CommonService <IdNameEntity>(dbc); CommonService <UserEntity> ucs = new CommonService <UserEntity>(dbc); var train = cs.GetAll().Include(t => t.Entries).SingleOrDefault(t => t.Id == dto.TrainId); if (train == null) { return(0); } var user = ucs.GetAll().SingleOrDefault(u => u.Mobile == dto.Mobile); if (user == null) { user = new UserEntity(); user.Mobile = dto.Mobile; user.Name = dto.Name; user.NickName = "dt_" + new Random().Next(); user.PhotoUrl = ""; user.Gender = dto.Gender == "男"; user.Address = dto.Address; user.LoginErrorTimes = 0; user.PasswordHash = ""; user.PasswordSalt = ""; user.PassCount = 0; user.WinCount = 0; user.IsWon = false; user.ChangeTime = DateTime.Now; dbc.Users.Add(user); } else { user.Mobile = dto.Mobile; user.Name = dto.Name; user.Gender = dto.Gender == "男"; user.Address = dto.Address; user.ChangeTime = DateTime.Now; } EntryEntity entity = new EntryEntity(); entity.Address = dto.Address; entity.BankAccount = dto.BankAccount; entity.Contact = dto.Contact; entity.Duty = dto.Duty; entity.Ein = dto.Ein; entity.Gender = dto.Gender == "男"; entity.InvoiceUp = dto.InvoiceUp; entity.Mobile = dto.Mobile; entity.Name = dto.Name; entity.OpenBank = dto.OpenBank; entity.PayId = ics.GetAll().SingleOrDefault(i => i.Name.Contains(dto.PayName)).Id; entity.StayId = ics.GetAll().SingleOrDefault(i => i.Name.Contains(dto.StayName)).Id; entity.CityId = dto.CityId; entity.EntryChannelId = dto.EntryChannelId; //entity.Workplace = dto.Workplace; entity.WorkUnits = dto.WorkUnits; dbc.Entries.Add(entity); train.Entries.Add(entity); dbc.SaveChanges(); return(entity.Id); } }