Beispiel #1
0
 public void Dispose()
 {
     Marshal.FinalReleaseComObject(this.Worksheet);
 }
Beispiel #2
0
        internal ConnectionPointCookie(object source, object sink, Type eventInterface)
        {
            Exception ex = null;

            if (source is UnsafeNativeMethods.IConnectionPointContainer)
            {
                UnsafeNativeMethods.IConnectionPointContainer cpc = (UnsafeNativeMethods.IConnectionPointContainer)source;

                try
                {
                    Guid tmp = eventInterface.GUID;
                    if (cpc.FindConnectionPoint(ref tmp, out connectionPoint) != NativeMethods.S_OK)
                    {
                        connectionPoint = null;
                    }
                }
                catch (Exception e)
                {
                    if (CriticalExceptions.IsCriticalException(e))
                    {
                        throw;
                    }

                    connectionPoint = null;
                }

                if (connectionPoint == null)
                {
                    ex = new ArgumentException(SR.Get(SRID.AxNoEventInterface, eventInterface.Name));
                }
                // IsComObject(sink): this is the case of a managed sink object wrapped in IDispatchSTAForwarder -
                // see WebBrowser.CreateSink().
                else if (sink == null || !eventInterface.IsInstanceOfType(sink) && !Marshal.IsComObject(sink))
                {
                    ex = new InvalidCastException(SR.Get(SRID.AxNoSinkImplementation, eventInterface.Name));
                }
                else
                {
                    int hr = connectionPoint.Advise(sink, ref cookie);
                    if (hr != NativeMethods.S_OK)
                    {
                        cookie = 0;
                        Marshal.FinalReleaseComObject(connectionPoint);
                        connectionPoint = null;
                        ex = new InvalidOperationException(SR.Get(SRID.AxNoSinkAdvise, eventInterface.Name, hr));
                    }
                }
            }
            else
            {
                ex = new InvalidCastException(SR.Get(SRID.AxNoConnectionPointContainer));
            }


            if (connectionPoint == null || cookie == 0)
            {
                if (connectionPoint != null)
                {
                    Marshal.FinalReleaseComObject(connectionPoint);
                }

                if (ex == null)
                {
                    throw new ArgumentException(SR.Get(SRID.AxNoConnectionPoint, eventInterface.Name));
                }
                else
                {
                    throw ex;
                }
            }
        }
Beispiel #3
0
        private void button2_Click(object sender, EventArgs e)
        {
            Excel.Application app;
            Excel.Worksheet   wsh;
            Excel.Workbook    book;

            app  = new Excel.Application();
            book = app.Workbooks.Add();

            wsh      = (Excel.Worksheet)book.Worksheets.get_Item(1);
            wsh.Name = "Menu";
            DataTable dt_menu     = main.db.getDb("menu");
            DataTable dt_menufood = main.db.getDb("menufood");

            DataColumn[] key = { dt_menu.Columns["menuid"] };
            dt_menu.PrimaryKey = key;
            foreach (DataRow a in dt_menu.Rows)
            {
                a.SetField("isShow", "N");
            }
            for (int i = 0; i < numofrow; i++)
            {
                Label lab = (Label)tableLayoutPanel1.GetControlFromPosition(0, i);
                dt_menu.Rows.Find(lab.Tag).SetField("isShow", "Y");
                for (int k = 0; k < dt_menufood.Rows.Count; k++)
                {
                    if (dt_menufood.Rows[k]["menuid"].ToString().Equals(lab.Tag.ToString()))
                    {
                        dt_menufood.Rows[k].Delete();
                        dt_menufood.AcceptChanges();
                        k--;
                    }
                }
                Label    lab2  = (Label)tableLayoutPanel1.GetControlFromPosition(1, i);
                String[] split = { " " };
                String[] temp  = lab2.Tag.ToString().Split(split, StringSplitOptions.RemoveEmptyEntries);
                foreach (String a in temp)
                {
                    DataRow row = dt_menufood.NewRow();
                    row["menuid"]  = lab.Tag;
                    row["ftypeid"] = a;
                    row["many"]    = 1;
                    dt_menufood.Rows.Add(row);
                }
            }
            genXMLData(dt_menu, wsh);

            wsh      = (Excel.Worksheet)book.Worksheets.Add();
            wsh.Name = "MenuFood";



            genXMLData(dt_menufood, wsh);

            String s       = SaveFilePath();
            String appPath = System.IO.Path.GetDirectoryName(Application.ExecutablePath);

            for (int i = 1; i < book.Worksheets.Count + 1; i++)
            {
                Excel.Worksheet wsh1;
                wsh1 = (Excel.Worksheet)book.Worksheets.get_Item(i);
                wsh1.Columns.AutoFit();
                Marshal.FinalReleaseComObject(wsh1);
            }
            book.SaveAs(appPath + "\\menu\\" + s + "\\" + fileName);
            if (wsh != null)
            {
                Marshal.FinalReleaseComObject(wsh);
            }
            if (book != null)
            {
                book.Close(false); //忽略尚未存檔內容,避免跳出提示卡住
                Marshal.FinalReleaseComObject(book);
            }
            if (app != null)
            {
                app.Workbooks.Close();
                app.Quit();
                Marshal.FinalReleaseComObject(app);
            }
            MessageBox.Show("Save");
        }
Beispiel #4
0
 public static void ReleaseCom(Object ComObject)
 {
     Marshal.FinalReleaseComObject(ComObject);
 }
Beispiel #5
0
        protected override bool Internal_ExcelCancel_Parsing(string filepath)
        {
            try
            {
                Microsoft.Office.Interop.Excel.Application ap = null;
                Workbook  wb = null;
                Worksheet ws = null;
                HKExcelHelper.GetWorkSheet(filepath, ref ap, ref wb, ref ws);

                Range tRange            = null;
                Int32 nCurrentRow       = 2;
                Int32 CouponColumn      = 2;
                Int32 CancelCountColumn = 18;
                Int32 StateColumn       = 22;

                while (true)
                {
                    try
                    {
                        tRange = ws.Cells[nCurrentRow, CouponColumn];
                        if (tRange == null)
                        {
                            break;
                        }

                        CCancelData pCCancelData = new CCancelData();
                        pCCancelData.channelOrderCode_ = Convert.ToString(tRange.Value2);

                        if (string.IsNullOrEmpty(pCCancelData.channelOrderCode_) == true)
                        {
                            break;
                        }

                        // 혹시 중복해서 엑셀파일을 다운로드 받았다면 중복이 있을수 있다. 이건 그냥 지나쳐야 한다.
                        if (Excel_Cancel_List_.ContainsKey(pCCancelData.channelOrderCode_) == true)
                        {
                            break;
                        }

                        tRange = ws.Cells[nCurrentRow, CancelCountColumn];
                        pCCancelData.CancelCount_ = Convert.ToInt32(tRange.Value2);

                        tRange = ws.Cells[nCurrentRow, StateColumn];
                        pCCancelData.State_ = Convert.ToString(tRange.Value2);


                        for (Int32 i = 1; i <= pCCancelData.CancelCount_; i++)
                        {
                            CCancelData tempExcelData = new CCancelData();
                            tempExcelData.channelOrderCode_ = string.Format("{0}_{1}", pCCancelData.channelOrderCode_, i);
                            tempExcelData.State_            = pCCancelData.State_;
                            tempExcelData.CancelCount_      = 1;
                            Excel_Cancel_List_.Add(tempExcelData.channelOrderCode_, tempExcelData);
                        }
                    }
                    catch (System.Exception ex)
                    {
                        NewLogManager2.Instance.Log(string.Format("Internal_ExcelCancel_Parsing 엑셀 파싱 에러 : {0}/{1}", filepath, ex.Message));
                        nCurrentRow++;
                        continue;
                    }

                    nCurrentRow++;
                }


                wb.Close(false, Type.Missing, Type.Missing);
                ap.Quit();

                Marshal.FinalReleaseComObject(ws);
                Marshal.FinalReleaseComObject(wb);
                Marshal.FinalReleaseComObject(ap);
                ws = null;
                wb = null;
                ap = null;
                GC.Collect();
            }
            catch (System.Exception ex)
            {
                NewLogManager2.Instance.Log(string.Format("Error public override bool Internal_ExcelCancel_Parsing - {0}", ex.Message));
                return(false);
            }

            return(true);
        }
 public void FinalReleaseComObject_NonComObject_ThrowsArgumentException()
 {
     AssertExtensions.Throws <ArgumentException>("o", () => Marshal.FinalReleaseComObject(10));
 }
        private async void ReadAndJoinExcells()
        {
            int  startingRowIndex = 1;
            bool isFirst          = true;
            int  FileSizeIndex    = 0;
            int  maxfileSize      = excellFilePaths.Count;

            Application application         = null;
            Workbooks   wbooks              = null;
            Worksheet   destinationSheet    = null;
            Workbook    destinationWorkbook = null;

            try
            {
                WriteConsole("Kopyalama Başlıyor...");
                await Task.Run(() =>
                {
                    //Instantiate the application object
                    application             = new Application();
                    application.CutCopyMode = (Microsoft.Office.Interop.Excel.XlCutCopyMode) 0;
                    wbooks          = application.Workbooks;
                    object misValue = System.Reflection.Missing.Value;

                    destinationWorkbook = wbooks.Add(misValue);
                    destinationSheet    = (Worksheet)destinationWorkbook.Worksheets.get_Item(1);
                    //Copy Excel worksheet from source workbook to the destination workbook
                });

                foreach (var item in excellFilePaths)
                {
                    FileSizeIndex++;
                    WriteConsole($" {FileSizeIndex}/{maxfileSize} {item.FileName} Kopyalanıyor...");
                    await Task.Run(() =>
                    {
                        Workbook sourceWorkbook = wbooks.Open(item.Path);
                        Worksheet wsheet        = (Worksheet)sourceWorkbook.Worksheets.get_Item(1);
                        if (isFirst)
                        {
                            startingRowIndex = 1;
                        }
                        else
                        {
                            startingRowIndex = 2;
                        }
                        var usedRange = wsheet.UsedRange;
                        usedRange.Cells[1, 1].Copy();
                        usedRange.Range[usedRange[startingRowIndex, 1], usedRange[usedRange.Rows.Count, usedRange.Columns.Count]].Copy();
                        if (isFirst)
                        {
                            destinationSheet.Paste(destinationSheet.UsedRange.Cells[1, 1]);
                            isFirst = false;
                        }
                        else
                        {
                            destinationSheet.Paste(destinationSheet.UsedRange.Cells[destinationSheet.UsedRange.Rows.Count + 1, 1]);
                        }
                        sourceWorkbook?.Close();
                        Marshal.ReleaseComObject(sourceWorkbook);
                    });
                }

                WriteConsole("Çıktı oluşturuluyor...");
                //Save the file

                await Task.Run(() =>
                {
                    destinationWorkbook.SaveAs(outFile.Path, AccessMode: XlSaveAsAccessMode.xlShared);
                });
            }
            catch
            {
            }
            finally
            {
                WriteConsole("Çıktın Hazır :) Güle güle kullan...");
                try
                {
                    destinationWorkbook?.Close();
                    Marshal.ReleaseComObject(destinationWorkbook);
                    wbooks?.Close();
                    Marshal.ReleaseComObject(wbooks);
                    application?.Quit();
                    Marshal.FinalReleaseComObject(application);
                }
                catch (Exception) { }
                application = null;
            }
        }
