需要引用到的命名空间:
using System.Data;
using Model;
查询功能的实现:
/// <summary>
/// 查询
/// </summary>
/// <param name="id"></param>
/// <param name="content"></param>
/// <param name="state"></param>
/// <returns></returns>
public static DataTable Select(int id = 0, string content = "", int state = 0)
{
var sql = "select Task.*,Project.ProjectName from Task,Project where Task.ProjectID=Project.ProjectID";
if (id != 0)
{
sql += " and task.ProjectID=" + id;
}
if (content != "")
{
sql += string.Format(" and Content like '%{0}%'", co