private void btImprimir_Click(object sender, EventArgs e)
{
//System.Drawing.Image objImage = System.Drawing.Image.FromFile(pic1.ImageLocation);
DataRow drCli;
string vWhere = " Empresa = " + cParamXml.Emp + " and codcli = '" + txCodCli.Text + "' ";
drCli = cUtil.fncTraeCampos("GC_ClienteProducto", vWhere, cParamXml.strConec, "SQL");
string vEtiCli = "";
string vEt = "";
if (drCli != null)
{
vEt = drCli["EtiCli"].ToString();
if (vEt == "1")
{
vEtiCli = drCli["EtiDes"].ToString();
if (vEtiCli == "")
{
vEtiCli = txNomCli.Text;
}
}
}
string vLogoCaja = cProducto.Articulo.fncTraeC("LogoCaja", txProd.Text);
bool vConLogo = true;
if (vLogoCaja == "0")
{
vConLogo = false;
}
dtsEtiCaja dts = new dtsEtiCaja();
DataTable dt = new DataTable();
dt = dts.Tables["dtEtiCaja"].Clone();
DataRow dr = dt.NewRow();
dr.BeginEdit();
dr["Producto"] = txProd.Text;
dr["Cliente"] = txNomCli.Text;
dr["Pieza"] = txProdCli.Text;
dr["DesProd"] = txNomProd.Text;
dr["Lote"] = txLote.Text;
if (txPiezasCaja.Text == "")
{
txPiezasCaja.Text = "0";
}
dr["PiezasCaja"] = Convert.ToInt32(txPiezasCaja.Text);
dr["Fecha"] = dateFecha.Value;
dr["Operario"] = txOper.Text;
if (txCaja.Text == "")
{
txCaja.Text = "0";
}
dr["Caja"] = txCaja.Text;
dr["Imagen"] = cUtil.imageToByteArray(pic1.Image);
dr["EtiCliente"] = vEtiCli;
dr.EndEdit();
dt.Rows.Add(dr);
int vAncho = 1;
int vAlto = 1;
if (pic1.Image != null)
{
vAncho = pic1.Image.Width;
vAlto = pic1.Image.Height;
}
//if (vAncho >= vAlto)
//{
// vAlto = vAlto * 720 / vAncho;
// vAncho = 720;
//}
//else
//{
// vAncho = vAncho * 840 / vAlto;
// vAlto = 840;
//}
cInformes.Imp = (cParamXml.Imp == "True") ? true : false;
cInformes.sbrEtiCaja(dt, vAlto, vAncho, vEt, vConLogo);
}
private void btPrinEti_Click(object sender, EventArgs e)
{
if (grProduc.Rows.Count == 0)
{
MessageBox.Show("No hay Cajas/Bolsas para imprimir"); return;
}
if (grProduc.SelectedRows.Count == 0)
{
MessageBox.Show("No se selecionado ninguna fila para imprimir"); return;
}
string vNomCli = lbNomCli.Text;
string vProd = txProd.Text;
string vNomProd = lbNomProd.Text;
string vNOF = txOF.Text;
string vProdCli = txProdCli.Text;
DataRow drCli;
string vWhere = " Empresa = " + cParamXml.Emp + " and codcli = '" + txCodCli.Text + "' ";
drCli = cUtil.fncTraeCampos("GC_ClienteProducto", vWhere, cParamXml.strConec, "SQL");
string vLogoCaja = cProducto.Articulo.fncTraeC("LogoCaja", vProd);
bool vConLogo = true;
if (vLogoCaja == "0")
{
vConLogo = false;
}
string vEtiCli = "";
string vEt = "";
if (drCli != null)
{
vEt = drCli["EtiCli"].ToString();
if (vEt == "1")
{
vEtiCli = drCli["EtiDes"].ToString();
if (vEtiCli == "")
{
vEtiCli = vNomCli;
}
}
}
foreach (DataGridViewRow dr in grProduc.SelectedRows)
{
string vFecha = Convert.ToDateTime(dr.Cells["Fecha"].Value.ToString()).ToShortDateString();
string vOper = cUtil.Piece(dr.Cells["IdOper"].Value.ToString(), "-", 1);
string vCaja = dr.Cells["NumCajaBolsa"].Value.ToString();
string vPiezasCaja = dr.Cells["CanProd"].Value.ToString();
string vTipo = dr.Cells["Tipo"].Value.ToString();
string vCodigo = dr.Cells["codigo"].Value.ToString();
string vsNumCajaBolsa = "";
if (vTipo != "B")
{
vsNumCajaBolsa = vCaja.ToString();
}
else
{
vsNumCajaBolsa = vCodigo;
}
dtsEtiCaja dts = new dtsEtiCaja();
DataTable dt = new DataTable();
dt = dts.Tables["dtEtiCaja"].Clone();
DataRow dr2 = dt.NewRow();
dr2.BeginEdit();
dr2["Producto"] = vProd;
dr2["Cliente"] = vNomCli;
dr2["Pieza"] = vProdCli;
dr2["DesProd"] = vNomProd;
dr2["Lote"] = vNOF;
if (vPiezasCaja == "")
{
vPiezasCaja = "0";
}
dr2["PiezasCaja"] = Convert.ToInt32(vPiezasCaja);
dr2["Fecha"] = Convert.ToDateTime(dr.Cells["Fecha"].Value.ToString());
dr2["Operario"] = vOper;
if (vsNumCajaBolsa == "")
{
vsNumCajaBolsa = "0";
}
dr2["Caja"] = vsNumCajaBolsa;
dr2["Imagen"] = cUtil.imageToByteArray(picFoto.Image);
dr2["EtiCliente"] = vEtiCli;
dr2.EndEdit();
dt.Rows.Add(dr2);
int vAncho = 1;
int vAlto = 1;
if (picFoto.Image != null)
{
vAncho = picFoto.Image.Width;
vAlto = picFoto.Image.Height;
}
cInformes.Imp = (cParamXml.Imp == "True") ? true : false;
cInformes.sbrEtiCaja(dt, vAlto, vAncho, vEt, vConLogo);
//cInformes.sbrEtiCaja(vNomCli, vProd, vNomProd, vNOF, vPiezasCaja, vFecha, vOper, vCaja,vProdCli);
}
}
