/// <summary> /// 得到一个对象实体 /// </summary> public Hoto.Model.manager_role GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,role_name,role_type from dt_manager_role "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = id; Hoto.Model.manager_role model = new Hoto.Model.manager_role(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { #region 父表信息 if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } model.role_name = ds.Tables[0].Rows[0]["role_name"].ToString(); if (ds.Tables[0].Rows[0]["role_type"].ToString() != "") { model.role_type = int.Parse(ds.Tables[0].Rows[0]["role_type"].ToString()); } #endregion 父表信息end #region 子表信息 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("select id,role_id,channel_name,channel_id,action_type from dt_manager_role_value "); strSql2.Append(" where role_id=@role_id "); SqlParameter[] parameters2 = { new SqlParameter("@role_id", SqlDbType.Int, 4) }; parameters2[0].Value = id; DataSet ds2 = DbHelperSQL.Query(strSql2.ToString(), parameters2); if (ds2.Tables[0].Rows.Count > 0) { #region 子表字段信息 int i = ds2.Tables[0].Rows.Count; List <Hoto.Model.manager_role_value> models = new List <Hoto.Model.manager_role_value>(); Hoto.Model.manager_role_value modelt; for (int n = 0; n < i; n++) { modelt = new Hoto.Model.manager_role_value(); if (ds2.Tables[0].Rows[n]["id"].ToString() != "") { modelt.id = int.Parse(ds2.Tables[0].Rows[n]["id"].ToString()); } if (ds2.Tables[0].Rows[n]["role_id"].ToString() != "") { modelt.role_id = int.Parse(ds2.Tables[0].Rows[n]["role_id"].ToString()); } modelt.channel_name = ds2.Tables[0].Rows[n]["channel_name"].ToString(); if (ds2.Tables[0].Rows[n]["channel_id"].ToString() != "") { modelt.channel_id = int.Parse(ds2.Tables[0].Rows[n]["channel_id"].ToString()); } modelt.action_type = ds2.Tables[0].Rows[n]["action_type"].ToString(); models.Add(modelt); } model.manager_role_values = models; #endregion 子表字段信息end } #endregion 子表信息end return(model); } else { return(null); } }
/// <summary> /// �õ�һ������ʵ�� /// </summary> public Hoto.Model.manager_role GetModel(int id) { StringBuilder strSql = new StringBuilder(); strSql.Append("select id,role_name,role_type from dt_manager_role "); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = id; Hoto.Model.manager_role model = new Hoto.Model.manager_role(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { #region ������Ϣ if (ds.Tables[0].Rows[0]["id"].ToString() != "") { model.id = int.Parse(ds.Tables[0].Rows[0]["id"].ToString()); } model.role_name = ds.Tables[0].Rows[0]["role_name"].ToString(); if (ds.Tables[0].Rows[0]["role_type"].ToString() != "") { model.role_type = int.Parse(ds.Tables[0].Rows[0]["role_type"].ToString()); } #endregion ������Ϣend #region �ӱ���Ϣ StringBuilder strSql2 = new StringBuilder(); strSql2.Append("select id,role_id,channel_name,channel_id,action_type from dt_manager_role_value "); strSql2.Append(" where role_id=@role_id "); SqlParameter[] parameters2 = { new SqlParameter("@role_id", SqlDbType.Int,4)}; parameters2[0].Value = id; DataSet ds2 = DbHelperSQL.Query(strSql2.ToString(), parameters2); if (ds2.Tables[0].Rows.Count > 0) { #region �ӱ��ֶ���Ϣ int i = ds2.Tables[0].Rows.Count; List<Hoto.Model.manager_role_value> models = new List<Hoto.Model.manager_role_value>(); Hoto.Model.manager_role_value modelt; for (int n = 0; n < i; n++) { modelt = new Hoto.Model.manager_role_value(); if (ds2.Tables[0].Rows[n]["id"].ToString() != "") { modelt.id = int.Parse(ds2.Tables[0].Rows[n]["id"].ToString()); } if (ds2.Tables[0].Rows[n]["role_id"].ToString() != "") { modelt.role_id = int.Parse(ds2.Tables[0].Rows[n]["role_id"].ToString()); } modelt.channel_name = ds2.Tables[0].Rows[n]["channel_name"].ToString(); if (ds2.Tables[0].Rows[n]["channel_id"].ToString() != "") { modelt.channel_id = int.Parse(ds2.Tables[0].Rows[n]["channel_id"].ToString()); } modelt.action_type = ds2.Tables[0].Rows[n]["action_type"].ToString(); models.Add(modelt); } model.manager_role_values = models; #endregion �ӱ��ֶ���Ϣend } #endregion �ӱ���Ϣend return model; } else { return null; } }