¡¾·ÖÏíASP.net¡¿linq to sql¶¯Ì¬ÅÅÐò ½â¾ö·½°¸
*********
·ÖÊý²»¹»£¬Ö»ÄÜ·¢Õâ¶ùÁË¡£
*********
Ò»°ãÎÒÃÇʹÓÃÕâÑùµÄÅÅÐò·½Ê½£º
var DS = from a in DB.news where a.XXX == '1' orderby a.SSS,a.SSS2 descending select a;
Èç¹û¶¯Ì¬ÅÅÐòµÄ»°£¬Ê¹ÓÃswitchÒ²¿ÉÒÔÂú×ãÐèÇ󣬵«µ±ÅÅÐòÒÀ¾ÝºÜ¶àʱ£¬ÕâÏÔÈ»²»ÊÇÃ÷ÖÇÖ®¾Ù¡£
ÎÒÃÇ¿ÉÒÔÕâÑù×ö£º
var DS = from a in DB.news where a.XXX == '1' select a;
DS = LinqSort.OrderBy(DS, SortOrder.Value + " " + OrderDire.Value);
if (XXX)
DS = LinqSort.ThenBy(DS,SortOrder2.Value + " " + OrderDire.Value);
XXX.DataSource = DS.Skip(I).Take(PageSize);
·Ï»°²»¶à˵£¬LinqSortÀàÈçÏ£º
C# code:
using System;
using System.Linq;
using System.Linq.Expressions;
using System.Reflection;
namespace Name
{
public static class LinqSort
{
/// <summary>
/// Linq¶¯Ì¬ÅÅÐò
/// </summary>
/// <typeparam name="T">T</typeparam>
/// <param name="source">ÒªÅÅÐòµÄÊý¾ÝÔ´</param>
/// <param name="value">ÅÅÐòÒÀ¾Ý£¨¼Ó¿Õ¸ñ£©ÅÅÐò·½Ê½</param>
/// <returns>IOrderedQueryable</returns>
public static IOrderedQueryable<T> OrderBy<T>(this IQueryable<T> source, string value)
{
string[] arr = value.Split(' ');
string Name = arr[1].ToUpper() == "DESC" ? "OrderByDescending" : "Order
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽÎļþ
<folder state="unchecked" label="È«²¿">
¡¡¡¡<folder state="unchecked" isBra ......
C# code:
SqlConnection conn = CsDB.sqlcon();
SqlDataAdapter da = new SqlDataAdapter("select fwCoding from bjmuma_fwCoding where OrderNumber='" + Order + & ......
ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏÂ
±íÃû: hisdata
×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä
Id value state dattime
101 32.3 0 ......