/// <summary>
/// 设置插入数据的命令
/// </summary>
/// <param name="entity">实体对象</param>
/// <param name="cmd">命令</param>
/// <returns>返回真说明要取主键</returns>
private void CreateFullSqlParameter(RolePowerData entity, MySqlCommand cmd)
{
//02:标识(ID)
cmd.Parameters.Add(new MySqlParameter("ID", MySqlDbType.Int32)
{
Value = entity.ID
});
//04:页面标识(PageItemId)
cmd.Parameters.Add(new MySqlParameter("PageItemId", MySqlDbType.Int32)
{
Value = entity.PageItemId
});
//05:角色标识(RoleId)
cmd.Parameters.Add(new MySqlParameter("RoleId", MySqlDbType.Int32)
{
Value = entity.RoleId
});
//06:权限(Power)
cmd.Parameters.Add(new MySqlParameter("Power", MySqlDbType.Int32)
{
Value = entity.Power
});
//07:权限范围(DataScope)
cmd.Parameters.Add(new MySqlParameter("DataScope", MySqlDbType.Int32)
{
Value = (int)entity.DataScope
});
}
/// <summary>
/// 取得仅更新的SQL语句
/// </summary>
internal string GetModifiedSqlCode(RolePowerData data)
{
if (data.__EntityStatusNull || !data.__EntityStatus.IsModified)
{
return(";");
}
StringBuilder sql = new StringBuilder();
sql.AppendLine("UPDATE `tb_sys_role_power` SET");
//页面标识
if (data.__EntityStatus.ModifiedProperties[RolePowerData.Real_PageItemId] > 0)
{
sql.AppendLine(" `page_item_id` = ?PageItemId");
}
//角色标识
if (data.__EntityStatus.ModifiedProperties[RolePowerData.Real_RoleId] > 0)
{
sql.AppendLine(" `role_id` = ?RoleId");
}
//权限
if (data.__EntityStatus.ModifiedProperties[RolePowerData.Real_Power] > 0)
{
sql.AppendLine(" `power` = ?Power");
}
//权限范围
if (data.__EntityStatus.ModifiedProperties[RolePowerData.Real_DataScope] > 0)
{
sql.AppendLine(" `data_scope` = ?DataScope");
}
sql.Append(" WHERE `id` = ?ID;");
return(sql.ToString());
}
/// <summary>
/// 读取Form传过来的数据
/// </summary>
/// <param name="data">数据</param>
/// <param name="convert">转化器</param>
protected void DefaultReadFormData(RolePowerData data, FormConvert convert)
{
//数据֪
data.PageItemId = convert.ToInteger("PageItemId");
data.RoleId = convert.ToInteger("RoleId");
data.Power = convert.ToInteger("Power");
data.DataScope = (PositionDataScopeType)convert.ToInteger("DataScope");
}
/// <summary>
/// 载入数据
/// </summary>
/// <param name="reader">数据读取器</param>
/// <param name="entity">读取数据的实体</param>
public override void SimpleLoad(MySqlDataReader reader, RolePowerData entity)
{
using (new EditScope(entity.__EntityStatus, EditArrestMode.All, false))
{
entity._id = (int)reader.GetInt32(0);
entity._pageitemid = (int)reader.GetInt32(1);
entity._roleid = (int)reader.GetInt32(2);
entity._power = (int)reader.GetInt32(3);
if (!reader.IsDBNull(4))
{
entity._datascope = (PositionDataScopeType)reader.GetInt32(4);
}
}
}
/// <summary>
/// 设置插入数据的命令
/// </summary>
/// <param name="entity">实体对象</param>
/// <param name="cmd">命令</param>
/// <returns>返回真说明要取主键</returns>
protected sealed override bool SetInsertCommand(RolePowerData entity, MySqlCommand cmd)
{
cmd.CommandText = InsertSqlCode;
CreateFullSqlParameter(entity, cmd);
return(true);
}
/// <summary>
/// 设置更新数据的命令
/// </summary>
/// <param name="entity">实体对象</param>
/// <param name="cmd">命令</param>
protected sealed override void SetUpdateCommand(RolePowerData entity, MySqlCommand cmd)
{
cmd.CommandText = UpdateSqlCode;
CreateFullSqlParameter(entity, cmd);
}
