public int DInsertDetReq(EReqDetalle eReqDet, string tabla)
{
int i = 0;
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
string sql = "INSERT INTO " + tabla + " " +
" (A12STT, A12NSA, A12NIT, A12COD, A12CCA, " +
" A12PRO, A12CTA, A12CAS, A12CAD, A12IMP, " +
" A12IMD, A12EST, A12NVS, A12FVS, A12HVS, A12UDE) " +
" VALUES " +
" ('" + eReqDet.Situacion + "', '" + eReqDet.NroReqSalida + "', " + eReqDet.NroItem + ", '" + eReqDet.CodMatPrima + "', " + eReqDet.CtaCargo + ", " +
" " + eReqDet.Procedencia + ", " + eReqDet.CtaAlmacen + ", " + eReqDet.CantidadSoli + ", " + eReqDet.CantidadAte + ", " + eReqDet.ImpSoles + ", " +
" " + eReqDet.ImpDolares + ", '" + eReqDet.Estado + "', " + eReqDet.NroValeSalida + ", " + eReqDet.FechaSalida + ", " + eReqDet.HoraSalida + ", '" + eReqDet.UserDespacha + "')";
cmd.CommandText = sql;
cmd.Connection = cn;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
i = 1;
cmd.Dispose();
cn.Dispose();
cn.Close();
}
catch { throw; }
return i;
}
void GrabaDetalle()
{
tbldetalle = (DataTable)Session["CARRITO"];
for (int i = 0; i <= tbldetalle.Rows.Count - 1; i++)
{
//dgvDetReq.Rows[i].Cells[1].ToString().Trim();
EDetReq = new EReqDetalle();
EDetReq.Situacion = "S";
EDetReq.NroReqSalida = nroReq;
EDetReq.NroItem = Convert.ToDecimal(i + 1);
EDetReq.CodMatPrima = tbldetalle.Rows[i]["codProd"].ToString();
EDetReq.CtaCargo = Convert.ToDecimal(tbldetalle.Rows[i]["vCuentaCargo"].ToString());
EDetReq.Procedencia = Convert.ToDecimal(tbldetalle.Rows[i]["vProcedencia"].ToString());
EDetReq.CtaAlmacen = Convert.ToDecimal(tbldetalle.Rows[i]["vCtaAlmacen"].ToString());
EDetReq.CantidadSoli = Convert.ToDecimal(tbldetalle.Rows[i]["Cantidad"].ToString());
/*******************Actualizacion************************/
EDetReq.CantidadAte = 0;
/********************************************************/
EDetReq.ImpSoles = Convert.ToDecimal(tbldetalle.Rows[i]["TotalS"].ToString());
EDetReq.ImpDolares = Convert.ToDecimal(tbldetalle.Rows[i]["TotalD"].ToString());
/*******************Actualizacion************************/
EDetReq.Estado = "1";
EDetReq.NroValeSalida = 0;
EDetReq.FechaSalida = 0;
EDetReq.HoraSalida = 0;
EDetReq.UserDespacha = "";
/********************************************************/
objTran = new BTransaccion();
int j = objTran.BInsertDetReq(EDetReq, "ALI012UTIL");
}
}
public int BInsertDetReq(EReqDetalle eReqDet, string tabla)
{
return objTran.DInsertDetReq(eReqDet, tabla);
}
