public Budget_iconAtHome SelectByOID(Guid guidiconOID)
        {
            Budget_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, sqlParam);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    icon          = new Budget_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);
        }
        public List <Budget_iconAtHome> SelectAll()
        {
            List <Budget_iconAtHome> iconAtHomeList = null;

            try
            {
                string sSQL = "SELECT * FROM iconAtHome Order By Seq";

                DataSet ds = SqlHelper.ExecuteDataset(ConnectionString, CommandType.Text, sSQL);
                if (ds.Tables[0].Rows.Count > 0)
                {
                    iconAtHomeList = new List <Budget_iconAtHome>();
                    Budget_iconAtHome icon = null;
                    for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                    {
                        icon          = new Budget_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);
        }