public DataTable GetPCode(string Pname)
{
try
{
// string SQL = "Select Isnull(Max(right(PCODE,3)),0) as Num from TiaERPAppReg where " + left + "='" + strname + "' And IsNumeric(Right(pcode, 3)) > 0";
string SQL = "select MAX(Substring(PtCode,8,10)) from ACPMST_temp where PtCode like '%" + Pname + "%'";
return(objdal.getDataNew_code(SQL));
}
catch (Exception)
{
throw;
}
}