public DataTable getcount(CV_EQM_EQUIP_SPOT_CHECK_QueryParam qp)
{
DataTable list = null;
string Sql = @" select count(*)
from CV_EQM_EQUIP_SPOT_CHECK
where 1=1 ";
if (!string.IsNullOrEmpty(qp.DeviceType))
{
Sql += " and DeviceType = N'" + qp.DeviceType + "' ";
}
if (!string.IsNullOrEmpty(qp.DeviceName))
{
Sql += " and DeviceName = N'" + qp.DeviceName + "' ";
}
if (!string.IsNullOrEmpty(qp.DeviceSpecID))
{
Sql += " and DeviceSpecID = N'" + qp.DeviceSpecID + "' ";
}
list = BSCBO.GetDataTableBySql(Sql);
return(list);
//return Request.CreateResponse(HttpStatusCode.OK, Sql);
}
public EQM_Page_Return Getpartdata(CV_EQM_EQUIP_SPOT_CHECK_QueryParam param)
{
EQM_Page_Return entities = CheckBO.GetEntities(param);
return(entities);
}