Beispiel #8
0
        public void convertPDFToWord(frmMain mainApp, string inFile, string outFile)
        {
            // Initialise MS Word variables
            Word.Application oWord = null;
            Word.Documents   oDocs = null;
            Word.Document    oDoc  = null;

            // Try to run word and open document
            try {
                // Start Word
                mainApp.statusUpdate2("(Starting Word)");
                oWord               = new Word.Application();
                oWord.Visible       = false;
                oWord.DisplayAlerts = Word.WdAlertLevel.wdAlertsNone;
                if (oWord == null)
                {
                    MessageBox.Show("Word could not be started. Please check that it is installed correctly and allows automation.");
                    Debug.WriteLine("Word could not be started. Check that compiled app reference matches Office version installed.");
                    return;
                }
                else
                {
                    Debug.WriteLine("Word.Application is started");
                }
                mainApp.pbUpdate(20, frmMain.pbModeIncrement);

                /*
                 * Check MS Word interop version (Interop version is not always the only installed version, but close enough)
                 * Incompatible:
                 * Office 2003: 11.0
                 * Office 2007: 12.0
                 * Office 2010: 14.0
                 * Native PDF conversion available starting from:
                 * Office 2013: 15.0
                 * Office 2016: 16.0
                 * */
                mainApp.statusUpdate2("(Checking Word Compatibility)");
                string msWordVersion = oWord.Application.Version;
                Debug.WriteLine("MS Word Version: " + msWordVersion);
                if (Convert.ToDouble(msWordVersion) > 14)
                {
                    Debug.WriteLine("MS Word Version is newer than 2013. Native PDF conversion available.");
                }
                else
                {
                    MessageBox.Show("It appears that the installed version of Microsoft Word does not support native PDF conversion. Word 2013 or greater is required.");
                }

                // Call subroutine to check/set registry value for MS Word silent PDF conversion
                // TODO: Test before uncommenting for production
                this.setWordPDFConversionSilent(msWordVersion);
                mainApp.pbUpdate(20, frmMain.pbModeIncrement);

                // Open Word document
                mainApp.statusUpdate2("(Opening PDF and converting to Word)");
                oDoc = oWord.Documents.Open(inFile, false, true);
                Debug.WriteLine("Word.Document is opened");
                mainApp.pbUpdate(20, frmMain.pbModeIncrement);

                // PDF automatic converts to Word format on open
                // We can now save the document
                mainApp.statusUpdate2("(Saving as Word document)");
                oDoc.SaveAs2(outFile, Word.WdSaveFormat.wdFormatDocumentDefault);
                mainApp.pbUpdate(20, frmMain.pbModeIncrement);

                // Clean up and close apps
                // TODO: Need to test if this also closes user's other windows!!!
                mainApp.statusUpdate2("(Closing Word)");
                Debug.WriteLine("Cleaning up...");
                mainApp.pbUpdate(20, frmMain.pbModeIncrement);
                oDoc.Close(false, Type.Missing, Type.Missing);
                //oWord.Documents.Close(false, Type.Missing, Type.Missing);
                oWord.Quit(false, Type.Missing, Type.Missing);
            }
            catch (Exception ex) {
                Debug.WriteLine("Error:{0}", ex.Message);
            }
            finally {
                // Clean up the unmanaged Word/Excel COM resources by explicitly calling Marshal.FinalReleaseComObject on all accessor objects.
                if (oDoc != null)
                {
                    Marshal.FinalReleaseComObject(oDoc);
                    oDoc = null;
                }
                if (oDocs != null)
                {
                    Marshal.FinalReleaseComObject(oDocs);
                    oDocs = null;
                }
                if (oWord != null)
                {
                    Marshal.FinalReleaseComObject(oWord);
                    oWord = null;
                }
            }
        }
Beispiel #9
0
        /// <summary>
        /// Send Mail
        /// </summary>
        /// <returns></returns>
        public NotifyComResponse Send()
        {
            NotifyComResponse notifyComResponse = new NotifyComResponse();

            try
            {
                try
                {
                    MailAddress ma = new MailAddress(_fromAddress);
                }
                catch (FormatException ex)
                {
                    // invalid from mail address, set it to [email protected]
                    LogBook.Write("The format for the from email address (" + _fromAddress + ") is incorrect. [email protected] will be used instead.");
                    _fromAddress = "*****@*****.**";
                }

                SmtpClient ss = new SmtpClient(_smtpServer, _smtpPort);


                MailMessage mm = new MailMessage(_fromAddress, _toAddress, _subject, _body);

                CDO.Message message = new CDO.Message();
                /*Create Mail Message Object*/
                MailMessage mailObj = new MailMessage();
                /*Email from address*/
                mailObj.From = new MailAddress(_fromAddress, _fromName);
                /*Email to address*/
                mailObj.To.Add(new MailAddress(_toAddress));
                /*Email subject*/
                mailObj.Subject = _subject;
                /*Email Body Encoding*/
                mailObj.BodyEncoding = Encoding.Default;
                /*Email Body*/
                mailObj.Body = _body;
                /*Body format (HTML/Text)*/
                mailObj.IsBodyHtml = _isBodyHTML;

                /*Via SMTP Gateway (i.e. your local Exchange Server)-> SmtpSendMethod = 0*/
                /*Via Direct Domain SMTP Connection w/DNS MX Lookup-> SmtpSendMethod = 1*/
                /*When SmtpSendMethod = 1 we are sending via local host instead of using SMTP settings*/
                SmtpClient smtpClientObj = null;
                if (_sendMethod == 1)
                {
                    //Send message
                    string domain = mailObj.To[0].Address.Substring(mailObj.To[0].Address.IndexOf('@') + 1);
                    //To Do :need to check for MX record existence before you send. Left intentionally for you.
                    string mxRecord = SendSMTP.DnsLookUp.GetMXRecords(domain)[0];
                    smtpClientObj = new SmtpClient(mxRecord);
                }
                else
                {
                    if (_isTLS == true && _isSSL == false)
                    {
                        ss.EnableSsl             = true;
                        ss.Timeout               = 20000;
                        ss.DeliveryMethod        = SmtpDeliveryMethod.Network;
                        ss.UseDefaultCredentials = false;
                        ss.Credentials           = new NetworkCredential(_smtpAuthUserName, _smtpAuthPassword);

                        mm.BodyEncoding = UTF8Encoding.UTF8;
                        mm.DeliveryNotificationOptions = DeliveryNotificationOptions.OnFailure;
                        mm.IsBodyHtml = _isBodyHTML;
                    }
                    else
                    {
                        CDO.IConfiguration configuration = message.Configuration;
                        ADODB.Fields       fields        = configuration.Fields;


                        ADODB.Field field = fields["http://schemas.microsoft.com/cdo/configuration/smtpserver"];
                        field.Value = _smtpServer;

                        field       = fields["http://schemas.microsoft.com/cdo/configuration/smtpserverport"];
                        field.Value = _smtpPort;

                        field       = fields["http://schemas.microsoft.com/cdo/configuration/sendusing"];
                        field.Value = CDO.CdoSendUsing.cdoSendUsingPort;

                        field = fields["http://schemas.microsoft.com/cdo/configuration/smtpauthenticate"];

                        if (_smtpAuthMethod == "" || _smtpAuthMethod.ToUpper() == "NONE")
                        {
                            field.Value = CDO.CdoProtocolsAuthentication.cdoAnonymous;
                        }
                        else if (_smtpAuthMethod.ToUpper() == "NTLM")
                        {
                            field.Value = CDO.CdoProtocolsAuthentication.cdoNTLM;
                        }
                        else
                        {
                            field.Value = CDO.CdoProtocolsAuthentication.cdoBasic;
                        }

                        field       = fields["http://schemas.microsoft.com/cdo/configuration/sendusername"];
                        field.Value = _smtpAuthUserName;

                        field       = fields["http://schemas.microsoft.com/cdo/configuration/sendpassword"];
                        field.Value = _smtpAuthPassword;

                        field       = fields["http://schemas.microsoft.com/cdo/configuration/smtpusessl"];
                        field.Value = _isSSL;

                        field       = fields["http://schemas.microsoft.com/cdo/configuration/smtpconnectiontimeout"];
                        field.Value = 10;

                        fields.Update();

                        message.From    = @"""" + _fromName + @""" <" + _fromAddress + ">";;
                        message.To      = _toAddress;
                        message.Subject = _subject;
                        if (_isBodyHTML)
                        {
                            message.HTMLBody = _body;
                        }
                        else
                        {
                            message.TextBody = _body;
                        }
                    }
                }

                try
                {
                    if (_sendMethod == 1)
                    {
                        smtpClientObj.Send(mailObj);
                    }
                    else
                    {
                        /*Send Mail*/
                        if (_isTLS == true && _isSSL == false)
                        {
                            ss.Send(mm);
                        }
                        else
                        {
                            message.Send();
                        }
                    }

                    /*Record notify response*/
                    notifyComResponse.IsError         = false;
                    notifyComResponse.IsSucceeded     = true;
                    notifyComResponse.ResponseContent = "Email sent to: " + "[" + _emailToName + "]" + _toAddress + ((_isAlphaPager) ? " (ALPHA PAGER) " : "");
                }
                catch (Exception ex)
                {
                    /*Record notify response*/
                    notifyComResponse.IsError         = true;
                    notifyComResponse.IsSucceeded     = false;
                    notifyComResponse.ResponseContent = "Email to: " + "[" + _emailToName + "]" + _toAddress + ((_isAlphaPager) ? " (ALPHA PAGER) " : "") + " Failed " + ex.Message;

                    /*Debug Object values for reference*/
                    LogBook.Debug(notifyComResponse, this);

                    /*Write exception log*/
                    LogBook.Write("Error has occurred while sending email to ." + _emailToName, ex, "CooperAtkins.NotificationServer.NotifyEngine.Email.EmailClient");
                }
                finally
                {
                    // Added on 2/19/2012
                    // Srinivas Rao Eranti
                    // Added try catch to release the message object
                    try
                    {
                        Marshal.FinalReleaseComObject(message);
                        // GC.SuppressFinalize(message);
                    }
                    catch
                    {
                    }
                }
            }
            catch (Exception ex)
            {
                /*Record notify response*/
                notifyComResponse.IsError         = true;
                notifyComResponse.IsSucceeded     = false;
                notifyComResponse.ResponseContent = "Email to: " + "[" + _emailToName + "]" + _toAddress + ((_isAlphaPager) ? "(ALPHA PAGER)" : "") + " Failed " + ex.Message;


                /*Debug Object values for reference*/
                LogBook.Debug(notifyComResponse, this);

                /*Write exception log*/
                LogBook.Write("Error has occurred while preparing SMTP setting.", ex, "CooperAtkins.NotificationServer.NotifyEngine.Email.EmailClient");
            }
            return(notifyComResponse);
        }
Beispiel #10
0
 public void Dispose()
 {
     Marshal.FinalReleaseComObject(writer);
 }
