public bool CreateTemplateTechProcess001(DrawingsDTO drawingsDTO) { //try //{ // Factory.GetWorkbook(GeneratedReportsDir + @"\template001.xlsx"); //} //catch (Exception ex) //{ // MessageBox.Show("не найдено шаблон документа!\n" + ex.Message, "Увага", MessageBoxButtons.OK, MessageBoxIcon.Warning); // return false; //} //var Workbook = Factory.GetWorkbook(GeneratedReportsDir + @"\template001.xlsx"); //var Worksheet = Workbook.Worksheets[0]; //var Сells = Worksheet.Cells; //IRange cells = Worksheet.Cells; //Сells["A" + 39].Value = drawingsDTO.ParentName; //Сells["A" + 39].HorizontalAlignment = HAlign.Center; //Сells["W" + 48].Value = drawingsDTO.DetailWeight; //Сells["W" + 48].HorizontalAlignment = HAlign.Center; //Сells["BI" + 48].Value = drawingsDTO.TH.ToString() + "х" + drawingsDTO.W.ToString() + "х" + drawingsDTO.L.ToString(); //Сells["BI" + 48].HorizontalAlignment = HAlign.Center; //Сells["CD" + 48].Value = drawingsDTO.Quantity; //Сells["CD" + 48].HorizontalAlignment = HAlign.Center; //Сells["BB" + 7].Value = drawingsDTO.Number; //Сells["BB" + 7].HorizontalAlignment = HAlign.Center; //Сells["BB" + 41].Value = drawingsDTO.Number; //Сells["BB" + 41].HorizontalAlignment = HAlign.Center; //Сells["BS" + 75].Value = drawingsDTO.Number; //Сells["BS" + 75].HorizontalAlignment = HAlign.Center; //Сells["BS" + 106].Value = drawingsDTO.Number; //Сells["BS" + 106].HorizontalAlignment = HAlign.Center; //Сells["CO" + 07].Value = TechProcesNameToStr(drawingsDTO.TechProcess001Name); //Сells["CO" + 07].HorizontalAlignment = HAlign.Center; //Сells["CO" + 41].Value = TechProcesNameToStr(drawingsDTO.TechProcess001Name); //Сells["CO" + 41].HorizontalAlignment = HAlign.Center; //Сells["CO" + 75].Value = TechProcesNameToStr(drawingsDTO.TechProcess001Name); //Сells["CO" + 75].HorizontalAlignment = HAlign.Center; //Сells["CO" + 106].Value = TechProcesNameToStr(drawingsDTO.TechProcess001Name); //Сells["CO" + 106].HorizontalAlignment = HAlign.Center; //try //{ // string fileName = String.Format("Зведена обігово-сальдова по рахунку 313 за період"); // //string fileName = String.Format("Зведена обігово-сальдова по рахунку 313 за період з {0} по {1}", startDate.ToShortDateString(), endDate.ToShortDateString()); // //Workbook.SaveAs(DbExelDir + techProcess001DTO.TechProcessName.ToString() + ".xls", FileFormat.Excel8); // Workbook.SaveAs(drawingsDTO.TechProcess001Path, FileFormat.Excel8); // Process process = new Process(); // process.StartInfo.Arguments = "\"" + drawingsDTO.TechProcess001Path + "\""; // process.StartInfo.FileName = "Excel.exe"; // process.Start(); //} //catch (System.IO.IOException) { MessageBox.Show("Документ уже открыто!", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Warning); } //catch (System.ComponentModel.Win32Exception) { MessageBox.Show("На рабочей станции отсутсутствует пакет программ Microsoft Oficce!", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Warning); } return(true); }
public bool UpdateTemplateTechProcess002(DrawingsDTO drawingsDTO) { var Workbook = Factory.GetWorkbook(drawingsDTO.TechProcess002Path); var Worksheet = Workbook.Worksheets[0]; var Сells = Worksheet.Cells; IRange cells = Worksheet.Cells; Сells["A" + 39].Value = drawingsDTO.ParentName; Сells["A" + 39].HorizontalAlignment = HAlign.Center; Сells["W" + 48].Value = drawingsDTO.DetailWeight; Сells["W" + 48].HorizontalAlignment = HAlign.Center; Сells["BI" + 48].Value = drawingsDTO.TH.ToString() + "х" + drawingsDTO.W.ToString() + "х" + drawingsDTO.L.ToString(); Сells["BI" + 48].HorizontalAlignment = HAlign.Center; Сells["CD" + 48].Value = drawingsDTO.Quantity; Сells["CD" + 48].HorizontalAlignment = HAlign.Center; Сells["BB" + 7].Value = drawingsDTO.Number; Сells["BB" + 7].HorizontalAlignment = HAlign.Center; Сells["BB" + 41].Value = drawingsDTO.Number; Сells["BB" + 41].HorizontalAlignment = HAlign.Center; Сells["BS" + 75].Value = drawingsDTO.Number; Сells["BS" + 75].HorizontalAlignment = HAlign.Center; Сells["BS" + 106].Value = drawingsDTO.Number; Сells["BS" + 106].HorizontalAlignment = HAlign.Center; Сells["CO" + 07].Value = TechProcesNameToStr(drawingsDTO.TechProcess002Name); Сells["CO" + 07].HorizontalAlignment = HAlign.Center; Сells["CO" + 41].Value = TechProcesNameToStr(drawingsDTO.TechProcess002Name); Сells["CO" + 41].HorizontalAlignment = HAlign.Center; Сells["CO" + 75].Value = TechProcesNameToStr(drawingsDTO.TechProcess002Name); Сells["CO" + 75].HorizontalAlignment = HAlign.Center; Сells["CO" + 106].Value = TechProcesNameToStr(drawingsDTO.TechProcess002Name); Сells["CO" + 106].HorizontalAlignment = HAlign.Center; //BB7, BB41 = Назв чертежа //BS75 = Назва чертежа (цыкл) //CO7,CO41 = Номер техпроцесса(цыкл +45) //W48 = вес //BI48 = размеры //A39 = размеры try { //string fileName = String.Format("Зведена обігово-сальдова по рахунку 313 за період"); //string fileName = String.Format("Зведена обігово-сальдова по рахунку 313 за період з {0} по {1}", startDate.ToShortDateString(), endDate.ToShortDateString()); //Workbook.SaveAs(DbExelDir + techProcess001DTO.TechProcessName.ToString() + ".xls", FileFormat.Excel8); Workbook.Save(); //Workbook.SaveAs(techProcess001DTO.TechProcessPath, FileFormat.Excel8); //Process process = new Process(); //process.StartInfo.Arguments = "\"" + techProcess001DTO.TechProcessPath + "\""; //process.StartInfo.FileName = "Excel.exe"; //process.Start(); } catch (System.IO.IOException) { MessageBox.Show("Документ уже открыто!", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Warning); } catch (System.ComponentModel.Win32Exception) { MessageBox.Show("На рабочей станции отсутсутствует пакет программ Microsoft Oficce!", "Внимание", MessageBoxButtons.OK, MessageBoxIcon.Warning); } return(true); }
public void DrawingUpdate(DrawingsDTO drawingsDTO) { var updateDrawings = drawings.GetAll().SingleOrDefault(c => c.Id == drawingsDTO.Id); drawings.Update((mapper.Map <DrawingsDTO, Drawings>(drawingsDTO, updateDrawings))); }
public int DrawingCreate(DrawingsDTO drawingsDTO) { var createDrawings = drawings.Create(mapper.Map <Drawings>(drawingsDTO)); return((int)createDrawings.Id); }