/// <summary> /// 打印Hood的CutList /// </summary> /// <param name="drawing"></param> /// <param name="dgv"></param> public bool ExecPrintHoodCutList(Drawing drawing, ModuleTree tree, DataGridView dgv) { Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); string excelBookPath = Environment.CurrentDirectory + "\\CutList.xlsx"; excelApp.Workbooks.Add(excelBookPath); Microsoft.Office.Interop.Excel.Worksheet workSheet = excelApp.Worksheets[1]; workSheet.Cells[1, 2] = drawing.ProjectName; workSheet.Cells[2, 2] = drawing.ODPNo; workSheet.Cells[3, 2] = drawing.Item; workSheet.Cells[4, 2] = tree.Module; workSheet.Cells[5, 2] = tree.Model; workSheet.Cells[7, 2] = dgv.Rows[0].Cells["AddedDate"].Value; workSheet.Cells[8, 2] = dgv.Rows[0].Cells["UserAccount"].Value; FillCutListDate(workSheet, dgv); //预览 //excelApp.Visible = true; //excelApp.Sheets.PrintPreview(true); //打印 workSheet.PrintOutEx(); KillProcess(excelApp); excelApp = null; //对象置空 GC.Collect(); //垃圾回收机制 return(true); }
/// <summary> /// 打印天花烟罩标签 /// </summary> /// <param name="objProject"></param> /// <param name="list"></param> /// <returns></returns> internal bool ExecPrintCeilingLabel(Project objProject, List <CeilingAccessory> itemList) { Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); string excelBookPath = Environment.CurrentDirectory + "\\CeilingLabel.xlsx"; excelApp.Workbooks.Add(excelBookPath); Microsoft.Office.Interop.Excel.Worksheet workSheet = excelApp.Worksheets[1]; foreach (var item in itemList) { workSheet.Cells[1, 1] = objProject.ODPNo; string descEng = item.PartDescription.Substring(item.PartDescription.IndexOf("(") + 1); workSheet.Cells[2, 1] = item.PartDescription.Substring(0, item.PartDescription.IndexOf("(")); workSheet.Cells[3, 1] = descEng.Substring(0, descEng.Length - 1); workSheet.Cells[4, 1] = item.PartNo; workSheet.Cells[5, 1] = item.Quantity + "-" + item.Unit + " (" + item.Location + ")"; workSheet.Cells[6, 1] = item.Material; workSheet.Cells[7, 1] = item.Length + "x" + item.Width + "x" + item.Height + "(mm)"; //打印 workSheet.PrintOutEx(); } //预览 //excelApp.Visible = true; //excelApp.Sheets.PrintPreview(true); KillProcess(excelApp); excelApp = null; //对象置空 GC.Collect(); //垃圾回收机制 return(true); }
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 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(); }
internal void Print() { object misValue = System.Reflection.Missing.Value; xlSh.Columns.AutoFit(); xlSh.PrintOutEx(1, misValue, 1, false, misValue, misValue, misValue, misValue); Dispose(); }
internal static void PrintExcelSheet(Excel.Application app, Excel.Worksheet sheet, String activePrinter) { try { app.ActivePrinter = activePrinter; sheet.PrintOutEx(); } catch (Exception e) { Console.WriteLine("Print error:\r\n" + e.Message); } }
/// <summary> /// 打印发货清单 /// </summary> /// <param name="objProject"></param> /// <param name="dgvCeilingPackingList"></param> /// <returns></returns> public bool ExecPrintCeilingPackingList(Project objProject, DataGridView dgv) { Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); string excelBookPath = Environment.CurrentDirectory + "\\CeilingPackingList.xlsx"; excelApp.Workbooks.Add(excelBookPath); Microsoft.Office.Interop.Excel.Worksheet workSheet = excelApp.Worksheets[1]; //将区域添加到字典中并计数 Dictionary <string, int> locationList = new Dictionary <string, int>(); for (int i = 0; i < dgv.RowCount; i++) { if (locationList.ContainsKey(dgv.Rows[i].Cells["Location"].Value.ToString())) { locationList[dgv.Rows[i].Cells["Location"].Value.ToString()] += 1; } else { locationList.Add(dgv.Rows[i].Cells["Location"].Value.ToString(), 1); } } int startRow = 0; int endRow = 0; int countRow = 0; foreach (var item in locationList) { endRow = startRow + item.Value; workSheet.Cells[1, 1] = objProject.ODPNo + "-天花烟罩发货清单(Ceiling Hood Packing List)-" + item.Key; workSheet.Cells[2, 3] = objProject.ProjectName; workSheet.Cells[3, 3] = DateTime.Now.ToShortDateString(); workSheet.Cells[4, 3] = dgv.Rows[1].Cells["UserAccount"].Value; FillCeilingPackingListDate(workSheet, dgv, startRow, endRow); //预览 //excelApp.Visible = true; //excelApp.Sheets.PrintPreview(true); //打印 workSheet.PrintOutEx(); Microsoft.Office.Interop.Excel.Range range = workSheet.Rows["7:" + (item.Value + 7), Missing.Value]; range.Delete(Microsoft.Office.Interop.Excel.XlDirection.xlDown); startRow = endRow; } KillProcess(excelApp); excelApp = null; //对象置空 GC.Collect(); //垃圾回收机制 return(true); }
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(); }
/// <summary> /// 天花烟罩打印JobCard /// </summary> /// <param name="tree"></param> public void ExecPrintCeilingJobCard(Project objProject, string itemNo, string model) { Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); string excelBookPath = Environment.CurrentDirectory + "\\JobCard_Ceiling.xlsx"; excelApp.Workbooks.Add(excelBookPath); Microsoft.Office.Interop.Excel.Worksheet workSheet = excelApp.Worksheets[1]; //通用信息 workSheet.Cells[3, 3] = objProject.ODPNo; workSheet.Cells[4, 3] = objProject.BPONo; workSheet.Cells[5, 3] = objProject.ProjectName; workSheet.Cells[6, 3] = objProject.CustomerName; workSheet.Cells[13, 7] = objProject.ShippingTime.ToShortDateString(); //天花烟罩 workSheet.Cells[7, 3] = itemNo; workSheet.Cells[8, 3] = model; workSheet.Cells[20, 4] = ""; workSheet.Cells[20, 5] = ""; workSheet.Cells[20, 6] = ""; workSheet.Cells[20, 7] = ""; workSheet.Cells[20, 8] = ""; //特殊要求 List <string> srList = new RequirementService().GetSpecialRequirementList(objProject.ODPNo); for (int i = 0; i < srList.Count; i++) { if (i > 6) { continue; } workSheet.Cells[23 + i * 2, 3] = srList[i]; } ////预览 //excelApp.Visible = true; //excelApp.Sheets.PrintPreview(true); //打印 workSheet.PrintOutEx(); KillProcess(excelApp); excelApp = null; //对象置空 GC.Collect(); //垃圾回收机制 }
protected void Button1_Click(object sender, EventArgs e) { try { // Instantiate Excel and start a new workbook. Excel.Application excelApp = new Excel.Application(); // if you want to make excel visible to user, set this property to true, false by default excelApp.Visible = false; // open an existing workbook string workbookPath = @"C:\Temp\ecov.xlsx"; Excel.Workbook excelWorkbook = excelApp.Workbooks.Open(workbookPath, 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false); // get all sheets in workbook Excel.Sheets excelSheets = excelWorkbook.Worksheets; // get some sheet string currentSheet = "Estudio de caso"; Excel.Worksheet excelWorksheet = (Excel.Worksheet)excelSheets.get_Item(currentSheet); excelWorksheet.PrintOutEx(Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); excelWorkbook.SaveAs(@"C:\Temp\ecov1.xlsx"); excelApp.Quit(); } catch (Exception theException) { String errorMessage; errorMessage = "Error: "; errorMessage = String.Concat(errorMessage, theException.Message); errorMessage = String.Concat(errorMessage, " Line: "); errorMessage = String.Concat(errorMessage, theException.Source); } }
public void createMonthlyFE(List <Entities.SAAOModel> Monthly, string month) { ExApp = new Excel.Application(); ExApp.Visible = false; ExBook = ExApp.Workbooks.Open("C:\\Monthly.xlsx"); ExSheet = (Excel.Worksheet)ExBook.Sheets[2]; ////////FINANCIAL EXPENSES MONTHLY // Month, Year ExSheet.Cells[3, 1] = month + DateTime.Now.Year.ToString(); /////// FINANCIAL EXPENSES //50301040 ExSheet.Cells[12, 6] = Monthly[0].AB; ExSheet.Cells[12, 9] = Monthly[0].Amount; // Month ExSheet.Cells[7, 9] = month; try { ExSheet.SaveAs("DBMS\\Monthly\\FE\\" + month + "_REPORT_FE.xlsx"); } catch { } finally { if (MessageBox.Show("Do you want to continue to printing?", "Print?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { ExSheet.PrintOutEx(); } ExApp.Visible = true; ExSheet.PrintPreview(); ExBook.Close(); } }
private void button6_Click(object sender, EventArgs e) { Excel.Application app = new Excel.Application(); string Filestr = $@"C:\hw4\{textBox8.Text}"; app.Visible = true; Excel.Workbook workbook = app.Workbooks.Open(Filestr); Excel.Worksheet worksheet = (Excel.Worksheet)workbook.ActiveSheet; //app.Workbooks.Open(Filestr); Excel.PageSetup pageSetup = worksheet.PageSetup; pageSetup.Orientation = Excel.XlPageOrientation.xlLandscape; workbook.Save(); worksheet.PrintOutEx(); workbook.Close(); app.Quit(); }
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(); }
public void createSAAOExcel(List <Entities.SAAOModel> SAAO) { DateTimeFormatInfo dateFormat = new DateTimeFormatInfo(); ExApp = new Excel.Application(); ExApp.Visible = false; ExBook = ExApp.Workbooks.Open("C:\\SAAO.xls"); ExSheet = (Excel.Worksheet)ExBook.Sheets[1]; string month = dateFormat.GetMonthName(DateTime.Now.Month); /////////////// CAPITAL OUTLAY /////////////// // Month, Year ExSheet.Cells[7, 1] = "as of " + month + ", " + DateTime.Now.Year; //10702990 ExSheet.Cells[95, 6] = SAAO[0].AB; ExSheet.Cells[95, 9] = SAAO[0].Amount; //10704020 ExSheet.Cells[96, 6] = SAAO[1].AB; ExSheet.Cells[96, 9] = SAAO[1].Amount; //10705020 ExSheet.Cells[97, 6] = SAAO[2].AB; ExSheet.Cells[97, 9] = SAAO[2].Amount; //10705030 ExSheet.Cells[98, 6] = SAAO[3].AB; ExSheet.Cells[98, 9] = SAAO[3].Amount; //10705070 ExSheet.Cells[99, 6] = SAAO[4].AB; ExSheet.Cells[99, 9] = SAAO[4].Amount; //10705090 ExSheet.Cells[100, 6] = SAAO[5].AB; ExSheet.Cells[100, 9] = SAAO[5].Amount; //10705110 ExSheet.Cells[101, 6] = SAAO[6].AB; ExSheet.Cells[101, 9] = SAAO[6].Amount; //10705130 ExSheet.Cells[102, 6] = SAAO[7].AB; ExSheet.Cells[102, 9] = SAAO[7].Amount; //10705140 ExSheet.Cells[103, 6] = SAAO[8].AB; ExSheet.Cells[103, 9] = SAAO[8].Amount; //10705990 ExSheet.Cells[104, 6] = SAAO[9].AB; ExSheet.Cells[104, 9] = SAAO[9].Amount; //10707010 ExSheet.Cells[105, 6] = SAAO[10].AB; ExSheet.Cells[105, 9] = SAAO[10].Amount; //10707020 ExSheet.Cells[106, 6] = SAAO[11].AB; ExSheet.Cells[106, 9] = SAAO[11].Amount; //50101010 ExSheet.Cells[16, 6] = SAAO[12].AB; ExSheet.Cells[16, 9] = SAAO[12].Amount; //50101020.1 ExSheet.Cells[18, 6] = SAAO[13].AB; ExSheet.Cells[18, 9] = SAAO[13].Amount; //50101020.2 ExSheet.Cells[19, 6] = SAAO[14].AB; ExSheet.Cells[19, 9] = SAAO[14].Amount; //50102010 ExSheet.Cells[20, 6] = SAAO[15].AB; ExSheet.Cells[20, 9] = SAAO[15].Amount; //50102020 ExSheet.Cells[21, 6] = SAAO[16].AB; ExSheet.Cells[21, 9] = SAAO[16].Amount; //50102030 ExSheet.Cells[22, 6] = SAAO[17].AB; ExSheet.Cells[22, 9] = SAAO[17].Amount; //50102040 ExSheet.Cells[23, 6] = SAAO[18].AB; ExSheet.Cells[23, 9] = SAAO[18].Amount; //50102050 ExSheet.Cells[25, 6] = SAAO[19].AB; ExSheet.Cells[25, 9] = SAAO[19].Amount; //50102060 ExSheet.Cells[26, 6] = SAAO[20].AB; ExSheet.Cells[26, 9] = SAAO[20].Amount; //50102100 ExSheet.Cells[24, 6] = SAAO[21].AB; ExSheet.Cells[24, 9] = SAAO[21].Amount; //50102110 ExSheet.Cells[27, 6] = SAAO[22].AB; ExSheet.Cells[27, 9] = SAAO[22].Amount; //50102120 ExSheet.Cells[28, 6] = SAAO[23].AB; ExSheet.Cells[28, 9] = SAAO[23].Amount; //50102130 ExSheet.Cells[29, 6] = SAAO[24].AB; ExSheet.Cells[29, 9] = SAAO[24].Amount; //50102140 ExSheet.Cells[31, 6] = SAAO[25].AB; ExSheet.Cells[31, 9] = SAAO[25].Amount; //50102150 ExSheet.Cells[30, 6] = SAAO[26].AB; ExSheet.Cells[30, 9] = SAAO[26].Amount; //50102990 ExSheet.Cells[32, 6] = SAAO[27].AB; ExSheet.Cells[32, 9] = SAAO[27].Amount; //50103010 ExSheet.Cells[33, 6] = SAAO[28].AB; ExSheet.Cells[33, 9] = SAAO[28].Amount; //50103020 ExSheet.Cells[34, 6] = SAAO[29].AB; ExSheet.Cells[34, 9] = SAAO[29].Amount; //50103030 ExSheet.Cells[35, 6] = SAAO[30].AB; ExSheet.Cells[35, 9] = SAAO[30].Amount; //50103040 ExSheet.Cells[36, 6] = SAAO[31].AB; ExSheet.Cells[36, 9] = SAAO[31].Amount; //50104030 ExSheet.Cells[37, 6] = SAAO[32].AB; ExSheet.Cells[37, 9] = SAAO[32].Amount; //50104990 ExSheet.Cells[38, 6] = SAAO[33].AB; ExSheet.Cells[38, 9] = SAAO[33].Amount; //50201010 ExSheet.Cells[50, 6] = SAAO[34].AB; ExSheet.Cells[50, 9] = SAAO[34].Amount; //50201020 ExSheet.Cells[51, 6] = SAAO[35].AB; ExSheet.Cells[51, 9] = SAAO[35].Amount; //50202010 ExSheet.Cells[52, 6] = SAAO[36].AB; ExSheet.Cells[52, 9] = SAAO[36].Amount; //50203010 ExSheet.Cells[53, 6] = SAAO[37].AB; ExSheet.Cells[53, 9] = SAAO[37].Amount; //50203020 ExSheet.Cells[54, 6] = SAAO[38].AB; ExSheet.Cells[54, 9] = SAAO[38].Amount; //50203070 ExSheet.Cells[55, 6] = SAAO[39].AB; ExSheet.Cells[55, 9] = SAAO[39].Amount; //50203080 ExSheet.Cells[56, 6] = SAAO[40].AB; ExSheet.Cells[56, 9] = SAAO[40].Amount; //50203090 ExSheet.Cells[57, 6] = SAAO[41].AB; ExSheet.Cells[57, 9] = SAAO[41].Amount; //50203990 ExSheet.Cells[58, 6] = SAAO[42].AB; ExSheet.Cells[58, 9] = SAAO[42].Amount; //50204010 ExSheet.Cells[59, 6] = SAAO[43].AB; ExSheet.Cells[59, 9] = SAAO[43].Amount; //50204020 ExSheet.Cells[60, 6] = SAAO[44].AB; ExSheet.Cells[60, 9] = SAAO[44].Amount; //50205010 ExSheet.Cells[61, 6] = SAAO[45].AB; ExSheet.Cells[61, 9] = SAAO[45].Amount; //50205020.1 ExSheet.Cells[62, 6] = SAAO[46].AB; ExSheet.Cells[62, 9] = SAAO[46].Amount; //50205020.2 ExSheet.Cells[63, 6] = SAAO[47].AB; ExSheet.Cells[63, 9] = SAAO[47].Amount; //50205030 ExSheet.Cells[64, 6] = SAAO[48].AB; ExSheet.Cells[64, 9] = SAAO[48].Amount; //50210030 ExSheet.Cells[65, 6] = SAAO[49].AB; ExSheet.Cells[65, 9] = SAAO[49].Amount; //50211030 ExSheet.Cells[66, 6] = SAAO[50].AB; ExSheet.Cells[66, 9] = SAAO[50].Amount; //50211990 ExSheet.Cells[67, 6] = SAAO[51].AB; ExSheet.Cells[67, 9] = SAAO[51].Amount; //50212020 ExSheet.Cells[68, 6] = SAAO[52].AB; ExSheet.Cells[68, 9] = SAAO[52].Amount; //50212030 ExSheet.Cells[69, 6] = SAAO[53].AB; ExSheet.Cells[69, 9] = SAAO[53].Amount; //50213040 ExSheet.Cells[70, 6] = SAAO[54].AB; ExSheet.Cells[70, 9] = SAAO[54].Amount; //50213050.1 ExSheet.Cells[71, 6] = SAAO[55].AB; ExSheet.Cells[71, 9] = SAAO[55].Amount; //50213050.2 ExSheet.Cells[72, 6] = SAAO[56].AB; ExSheet.Cells[72, 9] = SAAO[56].Amount; //50213050.3 ExSheet.Cells[73, 6] = SAAO[57].AB; ExSheet.Cells[73, 9] = SAAO[57].Amount; //50213050.4 ExSheet.Cells[74, 6] = SAAO[58].AB; ExSheet.Cells[74, 9] = SAAO[58].Amount; //50213050.5 ExSheet.Cells[75, 6] = SAAO[59].AB; ExSheet.Cells[75, 9] = SAAO[59].Amount; //50213050.6 ExSheet.Cells[76, 6] = SAAO[60].AB; ExSheet.Cells[76, 9] = SAAO[60].Amount; //50213050.7 ExSheet.Cells[77, 6] = SAAO[61].AB; ExSheet.Cells[77, 9] = SAAO[61].Amount; //50213060 ExSheet.Cells[78, 6] = SAAO[62].AB; ExSheet.Cells[78, 9] = SAAO[62].Amount; //50213070 ExSheet.Cells[79, 6] = SAAO[63].AB; ExSheet.Cells[79, 9] = SAAO[63].Amount; //50216020 ExSheet.Cells[80, 6] = SAAO[64].AB; ExSheet.Cells[80, 9] = SAAO[64].Amount; //50216030 ExSheet.Cells[81, 6] = SAAO[65].AB; ExSheet.Cells[81, 9] = SAAO[65].Amount; //50299010 ExSheet.Cells[82, 6] = SAAO[66].AB; ExSheet.Cells[82, 9] = SAAO[66].Amount; //50299020 ExSheet.Cells[83, 6] = SAAO[67].AB; ExSheet.Cells[83, 9] = SAAO[67].Amount; //50299030 ExSheet.Cells[84, 6] = SAAO[68].AB; ExSheet.Cells[84, 9] = SAAO[68].Amount; //50299050 ExSheet.Cells[85, 6] = SAAO[69].AB; ExSheet.Cells[85, 9] = SAAO[69].Amount; //50299060 ExSheet.Cells[86, 6] = SAAO[70].AB; ExSheet.Cells[86, 9] = SAAO[70].Amount; //50299070 ExSheet.Cells[87, 6] = SAAO[71].AB; ExSheet.Cells[87, 9] = SAAO[71].Amount; //50299990 ExSheet.Cells[88, 6] = SAAO[72].AB; ExSheet.Cells[88, 9] = SAAO[72].Amount; //50301040 ExSheet.Cells[92, 6] = SAAO[73].AB; ExSheet.Cells[92, 9] = SAAO[73].Amount; try { ExSheet.SaveAs("DBMS\\SAAO\\SAAOAsOf_" + month + ".xlsx"); } catch { } finally { if (MessageBox.Show("Do you want to continue to printing?", "Print?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { ExSheet.PrintOutEx(); } ExApp.Visible = true; ExSheet.PrintPreview(); ExBook.Close(); } }
public void createMonthlyCO(List <Entities.SAAOModel> Monthly, string month) { ExApp = new Excel.Application(); ExApp.Visible = false; ExBook = ExApp.Workbooks.Open("C:\\Monthly.xlsx"); ExSheet = (Excel.Worksheet)ExBook.Sheets[1]; /////////////// CAPITAL OUTLAY /////////////// // Month, Year ExSheet.Cells[3, 1] = month + DateTime.Now.Year.ToString(); //CAPITAL OUTLAY //10702990 ExSheet.Cells[12, 6] = Monthly[0].AB; ExSheet.Cells[12, 9] = Monthly[0].Amount; //10704020 ExSheet.Cells[13, 6] = Monthly[1].AB; ExSheet.Cells[13, 9] = Monthly[1].Amount; //10705020 ExSheet.Cells[14, 6] = Monthly[2].AB; ExSheet.Cells[14, 9] = Monthly[2].Amount; //10705030 ExSheet.Cells[15, 6] = Monthly[3].AB; ExSheet.Cells[15, 9] = Monthly[3].Amount; //10705070 ExSheet.Cells[16, 6] = Monthly[4].AB; ExSheet.Cells[16, 9] = Monthly[4].Amount; //10705090 ExSheet.Cells[17, 6] = Monthly[5].AB; ExSheet.Cells[17, 9] = Monthly[5].Amount; //10705110 ExSheet.Cells[18, 6] = Monthly[6].AB; ExSheet.Cells[18, 9] = Monthly[6].Amount; //10705130 ExSheet.Cells[19, 6] = Monthly[7].AB; ExSheet.Cells[19, 9] = Monthly[7].Amount; //10705140 ExSheet.Cells[20, 6] = Monthly[8].AB; ExSheet.Cells[20, 9] = Monthly[8].Amount; //10705990 ExSheet.Cells[21, 6] = Monthly[9].AB; ExSheet.Cells[21, 9] = Monthly[9].Amount; //10707010 ExSheet.Cells[22, 6] = Monthly[10].AB; ExSheet.Cells[22, 9] = Monthly[10].Amount; //10707020 ExSheet.Cells[23, 6] = Monthly[11].AB; ExSheet.Cells[23, 9] = Monthly[11].Amount; try { ExSheet.SaveAs("DBMS\\Monthly\\CO\\" + month + "_REPORT_CO.xlsx"); } catch { } finally { if (MessageBox.Show("Do you want to continue to printing?", "Print?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { ExSheet.PrintOutEx(); } ExApp.Visible = true; ExSheet.PrintPreview(); ExBook.Close(); } }
public void Print(List <object> param) { JObject dataObj = (JObject)param[0]; JArray data = (JArray)dataObj["Outputs"]; string SaveAsPath = param[1].ToString(); string TemplateFile = param[2].ToString(); Excel.Application excel = new Excel.ApplicationClass(); Excel.Workbook wb = null; Excel.Worksheet ws = null; try { wb = excel.Application.Workbooks.Open(TemplateFile, Type.Missing, true, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, true, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); ws = (Excel.Worksheet)wb.Worksheets.get_Item(1); foreach (var item in data) { string Name = "@" + item["Name"].ToString() + "@"; string Type = item["Type"].ToString(); for (int i = 1; i <= ws.UsedRange.Rows.Count; i++) { Excel.Range A = (Excel.Range)ws.Cells[i, 1]; if (A.Text.ToString() == Name) { if (Type == "0") { ws.Cells[i, 2] = item["Value"].ToString(); } else { JArray Values = (JArray)item["Value"]; for (int x = 0; x < Values.Count; x++) { ws.Cells[i, x + 2] = Values[x].ToString(); } } } } } for (int i = 1; i <= ws.UsedRange.Rows.Count; i++) { Excel.Range A = (Excel.Range)ws.Cells[i, 1]; if (A.Text.ToString() == "@PAGE@") { ws.Cells[i, 2] = dataObj["PAGE"].ToString(); } if (A.Text.ToString() == "@ALLPAGE@") { ws.Cells[i, 2] = dataObj["ALLPAGE"].ToString(); } } Excel.Worksheet wsPrint = (Excel.Worksheet)wb.Worksheets[2]; wsPrint.PrintOutEx(); if (File.Exists(SaveAsPath)) { try { File.Delete(SaveAsPath); } catch { } } ws.SaveAs(SaveAsPath, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); } catch (Exception ec) { throw ec; } finally { KillProcess(excel); } }
static void ClientProccesing(object client_obj) { DataMatrix.net.DmtxImageEncoder encoder = new DataMatrix.net.DmtxImageEncoder(); Byte[] bytes = new Byte[256]; String data = null; TcpClient client = client_obj as TcpClient; data = null; NetworkStream stream = client.GetStream(); int i, j, ArrayCount, c = 0, cs = 0; string[] STR_all_elements = new string[101]; string Cennik = ""; for (i = 0; i < 101; i++) { STR_all_elements[i] = ""; } i = 0; while ((j = stream.Read(bytes, 0, bytes.Length)) != 0) { data = System.Text.Encoding.ASCII.GetString(bytes, 0, j); STR_all_elements[i] = data; //data = "Привет!"; if (Convert.ToInt32(STR_all_elements[i].Substring(STR_all_elements[i].Length - 1, 1)) == 9) { if (Convert.ToInt32(STR_all_elements[i].Substring(STR_all_elements[i].Length - 2, 1)) == 1) { //MessageBox.Show("по артикулу", "Внимание"); Cennik = STR_all_elements[i].Substring(0, STR_all_elements[i].Length - 5); for (j = 1; j < LastRow; j++) { if (Cennik == Convert.ToString(arrData[j, 2])) { data = Convert.ToString(arrData[j, 2]) + " " + Convert.ToString(arrData[j, 3]) + " " + Convert.ToString(arrData[j, 4]) + "руб."; c = 1; break; } } cs = 1; } else { //MessageBox.Show("по штрихкоду", "Внимание"); Cennik = STR_all_elements[i].Substring(0, STR_all_elements[i].Length - 5); for (j = 1; j < LastRow; j++) { if (Cennik == Convert.ToString(arrData[j, 1])) { //получаю артикул data = Convert.ToString(arrData[j, 2]) + " " + Convert.ToString(arrData[j, 3]) + " " + Convert.ToString(arrData[j, 4]) + "руб."; c = 1; break; } } cs = 1; } } if (cs == 1 && c == 0) { data = "Товар в базе не найден!"; } Console.WriteLine(STR_all_elements[i].ToString() + "\n"); byte[] msg = System.Text.Encoding.UTF8.GetBytes(data); stream.Write(msg, 0, msg.Length); i++; } ArrayCount = i; client.Close(); if (c == 1 || cs == 1) { goto m; } for (i = 0; i < ArrayCount; i++) { //предотвращение выбивания сервера при получении пустого элемента if (STR_all_elements[i] == null) { STR_all_elements[i] = " "; } } string[] STR_art_1 = new string[100]; string[] STR_art_2 = new string[100]; string[] STR_art_3 = new string[100]; string[] STR_shtrih_1 = new string[100]; string[] STR_shtrih_2 = new string[100]; string[] STR_shtrih_3 = new string[100]; // Массивы с данными для печати (первый номер - ноиер товара, второй его Артикул, наименование, цена) string[,] Shablon_1 = new string[100, 4]; string[,] Shablon_2 = new string[100, 4]; string[,] Shablon_3 = new string[100, 4]; int k1 = 0, k2 = 0, k3 = 0, j1 = 0, j2 = 0, j3 = 0, j4 = 0, j5 = 0, j6 = 0; //заполняем массив пустыми ячейками for (i = 0; i < 100; i++) { STR_art_1[i] = ""; STR_art_2[i] = ""; STR_art_3[i] = ""; STR_shtrih_1[i] = ""; STR_shtrih_2[i] = ""; STR_shtrih_3[i] = ""; for (j = 0; j < 4; j++) { Shablon_1[i, j] = ""; Shablon_2[i, j] = ""; Shablon_3[i, j] = ""; } } for (i = 0; i < ArrayCount; i++) { //работаем с массивом if (Convert.ToInt32(STR_all_elements[i].Substring(STR_all_elements[i].Length - 1, 1)) == 1) { //шаблон 1 if (Convert.ToInt32(STR_all_elements[i].Substring(STR_all_elements[i].Length - 2, 1)) == 1) { //MessageBox.Show("по артикулу", "Внимание"); STR_art_1[j1] = STR_all_elements[i].Substring(0, STR_all_elements[i].Length - 5); j1++; } else { //MessageBox.Show("по штрихкоду", "Внимание"); STR_shtrih_1[j2] = STR_all_elements[i].Substring(0, STR_all_elements[i].Length - 5); j2++; } } else if (Convert.ToInt32(STR_all_elements[i].Substring(STR_all_elements[i].Length - 1, 1)) == 2) { //шаблон 2 if (Convert.ToInt32(STR_all_elements[i].Substring(STR_all_elements[i].Length - 2, 1)) == 1) { //MessageBox.Show("по артикулу", "Внимание"); STR_art_2[j3] = STR_all_elements[i].Substring(0, STR_all_elements[i].Length - 5); j3++; } else { //MessageBox.Show("по штрихкоду", "Внимание"); STR_shtrih_2[j4] = STR_all_elements[i].Substring(0, STR_all_elements[i].Length - 5); j4++; } } else if (Convert.ToInt32(STR_all_elements[i].Substring(STR_all_elements[i].Length - 1, 1)) == 3) { //шаблон 3 if (Convert.ToInt32(STR_all_elements[i].Substring(STR_all_elements[i].Length - 2, 1)) == 1) { //MessageBox.Show("по артикулу", "Внимание"); STR_art_3[j5] = STR_all_elements[i].Substring(0, STR_all_elements[i].Length - 5); j5++; } else { //MessageBox.Show("по штрихкоду", "Внимание"); STR_shtrih_3[j6] = STR_all_elements[i].Substring(0, STR_all_elements[i].Length - 5); j6++; } } } // данные отсортированы по типам в массивы string FindObj = String.Empty; for (i = 0; i < j1; i++) { FindObj = STR_art_1[i]; for (j = 1; j < LastRow; j++) { if (FindObj == Convert.ToString(arrData[j, 2])) { //получаю артикул Shablon_1[k1, 0] = Convert.ToString(arrData[j, 2]); Bitmap bmp = encoder.EncodeImage(Shablon_1[k1, 0].ToString()); bmp.Save(@AppDomain.CurrentDomain.BaseDirectory + "\\DataM\\" + Shablon_1[k1, 0].ToString() + ".Png", System.Drawing.Imaging.ImageFormat.Png); //получаю наименование Shablon_1[k1, 1] = Convert.ToString(arrData[j, 3]); //получаю цену Shablon_1[k1, 2] = Convert.ToString(arrData[j, 4]); //контроль Долго хранимого товара Shablon_1[k1, 3] = Convert.ToString(arrData[j, 5]); k1++; break; } } } // Теперь по штрихкоду для первого шаблона for (i = 0; i < j2; i++) { FindObj = STR_shtrih_1[i]; for (j = 1; j < LastRow; j++) { if (FindObj == Convert.ToString(arrData[j, 1])) { //получаю артикул Shablon_1[k1, 0] = Convert.ToString(arrData[j, 2]); try { Bitmap bmp = encoder.EncodeImage(Shablon_1[k1, 0].ToString()); bmp.Save(@AppDomain.CurrentDomain.BaseDirectory + "\\DataM\\" + Shablon_1[k1, 0].ToString() + ".Png", System.Drawing.Imaging.ImageFormat.Png); } catch (Exception e) { Console.WriteLine("Exception:", e); } //получаю наименование Shablon_1[k1, 1] = Convert.ToString(arrData[j, 3]); //получаю цену Shablon_1[k1, 2] = Convert.ToString(arrData[j, 4]); //контроль Долго хранимого товара Shablon_1[k1, 3] = Convert.ToString(arrData[j, 5]); k1++; break; } } } //Шаблон 2 for (i = 0; i < j3; i++) { FindObj = STR_art_2[i]; //MessageBox.Show(STR_art_1[i]); for (j = 1; j < LastRow; j++) { if (FindObj == Convert.ToString(arrData[j, 2])) { //получаю артикул Shablon_2[k2, 0] = Convert.ToString(arrData[j, 2]); Bitmap bmp = encoder.EncodeImage(Shablon_2[k2, 0].ToString()); bmp.Save(@AppDomain.CurrentDomain.BaseDirectory + "\\DataM\\" + Shablon_2[k2, 0].ToString() + ".Png", System.Drawing.Imaging.ImageFormat.Png); //получаю наименование Shablon_2[k2, 1] = Convert.ToString(arrData[j, 3]); //получаю цену Shablon_2[k2, 2] = Convert.ToString(arrData[j, 4]); //контроль Долго хранимого товара Shablon_2[k2, 3] = Convert.ToString(arrData[j, 5]); k2++; break; } } } // Теперь по штрихкоду для второго шаблона for (i = 0; i < j4; i++) { FindObj = STR_shtrih_2[i]; for (j = 1; j < LastRow; j++) { if (FindObj == Convert.ToString(arrData[j, 1])) { //получаю артикул Shablon_2[k2, 0] = Convert.ToString(arrData[j, 2]); Bitmap bmp = encoder.EncodeImage(Shablon_2[k2, 0].ToString()); bmp.Save(@AppDomain.CurrentDomain.BaseDirectory + "\\DataM\\" + Shablon_2[k2, 0].ToString() + ".Png", System.Drawing.Imaging.ImageFormat.Png); //получаю наименование Shablon_2[k2, 1] = Convert.ToString(arrData[j, 3]); //получаю цену Shablon_2[k2, 2] = Convert.ToString(arrData[j, 4]); //контроль Долго хранимого товара Shablon_2[k2, 3] = Convert.ToString(arrData[j, 5]); k2++; break; } } } //Шаблон 3 for (i = 0; i < j5; i++) { FindObj = STR_art_3[i]; for (j = 1; j < LastRow; j++) { if (FindObj == Convert.ToString(arrData[j, 2])) { //получаю артикул Shablon_3[k3, 0] = Convert.ToString(arrData[j, 2]); Bitmap bmp = encoder.EncodeImage(Shablon_3[k3, 0].ToString()); bmp.Save(@AppDomain.CurrentDomain.BaseDirectory + "\\DataM\\" + Shablon_3[k3, 0].ToString() + ".Png", System.Drawing.Imaging.ImageFormat.Png); //получаю наименование Shablon_3[k3, 1] = Convert.ToString(arrData[j, 3]); //получаю цену Shablon_3[k3, 2] = Convert.ToString(arrData[j, 4]); //контроль Долго хранимого товара Shablon_3[k3, 3] = Convert.ToString(arrData[j, 5]); k3++; break; } } } // Теперь по штрихкоду для первого шаблона for (i = 0; i < j6; i++) { FindObj = STR_shtrih_3[i]; //MessageBox.Show(STR_art_1[i]); for (j = 1; j < LastRow; j++) { if (FindObj == Convert.ToString(arrData[j, 1])) { //получаю артикул Shablon_3[k3, 0] = Convert.ToString(arrData[j, 2]); Bitmap bmp = encoder.EncodeImage(Shablon_3[k3, 0].ToString()); bmp.Save(@AppDomain.CurrentDomain.BaseDirectory + "\\DataM\\" + Shablon_3[k3, 0].ToString() + ".Png", System.Drawing.Imaging.ImageFormat.Png); //получаю наименование Shablon_3[k3, 1] = Convert.ToString(arrData[j, 3]); //получаю цену Shablon_3[k3, 2] = Convert.ToString(arrData[j, 4]); //контроль Долго хранимого товара Shablon_3[k3, 3] = Convert.ToString(arrData[j, 5]); k3++; break; } } } //массивы готовы к печати. Shablon_1 Shablon_2 Shablon_3 // Массивы с данными для печати (первый номер - товар, второй его Артикул, наименование, цена) счетчики k1, k2, k3 lock (_lock) { //Console.WriteLine("Thread " + Thread.CurrentThread.ManagedThreadId); int x, y, z, t, x1, y1, z1, t1; Excel.Workbook WB = excelapp.ActiveWorkbook; Excel.Worksheet WS = excelapp.ActiveSheet; if (k1 > 0) { excelapp.Workbooks.Open(@AppDomain.CurrentDomain.BaseDirectory + "\\Sh_1.xlsx"); WB = excelapp.ActiveWorkbook; WS = excelapp.ActiveSheet; excelapp.Visible = false; Excel.Range rg = null; float il, it, iw, ih; float zExcelPixel = 0.746835443f; x = 1; y = 3; z = 9; t = 1; x1 = 11; y1 = 1; z1 = 3; t1 = 8; //Console.WriteLine("Thread st 2" + Thread.CurrentThread.ManagedThreadId); for (i = 0; i < k1; i++) { WS.Cells[x, x1] = Shablon_1[i, 0]; WS.Cells[y, y1] = Shablon_1[i, 1]; WS.Cells[z, z1] = Shablon_1[i, 2]; Image im = Image.FromFile(@AppDomain.CurrentDomain.BaseDirectory + "\\DataM\\" + Shablon_1[i, 0].ToString() + ".Png"); // размеры изображения для Shape нужно преобразовывать iw = zExcelPixel * im.Width;// получаем из ширины исходного изображения ih = zExcelPixel * im.Height; if (i % 2 == 0) { rg = WS.get_Range("M" + z, "M" + z); } else { rg = WS.get_Range("AA" + z, "AA" + z); } il = (float)(double)rg.Left;// размеры поступают в double упакованый в object it = (float)(double)rg.Top; WS.Shapes.AddPicture(@AppDomain.CurrentDomain.BaseDirectory + "\\DataM\\" + Shablon_1[i, 0].ToString() + ".Png", Office.MsoTriState.msoFalse, Office.MsoTriState.msoTrue, il, it, iw - 20, ih - 20); im.Dispose(); if (Shablon_1[i, 3] == "1") { WS.Cells[t, t1] = "."; } if (i % 2 == 0) { x1 = 25; y1 = 15; z1 = 17; t1 = 22; } else { x1 = 11; y1 = 1; z1 = 3; t1 = 8; x = x + 11; y = y + 11; z = z + 11; t = t + 11; } //Console.WriteLine("Thread st 3 " + Thread.CurrentThread.ManagedThreadId); } if (k1 <= 10) { WS.PrintOutEx(1, 1); } else if (k1 > 10 && k1 <= 20) { WS.PrintOutEx(1, 2); } else if (k1 > 20 && k1 <= 30) { WS.PrintOutEx(1, 3); } else if (k1 > 30 && k1 <= 40) { WS.PrintOutEx(1, 4); } else if (k1 > 40 && k1 <= 50) { WS.PrintOutEx(1, 5); } else if (k1 > 50 && k1 <= 60) { WS.PrintOutEx(1, 6); } else if (k1 > 60 && k1 <= 70) { WS.PrintOutEx(1, 7); } else if (k1 > 70 && k1 <= 80) { WS.PrintOutEx(1, 8); } else if (k1 > 80 && k1 <= 90) { WS.PrintOutEx(1, 9); } else if (k1 > 90 && k1 <= 100) { WS.PrintOutEx(1, 10); } GC.Collect(); WB.Close(false); excelapp.Quit(); } //Console.WriteLine("Thread st4" + Thread.CurrentThread.ManagedThreadId); //печать 2го шаблона if (k2 > 0) { excelapp.Workbooks.Open(@AppDomain.CurrentDomain.BaseDirectory + "\\Sh_2.xlsx"); WB = excelapp.ActiveWorkbook; WS = excelapp.ActiveSheet; excelapp.Visible = false; Excel.Range rg = null; float il, it, iw, ih; float zExcelPixel = 0.746835443f; x = 1; y = 2; z = 6; t = 1; x1 = 8; y1 = 1; z1 = 2; t1 = 5; for (i = 0; i < k2; i++) { WS.Cells[x, x1] = Shablon_2[i, 0]; WS.Cells[y, y1] = Shablon_2[i, 1]; WS.Cells[z, z1] = Shablon_2[i, 2]; Image im = Image.FromFile(@AppDomain.CurrentDomain.BaseDirectory + "\\DataM\\" + Shablon_2[i, 0].ToString() + ".Png"); // размеры изображения для Shape нужно преобразовывать iw = zExcelPixel * im.Width;// получаем из ширины исходного изображения ih = zExcelPixel * im.Height; if (i % 2 == 0) { rg = WS.get_Range("I" + z, "I" + z); } else { rg = WS.get_Range("S" + z, "S" + z); } il = (float)(double)rg.Left;// размеры поступают в double упакованый в object it = (float)(double)rg.Top; WS.Shapes.AddPicture(@AppDomain.CurrentDomain.BaseDirectory + "\\DataM\\" + Shablon_2[i, 0].ToString() + ".Png", Office.MsoTriState.msoFalse, Office.MsoTriState.msoTrue, il, it, iw - 20, ih - 20); im.Dispose(); if (Shablon_2[i, 3] == "1") { WS.Cells[t, t1] = "."; } //правая левая стороны листа if (i % 2 == 0) { //координаты ячеек x1 = 18; y1 = 11; z1 = 12; t1 = 15; } else { x1 = 8; y1 = 1; z1 = 2; t1 = 5; x = x + 8; y = y + 8; z = z + 8; t = t + 8; } } if (k2 <= 10) { WS.PrintOutEx(1, 1); } else if (k2 > 10 && k2 <= 20) { WS.PrintOutEx(1, 2); } else if (k2 > 20 && k2 <= 30) { WS.PrintOutEx(1, 3); } else if (k2 > 30 && k2 <= 40) { WS.PrintOutEx(1, 4); } else if (k2 > 40 && k2 <= 50) { WS.PrintOutEx(1, 5); } else if (k2 > 50 && k2 <= 60) { WS.PrintOutEx(1, 6); } else if (k2 > 60 && k2 <= 70) { WS.PrintOutEx(1, 7); } else if (k2 > 70 && k2 <= 80) { WS.PrintOutEx(1, 8); } else if (k2 > 80 && k2 <= 90) { WS.PrintOutEx(1, 9); } else if (k2 > 90 && k2 <= 100) { WS.PrintOutEx(1, 10); } WB.Close(false); excelapp.Quit(); } //3й шаблон if (k3 > 0) { excelapp.Workbooks.Open(@AppDomain.CurrentDomain.BaseDirectory + "\\Sh_3.xlsx"); WB = excelapp.ActiveWorkbook; WS = excelapp.ActiveSheet; excelapp.Visible = false; Excel.Range rg = null; float il, it, iw, ih; float zExcelPixel = 0.746835443f; x = 1; y = 2; z = 8; t = 1; x1 = 10; y1 = 1; z1 = 2; t1 = 7; for (i = 0; i < k3; i++) { WS.Cells[x, x1] = Shablon_3[i, 0]; WS.Cells[y, y1] = Shablon_3[i, 1]; WS.Cells[z, z1] = Shablon_3[i, 2]; Image im = Image.FromFile(@AppDomain.CurrentDomain.BaseDirectory + "\\DataM\\" + Shablon_3[i, 0].ToString() + ".Png"); // размеры изображения для Shape нужно преобразовывать iw = zExcelPixel * im.Width;// получаем из ширины исходного изображения ih = zExcelPixel * im.Height; if (i % 2 == 0) { rg = WS.get_Range("K" + (z + 1), "K" + (z + 1)); } else { rg = WS.get_Range("W" + (z + 1), "W" + (z + 1)); } il = (float)(double)rg.Left;// размеры поступают в double упакованый в object it = (float)(double)rg.Top; WS.Shapes.AddPicture(@AppDomain.CurrentDomain.BaseDirectory + "\\DataM\\" + Shablon_3[i, 0].ToString() + ".Png", Office.MsoTriState.msoFalse, Office.MsoTriState.msoTrue, il, it, iw - 20, ih - 20); im.Dispose(); if (Shablon_3[i, 3] == "1") { WS.Cells[t, t1] = "."; } //правая левая стороны листа if (i % 2 == 0) { //координаты ячеек x1 = 22; y1 = 13; z1 = 14; t1 = 19; } else { x1 = 10; y1 = 1; z1 = 2; t1 = 7; x = x + 11; y = y + 11; z = z + 11; t = t + 11; } } if (k3 <= 10) { WS.PrintOutEx(1, 1); } else if (k3 > 10 && k3 <= 20) { WS.PrintOutEx(1, 2); } else if (k3 > 20 && k3 <= 30) { WS.PrintOutEx(1, 3); } else if (k3 > 30 && k3 <= 40) { WS.PrintOutEx(1, 4); } else if (k3 > 40 && k3 <= 50) { WS.PrintOutEx(1, 5); } else if (k3 > 50 && k3 <= 60) { WS.PrintOutEx(1, 6); } else if (k3 > 60 && k3 <= 70) { WS.PrintOutEx(1, 7); } else if (k3 > 70 && k3 <= 80) { WS.PrintOutEx(1, 8); } else if (k3 > 80 && k3 <= 90) { WS.PrintOutEx(1, 9); } else if (k3 > 90 && k3 <= 100) { WS.PrintOutEx(1, 10); } WB.Close(false); excelapp.Quit(); DirectoryInfo dirInfo = new DirectoryInfo(@AppDomain.CurrentDomain.BaseDirectory + "\\DataM\\"); foreach (FileInfo file in dirInfo.GetFiles()) { file.Delete(); } //Console.WriteLine("Exit" + Thread.CurrentThread.ManagedThreadId); } } m :; }
public void createMonthlyMOOE(List <Entities.SAAOModel> Monthly, string month) { ExApp = new Excel.Application(); ExApp.Visible = false; ExBook = ExApp.Workbooks.Open("C:\\Monthly.xlsx"); ExSheet = (Excel.Worksheet)ExBook.Sheets[3]; /////////////// MOOE /////////////// // Month, Year ExSheet.Cells[3, 1] = month + DateTime.Now.Year.ToString(); ///////MOOE //50201010 ExSheet.Cells[12, 6] = Monthly[0].AB; ExSheet.Cells[12, 9] = Monthly[0].Amount; //50201020 ExSheet.Cells[13, 6] = Monthly[1].AB; ExSheet.Cells[13, 9] = Monthly[1].Amount; //50202010 ExSheet.Cells[14, 6] = Monthly[2].AB; ExSheet.Cells[14, 9] = Monthly[2].Amount; //50203010 ExSheet.Cells[15, 6] = Monthly[3].AB; ExSheet.Cells[15, 9] = Monthly[3].Amount; //50203020 ExSheet.Cells[16, 6] = Monthly[4].AB; ExSheet.Cells[16, 9] = Monthly[4].Amount; //50203070 ExSheet.Cells[17, 6] = Monthly[5].AB; ExSheet.Cells[17, 9] = Monthly[5].Amount; //50203080 ExSheet.Cells[18, 6] = Monthly[6].AB; ExSheet.Cells[18, 9] = Monthly[6].Amount; //50203090 ExSheet.Cells[19, 6] = Monthly[7].AB; ExSheet.Cells[19, 9] = Monthly[7].Amount; //50203990 ExSheet.Cells[20, 6] = Monthly[8].AB; ExSheet.Cells[20, 9] = Monthly[8].Amount; //50204010 ExSheet.Cells[21, 6] = Monthly[9].AB; ExSheet.Cells[21, 9] = Monthly[9].Amount; //50204020 ExSheet.Cells[22, 6] = Monthly[10].AB; ExSheet.Cells[22, 9] = Monthly[10].Amount; //50205010 ExSheet.Cells[23, 6] = Monthly[11].AB; ExSheet.Cells[23, 9] = Monthly[11].Amount; //50205020.1 ExSheet.Cells[24, 6] = Monthly[12].AB; ExSheet.Cells[24, 9] = Monthly[12].Amount; //50205020.2 ExSheet.Cells[25, 6] = Monthly[13].AB; ExSheet.Cells[25, 9] = Monthly[13].Amount; //50205030 ExSheet.Cells[26, 6] = Monthly[14].AB; ExSheet.Cells[26, 9] = Monthly[14].Amount; //50210030 ExSheet.Cells[27, 6] = Monthly[15].AB; ExSheet.Cells[27, 9] = Monthly[15].Amount; //50211030 ExSheet.Cells[28, 6] = Monthly[16].AB; ExSheet.Cells[28, 9] = Monthly[16].Amount; //50211990 ExSheet.Cells[29, 6] = Monthly[17].AB; ExSheet.Cells[29, 9] = Monthly[17].Amount; //50212020 ExSheet.Cells[30, 6] = Monthly[18].AB; ExSheet.Cells[30, 9] = Monthly[18].Amount; //50212030 ExSheet.Cells[31, 6] = Monthly[19].AB; ExSheet.Cells[31, 9] = Monthly[19].Amount; //50213040 ExSheet.Cells[32, 6] = Monthly[20].AB; ExSheet.Cells[32, 9] = Monthly[20].Amount; //50213050.1 ExSheet.Cells[33, 6] = Monthly[21].AB; ExSheet.Cells[33, 9] = Monthly[21].Amount; //50213050.2 ExSheet.Cells[34, 6] = Monthly[22].AB; ExSheet.Cells[34, 9] = Monthly[22].Amount; //50213050.3 ExSheet.Cells[35, 6] = Monthly[23].AB; ExSheet.Cells[35, 9] = Monthly[23].Amount; //50213050.4 ExSheet.Cells[36, 6] = Monthly[24].AB; ExSheet.Cells[36, 9] = Monthly[24].Amount; //50213050.5 ExSheet.Cells[37, 6] = Monthly[25].AB; ExSheet.Cells[37, 9] = Monthly[25].Amount; //50213050.6 ExSheet.Cells[38, 6] = Monthly[26].AB; ExSheet.Cells[38, 9] = Monthly[26].Amount; //50213050.7 ExSheet.Cells[39, 6] = Monthly[27].AB; ExSheet.Cells[39, 9] = Monthly[27].Amount; //50213060 ExSheet.Cells[40, 6] = Monthly[28].AB; ExSheet.Cells[40, 9] = Monthly[28].Amount; //50213070 ExSheet.Cells[41, 6] = Monthly[29].AB; ExSheet.Cells[41, 9] = Monthly[29].Amount; //50216020 ExSheet.Cells[42, 6] = Monthly[30].AB; ExSheet.Cells[42, 9] = Monthly[30].Amount; //50216030 ExSheet.Cells[43, 6] = Monthly[31].AB; ExSheet.Cells[43, 9] = Monthly[31].Amount; //50299010 ExSheet.Cells[44, 6] = Monthly[32].AB; ExSheet.Cells[44, 9] = Monthly[32].Amount; //50299020 ExSheet.Cells[45, 6] = Monthly[33].AB; ExSheet.Cells[45, 9] = Monthly[33].Amount; //50299030 ExSheet.Cells[46, 6] = Monthly[34].AB; ExSheet.Cells[46, 9] = Monthly[34].Amount; //50299050 ExSheet.Cells[47, 6] = Monthly[35].AB; ExSheet.Cells[47, 9] = Monthly[35].Amount; //50299060 ExSheet.Cells[48, 6] = Monthly[36].AB; ExSheet.Cells[48, 9] = Monthly[36].Amount; //50299070 ExSheet.Cells[49, 6] = Monthly[37].AB; ExSheet.Cells[49, 9] = Monthly[37].Amount; //50299990 ExSheet.Cells[50, 6] = Monthly[38].AB; ExSheet.Cells[50, 9] = Monthly[38].Amount; // Month ExSheet.Cells[7, 9] = month; try { ExSheet.SaveAs("DBMS\\Monthly\\MOOE\\" + month + "_REPORT_MOOE.xlsx"); } catch { } finally { if (MessageBox.Show("Do you want to continue to printing?", "Print?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { ExSheet.PrintOutEx(); } ExApp.Visible = true; ExSheet.PrintPreview(); ExBook.Close(); } }
private void btnImprimir_Click(object sender, EventArgs e) { try { DialogResult dr = MessageBox.Show("¿Está seguro que quiere imprimir el estudio?", "Consulta", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { Cursor.Current = Cursors.WaitCursor; // Ruta de xls string fuentePath = ConfigurationManager.AppSettings["dirFormato"]; string destinoPath = ConfigurationManager.AppSettings["dirSalidas"]; string nombreArchivo = ConfigurationManager.AppSettings["formato"]; string nuevoArchivo = nombreArchivo + "_" + dat.IdPersona + "_" + DateTime.Now.ToString("yyyyMMdd_hhmmss"); string ext = ".xlsx"; string current = Environment.CurrentDirectory; // Use Path class to manipulate file and directory paths. string workbookPath = System.IO.Path.Combine(fuentePath, nombreArchivo + ext); string destinoFile = System.IO.Path.Combine(destinoPath, nuevoArchivo + ext); Excel.Application excelApp = new Excel.Application(); excelApp.Visible = false; // open an existing workbook //string workbookPath = @"C:\Temp\ecov.xlsx"; Excel.Workbook excelWorkbook = excelApp.Workbooks.Open(workbookPath, 0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true, false, 0, true, false, false); // get all sheets in workbook Excel.Sheets excelSheets = excelWorkbook.Worksheets; // get some sheet string currentSheet = "Estudio de caso"; Excel.Worksheet excelWorksheet = (Excel.Worksheet)excelSheets.get_Item(currentSheet); DatosNotificante notificante; DatosGenerales generales; Antecedentes antecedentes; IEnumerable <Viaje> viajes; DatosClinicos clinicos; DatosUnidadMedica unidadMedica; Tratamiento tratamiento; Laboratorio laboratorio; Evolucion evolucion; IEnumerable <Contactos> contactos; using (var context = new EstudioEpidemiologicoEntities()) { notificante = context.DatosNotificante.Where(l => l.IdUnidadNotificante == 1).ToList().First(); generales = context.DatosGenerales.Where(l => l.IdPersona == dat.IdPersona).ToList().First(); antecedentes = context.Antecedentes.Where(l => l.IdPersona == dat.IdPersona).ToList().First(); viajes = context.Viaje.Where(l => l.IdPersona == dat.IdPersona).ToList(); clinicos = context.DatosClinicos.Where(l => l.IdPersona == dat.IdPersona).ToList().First(); unidadMedica = context.DatosUnidadMedica.Where(l => l.IdPersona == dat.IdPersona).ToList().First(); tratamiento = context.Tratamiento.Where(l => l.IdPersona == dat.IdPersona).ToList().First(); laboratorio = context.Laboratorio.Where(l => l.IdPersona == dat.IdPersona).ToList().First(); evolucion = context.Evolucion.Where(l => l.IdPersona == dat.IdPersona).ToList().First(); contactos = context.Contactos.Where(l => l.IdPersona == dat.IdPersona).ToList(); } //DATOS DE LA UNIDAD NOTIFICANTE excelWorksheet.Range["C7"].Value = notificante.Entidad; excelWorksheet.Range["F7"].Value = notificante.Jurisdiccion; excelWorksheet.Range["I7"].Value = notificante.Municipio; excelWorksheet.Range["P7"].Value = notificante.NombreUnidadMedica; excelWorksheet.Range["C9"].Value = notificante.Institucion; excelWorksheet.Range["I9"].Value = notificante.CLUES; //DATOS GENERALES excelWorksheet.Range["E11"].Value = generales.FechaIngresoUnidad; excelWorksheet.Range["E14"].Value = generales.PrimerApellido; excelWorksheet.Range["k14"].Value = generales.SegundoApellido; excelWorksheet.Range["Q14"].Value = generales.Nombres; excelWorksheet.Range["E16"].Value = generales.NacimientoDía; excelWorksheet.Range["G16"].Value = generales.NacimientoMes; excelWorksheet.Range["I16"].Value = generales.NacimientoAnio; excelWorksheet.Range["K16"].Value = generales.Edad; excelWorksheet.Range["N16"].Value = generales.CURP; if (generales.Sexo.Equals("H")) { excelWorksheet.Range["D18"].Value = "X"; } else { excelWorksheet.Range["D19"].Value = "X"; } if (!generales.Embarazada.Equals(null)) { if (generales.Embarazada.Value) { excelWorksheet.Range["G19"].Value = "X"; } else { excelWorksheet.Range["H19"].Value = "X"; } } excelWorksheet.Range["K19"].Value = generales.MesesEmbarazo; if (!generales.EnPeriodoPuerperio.Equals(null)) { if (generales.EnPeriodoPuerperio.Value) { excelWorksheet.Range["P19"].Value = "X"; } else { excelWorksheet.Range["Q19"].Value = "X"; } } excelWorksheet.Range["S19"].Value = generales.DiasPuerperio; //Nacionalidad if (generales.Nacionalidad.Equals("M")) { excelWorksheet.Range["D21"].Value = "X"; } else { excelWorksheet.Range["F21"].Value = "X"; } excelWorksheet.Range["J21"].Value = generales.PaisOrigen; excelWorksheet.Range["R21"].Value = generales.NoExpedienteSeguridadSocial; excelWorksheet.Range["E23"].Value = generales.EntidadNacimiento; excelWorksheet.Range["O23"].Value = generales.EntidadDelegacionResidencia; excelWorksheet.Range["E25"].Value = generales.MunicipioResidencia; excelWorksheet.Range["M25"].Value = generales.Localidad; excelWorksheet.Range["E27"].Value = generales.Calle; excelWorksheet.Range["M27"].Value = generales.NoExterno; excelWorksheet.Range["R27"].Value = generales.NoInterno; excelWorksheet.Range["E29"].Value = generales.EntreCalles; excelWorksheet.Range["N29"].Value = generales.YCalle; excelWorksheet.Range["E31"].Value = generales.Colonia; excelWorksheet.Range["J31"].Value = generales.CP; excelWorksheet.Range["P31"].Value = generales.Telefono; //SeReconoceIndigena if (!generales.SeReconoceIndigena.Equals(null)) { if (generales.SeReconoceIndigena) { excelWorksheet.Range["F33"].Value = "X"; } else { excelWorksheet.Range["G33"].Value = "X"; } } //HablaAlgunaLenguaIndigena if (!generales.HablaAlgunaLenguaIndigena.Equals(null)) { if (generales.HablaAlgunaLenguaIndigena) { excelWorksheet.Range["N33"].Value = "X"; } else { excelWorksheet.Range["O33"].Value = "X"; } } excelWorksheet.Range["D36"].Value = generales.Ocupacion; //EsMigrante if (!generales.EsMigrante.Equals(null)) { if (generales.EsMigrante) { excelWorksheet.Range["N36"].Value = "X"; } else { excelWorksheet.Range["O36"].Value = "X"; } } ///ANTECEDENTES EPIDEMIOLÓGICOS if (!antecedentes.ViajoChina14dPrevInicioSintomas.Equals(null)) { if (antecedentes.ViajoChina14dPrevInicioSintomas) { excelWorksheet.Range["J39"].Value = "X"; } else { excelWorksheet.Range["K39"].Value = "X"; } } if (!antecedentes.ResidenteChina.Equals(null)) { if (antecedentes.ResidenteChina) { excelWorksheet.Range["R39"].Value = "X"; } else { excelWorksheet.Range["S39"].Value = "X"; } } excelWorksheet.Range["F43"].Value = antecedentes.FechaViajeChina; excelWorksheet.Range["M43"].Value = antecedentes.AerolineaVueloLlegadaMexico; excelWorksheet.Range["E46"].Value = antecedentes.FechaLlegadaMexico; if (!antecedentes.ContactoPersonaSintomasRespiratorios.Equals(null)) { if (antecedentes.ContactoPersonaSintomasRespiratorios.Equals("S")) { excelWorksheet.Range["I49"].Value = "X"; } else if (antecedentes.ContactoPersonaSintomasRespiratorios.Equals("N")) { excelWorksheet.Range["J49"].Value = "X"; } else { excelWorksheet.Range["K49"].Value = "X"; } } excelWorksheet.Range["G52"].Value = antecedentes.LugarContactoPersonas; if (!antecedentes.ContactoAnimales.Equals(null)) { if (antecedentes.ContactoAnimales) { excelWorksheet.Range["F55"].Value = "X"; } else { excelWorksheet.Range["G55"].Value = "X"; } } excelWorksheet.Range["J55"].Value = antecedentes.CualAnimal; //Validar marcado excelWorksheet.Range["C58"].Value = antecedentes.TipoContactoAnimal; if (!antecedentes.VisitoMercadoVentaAnimales.Equals(null)) { if (antecedentes.VisitoMercadoVentaAnimales) { excelWorksheet.Range["H60"].Value = "X"; } else { excelWorksheet.Range["I60"].Value = "X"; } } excelWorksheet.Range["K60"].Value = antecedentes.LugarMercadoVentaAnimales; excelWorksheet.Range["Q60"].Value = antecedentes.FechaVisitaMercado; if (!antecedentes.Ult14dContacCercanoPersSospCoV.Equals(null)) { if (antecedentes.Ult14dContacCercanoPersSospCoV) { excelWorksheet.Range["P71"].Value = "X"; } else { excelWorksheet.Range["R71"].Value = "X"; } } if (!antecedentes.Ult14dContacCercanoPersCorfiLabCoV.Equals(null)) { if (antecedentes.Ult14dContacCercanoPersCorfiLabCoV) { excelWorksheet.Range["P73"].Value = "X"; } else { excelWorksheet.Range["R73"].Value = "X"; } } if (!antecedentes.ContacPersViajChina14dPrevIniSintomas.Equals(null)) { if (antecedentes.ContacPersViajChina14dPrevIniSintomas) { excelWorksheet.Range["M76"].Value = "X"; } else { excelWorksheet.Range["N76"].Value = "X"; } } //VIAJES int numCeldaViaje = 65; foreach (Viaje viaje in viajes) { excelWorksheet.Range["F" + numCeldaViaje].Value = viaje.Pais; excelWorksheet.Range["H" + numCeldaViaje].Value = viaje.Ciudad; excelWorksheet.Range["K" + numCeldaViaje].Value = viaje.FechaLlegada; excelWorksheet.Range["O" + numCeldaViaje].Value = viaje.FechaSalida; excelWorksheet.Range["R" + numCeldaViaje].Value = viaje.AerolineaVuelo; numCeldaViaje++; } //DATOS CLINICOS excelWorksheet.Range["E81"].Value = clinicos.FechaInicioSintomas; writeBool(excelWorksheet, "D85", "E85", clinicos.Fiebre); writeBool(excelWorksheet, "D86", "E86", clinicos.Tos); writeBool(excelWorksheet, "D87", "E87", clinicos.DolorToracico); writeBool(excelWorksheet, "D88", "E88", clinicos.DificultadRespiratoria); writeBool(excelWorksheet, "K85", "L85", clinicos.Cefalea); writeBool(excelWorksheet, "K86", "L86", clinicos.Irritabilidad); writeBool(excelWorksheet, "K87", "L87", clinicos.Diarrea); writeBool(excelWorksheet, "K88", "L88", clinicos.Vomito); writeBool(excelWorksheet, "K89", "L89", clinicos.Calosfrios); writeBool(excelWorksheet, "K90", "L90", clinicos.DolorAbdominal); writeBool(excelWorksheet, "K91", "L91", clinicos.Mialgias); writeBool(excelWorksheet, "K92", "L92", clinicos.Artralgias); writeBool(excelWorksheet, "K93", "L93", clinicos.AtaqueAlEdoGral); writeBool(excelWorksheet, "K94", "L94", clinicos.Rinorrea); writeBool(excelWorksheet, "K95", "L95", clinicos.Polipnea); writeBool(excelWorksheet, "K96", "L96", clinicos.Odinofagia); writeBool(excelWorksheet, "K97", "L97", clinicos.Conjuntivitis); writeBool(excelWorksheet, "K98", "L98", clinicos.Cianosis); writeBool(excelWorksheet, "K99", "L99", clinicos.Convulsiones); excelWorksheet.Range["K100"].Value = clinicos.OtroSintoma; writeBool(excelWorksheet, "R83", "S83", clinicos.Diabetes); writeBool(excelWorksheet, "R84", "S84", clinicos.EPOC); writeBool(excelWorksheet, "R85", "S85", clinicos.Asma); writeBool(excelWorksheet, "R86", "S86", clinicos.Inmunosupresion); writeBool(excelWorksheet, "R87", "S87", clinicos.Hipertension); writeBool(excelWorksheet, "R88", "S88", clinicos.VihSida); writeBool(excelWorksheet, "R89", "S89", clinicos.EnfermedadCardio); writeBool(excelWorksheet, "R90", "S90", clinicos.Obesidad); writeBool(excelWorksheet, "R91", "S91", clinicos.InsuficienciaRenalCronica); writeBool(excelWorksheet, "R92", "S92", clinicos.InsuficienciaHepaticaCronica); writeBool(excelWorksheet, "R93", "S93", clinicos.Tabaquismo); excelWorksheet.Range["O94"].Value = clinicos.OtroCoMorbilidad; //DATOS DE LA UNIDAD MÉDICA excelWorksheet.Range["E104"].Value = unidadMedica.ServicioIngreso; if (unidadMedica.TipPaciente.Equals("A")) { excelWorksheet.Range["O104"].Value = "X"; } else if (unidadMedica.TipPaciente.Equals("H")) { excelWorksheet.Range["R104"].Value = "X"; } excelWorksheet.Range["F106"].Value = unidadMedica.FechaIngresoUnidad; writeBool(excelWorksheet, "P106", "R106", unidadMedica.CasoIngresadoUCI); writeBool(excelWorksheet, "P108", "R108", unidadMedica.CasoIntubado); writeBool(excelWorksheet, "R110", "S110", unidadMedica.CasoDiagnostNeumoniaClinica); writeBool(excelWorksheet, "R112", "S112", unidadMedica.CasoDiagnostNeumoniaRadiológica); //TRATAMIENTO if (!tratamiento.RecibioTrataAntipireticoAnalgesico.Equals(null)) { if (tratamiento.RecibioTrataAntipireticoAnalgesico.Equals("S")) { excelWorksheet.Range["K116"].Value = "X"; } else if (tratamiento.RecibioTrataAntipireticoAnalgesico.Equals("N")) { excelWorksheet.Range["L116"].Value = "X"; } else { excelWorksheet.Range["M116"].Value = "X"; } } excelWorksheet.Range["P118"].Value = tratamiento.FechaInicioTrataAntipireticoAnalgesico; excelWorksheet.Range["F121"].Value = tratamiento.Paracetamol ? "X" : ""; excelWorksheet.Range["F122"].Value = tratamiento.Ibuprofeno ? "X" : ""; excelWorksheet.Range["F123"].Value = tratamiento.AcidoAcetilsalicilico ? "X" : ""; excelWorksheet.Range["F124"].Value = tratamiento.ClonixinatoLisina ? "X" : ""; excelWorksheet.Range["K121"].Value = tratamiento.Naproxeno ? "X" : ""; excelWorksheet.Range["K122"].Value = tratamiento.Proxicam ? "X" : ""; excelWorksheet.Range["K123"].Value = tratamiento.MetamizolSodico ? "X" : ""; excelWorksheet.Range["Q121"].Value = tratamiento.Diclofenaco ? "X" : ""; excelWorksheet.Range["Q122"].Value = tratamiento.Ketorolaco ? "X" : ""; excelWorksheet.Range["Q123"].Value = tratamiento.OtroAntipireticoAnalgesico.Value ? "X" : ""; if (!tratamiento.RecibioTrataAntiviral.Equals(null)) { if (tratamiento.RecibioTrataAntiviral.Equals("S")) { excelWorksheet.Range["K126"].Value = "X"; } else if (tratamiento.RecibioTrataAntiviral.Equals("N")) { excelWorksheet.Range["L126"].Value = "X"; } else { excelWorksheet.Range["M126"].Value = "X"; } } excelWorksheet.Range["P128"].Value = tratamiento.FechaInicioTrataAntiviral; excelWorksheet.Range["F131"].Value = tratamiento.Amantadina ? "X" : ""; excelWorksheet.Range["F132"].Value = tratamiento.Rimantadina ? "X" : ""; excelWorksheet.Range["F133"].Value = tratamiento.Oseltamivir ? "X" : ""; excelWorksheet.Range["F133"].Value = tratamiento.Zanamivir ? "X" : ""; excelWorksheet.Range["J132"].Value = tratamiento.Peramivir ? "X" : ""; excelWorksheet.Range["O131"].Value = tratamiento.Ribavirina ? "X" : ""; excelWorksheet.Range["O132"].Value = tratamiento.OtroAntiviral; if (!tratamiento.RecibioTrataAntibiotico.Equals(null)) { if (tratamiento.RecibioTrataAntibiotico.Equals("S")) { excelWorksheet.Range["K135"].Value = "X"; } else if (tratamiento.RecibioTrataAntibiotico.Equals("N")) { excelWorksheet.Range["L135"].Value = "X"; } else { excelWorksheet.Range["M135"].Value = "X"; } } excelWorksheet.Range["P137"].Value = tratamiento.FechaInicioTrataAntibiotico; excelWorksheet.Range["F140"].Value = tratamiento.Penicilina ? "X" : ""; excelWorksheet.Range["F141"].Value = tratamiento.Dicloxacilina ? "X" : ""; excelWorksheet.Range["F142"].Value = tratamiento.Ampicilina ? "X" : ""; excelWorksheet.Range["F143"].Value = tratamiento.Amikacina ? "X" : ""; excelWorksheet.Range["F144"].Value = tratamiento.Doxiciclina ? "X" : ""; excelWorksheet.Range["F145"].Value = tratamiento.Cefalosporina ? "X" : ""; excelWorksheet.Range["J140"].Value = tratamiento.Clindamicina ? "X" : ""; excelWorksheet.Range["J141"].Value = tratamiento.Claritromicina ? "X" : ""; excelWorksheet.Range["J142"].Value = tratamiento.Ciprofloxacino ? "X" : ""; excelWorksheet.Range["J143"].Value = tratamiento.Meropenem ? "X" : ""; excelWorksheet.Range["J144"].Value = tratamiento.Vancomicina ? "X" : ""; excelWorksheet.Range["Q140"].Value = tratamiento.AmoxicilinaAcClauvulanico ? "X" : ""; excelWorksheet.Range["Q141"].Value = tratamiento.OtrosAntibioticos.Value ? "X" : ""; //LABORATORIO writeBool(excelWorksheet, "E149", "F149", laboratorio.SeTomoMuestraPaciente); excelWorksheet.Range["M149"].Value = laboratorio.LaboratorioDiagnostico; excelWorksheet.Range["G154"].Value = laboratorio.ExudadoFaringeo.Value ? "X" : ""; excelWorksheet.Range["G155"].Value = laboratorio.ExudadoNasofaringeo.Value ? "X" : ""; excelWorksheet.Range["N154"].Value = laboratorio.LavadoBronquial.Value ? "X" : ""; excelWorksheet.Range["N155"].Value = laboratorio.BiopsiaPulmon.Value ? "X" : ""; excelWorksheet.Range["E157"].Value = laboratorio.FechaTomaMuestra; excelWorksheet.Range["O157"].Value = laboratorio.FechaEnvioMuestra; excelWorksheet.Range["E159"].Value = laboratorio.FechaRecepcionMuestra; excelWorksheet.Range["L159"].Value = laboratorio.FechaResultado; excelWorksheet.Range["R159"].Value = laboratorio.Resultado; //EVOLUCIÓN if (!evolucion.Evolucion1.Equals(0)) { excelWorksheet.Range["D163"].Value = evolucion.Evolucion1; } excelWorksheet.Range["E165"].Value = evolucion.FechaEgreso; excelWorksheet.Range["E167"].Value = evolucion.FechaDefunción; excelWorksheet.Range["H169"].Value = evolucion.FolioCertificadoDefunción; writeBool(excelWorksheet, "O169", "P169", evolucion.Defuncion2019nCoV); //CONTACTOS int numCeldaContacto = 175; foreach (Contactos contacto in contactos) { excelWorksheet.Range["B" + numCeldaContacto].Value = contacto.NombreCompleto; if (contacto.Sexo.Equals("F")) { excelWorksheet.Range["F" + numCeldaContacto].Value = contacto.Sexo; } else if (contacto.Sexo.Equals("M")) { excelWorksheet.Range["G" + numCeldaContacto].Value = contacto.Sexo; } excelWorksheet.Range["H" + numCeldaContacto].Value = contacto.Edad; excelWorksheet.Range["I" + numCeldaContacto].Value = contacto.TipoContactoIDoED; excelWorksheet.Range["K" + numCeldaContacto].Value = contacto.CorreoElectronico; excelWorksheet.Range["M" + numCeldaContacto].Value = contacto.SignosSintomas; excelWorksheet.Range["R" + numCeldaContacto].Value = contacto.Observaciones; numCeldaContacto++; } excelWorksheet.PrintOutEx(Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); // excelWorkbook.SaveAs(@"C:\Temp\ecov1.xlsx"); excelWorkbook.SaveAs(destinoFile); excelApp.Quit(); DatosGenerales oTabla = null; using (EstudioEpidemiologicoEntities tablas = new EstudioEpidemiologicoEntities()) { oTabla = tablas.DatosGenerales.Find(dat.IdPersona); oTabla.FechaImpresion = DateTime.Now; tablas.Entry(oTabla).State = System.Data.Entity.EntityState.Modified; tablas.SaveChanges(); cargaDatos(); } } } catch (Exception theException) { String errorMessage; errorMessage = "Error: "; errorMessage = String.Concat(errorMessage, theException.Message); errorMessage = String.Concat(errorMessage, " Line: "); errorMessage = String.Concat(errorMessage, theException.Source); MessageBox.Show(errorMessage, "Error en llenado del formato", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { Cursor.Current = Cursors.Default; } void writeBool(Excel.Worksheet Hoja, string CeldaSi, string CeldaNo, bool?Valor) { if (Valor.Value) { Hoja.Range[CeldaSi].Value = "X"; } else { Hoja.Range[CeldaNo].Value = "X"; } } }
/// <summary> /// 标准烟罩打印JobCard /// </summary> /// <param name="tree"></param> public void ExecPrintHoodJobCard(ModuleTree tree) { JobCard objJobCard = new JobCardService().GetJobCard(tree); //核对信息 if (objJobCard.Length == 0) { MessageBox.Show("编号" + objJobCard.Item + "中" + objJobCard.Module + "烟罩数据没有填写,请认真检查", "信息核对"); return; } if (objJobCard.LabelImage.Length == 0) { MessageBox.Show("编号" + objJobCard.Item + "中" + objJobCard.Module + "JobCard标签截图没有上传,请回到模型树中双击Item上传截图,请认真检查", "信息核对"); return; } Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); string excelBookPath = Environment.CurrentDirectory + "\\JobCard.xlsx"; excelApp.Workbooks.Add(excelBookPath); Microsoft.Office.Interop.Excel.Worksheet workSheet = excelApp.Worksheets[1]; //插入Item图片 if (objJobCard.LabelImage.Length != 0) { Image image = (Image) new Common.SerializeObjectToString().DeserializeObject(objJobCard.LabelImage); string imagePath = Environment.CurrentDirectory + "\\LabelImage.jpg"; if (File.Exists(imagePath)) { File.Delete(imagePath); //删除图片 } else { //保存图片到系统目录中 image.Save(imagePath); //将图片插入excel workSheet.Shapes.AddPicture(imagePath, Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoTrue, 5, 157, 580, 225); //左,上,宽度,高度 workSheet.Shapes.AddPicture(imagePath, Microsoft.Office.Core.MsoTriState.msoFalse, Microsoft.Office.Core.MsoTriState.msoTrue, 5, 545, 580, 225); //左,上,宽度,高度 //使用完毕后删除保存的图片 File.Delete(imagePath); } } //通用信息 workSheet.Cells[48, 3] = objJobCard.ODPNo; workSheet.Cells[49, 3] = objJobCard.BPONo; workSheet.Cells[50, 3] = objJobCard.ProjectName; workSheet.Cells[51, 3] = objJobCard.CustomerName; workSheet.Cells[58, 7] = objJobCard.ShippingTime.ToShortDateString(); //标准烟罩 if (objJobCard.HoodType == "Hood") { workSheet.Cells[52, 3] = objJobCard.Item + "(" + objJobCard.Module + ")"; workSheet.Cells[53, 3] = objJobCard.Model; workSheet.Cells[65, 4] = objJobCard.Module; //长度 if (objJobCard.Model == "KVI" || objJobCard.Model == "KVF" || objJobCard.Model == "UVI" || objJobCard.Model == "UVF" || objJobCard.Model == "KWI" || objJobCard.Model == "KWF" || objJobCard.Model == "UWI" || objJobCard.Model == "UWF" || objJobCard.Model == "CMOD" || objJobCard.Model == "KVIM" || objJobCard.Model == "UVIM") { if (objJobCard.Length != 0 && objJobCard.SidePanel == "BOTH") { workSheet.Cells[65, 5] = objJobCard.Length + 100; } else if (objJobCard.SidePanel == "MIDDLE") { workSheet.Cells[65, 5] = objJobCard.Length; } else { workSheet.Cells[65, 5] = objJobCard.Length + 50; } } else { workSheet.Cells[65, 5] = objJobCard.Length; } workSheet.Cells[65, 6] = objJobCard.Deepth; workSheet.Cells[65, 7] = objJobCard.Height; workSheet.Cells[65, 8] = objJobCard.SidePanel; } //天花烟罩 else if (objJobCard.HoodType == "Ceiling") { workSheet.Cells[52, 3] = objJobCard.Item; workSheet.Cells[53, 3] = objJobCard.Model; workSheet.Cells[65, 4] = ""; workSheet.Cells[65, 5] = ""; workSheet.Cells[65, 6] = ""; workSheet.Cells[65, 7] = ""; workSheet.Cells[65, 8] = ""; } //UL烟罩 else { } //特殊要求 List <string> srList = new RequirementService().GetSpecialRequirementList(objJobCard.ODPNo); for (int i = 0; i < srList.Count; i++) { if (i > 6) { continue; } workSheet.Cells[68 + i * 2, 3] = srList[i]; } //预览 //excelApp.Visible = true; //excelApp.Sheets.PrintPreview(true); //打印 workSheet.PrintOutEx(); KillProcess(excelApp); excelApp = null; //对象置空 GC.Collect(); //垃圾回收机制 }
public void createMonthlyPS(List <Entities.SAAOModel> Monthly, string month) { ExApp = new Excel.Application(); ExApp.Visible = false; ExBook = ExApp.Workbooks.Open("C:\\Monthly.xlsx"); ExSheet = (Excel.Worksheet)ExBook.Sheets[4]; ////////PERSONAL SERVICES // Month, Year ExSheet.Cells[3, 1] = month + DateTime.Now.Year.ToString(); //PERSONAL SERVICES //50101010 ExSheet.Cells[12, 6] = Monthly[0].AB; ExSheet.Cells[12, 9] = Monthly[0].Amount; //50101020.1 ExSheet.Cells[14, 6] = Monthly[1].AB; ExSheet.Cells[14, 9] = Monthly[1].Amount; //50101020.2 ExSheet.Cells[15, 6] = Monthly[2].AB; ExSheet.Cells[15, 9] = Monthly[2].Amount; //50102010 ExSheet.Cells[16, 6] = Monthly[3].AB; ExSheet.Cells[16, 9] = Monthly[3].Amount; //50102020 ExSheet.Cells[17, 6] = Monthly[4].AB; ExSheet.Cells[17, 9] = Monthly[4].Amount; //50102030 ExSheet.Cells[18, 6] = Monthly[5].AB; ExSheet.Cells[18, 9] = Monthly[5].Amount; //50102040 ExSheet.Cells[19, 6] = Monthly[6].AB; ExSheet.Cells[19, 9] = Monthly[6].Amount; //50102050 ExSheet.Cells[21, 6] = Monthly[7].AB; ExSheet.Cells[21, 9] = Monthly[7].Amount; //50102060 ExSheet.Cells[22, 6] = Monthly[8].AB; ExSheet.Cells[22, 9] = Monthly[8].Amount; //50102100 ExSheet.Cells[20, 6] = Monthly[9].AB; ExSheet.Cells[20, 9] = Monthly[9].Amount; //50102110 ExSheet.Cells[23, 6] = Monthly[10].AB; ExSheet.Cells[23, 9] = Monthly[10].Amount; //50102120 ExSheet.Cells[24, 6] = Monthly[11].AB; ExSheet.Cells[24, 9] = Monthly[11].Amount; //50102130 ExSheet.Cells[25, 6] = Monthly[12].AB; ExSheet.Cells[25, 9] = Monthly[12].Amount; //50102140 ExSheet.Cells[27, 6] = Monthly[13].AB; ExSheet.Cells[27, 9] = Monthly[13].Amount; //50102150 ExSheet.Cells[26, 6] = Monthly[14].AB; ExSheet.Cells[26, 9] = Monthly[14].Amount; //50102990 ExSheet.Cells[28, 6] = Monthly[15].AB; ExSheet.Cells[28, 9] = Monthly[15].Amount; //50103010 ExSheet.Cells[29, 6] = Monthly[16].AB; ExSheet.Cells[29, 9] = Monthly[16].Amount; //50103020 ExSheet.Cells[30, 6] = Monthly[17].AB; ExSheet.Cells[30, 9] = Monthly[17].Amount; //50103030 ExSheet.Cells[31, 6] = Monthly[18].AB; ExSheet.Cells[31, 9] = Monthly[18].Amount; //50103040 ExSheet.Cells[32, 6] = Monthly[19].AB; ExSheet.Cells[32, 9] = Monthly[19].Amount; //50104030 ExSheet.Cells[33, 6] = Monthly[20].AB; ExSheet.Cells[33, 9] = Monthly[20].Amount; //50104990 ExSheet.Cells[34, 6] = Monthly[21].AB; ExSheet.Cells[34, 9] = Monthly[21].Amount; // Month ExSheet.Cells[7, 9] = month; try { ExSheet.SaveAs("DBMS\\Monthly\\PS\\" + month + "_REPORT_PS.xlsx"); } catch { } finally { if (MessageBox.Show("Do you want to continue to printing?", "Print?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { ExSheet.PrintOutEx(); } ExApp.Visible = true; ExSheet.PrintPreview(); ExBook.Close(); } }
public void CreateRAO(List <RAOModel> rao) { DateTimeFormatInfo dtPicker = new DateTimeFormatInfo(); string month = dtPicker.GetMonthName(DateTime.Today.Month); ExApp = new Excel.Application(); ExApp.Visible = false; ExBook = ExApp.Workbooks.Open("C:\\RAO.xls"); ExSheetCO = (Excel.Worksheet)ExBook.Sheets[4]; ExSheetFE = (Excel.Worksheet)ExBook.Sheets[3]; ExSheetMOOE = (Excel.Worksheet)ExBook.Sheets[2]; ExSheetPS = (Excel.Worksheet)ExBook.Sheets[1]; int row = 14; // Personal Services foreach (var i in rao) { i.Particulars = i.Particulars.FindAll(l => l.ClassId == 10); if (i.Particulars.Count > 0) { ExSheetPS.Cells[row, 1] = i.BURFDate; ExSheetPS.Cells[row, 2] = i.BURNumber; } else { continue; } for (int x = 0; x < i.Particulars.Count; x++) { var j = i.Particulars[x]; switch (j.AccountCode) { case "50101010": ExSheetPS.Cells[row, 7] = j.Amount; break; case "50101020.1": ExSheetPS.Cells[row, 9] = j.Amount; break; case "50101020.2": ExSheetPS.Cells[row, 10] = j.Amount; break; case "50102010": ExSheetPS.Cells[row, 13] = j.Amount; break; case "50102020": ExSheetPS.Cells[row, 15] = j.Amount; break; case "50102030": ExSheetPS.Cells[row, 17] = j.Amount; break; case "50102040": ExSheetPS.Cells[row, 19] = j.Amount; break; case "50102050": ExSheetPS.Cells[row, 21] = j.Amount; break; case "50102060": ExSheetPS.Cells[row, 22] = j.Amount; break; case "50102100": ExSheetPS.Cells[row, 24] = j.Amount; break; case "50102110": ExSheetPS.Cells[row, 26] = j.Amount; break; case "50102120": ExSheetPS.Cells[row, 28] = j.Amount; break; case "50102130": ExSheetPS.Cells[row, 30] = j.Amount; break; case "50102140": ExSheetPS.Cells[row, 32] = j.Amount; break; case "50102150": ExSheetPS.Cells[row, 34] = j.Amount; break; case "50102990": ExSheetPS.Cells[row, 36] = j.Amount; break; case "50103010": ExSheetPS.Cells[row, 38] = j.Amount; break; case "50103020": ExSheetPS.Cells[row, 40] = j.Amount; break; case "50103030": ExSheetPS.Cells[row, 42] = j.Amount; break; case "50103040": ExSheetPS.Cells[row, 43] = j.Amount; break; case "50104030": ExSheetPS.Cells[row, 44] = j.Amount; break; case "50104990": ExSheetPS.Cells[row, 46] = j.Amount; break; } } row++; } // MOOE foreach (var i in rao) { i.Particulars = i.Particulars.FindAll(l => l.ClassId == 11); if (i.Particulars.Count > 0) { ExSheetMOOE.Cells[row, 1] = i.BURFDate; ExSheetMOOE.Cells[row, 2] = i.BURNumber; } else { continue; } for (int x = 0; x < i.Particulars.Count; x++) { var j = i.Particulars[x]; switch (j.AccountCode) { case "50201010": ExSheetMOOE.Cells[row, 6] = j.Amount; break; case "50201020": ExSheetMOOE.Cells[row, 8] = j.Amount; break; case "50202010": ExSheetMOOE.Cells[row, 10] = j.Amount; break; case "50203010": ExSheetMOOE.Cells[row, 12] = j.Amount; break; case "50203020": ExSheetMOOE.Cells[row, 14] = j.Amount; break; case "50203070": ExSheetMOOE.Cells[row, 16] = j.Amount; break; case "50203080": ExSheetMOOE.Cells[row, 17] = j.Amount; break; case "50203090": ExSheetMOOE.Cells[row, 19] = j.Amount; break; case "50203990": ExSheetMOOE.Cells[row, 21] = j.Amount; break; case "50204010": ExSheetMOOE.Cells[row, 23] = j.Amount; break; case "50204020": ExSheetMOOE.Cells[row, 25] = j.Amount; break; case "50205010": ExSheetMOOE.Cells[row, 27] = j.Amount; break; case "50205020.1": ExSheetMOOE.Cells[row, 29] = j.Amount; break; case "50205020.2": ExSheetMOOE.Cells[row, 30] = j.Amount; break; case "50205030": ExSheetMOOE.Cells[row, 31] = j.Amount; break; case "50210030": ExSheetMOOE.Cells[row, 32] = j.Amount; break; case "50211030": ExSheetMOOE.Cells[row, 34] = j.Amount; break; case "50211990": ExSheetMOOE.Cells[row, 36] = j.Amount; break; case "50212020": ExSheetMOOE.Cells[row, 37] = j.Amount; break; case "50212030": ExSheetMOOE.Cells[row, 39] = j.Amount; break; case "50213040": ExSheetMOOE.Cells[row, 41] = j.Amount; break; case "50213050.1": ExSheetMOOE.Cells[row, 42] = j.Amount; break; case "50213060": ExSheetMOOE.Cells[row, 43] = j.Amount; break; case "50213070": ExSheetMOOE.Cells[row, 44] = j.Amount; break; case "50216020": ExSheetMOOE.Cells[row, 46] = j.Amount; break; case "50216030": ExSheetMOOE.Cells[row, 47] = j.Amount; break; case "50299010": ExSheetMOOE.Cells[row, 49] = j.Amount; break; case "50299020": ExSheetMOOE.Cells[row, 51] = j.Amount; break; case "50299030": ExSheetMOOE.Cells[row, 53] = j.Amount; break; case "50299050": ExSheetMOOE.Cells[row, 54] = j.Amount; break; case "50299060": ExSheetMOOE.Cells[row, 55] = j.Amount; break; case "50299070": ExSheetMOOE.Cells[row, 56] = j.Amount; break; case "50299990": ExSheetMOOE.Cells[row, 59] = j.Amount; break; case "50213050.2": ExSheetMOOE.Cells[row, 42] = j.Amount; break; case "50213050.3": ExSheetMOOE.Cells[row, 42] = j.Amount; break; case "50213050.4": ExSheetMOOE.Cells[row, 42] = j.Amount; break; case "50213050.5": ExSheetMOOE.Cells[row, 42] = j.Amount; break; case "50213050.6": ExSheetMOOE.Cells[row, 42] = j.Amount; break; case "50213050.7": ExSheetMOOE.Cells[row, 42] = j.Amount; break; } } row++; } // Financial Expenses for (int x = 14; x < rao.Count; x++) { foreach (var i in rao) { i.Particulars = i.Particulars.FindAll(l => l.ClassId == 10); foreach (var j in i.Particulars) { switch (j.AccountCode) { case "50301040": ExSheetFE.Cells[x, 6] = j.Amount; break; } } } } foreach (var i in rao) { i.Particulars = i.Particulars.FindAll(l => l.ClassId == 10); foreach (var j in i.Particulars) { for (int x = 14; x < rao.Count; x++) { switch (j.AccountCode) { case "10704020": ExSheetCO.Cells[x, 8] = j.Amount; break; case "10705020": ExSheetCO.Cells[x, 10] = j.Amount; break; case "10705030": ExSheetCO.Cells[x, 11] = j.Amount; break; case "10705070": ExSheetCO.Cells[x, 13] = j.Amount; break; case "10705110": ExSheetCO.Cells[x, 14] = j.Amount; break; case "10705130": ExSheetCO.Cells[x, 16] = j.Amount; break; case "10705140": ExSheetCO.Cells[x, 17] = j.Amount; break; case "10705990": ExSheetCO.Cells[x, 18] = j.Amount; break; case "10707010": ExSheetCO.Cells[x, 19] = j.Amount; break; case "10707020": ExSheetCO.Cells[x, 20] = j.Amount; break; } } } } try { ExSheet.SaveAs("DBMS\\RAO\\" + month + "_REPORT_PS.xlsx"); } catch { } finally { if (MessageBox.Show("Do you want to continue to printing?", "Print?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { ExSheet.PrintOutEx(); } ExApp.Visible = true; } }
public void createBURExcel(Entities.BURModel SentBUR) { Entities.BURModel BUR = SentBUR; ExApp = new Excel.Application(); ExApp.Visible = false; ExBook = ExApp.Workbooks.Open("C:\\BUR.xls"); ExSheet = (Excel.Worksheet)ExBook.Sheets[2]; int lastRow = 20; decimal total = 0.00M; ExSheet.Cells[6, 7] = BUR.BURNumber; ExSheet.Cells[7, 2] = BUR.Payee; if (BUR.Office != "External") { ExSheet.Cells[8, 2] = BUR.Office; } ExSheet.Cells[12, 2] = BUR.Description + "\n" + "PR Number: " + BUR.PRNumber; foreach (var item in BUR.Particulars) { ExSheet.Cells[lastRow, 2] = item.Name; ExSheet.Cells[lastRow, 6] = item.Classification; //item.Code = item.Code.Insert(1, "-"); //item.Code = item.Code.Insert(4, "-"); //item.Code = item.Code.Insert(7, "-"); ExSheet.Cells[lastRow, 7] = item.Code; ExSheet.Cells[lastRow, 8] = item.Amount.ToString("C2"); total += item.Amount; lastRow++; } ExSheet.Cells[34, 8] = total; if (BUR.Office == "External") { ExSheet.Cells[41, 2] = BUR.OfficeheadName; ExSheet.Cells[42, 2] = BUR.OfficeheadPos; } else { ExSheet.Cells[41, 2] = BUR.OfficeheadName; ExSheet.Cells[42, 2] = BUR.OfficeheadPos; } ExSheet.Cells[44, 2] = DateTime.Now; ExSheet.Cells[41, 7] = BUR.BDHead; ExSheet.Cells[42, 7] = BUR.BDHead_Pos; ExSheet.Cells[44, 7] = DateTime.Now; ExBook.SaveAs("DBMS\\BUR\\BUR_" + BUR.BURNumber + ".xls"); if (MessageBox.Show("Do you want to continue to printing?", "Print?", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { ExSheet.PrintOutEx(); } ExApp.Visible = true; ExSheet.PrintPreview(); ExBook.Close(); }
public void PrintWorksheetAndCloseWorkbook(ref Excel.Worksheet ws, ref Excel.Workbook wb) { ws.PrintOutEx(); CloseWorkbook(ref ws, ref wb); }