Beispiel #11
0
        private void LoadFile(string fileName)
        {
            this.Cursor = Cursors.WaitCursor;

            Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();

            excelApp.Visible = false;

            Workbook workbook = excelApp.Workbooks.Open(fileName);

            //select the first sheet
            Worksheet worksheet = (Worksheet)workbook.Worksheets[1];

            //find the used range in worksheet
            Range excelRange = worksheet.UsedRange;

            object[,] valueArray = excelRange.Value2;

            int rows = excelRange.Rows.Count;
            int cols = excelRange.Columns.Count;

            //clean up stuffs
            workbook.Close(false);
            Marshal.ReleaseComObject(workbook);

            excelApp.Quit();
            Marshal.FinalReleaseComObject(excelApp);

            OleDbCommand cmd = new OleDbCommand("", MainForm.connection);

            tempTable = "TEMP_" + MainForm.userName.ToUpper();

            MainForm.tempTableCreate(tempTable, "create table " + tempTable + " (TEMP_ID counter Primary key, VESSEL_NAME varchar(255), VESSEL_IMO varchar(255), LAST_DATE DateTime)");

            int vslCol  = 1;
            int imoCol  = 2;
            int dateCol = 10;

            int    lineCounter = 0;
            string cmdText     = "";

            for (int row = 2; row <= rows; row++)
            {
                lineCounter++;

                if (lineCounter < 10)
                {
                    if (cmdText.Length == 0)
                    {
                        cmdText =
                            "select TOP 1 \n" +
                            "'" + MainForm.StrToSQLStr(valueArray[row, vslCol].ToString()) + "' as VESSEL_NAME,'" +
                            MainForm.StrToSQLStr(valueArray[row, imoCol].ToString()) + "' as VESSEL_IMO," +
                            MainForm.DateTimeToQueryStr(DateTime.FromOADate(Convert.ToDouble(valueArray[row, dateCol]))) + " as LAST_DATE \n" +
                            "from OPTIONS";
                    }
                    else
                    {
                        cmdText = cmdText + "\n union \n" +
                                  "select TOP 1 \n" +
                                  "'" + MainForm.StrToSQLStr(valueArray[row, vslCol].ToString()) + "','" +
                                  MainForm.StrToSQLStr(valueArray[row, imoCol].ToString()) + "'," +
                                  MainForm.DateTimeToQueryStr(DateTime.FromOADate(Convert.ToDouble(valueArray[row, dateCol]))) + " \n" +
                                  "from OPTIONS";
                    }
                }
                else
                {
                    cmdText = cmdText + "\n union \n" +
                              "select TOP 1 \n" +
                              "'" + MainForm.StrToSQLStr(valueArray[row, vslCol].ToString()) + "','" +
                              MainForm.StrToSQLStr(valueArray[row, imoCol].ToString()) + "'," +
                              MainForm.DateTimeToQueryStr(DateTime.FromOADate(Convert.ToDouble(valueArray[row, dateCol]))) + " \n" +
                              "from OPTIONS";

                    cmd.CommandText =
                        "insert into " + tempTable + " (VESSEL_NAME, VESSEL_IMO, LAST_DATE) \n" +
                        "select * from (\n" +
                        cmdText + "\n)";

                    MainForm.cmdExecute(cmd);

                    System.Windows.Forms.Application.DoEvents();

                    lineCounter = 0;
                    cmdText     = "";
                }
            }

            if (lineCounter > 0)
            {
                cmd.CommandText =
                    "insert into " + tempTable + " (VESSEL_NAME, VESSEL_IMO, LAST_DATE) \n" +
                    "select * from (\n" +
                    cmdText + "\n)";

                MainForm.cmdExecute(cmd);

                System.Windows.Forms.Application.DoEvents();

                lineCounter = 0;
            }

            FillTable();

            this.Cursor = Cursors.Default;
        }
Beispiel #12
0
        /// <summary>
        /// Rerurns up to maxEncodings codpages that are assumed to be apropriate
        /// </summary>
        /// <param name="input">array containing the raw data</param>
        /// <param name="maxEncodings">maxiumum number of encodings to detect</param>
        /// <returns>an array of Encoding with assumed encodings</returns>
        public static Encoding[] DetectInputCodepages(byte[] input, int maxEncodings)
        {
            if (Path.DirectorySeparatorChar == '/')
            {
                // unix
                return(new Encoding[0]);
            }

            if (maxEncodings < 1)
            {
                throw new ArgumentOutOfRangeException("at least one encoding must be returend", "maxEncodings");
            }

            if (input == null)
            {
                throw new ArgumentNullException("input");
            }

            // empty strings can always be encoded as ASCII
            if (input.Length == 0)
            {
                return new Encoding[] { Encoding.ASCII }
            }
            ;

            // expand the string to be at least 256 bytes
            if (input.Length < 256)
            {
                byte[] newInput = new byte[256];

                int steps = 256 / input.Length;
                for (int i = 0; i < steps; i++)
                {
                    Array.Copy(input, 0, newInput, input.Length * i, input.Length);
                }

                int rest = 256 % input.Length;
                if (rest > 0)
                {
                    Array.Copy(input, 0, newInput, steps * input.Length, rest);
                }
                input = newInput;
            }

            List <Encoding> result = new List <Encoding>();

            // get the IMultiLanguage" interface
            MultiLanguage.IMultiLanguage2 multilang2 = new MultiLanguage.CMultiLanguageClass();
            if (multilang2 == null)
            {
                throw new System.Runtime.InteropServices.COMException("Failed to get IMultilang2");
            }
            try
            {
                MultiLanguage.DetectEncodingInfo[] detectedEncdings = new MultiLanguage.DetectEncodingInfo[maxEncodings];

                int scores = detectedEncdings.Length;
                int srcLen = input.Length;

                // setup options (none)
                MultiLanguage.MLDETECTCP options = MultiLanguage.MLDETECTCP.MLDETECTCP_NONE;

                // finally... call to DetectInputCodepage
                multilang2.DetectInputCodepage(options, 0,
                                               ref input[0], ref srcLen, ref detectedEncdings[0], ref scores);

                // get result
                if (scores > 0)
                {
                    for (int i = 0; i < scores; i++)
                    {
                        // add the result
                        result.Add(Encoding.GetEncoding((int)detectedEncdings[i].nCodePage));
                    }
                }
            }
            finally
            {
                Marshal.FinalReleaseComObject(multilang2);
            }
            // nothing found
            return(result.ToArray());
        }
Beispiel #13
0
        public static Encoding[] DetectOutgoingEncodings(string input, int[] preferedEncodings, bool preserveOrder)
        {
            if (input == null)
            {
                throw new ArgumentNullException("input");
            }

            // empty strings can always be encoded as ASCII
            if (input.Length == 0)
            {
                return new Encoding[] { Encoding.ASCII }
            }
            ;

            List <Encoding> result = new List <Encoding>();

            // get the IMultiLanguage3 interface
            MultiLanguage.IMultiLanguage3 multilang3 = new MultiLanguage.CMultiLanguageClass();
            if (multilang3 == null)
            {
                throw new System.Runtime.InteropServices.COMException("Failed to get IMultilang3");
            }
            try
            {
                int[]  resultCodePages   = new int[preferedEncodings.Length];
                uint   detectedCodepages = (uint)resultCodePages.Length;
                ushort specialChar       = (ushort)'?';


                // get unmanaged arrays
                IntPtr pPrefEncs     = Marshal.AllocCoTaskMem(sizeof(uint) * preferedEncodings.Length);
                IntPtr pDetectedEncs = preferedEncodings == null ? IntPtr.Zero : Marshal.AllocCoTaskMem(sizeof(uint) * resultCodePages.Length);

                try
                {
                    if (preferedEncodings != null)
                    {
                        Marshal.Copy(preferedEncodings, 0, pPrefEncs, preferedEncodings.Length);
                    }

                    Marshal.Copy(resultCodePages, 0, pDetectedEncs, resultCodePages.Length);

                    MultiLanguage.MLCPF options = MultiLanguage.MLCPF.MLDETECTF_VALID_NLS | MultiLanguage.MLCPF.MLDETECTF_PREFERRED_ONLY;
                    if (preserveOrder)
                    {
                        options |= MultiLanguage.MLCPF.MLDETECTF_PRESERVE_ORDER;
                    }

                    if (preferedEncodings != null)
                    {
                        options |= MultiLanguage.MLCPF.MLDETECTF_PREFERRED_ONLY;
                    }

                    // finally... call to DetectOutboundCodePage
                    multilang3.DetectOutboundCodePage(options,
                                                      input, (uint)input.Length,
                                                      pPrefEncs, (uint)(preferedEncodings == null ? 0 : preferedEncodings.Length),
                                                      pDetectedEncs, ref detectedCodepages,
                                                      ref specialChar);

                    // get result
                    if (detectedCodepages > 0)
                    {
                        int[] theResult = new int[detectedCodepages];
                        Marshal.Copy(pDetectedEncs, theResult, 0, theResult.Length);


                        // get the encodings for the codepages
                        for (int i = 0; i < detectedCodepages; i++)
                        {
                            result.Add(Encoding.GetEncoding(theResult[i]));
                        }
                    }
                }
                finally
                {
                    if (pPrefEncs != IntPtr.Zero)
                    {
                        Marshal.FreeCoTaskMem(pPrefEncs);
                    }
                    Marshal.FreeCoTaskMem(pDetectedEncs);
                }
            }
            finally
            {
                Marshal.FinalReleaseComObject(multilang3);
            }
            // nothing found
            return(result.ToArray());
        }
