NBear使用时遇到参数是数组时的问题 - NBear Google Group

Message from discussion NBear使用时遇到参数是数组时的问题

Teddy

More options Dec 5 2006, 7:17 am

From: Teddy <shijie...@gmail.com>

Date: Tue, 5 Dec 2006 20:17:22 +0800

Local: Tues, Dec 5 2006 7:17 am

Subject: Re: NBear使用时遇到参数是数组时的问题

  Reply to author
  |
  Forward
  | Print
  | View thread
  | Show original
  | Report this message
  | Find messages by this author
  

可以在使用 Gateway.FindArray<T_Sell>(TSell._.Fac_Code == "0" & (TSell._.City_ID
== 1 | TSell._..City_ID == 2) ) 这样的语法来查询。

Teddy

On 12/5/06, 寻路者 <181443...@qq.com> wrote:

> public interface T_Sell:Entity
> {
> [PrimaryKey]
> Guid ID
> {
> get;
> set;
> }

> string Fac_Code
> {
> get;
> set;
> }

> string City_ID
> {
> get;
> set;
> }

> [NotNull]
> DateTime Log_Time
> {
> get;
> set;
> }

> [FkReverseQuery(LazyLoad=true)]
> T_Factory Factory
> {
> get;
> set;
> }

> [FkReverseQuery(LazyLoad = true)]
> T_Area_City AreaCity
> {
> get;
> set;
> }
> 该表有2个外键,分别是City_ID(0对应表
> T_Area_City),Fac_Code(对应表T_Factory)
> 现在要求查询:一个厂家在某一城市或某几个城市的销售记录.
> 储存过程SQL语句:select * from T_Sell
> where(fac_code=0 and (city_ID=01 or city_ID=02))
> 这样City_ID就变成一个数组参数,这样的话要怎么用GateWay解决?

Reply to author Forward