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