我想要在DAL层写个方法,去查询总和

[otto_zuo]

select sum(orderPrice) from orderCar where DateDiff(dd,[orderTime],getdate())=0

这个是SQL语句 ,就是不知道在DAL里咋写方法..让BLL层获取

public class getCountDAL
    {

        private static string connection = ConfigurationManager.AppSettings["StrConn"].ToString();


    }

[xcydj]

[otto_zuo]

求高人指点一二..只求个提示

[yyl8781697]

DAL层

public class getCountDAL
{
    private static string connection = ConfigurationManager.AppSettings["StrConn"].ToString();
    
    public DataTable GetData()
    {
       string sql="select sum(orderPrice) from orderCar where DateDiff(dd,[orderTime],getdate())=0"
       DataTable dt=SQLHELPER.ExecuteDataTable(sql);//这里需要一个sql帮助类 帮助查询
       return dt;
    }
 }

BLL层

public .... MethodName(...)
{
   ....
   DataTbale dt=(new getCountDAL()).GetData();//调用DAL中的方法
   .....
}

[LHNET66]