/* * { * "artist": [ * { * "ting_uid": "1025", * "name": "\u674e\u5b87\u6625", * "firstchar": "L", * "gender": "1", * "area": "0", * "country": "\u4e2d\u56fd", * "avatar_big": "http:\/\/musicdata.baidu.com\/data2\/pic\/138f4003010b70de881482c6ec895f03\/246707758\/246707758.jpg", * "avatar_middle": "http:\/\/musicdata.baidu.com\/data2\/pic\/369fca7ee5d59ba4ecbe8eedcc83950b\/246707763\/246707763.jpg", * "avatar_small": "http:\/\/musicdata.baidu.com\/data2\/pic\/4f6f6dc86f2172e5c3bc2119dd32341d\/246707808\/246707808.jpg", * "avatar_mini": "http:\/\/musicdata.baidu.com\/data2\/pic\/073d9f36756f54edd189a5aef71803de\/246707811\/246707811.jpg", * "albums_total": "38", * "songs_total": "232", * "artist_id": "1", * "piao_id": "0" * }, * { * "ting_uid": "1026", * "name": "\u5f20\u9753\u9896", * "firstchar": "Z", * "gender": "1", * "area": "0", * "country": "\u4e2d\u56fd", * "avatar_big": "http:\/\/musicdata.baidu.com\/data2\/pic\/05bc6f6db83ed75e53ad6c7eeaf5517a\/246709972\/246709972.jpg", * "avatar_middle": "http:\/\/musicdata.baidu.com\/data2\/pic\/f6a9c9f961c406104b3763d8f815abed\/246709976\/246709976.jpg", * "avatar_small": "http:\/\/musicdata.baidu.com\/data2\/pic\/7a2d717c0a473a91090a069bfe2621e5\/246709984\/246709984.jpg", * "avatar_mini": "http:\/\/musicdata.baidu.com\/data2\/pic\/5bc65fbe33d3a9899505ba979c6b0b6a\/246709985\/246709985.jpg", * "albums_total": "47", * "songs_total": "273", * "artist_id": "2", * "piao_id": "0" * }, * { * "ting_uid": "1027", * "name": "\u80e1\u7075", * "firstchar": "H", * "gender": "1", * "area": "0", * "country": "\u4e2d\u56fd", * "avatar_big": "http:\/\/musicdata.baidu.com\/data2\/pic\/119146258\/119146258.jpg", * "avatar_middle": "http:\/\/musicdata.baidu.com\/data2\/pic\/119146265\/119146265.jpg", * "avatar_small": "http:\/\/musicdata.baidu.com\/data2\/pic\/116050153\/116050153.jpg", * "avatar_mini": "http:\/\/musicdata.baidu.com\/data2\/pic\/116050172\/116050172.jpg", * "albums_total": "8", * "songs_total": "73", * "artist_id": "3", * "piao_id": "0" * }, * { * "ting_uid": "1028", * "name": "\u4f55\u6d01", * "firstchar": "H", * "gender": "1", * "area": "0", * "country": "\u4e2d\u56fd", * "avatar_big": "http:\/\/musicdata.baidu.com\/data2\/pic\/246707559\/246707559.jpg", * "avatar_middle": "http:\/\/musicdata.baidu.com\/data2\/pic\/246707565\/246707565.jpg", * "avatar_small": "http:\/\/musicdata.baidu.com\/data2\/pic\/246707590\/246707590.jpg", * "avatar_mini": "http:\/\/musicdata.baidu.com\/data2\/pic\/246707595\/246707595.jpg", * "albums_total": "7", * "songs_total": "91", * "artist_id": "4", * "piao_id": "0" * }, * { * "ting_uid": "1029", * "name": "\u5468\u7b14\u7545", * "firstchar": "Z", * "gender": "1", * "area": "0", * "country": "\u4e2d\u56fd", * "avatar_big": "http:\/\/musicdata.baidu.com\/data2\/pic\/65f9d4f188e2d8e9bb71b78a3648283f\/246710166\/246710166.jpg", * "avatar_middle": "http:\/\/musicdata.baidu.com\/data2\/pic\/62f8c0853ef1a076afaf090ec942cccd\/246710171\/246710171.jpg", * "avatar_small": "http:\/\/musicdata.baidu.com\/data2\/pic\/9073782ec532b3a5123fa1bc60c93b5a\/246710185\/246710185.jpg", * "avatar_mini": "http:\/\/musicdata.baidu.com\/data2\/pic\/00ed3c85b5c6af484e7badbc36d4f6f6\/246710188\/246710188.jpg", * "albums_total": "21", * "songs_total": "140", * "artist_id": "5", * "piao_id": "0" * } * ], * "nums": 2000, * "noFirstChar": "", * "havemore": 1 * } */ #endregion </param> /// <summary> /// getlist /// </summary> /// <param name="order"> /// <param name="limit"></param> /// <param name="offset"></param> /// <param name="area"></param> /// <param name="tArtist"></param> /// <returns></returns> public static ArtistMethod GetList(int order, int limit, int offset, TArea area, TArtist tArtist) { ArtistMethod artist = ArtistMethod.New; artist.Value = string.Format("{0}.getList", Prefix); artist.Parameters.Add(Parameter.Make("order", order.ToString())); artist.Parameters.Add(Parameter.Make("limit", limit.ToString())); artist.Parameters.Add(Parameter.Make("offset", offset.ToString())); artist.Parameters.Add(Parameter.Make("area", ((int)area).ToString())); artist.Parameters.Add(Parameter.Make("sex", ((int)tArtist).ToString())); return(artist); }
public int AddArea(TArea area) { int stat = 0; string code = area.code; string name = area.name; string cityId = area.cityId; NameValueCollection nvc = new NameValueCollection(); nvc.Add("@code", code); nvc.Add("@name", name); nvc.Add("@cityId", cityId); dh.Open(); stat = dh.ExecuteNonQuery(CommandType.Text, "Insert into area (code,name,cityId) value(@code,@name,@cityId)", nvc); dh.Close(); return(stat); }
public int UpdateArea(TArea area, int id) { int stat = 0; string code = area.code; string name = area.name; string cityId = area.cityId; NameValueCollection nvc = new NameValueCollection(); nvc.Add("@code", code); nvc.Add("@name", name); nvc.Add("@cityId", cityId); nvc.Add("@ID", id.ToString()); dh.Open(); stat = dh.ExecuteNonQuery(CommandType.Text, "Update area set code=@code,name=@name,cityId=@cityId where ID=@ID", nvc); dh.Close(); return(stat); }
public TArea GetAreaByCode(string Code) { TArea ta = new TArea(); NameValueCollection nvc = new NameValueCollection(); nvc.Add("@code", Code); dh.Open(); using (DbDataReader dr = dh.ExecuteReader(CommandType.Text, "Select ID,code,name,cityId from area where code=@code", nvc)) { if (dr.HasRows) { dr.Read(); ta.id = Convert.ToInt32(dr[0].ToString()); ta.code = dr[1].ToString().Trim(); ta.name = dr[2].ToString().Trim(); ta.cityId = dr[3].ToString().Trim(); } } dh.Close(); return(ta); }
public TArea GetAreaByID(int AreaID) { TArea ta = new TArea(); NameValueCollection nvc = new NameValueCollection(); nvc.Add("@ID", AreaID.ToString()); dh.Open(); using (DbDataReader dr = dh.ExecuteReader(CommandType.Text, "Select ID,code,name,cityId from area where ID=@ID", nvc)) { if (dr.HasRows) { dr.Read(); ta.id = AreaID; ta.code = dr[1].ToString().Trim(); ta.name = dr[2].ToString().Trim(); ta.cityId = dr[3].ToString().Trim(); } } dh.Close(); return(ta); }
public override string GetFullText(Connection conn) { TUCLP uclp = TUCLP.Seek(conn, this.uclp); //string filtered = FilterPrefixes(uclp.name, UclpPrefixes); TArea area = TArea.Seek(uclp.area); TRegion region = TRegion.Seek(uclp.area, uclp.region); StringBuilder fullText = new StringBuilder(); //if (area.name != filtered || region.name != filtered) fullText.AppendFormat("Област {0}, Община {1}, ", area.name, region.name); fullText.Append(uclp.name); if (street != 0) { fullText.AppendFormat(", {0}", TStreet.Seek(conn, this.uclp, street).name); } AddressPart[] parts = new AddressPart[] { new AddressPart("No ", adrNo), new AddressPart("Блок ", blockNo), new AddressPart("Подн.", subNo), new AddressPart("Вх.", entrance), new AddressPart("Ет.", floor), new AddressPart("Ап.", apartment) }; foreach (AddressPart part in parts) { if (part.text != "") { fullText.AppendFormat(", {0}{1}", part.prefix, part.text); } } return(fullText.ToString()); }
/// <summary> /// get artist list by area and type /// </summary> /// <param name="tArea"></param> /// <param name="tArtist"></param> /// <returns></returns> public abstract Task <ArtistContent> GetList(TArea tArea, TArtist tArtist);