/// <summary>
/// 获得数据列表
/// </summary>
public List<BWS.ERP.Model.sysUserEntity> DataTableToList(DataTable dt)
{
List<BWS.ERP.Model.sysUserEntity> modelList = new List<BWS.ERP.Model.sysUserEntity>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
BWS.ERP.Model.sysUserEntity model;
for (int n = 0; n < rowsCount; n++)
{
model = new BWS.ERP.Model.sysUserEntity();
if (dt.Rows[n]["ID"].ToString() != "")
{
model.ID = int.Parse(dt.Rows[n]["ID"].ToString());
}
model.sUserID = dt.Rows[n]["sUserID"].ToString();
model.sUserCName = dt.Rows[n]["sUserCName"].ToString();
model.sUserEName = dt.Rows[n]["sUserEName"].ToString();
string s = BWS.ERP.BaseControl.SysEncrypt.DecryptStr(dt.Rows[n]["sPassword"].ToString());
if (s != "KeyError")
{
model.sPassword = s;
}
else
{
model.sPassword = dt.Rows[n]["sPassword"].ToString();
}
if (dt.Rows[n]["ParentID"].ToString() != "")
{
model.ParentID = int.Parse(dt.Rows[n]["ParentID"].ToString());
}
if (dt.Rows[n]["EmpID"].ToString() != "")
{
model.EmpID = int.Parse(dt.Rows[n]["EmpID"].ToString());
}
if (dt.Rows[n]["iUserType"].ToString() != "")
{
model.iUserType = int.Parse(dt.Rows[n]["iUserType"].ToString());
}
if (dt.Rows[n]["bIsLock"].ToString() != "")
{
if ((dt.Rows[n]["bIsLock"].ToString() == "1") || (dt.Rows[n]["bIsLock"].ToString().ToLower() == "true"))
{
model.bIsLock = true;
}
else
{
model.bIsLock = false;
}
}
model.sRemark = dt.Rows[n]["sRemark"].ToString();
if (dt.Rows[n]["iFlag"].ToString() != "")
{
model.iFlag = int.Parse(dt.Rows[n]["iFlag"].ToString());
}
model.sUserTypeName = dt.Rows[n]["sUserTypeName"].ToString();
model.sDeptNo = dt.Rows[n]["sDeptNo"].ToString();
model.sDeptName = dt.Rows[n]["sDeptName"].ToString();
model.sDeptEName = dt.Rows[n]["sDeptEName"].ToString();
model.sParentUserID = dt.Rows[n]["sParentUserID"].ToString();
model.sParentCName = dt.Rows[n]["sParentCName"].ToString();
modelList.Add(model);
}
}
return modelList;
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(BWS.ERP.Model.sysUserEntity model, SqlTransaction trans)
{
return(dal.Add(model, trans));
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(BWS.ERP.Model.sysUserEntity model, SqlTransaction trans)
{
dal.Update(model, trans);
}
/// <summary>
/// 获得数据列表
/// </summary>
public List <BWS.ERP.Model.sysUserEntity> DataTableToList(DataTable dt)
{
List <BWS.ERP.Model.sysUserEntity> modelList = new List <BWS.ERP.Model.sysUserEntity>();
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
BWS.ERP.Model.sysUserEntity model;
for (int n = 0; n < rowsCount; n++)
{
model = new BWS.ERP.Model.sysUserEntity();
if (dt.Rows[n]["ID"].ToString() != "")
{
model.ID = int.Parse(dt.Rows[n]["ID"].ToString());
}
model.sUserID = dt.Rows[n]["sUserID"].ToString();
model.sUserCName = dt.Rows[n]["sUserCName"].ToString();
model.sUserEName = dt.Rows[n]["sUserEName"].ToString();
string s = BWS.ERP.BaseControl.SysEncrypt.DecryptStr(dt.Rows[n]["sPassword"].ToString());
if (s != "KeyError")
{
model.sPassword = s;
}
else
{
model.sPassword = dt.Rows[n]["sPassword"].ToString();
}
if (dt.Rows[n]["ParentID"].ToString() != "")
{
model.ParentID = int.Parse(dt.Rows[n]["ParentID"].ToString());
}
if (dt.Rows[n]["EmpID"].ToString() != "")
{
model.EmpID = int.Parse(dt.Rows[n]["EmpID"].ToString());
}
if (dt.Rows[n]["iUserType"].ToString() != "")
{
model.iUserType = int.Parse(dt.Rows[n]["iUserType"].ToString());
}
if (dt.Rows[n]["bIsLock"].ToString() != "")
{
if ((dt.Rows[n]["bIsLock"].ToString() == "1") || (dt.Rows[n]["bIsLock"].ToString().ToLower() == "true"))
{
model.bIsLock = true;
}
else
{
model.bIsLock = false;
}
}
model.sRemark = dt.Rows[n]["sRemark"].ToString();
if (dt.Rows[n]["iFlag"].ToString() != "")
{
model.iFlag = int.Parse(dt.Rows[n]["iFlag"].ToString());
}
model.sUserTypeName = dt.Rows[n]["sUserTypeName"].ToString();
model.sDeptNo = dt.Rows[n]["sDeptNo"].ToString();
model.sDeptName = dt.Rows[n]["sDeptName"].ToString();
model.sDeptEName = dt.Rows[n]["sDeptEName"].ToString();
model.sParentUserID = dt.Rows[n]["sParentUserID"].ToString();
model.sParentCName = dt.Rows[n]["sParentCName"].ToString();
modelList.Add(model);
}
}
return(modelList);
}