complex query

[tenvick]

the sql query \"select count(*) from ReserveOrder where Convert(varchar(10),OrderTime,101) =Convert(varchar(10),@OrderTime,101) and (RealName = @RealName or TEl=@TEl)\"

the easyobject how to do that?

[mgnoonan]

In this case, you are better off not using the dynamic query syntax and just writing your own custom load function in the concrete class, such as below.

Code: Select all

public int GetCount(DateTime OrderTime, string RealName, string TEl)
{
   string sqlCommand = \"select count(*) from \" + this.SchemaTableViewWithSeparator + this.TableName + \" where Convert(varchar(10),OrderTime,101) =Convert(varchar(10),@OrderTime,101) and (RealName = @RealName or TEl=@TEl)\";
   DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
   
   // Add procedure parameters (change the DbTypes to match your database)
   db.AddInParameter(dbCommand, \"OrderTime\", DbType.DateTime, OrderTime);
   db.AddInParameter(dbCommand, \"RealName\", DbType.AnsiString, RealName);
   db.AddInParameter(dbCommand, \"TEl\", DbType.AnsiString, TEl);
   
   // returns a bool if any rows loaded
   return (int)base.LoadFromSqlScalar(dbCommand);
}