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