/// <summary>
/// 将对象转换实体
/// </summary>
public Model.manager_role DataRowToModel(DataRow row)
{
Model.manager_role model = new Model.manager_role();
if (row != null)
{
#region 主表信息======================
//利用反射获得属性的所有公共属性
Type modelType = model.GetType();
for (int i = 0; i < row.Table.Columns.Count; i++)
{
//查找实体是否存在列表相同的公共属性
PropertyInfo proInfo = modelType.GetProperty(row.Table.Columns[i].ColumnName);
if (proInfo != null && row[i] != DBNull.Value)
{
proInfo.SetValue(model, row[i], null);//用索引值设置属性值
}
}
#endregion
#region 子表信息======================
StringBuilder strSql1 = new StringBuilder();
strSql1.Append("select * from " + databaseprefix + "manager_role_value");
strSql1.Append(" where role_id=@role_id");
SqlParameter[] parameters1 =
{
new SqlParameter("@role_id", SqlDbType.Int, 4)
};
parameters1[0].Value = model.id;
DataTable dt1 = DbHelperSQL.Query(strSql1.ToString(), parameters1).Tables[0];
if (dt1.Rows.Count > 0)
{
int rowsCount = dt1.Rows.Count;
List <Model.manager_role_value> models = new List <Model.manager_role_value>();
Model.manager_role_value modelt;
for (int n = 0; n < rowsCount; n++)
{
modelt = new Model.manager_role_value();
Type modeltType = modelt.GetType();
for (int i = 0; i < dt1.Rows[n].Table.Columns.Count; i++)
{
PropertyInfo proInfo = modeltType.GetProperty(dt1.Rows[n].Table.Columns[i].ColumnName);
if (proInfo != null && dt1.Rows[n][i] != DBNull.Value)
{
proInfo.SetValue(modelt, dt1.Rows[n][i], null);
}
}
models.Add(modelt);
}
model.manager_role_values = models;
}
#endregion
#region 权限信息======================
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("select * from MS_userRolePemission");
strSql2.Append(" where urp_roleid=@role_id");
SqlParameter[] parameters2 =
{
new SqlParameter("@role_id", SqlDbType.Int, 4)
};
parameters2[0].Value = model.id;
DataTable dt2 = DbHelperSQL.Query(strSql2.ToString(), parameters2).Tables[0];
if (dt2.Rows.Count > 0)
{
int rowsCount = dt2.Rows.Count;
List <Model.userRolePemission> models = new List <Model.userRolePemission>();
Model.userRolePemission modelt;
for (int n = 0; n < rowsCount; n++)
{
modelt = new Model.userRolePemission();
Type modeltType = modelt.GetType();
for (int i = 0; i < dt2.Rows[n].Table.Columns.Count; i++)
{
PropertyInfo proInfo = modeltType.GetProperty(dt2.Rows[n].Table.Columns[i].ColumnName);
if (proInfo != null && dt2.Rows[n][i] != DBNull.Value)
{
proInfo.SetValue(modelt, dt2.Rows[n][i], null);
}
}
models.Add(modelt);
}
model.RolePemissionList = models;
}
#endregion
}
return(model);
}
/// <summary>
/// 将对象转换实体
/// </summary>
public Model.manager DataRowToModel(DataRow row)
{
Model.manager model = new Model.manager();
if (row != null)
{
//利用反射获得属性的所有公共属性
Type modelType = model.GetType();
for (int i = 0; i < row.Table.Columns.Count; i++)
{
//查找实体是否存在列表相同的公共属性
PropertyInfo proInfo = modelType.GetProperty(row.Table.Columns[i].ColumnName);
if (proInfo != null && row[i] != DBNull.Value)
{
proInfo.SetValue(model, row[i], null);//用索引值设置属性值
}
}
#region 员工权限======================
//StringBuilder strSql2 = new StringBuilder();
//strSql2.Append("select * from MS_userRolePemission");
//strSql2.Append(" where urp_username=@name");
//SqlParameter[] parameters2 = {
// new SqlParameter("@name", SqlDbType.VarChar,20)};
//parameters2[0].Value = model.user_name;
//DataTable dt2 = DbHelperSQL.Query(strSql2.ToString(), parameters2).Tables[0];
//if (dt2.Rows.Count > 0)
//{
// int rowsCount = dt2.Rows.Count;
// List<Model.userRolePemission> models = new List<Model.userRolePemission>();
// Model.userRolePemission modelt;
// for (int n = 0; n < rowsCount; n++)
// {
// modelt = new Model.userRolePemission();
// Type modeltType = modelt.GetType();
// for (int i = 0; i < dt2.Rows[n].Table.Columns.Count; i++)
// {
// PropertyInfo proInfo = modeltType.GetProperty(dt2.Rows[n].Table.Columns[i].ColumnName);
// if (proInfo != null && dt2.Rows[n][i] != DBNull.Value)
// {
// proInfo.SetValue(modelt, dt2.Rows[n][i], null);
// }
// }
// models.Add(modelt);
// }
// model.UserPemissionList = models;
//}
#endregion
#region 员工的角色权限======================
StringBuilder strSql3 = new StringBuilder();
strSql3.Append("select * from MS_userRolePemission");
strSql3.Append(" where urp_roleid=@name");
SqlParameter[] parameters3 =
{
new SqlParameter("@name", SqlDbType.VarChar, 20)
};
parameters3[0].Value = model.role_id;
DataTable dt3 = DbHelperSQL.Query(strSql3.ToString(), parameters3).Tables[0];
if (dt3.Rows.Count > 0)
{
int rowsCount = dt3.Rows.Count;
List <Model.userRolePemission> models = new List <Model.userRolePemission>();
Model.userRolePemission modelt;
for (int n = 0; n < rowsCount; n++)
{
modelt = new Model.userRolePemission();
Type modeltType = modelt.GetType();
for (int i = 0; i < dt3.Rows[n].Table.Columns.Count; i++)
{
PropertyInfo proInfo = modeltType.GetProperty(dt3.Rows[n].Table.Columns[i].ColumnName);
if (proInfo != null && dt3.Rows[n][i] != DBNull.Value)
{
proInfo.SetValue(modelt, dt3.Rows[n][i], null);
}
}
models.Add(modelt);
}
model.RolePemissionList = models;
}
#endregion
}
return(model);
}
