예제 #1
0
 protected void btnGenerate_Click(object sender, EventArgs e)
 {
     try
     {
         string cmpconumeracaodocumento = "";
         tblNumeracaoDocumento tbl      = new tblNumeracaoDocumento();
         tbl.cmpCoNumeracaoDocumento = ViewState["cmpCoNumeracaoDocumento"] == null ? "0" : ViewState["cmpCoNumeracaoDocumento"].ToString();
         tbl.cmpCoFuncionario        = cmbPessoal.SelectedItem.Value;
         tbl.cmpCoObra          = cmbObra.SelectedItem.Value;
         tbl.cmpCoTipoNumeracao = cmbTipoGerar.SelectedItem.Value;
         tbl.cmpTxObservacoes   = txtDescription.Text;
         //tbl.cmpNoFornecedor = cmbFornecedor.SelectedItem.Value == "0" ? txtFornecedor.Text : cmbFornecedor.SelectedItem.Text;
         tbl.cmpDcDocumento = "";
         string numero = tbl.Save((HzConexao)HttpContext.Current.Session["connection"], ref cmpconumeracaodocumento);
         lblNovoNumero.Text = "O número gerado foi: " + numero;
         this.reset();
         Response.Redirect("WebNovoDocumento.aspx?cmpNuDocumento=" + numero, false);
     }
     catch (Exception ex)
     {
         string       s = ex.Message;
         StreamWriter w = new StreamWriter("c:\\svn\\orion\\errorona" + DateTime.Now.Day.ToString() + "_" + DateTime.Now.Month.ToString() + "_" + DateTime.Now.Hour.ToString() + ".txt");
         w.WriteLine(ex.Message);
         w.Close();
         w = null;
     }
 }
