/// <summary>
/// 增加
/// </summary>
/// <param name="Roles">Roles实体对象</param>
/// <returns>int值,返回自增ID</returns>
public int addReturnId(Roles model)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter ("@Roles_Name",model.Roles_Name),
new SqlParameter ("@Roles_CreatedTime",model.Roles_CreatedTime),
new SqlParameter ("@Roles_Remark",model.Roles_Remark),
new SqlParameter ("@Roles_Status",model.Roles_Status),
new SqlParameter ("@Roles_PanelID",model.Roles_PanelID)
};
return Convert.ToInt32(Helper.ExecuteScalar ("Roles_AddReturnId",param));
}
/// <summary>
/// 增加
/// </summary>
/// <param name="Roles">Roles实体对象</param>
/// <returns>bool值,判断是否操作成功</returns>
public bool add(Roles model)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter ("@Roles_Name",model.Roles_Name),
new SqlParameter ("@Roles_CreatedTime",model.Roles_CreatedTime),
new SqlParameter ("@Roles_Remark",model.Roles_Remark),
new SqlParameter ("@Roles_Status",model.Roles_Status),
new SqlParameter ("@Roles_PanelID",model.Roles_PanelID)
};
return Helper.ExecuteNonQuery("Roles_Add",param);
}
/// <summary>
/// 查看全部
/// </summary>
/// <returns>list集合</returns>
public List<Roles> selectAll()
{
List<Roles> list = new List<Roles>();
Roles model = null;
using (SqlDataReader dr = Helper.ExecuteReader("Roles_SelectAll", null))
{
while (dr.Read())
{
model = new Roles();
model.Roles_ID = dr["Roles_ID"].ToString();
if (DBNull.Value!=dr["Roles_Name"])
model.Roles_Name = dr["Roles_Name"].ToString();
if (DBNull.Value!=dr["Roles_CreatedTime"])
model.Roles_CreatedTime= Convert.ToDateTime(dr["Roles_CreatedTime"]);
if (DBNull.Value!=dr["Roles_Remark"])
model.Roles_Remark = dr["Roles_Remark"].ToString();
if (DBNull.Value!=dr["Roles_Status"])
model.Roles_Status = dr["Roles_Status"].ToString();
if (DBNull.Value!=dr["Roles_PanelID"])
model.Roles_PanelID = dr["Roles_PanelID"].ToString();
list.Add(model);
}
}
return list;
}
/// <summary>
/// 通过条件查询
/// </summary>
/// <param name="WhereString">查询条件</param>
/// <returns>Roles实体类对象</returns>
public List<Roles> selectByWhere(string WhereString)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter ("@where",WhereString)
};
List<Roles> list = new List<Roles>();
Roles model = null;
using (SqlDataReader dr = Helper.ExecuteReader("Roles_SelectByWhere", param))
{
while (dr.Read())
{
model = new Roles();
model.Roles_ID = dr["Roles_ID"].ToString();
if (DBNull.Value!=dr["Roles_Name"])
model.Roles_Name = dr["Roles_Name"].ToString();
if (DBNull.Value!=dr["Roles_CreatedTime"])
model.Roles_CreatedTime= Convert.ToDateTime(dr["Roles_CreatedTime"]);
if (DBNull.Value!=dr["Roles_Remark"])
model.Roles_Remark = dr["Roles_Remark"].ToString();
if (DBNull.Value!=dr["Roles_Status"])
model.Roles_Status = dr["Roles_Status"].ToString();
if (DBNull.Value!=dr["Roles_PanelID"])
model.Roles_PanelID = dr["Roles_PanelID"].ToString();
list.Add(model);
}
}
return list;
}
/// <summary>
/// 通过Id查询
/// </summary>
/// <param name="Id">主键Id</param>
/// <returns>Roles实体类对象</returns>
public Roles selectById(int Id)
{
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter ("@Roles_ID",Id)
};
Roles model = new Roles();
using (SqlDataReader dr = Helper.ExecuteReader("Roles_SelectById", param))
{
if (dr.Read())
{
model.Roles_ID = dr["Roles_ID"].ToString();
if (DBNull.Value!=dr["Roles_Name"])
model.Roles_Name = dr["Roles_Name"].ToString();
if (DBNull.Value!=dr["Roles_CreatedTime"])
model.Roles_CreatedTime= Convert.ToDateTime(dr["Roles_CreatedTime"]);
if (DBNull.Value!=dr["Roles_Remark"])
model.Roles_Remark = dr["Roles_Remark"].ToString();
if (DBNull.Value!=dr["Roles_Status"])
model.Roles_Status = dr["Roles_Status"].ToString();
if (DBNull.Value!=dr["Roles_PanelID"])
model.Roles_PanelID = dr["Roles_PanelID"].ToString();
}
}
return model;
}
/// <summary>
/// Устаревший метод для добавления новых объектов в набор EntitySet Roles. Взамен можно использовать метод .Add связанного свойства ObjectSet<T>.
/// </summary>
public void AddToRoles(Roles roles)
{
base.AddObject("Roles", roles);
}
/// <summary>
/// Создание нового объекта Roles.
/// </summary>
/// <param name="rolename">Исходное значение свойства Rolename.</param>
/// <param name="applicationName">Исходное значение свойства ApplicationName.</param>
public static Roles CreateRoles(global::System.String rolename, global::System.String applicationName)
{
Roles roles = new Roles();
roles.Rolename = rolename;
roles.ApplicationName = applicationName;
return roles;
}
