/// <summary>
/// 添加/修改音乐
/// </summary>
/// <param name="id">标题</param>
/// <param name="title">标题</param>
/// <param name="album">专辑</param>
/// <param name="singer">歌手</param>
/// <param name="tag">标签</param>
/// <param name="url">音乐路径</param>
/// <param name="pic">图片路径</param>
/// <param name="pubTime">发布时间</param>
public void AddUptMusic(int id, string title, string album, string singer, string tag, string url, string pic, DateTime pubTime)
{
var music1 = yfjbContext.Music.FirstOrDefault(m => m.Id == id);
//添加
if (music1 != null)
{
Music music = new Music()
{
Album = album, //专辑
Pic = pic, //图片路径
Singer = singer, //歌手
Tag = tag, //标签
Title = title, //标题
Url = url, //音乐路径
PubTime = pubTime, //发布时间
Status = 1
};
yfjbContext.Music.Add(music);
}
else//修改
{
music1.Album = album;
music1.Pic = pic;
music1.Singer = singer;
music1.Tag = tag;
music1.Title = title;
music1.Url = url;
music1.PubTime = pubTime;
}
yfjbContext.SaveChanges();
}
/// <summary>
/// 添加日记
/// </summary>
/// <param name="title"></param>
/// <param name="author"></param>
/// <param name="type"></param>
/// <param name="content"></param>
public void AddDiary(string title, string author, string type, string content)
{
TableDiary tableDiary = new TableDiary()
{
Title = title,
Author = author,
Type = type,
Content = content,
CreateTime = DateTime.Now
};
_yfjbContext.Add(tableDiary);
_yfjbContext.SaveChanges();
}
private void HttpGet(string Url, string code, string postDataStr = "")
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(Url + (postDataStr == "" ? "" : "?") + postDataStr);
request.Method = "GET";
request.ContentType = "text/html;charset=UTF-8";
request.Connection = "";
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Stream myResponseStream = response.GetResponseStream();
StreamReader myStreamReader = new StreamReader(myResponseStream, Encoding.GetEncoding("utf-8"));
// 默认简单配置，输出至控制台
//BasicConfigurator.Configure(repository);
//ILog log = LogManager.GetLogger(repository.Name, "NETCorelog4net");
string a = "";
string lastF170 = "";
string lastF191 = "";
yfjbContext yfjbContext = DatabaseHelper.GetDbInstance(_constr);
while ((a = myStreamReader.ReadLine()) != null && runningTickets.Contains(code))
{
try
{
if (a.Length > 5)
{
a = a.Substring(5);
var model = JsonConvert.DeserializeObject <TicksModel>(a);
if (model.data == null)
{
continue;
}
//插入数据库
if (model.data.f170 != null)
{
lastF170 = model.data.f170;
}
if (model.data.f191 != null)
{
lastF191 = model.data.f191;
}
if (model.data.f170 == null && model.data.f191 == null)
{
continue;
}
Ticksanalysis ticksanalysis = new Ticksanalysis()
{
Code = Convert.ToInt32(code),
Time = DateTime.Now,
WeiBi = Convert.ToSingle(lastF191),
UpDown = Convert.ToSingle(lastF170)
};
yfjbContext.Ticksanalysis.Add(ticksanalysis);
yfjbContext.SaveChanges();
}
}
catch (Exception ex)
{
a = "";
}
}
runningTickets.Remove(code);
Tickets ticket = _dbContext.Tickets.FirstOrDefault(t => t.Code == code);
ticket.Status = false;
_dbContext.SaveChanges();
myStreamReader.Close();
myResponseStream.Close();
}
private void HttpGet(string Url, int code, string postDataStr = "")
{
HttpWebRequest request = (HttpWebRequest)WebRequest.Create(Url + (postDataStr == "" ? "" : "?") + postDataStr);
request.Method = "GET";
request.ContentType = "text/html;charset=UTF-8";
request.Connection = "";
HttpWebResponse response = (HttpWebResponse)request.GetResponse();
Stream myResponseStream = response.GetResponseStream();
StreamReader myStreamReader = new StreamReader(myResponseStream, Encoding.GetEncoding("utf-8"));
// 默认简单配置，输出至控制台
BasicConfigurator.Configure(repository);
ILog log = LogManager.GetLogger(repository.Name, "NETCorelog4net");
string a = "";
string lastF170 = "";
string lastF191 = "";
int cnt = 1;
while ((a = myStreamReader.ReadLine()) != null)
{
//Thread.Sleep(1000 * 5);
try
{
if (a.Length > 5)
{
a = a.Substring(5);
var model = JsonConvert.DeserializeObject <TicksModel>(a);
if (model.data == null)
{
continue;
}
//插入数据库
if (model.data.f170 != null)
{
lastF170 = model.data.f170;
}
if (model.data.f191 != null)
{
lastF191 = model.data.f191;
}
if (model.data.f170 == null && model.data.f191 == null)
{
continue;
}
Ticksanalysis ticksanalysis = new Ticksanalysis()
{
Code = code,
Time = DateTime.Now,
WeiBi = Convert.ToSingle(lastF191),
UpDown = Convert.ToSingle(lastF170)
};
_dbContext.Ticksanalysis.Add(ticksanalysis);
_dbContext.SaveChanges();
cnt++;
}
}
catch (Exception ex)
{
a = "";
}
}
myStreamReader.Close();
myResponseStream.Close();
}
