Example #1
0
 protected string GetVersionName()
 {
     return(GetJsString(CSBasePage.GetVersionName(false)));
 }
        public static Dictionary <string, string> GetDynamicsid(string sid)
        {
            //string xmlData = "";
            Dictionary <string, string> dict = new Dictionary <string, string>();
            string connectionString          = ConfigHelper.GetDBConnection();
            List <CSBusiness.Version> list   = (CSFactory.GetCacheSitePref()).VersionItems;

            CSBusiness.Version item =
                list.Find(x => x.Title.ToLower() == CSBasePage.GetVersionName().ToLower());

            int versionName = 43;

            if (item != null)
            {
                versionName = item.VersionId;
            }
            String ProcName = "pr_site_get_dynamic_sid";

            SqlParameter[] ParamVal = new SqlParameter[6];
            ParamVal[0] = new SqlParameter("sid", sid ?? string.Empty);
            ParamVal[1] = new SqlParameter("@versionid", versionName);
            bool hasRecord = false;

            using (SqlDataReader reader = BaseSqlHelper.ExecuteReader(connectionString, ProcName, ParamVal))
            {
                while (reader.Read())
                {
                    dict.Add("sid", sid);
                    dict.Add("source", reader["source"].ToString());
                    dict.Add("media", reader["media"].ToString());
                    dict.Add("ProjectCode", reader["ProjectCode"].ToString());
                    dict.Add("PhoneNumber", reader["PhoneNumber"].ToString());
                    //xmlData = reader["DataXML"].ToString();
                    hasRecord = true;
                }
            }


            //if (!hasRecord)
            //{
            //    string sid1 = GetDynamicVersionData("sid");
            //    ProcName = "pr_site_get_dynamic_sid";
            //    SqlParameter[] ParamVal1 = new SqlParameter[6];
            //    ParamVal1[0] = new SqlParameter("sid", sid1 ?? string.Empty);
            //    ParamVal1[1] = new SqlParameter("@versionid", versionName);
            //    using (SqlDataReader reader = BaseSqlHelper.ExecuteReader(connectionString, ProcName, ParamVal1))
            //    {
            //        while (reader.Read())
            //        {
            //            dict.Add("sid", sid);
            //            dict.Add("source", reader["source"].ToString());
            //            dict.Add("media", reader["media"].ToString());
            //            dict.Add("ProjectCode", reader["ProjectCode"].ToString());
            //            dict.Add("PhoneNumber", reader["PhoneNumber"].ToString());
            //        }
            //    }


            //}
            return(dict);
        }