Beispiel #1
0
 public int DInsertCabReq(EReqCabecera eReqCab, string tabla)
 {
     int i = 0;
     try
     {
         SqlCommand cmd = new SqlCommand();
         cmd.CommandType = CommandType.Text;
         string sql = "INSERT INTO " + tabla + " ( " +
     " A11STT, A11NSA, A11TSA, A11FSA, A11TUR, " +
     " A11ARE, A11AUT, A11SOL, A11OTR, A11COR, " +
     " A11TIP, A11IMS, A11IMD, A11UGE, A11UA1, " +
     " A11UA2, A11UA3, A11FGE, A11FA1, A11FA2, " +
     " A11FA3, A11UHM, A11EST, A11NVS, A11FVS, " +
     " A11HVS, A11UDE, A11CGE, A11CA1, A11CA2, A11CA3) " +
     " VALUES " +
     " ('" + eReqCab.Situacion + "', '" + eReqCab.NroRequerimiento + "', " + eReqCab.TipoSalida + ", " + eReqCab.FechaSalida + ", " + eReqCab.Turno + ", " +
     " " + eReqCab.Area + ", " + eReqCab.Autorizado + ", " + eReqCab.Solicitante + ", " + eReqCab.OrdenTrabajo + ", " + eReqCab.Recibido + ", " +
     " '" + eReqCab.TipoAlmacen + "', " + eReqCab.ImpSoles + ", " + eReqCab.ImpDolares + ", '" + eReqCab.UserGenera + "', '" + eReqCab.UserAprueba1 + "', " +
     " '" + eReqCab.UserAprueba2 + "', '" + eReqCab.UserAprueba3 + "', '" + eReqCab.FechaGenera + "', '" + eReqCab.FechaAprueba1 + "', '" + eReqCab.FechaAprueba2 + "', " +
     " '" + eReqCab.FechaAprueba3 + "', " + eReqCab.HoraMinuto + ", '" + eReqCab.Estado + "', " + eReqCab.NroValeSalida + ", " + eReqCab.FechaValeSalida + ", " +
     " " + eReqCab.HoraValeSalida + ", '" + eReqCab.UsuarioDespacha + "'," + eReqCab.CodUserGenera + "," + eReqCab.CodUserAprueba1 + "," + eReqCab.CodUserAprueba2 + "," + eReqCab.CodUserAprueba3 + ") ";
         cmd.CommandText = sql;
         cmd.Connection = cn;
         cmd.Connection.Open();
         cmd.ExecuteNonQuery();
         i = 1;
         cmd.Dispose();
         cn.Dispose();
         cn.Close();
     }
     catch { throw; }
     return i;
 }
        void GrabarCabecera()
        {
            eCabReq = new EReqCabecera();
            eCabReq.Situacion = "S";
            eCabReq.NroRequerimiento = nroReq;
            eCabReq.TipoSalida = 1;
            eCabReq.FechaSalida = Convert.ToDecimal(fecha);
            eCabReq.Turno = turno;
            eCabReq.Area = Convert.ToDecimal(txtDpt.Text);
            eCabReq.Autorizado = Convert.ToDecimal((string)Session["CodPlanilla"]);//Convert.ToDecimal(codEmpleado);
            eCabReq.Solicitante = Convert.ToDecimal((string)Session["CodPlanilla"]);
            eCabReq.OrdenTrabajo = Convert.ToDecimal(txtOTR.Text);
            /********Verificarlo************/
            eCabReq.Recibido = 0;
            /**ACTUALIZACION GRABA LA GERENCIA POR CADA USUARIO***/
            eCabReq.TipoAlmacen = (string)Session["Gerencia"];
            /******************************/
            eCabReq.ImpSoles = Convert.ToDecimal(txtTotalS.Text);
            eCabReq.ImpDolares = Convert.ToDecimal(txtTotalD.Text);
            eCabReq.UserGenera = (string)Session["Usuario"];
            /*******************Actualizacion************************/
            eCabReq.CodUserGenera = Convert.ToDecimal((string)Session["CodPlanilla"]);
            eCabReq.CodUserAprueba1 = 0;
            eCabReq.CodUserAprueba2 = 0;
            eCabReq.CodUserAprueba3 = 0;

            eCabReq.UserAprueba1 = "";
            eCabReq.UserAprueba2 = "";
            eCabReq.UserAprueba3 = "";
            /********************************************************/
            eCabReq.FechaGenera = fecha;
            /*******************Actualizacion************************/
            eCabReq.FechaAprueba1 = "";
            eCabReq.FechaAprueba2 = "";
            eCabReq.FechaAprueba3 = "";
            /********************************************************/
            eCabReq.HoraMinuto = Convert.ToDecimal(Hora);
            /*******************Actualizacion************************/
            eCabReq.Estado = "1";
            eCabReq.NroValeSalida = 0;
            eCabReq.FechaValeSalida = 0;
            eCabReq.HoraValeSalida = 0;
            eCabReq.UsuarioDespacha = "";
            /********************************************************/
            objTran = new BTransaccion();
            int i = objTran.BInsertCabReq(eCabReq, "ALI011UTIL");
        }
Beispiel #3
0
 public int BInsertCabReq(EReqCabecera eReqCab, string tabla)
 {
     return objTran.DInsertCabReq(eReqCab, tabla);
 }