public List <LendingInfoDetail> QueryDetails(GoodsDetailQueryParam queryParam)
{
string strSqlWhere = " select * from View_LendingInfoDetail where 1=1 and strWorkShopGUID = '" + queryParam.workShopGUID + "' ";
if (queryParam.nReturnState != -1)
{
strSqlWhere += " and nReturnState =" + queryParam.nReturnState + "";
}
if (queryParam.nLendingType != -1)
{
strSqlWhere += " and nLendingType =" + queryParam.nLendingType + "";
}
if (queryParam.strTrainmanNumber != null && queryParam.strTrainmanNumber != "")
{
strSqlWhere += " and strBorrowTrainmanNumber =" + queryParam.strTrainmanNumber + "";
}
if (queryParam.strTrainmanName != null && queryParam.strTrainmanName != "")
{
strSqlWhere += " and strBorrowTrainmanName =" + queryParam.strTrainmanName + "";
}
if (queryParam.nBianHao != -1)
{
strSqlWhere += " and strLendingExInfo =" + queryParam.nBianHao + "";
}
if ((queryParam.strOrderField == null) || (queryParam.strOrderField == ""))
{
strSqlWhere += " order by dtBorrowTime Desc ";
}
else
{
strSqlWhere += " order by " + queryParam.strOrderField + " Desc";
}
return(QueryDetails_DTToList(SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, strSqlWhere.ToString()).Tables[0]));
}
public void QueryDetailsTest()
{
// string ConnectionString = string.Empty; // TODO: 初始化为适当的值
DBLendingInfoDetail target = new DBLendingInfoDetail(connstr); // TODO: 初始化为适当的值
GoodsDetailQueryParam queryParam = null; // TODO: 初始化为适当的值
List <LendingInfoDetail> expected = null; // TODO: 初始化为适当的值
List <LendingInfoDetail> actual;
queryParam = new GoodsDetailQueryParam();
queryParam.nBianHao = -1;
queryParam.strTrainmanName = "";
queryParam.strTrainmanNumber = "";
queryParam.nLendingType = 1;
queryParam.nReturnState = 0;
actual = target.QueryDetails(queryParam);
//Assert.AreEqual(expected, actual);
Assert.IsNotNull(actual);
//Assert.Inconclusive("验证此测试方法的正确性。");
}
