/*
* {
* "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);
