protected string query(ref tablesViewModel viewModel)
{
string ret = "";
tableDisp tmpModel = viewModel.editModel;
tableLib tlib = new tableLib(connEPLabDB);
var paras = new Dapper.DynamicParameters();
paras.Add("TableName", tmpModel.tableName + "", DbType.String);
paras.Add("TableDesc", tmpModel.tableDesc + "", DbType.String);
string sql = @"
select top 1000 *
from tables
where (@TableName='' or tablename=@TableName)
and (@TableDesc='' or tableDesc=@TableDesc)
";
var qry = tlib.Query <tableDisp>(sql, paras);
if (qry.Any())
{
viewModel.queryResult = qry.ToList();
}
else
{
viewModel.queryResult = null;
}
return(ret);
}
public tablesViewModel()
{
//tables = new List<Tables>();
editModel = new tableDisp();
queryResult = new List <tableDisp>();
}
