public List <ASAUDITPOSTTRN> getPOSTTRNDuplicate(AuditPostTRNReq d, SqlTransaction transac = null, string conStr = null)
{
DynamicParameters param = new DynamicParameters();
sql = " select * from [FT_ASAUDITPOSTTRN_COMPANY] (" + QuoteStr(d.COMPANY) + ") as B ";
sql += " where SQNO = " + QuoteStr(d.SQNO);
sql += " and COMPANY = " + QuoteStr(d.COMPANY);
sql += " AND B.ASSETNO IN ( SELECT X.ASSETNO FROM [FT_ASAUDITPOSTTRN_COMPANY] (" + QuoteStr(d.COMPANY) + ") X ";
sql += " where X.SQNO = " + QuoteStr(d.SQNO);
sql += " and X.COMPANY = " + QuoteStr(d.COMPANY);
sql += " GROUP BY X.ASSETNO HAVING COUNT(X.ASSETNO) >1 ) ";
if (!String.IsNullOrEmpty(d.DEPCODEOL))
{
sql += " and DEPCODEOL = '" + d.DEPCODEOL + "'";
}
if (!String.IsNullOrEmpty(d.AREACODE))
{
sql += " and POSITCODE = '" + d.AREACODE + "'";
}
if (!String.IsNullOrEmpty(d.ASSETNO))
{
sql += " and ASSETNO = '" + d.ASSETNO + "'";
}
if (!String.IsNullOrEmpty(d.YEAR))
{
sql += " and YR = '" + d.YEAR + "'";
}
if (!String.IsNullOrEmpty(d.MN))
{
sql += " and MN = '" + d.MN + "'";
}
//if (!String.IsNullOrEmpty(d.DEPMST))
//{
// sql += " and DEPCODEOL in (SELECT [DEPCODEOL] ";
// sql += " FROM FT_ASAUDITCUTDATE() ";
// sql += " where DEPMST = '" + d.DEPMST + "'";
// sql += " and company = '" + d.COMPANY + "'";
// if (!String.IsNullOrEmpty(d.YEAR))
// {
// sql += " and YR = " + QuoteStr(d.YEAR);
// }
// if (!String.IsNullOrEmpty(d.MN))
// {
// sql += " and MN = " + QuoteStr(d.MN);
// }
// if (!String.IsNullOrEmpty(d.YRMN))
// {
// sql += " and YRMN = " + QuoteStr(d.YRMN);
// }
// sql += " group by[DEPCODEOL])";
//}
//if (!String.IsNullOrEmpty(d.cutdt))
//{
// sql += " and DATEADD(dd, 0, DATEDIFF(dd, 0, cutdt)) = DATEADD(dd, 0, DATEDIFF(dd, 0, " + QuoteStr(d.cutdt) + "))";
//}
if (!String.IsNullOrEmpty(d.OFFICECODE))
{
sql += " and OFFICECODE = '" + d.OFFICECODE + "'";
}
if (!String.IsNullOrEmpty(d.TYPECODE))
{
sql += " and TYPECODE = '" + d.TYPECODE + "'";
}
if (!String.IsNullOrEmpty(d.GASTCODE))
{
sql += " and GASTCODE = '" + d.GASTCODE + "'";
}
if (String.IsNullOrEmpty(d.orderby) || d.orderby.Equals("1"))
{
sql += " order by ASSETNO,OFFICECODE ";
}
if (d.orderby.Equals("2"))
{
sql += " order by OFFICECODE,ASSETNO ";
}
if (d.orderby.Equals("3"))
{
sql += " order by DEPCODEOL,OFFICECODE,ASSETNO ";
}
if (d.orderby.Equals("4"))
{
sql += " order by POSITCODE,OFFICECODE,ASSETNO ";
}
var res = Query <ASAUDITPOSTTRN>(sql, param, conStr).ToList();
return(res);
}
