Esempio n. 1
0
        public iconAtHome SelectByOID(string PrefixTable, Guid guidiconOID)
        {
            iconAtHome icon = null;

            try
            {
                string         sSQL     = "SELECT * FROM ##iconAtHome WHERE iconOID=@iconOID";
                SqlParameter[] sqlParam = new SqlParameter[1];
                sqlParam[0]       = new SqlParameter("@iconOID", SqlDbType.UniqueIdentifier);
                sqlParam[0].Value = guidiconOID;
                DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL.Replace("##", PrefixTable), sqlParam);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    icon          = new iconAtHome();
                    icon.iconOID  = new Guid(ds.Tables[0].Rows[0]["iconOID"].ToString());
                    icon.Seq      = Convert.ToInt32(ds.Tables[0].Rows[0]["Seq"].ToString());
                    icon.FileName = ds.Tables[0].Rows[0]["FileName"].ToString();
                    icon.Title    = ds.Tables[0].Rows[0]["Title"].ToString();
                    icon.ShortDes = ds.Tables[0].Rows[0]["ShortDes"].ToString();
                    icon.iconURL  = ds.Tables[0].Rows[0]["iconURL"].ToString();
                }
            }
            catch (Exception ex) { }
            return(icon);
        }
Esempio n. 2
0
        public List <iconAtHome> SelectAll(string PrefixTable)
        {
            List <iconAtHome> iconAtHomeList = null;

            try
            {
                string sSQL = "SELECT * FROM ##iconAtHome";

                DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL.Replace("##", PrefixTable));
                if (ds.Tables[0].Rows.Count > 0)
                {
                    iconAtHomeList = new List <iconAtHome>();
                    iconAtHome icon = null;
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        icon          = new iconAtHome();
                        icon.iconOID  = new Guid(ds.Tables[0].Rows[i]["iconOID"].ToString());
                        icon.Seq      = Convert.ToInt32(ds.Tables[0].Rows[i]["Seq"].ToString());
                        icon.FileName = ds.Tables[0].Rows[i]["FileName"].ToString();
                        icon.Title    = ds.Tables[0].Rows[i]["Title"].ToString();
                        icon.ShortDes = ds.Tables[0].Rows[i]["ShortDes"].ToString();
                        icon.iconURL  = ds.Tables[0].Rows[i]["iconURL"].ToString();
                        iconAtHomeList.Add(icon);
                    }
                }
            }
            catch (Exception ex) { }
            return(iconAtHomeList);
        }