/// <summary>
/// 获取短链接并插入数据库
/// </summary>
/// <param name="url"></param>
/// <returns></returns>
public static string DataBaseShortUrl(string url)
{
using (var db = new ShortUrldbEntities1())
{
string sql = $"select * from t_ShortUrl where Url COLLATE Chinese_PRC_CS_AS = '{url}'";
var turl = db.Database.SqlQuery <t_ShortUrl>(sql).FirstOrDefault();
if (turl != null)
{
return(turl.Code);
}
else
{
var shorUrlList = UntilHelper.GetShortUrl(url);
foreach (var item in shorUrlList)
{
sql = $"select * from t_ShortUrl where Code COLLATE Chinese_PRC_CS_AS = '{url}'";
var code = db.Database.SqlQuery <t_ShortUrl>(sql).FirstOrDefault();
if (code == null)
{
db.t_ShortUrl.Add(new t_ShortUrl
{
Code = item,
Url = url
});
db.SaveChanges();
return(item);
}
}
return("短链接冲突");
}
}
}
/// <summary>
///数据库获取原URL
/// </summary>
/// <param name="shortUrl"></param>
/// <returns></returns>
public static string GetLongUrl(string url)
{
string[] str = url.Split('/');
url = str[str.Length - 1];
using (var db = new ShortUrldbEntities1())
{
string sql = $"select * from t_ShortUrl where Code COLLATE Chinese_PRC_CS_AS = '{url}'";
var code = db.Database.SqlQuery <t_ShortUrl>(sql).FirstOrDefault();
if (code != null)
{
return(code.Url);
}
}
return(string.Empty);
}