예제 #2
0
        protected void btnCartaOrion_Click(object sender, EventArgs e)
        {
            if (Gravar())
            {
                load();
                DateTime dated;
                dated = DateTime.Now;
                CCWordApp DocWord = new CCWordApp();

                try
                {
                    CultureInfo        culture = new CultureInfo("pt-BR");
                    DateTimeFormatInfo dtfi    = culture.DateTimeFormat;

                    int    dia       = DateTime.Now.Day;
                    int    ano       = DateTime.Now.Year;
                    string mes       = culture.TextInfo.ToTitleCase(dtfi.GetMonthName(DateTime.Now.Month));
                    string diasemana = culture.TextInfo.ToTitleCase(dtfi.GetDayName(DateTime.Now.DayOfWeek));
                    string data      = diasemana + ", " + dia + " de " + mes + " de " + ano;

                    CNumeroPorExtenso ValorExtenso = new CNumeroPorExtenso();
                    ValorExtenso.SetNumero(Convert.ToDecimal(txtValorNota.Text.Replace(".", ",")));

                    #region Numerar documento
                    string cmpconumeracaodocumento = "";
                    tblNumeracaoDocumento tbl      = new tblNumeracaoDocumento();
                    if (string.IsNullOrEmpty(txtNumeroDoc.Text))
                    {
                        tbl.cmpCoNumeracaoDocumento = "0";
                        tbl.cmpCoFuncionario        = "47"; //Departamento Faturamento
                        tbl.cmpCoObra          = "23";      //Escritório GrupoOrion
                        tbl.cmpIdObraFatura    = ViewState["cmpIdObraFatura"].ToString();
                        tbl.cmpCoTipoNumeracao = ViewState["cmpCoTipoNumeracao"].ToString();
                        tbl.cmpTxObservacoes   = "Carta de entrega de NF " + txtNuNotaFiscal.Text.ToString() + " R$ " + txtValorNota.Text.ToString() +
                                                 " referente a " + ViewState["cmpNuMesFatura"].ToString() + "/" + ViewState["cmpNuAnoFatura"].ToString() +
                                                 " " + lblNomeObra.Text.ToString();
                        tbl.cmpDcDocumento = "";
                        tbl.cmpNoUsuario   = ((HzLibGeneral.Util.HzLogin)Session["login"]).cmpNoUsuario.TrimEnd();
                        txtNumeroDoc.Text  = tbl.Save(Global.GetConnection(), ref cmpconumeracaodocumento);
                    }
                    #endregion

                    DocWord.Open(ConfigurationManager.AppSettings["WordMod"] + "Modelo de Carta Orion.dot");

                    DocWord.GotoBookMark("Numero_Doc");
                    DocWord.SetAlignment("Right");
                    DocWord.InsertText(txtNumeroDoc.Text.ToString());
                    DocWord.SetFont("nothing");

                    DocWord.GotoBookMark("Data_Carta");
                    DocWord.SetAlignment("Right");
                    DocWord.InsertText(data);
                    DocWord.SetFont("nothing");

                    string NomeDestinatario = "";
                    if (!string.IsNullOrEmpty(txtNomeDestinatario.Text))
                    {
                        NomeDestinatario = "Ilmo(a). Sr(a). " + txtNomeDestinatario.Text;
                    }

                    DocWord.GotoBookMark("Nome_Destino");
                    DocWord.SetFont("Bold");
                    DocWord.InsertText(NomeDestinatario);
                    DocWord.SetFont("nothing");

                    DocWord.GotoBookMark("Nome_Orgao");
                    DocWord.InsertText(txtNomeOrgao.Text);
                    DocWord.SetFont("nothing");

                    DocWord.GotoBookMark("Data_Inicial");
                    DocWord.InsertText(txtDataInicial.Text);

                    DocWord.GotoBookMark("Data_Final");
                    DocWord.InsertText(txtDataFinal.Text);

                    DocWord.GotoBookMark("Numero_Contrato");
                    DocWord.InsertText(ViewState["cmpNuContrato"].ToString().TrimEnd());

                    DocWord.GotoBookMark("Data_Emissao_Nota");
                    DocWord.InsertText(txtEmissaoNota.Text.ToString());

                    DocWord.GotoBookMark("Tipo_Servico");
                    DocWord.InsertText(txtNomeServico.Text.ToString());

                    DocWord.GotoBookMark("Numero_Nota");
                    DocWord.InsertText(txtNuNotaFiscal.Text);

                    DocWord.GotoBookMark("Valor_Nota");
                    string ValorNota = txtValorNota.Text.Replace(".", "");
                    DocWord.InsertText(Convert.ToDecimal(ValorNota).ToString("#,##0.00"));

                    DocWord.GotoBookMark("Valor_NotaExtenso");
                    DocWord.InsertText(ValorExtenso.ToString());

                    ArrayList list = new ArrayList();
                    list.Add("Anexo1");
                    list.Add("Anexo2");
                    list.Add("Anexo3");
                    list.Add("Anexo4");
                    list.Add("Anexo5");
                    list.Add("Anexo6");
                    list.Add("Anexo7");
                    list.Add("Anexo8");
                    list.Add("Anexo9");
                    list.Add("Anexo10");

                    int i = 0;
                    foreach (ListItem item in lstDocAnexo.Items)
                    {
                        DocWord.GotoBookMark(list[i].ToString());
                        DocWord.InsertText("-" + item.Text);
                        i++;
                    }

                    DocWord.InsertLineBreak();

                    DocWord.SaveAs(ConfigurationManager.AppSettings["WordDoc"] + "CO" + txtNumeroDoc.Text.Replace("/", "-") + " " + lblNomeObra.Text.ToString() + ".doc");
                    DocWord.Quit();

                    #region Grava nome do arquivo na tabela de documentos
                    if (string.IsNullOrEmpty(txtNumeroDoc.Text))
                    {
                        tbl.cmpCoNumeracaoDocumento = cmpconumeracaodocumento;
                        tbl.cmpDcDocumento          = ConfigurationManager.AppSettings["WordDoc"].ToString() + " CO" + txtNumeroDoc.Text.Replace("/", "-") + " " + lblNomeObra.Text.ToString() + ".doc";
                        tbl.Save(Global.GetConnection(), ref cmpconumeracaodocumento);
                    }
                    #endregion

                    #region gravar data e número da carta orion
                    tblFaturaObra table = new tblFaturaObra();
                    table.cmpIdFaturaObra  = ViewState["idFaturaObra"].ToString();
                    table.cmpEdCartaoOrion = ConfigurationManager.AppSettings["WordDoc"].ToString() + " CO" + txtNumeroDoc.Text.Replace("/", "-") + " " + lblNomeObra.Text.ToString() + ".doc";
                    table.cmpNuCartaOrion  = txtNumeroDoc.Text.ToString();
                    table.cmpNoUsuario     = ((HzLibGeneral.Util.HzLogin)Session["login"]).cmpNoUsuario.TrimEnd();
                    table.GravarCartaOrionFatura(Global.GetConnection());
                    load();
                    #endregion

                    Response.Clear();
                    Response.ContentType = "application/msword";
                    Response.AddHeader("Content-disposition", "filename=" + ConfigurationManager.AppSettings["WordDoc"] + "CO" + txtNumeroDoc.Text.Replace("/", "-") + " " + lblNomeObra.Text.ToString() + ".doc");
                    Response.WriteFile(ConfigurationManager.AppSettings["WordDoc"] + "CO" + txtNumeroDoc.Text.Replace("/", "-") + " " + lblNomeObra.Text.ToString() + ".doc");
                    Response.End();

                    //Response.Write("<script language='javascript'>"
                    //            + "window.open('" + Global.UrlDocWord + "CO" + txtNumeroDoc.Text.Replace("/", "-") + " " + lblNomeObra.Text.ToString() + ".doc" + "', '_blank', 'width=850, height=600, menubar=no, resizable=yes, scrollbars=yes, top=35, left=105')"
                    //            + "</script>");
                }
                catch (Exception ex)
                {
                    DocWord.Quit();
                    MsgBox.ShowMessage(ex.ToString(), "Erro");
                }
            }
        }