Beispiel #1
0
        protected void btnGuardar_Click(object sender, EventArgs e)
        {
            var minutes = Math.Round(Convert.ToDecimal(Request.Form["slMinutes"].ToString()) / 60, 2);
            var hours   = Convert.ToInt32(Request.Form["slHours"].ToString()) + minutes;

            Ent_tticol075 data075 = new Ent_tticol075()
            {
                orden         = txtWorkOrder.Text.Trim().ToUpper(),
                numOperacion  = _opno,
                tarifaHoraria = Request.Form["slHoursLaborType"].ToString(),
                horas         = hours,
                comentario    = Request.Form["slComments"].ToString(),
                usuario       = HttpContext.Current.Session["user"].ToString(),
                procesado     = 2,
                chequeado     = 2,
                fecha         = DateTime.Now,
                mensaje       = " ",
                refcntd       = 0,
                refcntu       = 0
            };

            List <Ent_tticol075> lista = new List <Ent_tticol075>();

            lista.Add(data075);

            var validInsert = _idaltticol075.insertarRegistro(ref lista, ref strError);

            if (validInsert > 0)
            {
                divTable.InnerHtml    = String.Empty;
                divBtnGuardar.Visible = false;
                txtWorkOrder.Text     = String.Empty;
                lblConfirm.Text       = mensajes("msjsave");
                lblConfirm.Visible    = true;
                lblError.Visible      = false;
                return;
            }
            else
            {
                lblError.Text      = mensajes("errorsave");
                lblError.Visible   = true;
                lblConfirm.Visible = false;
                return;
            }
        }
Beispiel #2
0
        private List <Ent_ParametrosDAL> AdicionaParametrosComunes(Ent_tticol075 parametros, bool blnUsarPRetorno = false)
        {
            method = MethodBase.GetCurrentMethod();
            string strError = string.Empty;
            List <Ent_ParametrosDAL> parameterCollection = new List <Ent_ParametrosDAL>();

            try
            {
                Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTD", DbType.Int32, parametros.refcntd);
                Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$REFCNTU", DbType.Int32, parametros.refcntu);
                Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CHEC", DbType.Int32, parametros.chequeado);
                Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$COMM", DbType.String, parametros.comentario);
                Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$CWTT", DbType.String, parametros.tarifaHoraria);
                Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$DATE", DbType.String, parametros.fecha.ToString("dd/MM/yyyy HH:mm:ss"));
                Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$HREA", DbType.Decimal, parametros.horas);
                Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$LOGN", DbType.String, parametros.usuario);
                Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$MESS", DbType.String, parametros.mensaje);
                Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$OPNO", DbType.Int32, parametros.numOperacion);
                Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PDNO", DbType.String, parametros.orden);
                Ent_ParametrosDAL.AgregaParametro(ref parameterCollection, ":T$PROC", DbType.Int32, parametros.procesado);

                if (blnUsarPRetorno)
                {
                    Ent_ParametrosDAL pDal = new Ent_ParametrosDAL();
                    pDal.Name         = "@p_Int_Resultado";
                    pDal.Type         = DbType.Int32;
                    pDal.ParDirection = ParameterDirection.Output;
                    parameterCollection.Add(pDal);
                }
            }
            catch (Exception ex)
            {
                strError = "Error when creating parameters [075]. Try again or contact your administrator \n";
                log.escribirError(strError + Console.Out.NewLine + ex.Message, stackTrace.GetFrame(1).GetMethod().Name, method.Name, method.ReflectedType.Name);
            }
            return(parameterCollection);
        }