示例#1
0
        private void LoadData()
        {
            SqlParameter par = new SqlParameter("@groupID", _id);

            DataTable dt = DB.TableFromProcedure("getGroup", new SqlParameter[1] { par });

            if (dt == null || dt.Rows.Count == 0)
            {
                _id = 0;
                return;
            }
            DataRow row = dt.Rows[0];

            _name = row["g_name"].ToString();
            _creator = row["g_user_name"].ToString();
            _category = new Category();
            _category.ID = (int)row["_id"];
            _category.Name = row["_name"].ToString();
            _description = row["g_description"].ToString();
            _gonggao = row["g_gonggao"].ToString();
            _tags = row["g_tags"].ToString();
            _uptime = (DateTime)row["g_uptime"];

            if (!int.TryParse(row["g_redu"].ToString(), out _redu))
                _redu = 0;
        }
示例#2
0
        /// <summary>
        /// category_b --> category
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public static Category ToCategory(int id)
        {
            int cid = 10;
            if (id == 101 || id == 108 || id == 115 || id == 116 || id == 117 || id == 118 || id == 119 || id == 121) cid = 12;
            else if (id == 102 || id == 106 || id == 123) cid = 21;
            else if (id == 103 || id == 110 || id == 111) cid = 15;
            else if (id == 104 || id == 109) cid = 18;
            else if (id == 105) cid = 11;
            else if (id == 107) cid = 21;
            else if (id == 112 || id == 113) cid = 16;
            else if (id == 114) cid = 17;
            else if (id == 120) cid = 13;
            else if (id == 122) cid = 18;
            else if (id == 124) cid = 10;

            Category cat = new Category();
            cat.ID = cid;
            if (cid > 10) cat.Name = Category.AllCategory[cid];
            else cat.Name = "�������";

            return cat;
        }