Beispiel #14
0
        public static string ConvertData(string files)
        {
            FileInfo newFile = new FileInfo(files);
            //if (!Directory.Exists(System.Windows.Forms.Application.StartupPath + @"\Report\"))
            //Directory.CreateDirectory(System.Windows.Forms.Application.StartupPath + @"\Report\");

            ApplicationClass excelApplication = new ApplicationClass();
            Workbook         excelWorkBook    = null;

            excelApplication.Caption = System.Guid.NewGuid().ToString().ToUpper();

            string paramSourceBookPath = files;//System.Windows.Forms.Application.StartupPath + @"\" + files;// @"D:\test.xls";
            object paramMissing        = Type.Missing;

            string name = Path.GetFileNameWithoutExtension(files);

            //string paramExportFilePath = System.Windows.Forms.Application.StartupPath + @"\Report\" + name + ".pdf";
            string paramExportFilePath = newFile.DirectoryName + @"\\" + name + ".pdf";


            //MessageBox.Show(paramExportFilePath);

            XlFixedFormatType    paramExportFormat  = XlFixedFormatType.xlTypePDF;
            XlFixedFormatQuality paramExportQuality =
                XlFixedFormatQuality.xlQualityStandard;
            bool   paramOpenAfterPublish = false;
            bool   paramIncludeDocProps  = true;
            bool   paramIgnorePrintAreas = true;
            object paramFromPage         = Type.Missing;
            object paramToPage           = Type.Missing;

            try
            {
                // Open the source workbook.
                excelWorkBook = excelApplication.Workbooks.Open(paramSourceBookPath,
                                                                paramMissing, paramMissing, paramMissing, paramMissing,
                                                                paramMissing, paramMissing, paramMissing, paramMissing,
                                                                paramMissing, paramMissing, paramMissing, paramMissing,
                                                                paramMissing, paramMissing);

                // Save it in the target format.
                if (excelWorkBook != null)
                {
                    excelWorkBook.ExportAsFixedFormat(paramExportFormat,
                                                      paramExportFilePath, paramExportQuality,
                                                      paramIncludeDocProps, paramIgnorePrintAreas, paramFromPage,
                                                      paramToPage, paramOpenAfterPublish,
                                                      paramMissing);
                    // MessageBox.Show(paramExportFilePath);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString());
                // Respond to the error.
            }
            finally
            {
                // Close the workbook object.
                if (excelWorkBook != null)
                {
                    excelApplication.DisplayAlerts = false;
                    excelWorkBook.Close(false, paramMissing, paramMissing);
                    Marshal.ReleaseComObject(excelWorkBook);
                    Marshal.FinalReleaseComObject(excelWorkBook);
                    excelWorkBook = null;
                }

                // Quit Excel and release the ApplicationClass object.
                if (excelApplication != null)
                {
                    excelApplication.Quit();
                    Config.EnsureProcessKilled(IntPtr.Zero, excelApplication.Caption);
                    Marshal.ReleaseComObject(excelApplication);
                    Marshal.FinalReleaseComObject(excelApplication);
                    excelApplication = null;
                }


                GC.Collect();
                GC.WaitForPendingFinalizers();
                GC.Collect();
                GC.WaitForPendingFinalizers();
            }

            return(paramExportFilePath);
        }
Beispiel #15
0
        //Create the Excel file from dataset
        public void Okuri(DataTable ds, string SOKOCD)
        {
            string         saveFileName = "送り状兼受領書_" + SOKOCD + "_" + DateTime.Now.ToString("yyyyMMddHHmmss");
            string         templetFile  = @"template\送り状兼受領書.xlsx";
            SaveFileDialog saveDialog   = new SaveFileDialog {
                Filter           = "Excel文件 |*.xlsx",
                FileName         = saveFileName,
                RestoreDirectory = true
            };

            if (saveDialog.ShowDialog() == DialogResult.OK)
            {
                saveFileName = saveDialog.FileName;
                File.Copy(templetFile, saveFileName, true);
                Excel.Application excel     = new Excel.Application();
                Excel.Workbook    workbook  = excel.Workbooks.Open(saveFileName);
                Excel.Worksheet   worksheet = workbook.Worksheets[1];
                excel.Visible = false;

                try
                {
                    log.Info("EXEC BEGIN");
                    var distinctIds = ds.AsEnumerable()
                                      .Select(s => new
                    {
                        area  = s.Field <string>("AREANM"),
                        homen = s.Field <string>("HOMEN"),
                        //soko = s.Field<string>("SOKONM"),
                        //nukn = s.Field<string>("NUKNNM"),
                    })
                                      .Distinct().ToList();

                    if (distinctIds.Count > 1)
                    {
                        int no = 0;
                        foreach (var a in distinctIds)
                        {
                            string    expression;
                            DataRow[] foundRows;
                            expression = "AREANM = '" + a.area.ToString() + "' AND HOMEN = '" + a.homen.ToString() + "'";

                            foundRows      = ds.Select(expression);
                            worksheet.Name = foundRows[0][11] + "_" + foundRows[0][10];
                            workbook.Worksheets[1].Name = workbook.Worksheets[1].Name.Split(' ')[0];
                            worksheet.Cells[1, "H"]     = foundRows[0][11];
                            worksheet.Cells[1, "AD"]    = foundRows[0][10];
                            worksheet.Cells[5, "B"]     = foundRows[0][2];
                            worksheet.Cells[5, "H"]     = foundRows[0][5];
                            worksheet.Cells[5, "N"]     = foundRows[0][3];
                            worksheet.Cells[5, "Y"]     = foundRows[0][1];
                            worksheet.Cells[5, "AS"]    = foundRows[0][6];
                            worksheet.Cells[5, "AW"]    = foundRows[0][7];
                            worksheet.Cells[5, "BC"]    = foundRows[0][8];
                            worksheet.Cells[5, "BM"]    = foundRows[0][9];
                            worksheet.Cells[5, "CD"]    = foundRows[0][12];
                            worksheet.Cells[5, "CN"]    = "サイン";

                            for (int i = 0; i < foundRows.Length - 1; i++)
                            {
                                Excel.Range RngToCopy   = worksheet.get_Range("B5").EntireRow;
                                Excel.Range RngToInsert = worksheet.get_Range("B" + (i + 6)).EntireRow;
                                RngToInsert.Insert(Excel.XlInsertShiftDirection.xlShiftDown, RngToCopy.Copy());

                                worksheet.Cells[6 + i, "B"]  = foundRows[i + 1][2];
                                worksheet.Cells[6 + i, "H"]  = foundRows[i + 1][5];
                                worksheet.Cells[6 + i, "N"]  = foundRows[i + 1][3];
                                worksheet.Cells[6 + i, "Y"]  = foundRows[i + 1][1];
                                worksheet.Cells[6 + i, "AS"] = foundRows[i + 1][6];
                                worksheet.Cells[6 + i, "AW"] = foundRows[i + 1][7];
                                worksheet.Cells[6 + i, "BC"] = foundRows[i + 1][8];
                                worksheet.Cells[6 + i, "BM"] = foundRows[i + 1][9];
                                worksheet.Cells[6 + i, "CD"] = foundRows[i + 1][12];
                                worksheet.Cells[6 + i, "CN"] = "サイン";
                            }
                            no++;
                            if (no < distinctIds.Count)
                            {
                                worksheet.Copy(workbook.Worksheets[1], Type.Missing);
                                worksheet.get_Range("B5:B1000").EntireRow.ClearContents();
                                worksheet.get_Range("CN6:CN1000").EntireRow.Borders.LineStyle = Excel.XlLineStyle.xlLineStyleNone;
                            }
                        }
                    }

                    else
                    {
                        foreach (var a in distinctIds)
                        {
                            string    expression;
                            DataRow[] foundRows;
                            expression     = "AREANM = '" + a.area.ToString() + "' AND HOMEN = '" + a.homen.ToString() + "'";
                            foundRows      = ds.Select(expression);
                            worksheet.Name = foundRows[0][11] + "_" + foundRows[0][10];
                            workbook.Worksheets[1].Name = workbook.Worksheets[1].Name.Split(' ')[0];
                            worksheet.Cells[1, "H"]     = foundRows[0][11];
                            worksheet.Cells[1, "AD"]    = foundRows[0][10];
                            worksheet.Cells[5, "B"]     = foundRows[0][2];
                            worksheet.Cells[5, "H"]     = foundRows[0][5];
                            worksheet.Cells[5, "N"]     = foundRows[0][3];
                            worksheet.Cells[5, "Y"]     = foundRows[0][1];
                            worksheet.Cells[5, "AS"]    = foundRows[0][6];
                            worksheet.Cells[5, "AW"]    = foundRows[0][7];
                            worksheet.Cells[5, "BC"]    = foundRows[0][8];
                            worksheet.Cells[5, "BM"]    = foundRows[0][9];
                            worksheet.Cells[5, "CD"]    = foundRows[0][12];
                            worksheet.Cells[5, "CN"]    = "サイン";

                            for (int i = 1; i < foundRows.Length; i++)
                            {
                                Excel.Range RngToCopy   = worksheet.get_Range("B5").EntireRow;
                                Excel.Range RngToInsert = worksheet.get_Range("B" + (i + 5)).EntireRow;
                                RngToInsert.Insert(Excel.XlInsertShiftDirection.xlShiftDown, RngToCopy.Copy());

                                worksheet.Cells[5 + i, "B"]  = foundRows[i][2];
                                worksheet.Cells[5 + i, "H"]  = foundRows[i][5];
                                worksheet.Cells[5 + i, "N"]  = foundRows[i][3];
                                worksheet.Cells[5 + i, "Y"]  = foundRows[i][1];
                                worksheet.Cells[5 + i, "AS"] = foundRows[i][6];
                                worksheet.Cells[5 + i, "AW"] = foundRows[i][7];
                                worksheet.Cells[5 + i, "BC"] = foundRows[i][8];
                                worksheet.Cells[5 + i, "BM"] = foundRows[i][9];
                                worksheet.Cells[5 + i, "CD"] = foundRows[i][12];
                                worksheet.Cells[5 + i, "CN"] = "サイン";
                            }
                        }
                    }
                }
                catch (Exception e)
                {
                    log.Error("ERROR" + e.Message);
                }

                finally
                {
                    excel.DisplayAlerts = false;
                    Application.DoEvents();
                    workbook.Save();
                    excel.Quit();
                    Marshal.FinalReleaseComObject(excel);

                    log.Info("EXEC END");
                }
            }
            else
            {
                MessageBox.Show("処理を中止しました。");
            }
        }
Beispiel #16
0
        private void backgroundWorkerBurn_DoWork(object sender, System.ComponentModel.DoWorkEventArgs e)
        {
            MsftDiscRecorder2   discRecorder   = null;
            MsftDiscFormat2Data discFormatData = null;

            IMediaItem mediaItem;

            try
            {
                //
                // Create and initialize the IDiscRecorder2 object
                //
                discRecorder = new MsftDiscRecorder2();
                var burnData = (BurnData)e.Argument;
                mediaItem = burnData.mediaItem;
                discRecorder.InitializeDiscRecorder(burnData.uniqueRecorderId);

                //
                // Create and initialize the IDiscFormat2Data
                //
                discFormatData = new MsftDiscFormat2Data
                {
                    Recorder             = discRecorder,
                    ClientName           = ClientName,
                    ForceMediaToBeClosed = _closeMedia
                };

                //
                // Set the verification level
                //
                var burnVerification = (IBurnVerification)discFormatData;
                burnVerification.BurnVerificationLevel = _verificationLevel;

                //
                // Check if media is blank, (for RW media)
                //
                object[] multisessionInterfaces = null;
                if (!discFormatData.MediaHeuristicallyBlank)
                {
                    multisessionInterfaces = discFormatData.MultisessionInterfaces;
                }

                //
                // Create the file system
                //
                IStream fileSystem;
                if (!CreateMediaFileSystem(discRecorder, multisessionInterfaces, out fileSystem, mediaItem))
                {
                    e.Result = -1;
                    return;
                }

                //
                // add the Update event handler
                //
                discFormatData.Update += discFormatData_Update;

                //
                // Write the data here
                //
                try
                {
                    discFormatData.Write(fileSystem);
                    e.Result = 0;
                }
                catch (COMException ex)
                {
                    e.Result = ex.ErrorCode;
                    MessageBox.Show(ex.Message, "IDiscFormat2Data.Write failed",
                                    MessageBoxButtons.OK, MessageBoxIcon.Stop);
                }
                finally
                {
                    if (fileSystem != null)
                    {
                        Marshal.FinalReleaseComObject(fileSystem);
                    }
                }

                //
                // remove the Update event handler
                //
                discFormatData.Update -= discFormatData_Update;

                if (_ejectMedia)
                {
                    discRecorder.EjectMedia();
                }
            }
            catch (COMException exception)
            {
                //
                // If anything happens during the format, show the message
                //
                MessageBox.Show(exception.Message);
                e.Result = exception.ErrorCode;
            }
            finally
            {
                if (discRecorder != null)
                {
                    Marshal.ReleaseComObject(discRecorder);
                }

                if (discFormatData != null)
                {
                    Marshal.ReleaseComObject(discFormatData);
                }
            }
        }
 public void FinalReleaseComObject_Unix_ThrowsPlatformNotSupportedException()
 {
     Assert.Throws <PlatformNotSupportedException>(() => Marshal.FinalReleaseComObject(null));
 }
Beispiel #18
0
        /// <summary>
        /// 获取 vb login 和 .net login
        /// 可绕过login验证
        /// </summary>
        /// <param name="bd"></param>
        /// <param name="oSysLogin"></param>
        /// <param name="u8Login"></param>
        /// <returns></returns>
        private Model.DealResult GetU8LoginNew(Model.APIData bd, UFSoft.U8.Framework.Login.UI.clsLogin oSysLogin, U8Login.clsLogin u8Login)
        {
            Model.DealResult dr = new Model.DealResult();

            System.Diagnostics.Trace.WriteLine("  before  GetU8Login 判断格式 ");
            #region 判断格式  登录
            string strErr = ",请在[账套档案注册]模块中更新!";
            if (string.IsNullOrEmpty(bd.ConnectInfo.UserId))
            {
                dr.ResultMsg = "默认操作员不能为空" + strErr;
                dr.ResultNum = -1;
                Marshal.FinalReleaseComObject(u8Login);
                throw new Exception(dr.ResultMsg);
            }
            if (string.IsNullOrEmpty(bd.ConnectInfo.Source))
            {
                dr.ResultMsg = "数据源不能为空" + strErr;
                dr.ResultNum = -1;
                Marshal.FinalReleaseComObject(u8Login);
                throw new Exception(dr.ResultMsg);
            }
            if (string.IsNullOrEmpty(bd.ConnectInfo.AccId))
            {
                dr.ResultMsg = "账套号不能为空" + strErr;
                dr.ResultNum = -1;
                Marshal.FinalReleaseComObject(u8Login);
                throw new Exception(dr.ResultMsg);
            }
            if (string.IsNullOrEmpty(bd.ConnectInfo.Srv))
            {
                dr.ResultMsg = "服务器地址不能为空" + strErr;
                dr.ResultNum = -1;
                Marshal.FinalReleaseComObject(u8Login);
                throw new Exception(dr.ResultMsg);
            }
            if (string.IsNullOrEmpty(bd.ConnectInfo.YearId))
            {
                dr.ResultMsg = "登陆年度不能为空" + strErr;
                dr.ResultNum = -1;
                Marshal.FinalReleaseComObject(u8Login);
                throw new Exception(dr.ResultMsg);
            }
            else
            {
                try { int.Parse(bd.ConnectInfo.YearId); }
                catch
                {
                    dr.ResultMsg = "登陆年度格式错误:" + bd.ConnectInfo.YearId + strErr;
                    dr.ResultNum = -1;
                    Marshal.FinalReleaseComObject(u8Login);
                    throw new Exception(dr.ResultMsg);
                }
            }
            DbHelperSQLP dsp    = new DbHelperSQLP(bd.ConnectInfo.Constring);
            string       strSql = "SELECT 1 FROM UFSystem.dbo.UA_AccountDatabase A JOIN UFSystem.dbo.UA_Account B ON A.cAcc_Id=B.cAcc_Id WHERE A.cAcc_Id='" + bd.ConnectInfo.AccId + "' ";
            if (!dsp.Exists(strSql))
            {
                dr.ResultMsg = "登陆失败,原因:账套 " + bd.ConnectInfo.AccId + " 在 " + bd.ConnectInfo.Srv + " 上不存在";
                dr.ResultNum = -1;
                Marshal.FinalReleaseComObject(u8Login);
                throw new Exception(dr.ResultMsg);
            }
            #endregion

            System.Diagnostics.Trace.WriteLine("  after  GetU8Login 判断格式 ");


            bool   bLogined;
            string beginDate;

            oSysLogin = new UFSoft.U8.Framework.Login.UI.clsLogin();

            beginDate            = "";      //GetMonthBegindate(acc_ID, iYear, "12")  //用12期间构造login,12期间必有
            oSysLogin.LanguageID = "zh-CN"; // GetAccountLoginLocaleID(modUtility.GetDbName(acc_ID, iYear))

            string subId    = U8.Interface.Bus.SysInfo.subId;
            string userId   = bd.ConnectInfo.UserId;
            string accId    = bd.ConnectInfo.Source + "@" + bd.ConnectInfo.AccId;
            string yearId   = bd.ConnectInfo.YearId;
            string password = bd.ConnectInfo.Password;
            string date     = bd.ConnectInfo.Date;
            string srv      = bd.ConnectInfo.sSrv;
            string serial   = bd.ConnectInfo.Serial;

            bLogined = oSysLogin.login(subId, userId, password, srv, date, accId, serial);

            if (!bLogined)
            {
                strErr = oSysLogin.ErrDescript; //& g_fmtr.GetString("String.U8.AA.Admin.4671", g_args)
                //'strErr = oSysLogin.ErrDescript & "内置用户密码不正确!"
                //'Call WriteTransferLog(g_ologin.cAcc_ID, g_ologin.cAccName, g_ologin.cIyear, "", "准备年结环境时出现错误,错误描述:" & oSyslogin.ErrDescript & "内置用户密码不正确!")
                dr.ResultMsg = "登陆失败,原因:" + strErr;
                dr.ResultNum = -1;
                Marshal.FinalReleaseComObject(u8Login);
                throw new Exception(dr.ResultMsg);
            }

            UFSoft.U8.Framework.LoginContext.ProductContext oLoginContext;
            oLoginContext = new UFSoft.U8.Framework.LoginContext.ProductContext();
            oLoginContext = oSysLogin.SubLogin(U8.Interface.Bus.SysInfo.subId);

            if (null == oLoginContext)
            {
                strErr = oSysLogin.ErrDescript;
                //'MsgBox oSyslogin.ErrDescript
                //'Call WriteTransferLog(g_ologin.cAcc_ID, g_ologin.cAccName, g_ologin.cIyear, "", "准备年结环境时出现错误,错误描述:" & oSyslogin.ErrDescript)
                dr.ResultMsg = "登陆失败,原因:" + strErr;
                dr.ResultNum = -1;
                Marshal.FinalReleaseComObject(u8Login);
                throw new Exception(dr.ResultMsg);
            }

            //u8Login = new U8Login.clsLogin();

            if (!u8Login.ConstructLogin(oSysLogin.userToken))
            {
                strErr = u8Login.ShareString;
                //'Call WriteTransferLog(g_ologin.cAcc_ID, g_ologin.cAccName, g_ologin.cIyear, "", "准备年结环境时出现错误,错误描述:" & oLogin.ShareString)
                dr.ResultMsg = "登陆失败,原因:" + strErr;
                dr.ResultNum = -1;
                Marshal.FinalReleaseComObject(u8Login);
                throw new Exception(dr.ResultMsg);
            }

            if (!u8Login.Login(ref subId, ref accId, ref yearId, ref userId, ref password, ref date, ref srv, ref serial))
            {
                System.Diagnostics.Trace.WriteLine("    GetU8Login  failed  ");
                dr.ResultMsg = "登陆失败,原因:" + u8Login.ShareString;
                if (u8Login.ShareString.IndexOf("年度") > 0 || u8Login.ShareString.IndexOf("日期") > 0)
                {
                    dr.ResultMsg += " - " + date;
                }
                dr.ResultNum = -1;
                Marshal.FinalReleaseComObject(u8Login);
                throw new Exception(dr.ResultMsg);
            }


            return(dr);
        }
Beispiel #19
0
        /// <summary>
        /// Initialize the MediaFoundationProvider with specific file.
        /// </summary>
        public MediaFoundationProvider(string url)
        {
            MediaFoundationApi.Startup();
            if (!File.Exists(url))
            {
                throw new FileNotFoundException("This file doesn't exist");
            }
            MediaFoundationInterop.MFCreateSourceResolver(out IMFSourceResolver resolver);
            //Creates both IMFMediaSource and IMFByteStream.Uses the stream for 'Read' method and uses the source to collect format information.
            resolver.CreateObjectFromURL(url, SourceResolverFlags.MF_RESOLUTION_BYTESTREAM | SourceResolverFlags.MF_RESOLUTION_CONTENT_DOES_NOT_HAVE_TO_MATCH_EXTENSION_OR_MIME_TYPE, null, out _, out object _stream);
            IMFByteStream byteStream = _stream as IMFByteStream;

            resolver.CreateObjectFromByteStream(byteStream, null, SourceResolverFlags.MF_RESOLUTION_MEDIASOURCE | SourceResolverFlags.MF_RESOLUTION_CONTENT_DOES_NOT_HAVE_TO_MATCH_EXTENSION_OR_MIME_TYPE, null, out _, out object _source);
            Marshal.FinalReleaseComObject(resolver);
            IMFMediaSource source = _source as IMFMediaSource;

            source.CreatePresentationDescriptor(out IMFPresentationDescriptor descriptor);
            descriptor.GetStreamDescriptorCount(out uint sdcount);
            for (uint i = 0; i < sdcount; i++)
            {
                descriptor.GetStreamDescriptorByIndex(i, out _, out IMFStreamDescriptor sd);
                sd.GetMediaTypeHandler(out IMFMediaTypeHandler typeHandler);
                typeHandler.GetMediaTypeByIndex(0, out IMFMediaType mediaType);
                mediaType.GetMajorType(out Guid streamtype);
                if (streamtype == MediaTypes.MFMediaType_Audio)
                {
                    mediaType.GetUINT32(MediaFoundationAttributes.MF_MT_AUDIO_SAMPLES_PER_SECOND, out int rate);//SampleRate
                    mediaType.GetUINT32(MediaFoundationAttributes.MF_MT_AUDIO_NUM_CHANNELS, out int channelcount);
                    int samplesize;
                    try
                    {
                        mediaType.GetUINT32(MediaFoundationAttributes.MF_MT_AUDIO_BITS_PER_SAMPLE, out samplesize);
                    }
                    catch (COMException e)
                    {
                        if ((uint)e.HResult != 0xC00D36E6)
                        {
                            throw e;
                        }
                        else
                        {
                            samplesize = 8;
                        }
                    }
                    WaveFormat = new WaveFormat(rate, samplesize, channelcount);
                }
                else
                {
                    continue;
                }
            }
            byteStream.GetLength(out streamlength);
            byteStream.SetCurrentPosition(0);
            //Moves all the bytes in IMFByteStream to MemoryStream.
            MediaFoundationInterop.MFCreateMemoryBuffer(unchecked ((int)streamlength), out IMFMediaBuffer mediabuffer);
            mediabuffer.Lock(out IntPtr pbuffer, out int length, out _);
            byteStream.Read(pbuffer, length, out _);
            byte[] buffer = new byte[length];
            Marshal.Copy(pbuffer, buffer, 0, length);
            datastream = new MemoryStream(buffer);
        }
Beispiel #20
0
        /// <summary>
        /// 获取Login对象
        /// </summary>
        /// <param name="bd"></param>
        /// <param name="u8Login"></param>
        /// <returns></returns>
        public Model.DealResult GetU8Login_bak(Model.APIData bd, U8Login.clsLogin u8Login)
        {
            System.Diagnostics.Trace.WriteLine("  begin GetU8Login  ");

            Model.DealResult dr = new Model.DealResult();

            #region 一次登录
            //if (bd.TaskType != 1 && null != _login)
            //{
            //    u8Login = _login;
            //    return dr;
            //}

            #endregion


            System.Diagnostics.Trace.WriteLine("  before  GetU8Login 判断格式 ");

            #region 判断格式  登录
            string strErr = ",请在[账套档案注册]模块中更新!";
            if (string.IsNullOrEmpty(bd.ConnectInfo.UserId))
            {
                dr.ResultMsg = "默认操作员不能为空" + strErr;
                dr.ResultNum = -1;
                Marshal.FinalReleaseComObject(u8Login);
                throw new Exception(dr.ResultMsg);
            }
            if (string.IsNullOrEmpty(bd.ConnectInfo.Source))
            {
                dr.ResultMsg = "数据源不能为空" + strErr;
                dr.ResultNum = -1;
                Marshal.FinalReleaseComObject(u8Login);
                throw new Exception(dr.ResultMsg);
            }
            if (string.IsNullOrEmpty(bd.ConnectInfo.AccId))
            {
                dr.ResultMsg = "账套号不能为空" + strErr;
                dr.ResultNum = -1;
                Marshal.FinalReleaseComObject(u8Login);
                throw new Exception(dr.ResultMsg);
            }
            if (string.IsNullOrEmpty(bd.ConnectInfo.Srv))
            {
                dr.ResultMsg = "服务器地址不能为空" + strErr;
                dr.ResultNum = -1;
                Marshal.FinalReleaseComObject(u8Login);
                throw new Exception(dr.ResultMsg);
            }
            if (string.IsNullOrEmpty(bd.ConnectInfo.YearId))
            {
                dr.ResultMsg = "登陆年度不能为空" + strErr;
                dr.ResultNum = -1;
                Marshal.FinalReleaseComObject(u8Login);
                throw new Exception(dr.ResultMsg);
            }
            else
            {
                try { int.Parse(bd.ConnectInfo.YearId); }
                catch
                {
                    dr.ResultMsg = "登陆年度格式错误:" + bd.ConnectInfo.YearId + strErr;
                    dr.ResultNum = -1;
                    Marshal.FinalReleaseComObject(u8Login);
                    throw new Exception(dr.ResultMsg);
                }
            }
            DbHelperSQLP dsp    = new DbHelperSQLP(bd.ConnectInfo.Constring);
            string       strSql = "SELECT 1 FROM UFSystem.dbo.UA_AccountDatabase A JOIN UFSystem.dbo.UA_Account B ON A.cAcc_Id=B.cAcc_Id WHERE A.cAcc_Id='" + bd.ConnectInfo.AccId + "' ";
            if (!dsp.Exists(strSql))
            {
                dr.ResultMsg = "登陆失败,原因:账套 " + bd.ConnectInfo.AccId + " 在 " + bd.ConnectInfo.Srv + " 上不存在";
                dr.ResultNum = -1;
                Marshal.FinalReleaseComObject(u8Login);
                throw new Exception(dr.ResultMsg);
            }
            #endregion

            System.Diagnostics.Trace.WriteLine("  after  GetU8Login 判断格式 ");

            string subId    = U8.Interface.Bus.SysInfo.subId;
            string userId   = bd.ConnectInfo.UserId;
            string accId    = bd.ConnectInfo.Source + "@" + bd.ConnectInfo.AccId;
            string yearId   = bd.ConnectInfo.YearId;
            string password = bd.ConnectInfo.Password;
            string date     = bd.ConnectInfo.Date;
            string srv      = bd.ConnectInfo.sSrv;
            string serial   = bd.ConnectInfo.Serial;


            #region 20140814

            #endregion

            System.Diagnostics.Trace.WriteLine("  before  GetU8Login u8Login.Login   ");
            System.Diagnostics.Trace.WriteLine("  login parameter :  " + subId + "----" + accId + "----" + yearId + "----" + userId + "----" + password + "----" + date + "----" + srv + "----" + serial);

            try
            {
                if (!u8Login.Login(ref subId, ref accId, ref yearId, ref userId, ref password, ref date, ref srv, ref serial))
                {
                    System.Diagnostics.Trace.WriteLine("    GetU8Login  failed  ");
                    dr.ResultMsg = "登陆失败,原因:" + u8Login.ShareString;
                    if (u8Login.ShareString.IndexOf("年度") > 0 || u8Login.ShareString.IndexOf("日期") > 0)
                    {
                        dr.ResultMsg += " - " + date;
                    }
                    dr.ResultNum = -1;
                    Marshal.FinalReleaseComObject(u8Login);
                    throw new Exception(dr.ResultMsg);
                }
            }
            catch (Exception ee)
            {
                if (dr.ResultNum == -1)
                {
                    throw new Exception(dr.ResultMsg);
                }
                else
                {
                    System.Diagnostics.Trace.WriteLine("   GetU8Login u8Login.Login Error : " + ee.StackTrace);
                    dr.ResultNum = -1;
                    throw new Exception(ee.Message);
                }
            }


            System.Diagnostics.Trace.WriteLine("  end  GetU8Login u8Login.Login ");
            System.Diagnostics.Trace.WriteLine("  end GetU8Login  ");

            //_login = u8Login;
            return(dr);
        }
        public CreateExcelFile(LoadXML x, LoadTemplate t)
        {
            XML      = x;
            template = t;
            try
            {
                //Start the Microsoft Excel Application
                string excelTemplate = System.AppDomain.CurrentDomain.BaseDirectory + "New EBOM " + template.time + ".xlsx";

                xlApp = new Microsoft.Office.Interop.Excel.Application();
                if (xlApp == null)
                {
                    MessageBox.Show("Excel is not properly installed!!");
                    return;
                }
                xlWorkBooks = xlApp.Workbooks;
                try
                {
                    xlWorkBook = xlWorkBooks.Open(excelTemplate, 0, false, 5, "", "", false, XlPlatform.xlWindows, "", true, false, 0, true, false, false); //open the template file!
                }
                catch (Exception e) { return; }
                xlWorkSheets = xlWorkBook.Worksheets;
                xlWorkSheet  = xlWorkSheets.get_Item(1);

                //int totalRows = template.allCells.GetLength(0);
                //int totalColumns = template.allCells.GetLength(1);



                //for (int row = 0; row < totalRows ; row++)
                //{
                //    for (int column = 0; column < totalColumns; column++) // the plus one is because the excel columns and rows start at 1
                //    {
                //        if (template.allCells[row, column].text.Contains("[TextHere]")) writeData(template.allCells[row, column]);
                //    }
                //    Console.WriteLine("Finished writing row " + (row + 1));
                //}

                foreach (LoadTemplate.myCell cell in template.titleBlock)
                {
                    writeData(cell);
                }
                foreach (LoadTemplate.myCell cell in template.headerRow)
                {
                    writeData(cell);
                }
                Console.WriteLine("Finished writing Title Block");

                for (int a = 0; a < template.bodyRows.Count; a++)
                {
                    Range range = xlWorkSheet.Range[xlWorkSheet.Cells[template.bodyRows[a][0].rowIndex, template.bodyRows[a][0].columnIndex], xlWorkSheet.Cells[template.bodyRows[a][template.bodyRows[a].Count - 1].rowIndex, template.bodyRows[a][template.bodyRows[a].Count - 1].columnIndex]]; // get whole row
                    range.Interior.Color = template.bodyColors[a % template.bodyColors.Count];                                                                                                                                                                                                     // change color of whole row
                    if (template.bodyRows[a][template.bodyRows[a].Count - 1].rightLineStyle != XlLineStyle.xlLineStyleNone)                                                                                                                                                                        // check if we need to set borders
                    {
                        for (int b = 0; b < template.bodyRows[a].Count; b++)                                                                                                                                                                                                                       //set borders
                        {
                            xlWorkSheet.Cells[template.bodyRows[a][b].rowIndex, template.bodyRows[a][b].columnIndex].Borders(XlBordersIndex.xlEdgeRight).LineStyle  = template.bodyRows[a][b].rightLineStyle;
                            xlWorkSheet.Cells[template.bodyRows[a][b].rowIndex, template.bodyRows[a][b].columnIndex].Borders(XlBordersIndex.xlEdgeRight).Weight     = template.bodyRows[a][b].rightWeight;
                            xlWorkSheet.Cells[template.bodyRows[a][b].rowIndex, template.bodyRows[a][b].columnIndex].Borders(XlBordersIndex.xlEdgeBottom).LineStyle = template.bodyRows[a][b].bottomLineStyle;
                            xlWorkSheet.Cells[template.bodyRows[a][b].rowIndex, template.bodyRows[a][b].columnIndex].Borders(XlBordersIndex.xlEdgeBottom).Weight    = template.bodyRows[a][b].bottomWeight;
                            xlWorkSheet.Cells[template.bodyRows[a][b].rowIndex, template.bodyRows[a][b].columnIndex].Borders(XlBordersIndex.xlEdgeLeft).LineStyle   = template.bodyRows[a][b].leftLineStyle;
                            xlWorkSheet.Cells[template.bodyRows[a][b].rowIndex, template.bodyRows[a][b].columnIndex].Borders(XlBordersIndex.xlEdgeLeft).Weight      = template.bodyRows[a][b].leftWeight;
                        }
                    }
                }


                int c = 0;
                foreach (List <List <LoadTemplate.myCell> > partGroups in XML.sorted)
                {
                    foreach (List <LoadTemplate.myCell> cellRows in partGroups)
                    {
                        foreach (LoadTemplate.myCell cell in cellRows)
                        {
                            writeData(cell);
                        }
                    }
                    Console.WriteLine("Finished writing row: " + ++c);
                }
                Console.WriteLine("Total Part Count: " + XML.totalPartCount);
                xlWorkBook.SaveAs(System.AppDomain.CurrentDomain.BaseDirectory + "Ebom_testing" + getTime() + ".xlsx");
            }
            finally
            {
                Console.WriteLine("Finished Saving Excel File");
                Marshal.FinalReleaseComObject(xlWorkSheet);
                Marshal.FinalReleaseComObject(xlWorkSheets);
                xlWorkBook.Close();
                Marshal.FinalReleaseComObject(xlWorkBook);
                xlWorkBooks.Close();
                Marshal.FinalReleaseComObject(xlWorkBooks);
                xlApp.Quit();
                Marshal.FinalReleaseComObject(xlApp); // excel objects don't releast comObjects to excel so you have to force it
            }
        }
Beispiel #22
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="fileName">file to get information form</param>
        /// <param name="sheetName">valid sheet name to get last row and column</param>
        /// <returns>ExcelLast</returns>
        public ExcelLast UsedRowsColumns(string fileName, string sheetName)
        {
            int RowsUsed = -1;
            int ColsUsed = -1;

            if (File.Exists(fileName))
            {
                Excel.Application xlApp        = null;
                Excel.Workbooks   xlWorkBooks  = null;
                Excel.Workbook    xlWorkBook   = null;
                Excel.Worksheet   xlWorkSheet  = null;
                Excel.Sheets      xlWorkSheets = null;

                xlApp = new Excel.Application();
                xlApp.DisplayAlerts = false;

                xlWorkBooks = xlApp.Workbooks;
                xlWorkBook  = xlWorkBooks.Open(fileName);

                xlApp.Visible = false;

                xlWorkSheets = xlWorkBook.Sheets;

                for (int x = 1; x <= xlWorkSheets.Count; x++)
                {
                    xlWorkSheet = (Excel.Worksheet)xlWorkSheets[x];

                    if (xlWorkSheet.Name == sheetName)
                    {
                        Excel.Range xlCells = null;
                        xlCells = xlWorkSheet.Cells;

                        Excel.Range workRange = xlCells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell);

                        RowsUsed = workRange.Row;
                        ColsUsed = workRange.Column;

                        Marshal.FinalReleaseComObject(workRange);
                        workRange = null;


                        Marshal.FinalReleaseComObject(xlCells);
                        xlCells = null;

                        break;
                    }

                    Marshal.FinalReleaseComObject(xlWorkSheet);
                    xlWorkSheet = null;
                }

                xlWorkBook.Close();
                xlApp.UserControl = true;
                xlApp.Quit();


                Release(xlWorkSheets);
                Release(xlWorkSheet);
                Release(xlWorkBook);
                Release(xlWorkBooks);
                Release(xlApp);

                return(new ExcelLast()
                {
                    Row = RowsUsed, Column = ColsUsed
                });
            }
            else
            {
                throw new Exception("'" + fileName + "' not found.");
            }
        }
