コード例 #1
0
        //----------------------------------
        //Generar cDocCodigo para Documentos
        //----------------------------------
        public string Get_NewIdcDocCodigo(BE_GeneraNewIdcDocCodigo Request)
        {
            string Item = "";

            try
            {
                clsConection Obj    = new clsConection();
                string       Cadena = Obj.GetConexionString("Naylamp");
                using (SqlConnection cn = new SqlConnection(Cadena))
                {
                    cn.Open();

                    using (SqlCommand cm = new SqlCommand())
                    {
                        cm.CommandText = "usp_Get_NewIDDocumento";
                        cm.CommandType = CommandType.StoredProcedure;
                        cm.Parameters.AddWithValue("cPerJurCodigo", Request.cPerJurCodigo);
                        cm.Connection = cn;

                        SqlParameter pCod = new SqlParameter();
                        pCod.ParameterName = "cNewIdcDocCodigo";
                        pCod.DbType        = DbType.String;
                        pCod.Size          = 36;
                        pCod.Direction     = ParameterDirection.Output;

                        cm.Parameters.Add(pCod);
                        cm.ExecuteNonQuery();
                        Item = cm.Parameters["cNewIdcDocCodigo"].Value.ToString();
                    }
                }
            }
            catch (Exception)
            {
                throw;
            }
            return(Item);
        }
コード例 #2
0
        public string Get_NewIdcDocCodigo(BE_GeneraNewIdcDocCodigo Request)
        {
            DA_NewIdcDocCodigo Obj = new DA_NewIdcDocCodigo();

            return(Obj.Get_NewIdcDocCodigo(Request));
        }