public List <ASSETKKF_MODEL.Data.Mssql.Mcis.zValue> Search(ASSETKKF_MODEL.Request.Mcis.zValueReq d)
{
DynamicParameters param = new DynamicParameters();
/*
* param.Add("@ValueNameIsNull", d.ValueName.ListNull());
* param.Add("@ValueDataIsNull", d.ValueData.ListNull());
* param.Add("@ValueDesIsNull", d.ValueDes.ListNull());
* param.Add("@txtSearch", $"%{d.txtSearch.GetValue()}%");
*/
string cmd = "";
/*
* string cmd = "SELECT * FROM mcis.dbo.zValue " +
* $"WHERE (@ValueNameIsNull IS NULL OR ValueName IN ('{ d.ValueName.Join("','") }')) " +
* $"AND (@ValueDataIsNull IS NULL OR ValueData IN ('{ d.ValueData.Join("','") }')) " +
* $"AND (@ValueDesIsNull IS NULL OR ValueDes IN ('{ d.ValueDes.Join("','") }')) " +
* $"AND (ValueName LIKE @txtSearch OR ValueName LIKE @txtSearch) " +
* //"ORDER BY ;";
*/
var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.zValue>(cmd, param).ToList();
return(res);
}
public List <ASSETKKF_MODEL.Data.Mssql.Mcis.zValue> GetData(ASSETKKF_MODEL.Request.Mcis.zValueReq d)
{
DynamicParameters param = new DynamicParameters();
param.Add("@ValueName", d.ValueName);
param.Add("@ValueData", d.ValueData);
param.Add("@ValueDes", d.ValueDes);
//param.Add("@txtSearch", $"%{d.txtSearch.GetValue()}%");
string cmd = "SELECT * FROM mcis.dbo.zValue " +
$"WHERE (@ValueName IS NULL OR ValueName = @ValueName) " +
$" AND (@ValueData IS NULL OR ValueData = @ValueData) " +
$" AND (@ValueDes IS NULL OR ValueDes = @ValueDes) " +
//$"AND (ValueName LIKE @txtSearch OR ValueName LIKE @txtSearch) " +
"ORDER BY ValueName ;";
var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.zValue>(cmd, param).ToList();
return(res);
}
