public static void PrintTransferSheet(User fromUser, User toUser, Equipment equipment, String date) { // INPUT NEEDED INFORMATION excelapp = new Excel.Application(); workbook = excelapp.Workbooks.Open( ConfigurationManager.ConnectionStrings["path"].ConnectionString + "TransferSheet.xlsx", Type.Missing, false, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); worksheet = (Excel.Worksheet)workbook.Sheets[1]; worksheet.Cells[3, 1] = "Дата: " + DateTime.Now.ToString(); worksheet.Cells[7, 2] = toUser.Name; worksheet.Cells[9, 2] = fromUser.Name; worksheet.Cells[12, 1] = equipment.Name; worksheet.Cells[12, 2] = equipment.Type; worksheet.Cells[12, 3] = equipment.Id; worksheet.Cells[12, 4] = equipment.Serial; worksheet.Cells[15, 1] = "Обязуюсь вернуть до: " + date.ToString(); // PRINT SHEET Drawing.Printing.PrinterSettings settings = new Drawing.Printing.PrinterSettings(); String printerName = settings.PrinterName.ToString(); worksheet.PrintOutEx(1, 1, 2, false, printerName, Type.Missing, Type.Missing, Type.Missing, Type.Missing); workbook.Close(false, Type.Missing, Type.Missing); excelapp.Quit(); GC.Collect(); }
public static void PrintLostSheet(User user, Equipment equipment) { // INPUT NEEDED INFORMATION excelapp = new Excel.Application(); workbook = excelapp.Workbooks.Open( ConfigurationManager.ConnectionStrings["path"].ConnectionString + "LostSheet.xlsx", Type.Missing, false, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); worksheet = (Excel.Worksheet)workbook.Sheets[1]; worksheet.Cells[3, 1] = "Дата: " + DateTime.Now.ToString(); worksheet.Cells[8, 2] = user.Name; worksheet.Cells[12, 1] = equipment.Name; worksheet.Cells[12, 2] = equipment.Type; worksheet.Cells[12, 3] = equipment.Id; worksheet.Cells[12, 4] = equipment.Serial; // PRINT SHEET Drawing.Printing.PrinterSettings settings = new Drawing.Printing.PrinterSettings(); String printerName = settings.PrinterName.ToString(); worksheet.PrintOutEx(1, 1, 2, false, printerName, Type.Missing, Type.Missing, Type.Missing, Type.Missing); workbook.Save(); excelapp.Quit(); GC.Collect(); }
public static void PrintExchangeSheet(User user, Equipment oldEquipment, Equipment newEquipment, String date) { // INPUT NEEDED INFORMATION excelapp = new Excel.Application(); try { workbook = excelapp.Workbooks.Open( ConfigurationManager.ConnectionStrings["path"].ConnectionString + "ExchangeSheet.xlsx", Type.Missing, false, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); } catch (Exception) { return; } worksheet = (Excel.Worksheet)workbook.Sheets[1]; worksheet.Cells[3, 1] = "Дата: " + DateTime.Now.ToString(); worksheet.Cells[7, 2] = user.Name.ToString(); worksheet.Cells[11, 1] = oldEquipment.Name.ToString(); worksheet.Cells[11, 4] = oldEquipment.Id.ToString(); worksheet.Cells[14, 1] = oldEquipment.Type.ToString(); worksheet.Cells[14, 3] = "№" + oldEquipment.Serial.ToString(); worksheet.Cells[19, 1] = newEquipment.Name.ToString(); worksheet.Cells[19, 4] = newEquipment.Id.ToString(); worksheet.Cells[22, 1] = newEquipment.Type.ToString(); worksheet.Cells[22, 3] = "№" + newEquipment.Serial.ToString(); worksheet.Cells[24, 1] = "Обязуюсь вернуть до: " + date.ToString(); // SHEETS PRINTING Drawing.Printing.PrinterSettings settings = new Drawing.Printing.PrinterSettings(); String printerName = settings.PrinterName.ToString(); worksheet.PrintOutEx(1, 1, 2, false, printerName, Type.Missing, Type.Missing, Type.Missing, Type.Missing); // EXCEL FILE CLOSING workbook.Close(false, Type.Missing, Type.Missing); excelapp.Quit(); GC.Collect(); }
public static void PrintReturnSheet(User user, Equipment equipment) { // INPUT NEEDED INFORMATION excelapp = new Excel.Application(); try { workbook = excelapp.Workbooks.Open( ConfigurationManager.ConnectionStrings["path"].ConnectionString + "ReturnSheet.xlsx", Type.Missing, false, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); } catch (Exception) { return; } worksheet = (Excel.Worksheet)workbook.Sheets[1]; worksheet.Cells[3, 1] = "Дата: " + DateTime.Now.ToString(); worksheet.Cells[7, 2] = ConfigurationManager.ConnectionStrings["stockName"].ConnectionString; worksheet.Cells[9, 2] = user.Name.ToString(); worksheet.Cells[12, 1] = equipment.Name.ToString(); worksheet.Cells[12, 4] = equipment.Id.ToString(); worksheet.Cells[15, 1] = equipment.Type.ToString(); worksheet.Cells[15, 3] = "№" + equipment.Serial.ToString(); // PRINT SHEET Drawing.Printing.PrinterSettings settings = new Drawing.Printing.PrinterSettings(); String printerName = settings.PrinterName.ToString(); worksheet.PrintOutEx(1, 1, 2, false, printerName, Type.Missing, Type.Missing, Type.Missing, Type.Missing); // EXCEL FILE CLOSING workbook.Close(false, Type.Missing, Type.Missing); excelapp.Quit(); GC.Collect(); }