/// <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()); }