Beispiel #23
0
        // 엑셀 파싱
        protected override bool Internal_Excel_Parsing(ChannelGoodInfo pChannelGoodInfo)
        {
            try
            {
                if (GoodsDownInfo_.ContainsKey(pChannelGoodInfo.Goods_Code_) == false)
                {
                    NewLogManager2.Instance.Log(string.Format("!! 상품 코드 엑셀이 없습니다. - {0}", pChannelGoodInfo.Goods_Code_));
                    return(false);
                }
                string filepath = GoodsDownInfo_[pChannelGoodInfo.Goods_Code_];
                Microsoft.Office.Interop.Excel.Application ap = null;
                Workbook  wb = null;
                Worksheet ws = null;
                HKExcelHelper.GetWorkSheet(filepath, ref ap, ref wb, ref ws);

                Range  tRange          = null;
                string tempString      = "";
                string comparesitename = "";

                Int32 nCurrentRow      = LQCrawlerInfo_.ExData_Start_;
                Int32 ExData_Option    = LQCrawlerInfo_.ExData_Option_;
                Int32 ExData_Coupncode = LQCrawlerInfo_.ExData_Coupncode_;
                Int32 ExData_Buyer     = LQCrawlerInfo_.ExData_Buyer_;
                Int32 ExData_Cancel    = LQCrawlerInfo_.ExData_Cancel_;

                Int32 ExData_Use         = LQCrawlerInfo_.ExData_Use_;
                Int32 ExData_Buyphone    = LQCrawlerInfo_.ExData_Buyphone_;
                Int32 ExData_Price       = LQCrawlerInfo_.ExData_Price_;
                Int32 ExData_BuyDate     = LQCrawlerInfo_.ExData_Buydate_;
                Int32 ExData_BuyCount    = LQCrawlerInfo_.ExData_Count_;
                Int32 ExData_GoodsName   = LQCrawlerInfo_.ExData_GoodName_;
                Int32 ExData_BasicColumn = 22;

                if (nCurrentRow > 0)
                {
                    ProcessStateManager.Instance.NeedParsingCount_ += (ws.UsedRange.Rows.Count - (nCurrentRow - 1));
                }

                while (true)
                {
                    try
                    {
                        tRange          = ws.Cells[nCurrentRow, 1];
                        comparesitename = Convert.ToString(tRange.Value2);

                        tRange = ws.Cells[nCurrentRow, ExData_Option];
                        if (tRange == null)
                        {
                            break;
                        }

                        tempString = tRange.Value2;


                        tRange = ws.Cells[nCurrentRow, ExData_BasicColumn];
                        string State = Convert.ToString(tRange.Value2);
                        if (State == "완료취소")
                        {
                            nCurrentRow++;
                            continue;
                        }
                        Int32      tempgoodSeq = -1;
                        COrderData pExcelData  = new COrderData();
                        pExcelData.channelSeq_            = LQCrawlerInfo_.Channel_Idx_;
                        pExcelData.authoritySeq_          = LQCrawlerInfo_.AuthoritySeq_;
                        pExcelData.goodsSeq_              = tempgoodSeq;
                        pExcelData.ExData_Option_         = tempString;
                        pExcelData.ExData_OptionOriginal_ = tempString;

                        tRange = ws.Cells[nCurrentRow, ExData_GoodsName];
                        pExcelData.ExData_GoodsName_ = tRange.Value2;
                        pExcelData.ExData_GoodsNick_ = Regex.Replace(pExcelData.ExData_GoodsName_, @"[^a-zA-Z0-9가-힣]", "");

                        tRange = ws.Cells[nCurrentRow, ExData_Coupncode];
                        if (tRange == null)
                        {
                            break;
                        }

                        pExcelData.channelOrderCode_ = Convert.ToString(tRange.Value2);
                        if (pExcelData.channelOrderCode_ == null)
                        {
                            break;
                        }
                        pExcelData.channelOrderCode_ = pExcelData.channelOrderCode_.Replace("'", "");
                        pExcelData.channelOrderCode_ = pExcelData.channelOrderCode_.Trim();   // 공백 제거

                        tRange = ws.Cells[nCurrentRow, ExData_Buyer];
                        pExcelData.orderName_ = Convert.ToString(tRange.Value2);
                        if (pExcelData.orderName_ == null)
                        {
                            pExcelData.orderName_ = "";
                        }

                        tRange = ws.Cells[nCurrentRow, ExData_Cancel];
                        pExcelData.ExData_Cancel_ = tRange.Value2;
                        if (pExcelData.ExData_Cancel_ == null)
                        {
                            pExcelData.ExData_Cancel_ = "";
                        }

                        tRange = ws.Cells[nCurrentRow, ExData_Use];
                        pExcelData.ExData_Use_ = tRange.Value2;
                        if (pExcelData.ExData_Use_ == null)
                        {
                            pExcelData.ExData_Use_ = "";
                        }

                        tRange = ws.Cells[nCurrentRow, ExData_Buyphone];
                        pExcelData.orderPhone_ = Convert.ToString(tRange.Value2);
                        if (pExcelData.orderPhone_ == null)
                        {
                            pExcelData.orderPhone_ = "";
                        }

                        pExcelData.orderPhone_ = pExcelData.orderPhone_.Replace("'", "");

                        if (ExData_Price != 0)
                        {
                            tRange = ws.Cells[nCurrentRow, ExData_Price];

                            if (tRange.Value2 != null)
                            {
                                // 돈에 , 가 있으면 제거하자.
                                tempString = Convert.ToString(tRange.Value2);
                                tempString = tempString.Replace(",", "");
                                pExcelData.orderSettlePrice_ = Convert.ToInt32(tempString);
                            }
                        }

                        tRange = ws.Cells[nCurrentRow, ExData_BuyDate];

                        double   temp = Convert.ToDouble(tRange.Value2);
                        DateTime dta  = DateTime.FromOADate(temp);
                        pExcelData.BuyDate_ = dta.ToString("u");
                        pExcelData.BuyDate_ = pExcelData.BuyDate_.Replace("Z", "");

                        if (ExData_BuyCount != 0)// 구매갯수를 따로 뽑아야 하는 채널에서만
                        {
                            tRange = ws.Cells[nCurrentRow, ExData_BuyCount];
                            pExcelData.BuyCount_ = Convert.ToInt32(tRange.Value2);
                        }

                        SplitDealAndInsertExcelData(pExcelData, comparesitename);
                    }
                    catch (System.Exception ex)
                    {
                        NewLogManager2.Instance.Log(string.Format("엑셀 파싱 에러 : {0}", ex.Message));
                        break;
                        //nCurrentRow++;
                        //continue;
                    }

                    ProcessStateManager.Instance.CurParsingCount_++;
                    nCurrentRow++;
                }

                wb.Close(false, Type.Missing, Type.Missing);
                ap.Quit();

                Marshal.FinalReleaseComObject(ws);
                Marshal.FinalReleaseComObject(wb);
                Marshal.FinalReleaseComObject(ap);
                ws = null;
                wb = null;
                ap = null;
                GC.Collect();
            }
            catch (System.Exception ex)
            {
                NewLogManager2.Instance.Log(string.Format("Error public override bool Internal_Excel_Parsing - {0}", ex.Message));
                return(false);
            }

            return(true);
        }
