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)); }