public List <ASSETKKF_MODEL.Data.Mssql.Mcis.MsDrawingPath> GetData(ASSETKKF_MODEL.Request.Mcis.MsDrawingPathReq d)
{
DynamicParameters param = new DynamicParameters();
param.Add("@DrawingCd", d.DrawingCd);
param.Add("@Itemno", d.Itemno);
param.Add("@PathName", d.PathName);
param.Add("@PathLink", d.PathLink);
param.Add("@EditUser", d.EditUser);
param.Add("@EditDate", d.EditDate);
//param.Add("@txtSearch", $"%{d.txtSearch.GetValue()}%");
string cmd = "SELECT * ,ROW_NUMBER() OVER(ORDER BY DrawingCd,itemno) AS RowID" +
$" , (SELECT TOP 1 DrawingNmTh FROM mmDrawing WHERE mmDrawing.DrawingCd = mcis.dbo.MsDrawingPath.DrawingCd) AS DrawingNmTh " +
$" FROM mcis.dbo.MsDrawingPath " +
$"WHERE (@DrawingCd IS NULL OR DrawingCd = @DrawingCd) " +
$" AND (@Itemno IS NULL OR Itemno = @Itemno) " +
$" AND (@PathName IS NULL OR PathName = @PathName) " +
$" AND (@PathLink IS NULL OR PathLink = @PathLink) " +
$" AND (@EditUser IS NULL OR EditUser = @EditUser) " +
$" AND (@EditDate IS NULL OR EditDate = @EditDate) " +
//$"AND (DrawingCd LIKE @txtSearch OR DrawingCd LIKE @txtSearch) " +
"ORDER BY ;";
var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.MsDrawingPath>(cmd, param).ToList();
return(res);
}
public List <ASSETKKF_MODEL.Data.Mssql.Mcis.MsDrawingPath> Search(ASSETKKF_MODEL.Request.Mcis.MsDrawingPathReq d)
{
DynamicParameters param = new DynamicParameters();
param.Add("@DrawingCdIsNull", $"%{d.DrawingCd.Trim()}%");
/*
* param.Add("@ItemnoIsNull", d.Itemno.ListNull());
* param.Add("@PathNameIsNull", d.PathName.ListNull());
* param.Add("@PathLinkIsNull", d.PathLink.ListNull());
* param.Add("@EditUserIsNull", d.EditUser.ListNull());
* param.Add("@EditDateIsNull", d.EditDate.ListNull());
*
* param.Add("@txtSearch", $"%{d.txtSearch.GetValue()}%");
*/
string cmd = "SELECT * ,ROW_NUMBER() OVER(ORDER BY DrawingCd,itemno) AS RowID" +
$" , (SELECT TOP 1 DrawingNmTh FROM mmDrawing WHERE mmDrawing.DrawingCd = mcis.dbo.MsDrawingPath.DrawingCd) AS DrawingNmTh " +
$" FROM mcis.dbo.MsDrawingPath " +
$"WHERE (DrawingCd LIKE @DrawingCdIsNull ) " +
//$"WHERE (DrawingCd LIKE '%"+d.DrawingCd.Trim()+"%') " +
/*
* $"AND (@ItemnoIsNull IS NULL OR Itemno IN ('{ d.Itemno.Join("','") }')) " +
* $"AND (@PathNameIsNull IS NULL OR PathName IN ('{ d.PathName.Join("','") }')) " +
* $"AND (@PathLinkIsNull IS NULL OR PathLink IN ('{ d.PathLink.Join("','") }')) " +
* $"AND (@EditUserIsNull IS NULL OR EditUser IN ('{ d.EditUser.Join("','") }')) " +
* $"AND (@EditDateIsNull IS NULL OR EditDate IN ('{ d.EditDate.Join("','") }')) " +
* $"AND (DrawingCd LIKE @txtSearch OR DrawingCd LIKE @txtSearch) " +
*/
$"ORDER BY DrawingCd;";
var res = Query <ASSETKKF_MODEL.Data.Mssql.Mcis.MsDrawingPath>(cmd, param).ToList();
return(res);
}
