public List <ZIP> GetZIP_i_Adresse(ref Adresse A)
{
string selectAdresseToolString = @"SELECT * FROM ZIP WHERE (Adresse = _AdresseID";
using (var cmd = new SqlCommand(selectAdresseToolString, OpenConnection))
{
SqlDataReader rdr = null;
cmd.Parameters.AddWithValue("@_AdresseID", A._AdresseID);
rdr = cmd.ExecuteReader();
List <ZIP> lort = new List <ZIP>();
ZIP zip = null;
while (rdr.Read())
{
zip = new ZIP
{
_ZipID = (long)rdr["_ZipID"],
_Land = (string)rdr["_Land"],
_By = (string)rdr["_By"],
_PostNummer = (string)rdr["_PostNummer"]
};
lort.Add(zip);
}
return(lort);
}
}
/// <summary>
/// Decompress an encrypted FAES File.
/// </summary>
/// <param name="encryptedFile">Encrypted FAES File</param>
/// <param name="overridePath">Override the read path</param>
/// <returns>Path of the encrypted, Decompressed file</returns>
public string DecompressFAESFile(FAES_File encryptedFile, string overridePath = "")
{
string fileCompressionMode = FileAES_Utilities.GetCompressionMode(encryptedFile.GetPath());
Logging.Log(String.Format("Compression Mode: {0}", fileCompressionMode), Severity.DEBUG);
switch (fileCompressionMode)
{
case "LZMA":
LZMA lzma = new LZMA();
return(lzma.DecompressFAESFile(encryptedFile, overridePath));
case "TAR":
TAR tar = new TAR();
return(tar.DecompressFAESFile(encryptedFile, overridePath));
case "ZIP":
ZIP zip = new ZIP(_compressionLevel);
return(zip.DecompressFAESFile(encryptedFile, overridePath));
case "LEGACY":
case "LEGACYZIP":
case "LGYZIP":
LegacyZIP legacyZip = new LegacyZIP();
return(legacyZip.DecompressFAESFile(encryptedFile, overridePath));
default:
throw new NotSupportedException("FAES File was compressed using an unsupported file format.");
}
}
/// <summary>
/// Компоновщик
/// </summary>
public static void GoCompositeItem()
{
IItem ammo = new Ammo();
IItem fuel = new Fuel();
IItem zip = new ZIP();
Composite tank = new Composite();
tank.AddItem(ammo);
tank.AddItem(ammo);
tank.AddItem(fuel);
tank.AddItem(zip);
Composite platoon = new Composite();
platoon.AddItem(tank);
platoon.AddItem(tank);
platoon.AddItem(tank);
Composite sq = new Composite();
sq.AddItem(platoon);
sq.AddItem(platoon);
sq.AddItem(platoon);
sq.AddItem(platoon);
Print(sq.Take(ESubdivision.ота));
Console.ReadKey();
}
public ActionResult DeleteConfirmed(int id)
{
ZIP zIP = db.ZIPs.Find(id);
db.ZIPs.Remove(zIP);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Zip1,City,State,Country")] ZIP zIP)
{
if (ModelState.IsValid)
{
db.Entry(zIP).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(zIP));
}
public ActionResult Create([Bind(Include = "Zip1,City,State,Country")] ZIP zIP)
{
if (ModelState.IsValid)
{
db.ZIPs.Add(zIP);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(zIP));
}
public void DeleteZIPDB(ref ZIP vtk)
{
string deleteString = @"DELETE FROM ZIP WHERE (ZipID = @ZipID)";
using (SqlCommand cmd = new SqlCommand(deleteString, OpenConnection))
{
cmd.Parameters.AddWithValue("@PhoneID", vtk.ZipID);
var id = (int)cmd.ExecuteNonQuery();
vtk = null;
}
}
public void DeleteZIPDB(ref ZIP zp)
{
string deleteString = @"DELETE FROM ZIP WHERE (_ZipID = @_ZipID)";
using (SqlCommand cmd = new SqlCommand(deleteString, OpenConnection))
{
cmd.Parameters.AddWithValue("@_ZipID", zp._ZipID);
var id = (long)cmd.ExecuteNonQuery();
zp = null;
}
}
// GET: ZIPs/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ZIP zIP = db.ZIPs.Find(id);
if (zIP == null)
{
return(HttpNotFound());
}
return(View(zIP));
}
public void GetZIPByID(ref ZIP zp) //Virker ikke - Aner ikke hvorfor
{
string sqlcmd = @"SELECT * FROM ZIP WHERE (_ZipID = @_ZipID)";
using (SqlCommand cmd = new SqlCommand(sqlcmd, OpenConnection))
{
cmd.Parameters.AddWithValue("@_ZipID", zp._ZipID);
SqlDataReader rdr = null;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
}
}
}
public void AddZipDB(ref ZIP zp)
{
string insertStringParam = @"INSERT INTO [ZIP] (_Land, _By, _PostNummer, _ZIPListeID)
OUTPUT INSERTED._ZipID
VALUES (@_Land, @_By, @_PostNummer, @_ZIPListeID)";
using (SqlCommand cmd = new SqlCommand(insertStringParam, OpenConnection))
{
cmd.Parameters.AddWithValue("@_Land", zp._Land);
cmd.Parameters.AddWithValue("@_By", zp._By);
cmd.Parameters.AddWithValue("@_PostNummer", zp._PostNummer);
cmd.Parameters.AddWithValue("@_ZIPListeID", zp._ZIPListeID);
zp._ZipID = (long)cmd.ExecuteScalar();
}
}
public void UpdateZIPDB(ref ZIP zp)
{
string updateString =
@"UPDATE ZIP
SET _Land = @_Land, _By = @_By, _PostNummer = @_PostNummer, _ZIPListeID = @_ZIPListeID
WHERE _ZipID = @_ZipID";
using (SqlCommand cmd = new SqlCommand(updateString, OpenConnection))
{
cmd.Parameters.AddWithValue("@_Land", zp._Land);
cmd.Parameters.AddWithValue("@_By", zp._By);
cmd.Parameters.AddWithValue("@_PostNummer", zp._PostNummer);
cmd.Parameters.AddWithValue("@_ZIPListeID", zp._ZIPListeID);
cmd.Parameters.AddWithValue("@_ZipID", zp._ZipID);
var id = (long)cmd.ExecuteNonQuery();
}
}
public override int GetHashCode()
{
int hashCode = 18982924;
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(Name);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(Email);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(Address);
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(City);
hashCode = hashCode * -1521134295 + ZIP.GetHashCode();
hashCode = hashCode * -1521134295 + EqualityComparer <string> .Default.GetHashCode(PhoneNumber);
return(hashCode);
}
public void AddZIPDB(ref ZIP hv)
{
// prepare command string using paramters in string and returning the given identity
string insertStringParam = @"INSERT INTO [ZIP] (City_Name, Country_Name, Postal_Code, ZipListID)
OUTPUT INSERTED.ZipID
VALUES (@City_Name, @Country_Name, @Postal_Code, @ZipListID)";
using (SqlCommand cmd = new SqlCommand(insertStringParam, OpenConnection))
{
// Get your parameters ready
cmd.Parameters.AddWithValue("@City_Name", hv.City_Name);//.ToString("yyyy-MM-dd HH:mm:ss");
cmd.Parameters.AddWithValue("@Country_Name", hv.Country_Name);
cmd.Parameters.AddWithValue("@Postal_Code", hv.Postal_Code);
cmd.Parameters.AddWithValue("@ZipListID", hv.ZIPL.ZipListID);
hv.ZipID = (long)cmd.ExecuteScalar(); //Returns the identity of the new tuple/record
}
}
public void GetZIPID(ref ZIP vk)
{
string sqlcmd = @"SELECT * FROM ZIP WHERE (ZipID = @ZipID)";
using (var cmd = new SqlCommand(sqlcmd, OpenConnection))
{
cmd.Parameters.AddWithValue("@AdressID", vk.ZipID);
SqlDataReader rdr = null;
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
//Værktøjskasse curvk = new Værktøjskasse();
vk.ZipID = (int)rdr["AdressID"];
vk.City_Name = (string)rdr["City_Name"];
vk.Country_Name = (string)rdr["Country_Name"];
vk.Postal_Code = (int)rdr["Postal_Code"];
}
}
}
public void UpdateZIP(ref ZIP vtk)
{
// prepare command string
string updateString =
@"UPDATE ZIP
SET City_Name = @City_Name, Country_Name = @Country_Name, Postal_Code = @Postal_Code
WHERE ZipID = @ZipID";
using (SqlCommand cmd = new SqlCommand(updateString, OpenConnection))
{
// Get your parameters ready
cmd.Parameters.AddWithValue("@City_Name", vtk.City_Name);
cmd.Parameters.AddWithValue("@Country_Name", vtk.Country_Name);
cmd.Parameters.AddWithValue("@Postal_Code", vtk.Postal_Code);
var id = (int)cmd.ExecuteNonQuery();
}
}
/// <summary>
/// Compress an unencrypted FAES File.
/// </summary>
/// <param name="unencryptedFile">Unencrypted FAES File</param>
/// <returns>Path of the unencrypted, compressed file</returns>
public string CompressFAESFile(FAES_File unencryptedFile)
{
switch (_compressionMode)
{
case CompressionMode.LZMA:
LZMA lzma = new LZMA();
Logging.Log("Compression Mode: LZMA", Severity.DEBUG);
return(lzma.CompressFAESFile(unencryptedFile));
case CompressionMode.TAR:
TAR tar = new TAR();
Logging.Log("Compression Mode: TAR", Severity.DEBUG);
return(tar.CompressFAESFile(unencryptedFile));
case CompressionMode.LGYZIP:
LegacyZIP legacyZIP = new LegacyZIP();
Logging.Log("Compression Mode: LEGACYZIP", Severity.DEBUG);
return(legacyZIP.CompressFAESFile(unencryptedFile));
default:
{
ZIP zip;
Logging.Log("Compression Mode: ZIP", Severity.DEBUG);
if (_compressionLevelRaw < 0)
{
Logging.Log(String.Format("Compression Level: {0}", _compressionLevel), Severity.DEBUG);
zip = new ZIP(_compressionLevel);
}
else
{
Logging.Log(String.Format("Compression Level: {0}", _compressionLevelRaw), Severity.DEBUG);
zip = new ZIP(_compressionLevelRaw);
}
return(zip.CompressFAESFile(unencryptedFile));
}
}
}
private void wc_DownloadFileCompleted(object sender, AsyncCompletedEventArgs e)
{
try {
string hexString = BitConverter.ToString(File.ReadAllBytes(archive).Take(2).ToArray()).Replace("-", " ");
if (hexString == "50 4B")
{
ZIP.InstallFromZip(archive, Properties.Settings.Default.Path_ModsDirectory);
}
else
{
ZIP.InstallFromCustomArchive(archive, Properties.Settings.Default.Path_ModsDirectory);
}
UnifyMessenger.UnifyMessage.ShowDialog($"{item.ModName} has been installed in your mods directory.",
"Success", MessageBoxButtons.OK, MessageBoxIcon.Information);
File.Delete(archive);
Close();
} catch {
UnifyMessenger.UnifyMessage.ShowDialog($"Failed to extract {item.ModName}...",
"Extract failed...", MessageBoxButtons.OK, MessageBoxIcon.Error);
Close();
}
}
internal SimulatorViewModel(string directoryToExtract)
{
_unpacker = new ZIP(directoryToExtract);
}
public IActionResult yjExportInfo(AddressRequestPayload payload)
{
var response = ResponseModelFactory.CreateInstance;
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportUserInfoWord\\";
var timeInfo = DateTime.Now.ToString("yyyyMMddHHmmss");
var wordName = timeInfo + "address.docx";
string wordUrl = sWebRootFolder + wordName;
MemoryStream ms = new MemoryStream();
XWPFDocument m_Docx = new XWPFDocument();
m_Docx.Write(ms);
ms.Flush();
SaveToFile(ms, wordUrl);
List <string> list = new List <string>();
using (_dbContext)
{
Document document111 = new Document();
document111.LoadFromFile(wordUrl);
Section section = document111.Sections[0];
section.Paragraphs[0].AppendBookmarkStart("picture");
section.Paragraphs[0].AppendBookmarkEnd("picture");
var user = AuthContextService.CurrentUser;
string s1 = payload.Kw2;
string[] s2 = s1.Split(" ");
StringBuilder where = new StringBuilder();
StringBuilder sql = new StringBuilder("SELECT * FROM HomeAddress HA ");
for (int i = 0; i < s2.Length; i++)
{
if (s2.Length > 0 && i == 0)
{
where.Append("WHERE ");
}
where.Append("HA.Address LIKE '%" + s2[i] + "%' ");
if (i >= 0 && i < s2.Length - 1)
{
where.Append(" AND ");
}
}
sql.Append(where);
//var query = _dbContext.HomeAdd.FromSql(sql.ToString());
var query = _dbContext.HomeAddress.FromSqlRaw(sql.ToString());
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.Address.ToString().Contains(payload.Kw));
}
if (!string.IsNullOrEmpty(payload.Kw1))
{
query = query.Where(x => x.Address.ToString().Contains(payload.Kw1));
}
var entities = query.ToList();
//var entities = _dbContext.HomeAddress.Where(x => ids.IndexOf(x.HomeAddressUuid.ToString()) >= 0).ToList();
for (int i = 0; i < entities.Count(); i++)
{
var pata = _hostingEnvironment.WebRootPath + EWM.GetEWM2("h_" + entities[i].HomeAddressUuid.ToString(), _hostingEnvironment, entities[i].Address);
//实例化BookmarksNavigator类,指定需要添加图片的书签“”
BookmarksNavigator bn = new BookmarksNavigator(document111);
bn.MoveToBookmark("picture", true, true);
//添加段落，加载图片并插入到段落
Section section0 = document111.AddSection();
Spire.Doc.Documents.Paragraph paragraph = section0.AddParagraph();
Image image = Image.FromFile(pata);
DocPicture picture = document111.Sections[0].Paragraphs[0].AppendPicture(image);
picture.Width = 160;
picture.Height = 180;
//picture.HorizontalPosition = 100.0f;
//picture.VerticalPosition = 50.0f;
bn.InsertParagraph(paragraph);
document111.Sections.Remove(section0);
//string output = sWebRootFolder + "test.docx";
document111.SaveToFile(wordUrl, FileFormat.Docx);
//Arraypata = pata.;
//list.Add(pata);
}
list.Add(wordUrl);
//关闭进程
document111.Dispose();
var time = DateTime.Now.ToString("yyyyMMddHHmmssfff");
var check = ZIP.CompressMulti(list, _hostingEnvironment.WebRootPath + "\\UploadFiles\\EWM\\" + time, false);
if (check)
{
response.SetSuccess("导出成功");
response.SetData("\\UploadFiles\\EWM\\" + time + ".zip");
}
else
{
response.SetFailed("导出失败");
}
}
return(Ok(response));
}
public void TheApp()
{
////Allokere Utillen
PersonDBUtil cmutil = new PersonDBUtil();
////Opretter ID for Person
Person hv = new Person()
{
PersonID = 1
};
//----------------------------------------Add Ziplister----------------------------------------
ZipListe nyzl = new ZipListe {
ZipListID = 2, ZipCode = "7000"
};
cmutil.AddZipListeDB(ref nyzl);
//----------------------------------------INSERT ZIP----------------------------------------
ZIP nyzv = new ZIP()
{
ZipID = 2, City_Name = "Fredericia", Country_Name = "DK", Postal_Code = 6400, ZIPL = nyzl
};
cmutil.AddZIPDB(ref nyzv);
//#################################################################################################
//----------------------------------------INSERT Adresse----------------------------------------
Adress nyav = new Adress()
{
AdressID = 4, Street_Name = "Aarhusvej", Street_Nr = 3, Apartment_Nr = 23, ZIPs = nyzv
};
cmutil.AddAdressDB(ref nyav);
//----------------------------------------UPDATE Adresse----------------------------------------
//Adress pv = new Adress() { AdressID = 20, Street_Name = "Aarhusvej", Street_Nr = 5, Apartment_Nr = 33};
//cmutil.UpdateAdress(ref pv);
//----------------------------------------DELETE Adresse----------------------------------------
//Adress nyev = new Adress() { AdressID = 10 };
//cmutil.DeleteAdressDB(ref nyev);
//#################################################################################################
//----------------------------------------INSERT Person----------------------------------------
Person nyhv = new Person()
{
First_Name = "Lauritz", Middle_Name = "Karl", Last_Name = "Johan", PrimaryAddress = nyav
};
cmutil.AddPersonDB(ref nyhv);
//----------------------------------------UPDATE Person----------------------------------------
//Person pv = new Person() { PersonID = 5, First_Name = "Henrik", Middle_Name = "Niels", Last_Name = "Olesen"};
//cmutil.UpdatePersonDB(ref pv);
//----------------------------------------DELETE Person----------------------------------------
//Person nyhv1 = new Person() { PersonID = 19 };
//cmutil.DeletePersonDB(ref nyhv1);
//#################################################################################################
//----------------------------------------INSERT Email----------------------------------------
//E_mail nyhv2 = new E_mail() { EmailID = 4, Email_Adress = "*****@*****.**", persons = nyhv};
//cmutil.AddE_mailDB(ref nyhv2);
//----------------------------------------DELETE Email----------------------------------------
//E_mail ev = new E_mail() { EmailID = 10 };
//cmutil.DeleteE_mailDB(ref ev);
//----------------------------------------UPDATE Email----------------------------------------
//E_mail evp = new E_mail() { EmailID = 3, Email_Adress = "*****@*****.**" };
//#################################################################################################
//----------------------------------------INSERT Phone----------------------------------------
//Phone nyph = new Phone() { PhoneID = 3, Phone_Nr = 8300758, Phone_Type = 5, personer = nyhv };
//cmutil.AddPhoneDB(ref nyph);
//----------------------------------------DELETE Phone----------------------------------------
//Phone nywph = new Phone() { PhoneID = 10 };
//cmutil.DeletePhoneDB(ref nywph);
//----------------------------------------UPDATE Phone----------------------------------------
//Phone eph = new Phone() { PhoneID = 4, Phone_Nr = 93939393, Phone_Type = 2, personer = nyhv };
//cmutil.UpdatePhone(ref eph);
//#################################################################################################
//----------------------------------------INSERT Alternativ----------------------------------------
//Alternativ avk = new Alternativ() { aatype = "Hjemmeboende", Adresse = nyav, Persone = nyhv, aaID = 1 };
//cmutil.AddAlternativDB(ref avk);
//----------------------------------------DELETE Alternativ----------------------------------------
//Alternativ nyal = new Alternativ() { aaID = 1};
//cmutil.DeleteAlternativDB(ref nyal);
//----------------------------------------UPDATE Alternativ----------------------------------------
/*Alternativ avp = new Alternativ() { AlternativID = 5, aatyper = "Udeboende" };
* cmutil.UpdatePersonDB(ref avp);*/
//#################################################################################################
//----------------------------------------INSERT Noter----------------------------------------
//Noter not = new Noter() { NoteID = 1, Notes = "Studerende", perso = nyhv };
//cmutil.AddNoterDB(ref not);
//----------------------------------------UPDATE Noter----------------------------------------
/*Noter notpv = new Noter() { NoteID = 1, Notes = "Opdateret", perso = nyhv };
* cmutil.UpdatePersonDB(ref nyhv);*/
//----------------------------------------DELETE Noter----------------------------------------
//Noter notet = new Noter() { NoteID = 1 };
//cmutil.DeleteNoterDB(ref notet);
//#################################################################################################
//Get ID'er
//cmutil.GetCurrentPersonById(ref nyhv);
//cmutil.GetPersonByName(ref nyhv);
}
private async void Btn_Update_Click(object sender, EventArgs e)
{
string archive = Path.GetTempFileName();
string metadata, version = string.Empty;
try { metadata = await Client.RequestString(this.metadata); }
catch { return; }
if (metadata.Length != 0)
{
string[] splitMetadata = metadata.Split(new[] { Environment.NewLine }, StringSplitOptions.None);
foreach (string line in splitMetadata)
{
string entryValue = string.Empty;
if (line.StartsWith("Version"))
{
entryValue = line.Substring(line.IndexOf("=") + 2);
entryValue = entryValue.Remove(entryValue.Length - 1);
version = entryValue;
}
if (line.StartsWith("Data"))
{
entryValue = line.Substring(line.IndexOf("=") + 2);
entryValue = entryValue.Remove(entryValue.Length - 1);
if (data != entryValue)
{
data = entryValue;
}
}
}
}
if (version != this.version)
{
using (WebClient client = new WebClient()) {
client.DownloadProgressChanged += (s, dlevent) => { pgb_Progress.Value = dlevent.ProgressPercentage; };
await client.DownloadFileTaskAsync(new Uri(data), archive);
client.DownloadFileCompleted += (s, dlevent) => {
byte[] bytes = File.ReadAllBytes(archive).Take(2).ToArray();
string hexString = BitConverter.ToString(bytes); hexString = hexString.Replace("-", " ");
DirectoryInfo extractData = new DirectoryInfo(modDirectory);
pic_Thumbnail.BackgroundImage.Dispose();
pic_Thumbnail.BackgroundImage = Properties.Resources.Exception_Logo_Full_Colour;
try {
if (Directory.Exists(modDirectory))
{
foreach (FileInfo file in extractData.GetFiles())
{
file.Delete();
}
foreach (DirectoryInfo directory in extractData.GetDirectories())
{
directory.Delete(true);
}
}
Directory.Delete(modDirectory);
} catch { }
if (hexString == "50 4B")
{
using (ZipArchive zip = new ZipArchive(new MemoryStream(File.ReadAllBytes(archive))))
ZIP.ExtractToDirectory(zip, Properties.Settings.Default.Path_ModsDirectory, true);
}
else
{
ZIP.InstallFromCustomArchive(archive, Properties.Settings.Default.Path_ModsDirectory);
}
UnifyMessenger.UnifyMessage.ShowDialog($"{lbl_Title.Text} has been updated successfully...",
lbl_Title.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
File.Delete(archive);
Close();
};
}
}
else
{
UnifyMessenger.UnifyMessage.ShowDialog("There are currently no updates available.",
lbl_Title.Text, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public int Collect(LogKind logKind, string strExportPath, DateTime dateFrom, DateTime dateTo, Action <int> actionProgress, CancellationTokenSource cancelToken)
{
if (actionProgress != null)
{
actionProgress(5);
}
//Init
_dateFrom = dateFrom;
_dateTo = dateTo;
string strTempPath = "";
SystemEventLog.SystemEventKind[] arrayExportTarget = null;
string strLogPath = "";
string strDBLogPath = "";
string strXmlPath = "";
if (logKind == LogKind.Client)
{
strTempPath = TOPSS_CLIENT_TEMP_PATH;
arrayExportTarget = TopssClientSystemLogTarget;
strLogPath = TOPSS_CLIENT_LOG_PATH;
strDBLogPath = "";
strXmlPath = TOPSS_CLIENT_XML_PATH;
}
else
{
strTempPath = TOPSS_SERVER_TEMP_PATH;
arrayExportTarget = TopssServerSystemLogTarget;
strLogPath = TOPSS_SERVER_LOG_PATH;
strDBLogPath = TOPSS_SERVER_DB_LOG_PATH;
strXmlPath = TOPSS_SERVER_XML_PATH;
}
string TempFolderName = MakeTempFolderName(logKind, dateFrom, dateTo);
strTempPath = Path.Combine(strTempPath, TempFolderName);
if (actionProgress != null)
{
actionProgress(10);
}
if (cancelToken.IsCancellationRequested)
{
CommonTool.DirectoryEx.DeleteDirectory(strTempPath);
return(-2);
}
//Clear Temp Folder
if (Directory.Exists(strTempPath))
{
CommonTool.DirectoryEx.DeleteDirectory(strTempPath);
}
Directory.CreateDirectory(strTempPath);
if (actionProgress != null)
{
actionProgress(15);
}
if (cancelToken.IsCancellationRequested)
{
CommonTool.DirectoryEx.DeleteDirectory(strTempPath);
return(-2);
}
//System Log Collect
string strSystemLogPath = Path.Combine(strTempPath, EXPORT_ROOT_SYSTEM_LOG);
foreach (var eventKind in arrayExportTarget)
{
SystemEventLog.ExportSystemEvent(eventKind, strSystemLogPath, dateFrom, dateTo);
}
if (actionProgress != null)
{
actionProgress(40);
}
if (cancelToken.IsCancellationRequested)
{
CommonTool.DirectoryEx.DeleteDirectory(strTempPath);
return(-2);
}
//Log Collect
if (!string.IsNullOrEmpty(strLogPath))
{
_strSrcPath = strLogPath;
_strDestPath = Path.Combine(strTempPath, EXPORT_ROOT_LOG);
CommonTool.DirectoryEx.TraversalDirectory(strLogPath, DoLogFileCollect);
}
if (actionProgress != null)
{
actionProgress(55);
}
if (cancelToken.IsCancellationRequested)
{
CommonTool.DirectoryEx.DeleteDirectory(strTempPath);
return(-2);
}
//DB Log Collect
if (!string.IsNullOrEmpty(strDBLogPath))
{
_strSrcPath = strDBLogPath;
_strDestPath = Path.Combine(strTempPath, EXPORT_ROOT_DB_LOG);
CommonTool.DirectoryEx.TraversalDirectory(strDBLogPath, DoLogFileCollect);
}
if (actionProgress != null)
{
actionProgress(70);
}
if (cancelToken.IsCancellationRequested)
{
CommonTool.DirectoryEx.DeleteDirectory(strTempPath);
return(-2);
}
//XML Collect
if (!string.IsNullOrEmpty(strXmlPath))
{
_strSrcPath = strXmlPath;
_strDestPath = Path.Combine(strTempPath, EXPORT_ROOT_XML);
CommonTool.DirectoryEx.TraversalDirectory(_strSrcPath, DoXMLFileCollect, false);
}
if (actionProgress != null)
{
actionProgress(80);
}
if (cancelToken.IsCancellationRequested)
{
CommonTool.DirectoryEx.DeleteDirectory(strTempPath);
return(-2);
}
//Dump Collect
if (!string.IsNullOrEmpty(strLogPath))
{
_strSrcPath = strLogPath;
_strDestPath = Path.Combine(strTempPath, EXPORT_ROOT_DUMP);
CommonTool.DirectoryEx.TraversalDirectory(_strSrcPath, DoDumpFileCollect, false);
}
if (actionProgress != null)
{
actionProgress(90);
}
if (cancelToken.IsCancellationRequested)
{
CommonTool.DirectoryEx.DeleteDirectory(strTempPath);
return(-2);
}
//Compress To ZIP
if (!strExportPath.EndsWith(".zip"))
{
strExportPath += ".zip";
}
//string zipPath = strExportPath + @"\" + TempFolderName + ".zip";
ZIP.Compress(strTempPath, strExportPath);
//Delete Temp File
CommonTool.DirectoryEx.DeleteDirectory(strTempPath);
if (cancelToken.IsCancellationRequested)
{
return(-2);
}
if (actionProgress != null)
{
actionProgress(100);
}
return(0);
}
public IActionResult Batchs(string command, string ids)
{
var response = ResponseModelFactory.CreateInstance;
string sWebRootFolder = _hostingEnvironment.WebRootPath + "\\UploadFiles\\ImportUserInfoWord\\";
var timeInfo = DateTime.Now.ToString("yyyyMMddHHmmss");
var wordName = timeInfo + "address.docx";
string wordUrl = sWebRootFolder + wordName;
MemoryStream ms = new MemoryStream();
XWPFDocument m_Docx = new XWPFDocument();
m_Docx.Write(ms);
ms.Flush();
SaveToFile(ms, wordUrl);
List <string> list = new List <string>();
using (_dbContext)
{
//document111.LoadFromFile(sWebRootFolder + "test.docx");
Document document111 = new Document();
document111.LoadFromFile(wordUrl);
Section section = document111.Sections[0];
document111.Watermark = null;
section.Paragraphs[0].AppendBookmarkStart("picture");
section.Paragraphs[0].AppendBookmarkEnd("picture");
var parameters = ids.Split(",").Select((id, index) => new SqlParameter(string.Format("@p{0}", index), id)).ToList();
var parameterNames = string.Join(", ", parameters.Select(p => p.ParameterName));
var entities = _dbContext.GrabageRoom.Where(x => ids.IndexOf(x.GarbageRoomUuid.ToString()) >= 0).ToList();
for (int i = 0; i < entities.Count; i++)
{
var pata = _hostingEnvironment.WebRootPath + EWM.GetEWM2("d_" + entities[i].GarbageRoomUuid.ToString(), _hostingEnvironment, entities[i].Ljname);
//实例化BookmarksNavigator类,指定需要添加图片的书签“”
BookmarksNavigator bn = new BookmarksNavigator(document111);
bn.MoveToBookmark("picture", true, true);
//添加段落，加载图片并插入到段落
Section section0 = document111.AddSection();
Spire.Doc.Documents.Paragraph paragraph = section0.AddParagraph();
Image image = Image.FromFile(pata);
//DocPicture picture = paragraph.AppendPicture(image);
DocPicture picture = document111.Sections[0].Paragraphs[0].AppendPicture(image);
picture.Width = 160;
picture.Height = 180;
//picture.HorizontalPosition = 100.0f;
//picture.VerticalPosition = 100.0f;
bn.InsertParagraph(paragraph);
document111.Sections.Remove(section0);
//string output = sWebRootFolder + "test.docx";
document111.SaveToFile(wordUrl, FileFormat.Docx);
}
list.Add(wordUrl);
//关闭进程
document111.Dispose();
var time = DateTime.Now.ToString("yyyyMMddHHmmssfff");
var check = ZIP.CompressMulti(list, _hostingEnvironment.WebRootPath + "\\UploadFiles\\EWM\\" + time, false);
if (check)
{
response.SetSuccess("导出成功");
response.SetData("\\UploadFiles\\EWM\\" + time + ".zip");
}
else
{
response.SetFailed("导出失败");
}
return(Ok(response));
}
}
private void Speichern_Click(object sender, RoutedEventArgs e)
{
InputEvaluator ie = new InputEvaluator();
if (ie.Evaluate(this))
{
PersonalAssistant paU = new PersonalAssistant();
var a = App.Current as App;
paU.Id = a.PAIndex;
paU.HomeAdress = new Adress();
paU.HomeAdress.AdressId = pa.HomeAdress.AdressId;
paU.HomeAdress.Street = Street.getContent();
paU.HomeAdress.HouseNumber = parseInt(HNr.getContent());
paU.HomeAdress.Etage = parseInt(Etage.getContent());
paU.HomeAdress.StairNumber = parseInt(StairNr.getContent());
paU.HomeAdress.DoorNumber = parseInt(DoorNr.getContent());
paU.HomeAdress.City = City.getContent();
paU.HomeAdress.ZipCode = parseInt(ZIP.getContent());
paU.HomeAdress.Country = Country.getContent();
paU.nationality = nationality.getContent();
paU.FirstName = FirstName.getContent();
paU.LastName = LastName.getContent();
paU.EMail = Email.getContent();
paU.PhoneNumber = PhoneNr.getContent();
paU.MobilePhone = MobileNr.getContent();
paU.SVN = parseLong(SVN.getContent());
paU.ClosingDateDocuments = DateTime.ParseExact(documentDate.getContent(), "dd.mm.yyyy", CultureInfo.InvariantCulture);
paU.IBAN = IBAN.getContent();
paU.BIC = BIC.getContent();
paU.AccountHolder = kontoinhaber.getContent();
//paU.EmploymentTimes.Clear();
paU.SV = ((bool)SV.IsChecked) ? (true) : false;
paU.Dienstvertrag = ((bool)Dienstvertrag.IsChecked) ? (true) : false;
paU.BestBH = ((bool)BestätigungBH.IsChecked) ? (true) : false;
paU.Grundkurs = ((bool)Grundkurs.IsChecked) ? (true) : false;
paU.Active = ((bool)activeRadioBtn.IsChecked) ? (true) : false;
//Weiterbildungen
paU.consumedHours = Convert.ToDecimal(tbHours.getContent());
paU.deadLineHours = Convert.ToDateTime(tbDeadline.getContent());
paU.InfoField = pa.InfoField;
bl.UpdatePa(paU);
//check if add and delete are in conflict
PAtoPurchaserBL PBL = new PAtoPurchaserBL();
foreach (Purchaser p in addedAGs)
{
foreach (Purchaser pd in deletedAGs)
{
if (p.Id == pd.Id)
{
addedAGs.Remove(p);
deletedAGs.Remove(pd);
}
}
}
//add PA connection
foreach (Purchaser p in addedAGs)
{
PBL.add(paU, p);
}
//delete PA connection
foreach (Purchaser p in deletedAGs)
{
PBL.delete(paU, p);
}
//add Employments
foreach (Employment emp in addedEmps)
{
_bl.insertEmployment(emp);
}
//delete Employments
foreach (Employment emp in deletedEmps)
{
_bl.deleteEmployment(emp);
}
foreach (Window window in Application.Current.Windows)
{
if (window.GetType() == typeof(Main))
{
(window as Main).FrameÜbersicht.Source = new Uri("../Personenverwaltung/PA/PAÜbersicht.xaml", UriKind.Relative);
}
}
}
}
private void save_Click(object sender, RoutedEventArgs e)
{
Purchaser purU = new Purchaser();
if (purData.Purchaser.ContactPerson != null)
{
purU.ContactPerson = new Person();
purU.ContactPerson = purData.Purchaser.ContactPerson;
}
PurchaserData purDataU = new PurchaserData();
purU.HomeAdress = new Adress();
InputEvaluator ie = new InputEvaluator();
if (ie.Evaluate(this))
{
purU.Id = AGidx;
purU.FirstName = FirstName.getContent();
purU.LastName = LastName.getmustContent();
purU.EMail = Email.getContent();
if (PhoneNr.getContent() != null)
{
purU.PhoneNumber = PhoneNr.getContent();
}
if (MobileNr.getContent() != null)
{
purU.MobilePhone = MobileNr.getContent();
}
purU.HomeAdress.AdressId = purData.Purchaser.HomeAdress.AdressId;
purU.HomeAdress.Street = Street.getContent();
purU.HomeAdress.StairNumber = parseInt(StairNr.getContent());
purU.HomeAdress.HouseNumber = parseInt(HNr.getContent());
purU.HomeAdress.Etage = parseInt(Etage.getContent());
purU.HomeAdress.DoorNumber = parseInt(DoorNr.getContent());
purU.HomeAdress.City = City.getContent();
purU.HomeAdress.Country = Country.getContent();
purU.HomeAdress.ZipCode = parseInt(ZIP.getContent());
purU.EntryDate = EntryDate.DisplayDate;
purU.ApprovalBegin = ApprovelFrom.DisplayDate;
purU.ApprovalEnd = ApprovelTo.DisplayDate;
purU.DistrictCommision = districtcommission.getContent();
purU.nationality = nationality.getContent();
purU.SVN = parseLong(SVN.getContent());
purDataU.HourlyRate = parseDecimal(PayperHour.getContent());
purDataU.TravellingAllowanceKM = parseDecimal(KmPay.getContent());
purDataU.HourlyRatePayoff = parseDecimal(billablePayperHour.getContent());
purDataU.Income = parseDecimal(Income.getContent());
purDataU.AssistenceDemand = parseInt(Needof.getContent());
purDataU.InputIncome = parseDecimal(IncomeBetrag.getContent());
purDataU.CareAllowance = parseInt((string)CareAllowence.SelectedValue);
purDataU.Purchaser.InfoField = purData.Purchaser.InfoField;
purDataU.Year = purData.Year;
purDataU.Month = purData.Month;
purU.IBAN = IBAN.getContent();
purU.BIC = BIC.getContent();
purU.AccountHolder = kontoinhaber.getContent();
if ((bool)activeRadioBtn.IsChecked)
{
purU.Active = true;
}
else if ((bool)inactiveRadioBtn.IsChecked)
{
purU.Active = false;
}
if ((bool)einfuehrungskurs.IsChecked)
{
purU.hasContract = true;
}
if ((bool)contract.IsChecked)
{
purU.hasIntroCourse = true;
}
if (purDataU.Purchaser.Employees != null)
{
foreach (EmploymentStatus emp in purData.Purchaser.Employees)
{
bool found = false;
foreach (PersonalAssistant pa in employedPA)
{
if (pa.Id.Equals(emp.Assistant.Id))
{
found = true;
}
}
if (found)
{
purU.Employees.Add(emp);
}
}
}
//add PA connection
PAtoPurchaserBL PBL = new PAtoPurchaserBL();
foreach (PersonalAssistant pa in addedPAs)
{
foreach (PersonalAssistant pad in deletedPAs)
{
if (pa.Id == pad.Id)
{
addedPAs.Remove(pa);
deletedPAs.Remove(pad);
}
}
}
foreach (PersonalAssistant pa in addedPAs)
{
PBL.add(pa, purU);
}
//delete PA connection
foreach (PersonalAssistant pa in deletedPAs)
{
PBL.delete(pa, purU);
}
//delete PA connection
//AKTIV RADIO BOXEN NAMEN
//switch to Übersicht
foreach (Window window in Application.Current.Windows)
{
if (window.GetType() == typeof(Main))
{
(window as Main).FrameÜbersicht.Source = new Uri("../Personenverwaltung/AG/AGÜbersicht.xaml", UriKind.Relative);
}
}
}
purU.InfoField = purData.Purchaser.InfoField;
purDataU.Purchaser = purU;
if (purU.FirstName != null && purU.LastName != null)
{
bl.UpdatePurchaser(purDataU);
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
if (purData == null)
{
purData = new PurchaserData();
}
if (purData.Purchaser == null)
{
purData.Purchaser = new Purchaser();
}
Purchaser pur = purData.Purchaser;
//purData = new PurchaserData();
pur.HomeAdress = new Adress();
InputEvaluator ie = new InputEvaluator();
bool save = true;
if (doubles())
{
SystemSounds.Asterisk.Play();
switch (MessageBox.Show("Es existiert bereits ein Auftraggeber mit diesem Namen. Soll er wirklich hinzugefügt werden?",
"Achtung!",
MessageBoxButton.YesNo, MessageBoxImage.Question))
{
case MessageBoxResult.No:
save = false;
break;
case MessageBoxResult.Yes:
break;
}
}
if (save)
{
if (ie.Evaluate(this))
{
pur.FirstName = FirstName.getContent();
pur.LastName = LastName.getmustContent();
pur.EMail = Email.getContent();
if (PhoneNr.getContent() != null)
{
pur.PhoneNumber = PhoneNr.getContent();
}
if (MobileNr.getContent() != null)
{
pur.MobilePhone = MobileNr.getContent();
}
pur.HomeAdress.Street = Street.getContent();
pur.HomeAdress.StairNumber = parseInt(StairNr.getContent());
pur.HomeAdress.HouseNumber = parseInt(HNr.getContent());
pur.HomeAdress.Etage = parseInt(Etage.getContent());
pur.HomeAdress.DoorNumber = parseInt(DoorNr.getContent());
pur.HomeAdress.City = City.getContent();
pur.HomeAdress.Country = Country.getContent();
pur.HomeAdress.ZipCode = parseInt(ZIP.getContent());
pur.BIC = BIC.getContent();
pur.IBAN = IBAN.getContent();
pur.SVN = parseLong(SVN.getContent());
pur.AccountHolder = kontoinhaber.getContent();
pur.EntryDate = EntryDate.SelectedDate;
pur.ApprovalBegin = ApprovelFrom.SelectedDate;
pur.ApprovalEnd = ApprovelTo.SelectedDate;
pur.nationality = nationality.getContent();
purData.HourlyRate = parseDecimal(PayperHour.getContent());
purData.TravellingAllowanceKM = parseDecimal(KmPay.getContent());
purData.HourlyRatePayoff = parseDecimal(billablePayperHour.getContent());
purData.Income = parseDecimal(Income.getContent());
purData.AssistenceDemand = parseInt(Needof.getContent());
purData.InputIncome = parseDecimal(IncomeBetrag.getContent());
purData.CareAllowance = parseInt((string)CareAllowence.SelectedValue);
pur.DistrictCommision = districtcommission.getContent();
if ((bool)activeRadioBtn.IsChecked)
{
pur.Active = true;
}
if ((bool)einfuehrungskurs.IsChecked)
{
pur.hasContract = true;
}
if ((bool)contract.IsChecked)
{
pur.hasIntroCourse = true;
}
//switch to Übersicht
foreach (Window window in Application.Current.Windows)
{
if (window.GetType() == typeof(Main))
{
(window as Main).FrameÜbersicht.Source = new Uri("../Personenverwaltung/AG/AGÜbersicht.xaml", UriKind.Relative);
}
}
purData.Purchaser = pur;
if (pur.FirstName != null && pur.LastName != null)
{
_bl.CreatePurchaser(purData);
}
//add PA connection
PAtoPurchaserBL PBL = new PAtoPurchaserBL();
foreach (PersonalAssistant pa in addedPAs)
{
foreach (PersonalAssistant pad in deletedPAs)
{
if (pa.Id == pad.Id)
{
addedPAs.Remove(pa);
deletedPAs.Remove(pad);
}
}
}
foreach (PersonalAssistant pa in addedPAs)
{
PBL.add(pa, pur);
}
//delete PA connection
foreach (PersonalAssistant pa in deletedPAs)
{
PBL.delete(pa, pur);
}
}
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
InputEvaluator ie = new InputEvaluator();
_bl = new PersonalAssistentBl();
bool save = true;
if (doubles())
{
SystemSounds.Asterisk.Play();
switch (MessageBox.Show("Es existiert bereits ein Persönlicher Assistent mit diesem Namen. Soll er wirklich hinzugefügt werden?",
"Achtung!",
MessageBoxButton.YesNo, MessageBoxImage.Question))
{
case MessageBoxResult.No:
save = false;
break;
case MessageBoxResult.Yes:
break;
}
}
if (save)
{
if (ie.Evaluate(this))
{
//PersonalAssistant pa = new PersonalAssistant();
pa.HomeAdress = new Adress();
pa.HomeAdress.Street = Street.getContent();
pa.HomeAdress.HouseNumber = parseInt(HNr.getContent());
pa.HomeAdress.Etage = parseInt(Etage.getContent());
pa.HomeAdress.StairNumber = parseInt(StairNr.getContent());
pa.HomeAdress.DoorNumber = parseInt(DoorNr.getContent());
pa.HomeAdress.City = City.getContent();
pa.HomeAdress.ZipCode = parseInt(ZIP.getContent());
pa.HomeAdress.Country = Country.getContent();
pa.nationality = nationality.getContent();
pa.FirstName = FirstName.getContent();
pa.LastName = LastName.getContent();
pa.EMail = Email.getContent();
pa.PhoneNumber = PhoneNr.getContent();
pa.MobilePhone = MobileNr.getContent();
pa.SVN = parseLong(SVN.getContent());
// TODO add document date
pa.IBAN = IBAN.getContent();
pa.BIC = BIC.getContent();
pa.AccountHolder = kontoinhaber.getContent();
pa.SV = ((bool)SV.IsChecked) ? (true) : false;
pa.Dienstvertrag = ((bool)Dienstvertrag.IsChecked) ? (true) : false;
pa.BestBH = ((bool)BestätigungBH.IsChecked) ? (true) : false;
pa.Grundkurs = ((bool)Grundkurs.IsChecked) ? (true) : false;
pa.Purchasers = new List <Purchaser>();
pa.EmploymentTimes = this.employmentList;
pa.consumedHours = Convert.ToDecimal(tbHours.getContent());
//Deadline für die Weiterbildungen ermitteln
if (pa.EmploymentTimes != null && pa.EmploymentTimes.Count != 0 && pa.EmploymentTimes.Last().EmplBegin.Year == 1)
{
pa.deadLineHours = pa.EmploymentTimes.Last().EmplBegin.AddYears(2);
}
else
{
pa.deadLineHours = DateTime.Now.AddYears(2);
}
if ((bool)activeRadioButton.IsChecked)
{
pa.Active = true;
}
foreach (Purchaser pur in employedPurchasers)
{
//pa.Purchasers.Add(pur);
}
_bl.CreatePa(pa);
PAtoPurchaserBL PBL = new PAtoPurchaserBL();
foreach (Purchaser p in addedAGs)
{
foreach (Purchaser pd in deletedAGs)
{
if (p.Id == pd.Id)
{
addedAGs.Remove(p);
deletedAGs.Remove(pd);
}
}
}
//insert PA Connection
foreach (Purchaser p in addedAGs)
{
PBL.add(pa, p);
}
//delete PA connection
foreach (Purchaser p in deletedAGs)
{
PBL.delete(pa, p);
}
//add Employments
foreach (Employment emp in addedEmps)
{
emp.EmplId = pa.Id;
_bl.insertEmployment(emp);
}
//delete Employments
foreach (Employment emp in deletedEmps)
{
emp.EmplId = pa.Id;
_bl.deleteEmployment(emp);
}
//switch to Übersicht
foreach (Window window in Application.Current.Windows)
{
if (window.GetType() == typeof(Main))
{
(window as Main).FrameÜbersicht.Source = new Uri("../Personenverwaltung/PA/PAÜbersicht.xaml", UriKind.Relative);
}
}
}
}
}
