/// <summary>
/// Show the Open File dialogue, then load the selected character.
/// </summary>
private void OpenFile(object sender, EventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog
{
Filter = "Chummer5 Files (*.chum5)|*.chum5|All Files (*.*)|*.*",
Multiselect = true
};
if (openFileDialog.ShowDialog(this) == DialogResult.OK)
{
Timekeeper.Start("load_sum");
Cursor = Cursors.WaitCursor;
Character[] lstCharacters = new Character[openFileDialog.FileNames.Length];
object lstCharactersLock = new object();
Parallel.For(0, lstCharacters.Length, i =>
{
Character objLoopCharacter = LoadCharacter(openFileDialog.FileNames[i]);
lock (lstCharactersLock)
lstCharacters[i] = objLoopCharacter;
});
Cursor = Cursors.Default;
Program.MainForm.OpenCharacterList(lstCharacters);
Application.DoEvents();
Timekeeper.Finish("load_sum");
Timekeeper.Log();
}
}
private void allToolStripMenuItem_Click(object sender, EventArgs e)
{
CommonOpenFileDialog m = new CommonOpenFileDialog();
m.IsFolderPicker = true;
m.EnsurePathExists = true;
m.Title = "Select Folder to Output to";
if (m.ShowDialog() == CommonFileDialogResult.Ok)
{
string dir = m.FileName;
for (int i = 0; i < entr.Count; i++)
{
Entry t = entr[i];
string filePath = Path.Combine(dir, t.off.ToString("X") + ".bik");
FileStream fileStream = new FileStream(filePath, FileMode.Create, FileAccess.Write);
listBox2.Items.Add("Extracting " + filePath);
listBox2.SelectedIndex = listBox2.Items.Count - 1;
Application.DoEvents();
for (int j = 0; j < t.size; j++)
{
fileStream.WriteByte(memory[t.off + j]);
}
fileStream.Close();
}
MessageBox.Show("Done.");
}
}
private void toggleButton1_Click(object sender, RibbonControlEventArgs e)
{
try
{
var currentCursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
Application.DoEvents();
if (this.monitorPane == null)
{
this.monitorPane = ThisAddIn.thisAddIn.CustomTaskPanes.Add(new AttachmentUserControl(), "Вложения");
this.monitorPane.VisibleChanged += (s, ea) =>
{
if (this.thisRibbon != null)
{
this.thisRibbon.Invalidate();
}
};
this.monitorPane.DockPosition = MsoCTPDockPosition.msoCTPDockPositionLeft;
this.monitorPane.Width = 370;
}
this.monitorPane.Visible = !this.monitorPane.Visible; // Visiblethis.MonitorToggleButton.Checked;
Cursor.Current = currentCursor;
}
catch (Exception ex)
{
var message = string.Format("Ошибка запуска: {0}", ex.Message);
MessageBox.Show(message, @"Ошибка!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static Form ShowXamarinControl(this ContentPage ctl, int Width, int Height)
{
var f = new Xamarin.Forms.Platform.WinForms.PlatformRenderer();
Xamarin.Forms.Platform.WinForms.Forms.Init(f);
f.Width = Width;
f.Height = Height;
var done = false;
Xamarin.Forms.Device.BeginInvokeOnMainThread(() =>
{
var app = new Xamarin.Forms.Application()
{
MainPage = ctl
};
f.LoadApplication(app);
ThemeManager.ApplyThemeTo(f);
if (ctl is IClose)
{
((IClose)ctl).CloseAction = () => f.Close();
}
f.ShowDialog();
done = true;
});
while (!done)
{
Application.DoEvents();
}
return(f);
}
private void ClearEventAndStatusDisplays()
{
// Clear communications
_displayReady = false;
CommunicationsDisplay.Navigate("about:blank");
while (!_displayReady)
{
Application.DoEvents();
}
}
private void ZautocNaHraca()
{
pocetZobrazeni = 0;
idHrac = _form.listHracov[_form.listHracov.IndexOf(new Hrac(hladanyHrac, "", ""))].ID;
// http://www.stargate-game.cz/utok.php?jakej=2&cil= stare
// http://www.stargate-game.cz/utok.php?page=0&hrac_id=1224426&utok_id=5
var url = new Uri("http://www.stargate-game.cz/utok.php?page=0&hrac_id=" + idHrac + "&utok_id=5");
wbUtok.Navigate(url);
while (true)
{
Application.DoEvents();
if (!string.IsNullOrEmpty(wbUtok.StatusText) && !wbUtok.StatusText.Contains("utok.php"))
{
break;
}
}
CultureInfo elGR = CultureInfo.CreateSpecificCulture("el-GR");
wbUtok.Document.GetElementsByTagName("input").GetElementsByName("jed1")[0].SetAttribute("value", int.Parse(_pocetPechota).ToString("0,0", elGR));
//pech[0].SetAttribute("value", _pocetPechota);
//var EB = wbUtok.Document.GetElementsByTagName("input").GetElementsByName("jednot5");
//EB[0].SetAttribute("value", _pocetEB);
var c = wbUtok.Document.GetElementsByTagName("input");
var d = wbUtok.Document.GetElementsByTagName("input").GetElementsByName("zautocit");
d[0].InvokeMember("Click");
var vystx = 0;
var vysty = 0;
var fmx = wbUtok.Parent.Location.X;
var fmy = wbUtok.Parent.Location.Y;
var item = c[5];
var wbx = wbUtok.Location.X;
var wby = wbUtok.Location.Y;
vystx = item.OffsetRectangle.X;
vysty = item.OffsetRectangle.Y;
var x = vystx + fmx + wbx + 10;
var y = vysty + fmy + wby + 40;
_form.TopMost = true;
var screenBounds = Screen.PrimaryScreen.Bounds;
Console.WriteLine(DateTime.Now.TimeOfDay + @" Utok");
DoMouseClick(x * 65535 / screenBounds.Width, y * 65535 / screenBounds.Height);
}
/// <summary>
/// force the web control to the last item in the window... set to the bottom for the latest activity
/// </summary>
private void ScrollMessageIntoView()
{
// MOST IMP : processes all windows messages queue
Application.DoEvents();
if (CommunicationsDisplay.Document != null)
{
CommunicationsDisplay.Document.Window.ScrollTo(0,
CommunicationsDisplay.Document.Body.ScrollRectangle.Height);
}
}
public void WaitFor(Func <bool> done)
{
//if (!OS.Mono) {
// // try to resolve timing problems
// // does not work so well, but better than nothing
// int i = 0;
// while (!done() && i < 10) {
// Thread.Sleep(5);
// i++;
// }
//}
Application.DoEvents();
}
protected void BlockUntilNavigationFinished()
{
BlockUntilNavigationFinishedDone = false;
this.DocumentCompleted -= BlockUntilNavigationFinishedEvent;
this.DocumentCompleted += BlockUntilNavigationFinishedEvent;
this.NavigationError -= BlockUntilNavigationFinishedEvent;
this.NavigationError += BlockUntilNavigationFinishedEvent;
while (!BlockUntilNavigationFinishedDone)
{
Application.DoEvents();
Application.RaiseIdle(new EventArgs());
}
}
private void Restore(object sender, RoutedEventArgs e)
{
if (WindowState == WindowState.Normal)
{
noDwmBorder.Visibility = Visibility.Hidden;
Application.DoEvents();
WindowState = WindowState.Maximized;
}
else
{
WindowState = WindowState.Normal;
}
}
private void Application_Startup(object sender, StartupEventArgs e)
{
Label LoadingLabel = new Label();
LoadingLabel.Text = "Carregando, por favor, aguarde....";
LoadingLabel.AutoSize = false;
LoadingLabel.Dock = DockStyle.Fill;
LoadingLabel.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
LoadingLabel.Font = new System.Drawing.Font(LoadingLabel.Font.FontFamily, 12f);
LoadingForm.Controls.Add(LoadingLabel);
LoadingForm.Size = new System.Drawing.Size(200, 100);
LoadingForm.FormBorderStyle = FormBorderStyle.None;
LoadingForm.StartPosition = FormStartPosition.CenterScreen;
LoadingForm.Show();
FApplication.DoEvents();
}
private void ImportSectionLinks(string selectedItem)
{
var retstring = selectedItem;
var pDialog = new ProgressDialog();
try
{
var owner = new Win32Window(Process.GetCurrentProcess().MainWindowHandle);
pDialog.Show(owner);
var selTopic = _mindManager.ActiveDocument.Selection.PrimaryTopic;
if (selTopic != null)
{
var pageIds = OnenoteUtils.GetSectionPageIds(retstring);
int count = pageIds.Count();
int block = 100 / count;
pDialog.Progress = 100 % count;
string mmLink;
foreach (var pageId in pageIds)
{
mmLink = OnenoteUtils.GetMindManagerLink(pageId);
var hl = Utils.GetMindManagerLink(mmLink);
pDialog.Progress += block;
pDialog.Message = hl.Title;
Topic topic = selTopic.AddSubTopic(hl.Title);
if (!string.IsNullOrEmpty(mmLink))
{
Hyperlink hyperlink = topic.Hyperlinks.AddHyperlink(hl.Text);
hyperlink.Arguments = hl.Argument;
}
Application.DoEvents();
//_MindManager.ActiveDocument.Save();
}
}
}
catch (Exception ex)
{
MessageBox.Show("Error importing section: " + ex.Message);
}
finally
{
pDialog.Close();
}
}
/// <summary>
/// Show the Open File dialogue, then load the selected character.
/// </summary>
private void OpenFile(object sender, EventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Chummer5 Files (*.chum5)|*.chum5|All Files (*.*)|*.*";
openFileDialog.Multiselect = true;
if (openFileDialog.ShowDialog(this) == DialogResult.OK)
{
Timekeeper.Start("load_sum");
foreach (string strFileName in openFileDialog.FileNames)
{
LoadCharacter(strFileName);
Timekeeper.Start("load_event_time");
Application.DoEvents();
Timekeeper.Finish("load_event_time");
}
Timekeeper.Finish("load_sum");
Timekeeper.Log();
}
}
/// <summary>
/// The monitor button click.
/// </summary>
/// <param name="sender">
/// The sender.
/// </param>
/// <param name="e">
/// The e.
/// </param>
private void MonitorToggleButtonClick(object sender, RibbonControlEventArgs e)
{
var currentCursor = Cursor.Current;
Cursor.Current = Cursors.WaitCursor;
Application.DoEvents();
if (this.monitorPane == null)
{
this.monitorPane = ThisAddIn.thisAddIn.CustomTaskPanes.Add(new MonitorUserControl(), "Монитор");
this.monitorPane.VisibleChanged += (s, ea) =>
{
this.thisRibbon.Invalidate();
};
this.monitorPane.DockPosition = (MsoCTPDockPosition)MsoCTPDockPosition.msoCTPDockPositionLeft;
this.monitorPane.Width = 370;
}
this.monitorPane.Visible = !this.monitorPane.Visible; // Visiblethis.MonitorToggleButton.Checked;
Cursor.Current = currentCursor;
}
private void Export_excel_Click(object sender, EventArgs e)
{
string path = @"..\..\..\"; //使用相對路徑
string filename = "students_data.xlsx"; //檔名
ExcelPackage excel = new ExcelPackage();
ExcelWorksheet worksheet = excel.Workbook.Worksheets.Add("學生資料"); //添加第一個資料表
/* //下面是匯出到excel的簡單格式設定 可自行變化並放進for迴圈
* ExcelWorksheet worksheet2 = excel.Workbook.Worksheets.Add("2222"); //新增工作表
* worksheet.Cells[1,1,1,10].Merge = true; //左右合併(第一到第十格)
* worksheet.Cells[1,1,2,10].Merge = true; //上下合併 1.2列合併
* worksheet.Cells[1, 1, 2, 10].Style.Font.Size = 20; //更改字型大小
* worksheet.Cells[1, 1, 1, 10].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center; //字型置中
*/
for (int i = 0; i < dataGridView1.ColumnCount; i = i + 1) //將屬性名稱寫進excel
{
worksheet.Cells[1, i + 1].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[1, i + 1].Value = dataGridView1.Columns[i].HeaderText; //依照上面合併使用過的列數(最大值+1)
}
for (int r = 0; r < dataGridView1.Rows.Count; r = r + 1) //將屬性值寫進excel
{
for (int i = 0; i < dataGridView1.ColumnCount; i = i + 1)
{
worksheet.Cells[r + 2, i + 1].Style.HorizontalAlignment = OfficeOpenXml.Style.ExcelHorizontalAlignment.Center;
worksheet.Cells[r + 2, i + 1].Value = dataGridView1.Rows[r].Cells[i].Value;
}
Application.DoEvents();
}
worksheet.Cells.AutoFitColumns(); //自動調整欄位大小
FileInfo excelFile = new FileInfo(path + filename);
excel.SaveAs(excelFile);
Process.Start(path + filename); //開啟excel檔
}
private void bt_thankYou_Click(object sender, EventArgs e)
{
// System.Threading.Thread t = new Thread(new ThreadStart(this.threaded_ThankYou));
// t.Start();
this.Close();
Application.DoEvents();
Thread.Sleep(1000 * 2);
// hier passierts
this.logger.WriteLine("bt_thankYou_Click");
Thread.Sleep(1000 * 2);
MailItem oMailItem = (MailItem)this.outlook.CreateItem(OlItemType.olMailItem);
oMailItem.To = this.config.Address_ThankYou;
oMailItem.Subject = "Thank You!";
oMailItem.Body = "i'd like to say 'thank you' to you.";
// oMailItem.Send();
oMailItem.Display(false);
Marshal.ReleaseComObject(oMailItem);
}
/// <summary>
/// Check installation
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void buttonCheck_Click(object sender, EventArgs e)
{
buttonCheck.Enabled = false;
listBoxResult.Items.Clear();
Application.DoEvents();
Thread.Sleep(200);
#region Call verification functions
try
{
VerifyConfigs();
}
catch (Exception ex)
{
AddResultValue(ex.ToString());
}
try
{
VerifyRegistry();
}
catch (Exception ex)
{
AddResultValue(ex.ToString());
}
try
{
VerifyFiles();
}
catch (Exception ex)
{
AddResultValue(ex.ToString());
}
try
{
if (radioButtonDoNotUseSLLAccelerator.Checked)
{
VerifyCertificateAndConfigurationOfHttpListener();
}
}
catch (Exception ex)
{
AddResultValue(ex.ToString());
}
try
{
VerifyAppPools();
}
catch (Exception ex)
{
AddResultValue(ex.ToString());
}
try
{
VerifyDatabase();
}
catch (Exception ex)
{
AddResultValue(ex.ToString());
}
try
{
VerifyOthers();
}
catch (Exception ex)
{
AddResultValue(ex.ToString());
}
#endregion
if (listBoxResult.Items.Count == 0)
{
AddResultValue("All correct");
}
else
{
AddResultValue("Total: " + listBoxResult.Items.Count + " errors");
}
buttonCheck.Enabled = true;
}
public void Run(ICoreApplication application, IServicesProvider servicesProvider = null)
{
FormsApplication.SetHighDpiMode(HighDpiMode.SystemAware);
FormsApplication.SetCompatibleTextRenderingDefault(false);
Sequence.CreateSequenceFunc = SequenceImpl.Create;
Sequence.NextFrameSequence = SequenceImpl.Create(0, 0, null, null);
dispatcher.DispatcherThread = Thread.CurrentThread;
using (var graphics = System.Drawing.Graphics.FromHwnd(IntPtr.Zero))
{
UiUnit.PixelsPerUnit = graphics.DpiX / 96f;
}
var scopeBuilder = new ScopeBuilder(servicesProvider);
scopeBuilder.WithSkia()
.WithInstance(gamePads).As <IGamePads>()
.WithInstance(keyboard).As <IKeyboard>()
.WithType <UiInput>().As <IUiInput>().AsSingleton()
.WithCrossTypes()
.WithInstance(dispatcher).As <ISystemDispatcher>().As <IDispatcher>()
.WithInstance(sequencer).As <ISequencer>()
.WithType <SelectFileServiceWinForms>().As <ISelectFileService>().AsSingleton();
var services = scopeBuilder.Build();
application.AfterInitServices += (s, b) =>
{
b.WithType <WindowServiceWinForms>().AsSelf().As <IWindowsService>().AsSingleton()
.WithType <AppColorTable>().AsSelf().AsSingleton();
};
services = application.Initialize(services);
application.Load();
var windowsService = services.GetService <WindowServiceWinForms>();
var stopwatch = new Stopwatch();
stopwatch.Start();
TimeSpan lastUpdateTimeSpan = stopwatch.Elapsed;
while (windowsService.MainWindow != null)
{
TimeSpan currentTimeSpan = stopwatch.Elapsed;
TimeSpan timeDelta = currentTimeSpan - lastUpdateTimeSpan;
lastUpdateTimeSpan = currentTimeSpan;
gamePads.Update();
keyboard.Update();
dispatcher.Process();
sequencer.Update(timeDelta);
for (var idx = 0; idx < windowsService.Windows.Count; ++idx)
{
var hostWindow = windowsService.Windows[idx];
hostWindow.Window.Update((float)timeDelta.TotalSeconds);
if (hostWindow.Window.IsDirty)
{
hostWindow.Redraw();
}
}
FormsApplication.DoEvents();
Thread.Sleep(1);
}
foreach (var wnd in windowsService.Windows)
{
wnd.Window.Close();
}
}
private void OgrenciSonuclari()
{
DizinIslemleri dizinIslemleri = new DizinIslemleri();
List <DosyaInfo> dosyalar = dizinIslemleri.DizindekiDosyalariListele(seciliDizin);
progressBar1.Maximum = dosyalar.Count;
progressBar1.Value = 0;
foreach (DosyaInfo dosya in dosyalar)
{
string filePath = dosya.DizinAdresi + @"\" + dosya.DosyaAdi;
string ilceAdi = dosya.DizinAdresi.Replace(seciliDizin, "").Replace("\\", "");
progressBar1.Value += 1;
label4.Text = "Okul sayısı : " + progressBar1.Value + "/" + dosyalar.Count + " ...veriler toplanıyor.";
DataTable table = ExcelUtil.ExcelToDataTable(filePath);
for (int satir = 1; satir <= table.Rows.Count; satir += 18)
{
string aciklama = table.Rows[satir + 5][11].ToString();
if (sinavAdi == "")
{
sinavAdi = table.Rows[17][0].ToString().ToUpper(CultureInfo.CurrentCulture);
}
//row
string tcKimlik = table.Rows[satir - 1][7].ToString();
string adiSoyadi = table.Rows[satir][7].ToString();
string okulu = table.Rows[satir + 3][7].ToString().Replace("İ", "İ").Replace("ı", "ı");
int turkceDogru = table.Rows[satir + 5][6].ToInt32();
int turkceYanlis = table.Rows[satir + 5][8].ToInt32();
decimal turkceNet = turkceDogru - ((decimal)turkceYanlis / 3);
int matDogru = table.Rows[satir + 6][6].ToInt32();
int matYanlis = table.Rows[satir + 6][8].ToInt32();
decimal matNet = matDogru - ((decimal)matYanlis / 3);
int fenDogru = table.Rows[satir + 7][6].ToInt32();
int fenYanlis = table.Rows[satir + 7][8].ToInt32();
decimal fenNet = fenDogru - ((decimal)fenYanlis / 3);
int inkDogru = table.Rows[satir + 8][6].ToInt32();
int inkYanlis = table.Rows[satir + 8][8].ToInt32();
decimal inkNet = inkDogru - ((decimal)inkYanlis / 3);
int dinDogru = table.Rows[satir + 10][6].ToInt32();
int dinYanlis = table.Rows[satir + 10][8].ToInt32();
decimal dinNet = dinDogru - ((decimal)dinYanlis / 3);
int ingDogru = table.Rows[satir + 11][6].ToInt32();
int ingYanlis = table.Rows[satir + 11][8].ToInt32();
decimal ingNet = ingDogru - ((decimal)ingYanlis / 3);
decimal sinavPuani = table.Rows[satir + 14][6].ToDecimal();
decimal yuzdelik = table.Rows[satir + 12][3].ToString().Replace("Türkiye Geneli Yüzdelik Dilimi: %", "")
.ToDecimal();
// okulu = Encoding.UTF8.GetString(Encoding.Default.GetBytes(okulu));
// adiSoyadi = Encoding.UTF8.GetString(Encoding.Default.GetBytes(adiSoyadi));
// aciklama = Encoding.UTF8.GetString(Encoding.Default.GetBytes(aciklama));
decimal toplamNet = (turkceNet + matNet + fenNet + inkNet + dinNet + ingNet);
LgsSonuc sonuc = new LgsSonuc
{
Tckimlik = tcKimlik.Trim(),
SinavPuani = sinavPuani,
YuzdelikDilim = yuzdelik,
ToplamNet = toplamNet,
TurkceDogru = turkceDogru,
TurkceYanlis = turkceYanlis,
TurkceNet = turkceNet,
MatDogru = matDogru,
MatYanlis = matYanlis,
MatNet = matNet,
FenDogru = fenDogru,
FenYanlis = fenYanlis,
FenNet = fenNet,
InkDogru = inkDogru,
InkYanlis = inkYanlis,
InkNet = inkNet,
DinDogru = dinDogru,
DinYanlis = dinYanlis,
DinNet = dinNet,
IngDogru = ingDogru,
IngYanlis = ingYanlis,
IngNet = ingNet,
Aciklama = aciklama,
AdiSoyadi = adiSoyadi,
IlceAdi = ilceAdi,
OkulAdi = okulu
};
sonucList.Add(sonuc);
//SonucManager manager = new SonucManager();
//manager.Insert(sonuc);
Application.DoEvents();
}
Application.DoEvents();
}
//dosyaları okuma bitti
}
private List <LgsSonuc> OkullariHesapla()
{
List <LgsSonuc> OkulOrtalamalariList = new List <LgsSonuc>();
List <LgsSonuc> okullar = sonucList.Where(x => x.Aciklama == "-").GroupBy(x => new { x.IlceAdi, x.OkulAdi }).Select(x => x.First()).ToList();
int islemSayisi = okullar.Count;
progressBar1.Maximum = islemSayisi;
progressBar1.Value = 0;
int a = 0;
//okul ortalamaları
foreach (var okul in okullar)
{
var okulVerisi = sonucList.Where(x => x.OkulAdi == okul.OkulAdi && x.Aciklama == "-");
int ogrenciSayisi = okulVerisi.Count();
a++;
progressBar1.Value = a;
label4.Text = "Okul ortalamaları hesaplanıyor. " + a + "/" + islemSayisi;
int turkceDogru = okulVerisi.Sum(x => x.TurkceDogru);
int turkceYanlis = okulVerisi.Sum(x => x.TurkceYanlis);
decimal turkceNet = (turkceDogru - ((decimal)turkceYanlis / 3)) / ogrenciSayisi;
int matDogru = okulVerisi.Sum(x => x.MatDogru);
int matYanlis = okulVerisi.Sum(x => x.MatYanlis);
decimal matNet = (matDogru - ((decimal)matYanlis / 3)) / ogrenciSayisi;
int fenDogru = okulVerisi.Sum(x => x.FenDogru);
int fenYanlis = okulVerisi.Sum(x => x.FenYanlis);
decimal fenNet = (fenDogru - ((decimal)fenYanlis / 3)) / ogrenciSayisi;
int inkDogru = okulVerisi.Sum(x => x.InkDogru);
int inkYanlis = okulVerisi.Sum(x => x.IngYanlis);
decimal inkNet = (inkDogru - ((decimal)inkYanlis / 3)) / ogrenciSayisi;
int dinDogru = okulVerisi.Sum(x => x.DinDogru);
int dinYanlis = okulVerisi.Sum(x => x.DinYanlis);
decimal dinNet = (dinDogru - ((decimal)dinYanlis / 3)) / ogrenciSayisi;
int ingDogru = okulVerisi.Sum(x => x.IngDogru);
int ingYanlis = okulVerisi.Sum(x => x.IngYanlis);
decimal ingNet = (ingDogru - ((decimal)ingYanlis / 3)) / ogrenciSayisi;
decimal toplamNet = okulVerisi.Sum(x => x.ToplamNet) / ogrenciSayisi;
decimal sinavPuanOrtalamasi = okulVerisi.Sum(x => x.SinavPuani) / ogrenciSayisi;
LgsSonuc sonuc = new LgsSonuc
{
OgrenciSayisi = ogrenciSayisi,
SinavPuani = sinavPuanOrtalamasi,
ToplamNet = toplamNet,
TurkceDogru = turkceDogru,
TurkceYanlis = turkceYanlis,
TurkceNet = turkceNet,
MatDogru = matDogru,
MatYanlis = matYanlis,
MatNet = matNet,
FenDogru = fenDogru,
FenYanlis = fenYanlis,
FenNet = fenNet,
InkDogru = inkDogru,
InkYanlis = inkYanlis,
InkNet = inkNet,
DinDogru = dinDogru,
DinYanlis = dinYanlis,
DinNet = dinNet,
IngDogru = ingDogru,
IngYanlis = ingYanlis,
IngNet = ingNet,
IlceAdi = okul.IlceAdi,
OkulAdi = okul.OkulAdi
};
OkulOrtalamalariList.Add(sonuc);
}
Application.DoEvents();
progressBar1.Value = 0;
return(OkulOrtalamalariList);
}
private List <LgsSonuc> IlveIlceleriHesapla()
{
List <LgsSonuc> ilIlceOrtalamalariList = new List <LgsSonuc>();
List <LgsSonuc> ilceler = sonucList.Where(x => x.Aciklama == "-").GroupBy(x => x.IlceAdi).Select(x => x.First()).ToList();
int islemSayisi = ilceler.Count;
progressBar1.Maximum = islemSayisi;
progressBar1.Value = 0;
int a = 0;
//ilçe ortalamaları
foreach (var ilce in ilceler)
{
var ilceVerisi = sonucList.Where(x => x.IlceAdi == ilce.IlceAdi && x.Aciklama == "-");
int ogrenciSayisi = ilceVerisi.Count();
a++;
progressBar1.Value = a;
label4.Text = "İlçe ortalamaları hesaplanıyor." + a + "/" + islemSayisi;
int turkceDogru = ilceVerisi.Sum(x => x.TurkceDogru);
int turkceYanlis = ilceVerisi.Sum(x => x.TurkceYanlis);
decimal turkceNet = (turkceDogru - ((decimal)turkceYanlis / 3)) / ogrenciSayisi;
int matDogru = ilceVerisi.Sum(x => x.MatDogru);
int matYanlis = ilceVerisi.Sum(x => x.MatYanlis);
decimal matNet = (matDogru - ((decimal)matYanlis / 3)) / ogrenciSayisi;
int fenDogru = ilceVerisi.Sum(x => x.FenDogru);
int fenYanlis = ilceVerisi.Sum(x => x.FenYanlis);
decimal fenNet = (fenDogru - ((decimal)fenYanlis / 3)) / ogrenciSayisi;
int inkDogru = ilceVerisi.Sum(x => x.InkDogru);
int inkYanlis = ilceVerisi.Sum(x => x.IngYanlis);
decimal inkNet = (inkDogru - ((decimal)inkYanlis / 3)) / ogrenciSayisi;
int dinDogru = ilceVerisi.Sum(x => x.DinDogru);
int dinYanlis = ilceVerisi.Sum(x => x.DinYanlis);
decimal dinNet = (dinDogru - ((decimal)dinYanlis / 3)) / ogrenciSayisi;
int ingDogru = ilceVerisi.Sum(x => x.IngDogru);
int ingYanlis = ilceVerisi.Sum(x => x.IngYanlis);
decimal ingNet = (ingDogru - ((decimal)ingYanlis / 3)) / ogrenciSayisi;
decimal toplamNet = ilceVerisi.Sum(x => x.ToplamNet) / ogrenciSayisi;
decimal sinavPuanOrtalamasi = ilceVerisi.Sum(x => x.SinavPuani) / ogrenciSayisi;
LgsSonuc sonuc = new LgsSonuc
{
ToplamNet = toplamNet,
SinavPuani = sinavPuanOrtalamasi,
TurkceDogru = turkceDogru,
TurkceYanlis = turkceYanlis,
TurkceNet = turkceNet,
MatDogru = matDogru,
MatYanlis = matYanlis,
MatNet = matNet,
FenDogru = fenDogru,
FenYanlis = fenYanlis,
FenNet = fenNet,
InkDogru = inkDogru,
InkYanlis = inkYanlis,
InkNet = inkNet,
DinDogru = dinDogru,
DinYanlis = dinYanlis,
DinNet = dinNet,
IngDogru = ingDogru,
IngYanlis = ingYanlis,
IngNet = ingNet,
IlceAdi = ilce.IlceAdi,
OgrenciSayisi = ogrenciSayisi
};
ilIlceOrtalamalariList.Add(sonuc);
}
//il ortalaması
var ilVerisi = sonucList.Where(x => x.Aciklama == "-");
int iLogrenciSayisi = ilVerisi.Count();
int turkceIlDogru = ilVerisi.Sum(x => x.TurkceDogru);
int turkceIlYanlis = ilVerisi.Sum(x => x.TurkceYanlis);
decimal turkceIlNet = (turkceIlDogru - ((decimal)turkceIlYanlis / 3)) / iLogrenciSayisi;
int matIlDogru = ilVerisi.Sum(x => x.MatDogru);
int matIlYanlis = ilVerisi.Sum(x => x.MatYanlis);
decimal matIlNet = (matIlDogru - ((decimal)matIlYanlis / 3)) / iLogrenciSayisi;
int fenIlDogru = ilVerisi.Sum(x => x.FenDogru);
int fenIlYanlis = ilVerisi.Sum(x => x.FenYanlis);
decimal fenIlNet = (fenIlDogru - ((decimal)fenIlYanlis / 3)) / iLogrenciSayisi;
int inkIlDogru = ilVerisi.Sum(x => x.InkDogru);
int inkIlYanlis = ilVerisi.Sum(x => x.IngYanlis);
decimal inkIlNet = (inkIlDogru - ((decimal)inkIlYanlis / 3)) / iLogrenciSayisi;
int dinIlDogru = ilVerisi.Sum(x => x.DinDogru);
int dinIlYanlis = ilVerisi.Sum(x => x.DinYanlis);
decimal dinIlNet = (dinIlDogru - ((decimal)dinIlYanlis / 3)) / iLogrenciSayisi;
int ingIlDogru = ilVerisi.Sum(x => x.IngDogru);
int ingIlYanlis = ilVerisi.Sum(x => x.IngYanlis);
decimal ingIlNet = (ingIlDogru - ((decimal)ingIlYanlis / 3)) / iLogrenciSayisi;
decimal toplamIlNet = ilVerisi.Sum(x => x.ToplamNet) / iLogrenciSayisi;
decimal sinavIlPuanOrtalamasi = ilVerisi.Sum(x => x.SinavPuani) / iLogrenciSayisi;
LgsSonuc sonucIl = new LgsSonuc
{
ToplamNet = toplamIlNet,
TurkceDogru = turkceIlDogru,
TurkceYanlis = turkceIlYanlis,
TurkceNet = turkceIlNet,
MatDogru = matIlDogru,
MatYanlis = matIlYanlis,
MatNet = matIlNet,
FenDogru = fenIlDogru,
FenYanlis = fenIlYanlis,
FenNet = fenIlNet,
InkDogru = inkIlDogru,
InkYanlis = inkIlYanlis,
InkNet = inkIlNet,
DinDogru = dinIlDogru,
DinYanlis = dinIlYanlis,
DinNet = dinIlNet,
IngDogru = ingIlDogru,
IngYanlis = ingIlYanlis,
IngNet = ingIlNet,
IlceAdi = "İl Ortalaması",
OgrenciSayisi = iLogrenciSayisi,
SinavPuani = sinavIlPuanOrtalamasi
};
ilIlceOrtalamalariList.Add(sonucIl);
Application.DoEvents();
progressBar1.Value = 0;
return(ilIlceOrtalamalariList);
}
public void SaveDataToExcel(string s)
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Title = "导出Excel文件";
saveFileDialog.Filter = "Excel 工作簿(*.xlsx)|*.xlsx|Excel 97-2003 工作簿(*.xls)|*.xls";
//设置默认文件类型显示顺序
saveFileDialog.FilterIndex = 1;
//是否自动在文件名中添加扩展名
saveFileDialog.AddExtension = true;
//是否记忆上次打开的目录
saveFileDialog.RestoreDirectory = true;
//设置默认文件名
saveFileDialog.FileName = _defaultFileName;
//按下确定选择的按钮
if (saveFileDialog.ShowDialog() == DialogResult.OK)
{
//获得文件路径
string localFilePath = saveFileDialog.FileName.ToString();
////数据初始化
//int TotalCount; //总行数
//int RowRead = 0; //已读行数
//int Percent = 0; //百分比
//NPOI
IWorkbook workbook;
string FileExt = Path.GetExtension(localFilePath).ToLower();
if (FileExt == ".xlsx")
{
workbook = new XSSFWorkbook();
}
else if (FileExt == ".xls")
{
workbook = new HSSFWorkbook();
}
else
{
workbook = null;
}
if (workbook == null)
{
return;
}
ISheet sheet = workbook.CreateSheet("紫外设备");
try
{
//读取标题
IRow rowHeader = sheet.CreateRow(0);
ICell cell = rowHeader.CreateCell(0);
cell.SetCellValue("紫外");
rowHeader = sheet.CreateRow(1);
for (int i = 0; i < _UVTitle.Count(); i++)
{
cell = rowHeader.CreateCell(i);
cell.SetCellValue(_UVTitle[i]);
}
//合并单元格
CellRangeAddress region = new CellRangeAddress(0, 0, 0, 4);
sheet.AddMergedRegion(region);
//导出数据
if (ResultDataViewModel.VM.ExhaustDetailData.UVSCalParam != null)
{
DriveDataToSheet(sheet, ResultDataViewModel.VM.ExhaustDetailData.UVSCalParam.ZeroIntensity, 0);
}
DriveDataToSheet(sheet, ResultDataViewModel.VM.ExhaustDetailData.UVSData, 1);
if (ResultDataViewModel.VM.ExhaustDetailData.UVSNOCalParam != null)
{
DriveDataToSheet(sheet, ResultDataViewModel.VM.ExhaustDetailData.UVSNOCalParam.Absorb, 2);
}
if (ResultDataViewModel.VM.ExhaustDetailData.UVSHCCalParam != null)
{
DriveDataToSheet(sheet, ResultDataViewModel.VM.ExhaustDetailData.UVSHCCalParam.Absorb, 3);
}
DriveDataToSheet(sheet, ResultDataViewModel.VM.ExhaustDetailData.AbsorbData, 4);
sheet = workbook.CreateSheet("红外设备");
//读取标题
rowHeader = sheet.CreateRow(0);
cell = rowHeader.CreateCell(0);
cell.SetCellValue("红外");
rowHeader = sheet.CreateRow(1);
for (int i = 0; i < _TDTitle.Count(); i++)
{
cell = rowHeader.CreateCell(i);
cell.SetCellValue(_TDTitle[i]);
}
//合并单元格
region = new CellRangeAddress(0, 0, 0, 4);
sheet.AddMergedRegion(region);
//导出数据
if (ResultDataViewModel.VM.ExhaustDetailData.TDLASCalParam != null)
{
DriveDataToSheet(sheet, ResultDataViewModel.VM.ExhaustDetailData.TDLASCalParam.ZeroIntensity, 0);
}
if (ResultDataViewModel.VM.ExhaustDetailData.TDLASCOCalParam != null)
{
DriveDataToSheet(sheet, ResultDataViewModel.VM.ExhaustDetailData.TDLASCOCalParam.Harm, 1);
}
if (ResultDataViewModel.VM.ExhaustDetailData.TDLASCO2CalParam != null)
{
DriveDataToSheet(sheet, ResultDataViewModel.VM.ExhaustDetailData.TDLASCO2CalParam.Harm, 2);
}
if (ResultDataViewModel.VM.ExhaustDetailData.TDLASCalParam != null)
{
DriveDataToSheet(sheet, ResultDataViewModel.VM.ExhaustDetailData.TDLASCalParam.Harm, 3);
}
DriveDataToSheet(sheet, ResultDataViewModel.VM.ExhaustDetailData.HarmData, 4);
Application.DoEvents();
//转为字节数组
MemoryStream stream = new MemoryStream();
workbook.Write(stream);
var buf = stream.ToArray();
//保存为Excel文件
using (FileStream fs = new FileStream(localFilePath, FileMode.Create, FileAccess.Write))
{
fs.Write(buf, 0, buf.Length);
fs.Flush();
fs.Close();
}
//成功提示
if (MessageBox.Show("导出成功，是否立即打开？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information) == DialogResult.Yes)
{
System.Diagnostics.Process.Start(localFilePath);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
finally
{
}
}
}
private void button1_Click(object sender, EventArgs e)
{
var path = textBox1.Text;
if (!File.Exists(path))
{
MessageBox.Show("Datei nicht gefunden");
return;
}
var app = new Microsoft.Office.Interop.Excel.Application();
if (app == null)
{
Console.WriteLine(
"EXCEL could not be started. Check that your office installation and project references are correct.");
return;
}
//app.Visible = true;
//var wb = app.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
var wb = app.Workbooks.Open(path);
var ws = (Worksheet)wb.Worksheets[1];
if (ws == null)
{
Console.WriteLine(
"Worksheet could not be created. Check that your office installation and project references are correct.");
}
// Struktur
//Col 1 = A1 = ID
//Col 2 = B1 = DE_Nummer
//Col 3 = C1 = Parent
//Col 4 = D1 = DE_Begriff
//Col 5 = E1 = DE_Dossierbildung
//Col 6 = F1 = DE_Aufbewahrungsfrist
//Col 7 = G1 = DE_Untertitel(Stufe3)
//Col 8 = H1 = DE_Haupttitel(Stufe2)
//Col 9 = I1 = Hinweis_DE
//Col10 = J1 =
//Col11 = K1 =
//Col12 = L1 = FR Nummer
//Col13 = M1 = FR Begriff
//Col14 = N1 = FR_Dossierbildung
//Col15 = O1 = FR_Aufbewahrungsfrist
//Col16 = P1 = FR_Untertitel (Stufe3)
//Col17 = Q1 = FR_Haupttitel(Stufe2)
//Col18 = R1 = Hinweis_FR
//A2 1 ...
//A3 2 ...
//...
//A1361 1360 ...
//A1362
var dicNr2Id = new Dictionary <string, int>();
var list = new List <ArchivplanRow>();
var i = 2;
while (true)
{
var aRange = ws.Cells[i, 1];
if (aRange == null)
{
Console.WriteLine(
"Could not get a range. Check to be sure you have the correct versions of the office DLLs.");
}
if (aRange.Value2 == null)
{
break;
}
var row = new ArchivplanRow();
row.ID = int.Parse(ws.CellText(i, 1));
row.DE_Nummer = ws.CellText(i, 2);
row.Parent = ws.CellText(i, 3);
row.DE_Begriff = ws.CellText(i, 4);
row.DE_Dossierbildung = ws.CellText(i, 5);
row.DE_Aufbewahrungsfrist = ws.CellText(i, 6);
row.DE_UntertitelStufe3 = ws.CellText(i, 7);
row.DE_HaupttitelStufe2 = ws.CellText(i, 8);
row.Hinweis_DE = ws.CellText(i, 9);
row.FR_Nummer = ws.CellText(i, 12);
row.FR_Begriff = ws.CellText(i, 13);
row.FR_Dossierbildung = ws.CellText(i, 14);
row.FR_Aufbewahrungsfrist = ws.CellText(i, 15);
row.FR_UntertitelStufe3 = ws.CellText(i, 16);
row.FR_HaupttitelStufe2 = ws.CellText(i, 17);
row.Hinweis_FR = ws.CellText(i, 18);
dicNr2Id.Add(row.DE_Nummer, row.ID);
list.Add(row);
i++;
if (i % 100 == 0)
{
label1.Text = i.ToString();
Application.DoEvents();
}
}
//// Fill the cells in the C1 to C7 range of the worksheet with the number 6.
//var args = new Object[1];
//args[0] = 6;
//aRange.GetType().InvokeMember("Value", BindingFlags.SetProperty, null, aRange, args);
ReleaseCom(app);
//// Change the cells in the C1 to C7 range of the worksheet to the number 8.
//aRange.Value2 = 8;
var entities = new ArchivplanEntities();
foreach (var row in list)
{
var item = new tbArchivplan();
item.AufbewahrungsfristDE = row.DE_Aufbewahrungsfrist;
item.AufbewahrungsfristFR = row.FR_Aufbewahrungsfrist;
item.BezeichnungDE = row.DE_Begriff;
item.BezeichnungFR = row.FR_Begriff;
item.DossierbildungDE = row.DE_Dossierbildung;
item.DossierbildungFR = row.FR_Dossierbildung;
item.HaupttitelDE = row.DE_HaupttitelStufe2;
item.HaupttitelFR = row.FR_HaupttitelStufe2;
item.HinweisDE = row.Hinweis_DE;
item.HinweisFR = row.Hinweis_FR;
item.ParentId = string.IsNullOrEmpty(row.Parent) ? 0 : (int)dicNr2Id[row.Parent];
item.RegPlanId = row.ID;
item.RegPlanNr = row.DE_Nummer;
item.UntertitelDE = row.DE_UntertitelStufe3;
item.UntertitelFR = row.FR_UntertitelStufe3;
entities.tbArchivplans.Add(item);
}
entities.SaveChanges();
}
/// <summary>
/// Add new vlue to checkedListBoxResult
/// </summary>
/// <param name="value">String</param>
private void AddResultValue(string value)
{
listBoxResult.Items.Add(value);
Application.DoEvents();
}
private void button1_Click(object sender, EventArgs e)
{
toolStripProgressBar1.Visible = true;
dataGridView1.DoubleBuffered(true);
SendMessage(dataGridView1.Handle, WM_SETREDRAW, false, 0);
dataGridView1.Rows.Clear();
using (var orion2019Entities = new Orion2019Entities())
{
foreach (var item in employeesCheckedListBox.CheckedItems)
{
var names = from pList in orion2019Entities.pList
from pDivision in orion2019Entities.PDivision
from pLogData in orion2019Entities.pLogData
from AcessPoint in orion2019Entities.AcessPoint
let point = AcessPoint.Name
where pDivision.ID == pList.Section && pDivision.Name == orgComboBox.Text &&
pLogData.HozOrgan == pList.ID &&
pLogData.DeviceTime > dateTimePicker1.Value &&
pLogData.DeviceTime <= dateTimePicker2.Value &&
pList.Name + " " + pList.FirstName + " " + pList.MidName ==
item.ToString() &&
(pLogData.ZoneIndex == 0 || pLogData.ZoneIndex == 1) &&
pLogData.Event == 32 &&
pLogData.DoorIndex == AcessPoint.ID
orderby pLogData.DeviceTime
select new
{
pList.Name,
pList.MidName,
pList.FirstName,
pList.ID,
pLogData.DeviceTime,
pLogData.ZoneIndex,
pLogData.Remark,
point
};
dataGridView1.ColumnCount = 7;
//dataGridView1.Columns[0].AutoSizeMode = DataGridViewAutoSizeColumnMode.AllCells;
var rows = new List <DataGridViewRow>();
foreach (var name in names)
{
var a = name.ZoneIndex == 0 ? "Выход" : "Вход";
var row = new DataGridViewRow();
row.CreateCells(dataGridView1);
row.Cells[0].Value = name.Name;
row.Cells[1].Value = name.FirstName;
row.Cells[2].Value = name.MidName;
row.Cells[3].Value = Convert.ToDateTime(name.DeviceTime).ToString("dd.MM.yyyy");
row.Cells[4].Value = Convert.ToDateTime(name.DeviceTime).ToString("HH:mm:ss");
row.Cells[5].Value = a;
row.Cells[6].Value = name.point;
rows.Add(row);
toolStripStatusLabel1.Text = "Получаем данные по сотруднику: " + name.Name + " " +
name.FirstName + " " + name.MidName;
SendMessage(statusStrip1.Handle, WM_SETREDRAW, true, 0);
statusStrip1.Refresh();
Application.DoEvents();
}
dataGridView1.Rows.AddRange(rows.ToArray());
SendMessage(dataGridView1.Handle, WM_SETREDRAW, true, 0);
dataGridView1.Refresh();
}
}
SendMessage(dataGridView1.Handle, WM_SETREDRAW, true, 0);
dataGridView1.Refresh();
toolStripStatusLabel1.Text = "Готово!";
toolStripProgressBar1.Visible = false;
}
