public async Task ImportExcel(Queue <DriverVM> listModel) { try { if (listModel != null && listModel.Count > 0) { //Encoding.RegisterProvider(CodePagesEncodingProvider.Instance); //MySqlConnection con = new MySqlConnection("server=192.168.1.208;userid=root;pwd=lyh888150;database=ccp(latest);sslmode=none;"); foreach (var item in listModel) { string sql = $"select * from aspnetusers where PhoneNumber={item.PhoneNumber}"; var user = new Aspnetusers(); using (ReadConnection) { user = await ReadConnection.QueryFirstOrDefaultAsync <Aspnetusers>(sql); } if (user != null) { if (user.UserCategory != UserCategory.JFEmployees) { user.UserCategory = UserCategory.JFEmployees; using (WriteConnection) { await WriteConnection.UpdateAsync(user); } } } else { var newuser = new Aspnetusers() { PhoneNumber = item.PhoneNumber, UserName = item.PhoneNumber, CertificatePhotoCertificationState = CertificationStatus.Uncommitted, DrivingLicenseKeyCertificationState = CertificationStatus.Uncommitted, IdentityCardCertificationState = CertificationStatus.Uncommitted, LockoutEnabled = true, RealNameStatus = CertificationStatus.Uncommitted, CertificationStatus = CertificationStatus.Uncommitted, TrailerLicenseCertificationStatus = CertificationStatus.Uncommitted, VehiclePhotoCertificationStatus = CertificationStatus.Uncommitted, RoleType = ApplicationRoleType.Driver, RoadTransportStatus = CertificationStatus.Uncommitted, Date = DateTime.Now, UserCategory = UserCategory.JFEmployees }; using (WriteConnection) { await WriteConnection.InsertAsync(newuser);; } } } } } catch (Exception ex) { throw ex; } }
public async Task <UserInfo> FindByLoginKeyAsync(string keyWord) { DynamicParameters param = new DynamicParameters(); string sql = @"select * from userinfo where PhoneNumber=@keyWord or Email=@KeyWord"; param.Add("@keyWord", keyWord); param.Add("@KeyWord", keyWord); using (ReadConnection) { var result = await ReadConnection.QueryFirstOrDefaultAsync <UserInfo>(sql, param); return(result); } }