C# (CSharp) System.Web.UI.Design.WebControls SqlDataSourceColumnData.GetOldValueParameterPlaceHolderの例

コード例 #1

ファイル: SqlDataSourceTableQuery.cs プロジェクト: pritesh-mandowara-sp/DecompliedDotNetLibraries

 private void AppendWhereClauseParameter(StringBuilder commandText, SqlDataSourceColumnData columnData, string oldValuesFormatString)
 {
     string escapedName = columnData.EscapedName;
     string oldValueParameterPlaceHolder = columnData.GetOldValueParameterPlaceHolder(oldValuesFormatString);
     if (columnData.Column.Nullable)
     {
         commandText.Append("((");
         commandText.Append(escapedName);
         commandText.Append(" = ");
         commandText.Append(oldValueParameterPlaceHolder);
         commandText.Append(") OR (");
         commandText.Append(escapedName);
         commandText.Append(" IS NULL AND ");
         commandText.Append(oldValueParameterPlaceHolder);
         commandText.Append(" IS NULL))");
     }
     else
     {
         commandText.Append(escapedName);
         commandText.Append(" = ");
         commandText.Append(oldValueParameterPlaceHolder);
     }
 }

コード例 #2

ファイル: SqlDataSourceTableQuery.cs プロジェクト: greyblue9/DecompliedDotNetLibraries

        private void AppendWhereClauseParameter(StringBuilder commandText, SqlDataSourceColumnData columnData, string oldValuesFormatString)
        {
            string escapedName = columnData.EscapedName;
            string oldValueParameterPlaceHolder = columnData.GetOldValueParameterPlaceHolder(oldValuesFormatString);

            if (columnData.Column.Nullable)
            {
                commandText.Append("((");
                commandText.Append(escapedName);
                commandText.Append(" = ");
                commandText.Append(oldValueParameterPlaceHolder);
                commandText.Append(") OR (");
                commandText.Append(escapedName);
                commandText.Append(" IS NULL AND ");
                commandText.Append(oldValueParameterPlaceHolder);
                commandText.Append(" IS NULL))");
            }
            else
            {
                commandText.Append(escapedName);
                commandText.Append(" = ");
                commandText.Append(oldValueParameterPlaceHolder);
            }
        }