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