/// <summary> /// 获取G_User实体List /// </summary> /// <param name="dt">源数据表</param> /// <returns></returns> public List <G_User> G_User(DataTable dt) { List <G_User> modelList = new List <G_User>(); G_User model; for (int n = 0; n < dt.Rows.Count; n++) { model = new G_User(); try{ model.u_id = (long)dt.Rows[n]["u_id"]; } catch { } try{ model.u_uname = (long)dt.Rows[n]["u_uname"]; } catch { } model.u_pwd = dt.Rows[n]["u_pwd"].ToString(); model.u_paypwd = dt.Rows[n]["u_paypwd"].ToString(); model.u_filename = dt.Rows[n]["u_filename"].ToString(); model.u_email = dt.Rows[n]["u_email"].ToString(); model.u_tname = dt.Rows[n]["u_tname"].ToString(); try{ model.p_id = (int)dt.Rows[n]["p_id"]; } catch { } try{ model.c_id = (int)dt.Rows[n]["c_id"]; } catch { } try{ model.d_id = (int)dt.Rows[n]["d_id"]; } catch { } try{ model.s_id = (int)dt.Rows[n]["s_id"]; } catch { } try{ model.cm_id = (int)dt.Rows[n]["cm_id"]; } catch { } model.pcdscm_address = dt.Rows[n]["pcdscm_address"].ToString(); try{ model.u_money = (decimal)dt.Rows[n]["u_money"]; } catch { } try{ model.u_examine = (bool)dt.Rows[n]["u_examine"]; } catch { } try{ model.u_addtime = (DateTime)dt.Rows[n]["u_addtime"]; } catch { } modelList.Add(model); } return(modelList); }
public bool Insert(List <UserModels> lstInfo) { bool result = true; var info = lstInfo.FirstOrDefault(); using (NuWebContext cxt = new NuWebContext()) { using (var transaction = cxt.Database.BeginTransaction()) { try { List <G_User> lstInsert = new List <G_User>(); G_User itemInsert = null; foreach (var item in lstInfo) { itemInsert = new G_User(); itemInsert.StoreId = item.StoreId; itemInsert.Name = item.Name; itemInsert.Email = item.Email; itemInsert.Password = item.Password; itemInsert.IsActive = item.IsActive; lstInsert.Add(itemInsert); } cxt.G_User.AddRange(lstInsert); cxt.SaveChanges(); transaction.Commit(); } catch (Exception ex) { _logger.Error(ex); result = false; transaction.Rollback(); } finally { if (cxt != null) { cxt.Dispose(); } } } } //var jsonContent = JsonConvert.SerializeObject(lstInfo); //_baseFactory.InsertTrackingLog("G_User", jsonContent, info.StoreId.ToString(), result); return(result); }
public void TestRegister() { IAuthRepository <G_User> authRepository = new AuthService(_connection); G_User user = new G_User() { LastName = "Jackson", FirstName = "Michael", Email = "*****@*****.**", Passwd = "Test1234=", Genre = 'M' }; bool result = authRepository.Register(user); Assert.IsTrue(result); Assert.IsNull(user.Passwd); //vérifie si le mot de passe qui revient de la DB a été mis sur null. }
public static C_User ToClient(this G_User user) { return(new C_User(user.Id, user.LastName, user.FirstName, user.Email, user.IsValid, user.Genre)); }