Beispiel #24
0
        /// <summary>
        /// Get last used column for a row
        /// </summary>
        /// <param name="fileName"></param>
        /// <param name="sheetName"></param>
        /// <param name="row"></param>
        /// <returns></returns>
        public int LastColumnForRow(string fileName, string sheetName, int row)
        {
            int lastColumn = -1;

            if (File.Exists(fileName))
            {
                Excel.Application xlApp        = null;
                Excel.Workbooks   xlWorkBooks  = null;
                Excel.Workbook    xlWorkBook   = null;
                Excel.Worksheet   xlWorkSheet  = null;
                Excel.Sheets      xlWorkSheets = null;

                xlApp = new Excel.Application();
                xlApp.DisplayAlerts = false;

                xlWorkBooks = xlApp.Workbooks;
                xlWorkBook  = xlWorkBooks.Open(fileName);

                xlApp.Visible = false;

                xlWorkSheets = xlWorkBook.Sheets;

                for (int x = 1; x <= xlWorkSheets.Count; x++)
                {
                    xlWorkSheet = (Excel.Worksheet)xlWorkSheets[x];

                    if (xlWorkSheet.Name == sheetName)
                    {
                        Excel.Range xlCells = null;
                        xlCells = xlWorkSheet.Cells;

                        Excel.Range workRange = xlCells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell);

                        Excel.Range xlColumns = xlWorkSheet.Columns;

                        int count = xlColumns.Count;

                        Marshal.FinalReleaseComObject(xlColumns);
                        xlColumns = null;

                        Excel.Range xlLastRange = (Excel.Range)xlWorkSheet.Cells[row, count];
                        Excel.Range xlDirRange  = xlLastRange.End[Excel.XlDirection.xlToLeft];

                        Marshal.FinalReleaseComObject(xlLastRange);
                        xlLastRange = null;

                        lastColumn = xlDirRange.Column;
                        Marshal.FinalReleaseComObject(xlDirRange);
                        xlDirRange = null;

                        Marshal.FinalReleaseComObject(workRange);
                        workRange = null;

                        Marshal.FinalReleaseComObject(xlCells);
                        xlCells = null;

                        break;
                    }

                    Marshal.FinalReleaseComObject(xlWorkSheet);
                    xlWorkSheet = null;
                }

                xlWorkBook.Close();
                xlApp.UserControl = true;
                xlApp.Quit();

                Release(xlWorkSheets);
                Release(xlWorkSheet);
                Release(xlWorkBook);
                Release(xlWorkBooks);
                Release(xlApp);

                return(lastColumn);
            }
            else
            {
                throw new Exception("'" + fileName + "' not found.");
            }
        }
