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