/// <summary>
/// 获取针对按主键查询的MySqlParameter数组
/// </summary>
/// <param name="sqlType">Sql类型</param>
/// <param name="primaryValue">主键的值</param>
internal static MySqlParameter[] GetFindMySqlParameter(string primaryValue)
{
MySqlParameter[] parameters = new[]
{
new MySqlParameter($"{MontageSqlHelper.SqlPrifix}{PrimaryKeyProp.GetMappingName()}", primaryValue),
};
return(parameters);
}
/// <summary>
/// 获取针对更新的的MySqlParameter数组
/// </summary>
/// <param name="sqlType">Sql类型</param>
/// <param name="primaryValue">实体类的实例</param>
internal static MySqlParameter[] GetUpdateMySqlParameters(T t)
{
var parameters = Properties.Select(
p => new MySqlParameter($"{MontageSqlHelper.SqlPrifix}{p.GetMappingName()}", p.GetValue(t) ?? DBNull.Value)
).ToList();
parameters.Add(new MySqlParameter($"{MontageSqlHelper.SqlPrifix}{PrimaryKeyProp.GetMappingName()}", PrimaryKeyProp.GetValue(t)));
return(parameters.ToArray());
}