Beispiel #25
0
 public void Initialize(IPluginSettings Settings) => Marshal.FinalReleaseComObject(Settings);
Beispiel #26
0
        /// <summary>
        /// 刻录
        /// </summary>
        public void Burn(string diskName = "SinoUnion")
        {
            if (!CanBurn)
            {
                throw new Exception("当前磁盘状态不支持刻录");
            }
            if (string.IsNullOrEmpty(diskName))
            {
                throw new Exception("DiskName不能为空");
            }
            if (BurnMediaList.Count <= 0)
            {
                throw new Exception("待刻录文件列表不能为空");
            }
            if (BurnMediaFileSize <= 0)
            {
                throw new Exception("待刻录文件大小为0");
            }

            try
            {   //说明
                //1.fsi.ChooseImageDefaults用的是IMAPI2FS的,我们定义的msRecorder是IMAPI2的.所以必须用动态类型
                //2.dataWriter也要使用动态类型,要不然Update事件会出异常.
                // Create an image stream for a specified directory.
                dynamic fsi = new IMAPI2FS.MsftFileSystemImage();           // Disc file system
                IMAPI2FS.IFsiDirectoryItem dir = fsi.Root;                  // Root directory of the disc file system
                dynamic dataWriter             = new MsftDiscFormat2Data(); //Create the new disc format and set the recorder

                dataWriter.Recorder   = msRecorder;
                dataWriter.ClientName = "SinoGram";
                //不知道这方法不用行不行.用的参数是IMAPI2FS的.
                //所以学官网的例子,把fsi改成了动态的.使用msRecorder作为参数
                fsi.ChooseImageDefaults(msRecorder);

                //设置相关信息
                fsi.VolumeName = diskName;   //刻录磁盘名称
                for (int i = 0; i < BurnMediaList.Count; i++)
                {
                    dir.AddTree(BurnMediaList[i].MediaPath, true);
                }
                // Create an image from the file system
                IStream stream = fsi.CreateResultImage().ImageStream;
                try
                {
                    dataWriter.Update += new DDiscFormat2DataEvents_UpdateEventHandler(BurnProgressChanged);
                    dataWriter.Write(stream);// Write stream to disc
                }
                catch (System.Exception ex)
                {
                    throw ex;
                }
                finally
                {
                    if (stream != null)
                    {
                        Marshal.FinalReleaseComObject(stream);
                    }
                }
            }
            catch (Exception ex)
            {
                Console.WriteLine($"刻录失败:{ex.Message}");
            }
        }
