/// <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);
}
