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