public static string GetCcodesDisplayName(_Pccode pccode, string ActualValue)
{
string strDisplay = string.Empty;
strDisplay = facade.GetCcodesDisplayName(pccode, ActualValue);
return(strDisplay);
}
public string GetCcodesDisplayName(_Pccode Pccode, string ActualValue)
{
string strDispName = string.Empty;
StringBuilder strSqlWhere = new StringBuilder();
strSqlWhere.Append(" SELECT * FROM [ILIMS_BasicData].[dbo].[c_codes] ");
strSqlWhere.Append(" WHERE 1=1 ");
DataSet ds = new DataSet();
if (!string.IsNullOrWhiteSpace(Pccode.ToString()))
{
strSqlWhere.AppendFormat(" AND pccode='{0}' ", Enum.Parse(typeof(_Pccode), Pccode.ToString()).GetHashCode());
}
strSqlWhere.AppendFormat(" AND ccode='{0}'", ActualValue);
ds = DBHelper.ExecuteDataSet(strSqlWhere.ToString());
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
if (row["cname"] != DBNull.Value)
{
strDispName = row["cname"].ToString();
}
}
}
return strDispName;
}
public string GetCcodesDisplayName(_Pccode Pccode, string ActualValue)
{
string strDispName = string.Empty;
StringBuilder strSqlWhere = new StringBuilder();
strSqlWhere.Append(" SELECT * FROM [ILIMS_BasicData].[dbo].[c_codes] ");
strSqlWhere.Append(" WHERE 1=1 ");
DataSet ds = new DataSet();
if (!string.IsNullOrWhiteSpace(Pccode.ToString()))
{
strSqlWhere.AppendFormat(" AND pccode='{0}' ", Enum.Parse(typeof(_Pccode), Pccode.ToString()).GetHashCode());
}
strSqlWhere.AppendFormat(" AND ccode='{0}'", ActualValue);
ds = DBHelper.ExecuteDataSet(strSqlWhere.ToString());
if (ds != null && ds.Tables.Count > 0)
{
foreach (DataRow row in ds.Tables[0].Rows)
{
if (row["cname"] != DBNull.Value)
{
strDispName = row["cname"].ToString();
}
}
}
return(strDispName);
}
public string GetCcodesDisplayName(_Pccode pccode, string ActualValue)
{
return this.LogicDal.GetCcodesDisplayName(pccode, ActualValue);
}
public static string GetCcodesDisplayName(_Pccode pccode, string ActualValue)
{
string strDisplay = string.Empty;
strDisplay = facade.GetCcodesDisplayName(pccode, ActualValue);
return strDisplay;
}
public string GetCcodesDisplayName(_Pccode pccode, string ActualValue)
{
return(this.LogicDal.GetCcodesDisplayName(pccode, ActualValue));
}
