c查詢.cs

来自「Teacher Manager System」· CS 代码 · 共 54 行

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using tw;
using System.Reflection;

/// </姓名>Aaron
/// </時間>03-04-1651
/// </內容>增加C查詢類別
public class C查詢
{
    public MyTrans TransferSqltoObject;
 
   
    public Object[] queryByObject(Object p_course, String tableName, params String[] p_strs)
    {
        PropertyInfo[] l_properties = p_course.GetType().GetProperties();
        //String l_strQueryString = "SELECT * FROM dbo.(SELECT ROW_NUMBER() OVER(ORDER BY DESC) AS ROWNO from " + tableName + ") AS T Where ROWNO >((目前頁數-1)*分頁大小)";
        String l_strQueryString = "SELECT * FROM " + tableName + "Where 1=1";
        foreach (PropertyInfo p in l_properties)
        {
            l_strQueryString = createQueryStringByLike(p_course, p_strs, l_strQueryString, p);
        }

        return TransferSqltoObject(l_strQueryString);
    }

    private String createQueryStringByLike(Object p_course, String[] p_strs, String l_strQueryString, PropertyInfo p)
    {
        foreach (String s in p_strs)
        {
            if (s.GetType().Equals(typeof(String)))
            {
                if (s.Equals(p.Name))
                {
                    l_strQueryString += " AND " + s + " LIKE'%" + p.GetValue(p_course, null).ToString() + "%'";
                }
            }
            else
                l_strQueryString += " AND " + s + "LIKE %" + p.GetValue(p_course, null).ToString() + "";

        }
        return l_strQueryString;
    }

	
}