private void PreencheGrid()
{
OleDbDataReader dr;
cConexao.cConexao cnn = new cConexao.cConexao();
string sSql = "SP_GERADOR_SEARCH @ACTION='D'";
dr = cnn.Oledb_Pesquisa(sSql);
cboGerador.Items.Add("TODOS");
while (dr.Read())
{
cboGerador.Items.Add(dr["FAN_GERADOR_FIL"].ToString());
}
cboGerador.SelectedIndex = 0;
}
public void ImpTicket(OleDbDataReader dr, string Tipo)
{
string sSql;
string str;
string[] strArrays;
int num;
int num1;
int num2;
int num3;
int num4;
int num5;
int num6;
cConexao.cConexao cnn = new cConexao.cConexao();
int i = 0;
int iRes = 0;
int iRes1 = 0;
int iQtdImp = 0;
int iCont = 0;
decimal dX = new decimal(0);
string sX = "";
string sDtSaida = "";
string sSetor = "";
string sPesoSaida = "";
string sNumTicket = "";
string sObs = "";
string sNumLab = "";
string sGerador = "";
string sCliente = "";
double dPesoEnt = 0;
double dPesoLiq = 0;
string[] sResiduo = new string[10];
if (dr.Read())
{
if (!(Tipo == "R"))
{
sSql = string.Concat("EXEC SP_BALANCA_IMP_TICKET ", dr["CD_CONTROLE_LAB"].ToString(), " , ");
str = sSql;
strArrays = new string[] { str, "'", dr["CNPJ_CPF_GERADOR"].ToString(), "', 'R', ", dr["ID_ENT_BALANCA"].ToString() };
sSql = string.Concat(strArrays);
}
else
{
sSql = string.Concat("EXEC SP_BALANCA_IMP_TICKET ", dr["CD_CONTROLE_LAB"].ToString(), " , ");
str = sSql;
strArrays = new string[] { str, "'", dr["CNPJ_CPF_GERADOR"].ToString(), "', 'H', ", dr["ID_ENT_BALANCA"].ToString() };
sSql = string.Concat(strArrays);
}
OleDbDataReader dr1 = cnn.Oledb_Pesquisa(sSql);
while (dr1.Read())
{
sObs = dr1["OBS_BAL_SAIDA"].ToString();
iQtdImp = Convert.ToInt16(dr1["QTDE_IMP_TICKET"].ToString());
sSetor = dr1["SETOR"].ToString();
sDtSaida = dr1["DT_SAIDA"].ToString();
sResiduo[iRes] = string.Concat(dr1["CD_RESIDUO"].ToString().Trim(), " - ", dr1["DESC_RESIDUO1"].ToString().Trim());
sNumTicket = dr1["NUM_TICKET"].ToString();
sNumLab = dr1["CD_CONTROLE_LAB"].ToString();
sGerador = dr1["FAN_GERADOR_FIL"].ToString();
sCliente = dr1["CLIENTE"].ToString();
if (Convert.ToDouble(dr1["PESO_RATEIO"].ToString()) <= 0)
{
dPesoEnt = dPesoEnt + Convert.ToDouble(dr1["PESO_MANUAL"].ToString());
dPesoLiq = dPesoLiq + Convert.ToDouble(dr1["PESO_MANUAL"].ToString());
}
else
{
dPesoEnt = dPesoEnt + Convert.ToDouble(dr1["PESO_RATEIO"].ToString());
dPesoLiq = dPesoLiq + Convert.ToDouble(dr1["PESO_RATEIO"].ToString());
}
iRes++;
}
sPesoSaida = (Convert.ToDouble(dr["PESO_BRUTO_BALNACA_ENTRADA"].ToString()) <= 0 ? dr["PESO_TARA_MANU_ENTRADA"].ToString() : dr["PESO_TARA_BALANCA_ENTRADA"].ToString());
dPesoEnt = dPesoEnt + Convert.ToDouble(sPesoSaida);
string sPesoEnt = Convert.ToString(dPesoEnt);
string sPesoLiq = Convert.ToString(dPesoLiq);
sPesoSaida = Convert.ToString(Convert.ToDouble(sPesoSaida));
for (i = 0; i < iQtdImp; i++)
{
dX = new decimal(0);
this.IncluirTextoImpressao("PROACTIVA MEIO AMBIENTE BRASIL LTDA", Convert.ToString(dX), "0,2");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
this.IncluirTextoImpressao("CGA - IPERO", sX.Replace(".", ","), "3");
dX = dX + Convert.ToDecimal("1");
sX = Convert.ToString(dX);
if (!(sSetor != "0"))
{
this.IncluirTextoImpressao(string.Concat("N Ticket: ", sNumTicket, " N Lab.: ", sNumLab), sX.Replace(".", ","), "0");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
}
else
{
strArrays = new string[] { "N Ticket: ", sNumTicket, " N Lab.: ", sNumLab, " Setor: ", sSetor };
this.IncluirTextoImpressao(string.Concat(strArrays), sX.Replace(".", ","), "0");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
}
this.IncluirTextoImpressao(string.Concat("Cliente: ", sCliente), sX.Replace(".", ","), "0");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
this.IncluirTextoImpressao(string.Concat("Gerador: ", sGerador), sX.Replace(".", ","), "0");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
this.IncluirTextoImpressao(string.Concat("Transp: ", dr["FAN_TRANSPORTADOR"].ToString()), sX.Replace(".", ","), "0");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
this.IncluirTextoImpressao(string.Concat("Placa do Veículo: ", dr["PLACA_TRANSPORTADOR"].ToString()), sX.Replace(".", ","), "0");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
this.IncluirTextoImpressao(string.Concat("Motorista: ", dr["NOM_MOTORISTA"].ToString()), sX.Replace(".", ","), "0");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
this.IncluirTextoImpressao("Resíduo: ", sX.Replace(".", ","), "0");
for (iRes1 = 0; iRes1 < iRes; iRes1++)
{
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
string str1 = sResiduo[iRes1] ?? "";
this.IncluirTextoImpressao(str1, sX.Replace(".", ","), "1");
}
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
this.IncluirTextoImpressao(string.Concat("Data Entrada: ", dr["DT_ENTRADA"].ToString()), sX.Replace(".", ","), "0");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
this.IncluirTextoImpressao(string.Concat("Peso Entrada(kg): ", sPesoEnt), sX.Replace(".", ","), "0");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
this.IncluirTextoImpressao(string.Concat("Data Saída: ", sDtSaida), sX.Replace(".", ","), "0");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
this.IncluirTextoImpressao(string.Concat("Peso Saída(kg): ", sPesoSaida), sX.Replace(".", ","), "0");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
this.IncluirTextoImpressao(string.Concat("Peso Líquido(kg): ", sPesoLiq), sX.Replace(".", ","), "0");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
if (sObs.Length > 1)
{
num6 = (sObs.Length > 26 ? 26 : sObs.Length);
iCont = num6;
this.IncluirTextoImpressao(string.Concat("Obs: ", sObs.Substring(0, iCont).ToString()), sX.Replace(".", ","), "0");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
sObs = (sObs.Length <= iCont + 1 ? "" : sObs.Substring(iCont + 1).ToString());
}
if (sObs.Length > 1)
{
num5 = (sObs.Length > 32 ? 32 : sObs.Length);
iCont = num5;
this.IncluirTextoImpressao(sObs.Substring(0, iCont).ToString(), sX.Replace(".", ","), "0,5");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
sObs = (sObs.Length <= iCont + 1 ? "" : sObs.Substring(iCont + 1).ToString());
}
if (sObs.Length > 1)
{
num4 = (sObs.Length > 32 ? 32 : sObs.Length);
iCont = num4;
this.IncluirTextoImpressao(sObs.Substring(0, iCont).ToString(), sX.Replace(".", ","), "0,5");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
sObs = (sObs.Length <= iCont + 1 ? "" : sObs.Substring(iCont + 1).ToString());
}
if (sObs.Length > 1)
{
num3 = (sObs.Length > 32 ? 32 : sObs.Length);
iCont = num3;
this.IncluirTextoImpressao(sObs.Substring(0, iCont).ToString(), sX.Replace(".", ","), "0,5");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
sObs = (sObs.Length <= iCont + 1 ? "" : sObs.Substring(iCont + 1).ToString());
}
if (sObs.Length > 1)
{
num2 = (sObs.Length > 32 ? 32 : sObs.Length);
iCont = num2;
this.IncluirTextoImpressao(sObs.Substring(0, 32).ToString(), sX.Replace(".", ","), "0,5");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
sObs = (sObs.Length <= iCont + 1 ? "" : sObs.Substring(iCont + 1).ToString());
}
if (sObs.Length > 1)
{
num1 = (sObs.Length > 32 ? 32 : sObs.Length);
iCont = num1;
this.IncluirTextoImpressao(sObs.Substring(0, iCont).ToString(), sX.Replace(".", ","), "0,5");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
sObs = (sObs.Length <= iCont + 1 ? "" : sObs.Substring(iCont + 1).ToString());
}
if (sObs.Length > 1)
{
num = (sObs.Length > 32 ? 32 : sObs.Length);
iCont = num;
this.IncluirTextoImpressao(sObs.Substring(0, iCont).ToString(), sX.Replace(".", ","), "0,5");
dX = dX + Convert.ToDecimal("0,5");
sX = Convert.ToString(dX);
sObs = (sObs.Length <= iCont + 1 ? "" : sObs.Substring(iCont + 1).ToString());
}
this.IncluirTextoImpressao("Ass. Balanceiro:_____________________", sX.Replace(".", ","), "0");
dX = dX + Convert.ToDecimal("1");
sX = Convert.ToString(dX);
this.IncluirTextoImpressao("Conf. Balanceiro:____________________", sX.Replace(".", ","), "0");
dX = dX + Convert.ToDecimal("1");
sX = Convert.ToString(dX);
this.IncluirTextoImpressao("Ass. Motorista:______________________", sX.Replace(".", ","), "0");
this.Imprimir();
}
}
}
