public DataSet GetListPaged(Model_DatabaseCopyLibraryParam model, int PageIndex, int PageSize, out int rCount, out int pCount)
{
StringBuilder builder = new StringBuilder();
builder.Append("SELECT row_number() over(order by DatabaseCopyLibrary.UpdateTime DESC ) AS r_n, DataBaseName,DataBaseAddress,DatabaseCopyLibrary_ID,DatabaseCopyLibrary_Remark,LoginName,LoginPassword,CustomerInfo.CustomerInfo_NameCN \r\n from DatabaseCopyLibrary inner join CustomerInfo on CustomerInfo.CustomerInfo_ID= DatabaseCopyLibrary.CustomerInfo_ID\r\n where 1=1 ");
if (!string.IsNullOrEmpty(model.CustomerInfo_NameCN))
{
builder.Append(" and CustomerInfo.CustomerInfo_NameCN like'" + model.CustomerInfo_NameCN + "%'");
}
if (!string.IsNullOrEmpty(model.DatabaseCopyLibrary_ID))
{
builder.Append(" and DatabaseCopyLibrary.DatabaseCopyLibrary_ID like'" + model.DatabaseCopyLibrary_ID + "%'");
}
if (!string.IsNullOrEmpty(model.DataBaseName))
{
builder.Append(" and DatabaseCopyLibrary.DataBaseName like'" + model.DataBaseName + "%'");
}
return(sys.GetRecordByPage(builder.ToString(), PageIndex, PageSize, out rCount, out pCount));
}
public DataSet GetListPaged(Model_DatabaseCopyLibraryParam model, int PageIndex, int PageSize, out int rCount, out int pCount)
{
return(this.dal.GetListPaged(model, PageIndex, PageSize, out rCount, out pCount));
}
