/// <summary>
/// 载入数据
/// </summary>
/// <param name="reader">数据读取器</param>
/// <param name="entity">读取数据的实体</param>
public override void SimpleLoad(MySqlDataReader reader, SubjectionData entity)
{
using (new EditScope(entity.__EntityStatus, EditArrestMode.All, false))
{
entity._id = (int)reader.GetInt32(0);
entity._masterid = (int)reader.GetInt32(1);
entity._slaveid = (int)reader.GetInt32(2);
}
}
/// <summary>
/// 设置插入数据的命令
/// </summary>
/// <param name="entity">实体对象</param>
/// <param name="cmd">命令</param>
/// <returns>返回真说明要取主键</returns>
private void CreateFullSqlParameter(SubjectionData entity, MySqlCommand cmd)
{
//02:标识(Id)
cmd.Parameters.Add(new MySqlParameter("Id", MySqlDbType.Int32)
{
Value = entity.Id
});
//05:主键(MasterId)
cmd.Parameters.Add(new MySqlParameter("MasterId", MySqlDbType.Int32)
{
Value = entity.MasterId
});
//06:关联(SlaveId)
cmd.Parameters.Add(new MySqlParameter("SlaveId", MySqlDbType.Int32)
{
Value = entity.SlaveId
});
}
/// <summary>
/// 取得仅更新的SQL语句
/// </summary>
internal string GetModifiedSqlCode(SubjectionData data)
{
if (data.__EntityStatusNull || !data.__EntityStatus.IsModified)
{
return(";");
}
StringBuilder sql = new StringBuilder();
sql.AppendLine("UPDATE `tb_sys_subjection` SET");
//主键
if (data.__EntityStatus.ModifiedProperties[SubjectionData.Real_MasterId] > 0)
{
sql.AppendLine(" `master_id` = ?MasterId");
}
//关联
if (data.__EntityStatus.ModifiedProperties[SubjectionData.Real_SlaveId] > 0)
{
sql.AppendLine(" `slave_id` = ?SlaveId");
}
sql.Append(" WHERE `id` = ?Id;");
return(sql.ToString());
}
/// <summary>
/// 读取Form传过来的数据
/// </summary>
/// <param name="data">数据</param>
/// <param name="convert">转化器</param>
protected void DefaultReadFormData(SubjectionData data, FormConvert convert)
{
//数据֪
data.MasterId = convert.ToInteger("MasterId");
data.SlaveId = convert.ToInteger("SlaveId");
}
/// <summary>
/// 设置插入数据的命令
/// </summary>
/// <param name="entity">实体对象</param>
/// <param name="cmd">命令</param>
/// <returns>返回真说明要取主键</returns>
protected sealed override bool SetInsertCommand(SubjectionData 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(SubjectionData entity, MySqlCommand cmd)
{
cmd.CommandText = UpdateSqlCode;
CreateFullSqlParameter(entity, cmd);
}
