根据参数生成查询SQL语句 请各位高手进来帮下忙，

[cylkiss]

详细如下函数，怎么实现，之前没做过或者给点思路也行，请各位帮帮忙。
/// <summary>
/// 根据参数生成查询SQL语句
/// </summary>
/// <param name="tableName"> 表名 </param>
/// <param name="keyName">关键字段</param>
/// <param name="strCondition">条件值 </param>
/// <returns></returns>
public string GetSql(string tableName, string keyName, string strCondition)
{
return "";
}

[hxf66888]

若你的关键字段是要返回的字段值,就把*替换掉,如是用于条件的,就把 字段 替换掉.

string sql ="select * from "+ tableName+" where 字段=+" strCondition";
return sql;

[magicbacon]

    /// <summary> 
    /// 根据参数生成查询SQL语句 
    /// </summary> 
    /// <param name="tableName"> 表名 </param> 
    /// <param name="keyName">关键字段 </param> 
    /// <param name="strCondition">条件值 </param> 
    /// <returns> </returns> 
    public string GetSql(string tableName, string keyName, string strCondition)
    {
        return "SELECT * FROM [" + tableName + "] WHERE [" + keyName + "]='" + strCondition + "'";
    } 

[jhdxhj]

C# code /// <summary>
/// 根据参数生成查询SQL语句
/// </summary>
/// <param name="tableName"> 表名 </param>
/// <param name="keyName">关键字段 </param>
/// <param name="strCondition">条件值 </param>
/// <returns> </returns>
public string GetSql(string tableName, string keyName, string strCondition)
{
return "SELECT * FROM [" + tableName + "] WHERE [" + keyName + "]='" + strCondition + "'";
}

[cylkiss]

再请问一下，如果是数组呢，？还是相同的处理么。例如string[] AA 在方法中定义一个这样的参数。

[cylkiss]

它对应的还有一个后面参数为数组的，例如：
public string GetSql(string tableName, string[] keyName, string[] strCondition)

[magicbacon]

    /// <summary> 
    /// 根据参数生成查询SQL语句 
    /// </summary> 
    /// <param name="tableName">表名 </param> 
    /// <param name="keyName">关键字段 </param> 
    /// <param name="strCondition">条件值 </param> 
    /// <returns> </returns> 
    public string GetSql(string tableName, string[] keyName, string[] strCondition)
    {
        string sql = "SELECT * FROM [" + tableName + "] WHERE ";
        for (int i = 0; i < keyName.Length - 1; i++)
        {
            sql += "[" + keyName[i] + "]='" + strCondition[i] + "' AND ";
        }
        sql += "[" + keyName[keyName.Length - 1] + "]='" + strCondition[keyName.Length - 1] + "'";
        return sql;
    } 

[新时代新目标新征程]

[Quote=引用 6 楼 magicbacon 的回复:]
C# code /// <summary>
/// 根据参数生成查询SQL语句
/// </summary>
/// <param name="tableName">表名 </param>
/// <param name="keyName">关键字段 </param>
/// <param name="strCondition">条件值 </param>
/// <returns> </returns>
public string GetSql(string tableName, string[] keyName, string[] strCondition)
{
string sql = "SELECT * FROM [" + t…
[/Quote]up

[magicbacon]

当然这是最基本的，最好还要加上一些判断：如果两个数组长度不一样怎么处理，等等，加强健壮性~

[cylkiss]

噢，谢了各位。

[ErnestChen2go]

[Quote=引用 2 楼 magicbacon 的回复:]
C# code
/// <summary>
/// 根据参数生成查询SQL语句
/// </summary>
/// <param name="tableName"> 表名 </param>
/// <param name="keyName">关键字段 </param>
/// <param name="strCondition">条件值 </param>
/// <returns> </returns>
public string GetSql(string tableName, string keyName, string strCondition)
{
return "SELECT * FROM [" + tableName + "] WHE…
[/Quote]
就这样的