protected void btnSaveFatura_Click(object sender, EventArgs e)
{
if (ViewState["AberturaFaturamento"].ToString() == "true")
{
if (ValidarCampos(ViewState["AberturaFaturamento"].ToString()))
{
tblFaturaObra table = new tblFaturaObra();
table.cmpNuAnoFatura = cmbAnoAbertura.SelectedValue.ToString();
table.cmpNuMesFatura = cmbMesAbertura.SelectedValue.ToString();
table.cmpDtPrevEmissaoNota = txtDtEmissaoNota.Text.ToString();
table.cmpDtPrevEntregaDocObra = txtDtEntregaDoc.Text.ToString();
table.cmpDtPrevRecebeNota = TxtDtRecFatura.Text.ToString();
table.cmpNoUsuario = ((HzLibGeneral.Util.HzLogin)Session["login"]).cmpNoUsuario.TrimEnd();
table.FaturamentoAbertura(Global.GetConnection());
MsgBox.ShowMessage("Faturamento aberto com sucesso!", "Aviso");
gvDados.DataSource = pesquisa();
gvDados.DataBind();
}
else
{
this.ModalPopupExtender2.Show();
}
}
else
{
if (ViewState["cmpTpFatura"].ToString() == "1" ? ValidarCampos(ViewState["AberturaFaturamento"].ToString()) : true)
{
try
{
tblFaturaObra table = new tblFaturaObra();
table.cmpIdFaturaObra = ViewState["cmpIdFaturaObra"].ToString();
table.cmpDtPrevEmissaoNota = txtDtEmissaoNota.Text.ToString();
table.cmpDtPrevEntregaDocObra = txtDtEntregaDoc.Text.ToString();
table.cmpDtPrevRecebeNota = TxtDtRecFatura.Text.ToString();
table.cmpInEmiteNotaMes = ChkEmissaoNota.Checked.ToString();
table.cmpNoUsuario = ((HzLibGeneral.Util.HzLogin)Session["login"]).cmpNoUsuario.TrimEnd();
table.GravarAberturaFaturamento(Global.GetConnection());
MsgBox.ShowMessage("Registro atualizado com sucesso!", "Aviso");
btnPesquisar_Click(sender, e);
}
catch (Exception ex)
{
Global.ShowError(Global.Title, ex);
}
}
else
{
this.ModalPopupExtender2.Show();
}
}
}
private bool Gravar()
{
bool ret = false;
if (ValidarCampos())
{
tblFaturaObra table = new tblFaturaObra();
table.cmpIdFaturaObra = ViewState["idFaturaObra"].ToString();
table.cmpNoDestinoCarta = txtNomeDestinatario.Text;
table.cmpNoOrgaoDestinoCarta = txtNomeOrgao.Text;
table.cmpDtPeriodoInicialServico = txtDataInicial.Text + " 00:00";
table.cmpDtPeriodoFinalServico = txtDataFinal.Text + " 00:00";
table.cmpNuNotaFiscal = txtNuNotaFiscal.Text;
table.cmpDtEmissaoNotaFiscal = txtEmissaoNota.Text + " 00:00";
table.cmpVlNota = txtValorNota.Text.Replace(",", ".");
table.cmpEdEmailEng = txtEmailEng.Text;
table.cmpEdEmailAuxAdm = txtEmailAux.Text;
table.cmpNoUsuario = ((HzLibGeneral.Util.HzLogin)Session["login"]).cmpNoUsuario.TrimEnd();
ret = table.Save(Global.GetConnection());
}
return(ret);
}
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");
}
}
}
