private const string SQL_SELECT_ALLLIST = "SELECT * FROM Counseling where uid=@UID";
private const string PARM_UID = "@UID";
public DataTable Search(Model.Counseling CSL)
{
SqlParameter[] SearchParms = new SqlParameter[1];
SearchParms[0] = new SqlParameter(PARM_SEARCH, SqlDbType.VarChar,10);
SearchParms[0].Value = CSL.search;
if (CSL.searchKind == "CAuthor")
{
SQL_SELECT_SEARCH = SQL_SELECT_SEARCH + " AND Counseling.CAuthor like '%'+@SEARCH+'%'";
}
if (CSL.searchKind == "CContent")
{
SQL_SELECT_SEARCH = SQL_SELECT_SEARCH + " AND Counseling.CContent LIKE '%'+@SEARCH+'%'";
}
using (DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.CONN_STRINGCSL, CommandType.Text, SQL_SELECT_SEARCH, SearchParms))
{
return ds.Tables[0];
}
}