public List <ApplicationElement> SelectByOID(string PrefixTable, Guid guidElementOID)
{
List <ApplicationElement> allKey = null;
try
{
string sSQL = "SELECT Culture.*,Element.ElementKey FROM ##CL_ApplicationElementCulture Culture Left Join ##CL_ApplicationElement Element on Element.ElementOID = Culture.ElementOID WHERE Culture.ElementOID=@ElementOID";
SqlParameter[] sqlParam = new SqlParameter[1];
sqlParam[0] = new SqlParameter("@ElementOID", SqlDbType.UniqueIdentifier);
sqlParam[0].Value = guidElementOID;
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL.Replace("##", PrefixTable), sqlParam);
if (ds.Tables[0].Rows.Count > 0)
{
DataRow oneRow;
allKey = new List <ApplicationElement>();
ApplicationElement elk = new ApplicationElement();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
oneRow = ds.Tables[0].Rows[i];
elk = new ApplicationElement();
elk.ElementOID = new Guid(oneRow["ElementOID"].ToString());
elk.Key = oneRow["ElementKey"].ToString();
elk.Culture = oneRow["Culture"].ToString();
elk.Value = oneRow["PropertyValue"].ToString();
allKey.Add(elk);
}
}
}
catch (Exception ex)
{
}
return(allKey);
}
public List <ApplicationElement> SelectAll(string PrefixTable)
{
List <ApplicationElement> allKey = null;
try
{
string sSQL = "SELECT Culture.*,Element.ElementKey FROM ##CL_ApplicationElementCulture Culture Left Join ##CL_ApplicationElement Element on Element.ElementOID = Culture.ElementOID";
DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL.Replace("##", PrefixTable));
if (ds.Tables[0].Rows.Count > 0)
{
DataRow oneRow;
allKey = new List <ApplicationElement>();
ApplicationElement elk = new ApplicationElement();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
oneRow = ds.Tables[0].Rows[i];
elk = new ApplicationElement();
elk.ElementOID = new Guid(oneRow["ElementOID"].ToString());
elk.Key = oneRow["ElementKey"].ToString();
elk.Culture = oneRow["Culture"].ToString();
elk.Value = oneRow["PropertyValue"].ToString();
allKey.Add(elk);
}
}
}
catch (Exception ex)
{
}
return(allKey);
}