Beispiel #27
0
        private void CreateFSIFile(FileInfo file, IFsiDirectoryItem diritem)
        {
            var realpath = UniqueListFileSystemInfo.GetPhysicalPath(file.FullName);
            var index    = realpath.IndexOf(":\\") + 1;

            if (_sysImage.Exists(realpath.Substring(index)) == FsiItemType.FsiItemNotFound)
            {
                var crtdiritem = diritem;
                var name       = Path.GetFileName(realpath);
                if (string.Compare(diritem.FullPath, Path.GetDirectoryName(realpath).Substring(index), true) != 0)
                {
                    var fsipath = Path.GetDirectoryName(realpath).Substring(index + 1 + diritem.FullPath.Length);
                    var dirs    = fsipath.Split('\\');

                    var dInfo   = new DirectoryInfo(CaptureDirectory);
                    var subdirs = dInfo.FullName.Split('\\');
                    //MessageBox.Show(subdirs.Length.ToString());
                    //create the subdirs one by one
                    foreach (var dir in dirs.Skip(subdirs.Length - 1))
                    {
                        if (dir.Length == 0)
                        {
                            continue; //in the root like C:\
                        }
                        try
                        {
                            var newpath = string.Format("{0}\\{1}", crtdiritem.FullPath, dir);
                            if (_sysImage.Exists(newpath) != FsiItemType.FsiItemDirectory)
                            {
                                crtdiritem.AddDirectory(dir);
                            }
                        }
                        catch
                        {
                            Cancel = true;
                            throw;
                        }
                        crtdiritem = crtdiritem[dir] as IFsiDirectoryItem;
                    }
                }

                COMTypes.IStream newStream = null;

                try
                {
                    newStream = LoadCOMStream(realpath);
                    crtdiritem.AddFile(name, newStream);
                }
                finally
                {
                    Marshal.FinalReleaseComObject(newStream);
                }

                ActualSize += file.Length;
                if (Update != null && Update.GetInvocationList().Length > 0)
                {
                    Update(file.FullName, file.Length);
                }
            }
            else
            {
                throw new ApplicationException(realpath.Substring(index) +
                                               " occurs in multiple source folders with the same name.");
            }
        }
Beispiel #28
0
        private void SaveSettings()
        {
            using (var ms = new MemoryStream())
            {
                var bf = new BinaryFormatter();
                bf.Serialize(ms, _tempApplicationData.Bookmarks);
                ms.Position = 0;
                var buffer = new byte[(int)ms.Length];
                ms.Read(buffer, 0, buffer.Length);
                Properties.Settings.Default.SavedBookmarks = Convert.ToBase64String(buffer);
            }

            Properties.Settings.Default.Save();

            const string shortcutName    = "VagrantTray.lnk";
            var          startupPath     = Environment.GetFolderPath(Environment.SpecialFolder.Startup);
            var          startupShortcut = Path.Combine(startupPath, shortcutName);

            if (Properties.Settings.Default.LaunchOnWindowsStartup)
            {
                if (!File.Exists(startupShortcut))
                {
                    var     t     = Type.GetTypeFromCLSID(new Guid("72C24DD5-D70A-438B-8A42-98424B88AFB8")); //Windows Script Host Shell Object
                    dynamic shell = Activator.CreateInstance(t);
                    try
                    {
                        var lnk = shell.CreateShortcut(startupShortcut);
                        try
                        {
                            lnk.TargetPath   = System.Reflection.Assembly.GetExecutingAssembly().Location;
                            lnk.IconLocation = "shell32.dll, 1";
                            lnk.Save();
                        }
                        finally
                        {
                            Marshal.FinalReleaseComObject(lnk);
                        }
                    }
                    finally
                    {
                        Marshal.FinalReleaseComObject(shell);
                    }
                }
            }
            else if (File.Exists(startupShortcut))
            {
                File.Delete(startupShortcut);
            }

            var newBookmarks =
                _tempApplicationData.Bookmarks.Where(
                    b => !_applicationData.Bookmarks.Contains(b, new BookmarkEqualityComparer())).ToList();
            var removedBookmarks =
                _applicationData.Bookmarks.Where(
                    b => !_tempApplicationData.Bookmarks.Contains(b, new BookmarkEqualityComparer())).ToList();

            foreach (var removedBookmark in removedBookmarks)
            {
                _applicationData.Bookmarks.Remove(removedBookmark);
            }
            foreach (var newBookmark in newBookmarks)
            {
                _applicationData.Bookmarks.Add(newBookmark);
            }
        }
        private static Encoding DetectOutgoingEncoding(string input, int[] preferedEncodings, bool preserveOrder)
        {
            if (input == null)
            {
                throw new ArgumentNullException("input");
            }

            // empty strings can always be encoded as ASCII
            if (input.Length == 0)
            {
                return(Encoding.ASCII);
            }

            Encoding result = Encoding.ASCII;

            // get the IMultiLanguage3 interface
            MultiLanguage.IMultiLanguage3 multilang3 = new MultiLanguage.CMultiLanguageClass();
            if (multilang3 == null)
            {
                throw new System.Runtime.InteropServices.COMException("Failed to get IMultilang3");
            }
            try
            {
                int[]  resultCodePages   = new int[preferedEncodings != null ? preferedEncodings.Length : Encoding.GetEncodings().Length];
                uint   detectedCodepages = (uint)resultCodePages.Length;
                ushort specialChar       = (ushort)'?';


                // get unmanaged arrays
                IntPtr pPrefEncs     = preferedEncodings == null ? IntPtr.Zero : Marshal.AllocCoTaskMem(sizeof(uint) * preferedEncodings.Length);
                IntPtr pDetectedEncs = Marshal.AllocCoTaskMem(sizeof(uint) * resultCodePages.Length);

                try
                {
                    if (preferedEncodings != null)
                    {
                        Marshal.Copy(preferedEncodings, 0, pPrefEncs, preferedEncodings.Length);
                    }

                    Marshal.Copy(resultCodePages, 0, pDetectedEncs, resultCodePages.Length);

                    MultiLanguage.MLCPF options = MultiLanguage.MLCPF.MLDETECTF_VALID_NLS;
                    if (preserveOrder)
                    {
                        options |= MultiLanguage.MLCPF.MLDETECTF_PRESERVE_ORDER;
                    }

                    if (preferedEncodings != null)
                    {
                        options |= MultiLanguage.MLCPF.MLDETECTF_PREFERRED_ONLY;
                    }

                    MultiLanguage.HRESULT hres;

                    hres = multilang3.DetectOutboundCodePage(
                        options,
                        input,
                        (uint)input.Length,
                        pPrefEncs,
                        (uint)(preferedEncodings == null ? 0 : preferedEncodings.Length),
                        pDetectedEncs,
                        ref detectedCodepages,
                        ref specialChar);

                    if (hres != MultiLanguage.HRESULT.S_OK)
                    {
                        MessageBox.Show("Error 1 ! HRESULT=" + hres.ToString());
                    }

                    // get result
                    if (detectedCodepages > 0)
                    {
                        int[] theResult = new int[detectedCodepages];
                        Marshal.Copy(pDetectedEncs, theResult, 0, theResult.Length);
                        result = Encoding.GetEncoding(theResult[0]);
                    }
                }
                finally
                {
                    if (pPrefEncs != IntPtr.Zero)
                    {
                        Marshal.FreeCoTaskMem(pPrefEncs);
                    }
                    Marshal.FreeCoTaskMem(pDetectedEncs);
                }
            }
            finally
            {
                Marshal.FinalReleaseComObject(multilang3);
            }
            return(result);
        }
Beispiel #30
0
        static void loadExcel(string file, int startrow, int endrow)
        {
            Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();
            excel.Visible = true;
            excel.Visible = false;

            Excel.Workbook  theWorkbook;
            Excel.Worksheet worksheet;


            theWorkbook = excel.Workbooks.Open(file,
                                               Type.Missing, Type.Missing, 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 = theWorkbook.Worksheets[1];
            Excel.Range range;
            int         succeeded = 0;
            int         failed    = 0;

            for (int row = startrow; row <= endrow; row++)
            {
                GeoPoint locPoint = new GeoPoint();
                string   cellName;
                //check if there is already a house has the same code name if so skip it
                cellName = "A" + row.ToString();
                range    = worksheet.get_Range(cellName, Missing.Value);
                string codeName = range.Value2.ToString();
                var    tId      = Guid.Empty;
                if (houseService.HouseExistByCodeName(codeName))
                {
                    tId = houseService.FindHouseByCodeName(codeName).Id;
                    Console.WriteLine("house exists");
                }
                //check if it has a name if not skip if
                cellName = "B" + row.ToString();
                range    = worksheet.get_Range(cellName, Missing.Value);
                string houseName = range.Value2.ToString();
                if (string.IsNullOrEmpty(houseName))
                {
                    Console.WriteLine("no house name, skip");
                    failed++;
                    continue;
                }
                //chekck if the location is validte if not skip
                cellName = "C" + row.ToString();
                string location = worksheet.get_Range(cellName, Missing.Value).Value2.ToString();
                try
                {
                    locPoint = HouseService.GetGeoPoint(location);
                }
                catch
                {
                    failed++;
                    Console.WriteLine("invalid location, skip");
                    continue;
                }
                //all check noe build a house
                //user the code name to locate the photo folder
                var path   = file.Substring(0, file.LastIndexOf(@"\") + 1) + @"photo\" + codeName;
                var photos = new List <string>();
                try
                {
                    photos = getPhotos(path, codeName).ToList <string>();
                }
                catch
                {
                    Console.WriteLine("no photo");
                }

                DateTime year = DateTime.Parse("0001 06 06");
                try
                {
                    year = DateTime.Parse(worksheet.get_Range("I" + row.ToString(), Missing.Value).Value2.ToString() + " 06 01");
                }
                catch
                {
                    //no build year
                }
                House newHouse = new House
                {
                    CodeName       = codeName,
                    Name           = houseName,
                    Images         = photos.Any() ? photos : null,
                    Cover          = photos.Any() ? photos[0] : null,
                    Location       = locPoint,
                    LocationString = worksheet.get_Range("D" + row.ToString(), Missing.Value).Value2.ToString(),
                    Abstarct       = worksheet.get_Range("E" + row.ToString(), Missing.Value).Value2.ToString(),
                    Country        = worksheet.get_Range("F" + row.ToString(), Missing.Value).Value2.ToString(),
                    Province       = worksheet.get_Range("G" + row.ToString(), Missing.Value).Value2.ToString(),
                    City           = worksheet.get_Range("H" + row.ToString(), Missing.Value).Value2.ToString(),
                    //BuiltYear = year,
                    //Condition = worksheet.get_Range("K" + row.ToString(), Missing.Value).Value2.ToString(),
                    //historica , photo value is not fixed yet
                    Description = worksheet.get_Range("P" + row.ToString(), Missing.Value).Value2.ToString(),
                };
                newHouse.AddExtraInformation("houseinfo-condition", worksheet.get_Range("K" + row.ToString(), Missing.Value).Value2.ToString());
                newHouse.AddExtraInformation("houseinfo-buildyear", year.Year);
                string tagString;
                try
                {
                    tagString     = worksheet.get_Range("L" + row.ToString(), Missing.Value).Value2.ToString();
                    newHouse.Tags = tagString.Split(';').ToList <string>();
                }
                catch (Exception)
                {
                    newHouse.Tags = null;
                }

                var extra = worksheet.get_Range("Q" + row.ToString(), Missing.Value).Value2;
                if (extra != null)
                {
                    string extraStr = extra.ToString();
                    getExtra(extraStr, newHouse);
                }
                if (tId == Guid.Empty)
                {
                    houseService.InsertOne(newHouse);
                    succeeded++;
                    Console.WriteLine("house added: " + codeName);
                }
                else
                {
                    newHouse.Id = tId;
                    houseService.SaveOne(newHouse);
                    succeeded++;
                    Console.WriteLine("house updated: " + codeName);
                }
            }
            //clean up

            theWorkbook.Close(false, Type.Missing, Type.Missing);
            Marshal.ReleaseComObject(theWorkbook);

            excel.Quit();
            Marshal.FinalReleaseComObject(excel);
            Console.WriteLine("succeeded:" + succeeded);
            Console.WriteLine("failed:" + failed);
        }